SUMMARY

• Over 9 years of experience in IT as a Business Systems Analyst, Data Modeler, Data Analyst in the Healthcare, Finance, Retail and Telecommunications industry in all stages of the Software Development Life Cycle(SDLC).
• Experienced in Data Warehouse, Database design, SQL, and PL/SQL programming
• Hands on Business System Analysis experience on Full life cycle of the project using methodologies like AGILE, SCRUM Waterfall, RUP and hybrid methods.
• 9+ Years of experience as Business Analyst in Planning, Analyzing, Documenting, Designing and Supporting software application implementations with understanding the architecture, scope and functionality.
• Experience in understanding and supporting both the Business and Technical teams in all Phases of Software Development Life Cycle (SDLC) by using different Methodologies like Iterative, waterfall, agile - scrum and Rational Unified Process (RUP).
• Experience in conducting GAP analysis, Traceability Matrix, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Experience in defining scope and objectives, researching and root-cause analysis; analyzing business and user requirements for complex projects.
• 6+ years Data Modeling experience using Erwin 7.3, ER Studio, Power Designer. Dimensional Modeling, Relational Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data mart, OLTP, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
• Extensively experienced in Data Mining, Data Profiling, Data Quality, Data Cleansing and Data Validation.
• Experience in creating Source to Target mapping documents, gathering business requirements from business/user, creating Process Flows and Data Flow Diagram (DFD). Working directly with ETL team for data extraction, Data Quality (DQ) team for validation.
• Have a good understanding of views, Synonyms, Indexes, Joins, Partitioning, purging, clustered and non-clustered indexes, identifying and non-identifying relationships, super types and sub types.
• Worked in different relational databases environments such as Oracle, SQL Server, DB2 and MS Access.
• Worked with heterogeneous relational databases such as Teradata, Oracle, MS Access and SQL Server.
• Worked with Data Management team for exceptional data handling.
• Hands on experience in testing ETL mappings and Business Object (BO) reports.
• Proficient in all cycles of test life cycle from test planning to defect tracking andmanaging defect lifecycle.
• Interacting regularly with the development team, creative services, database designer, system administrator and the higher management to meet the deadlines of Project milestones.
• Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.

TECHNICAL SKILLS

Business/Data Modeling Tools: MS Visio, MS Excel, Rational Rose, EDimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Erwin r7.2/3/4, Sybase Power Designer.

Databases: Oracle 11g, 10i 9i/8i, SQL Server 2012/2008/20052000 , DB2, Teradata 13.0, MS Access 2007.

ETL: Data stage, Abinitio, Informatica Power Center 8.X/7.x/6.2

Tools: WinSQL, TOAD, Autosys, Teradata SQL Assistant, Clear Quest, HPALM, Rally, Rational Requisite Pro

Environment: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3,Sun Solaris7, WinNT4.0

PROFESSIONAL EXPERIENCE

Confidential, Minnetonka, MN

Sr. Business Systems Analyst

Responsibilities:

• Worked closely with Architects, Technical leads, Project Teams and Participated Business for defining the business Requirements.
• Participated in JAD sessions with stakeholders and to ensure accurate requirements were captured.
• Worked collaboratively with Scrum Team to detail out Features, User Stories and Spikes in preparation for development.
• Worked closely with Scrum team (Product Owner, ETL Developers, Quality Assurance Analysts and others) to ensure requirements and design are completely understood.
• Evaluated design Solutions and Participated in Sprint Review meetings with Scrum Team.
• Involved in gathering business requirements by discussing with SME and Product owner.
• Involved in profiling the data using MySQL for the support of clear understanding of the data.
• Involved in Analysis of data in source and target database by performing SQL Queries. Worked on DML, DDL and Joins.
• Involved in creating Source to Target Mapping Documents.
• Involved in writing Transformation logic for mapping the data from source to Target.
• Performed validation of Source Files.
• Analyzed the JSON files using XML SPY and MS ACCESS.
• Involved in integrating the JSON files to API.
• Worked collaboratively with ETL team and QA team to ensure system deliverables align with business requirements with measurable results.
• Involved in creating Test Data for evaluating in and out boundaries of Testing
• Involved in fixing the defects raised by QA Team.
• Worked closely with ETL team and QA Team for End- to- End Testing.

Environment: Rally, Mainframe, DB2, MySQL, XML Spy, ER Studio, Data Stage, Microsoft outlook 2010, Excel, Visio, Access, SOAPUI, Adobe pdf, DQ Analyzer, Toad, IBM Data Studio, DB Visualizer.

Confidential, Kansas City, MO

Sr. Business Systems Analyst/ Data Analyst

Responsibilities:

• Worked on business requirement Gathering with subject matter experts and product Owners to identify and understand requirements.
• Defined key facts and dimensions necessary to support the business requirements.
• Participated in JAD sessions with stakeholders and to ensure accurate requirements were captured
• Analyzed the source data coming from various data sources like Mainframe & Oracle.
• Created Source layouts for Big data HDFS environment.
• Facilitated project kickoff session with Business and SMEs to understand the requirements which also involved Project Manager, Development Lead, Data Modeler, Data Mapper, Architect etc.
• Responsible for the Analysis, Design and Modeling with Erwin
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements using Erwin.
• Decided the datatype and length of columns by discuss with teams about expected data in that column and this also depends on database platform.
• Created schema objects like Indexes, Views and Sequences.
• Created the relationships and Define parent and child table.
• Created table level and column level constraints and default values
• Created lookup tables if there any columns which need to be described
• Tuning and optimization of SQL Queries
• Performed the data model comparisons between the data models in data mart and the database to find if they are same. Once the data Model is completed, Created Source to target mapping Document
• Review the Source to target mapping document with ETL teams.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Performed Data Validations using SQL developer.
• 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 of new the EDW.

Environment: - Oracle 11g, Erwin 7.3, Excel, Visio, Microsoft outlook 2010, Adobe pdf, DQ Analyzer, SQL Server, Mainframe, DB2, Hadoop, PLSQL Developer.

Confidential, Irving, TX

Sr. Business Systems Analyst/Data Analyst

Responsibilities:

• Conducted JAD sessions with stakeholders and to ensure accurate requirements were captured
• Participated in Daily Standups with the Project Manager, Development Team, QA Team and other Business Analysts
• Accurately and efficiently translated business requirements to high level and atomic level specifications
• Developed and presented conceptual and functional models along with cross-functional process and system dependencies.
• Participated and conducted iteration kick-off meetings to develop a backlog to adequately meet the team’s bandwidth.
• Wrote User Stories to identify business requirements and capture user experience.
• Created Product Backlog Items and prioritized them to help define the scope for each iteration.
• Demonstrated the configurability and functionality of new Item Types to cross functional teams and product owners.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using ER/Studio.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements using ER/studio.
• Created schema objects like Indexes, Views and Sequences
• Involved in dimensional modeling of the data warehouse to design the business process.
• Designed Logical data model and Physical Conceptual data model using ER/studio Data Architect.
• Created the ETL data mapping documents between source systems and the target data warehouse.
• Worked with the OLTP database to generate the DDL.
• Performed 1st, 2nd, 3rd Normal form.
• Data mapping using Business Rules and data transformation logic for ETL purposes.
• Involved in Migrating the data model from one database to oracle database and preparedanoracle staging model.
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Developed ER and Dimensional Models using ER/studio Data Architect advanced features.
• Created physical and logical data models using ER/studio Data Architect.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Worked with Claims data, member’s data and provider’s data.
• Worked with PPOs and HMO care Plans
• Extensive use of SQL for accessing and manipulating database systems and Profiling.
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results for the project team.
• Assisted in the design of report layouts to maximize usability and business relevance.

Environment: ER/Studio, Ab-initio, Oracle 9i/ 10g, DB2 8.0, PL/SQL, MS SQL Server 2008, SQL Developer, Toad, Talend, IBM Rational clear quest, Clear case, Cute PDF.

Confidential, Chicago, IL

Data Modeler/Data Analyst

Responsibilities:

• Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design.
• Conducted requirement gathering and Business Analysis to build a large analysis warehouse.
• Performed Data Analysis to primarily identify Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Created logical & physical data models and Meta Data to support the requirements
• Analyzes requirements to develop design concept and technical approaches
• Find the business requirements by verifying Manual Reports.
• Worked with POS for sales, transactions, quantity of sale.
• Worked with labor tracker team to find labor time and salaries and no of labor hours.
• Worked with different retail departments to find projected values, exact values of salaries, sales.
• Conversion of manual reports to automated documents.
• Worked with OLTP to find the daily transactions and type of transactions occurred and the amount of resource used.
• Preparation of Data Dictionary/Meta Data of the data elements.
• Walked through the Logical Data Models of all source systems for data quality analysis
• Created the ETL data mapping documents between source systems and the target data warehouse.
• Facilitated project kickoff session with Business and SMEs to understand the requirements which also involved Project Manager, Development Lead, Data Modeler, Data Mapper, Architect etc.
• Developed and designed Data marts extensively using Star Schema.
• Identifies impact of existing models with respect to new BI framework
• Designs conceptual and logical models for the data warehouse or data marts to support BI reporting repository
• Assist in creating source to target mappings from reporting data sources to Data Warehouse
• Defining facts and dimensions for Analytic reports for Data Marts
• Defining data mappings for the Data Marts
• Analyzing existing data sources and reports

ENVIRONMENT: - Erwin 3.5.2, Teradata, DB2, Oracle 9i, SQL Server 2008, Teradata, sql assistant, Unix, SSRS, Micro strategy, Data stage, Microsoft Excel, Windows XP.

Confidential, Grand Rapids, MI

Business Systems Analyst

Responsibilities:

• Participated in Sprint Planning sessions to transition user stories over to developers
• Used user stories approach for describing the requirements using the user story template.
• Reviewed user stories with business users and got their approval
• Worked closely with business users to prioritize and scope out the Product Backlog Items (PBI) based on priority and bandwidth
• Gathered requirements and created Use Cases, Use Case Diagrams, and Activity Diagrams using MS Visio.
• Prepare business flow diagrams and define the workflows.
• Facilitated project kickoff session with Business and SMEs to understand the requirements which also involved Project Manager, Development Lead, Data Modeler, Data Mapper, Architect etc.
• Responsible for the Analysis, Design and Modeling with Erwin
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements using Erwin.
• Provided production support by monitoring the processes running daily.
• Created schema objects like Indexes, Views and Sequences
• Performed data analysis of the source data coming from third party sources.
• Involved in dimensional modeling of the data warehouse to design the business process.
• Designed Logical data model and Physical Conceptual data model using Erwin.
• Tuning and optimization of SQL Queries
• Performed the data model comparisons between the data models in data mart and the database to find if they are in sink.
• Data mapping using Business Rules and data transformation logic for ETL purposes.
• Created the ETL data mapping documents (STM) between source systems and the target data warehouse.
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Developed ER and Dimensional Models using Erwin advanced features.
• Created physical and logical data models using Erwin.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Assisted in the design of report layouts to maximize usability and business relevance.
• Environment: Erwin Data modeler r8, Informatica 9.1, Informatica data explorer 9.1 Oracle 9i/ 10g, DB2 8.0, PL/SQL, MS SQL Server 2000, SQL server management studio, toad 10.1, MDM, IBM Rational clear quest, Clear case, Cute PDF.

Confidential

Data Analyst

Responsibilities:

• Responsible for the Analysis, Design and Modeling.
• Worked with the Microsoft office tools for mapping and multiple other purposes.
• Monitored the CA calls using nice calls to schedule the work and find scheduled hours for the resources to work on it.
• Created events and tasks in the work flows using workflow manager.
• Created schema objects like Indexes, Views and Sequences
• Involved in dimensional modeling of the data warehouse to design the business process.
• Designed Logical data model and Physical Conceptual data model using ER/studio Data Architect.
• Created the ETL data mapping documents between source systems and the target data warehouse.
• Worked with the OLTP database to generate the DDL.
• Data mapping using Business Rules and data transformation logic for ETL purposes.
• Involved in Migrating the data model from one database to oracle database and preparedanoracle staging model.
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Assisted in the design of report layouts to maximize usability and business relevance.

Environment: Erwin 3.5.2, Informatica Power Center 4.7/1.7, UNIX Shell Scripting, PL/SQL, XML, Oracle 8i, DB2, Shell Scripting, Visio, SQL developer, MS SQL Server 2000.