PROFESSIONAL SUMMARY:
IT professional , Over 7 years experience in System Analysis, Design and Development and Extensive experience in IBM DataStage v 8.5/8.1/ 7.x using Components like Administrator, Manager, Designer, and Director.

• Extensively involved in the development of Datastage ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse for Business Analysis.
• Extensively worked on IBM Datastage v 8.5/8.1/7.5.x/7.0.
• Worked and Extracted data from various database sources like Oracle 10g/9i/8i, DB2, Teradata, XML and Flat Files.
• Expertise in understanding/grasping Complex jobs and Business models.
• Developed Datastage jobs in Parallel (PX) and Server Environment.
• In depth experience in dealing with Datastage Designer stages like Lookup , Join, Merge, Row generator, Transformer, SCD, Remove Duplicate, Sort, Peek, Change capture, Filter, CFF, Copy, Sequential File, FTP, Data Set, ODBC, etc.
• Worked on Datastage Director for executing, monitoring, analyzing logs and scheduling the jobs.
• Worked on Datastage Client Manager to import/export various job components to various projects.
• Experience in designing Datastage sequence jobs and Quality Stage jobs.
• Experience in writing, testing and implementation of the triggers, procedures, functions at Database level using PL/SQL.
• Done Performance tuning of the DataStage jobs.
• Involved in Testing, System Testing and Integration Testing of Datastage jobs.
• Strong Knowledge in Software Development Lifecycle.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in Relational, Dimensional and Multidimensional modeling.
• Developed Source to Target Mapping documentation based on business requirement specifications.
• Good Experience with Version Controls in Datastage.
• Experience in using Autosys Scheduler Tool to schedule Datastage jobs.
• Extensively used Email Notification, Nested Condition, Sequencer and Terminator activities in Job Sequences.
• Experience in UNIX Shell Scripting to automate file manipulation, data loading procedures, Data Conversion and scheduling jobs.
• Excellent Communication and Interpersonal skills. Versatile team player with proven problem solving skills and ability to easily grasp new technologies.

Technical Skills

DataStage 8.5/8.1/7.5.1/7.5/7.1/6.0

Languages:

C, C++, Unix Shell Programming, SQL, PL/SQL

Operating Systems:

Unix, Windows, Aix (IBM)

Database and Tools & Oracle Tools:

Oracle 9i,10g,11g, SQL Server 2000, DB2,SQL*Plus, TOAD, SQL*Loader, Designer 2000, Developer 2000 ,Teradata V2R6

Web Technologies:

HTML, JavaScript

Data Modeling Tools & Scheduling Tools :

Tivoli,Erwin,Zena , Autosys,Control M

Reporting Tools:

Business Objects, OBIEEE, Cognos, MicroStrategy, SSRS.

EDUCATION : Bachelor’s in Computer science Engineering.

PROFESSIONAL EXPERIENCE

Confidential,July’10 – Present
East Providence, RI
ETL/Datastage Developer

Confidential,is one of the 15 largest banks in the United States and Citizens is a wholly owned subsidiary of the Royal Bank Of Scotland, and provides Customers with a full range of financial products and services at more than 1,500 convenient locations from Vermont to Illinois. The main goal of Data ware House (RDP) is extract the data from various sources like Flat files and Data bases load into Data Ware House and process the data for our internal Citizens bank Risk Analysis and reporting to parent bank Royal Bank of Scotland and also reporting to Federal government and also providing Customers data to Equifax.

Responsibilities:

• Interacted with Business users and Technical Architects to analyze the data & gathering the requirements from various sources.
• Developed jobs using DataStage in Designer to extract data from different operational Sources like Flat Files, CSV Files, Delimited Files and performed business operations on data like Cleansing, Transforming and Load (Initial/Incremental) into Target DWH.
• Extensively used Data Set, File Set, CFF, Lookup, Transformer, Sort, Join, Merge, Lookup, Funnel, Copy, and Modify stages.
• Involved in daily meetings with the client for requirements and provide services to meet the required SLAs.
• Created Design Documents and Unit Test cases with test Results Documents.
• Used Job Sequencers to run the jobs sequentially and reporting the Status of the Job through Email.
• Exported and imported the Datastage jobs between the production and the development servers
• Developed JOBS to load the data into the Warehouse environment using the Slowly Changing Dimension techniques.
• Check the output according to the specifications using Unit Test.
• Basically involved in providing Support to the built Applications and also involved in developing in new dimensions while enhancing the application.
• Loading the data into the Staging and moving the data from Staging to ODS.
• Involved in Business Requirement gathering sessions
• Designing of the ETL jobs as per the client’s requirements.
• Involved in Unit, Integration, system, and performance testing levels and Involved in Performance tuning at source, target, jobs and system levels and Testing Jobs with Unit Test plan.
• Integrate the data from the Source system into the target database.
• Involved in S.I.T (System Integration and Testing) and U.A.T (User Acceptance Testing).
• Supported Data Reconciliation team during the data recon process
• Extensively used SQL coding for overriding the generated SQL in Datastage and also tested the data loaded into the data base.
• Used Autosys Scheduler to Schedule the jobs.
• Supported the application after moving into Production and Troubleshooting the issues faced in Production support.

Environment: IBM InfoSphere Datastage 8.5/8.1, Autosys, Oracle11g/10g, DB2 8.x/9.x, MS SQL Server 2000/5/8, SQL,AQUA data studio, HP ALM 11.0 ,PL/SQL, Windows 2000/NT & IBM AIX.

Confidential,March’08 – July’10
Hoffman Estates, IL
EDWH/DataStage Developer

This application is used to send Markdown Prices for apparel line of business. The Project was aimed at building Institutional Analytical Data mart to support the Sales and Inventory comparison to other Retail Industries. The source data such as Sales and Inventory data feed from various sources and then loaded into Data Ware House to Revenue Optimization application and also for our internal business analysis and then our Business creates Group Plans for every season for divisions and Category Based on the historical data which is feed to application we get recommendations on a weekly basis. Committee reports are then created from the Data mart.

Responsibilities:

• Involved with the end users / business analysts to collect the requirements of the project.
• Preparation of technical specification for the development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data Marts and defining ETL standards..
• Experienced with DataStage Parallel Extender for partitioning the data into subsets and load balancing across all available processors to achieve job performance.
• Extensively used Data Set, File Set, CFF, Lookup, Transformer, Sort, Join, Merge, Lookup, Funnel, Copy, and Modify stages.
• Created Fast load, Fast export, Multiload, Tpump, BTeq Scripts where required to load and transform data from various sources to target D.W.H.
• Extensively used Dataset management utility –viewing, copying, and deleting data.
• Exposure to Orchestrate – OSH scripts, Operators.
• Used DataStage Manager to import the metadata / schema definitions into various jobs.
• Worked on the cleanup, fixes and loading of metadata into the Warehouse.
• Created job sequences to handle the load dependency.
• Used Director to run, monitor and schedule the jobs.
• Extensively wrote user SQL coding for overriding generated SQL query in DataStage.
• Extensively involved in Quality Stage (Integrity Stage) for quality checking and error detection process.
• Developed various PL/SQL stored procedures to enhance reusability during data validation and to perform unit testing.
• Created UNIX shell scripts to extract specific columns needed for business from the raw files.
• Created and documented various Data Quality Scripts to perform system integrated testing and user acceptance testing.
• Created lots of PL/SQL scripts to tune and optimize the database performance.
• Extensively worked with SQL Loader to load the flat files into various Oracle tables.
• Used SQL Navigator to query the DW tables and validate the data.
• Extensively used Erwin to import and export the data model definition of business

Environment: DataStage 8.1/8.0, Cognos, Parallel Extender/Enterprise Edition, SQL, PL/SQL, Teradata, Oracle 11g/10g,Quality Stage 7.5,TOAD 7.5, SQL Navigator, MS Excel, Windows XP, Erwin 4.2.

Confidential,Nov’06 – March’08
Pittsburg, PA
DataStage Developer

As an investment bank, Mellon is one of the leading underwriters of debt and equity securities and strategic advisor to corporations, governments, institutions and individuals worldwide. The project involved building and deploying a data warehouse to track Mellon deal related expenses for all stages of a deal. All expenses are recovered from the client upon maturity of the deal. The data for this warehouse was extracted from Oracle Financials and Flat files from Oracle RDBMS based billing system into the target Oracle 9i database.

Responsibilities:

• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into Staging and then to Mainframes Datasets.
• Extensively used all the stages of Data Stage EE like Look up, Merge, Remove Duplicate, Sort, Filter, Transformer, Dataset, Row Generator, etc.
• Extensively wrote user SQL coding for overriding for generated SQL query in DataStage.
• Exclusively Wrote PL/SQL Scripts for data validation and data quality.
• Designed, developed and deployed Data Stage Jobs and fine-tuned them by implementing best practices following Naming Standards andparameterized the variables from Global Environment to stage level.
• Exclusively Wrote Shell Scripts for running Scheduled DataStage Jobs and other related scripts based on requirements.
• Lead Off-shore team and conducted code reviews.
• Used QualityStage to staderdize address and data which are coming from Vzw source systems as per the business requirements.
• Extensively worked on plug-ins like Stored procedures, QualityStage/QualityStage Metadata.
• Used DataStage Director to monitor cleanup resources and run job.
• Created Job Sequencers to control set of DataStage jobs.
• Participated in the review of Technical, Business Transformation Requirements Document.

Environment: DataStage 7.5/8.1, QualityStage 7.5, Designer, Director, Manager, Oracle 10g, PL/SQL, Aix, Toad,Erwin,Autosys.

Confidential,Feb’05 – Oct’06
Hyderabad, India
ETL/Quality Analyst

Confidential,provides information and software solutions to financial institutions, advisory firms, and corporations. Capital IQ helps clients to access deep information on companies, people, securities, industries, and markets worldwide. It provides solutions through web and Excel-based applications as well as client-side systems.

Responsibilities:

• Involved in Test plan and Test case preparation.
• Prepared reusable function in QTP to use across the automation scripts
• Involved in Installation testing and Transformation of XML documents using XSLT.
• Transformed the XML documents into various form using XSLT.
• Identify business rules for data migration and Perform data validations.
• Assisted in kicking off Data stage ETL jobs using UNIX and analyzed the data in dimension and fact tables.
• Used DataStage Director to monitor cleanup resources and run job.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Coordinated with Offshore team and Onsite managers
• Interacting with developers for the Bug Fixes and Problem resolution
• Involved in preparing Daily status report
• Provided weekly management status reports.
• Executed SQL Queries to check table updates and data retrieval
• Conducted Data Driven Testing using different sets of external data
• Involved in Hindi based Localization Testing.
• Reporting defects to development team through the Test Director.
• Involved in Test Summary Report preparation

Environment: DataStage 7.1/6.0, QualityStage 7.1, Designer, Director, Manager, Oracle 8i, PL/SQL, Aix, Toad, QTP 7.0, Win Runner, Test Director 7.5, XML, XSLT, SQL, Test Cases, Test Scripts, Test Plan, Traceability Matrix.