SUMMARY

• Over 8+ years of dynamic career reflecting pioneering experience in the field of Information Technology as a DataStage/ETL Developer in Data Warehousing technologies, with strong understanding in all phases of SDLC involving Requirement gathering, Business analysis, Application Design, Data Modeling, Development, Testing and Maintenances and Documentation.
• Experience in verticals - Education, Finance (Bank, Investment) and Insurance (life, Auto).
• Experience in different version of IBM InfoSphere Information Server Data Stage 8.5/8.1 and Quality Stage.
• Expertise in Data Requirement Analysis, Design, Development of ETL process using IBM DataStage 8.5/8.1/7.x/6.x(InfoSphere Information Server, Web Sphere, Ascential DataStage) DataStage Designer, DataStage Director, DataStage Administrator, Parallel Extender (PX)/Orchestrate.
• Expertise in cleansing the data using IBM QualityStage 7.5.2/7
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources such as DB2-UDB, SQL Server, Sybase, Oracle, Teradata, XML, MS-Access and Sequential files.
• Efficient in Analyzing, Designing, Developing, and maintaining highly complex ETL processes.
• Excellent knowledge of Server jobs, Parallel jobs, Job sequences, Containers, SQL, PL/SQL, Stored Procedures and Triggers, debugging, troubleshooting and performance tuning.
• Proficient in DataStage BASIC Language for the development of user-defined Routines and Transformations.
• Extensively contributed in the areas of Dimensional modeling (Star Schema and Snowflake Schema).
• Excellent knowledge of studying the data dependencies using Metadata stored in the DataStage Repository.
• Developed complex UNIX Shell Scripts for automation of ETL processes and Data transfer needs.
• Proven track record in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
• Expert in unit testing, system integration testing, implementation and maintenance of DataStage jobs.
• Excellent experience in elevating successful code to production.
• Highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS

• IBM Info Sphere Information Server (DataStage and QualityStage
• Information Analyzer
• Metadata Workbench) 8.7 8.5
• Ascential DataStage Enterprise and DataStage 8.5/8.1/7.5/7/6. x(Designer
• Manager
• Director and Administrator)
• Ascential QualityStage 7.5.2/7
• Business Objects
• Erwin
• Oracle 11g/10g/9i/8i
• DB2 UDB 7.1/8.1
• SQL Server 2000 2005
• MS Access
• TeraDataV2R5
• Netezza
• Sybase
• SQL
• PL/SQL
• Visual Basic 6.0/5.0
• HTML
• C
• C++
• UNIX Shell Scripting
• Solaris 2.x./8
• Linux 7.1/7.2/8
• IBM-AIX
• HP UX
• SCO-UNIX
• Windows 2000 Server/Advanced Server
• Windows 95/98/2000/XP
• OS/390
• WinNT4.0
• MSDOS6.22
• TOAD 7.x/8.x for Oracle
• Cute Ftp
• Smart Ftp
• Telnet
• Microsoft Visio
• Autosys.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Data stage Developer

Responsibilities:

• Designed and developed jobs for extracting, transforming, integrating, and loading data into data mart using Data Stage Designer.
• Developed, executed and monitored the ETL Data Stage jobs in the Data Stage designer and Director Components.
• Worked with Data Stage Director to schedule, monitor, analyze performance of individual stages and run multiple instances of a job.
• Responsible for developing, validating, and communicating data modeling solutions, including both relational and dimensional models.
• Developed user defined Routines and Transformations for implementing Complex business logic.
• Developed Job Sequencer and batches and have edited the job control to run jobs in sequence.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used Data Stage as an ETL tool to extract data from sources systems, loaded the data into the Oracle server database.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Tuned Data Stage jobs to enhance their performance.
• Involved in the preparation of ETL documentation by following the business rule, procedures and naming conventions.
• Performed job tuning for better performance.
• Performed Unit and Integration testing on the jobs created.
• Having experience in Autosys to run the jobs in production Environment.

Environment: IBM InfoSphere Information Server (Data Stage and Quality Stage, Information Analyzer, Business Glossary, Metadata Workbench)8.5/ 8.1, Autosys, DB2 .

Confidential, Pennsylvania

Data Stage Developer

Responsibilities:

• Understanding existing business model and customer requirements
• Extracting Data from various source using the ETL tool
• Worked on Datastage - Source Analyzer, Warehouse designer, jobs and Containers, Transformations. The objective is to extract data stored in Oracle
• Design the sources and targets based on the requirements
• Developing the transformations and creating Sophisticated Jobs
• Created and executed sessions and batches using Server Manager
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Migration knowledge in Exporting and Importing of ETL Jobs across different environments
• Good in maintenance, performance tuning and support of implemented software products
• Re-Scheduling the batches in case of stopped it for resolving issues
• Created standard filters, calculation prompts, and conditions
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Tuned Data Stage jobs to enhance their performance.
• Involved in the preparation of ETL documentation by following the business rule, procedures and naming conventions.
• Performed job tuning for better performance.
• Performed Unit and Integration testing on the jobs created.

Environment: Datastage v7.5/8.1 PX, Autosys, DB2.

Confidential - Pennsylvania

Data Stage Developer/ Data Modeler

Responsibilities:

• Involved in understanding business processes and coordinated with business analysts to get specific user requirements.
• Involved in understanding logical and physical models for the subject area of the Customer Information Management.
• Designed the mappings between sources (external files and databases) and Operational staging targets.
• Extensively used stages in Parallel Extender (PX) to design DataStage jobs for performing the required integration.
• Extensively used Sequential file and Complex Flat File stages to read COBOL files.
• Experienced with data modeling tools such as MS Visio and/or Erwin
• Experienced in relational data models such as conceptual, logical and physical data models, dimensional data models, data dictionary, and metadata.
• Responsible for developing, validating, and communicating data modeling solutions, including both relational and dimensional models.
• Involved in facilitate Business and IT Communications by creating and managing a common business vocabulary.
• Extensively used DataStage Tools like InfoSphere DataStage Designer, InfoSphere DataStage Director.
• Received the source data in the form of Oracle tables, Sequential files, flat files and Excel sheets, Mainframes, SQL Server.
• Involved in Import of Business Terminology from Excel Spread Sheets into Business Glossary.
• Involved in Understanding the value of Business Metadata.
• Involved in managing integration assets to enable in-depth analysis using Metadata Workbench.
• Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
• Involved in job scheduling using Autosys.
• Created Job Sequencer to execute a set of jobs.
• Created error and exception handling procedures to identify record, report and fix errors.
• Validated the current production data, the existing data and programming logics involved.
• Ensured that the data integration design aligns with the established information standards.
• Developed jobs to extract the source data from different sources, integrated and populated the extracts after cleansing, transforms and integrating.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Scheduled, tested and debugged jobs. Worked on programs for scheduling data loading and transformations using DataStage from source systems to Oracle 11g using PL/SQL.
• Improved the performance of jobs by interpreting the performance statistics and enhanced the job designs.

Environment: IBM InfoSphere Information Server (DataStage and QualityStage, Information Analyzer, Business Glossary, Metadata Workbench) 8.1, IBM-AIX, Oracle 11g, Unix Shell Scripts (ksh), PL/SQL,UNIX, Netezza, Autosys, ERWIN and MSVisio .

Confidential

Junior Programmer

Responsibilities:

• Developing Jobs using Datastage v7.5 PX
• Working under different modules to achieve the project deliveries possible.
• Working with Flat files as source and loading into Oracle Database.
• Using the stages like Copy, Sequential File, Dataset, Modify, Transformer, Lookup etc
• Applying the parallelism for better performance and Creating Sequencers for jobs.
• Developing shell scripts to automate the run of Datastage sequencers and jobs.
• Unit testing the Jobs.
• Working actively in the integration testing.
• Providing the technical help to other teams.

Environment: Ascential DataStage 7.5, Oracle 9i, PL/SQL, SQL*Plus, UNIX Shell Scripts, HP-UX 10.0, Windows 2003/NT 4.0, ERWIN 7.3, Business Objects 5.0, Meta Stage and Integrity.

Confidential

DataStage Developer/ Data Modeler

Responsibilities:

• Responsible for understanding the requirements, analysis, design, development and implementation into the system.
• Involved in designing of data models using Erwin.
• Created jobs in DataStage to extract from heterogeneous data sources like DB2, Sybase, Access, Flat files and Text files to Oracle.
• Scheduled and monitored the jobs in DataStage Director to load data into target database.
• Used server components (DataStage Repository, DataStage Server, and DataStage Package Installer).
• Cleansed the data at the staging level before populating the extracts.
• Used Director for executing and scheduling the jobs.
• Used Manager for export/import various DataStage components.
• Defined the Granularity, Aggregation, and Partitioning required.
• Developed SQL Scripts to modify the existing database objects and packages.
• Created error and exception handling procedures to identify record, report and fix errors.
• Executed SQL statements using joins, date functions, functions, and sub-queries to generate reports.
• Identified source systems, connectivity, related tables and fields and ensure that data is suitable for mapping.
• Involved in the testing of the forms against checklist, preparing problem reports and fixing the problems to have the correct functionality of all the forms.
• Evaluated the consistency and integrity of the model and repository.
• Created DataStage scripts for data transformation, conditioning, validation and loading.
• Developed, automated and scheduled load processes using UNIX shell scripting.

Environment: DataStage 8 (Designer, Manager, Director), Windows XP, Oracle 9i/8i, SQL, PL/SQL, Erwin7.0, UNIX, MS Access, Sybase, DB2.

Confidential

DataStage Developer/ PL-SQL

Responsibilities:

• As a Technical Team Member I was involved in Development of different modules and PL/SQL procedures.
• Was responsible for identifying the business user requirements.
• Developed transformations logic and developed various mappings in DataStage Designer.
• Used ODBC to connect to the target Oracle database.
• Used SQL overrides extensively and substituted them in place of multiple transformations.
• Used transformations for data complex aggregations.
• Responsible for improving query and session performance.
• Created, launched & scheduled sessions and batches using Server Manager.
• Defined mappings for slowly changing Dimensions and slowly growing targets.
• Created Unit test plan documents and executed the same successfully.
• Used DataStage Director for executing and scheduling the jobs.
• Used DataStage Manager for export/import various DataStage components.
• Used Before/ After Job-Subroutines in Job Properties.
• Responsible for performance Tuning.
• Performed Unit Testing.

Environment: DataStage Designer, DataStage Director, Designer Manager, Oracle, IBM DB2 UDB, Teradata, Mainframes, Unix Shell Scripts, PL/SQL,UNIX And DOS Sequential Files, MS Access.