SUMMARY:

• 8+ years of experience in Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehousing and Client/Server applications.
• Experience in ETL Tool IBM Information Server 8.5, 8.1, 8.0.1 and Ascential DataStage 7.X.
• Experience in integration of various data sources like Oracle, DB2, Teradata, SQL Server, XML and Flat files into the Staging Area using Datastage Designer.
• Designed, tested and migrated DataStage jobs from Development Systemto Test System and then to Production System for Operational Data Store and Data Warehouse.
• Experience in dimensional data modeling, star schema modeling, snowflake modeling, fact and dimensional table design, physical and logical data modeling.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture)
• Analysis of high - level design specifications into simple ETL coding and mapping standards.
• Worked onUNIX ShellScripts for file deletion, Automation, job run, file processing, Initial Load, batch loads, Cleanup, Job scheduling and Reports.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.
• Experience in Extracting data from Flat files, Unix Flat Files and Complex Flat Files.
• Programming experience using SQL, PL/SQL, Oracle, and Unix Shell Scripting.
• Worked on transforming text data to XML data using XML packages.
• Extensive experience in loading high volume data, and performance tuning
• Good exposure to development, testing, debugging, implementation, documentation, and production support.
• Worked closely with Business Analyst to understand business rules and developed Datastage Jobs.
• Developed professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts.
• Excellent interpersonal and communication skills, and in working with senior level managers, business people and developers across multiple disciplines.

TECHNICALSKILLS:

ETL Tools: IBM Web sphere DataStage 8.5,8.0.1/8.0, 7.5/7.1/6.0/5.2/5.1, IBM Business Glossary

Databases: Oracle 10g/9i/8i/8.x, MS SQL Server 7.0/6.5, DB2 UDB, MS Access 7.0, Teradata, ODBC, Sybase

Databases Tools: IBM Data Studio,SQL* Plus 9.2, SQL Loader 9.2, SQL Navigator 4.1, TOAD 7.5, DB2 Import, DB2 Export

Prog. Languages: SQL,PL/SQL, Shell scripting, C, C++, Java, VB 5.0

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

DataStage Developer

Responsibilities:

• Involved in Design, Development and unit testing of DataStage jobs and migrating the code from one environment to the other.
• Developed ETL jobs in DataStage using various stages like Complex Flat File Stage,Join, Transformer, Filter, Copy, Change Data Capture, Change Data Apply etc.
• 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, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Used UNIX Shell Scripts for scheduling the jobs.
• Performed Unit Testing for all the ETL jobs and involved in mocking of the data where ever necessary.
• Done Partitioning Rules for Hash, Same, Round Robin, Range, Random, Modulus
• Created and generated reports, comparisons using Excel for user level purpose.
• Proper Null handling for CDC columns in CARI CDC jobs and revert them back to Nulls before loading.
• Read Cobol Copy Books From Mainframe to ETL DataStage.
• Imported Header, Trailer and Detailer Formats into the Table Definitions.

Environment: IBM DataStage 8.5, IBM Buisness Glossary, DB2, COBOL COPY BOOK,UNIX Shell Scripts, PL/SQL,Windows XP

Confidential, Richardson, TX

DataStage Developer

Role & Responsibilities:

• Coordinated with Master Data team in creating design standards and technical specifications for DataStage jobs.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Extracted data from Flat files/Relational and loaded into Data Warehouse built on Teradata.
• Hands on experience with Repository and Metadata.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• 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)
• Implemented multi-node declaration using configuration files for performance enhancement.
• Used the Data Stage Director to schedule running the solution, testing and debugging its components & monitor the resulting executable versions.
• Performed job troubleshooting using job log (using environment variables) and DataStage Debug stages.

Environment: IBM WebsphereDataStage 7.5.2/8.0.1, Oracle 10g, Teradata, Flat Files, IBM AIX, Windows XP.

Confidential, Bentonville, AR

Datastage Consultant

Role & Responsibilities:

• Designed & Developed jobs according to business requirements
• Designed the ETL process to Extract translates and load data from various sources to Teradata data warehouse.
• Designed the jobs based on the understanding the data model table relationship.
• Enhanced the Job Performance by using proper partitioning methods, analyzed job and system resource utilization.
• Extensively worked on Data Acquisition and Data Integration, Transforms, Loading and Analysis
• Developed Job sequencers for executing DataStage jobs
• Worked extensively on different types of stages like Sequential file, Hashed File, Aggregator, ORA Bulk, Transformer, Merge, Join, Lookup, Sort and Containers (Server, Parallel) for developing job.
• Developed jobs in Parallel Extender using different stages like Join, Transformer, External filter, Row generator, Column generator, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup File Set, Change Data Capture, Modify, and Aggregator
• Worked on Quality Stage with various stages such as Transfer Stage, Select Stage, Sort Stage, Build Stage and Unit join Stage for addressing standardization, match passing, country wide segregation of data.
• Loading and Validating Data from flat files to Teradata Tables
• Performed tuning and optimization of complex SQL queries using Teradata.
• Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.
• Created job sequences and job schedules to automate the ETL process. Enhanced the job properties for performance tuning.
• Designed and developed several extract programs to send files to third party vendors using XML.
• Used UNIX Shell Scripts for scheduling the jobs.
• Designed documents for maintaining best practices of DataStage

Environment: AscentialDataStage 7.5, IBM DataStage 8.1, Teradata 12.0, Teradata SQL Developer, UNIX, Shell Scripts, Windows XP

Confidential, Newport, CA

DataStage/QualityStage Developer

Role & Responsibilities:

• Extensively used DataStage as the data migration/transformation tool for Corporate Data Warehouse application.
• Gathered requirements from business and created source to target mapping sheets and modified existing data modeling.
• Designed the logical and physical data warehouse schema. Analyzed source systems and creating a mapping to the target database schema.
• Extracted data from Teradata, applied Transformations and loaded in to Oracle Database.
• Involved in Design, Development and unit testing of DataStage jobs and migrating the code from one environment to the other.
• Extensively worked with Parallel Extender using Parallel Processing.
• Worked on QualityStage for a Project and performed standardization, Match Frequency and Unduplicate for datastage jobs.
• Involved in modifying existing DataStage Jobs for better performance.
• Extensively used DataStage Designer to design and develop Server and PX jobs to migrate data from transactional system (Oracle 9i) into the Data Warehouse.
• Worked closely with Business Analysts to understand business rules and developed Prototype jobs.
• Created many parallel jobs and parameterized the jobs for optimization.
• Extensively developed Server/PX Shared Containers for Reusability.
• Extensively used DataStage Manager to Export/Import DataStage Job components and Import Plug in Table Definitions from Oracle database.
• Created Unix Shell Scripts as wrappers to automate the process of running DataStage jobs and to track DataStage Job logs and Script logs.
• Redesigned many existing ETL jobs (SQL scripts, Shell Scripts) in DataStage as per the Framework approach.
• Provided Support to various groups to design and develop ETL job flow using DataStage and Shell Scripts.
• Worked closely with Data Analysts to make sure the data is accurate and consistent for table loads.
• Migration from 7.5 to 8.5 Environment.

Envirobt: Data Stage 7.5, Infosphere Information server 8.0.1, UNIX, Erwin, Oracle 9i, Teradata V2R6, SQL, SQL* Loader,SQL Server 2005.

Confidential, Minneapolis, MN

Datastage Developer

Role & Responsibilities:

• Worked extensively with business analysis team in requirements gathering.
• Converted Functional specifications to Technical specifications.
• Documented the Functional and ETL specification using Microsoft VISIO, Word, Excel, PowerPoint and Erwin Data modeler. Demonstrated the ETL specification documentation to Business Analyst. Analysis of Source and target systems. Performed thorough analysis of source and target systems to identify the data granularity.
• Developed ETL jobs in Datastage using various stages like Join, Transformer, Filter, Copy, Change Data Capture, Change Data Apply etc.
• Used Different Partitioning methods in parallel job (Auto, Round-Robin, Hash, and Entire) to improve the performance and to get the accurate results according to the business requirements using Parallel Extender.
• Used lookup stage with reference to Netezza table for insert/update strategy and for updating slowly changing dimensions.
• Worked on QUALITY STAGE for the Name standardization using the INVESTIGATE STAGE, Standardization stage.
• Implemented best practices in designing the DataStage jobs for better performance and also fine-tuned the database SQL queries.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Tuning of SQL queries in SQL overrides for better performance.
• Created Source to target Mapping Matrix in loading the data to Dimensions and Fact Tables using Informatica.
• Designed procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Responsible for physical design modifications of enterprise data warehouse - Managed Care and DSS Universe using Business Objects Designer 6.5.
• Reconciliation of data from scratch i.e., from source to target. Maintaining the flow and writing SQL queries and finding the mismatches in the data manually. Like UNIT testing.
• Developed various reports in Business Objects that have drill down capabilities.
• Also used BCP batch files for moving data from one database server to other database server.
• Created and generated reports, comparisons using EXCEL for user level purpose.
• Written UNIX and PERL Scripts for event automation.
• Assisted the other team developers to understand the model and enhanced the existing models.

Environment: Enterprise DataStage 8.0,Datastage 7.5.2, Datastage Parallel Extender 8.5, BO XIR2, ORACLE 10g, UNIX AIX, XML,Autosys, Erwin 7.0,Windows NT 4.0, PL/SQL, TOAD for Oracle 9.1.2., MS excel.

Confidential

ETL Developer (contract with L&T InfoTech)

Role & Responsibilities:

• Analyzed and validating the form of data which are available in the existing systems.
• Extracted the data from various systems by designing ETL jobs and populated the data to the target databases.
• Implemented SCD Type-1 and SCD Type-2 while loading the data into the target databases.
• Created Sequence jobs for each set of tasks and tested all the jobs and checked the improvement of the performance from the existing system.
• Used Lookup, Sort, Merge, Funnel, Filter, Transformer stages.
• Used Transformer stages with stage variables to map data create expressions and constraints to match the business transformations.
• Created user defined SQL queries based on requirements.
• Used job sequencer and job parameterization.

Environment: DataStage 6.0, Oracle 9i, Windows Server 2003, MS Office Tools.