PROFESSIONAL SUMMARY:

• Around 8 years of experience in building Data Warehouse using IBM DataStage 8.5/8.1/8.0.1/7.5.2 (Data stage Enterprise Edition).
• Proficient in Software Life Cycle Development Methodology (SDLC)
• Strong experience in loading and maintaining Data Warehouses and Data Marts using DataStage ETL processes.
• Extensive exposure to Star, Snowflake Schema and Multidimensional Data Models.
• Experience in Extraction, cleansing, integration, loading of data from/to disparate data sources.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using DataStage, UNIX shell scripting and SQL Loader.
• Worked with XML input, XML output and XML transformer.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables and star schema modeling.
• Experience in Teradata utilities in like Fast Load, MultiLoad and Fast Export, query tools BTEQ and SQL Assistant, Teradata SQL, Explain Plan, bulk loaders and un - loaders.
• Excellent experience in extracting data from Teradata, DB2, and Oracle and loading into an EDW.
• Assisting the data modeler/data warehouse developer in reviewing staging, data warehouse and data mart models for completeness and the ability to load.
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
• Involved in Requirements Gathering, Logical design model & physical design model meetings to understand the data flow, frequency of data loads into EDW and create S2T Mapping documents and visio diagrams.
• Extensive experience in loading high volume data, and performance tuning.
• Involved in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
• Good interpersonal skills, experience in handling communication and interactions between different teams.

TECHNICAL SKILLS:

Data Warehousing/ETL: IBM Data Stage 8.5,8.1.1, 8.1, 8.0.1 /7.5.1, Quality Stage 8.1

Databases: Teradata, Oracle 9i/10g, SQL server 2008 and Db2

Business Intelligence: Business objects 5.x, Micro Strategy

Languages: SQL, PL/SQL, C

Operating Systems: Windows NT & 2000, HP-UX, AIX and Linux

Database Tools: SQL Plus, SQL Loader, Teradata SQL assistance

Data Modeling Tools: Erwin 4.1

PROFESSIONAL EXPERIENCE:

Confidential, Bothell, WA

DataStage Senior Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Developed the datastage jobs that include Extract, Transformation and loading of customer data using Sequential file, Transformer, Aggregate, Sort, Join, Lookup, CFF, Remove Duplicates, Copy, Funnel, Dataset, Hashed File, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding
• Created Error files and Log Tables containing data with discrepancies to analyze and re-process data
• Used IBM Clearcase to checkin the code and create packages for migration of code to different environments by creating versions as part of migration release.
• Created migration documents for job migration among the repositories and run books for data execution process.
• Extensively used the Sequential File Stage, Dataset Stage, File set Stage, Modify Stage, Look-up, transformation and other Database plug-ins and the stage provided by the DataStage to perform transformation and load the data.
• Taking the backup of jobs developed using DataStage import/export utility
• Used Peek stage for debugging the parallel jobs.
• Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic to Slowly Changing Dimensions.
• Designed a job template that provides the Environmental parameters for the subsequent use in the projects.
• Extensively worked with DataStage Job Sequences to Control and Execute DataStage Jobs and Job Sequences using various Activities and Triggers.
• Extensively used Microsoft Visio for documentation and control m to schedule the jobs.
• Worked with Business users to fix defects and implemented the best practices for conducting best UNIT TESTING and INTEGRATION TESTING and documenting the test results for User Acceptance.
• Created UNIX shell scripts to extract specific columns needed for business from the raw files.

Environment: IBM Information Server 8.5(DataStage), IBM Clearcase, Oracle, UNIX.

Confidential

DataStage Developer

Responsibilities:

• Participate in all stages of the development life cycle including requirement analysis, design, development and implementation of the system.
• Developed Schema files, one per source type to extract and load the data.
• Troubleshooting and stabilizing the System by analyzing the data and the ETL Code, also minor enhancements/fixes.
• Extracted data from various file or DB based source systems into EDI staging Teradata database using Runtime column Propagation (RCP) method.
• Wrote the batch codes in batch files to run the jobs in sequence.
• Wrote UNIX shell scripts to create SFTP files and also coded UNIX shell scripts to perform integration between source and the target data bases.
• Job redesign to handle huge volumes of data.
• Used CDC (Change Data Capture) in data integration to identify changes in enterprise data sources.
• Wrote DDL Scripts for Creating And Altering Tables.
• Developed DataStage Job sequence used the User activity variables; job Activity, File Stages, Execute command, Loop Activity, Terminate.
• Mapping of business requirements to transformation rules, design, code, test cases, & test results by Preparing and maintaining Requirements Traceability Matrix
• Experienced with the server jobs and hash file to make look ups in the transformer stage.

Environment: IBM Data Stage (Server Edition), Oracle 9i, MS Access, UNIX, PL/SQL

Confidential, Richmond, VA

DataStage Developer

Responsibilities:

• Involved with the end users / business analysts to collect the requirements of the project.
• Preparation of technical specification for the development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data Marts and defining ETL standards..
• Experienced with DataStage Parallel Extender for partitioning the data into subsets and load balancing across all available processors to achieve job performance.
• Extensively used Data Set, File Set, CFF, Lookup File Set, Transformer, Sort, Join, Merge, Lookup, Funnel, Copy, and Modify stages.
• Used Data stage Transformation Extender for complex transactions and messages.
• Created Fast load, Fast export, Multiload, Tpump, BTeq Scripts where required to load and transform data from various sources to target D.W.H.
• Extensively used Dataset management utility - viewing, copying, and deleting data.
• Exposure to Orchestrate - OSH scripts, Operators.
• Used DataStage Manager to import the metadata / schema definitions into various jobs.
• Worked on the cleanup, fixes and loading of metadata into the Warehouse.
• Created job sequences to handle the load dependency.
• Used Director to run, monitor and schedule the jobs.
• Extensively wrote user SQL coding for overriding generated SQL query in DataStage.
• Extensively involved in Quality Stage (Integrity Stage) for quality checking and error detection process.
• Developed various PL/SQL stored procedures to enhance reusability during data validation and to perform unit testing.
• Created and documented various Data Quality Scripts to perform system integrated testing and user acceptance testing.
• Created lots of PL/SQL scripts to tune and optimize the database performance.
• Extensively worked with SQL Loader to load the flat files into various Oracle tables.
• Used SQL Navigator to query the DW tables and validate the data.
• Extensively used Erwin to import and export the data model definition of business.

Environment: Ascetical DataStage 8.1/8.0, Parallel Extender/Enterprise Edition, SQL, PL/SQL, Teradata, Quality Stage 7.5, Tool utilities(BTeq, Fast Export, Multiload, Fast load, Tpump), TOAD 7.5, SQL Navigator, MS Excel, Windows XP, Erwin 4.2, Zena..

Confidential

ETL Developer

Responsibilities:

• Developed healthcare system making using Data Marts.
• Extracted the data stored in different databases and loaded into Oracle system.
• Involved in the creation of jobs using DataStage designer and used Director to validate, schedule, run and monitor the DataStage jobs.
• Involved in designing the procedures for getting the data from all system to Data Warehousing system.
• Information stored in table definition and is entered using DataStage manager.
• Extensively used ETL Tool to load data from DB2 to Oracle Database.
• Exporting the universe to the repository to make resources available to the users.
• Created the reports using the universes as the main Data providers and writing the complex queries including sub queries, unions, joins, intersects and aliases.
• Extensive use of slice and dice for generating master/detail and tabular reports.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL

Environment: Ascential DataStage 7.5.1, Oracle 8i/9i, SQL, PL/SQL, Windows NT, UNIX

Confidential

Intern

Responsibilities:

• Created DataStage jobs to extract data from various sources, transformed data according to the requirement and load into data warehouse.
• Involved in implementing star schema for the data warehouse using Erwin for Logical/Physical data modeling and Dimensional Data Modeling.
• Extensively used Ascential DataStage Manager, Designer, and Director for creating and implementing jobs.
• Used parallel extender for splitting the data into subsets and to load data, utilizing all available processors to achieve job performance.
• Developed UNIX shell scripts to automate the Data Load processes to the target Data warehouse.
• Wrote custom routines for cleaning data before loading data into target database.
• Wrote technical documentation and data processing documentation for backend systems

Environment: Ascential DataStage 7.5.1, DB2, Oracle 9i, Erwin 3.5.2.