Tanmay Patil
Pune
Summary
Technically adept professional with over 14 years of experience leveraging expertise in ETL using Oracle PL/SQL and Agile methodologies to deliver high-quality data-driven projects for clients. Proven ability to manage concurrent projects, streamline data loading processes and implement Agile practices to ensure on-time, on-budget project completion. Lead projects for ETL, ensuring data integrity and accuracy throughout the project lifecycle including: functional and technical analysis, development, testing, deployment
Overview
14
14
years of professional experience
1
1
Certification
Work History
Assistant Consultant
Tata Consultancy Services (TCS)
Pune
06.2019 - Current
- Led and managed a portfolio of 2 concurrent projects related to data loading and application development in Risk Finance & Treasury
- Utilized SAFe to deliver user stories within defined sprints, resulting in increased team efficiency and project predictability and cross-functional collaboration with multiple teams
- Streamlined project planning, resource allocation, and risk mitigation strategies to ensure timely and successful project completion
- Reduced root cause analysis (RCA) time for production incidents by 50%, from 24 hours to less than 12 hours
- This resulted in faster resolution times and minimized business impact
- Implemented stricter code review and testing processes, leading to a significant decrease in the number of bugs deployed to production
- This proactive approach further reduced the occurrence of incidents and improved overall application stability.
Technical Leader
BNY Mellon Technologies
Pune
03.2015 - 03.2019
- Utilized Eagle PACE for a data warehousing project, creating, and deploying Oracle PL/SQL code (packages, procedures, views) to automate data quality checks and health monitoring for the entire application
- Identified bottlenecks in the existing codebase that were causing slow processing times
- Upgraded outdated libraries and packages to improve efficiency
- Refactored and tuned critical code sections to achieve a significant 25% reduction in processing time
- Applied learning on the job and developed a web-based portal for providing insights to the customers into the system for monitoring, health checks and downloading the same in report format using C#.
Technical Support Engineer
Cybage Technologies
Pune
12.2012 - 03.2015
- Automated client workflows by developing and maintaining SQL and UNIX scripts, streamlining data processing tasks
- Extracted critical business data by crafting complex SQL queries across diverse databases, ensuring efficient access to valuable insights
- Troubleshooted complex project issues by leveraging expertise in SQL and UNIX commands, resolving problems swiftly and maintaining project momentum
- Championed data integrity by implementing robust procedures and best practices to guarantee the system's seamless operation for all intended processes.
Junior Software Engineer
Steria India Pvt Ltd.
Pune
08.2010 - 12.2012
- Enhanced data management processes for critical business data by leveraging expertise in Oracle 10g and developing/modifying PL/SQL constructs
- Optimized data processing pipelines by efficiently modifying Shell scripts, significantly reducing SQL execution times on Unix servers
- Implemented robust ETL (Extract, Transform, Load) processes to ensure accurate and timely loading of business-critical data
- Maintained operational efficiency by monitoring data jobs through Control-M, ensuring smooth data flow and system stability.
Education
BE in Computer Engineering -
North Maharashtra University
Dhule, Maharashtra06.2010
Skills
- Oracle PL/SQL
- Data Warehousing
- Mongo DB
- Cloud Architecture
- Control-M
- Unix
- Quality Assurance
- Technical review
- GIT
Certification
- MongoDB Cloud Architect from MongoDB, July-2024
- Generative AI for Business Leaders, Pune, Maharashtra, LinkedIn, May-2024
- SQL with Python, Pune, Maharashtra, LinkedIn, Apr-2024
- Oracle 12c, Pune, Maharashtra, LinkedIn, Apr-2024
- Agile Foundations, Pune, Maharashtra, Project Management Institute (PMI), Jan-2022
- Hadoop and Big Data Certified Developer, Pune, Maharashtra, SimpliLearn, Apr-2015
Interests
- Football
- Developing KMS
- Read/Listen to books
Languages
Marathi
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Spanish
Beginner (A1)
A1
Accomplishments
- Multiple Star of the Month awards
- Multiple Best Team awards
- Multiple Appreciations from customers
Timeline
Assistant Consultant
Tata Consultancy Services (TCS)
06.2019 - Current
Technical Leader
BNY Mellon Technologies
03.2015 - 03.2019
Technical Support Engineer
Cybage Technologies
12.2012 - 03.2015
Junior Software Engineer
Steria India Pvt Ltd.
08.2010 - 12.2012
BE in Computer Engineering -
North Maharashtra 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
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Divya KandimallaDivya Kandimalla
SQL Support Engineer at Tata Consultancy Services (TCS)SQL Support Engineer at Tata Consultancy Services (TCS)
Gyata JainGyata Jain
Senior SQL Server DBA at Tata Consultancy Services (TCS)Senior SQL Server DBA at Tata Consultancy Services (TCS)
Poornima MendesPoornima Mendes
Senior Analyst, Strategic Data Management & Governance at Phreesia India Pvt LtdSenior Analyst, Strategic Data Management & Governance at Phreesia India Pvt Ltd