SUMMARY

• Around 6years of experience as a Data Analyst on large data integration and business intelligence projects.
• Experience with Informatica, data conversions, data integrations, data warehousing, and business intelligence architecture.
• Extensive experience in Data integration across various verticals (Health Insurance, Telecom, Retail) using DWBI tools.
• Expert in all phases of Software development life cycle(SDLC) - Requirements, Analysis, Design Documentation, Development, Unit Testing, User Acceptance Testing and Implementation.
• Extensive experience in Information Technology Industry using advanced SQL coding, over various platforms like Teradata, Oracle and SQL server for data mining and report generation.
• Business Requirements review, gap identification, defining business process including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Excellent problem solving ability in query performance tuning and finding issues with resource intensive queries.
• Experienced in creating and maintaining the Requirements definition documents that included Business requirements and Functional requirements
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat files,
• Understanding and interpreting requirement specifications and planning for new upgrades.
• Developed Use Case Models, Activity, Sequence and UML diagrams.
• Expert in troubleshooting/debugging and improving performance Confidential different stages like database,workflows,mapping.
• Intense Knowledge in designing Fact & Dimension Tables, Physical & Logical data models
• Involved in writing Unit test cases for complex scenarios.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

Data warehousing: Informatica PowerCenter 9.X/ 8.6/8.5/8.1/7.1 Data Profiling, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling

Databases: SQL Server 2005, Oracle 11g,10g, My SQL, MS-Access, Teradata

Operating System: HP-UX11/10/9, Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows XP Professional/2000/NT/98/95

Other Tools: MS Visual Source Safe, PVCS, Autosys, Quality center, MS Visio, MS Project

DB Tools: SQL*Plus, PL/SQL Developer, TOAD, SQL Assistant,SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

Data Analyst

Responsibilities:

• Performed analysis of all data into, out of and within company in support of Data Warehousing efforts.
• Identified data issues within the organization and assist in the development plans to resolve data issues.
• Assisted in ETL development, documentation and testing as needed.
• Worked extensively on Erwin and ER Studio in several projects in bothOLAP and OLTPapplications.
• Monitored the quality of data submitted to regulatory agencies.
• Performed numerous SQL Statements to load and extract data to and from database for testing.
• Developed, documented and performed testing and validation as needed.
• Worked with SMEs to develop business rules that support the transformation of data.
• Performed the Back-end testing manually by writing and executing SQL statements on Oracle Source Database and Teradata target.
• Performed in depth analysis of data and facilitated discussions between end users and data moduler as needed.
• Worked with the ETL team during the upload process.
• Written, Queries to retrieve data from ODS to analyse relationships and supported in building the Data Model.
• Written SQL Queries to apply and maintain the Business Rules.

Environment: Teradata, Oracle 11g, Informatica PowerCenter 9.5.1/9.1.2 , UNIX Shell Scripts, Cognos, OBIEE, HP Quality Center.

Confidential, Columbia, MD

Database Analyst

Responsibilities:

• Involved in analyzing the source data coming from different data sources for the Business Intelligence Aggregated Data Store project.
• Performed documentation of business and systems requirements.
• Analyzed incoming claims data entered by Eligible Professionals in PQRS System.
• Created source to target mapping documents from staging area to Data Warehouse/Data Mart.
• Performed numerous SQL Statements to load and extract data to and from database for testing.
• Created multi set, set and volatile tables using Teradata.
• Used SQL within the target Teradata platform.
• Performed the Back-end testing manually by writing and executing SQL statements on Oracle Source Database and Teradata target.
• Performed in depth analysis of data and prepared weekly, biweekly, monthly reports using Ms Exceland SQL.
• Created gap analysis documents.
• Created and modified views within Teradata/Oracle for business analysts.
• Worked with the ETL team during the upload process.
• Performed numerous SQL queries that were highly tuned using concepts like Explain, Stats and CAST.
• Written, Queries to retrieve data from ODS to analyse relationships and supported in building the Data Model.
• Written SQL Queriesto apply and maintain the Business Rules.

Environment: Teradata,Oracle 11g, Informatica Power Center 9.5.1/9.1.2 , UNIX Shell Scripts,Cognos, OBIEE,HP Quality Center.

Confidential, Falls church, VA

Data Analyst

Responsibilities:

• Actively involved in GAP analysis and gathered requirements from Business Analysts, customers and subject matter experts to define the reporting requirements of proposed system.
• Analysed data integration strategies to customize simultaneous analysis of data from new and old environments.
• Worked closely with the development team to verify that business needs are fulfilled and deliverables are produced within specified budget, quality and time
• Export data into MS-Excel and create pivot tables on the resultant data set.
• Extensively used SQL coding to analyse, validate data. Used Toad to validate the data and testing.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous sources and determined the hierarchies in dimensions
• Implemented various integrity constraints for data integrity like referential integrity using primary key and foreign keys relationships
• Tuning of SQL queries for better performance
• Responsible for monitoring all the sessions that are scheduled and involved in debugging the Mappings that failed.
• Performed System Testing, Regression Testing, Acceptance Testing

Environment: SQL Server 2005, Oracle 10g, InformaticaPower Center 9.1/8.6, DB2, UNIX, Autosys