Client: Regeneron

Responsibilities:

• Overseeing data pipelines and dashboards for a Pharma client in the US, ensuring seamless data flow from diverse source files to final dashboards.
• Collaborating with junior team members and onshore counterparts to prepare accurate sales reports and customer payouts.
• Conducting daily calls with onshore counterparts to facilitate process understanding and perform data analysis using Excel and SQL.

Client: New York Life Insurances

Responsibilities:

• Migrated on-premises data on Datastage to the cloud (Redshift) according to business requirements using IDMC, implementing various performance measures to optimize ETL pipeline performance.
• Maintained daily Tech Tracker/Issue logs for updates and issues related to objects.
• Coordinated with the QA testing team to resolve defects in QA and STAGE environments.
• Addressed and resolved various performance issues in ETL and database with effective and efficient solutions.
• Managed a team of 3-4 people, attending regular and ad hoc meetings to update statuses and resolve daily data and code-related issues.
• Participated in the deployment team using CI/CD pipelines in Jenkins to deploy codes in PROD and non-PROD environments.

Responsibilities:

• Collaborated with business analysts for data analysis and requirement gathering.
• Conducted logical and physical data modeling in SAP PowerDesigner for data warehouses using STAR Schema.
• Utilized Informatica Cloud Services (IICS CDI) to transform data according to business rules.
• Implemented Slowly Changing Dimensions (SCD) mappings and optimized Informatica mappings for peak load performance.
• Operated within Agile methodology using JIRA, kanban board, and participated in daily Scrum meetings, monthly backlog refinements, and Sprint planning meetings with various stakeholders.

Client: Sanofi

Responsibilities:

• Built a data mart for the VEEVA CRM application, completed ETL pipelines, and automated ETL jobs using IICS CAI.
• Managed stakeholders to establish and maintain the environment in UAT and production.
• Proposed and implemented test cases during unit testing using HP ALM, ensuring the effective execution of these test cases.

Client: Thrivent Financials

Responsibilities:

• Monitored over 2500 ETL codes in Zena and provided production support using Informatica PowerCenter.
• Resolved job abends and supported data flow, addressing daily data issues effectively.
• Served as on-call support during critical hours and major deployments.
• Developed new ETL codes to enhance data mart development activities.
• Trained new joiners and led a team of two junior developers.

Client: Bristol Myers Squibb

Responsibilities:

• Provided production support for the Salesforce-based VEEVA CRM application.
• Collaborated with large teams across regions, managing medium to complex change requests.
• Led L2 and L3 issue resolutions and conducted knowledge exchange sessions.
• Successfully implemented the VEEVA CRM application for the LATAM region in an Agile manner, utilizing technologies such as Informatica PowerCenter, Autosys for job automation, ServiceNow for incident and change management, and HP ALM for running test cases.