SUMMARY

• 6+ years of experience in the Information Technology (IT) Industry serving as a Data Analyst in a Data warehousing environment.
• Working knowledge of Bank, Health, Insurance, Retail and Finance domains.
• Hands on experience on Full life cycle of the project using methodologies like Agile, Waterfall, RUP and hybrid methods.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Chaired and conducted JAD sessions with business and technical teams.
• Expert in analyzing/troubleshooting and providing technical support for Oracle/Unix applications and their interfaces.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Worked extensively in Data consolidation and harmonization
• Experience in Data alignment and Data cleansing.
• Vast experience of working in the area data management including data analysis, gap analysis and data mapping.
• Worked extensively with Dimensional Modeling and Data Migration.
• Experience in Data Transformation, Metadata, Data dictionary, Data Loading, Modeling and Performance Tuning.
• Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Business Objects.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking using ClearQuest.
• Coordinated and prioritized outstanding defects and system requests based on business requirements.
• Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements.
• Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.
• Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures and Functions. Tuning using various types of Partitioning and Indexes.
• Experience in providing Production Batch support.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL

Development Environment: Enterprise Manager, SQL Server Profiler, Query Analyzer, Export & Import

Database: MS SQL Server 2012/2008 R2/2008/2005, MS Access, Oracle 11g/10g

Operating System: Windows Server 2012 R2/2008 R2/2003, Windows 8/7/Vista/XP

Reporting Tools: SQL Server Reporting services (SSRS), Crystal Reports 9/8.5

Database Tools: SSAS, DTS, Management Studio, Resource governor, Data compression, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SQL Server Dashboard, Business Intelligence Development Studio (BIDS), Red Gate, Ideara Diagnostic Manager

ETL Tools: SQL Server Integration Services (SSIS), Informatica 9.x/8.x/7.x, IBM Data Stage 8.x

Designing Tools: Erwin 8.0/7.3, Rational Rose, MS Visio, SharePoint 2010

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Data Analyst

Responsibilities:

• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Analyzed the source data coming from various data sources like Mainframe & Oracle.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Dealt with Oracle Hyperion Financial Management tool for financial consolidation and reporting.
• Worked extensively in Data consolidation and harmonization
• Worked extensively on the SQL Server environment to run out the queries and explore the Databases.
• Defined key facts and dimensions necessary to support the business requirements.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling.
• Made statistical analysis and reports using SAS.
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Flat file conversion from the data warehouse scenario.
• Created Fact and Dimension tables in Mart.

Environment: Windows 2012/2008 Server, SQL Server 2008/2012, Oracle 10g, UNIX, SAS, DB Visualizer, OLAP, MS Office, T-SQL, Informatica Power Center 9.1, PL/SQL, Quality Center, and Putty

Confidential, New York, NY

Data Analyst

Responsibilities:

• Extensively used Informatica Power Center 8.6.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area using Informatica Power Center 8.6.1.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Involved in data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in creating/modifying reports using Business Objects and Web Intelligence.
• Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica Power Center 8.6.1, SQL Server 2008, Oracle 10g, Business Objects XI R2, Web Intelligence 2.5, Oracle, PL/SQL, TOAD, SQL*Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential, Houston, TX

Data Analyst

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Responsible for dimensional modeling of the data warehouse to design the business process.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Loaded the data from IMS files into oracle tables using Informatica with any data cleansing required.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Worked on database connections, SQL Joins, views in Database level.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Used UNIX shell scripting for Scheduling Informatica Workflows.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented procedures/functions in PL/SQL for Stored Procedure Transformations.
• Monitored workflows and collected performance data to maximize the session performance.

Environment: Informatica Power Center 8.6, MS SQL Server 2008, SSIS, Oracle 10g, ERWIN, Windows 2008, DB2, PL/SQL, SQL.

Confidential, San Jose, CA

Data Analyst

Responsibilities:

• Developed Logical and physical database designs for the transaction system.
• Extract the XML file from source transform it with multiple transformation including XML Transformation.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations.
• Used PL/SQL Views, Triggers, Procedures and Functions.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Developed mappings to implement type 2 slowly changing dimensions.
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
• Used various Informatica Error handling technique to debug failed session.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision Used various debugging techniques to debug the mappings.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance.

Environment: Informatica Power Center 8.6, Oracle 9i, SQL Server 2008/2005, SQL, PL/SQL, MS Visio, ERWIN, Toad, Windows 2008, XML, UNIX.

Confidential, Englewood, CO

Data Analyst

Responsibilities:

• Identify business, functional and Technical requirements through meetings and interviews and JAD sessions.
• Define the ETL mapping specification and Design the ETL process to source the data from sources and load it into DWH tables.
• Designed the logical and physical schema for data marts and integrated the legacy system data into data marts.
• Integrate Data stage Metadata to Informatica Metadata and created ETL mappings and workflows.
• Designed mapping and identified and resolved performance bottlenecks in Source to Target, Mappings.
• Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.
• Involved in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL.
• Developed Stored Procedures to test ETL Load per batch and provided performance optimized solution to eliminate duplicate records.
• Involved with the team on ETL design and development best practices.

Environment: Informatica Power Center 7.1.2, Power Exchange, IBM Rational Data Architect, MS SQL Server 2008/2005, PL/SQL, IBM Control Center, TOAD,