Business Analyst Resume
OH
SUMMARY
- Eight years of experience in the fields of Finance & Banking (five years), Venture Capital (two years), and Healthcare (one year).
- Strong knowledge of SDLC methodologies such as Agile (Scrum), RUP and Waterfall with hands on experience in all of them.
- Extensive experience in Business Analysis, Requirement Gathering and Analysis, Business Process Modelling (BPM) and Software Validation.
- Experience in usingbusiness modeling tools like MS Visio and Unified Modeling Language (UML) for creating Use Case Diagrams,BusinessProcess Models, Process Flow Diagrams, Class Diagrams, Activity Diagrams, Sequence Diagrams, and workflow diagrams.
- Expert in using MS Visio for creating User Interface (UI) mockup screens/wireframes.
- Presenting requirements in graphical form with use of prototypes, and Process maps.
- Designed “AS - IS” and “TO-BE” process flow diagrams, performed SWOT Analysis, Risk Analysis and Gap Analysis.
- Expertise in creating numerous artifacts such as Business Requirement Document(BRD), Functional requirement Document(FRD), writing and maintaining Test Matrix and Requirements Traceability Matrix.
- Expertise in conventional and non-conventional requirement elicitation techniques such as Joint Application Development (JAD) sessions, brainstorming, document analysis, project meetings, prototyping, questionnaires, focus groups, and interviews.
- Experience in creating Product Backlog, Sprint Backlog and facilitate sprint planning and review meetings.
- Performed planning and development of Test Plans, Test Cases and Test Scenario to meet product’s business and solution requirements.
- Worked collaboratively with the Development and Quality Assurance teams during the Test Life Cycle in understanding and documenting Test Cases and performing User Acceptance Testing (UAT).
- Experience in various Healthcare areas like Enrollment, Benefits, Claims adjudication, Migration, Provider, Eligibility, Prior authorization for Medicaid and Medicare programs.
- Broad understanding of medical management (Medical, Pharmacy, Claims, Provider, Customer eligibility data, Client structure, and Benefits), claims clinical data quality metrics, and health outcomes.
- Strong knowledge on Guidewire Billing Center, Policy Center and Claims Center integrations.
- Worked with various FACETS online modules such as Billing, Provider, Claims and Membership/Subscription modules.
- Strong experience in Regression analysis and designing Predictive models to forecast budget and pricing.
- Core expertise on scheduling and project scope.
- Expert at increasing company revenue and productivity through detailed cost analysis.
- Proven ability to serve as a liaison between technical developers and product management.
- Strong verbal and written communication, presentation skills.
- Excellent Problem-Solving skills, Multi-tasking skills, ability to meet deadlines, ability to work under pressure and deal with ambiguity.
TECHNICAL SKILLS
Database: MySQL, MS Access
Language: R, SQL, Python
Software: R, SPSS, JIRA, MS-Suite (Word, Excel, Access, Project, PowerPoint, Outlook), MS SharePoint, Adobe Acrobat
Design Tools: MS Visio, Rational Rose
Analytical Tools: Google Analytics
Data Visualization Tools: Tableau, Shiny R
Methodologies: Agile, Waterfall, SDLC
PROFESSIONAL EXPERIENCE
Confidential, OH
Business Analyst
Responsibilities:
- Perform Need Analysis and SWOT analysis to check the level of enhancement required as per the new business requirements.
- Provide data driven solutions by analyzing internal and external data on consumers, competitors and market place.
- Analyze and interpret data to identify trends, patterns and opportunities for the business and clients and formulate recommendations to advise clients through written research reports, industry updates, and presentations.
- Clarify client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
- Assist clients in development of Business Requirements by doing a Feasibility Study and Market Analysis to understand the trends, and create visualization dashboards using Tableau.
- Identify areas for improvement and increased sales and marketing opportunities of our clients through various comparative analytics, statistical and data mining techniques.
- Conduct JAD sessions with stakeholder and technical team to gather requirements.
- Extensively worked with different phases of SDLC involving preparation of Business Analyst Test scripts, Low effort low complexity work forms for IT testing and UAT approvals.
- Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
- Drive strategic business decision making through detailed analytics, insights and Real-Time reporting on Key Performance Indicators (KPIs) and financial results.
- Using data analysis techniques to validate business rules.
- Track and report key business performance metrics, sales trend, and campaign performance using digital marketing analytics.
- Create innovative executive dashboards, scorecards, and weekly/monthly reports on the status of key business measurements using Tableau features such as such as parameters, sets, calculated fields and table calculations, user filters, action filters and applying advanced technical charts.
- Handle portfolio steering committee meeting and monitor performance of portfolio companies to anticipate necessary adjustments to strategies.
- Analyze Business Requirements and translate them into HP Project and Portfolio Management (HP PPM) functional requirements.
- Prepare Functional Specification Document (FSD), Business Requirement Document (BRD) and Technical Design Document (TDD) for the detailed expansion of the functionality and going over it with the technical as well as the testing team.
- Present findings using rich interactive graphics like Shiny R and data visualizations to identify the usage and growth pattern that have high impact on business decisions.
- Help client in designing business plans including revenue forecasting and marketing strategies.
- Analyze current market trend to determine the viability of the business - identify the key risks associated with the investment and develop a risk mitigation plan.
- Analyze the performance of client’s website using Google Analytics.
- Responsible for creating Project Control Plan, Risk and Issue Management Process.
- Assist co-business analyst in drawing data flow diagrams and process flow diagrams using MS Visio.
- Provide hands-on project schedule management using MS Project during the various stages of the project.
- Keep a check on Sprint burn down’s daily updating to reflect the progress of the sprint backlog.
- Facilitate sprint review meeting to review the completed work and presented it to the stakeholders.
- Provide ad/hoc financial analysis and reporting in support of annual contract renewals.
- Define, retrieve, and analyze large datasets usingSQL, and Excel to drive and define operational solutions and approaches.
- Track issue, develop iteration reports and project management functions using JIRA.
Environment: Tableau, Shiny R, HP PPM, MS Project, MS Visio, MS Office suite, SQL, MySQL, SharePoint, Agile (SCRUM), JIRA, Google Analytics, SWOT Analysis, GAP Analysis
Confidential, OH
Sustainability Investment Manager
Responsibilities:
- Assessed endowment investment of $4 million in sustainable corporations and entities and recommended strategies for increasing investment in these corporations and entities.
- Performed business and industry analysis, and competitive benchmarking of sustainability performance using digital marketing analytics.
- Derive, synthesize and provide actionable insight recommendations from complex data mining and analyses.
- Worked cross-functionally to understand key stakeholder needs.
- Produced reports & maintain KPI dashboards to monitor the performance of the account, competitive analysis and promotional analysis along with insights using Nielsen.
- Assisted with business reviews, internal and external presentations.
- Experienced in data processing and analysis, developing metrics and projections based on analysis results, and report writing.
- Actively participated at the Sustainability Committee meetings.
- Conducted SWOT analysis and Cost benefit analysis including ROI and Financial Justification.
- Market positioning, financial modeling and valuation analysis - IRR analysis, discounted cash flow valuations, investment valuations, and comparable company analysis.
Environment: Bloomberg, SWOT analysis, Cost Benefit Analysis, Financial modeling, MS Project, MS Office suite, SQL, MySQL, SharePoint, Nielsen.
Confidential
Healthcare Business Analyst
Responsibilities:
- Interacted with healthcare clients, performed document analysis, created prototyping, and conducted interviews to analyze their data and gather requirements, objectives, and input and output requirements.
- Performed Claims and Adjustments, translated market needs, use Cases and business requirements into complete User Stories.
- Gathered requirements and prepared functional documents forFACETS4.71.
- Analyzed the feasibility of and developed requirements for new systems and enhancements to existing systems.
- Designed BRD and FRD as per the User requirements and uploaded the document in Knowledge Link.
- Analyzed data architecture, documented and delivered data mapping and performed risk analysis.
- Created UML diagrams (use case, activity, sequence, and component diagrams) and Flowcharts using Rational Rose and MS Visio.
- Implemented the SDLC for the developing life cycle and followed the standards process in the application.
- Performed gap analysisforHIPAA P and 835transactions andHIPAA Pand835transactions.
- Ensured all artifacts complied with HIPAA 5010 guidelines.
- Created AS IS and TO BE documents to show the current and proposed functionalities of the system. Subsequently broke them down by brainstorming with different team members to get the low level ‘To Be’ well.
- Involved in data mapping usingFacets data model.
- Worked withFACETSTeam for HIPAA Claims Validation and Verification Process.
- Managed and developedEDIspecifications, for data feeds and mappings for integration between various systems to meet HIPAA requirements.
- Performed Gap Analysis to analyze the gap that exists between present status of the system and the HIPAA changes.
- Identified specifications for billing and accounts receivable requirements, performed GAP and presented information to IT team to identify system requirements.
- Predicted future trends in cost, utilization and performance using statistical methodologies (extrapolation, interpolation) to provide analytic support for finance, pricing and actuarial functions.
- Measured and analyzed financial/performance management metrics and utilization metrics of healthcare.
- Identified and investigated complex suspect areas regarding medical cost issues.
- Involved in Claim validation and Pend/Denied Claims Analysis for the Health plans Medicaid programs.
- Involved in data mapping usingFacets data model.
- Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
- Performed code reviews, Test Plans, Test Strategy, System testing, End-to-End Testing, System Integration testing (SIT), and User Acceptance testing (UAT) followed by production verification, post production testing and support.
- Recommended changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes.
- Tested different functionality of the application like Medicaid eligibility data, Medicaid claim processing etc.
- Worked with and managed vendors, outside consultants, and other third parties to improve information security within the organization.
- Analyzed corporate healthcare business processes to develop customized solutions.
- Assessed business impacts and make recommendations through use of healthcare analytics and predictive modeling.
- Wrote SQL Queries in MS Access to sort data and analyze the large set of data during project life cycle.
Environment: Facets, EDI, HIPAA, Quality Center, MS Project, MS Visio, MS Office suite, SQL, SharePoint, RTM.
Confidential
Business Analyst
Responsibilities:
- Led conversations with different level of Stakeholder and SME’s to identify requirements, use cases and to develop functional, nonfunctional and information requirements.
- Conducted JAD sessions, focus groups to allow different stakeholders to communicate their perspectives with each other, resolve any issues, and come to an agreement quickly.
- Reviewed requirements and understand technical recommendations and constraints, and developed comprehensive and accurate Functional specifications; Data Mapping, and Process flows.
- Analyzed the system from both Technical and Business perspectives and prepared Business Alignment Document (BAD) and Business Operating Document (BOM).
- Responsible for identifying and maintaining a clear and measurable software development process that is deployable throughout the enterprise using SDLC industry best practices.
- Created visual models to enable collective understanding of process, data flow, user interaction and others as needed.
- Designed Retail Banking Business Process Model (Activity diagrams, Sequence diagrams and Collaboration diagrams), developed Use Cases, UML diagrams.
- Responsible for creating the Retail Banking BRD and the Retail Banking Functional Requirement Document (FRD).
- Responsible for creating and maintaining documentation related to the project including scope document, vision document, functional specification document, defect status report, risk analysis document, mitigation plans, supplementary requirements specification document and impact analysis document.
- Identified and documented issues, risks and gaps, their description, their impact and provided recommendation and alternatives to develop the application to meet the user requirement.
- Documented the server requirements and requirements related to security within SharePoint and using Windows Active Directory.
- Experience in Multi-factor authentication and password vaulting controls.
- Coordinated with Test Team to develop Test Plans, Test Cases and Test scripts.
- Assisted with UAT, developing and maintain quality procedures, and ensuring that appropriate documentation is in place.
- Responsible for design, information architecture and user experience of newly proposed websites and web-based E-commerce applications.
- Helped project manager in developing schedules in MS-Project or Gantt charts.
- Developed SQL queries to extract data.
Environment: MS Project, MS Visio, MS Office suite, SQL, MySQL, SharePoint, UML, RUP
