SUMMARY

• 71/2 years of IT experience in teh field of Data/ Business analysis, ETL Development, Data Modeling, Testing and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, Metadata Management Services and Configuration Management.
• Expertise in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using CA Erwin, Oracle, SQL Developer, SQL Server Management studio, My SQL, SQL Plus.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Good Knowledge in Business Intelligence tools like Business Objects, SAS, R, SPSS and Cognos.
• Extensively used complete knowledge ofdatawarehouse methodologies (Ralph Kimball, Bill Inmon), ODS, EDW, OLAP concepts and Metadata repository.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Designed, developed and supported ETL mappings and scripts for data marts using Informatica power center and Talend.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Extensive experience in visualizing teh design of teh system by UML, Class diagrams, ER Diagrams and web page mock-ups.
• Expert in excel 2007/2010/2013 and its features like pivot tables, charts, functions like VlookUP, HlookUP, Solver, Goal Seek and Data analysis etc.
• Experience in building Data Warehouses/Data Marts using different ETL tools.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings.
• Experience in analyzing teh data using different analytical tools combining together to work on same data set to produce teh optimized results.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to teh customer and feasible for teh developers and to limit a project’s exposure to teh forces of change.
• Solid experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Experience in integration of various data sources like Oracle, SQL server and MS access and non-relational sources like flat files into staging area.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), AGILE and Waterfall Methodologies.
• Comprehensive knowledge and experience in process improvement, data extraction, data cleansing for analysis, data manipulation and data quality testing for gaps.
• Worked on different platforms such as Windows/98/NT/07/08 and UNIX.
• Implemented Optimization techniques for better performance on teh ETL side and also on teh database side.
• Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.
• Experience in creating functional/technical specifications, data design documents based on teh requirements.
• Worked on different databases including Oracle, SQL server and Teradata.

TECHNICAL SKILLS

Data Modeling Tools: CA Erwin 9/8/7.1/4.5/4.0 , UML, Rational Rose, MS Visio 2010

Data Analytics Tools: SAS 9.4/9.3/e-miner, R, R Studio, SPSS and Tableau

Reporting Tools: SQL Server 2005/2008 Reporting Services, Oracle Reports, MS Excel, Business Objects, Micro Strategy

Project Management: MS Office Suite, MS Project, Clarity

Databases& Tools: Oracle, MySQL, MS Access, MS SQL Server 2005/08/12/14

Methodologies: Agile, SDLC, Waterfall

ETL Tools: SQL Server 2005/2008 Integration Services, Talend and Informatica Power Center8.1/9.1

Languages: SQL, PL/SQL, Visual Basic, C++ and Java

Operating Systems: Windows (2000, NT, XP, VISTA, 7, 8, 10) and Linux

Others: Rational Requisite Pro, MS Office, HP Quality Center, Pulse, Clear Case

PROFESSIONAL EXPERIENCE

Sr Data Modeler/Analyst

Confidential, San Antonio, TX

Responsibilities:

• Involved in data analysis and creating data mapping documents to capture source to target transformation rules.
• Worked with business users to gather requirements and create data flow, process flows and functional specification documents.
• Created Talend Mappings to populate teh data into Staging, Dimension and Fact tables.
• Used Erwin and Visio to create 3NF and dimensional data models and published to teh business users and ETL / BI teams.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Worked on ODBC Data Connections to SQL Server database and a Datacard 9000 machine.
• Developed Word forms using VBA to conduct various surveys in order to optimize monthly report based on team usage.
• Involved in Data mapping specifications to create and execute detailed system test plans. Teh data mapping specifies wat data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Worked on creating role-playing dimensions, fact less Fact, snow flake and star schemas.
• Analyzed functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Transformed data to various sources using SQL Server Integration Services andTalendOpen Studio.
• Worked on extracting data from teh hadoop distributed file system into Microsoft excel using power query.
• Worked on ensightenfor enterprise data and tag management.
• Prepared Test cases based on Technical Specification document.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and teh Target Data.
• Involved in teh validation of teh OLAP Unit testing and System Testing of teh OLAP Report Functionality and data displayed in teh reports.
• Implemented Slowly Changing Dimensions - Type me & II in Dimension tables as per teh requirements.
• Responsible for Performance Tuning at Talend level and SQL queries level.
• Responsible for testing all new and existing ETL data warehouse components.
• All Mappings & workflows succeeded in Testing Environment move from Development to Production Environment.
• Performed Verification, Validation, and Transformations on teh Input data (Text files, XML files) before loading into target database.
• Interacted with functional analysts to understand requirements and write high-level test scripts.
• Reviewed ERD dimensional model diagrams to understand teh relationships and cardinalities to halp in preparation of integrity test cases.
• Written test cases for data extraction, data transformation, and reporting.
• Responsible for Testing Schemas, Joins, Data types and column values among source systems, Staging and Data mart.
• Analyzed teh objectives and scope of each stage of testing process from teh Test plan.
• Interacted with business analysts to gather teh requirements for business and performance testing.
• Reporting tools, query tools, extraction and cleansing tools, transformation tools Using Metadata.
• Responsible for performing teh data validation, process flow, dependency, Functionality Testing and User Acceptance Testing.
• Extensively used Quality Center to prepare test cases, execution of test cases and bug tracking.

Environment: Erwin 4.5/4.0, Informatica Power Center 8.1/9.1, ODBC, Power Connect/ Power exchange, Oracle 11g, MES, Reference Data, MS SQL Server 2008 R2, SQL, PL/SQL, XML, Metadata, Windows NT 4.0, Power Query, Talend, Unix Shell Scripting.

Senior Data Modeler/Analyst

Confidential, Charlotte, NC

Responsibilities:

• Conducted meetings with teh end users and performed interviews to gather teh requirements from them and to convert those requirements into Requirements document for teh development and testing teams.
• Analyzed teh business requirements to get a thorough understanding of teh testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of teh requirements during testing.
• Designed Logical/Physical and Conceptual models of database using CA Erwin and MS Visio.
• Did extensive reverse engineering of databases using ERwin.
• Worked with teh developers to understand teh ERD (Entity Relationship Diagram) and thus create comprehensive test plans, following teh RUP model, for teh applications and also gather test data for teh data driven test cases.
• Worked extensively on BI (SSIS) Packages for extracting teh data of teh customers from OLTP, transform dat data and load it into teh OLAP.
• Extensively involved in using BI tools like Import and Export Wizard for developing teh packages.
• Wrote SAS programs to convert client data into standardized format and produced statistical reports.
• Executed SAS macros against client data to produce value added data and reporting.
• Provided teh sequence and flow diagrams for various modules in teh project using Rational Rose.
• Created solid DSS databases for Reporting.
• Participated in weekly review meetings to report teh documented test metrics and defects found in teh System. Closed bug reports once they are resolved and verified.
• Involved in Training and Documentation of teh complete project.
• Involved in Data mapping specifications to create and execute detailed system test plans. Teh data mapping specifies wat data will be extracted from sources.
• Gather requirements and design of data warehouse and data mart entities.
• Used SQL to perform data analysis, data profiling and generating reports.
• Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
• Worked with business people, data stewards, SMEs as a part of data model designing and source to target mapping document creation.
• Identified opportunities for business process improvement and initiated efforts to make improvements.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
• Worked with Data Quality and ETL teams as part of my job responsibilities.

Environment: CA Erwin, SAS, MS VISIO, SQL Server 2008, Microsoft Word, Excel, PowerPoint, SSAS, SSRS and SSIS.

Data Modeler/Analyst

Confidential, Overland Park, KS

Responsibilities:

• Designed & Created Test Cases based on teh Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document)
• Involved in extensive Data validation using SQL queries and back-end testing
• Extensively used CA Erwin in Creating Conceptual, Logical and Physical data models.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Experienced in Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Managed and reviewed Hadoop log files.
• Involved analysis of a variety of source system data, coordination with subject matter experts, development of standardized business names and definitions, construction of a non-relational data model using Erwin modeling tool, publishing of a data dictionary, review of teh model and dictionary with subject matter experts and generation of data definition language.
• Managed all software development processes involving requirements management, workflow analysis, source Data Analysis, data mapping, metadata management, data quality, testing strategy and maintenance of teh model.
• Worked on level understanding of using different databases in combinations for Data extraction and loading, joining data extracted from different databases and loading to a specific database.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data
• Created end-to-end security architecture solution from sources system, warehouse till consumer layers like web portals, BI reports.
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, TOAD, MS Access, MS Excel and SQL.
• Worked on Naming standards for Table/Column/Index/Constraints names thru Erwin Macros and Master Abbreviations file.
• Written SQL scripts to test teh mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Performed Data Reconciliation between integrated systems, Involved in extensive Data Validation with SQL queries, Involved in Regression testing and Investigation of Data Quality issues.
• Worked on Physical design for both SMP and MPP RDBMS, with understanding of RDMBS scaling features
• Extensively used agile methodology as teh Organization Standard to implement teh data Models.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6/9.1/9.5, SSIS, Oracle 11G, Teradata SQL Assistant, CA ERWIN 7.2, Subversion, MS-Office, Oracle 10g, 11g RAC, SQL Server 2008/2012, SQL PLUS, PL/SQL

Data Analyst

Confidential, Washington, DC

Responsibilities:

• Participated in meetings with stakeholders, business managers, users to understand anddocument business requirementsandfunctional specificationsfor theWorkflow.
• Took sessions for teh teammates and partners on Pega systems Smart BPM & PEGA Scrum Methodology.
• Documented detailBusiness Process Designand created Use Cases.
• Extensively usedMS SharePointforversion control. Uploaded files and maintained folders in Share Point.
• Developed Conceptual, Logical and Physical data models for teh database using CA Erwin and MS Visio.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Created Business Rules Spread Sheet (BRS) as needed and Requirement Traceability Matrix (RTM) to track teh requirements and link it to teh test cases.
• Responsible to determine theGAP Analysisbetween theAs-Is / To-BeBusiness Process Flows.
• As a Project Team Defect Coordinator, responsible for Managing teh Defect process for teh project and ensuring Traceability to Requirements and Test Cases.
• Defect coordination involved working with teh Project Managers, Development, System and UAT testing teams to ensure defects are addressed, managed and closed as appropriate.
• Conducted meeting between teh business, development and testing teams to resolve defects in Triage.
• Updated defects "real-time" in Defect Action board meetings.
• Worked with testing team on submitting defects in HP Quality Center.
• Provided first-level Test Tool support for Quality Center; and perform additional duties processing Change Requests, and other tasks as required.

Environment: Windows XP, CA Erwin 7.0, MS Visio, Clear Quest, Requisite Pro, SharePoint, SQL, HTML, XML.

Data Analyst

Confidential

Responsibilities:

• Participated in user meetings and gatheird requirements from them. Identified high-level requirements for developing and documenting detailed business requirements
• Prepared use case document with all possible cases along with test cases document.
• Analyze business and system requirements, mange development of specifications to create detailed test plans, and verify bug fixes.
• Involved in meetings with SME (subject matter experts) and users for requirements gathering.
• Revised and updated teh technical feasibility documents and created sequence diagrams.
• Utilized RUP (Rational Unified Process) to create use cases, activity, class diagrams and workflow process diagrams.
• Extensive development providing data integrated solutions using VB 5.0.
• Responsible for providing database solutions using MS Access/ SQL Server/ Oracle database.
• Proficiently used T-SQL/ PL/SQL in creating tables, views, triggers, stored procedures.
• Written queries for stored procedures, clustered and non-clustered indexes, Unique/Check Constraints, Views and triggers.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Created reports using Crystal Reports and Oracle Forms/Report.
• Provided technical/Functional support to end-user.
• Managed Internal Project Management Services and Internal Quality Management Services and conducted Internal and external audits for enhancements.

Environment: MS SQL Server 2000, Oracle 8.0/9.0, Visual Basic 5.0, TSQL, PLSQL, Windows NT /2000

Data Analyst

Confidential

Responsibilities:

• Interacted with teh stakeholders to get a better understanding of client business processes and gather business requirements.
• Identified Use cases from teh requirements and wrote Use Case Specifications.
• Worked with corporate and field executives to manage teh expectations of teh project and put out fires as changes and new business requirements came up.
• Incorporated best industry practices and worked with teh project manager on getting deliverables out under budget and ahead of schedule.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Created Use-Cases and Business Use-Case Model after accessing teh status and scope of teh project and understanding teh business processes.
• Conducted informal Sessions to develop an architectural solution dat teh application meets teh business requirements, resolve open issues, and change requests.
• Conducted user interviews and tracked client expectations.
• Involved in reviewing business requirements and analyzingdatasources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects.
• Document and publish test results, troubleshoot and escalate issues.
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with teh dependencies
• Functionality testing of email notification in ETL job failures, abort ordataissue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of teh product and schedule
• Created and executed test cases for ETL jobs to upload masterdatato repository.
• Responsible to understand and train others on teh enhancements or new features developed.
• Created and execute test scripts, cases, and scenarios dat will determine optimal system performance according to specifications.

Environment: Oracle 8i, SQL, Crystal Reports, HP Quality Center, MS Word, MS Power point, MS Excel.