Madhumathi A. S
Datawarehouse Expert | Track Lead
Bangalore,Karnataka
Summary
Around 16 years and 3 months of work-experience in IT industry with exposure in Requirement Analysis, Design, Development, unit testing and Production support. Worked on technologies in data warehousing and business intelligence having knowledge of Abinitio, UNICA, Informatica, Teradata, DB2, Mainframe, COGNOS (Reporting & Administration), Informatica CLOUD, API, UNIX. Currently working on the projects for Pepsico – R & H Domain as Track Lead. Strong communication, team management and inter-personal skills. A quick learner with the ability to make solutions-oriented, creative, and innovative contributions in highly demanding situations. Professional Experience in Informatica, Mainframe, Unix, Teradata & DB2. A strong contributor towards knowledge management activities including project documentation, user manuals and other technical documentation. Practical Associate Consultant with expertise in managing priorities to meet deadlines and realize high-quality outcomes. Committed to establishing credibility and developing relationships with associates and managers. Strong conceptual thinking skills and new concepts acquisition.
Overview
16
16
years of professional experience
7
7
years of post-secondary education
4
4
Certifications
Work History
Associate Consultant – Track Lead
Tata Consultancy Services
03.2022 - Current
- Managing the routine portfolio activities of the Team
- Drive Critical Business Calls with customers
- Preparing the business required documents for decision making
- Engage in escalation calls
- Engage in ITIL activities like Incident/SR/CR/PRB/Event Management by tracking them in business documents
- Helped team of 20+ lead consultants optimize efficiency of current systems by conducting training sessions.
Team Lead
McCain US
06.2019 - Current
- Deployment & Unit Testing in all lower environments
- Detailed documentation of the implemented ETL Changes
Associate-Projects
Cognizant Technology Solutions
04.2011 - 03.2022
Senior Developer
Sodexo
10.2020 - 03.2021
- Modifying existing informatica mapping to plugin enhancements related to the GDSN application/data
- Deployment & Unit Testing in all lower environments
- Detailed documentation of the implemented ETL Changes
Senior Developer
Walgreens US
06.2020 - 09.2020
- Modifying existing Abinitio graphs and plans based on new requirement mostly disable some components, changing reformat logic, adding zero byte dummy file, changing extraction logic etc.
- Obsolete some existing jobs
- Unit Testing in all lower environments (there are total 8 lower env), then deploy in prod.
- QA Testing end to end with proper data. Data mock up/masking might be required.
- Develop Test strategy, test plan, execute test cases and defect management for the ETL systems.
- Coordination with external data source partner is also required.
- Detailed documentation
- Deploying the code in prod, creating tag, save file, CRQ, attend CAB call etc.
- Coordinating with existing Runops team for KT and functional testing confirmation etc.
Team Lead
Walgreens US
05.2018 - 06.2020
- Involved in Abinitio / UNICA Application Support & enhancements
- Involved in scheduling jobs and Monitoring (Mainframe CA Workstation).
- Involved in the recovery process for the failed jobs/UNICA Flowcharts.
- Drive Critical Maintenance activities
- Maintained good rapport with Offshore / Onsite Team members.
- Maintained Incident Reduction Analysis and also avoided/taken care of SLA breach.
- Active contributions to Quality Audits, Monthly Dashboard, Quarterly & Weekly Reports, Onsite Communications etc.
- Helped other Walgreens delivery teams as well through appropriate Intra-Team co-ordinations.
- Made contributions to external teams on multiple aspects.
- Acquired extensive knowledge of Walgreens Business Process, Protocols, and Client processes.
Senior System Engineer
Cermaq
05.2017 - 05.2018
- Installation and Configuration of Cognos App versions and Fix Packs Upgrade
- Resolution of User related issues with respect to IBM Cognos App through SNOW incident Management
- Co-ordination with Vendor for resolution of critical issues.
- Involved in the recovery process for the failed Data Stage/ETL jobs
- Maintained good rapport with Offshore / Onsite
- Involved in internal Knowledge Sharing
Team - Developer
Johnson & Johnson US
10.2015 - 04.2017
- Involved in ETL Testing & Development Enhancement-
- Enhancement/Creation of mapping, sessions and workflows using Informatica Power Center 8.x/9.x
- Analysis for PRB’s and Fixes.
- Prepared Process Specs.
- Maintain code performance tuned.
- Involved in scheduling jobs and Monitoring (TIDAL Scheduler).
- Involved in the recovery process for the failed jobs.
- Maintained good rapport with Offshore / Onsite Team members.
- Maintained Incident Reduction Analysis and avoided/taken care of SLA breach.
- Prepared and attended the Monthly/Quarterly &Weekly status report meetings.
- Involved in Testing of Enhanced code and prepared the test cases and validate the code Enhancements done by the Team (Informatica).
- Expertise in writing detailed test cases & test scenarios to cover data completeness, correctness, data transformation and data quality testing from source to target mapping within data warehouse.
- Worked on Defect Management
Team Lead
Kohl US
01.2010 - 02.2014
- Involved in ETL Development Enhancement-
- Enhancement/Creation of mapping, sessions and workflows using Informatica Power Center 8.x/9.x
- Analysis for PRB’s and Fixes.
- Prepared Process Specs.
- Maintain code performance tuned.
- Involved in Testing of Enhanced code and prepared the test cases and Validated the code Enhancements done by the Team (Informatica /Mainframe).
- Was a Moderator of the Retail Pedia group and has spread the retail awareness.
Programmer Analyst
Cognizant Technology Solutions
12.2009 - 03.2011
Software developer
Department of Treasuries, Government of Karnataka
04.2009 - 01.2010
- As a developer of the Enhancement / Support tasks, which involve understanding the new requirements from clients and suggest design changes for new modules.
- Actively involved in preparing test cases and testing the new module / changes.
- Developed few modules for STAG (Statement Aggregation) Application.
- Ensuring that all details related to data fixes, operational activities, Known errors and new errors are documented for the owned system.
- Adopting the quality procedures.
- Providing statistical reports, data extracts to business by writing queries.
- Fixing bugs in the COBOL code.
- Preparing of Unit Test Plan (UTP) and Unit Testing.
Programmer Analyst-Trainee
Cognizant Technology Solutions
11.2008 - 11.2009
Education
Master of Science -
UVCE, Bangalore University
Bangalore 08.2005 - 04.2008
Bachelor of Arts -
St Anne’s College For Women
Bangalore 08.2002 - 04.2005
Associate of Arts -
St Anne’s College For Women
08.2000 - 04.2002
ICSE - undefined
St Francis Xavier’s Girl’s High School
Skills
- IBM/DELL Compatible PC
- Unix
- Mainframes ZOS
- Windows 9X
- Windows NT
- Windows XP
- Windows Vista
- UDB-DB2
- Teradata
- Oracle
- COBOL
- JCL
- C
Certification
Cognizant, Health Care (CCP), 2009
Personal Information
- Date of Birth: 03/07/84
- Nationality: Indian
Current Position
Associate- Projects, LoS: CDB-AIA BIG DATA, Tata Consultancy Services, Bangalore
Timeline
Associate Consultant – Track Lead
Tata Consultancy Services
03.2022 - Current
Senior Developer
Sodexo
10.2020 - 03.2021
Senior Developer
Walgreens US
06.2020 - 09.2020
Team Lead
McCain US
06.2019 - Current
Team Lead
Walgreens US
05.2018 - 06.2020
Senior System Engineer
Cermaq
05.2017 - 05.2018
Team - Developer
Johnson & Johnson US
10.2015 - 04.2017
Associate-Projects
Cognizant Technology Solutions
04.2011 - 03.2022
Team Lead
Kohl US
01.2010 - 02.2014
Programmer Analyst
Cognizant Technology Solutions
12.2009 - 03.2011
Software developer
Department of Treasuries, Government of Karnataka
04.2009 - 01.2010
Programmer Analyst-Trainee
Cognizant Technology Solutions
11.2008 - 11.2009
Master of Science -
UVCE, Bangalore University
08.2005 - 04.2008
Bachelor of Arts -
St Anne’s College For Women
08.2002 - 04.2005
Associate of Arts -
St Anne’s College For Women
08.2000 - 04.2002
ICSE - undefined
St Francis Xavier’s Girl’s High School
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Prerana AnilPrerana Anil
School Counselor at Cadabams HospitalsSchool Counselor at Cadabams Hospitals