Abilash Yadav

About Abilash Yadav

Over 7 years of Data Warehousing experience in the areas of ETL design and Development. Involved in complete SDLC, including Requirements gathering, System Designing, Data modeling, and ETL design, development, Production Enhancements, Support and Maintenance. Excellent Interpersonal and communication skills with an ability to remain highly focused and self-assured in fast-paced and high-pressure environments.Extensive ETL tool experience using IBM Infosphere/Websphere DataStage, Ascential DataStage.Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.Worked with Dimensional modeling, Data migration, Data cleansing, ETL Processes.Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL CodingExperienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.Knowledge in using Erwin as leading Data modeling tool for logical (LDM) and physical data model (PDM).Assisted in development efforts for Data marts and Reporting.Extensive experience in design and development of Decision Support Systems (DSS).Technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.Worked with various databases like Oracle 10g/9i/8i, DB2, SQL Server, Teradata.

Experience

1. Datastage Developer

   Wells Fargo

   Jul 2012 — Present

   Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage.Involved in design of dimensional data model – Star schema and Snow Flake SchemaGenerating DB scripts from Data modeling tool and Creation of physical tables in DB.Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source filesCreated some routines (Before-After, Transform function) used across the project.Experienced in PX file stages that include Complex Flat File stage, DataSet stage, LookUp File Stage, Sequential file stage.Adept knowledge and experience in mapping source to target data using IBM Data Stage 8.xImplemented multi-node declaration using configuration files (APT_Config_file) for performance enhancement.Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)Debug, test and fix the transformation logic applied in the parallel jobsInvolved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.Experienced in using SQL *Loader and import utility in TOAD to populate tables in the data warehouse.Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost.Repartitioned job flow by determining DataStage PX best available resource consumption.Created, implemented, modified and maintained the business simple to complex reports using Business objects reporting module.

Education

• Indian Institute of Technology, Bombay

  Bachelor's degree, Electrical, Electronics and Communications Engineering

  1998 — 2002

• Nagpur University

  Master's degree, Computer Software Engineering

  2002 — 2005

Skills

• Teradata Data Warehouse
• Sql
• Data Warehousing
• Hp Quality Center
• Visual Basic
• Etl
• Unix Shell Scripting
• Websphere
• Testing
• Oracle
• Database Design
• Software Development Life Cycle
• Unix
• Oracle Database
• Clearcase
• Datastage
• Pl/Sql
• Etl Design and Development
• Ascential Datastage
• Autosys
• Toad