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.

Confidential

DataStage Developer-Datawarehouse Analyst

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