Anchal Batra

Client: Toyota Motors North America – Guest Engagement Platform (BEC)
Technologies: Informatica PowerCenter, Salesforce, AWS Glue, Snowflake, Postgres, Amazon S3, AppFlow, ServiceNow

• Led Wave 1 data migration across 10 countries, designing and implementing 50+ ETL flows integrating Snowflake, AWS Glue, and Salesforce, while building reusable infrastructure to support future rollouts.
• Directed full-cycle data migration from Siebel to Salesforce using Informatica PowerCenter, ensuring data integrity and optimal performance throughout migration stages.
• Designed and implemented data archival solutions from Siebel to Postgres, enabling seamless historical data access and reporting.
• Established AWS-hosted Postgres instances and configured integration pipelines with Informatica PowerCenter, enhancing cross-platform connectivity.
• Utilized AWS Glue to connect on-premise Postgres databases with Amazon S3, streamlining data flows and improving operational efficiency.
• Integrated Salesforce with multiple upstream/downstream systems, ensuring robust UAT and production deployments.
• Served as Support Project Lead, managing issue resolution, overseeing system transitions, and mentoring team members to meet SLA targets.
• Acted as Scrum Master, facilitating agile ceremonies, sprint planning, and cross-team collaboration to ensure on-time delivery.
• Collaborated with business teams to gather and refine requirements, and implemented automated data validation processes for accuracy and compliance.
• Managed SIT and PROD environment setups, including AppFlow migrations and change control via ServiceNow.
• Delivered weekly status reports to stakeholders and ensured alignment of technical outcomes with strategic business goals.
• Created onboarding documentation and conducted Knowledge Transfer (KT) sessions, fostering smooth team transitions and continuity.
• Mentored junior developers, enhancing team capacity and execution through technical guidance and leadership.

Client: Philip Morris International (PMI) – Accenture
Technologies: Salesforce CloudCraze, Dell Boomi, AWS SQS

• Analyzed and translated PMI’s business requirements into detailed functional and technical specifications.
• Managed end-to-end project deliverables, including issue resolution and error-handling procedures.
• Estimated and documented change requests, overseeing their planning and implementation.
• Led team activities including code migration, peer code reviews, and deployment across SIT and UAT environments.
• Executed comprehensive testing and debugging, ensuring seamless data integration and message flows between Salesforce CloudCraze and third-party logistics systems using Dell Boomi and AWS SQS.
• Contributed to the design and development of PMI’s global B2B eCommerce solution built on Salesforce CloudCraze.

Client: GlaxoSmithKline (GSK) – MI Futures Project
Technologies: Veeva CRM, Salesforce ServiceCloud, Informatica PowerCenter 9.6.1/10.0, Oracle SQL, Dell Boomi, AWS SQS

• Led and supported the global Data Migration initiative to transition CRM structures to Veeva CRM across 100+ markets, catering to multiple marketing groups.
• Executed end-to-end data migration using Informatica workflows, Oracle SQL, and Veeva Loader configuration tailored for diverse geographies.
• Designed and developed Informatica ETL mappings to populate Oracle databases, applying various transformations based on evolving business needs.
• Oversaw team deliverables including code migration, code reviews, and estimation of change requests, ensuring smooth and timely interface implementation.
• Built and managed inbound/outbound integrations in Dell Boomi between Salesforce and third-party Logistic Service Providers via AWS SQS.
• Developed and maintained ETL processes from functional specifications, ensuring seamless data synchronization between Oracle databases and Salesforce/Veeva environments.
• Conducted comprehensive testing and debugging in non-production environments, resolving data and system-related issues.
• Managed multiple workstreams concurrently, collaborating closely with development and QA teams to perform system and unit acceptance testing.
• Provided post-migration support, troubleshooting data discrepancies and resolving integration challenges across global deployments.
• Played a key role in the MI Futures program, aimed at decommissioning legacy on-premise systems and building a scalable, cloud-based CRM solution using Salesforce ServiceCloud and Informatica.

Client: QBE Insurance – Accenture
Technologies: Informatica, Oracle, SQL, ETL, MIS, BMS

• Executed end-to-end business support and enhancement processes by analyzing existing data models and gathering business requirements.
• Monitored daily OLTP data loads to ensure data integrity, performance, and timely resolution of load failures or data quality issues.
• Developed and modified ETL mappings to support code enhancements, scheduled batch processes, and performed rigorous testing based on business requests.
• Managed and implemented Change Requests, optimized SQL queries, resolved support tickets, and conducted knowledge transfer (KT) sessions for smooth team transitions.
• Contributed to the maintenance and enhancement of over 50 underwriting applications, including integration with third-party systems such as MIS (Management Information System) and BMS (Broker Management System).
• Supported QBE, one of the world’s leading reinsurers, in maintaining robust and efficient data processes within a complex insurance application landscape.