Tasneem Ahsan
Pune
Summary
With a proven track record of 6+ years at Infosys Limited, I spearheaded the seamless migration of 100+ Oracle databases to PostgreSQL (including both On-Prem & Cloud), showcasing my expertise in Ora2pg migration and strong management skills. My strategic approach and collaboration led to optimized database performance and system resilience, underlining my ability to deliver complex projects efficiently.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Technology Analyst
Infosys Private Limited
Zurich, Switzerland & Pune
07.2020 - Current
- Led the migration of over 30 applications involving 100+ Oracle databases to PostgreSQL, ensuring a seamless transition with minimal downtime from inception to completion.
- Developed comprehensive migration strategies, including schema remediation/conversion, data migration, and constraint migration.
- Conducted a thorough assessment of the Oracle database to identify migration challenges, define migration strategies, and optimize performance.
- Collaborated closely with application teams to coordinate migration activities and address technical issues promptly.
- Proficient in understanding PL/SQL complex queries and code, and remediating to PostgreSQL-compatible SQL queries, stored procedures, triggers, or functions.
- Performed various PostgreSQL on-premises DB version upgrades, handled en route challenges faced, and performed rollbacks where required.
- Involved in the migration of Azure PostgreSQL DB from a single server to a flexible server using FMS or pg_dump and pg_restore.
- Handled protected data and worked on restricted zone servers/DBs from the client office at the onsite location.
- Optimized PostgreSQL database performance post-migration through query performance tuning and indexing strategies.
- Configured Patroni clusters to ensure data availability and system resilience in the production environment.
- Troubleshot patroni setups, diagnosed issues, and implemented solutions to ensure the smooth operation of the PostgreSQL database.
System Engineer
Infosys Private Limited
Bhubaneswar
04.2019 - 06.2020
- I analyzed the existing COBOL programs, jobs, and DB2 database with respect to the business and used them to resolve the client issues.
- Managed production jobs, ABEND, and performed impact analysis to resolve user and production issues.
- Also, I learned the flow of events through various dispatchers from the QUEUE segment and solved various failures and stuck events in the QUEUE.
- Performed root cause analysis to identify the cause of issues in the test/production environment.
- Worked on 24/7 on-call support and resolved technical and production issues, along with Agile methodologies.
System Engineer Trainee
Infosys Private Ltd.
Mysore
12.2018 - 04.2019
- Completed training in Python and DBMS concepts.
- Learned new concepts for optimizing the application and improving code quality.
- Completed training in the stream section on Mainframe, which included JCL, Cobol, DB2, and various CICS transactions.
Education
Integrated M.Tech - Water Engineering & Management
Central University of Jharkhand
Ranchi, Jharkhand08-2018
Intermediate - Science
Jharkhand Academic Council
Simdega05-2013
Matriculation -
Central Board of Secondary Education
Simdega05-2011
Skills
- Ora2pg migration
- PostgreSQL
- PLPGSQL
- PostgreSQL version upgrade
- Azure PostgreSQL
- Oracle SQL
- PL/SQL
- Performance tuning
- DB2 concepts
- Python
- Agile methodology
- Management Skills
- JCL and COBOL
- Microsoft Office 365
Certification
- Database Design and Basic SQL in PostgreSQL from the University of Michigan.
- Intermediate PostgreSQL from the University of Michigan.
- Deploy a container by using Azure Kubernetes Service from Microsoft.
- Infosys Certified Python Associate.
- Infosys Certified PostgreSQL Associate.
- Infosys Certified Global Agile Developer.
- Infosys Certified Kanban Practitioner.
Awards
- Excelled Infosys Limited training under HPF Rating
- Received Infosys Rise Insta Award Q3 2022 and Q3 2024
- Gold Medalist of the batch (2013-2018) on Water Engineering & Management at Central University of Jharkhand
Personal Information
Date of Birth: 10/09/95
Tools Used
PgAdmin 4, SQL Developer Client, Infosys Data Migration tool (IDM), Azure portal, Azure FMS database, Nifi, Putty/SuperPutty, Microsoft Office 365, JIRA, Toad, DBever, Eclipse, Service Now, BMC Remedy, Reflection Workspace, Itron IEE, CSS Workstation,
Timeline
Technology Analyst
Infosys Private Limited
07.2020 - Current
System Engineer
Infosys Private Limited
04.2019 - 06.2020
System Engineer Trainee
Infosys Private Ltd.
12.2018 - 04.2019
Integrated M.Tech - Water Engineering & Management
Central University of Jharkhand
Intermediate - Science
Jharkhand Academic Council
Matriculation -
Central Board of Secondary Education
Similar Profiles
Jaswanth TumatiJaswanth Tumati
SYSTEM ENGINEER - JAVA WEB DEVELOPER at INFOSYS PRIVATE LIMITEDSYSTEM ENGINEER - JAVA WEB DEVELOPER at INFOSYS PRIVATE LIMITED
Choudhary Amit Kumar ManojChoudhary Amit Kumar Manoj
Senior System Associates at Infosys Private LimitedSenior System Associates at Infosys Private Limited
Vaishakhi KabirVaishakhi Kabir
Salesforce Developer at Infosys Private LimitedSalesforce Developer at Infosys Private Limited