Roopali Bhatnagar

Email:add8sb@r.postjobfree.com Ph no: +91-909*******

PROFILE SUMMARY

● 4.5 years of IT experience in ETL System Analysis, Design, Development, Support, Implementation and Testing in the field of data warehousing, Business Intelligence & Database business application systems for Healthcare, Telecom, Finance & Banking Sectors.

● Extensively worked in developing ETL process to Extract, Transform and Load data from various sources into Data Warehouses using DataStage Manager, Designer, Director and Administrator.

● Ability in understanding business processes/requirements and translating into technical requirements.

● Active participation on various phases of End-to-End Business Intelligence solutions using DWH, DB & BI tools such as IBM-DataStage.

● Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing, Peer Testing and Technical Documentation.

● Completing staging process like Data cleansing, Data migration, Data Aggregating & Data Integration.

● Used all components of DataStage including stages like Data set, Join, Lookup, Merge, Aggregator, Sort, Funnel and Transformer etc.

● Extracted data from various sources like Oracle, Xml and Flat files.

● Experience working on multiple platforms like Windows and UNIX.

● Good Knowledge in ETL, SQL, UNIX, Netezza, Data-warehousing concepts.

● Experience in Data analysis using pivot tables and Charts using Microsoft Excel.

● Hands-on experience in Database Performance tuning, identifying and resolving performance bottlenecks in various levels like targets, sources, mappings and sessions.

● Writing and Executing Test cases at all the level from development to Production (UAT).

● Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

● Experience with Interpretation of statistical analysis, analyzing the data.

● Ability in coordinating with onshore / offshore teams, Quality in managing the team and understanding the business.

● Understanding about the business approaches like SDLC, Agile & Waterfall Model.

● An effective communicator with strong analytical, leadership, logical thinking & problem solving abilities.

Key Skills

RDBMS : Oracle 10g, IBM Netezza, DB2, Teradata, SQL Server Tools : DataStage 7.5/8.5/8.7/9.1/11.3, Cognos

Operating Systems : UNIX, Windows.

Certifications and Training

Completed DataStage version 8.5 certification of IBM Infosphere. Oracle certified for SQL, Pl-SQL databases.

IBM trainings: Cognos, Bluemix, IBM Watson, DSP, IBM SPSS Modeler, SAP-BPC Embedded. WORK EXPERIENCE

IBM India Pvt. Ltd. Since Feb’13 to Jun’15

Accenture Since Jun’15 to Apr’16

SLK Software Since Apr’16 to Nov’16

DAPL Consultancy Since Jan’20 to currently working Project Handled:

Title: Amedisys Inc (HCPDW Implementation)

Domain: Healthcare

Organization: IBM

Role: ETL Developer (ASE)

Duration: 10 Months

Team Size: 25

Brief: The project is aimed to implement Health care Provider Data model where IBM needs to fulfill BI requirements.

Deliverables:

o Contribution in developing jobs and high-level Sequences. o Analyzed and understood the mapping that specified the requirement to develop jobs using DataStage 9.1 execution and testing of high-level sequences. o Prepared Unit Test Plan for concerned Subject Areas. o Explored new database technologies, Ex: Netezza, MS-SQL, most of the source systems are implemented using Microsoft SQL Server database server and data integration target database will be implemented on the IBM Netezza database appliance. o Participated pro-actively and used to demonstrate my knowledge to other team members, by interacting with all the team members tried to solve different issues. I have given presentations, arranged knowledge sharing calls. Title: AT&T (GCP) Global computing Platform

Domain: Telecom

Organization: IBM

Role: ETL Developer (SE)

Duration: 1 year 4 months

Team Size: 60

Brief: GCP consists of ETL and EDB (SA, SD and FMO) teams. GCP will have the replica of all the different application that supports and load these replicas from the respective application tables/feed files. In general, ETL will get the data from the up-stream to and provide to the downstream as required.

Deliverables:

o Project Estimation, HLD Design, Impact analysis and review. Import, export, create and manage metadata for use within jobs.

o Overseeing maintenance of system environment using crons for scheduling jobs

(commands or shell scripts) to run periodically at fixed times, dates or intervals o Implement C:D setup for sending files to downstream o Setup a flip-flop for Tirks application, worked on Datastage 7.1,7.5,8.7,9.1 & Oracle, SQL. Title: Wind (ISP) Wind Telecommunication Spa (also known as Wind Italy) Domain: Telecom

Organization: Accenture

Role: ETL Developer (SE)

Duration: 10 Months

Team Size: 31

Brief: Wind is an Italian telecom operator which offers integrated mobile, fixed and Internet services (under Wind brand for mobile and business services and under Info Strada brand for home). The company’s product offerings include mobile commerce, fixed line services, broadband (with and without contract), device offers, offers including Local and long distance calls, free calling features, discounted SMS, top-up plans and many more. Deliverables:

Making enhancement to the ETL mappings, using DataStage 9.1, DB2, MySQL.

Fixing the job failures in environment, Finding & providing root cause analysis.

Developed mapping parameters and variables to support SQL override. Created mapplets to use them in different mappings.

Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data.

Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner etc.

Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.

Used workflow manager for session management, database connection management and scheduling of jobs.

Title: FHN (First Horizon National Bank, USA)

Domain: Banking

Organization: SLK Software

Role: ETL Developer (SSE)

Duration: 8 Months

Team Size: 31

Brief: First Horizon National Corporation is a large bank holding company based in Memphis, Tennessee, United States. It is the parent company of First Tennessee Bank, FTN Financial, FTB Advisors, Inc., and a host of other insurance and financial services companies. Deliverables:

Involved in design, Unit testing, development, troubleshooting and debugging of the code, successful deployments of the code, driving the conference call for requirement gathering from the client side, implemented with Datastage 11.3, Xml files and SQL.

Mapping the business requirements and translating these requirements into functional specifications and detailing tests.

Ensuring timely completion and delivery of project to the client; extending production support of multiple applications.

Liaising with key clients, nurturing relationships with key influencers and acquiring profitable business for providing systems support and implementation of software. Title: Syniti CMA-CGM(APL-FICA), Singapore

Domain: Shipping and Transport

Organization: DAPL Consultancy

Role: Data Consultant

Duration: currently working

Team Size: 7

Brief: CMA CGM S.A. is a French container transportation and shipping company. It is a leading worldwide shipping group, using 200 shipping routes between 420 ports in 150 different countries. In this project we were changing their old invoice tradition mainframe system to SAP BW.

Deliverables:

o Worked on end to end requirement of ETL Datastage development from design to deployment in production environment and in process of Go-Live. o Got the opportunity to learn about the Teradata database, and getting trained on the tools SAP-BODS and ETL-DSP.

o Created the Teradata scripts, implemented mapping transformations, and scheduled the jobs as per requirements.

o Deployed projects smoothly in each release without any issue, all the deliverables released on timeline in different execution environments. ACADEMIC DETAILS

B. Tech in Computer Science Under the RGPV University, India with 72.7%. HOBBIES & INTERESTS

Playing Table Tennis, Volunteering at the events, Playing Musical instruments, Singing, Cooking, Reading, Arts Creativity, & Exploring new places and veg. food.

Contact this candidate