Saranya Ambikapathi
Frankfurt
Summary
With an extensive 13+ year tenure at Tata Consultancy Services, a wealth of experience in project delivery across diverse sectors, focusing on Investments, Banking & Financial Services, and Retail. Proficient in key technologies, expertise lies in Informatica PowerCenter, IICS-IDMC, Azure Data Factory, PL/SQL, Oracle, SQL Server, Autosys, Unix, and PowerBI. Additionally, I have gained good onsite experiences with clients by building a good and trusted environment of success. Currently serving as the Technical Lead at TCS for Allianz Global Investors clients. Successfully contributed to the seamless execution of migration projects, supporting the migrated project, demonstrating a strong command of technological tools and a strategic understanding of the financial domain.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Technical Lead
Tata Consultancy Services
08.2021 - Current
- Client - Alliance Group of Investors , Frankfurt
- I am proficient in managing a Data Integration Framework that operates as a distribution hub for extensive sets of data flows downstream, involving Informatica PowerCenter / Data integration hub code designs.
- Led a huge team of 25+ developers, for migration of all on premises codes to IICS/IDMC and Azure Data Factory cloud platforms successfully with high quality on time and as per the budget constraints.
- I place a strong emphasis on the critical tasks of maintaining and enhancing this framework.
- Ensuring the timely delivery of delayed files caused by any outages is a key aspect of my responsibilities.
- My expertise lies in collaborating, streamlining and optimizing data flows to meet stringent timelines while maintaining the integrity of the overall framework.
- Collaborated with cross-functional teams to ensure seamless integration of various project components which includes calling Python programs from ADF pipelines, establishing linked services to different Azure data storages.
Technical Lead
Tata Consultancy Services
12.2019 - 07.2021
- Client - Swiss Re
- Engaged in the FiPro Project, a commission agents initiative for SwissRe re-insurance, I played a pivotal role in not only developing PowerCenter logic but also contributing to hands-on Power BI reporting
- This involved utilizing the data generated from PowerCenter to create insightful and visually compelling reports
- My multifaceted involvement in both logic development and reporting underscored my ability to seamlessly integrate different aspects of the project, enhancing its overall effectiveness and providing comprehensive insights for stakeholders.
Project Lead/ Developer
Tata Consultancy Services
06.2014 - 07.2019
- DB Feeds project, where various DB products (Insurance/Credit cards/Loans) related business logics for data were implemented in PowerCenter code and handled performance tuning challenges.
- Streamlined project management processes by implementing Agile methodologies and improving team communication.
- Optimized resource utilization by accurately forecasting project needs and allocating resources accordingly throughout the project lifecycle.
- Collaborated with cross-functional teams to ensure seamless integration of various project components.
Developer
Tata Consultancy Services
07.2013 - 05.2014
- Client - PNC, Pittsburg National Corporation
- PowerCenter Feeds Project, worked as Informatica PowerCenter core developer with Unix scripting knowledge and PLSQL/ SQL Store procedures, Triggers, Functions, Cursors
- Core business logics were implemented in the workflows for decision making on Client Reports.
Developer
Tata Consultancy Services
03.2011 - 06.2013
- Supervalu Merchandising CDIA Project, which plans the deals/promotions for the Retail Store
- I had good opportunity to learn Oracle/PLSQL and PowerCenter development.
- Completed Lean Six Sigma certifications.
Trainee
TCS Trainee
12.2010 - 03.2011
- TCS core trainings in JAVA/J2EE and Data Warehousing concepts.
Education
Bachelors of Engineering - Information Science and Engineering
Visvesvaraya Technological University
JSSATE, Bangalore, India 06.2010
Skills
- Informatica PowerCenter
- Cloud Informatica Data Integration(IICS/IDMC)
- Azure Data Factory - Data Engineering
- SQL Server
- PLSQL
- Oracle
- Autosys
- Unix
- PowerBI
- Agile Methodology
- Issue investigation
- Performance Optimization
- Test-driven development
- Code Review Expertise
- Automation methods
- Software development life cycle
- Quality assurance standards
Currentcompany
Tata Consultancy Services Ltd, 12/15/2010, Allianz Global Investors GmbH, Data Integration and PowerCenter maintenance, Technical Lead, Guiding the technical implementation process, I serve as the primary point of escalation for resolving technical issues. In my role, I take responsibility for engaging with customers/users, addressing operational facets of projects tied to solution and service delivery, and troubleshooting issues. My commitment extends to ensuring the high quality of requirement analysis, design, development, and the overall solution and service delivered. I uphold stringent quality control measures through thorough reviews.
Accomplishments
Received Best Employee Awards-2024.
Received Best TCS Auditor 2022-2023 for inspecting cross functional team health checks.
Certification
Microsoft Azure Fundamentals AZ 900
Microsoft Azure PowerBI Data Analyst PL 300
Pursuing, Microsoft Certification: Azure Data Engineer Associate DP 203Timeline
Technical Lead
Tata Consultancy Services
08.2021 - Current
Technical Lead
Tata Consultancy Services
12.2019 - 07.2021
Project Lead/ Developer
Tata Consultancy Services
06.2014 - 07.2019
Developer
Tata Consultancy Services
07.2013 - 05.2014
Developer
Tata Consultancy Services
03.2011 - 06.2013
Trainee
TCS Trainee
12.2010 - 03.2011
Bachelors of Engineering - Information Science and Engineering
Visvesvaraya Technological University
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
Shantal MurilloShantal Murillo
Senior Compliance/AML Officer at Finance in MotionSenior Compliance/AML Officer at Finance in Motion