SUMMARY

• Eight Plus (8+) Years of experience in Software Analysis, Design and Development, Experience in Internet Technologies, Client/Server business systems, GUI prototyping, Data warehousing and application development in Insurance, Manufacturing, Financial and Pharmaceutical Industries.
• 8+ years of experience with ETL tools such as Ascential DataStage 8.0/7.5/7.1/6.0/5.2/ 5.1 (DataStage Manager, DataStage Administrator, DataStage Designer, DataStage Director) and Informatica PowerCenter 7.1/7.0/6.2/6.1/5.1 (Designer, Repository manager, Repository Administrator console, Server manager, Work flow manager, work flow monitor) and Informatica PowerMart 6.2/5.2/5.1/4.7
• 3+ years of Data Modeling experience in design and implementation of Star, Snowflake schemas and multi dimensional modeling. Proficiency in using ERWIN 4.5/4.1 Tool for Logical and Physical Data Model.
• Proficiency in Design, Development of Business Reports using Business Objects 6.5/6.1.3 and Cognos 6.0/5.0.
• 6+ years of Oracle 10g/9i/8i/8/7.3, MS SQL server, DB2, MS Access 2002/2000/7.0 , Erwin, SQL, PL/SQL, SQL*PLUS, Developer 2000, Windows NT/2000, Sun Solaris, IBM AIX, HP - UX.
• Experience in integration of various data source like DB2, SQL Server, Oracle and MS Access into staging area.

TECHNICAL SKILLS

ETL Tools: Ascential DataStage 8.0/7.5/7.1/6.0/5.2/ XE (Administrator, Manager, Designer, Director, Parallel Extender/Orchestrate, Quality Stage/Integrity, Metastage), DataStage Plug-In, Informatica PowerCenter 7.1/7.0/6.2/6.1/5.1 , Informatica PowerMart 6.2/5.2/5.1/4.7 , Data Mining, OLAP and OLTP.

OLAP Tools: Business Objects 6.X/5.X/4.1, Cognos 6.0/5.x

Data Modeling Tools: Erwin 4.1/4.0/3.5.2 , Designer2000/6i

RDBMS: Oracle 10g/9i/8i/8.x/7.x, MS SQL Server 2000,Ms Access, DB2, Teradata V2R3/V2R4.1

Languages: SQL, BASIC, C, C++, Java 2.0, VB.Net, C#, COBOL, HTML, DHTML, XML, JavaScript

GUI: Developer 2000 (Forms, Graphics, Reports and Report Server), Crystal Reports 7.0

Other tools: Oracle Utilities, SQL*Loader, ODBC, WinRunner 7.0/7.5, Test Director 6.5/7.0, Loadrunner 7.5

Operating Systems: AIX/ Linux 7.x/6.x, SOLARIS, HP-UX, WINDOWS NT/95/98/2000

PROFESSIONAL EXPERIENCE

Confidential, TORRENCE, CA

Data Stage Consultant

Responsibilities:

• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into Enterprise Data Warehouse tables.
• Gathering and documenting requirements, requirements analysis, converting requirements into High Level Design Documents.
• Worked with various sources such as Oracle, Flat files. Used Ascential Data stage to extract data & Load into Data Warehouse and Data Marts built on Oracle Database.
• Extensively worked with Claims, Policy, and Quote data and did transformation as per business requirement and loaded into the database.
• Checked in code, ETL specs, Test cases into PVCS on a daily basis.
• Conducted various before and after code reviews.
• Actively participated in the Team meetings to gather the business requirements and developing the Specifications.
• Created and edited the design specification documents for the jobs.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Participated in discussions with Team leader, Group Members and Technical Manager regarding any technical and Business Requirement issues.
• Validation & Exception reporting on data
• Extensively worked in the performance tuning of the DataStage jobs, ETL Procedures and processes, tuning the SQL used in Transformations and fine-tuning the database.
• Defined business rules, aggregations and lookups
• Extensively used Ascential DataStage - Designer, Manager and Director for creating and implementing various jobs
• Used DataStage to transform the data through multiple stages and prepared documentation
• Extensively worked with various stages in parallel Extender like Sequential file, Dataset, lookup, peek, transformer, Merge, Aggregator, row generator and many more to design jobs and load into Dimension and Fact tables.
• Created Containers to use in multiple jobs
• Automated and fine tuned DataStage jobs and sequences for loading source systems data into warehouse
• Used debug mode in data stage to test the data flow and fix jobs
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in DataStage.
• Involved in Unit testing, System testing and Integration testing.

Environment: Datastage 7.5/8.5 (Manager, Administrator, Designer, Director), Data Warehousing, Version control, Oracle 9i, SQL, PL/SQL, Shell Script, TOAD 7.4, Erwin 4.5, AIX 5.3, W XP Professional.

Confidential, DEARBORN, MI

Data Warehousing Consultant (Datastage Consultant)

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.
• Gathering and documenting requirements, requirements analysis, converting requirements into High Level Design Documents.
• Created Test Data studying the Business requirements and directly interacted with the customers for any changes in the requirement specs.
• Created Test Cases using Mercury Test Director 9.0, generated all of the design steps for my modules and ran them in the test lab and logged any defects.
• Checked in code, ETL specs, Test cases into PVCS on a daily basis.
• Conducted various before and after code reviews.
• Data Analysis of source data to meet the EDW requirements
• Finalize source data layouts and needs
• Finalize Compensation and Contracting business team’s needs-data requirements
• Extracted from and loaded data into databases such as XML, Oracle, Teradata, DB2, Mainframe flat files.
• Validation & Exception reporting on data
• Defined business rules, aggregations and lookups
• Extensively used Ascential DataStage - Designer, Manager and Director for creating and implementing various jobs
• Used DataStage to transform the data through multiple stages and prepared documentation
• Extensively worked with various stages in parallel Extender like Sequential file, Dataset, lookup, peek, transformer, Merge, Aggregator, row generator and many more to design jobs and load into Dimension and Fact tables.
• Used Metastage for managing the metadata.
• Created Containers to use in multiple jobs
• Automated and fine tuned DataStage jobs and sequences for loading source systems data into warehouse
• Scheduled various Jobs using Autosys to run them at a specified deployment window.
• Used debug mode in data stage to test the data flow and fix jobs
• Created process to generate data extracts, validation and QA process

Environment: Datastage 7.5/7.1(Manager, Administrator, Designer, Director, AIX)Data Warehousing, ETL, Version control, Oracle 10g/9i, SQL*Loader, TOAD 7.4, Erwin 4.5, Visio 6, Hummingbird Exceed, Sun Fire, W XP Professional.

Confidential, Chicago, IL

Data Warehousing Consultant (Datastage Consultant)

Responsibilities:

• Conducting ETL team meetings and explaining the requirements to team members.
• Responsible for analysis, design and development of data warehouse
• Walking through Job designs, Code by team members, correcting if necessary.
• Designing job templates to specify high level frame work approach.
• Design the Data Mart model with Erwin using Star Schema methodology.
• Designed and Customized data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed Data Stage jobs for Loading Staging Data from different sources like People Soft DB, Grid DB, and SQL Server DB into Data Warehouse applying business rules which consists data loads, data cleansing, and data massaging.
• Implemented Slowly Changing Dimension Model Type II, for all tables in DW.
• Generated Lot of Sequencer jobs to call through AutoSys for these SCD to run in order.
• Designed and developed lots of Data Stage jobs to load into Dimension and Fact Tables of different Data Marts from extracting data from Data Warehouse tables.
• Extensively used Pivot stage to pivot the source data to achieve required table structures like converting data from columns into rows and rows into columns.
• Extensively used all the stages of Data Stage like Pivot, Folder, Container, Aggregator, and Transformer etc.
• Designed, developed and deployed Data Stage Jobs and fine-tuned them by implementing best practices like converting using Hash Tables for look-ups and following Naming Standards, Parameterize the variables from Global Environment to stage level.
• Used Parallel Extender for parallel processing of data extraction and transformation.
• Used Parallel Extender to run jobs on SMP systems.
• Extensively worked in Ascential Quality Stage to clean up the address information with in the client data.
• Used Sequential file stage to extract the data from text files.
• Used Transformer stage for transformations and Aggregator for Aggregations.
• Extensively used to Aggregator stage to sort and group the provider data and calculated the quartile ranking for the eligible providers.
• Used Quality stages built in wizards for parsing and removing duplicate records.
• Unduped the address records using Ascential Quality Stage
• Configured Metastage Directory using Metastage Administrator. Extensively used almost all of the stages & transforms of the DataStage for various types of Date Conversions.
• Developing Shell scripts to automate file manipulation and data loading procedures.
• Used Business Objects to generate Business reports.

Environment: DataStage 7.5/7.1, DataStage Plug-in, Parallel Extender, Quality Stage, Metastage, Erwin 4.5, Version Control, PL/SQL, Oracle 10g/9i, SQL Server 2005/2000, DB2 8.0, Business Objects 6.5, Windows XP/2000, HP UNIX.

Confidential, PA

Data Warehousing Consultant (Informatica Consultant)

Responsibilities:

• Requirement gathering and business analysis
• Expertise in data design and modeling by applying Ralph Kimball Methodology of dimensional modeling
• Designed logical and physical data models using star schema
• Extensively used Erwin for Dimensional Data Modeling
• Created complex Informatica mappings, applets, and reusable transformations to be called from Informatica jobs and QA procedures to be loaded in staging area, ODS designed in 3rd Normal Form and then to the data mart .
• Responsible for populating the mappings using business rules into the Repository for Meta Data management
• Created, monitored, trouble shoot sessions and workflows to run loads using Workflow manager for workflow and session management, database connection management
• Extensively migrated data from different source systems developing transformation logic to be used in Informatica
• Identified and tracked the slowly changing dimensions and determining the hierarchies in dimensions
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints using TOAD to meet the project requirement
• Extracted data from flat file, performed complex joiner, lookup and filter transformations to extract transform and load data
• Tuned the informatica sessions and mappings for optimum performance
• Extensively used Unix Scripting and scheduled PMCMD to interact with Informatica Server from command mode
• Developed test-scripts, test plans, unit test documents for end-to-end workflows testing of the validated system

ENVIRONMENT: Informatica - Power Center 7.1, TOAD, Erwin 4.5, Siebel 7.8.2, SQL* Loader, Oracle 9i, HP-Unix, Autosys, Windows 2000.

Confidential, Pittsburgh, PA

Data Warehousing Consultant (Datastage Consultant)

Responsibilities:

• Business Analysis and Requirements Collection
• Analysis and Design of Extraction, Transformation and Loading processes.
• Consolidated, Cleansed, Integrated, ETL, and customized of data.
• Design and Development of ETL Processes and Stored Procedures and also tuned them for better performance.
• Identified sources and analyzed source data.
• Designing the Data model.
• Worked with Integrity’s Investigation, Standardization/Conditioning, Matching and Survivorship.
• Performed address cleaning on Investor’s data.
• Used Integrity’s pre-built procedures/rule sets for cleaning addresses.
• Analyzed the source data using MetaRecon.
• Used Metastage to perform the Column/Table/Cross-table analysis.
• Exported the basic jobs created by MetaRecon and later customized them for business requirements.
• Extensively used DataStage Manager, Designer, Administrator, and Director for creating and implementing jobs.
• Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file stages.
• Created shared containers to use in multiple jobs.
• Extensively used Link Partitioner and Link collector in improving the performance.
• Used Parallel Extender to run the jobs in parallel.
• Performed Unit testing and Integration testing of the module.
• Used Syncsort for sorting files before the data loading process.
• Worked on Oracle VArrays, Nested Tables and Oracle Objects.
• SQL scripts were written to test the mappings.
• Created Shell Scripts, which will intern call the DataStage jobs with all paths to Source and targets and even with connection information.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.

Environment: Datastage 6.0, Datastage TX, Flat files, Oracle 8i, PL/SQL, SQL*Loader, Stored Procedures, Syncsort, Swift, Business Objects, Windows NT, Solaris.