Business Analyst Resume
SUMMARY:
- A Professional with 11 years’ experience as a Business Analyst in various domains. Expertise in different phases of Software Development Life Cycle (SDLC) with proficiency in Agile, Scrum, RUP and Waterfall Methodologies. Extensive experience in Unified Modeling Language (UML) diagrams such as Use case Diagrams (UCD), Sequence Diagrams and Activity Diagrams and State Diagrams.
- Thoroughly experienced in creating requirement specifications by facilitating Joint Application Design (JAD) sessions and structuring interviews. Excellent Knowledge of Business Requirement Document (BRD), Functional Requirement Document (FRD), Project life cycle with outstanding Business Analysis, Project Planning, Workflow, Execution and Control with ability to support multiple simultaneous short - term projects.
- Experience in creating and maintaining Requirement Traceability Matrices (RTM), conducting GAP Analysis, SWOT Analysis. Expertise in writing SQL queries to extract data from different databases and perform data analysis.
- Thorough experience in creating Scope and Vision Document, SRS, BRD, FRD by utilizing various modeling techniques including UML, BPMN, Wireframes.
- Knowledge about HIPAA, Medicare and Medicaid (CMS) claims, claims processing, ICD-9/ ICD-10 using DSM-5, 4010 and 5010 standards. Knowledgeable in-Patient Enrollment Process & Life Cycle of a Claim
- Excellent verbal/written skills and can perform well both independently and as a team member
- Experience and good understanding of the hospital system including Registration, Scheduling, Pharmacy, Patient Accounting, HIM, Claim Processing functions.
- Experienced with Oracle E-Business Suite (Procure to Pay) and Oracle PeopleSoft Financials.
- Good experience in Application model development in Oracle Policy Automation (OPA) including designing OPA model, authoring OPA rules, Interview screen etc. Hands on experience in data warehousing, data analysis, and/or data visualization. Good understanding of Section 508 Compliance testing using standard tools.
- Experience working with teams located in different geographies and time-zones
- Experience in PeopleSoft HRMS (Core HR, NA Payroll, Security), Financials (Accounts Payable, Receivable), E-Business Suite (Procure to Pay)
- Experience with enterprise upgrades to workstation OS, Microsoft Project Server, and Microsoft Exchange.
TECHNICAL SKILLS:
Software Methodologies/ Models: Waterfall, Agile
Agile Methodologies: Scrum, Kanban
Requirement Management Tools: IBM Rational Requisite Pro, Blueprint
Operating Systems: Windows, Linux, UNIX
Database Management Systems: MS SQL Server, MySQL, MS Access, Oracle
Enterprise Tools: PeopleSoft HCM 8.X, 9.X
Programming Languages: C, C++, Java, Unix
Testing Tools and Defect Tracking Tools: ALM/ HP Quality Center, HP LoadRunner/Performance Center, JIRA
Business Modeling Tools: MS Visio, Rational Rose
Content Management Tools: SharePoint, Apache Subversion (SVN), TFS.
Business Intelligence: Informatica
Documentation Tools: MS Office (Excel, Word, PowerPoint), MS Project, Adobe Photoshop
PROFESSIONAL EXPERIENCE:
Confidential
Business Analyst
- Currently working on the NYSoH application as Business Analyst.
- Making sure that the Change Requests are carried right from their initiation to deployment by coordinating with various business stakeholders, vendors by following multiple deadlines and getting concurrences on multiple documents accordingly.
- Providing feedback on various specification documents and then sending them for baselining so that the testing team creates test scenarios on the baselined document.
- Validated the EDI 834 Reconciliation of various Issuers records and provided detailed documentation of the validated records to the Operations Team.
- Worked on three VLP (Verify Lawful Presence) Change requests whose ROM (Rough Order Magnitude) was determined to be more than 5000 hours and made sure that the CRs have been delivered on time.
- Created Specification documents for 3 technical Change Requests which increased the efficiency of processing EDI 834s.
- Coordinated multiple meetings between Policy, Systems and Vendor teams for agreement on various change request related items.
- Provided all the teams with detailed notes of various meetings with Policy and the business.
Environment: Microsoft Exchange, IBM Rational Jazz, MS Word, MS Excel, MS PowerPoint, NYSOH EIT environment (testing), Cisco WebEx.
Confidential
Senior Business Analyst
- Created Business Requirements Document for the State’s Inventory Database System.
- Performed Regression testing of the CDCS system before the move to production for one of the releases.
- Participated in Data Quality Reviews at 5 locations throughout Connecticut to check the authenticity of those programs.
- Closely monitored Client Notification messages.
- Currently working with CYFSC (Child, Youth and Family Support Center) for tracking various Child/Youth/Family related processes that are sponsored by the State of CT.
- Extensively participated in Testing the CMIS application (this system feeds information to CDCS) in various assessments.
- Worked on eliminating close to 800 duplicate records in CDCS so that the system performance can be increased.
Environment: Microsoft Visual Studio, 2012(Team Foundation Server), CMIS, CDCS, CCAS, MS-Office Suite (Word, Excel, Visio, Project), Balsamiq.
Confidential
Senior Business/ Systems Analyst
- Part of the team that drafted the Statement of Work, Project Kick off Meeting Review Document and preparing the agenda for Fit/Gap Sessions.
- Participated in 35 Fit/Gap sessions to understand the State’s requirement for extra customization on the PeopleSoft HR system.
- Performed Data Mapping of the existing system and the PeopleSoft system by running query so that the non-delivered fields are discovered.
- Created and Developed Business Process Designs for the Transaction Approval Process for various agencies.
- Created over 300 test scripts during various phases of testing.
- Spearheaded Load/Performance Testing of the Application and the average time per transaction was reduced from 58 seconds to 12.58 seconds.
- Documented Technical and Functional Specifications for the HCM Project.
- Created Test Scripts for Master File Reconciliation.
- Tracked up all the open issues for which tickets have been opened and prioritized them and made sure that they were closed before the conversion was done.
- Worked with PMs, Leads (Technical and Functional), SMEs, Project Director and Delivery Managers at various stages of the project.
- Worked on Oracle E-Business Suite (Procure to Pay) when working for New York State Department of Tax and Finance.
Environment: PeopleSoft HCM (Core HR, Payroll modules), MS office suite, HP Load Runner, LATS (Leave and Accrual Tracking System), Office 365.
Confidential
Senior Business Analyst
- Business Requirement Documentation of the Client’s Development Process with detailed description of the Clients database and table names and implementation dates with milestones.
- Testing the Correctness of EDI 278 and 834 Response files.
- Worked on Procure to Pay module to assist in Magellan’s internal project with various Clients.
- Generating AUTH IDs, BATCH IDs and RUN IDs for various CENTENE and COVENTRY CLIENTS (Total number of clients=40).
- Manually Running the Job Extracts in AUTHAUTOMATION and checking their statuses using JOBRUNNER.
- Processing Response of the EDI 278 Response Files and promoting them to QA.
- Involved in creating Test Cases and participated in Manual Testing.
- COVENTRY and CENTENE Client Response file testing using SQL Server.
Environment: Oracle E-Business Suite (Procure to Pay), MS Word, MS Excel, SQL Server Management Studio (2008 R2), SharePoint 2010, JOBRUNNER, QC.
Confidential
Senior Business Analyst
- Identified risks, problems, requirements and concerns of the Hospital in order to comply with ICD-10 changes. Actively worked on Data analysis and Report analysis with respect to ICD-10 impact.
- Performed baseline assessment of Hospital-Provider systems and related interfaces. The existing service level agreements and/or policies and operational business procedures for readiness to comply with HIPAA as well as ICD-10 requirements. Gathered requirements by conducting interviews with end users. Prepared use cases, functional & system requirement specifications so that developers can understand the business process and rules according to their perspective. Planned and organized UAT sessions with business users and tracked defects using defect tracking tools.
- Highly involved in documenting department workflows and process flows with respect to applications. Analyzed System flows of various departments of the hospital.
- Collected the information related to ongoing application upgrade and their impact on ICD-10 implementation and created awareness within the departments regarding the need, impact, benefits and risks of ICD-10 code application. Involved in providing education about the ICD-10 standards, its requirements, complexity and accuracy to Physicians and Nurses of the hospital. Re-Organized the collected data and prepared documentation for implementation.
- Figured out the requirement of training in various departments of the hospital based on their daily work.
- Performed impact analysis on applications for deadliness of ICD-10 conversion. Additionally, was also responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting
- Mapped the collected data with the existing data provided by the hospital departments. Also, Used Word, Excel and Visio as a working tool and SQL scripts/queries for data verification and validation. Experienced in using EHR technology to submit clinical quality and other measurement.
- Experience working with patient access portal while performing UAT.
- Creation of test data and testing of programs developed for data migration.
- Conduct test development, execution, and administration of test phases, including functional testing.
Environment: Rational Unified Process (RUP), UML, SQL server, Blueprint, Cognos, SharePoint 2010, MS Office Tools - MS Word, MS Excel, MS Access, MS Visio, QC.
Confidential
Systems Analyst/ Business Analyst
- Studied and elicited the requirements for multi-currency platform for cross border payment by interacting with the managers, development team and treasury department.
- Creating Business Requirement Document (BRD) based on the documented requirements and created workflow diagrams.
- Involved in test case review meetings.
- Prepared Screen mock-ups by coordinating with different business users to illustrate the user requirements.
- Participated in validating automation tests for terms and conditions and other website specifications.
- Liaised between merchant services and treasury business units to gather requirements.
- Established test methodologies, test cases, scripts and user acceptance testing.
Environment: Agile/Scrum Methodology, TDD, Oracle, Java, Rational Rose, Rational Requisite Pro, MS Office, JIRA.
Confidential
Business Analyst, Systems Analyst
- The User requirements collected from the stakeholders were converted into Functional Requirements. Functional Requirements Document
- Worked with stakeholders on Joint Application development (JAD) during prototyping phase of SDLC
- Worked with SCRUM Project Management and Agile Methodologies FOR Software Development Life Cycle
- Data flow and work flow diagrams were created to clarify the functional requirements.
- Used SQL Server 2003 as a backend Database Server and Crystal Reports to generate reports
- Use cases and use case models were created to help developers in understanding the requirements and for the test team to create functional test cases.
- Interacted with the QA team to analyze and review the requirements document and make sure all the requirements are covered by at least one or more test cases.
- Worked with QA team to develop performance test cases based on projected user load.
- Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application
- Assisted in writing the system test strategy, that contains test scenarios and test scripts for functional testing of interfaces & verifies the fields are populated with proper data into Order Management System.
- Analyzed and reviewed the System requirements/Test plans and documented Test cases for functional, GUI and backend testing.
- Manage application defects in Mercury Quality Center and testing with collaboration with the vendor and QA team. Developing test plans, (UAT) user acceptance testing.
Environment: UML, Agile/SCRUM, HTML, XML, SQL Server 2003, UNIX, IBM Rational Rose, MS office suite and MS Visio, Flat files searching, QC.
Confidential
Business Analyst/System Analyst
- Responsible for the requirements gathering from RTO (Regional Transport Offices) and technical team.
- Creating Reports by using Cognos BI.
- Extraction of data related to a specific RTO.
- Developed the Use case diagrams, Activity diagrams and Sequence Diagrams throughout the course of the project.
- Coordinated with the QA team in testing.
- Created the Functional and Non-Functional Requirements for the Project.
- Wrote SQL queries for extraction of the data and testing its correctness.
- Developed Standard Operating Procedures (SOP) and recovery plans for the Cognos BI financial database and web portal services.
- Managed the testing of the BI application with HP Test Tools, QTP & QC and User acceptance testing.
Environment: Agile Methodology, Pair Programming, SQL Server, Rational Rose, Cognos, MS Access, MS Word, MS Power Point, HP QC, QTP
Confidential
Business Analyst/ Systems Analyst
- Actively worked on Business requirement gathering, analysis and Data analysis.
- Analyzed the existing web based application to determine existing functionalities and perform gap analysis for new functionalities.
- Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and User Interface
- Conducted JAD sessions for user interviews to gather requirements.
- Wrote Use Cases for EDI transactions.
- Created UML diagrams including Data Flow Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
- Perform SQL queries to do database testing
- Coordinated between test team, development and business team in clarifying the functionality issues and requirement specification
Environment: Agile SDLC, Oracle, Cognos BI, Enterprise View, SQL, IBM Rational Requisite Pro, IBM Rational ClearCase, IBM Rational Clear Quest, MS Access.
