Business Analyst Resume
Los Angeles, CA
SUMMARY:
- Senior BA with 8 years working experience in healthcare domain (health Insurance, Hospitals).
- Highly motivated with an intuitive personality, excellent team player, and quick learner of new technologies.
- Extensive experience in various Software Development Life cycles (SDLC) like Waterfall, Agile, Scrum, RUP, Test Driven Development.
- Experience in Requirement & Analysis techniques like Brainstorming, Mind mapping, prototyping, Surveys, Interviews & fish bowl techniques.
- Experience in preparing Project Deliverables such as, Business Requirement Document (BRD), Systems Requirement Documents (SRS), Functional Requirement Document (FRD), and Use - Case Specifications.
- Experience in conducting Joint Application Design Sessions (JAD), focus group sessions & Rapid Application Development (RAD).
- Have good understanding of data modelling concepts like Entity, Attributes, Cardinality, Generalization, and Specialization &Entity-Relationship Models.
- Proficient in conducting Business Process Modeling (BPM), GAP Analysis, SWOT Analysis, Cost/Benefit Analysis, ROI analysis, Risk analysis, Feasibility Analysis and Impact Analysis.
- Experience facilitating meetings between onshore &offshore team members.
- Knowledge on Structured Query Language (SQL), Stored Procedures.
- Good Knowledge about 3 -tier architecture, Service Oriented Architecture, Web services (SOAP, Restful), XML, HTML, CSS, JavaScript.
- Possess knowledge of Data Warehouse Architecture & concepts like data marts, data mapping, fact table, dimension table, metadata, Star Schema and Snow Flake Schema.
- Strong presentation and analytical/problem-solving skills.
TECHNICAL SKILLS:
SDLC Methodologies: Waterfall, Agile-Scrum, Scrum- Waterfall hybrid, RUP.
Business Skills: Change Management, Use Case Modeling, JAD sessions, Requirement Workshops, GAP Analysis, SWOT Analysis, Impact Analysis, Project Planning, Scheduling and Budgeting.
Requirements Management: JIRA, HP ALM, Version One, JIRA confluence, Share Point.
Microsoft Office: MS Office Suite (Word, Excel, PowerPoint, Visio), SharePoint, MS Project.
Languages: SQL, PL/SQL, XML, HTML, Java, JavaScript.
Web Services: SOAP, Restful.
Databases: MS-Access, SQL Server, DB2, MYSQL, Oracle.
Testing Tools: HP ALM, HP QC, and Load Runner.
Reporting Tools: Tableau, SQL Server Reporting Services (SSRS), IBM cognos.
ETL tools: Informatica- Power center, SSIS.
PROFESSIONAL EXPERIENCE:
Confidential
Business Analyst
Responsibilities:
- Studied existing application identified & documented gaps, created Mock ups, complied and verified GAP Analysis documents with the Product Manager
- Utilized Team Foundation Server to document stories, track team’s velocity and Forecast product progress
- Created Release Backlog, Prioritized backlog, assigned stories to sprints based on client priority
- Demoed Product increments to Client and Managed requirement churns
- Responsible for conveying Business insights to development teams
- Managed Clinical, Cancer Staging and non-clinical CCDA (Consolidated Clinical Data Architecture) Product lines
- Worked closely with Architects during Designing the product lines
- Enhanced existing Clinical Decision Support system
- Ensured timely communications between Development team and Client
- Utilized Fibonacci sequence to estimate User Stories & MOSCOW method to prioritize Product backlog.
- Used SQL queries to Identify Duplication of Records and communicated to Developers and Systems Analyst
- Used MySQLyog database tool to study enterprise data and created data mapping documents
- Utilized standard terminologies like SNOMED-CT, LIONC, ICD9/ICD-10, and RxNorm
- Defined Acceptance Criteria, Definition of done for user stories
- Upgraded the entire application with SHA 2 - 256 certificates to comply with Certified EHR security Standards
- Responsible for working with Technical writer to create Release Notes
- Identified & Reported areas for potential business expansion
Environment & tools: Scrum - agile framework
Tools: Team Foundation Server, MySQLyog, Ms- office, mock up screens
Systems: SQL server
Terminology: CERT EHR, Meaningful Use, MIIPS
Confidential
Analytics
Responsibilities:
- Reported Project status on weekly basis to Project and Program manager. Analyzed team's capacity and competency to intake projects onto team's board
- Facilitated meetings with Tech lead’s, Architects, Program managers to drive project progress
- Develop project time line based on enterprise Release schedule & Managed Subarea release for 5 teams and 4 Assets
- Managed two teams with 5 and 7 members each (onshore & Offshore & nearshore)
- Used SharePoint, MS project, Version one, Excel, Squids, Service Desk
- Conducted Sprint ceremonies like daily scrum, Sprint Planning, Sprint review, Backlog refinement meeting
- Used Version one to analyze and report team’s velocity and estimated capacity
- Used Squids to track Project test cases and Defect status
- Worked with Production Support Management to resolve Production Incidents and used Service Desk to track the status
- Used Enterprise Turn Point (ETP) to manage component turns and Project Release
- Conducted Requirements gathering, Design Review sessions with internal consumers and coordinated with multiple teams to ensure Project progress
Environment & tools: Scrum - agile framework
Tools: Version-one, SSIS v11, SharePoint 2010, Visio, Outlook MS office 2010, Squids, ETP
Systems: SQL server, Informatica DIH
Terminology: Preferences, Medicare, Medicaid
Confidential, Los Angeles, CA
Sr. Business Analyst/Scrum Master
Responsibilities:
- Extensively interacted and gathered requirements by conducting meetings with key stakeholders, IT departments, end-users & SME’s.
- Thoroughly studied current AS-IS process and mapped it to TO-BE state to prepare a GAP Analysis document.
- Conducted JAD sessions, utilized wireframes, mind mapping techniques to clarify requirements.
- Documented BRD containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business requirements.
- Analyzed system requirements and created Use Cases, Workflow Diagrams, Entity Relationship Diagrams using MS Visio.
- Extensively coordinated with Compliance team, Quality team to analyze HIPAA &Meaningful Use aspects of the project.
- Utilized standard terminologies like SNOMED-CT, LIONC, ICD9/ICD-10, and RxNorm
- Used HL7 Consolidated -Clinical Data Architecture (C-CDA) to construct documents.
- Utilized Waterfall-Scrum Hybrid Methodology to develop the system.
- Facilitated Scrum Ceremonies like Daily Scrum, Sprint Planning meeting, Scrum/Stand, Sprint Review meeting, Sprint Retrospective and Backlog grooming meeting.
- Used JIRA to manage Sprint & Version Backlogs, generated artifacts to track team’s performance.
- Used JIRA Confluence to manage project related documents, Sprint retrospect meeting reports.
- Assisted Product Owner on working with requirements to create Product Backlog.
- Created Acceptance criteria in consultation with Product owner & Scrum team.
- Maintained and uploaded all project related documents in SharePoint 2013
- Acted as a Scrum master for UI/UX team and Functional Team.
- Developed Data map document and Cross walk documents in coordination with architect & IT teams.
- Wrote Complex SQL queries to verify the front-end and back-end systems
- Worked closely with ETL team during project implementation and actively suggested to share and optimize work.
Environment: Waterfall-scrum Hybrid
EMR: EPIC
Tools: JIRA, JIRA Confluence, MS-Visio 2013, MySQL workbench, SharePoint, HPQC v 11.0, mock up screens, MS-office 2013, Informatica- power center
Web service: SOAP, Restful
Terminology: SNOMED-CT, LIONC, ICD-10, RxNorm, ICD9 / ICD10, CPT, HL7-CCD, CCDA
Confidential, San Antonio, TX
Sr. Business Analyst
Responsibilities:
- Gathered Business Requirements and managed them using Requisite Pro.
- Interacted with the Users, Designers and Developers, SMEs, Project Manager to get a better understanding of the Business Processes.
- Prepared Business Requirement Documents (BRD) based on the gathered requirements and broke it down to SRS in consultation with the technical team.
- Conducted the SRS reviews and walkthroughs with designers, developers and stakeholders.
- Assisted Project Manager in Project Management Documentation and got MS Project experience
- Analyzed business needs and developed use-cases &use case diagrams using Rational Rose and complied them into System Requirement Specification (SRS) document.
- Documented Claims processing lifecycle and got good exposure of X12 837, 270 transactions for HIPAA 4010& 5010.
- Created and maintained source-to-target Data Mapping and Data conversion spreadsheet.
- Utilized Inner join and Outer Join SQL queries to analyze the integrity of data.
- Utilized Generalized Equivalence Mapping (GEM) Crosswalk reports for forward & backward mapping ICD 9 to ICD 10 codes.
- Re-engineering the capturing of transactions with legacy systems, Eligibility Transaction 270, 837 Claim Status Request and Response 276.
- Prepared Test Strategy, Test Plan, test report and Requirement Traceability Matrix using HP QC.
- Involved in unit testing & Facilitated UAT sessions by providing test data.
- Maintained a change request log, conducted impact analysis when a request for change (RFC) was raised, escalated the results to Change Control Board (CCB) and updated documents on to SharePoint.
Environment: Waterfall-SDLC
Tools: Requisite Pro 7.1, HPQC v10, MS-office 2007 (Excel, Word, Power point, Project, Outlook, Visio), XML, AS400, Windows 8/XP, Mainframe, SQL Developer
Terminology: EDI 837/835, 270, 276/277
Confidential
Sr. Business Analyst
Responsibilities:
- Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
- Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
- Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
- Complied BRD and converted into SRS and FSD.
- Studied the current process and compared it to TO-BE process & created a GAP analysis
- Utilized Informatica to perform ETL and create a data mart for operations department which was used to generate reports.
- Utilized requirements, business rules & helped analyze, develop OLAP cube for analysis.
- Extensively used MS-office to compile requirements and create Requirements Traceability Matrix
- Discussed with technical team, business sponsors to select a suitable reporting tool.
- Developed SQL queries to check the data integrity
- Developed test cases, test scripts and created Requirements traceability matrix.
- Facilitated UAT by the Business sponsors, documented change requests and validated changes by the Change control board
- Used Tableau to generate Predefined and Ad-hoc reports
- Assisted the implementation team during Go-Live session.
Environment: Waterfall SDLC
Tools: Oracle, PL-SQL, Tableau 5.0, IBM BPM, SQL Developer, MS Office 2007 (Project, Excel, Word, Outlook, Visio) XML, AS400, Windows XP, Mainframe, IBM Data manger, Informatica 8.0
Confidential
Business Analyst
Responsibilities:
- Conducted extensive requirement elicitation sessions like JAD, Mind mapping, Focused groups, public surveys (electronic & paper based).
- Helped analyze collected data and create a model for requirements.
- Broke down high level requirements to low level functional and non-functional requirements.
- Conducted sessions with technical teams to understand and convert business requirements to technical requirements.
- Helped business sponsors to decided suitable built system (.net/java/PHP) basing on requirements and future road map.
- Helped hire UI / UX team.
- Developed project charter, project scope, and documented BRD (Business requirement document)
- Developed test cases, test scripts & conducted Unit tests and User acceptance testing.
- Extensively involved post production and go live phases.
- Helped analyze Beta testing reports and re-engineer business scope.
- Helped develop a future road map for the organization.
Environment: Agile, PHP
Tools: MS Office - Word, Excel, Project, Access, One Note
Confidential
Business Analyst
Responsibilities:
- Worked on Hospital data processing for improving database for storing user files.
- Analyzed business needs, created and developed new functionality to meet real time data integration that facilitated decision.
- Worked on functions such as Change Control and Request, and managed complaints to ensure customer satisfaction.
- Active involvement in ETL design for data integration and master data management.
- Experience of managing multiple stakeholders across the organization, and in QA integration of systems.
- Involved in detailing project mission, data process flow diagrams, and timelines.
- Worked with SQL queries for data manipulations.
- Created Entity relationship diagrams for the proposed database.
- Participated in the development and creation of the data warehouse.
- Participated in creation of database objects.
- Assisted in building a business analysis process model using Rational Rose, Requisite Pro and Visio 2007
- Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams.
Environment: Waterfall
Tools: Oracle, PL-SQL, Framework Manager, Business Intelligence Suite 10.2, IBM BPM, SQL Developer, MS Project, Excel, Word, Outlook, Visio, XML, AS400, Windows XP, Mainframe, IBM Data manger.
