Sr. Business Analyst Resume
Sacramento, CA
SUMMARY
- Experienced in conducting Joint Application Development (JAD) sessions and Discovery Workshops for requirements gathering, analysis and design
- Drafted Requirements Traceability Matrix (RTM) to check the project requirements and to track the documentation and project tasks
- Appraised the AS - IS and TO-BE business processes (GAP analysis) and experienced in converting these requirements into technical specifications for preparing Test plans.
- Worked on Waterfall, Hybrid and Agile SCRUM methodologies.
- Experienced in creating UML diagrams like Activity, Use case and Sequence diagrams using tools such as Rational Rose and Microsoft Visio
- Experienced in Web Enhancement projects related to improving customer and user experience at payer side applications.
- Vast experience in dealing with the Claim Processing System adhering to HIPAA compliances.
- In depth knowledge of ICD-9-CM, ICD-10-CM structures
- Experienced with various Hospital reimbursement methods like DRG, Per Diem, Capitations
- Corresponded regularly with the development team, database designer, system administrator and the higher management to meet the deadlines of Project milestones
- Created Requirement Traceability Matrix (RTM) to relate the requirements on a Parent-Child basis and track the documentation and project tasks using Rational Requisite Pro
- Participated in several Sprint Planning, Sprint Review, Daily Scrum and Backlog Grooming Sessions
- Involved in reviewing Test plans, Test strategies and Test cases with the QA team.
- Experiences in manipulating and retrieving data from database using SQL Queries.
- Experience with Statistical Analysis System(SAS)
- Experienced in development of metrics, reporting and dashboards including excel reporting (Charts, vlookup and advanced formulae).
- Experienced in SQL Server Reporting Service (SSRS), SQL Server Integration Service (SSIS), Executing Queries and Running Stored Procedures Knowledge of Data-warehouse and ETL process.
- Well-versed with Relational and Dimensional Modelling techniques like Star, Snowflake Schema, OLAP, Fact and Dimensional Tables.
- Worked on data integration of multiple data sources and targets like Oracle, SQL Server, and MS Access, Flat files and XML.
- Strong experience in leading UAT/ SIT (SystemIntegration testing) plans and test cases based on theBusiness/SystemRequirements.
- Excellent communication and presentation skills. Experience working with business user as well as senior management
- Experience in working with cross functional teams and translate business needs into solution requirements.
- Worked individually, as well as in team environment, to achieve project goals
TECHNICAL SKILLS
Project Methodologies: Agile Scrum, Waterfall, RUP
Database Oracle: 9i/8i, MS-SQL Server 2005/2008, MySql4.x, Data warehouse, ETL, Zoho
Operating System: Windows, Vista, DOS, Mac
Microsoft tools: MS Outlook, MS Project, Microsoft Office Suite, SharePoint
Data modeling tools: MS Visio, balsamic, mock up, pencil
Testing tools: Mercury Quality Center, HP ALM, Soap UI
Tools: and Package Rational Requisite: Pro, JIRA, TOAD, Trello, SPSS, SAS
PROFESSIONAL EXPERIENCE
Sr. Business Analyst
Confidential, Sacramento, CA
Responsibilities:
- Worked in a Hybrid Agile project delivery environment facilitating Epics, Themes, user stories, sprint planning, daily scrum/stand-ups, sprint review, sprint retrospectives and demos onto Rally Agile development software
- Responsible for working with the State to review and modify process flows to increase productivity and effectively utilize enterprise solutionfeatures not provided by the legacy systems.
- Actively involved in analyzing the Web Service Application and Check the API documents.
- Created detailed report specification document that included KPI descriptions and data mappings.
- Interviewed the stakeholders and project sponsors for mappingrequirements and analyzing structured & normalized data sets
- Responsible for Requirement Gathering from business, Requirement Analysis, Functional Point Analysis, Client Interaction, Work Allocation to the team members in accordance to focus factor
- Identified the tools and data models to translate and migrate data such as, SQL Server (ETL)
- Captured business rules related to access rights related to reports, in compliance with HIPPA regulations and security standards
- Completing the Fit Gap and impact analysis and identifying gaps between the current and future state.
- Worked closely with development teams to create new reports and migrate old reports to new system
- Co-ordination with the Dev Ops team for smooth transition.
- Worked closely with database teams to help them transform the data from flat files, excel sheets, pdfs and other databases using ETL (Extract Transform Load) techniques
- Owning and managing requirements traceability matrix (RTM), gap analysis and change impact to enable business processes
- Conducted/Part of Release Readiness reviews, Milestone Reviews, and Business Go/No-Go reviews
- Identified various Key Performance Indicators (KPI) for daily, weekly and monthly reporting
Business Systems Analyst
Confidential, Richardson, TX
Responsibilities:
- Reviewed detailed documentation for EDI X12 837 transactions including loops, segments and data elements.
- Extensively worked withSMEsto better understand the existing standards and conduct Gap Analysis ofEDI 837 transaction.
- Performed data mapping and data modeling and used canonical data model to map data fromX12 834 transactions.
- Did the forward andbackwarddata mapping between the fields in mainframe andFACETS.
- Worked onData tables and created audit reports using queries. Manually loaded data inFACETSand have good knowledge onbusiness rules.
- Documented business and logical rules for impacted segments.
- Gathered requirements afterconducting Discovery workshopswith the purpose of defining the business and system requirements.
- Created the Product Backlog and converted PBIs to detailed user stories.
- Made sure the conversions were according to CPT, HCPCS and Modifiers adhering to HIPPA regulations
- Developed Sprint Burn down chart to check if the delivery of the system is on time.
- Ensured the compliance of the EDI transaction (837- Healthcare Claim Form).
- Ensured smooth translation of the business requirements to the developers at various Sprint cycles.
- Mentioned in the Sprint Backlog and also ensured that all the rules were followed.
- Leaded the team in conducting User Acceptance Testing for the Claims Processing System.
- Worked with QA team to test the application quality and perform UAT, conducted Root Cause analysis for UAT environment.
Sr. Business Systems Analyst
Confidential, Plano, TX
Responsibilities:
- Elicit requirements by conducting phone interviews, JAD sessions with SMEs and clients.
- Participate in IVR review sessions to understand the current process and document GAP analysis.
- Captured business rules for new features to be added to IVR system
- Measured system behaviour by producing system use cases to capture all the functionalities expected from updated system.
- Tuning analysis - using various speech recognition analysis/tuning tools & methods (Nuance Application Report (NAR)), live call monitoring, call logs, analyse caller behaviour and transaction success rates with respect to IVR applications.
- Create tuning reports that include a detailed analysis of areas in an IVR application needing improvement and include recommended enhancements.
- Create and maintain a method of tracking the success rates of tuning enhancements.
- Recommend speech and touch-tone user interface design enhancements via call flow, dialogue, and/or prompt change.
- Assist in implementing design changes by interacting with designers and developers, directing voice talents, and by managing usability tests
- Collaborated with testing teams for running detailed UAT tests before roll out.
- Work with business and call centre resources to better understand the needs of each with respect to IVR, in an attempt to put forward detailed & balanced tuning enhancement recommendations.
- Keep an open & persistent line of communication with call centre & business resources to understand operational changes and potential impacts to IVR usage.
- Act as the liaison between our Legal, Audit, Risk and Compliance teams to ensure that IVR systems are managing risk appropriately.
Business Systems Analyst
Confidential, Dallas, TX
Responsibilities:
- Facilitated and led group discussions in Joint Application Development (JAD) sessions and elicited functional and non-functional requirements.
- Responsible for accuracy of customer profile and engagement data.
- Deployed, configured and supported the prototype application for its demo /UAT for various segments of customers, prepared deck for UAT & gathered feedback and followed up with further updates on the prototype and related documents.
- Primarily involved in developing use case document for the application, traceability matrix, system requirement specification (SRS) and presentations for proposed solution
- Worked on various Salesforce.com Standard objects like Accounts, Opportunities, Leads, Campaign and Reports.
- Created various Custom objects, Tabs, Workflows, Reports, Apex triggers and validation rules for the application.
- Defined various Validation rules to validate the data in the application.
- Customized Page Layouts for Salesforce.com Standard and Custom objects.
- Created custom report types and generated report using the report types.
- Experience in working with Development team for solving the gaps in Business requirement
- Used Data loader for all data adding, updating, and deleting, exporting data.
- Documented Sales force fundamentals and reporting for easy understanding and navigation for business users
- Familiar with SFDC MVC architecture, Salesforce.com Sales cloud, Service cloud, Data cloud functionalities.
- Worked on SQL queries for data extraction from Salesforce
Business Analyst
Confidential, San Jose, CA
Responsibilities:
- Followed Agile-SCRUM methodology to build the application. Participated in scrum-planning meetings, daily standup meetings and retrospective meetings and ensured the status is updated
- Conducted Backlog grooming sessions for capturing epics and user stories with Product owner and the team.
- Captured customer specific information by working closely with Product Owners and Business Users.
- Tracked and managed product backlog, burn-down charts and story points.
- Created activity diagrams and use-cases to capture information flow between the website and backend systems.
- Created wireframes and mockups for the web interface and discussed with UI designer to develop the prototypes for the website.
- Completing impact analysis of new requirements and accommodate change requirements in coming sprints.
- Identified and documented data sources needed to fetch and populate required data fields.
- Created data dictionaries for capturing customer information in the required forms.
- Reviewed test plans and test cases and ensuring test cases reflect user needs; responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs
- Documented the potential functional improvements in the current information system as future enhancements
