SUMMARY

• Around 7 years of experience in the IT Industry serving as a Data Analyst in a Data warehousing environment.
• Working knowledge of Bank, Health, Insurance, Telecom and Finance domains.
• Hands on experience on Software Development Life Cycle (SDLC) of the project using methodologies like Waterfall, Agile, 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.
• Extensive experience on Business Intelligence (and BI technologies) tools such as OLAP, data warehousing, reporting and querying tools, data mining and spreadsheets.
• 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, Reporting and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Extensive experience on collaborating with SME's to define data standards, Business data definitions, Business rules, Critical Business information, Master Data, Data Quality and ETL creation and updating processes.
• 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 SSRS and SAP 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.
• Experience with developing Hyperion Financial reports and Tableau Desktop.
• 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.
• 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

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

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

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau, Hyperion, Tableau, SAP Crystal Reports

ETL Tools: SQL Server Integration Services (SSIS)Informatica 9.5/8.6/7.1

Designing Tools: ERwin 9/8/7, Rational Rose, MS Visio, SharePoint 2010

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, MN

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 MS SQL environment to run out the queries and explore the databases and feed date for Tableau reporting.
• 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 2008 Server, Mainframe, MS SQL Server 2012/2008, UNIX, SAS, OLAP, MS Office, Tableau, T-SQL Queries, Informatica 9.5, PL/SQL

Confidential, Plano, TX

Data Analyst

Responsibilities:

• Extensively used Informatica 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. Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources to targets mappings and sessions to improve the performance of data load.
• Assessed and developed strategic Data Governance goals, Data Quality Assurance processes, Master Data Management administration.
• Designed Logical and Physical Modeling using ERwin Data Modeler tool.
• Did 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 Hyperion and Tableau Reporting Tools.

Environment: Informatica 8.6, Oracle 11g, Business Objects XI 3.1, PL/SQL, Hyperion, Tableau, SQL Plus, Erwin 8, Windows, UNIX, Control M.

Confidential, Detroit, MI

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 Informatica 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 7.1, MS SQL Server 2008, SSIS, SASS, Oracle 10g, ERwin 7, Windows 2003, IBM DB2, PL/SQL, SQL.

Confidential, Scottsdale, AZ

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 7.1, Oracle 9i, SQL Server 2005, PL/SQL, Mainframe DB2, MS Visio, ERwin 7, TOAD 8.0, Windows XP, XML, UNIX.

Confidential, Dallas, TX

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 data from sources and load it into Data Warehouse 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 7.1, Power Exchange, IBM Rational Data Architect, MS SQL Server 2005, PL/SQL, IBM Control Center, TOAD, MS Project Plan