SUMMARY:

• 10 years of ETL, data mapping, data analysis & modelling and product catalog configuration experience in Data warehousing, data migration and data configuration projects.
• Has been involved in whole SDLC life cycle for various development and maintenance/enhancement projects and has worked on ETL job design and automation, development, data mapping and modelling, data analysis/profiling and cleansing, scheduling and deployment.
• Worked on several source/targets like Oracle, DB2, Teradata, Big data Hadoop, flat files, XML files, COBOL Mainframes files etc.

TECHNICAL SKILLS:

Domain: Healthcare, Banking, Insurance, Heavy automobile, retail

Programming Languages: PL/SQL, Shell scripting, Core JAVA, excel VBA

Operating System: UNIX, Windows

ETL Tools: IBM Datastage (7.5, 8.0, 8.5, 8.7, 11.3), Ab - Initio

Data profiling/cleansing tools: IBM Information analyzer, IBM Qualitystage

Database: Oracle(9i, 11g), Netezza 3.0, DB2 10.5, Sybase, MS-SQL, Hortonworks Hadoop

Scheduling tool: Autosys

Version control: SVN, VSS

PROFESSIONAL EXPERIENCE:

Confidential

Sr EPC developer

Role & Contribution

• Worked with division teams for various billing and package codes (CSG and DDP billing systems).
• Analyzed and configured offers based on campaign codes provided
• Created ETL jobs for audits and various validation on offers in billing system for e.g. looking for correct bill codes, offer names etc
• Worked on mapping bill codes and package codes in the EPC system
• Worked on configuring offer presentation and contents
• Worked on analyzing and fixing production fallouts in a timely manner

TechnologiesOracle 11g

Tools: IBM Datastage 11.3, DDP and CSG billing systems

ETL Lead developer

Responsibilities:

• Worked with Appian team in completing the data mapping based on data load requirement and data model.
• Helped in creation of the data model for the Appian system
• Created stored procedures in Oracle as per business logic
• Suggested data types to be used in Appian for an efficient data load
• Designed the best possible approach based on the data load requirement.
• Designed the ETL jobs that run efficiently to complete the load in lesser time.
• Created automated flow of ETL jobs taking into consideration the load each job will create on the server

TechnologiesSybase 15.7, MS-SQL, Oracle 11g

Tools: IBM Datastage 11.3

ETL Consultant

Responsibilities:

• Designed and created generic jobs to load data from truck data files to DB2
• Created automated flow of ETL jobs for various data load to DB2
• Created generic solution for slowly changing dimensions and surrogate key generation
• Involved in testing and performance monitoring of generic ETL jobs for data load

TechnologiesDB2 10.5, Hortonworks Big data Hadoop, DB2

Tools: IBM Datastage 11.3

ETL Lead developer

Responsibilities:

• Worked as a team lead and is actively involved in reviewing the data models, ETL design/development and performance tuning of the ETL process
• Designed and developed functionalities like surrogate key generation, implementation of slowly changing dimensions, row pivoting etc in ETL tool
• Created Datastage sequences and UNIX scripts to automate the ETL process
• Worked on file handling like FTP and data file validation during the ETL process

TechnologiesOracle 11g

Tools: IBM Datastage 8.7 (ETL tool)

Senior ETL Developer

Responsibilities:

• Worked on process creation of data extraction from flat files received from business partners.
• Helped the data modelers for the creation of data models.
• Worked on design and development of ETL jobs for migration
• Handled data issues wherever encountered and reported it to the source system team
• Planned cut off strategy and data reconciliation during data migration
• Created jobs for complex parent child account relationships

TechnologiesOracle 11g

Tools: IBM Datastage 8.0

ETL Developer

Responsibilities:

• Worked on Data profiling using PL-SQL and IBM Information Analyzer.
• Took part in source to target mapping meetings with the client
• Involved in design, development and testing of Datastage jobs and PL-SQL codes for Data migration
• Worked as onshore co-coordinator and was involved in delegation of some development work to the offshore team

TechnologiesUNIX scripting, Oracle 11g, PL-SQL

Tools: IBM Datastage 8.0, IBM Information Analyzer 8.0

ETL Developer

Responsibilities:

• Datastage job development and scheduling as per requirement
• Was also involved in enhancement of previous Datastage jobs
• Loading of daily and monthly feeds from the source files into the facts and dimension tables
• Scheduling of Datastage jobs through Autosys
• Creation of UNIX wrapper scripts to start the ETL process

TechnologiesUNIX scripting, Netezza 3.0, Oracle 10g

Tools: IBM Datastage 7.5, Autosys

ETL Developer

Responsibilities:

• Worked as an Ab Initio developer
• Creation of ASCII metadata based on mainframes copybook
• Created Ab Initio graphs to extract data from Mainframes files and cleanse it based on downstream requirement
• Data was validated for date formats, NULLs etc. and cleansed as per downstream requirements
• Created automation scripts for copying production Autosys JILs to test and Dev environment

TechnologiesUNIX scripting, Oracle 9i

Tools: Ab Initio, Autosys