SUMMARY

• Over 6years of experience in System Analysis, Design, Development in the fields of Data warehouse and Data Mart applications and Developing Client/Server applications using IBM Information Server 8.x DataStage, Oracle, PL/SQL, SQL Server, DB2, TOAD, Erwin, VISIO and Shell Scripts.
• Extensive experience in Data warehousing tools IBM Information server 8.1/8.5(Designer, Director and Administrator) and Ascential DataStage 8.1/8.5 (Designer, Director and Administrator), Infosphere Qualitystage 8.1/8.5 and Data Modeling Tools.
• Extensive experience with Oracle, DB2, MS SQL Server, Netezza and Teradata databases.
• Extensive experience working with Oracle 8i/9i/10g/11g including PL/SQL programming.
• Experience with DataStage Administration activities.
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, Fact and Dimension Tables.
• Extracted data from heterogeneous sources like SQL server, Oracle, DB2,.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts using Ascential DataStage (Designer, Director and Manager).
• Strong skills in Master Data Management ( MDM ) like data collection and data transformation
• Experience inDatastage Administrator to create/modify/delete projects, and cleanup projects and implemented security amongDatastage users and projects
• Experienced in troubleshootingdatastagejobs, enhancement of jobs and addressing production issues like performance tuning and enhancement.
• Worked extensively with different processing stages of Datastage like Filter, Sort, Aggregator, Copy, Transformer, Funnel, Join, XML stage, Look Up, Merge, Pivot, Modify, Switch.
• Experience in Data warehousing and Data migration.
• Experience in Shell Scripting (Korn Shell).
• Experienced in using highly scalable parallel processing Infrastructure using Data Stage Parallel Extender (DS - PX).
• Extensively worked co-coordinating with offshore team distributing the work, keep tracking development status and monitor day to day activities.
• Developed and executed Data Stage jobs including Job execution status, monitoring a job, job log view, job scheduling, creating batches and scheduling batches.
• Excellent knowledge in Extraction, Cleansing and Modification of data from/to various Data Sources like Flat Files, Sequential files, Comma Delimited files (.csv), XML and Databases like Oracle, ODBC, DB2, Teradata
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications.
• In Depth knowledge in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon) addressing Slowly Changing Dimensions (SCDs)
• Experience in integration of various data source like Oracle, SQL Server and DB2.
• Experience with Conceptual, Logical and Physical data modeling.

TECHNICAL SKILLS

ETL Tools: Ascential DataStage 8.x, IBM WebSphere DataStage and Infosphere -QualityStage 8.1, 8.5, 8.7, and 9.1, 11.3v.

Operating Systems: Windows 98/2000/XP, NT 4.0, LINUX/UNIX (HP, Sun Solaris 7/8, AIX, Humming bird, PERL).

Databases: DB2 8.2, DB2UDB, Oracle 10i/9.x/8i/8.0/7i, SQL Server 7.0/2000, TeradataInformix and MS-Access, Netezza, MDM, Teradata.

Languages: C, C++, C#, PL/SQL, SQL, UNIX shell programming, HTML and Visual Basic 5.0/6.0

Database Tools: Teradata version 13, SQL Plus, SQL Loader, Import, TOAD, Export, Quest SQL Navigator 4.3, SQL Programmer, PL/SQL Developer, Teradata Sql Assistant

PROFESSIONAL EXPERIENCE

Confidential, Kansas City MO

Data stage Developer

Responsibilities:

• Analyze, design, develop, implement and maintain moderate to complex initial load and Incremental load jobs to provide data to ODS.
• Extensively created parameters in job properties for entering default values while loading.
• Worked with Data stage client tools - Designer, Director, Manager and Administrator
• Involved in several optimizations on Datastagejobs and improved the performance.
• Developed jobs in data stage, using different stages like Transformer, Aggregator, Lookup, Merge, Join, Remove Duplicate, Funnel, Sort, Change Data Capture, Sequential File, Complex Flat file and ODBC.
• Created jobs and sequences to extract allowances, benefits, brokers, claims, members, providers and employee group data with applying various business rules.
• Analyzed data issues in the load and providing the solution for the issues, discussing with the data owners and creating DS jobs to correct the data.
• DesignedDatastageETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the data marts.
• Created re-usable components using shared containers for local use or shared use.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Created various parallel jobs for automating the entire process of loading the data.
• Interacted with business intelligence team to Design various reports using Business Objects (BO) reporting tool.

Environment: IBM Infosphere Data Stage 11.3, Oracle 11g/10g, PL/SQL developer, Business Objects, Autosys, SQL Navigator, Complex Flat files, XML files, SQL, PL/SQL, Shell scripts, UNIX, Windows XP.

Confidential, Greensboro, NC

Data stage Developer

Responsibilities:

• Design and developETLmappings to extract, clean and load the data feeds.
• Analyze business requirements and translate into ETL data rules.
• Assist in data analysis and metadata management.
• Effectively operate within a team of technical and business professionals.
• Performance tuning of ETL jobs.
• Focus on data quality.
• Maintain existing Datastage jobs in the data warehouse environment.
• Follow environment standards for design, development, and documentation processes.
• Complete the end-to-end design and development of processes needed to extract, transform, and load data from the core warehouse to refined warehouse (Data Marts).
• Creating the scheduling plan job execution timings and sharing it with scheduling team (control M).
• Schedule, plan and conduct meetings with business analysts, data base administrators, data stage administrators, data architects, project managers and other technical or business professionals. Communicate plans and designs and solicit feedback and gather signoff of planned ETL processes.
• Modify the design of DataStage jobs to allow for smooth transition from development through integration testing and production.
• DevelopedUnix scripts to run the Datastage job and other file validations.
• Created Unix Shell scripts to automate the data load processes to the target Data Warehouse.
• Used QualityStage stages such as investigate, standardize, match and survive for data quality and data Profiling issues during the designing
• Involved in documenting the Frame Work Templates and the process of developing jobs using Templates.
• Extended data profiling capabilities and provided foundation for data governance initiatives using IBM Information analyzer and job maintainability.
• Data from the datastage is passed to the D3 documents using in text/xml/json format.
• Data profiling is done on various source systems to identify and accommodate the required data from these various source systems into the EDW
• Experienced in Data Modeling as well as reverse engineering using tools Erwin, Oracle Designerand MS Visio, SQL server management studio and store procedures
• Write data mapping documentation for reporting components and document flows where appropriate.
• Provide estimates for the ETL projects including testing, documentation, and implementation.
• Prepare knowledge transfer documents and provide staff training in DataStage project deployment, application scripts and run documents.
• For Effective Standardization manually defined rule sets.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
• Extensively designed, developed and implemented Parallel Extender jobs using Parallel Processing (Pipeline and partition) techniques to improve job performance while working with bulk data sources.

Environment: IBM Infosphere 8.1, IBM Information Analyzer, Oracle 10g,PL/SQL, SQL Server, Autosys, Toad, Cognos, Microsoft Visual Studio 2012,, Quality Center and Teradata SQL Assistant.

Confidential

Datastage Developer

Responsibilities:

• Worked with business customers for requirements gathering, building Logical and physical data models.
• Worked with architects and subject-matter experts to design comprehensive ETL solutions.
• Used DatastageDirector and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Involved in Defining Best ETL practice doc, Development standards doc for DataStage ETL Jobs.
• Created ETL process flows, Design spec documents, Unit test cases for DataStage ETL jobs.
• Created Project Level Parameter Sets and Reusable components like Shared Containers.
• Used various Parallel Stages like Lookup, CDC, Merge, Join, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer, Row Generator, Column Generator Stages etc extensively.
• Monitor jobs for performance issues and troubleshooting.
• Extensively used complex file stage to process complex format source files to convert data from legacy sources
• Provide performance tuning insight to project teams.
• Developed DS Routines for extract job parameters from files and developed DS routines for job Auditing.
• Involved in creating AutoSys for Scheduling the Job dependencies and Timings.
• Used DataStage Director to monitor, analyze and debug DataStage jobs.
• Modified UNIX shells according to the latest business requirement.
• Unit tested Datastage Jobs in development including creating the appropriate test data.
• Experience in generating and interpreting mapping documentation, and translating into detailed design specifications using ETL code.
• Designed DataStage sequences to specify Job execution order.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.

Environment: Ascential DataStage 8.1/8.5, TOAD, Oracle 10g/11g, SQL, PLSQL, SQL Loader, Shell Scripts, AutoSys, HP UNIX, Windows XP.