SUMMARY:

• 7 years of IT experience as a Datastage Developer in ETL Design, Development, Programming, Testing, Performance Tuning, Implementation and Troubleshooting and Error Handling in the field of Data Warehousing and Application Development.
• Strong Data Warehousing experience, apply expertise in ETL Tool Datastage, Experienced in Microsoft Office for diverse administrative tasks. Expertise with Microsoft Word, Excel, PowerPoint, and Adobe Photoshop. Understand process of transforming advancements in technology and business systems from vision to products and services.
• Translate technical information into user - friendly language; forge productive relationships across employee levels and departments. Adept in communicating with diverse groups and personalities. Serve as primary point of contact for customers and exceed client expectations for service and support.
• Expertise in data and logical modeling of the data.
• Involved in troubleshooting, Performance tuning and Performance monitoring.
• Excellent in Documentation, End-User and Knowledge Transfer
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Experience in converting business requirements into a feasible technical solution.
• Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
• Client-focused and professional to serve as key company representative. Demonstrate exceptional productivity and efficiency. Self-starter, excelling in fast-paced business environments. Organized and accurate, with critical time management skills; consistently exceed expectations. Strong communication and decision making skills.
• Technologically savvy and highly motivated with a business management degree and leveraging computer strengths complemented by solid business and database to excel in today’s market.
• Highly organized, detail-oriented professional with strong business and technical skills.
• Played significant role in various phases of project life cycle, such as requirements gathering, functional & technical design, testing, Production Support and implementation.
• Excellent team member with problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.

TECHNICAL SKILLS:

ETL/Middleware Tools: IBM Information Server/ Datastage9.1, 8.5, 8.1, 8.0 & 7.5, Oracle PL/SQL

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimension tables, Physical and Logical Data Modeling.

RDBMS: Oracle 10g/9i, MS SQL Server 2000, MS Access.

Programming Skills: SQL, PL/SQL, HTML, DHTML, XMLModeling Tool: SQL Navigator, MS Visual Studio, WinSQL, SQL DeveloperOperating Systems: Windows XP and 7

PROFESSIONAL EXPERIENCE:

Confidential - Southfield, MI

Datastage Developer

Responsibilities:

• Involved in meetings with the users to gather and analyze the requirements.
• Worked closely with the Data analyst and business analyst during the design and development of ETL technical specification document.
• Used DataStage as an ETL to extract data from sources like flat files and DB2 and loaded to target DB2 UDB.
• Extensively used parallel stages like Aggregator, Sort, Column Generator, Join, Merge, Head and peek for development and de-bugging purposes.
• Developed jobs to standardize and improving error handling.
• Fixing various bugs in the applications by changing the design after analysis.
• Understanding the business rules and changing the application for performance and stability and adhering to business rules.
• Gathering the metadata definition of the source systems, preparing Transformation rules according to the business requirements for new enhancements.
• Good experience in working as coordinator to offshore team from Onshore under ETL, DataStage, environment.
• Created reusable components like parameter sets.
• Involved in the performance tuning during historical & Daily loads and reduced the batch window and also in making the application Robust.
• Experience in deploying new applications into the production environment.
• Good experience in creating various reusable jobs as part of enhancements, data requests and production fixes.
• Experience in handling teams at both onshore and offshore.
• Experience in handling Transition activities of the new applications from development team to support team.
• Involved in importing and exporting jobs category wise and maintaining the backup regularly.

Environment: DataStage 8.5/8.1 (Parallel Extender EE), Oracle 10g, Mainframes, SQL, PL/SQL, SQL*Loader, Windows XP/7.

Confidential, Columbus, OH

DataStage Developer

Responsibilities:

• Design, develop, test, implement and support of Data Warehousing Applications using Business Objects Data Services.
• Prepare high level design document, detail design document, system requirement document, technical specifications, table level specs and test plan documents.
• Extract data from legacy systems to staging area and then cleanse, homogenize, process and load into the data warehouse.
• Research, analyze and prepare conceptual, logical and physical data models for the new applications and optimize the data structures to enhance data load times and end-user data access response times.
• Create processes to ensure the data quality of the information collected.
• Worked with Data Modeler to design the dimension tables and fact tables of the target data ware house
• Designed the mappings between sources external files and databases such as Oracle, SQL Server, DB2, Flat files and XML files to Operational staging targets.
• Designed and Developed ETL jobs using Datastage tool to load the transformed data into the respective data warehouse and Data Marts.
• Used Datastage designer for importing metadata from repository, new job categories and creating new data elements.
• Developed/Enhanced ETL Processes to load the data from different source systems including Oracle, SQL Server, Flat files into warehouse system using DataStage.
• Developed complex mappings in DataStage to load the data from various sources using different transformations like Join, Merge, Lookup, Change Capture, Remove Duplicates, Funnel, Filter, Copy, Peek, Pivot, Aggregator, Modify, and Transformer Stages.
• Created error handling and reject file process to capture rejects for data analysis and data re-process.
• Created reusable components like parameter sets.
• Involved in the performance tuning during historical & Daily loads and reduced the batch window and also in making the application Robust.
• Created various scripts to automate the batch processing of many applications which are processed manually.

Environment: IBM-InfoSphere Datastage 7.5, 8.1, Oracle SQL Developer, Secure FTP

Confidential - NJ

Datastage Developer

Responsibilities:

• Designed and Developed ETL jobs according to business requirements using Datastage tool to load data warehouse and Data Mart.
• Used Datastage designer for importing metadata from repository, new job categories and creating new data elements.
• Used the Data Stage Director and its run-time engine to schedule, run the solution, test and debug its components, and monitor ETL Jobs.
• Involved in Designing Parallel Jobs andcreating jobs for Error validations.
• Integrated data from different sources using Join, Merge and Lookup stages.
• Created Log Tables containing data with discrepancies to analyze and reprocess
• Performance tuned the ETL jobs for better performance.
• Extensively used processing stages like Join, Merge, Funnel, Filter, Aggregator, Sort, Transformer, Lookup, File Set, Data Set, XML, Complex Flat File and Sequential File
• Extensively worked on Surrogate key Generator to generate Warehouse key before loading data into Warehouse.
• Using Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
• Developed error handling process to collect rejects for data analysis.
• Worked on Optimizing and Performance tuning on targets, sources and mappings to increase the efficiency of the process.
• Stored procedures using PL/SQL statements for extracting as well as writing data.
• Extensively used Datasatage Director to execute, monitor execution status and log view, also used in scheduling jobs and batches.

Environment: IBM WebSphere Enterprise DataStage 8.0/7.5.2, Oracle, MS SQL Server 2005, PL/SQL,Windows XP.

Confidential - PA

DataStage Developer

Responsibilities:

• Used DataStage manager to import, create and edit the metadata.
• Used the DataStage Administrator to assign privileges to users or users groups, move, rename or delete projects and manager or publish jobs from development to production status.
• Validated all applications and ran the jobs using DataStage Director.
• Worked on Data migration from SQL Server and was responsible developing Data Stage Jobs, creating mapping for data transformation, extracting data from Oracle and Loading it into the Dimensional tables.
• Backups by using Data Stage Manager Exporting data stage components and packaging of projects.
• Implemented the Surrogate Key by using Key Management functionality for newly inserted rows in Data Warehouse
• Used Autosys to schedule the Datastage ETL batch jobs on daily, weekly and monthly basis.
• Performed tuning of the repository and jobs for optimum performance.
• Prepared Test Plan and performed Unit Testing, System, Integration, Volume Testing.
• Extensively involved in writing Stored Procedures and calling the same through Data Stage Stored Procedure Transformation.
• Involved in extracting the data from different data sources like Oracle, DB2, several other databases and flat files.
• Developed parallel jobs, server jobs using different stages, which includes Aggregator, Join, Transformer, Sort, Filter and Lookup etc.,
• Used the DataStage Director and Manager to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions.
• Written functions, transforms, before and after job routines using DataStage basic.

Environment: DataStage EE 7.5/8.0, SQLServer 2005, Oracle10g/9i, Win XP

Confidential - VA

Datastage Developer

Responsibilities:

• Design DataStage sequences to specify Job execution order.
• Redesigned few jobs in Datastage Designer to meet the changes in new incoming feeds.
• Coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
• Design of Logical and Physical Data Models and developed the STAR Schema models
• Multi source Extraction Transformation and loading into the Repository using Data Stage.
• Developed various Data extractions, Transformations rules based on Business requirements.
• Designed ETL jobs to identify and remove duplicate rows using remove duplicate stage.
• Code review of several mappings which could have a performance impact.
• Created and modified all the jobs and shell scripts with new email Id’s and groups for abort and failure notifications.
• Involved in unit, system and end-to-end testing of the design.
• Actively involved in everyday job monitoring and resolved all the issues which are related to job aborts and job failures.
• Worked on call for production support.
• Assist in planning and installing datastage upgrades and project implementation.
• Ensure that the system continues to perform to maximum efficiency after the go-live and on an on-going with minimum disruption.

Environment: IBM-InfoSphere Datastage 7.5, Oracle, Windows XP, MS Word, Excel