PROFESSIONAL SUMMARY:

• Over 9 years of experience in Data modeling, Data warehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM WebSphere Data Stage 8.x/7.x
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Data Stage (Ver8.0/7), designing and developing jobs using Data Stage Designer, Data Stage Manager, Data Stage Director and Data Stage Debugger.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Excellent in using highly scalable parallel processing Infrastructure using Data Stage Parallel Extender.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, Netezza and DB2, Sybase, XML and Flat files into the staging area.
• Experience in Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Proven track record in addressing production issues like performance tuning and enhancement.
• Excellent knowledge in creating and managing Conceptual, Logical and Physical Data Models.
• Experience in dimensional and relational database design.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in different Scheduling tools like AutoSys for automating and scheduling jobs run.

TECHNICAL SKILLS:

Datastage/Database: IBM Information Server V8.1&8.5 (Data Stage, Quality Stage, Information Analyzer)Oracle 8i/9i/10g, MS SQL Server 2005/2008, DB2 UDB, MS Access, Sybase, SQL, PL/SQLSQL*Plus, Flat files, Sequential files, Netezza, TOAD 9.6, Microsoft VisioOracle Developer 2000SQL*Loader, Windows NT,/XP

RDBMS: Oracle8.i, MS - Access2000, Sybase and SQL server 7.0, DB2/400 and TOAD

GUI: Visual Basic 6.0, Developer- 2000.

Validation Tools: CVS, PVCS, Documentum.

Other Tools: MS Visual SourceSafe, Visual intercept, Visio, Versata Studio.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Data Stage Developer

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Studied the PL/SQL code developed to relate the source and target mappings.
• Helped in preparing the mapping document for source to target.
• Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of Data Stage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• 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.
• Used Autosys job scheduler for automating the monthly regular run of DW cycle in both production and UAT environments.
• Participated in weekly status meetings.

Environment: IBM InfoSphere Data Stage8.0/8.5(Designer, Manager, Director, Administrator),Oracle 10g,SQL Server 2008, DB2, Flat files, Sequential files, Autosys, TOAD 9.6, SQL*Plus, HP Quality Center (ALM 11.0), Windows NT and IBM-Iseries AS/400- WINS, Web services (SOAP and XML Spy)

Confidential, NJ

ETL Developer

Responsibilities:

• Involved in system analysis and design of the Data warehouse
• Developed Functional (Business terms) and Technical Design documents.
• Responsible for Requirement Gathering Analysis and End user Meetings.
• Worked closely with data modeler and database administrator to understand the business process and participated in gathering of business requirements to load the data warehouse which is designed on the Star schema and RALPH KIMBALL methodology.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Extensively worked with Parallel Extender. Using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Extensively used Parallel Job Stages like Stored Procedure, Dataset/File set, Aggregator, Join, Transformer, Sort, Merge, Filter, Modify, Lookup, Funnel and Pivot.
• Worked on Head, Tail and Peek stages for debugging Data stage jobs.
• Used parameter sets for easy maintenance of project specific parameters and better functionality.
• Used Job Sequencer stages to link multiple jobs in Series/Parallel based on the requirement
• Used partition key in Parallel Extender job for bulk loading of data and to get better performance.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data ware house database.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Implemented shared containers for multiple jobs, which have the same business logic.
• Strictly followed the change control methodologies while deploying the code from DEV, QA and Production.
• Responsible for Formulating the DW process to load from sources to Target tables.
• Developed Data Stage jobs where in using data stage, data from different sources formatted, cleaned, summarized, aggregated and transform into data warehouse
• Used the Data stage Designer to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Designed and implemented slowly changing dimensions (SCD’s) methodologies
• Designed job sequences for running jobs.
• Responsible for integrating the data warehouse on both Windows and UNIX platforms
• Interaction with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution

Environment: IBM Information Server Data Stage8.0, Oracle 10g, SQL, PL/SQL, UNIX, SQL*Loader, Autosys, Business Objects 6.1, Windows 2003, IBM AIX 5.2/5.1, HPMercuryQualityCenter9.0

Confidential, NJ

System Analyst / Datastage Developer

Responsibilities:

• Maintained and support systems for data warehouse and business intelligence (BI) initiatives, including software, servers, and networks.
• Documented the changes\new requests determined after discussion with Business Users into a Business Requirements Document.
• Create data verification methods and comply with standard system procedures.
• Performed data analysis, testing, debugging, audits, disaster recovery, and problem resolution.
• Worked with users and coordinating with application developers to understand and capture data/reporting requirements
• Involved evaluating the technology solutions and present recommendations for improved system operations.
• Coordinated andperformed in-depth tests, including end-user reviews, to modify new systems to ensure they meet defined system requirements.

Environment: IBMWebSphere DataStage 7.5.2& 8.0 (Designer, Manager, Director, Administrator), Test Director 8.0, Windows XP/2K, Servlets, XML, Java Server pages (JSP), Oracle, SQL 7.0 & 2000, Java2.0, Java Script and TOAD

Confidential, NJ

Business Data Analyst

Responsibilities:

• Involved in different phases of Project Life Cycle.
• Used MS project for Project Scheduling during the entire life cycle.
• Analyzed the Business and system Requirements of Portfolio, Markets, Investing and Accounts.
• Extensively used Test Director, for test planning, bug tracking and reporting.
• Involved in developing the test strategy.
• Validated data for problem identification and significance across multiple report and data sources
• Assisted in the design, creation, testing, implementation and maintenance of processes/systems to oversee and carry out analyses
• Used Test Director to maintain test cases and test scripts.
• Lead client facilitation meetings to gather requirements (Inception phase), there after Analysis & Design of architecture using Object Oriented Programming, UML & Rational Unified Process involving in all phases of the lifecycle ensuring successful deployment and maintenance
• Involved in analysis and design with business analysis to generate Use Case diagrams, Class diagrams, Sequence diagrams
• Business objects, Domain Object Model and Visio to depict process flows and PowerPoint presentations.
• Involved in Component design and responsible for creating various UML diagrams for the system, Rational Rose was used for Visual Modeling.
• Worked on Dynamic Data Exchange (DDE) and Remote computing services.
• Extensively involved in performing the Backend testing of the application. Executed various SQL queries, PL/SQL procedures and triggers to perform the validity of the data.
• Master GUI Map is maintained in the central repository and changes are made to it for every version.
• Change/ Incident management using Rational Clear Quest
• Involved in and Documentation.

Environment: Ascential Data Stage 7.5 (Designer, Manager, Director, Administrator), Oracle 9i, TOAD, SQL/PLSQL,Win runner7.0, Test Director7.2, Load Runner, Windows XP/2K, Servlets, XML, Java Server pages (JSP)