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:

·        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. 

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