Business Data Analyst

SHANTANU KAPREKAR Phone: 703-***-****

Email ID: ******************@*****.***

Summary

•Over 6+ years of experience as a Business Analyst in the Biotech and Healthcare domain.

•Certified Scrum Master

•Work experience in industries - Retail, Biotechnology and Business

•Skilled in performing Gap Analysis and Impact Analysis by recognizing existing advances, archiving the upgrades to meet the end-state prerequisites.

•Proficient in interacting with Stakeholders, Subject Matter Experts (SMEs), System Analysts and Technical team with excellent communication and interpersonal skills.

•Excellent Analytical skills in understanding and identifying the Business Process and conducting feasibility studies to develop Scope and Vision Document.

•Ability to elicit stakeholder's requirements, to analyze and synthesize information, and to document business requirements both textually and graphically.

•Propensity to leverage both financial/investment knowledge and system familiarity in order to analyze, define, and translate detailed business needs into solutions.

•Strong analytical skills and creative thinking with ability to solve problems and generate new ideas.

•Possess strong product management skills, excellent verbal and written communication skills, and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.

•Thorough understanding of the Software Development Life Cycle (SDLC) and their variants with Waterfall, Agile (Scrum), RUP.

•Experienced in tracking, documenting, mitigating and resolving Project Risks and Issues.

•In-depth working knowledge of Cost/benefit analysis.

•Experienced in writing Business Requirements Document (BRD) and Functional Requirements Document (FRD).

Technical Skills

•Databases

•MS SQL Server, Oracle 9i

•Methodologies/Frameworks

•Agile, RUP, Waterfall, Iterative, UML, CMM

•Bioinformatics

•BLAST, FASTA, CLASTAL W, NET PRIMER, MEGA 4

•Software Tools

•Rational Rose, Rational Requisite Pro., Share point, Team foundation server

•Office Tools

•MS Access, Excel, Power Point, Word, MS Outlook Express, Outlook Exchange

•Claim Engines

•Facets, QXNT, AS 400/iSeries

Work Experience

Aetna, Philadelphia, PA (Nov 2016 – current)

Business Data Analyst

Responsible for soliciting business requirements and creating healthcare informatics reports, spanning claim, provider data, and utilization management reports.

Responsible for end to end process, including QA of reports, to ensure compliance with internal and external requirements.

The analyst will assist management in the creation and maintenance of various reports and reporting tools needed to meet department goals.

Develop content management methods; including updates, gap-filling, and quality control

Identify query methods supporting visualizations that enable efficient, responsive data exploration and analysis

Manage linkages and quality to provider data sets

Extensive use of SQL server for data querying purpose and analysis provider relation data

Responsible for gap analysis of data and communication with IT team to get solution for fulfilling the gaps

Environment: SQL server management 2012, QNXT 5.1

United Health One, Green Bay, WI (April 2015 – Nov 2016)

Business Analyst

Working as a mentor for paradigm shift of waterfall methodology to Agile methodology; for the complete team of departmental end-users, technical analysts, information technology analysts.

Working with cross functional teams to make team understand complete ‘Agile processes’ and importance of Agile ceremonies.

Consultation with functional unit management and personnel to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access.

Acting as a liaison between departmental end-users, technical analysts, information technology analysts, consultants and other governmental organizations in the analysis, design, configuration, testing and maintenance of case management systems to ensure optimal operational performance.

Creating and maintaining the product backlog using TFS tool and also tracking the documents changes for functional and business specifications.

Practicing and writing a detailed universally understood procedure for permanent records and for use in training.

Interpretation of case management systems and functional technical literature and translating in terms understandable to the end-users.

Met with users and stakeholders to understand the problem domain, gathered customer requirements through interviews (group and one-on-one) along with JAD sessions.

Helped the testing team to successfully conduct User Acceptance Testing (UAT)

Completed Data Mapping for Group and detail Product analysis and report writing

Analyzed the front end Customization requirements on iSeries/AS 400 applications(Member, Group/Subgroup application, Member maintenance, etc)

Environment: UHOPS( Home grown application on AS 400/iSerise), MS SQL, MS Share Point, Team foundation Server (TFS), DB2

Cognosante,McLean, VA (April 2014 - April 2015)

Business Analyst

Project Description: MMIS project is to provide the Base component of the MMIS, which receives and processes prior authorizations, referrals, claims, and remittance advices for medical and dental services. The project also manages provider enrollment for all Idaho Medicaid providers along with Idaho Medicaid Member. This includes the files and data conversion and migration of all application functionality from the legacy MMIS system to the client-server application (Health PAS system).

Responsibilities

●Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus.

●Participated in review and analysis of business requirements, adding additional cases as needed, insuring they are complete and testable.

●Met with users and stakeholders to understand the problem domain, gathered customer requirements through interviews (group and one-on-one) along with JAD sessions.

●Identified the issues and done gap analysis with existing and current RDS Extract system for reconciliation process.

● Dealt resolving issues with member attributes, enabling multiple rules associated with member lookup process in QNXT.

●Did the forward and reverse data mapping between the fields in mainframe and QNXT.

●Tested the changes for the front end screens in QNXT related to following modules, test the QNXT batches (member load, Billing, Provider, etc).

●Analyzed the front end Customization requirements on QNXT applications(Member, Group/Subgroup application, Member maintenance, etc)

●Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, etc from Legacy system (AIM) to QNXT.

●Responsible for working with the State to review and modify process flows to increase productivity and effectively utilize QNXT features not provided by the legacy systems.

●Worked on modules related to configuration of Benefits and plan - Providers, Contract & Claims and worked with Claims, Provider attributes, enabling EOB & Remit rules associated with Provider configuration process in QNXT.

●Worked on Configuration of Providers and Contract - Provider demographics, Provider Contract and Contract information.

●Resolved issues like member duplicated in file, dealing with dependent transaction if subscriber is not found, failures in submissions in QNXT.

●Logged defects in Rational Clear Quest, re-tested defects, analyzed defect with Users and Developers

●Completed Data Mapping for Group and detail Product analysis and report writing

Environment:QNXT, MS SQL Server 2005, Rational Reqpro, Rational Clearquest, Rational Manual Tester, Rational Test Manager, MS SQL Server Reporting Service (SSRS), Venetica Process Manager, MS Share Point.

Fairleigh Dickinson University, Teaneck, NJ

Administrative Assistant (Aug 2012–May 2013)

Responsible for providing an efficient and professional administrative and clerical support to Department chairs, professors, and colleagues to facilitate the efficient operation of the office

Responsibilities

Facilitating meetings and international conferences

Ensuring office procedures and systems operate efficiently

Create contracts and process them as per requirements for part time faculty

Assisted with scheduling and planning classes for semesters

PROJECT - Database Designing (Project Manager)

Designing data collection and data entry form using MS Access for office of placement

Creating queries and narrowing down to the parameters in MS Access

Data mining and data collection using advance MS Excel and Big Builder database

Project managing and coordinating between business requirements and technical issues

PROJECT - International Level Survey: Designing and Publishing (Project Assistant)

Designed survey using Google form application to analyze ‘human brain fatigue’

Published the survey on Amazon Mechanical Turk globally

Created excel data collection file by segregating user’s entrees to determine response differentials

Determined respondent’s fatigue level, professional background: whether homemaker or working professionals?

ReeLabs, Mumbai, India (Aug 2011 – July 2012)

Business Analyst

ReeLabs is stem cell banking company. The project involved understanding of bioinformatics and business. It provided real time experience on cryopreservation process, enrollments, payments, and adjuster activity to identify trends and make timely decisions to manage workplace safety, reduce loss costs, and boost bottom line. The system generates reports that include analysis of injuries by line of business.

Responsibilities

Worked with Team leaders, identified and analyzed the given information, procedures and decision flows.

Evaluated existing procedure and methods.

Worked on MS Word and MS Visio for analyzing, managing and documenting requirements.

Collected business requirements, identified system interfaces and created the Required Specification Documents.

Prepared Process Flow diagrams, Activity diagrams and Use Case diagrams using MS Visio.

Analyzed requirement document by identify ambiguous, incomplete & incorrect requirements

Helped in developing attribute matrix and functionality Traceability Matrix.

Followed PMI standards throughout the project life cycle.

Environment

MS Visio, MS Project, UML, Rational Requisite Pro, SQL, Oracle, Java and MS Office Suite

Roche, Melbourne, Australia (Aug 2008 – June 2011)

Business Analyst

Description: The primary mission of the Genentech Research & Early Development (gRED) organization is to discover and rigorously assess promising molecule candidates for viable therapeutic benefits. The gRED Development Sciences division’s core mission is to translate scientific hypotheses into therapeutic possibilities by enabling the discovery and development of safe and effective therapeutics at optimal doses in relevant populations. As a gRED IT Business Systems Analyst (BSA), my primary responsibilities were to support the Development Sciences IT requirements process for in-house developed or purchased IT systems to meet functional area business needs in the Early Development functional domain.

Planning early stage project efforts; specifically, requirements gathering methods based on user community work style, requirements assessment and scoping, and project initiation and funding.

Collaborating with Project Managers, Architects, Engineers, Developers, and Designers on scope, solutions, constraints, and risks.

Analyzing, documenting, and advising on current and future business process models.

Analyzing and documenting high-level requirements (scope).

Analyzing and documenting detailed functional requirements and business rules (use cases).

Analyzing and documenting data requirements (from business needs perspective).

Analyzing and documenting task models that accurately represent a cross-section of a particular end-user community.

Planning and facilitating workshops and end-user working sessions intended to surface requirements and validate designs.

Environment:

MS Visio, MS Project Team foundation server 2005, SQL, Oracle, Java and MS Office Suite

Education

Masters of Business Administration (M.B.A) Fairleigh Dickinson University Teaneck, NJ

Master of Science (M.S) BiotechnologySwinburne University of Technology Melbourne, Australia

B. Tech BiotechnologyDr. D. Y. Patil Institute for Biotechnology & Bioinformatics Mumbai, India

Contact this candidate