SUMMARY:

• Above 7 years of experience working as a Data Analyst/Data Modeler with emphasis on Data Mapping and Data Validation in Data Warehousing Environment.
• Strong Data Warehousing experience using Informatica with extensive experience in designing the Workflows, Work lets, Mappings, configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.x/8.x/7.x/ 6.x.
• Extensive experience in enterprise Data flow analysis, Data modelling and analytics (SSRS, SSAS, SSIS, ETL, MDM, Entity Data Models and data warehousing) incorporating metadata collection techniques to enhance informatics strategies.
• Strong Data warehousing and ETL experience using Informatica Power Center, Informatica MDM 9.6.1, IDQ Developer 9.5.x/8.6.x, Warehouse Designer, Source Analyzer, mapping Designer, Transformation Developer, Mapplet Designer, Mapping Designer.
• Proficient in the phases of SDLC including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Expert in designing Databases (relational, analytical (OLAP), columnar, NO - SQL) and Data modeling (conceptual, logical & physical data models) using Star/Snowflake schema, relational, anchor-fundamental and cubes with tools like Erwin.
• Performed profiling, cleansing, error handling, performance tuning & QA testing using ETL tools like Informatica Power Center and IBM Infosphere
• Extensively worked with Teradata utilities BTEQ, Fast Export, and Multi Load to export and load data to/from different source systems including flat files.
• Experienced with Informatica Data Quality(IDQ) transformations like Address, validator, Parser, Match, Exception, Merge, Standardizer and Human Task
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience in Database Programming SQL & PLSQL, MS Access, Oracle XML, DB2 Teradata, Database Tuning and Query Optimization. Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Expertise in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.
• Strong experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of ETL tools such as Informatica Power Center.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Adept at Business Intelligence Reporting and Visualization including requirements gathering, model creation, reports & dashboard designing, analytics, administration, tuning & optimization using tools like IBM Cognos, Qlikview, Tableau
• Extensively used ETL to load data using Power Center / Power Exchange from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Demonstrated experience in conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g/10g/9i, MS SQL Server, DB2, Teradata, and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Building Data Warehouse/Data Marts using Ascential Datastage 7.5.2/7.5.3 and IBM Infosphere Datastage 8.1.0/8.1.2/8.5
• Expertise in extracting, transforming and loading data between homogeneous and heterogeneous systems like SQL Server, Oracle, DB2, MS Access, Excel, Flat File and etc. using SSIS packages.

TECHNICAL SKILLS:

Data Modelling: Dimensional Data Modelling, Star Schema Modelling, Snowflake Modelling, Physical and Logical Data Modelling

Data Modelling Tools: ERwin 9x/8x/7x, Sybase Power Designer, Oracle Designer, IBM Infosphere.

Data Warehousing: Informatica Power Center 9.x/8.x, Informatica IDQ/MDM.

ETL Tools: SSIS, Informatica Power Center, Informatica IDQ, Informatica DVO

Programming Languages: Java, SAS/SQL, SQL, T-SQL, UNIX, PL/SQL.

Database Tools: Microsoft SQL Server, IBM DB2, Oracle, MS Access, PostgreSQL, Teradata

Reporting Tools: Business Objects, OBIEE, Cognos, Actuate, SSRS, BIRT

Big Data: Hadoop, HDFS 2, Hive, HBase, Sqoop .

Operating Systems: Microsoft Windows 9x /2000/XP/ Vista/7/10 and UNIX.

QA Tools: Quick Test Pro, Load Runner, Quality Center.

Other Tools: MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Microsoft Project, Microsoft Visio, Microsoft Sharepoint

WORK EXPERIENCE:

Confidential

Sr. Data Analyst/ Data Modeler

Springfield, MO

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Performed Data modelling using Erwin, maintaining the database schema.
• Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
• Involved in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs and creation of Process Flow diagrams
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
• Generated various reports and documentation using Report Designer and pinned reports in Erwin.
• Created entity/process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Analyzed data model, wrote business algorithms using stored procedures and queries, and performed proof of concepts for new data architecture.
• Performed users access authorization, definedlocations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Designed different type of STAR schemas using Erwin with various Dimensions like time, services, customers and FACT tables for Claims related project.
• Preparing Dashboards using calculations, parameters in Tableau.
• Conducted design reviews and validated data models and was involved in MDM (Master Data Management).
• Extensively used Toad for SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL Procedures for Informatica mappings for truncating the data in target tables at run time.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Work with business analysts and developers to align the best information architecture strategy with business requirements
• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day Branch Operations as well as Sales and Services.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
• Performed Data Migration where the relational data is extracted from different sources (Flat files / Excel sheets / XML files), transformed and loaded into the target Oracle database without any data loss.
• Created various SQL Schema, Triggers, views, index/keys and stored procedures along with compiling them in SQL server and performed tuning of SQL queries to improve the response time.
• Assisted in designing, development, and architecture of Hadoop clusters and HBase systems.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Authored User reference documents on all the deliverables created for future reference by Business Users and conducted training sessions

Environment: Oracle11g, Erwin9.6, Teradata, SQL, SAS, PL/SQL, Data Mining, MS Office, IDQ, SSRS, Visio, Tableau Desktop 8.x/9.x/10.x, IBM Infosphere, ER Studio, Hadoop, Hive, SSIS, Crystal Reports 14.1.x, MS Project, MS FrontPage 2003, Informatica Power Center 9.5.x

Confidential

Sr. Data Analyst

Pasadena, CA

Responsibilities:

• Enhanced the existing service oriented EDI Facts Metadata Repository system to accommodate metadata for surveys and Business Rule Repository.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Provided ETL design, development and testing estimations based on business requirements and research into data that is currently sourced.
• Wrote PostgreSQL Queries to work with the data, being loaded from external client files into the Data Warehouse.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Extensively worked on different subject areas like Product, Individuals, Accounts, Scores, Billing, Services, Demographics, Call details and summary details.
• Extensively worked with tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
• Involved in developing Data Quality jobs to Investigate, standardize addresses and match with USPS database using IBM InfoSphere Quality Stage.
• Involved in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Developing the ETL mappings for .XML, .CSV, .TXT sources and loading the data from these sources into relational tables with Talend ETL.
• Helped in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS.
• Used Informatica and the Data Warehouse Administration Console (DAC) to configure ETL metadata and run an execution plan to load Oracle E-Business Suite (EBS) data into the OBAW.
• Exposure to LAMP (Linux, Apache, and MySQL & Perl) and WAMP (Windows, Apache, MySQL & Perl) technologies for building web applications as required.
• Provided knowledge transfer and analysis for the TSA Business Intelligence (BI) and Data Warehouse solution transition task to assist in the transfer of TSA government assets inhouse.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Invoved in the integration of various data sources with multiple relational databases like Oracle11g/Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Used ERwin's reverse engineering to connect to existing database and ODS to graphically represent the Entity Relationships.
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle.
• Developed complex mapping to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata.
• Was also involved in development of the data warehouse using OWB and various reports based on the warehouse data using Oracle APEX.
• Developed various ETL jobs based on the business requirements using IBM InfoSphere DataStage.
• Extensive experience in supporting Informatica applications, data extraction from heterogeneous sources using Informatica Power Center.
• Worked on creating dimensional data model in Erwin
• Reverse Engineered databases and then forward engineered them to Teradata using Erwin.
• Creating necessary repositories to handle the metadata in the ETL process.
• Extensive experience in error handling and problem fixing in Informatica.

Environment: Oracle11g, Erwin9.1/9.2/9.5, Teradata, SQL, PL/SQL, Data Mining, MS Office, IDQ, SSRS, Visio, Tableau Desktop 8.2/8.1/8.0, IBM Infosphere, ER Studio, Hadoop, Hive, SSIS, Crystal Reports 14.0.x, MS Project, Informatica Power Center 9.1

Confidential

Data Analyst

San Francisco, CA

Responsibilities:

• Involved in requirement gathering meetings, brainstorming sessions and detailed design meets
• Conducted Gap analysis, developed functionality requirements, and documented the business rules
• Involved in requirement analysis and understanding of business analysis and creating a design work flow
• Analyze data stored in the data warehouse to validate the data integrity and flow into the respective entities
• Provide inputs to development team in performing extraction, transformation and loading for data marts and data warehouses.
• Identified the facts and dimensions using ER Studio Data modeling tool to represent the Star Schema Data Marts.
• Developed a Conceptual/Logical model using ER Studio based on requirements analysis
• Created dimensional model for the reporting system by identifying required dimensions and facts using ER Studio
• Used ER Studio for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Designed the logical data model from the technical design documents and translating to a physical data model using Erwin/ER Studio.
• Gathered reporting requirements from business end users/clients. Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Responsible for Metadata Management, keeping up to date centralized metadata repositories using ERwin modeling tools
• Performed source data analysis and captured metadata, reviewed results with business.
• Designed UML Models and Relational data Models for applications using Rational Rose and Visio. Created DDL scripts for physical implementation of databases of the Physical Data Model.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting services.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Analyzed the data which is using the maximum number of resources and made changes in the back-end code using PL/SQL stored procedures and triggers
• Tuned SQL queries and indexed database tables wherever necessary and partitioned databases

Environment: Oracle 11g, Erwin 7.3.x/8, SQL Server, SAS, ER Studio, Sybase Power Designer, IBM Data Stage, Visio, PL/SQL, Unix, MS Office, MS Visio, Informatica Power Centre 9.0.x/9.1, Hadoop, Data Mining

Confidential

Business Analyst

Baltimore, MD

Responsibilities:

• Conducted JAD sessions with stakeholders, business users at various phases of software Development Life Cycle (SDLC) to discuss and resolve issues.
• Created Business Requirement Document (BRD), Functional Requirements Specification (FRS), and technical requirement specification for application development.
• Involved in collecting the business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Performed Gap Analysis of the processes to identify and validate requirements.
• Involved in planning and defining the system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Interacted with the Subject Matter Experts (SME's) and stakeholders to get a better understanding of client business processes and gather business requirements.
• Used SQL queries for extracting desired data from multiple databases.
• Validated business rules and all artifacts with users, approval and sign off.
• Created test plans, test scenarios, test cases for unit and system.
• Assisted QA team in testing phase by creating Test Plans and Test Cases documents.
• Worked on documentation for end user training and conducted end user training.
• Defined acceptance criteria for the completion of the solution. Created business requirement documents and integrated the requirements and underlying platform functionality.
• Gathered the Clients AS-IS functionality, analyzed to map with Best Practice and designed TO-BE document.
• Involved in generation and execution of SQL queries with the Payroll coordinators to gather the requirements and implement them in the Kronos.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Worked in close proximity with Business users, project stakeholders, Subject Matter Experts (SMEs) and staff to understand high level business requirements and minute level specifications for new applications, and to modify existing applications.
• Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Assisted in the UAT and in the preparation of the Test Plan, Test cases with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.