SUMMARY:

• Data analysis professional with 9+ years of total IT experience and expertise in business analysis for data warehouse/data mart development, SQL and analysis of Online transactional Processing(OLTP), data warehouse (OLAP) and business Intelligence (BI) applications.
• Proficient in all phases of the Software Development Lifecycle (SDC).
• Excellent skills in forming and facilitating Joint Application Design (JAD) for eliciting data requirements that support the business requirements and documenting data flows.
• Worked on Canonical data modeling to create logical and physical data models.
• Experience in writing Business Requirements Document (BRD), Functional Requirements Document (FRD), Request for Proposals (RFP), Statement of Work (SOW) and Standard Operating Procedures (SOP)
• Expertise in Object - Oriented Design using UML to implement Use Case Model, Analysis Model, Design Model, Implementation Model, Use case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, and Activity diagrams), and Class Diagrams using Rational Rose and MS Visio
• Familiarity working on SOA standards and trends.
• Immense Experience in Customer Interaction, Collecting and Handling Customer Requirements.
• Worked on MS Access Reporting .
• Familiarity working on XML Schemas.
• Experience working on Jira.
• Extensively used Tableau for reporting and views.
• Experience working on Power BI dashboard & BI reports
• Coherent with Normalization/Denormalization techniques in relational/dimensional environments and have performed normalizations up to 3NF (Third Normal Form).
• Competent knowledge in Data Modeling tools like ERWIN, IBM Rational Software Architect (RSA) and Embarcadero ER/Studio.
• Experienced as both an onsite and offshore project member.
• Well versed in Forward and Reverse Engineering principles.
• Experience working on Medicare and Medicaid projects.
• Experience working on data flow from source systems to Operational data stage.
• Experience working on Agile, Kanban and Scrum methodologies.
• Conversant in oracle tools and utilities like Toad, SQL PLUS, SQL Developer.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
• Created data mappings to load data from target using different transformations and executed workflows for data loads to target systems.
• Experience coordinating between business and technical areas to achieve high - quality delivery of multiple complex development projects in a fast - paced, dynamic environment through successful planning, tracking and management techniques to deliver on - time and develops risk mitigation strategies.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME’s to obtain domain level information of projects.
• Good understanding of Ralph Kimball’s and Bill Inmon’s modeling techniques.
• Well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle. Quick starter with ability to master and apply new concepts. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Working knowledge on Release management and Change management.

TECHNICAL SKILLS

Data Modeling Tools: IBM IDA Data Architect 7.1, ERWIN 9.1/ 8.2/7.3/7.0, ER studio. Reporting Tools SAS, SAS BI, WEB REPORT STUDIO, ENTERPRISE GUIDE, Business Objects, Business Intelligence, SSRS ETL Tools Informatica 8x,9x,SSIS PLSQL Datastage Languages SQL, SAS, SAS BI,VISUAL ANALYTICS,OLAP CUBE, HTML JAVA Databases Oracle11g/10g MS SQL Server2005/2008, MS Access, Teradata,DB2 Hadoop Operating Systems Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Tech BA/ Product Owner (Merchandising)

Responsibilities:

• Kohls, is a retail client headquartered in Milwaukee, Wisconsin.to be the most engaging retailer in America . Project scope involves most of the projects in migration of data from Oracle DB to Mongo DB on Cloud, data conversion, data mapping, backfeedprocess.Develop technical workflows using Lucidchart for new changes in Webservices and API’s in Json format, SQL querying using Hive databases .
• Roles&Responsibilities:
• Interacted with the business users (SME) on regular basis to consolidate and analyze the requirements for Data Migration.
• Developed and ensured the user stories comply with the requirements criteria, have sufficient business value and selling points
• Analyzed and incorporated the Business requirements from SME’s, End Users and produced the high-Level Design, functional Requirements documents
• Managed multiple Data related companion projects in Google cloud platform (GCP), EDW, Informatica environment.
• Responsible for reviewing QA validation signoffs and product signoffs.
• Reviewed JIRA stories, Acceptance criteria, organized grooming sessions to offshore team (Future Sprint & Backlog grooming) and prioritize user stories.
• Worked on performing Gap analysis for different business use case scenarios across different source systems
• Facilitated scrum ceremonies (User Stories grooming, sprint planning, retrospectives, daily stand-ups, review sprint backlog, updated burn down chart at the end of each iteration
• Documenting the Sprint metrics utilized by the team members to complete Sprint cycles
• Worked with end users understanding and eliciting business requirements.
• Write Functional Requirements Documents, participate in document reviews with business users and Development teams
• Working on Agile/Scrum methodology and propose innovative solutions based on analysis.
• Worked with the team to ensure Change management and Deployment Plan is being coordinated.
• Worked on creating DR plan and SD knowledge Transfer documentation
• Identify change of request from business and coordinate with development and QA teams.
• Develop business architecture using requirements such as scope, processes, risks
• Led the Scrum meetings with the Product Owners, Development Team as the Scrum Master. Ensured the user stories comply with the requirements criteria, have sufficient business value and selling points. Each story should show value to the Users, Customers, and Stakeholders.

Confidential

Tech BA/Product Owner (Merchandising)

Roles&Responsibilities:

• Interacted with the business users (SME) on regular basis to consolidate and analyze the requirements for Data Migration.
• Worked on a specific Subject area/Business area of the enterprise, related to Sales transactions of customers .
• Worked on conversion process of data, which is stored in flat files into SQL tables.
• Managed multiple Data related companion projects in Google cloud platform (GCP), EDW, Informatica environment.
• Created requirement documents and performed gap analysis on the existing and to - be approach .
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Worked on creating Jira stories for migrating data from Big data Hadoop environment to Google Cloud Platform(GCP)
• Produced the current state (“as is”) and proposed solution (“to be”) flow diagrams as part of functional design. Proof of Concept (POC) and business requirements developed UML diagrams (Activity, Use Cases, Sequence), process and data flow diagrams use cases, created the data mapping, impact and gap analysis for the data conversion.
• Worked on organizing the working sessions with users to validate Test Results in Prod environment
• Worked with the end users to ensure UAT approvals
• Collaborated in gathering of business requirements (BRD) with stakeholders, SME’s from inception to document approvals, collaborated in with key business users to analyze and scope out business need.
• Facilitated scrum ceremonies (User Stories grooming, sprint planning, retrospectives, daily stand-ups, review sprint backlog, updated burn down chart at the end of each iteration).
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise.
• Produced detailed functional design specifications, Proof of Concept (POC) and business requirements
• Developed UML diagrams, Incorporated XML/XSD schemas specifications as part of the high-level design document.
• Worked on Power BI reporting tool for interactive dashboards and BI reporting requirements
• Supported QAT and UAT efforts, collaborated in reviewing and approving test plans and test objectives and testing activities to resolve any anomalies.
• Led the Scrum meetings with the Product Owners, Development Team as the Scrum Master. Ensured the user stories comply with the requirements criteria, have sufficient business value and selling points. Each story should show value to the Users, Customers, and Stakeholders.
• Worked closely with design architects and operations teams to obtain requirement sign-off
• Created Use Cases and Process Flow diagrams using MS Visio
• Developed As-Is and To-Be flowcharts and wrote business requirements and technical requirements. Managed development team by working with them to review business needs and monitor progress based on project schedule.
• Extracted data from various data stores utilizing criteria based on client requirements
• Developed and ensured the user stories comply with the requirements criteria, have sufficient business value and selling points
• Analyzed and incorporated the Business requirements from SME’s, End Users and produced the high-Level Design, functional Requirements documents
• Reviewed JIRA stories, Acceptance criteria, organized grooming sessions to offshore team (Future Sprint & Backlog grooming) and prioritize user stories.
• Orchestrated meeting with Business and stakeholders to identify the scope and define KPI
• Responsible for managing project progress and roadmaps, identify risk, risk mitigation factors and address technical issues and infrastructure.
• Responsible for reviewing QA validation signoffs and product signoffs.
• Managed multiple projects across cross functional teams for designing and developing marketing reports.
• Coordinated with global /cross functional teams regarding release schedules and system dependencies with Deployment cycles.

Confidential, Columbus, Ohio

Business Analyst

Roles & Responsibilities:

• Interacted with the business users (SME) on regular basis to consolidate and analyze the requirements for Actuarial Modernization.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis, Involved in multiple projects with different business units. .
• Defined project scope, objectives, staffing, resources and deliverables for Data Migration from Oracle Systems and implemented Data quality and Data governance Project.
• Developed and initiated internal process to improve project management program delivery.
• Acted as primary day-to-day point of contact for the client and the operational aspects of the project.
• Reported metrics, analyzed data and assessed service management performance for senior leadership and the customer as well as recommend improvements.
• Performed risk management and managed scope creep for issue related to the projects as well as any new requirements being introduced.
• Participated in the ongoing corporate business requirements to ensure continuous alignment with the IT roadmap and maximized the efficiencies of the processes.
• Conducted and participated in JAD Sessions periodically with various Subject Matter Experts at various phases of the Software Development Life Cycle to discuss open issues and resolve them.
• Made a Gap Analysis and assisted the development team to understand the To-Be process.
• Created documents like the Business Glossary to facilitate the other teams in understanding client business.
• Approved changes, reviewing open issues and communicating essential information.
• Logged issues in JIRA and monitored resolution to completion.
• Involved in successful releases of the product until it went live.
• Worked on creating Gap analysis for different business use case scenarios across different source systems related to Hedging process for Policy.
• Worked on analyzing the Error Logic Check documents and documented the transformation logic across different source systems.

Confidential, Mason,Ohio

Data Analyst

Roles &Responsibilities:

• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form.
• Designed the data marts in dimensional data modeling using star and snowflake schemas
• Worked on creating DataVault approach for Billing and Settlement domains for acquiring customers of the company
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Worked on creating Business requirement documents for Credit card payment process for Merchant, Retail, Mortgage institutions and Banks.
• Worked on creating Data models, like forward engineering data models to load new EDW Oracle Exadata
• Worked on Hadoop interface layer for data transformation through MapReduce, Hive, Pig, Impala,
• Performed GAP analysis ensuring business compliance and Risk
• Worked with end users understanding and eliciting business requirements.
• Worked on Jira to create Epics ad user stories as per the project scope and priority
• Worked with various client groups as a project support and coordinator to ensure deliverables are, estimated and prioritized timely.
• Work cooperatively with BI Solutions Architects and developers during the development life cycle to ensure that business requirements guide the development life cycle.
• Write Functional Requirements Documents, participate in document reviews with business users and Development teams
• Working on Agile/Scrum methodology and propose innovative solutions based on analysis.
• Identify change of request from business and coordinate with development and QA teams.
• Develop business architecture using requirements such as scope, processes, risks
• Creation of business-process model diagrams, flows & requirements using MS Visio
• Familiarity with Workday, financial management software solutions.
• Developed ETL routines using PL/SQL and Data stage to plan an effective package development process, and design the control flow within the packages
• Worked on migrating data from source systems to ODS layers
• Worked on creating Reports in MS-Access, forms and writing queries.
• Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables
• Extracted data from databases Oracle, SQL server and DB2 using PL/SQL to load it into a single repository for Data analysis.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models
• Worked on Agile and scrum methodologies.
• Compare data with original source documents and validate Data accuracy.

Confidential, Dayton Ohio

Sr. Business Analyst/Data Analyst

Responsibilities:

• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form
• Worked on creating Business requirement documents and functional requirement documents for Different Use cases.
• Worked on migrating data from source system to ODS Layer.
• Worked on Medicare and Ohio Medicaid Projects
• Worked on Tableau views for reporting.
• Worked on Canonical data model using XML pattern structure for creating physical data models from logical data models
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Experience working on different Claim types like Rx, (Pharmacy Preferred, and NonPreferred) Dental, Medical, Hospital claims.
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Worked on different data models for Claims, Members and Providers for different claim types, for different Health Partner Incentive programs.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Worked on Semantic layer data model for different phases of data warehouse cycle.
• Worked on creating corporate data models, using graphical representation to source and integrate the different claim types.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Worked on Agile and Scrum methodologies.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked on Redshift for data analysis of datawarehouse and query performances
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic
• Worked on stored procedures for processing business logic in the database.
• Worked on MS Access for reporting, development and database modification.
• Performance query tuning to improve the performance along with index maintenance.
• Worked on the reporting requirements for the data warehouse.
• Worked on Jira for issue tracking.
• Created support documentation and worked closely with production support and testing team. Environment: ERWIN 8.2, Oracle 11g, Crystal Reports, Toad, Windows OS, DB2, Teradata, SSRS, SQL

Confidential

Sr.Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form.
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic
• Integrated data from various Data sources like MS SQL Server, DB2, Teradata using Informatica to perform Extraction, Transformation, loading (ETL processes).
• Developed mappings, sessions and batches for relational & flat file sources and targets. Loaded data into target database from sources using Workflow Manager.
• Worked on stored procedures for processing business logic in the database.
• Performance query tuning to improve the performance along with index maintenance.
• Worked on the reporting requirements for the data warehouse.
• Created support documentation and worked closely with production support and testing team. Environment: ERWIN 8.2, Oracle 11g, Crystal Reports, Toad, Windows OS, DB2, Teradata, SSRS, Business objects, SQL Server 2008

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Extensive analysis to find the issues present in the existing financial planning sources. Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community
• Analyzed on what enhancements needed on the source systems.
• Designed new financial planning data mart to make the data available in the required format.
• Had working sessions with finance users to understand the grain for each subject area.
• Worked with business users to validate the reference data.
• Created detailed data specifications document which is a source for ETL team.
• Supported ETL team in understanding rules for loading data into data mart.
• Wrote SQL prototypes against new strategic sources to confirm the numbers are showing the same.
• Maintained complete metadata in the Erwin model.
• Maintaining database change logs, Sub models.
• Extensively using the Erwin design tool & Erwin model manager to create and maintain the versions of the Financial Planning Data Mart.
• Helped testing team to create test cases.

Environment: ERWIN 8.2, Oracle 11g, Crystal Reports, Toad, Windows OS, DB2, Teradata, SSRS, Business objects, SQL Server 2008

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Involved in gathering user requirements along with the Business Analyst.
• Participated in creating the logical model of an online processing system for a large financial institution using Erwin.
• Worked with DBAs to generate physical model.
• Worked on Bill inmon methodologies for modeling.
• Created tables, views, procedures and SQL scripts and mapping documents.
• Worked on slowly changing dimensions (SCD) and hierarchical dimensions
• Worked on conversion process of data, which is stored in flat files into oracle tables.
• Designed and Developed SQL procedures, functions and packages to create Summary tables.
• Generating ad-hoc reports using crystal reports 9.
• Developed database backup and restore policy.
• Expertise in Creating Report Models for building Ad-hoc Reports Using SSRS.
• Expertise in Generating Reports using SSRS and Excel Spreadsheet.
• Expertise in Creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.
• Hands on Experience in creating ETL Packages using SQL Server 2005 Integration Services (SSIS).
• Good Understanding in Database and Data Warehousing Concepts.

Environment: Oracle8i, SQLServer, SSIS, SSRS, ERWIN, HTML, Crystalreports9, MSOFFICE, Windows XP.