Summary:

• Around 7 years of total IT experience in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications, Client/Server Applications, using Object Oriented Analysis, Design and Methodologies
• Around 7 years of experience in ETL methodologies in all the phases of the Data warehousing life cycle
• Around 7 years of experience in DataStage Server and Enterprise Edition using Components like Administrator, Manager, Designer, and Director.
• Experience in DataStage Parallel Extender Formerly known as DataStage PX for Parallel Processing to improve job performance while working with bulk data
• Extensive experience in database design for data warehouses with strong understanding of Star and Snowflake Schemas
• Experience in logical and physical data modeling skills with emphasis on Dimensional Data Modeling.
• Extensive experience of gathering business requirements, technical specifications, documenting them, and converting them into robust system designs
• Knowledge of full life cycle development for building a Data Warehouse.
• Strong knowledge of the Data cleansing and Data profiling methodologies and their importance on Enterprise wide Data Quality initiatives
• Knowledge in ETL, DSS and Data warehousing and OLAP technology using DataStage, BI tools Business objects and Cognos .
• Excellent experience in most of the RDBMS including Oracle 10g/9i/8x/7.3, SQL Server 2000 DB2
• Experience in SQL, SQL PLUS, PL/SQL and developed Stored Procedures, Functions, Triggers, Cursors and Packages.
• Expertise in using SQL Navigator 4.2, TOAD and PL/SQL Developer tools.
• Good experience in developing Oracle Forms and Reports 6i previous versions including Designer9i Web forms9i, Web reports9i
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning, System Testing
• Knowledge in various data bases like Oracle, MS SQL Server, DB2 and TERADATA
• Scheduled parallel batch process in server and backup revitalization and fine-tuning of sessions
• Proven track record in troubleshooting of DataStage Jobs and addressing production issues such as performance tuning and enhancement
• Strong writing and documentation skills for the management, development and control of documentation
• Excellent team player with good organizational, communicational, interpersonal analytical skills

Technical Skills:

Professional experience:

Confidential

DataStage Developer

Responsibilities:

• Created Processes using Datastage 8.5, 8.7, DB2 , Oracle 11,SQL Server 2008, AIX, Fast Track.
• Created DataStage process design documents and run book for production support.
• Created ETL jobs extracting data from different sources and loading to IBM CBI EDW Model
• Worked on improving performance of ETL jobs which extract data from Oracle and load to DB2 UDB.
• Involved in loading the source data into DB2 production tables using ODBC, Transformer, Lookup, Join, Sequential File , Sort Stage ,Modify and Remove Duplicate Stages to load and from test tables as final claims and raw claims and doing a data quality checks.
• Submitting the jobs and monitoring the jobs on Mainframes.
• Involved in writing implementation plans for the AR Actions Request .
• Involved in database administration functions such as granting access to users on tables and schemas, and creating indexes and tablespaces, monitoring and maintaining the logs.
• Worked on Test case execution. initial and Delta and fixing defects.

Environment: IBM Information Server 8.7 , DB2 UDB , Oracle, IBM Fast Track, TOAD, Sql Server.

Confidential

DataStage Developer

Responsibilities:

• Worked on creating jobs for IPA Integrated Pricing Analysis Project using Sequential file stage, Sort, DB2 connector, Aggregator, Transformer.
• created a script which will move the files to archive and removes the files from archive
• Working on process changes to current ETL jobs to improve performance.
• Worked on production support.
• Involved in supporting the DWH users in reset the passwords, deactivating and activating the user accounts.
• Performing Data quality checks before the users have the access to the data.
• Performing various daily tasks of Monitoring long running Sql Queries and helping the users in resolving the long running Sql.

Environment: IBM Information Server 8.1 , DB2 UDB, Control M, IBM Clear Case, TOAD, WINSQL

Confidential

ETL Developer- BAC DUAL POST-Recon

Responsibilities:

• Involved with business team to understand the objective of the project.
• Worked with Business Analysts creating mapping documents.
• Created ETL jobs which use flat files and SAP data to join and load into SAP by using SAP Plug in Stages
• ABAP Extract and SAP BW Load .
• Worked on Validation of Data with Business Team and fixing the issues.
• Created Sequences to automate the jobs based on the requirements.
• Provided Knowledge Transfer to off shore team.
• Responsible for coordinating with team members and mentoring them in testing the project with short time line.
• Provided assistance to the team members in resolving unit testing issues/errors

Environment: Teradata 12, IBM Information Server 8.1, AIX, SQL Assistant, CONTROL- M,SAP Bank Analyzer

Confidential

Datastage Developer

Responsibilities:

• Involved with business analysts and users creating new logical and physical database design.
• Working on re writing the current ETL Processes which are running using sql,pl/sql procedures to the new Datastage Jobs.
• Created jobs which loads the data from source systems to production and comparing with the current production load to validate the Datastage load with current production load
• Involved in created Datastage jobs using oracle enterprise stage, oracle connector, lookup, join, transform, compare, sort, dataset and promote subrecord stages in the new Datastage jobs
• Created batch jobs and job sequences and scheduled to run in parallel with the current production loads which handle the activities that fail and also created the error handling and mail notifications to the reporting group operators.
• Working on performance issues in the new Datastage jobs and comparing the performance metrics against the current production.
• Worked on creating Technical design document, datastage job flow designs and rollout instructions to hand off the jobs to reporting group.

Environment: IBM Webspehere Datastage 8.1, AIX64 5.3 , Oracle 10g, cognos, Autosys, Toad, Embarcadero rapid sql 7.6.3 , InfoSphere Data Architect Version 7.5.2

Confidential

Datastage Developer

Responsibilities:

• Involved with business analysts and users creating logical and physical database design.
• Involved in loading the extracted data from mainframes into db2 tables using db2 utilities such as Load, Export, and Import into test tables.
• Involved in creating star schema Dimension and fact tables .
• Involved in loading the source data into DB2 production tables using ODBC, Transformer, Lookup, Join, Sequential File , Sort Stage ,Modify and Remove Duplicate Stages to load and from test tables as final claims and raw claims and doing a data quality checks.
• Involved in collecting sample data using Sample Stage from Test Tables.
• Merging the data from different source tables into a single table by using the Merge Stage.
• Involved in creating Monthly, Quarterly Summary tables and loads.
• Monitoring the jobs using the DataStage Director and used DataStage Manager to import table definitions.
• Checking status of received files to be extracted from CMS.
• Involved in creating Business object universes, creating reports and publishing them to Webi.
• Submitting the jobs and monitoring the jobs on Mainframes.

Environment: DataStage 7.5 Enterprise Edition,IBM DB2 UDB 8.2.7,AIX64 5.3 , Business objects 6.5, WEBi/Info view/OS 3270,ISO Warehouse Tracking Tool, COBOL, SAS 8.2, Korn shell, BCU 1.1

Confidential

DataStage Developer

Responsibilities:

• Involved in redesigning the existing ETL jobs, which are delivered by people soft on HCM/EPM environment to increase the execution time.
• Involved in minimizing the hashed file stages and re writing the sql code when extracting the data from the database.
• Involved in removing the existing code and writing new sql scripts in ETL jobs to minimize the execution time.
• Minimized the number of Sequences the jobs are using for optimum performance.
• Involved in removing DRS stage and replacing with OCI stage in some of the ETL jobs.
• Troubleshoot the failing sequences overnight, redesigning the existing sequences and creating mail activity notifications.
• Created the SSIS jobs in SQLserver2005 for loading the Financial Aid data into ODS data mart for analyzing the student enrollment process.
• Created the DataStage jobs for loading the SQL server ODS data into Oracle data warehouse into People soft EPM tables.
• Used DRS stage, OCI Stage, ODBC stage, and Link Partitions stages for the process.
• Involved in redesigning, testing and implementing the delivered ETL jobs
• Involved in on call support 24/7.

Environment: Data Stage 7.5 Server Edition , SQL server 2000 /2005, Oracle 9i /10g, People soft 9.0, SQL Server reporting. SSIS packages, Sun Solaris .

Confidential

DataStage Developer

Responsibilities:

• Involved in requirement gatherings and designing and modifications of tables and EDW MPM Data Mart according to the business requirements.
• Analyzing the source data and data profiling working with business analysts, team lead and project manager
• Designing logical and physical design data modeling with start schema using Erwin.
• Designed ETL jobs using designer server edition to extract and load the data by applying rules in the transformations, using hashed files, Merge, OCI stages
• Writing SQL statements to improve the performance of the jobs and tuning the SQL statements
• Designed Sequences to run the jobs and monitoring the jobs
• Involved in System Testing and Unit testing of jobs.
• Involved in writing routines to adjust the load dates and time.
• Exporting the jobs to Testing Environment from Development and then to Production.
• Used DataStage Director to schedule and monitor the performance of the jobs.
• Involved in creating the Universe using Business Objects Designer
• Involved in creation of various reports which includes weekly reports, bi-weekly reports, reports by Group, reports by Product and Sub-product
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail, Slice Dice and Drill Down.

Environment: IBM WebSphere DataStage 7.5 Server Edition Designer, Director, Manager, and Administrator , SQL Plus, PL/SQL, Oracle 9i, Windows XP, Sun Solaris, Erwin, Business Objects 6.5. TOAD, SQL Builder.

Confidential

Datastage Developer

Responsibilities:

• Involved in requirements gathering and creating logical and physical design based on the business requirements
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse
• Worked closely with Project lead/Manager, Architects, and Data Modelers to understand the business process and functional requirements
• Designed and developed Parallel jobs to extract data, clean, transform, and load the target tables using the DataStage Designer
• Design and Develop Enterprise edition Jobs based on the specification
• Designed and developed job sequencers and batches to run multiple jobs
• Used DataStage Manager for importing the source and target database schemas, importing and exporting jobs/projects.
• Created many transforms and routines for handling special cases involving complex logic.
• Prepared Specification Documents for DataStage Jobs
• Involved in Unit testing and integration testing to compare data with production data.
• Developed Parallel jobs using various stages like Join, Merge, Lookup, Sort, Transformer, Remove Duplicate, Filter, Column Generator, Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems
• Used the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics
• Extensively used SQL coding for overriding the generated SQL in datastage and also tested the data loaded into the data base.
• Worked with Data Stage Administrator to create/modify/delete projects and cleanup projects

Environment: IBM WebSphere DataStage 7.5 Designer, Director, Manager, and Administrator , Parallel Extender, SQL Plus, PL/SQL, DB2 UDB, Oracle 10g, SQL Server, Windows XP, UNIX, Erwin, SQL Loader, Business Objects 6.5