SUMMARY:

• Certified Scrum Master with 5.5 years of experience as a Business Analyst in multiple domains including Confidential Strong understanding of project life cycle and SDLC methodologies like Agile and Waterfall.
• Highly skilled in SQL, good knowledge of ETL concepts, MS Excel, Lean Six Sigma certified
• Adept at creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Use Case, Sequence, Activity diagrams.
• Good knowledge of visualizations
• Working knowledge of Confidential including knowledge of EMR, EHR, HIE, HEDIS; Quality standards PQRS, NCQA, MACRA; Patient and Payers-Medicare/Medicaid, SCHIP; ICD-10 code
• Solid business communication, and presentation skills, adept at creating and coordinating extensive communication networks, written correspondence, reports, project status reports, PowerPoint presentations, e-mails).
• 5+ years of experience working on small to medium sized projects involving complex data sets and high variability .

TECHNICAL SKILLS:

TOOLS: Oracle SQL, Tableau, HPQC, ETL Testing, CRM, Toad for Oracle, Google Analytics, IBM Watson, Lucid Charts, SharePoint, Unix, MS Visio, RTC, HP ALM, HP Agile Manager, Familiar with CAWA, MS Excel, MS Word, MS PowerPoint, Familiar with SAS Enterprise Miner

SKILLS: Business Analysis, Data Analysis, Root cause Analysis, Defect Managemnet, Agile Development, Waterfall SDLC

PROFESSIONAL EXPERIENCE:

Confidential

BUSINESS DATA ANALYST

Responsibilities:

• Gathered business requirements from client through one-on-one & group interviews with client subject matter experts
• Analysed the obtained requirements from client to design Use Cases from BRD’s in an agile environment, with proper traceability from BRDs to Use Cases; got the Use Cases approved by Internal Business POCs & SMEs.
• Analysed functional requirements to develop user stories and use case descriptions for new decision engine functionality being implemented in the Health Business System of CVS to add flexibility for shipping of online orders for specialty drugs
• Reviewed master test plan, test scenarios, test cases and test data based on the functional requirements and reviewed test summary report at the end of every test cycle; hence improved code quality by 10% compared to previous releases
• Facilitated regression tests, UI tests, smoke tests and User Acceptance Tests (UAT); provided execution reports and status dashboards to higher management; meeting deadlines and standards for healthcare IT applications
• Created requirement traceability matrix (RTM) to link the functional requirements to test cases to track coverage
• Performed root cause analysis to verify the impact of different factors on the decision-making capability
• Generated standardized and ad-hoc reports on various operational measures of order and inventory management using SQL
• Trained 10 team members on ALM, defect logging, SQL developer for Oracle and CVS health care applications
• Liaised with customers and technology teams to troubleshoot data issues and close defects; thus achieving the goal of reducing delivery time of specialty drugs to patients by 35%.

Confidential

DATA ANALYST

Responsibilities:

• Designed data processing solutions for Integrated Information Platform for an ETL project; Created user stories from use cases so that the technical team could consume it; reducing downstream impacts by 33%
• Led a team of five to roll out data for 15 medical studies conducted by the client to reduce the cycle of clinical trials
• Reviewed test plan, outlined testing workflow and prepared over 200 complex SQL scripts to validate the flow of data from source through all the data layers; Verified flow of data from source to ingest to persist and to access layer
• Liaised with multiple teams such as support and operations teams for preparing contingency plan to reduce potential defects arising after development phase; thereby streamlining development and saving 400 man-hours.
• Interacted with data modeller’s and SME’s to understand the various ETL and business logics in the data lineage sheet; used the data transformations to develop complex queries to validate the business and data logics
• Worked closely with the QA lead to review and get the Test Plans, Test Cases & Test Scripts set up in HPQC and ensured the right naming convention to provide traceability; generated daily reports to lead defect triage meetings
• Monitored closely the Defect logging in HPQC and ensured the right script linkage is in place for each logged defect.
• Leveraging data from multiple sources, created dashboards and visualization on various KPI’S of clinical trials using Tableau
• Updated daily Excel report and weekly dashboards which classified work progress status to share with management & stakeholders; identified pending issues and delegated additional resources ensuring timely completion.

Confidential

ANALYST

Responsibilities:

• Formulated complex SQL queries to provide data to the client (leading Indian Telecom giant) for implementation of new service charge plans; gained client facing experience; thereby generating $100K revenue for Confidential .
• Created Excel-based reports using SQL-extracted data of customers details to analyse trends in sales to postpaid plans
• Executed advanced Excel functions like Confidential, pivot tables and row-level sorting to fabricate reports
• Provided resolution to customer post-paid related issues using incident tracker application, Customer Resource Management (CRM), Billing system BP Kenan and Toad for Oracle; reducing customer complaints by 15%.