Amrita Save

Business Analyst

ac8bis@r.postjobfree.com

Summary

11+ years of IT experience with 7 years as a Business / Data Analyst for medium to complex projects in various industry sectors including Healthcare.

Experience and knowledge of member portal, provider portal, medical claims processing, pharmacy claims processing and tools for inquiring claims information.

Extensive experience on Business Analysis,System Analysis, Design, Implementation and Support of various applications on desktop and mobile platforms and Data Warehousing.

Extensive experience in project scope definition based on business objectives and preliminary business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions as part of project management.

Exceptional analysis skills with an ability to transform the needs of business stakeholders, SMEs, UI/UX Designers,system users to business / functional requirements and supporting IT team in understanding and assessing the gaps between solution design and business requirements

Extensive working knowledge/experience in most phases (Feasibility studies, Requirements Gathering/Documentation, Analysis, Development and Testing coordination) of the industry standard Software Development Life Cycle (SDLC) methodologies such as: Rational Unified Process (RUP), Waterfall, and AGILE.

Experience in preparing Business Requirements Document (BRD), Requirements traceability matrix, Data mapping documents, test plans, Test Cases, Business Process Specification, and Business Data Elements Specification documents, User guides, User stories.

Experience working for Content Management Systems.

Extensive experience in creating use cases, process flows, AS-IS models and TO-BE models and wireframes.

Proficient in modeling Business Processes by creating and using UML diagrams, including Use Case, -Activity diagrams, using MS Visio.

Experience in documenting the business rules for Data Conversion, Data Integrations, Extract, transform and load (ETL), data mappings and data modelling based for complex projects involving multiple Data Sources.

Expertise in complete Testing life cycle of a project from the time of understanding requirements, Effort estimations, creation of test plans, test scripts, gathering or creating test data, smoke testing, multiple rounds of system testing, defect management and coming up with best practices and writing SQL queries and working knowledge on databases

Highly motivated individual with exceptional analytical, quantitative, problem solving, organization, and communication and presentation skills with proven record of contributing significantly to projects independently and as part of the team. Excellent adaptation to new technologies, new business rules and business processes.

Knowledge of data extraction, data explorations, data cleaning, machine learning models and Natural language processing using Python. Knowledge of time series concepts.

Education

Masters in computer management from Pune University, India 2001.

Technical Skills

Databases

Oracle,, Sybase,MS Access, SQL

Operating Systems

Windows NT/2000/XP/2003/Vista

Languages

Visual Basic, VBA

Business Modeling Tools

MS Visio, MS Office, MS Outlook, Sharepoint

Methodologies

Object Oriented Analysis and Design (OOAD), Rational Unified Process (RUP), AGILE, Waterfall, and Business process modelling notations (BPMN)

Tools

Rally, Clear Quest, Clear Case, Quality Center, Rational Requisite pro, Caliber Rm, Crystal Reports, SharePoint, Tridion for content management,Smart sheets.

Certifications

Scrum Master

Experience

KW Energy, NJ,USA - Data / Business Analyst (Sept 2016 – )

Responsibilities:

Analyzed large dataset of energy trade using Python and Microsoft Excel to find the meaningful insights and answer important business questions. The purpose was to produce data and reports and actionable information to support the client in decision making. Information was provided at various grid level, for different periods, regions, price, volume etc.

Data analysis and identifying patterns like Trend, Seasonality,Price, Stationarity.

Extracted,validated and cleaned the dataset from various sources.

Synthesized the daily, weekly, and monthly transactional data and furnished ad-hoc reports and dashboards using Python.

Used Python for visualizations to tell the story of the data and created easily digestible data bites, such as graphs, images, and lists to make a visual interpretation of the data.

Ad hoc analysis/reports as needed developed by gathering customer requirements

Based on the developed requirements created Predicative analysis models using statistical techniques to help the client to undertake effective business model.

Conducted various testing such as functional, regression, user acceptance, integration, and performance to verify the customer's requirements.

Identified and assessed business stakeholder's business/ functional requirements and translated them into requirement documents such as BRD / FRD.

Designed and reviewed various test cases. Ensured the smooth and timely delivery of the product.

Web scraping data from websites (FERC) to get contact data. This was used for Lead generation.

Designed and created email campaigns for the company.

Kaiser Permanente, Oakland, CA – Business Analyst (Jul 2015 – Mar 2016)

Project#1: The project was for Kaiser member portal – My doctor Online. A tool to display the member’s upcoming as well as past immunization, cancer screenings and other health reminders. Using certain clinical rules, the status of the screenings was determined and in case of any due cancer screenings an electronic alert would be sent to the member’s email id. This project was implemented both on desktop as well as mobile.

Project#2: This project was to display details for surgery patients of gall bladder surgery, hernia etc. The surgery details of the member were displayed on the portal for the member. The pre-surgery care, after surgery care details were displayed as per which surgery the member had been thru. This project was implemented both for desktop and mobile. The static content displayed on the website was pulled from a CMS, Tridion.

Responsibilities:

Planned and held meetings with the business stakeholders / Senior Architects for the eliciting requirements for desktop / web and mobile applications.

Documented the user stories and tracked them to completion in Rally.

Requirements walkthrough with the UI/UX designers to get the visuals / assets / wireframes.

Story time for the IT technical teams to bridge any gaps in requirements understanding.

Analyzed business needs and documented the clinical rules.

Ensure design fulfils goals and objectives of stakeholders and meets stated business needs

Giving demo to stakeholders to receive their feedback /comments and plan and schedule with Project Manager its incorporation in the product.

Conducted and participated in stakeholders meeting to resolve issues and manage milestones.

Documented email templates and inbound emails for clients and customers. Documented the workflow rules and the related tasks, time triggered tasks, email alerts.

Prepared user guides on the functional as well as the navigational aspects of the tools.

Analyzed the requirements for web analytics and reporting and event tracking on the member portals.

Develop, maintain, and execute detailed test plans / scripts based on user stories, design documents, and other artifacts

Provide traceability from business requirements and technical specifications to test conditions and scenarios.

Performed UAT and validated test results through front end user interface and back end database.

Used SQLs for doing database testing.

Testing after go-live to make sure the product meets the business requirements.

Maintaining static content in CMS. Writing requirements for any improvements or enhancements needed for Tridion system.

Making user guides for technical writers to add/edit/delete data in CMS.

HP, Pune, India - Business Analyst (May 2010 - Dec 2010)

Worked with Business stakeholders in analyzing the provider modules in legacy system HP Interchange Medicaid Management Information System and Metavance to develop the requirements for a new and improved HPS Next Gen System

Eliciting business rules and analyzing assumptions, constraints, risks, and dependencies and performed GAP Analysis

Eliciting business requirements and preparing Business Process Model using UML concepts,Business Process Specification, and Business Data Element Specification documents

Conducting requirements map to technology meetings with the development team

Creating activity diagrams, use cases using requirement management tools such as CaliberRM and HP Quality Center, Visio.

Preparing functional specification and ancillary documents

Reviewing test scripts to ensure the requirement coverage and participating in the ambiguity analysis with the testing team

Identifying gaps and integration points between requirement management tools and test management tools

Helping in achieving bidirectional traceability between requirements and test cases and performing end-to-end traceability from activity diagrams to test cases

Performing Business acceptance testing and UAT with the business users

Performed data analysis and testing by writing SQLs

Performed Data Mapping from source to target

Maintained mapping of data values for ETL under different categories for analysis.

Analyzed data to identify effective attributes for Reporting.

Develop complex SQLs to create/update test data and validate test case results over multiple tables. Testing data from various sources (CSV /Seibel applications) with target data in the Oracle Data warehouse.

Reviewed Change Requests to analyze potential BI impact on existing reports and coordinate with end users

Other projects

Aetna, Pune, India – Business Analyst (Nov 2009 - May 2010)

Project: ICD 9 to ICD 10 impact assessment

Led a team of 10 to identify the impacts on the various systems from the ICD9 to ICD 10 conversion perspective.

The main responsibility was to understand the process flows from the various SME, document them and find the impact points.

The impact points were analyzed and then using an internal tool, all the process, sub-process, activities etc. were identified which were going to be impacted.

Estimation was provided to the client for the changes required in the system.

Aetna, Pune, India – Business System Analyst (Jan 2008 – Oct 2009)

Project: Pharmacy adjudication system, Provider secure website, Strategic Desktop

These projects involved various major releases for the pharmacy claims adjudication system; Non –calendar year processing, Prescription drug reporting etc.

For Provider Secure website, an enhancement was required - to create Payment estimate for the pseudo claims submitted by the provider before the actual service rendered to the member.

Enhancements for Strategic desktop to view the new elements for the claim.

Independently handling the various projects on different applications, without any onsite counterpart.

Requirement Gathering and Analysis, Creation of use cases, UML activity diagrams, and wireframes, Estimations, Review of work products, Review of design and test plans, preparation of UAT plans and test scripts and testing.

Training and mentoring fresh Business System Analysts (close to around 50) who had no BA background.

Aetna, Connecticut, USA - Business Analyst ( Mar 2007 - Feb 2008)

Project #1: Medical Funding Services

Project #2: Web Interface for Claims Rules

Claim Reporting System involves the control and reporting of Benefit payments after the amounts have been determined, issued or approved.

This project involved integration with a third party vendor Medical Funding Services for prompt claim payment to the providers.

Constant liaison with Business for Requirement Gathering and Analysis, organize meetings with Business, Development and Quality Engineering team for requirement gathering and Work product review.

Document High level and detailed level requirements; create use case diagrams and narratives.

Estimations, Preparation of UAT plans and UAT Testing (using Mainframe), Review of work products, Review of design and test plans, Support during design, development, deployment and warranty.

Analyzing business rules for the non-participating provider claims as per state regulations and incorporating them in the system.

Created the user friendly wireframes and overcame the challenge to change the outlook of the client towards web interfaces from Mainframe screens.

Aetna, Pune, India - QA Lead ( Sep 2006 - Mar 2007)

Project: Centralized Overpayment Processing

Centralized Overpayment Processing System is used to track and report all claim overpayment activity, Traditional and HMO. It is also used to identify trends and the root causes of overpayments.

Successfully lead a module with a team size of 6

Analysis of requirement specifications, Preparation of Test Cases and execution and have delivered quality output

Testing environment used was Visual Basic and Sybase

Tested the database at the backend with various SQL commands/scripts

Project management activities like preparation of Project metrics / Status reports etc, allocation of work to the team members and review

Aetna, Pune, India – QA Lead ( Dec 2005 - Sep 2006 )

Project: Pharmacy Managed Claim Adjudication

Pharmacy adjudication system is one of the mission critical systems supporting the customer business units of the US Payer. There are about 100 users using the system. The system has an SLA of response within 2.5 seconds to the pharmacy provider. If the system does not respond to the claim, the claim is automatically rejected by the network protocol. This project involved major enhancements to the adjudication system.

Successfully lead a team size of 10 and delivered quality output with minimal defects.

Requirement Analysis, Estimations.

Testing environment used Visual Basic, UNIX and Oracle.

Backend testing using SQL extensively.

Onsite co-ordination,Test Plan creation, Testing,defect management

Project management activities - Allocation of tasks, Tracking of efforts and status reporting, appraisals,Mentoring of new team members

Aetna, Pune, India – QA Lead ( Jan 2004 - Nov 2005)

Project: Sales, Quoting and Rating

AQC (Quoting Center) is a web based application which is used to create quotations for existing & prospective clients. The project involves preparation of test plans and testing of existing application for New Business & Renewals.

Successfully lead a module with a team size of 5

Analysis of requirement specifications,Preparation of Test Cases and execution and have delivered quality output well within the timelines

Testing involved checking for more than 200 elements on the web pages and their permutations and combinations. Manual testing of complex quote creation / renewal systems

Preparation of tools in VBA for automation testing.

Project management activities like preparation of Project metrics / Status reports, allocation of work to the team members and review

Mentoring the new team members

Contact this candidate