SUMMARY:

• 10 years of experience in analysis, design, development, testing, maintenance and implementation of ETL methodologies in all phases of Data warehousing life cycle and Relational databases using IBM InfoSphere DataStage 11.3/9.1/8.5/8.1.
• Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema).
• Deep understanding of OLTP, OLAP and data warehousing environment and tuning both kind of systems for peak performance.
• Familiar in using highly scalable parallel processing Infrastructure using DataStage Enterprise Edition (Parallel and Server).
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), Surrogate Key assignment and CDC (Change Data Capture).
• Expert in designing Parallel jobs using various stages like Join, Merge, Sort, Copy, Lookup, RemoveDuplicates, Filter, Funnel, Dataset, Complex flat file, Modify, Aggregator, XML, Transformer, Change Apply, Row Generator, Column Generator and many other stages.
• Experience in working with parallel extender for splitting bulk data into subsets to distribute the data to all available processors to achieve best job performance.
• Experienced in Performance Tuning, Bug Fixing and Trouble Shooting of Data Stage Jobs.
• Experienced in Oracle PL/SQL to develop oracle functions, stored procedures, packages, triggers and experienced in incorporation of various data sources like Oracle, SQL server, DB2, Flat files, Teradata, Mainframe sources, datasets operational sources into the staging area.
• Experienced in Data Warehousing, Application Development and Production Support, also good Experience with different RDBMS like Oracle 11g/10g/9i/8i, DB2 for ZOS and DB2 for Unix.
• Expertise in creating reusable components such as Shared containers, Local Containers and in creating custom transformations, functions, routines.
• Experienced in performance tuning, bug fixing and troubleshooting of DataStage jobs.
• Worked on Scheduling tools like Autosys, Control-M for automating jobs run.
• Worked on Unix shell scripts for the scheduling of sessions, automation of processes, also for pre/post session scripts.
• Experience in coordinating with offshore and offsite teams to resolve design, development and testing issues.
• Having excellent track record as a strong team player with effective communication, analytical, multi-tasking skills, resourceful, result driven, ability to grasp quickly and self-motivated.

TECHNICAL SKILLS:

ETL Tools: IBM Info sphere DataStage 11.5/9.1/8.7/8.5/8.0.1/7.5

Operating Systems: UNIX, Windows NT/ 2000/XP, Windows7, Unix, AIX/Linux

Database: Teradata-15.10.1.4, Oracle11g/10g/9i/8i, MS Access, DB2 for ZOS V9/V10, DB2 V10 for Unix, MS-SQL Server, HP Vertica databases.

Languages: SQL, PL/SQL, C++, UNIX Shell scripting, JIL (Job Information Language), COBOL, JCL, REXX

DW/ETL Concepts: IBM InfoSphere DataStage Suite, IBM DataStage 8.0.1/7.5.2/7.1/7.0 Parallel Extender (PE), SSIS 2008/2012, Information Analyzer, Metastage 6.0, Cognos 6.0/5.x, Data Mining, Tableau Desktop/Server, OLAP and OLTP.

Data Modelling: Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions, Physical and Logical Data Modeling, Erwin 3.5.2/3.X

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale CA

Senior DataStage Developer

Responsibilities:

• Worked on IBM InfoSphere DataStage 11.3 to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Designing ETL jobs incorporating complex transform methodologies using Data Stage tool resulting in development of efficient interfaces between source and target systems.
• Developed/Modified Parallel jobs using Parallel stages like: Dataset, Sequential file, Funnel, Filter, Modify, Merge, Join, Lookup, Transformer and External Source Stage.
• Implemented data extraction, transformation and load processes in a parallel framework.
• Used stages like Transformer, sequential, Aggregator, Data Set, File Set, CFF, Remove Duplicates, Sort, Join, Merge, Lookup, Funnel, Copy, Modify, Filter, Change Data Capture, Change Apply, Head, Tail, Sample, Surrogate Key, External Source, External Target, Compare, Teradata Connector.
• Developed/ Modified the JIL (Job Information Language) Jobs in Autosys for scheduling the batch process.
• Worked with widely used stages like Flat File, Lookup, Join, Pivot, Transformer, Sort, Aggregator, Merge, Row Generator, and Column Generator, FTP and troubleshoot the designed jobs and tested the jobs for all logical errors.
• Customizing the Datastage Parallel jobs as per current business enhancements.
• Worked on DataStage V9.1 to developETLjobs that loads the data from staging to target tables in Teradata server as database.
• Involved in Performance and Tuning the Parallel Extender jobs to the maximum extent and achieved the best performance by reducing the Loading Time.
• Used different Parallel Extender Partitioning techniques in the stages to facilitate the best parallelism in the Parallel Extender jobs.
• Used shared containers for multiple jobs, which have the same business logic.
• Involved in performance tuning of the Data Stage jobs and queries.
• Extensively used Hash File Concept to improve performance.
• Involved in unit testing and validating the jobs before & after deployment of the codes.

Environment: IBM InfoSphere DataStage 9.1 (Designer, Administrator, Director), CA-Software Change Manager /Harvest, Teradata Server, Teradata SQL Assistant, Windows 7, IBM Rational Quest, Autosys, Unix Shell Scripting, AUTOSYS JIL (Job Information Language), Winscp

Confidential, Malvern PA

Senior DataStage Developer

Responsibilities:

• In AGILE, helped the team in planning the sprint by identifying modules and creating stories.
• Created COBOL-DB2, COBOL-IMS, CICS modules, insert/update or delete from DB, JCLs to
• execute the modules.
• Coded native stored procedures using IBM Datastudio to support our application UI to interact with DB2 database.
• Extensively used BMC and IBM Datastudio to do EXPLAINS on stored proc queries to understand the access path and optimized the queries accordingly.
• Designed and developed aREXX utility to parse COBOL/CICS source code and identify/create copybooks contained within and integrated with the CLIST to make it an invokable command.
• REXXscripts were written and run in the production environment as well as the test environment to verify the FTP data transfers and data integrity of testing data.
• Used File-Aid for DB2, QMF and SPUFI for accessing the DB2 database. Created DCLGENs and used them in COBOL modules.
• Used DB entities Views, Indexes and DB concepts like Triggers to handle & maintain data.
• Used Endevor tool to maintain the COBOL modules, JCLs, parms and procs and for promoting the same to higher environments.
• Used MainframeExpress to debug the COBOL modules and perform the unit testing.
• Used NDM and FTP has file transfer protocols between mainframe LPARs and between mainframe and midrange servers respectively.
• Used CA-7 as the scheduler tool for all the batch flows inside the application.
• Created Ezetrieve codes, Sort utilities like SyncSort and IBM DB utilities using JCL and framed the job flows for batch processing of application data.

Environment: IBM InfoSphere DataStage 9.1 (Designer, Administrator, Director), CA-Software Change Manager /Harvest, Teradata Server, Teradata SQL Assistant, Windows 7, IBM Rational Quest, PAC 2000(BMC remedy tool), Autosys, Unix Shell Scripting, AUTOSYS JIL (Job Information Language), WinSCP, Anthill Pro 5.0

Confidential, Newark DE

Senior Datastage Developer

Responsibilities:

• Worked on IBM InfoSphere DataStage 9.1 to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Implementing Industry ETL standards and best practices, performance tuning during designing the Datastage Jobs.
• Developed Parallel jobs using Parallel stages like: Dataset, Sequential file, Funnel, Filter, Modify, Merge, Join, Lookup, Transformer and External Source Stage.
• Used stages like Transformer, sequential, Aggregator, Data Set, File Set, CFF, Remove Duplicates, Sort, Join, Merge, Lookup, Funnel, Copy, Modify, Filter, Change Data Capture, Change Apply, Head, Tail, Sample, Surrogate Key, External Source, External Target, Compare.
• Involved in Performance and Tuning the Parallel Extender jobs to the maximum extent and achieved the best performance by reducing the Loading Time.
• Used different Parallel Extender Partitioning techniques in the stages to facilitate the best parallelism in the Parallel Extender jobs.
• Designed XML stages for reading XML log files for capturing data stage jobs audit data.
• Created master controlling sequencer jobs and scheduled it using AUTOSYS.
• Involved in performance tuning of the Data Stage jobs and queries.

Environment: IBM InfoSphere DataStage 9.1 (Designer, Administrator, Director), Business Objects 7.0, SQL Server 2000, SQL Query Analyzer, Windows NT/ XP.

Confidential, Jersey City, NC

Stage Developer

Responsibilities:

• Expertise in designing and implementing Datastage Architecture in data warehousing and Business Intelligence projects.
• Worked with Functional team and Data Modelers/Architects to identify and understand the data from different source systems.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing various kinds of transformations using SQL Server Integration Services (SSIS)
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Worked on the Data base design & data model - Logical & Physical design with hands on experience on DDL and DML SQL operations.
• Created Datastage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems like ODS, flat files, scheduled the same using IBM DataStage Sequencer for SI testing.
• Preparing development timing plans & reporting to senior management about the supplier progress system & ensuring their engineering support for onsite integration & production launch.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Automated process of job monitoring which helped in minimizing the manual intervention & documenting them perfectly.
• Developed the reusable components, best practices that were later used in other Data warehouse.

Environment: Data Stage 8.X, DB2 UDB, Oracle 11g, UNIX, MICROSOFT VISIO, control-M, SQL plus, WinCVS, AUTOSYS, MS SQL Server 2008 (SSIS/SSRS).

Confidential, Charlotte, NC

Senior ETL Developer

Responsibilities:

• Reviews existing data dictionaries and source to target mappings.
• Participate in Data modeling discussions, exchange thoughts to come up with a best model to efficiently serve both ETL teams and reporting teams.
• Designed complex DataStage mappings and re-usable transformations to facilitate Initial, Incremental and CDC data loads and parameterize to source from multiple systems.
• Worked on SSIS/DTS Package Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Used various control flow tasks such as bulk insert task, transfer job task, different data flow tasks and FTP task along with For Loop and For Each Loop containers to create SSlS packages.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created stored procedures to transform the data and worked extensively In T-SQL for various needs of the transformations while loading the data.
• Extensive Experience in writing SQL, PL/SQL queries, stored procedures, functions, packages and database triggers, exception handlers.

Environment: IBM Info sphere Datastage v7.5/8.5, Informatica Power center8.6, UNIX, Shell scripting, control M, Erwin, Teradata, Oracle, PL/SQL

Confidential, Charlotte

Datastage Developer

Responsibilities:

• Implemented Data Quality process which transforms the input fields into the data types used in the target database tables and does basic checks on the data fields and reports the data errors.
• Developed Parallel Jobs which loads Dimension Tables and maintained Surrogate key generation in multiple run.
• Extensively dealt with change capture techniques for implementing slowly changing dimensions process.
• Familiar with import/export of DataStage Components (Jobs, DS Routines, DS Transforms, and Table Definitions) between DataStage Projects, use of Dataset Management (DSM) utility and multiple jobs compile utility with use of Data Stage Director.
• Developing shell scripts to automate file manipulation and data loading procedures.
• Used Shared container for simplifying design and maintenance.
• Experienced in fine tuning, Trouble shooting, bug fixing, defect analysis in DataStage Jobs.
• Used error handler process Jobs to capture look up failure, duplicates and data type errors and these errors are captured to an error log detail table.
• Created process flow diagrams using Microsoft VISIO.
• Documented the development process and performed knowledge transfer to Business Intelligence team.

Environment: Data Stage/Quality Stage 8.0 (IBM WebSphere Data stage and Quality Stage Designer, Director, Administrator), DB2 UDB 9.2, SQL Server 2000, Linux 10, SQL, PL/SQL, UNIX Shell Scripting, Microsoft Visio, DB2 Visualizer, MS SQL server, Mainframe, COBOL.

Confidential

Mainframe Developer

Responsibilities:

• Created high-level and low-level design documents from the requirements documents.
• Worked as a team to develop a database for the application, logically grouped the data in the form of tables, defined columns in the tables, defined the constraints, created and executed DDL statements.
• Created JCLs to frame the job flow to develop various modules with in the application.
• Created COBOL-DB2 programs to format the data, apply business cases and then insert, Update or delete into database.
• Used ChangeMan as the version control tool for COBOL modules and the JCLs code
• Prepared the Unit test scripts and unit tested the COBOL-DB2 modules and mainframe job flows extensively.
• Extensively used XPEDITOR as the debug tool to test the code modules.
• Used the IBM Load and Unload utilities for the bulk load and extraction of data. Handled very high volumes of data for batch processing.
• Used File-Aid for DB2, QMF and SPUFI for accessing the DB2 database. Created DCLGENs and used them in COBOL modules. Used tools like Syncsort.
• Used VISUAL EXPLAINS tool to analyze and optimize the performance of an SQL query.
• Created DB2 Stored Procedures using COBOL for manipulating and fetching data for the web server calls made from front end application.
• Created COBOL codes for accessing, reading and editing the VSAM datasets.
• Created Ezetrieve codes for file comparison and data manipulation and formatting activities.
• Used NDM and FTP has file transfer protocols between mainframe LPARs and between mainframe and UNIX servers.

Environment: COBOL, DB2, JCL, Ezetrieve, SyncSort, MS SQL Stored Procedures, Endevor, Xpeditor, BMC Explains, CA-7, MS Visio, Quality Center, SharePoint