SUMMARY:

• 6+ years of Industry experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Expert in writing SQL queries and optimizing the queries in Oracle, Server 2008 and Teradata.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and FastExport.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Excellent knowledge on Perl & Unix.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica PowerCenter Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Experience in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
• Excellent experience in analysis huge volumes of data in industries such as Finance, Healthcare & Retail.
• Excellent knowledge on creating reports on SAP Business Objects, Webi reports for multiple data providers.
• Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine financial data.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Excellent knowledge on creating DML statements for underlying statements.
• Extensive ETL testing experience using Informatica 8.6.1/8.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Have good exposure on working in offshore/onsite model with ability to understand and/or create functional requirements working with client and also have Good experience in requirement analysis and generating test artifacts from requirements docs.
• Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

PROFESSIONAL EXPERIENCE:

Sr. Data Analyst

Confidential, Richfield, MN

Responsibilities:

• Analyze raw data, draw conclusions & develop recommendations writing SQL scripts to manipulate data for data loads and extracts.
• Participate in defect review meetings with the team members. Work closely with the project manager to record, track, prioritize and close bugs.
• Create all data issue design documents thoroughly and with sufficient logic update;
• Involve with Business Unit SME's, Process Owners, and other groups to get related business rules and information on data in the development of specifications for data cleanup;
• Involve in formulating strategies to manage the data part of the project. Beginning with data checking, data cleaning and working with developers and the business users efficiently to provide quality deliverables.
• Execute Data quality checks in the form of SQL queries to ensure data integrity and enforce business rules.
• Extensively involve with Data cleansing, formatting of the data to correct the mismatch in Staging area.
• Perform User Acceptance Testing (UAT) or both Data and Functionality Issues.
• Identify and address recurring/ root cause issues that can affect Data Integrity.
• Analyzing the huge data from legacy system to new system (SQL) for migration and identified the gaps.
• Gathering the actual requirement from the business and coordinating with business stake holders regarding the table structure.
• Designed and implemented complex SQL queries for QA testing and report/ data validation. Detected defects, reported issues and results to dev and PP team using Issue Tracking tool ITS.
• Involved in scrum process like Grooming, Meeting and reviews for sprint estimates.
• Coordinating with the BA and DEV teams to fix the gaps between businesses, development and implementation phases of the project.
• Perform requirement analysis and document deliverables based on the version control within internal storage.
• Data Migration testing using SQL and checking source and target data integrity.
• Developed daily and weekly status reports.
• Worked on issues with migration of data from development to QA environment. Arranged and attended team meetings with off shore team to meet the project deadlines.
• Performed Data Profiling and extensive data validation.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets. Independently perform complex troubleshooting, root-cause analysis and solution development.
• Worked with Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Created Source to target Data mapping document of input /output attributes with the proper transformations which would help for the easy development of ETL bridge.

Data Analyst

Confidential, Woonsocket, RI

Responsibilities:

• Extensively involved in every phase of the SDLC process starting from Inception to Transition.
• Interviewed Business Users to gather reporting / data requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work.
• Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Created adhoc reports and pivot tables in Excel using VBA and macros.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Analyze the Business Object reports/extracts and submit to the Risk manager after the proper validation.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Worked with business requirements analysts & SMEs to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Performed Data Profiling to assess the risk involved in integrating data for new applications, including the challenges of joins and to track data quality.
• Identified Multiple Dimensions and Fact tables. Used advance data modeling concepts of Degenerated dimension, sub-dimension, Fact less fact table, Aggregate fact tables in Multidimensional model.
• Used advanced dimensional modeling concept Multi Valued Dimensions to resolve many to many relationships using Bridge or associative identity between tables.
• Handled Model Access, Viewing and overall control by restricting access to sensitive data, maintained Model histories, Tracked changes to every modeling object through versions.
• Extensively used Erwin for reverse engineering and hosting according to the business requirements on existing models.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Worked on different data formats, Flat files, SQL files, Databases, XML schema, CSV files.
• Attended JAD sessions with Data Architects to build up subject area specific models. Working with other Data analysts and Info analysts for each subject area.
• Developed on overall project plan and implementation schedule through consultations with project team, management, employees and external consultants.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and ETL loading strategy designing.
• Maintained the Requirements Traceability Matrix (RTM) across the deliverables of a project.
• Supported QA/ETL teams in ensuring proper implementation of the requirements and developed test plans and test scripts for testing and UAT (User Acceptance Testing).

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.1/8.6/7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, Data Stage 8.x.

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite.

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin.

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest.

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server, UDB DB2 9.x, Teradata, MS Access 7.0.

Programming: SQL, PL/SQL, UNIX Shell Scripting, VB Script.

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata SQL Assistant.