Naga S.

DATA SCIENTIST

70 dollar

My experience

More

CognizantJuly 2013 - September 2017

Client:

CNO Financial Group, a US based insurance company is a group of major insurance companies that provides the services to other insurance companies and maintains its insurance policies.

Actuarial and Re-Insurance System which holds the data from actuaries who are professional statisticians working for an insurance company. The policies information such as LIFE INSURANCE, HEALTH INSURANCE, and ANNUITIES arrive at the system in the form of flat files, Excel files, Access files, and FoxPro and oracle database. This data is loaded into the SQL Server tables using SSIS (ETL) tool. And then further process will be taken care as per the business logic and keep it ready for other systems like LIFEPRO to make use of the consolidated and Processed data.


* Involved in designing, developing and deploying packages in MS SQL Server environment and SSIS in Business Intelligence Development Studio (BIDS).

* Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

* Prepared the complete data mapping for all the migrated jobs using SSIS.

* Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures.

* Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.


Had been to USA to meet the clients on project purpose for couple of months.
More

Tech MahindraAugust 2010 - June 2013

to meet the clients on project purpose for couple of months.

Client:

Tech Mahindra - Internal

The project is about capturing daily efforts entered by associates against Project and Activities. It includes confirmation and rejection of entered efforts, editing of efforts, shifts, raising requests like - holiday requests, https access requests, approvals of these requests by respective authorities, intimation of various activities happening at different stages through database mailing, generating reports and finally porting confirmed efforts to another tool for invoicing and billing generation. It also includes maintenance of various roles corresponding to Projects and Circles and monitoring their movements across Projects and estimation percentage of completion for the active fixed bid projects for tracking the current status of such active FB projects to check about the project overrun and other information details needed by the Finance team.

Responsibilities:


* Requirement gathering & analysis in Claims, Provider and Medical Management area while interacting with Clients

* Responsible for review of the deliverable from offshore Claims, Provider and Medical Management area

* Developed Views, Stored procedures, Functions, Triggers etc., using SQL server 2005, Performance Tuning, Data Migration Tasks, T-SQL DML and DDL operations

* Involved in Design and Development of SSIS Packages using various Control Flow and Data Flow items to Extract, Transform and Load the Data using SQL Server Integration Services (SSIS)

* Handled Performance Tuning and Optimization of SSIS packages, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally

* Experienced in configuring with Error logging and Event handling to redirect error rows and fix the errors in SSIS Testing - unit testing & integration testing

* Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

My stack

Visual FoxPro, Unit testing, Troubleshooting, Tableau Software, Tableau, Stored procedures, SQL Server Reporting Services, SQL Server Integration Services, SQL, Python, Performance tuning, Oracle, OLTP, Neural networks, MS Excel, Microsoft SQL Server 2005, Microsoft SQL Server, Microsoft Excel, Machine Learning, Interpersonal skills, Integration testing, ETL, Data Warehousing, Data Migration, Artificial Intelligence, Analysis