SUMMARY

• Around 8 years of IT experience with special emphasis on system analysis, design, development and implementation of ETL methodologies in all phases of Data warehousing life cycle and Relational databases using IBM DataStage 8.7/8.5/8.1/7. x/6.x(Information Server, WebSphere, Ascential DataStage, Datastage quality stage).
• Expertise in Insurance,Banking, Finance, Health Care and Trading domains.
• Strong data warehousing experience using IBM DataStage Components like Datastage Quality stage, Datastage Designer, Datastage Manager, Datastage Director, Datastage Administrator and Parallel Extender, ERwin, SQL Server, Oracle PL/SQL and involved in all the stages of Software Development Life Cycle (SDLC).
• Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema).
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogate key assignment and CDC (Change Data Capture).
• Experienced in Oracle PL/SQL to develop oracle functions, stored procedures, packages and triggers and experienced in in corporation of various data sources like Oracle, SQL server, Teradata and Flat files into the staging area.
• Experienced in Data Warehousing, Application Development and Production Support and excellent knowledge of different RDBMS like Oracle 8i/9i/10g/11g/12C, MS SQL Server and Teradata.
• Expertise in creating reusable components such as Shared containers, Local Containers and in creating custom transformations, functions and routines.
• Experienced with legacy systems and good understanding of SQL, RDBMS and Object-Oriented technologies.
• Excellent understanding of the DBA functions including creating tables, table spaces, databases and indices and extensive experience in UNIX Shell Scripting and Windows batch CMD Scripting..
• Good experience in writing JIL scripts and designing Autosys jobs using Web GUI and proven track record in troubleshooting of Datastage jobs and addressing production issues.
• Having excellent track record as a strong team player with effective communication, analytical and multi-tasking skills, resourceful, result driven and self-motivated.

TECHNICAL SKILLS

• IBM Infosphere 8.7/8.5(DataStage Enterprise
• Information Analyzer
• Quality Stage
• Metadata Workbench)
• Ascential DataStage
• Enterprise and DataStage 8.7/8..5/7.x/6.x/5.x
• Erwin
• Oracle 12C/11g/10g/9i/8i
• T-SQL
• TOAD
• Clear-Quest
• SQL Server 2000/2005/2008
• MS Office
• Windows 7/XP/NT/2000/98
• C
• C++
• TeradataV2R5.x/V2R6.x
• MKS
• Autosys
• UML
• Rational Rose
• MS Visio
• BOXI
• Outlook Express
• Lotus Notes.

PROFESSIONAL EXPERIENCE

Confidential, New-York City, NY

ETL/Data Warehouse Developer

Responsibilities:

• Actively interacted with data modeler in developing data mart design with Facts and Dimension tables for data warehouse.
• Created jobs using DataStage designer to import data from heterogeneous sources like Db2, Oracle, Flat files and SQL server.
• Used technical specifications and business rules for transforming the extracted data.
• Worked with DataStage Manager for importing and exporting table definitions/metadata and routines between DataStage projects.
• Extensively created user defined routines in addition to the DataStage in-built routines and transforms to handle various special and complicated data manipulations.
• Performed source data analysis and data cleansing.
• Involved in performance tuning of the DataStage jobs.
• Used DataStage Director to schedule, monitor and run jobs.
• Used DataStage Administrator for creating DataStage projects and setting up purging criteria.
• Involved in unit testing, system and integration testing.
• Developed UNIX shell scripts for file validations and job scheduling.
• Created detailed technical documentation for the jobs developed.

Environment: IBM DataStage 8.7/8.5, Oracle 12c/11g, DB2 V5,Win SCP, Windows 7/XP, IBM AIX, MS Visio, TOAD, Unix shell scripts,, SQL Developer, JIRA, Outlook Express, Lotus Notes.

Confidential, SanAntonio, TX

Enterprise Data Specialist

Responsibilities:

• Understanding of data mart development to include dimensional structures.
• Manage and direct high severity conference bridges and drive application, infrastructure, and vendor partners to problem resolution.
• Develop and Implement software Life Cycle Management Strategy jobs for supported platforms.
• Technical support to 2nd level support and provisioning teams.
• Follow change management standards and best practices for all software implementations and modifications to the environment.
• Follow standard project management disciplines for all platform driven initiatives.
• Develop Enterprise monitoring for ETL/Integration tools.
• Establish vision / road map for building leading edge integration solutions by leveraging the latest in middleware and server technologies.
• Lead and establish architectural design and operational requirements - leveraging state of the art technology to provide high availability across multiple datacenters.
• Plan, design, lead construction of Enterprise ETL/Data Warehouse/Integration tools.
• Develop Attended daily/Weekly Application/warehouse meetings to review the status of the schedule and go through pending issues.
• Design and lead construction solutions per Target Technology standards and best practices.
• Develop strong partnerships and lead efforts across teams to promote re-use and develop consistent technical build, implementation and support processes.

Environment: Datastage 8.5/8.1 PX, Control-M, Squirrel, SOL Server, DB2, Windows XP, Unix, Microsoft Visio, Microsoft excel, Microsoft word, VMware Service manager.

Confidential, Crystal City, VA

Datastage Developer/Admin

Responsibilities:

• Participated in business meetings, raised the requirement gaps and document the process. Participated in design meetings and perform detail level design using parallel extender.
• Involved in debugging data issues between source systems and EDW. Use Datastage Admin and Design and develop configuration files, Environment variables and parameter sets at Unix level.
• Designed and developed jobs in Quality Stage as per the ETL standards.
• Developed custom routines and transformations for Data Reconciliation of Source, File Check, and Custom TimeStamp format. Create, delete, move projects from one place to another.
• Extensive used Complex flat file, aggregator, Data set, Look-up, Join, Merge, sort, pivot, peek, Funnel, Filter, ODBC, DRS stages.
• Loaded reference table data from MS Access to ODBC DB and loaded excel files to tables through SQL Assistant. Setting up datastage users through administrator.
• Wrote UNIX shell scripts to run Datastage jobs, setup ETL Controls, archive files, ftp files and file validations.
• Actively participated in SWOT sessions with Business users to create complex test cases and fix the data using agile methodology.
• Coordinated with Release manager and DA to migrate the components from one environment to another environment.
• Worked for Production support to maintain the balance issues, data issues and job failures.
• Involved in performance tuning by rewriting the queries and modifying existing Datastage jobs.
• Facilitate unit, system and user acceptance tests and fix defects by debugging and finding the root cause of the defects in timely manner.
• Supported business users during User Acceptance Test (UAT) and Post Implementation Phase.
• Involved in production support for production cycle runs and ETL related issues.
• Communicated data availability with users and management.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.

Environment: IBM Datastage 8.5/8.1 Quality Stage, SOL-Server 2005/08, Windows XP, Virtual Machine, Lotus Notes, MS Access, MS Excel, Oracle SQL Developer, CAST SQL Builder, Erwin, Microsoft Visio.

Confidential, Chandler, AZ

Datastage Developer

Responsibilities:

• Understood the specification and requirement of the project and existing program and identified required solutions to perform data migration to extract data from CSV, Oracle, SAP, XML, SQL server, Teradata, DB2 into data-warehouse.
• Involved in several requirement discussions, weekly meetings with manager and business consultant for designing data-model and to make sure that work performed is according to the requirement.
• Developed complex server/Parallel jobs using Quality Stage to extract data from the SQL Server and migrating to Oracle database. Also involved in SDLC methodologies.
• Developed jobs to extract data from the initial source, complex dimension and fact tables which were loaded from an oracle database and migrating to an oracle datawarehouse using parallel extender.
• Wrote complex queries to select, update, insert, before/after subroutines and join the tables to perform tasks needed for SCD type 2 method required for the project.
• Extensively used Oracle-Oci stage, ODBC stage, sequential files, Hash Files, Transformer, sequence, email notify, Functions and Date conversions to data migrate effectively into the datawarehouse.
• Involved in writing several complex queries to extract, update and delete huge volume of data whenever there is change in the source and perform unit-testing on data.
• Identified unknown and known defects based on Quality Analysis which would be an impact for UAT.
• Involved in identifying and creating test case scenarios to check the efficiency of job and the data is not misread. Tuned the data stage jobs and PL/SQL queries to enhance performance and quality of jobs.
• Provided assistance to QA Team, in defining and Validating the test scenarios in my work area.
• Worked with UAT to tune the jobs and assisted production support team in identifying data issues.

Environment: Datastage 8.5/8.1 Quality Stage, PL/SQL, T-SQL, Teradeta, DB2, Oracle 11g, Toad, Clear-Quest, Clear-Case, Unix, Quality stage, metadata workbench..

Confidential, Hartford, CT

Datastage Developer

Responsibilities:

• Analyzed the various sources and designed and developed server/parallel jobs for extracting data from different databases such as SQL Server, IBM DB2 Mainframe, Teradata, Oracle, flat/CSV files and sequential files using Datastage Quality Stage..
• Interacted with business users, reporting analysts in gathering information about the business logic to populate the target tables and writing Teradata btq’s.
• Extensively used hash file stage, transformer stage, aggregator stage, link partitioner and link collector stages in transforming the source data migration into the target database.
• Developed user defined subroutines in BASIC to implement complex transformations, date conversions, code validations & calculations using different Data-Stage supplied functions, MQ plug-in, XML packages.
• Designed jobs using different parallel job stages such as join, merge, lookup, remove duplicates, filter, dataset, lookup file set, change data capture, switch, modify, aggregator.
• Involved in high performance tuning of both the Server and Parallel jobs. Extensively used DataStage Director's Job monitoring to perform the tuning of the jobs.
• Used DataStage Manager to move the jobs from development to system test, integration and performance test environments and Quality stage to cleanse the data.
• Provided technical support to the operational data source ETL team in solving some of the major issues in DataStage jobs development.
• DataStage best practices were formulated keeping in mind simplicity and higher performance and later incorporated into the jobs developed.
• Developed job sequences for the designed jobs using job activity, exec command, e-mail notification activities and triggers.
• Involved in unit testing, system testing, integration, reporting, and performance testing of the jobs.
• Produced extensive documentation for the designed jobs/sequencers for future referrals.

Environment: IBM Infosphere Datastage 7.5, Parallel Extender, Metadata workbench, quality stage, ERwin 4.1, BOXI reporting, Toad, SQL Server, Query Analyzer, Enterprise Manager, PL-SQL, Oracle 9i, SQL * Loader, IBM DB2, Linux, Windows, Business Objects, Control-M.

Confidential, Erie, PA

Data Warehousing Designer and Developer

Responsibilities:

• Analyzed the present data warehouse data model, based on the current data warehouse structure created jobs using DataStage designer to import data from heterogeneous sources like Oracle, Sybase, Flat files and SQL server to the data warehouse.
• Used DataStage Manager to import/export metadata, jobs, and routines from the repository.
• Validation, monitoring and scheduling of various DataStage jobs was done using DataStage Director. Was also involved in viewing and interpreting of the performance statistics.
• Used plug-in stages such as FTP, Merge and Pivot and also various stages like Sequential, Hashed, ODBC, Oracle OCI, Aggregator, Link Partitioner/Link Collector, and Inter-Process.
• Created Batches (DS job controls) and Sequencers to control set of DataStage jobs.
• Extensively used built-in DataStage transforms, functions and routines for conditioning, conversions, validation and loading, and also developed if required
• Extensively wrote user SQL coding for overriding the generated SQL query in DataStage.
• Designed mappings between sources to operational staging targets.
• Implemented logic for Slowly Changing Dimensions.
• Wrote UNIX Shell Scripts for file validation and scheduling DataStage jobs.
• Participated in the review of Technical, Business Transformation Requirements Document.

Environment: Ascential DataStage 7.0/6.0XE (Designer, Manager, Director), Parallel Extender MetaStage, ERwin 4.1, Oracle 9i, Autosys, Windows 2000 and UNIX AIX 4.1.