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.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• 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.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.
• 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,