APOORVA MATEE
Senior Business Analyst
Email id: ********.****@*****.***
Contact No: 407-***-****
Client focused System Business Analyst with over 8+ years of experience in Pharmacy, Banking, Insurance (Property & Casualty), Healthcare and Telecom domain. Exhibited proven record of providing business solutions for high priority business goals.
PROFESSIONAL SUMMARY:
Proficient in defining scope of projects based on gathering Business Requirements including Documentation of constraints, assumptions, business impacts, project risks & scope exclusions through direct user interviews, JAD Sessions, requirement gathering sessions and meeting with small as well as large groups of stakeholders. Extensive experience in full Software Development Life Cycle(SDLC) methodologies such as Waterfall(Predictive) approach and Agile(Adaptive) approach ‘Scrum’.
Strong understanding of various Agile approaches like Scrum, Kanban, Extreme Programing (XP) and Scrum/XP Hybrid.
Performed Gap Analysis to identify the GAP between AS-IS and TO-BE states of the application/processes and Impact analysis to ensure that captured requirements are not creating any impact on any other project.
Proficient analyzing and documenting project scope document, Statement of Work, Project plan, requirement change request forms(CRs), Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), Software Requirements Specification (SRS), Product Backlogs, Sprint Backlogs, Burn Down Charts, Key performance indicators (KPI).
Facilitated various scrum ceremonies in Agile Scrum Methodology like Grooming, Sprint Planning, Daily Stand-Ups, Review, Retrospective etc. and was responsible for solving impediments and conflicts.
Designed Business models using UML Diagrams such as high-level Use Cases and low-level Use Cases Specifications, Activity Diagrams, Swim lanes and Sequence Diagrams using Rational Rose and Enterprise Architect.
Designed workflows, cross-functional flowcharts in MS Visio and wireframes/ prototypes/ mockups using Axure RP 8, Pencil and Balsamiq.
Solid understanding of Feasibility Study, SWOT Analysis, Cost Benefit Analysis, Problem Analysis, Risk Analysis, Root Cause Analysis and Pareto 80/20.
Strong Excel skills to build charts, tables, graphs, pivot tables and other Excel-based reporting.
Worked on database queries, joins operation, updates, inserts and deletes.
Experienced working with Business Intelligence (BI) and Data warehousing tools like IBM Cognos and Informatica.
Excellent understanding of relational database(RDBMS) and expertise in running SQL queries. Knowledge on Data warehousing concepts such as Data transformation, Data Mapping, Data Modeling and Data Profiling.
Extensive knowledge in the implementation of Data Modeling, Data analysis, data validation and database design.
Created User stories with Acceptance criteria in Rally and JIRA for technical implementation.
Strong skills and ability to troubleshoot issues quickly and independently finding solutions to solving them in a timely manner.
Ability to analyze complex problems, interpret operational needs, and develop integrated, creative solutions.
Exceptional understanding of the QA life cycle, from test plan, test scripts, issue resolution to User Acceptance (UAT), System Integration (SIT) and end-to-end testing.
Adept in Team Management, Problem Resolution, Conflict Management, People Management and Interpersonal Skills.
Created operating instructions, how-to manuals, assembly instructions, and “frequently asked questions" pages to help technical support staff, customers, and other users within a company or an industry as needed.
Expert communicator (written, verbal and presentation) involved in high level interaction and influence with variety of audiences (Senior Executives, Clients PMs, developers, SME) as well as PMO.
TECHNICAL SKILLS:
Domain
Pharmacy, Banking, Insurance(Property & Casualty), Healthcare,, E-commerce and Telecom
Operating Systems
Windows XP/7/2008/10, Mac OS, Unix
Project Methodology
Agile(Scrum), Hybrid, Waterfall
UML Tools
MS Visio, Rational Rose, Enterprise Architect
Wire framing, Mockup Tools
Balsmiq, Pencil, Axure RP 8
Requirements Management
Microsoft Office(Excel, OneNote, Outlook, PowerPoint, Word), MS Office 365, Rational Requisite Pro
Project Tracking tools
JIRA, Rally, Microsoft Project, Team Foundation Server (TFS)
Programming Languages
Java, HTML, CSS, C
Database System
Oracle, SQL Server, IBM DB2, MS Access
Data Modeling
Erwin
Reporting
Tableau, IBM Cognos, SSRS, BO
Version Control System
GIT, Sub version Control (SVN)
WORK EXPERIENCE:
Project Profile 1
Client
LifeScan- A Johnson and Johnson Company
Location
King of Prussia, PA
Duration
October 2017– Present
Role
Senior Business Analyst
A Johnson & Johnson Company since 1986, LifeScan is headquartered in Chesterbrook, Pennsylvania.
Development of new technology and manufacturing of innovative blood glucose monitoring devices has made OneTouch systems the #1 most prescribed brand by Endocrinologists and Primary Care Physicians.
Project 1
European Union General Data Protection Regulation (EU GDPR)
GDPR is a regulation that requires businesses to protect the personal data and privacy of EU citizens. This replaces the Data Protection Directive 95/46 which goes into effect in May 25th,2018. As this replaces current legal framework for privacy and personal data protection in the EU, we are localizing some features of OneTouch Reveal Web and Mobile App. Localization is based on Patients right to restrict, right to delete account and few other.
Project 2
HITRUST Security Assessment for OneTouch Reveal(OTR) System
HIPAA security assessment is a base HITRUST security assessment that encompasses a subset of the HITRUST framework across 19 security domains. Depending on the scope and risk of the HIPAA environment, the assessment represents 120-328 of the HITRUST controls.
Responsibilities:
Met with client groups and worked as liaison between technology and the business clients to improve business processes and support critical business strategies.
Worked with cross functional teams from various business areas such as Privacy, Legal, Labelling, Security, UX, Web and Mobile Development team, Web and Mobile testing team, verification and validation team, quality, project management.
Used effective Adaptive (Scrum) techniques to conduct weekly team meetings in order to ensure that the development activities are streamlined
Elicited business requirements from core business units via interviewing, teleconference meetings, semiformal and formal meetings.
Documented requirements in pre-existing Sub-system requirement document(SSRD) in Cockpit tool.
Worked closely with user experience(UI/UX) team for creation of UX specifications and mockups for web, mobile (android and iOS).
Designed quality user stories making sure that they meet INVEST criteria
Conducted Sprint planning meeting with developers and testers to review user stories, assign story points and cards to a respective sprint.
Worked in organization developed Hybrid environment for effective management.
Create Requirement Traceability Matrix (RTM) to trace the requirements and to make sure the project requirements are fulfilled.
Wrote requirement specification, user stories, and acceptance criteria and used JIRA as project management tool.
Conducted sprint planning meeting with the developers and quality assurance analysts to review user stories, assigned story points and assign cards to a respective sprint.
Coordinated User Acceptance Testing (UAT) on a monthly basis with the Subject Matter Experts(SMEs) to make sure that all the requirements are addressed in the application
Collaborated with Scrum master and scrum teams for creating Scrum artifacts like Burn-down charts, Task boards, Velocity planning and Sprint grooming prioritizing backlogs.
Attended workshop for Mapping, scoping, risk analysis with third party HITRUST assessor.
Gathered 120 documents from internal document sharing tool, J&J’s site and AWS web documentations.
Environment: Amazon Work Spaces(AWS), JIRA, SVN, Cockpit, Box, ENABLE, MS Outlook, Project, Word, Excel, PowerPoint, MS Teams, Visio, Eclipse, mongoDB, Confluence, Hybrid Approach
Project Profile 2
Client
Synovus Financial Corp.
Location
Columbus, GA
Duration
August 2016– September 2017
Role
Senior Business Analyst
Synovus Financial Corp. provides integrated financial services including wealth management, commercial and retail banking, financial management, insurance and mortgage services to the customers through 28 locally-branded banking divisions of its wholly owned subsidiary bank, Synovus Bank, and other offices in Georgia, Alabama, South Carolina, Florida and Tennessee. My project was aimed at creating an Enterprise Reporting System to support business areas including Asset management, Portfolio management and Risk management. The system assimilates enterprise asset information into a centralized data warehousing system via ETL processes. The system when deployed provides a consolidated view of the enterprise asset information through a reporting interface. The main goal was to provide important information to managers in effective way. Thus helping managers to plan business strategies and make appropriate business decisions.
Responsibilities:
Worked on business rules of various banking processes like equities, mutual funds, futures, swaps, derivatives etc.
Ensure compliance with client's asset management policies and practices.
Met with client groups and worked as liaison between technology and the business clients to improve business processes and support critical business strategies.
Implemented layouts for Suspicious Activity and Pattern analysis under AML regulations.
Used effective Adaptive (Scrum) techniques to conduct weekly team meetings in order to ensure that the development activities are streamlined.
Documented various business rules, thresholds, parameters recommended by the quantitative analysis team.
Evaluated complex profit plans, operating records, and financial statements.
Directed preparation of studies, reports, analyses, and recommendations in areas such as budgets, forecasts, financial plans, statistical reports, and business forecasts.
Facilitated Joint Application Development (JAD) and Joint Requirement Planning (JRP) with stakeholders by sending out meeting agenda and reference documents.
Create Requirement Traceability Matrix (RTM) to trace the requirements and to make sure the project requirements are fulfilled.
Wrote requirement specification, user stories, and acceptance criteria and used Rally as project management tool.
Conducted sprint planning meeting with the developers and quality assurance analysts to review user stories, assigned story points and assign cards to a respective sprint.
Collaborated with Scrum master and scrum teams for creating Scrum artifacts like Burn-down charts, Task boards, Velocity planning and Sprint grooming prioritizing backlogs.
Worked closely with the Business Intelligence (BI) team to define standards for report.
Involved in data mapping and making traceability views.
Data analysis was performed on customers, products or services used, geographic locations involved in the transaction so that Risk Management team can take appropriate actions.
Involved in reviewing Entity Relationship, Data Flow, State Transition and Class Diagrams with the Systems Analyst.
Involved in data mapping and making traceability views.
Gathered and defined OLTP and OLAP database modeling requirement.
Experience in writing SQL queries for validating, data mapping, data extraction and data manipulation.
Worked closely with ETL developer in designing Logical and Physical Database Designing using Erwin Tool and created Facts and Dimension Tables using star schema based on user requirements and created target database on Oracle 11g.
Maintained documents for change request and implemented procedures for testing changes.
Coordinated the User Acceptance Testing (UAT) on a monthly basis with the SME's to make sure that all the requirements are addressed in the application.
Automated the generation of Customer Due Diligence (CDD) and Enhanced Due Diligence (EDD) reports in compliance with Anti Money Laundering (AML).
Gathered knowledge on Customer on Boarding (COB) workflow, setup roles in Customer Identification Process (CIP) and Customer Due Diligence (CDD).
Ensured the enhancements are completed in a timely fashion, they follow the appropriate IT guidelines and meet/exceed user requirements.
Involved in writing user manuals and conducting user trainings sessions.
Environment: Balsamiq, MS Visio, JIRA, Java, Informatica, IBM Cognos, SQL, Erwin, Oracle 11g, Oracle Webserver, MS Office Suite, Agile approach.
Project Profile 3
Client
NJM Insurance Group
Location
West Trenton, NJ
Duration
August 2015 – July 2016
Role
Senior Business Analyst
New Jersey Manufacturers Insurance Company or NJM, offers personal auto, commercial auto, workers' compensation, homeowners and umbrella insurance. The project was to automate the Insurance claim system and enhance the CRM by providing real time monitoring for its Auto insurance division. The project involved developing a system in place for online quote applications to obtain reliable quotes in real time from existing web portal. The Project was undertaken to enhance the existing functionality of convenient access to real-time quote information with the ability to download quote information. The application also helped agents to obtain quotes for their customers. I was also involved in web service and user interface development covering claims.
Responsibilities:
Analyzed the system by performing As-Is study and created To-Be process flow in order to determine whether solutions meet the high-level business requirements.
Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Flood Claims etc.
Analyzed the Business rules for Claim assignments throughout the New Jersey, so as to have balanced work load for all the claims representatives.
Assisted cross-functional teams from Property and Casualty division business teams such as Annuities, Securities, Policy & Program Evaluation Team, Project Sponsors & Actuaries.
Utilized corporation developed Hybrid approach.
Elicited business requirements from core business units via JAD sessions, teleconference meetings, semiformal and formal meetings.
Documented the requirements in pre-existing Business requirement document(BRD)
Responsible for process modeling from inception through implementation and post implementation optimization along with associated UI design.
Planned and defined system requirements with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
Worked closely with user experience(UI/UX) team for creation of wireframes and prototyping for web portal.
Designed quality user stories making sure that they meet INVEST criteria.
Conducted Sprint planning meeting with developers and testers to review user stories, assign story points and cards to a respective sprint.
Engaged in analyzing requirements, identifying various individual logical components, expressing the system design through UML Diagrams.
Coordinated User Acceptance Testing (UAT) on a monthly basis with the Subject Matter Experts(SMEs) to make sure that all the requirements are addressed in the application.
Assisted with the development of user manuals and trainings to help educate users on the new functionality.
Environment: MS Visio, JavaScript, Rally, Pencil, Microsoft Office Tools, MS Dynamic CRM, SSRS, SQL Server, Hybrid Methodology
Project Profile 4
Client
Molina Healthcare
Location
Columbus, OH
Duration
May 2013- June 2015
Role
Business Analyst
Molina Healthcare is one amongst Fortune 500 companies. It provides quality healthcare to people receiving government assistance. The aim of the project was to enhance the existing software for medical billing. Stake holders faced a lot of technical problem while following up on billing and claims. The Scope of the project was to study the As-Is business process, identify the problems and perform the FIT/GAP analysis to develop a new To-Be system where all the information regarding the claims on a dashboard where the clients and the stakeholders can work on the claims and also can upload the corresponding documents into the system.
Responsibilities:
Gather, document, and analyze business data requirements, workflow processes, and process improvements. Demonstrate excellent elicitation skills during SME interviews.
Comprehensive knowledge of Healthcare Insurance including Medicaid, Medicaid Information Technology Architecture, Medicare and Medicaid Management Information Systems (MMIS).
Effectively elaborated the Current process and recommended a clear picture of the proposed process for the projects in the organization.
Used Waterfall Methodology to configure and develop process, standards and procedures.
Designed the Business Requirement Document (BRD) based on feedback from senior management. Conducted JAD sessions with SME including business owners, sponsors and analysts
Translate business requirements to technical requirements by working with technical team.
Performed data analysis for integration requirements, reporting needs.
Trace requirements to deployed system to ensure all the requirements are met.
Inform Project Manager of technical issues/bugs and resolutions.
Used HIPAA 4010 TX codes to support the analysis of current business processes and work with management to improve and implement enterprise solutions to ensure compliance.
Was involved in designing future state processes for HIPAA 5010 transaction processing for EDI's 837, 835, and 834 and ICD 10 Code sets. HIPAA 4010-5010 Conversion Analysis - Involved in the documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
Develop test plans for UAT and user documentation.
Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances.
Worked with the QA and UAT teams to conduct an assessment and determine how effective UAT and QA guidelines can help the client timely completion of projects
Environment: MS Visio, Word Excel, PowerPoint, IBM Rational Rose, IBM Rational Requisite pro, SQL, IBM Db2, MS Project, Waterfall Approach.
Project Profile 5
Client
T-Mobile
Location
Norton, MA
Duration
September 2010- April 2013
Role
Associate Business Analyst
This project was about the implementation of BMC remedy AR system and ITSM 7.6.04 suites which includes Incident Management, Problem Management, Change Management and Service Level Management.
Responsibilities:
Lead and facilitated Business Requirements workshops with business users.
Captured As-Is process, define To-be processes based on ITILv3 framework, defined Key Performance Indicators (KPIs).
Designed process flows using MS Visio.
Assisted in preparing Business Requirements Document (BRD), got respective sign offs.
Acted as an interface with Development and Quality Assurance teams, communicated Business Requirements and conducted Functional Testing.
Participating in weekly and fortnightly meetings.
Liaised with the Project team to assist in detecting, analyzing, troubleshooting and resolving the issues.
Worked closely with Configuration Management Database & Atrium Discovery and Data Mapping (CMDB & ADDM) Team in order to role-play for better understanding of the process.
Worked on Configuring the IP Addresses to help find out the undiscovered Configuration Items (CIs) into Configuration Management Database.
Reported inconsistency of form fields and maintenance of CMDB CI's.
Managed Atrium Discovery and Data Mapping ADDM to automate asset discovery and application dependency mapping to build a comprehensive view of all data center assets and the relationship between them.
Guide training team to prepare Training Documentation and conduct Business User Training.
Developed, maintained and improved the internal support documentations and processes based on the ITIL framework.
Liaised with the Product Vendors and Professional Services team and escalating the defects and enhancement requests.
Sustained high-level customer satisfaction and received appreciation from Manager and the team.
Environment: MS Office, Java, Oracle 11g, Virtual Machine, Rational Rose, Linux, Windows, Atrium Discovery and Data Management(ADDM), Configuration Management Database(CMDB), SAP Business Objects