On-Site Data Management

Alok Kumar Kushwaha

Email:- *******@*****.*** Contact number: - +1-508-***-****

Experience Summary

●Total 16 years of IT experience in Life science, Insurance, healthcare & Banking Domain in Tata consultancy Services.

●13 years of relevant experience in Informatica Powercenter, Oracle SQL queries & Unix scripting.

●2 years of relevant experience in Intelligent Data Management Cloud (IDMC).

●Having valid H1-B visa and currently working in Massachusetts USA past 8 months. I do have 2 years of on-site (Hong Kong) experience too.

●Extensive understanding of source to target mapping & business rules associated with ETL, data warehouse concepts, could application integrations.

●Proficiency in designing ETL workflow, IICS task flows, Data Migration, Data Verification, Debugging ETL issues, System Integration, Functionality & Regression testing and reconciliation with SQL queries.

●Team Leading with Management skills & communication skills. I do have confidence to deliver the services or product in time with quality to customers throughout project life cycle.

●Ability to collaborate with developers, testers, project managers and other team members in complex projects spread across different geography.

Education

I have completed my degree of Bachelor of technology in 2008 with Electronic & Communication stream from Uttar Pradesh Technical University Lucknow India.

Sunovion Commercial Application Support – (Since Feb 1st 2023 to till now)

Vertex Pharmaceuticals informatica Support – (Since Apr 17th 2017 to Jan 31st 2023)

AXA Heath claim Portal – (Since Apr 2nd 2014 to Apr 15th 2017)

Humana enterprise data integration services – (Since Mar 07th 2012 to Mar 31st 2014)

Ameriprise Financial Online Brokerage Project – (Since 24 Jan 24th 2009 to Mar 03rd 2012)

Career Profile

Position Informatica Developer, Team lead, System Analyst, Data validation engineer

Key Responsibilities

Involved in clients and business user communication to understand business enhancement requirements.

Providing cost estimation sheet against each change request, weekly status report to client.

Coordination with on-site client team and other third-party teams to achieve project goals. I do work with Agile methodology. Involved in preparing ETL mapping sheet.

Involved in creating IDMC source & target connection, mappings, mapping task, task flow.

Involved in creating service connector, app connections, CAI process using REST APIs.

Doing impact analysis on existing intentions due to new org’s object change and incorporating the change in existing integrations based on impact analysis result after business approval.

Responsible for project deliveries in or before time with quality and accuracy.

Responsible for creating Power centre ETL connection, mappings, session, workflows, setting parameter files and database objects creation via SQL scripts in projects to meet business requirements.

Responsible for developing ETL mappings using transformations, look-ups, command tasks, etc. and debugging issues on job failure.

Computers Worked on

Computer System

Programming Languages

Special Software

Windows

SQL, PL SQL

Informatica Power Centre, Informatica IDMC (earlier IICS), Putty, WinSCP, SQL developer, Jira, Service Now, Beyond Compare, Notepad ++

Personal Details

Gender Male

Nationality Indian

Marital Status Married

Designation Associate Consultant

Adress 125 Sudbury Road, Ashland, Massachusetts, USA 01721

Visa Details Currently, H1B extension is filed by Tata consultancy services

Contact this candidate