Business Analyst Resume
West Sacramento, CA
SUMMARY
- 8 years of experience as Business Analyst/Data Analyst with hands on experience in Prison Industry, Justice and Public Safety, Insurance, Healthcare, Government Welfare Sectors.
- Strong knowledge of the Software Development Life Cycle methodologies (phases and gates) like Agile and Waterfall models.
- Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) across the deliverables of a project.
- Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).
- Effectively used Rational Requisite Pro to organize, track and change requirements of the system.
- Expertise of UML in visualizing and documenting the artifacts using Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams, Sequence Diagrams using MS Visio.
- Experience in facilitating Joint Application Development (JAD) sessions, conducting user interviews and acting as a liaison between the customers, development team and testing team.
- Experience in working with QA team to develop the test plans, test scenarios, test procedures, and test cases to ensure adequate testing of software both before and after completion.
- Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users as well as trained users to use the system configured.
- Analytical, methodical and resourceful approach to problem solving, identifying root causes and corrective actions to meet short and long - term business, financial and system requirements.
- Excellent verbal/written communication skills and strong analytical abilities and can perform well both independently and as a team player.
- Excellent understanding of the working of SharePoint application.
- Extensive experience in Functional testing, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, System Testing, Build Verification Testing, User Acceptance Testing.
- Good Knowledge of PMBOK and BABOK.
- Conducted JAD sessions, created Use Cases, workflows, screen shots and Power Point presentations for the Web Applications.
- Experience in conducting Feasibility Studies, Data Analysis, System Analysis, Gap Analysis, Risks Analysis and Root Cause Analysis (RCA).
- Gathered and documented functional and non-functional requirements.
- Experience in preparation of Deliverables, Business Requirement Documents (BRD), detailed Functional Specifications and Non-Functional Specifications, developing Use Cases and Test Cases.
- Experience with mainframe applications such as TSO, and CICS, and familiar with SQL Query Management tools like Toad for Oracle and the Query Analyzer in Microsoft SQL Server.
- Familiar with HIPAA EDI transactions such as 835, 837, EFT/ERA 270/271, 276/277 etc.
- In depth knowledge of SDLC in all four phases of a project: Inception, Elaboration, Construction and Transition.
- Performed UAT and exposure to Operational Readiness Testing (ORT)/SIT.
PROFESSIONAL EXPERIENCE:
Confidential
Business Analyst
Responsibilities:
- Worked with FMD customer(s) by processing their requests for IT, and non-IT purchases.
- Created DMCs for ETS IT purchase approvals.
- Analyze the best possible logical solution with proper documentation to support ETS purchase.
- Performed research analysis for best IT equipment purchase practices.
- Working on creating a FMD IT contracts document to clearly define the guidelines for ETS IT project(s).
- Continuously working on creating tools to clearly describe the scope of projects.
- Good communication, and writing/ documentation skills.
- Working on multiple projects, and coordinating with multiple teams at the same time.
Confidential
Senior Business Analyst
Responsibilities:
- Corporate Business Analyst on Patient Reviews project- Providing members with ability to review VSP Premier Practice doctors. Participating in entire lifecycle of project: Determining business needs and creation of Business Requirements documentation, working with UX designer on potential layouts for optimal user experience, collaborating with developers to assure BRD is met, participate in entire implementation phase, and perform user acceptance testing.
- Doctor Profiles- Addition of profiles for VSP Premier Practice Providers. Creating of BRD’s for project, UX design and UAT.
- VSP Redesign- Redesigning of VSP.com for a more seamless experience for million members. Analysis and research on which design would provide optimal experience for members. Creating of Business Requirements documentation, based on final design choice by business.
- Meeting business partners, conducting JAD sessions, drafting BRD’s, creating test plans and UAT of all implementations.
- As a business analyst, I am extensively involved in identifying the efficient solution(s) in accord with the best practices, and standards available in the industry.
- Followed the agile scrum methodology to work on multiple projects at the same time.
- Wrote user stories for multiple website portals, keeping the high standards for validation rules like error messages, login credentials etc.
- Evaluate business process changes to identify and document business impacts and benefits.
- Act as subject matter expert to provide business requirements for process improvements and system enhancements.
- Conduct effective interview/research to determine and document the stakeholders, business needs and requirements
- Create and analyzes workflow diagrams.
- Review technical design deliverables to ensure business objectives are reached.
- Assist business stakeholders with user acceptance testing, defect reporting and resolution.
- Assist with training including identification of needs, development of materials, communications of changes, manuals, etc.
- Provide post implementation support, such as, problem resolution, adjustments to new procedures, and change management.
- Develop presentations of materials, models, findings, plans and/or conclusions.
- Continually looks for process improvement strategies.
Confidential
Senior Business Analyst/ Quality Analyst
Responsibilities:
- I have extensive knowledge of the complete SOMS (eOMIS application) project and all of the modules - Counts, Sentence Calc, Court Commitments for an inmate, Sentence Components, Classification, Programs, Hold and Warrants, Demographic & Personal profile of an Offender, External Movements, Parole functionality, Offender Appointment System, daily, weekly, and real time reports generated from the system, and that are currently in production for CDCR.
- As a BA, I have worked with CDCR and 23 downstream interface partners (DAPO, California Corrections Electronic Health Care System, California’s Department of Justice, California’s Secretary of State, Social Security Administration, Board of Parole Hearing, Lifer Scheduling and Tracking System, Disability and Effective Communication System, Department of Child Support Services, Sacramento Sheriff’s Department, FBI etc.) to identify their system requirements, to resolve system constraints to successfully implement the SOMS project in production.
- As a BA for SOMS project, I am extensively involved with CalParole Replacement project, starting from conducting JAD sessions, conducting client meetings, identifying requirements, and documenting the requirements.
- Gathered requirements by conducting meetings and brainstorming sessions with end users and Subject Matter Experts.
- Documented the client-approved requirements in GSD (General Systems Design) document.
- Conducted bi-weekly internal team meetings to identify system constraints.
- Worked with developers to created DSD (Detailed System Design) specification documents.
- Created Interface specification design documents for CDCR’s downstream partners (Interface partners).
- Extensively involved in identifying the issues, defects and problem statements with the project team.
- Created Remedy Tickets in HP Service Manager for any production defects, issues, change requests.
- Attended bi-weekly Quality Assurance Board meetings to decide the schedule for system downtime to implements change requests.
- Kept the GSD, DSD, and Interface specification documents updated, based on the new changes that are implemented via change request in production.
- Conducted training sessions with training department to provide the updated information to the CDCR customer service department.
- Complete understanding of California Corrections Electronic Health Care System (CCHCS), Electronic Record Management System, Rule Violation Reports (Discipline) project, Security Threat Group phase 1 (Gang sets, and subsets).
- As a BA, I am extensively involved with developers in Unit testing to identify, investigate and fix the defects.
- As a Quality Analyst, I am extensively involved with system testing, regression testing, component integration testing.
- I have complete understating of CDCR’s database tables for CalParole Replacement project.
- During regression testing, wrote SQL queries to extract data from the database, and validate the data with the existing record in eOMIS application.
- Extensively involved in User Acceptance Testing.
- Extensively involved in lifecycle testing with CDCR and downstream partners.
- Validated the data generated by eOMIS application with downstream interface partners.
- Used Autosys tool to force start jobs and reports from the system during lifecycle testing phase.
- Identify any issues or mismatch of data generated from the system and the reports that are delivered to the interface partners.
- Conducted thorough investigation on issues reported by CDCR and interface partners.
- Investigated, and logged the defects in HP QC tool, and assign it to appropriate resource to resolve the defect.
- Conducted bi-weekly defect status meetings with CDCR and interface partners, and provided status.
- Because, I had worked as a BA on CalParole Replacement project, and because of my knowledge of all the modules of SOMS project, I was the main point of contact for all the questions, issues reported by CDCR and downstream interface partners during lifecycle testing during CalParole Replacement project.
- Currently working on Data Center Migration project to migrate CDCR’s database to cloud based database storage.
- Writing test scripts for complete CDCR database including all domains of SOMS application, reports generation and data validation, interface partner validation test scripts.
Confidential, West Sacramento, CA
Business Analyst/ Data Analyst
Responsibilities:
- As a BA, extensively involved in SDN 13001 (Modify Paper Claim Forms) starting from the beginning of the SDLC phases: Inception, Elaboration, Construction and Transition.
- Hands on experience with the processing of a CMC and paper claims, including RTD process, claims denial process.
- Extensively involved with mailroom, claims prep team, KDE/OCR team to identify the impacts of replacing the old CMS 1500 (08/05) claim form with the new CMS 1500 (02/12) claim form.
- Complete understanding of how a claim is processed on paper claim form 30-1, 30-4, 25-1, Appeals, CMS 1500 (02/12), as well as a CMC (Computer Media Claim).
- Modified rejection letter 88-J-28 to add new post ICD-10 project implementation information.
- Conducted daily, weekly and monthly meetings to capture and document requirements.
- Conducted JAD sessions with the client to identify and document requirements.
- Understood problem solving and conflict management, including the ability to manage conflict and find mutually acceptable resolutions.
- Co-ordinated the team effort with the ICD-10 project team to identify and root out gaps between ICD-10 project and SDN 13001 (Modify Paper Claim Forms).
- Attended regular defect control meetings.
- Extensively involved in identifying the issues, defects and problem statements with the SDN team and ICD-10 project team.
- Extensively involved with publications department in writing and publishing over 40 provider bulletins, news flashes, and making updates to over 30 provider manual sections using DCN process.
- Worked with project team and DHCS to solve project related issues and defects.
- Experience with PROD support and co-ordinate effort to solve PROD issues.
- Working on to update the Companion Guide using the Council for Affordable Quality Healthcare (CAQH) Committee on Operating Rules for Information Exchange (CORE) v5010 Master Companion Guide Template per the CAQH CORE Phase III Operating Rule 350.
- Gathered requirements to implement Uniform Use of Claim Adjustment Reason Codes and Remittance Advice Remark Codes (835) per the CAQH CORE Phase III Operating Rule 360.
- Establish written Late/Missing EFT and ERA Transactions Resolution Procedures defining the process a healthcare provider must use when researching and resolving a late or missing healthcare EFT Standards payment and/or the corresponding late or missing ASC X12N 835 per the CAQH CORE Phase III Operating Rule 370.
- Wrote and documented requirements for the implementation of the Eligibility and Benefits Batch Response Time per the CAQH CORE Phase I Operating Rule 155.
- Wrote and documented requirements Implementation of the Eligibility and Benefits System Availability per the CAQH CORE Phase I Operating Rule 157.
- Identified and defined the additional data elements within the ASC X12N 270 Batch Processing Detail Report.
- Experience in working on a mapping document defining CARC/RARC/CAGC combinations for claims based on CORE-Required Code Combinations for CORE-defined Business Scenarios, version 3.0.4, published February 01, 2014.
- Gathered and documented requirements to communicate the procedures to resolve late/missing EFT (Electronic Fund Transfer) and ERA (Electronic Remittance Advice) transactions according to the CAQH CORE rule requirements.
- Gathered and documented requirements for Batch ASC X12N 277 Response Transactions for the corresponding ASC X12N 276 requests.
- Experienced in working with TSC and Cash control unit training program and SOP manual updates.
- Experienced in working with TSC and O&E Training department.
- Experience with SYSIN table creation and updates verification.
- Complete understanding of CA-MMIS tables in TSO and Layouts.
- Experience with mainframe production and system test application/ modules, including provider sub - system, PcMF inquiry screen, diagnosis code inquiry screen, and the corresponding sub-system applications.
- Complete understanding of CA-MMIS eligibility screens, diagnosis Icd-10 to 9 crosswalks.
- Experience in working with mid-range applications like SURS, TAR/SURGE, LSMS, OLCC application.
- Complete understanding of POS device processing of a claim.
- Experience in working with a project related to deactivation of legacy IDs.
- Experienced and understanding of San Mateo HCP 703 CCS only Aid Code 9D.
- Experience in working on projects related to managed care plan and fee-for-service claims.
- Complete understanding of claim type 01, 02, 03, 04, 05, 06, 09, appeals, CIF, and crossovers.
- Experienced in updating the 16 POS user and technical manuals.
- In process of coordinating the training effort for the stakeholders and users for the new VX 520 POS device.
- Complete understanding of implementation of Affordable Care Act aid codes.
- Implemented more than 40 ACA aid codes to the medi-cal reports MR-O-145, MR-O-151, MR-O-351, TP-O-412, and TP-O-740 for federal funding participation distribution based on emergency, pregnancy, ambulatory, LTC services.
- Complete understanding of full scope and restricted ACA aid codes.
- Complete understanding of mapping the ACA aid Codes to CMS 64 system.
- Created 4 new special reporting categories for ACA aid codes.
- Did extensive research to find impacts and constraints to map the ACA aid codes 4 existing fund codes in the CMS 64 system; and successfully mapped.
- Extensive experience in working with CHDP reporting and funding.
- Experienced in creating excel tools for the accurate documentation of interaction of team members during the all the 4 phases of waterfall SDLC.
Confidential, Austin, TX
Business Analyst/Data Analyst
Responsibilities:
- Conducted meetings with the team members to organize and finalize the working hours and resources.
- Prepared a detailed BUR (Business User Requirement) document to explain working of the project to the stakeholders.
- Define business and user requirements.
- Defined in scope and out scope requirements.
- Gathered requirements by conducting meetings and brainstorming sessions with end users and Subject Matter Experts (SME).
- Verified assumptions and constraints with the team members.
- Extensively used data mapping from source to target and target to source for Sun to Oracle migration of database.
- Wrote use cases for the system.
- Hands on experience in writing test cases from business requirements and use cases.
- Defined system requirements in the detailed design process.
- Performed extensive Requirement analysis and developed use cases and workflows.
- Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams.
- Extensively involved in regression, integration, and UAT testing.
- Worked on java code with the developers to verify table and column names from the database to be transferred.
- Created graphical representation of reports as per the End user requirements using Business Objects and Crystal reports.
- Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update the scripts.
- Prepared and executed test cases for Navigational test, Functionality testing and GUI testing.
Environment: Requisite Pro, Rational Rose, Agile, Java, HL7 Interfaces, PL/SQL, HTML, MS Office, MS Visio, EDI, Rational Clear Quest, Rational Clear Case, UML, RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio.
Confidential, Erie, PA
Application Process Analyst
Roles and Responsibilities
- Conducted interviews with stakeholders to gather requirements and generate project plan.
- Gathered project plan specifications by conducting interview sessions with stakeholders and users.
- Helped in creating the layout of a user-friendly interface design.
- Depending upon the need of the project, I have discussed the database with the project team.
- Designed a work flow diagram for the understanding of the stakeholders.
- Attended the meetings with the business as well as development participants for discussing results, decision-making and planning of the testing processes.
- Estimated time hours and budget needed for the development and later implementation of the project with the stakeholders.
- Worked closely with the development team on SQL Server 2003 to understand the database.
- Created a web based application using asp.net with C# as a front-end application.
- Connected the front-end application with the existing database using SQL Server 2003.
- Solved several constraints and compatibility issues regarding working and implementation of web - based application.
- Wrote code for the web-based application for the design of the main page of the system and its sub-pages.
- Wrote use cases in detail for the better understanding of the end users.
- Designed architectural diagrams, business processes, context diagrams, block diagrams, high level and low level use case diagrams, product development cycle, flow charts, UML diagrams, entity relationship diagrams, and traceability matrix as a part of project report for the better understanding of the project team.
Environment: Windows XP, Windows Vista, Windows 7, Internet Explorer, SQL Server 2003/2005, Microsoft Visual Studio 2008, Mercury QC, MS -Office, MS - Visio.
