Dorcas Gaddam
Senior Manager
Hyderabad
Summary
17 years of experience in IT and consulting services for Banking and Finance clients (Life Insurance). Worked for crucial clients- HP, Unilever, DLG, AIA and ADS. Certified Engagement Manager Level-1 (Capgemini Internal certification) having experience in maintaining financial and non-financial data. Proficient in handling Data Migration (On-Prem to Cloud) projects. Experience in all the phases of the Data warehouse life cycle involving Design, Development, Analysis, and testing in the various areas of Data warehousing. Data Governance, Data Quality Assurance, Data Visualization and Query Optimization. Capably juggle and effectively manage multiple priorities simultaneously. Possess excellent communication, relationship management and team building skills. Multi-faceted professional with demonstrated ability to identify and define needs and formulate solutions. Strong analytical and critical thinking skills. Strong expertise in Agile methodologies, resource allocation, and stakeholder management. Strong Experience in analyzing requirements, Data Analysis in cloud environment with agile methodology.
Overview
17
17
years of professional experience
2
2
Certifications
Work History
Data Lead
Capgemini
02.2024 - Current
- Working with cross-functional teams to facilitate seamless collaboration on data-driven initiatives.
- Acting subject matter expert pertaining to data integrity,Data load strategies and plan
- Leading the GWCC data migration project, ensuring smooth transitions with minimal disruption to business activities.
Engagement Manager/Technical Project Manager
Capgemini
08.2023 - 01.2024
- Liaising with key stakeholders and system integration partners
- Manage data migration workstream within the established project budgets and check on potential deviations
- Overseeing and ensuring delivery of all aspects of data analysis, mapping, and transfer
- Owning the quality of the migrated data and the validity of the migration processes and operation
- Define the migration strategy and plan
- Planning, scheduling, tracking/monitoring, resource allocation, issue/risk management
- Proficient project management, leadership, team building, meeting management, problem resolution, risk management and decision-making skills
- Driving development and testing teams; and executing the program of projects against committed milestones.
Service Delivery Manager/Scrum Master
Capgemini
03.2023 - 08.2023
- Developing status reports and dashboards, including metrics-informed analysis
- Anticipating issues and acting proactively to address potential issues
- Development capacity planning and helping in release scheduling
- Manage multiple work streams
- Provides metrics and status to senior management
- Support/Collaborate with team members to implement Agile/Scrum best practices Provides and supports the implementation of business solutions.
Service Delivery Manager/Scrum Master
Capgemini
04.2021 - 12.2022
- Team management, Task assignment and coordination
- Tasks/Incident Management, maintaining the Jira and ServiceNow Dashboards
- Preparing the Monthly and Weekly Status Reports with KPI's
- Scrum Master for three program initiatives
- Prepared and presented reports summarizing key findings and recommendations
- Assisted the team with Azure SQL issues with Data if any.
Service Delivery Manager, Data Analyst, Data Modeler
Capgemini
01.2019 - 03.2021
- Developed and maintained complex SQL queries to extract, clean, and analyze large datasets from multiple sources
- Conducted data exploration and visualization to identify trends, patterns, and anomalies
- Data Modelling for additional requirements
- Data Analysis and Source to Target Mapping based on the requirements
- Collaborated with the team to identify and resolve data quality issues
- Aware of Guidewire suite for P & C insurance.
ETL Lead, Data Analyst, Data Modeler
Capgemini
12.2016 - 03.2018
- ETL Team management, Task assignment and coordination of ETL resources
- ETL Design and mapping from source systems to ODS
- Data Modelling for Enterprise Data Warehouse
- Data Analysis and Source to Target Mapping based on the requirements for EDW
- Collaborated with cross-functional teams to understand business requirements and deliver actionable insights
- Improved data quality and integrity by implementing data cleansing and validation processes
- Developed and automated data pipelines to streamline data processing workflows.
Individual Contributor (Technical Consultant)
Tech Mahindra
04.2014 - 07.2015
- Outlining high level integrated designs to meet the requirements deal with Lending business of GE and align them with existing architecture
- Coordinating with the source management teams and validating the data which is flowing into the EDW and from EDW to other data marts
- Requirements gathering, gaining business consensus, performing vendor and product evaluations, mentoring business, and resources, delivering solutions, training, and documentation
- Optimize SQL queries and database performance by analyzing query execution plans, identifying bottlenecks, and suggesting indexing or schema modifications.
Individual Contributor/Technical Consultant
Tech Mahindra
05.2013 - 02.2014
- Established standards and guidelines for the design & development, tuning, deployment, and maintenance of information
- Defined and implemented the strategy roadmap for enterprise data, implementation and data management for new data sources, publicly available data, and business-to-business partnerships across geographic locations
- Efficiently managed a team and responsible for delegating work to the team members, monitoring team performance through timely feedbacks, thereby, ensuring overall team productivity and quality
- Worked on the activities for the merger project for all integrations and systems are to remain as-is except for changes required to accommodate SLO conflict resolution
- Worked on strategies for data acquisitions and archive recovery.
Individual Contributor/Technical Consultant
KPIT Cummins Infosystems Ltd.
01.2012 - 04.2013
- Individual contributor for Analysis, Development, Testing (unit and integration) and migration
- Develop, optimize, and maintain SQL scripts, and functions for data extraction, transformation, and loading (ETL) processes
- Monitor job performance, identify bottlenecks, and suggest improvements to optimize query execution and overall efficiency.
Individual Contributor/Technical Consultant
KPIT Cummins Infosystems Ltd.
10.2011 - 12.2011
- Developed mappings from the Source to Target mapping sheet as per the requirement for the planning and procurement migration projects
- Individual contributor from offshore for development, testing and migration
- Document SQL scripts, queries, and data analysis processes to ensure proper knowledge sharing and maintain a repository of best practices and guidelines.
Technical Consultant
KPIT Cummins Infosystems Ltd.
04.2011 - 07.2011
- Worked on migration of existing jobs from legacy systems in informatica version 7 to Informatica version 8, with the changes in the data flow based on the change in the requirement
- Worked on Technical design document, reviewing, documenting, designing, developing and unit testing
- Ensure data compatibility and integrity during the conversion process.
Technical Consultant
KPIT Cummins Infosystems Ltd.
08.2007 - 04.2011
- Worked on the Base Product Application issues, Performance tuning, Data related issues, Issues because of customization, Monitoring Jobs, Administration support and Disaster Recovery related issues in BODI/ BODS
- To ensure proper source load and on-time availability of data, the data ownership / accuracy of information / verification of data is the responsibility of the operating companies
- Creating monthly review reports, SLA review documents and sending it to the Unilever managers on monthly basis
- Track Incidents, Problem and Change requests and prepare trend analysis document
- Supervised the BODI XI migration activity, by scheduling jobs, Job server configuration, review and confirming MQ interface list, and TWS-Script script deployment with production set-up
- Data upload support, Monthly interface monitoring and resolving issues for code drops and performance tuning.
Senior Software Eng.
KPIT Cummins Infosystems Ltd.
02.2005 - 11.2006
- Development, Maintenance, Tuning, Troubleshooting and enhancements of existing mappings and workflows
- Creating scripts for pre/post ETL process and scheduling those jobs using Tidal scheduler along with the ETL jobs
- Implemented CDC (Change Data Capture) by creating parameter files and ETL control tables for incremental loads
- Defined Load strategies and created/scheduled Informatica jobs using tidal scheduler for diverse types of loads based on the frequency
- Created batch scripts to implement the pre/post ETL tasks (like to drop/rebuild bitmap index, truncate stage tables, check Source/Target database availability, add file header to the target files in informatica load) Performed Informatica administrator activities such as code migration across environments and managing user/groups
- Analysis of Physical Data Model for ETL, mapping and design of ETL Process flow diagrams.
Education
Master of Business Administration - Human Resource Management
BRAOU
Bachelor of Technology - Computer Science and Information Technology
SNIST, JNTU
Skills
Data Warehousing
Data Profiling
Data Governance
ETL development
Qlik Sense
Certifications And Awards
- Certified SAFe 5 Scrum Master ( recertification by Feb 2024), SAFe Agilist
- Certified Engagement Manager – Level 1 Certified by Capgemini.
- Received “People Champ” R & R award for Q2 2022
Visa Status
H1 b
Valid until 09/30/25
Stamped at Hyderabad, India
Skills Profile
Project management software (Jira, Service Now), Microsoft Office Suite (Word, Excel, PowerPoint), Data analysis and reporting tools (e.g., Excel, Power BI), Collaboration tools (Microsoft Teams), ERWin 4.1, Dimensional Modeling (Star schema and Snowflaking), Waterfall and Agile Methodologies (Scrum, Kanban- Jira), Teradata v.13. 10, Oracle 8i/9i/10g, Amazon Redshift, Azure SQL, Tidal, Tivoli, ControlM, Workload Automation Suite v.8.0 (Appworx), AWS- S3, EC2, Redshift, Azure-Storage (ADLS Gen2), ADF, SQL DB, Terraform, Databricks, Informatica Power Center 9.x/8.x/7.x/6.x, BODI 11.7(R2)/6.1, SAP BODS 12.2, Knowledge in Data stage, Remedy 6.03.00, OVSD/ SM7, HP Application Lifecycle Management (HP ALM), Service Now, Adapt freely to diverse situations and changing demands in demanding environments and prepare for unforeseen circumstances., Planning and owning service delivery of three program initiatives parallelly., Recognizing, responding, and managing changes to vision and plans., Supervise supportively while building Trust among the team., Finding right people and motivating them to work towards my vision., Successfully organized seminars, meetings, team-building activities, Efficiently managed a team and responsible for delegating work to the team members, monitoring team performance through timely feedbacks, thereby, ensuring overall team productivity and quality.
Training
- Conducted trainings to team members on informatica, Data Mapping, Data Modeling tool- ERWin, Managed Services.
- Conducted New Team Rituals as part of Hybrid working model for the team both virtually and physically.
- Completed Connected Manager Virtual Training program by Capgemini University (Harvard ManageMentor)
Certification
SAFe Scrum Master
Timeline
Data Lead
Capgemini
02.2024 - Current
Engagement Manager/Technical Project Manager
Capgemini
08.2023 - 01.2024
Certified SAFe Agilist
03-2023
Service Delivery Manager/Scrum Master
Capgemini
03.2023 - 08.2023
SAFe Scrum Master
09-2022
Service Delivery Manager/Scrum Master
Capgemini
04.2021 - 12.2022
Service Delivery Manager, Data Analyst, Data Modeler
Capgemini
01.2019 - 03.2021
ETL Lead, Data Analyst, Data Modeler
Capgemini
12.2016 - 03.2018
Individual Contributor (Technical Consultant)
Tech Mahindra
04.2014 - 07.2015
Individual Contributor/Technical Consultant
Tech Mahindra
05.2013 - 02.2014
Individual Contributor/Technical Consultant
KPIT Cummins Infosystems Ltd.
01.2012 - 04.2013
Individual Contributor/Technical Consultant
KPIT Cummins Infosystems Ltd.
10.2011 - 12.2011
Technical Consultant
KPIT Cummins Infosystems Ltd.
04.2011 - 07.2011
Technical Consultant
KPIT Cummins Infosystems Ltd.
08.2007 - 04.2011
Senior Software Eng.
KPIT Cummins Infosystems Ltd.
02.2005 - 11.2006
Master of Business Administration - Human Resource Management
BRAOU
Bachelor of Technology - Computer Science and Information Technology
SNIST, JNTU