Responsibilities:

· Developed:

• Talend Jobs using Talend Big Data (6.3.1) which load data into Core Data Platform (Data Lake)
• External Hive Tables on top of HDFS location

· Ensured data validation between SQL Server and Data Lake

· Mentored multiple associates in the team and shared technical and functional knowledge with them

· Reviewed project metrics and managed the process audits for a team of 20+ members

Responsibilities:

· Led design & implementation of PowerPivot Table (like trend line, Bar chart, pie chart, tabular report) and Chart Reports upon the built Tabular model; generated Power View reports

· Acted as offshore SME to directly deal with Cognizant and customers

· Worked as part of Cognizant lateral recruitment drive for MSBI

Responsibilities:

· Steered production support activities which involved monitoring 100+ jobs; took necessary action during job failures; worked on numerous PowerBI POCs for upgrading existing PowerPivot reports

· Created:

• Stored procedures, Views and Triggers as per business requirement
• SSIS packages for the data movement across the systems; streamlined the processing of SSIS package through the usage of configuration files / Environment variable / SQL server
• Batch file for Automating SSIS package execution
• Subscriptions-automated e-mail delivery of SSRS reports for end users

· Managed database partitions and index optimization in SQL server

· Conducted Data Quality compliance checks and Data Quality automation for data across QNXT, ODS and Datamart systems

Responsibility:
Prepared Design Specification Document.
Developed SSIS packages for loading the data into the existing claims recovery system.
Designed and Developed SSRS Reports.
Integrated SSRS reports with .Net application.
Automation of SSIS Package through SQL Agent for Monthly load.
Migrated few web application reports to SSRS reports.
Worked on various incidents involving analysis, data/code fix and testing.
Prepared Unit Test Cases and Unit Test Plans.
Handled Unit Testing and System Integration Testing in respective environments.

Creation of a package in Oracle 9i for data exchange between two systems – one system beingData repository and other, a User Interface system.Day to day activities for this project included two or more of the following - getting requirementsfrom the client, analysis, coding, creating test plans testing.Worked in UAT support phase for this project involving few enhancements to the package for theClient.

Performed the role of Data Analyst in this project.Daily activities for this project were - serving ad-hoc requests from client which involves complexdata and process analysis, data mining, data fix, monitoring jobs in Informatica and file transferusing FileZilla.Worked in numerous ad-hoc requests in this project.Performed monthly and weekly file processing for the client.

Performed data analysis and testing primarily in this project.Involved in Impact analysis for SQL stored procedures and .Net code.This was one of the high visibility projects in Infosys and the project gained excellent appreciation and trust from the client.

Developed a module in .Net for the clientDaily activities – analysis, coding, developing test plan and testing the module.Followed best practices in Knowledge management and Configuration Management.

Migrated web application reports to SSRS. Developed 15 tabular reports using SSRS 2008.Made enhancement to Coordination of Benefits (.Net) application for the client and gainedappreciation for the same.Automated an extract generation task using SSIS 2005.Day To Day activities –Working in various tickets, analysis, data/code fix and testing.Knowledge sharing with the team.