SUMMARY

• 9+ years of Industry experience as Confidential ETL Developer and Data Analyst wif strong background in Data Warehousing, Data Lineage, Business Intelligence Reporting.
• Extensive experience in documentation of business requirements and technical specification.
• Extensive experience on Enterprise Data Management Project for Data Lineage, created various ETL Data Mapping documents, Data Transformations, Metadata, Data Flow and Process Flow Diagram, Conceptual and Physical Data Model.
• Excellent noledge of Confidential architecture.
• Expert in writing SQL queries and optimizing teh queries in Confidential, Oracle 10g, Microsoft SQL Server 2005 database.
• Good noledge of Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Extensively worked on Confidential SQL Assistant and Confidential Utilities like FASTLOAD, MULTILOAD, BTEQ, FASTEXPORT and TPT.
• Strong experience in Confidential SQL, Confidential Indexes, Stored Procedures, Macros, Views, Confidential OLAP.
• Experience in performance tuning and optimization of Confidential SQL using Views, Indexing mechanism and Global Temporary tables in Confidential .
• Strong experience in data warehousing projects dealing wif ETL (extraction, transformation, load) Datastage8.0 ETL tool.
• Hands on experience in SAS ODS 9.2, Informatica PowerCenter 8.6, Mainframe.
• Extensive noledge about UNIX Shell Scripting and file manipulation techniques.
• Proficient wif Business Intelligence technologies and methods using Cognos8.
• Excellent noledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Expert in writing Test Plans and Test Cases for UAT in Confidential and Oracle.
• Excellent verbal, presentation and written communication skills.

TECHNICAL SKILLS

Database: Confidential V2R12, Oracle10g,SQL Server 2005

Data Modeling Tool: Sybase Power Designer 15

ETL/ELT Tools: Oracle Data Integrator (Sunopsis V4), IBM Info Sphere Information Server 8.1(Data Stage, Quality Stage), Informatica Power Center 9.0

Confidential - Tools & Utilities: Confidential SQL Assistance 13, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPT

Operating System: Windows 95/98/NT/2000

BI Tool/Reporting Tool: Cognos8-Report Studio, MS Excel, MS Power Point

Data Flow Diagram: Microsoft Visio 2010

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Data Analyst

Environment: Confidential 12, Oracle 10g, Microsoft Visio, Sybase Power Designer, Microsoft Excel

Responsibilities:

• Working on Enterprise Data Management project for EDM Standards & Policies.
• Interacting wif business and technical staff and SME's of teh various applications to understand teh business and process flow.
• Interacting wif teh Business Users for creating metadata of KBE’s, Technical Metadata such as server details and Definitional Metadata such as business name, data size etc.for various applications.
• Analyzing data into Confidential Database verifies teh KDE against prioritized KBE (Business definition)
• Importing Data Linage documents, Metadata documents into standard InfoPortal template.
• Doing analysis of data alterations using Confidential Bteq, SAS Jobs/Scripts and XML Files from system to system and creating Data Lineage mapping documents, transformation logic documents.
• Interacting wif application owners for data movement and creating Process and Data flow diagram using Microsoft Visio 2010 to show source/target systems, frequency of data, method of transformation etc.
• Experience in translating business requirements into Conceptual and Logical Data Models using Sybase power designer 15.
• Designed & Created Confidential SQL Queries in SQL Assistant and Oracle SQL in TOAD for Unit Test Cases (UAT) based on teh KBE’s and verified teh data quality rules.
• Conducting Business Review meeting and IT SME review meeting.

Confidential

Senior Technical Consultant

Environment: Confidential 12, Confidential Utilities, UNIX, IBM Data Stage 8.0

Responsibilities:

• Interacted wif teh Business Users to analyze teh business requirements and transform teh business requirements into teh technical requirements.
• Generated business requirement document, mapping document, technical specifications document, data quality reports, developed ad hoc reports.
• Constructed context diagrams and data-flow diagrams based on a description of a business process.
• Worked on Confidential FSLDM having Credit Risk data.
• Loading data from Flat Files into teh Staging area using Confidential BTEQ scripts.
• Developed new FASTEXPORT scripts to generate teh files dat feed teh upstream systems.
• Developed ETL processes using Data Stage designer to load data from Flat Files (Fixed Width) to staging database Confidential and from staging to teh target Confidential Data Warehouse.
• Used Data Stage stages namely Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Row Generator stages in accomplishing teh ETL Coding.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Worked as Data Analyst, by gathering requirements related to designing of report and overall functionalities to be included. Made changes to teh report based on teh feedback given by teh user.
• Used advanced Excel functions for data analysis including, Excel pivot table, pivot charts, macros, logical statements.
• Involved in data quality requirements in terms of data analyze, consistency, accuracy, referential integrity, cleanse, and consolidate data before loading into data warehouse.
• Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations.
• Prepared reports for presentations using Access, Excel, and Microsoft Power Point.
• Responsible for training people on Confidential and noledge transfer in project work.

Confidential

Technical Consultant

Environment: Confidential 12, Confidential Utilities, UNIX, IBM Data Stage 8.0, Micro strategy

Responsibilities:

• Worked as a Team lead.
• Interacted wif teh Business Users to analyze teh business requirements and transform teh business requirements into teh technical requirements.
• Generated business requirement document, mapping document, technical specifications document, data quality reports, developed ad hoc reports.
• Identified project activities to be completed before transition can start.
• Involved in data loading using Confidential BTEQ scripts.Converted a multi-level and redundant SQL process into one simplistic BTEQ script.
• Developed new FASTEXPORT scripts to generate teh files dat feed teh upstream systems.
• Developing shell script, wrapper in UNIX.
• Working on Confidential SQL to build complex queries on Warehouse tables.
• Extensively used IBM Info Sphere Data Stage Manager, Designer and Director for creating and implementing and managing Data Stage jobs.
• Developed ETL processes using Data Stage designer to load data from Flat Files (Fixed Width) to staging database Confidential and from staging to teh target Confidential Data Warehouse.
• Used Data Stage stages namely Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Row Generator stages in accomplishing teh ETL Coding.
• Used Quality Stage to coordinate teh delivery, consistency, removing data anomalies and spelling errors of teh source information.
• Experience in Data profiling, standardization, matching and survivorship using Quality Stage. Worked wif Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
• Performance tuning of SQL (Explain plans, Collect statistics, Primary and Secondary indexes).
• Involved in data quality requirements in terms of data analyze, consistency, accuracy, referential integrity, cleanse, and consolidate data before loading into data warehouse.
• Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.
• Involved in analytical reporting using Advanced Excel Pivot tables and charts, macros, vlookup.

Confidential

Offshore project coordinator, ETL Developer

Responsibilities:

• Worked on individually assigned task such as Sybase to Confidential code conversion.
• Worked on performance tuning of Confidential query, PI, SI,PPI Indexing, use of compression of columns, stats collection, checking sub queries wif IN/NOT In and try to replace wif Joins.
• Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.
• Attending Meetings and Conference calls wif client for further necessary actions and status.

Confidential

Onsite project coordinator, ETL Developer

Environment: Confidential 12, Confidential Utilities, UNIX, IBM Data Stage 8.0

Responsibilities:

• Coordinating wif teh technical and business team at client site (Richmond, Virginia) to analyze teh Requirements and transform teh business requirements into teh technical requirements.
• Generated business requirement document, mapping document, technical specifications document, data quality reports, developed ad hoc reports.
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Used several stages like Sequential file, Hash file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator (debugging stage), Peek, Remove Duplicates, Copy, Lookup and RDBMS during teh development process of teh DataStage jobs.
• Used DataStage/QualityStage Designer to import/export jobs, table definitions,
• Created parameter sets to group DataStage job parameters and store default values in files to make sequence jobs and shared containers faster and easier to build. Worked wif Confidential BTEQ, TPT to run teh scripts in batch mode.
• Worked on UNIX Shell Scripts for copying and moving files to and from server.
• Developing Unit Test case, Tech Specifications.
• Worked on mapping documents provided by client.
• Worked as Data Analyst, by gathering requirements related to designing of report and overall functionalities to be included. Made changes to teh report based on teh feedback given by teh user.
• Team building, like giving training on teh application and new technologies to offshore team.
• Wrote teh Document of understanding and other technical documents including user guides.

Confidential

Onsite project coordinator, ETL Developer

Environment: Confidential 12, Confidential Utilities, Confidential Stored Procedures, UNIX, Informatica Power Center 9.0

Responsibilities:

• Coordinating wif technical team at client side (Toronto, Canada) and understanding new change request and helping Users to do UAT.
• Generated business requirement document, mapping document, technical specifications document, data quality reports, developed ad hoc reports.
• Designed Informatica mappings by translating teh business requirements.
• Imported Source/Target Tables from teh respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Worked wif Confidential BTEQ, TPT to run teh scripts in batch mode.
• Worked on UNIX Shell Scripts for copying and moving files to and from server.
• Developing Unit Test case, Tech Specifications.
• Worked on mapping documents provided by client.
• Worked as Data Analyst, by gathering requirements related to designing of report and overall functionalities to be included. Made changes to teh report based on teh feedback given by teh user.
• Team building, like giving training on teh application and new technologies to offshore team.
• Wrote teh Document of understanding and other technical documents including user guides.

Confidential

Offshore project coordinator, ETL Developer

Responsibilities:

• Extensively worked on understanding teh business requirements.
• Development & Implementation of Interface, Procedures, Packages, User Functions, Variables in ELT Process using ODI.
• Load Data from Fixed, Delimited files to Confidential and also Extract data from TD tables to flat files.
• Created transformation, Load data using fast load generated in ODI.
• Schedule and monitor teh Jobs in ODI.
• Understanding DB2 procedures and converted into Confidential DDL, DML.
• Used UNIX shell script into ODI Packages.
• Reviewed all teh code developed by teh team, before moving to next environment (Peer review)
• Unit testing of data and sending to client.

Confidential

Onsite project coordinator, Data Analyst

Environment: Confidential 6, Confidential Utilities, UNIX, Cognos8, Oracle Data Integrator

Responsibilities:

• Extensively worked on understanding teh business requirements.
• Generated business requirement document, mapping document, technical specifications document, data quality reports, developed ad hoc reports.
• Identified project activities to be completed before transition can start.
• Work as Business analyst for designing overall Cognos reporting requirements.
• Development of reports using report studio in Cognos8 Report Studio.
• Enabled teh Drill through to teh users to view teh more detailed reports.
• Create various types of reports like Master Detail, Cross Tab and Drill Down reports to enable easy analysis. Worked wif end users during teh integration test and production to resolve teh
• Functional and formatting issues.
• Worked as Data Analyst, by gathering requirements related to designing of report and overall functionalities to be included.
• Made changes to teh report based on teh feedback given by teh user.
• Enabled teh users to select their report type Like Date Range, YOY View, MOM View, QOQ wif teh use of conditional variables and Java Scripts.
• Integrated all teh reports in to Single Page.
• Enabled teh user selections at teh run time of report page.
• Optimized teh reports wif teh help of Native SQL, Query Processing Methods.
• Helped users in doing UAT for entire product and also created documentation which would help new Users get acquainted wif teh product.

Confidential

Onsite project coordinator, ETL Developer

Responsibilities:

• Extensively worked on understanding teh business requirements.
• Development & Implementation of Interface, Procedures, Packages, User Functions, Variables in ELT Process using ODI.
• Load Data from Fixed, Delimited files to Confidential and also Extract data from TD tables to flat files.
• Designed Informatica mappings by translating teh business requirements.
• Imported Source/Target Tables from teh respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Worked wif Confidential BTEQ, TPT to run teh scripts in batch mode.
• Worked on UNIX Shell Scripts for copying and moving files to and from server.
• Developing Unit Test case, Tech Specifications.
• Worked on mapping documents provided by client.
• Worked as Data Analyst, by gathering requirements related to designing of report and overall functionalities to be included. Made changes to teh report based on teh feedback given by teh user.
• Team building, like giving training on teh application and new technologies to offshore team.
• Wrote teh Document of understanding and other technical documents including user guides.
• Project Name: ST Paul Travelers, USA