Data Analyst Project

Ramya

732-***-**** Business Analyst/Data Analyst **********@*****.***

PROFESSIONAL SUMMARY:

Over 8+ years of professional experience as Business Analysis, Business Modeling, Requirement Gathering, Software Validation, Data Analysis

Extensive experience working in Software Development Life Cycle (SDLC) including Waterfall, Agile (Sprint) and Rational Unified Process (RUP).

Extensive experience in creating numerous artifacts such as Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Requirements Traceability Matrix (RTM), Business Use Case documents, System Use Case documents, GAP analysis documents.

Strong experience working on projects related to Health Information Exchange (HIE), Medicare, Medicaid, EDI transactions (inbound and outbound), Claims Adjudication, HIPAA, CPT and expert in Affordable Care Act( ACA), aka Healthcare Reform (HCR).

Extensive experience in Claims Adjudication, Membership Administration System, Benefit Administration System, Provider Information System, Code Administration System, Enrollment System, Payment Gateway.

Experience on Retail / Supply chain domain with strong knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process, Accounting & financials as well as strong experience in POS and Assortment Planning

Hands-on experience on Online/Internet banking and payment systems including Credit/Debit Cards, Mobile Banking, Check Processing, Global Portfolio Management, ACH processing and wire-transfers, loan origination process, fixed income products like (treasury, Bonds, notes and bills), mortgage backed securities and bonds.

Astute understanding of value created by AS-IS and TO-BE analysis and experienced in conducting process evaluations and writing recommendations based on the analysis.

Strong experience working with Scrum methodology and well versed in writing user stories using JIRA tool.

Proficient in conducting JAD sessions with teams aimed to devise joint solutions to business requirements

Specialized in creating UML Diagrams such as use cases, business process models, activity and data flow diagrams using MS Visio and Rational Rose; consistently translating business requirement into IT solutions Expert level skills in MS Office products and other tools including MS Project, MS Word, MS Power Point, MS Visio, Axure, MS FrontPage, MS Excel.

Proficient in creating multiple table views and reports generated through qlik view and tableau for business analysis.

Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as analyst

Responsible for understanding business analysis concepts for logical data modeling, data flow processing and data base design

Strong data collection, analysis and interpretation skills

Experience in working on Data Dictionaries, Data Definition with explanation of concepts in the form of use cases.

Thorough experience in all the phases of Waterfall methodology from requirements elicitation followed by analysis, design, coding, testing, and maintenance.

Proficient in writing SQL queries for data verification and validation.

Experience in SQL ad-hoc queries to extract data from various databases for data analysis and generating reports per the format specified Subjects Matter Experts (SME's).

Expertise in relational databases using RDBMS like MYSQL,PLSQL and creating entity relationship diagrams.

Extensive experience on building dashboards using Tableau from various database (Oracle, Hive and vertica).

Experienced in all aspects of analytics/data warehousing solutions like Data Mapping, ETL Development, Data Modeling, Metadata Management, Data migration and Reporting Solutions.

Extensive experience in working with QA team to create Test Plan, Test Scenarios, Test Cases, Test Matrices, Test Reports to conduct Functional testing, Integration testing, System testing, GUI testing, Performance testing, Load testing, Smoke testing, Regression testing, White Box testing, and User Acceptance testing

Experience in using defect tracking tools to address bugs/issues and interacting with development team to fix errors.

EDUCATION:

Bachelors of Business administration (BBA), Osmania University, India.

TECHNICAL SKILLS:

RDBMS

MS SQL Server, MySQL, Teradata

Project Tracking tool

HP QC/ALM, JIRA, Microsoft Test Manager

Modeling Tools

MS Visio, Rational Rose, SharePoint, Erwin

Requirements Management Tools

JIRA, HP ALM, HP QC, SAS

Project Management Tools

MS Office Suite (Project, Excel, Word, PowerPoint)

Industry Standard

SQL, HIPAA 5010, ICD9, ICD10, ANSI X12

Methodology

Agile(Scrum), Waterfall, Rational Unified Process (RUP)

Operating System

Windows, 98/2000/XP/Vista/Window 7, Unix/Linux

Tools

WinRunner, LoadRunner, QTP, Quality Center Test Director, Selenium, Silk, Cucumber, JIRA, ClearQuest, Tableau

PROFESSIONAL EXPERIENCE:

United Health Group, Minnetonka, MN

Business Analyst/Data Analyst Feb 2016 - Present

This project involved creating the medical claims processing system for UnitedHealth. It consisted of different modules like provider enrollment, member enrollment, programs and coverage. This project also involved the maintenance of claims workstation that automatically handles the entire claims life cycle.

Responsibilities:

Gathered and documented business requirements for existing and future business systems.

Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.

Ensured that project requirements are properly tracked and documented.

Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.

Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.

Actively worked on Data analysis and Report analysis with respect to ICD-10 impact.

Ensured that relevant UML diagrams and tools(Requisite Pro) were used in all requirement documents. Example user requirements and functional specification requirements.

Maintained requirement TRACEBILITY matrix(RTM) and managed requirements.

Extensively worked on Data Mapping and ETL

Involved in utilizing agile to configure and develop process, standards, procedures and also assisted the development team during the second and third iteration using the agile model.

Wrote user stories using JIRA tool.

Participated in Requirement gathering for data modeling purposes

Captured business requirements for reconciliation reports and designed metrics in Micro strategy

Capture and Formulation of Business Rules and delivery of Business Rules Templates.

Created requirements analysis and design phase artifacts using, Rational Software Modeler and MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.

Creation of UML Diagrams including Context, Business Rules Flow, and Class Diagrams

Analyzed trading partner specifications and created EDI mapping guidelines.

Completed the documentation of Claims Scenario's for the source system.

Hands-on experience with the hospital working system including Registration, Scheduling, Radiology, Laboratory, Pharmacy, Patient Accounting, HIM, Claim Processing etc.

Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.

Ensured that all Lines of Business specifications were consistent in form and function to the Diamond Base System.

Created Business process workflow diagrams using IBM business process modeler.

Performed SQL queries for retrieving, organizing the database with general command like select, create, update and join.

Conducted the final user acceptance testing(UAT) and usability testing.

Environment: Agile, MS Office, Windows 7, MS Visio, JIRA, HP SharePoint, MS Project, MS Visio, SQL, SOAP, XML, MMIS.

South Carolina Department of Health and Human Services, North Carolina

Business Analyst/Data Analyst April 2014 – Jan 2016

The Project involved enhancement of MMIS system for new MCO products including claim processing module, premium payment module etc. Another project involved helping the department in creating documents for Integrated Eligibility Determination system for Medicaid, TANF and SNAP.

Responsibilities:

Gathered Business/Technical Requirements, Approval of CR (Change request), and Implementations for State MMIS.

Responsible for designing future state processes for new MCO and transaction between MMIS and MCO.

Worked on creating State based Rule requirement document with Rule ID (CFR number)

Gathered business and functional requirement for eligibility determination for SNAP, TANF and Medicaid program

Created functional design for SNAP, TANF and Medicaid eligibility programs

Worked on Child Support Incentive Benefits delivered through Electronic Benefit Transfer

Researched on state based rules, configuration to be implemented in integrated eligibility system

Gained extensive experience in modifying the CICS screens for various areas such as Enrollment, Billing, Provider Record and Reimbursement Status in MMIS

Wrote clear, concise detailed System Requirements Specification(SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance

Experience in implementation of CPT codes changes in the current claim processing modules in MMIS.

Worked on JIRA which include Defects Management, Test Plan and Dashboard.

Talking to different stakeholders based on requirements of that particular defect, uploading document required, checking history, status notes, setting up resources to handle and fix it

Worked on Rational Requisite Pro application to handle various requirements including Functional requirements, High-level requirements, Non-functional requirements, Scope statement and User requirements

Created the conceptual, Logical and Physical Model for the data warehouse with emphasis on insurance (life and health), mutual funds and annuity using Erwin data modeling tool.

Created Source to target Mapping Matrix for the ETL developers in loading the data to Dimensions and Fact Tables using SAS.

Point of Contact of the Content Management software solutions including Microsoft SharePoint Server 2013/2007 and Open Text Live link

Provided online support to users for various applications such as IPCS (Internet Professional Claims Submission).

Environment: HP ALM,, Sales force, MS Office, SDLC waterfall Windows 7, MS Visio, HP SharePoint, MS Project, MS Visio, SQL, SOAP, XML, MMIS,

Target Corporation - Minneapolis, MN

Business Analyst/Data Analyst Jan 2013 - March 2014

E-commerce & Web Analytics Implementation: Target Corporation operates general merchandise stores in the United States. The primary goal of the project was to implement new features such as Buy Online Pick up in Store (BOPUS), Guest checkout, Auto Refill, Compare Products, Product Bundle, Persistence shopping cart etc.

Responsibilities:

Involved in all phases of software development life cycle (SDLC) in RUP framework.

Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.

Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis. Performed user interviews.

Held responsibility for creating business flow diagrams and charts for E-commerce using MS Visio

Applied Unified Modeling Language (UML) methodologies to design Communication

Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.

Extensively interacted with both user group and development team.

Managed and tracked change control process of requirements and design changes.

Documented the changes, issues and their impact on the system design and delivery.

Provided documentation such as requirements management plans, functional

requirements, test plans and test cases.

Involved in the creation of new e-commerce products, arrival notices and customized reporting.

Incorporated the best practice methodologies as advocated by the Rational Unified Process.

Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology using Rational Rose

Created prototypes, screen mockups, and wireframes to communicate the design with clients and stakeholders

Worked with Storyboards to model the interactions that users have with the software

Wrote user requirements specification (URS) and Functional requirements specification(FRS) Documents as per the Business requirements and process flow

Environment: MS Access, MS Word, MS PowerPoint, MS Visio, MS Project, RUP, Rational Rose, Requisite Pro

Capital one, Mc lean,VA

BUSINESS ANALYST /DATA ANALYST Jan 2011-Dec 2012

Capital One is a diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK and Canada. The current project Presentation Layer involves in creation of new tables in CDW for storing the data required by Analysts. The data from base tables in CDW will be loaded in these presentation layer tables after required transformations are performed. These new tables will consist of columns (also termed as attributes) that are essentially derived from the base layer data. These attributes are defined by the Data Analyst team and the same team will be the primary end user of these new tables. The primary focus of this project will be improving the performance of queries that generate reports and make analytics efficient. The Statement Aggregate feed consists of selecting data from CDW tables for various subject areas like Access checks, Account information, Account Status, Account Disposition, APR, Credit limit change, Rewards, Statement, Transaction and Model Scores.

Responsibilities:

Facilitated JAD sessions with the business customers, users, application designers and business systems analysts to define the data requirements and reporting requirements

Analyzed the business/reporting requirements and converted them to Technical design documents for designing the database structure

Worked under enormous pressure with successful delivery of the assigned projects to meet the timelines and provided support to the technical team

Created conceptual data models for various subject areas like Account, Account Management, Balance Transfer, rewards based on the design specifications

Created logical and physical data models in Erwin data modeling tool for all the subject areas within the corporate finance system and forward engineered the tables to the database

Created a corporate Metadata Repository allowing users to manage and leverage enterprise metadata

Conducted LDM and PDM reviews with data SMEs and applied Capital One guidelines and Naming Standards

Checked models in and out of Model Repository and documented data model translation decisions

Assisted the database administrators in developing the physical data model and ensured the database designs fulfilled the requirements, including data volume, frequency needs and long term data growth

Ensure that the developers and database administrators responsible for developing the database thoroughly understanding the requirements and designs

Defined the data warehouse architecture considering the data flow from authoritative sources to the staging areas and then to the target data warehouse

Worked closely with the development team to design, develop and test the Data Stage jobs to maintain the data marts (Extract, Transform and Load data)

Involved in heavy performance tuning of the ETL processes identifying the bottlenecks at different stages of the ETL

Used Data Stage Director to schedule, monitor and run jobs

Created UNIX shell scripts to compare the source flat files and merge them depending on the requirement before using the flat file as a source for the ETL.

Actively involved in User acceptance testing and helped the users in understanding the business and design

Conducted daily stand up meetings with the team to discuss the status

Generated professional business reports using Cognos tool based on the business rules and distributed to the end users.

Environment: Windows, Erwin 4.1, MS Office Tools, Oracle 9i/10g, Teradata 7.1.0, Ascential Data Stage 7.5.1, Cognos 8.0

Bajaj capital limited - New Delhi, India

Jr BUSINESS ANALYST Jan 2009 - Dec 2010

Bajaj capital limited is one of the leading diversified financial services provider which offers home mortgage services. The scope of the Project was to implement a mortgage system which is a windows-based software package that is designed to be a complete mortgage lending solution. The system allows for processing, closing and underwriting of all loan types for both wholesale and retail production and also provides a centralized repository for underwriting and monitoring processes.

Responsibilities:

Acted as a liaison between the business users and technical teams to build applications based on the business requirements - provided a single point of contact for user communication (managed issue tracking, prioritization and resolution).

Followed all the phases in the project management life cycle.

Reviewed test plans and results.

Co-ordinated with other business analysts and clients for reviewing test results.

Involved in CMS (Content Management System) in automating various aspects of Web and Publication Content Creation, Document Management and Delivery.

Worked with project team to write up Requirement Documents (defined user and system interfaces–actors with the help of use case diagrams).

Refined the requirements (use-cases) and Business Process Models to detailed level appropriate for technical analysis and system design.

Participated in sessions to define the solution approaches, and identify assumptions, constraints, risk and issues.

Revealed unidentified requirements, evaluated changes to requirements, and assessed impact of changes.

Recommended process or system changes intended to eliminate identified risks or gaps.

Worked thoroughly with all the phases of waterfall.

Worked with Finance and IT department to operate across functions and worked with resources external to the Project Team.

Developed functional requirements and specifications.

Provided regular verbal and written status reports to IT management and business community; published meeting minutes and maintained project plans.

Coordinated with the project team and testing team to revise project artifacts (such as use-case specifications, test scripts, and so on) to reflect requirement changes.

Worked independently with minimum supervision as part of a dynamic IT team.

Environment: Windows XP, Waterfall, Rational Rose, Rational Clear Quest, Microsoft Project.

Contact this candidate