SUMMARY:

• Having 9+ years of experience in Data Warehousing with strong knowledge in multiple versions of IBM Infosphere Datastage(11.5/9.1/8.x/7.5).
• Involved in creating Proof of concepts and standards as Center of Excellence team member in Confidential .
• Involved in Design and code reviews of ETL for various projects.
• Having Experience in loading Data to Several Enterprise Datawarehouse(EDW),ODS and DataMart’s using Datastage.
• Strong experience in working with multiple RDBMS technologies like Oracle 12c/11/10, Microsoft SQLserver 2008/2012,IBMDB2 and Teradata 10/12/13/14.
• Involved in business requirement gathering meetings and development workshops.
• Good estimation skills coupled with a solid approach to the deliverables.
• Understood the business rules and implemented data transformation methodologies.
• Prepared ETL design /mapping documents based on business requirements.
• Hands on experience in developing Datastage server & parallel jobs.
• Involved in performance tuning of existing designs to reduce run times in production.
• Involved in creation of test plan strategy for Datastage by working with QC team.
• Involved in Data Stage Environment set up of various projects.
• Hands - on experience working on Agile and Waterfall model methodologies.
• Exceptional ability in trouble shooting and fixing issues.
• Exceptional ability to code and understand UNIX and SQL scripts.
• Experience in writing scripts using Teradata utilities like Multiload/Fast load/TPUMP.
• Involved in creation and execution of Disaster recovery plan by working with Data stage infrastructure, DBA and several upstream/downstream system teams.
• Solid Experience in batch processing and hands on working with Autosys.
• Experience working with EBCDIC/ASCII format mainframe/VSAM source files. knowledge on other ETL tools like Informatica power center and Alteryx.
• Experience in Data profiling using IBM Infosphere Information Analyzer.
• Experience in using Hadoop File connector & Big data file stages in Data stage.
• Experience in Using other information server tools like FastTrack and Data click.
• Experience in Parsing, Transforming and composing XML Data using Hierarchy, XML input/output and XML transformer stages using Datastage.
• Experience in writing rulesets using quality stage and Information analyzer.
• Perform column analysis, rule analysis, primary key analysis, natural key analysis, foreign-key analysis, and cross-domain analysis using IBM Information Analyzer.
• Experience in Data standardization using IBM InfoSphere Datastage &Quality Stage.
• Experience in Word Investigations,Character Discrete using Investigate stage.
• Experience in using various quality stages like Investigate,Standardize,Match stage.
• Experience in creating ETL packages using SSIS to validate, extract, transform and load data to warehouse databases, data mart databases.
• Proficiency in Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.
• Provided Logging, Error handling by Event Handler and Custom Logging for SSIS.
• Experience in loading data into HIVE Tables using connector in Datastage.
• Experience in Transferring files from Linux to HDFS using sqoop.
• Knowledge on Data visualization/Reporting tool Tableau.
• Experience in using Oozie workflow activity of Datastage for scheduling jobs in Hadoop.
• Experience in using Hadoop stack (Sqoop,Hive,Hbase).
• Provided Logging, Error handling by Event Handler and Custom Logging for SSIS.

TECHNICAL SKILLS:

ETL Tool: IBM Infosphere Datastage 8.X/9.1/11.X, IBM Information Analyzer, IBM Change Data Capture, IBM Infosphere Quality Stage, Ascential Data stage 7.5, Informatica power center 8.X/ 9.X, SQL Server integration services 2008(SSIS), Alteryx

Reporting Tool: Tableau

Data Profiling Tool: IBM Infosphere Information Analyzer

RDBMS: Oracle 9i/10g/11g/12c, Teradata 10/12/13/14, SQL server 2005/2008/2012, IBM DB2

Languages: SQL, PL/SQL,C,C++,XML

Data Modeling: Erwin

Operating System: Windows XP/7/10,Linux,Unix

Version control: PVCS, Accurev, Git Hub

Scheduling Tool: Autosys

Other Tools: HP ALM,CA Agile, Putty, IBM HOD,Winscp

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Environment: IBM Infosphere Datastage 9.1/11.5, IBM Infosphere Information Analyzer, IBM Infosphere Quality Stage, IBM Connector Migration Tool, Horton works Hadoop 2.X,Oracle 12c Teradata 14, Mainframe Flat files, Linux,Windows7,Autosys, IBM Host on Demand, AGILE Methodology

SDA (System design analyst)

Responsibilities:

• Involved in Gathering business requirements and design of the ETL system to meet the reporting application needs.
• Involved in Environment setup of the Data stage project in DEV/QC/Production environments.
• Prepared Test plan strategy by working with QC team.
• Prepared ETL design documents and mapping sheets for developers.
• Architected ETL design templates and done coding for complex requirements.
• Involved in design and code reviews of Datastage jobs.
• Involved in Data modeling workshops and development.
• Played lead role owning to the delivery of ETL component.
• Involved in Performance tuning of ETL components.
• Efficiently fixed the data issues during all phases of project life cycle.
• Provided knowledge to the support team on timely basis to understand the data flow for fixing the issues.
• Prepared run book instructions and data catchup process for support team.
• Involved in preparing unit test cases and module specification documents.
• Involved in creating POC for using Hadoop file connector and Bigdata File stage of Datastage.

Confidential, Dearborn, MI

Environment: IBM Infosphere Datastage 8.5, Ascential Datastage 7.5, Teradata 13,Mainframe Flat files, Linux,WindowsXP, IBM DB2,Microsoft SQL server 2012, Oracle 11g

Team Lead

Responsibilities:

• Involved in Environment setup of datastage 8.5 for the existing projects.
• Fixed the issues related to version migration in all environments.
• Played lead role owning to the delivery of ETL component.
• Involved in data validation post migration of ETL components.
• Involved in modification of all Unix components based on requirementsf the new environment.
• Involved in unit testing of jobs in new Environment.
• Provided support for all Migration projects until production deployment.
• Involved in changing the ETL jobs from legacy Teradata database stage to Teradata connector stage and validated the data.
• Provided knowledge on IBM Infosphere Datastage 8.5 to resources.
• Involved in developing Proof of concept on Datastage connector migration tool.
• Involved in developing proof of concept on new stages in Datastage 8.5.

Confidential, Dearborn, MI

Environment: IBM Infosphere Datastage 7.5.2, Teradata 13, Linux,WindowsXP, Microsoft SQL server, Oracle 10g,DB2

Team Lead

Responsibilities:

• Involved in design and development of ETL code as per business requirements.
• Worked with data architects and data analysts to review and interpret data dependencies and data model relationships.
• Developed detailed ETL design documents, ETL specifications and data mappings based on requirements.
• Designed jobs using different stages like Change Capture stage, Modify stage, Aggregator stage, Sort stage, Data Set stage, DB2 UDB stage, ODBC stage, FTP plug-in, Merge, Join, Lookup, Transformer (Parallel), Oracle Enterprise Stage and Stored Procedure stage.
• Worked with production support team and defined production release requirements.
• Used routines to implement complex transformations, date conversions, processing logics and calculations using various Datastage in built functions.
• Design mapping documents, which include details of field-to- field mapping between sources and target, Business (Transformation) Rules, Processing flow and details of sessions, pre-dependencies, post-dependencies, and exception error processing methodology.
• Extracted data from sources like DB2, Fixed width and Delimited Flat files, transformed the data according to the business requirement and then Loaded into Oracle database.
• Involved in supporting testing team for data validation.
• Worked with various Partitioning (Round-Robin, Hash fields, Range, Random and etc.) and Collecting (Round-Robin, Ordered and Sorted Merge) techniques.
• Designing and developing of PLSQL - procedures to load table Data.
• Designed Job sequences to provide optimal run time besides complex dependencies.
• Created unit test cases for testing the jobs.
• Involved in performing the various data cleansing activities in Datastage.
• Developed Autosys JILS for scheduling Datastage jobs.
• Performance tuning of jobs is done at stage level.
• Involved in the Peer review.
• Extensively worked in improving performance of the jobs by avoiding as many transforms as we can.
• Prepared documentation for unit, integration and final end - to - end testing.
• Optimized/Tuned Datastage jobs for better performance and efficiency.
• Responded to customer needs; self-starter and customer service oriented.
• Worked within the team to make appropriate, effective decisions related to project responsibilities and to initiate and follow-up on assigned tasks without supervision.
• Provided support and guidance by creating Release, Deployment guide documents.

Confidential, Dearborn, MI

Environment: MS SQL Server 2008/2008R2, MS SQL Server Integration Services, Sequential Files,Autosys

Developer

Responsibilities:

• Involved in incorporating new changes as per business requirements.
• Involved in Loading data to operational Data store(ODS) and then to EDW.
• Involved in Created unit test cases and Module specification documents.
• Involved in performing the various data cleansing activities.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Merge and Union all.
• Designed ETL jobs to cater SCD1, SCD2 scenarios.

Confidential, Dearborn, MI

Environment: Ascential Datastage 7.5.2, Teradata 10, Linux, Windows XP, Sequential Files, Oracle 9i

Developer

Responsibilities:

• Involved in incorporating new changes as per business requirements.
• Involved in Loading data to operational Data store(ODS) and then to EDW.
• Involved in Created unit test cases and Module specification documents.
• Involved in performing the various data cleansing activities.
• Worked with various stages like lookup, join, merge, sort etc.
• Performance tuning of jobs is done at stage level.
• Designed ETL jobs to cater SCD1, SCD2 scenarios.
• Designed job sequencer to run multiple jobs with dependency and email notifications in Datastage.
• Involved in Unit Testing, SIT and UAT Worked with the users in data validations.