Power Center Information Technology

CHANDNI GUPTA

PROFESSIONAL SUMMARY

• Overall * years 10 months of experience as Senior System Analyst (ETL Developer) in Data Migration Team with specialization of Amdocs telecom suite (OMS/CRM/Enabler).

• Designed and developed ETL workflows using Informatica PowerCenter to extract data from various source systems, transform and cleanse it, and load it into the target data warehouse.

• Building and enhancing the migration mappings using Python, ksh and SQL scripts in Informatica power center client tool as per the customer's specification.

• Extensive onsite customer experience with trips at customer locations for Support, execution of migrated data from legacy to Target, analysis of defects and fixing in code.

• Fully experienced in end-to-end development of software products from requirement analysis to system study, designing, coding, testing, de-bugging, documentation, implementation and maintenance.

• Coordinating and working with Israel and USA based teams to gather requirements and translate them into technical specifications for ETL development.

• Handling bug fixing activity during Low volume and Full volume testing before actual Migration Rehearsals or Production.

• Worked on Performance Tuning to optimize Informatica workflows, mappings, sessions, and transformations for reducing data load times.

• Having a basic understanding of AWS services, architectural best practices, and the AWS Cloud infrastructure.

WORK HISTORY

ETL Informatica Developer, 04/2013 to 02/2018

Amdocs - India

KEY PROJECTS UNDERTAKEN:-

Vodafone Netherlands (Europe)

April 2013 till December 2014

• Transformed all legacy CRM, ordering systems of Vodafone Netherlands Telecom into Amdocs CRM, Ordering Systems for all prepaid Subscribers.

• Created Data Mappings from UF to Intermediate tables and then intermediate tables to Target system. Supporting Data Cleansing Issues and providing detailed reports on data quality & reconciliation.

CONTACT

Address: Madison, WI 53590

Phone: 608-***-****

Email: ************.**.*****@*****.***

SKILLS

• Tools: Informatica Power Center

9.6.1, SQL Developer, Toad, Quality

Center, Putty

• Database: Oracle SQL/PLSQL

• Language : Python, Shell Scripting

• Operating Systems :- Windows, Unix

CNT Ecuador

January 2015 till April 2016

• To merge CNT customer data into Amdocs CRM,OMS and Billing System.

• Designing, mappings, coding and populating database tables and unit testing.

Optimized ETL performance through tuning, indexing, and partitioning techniques.

AT&T DTV Openet (USA)

May 2016 till Feb 2018

• To migrate AT&T data into Amdocs System.

• Developed and tested all informatica mappings and Unix Scripts as per specification document provided.

• Developed and maintained Python scripts for data extraction from various sources, including APIs, databases, and flat files.

• Transformed and cleansed data using Python libraries and SQL queries, ensuring consistency and accuracy.

EDUCATION

Bachelor of Engineering, Information Technology, 06/2012 Jaipur Engineering College & Research Center - India CERTIFICATIONS

OCJP (Oracle Certified Java Programmer) for JavaTM 6

Contact this candidate