Summary
Overview
Work History
Education
Skills
Certification
Technical Competencies
Accomplishments
Timeline
Generic

Jhansi Mandla

Bangalore

Summary

IT professional with 15 years of experience in cloud computing, data warehousing, and project management. Expertise in architecting and optimizing cloud solutions and data infrastructures, ensuring efficient project delivery and operational excellence. Proven ability to lead cross-functional teams and implement Agile methodologies to enhance productivity and align IT initiatives with business goals. Committed to driving digital transformation through innovative, scalable, and cost-effective technology solutions.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Technical Delivery Manager

CGI
Bengaluru
03.2012 - Current
  • Client Overview: Large Health Insurance Company, USA
  • Spearheaded the migration of Legacy Datawarehouse platform to a cloud-based platform. Achieved 800% improvement in migration velocity.
  • Led development of robust Data Warehousing solutions, increasing data retrieval speed by 60% and improving team productivity by 35%.
  • Led end-to-end system analysis to identify root causes of recurring production support (PS) incidents across critical applications. Reduced PS incident volume by 42% minimizing unplanned outages and enhancing user experience.
  • Partnered with client stakeholders to present KPIs, incident trend analysis, and actionable insights during governance reviews.
  • Collaborated with cross-functional teams to design and implement preventive solutions, significantly improving system stability and performance.
  • Designed and architected, a validation accelerator tailored for PowerCenter to IDMC migration projects, ensuring zero-defect delivery through automated code validation.
  • Recognized by leadership for innovation in reducing production defects and enhancing audit compliance.
  • Managed multiple high-stakes regulatory compliance projects with tight deadlines and evolving requirements to ensure adherence to industry mandates and client-specific regulations. Successfully delivered the projects within the regulatory deadline, preventing potential client penalties and reputational damage.
  • Large Health Insurance Company, USA

Associate Consultant

CGI
12.2019 - 01.2022
  • Client Overview: Large Health Insurance Company, USA
  • Participated in and led design peer review sessions, technical reviews and client reviews with team.
  • Guided the development team on building and optimizing ETL pipelines.
  • Acted as the point of escalation for technical issues, providing expert troubleshooting across data ingestion, transformation, and reporting layers.
  • Oversaw code reviews, unit testing, and integration validation, maintaining high code quality and delivery timelines.
  • Mentored junior developers and provided technical leadership, best practices, and upskilling initiatives.
  • Oversaw release planning, deployment automation, and production cutovers, ensuring zero disruption to business operations.
  • Facilitated knowledge transfer sessions, design walkthroughs, and code reviews to improve overall team capability.
  • Identified performance bottlenecks in queries, ETL jobs, and data models; implemented query tuning, indexing, and partitioning strategies.
  • Worked directly with client stakeholders to gather evolving requirements, demonstrate POCs, and incorporate feedback.
  • Worked closely with project managers and product owners to manage risks, dependencies, and delivery timelines.

Lead Analyst

CGI
12.2014 - 12.2019
  • Client Overview: Large Health Insurance Company, USA
  • Led Data team of ETL Developers in delivering high-quality on-time data integration solution using Informatica PC and IDMC.
  • Conducted Code reviews, mentored Junior team members and facilitated technical issue resolutions.
  • Collaborated with QA and business teams to address validation gaps.
  • Implemented Performance Optimization techniques by monitoring runtimes and optimize queries and improve throughput.
  • Provided critical Issue resolution along with RCA and resolution through technical guidance to team.
  • Facilitated daily standups (or the daily scrum) as needed. Regular analysis of burndown charts and other portfolio planning tools to understand what gets built and at what cadence.
  • Large Health Insurance Company, USA

Senior Software Engineer

CGI
03.2012 - 12.2014
  • Client Overview: Large Health Insurance Company, USA
  • Creating and configuring Informatica workflows, mappings, and transformations.
  • Writing complex data extraction and loading scripts.
  • Implementing data quality rules and cleansing processes.
  • Created the requirement document and design document. Developed POC for few use cases.
  • Provided critical Issue resolution along with RCA.
  • Performing unit, integration, and system testing to ensure data accuracy and integrity.

Senior Systems Engineer

Wipro Ltd.
Bangalore
11.2010 - 02.2012
  • Client Overview: Large Investment Bank, USA
  • Creating and configuring Informatica workflows, mappings, and transformations.
  • Writing complex data extraction and loading scripts.
  • Implementing data quality rules and cleansing processes.
  • Created the requirement document and design document. Developed POC for few use cases.
  • Provided critical Issue resolution along with RCA.
  • Involved in design and creating Autosys jobs to schedule.
  • Involved in debugging, troubleshooting procedures, functions, packages, customizing the existing PL/SQL packages.
  • Performing unit, integration, and system testing to ensure data accuracy and integrity.
  • Large Investment Bank, USA

Software Engineer

Tata Consultancy Services
Bengaluru
07.2007 - 10.2010
  • Client Overview: Large Infrastructure Org, USA
  • Creating and configuring Informatica workflows, mappings, and transformations.
  • Writing complex data extraction and loading scripts.
  • Implementing data quality rules and cleansing processes.
  • Created the requirement document and design document. Developed POC for few use cases.
  • Provided critical Issue resolution along with RCA.
  • Involved in design and creating Autosys jobs to schedule.
  • Involved in debugging, troubleshooting procedures, functions, packages, customizing the existing PL/SQL packages.
  • Performing unit, integration, and system testing to ensure data accuracy and integrity.

Education

Computer Science And Technology

Siddharth Insititute of Engineering And Technology
JNTU

Skills

  • Cloud architecture and infrastructure
  • Agile and DevOps practices
  • Data warehousing and optimization
  • Sprint planning and execution
  • Issue and risk management
  • Request for proposal (RFP) development
  • Business intelligence and analytics
  • Data processing with PySpark
  • AWS expertise and services management
  • Python programming skills
  • Teradata database management
  • Oracle database systems proficiency
  • Health insurance knowledge
  • Banking industry experience
  • Finance sector expertise
  • Version control with Bitbucket

Certification

  • PAHM – Health Insurance
  • Agile Safe Practitioner
  • Databricks Data Engineer
  • AWS Solution Architect

Technical Competencies

  • PySpark
  • Databricks
  • Python
  • Teradata
  • Oracle
  • Informatica/IDMC
  • Scheduling Tools:Control-M,Tidal
  • AWS services (Jupyter Notebook, VectorDB, SNS, eventbridge, Glue, S3, RDS, EC2)
  • Domain : Health Insurance, Banking, Finance,

Accomplishments

  • Envision Hackathon(CGI) - 2025 - Winner
  • Gold Award
  • STAR Award
  • Received Best Team Award

Timeline

Associate Consultant

CGI
12.2019 - 01.2022

Lead Analyst

CGI
12.2014 - 12.2019

Technical Delivery Manager

CGI
03.2012 - Current

Senior Software Engineer

CGI
03.2012 - 12.2014

Senior Systems Engineer

Wipro Ltd.
11.2010 - 02.2012

Software Engineer

Tata Consultancy Services
07.2007 - 10.2010

Computer Science And Technology

Siddharth Insititute of Engineering And Technology
Jhansi Mandla