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 the 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 the various applications to understand the business and process flow.
• Interacting wif the 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 the 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 the KBE’s and verified the 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 the Business Users to analyze the business requirements and transform the business requirements into the 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 the Staging area using Confidential BTEQ scripts.
• Developed new FASTEXPORT scripts to generate the files dat feed the 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 the target Confidential Data Warehouse.
• Used Data Stage stages namely Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Row Generator stages in accomplishing the 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 the report based on the feedback given by the 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 the Business Users to analyze the business requirements and transform the business requirements into the 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 the files dat feed the 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 the target Confidential Data Warehouse.
• Used Data Stage stages namely Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Row Generator stages in accomplishing the ETL Coding.
• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the 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 the technical and business team at client site (Richmond, Virginia) to analyze the Requirements and transform the business requirements into the 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 the development process of the 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 the 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 the report based on the feedback given by the user.
• Team building, like giving training on the application and new technologies to offshore team.
• Wrote the 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 the business requirements.
• Imported Source/Target Tables from the 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 the 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 the report based on the feedback given by the user.
• Team building, like giving training on the application and new technologies to offshore team.
• Wrote the Document of understanding and other technical documents including user guides.

Confidential

Offshore project coordinator, ETL Developer

Responsibilities:

• Extensively worked on understanding the 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 the Jobs in ODI.
• Understanding DB2 procedures and converted into Confidential DDL, DML.
• Used UNIX shell script into ODI Packages.
• Reviewed all the code developed by the 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 the 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 the Drill through to the users to view the 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 the integration test and production to resolve the
• 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 the report based on the feedback given by the user.
• Enabled the users to select their report type Like Date Range, YOY View, MOM View, QOQ wif the use of conditional variables and Java Scripts.
• Integrated all the reports in to Single Page.
• Enabled the user selections at the run time of report page.
• Optimized the reports wif the 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 the product.

Confidential

Onsite project coordinator, ETL Developer

Responsibilities:

• Extensively worked on understanding the 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 the business requirements.
• Imported Source/Target Tables from the 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 the 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 the report based on the feedback given by the user.
• Team building, like giving training on the application and new technologies to offshore team.
• Wrote the Document of understanding and other technical documents including user guides.
• Project Name: ST Paul Travelers, USA