PRITAM CHOWDHURY
Kolkata,MO
Summary
Informatica Cloud Lead Analyst and Data Warehouse Analyst at Tata Consultancy Services.
Overview
6
6
years of professional experience
Work History
IT Operations Analyst
Tata Consultancy Services
Kolkata
07.2019 - Current
- Company Overview: Currently working in an onsite position at TCS Uruguay.
- More than 5 years of experience in the IT industry, with over 4 years in the areas of Data Warehousing, IICS, CAI, and CDI integrations with various applications.
- I am a motivated, hardworking, and skilled individual who considers himself an excellent team player and has over four years of industry experience, which includes extensive experience with Informatica PowerCenter, Informatica Cloud (IICS), and Oracle Databases.
- I have worked extensively with PowerCenter in performing the Extraction, Transformation, and Loading process in the area of Data Warehouse and Business Intelligence.
- I also have designed and led the cloud migration initiative to move from PowerCenter to IICS.
- I have a very good technical background, combined with excellent analytic ability, good communication, and interpersonal skills.
- Specialties: ETL: IICS CAI/CDI, GIT, IICS Admin, Informatica PowerCenter, Oracle Fusion SaaS (General Ledger), Data Warehousing.
- Databases: Oracle.
- Cloud Exposures: Oracle Cloud Infrastructure (OCI), Azure.
- Business Domain: Publishing.
Education
B.Tech/B.E. - Mechanical
College of Engineering And Management, Kolaghat
01.2019
12th - English
CISCE(ICSE/ISC)
01.2015
10th - English
CISCE(ICSE/ISC)
01.2013
Skills
- Informatica Cloud (CAI/CDI)
- IICS Admin
- Informatica PowerCenter
- Performance tuning
- PLSQL
- GIT
- Data warehousing
- Cloud migration
- Real-time integration
- API integration
- Data integration expertise
- Agile methodologies
- Project management
Projects
Oracle Fusion SaaS Support(Onsite):
• Resolved over more than 50 technical support tickets regarding IICS to Oracle Fusion SaaS Integrations acheiving 98% resolution rate within service level aggrement(SLA) timeframes.
• Develop and implement newer solutions to ease out the existing dataflow transformation logics, reducing downtime by 20% and improving overall system performance.
• Providing end user support maintaing 98% user statisfaction through timely and efficient issue resolution.
• Mitigating out risk in existing IICS dataflows thus making the system roboust.
Cloud Migration Initiative:
• Led the cloud migration initiative of existing Informatica on-premise powercenter integtaions for Enterprise Data Warehouse to IICS Cloud following industry standard best practices.
• Transforming existing complex Oracle PL/SQL stored procedures to IICS CDI dataflows.
• Responsible for the design, coding, testing and implementation of ETL functionality.
• Providing POCs to client for New enhancement opportunities.
• Design and implementation of enhancements to meet the requirement of Client.
Revenue Reconciliation:
• Development of ETL mappings, sessions, wroklets and workflows to integrate McGraw-Hill School education group royalty expenses to RevPro(Zuora) for revenue reconciliation.
• Development of ETL mappings, sessions, wroklets and workflows to integrate general ledgers to Oracle ERP application.
• Responsible for the design, coding, testing and implementation of ETL functionality.
• Providing POCs to client for New enhancement opportunities.
• Design and implementation of enhancements to meet the requirement of Client.
Timeline
IT Operations Analyst
Tata Consultancy Services
07.2019 - Current
B.Tech/B.E. - Mechanical
College of Engineering And Management, Kolaghat
12th - English
CISCE(ICSE/ISC)
10th - English
CISCE(ICSE/ISC)
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