SUMMARY

• Over 9+ Years of experience in full life cycle of software project development in various areas like design, Applications development of Enterprise Data Warehouse on large scale development efforts leveraging industry standard ETL toolsSynopsis
• Highly accomplished and innovative Senior Developer having experience and broad skill sets in ELT programming and data ware housing using IBM info sphere Data stage and Quality stage 9.1. Strong background in Data Warehousing, dimensional modeling, Star Schema, snowflake schema and ETL jobs. Gained proficiency in all phases of SDLC and Software Testing Life - Cycle from test cases design and development to defect tracking to managing defect life cycle. Able to quickly learn and understand business domain and behave to deliver business value on a consistent basis.
• Maintain and enhance proficiency with tools and technologies and provide mentoring and training as the opportunities arise
• Experience in understanding of business issues and goals in order to provide appropriate technical solutions
• Experience in delivering projects in HealthCare/Banking/Financial Services organization
• Ability to self-start and support projects through full-life cycle
• Proven track record of delivering IT projects

TECHNICAL SKILLS:

Data Warehousing Tools: IBM Info Sphere Data Stage and Quality Stage (11.3/9.1/8.7/8.5/8.1/7.5 x2/7.0)

Big Data Technologies: HDFS, HBase, Hive, PIG, Sqoop, Flume, Oozie

Programming Languages: PL/SQL, SQL, C, C++, Java

Scripting Languages: Unix shell scripting, Perl, AWK

Operating systems: IBM AIX 6.3, HP-UX, Red Hat Linux 4.0, Windows 8, Windows Server 2003, CentOS.

Methodologies: Data Modeling, ER Modeling.

Databases: Oracle 11g/10g/9i/8i, DB2 8.7, Teradata V13

BI Tools: Hyperion Essbase and Planning, Tableau

Version Control Tools: Tortoise SVN, PVCS, Clear case.

Scheduling Tools: Control-M 6.3, Autosys 4.0, TWS 8.6

Other Tools: Quest TOAD 12.1, HP ALM, Service Catalog, Ultra Edit, WinSCP,HPSM,ITG, Tera Data SQL Assistant,DB2 Control Centre,XML Editor, Attunity Stream V5.1

PROFESSIONAL EXPERIENCE

Confidential, MN

Senior ETL Developer

Responsibilities:

• Key project implementations as Senior team member
• Used Nodes Process - Improved the performance of the major SQL queries in extracting huge amount of data for daily processing which helps to meet SLA for ETL batch
• Implemented the common framework for ETL process.
• Taken the responsibility of implementing 3RDD Big Data project as part of health care reforms and delivered it before the schedule and involving in Daily Production Batch load.
• Preparing the DQ Requirement sheets and taking the sign off from the SME’s before getting start with the design of actual jobs.
• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information
• Generating the Pattern report and Token report as requested by the Business in identifying the Data patterns and inconsistency in source data.
• Effectively used standardized stage in standardizing the source data by using the existed rule sets like name, address etc.
• Build customized rule sets for standardizing the source data.
• Used Match and Survive stages in order to get the best breed of record from the source to target.
• Effectively worked on AVI stage to validate the address information coming from the source and generated the valid and invalid address reports.
• Have direct meetings with Business users to understand the all issues they reported/facing and provide them short and long term workaround. Implementing manual work-around where manual effort required until fix went to live
• Participated in war-room meetings in case of any potential delay in cycle from our end due to any major failures in code or any other upstream or downstream failures.
• Created UNIX scripts to automate the process for long running jobs and failure jobs status reporting.
• Involved in various reviews and meetings including Internal and external code review, weekly status calls, issue resolution meetings and onsite code acceptance meetings.
• Involved in documenting the code changes as per UDP/ADP documentation process.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets
• Involved in implementing common ETL framework process for all the jobs in projects.

Environment: IBM info sphere Data stage V11.3, Oracle 10g, HP ALM, TWS V8.5, ITG

Confidential, MN

Senior ETL Developer

Responsibilities:

• Understand the Application and technical specification documents for individual subject area
• Creates logical data models adhering to data warehouse design principles.
• Extensively used ETL to load data from different source systems having different formats to target Oracle BI.
• Involved in ETL design and implementation of Scd type 2 data warehouse. Leading a module at offshore for design and implementation of the same.
• Monitoring the entire Batch cycle of application and working on high priority incidents and Problem Tickets
• Implementing manual work-around where manual effort required until fix went to live
• Have direct meetings with Business users to understand the all issues they reported/facing and provide them short and long term workaround.
• Involved in developing SPRF’s with Dev Team and implemented performance tuning on Datastage jobs which are running with poor performance in production
• Created Unix scripts to automate the process for long running jobs and failure jobs status reporting
• Involved in monthly code releases for the allocated PT’s and Change Tickets
• Used ITG tool for code deployment from BFX to Prod and other Test environments as well
• Working as a Primary and secondary support member to fix daily cycle issues and other incidents and service calls as well.
• Involved in migration of autosys jobs to TWS jobs as part of project migration

Environment: IBM info sphere Data stage V8.7, HP QC, ORACLE 10 g, TWS V8.5, HPSM, ITG, Autosys 4.0

Confidential, NY

ETL Developer

Responsibilities:

• Understand the technical specifications and develop data stage jobs for Extraction Transformation, Cleansing and Loading process of DW.
• Captured data from a variety of sources including DB2, Flat Files, SAP R/3 Mainframes and other formats.
• Extensively worked with Data Stage Shared Containers for Re-using the Business functionality.
• Used extensively Reject Link, Job Parameters, and Stage Variables in developing jobs.
• Drafting technical documents like Overview documents, migration and deployment documents for every code release.
• Involved in Migration of Data stage code from DS 7.5x2 to DS 8.1.
• ABAP extract packs for extracting the data from ABAP reports.
• Used IDOC/BAPI load methods to load the master data into SAP.
• Used SAP plugins (ABAP Extract, IDoc Extract, IDoc Load and BAPI LOAD).
• Involved in various reviews and meetings including Internal and external code review, weekly status calls, issue resolution meetings and onsite code acceptance meetings.
• Assisted SIT testing team, UAT team and Production team during code release with code walk through and presentations and Defect identification, reporting and tracking.
• Review of test cases & scripts.

Environment: IBM Web sphere Data stage V8.1, Oracle 10g, HP QC, DB2 8.7, Teradata V12, SAP R/3,Control-M

Confidential, NY

ETL Developer

Responsibilities:

• Understand the business rules completely and implements the data transformation methodology.
• Developed various transformations using transformer stage, used other stages such as merge stage, look up stage, funnel stage, filter stage, copy stage, Pivot stage.
• Implemented Audit routines for audit capture activity.
• Automation is done by using batch logic, scheduling jobs on a daily, on a weekly and yearly basis depending on the requirement using Control-M.
• Created database tables and used PL/SQL procedure for validation report, Balancing report, Audit report
• Developed Sequences as well as Parallel jobs to load the data from flat files to DB2.
• Involved in Unit testing to prepare the Job level Test Cases
• Creating implementation plans and Production support

Environment: IBM Web sphere Data stage V8.1, DB28.7, HP QC, Cognos 8x, Control-M

Confidential, NY

ETL Developer

Responsibilities:

• Understand the business rules completely and implements data transformation methodology
• Validating data at field level and implemented rejection handling to capture bad data
• Designed & developed numerous Jobs in the project which involved Complex transformations, performance enhancements, validations, surrogate keys, SCD’s.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Code Deployment to different Regions and Prepared deployment documents for every code release.
• Development of newly added facets with the new subject areas along with the modification in existing subject areas as per the change in the requirement with the ad-hoc processing and the reporting of data.
• Design and implementation of Audit Trail Model, a new process to have audit of data being migrated from one release to other release in the subsequent Transformation releases.
• Preparing all the artifacts related to project.
• Fixed the bugs generated in SIT, UAT and PROD.

Environment: Ascential Data stage V7.5x2, HP QC, ORACLE 9i, Control-M, PL/SQL, COBOL-II, VSAM, and DB2.