Sr Business Analyst
Resume:
Rene Kaur
*********@*****.***
Professional summary:
• Masters of Business Administration graduate with an emphasis in Information Technology and Finance; complemented with experience in various domains such as Finance, Healthcare, Insurance, and Retail.
• 4+ years of experience as a Project lead and 6+ years as Business Analyst in software development.
• Extensive experience as a liaison between Stakeholders and developers in developing automated solutions for their company.
• Expertise in tracking Project Increments and Sprints and delivering the status to business in a timely fashion. Escalate issues when required and take up with appropriate personnel.
• Expertise in Business Analysis, Business Technology Optimization, Process Management, Quality Assurance, Software Design, Analysis, Data Modeling and Testing, of enterprise class client/server applications with strong understanding of software development life cycle and object oriented methodologies.
• Experienced in the Software Development Life Cycle (SDLC) methodologies; defining and understanding the scope of the project, creating application road maps, gathering business requirements, developing business process models performing effective communications and expectation setting including understanding of business functional requirements matching to technical systems setups and configuration, and finding the perfect solution for the client. Strong knowledge of Quality Assurance Life Cycle.
• Defined scope and boundaries as part of concept development. Prepare and present Project Proposals.
• Responsible in change management while effectively planning, creating, tracking, testing, packaging and releasing a project or product.
• Accommodated and facilitated Joint Application Development (JAD) sessions, proposed alternative tasks, benefits, documented, analyzed and synthesized the results as parts of business requirements.
• Experience in conducting GAP Analysis of the software to identify the gaps that exist between the original ideas and the organization’s actual processes. Experience in As-Is & To-Be modeling to define and understand the current business process and analyze it to formulate a future business process.
• Facilitated and contributed actively at project meetings, to analyze test results and issues.
• Demonstrated ability to step into new environments, learn new skills and lead teams to success.
• Experienced in restructuring and streamlining business processes of HRIS, sales, customer service units and other internal departments through the software development life cycle to increase team performance and customer satisfaction levels.
• Extensive knowledge in Project Management Life Cycle and software development methodologies such as Agile, Waterfall and RUP, SCRUM.
• Expertise in using business analysis tools like MS Visio, Rational Requisite Pro, Rational Rose, Clear Case and Clear Quest. Expertise in creating Conceptual Data Models, Process/Data Flow Diagrams, Use Case Diagrams, Class Diagrams, State Diagrams, Sequence Diagrams & Activity Diagrams.
• Monitored User Acceptance Testing for systems and enhancements.
• Organized workshops, surveys, interviews and JAD sessions with end users, expert team and technical team.
• Knowledge in programming Languages: Oracle PL/SQL, MS Access SQL
• Knowledge of CPT, ICD-9, and DRG codes
• Experience in HEDIS Reporting Software and VIPS as per NCQA standards.
Education
MBA: Masters of Business Administration, Ohio University, Athens, OH.
MA: Masters of Public Administration, Punjab University, India.
BA: Bachelors of Arts (Mathematics and Economics Honors), Punjab University, India.
Methodologies RUP, Agile, Waterfall, UML
Tools WinRunner, LoadRunner, Quick Test Pro, Rational Robot, Quality
Centre.
Databases Oracle (RDBMS), MS SQL, DB2, SQL Server, MS Access,
Sybase
Operating Systems UNIX, Win NT/Win2k/XP
Project Management/ Requirement Tools MS Visio, Rational Rose, Rational Requisite Pro
MS Office MS Access, Excel, PowerPoint, Visio, MS Project
Technical Skills
Professional Experience
United Health Group, Salt Lake City, UT (Remote) Feb 2011 - Current
Sr IS Business Analyst
I am part of the Medical Management quality applications & operations team at United Health Group. Responsible for the creation, maintenance and reporting all HEDIS (healthcare effectiveness data and information set) measures for NCQA accreditation. Management of few departmental projects including programming for HEDIS measures for NCQA accreditation through FOCUS and SQL programming. Ensure completion of all programming projects for all programmers in department.
• Identify data populations for Member Outreach projects
• Produce monthly and quarterly reports on health care product data
• Gather user requirements and lead the design of a system to meet those requirements
• Responsible for leading multiple projects and ensuring they are completed on time and functional
• Gather user requirements and lead the design of a system to meet those requirements
• Responsible for HEDIS reporting for three product lines and 180,000 members, Medicaid, SCHIP (Healthy Families) and a local health initiative.
• Analyze database for errors.
• Currently using Med Measures and Med Capture for HEDIS reporting software
• Post HEDIS analysis reviewing HEDIS processes that can be improved as well as developing interventions for measures with areas for improvement
• HEDIS reporting from mainframe data systems. Design, program and generate HEDIS data from VIPS mainframe environments. This data is used internally as a data quality check for current HEDIS rates.
• CAHPS reporting and statistical analysis. Performing statistical data analysis on CAHPS indicators testing for significant improvements and identifying.
• CAHPS reporting and statistical analysis. Performing statistical data analysis on CAHPS indicators testing for significant improvements and identifying opportunities for improvement. This is then presented graphically and reported to the Quality improvement department for barrier analysis.
Client: IT Networks, Salt Lake City, UT (Remote) May 2007 – Feb 2011
Role: Sr. Business Analyst & Project Administration
IT Networks is a manufacturing firm and a call center for business continuity and disaster recovery solutions. I have worked as a Business Analyst on multiple projects - sales tracking and GUI presentation project, HRIS, tech support call priority project, and Collection/Accounting workflow project for enhanced performance management. Worked with domestic and offshore software development teams.
Project #1: Sales Tracking & GUI Automation Project (STG)
I was part of the STG team for the call center sales tracking and enhanced GUI presentation/automation software. It is the most configurable, tools based workflow automation engine that would track and establish the number of GUI’s lead to increased sales per account and per resellers and channel partners.
Responsibilities:
• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Led a team of five developers and 6 testers and 2 technical writers through the implementation phase of the Customer Order Processing System.
• Performed analysis, design and technical specification development based on business requirements.
• Presented the application functionality to upper management and business areas.
• Designed the Customer Service Performance Measurement subsystem to measure the amount of time spent between the order cycle points (order inception, manufacturing, distribution and invoicing). Led to improvements in business processes.
• Co-author business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Experience in identifying Business Rules, which include data collection, validation, workflow, documentation, policies, pricing and security.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements with Business Teams. Then documented them in a format that can be reviewed and understood by both business people and technical people.
• Developed and implemented processes and tools for requirements gathering, Analysis, planning, tracking and delivery using Rational Rose requisite pro – RUP
• Worked as a liaison between the business stakeholders and technical teams to ensure the business requirements are understood and implemented to the systems accurately.
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
• Designed and developed project document templates based on SDLC methodology.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Assist Program Managers with the development of project schedules.
• Develop requirements and preliminary design for client applications. Perform analysis and design projects using a systems development methodology. Work with all levels of client staff in solution definition.
• Coordinated activities between business unit and technical staff, developing new methods, policies, and procedures to meet the business needs.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Ability to create, review, and implement technical designs.
• Used the traceability matrix to analyze the change effects and the defect resolving issues.
• Assisted in building a business analysis process model using MS Visio.
• Coordination with technical writers and other departments to understand and interpret requirements.
• Responsible for User Training Documentation
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
• Conducted UAT (User Acceptance) Testing.
• Collaborated with the QA team to developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Organized cross training of team members and Users to become more responsive.
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation
• Developed timelines for project delivery, and managed projects and resources to successful completion
• Assisted in the development of quality assurance artifacts including: Quality Assurance Plan, Product Acceptance Plan, Test Plan, Test Case.
Project#2: HRIS
• Prepared standard, periodic and ad hoc HRIS reports and staffing reports with Taleo on headcount, turnover, staffing hires, and EEO-1 reports.
• Collected, analyzed, interpreted and summarized data for analytical reporting.
• Managed the weekly and biweekly benefit reporting and reconciliation of 401-K and medical benefits, and FSA accounts.
• Collaborated with IT and external vendors on the development and maintenance of automatic data feeds, interfaces from the HRIS to employee benefit plan and other HR vendors.
• Performed testing of fixes, upgrades, enhancements and new functionality in Oracle.
• Project lead in Implementing Compensation Workbench by reviewing requirements, testing the system with our Business Analyst team.
• Processed data entry for employee promotions, new hires, transfers, merit increases, pay changes and tuition reimbursement.
• Gathered new hire paperwork to meet payroll deadline. Experience with ADP system.
• Managed Staffing team with orientation for new hires by reviewing polices and procedures, and benefit information.
• Assisted employees with benefit questions therefore, worked with vendors on a daily basis, payroll and HR managers.
• Administrator of Compensation Workbench by trouble shooting issues and working with account managers and supervisors.
• Conducted HR process reviews to include process mapping, documentation of policies/procedures, analysis, and reporting.
• Proposed improvements to existing processes to improve data integrity and usability of HR data.
• Provided direction, knowledge and supported other HRIS team members.
• Researched and identified the root cause for data problems, which required interaction with IT, HR, Payroll on resolution system issues.
• Maintained organization management, position management, and job management in HRIS system.
• Acted as an escalation point for end-users who were experiencing difficulties in using ADP – HR system.
• Created and documented standard operation procedures for all processes used in the system.
• Worked with IT, Compensation, and HRIS to create system usability for the new Division.
• Created ad hoc reports for Directors, Staffing Departments, International Team and Vice Presidents by using query analyzed data regarding headcount, turnover, and promotions.
• Maintained a monthly schedule of reports on benefits, weekly hires, weekly terminations, sales hires, staffing.
• Processed data entry for employee promotions, new hires, transfers, merit increases, and pay changes
• Worked with Staffing team to ensure hires were on boarded.
• Maintained the Organizational Management Module.
Client: Independent Health, Buffalo, NY Aug 2003 – Nov 2005
Role: Business Analyst
Independent Health Plans, Inc. Provides managed care services for government-sponsored healthcare programs, focusing on Medicaid and Medicare. Headquartered in Buffalo, NY. IH offers a variety of health plans for families, children, aged, blind and disabled and prescription drug plans. Worked as a business analyst on the patient registration system for patient scheduling, medical insurance checking, claims processing, and reporting for Performance Management System implementation. The purpose of this project involved population of the Enterprise Data Warehouse (EDW), which is used in critical reporting and analysis. The operational data from Mainframes was picked and transformed to store in a central repository DB2 for data warehousing needs.
Responsibilities:
• Involved in gathering, analyzing and documenting business requirements and data specifications.
• Created and reviewed business requirements, functional specifications, project schedules and documentation.
• Created Use case diagrams and business process workflow diagrams including Activity and Sequence Diagrams using MS Visio and developed test plans, test cases to analyze and match results.
• Reproduce, verify, and validate issues documented in a defect tracking system, and write tractability matrices based on use cases and business requirements documents (BRDs) using Mercury Quality Center as QA Status Report, QA Summary Reports, QA Test Logs, Maintain issue and defect databases.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Created mainframe DB2 table queries to assist in data analysis and extraction.
• Involved extensively in the inception phase for understanding the Scope of the Project, feasibility of the implementation and define the risk factors involved in the project.
• Used Rational Requisite Pro to organize, maintain and track user requirements.
• Facilitated weekly meetings between business users, developers and testers to discuss the status of the project and gather any new requirements.
• Conducted JAD sessions for communicating with all project managers, senior management and other stakeholders.
• Developed Test cases to perform GUI and Functionality Testing using Quick Test Professional.
• Worked closely with QA teams to ensure testing issues were resolved.
Client: Franklin Square Hospital Center, Baltimore, MD Oct 2002 - Aug 2003
Role: Business Data Analyst
This is an application for the Revenue side of the hospital management. Using this software lab activity such as new patient eligibility 270/271, registration, appointment fixing, doctor consultation, lab testing, pharmacy, ward management, report generation and billing can be achieved. All the relevant information is added through administrator modules. Each user is given a user name and password and they can only access that module assigned to them. For example, the receptionist can access the new patient registration module and the doctor, the consultation schedule module and so on. The administrator can access all the modules.
Responsibilities:
• Conducted user interviews, gathered requirements, and analyzed the requirements using Visio, Requisite-Pro.
• Worked with the business team to collect the business requirements, security and service level requirements and documented them using Requisite-Pro.
• Analyzed set behavior and contribution to business performance, critical business metrics & tracking underlying business trends using Business Objects.
• Performed and documented requirement analysis and data analysis
• Working with different IT & Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects
• Designed new process flows for the existing system as well as for the enhanced system.
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications.
• Translated customer/client needs into new features and new services
Client: Fifth Third Bank, Ohio May 2001- Sept 2002
Role: Business Analyst
An automating process meant for decision-making and review of their financial services. The system should let them keep track of historical data, Statistics, Market Data, and Market Evaluation on Credit Card Sales. This project was developed to create sales Datamart, which enables the Sales Managers to analyze the sales performance and formulate new strategies to improve sales. Analysis was performed on a continuous basis for formulating Dynamic Sales Strategies
Responsibilities:
• Responsible for Gathering Requirements from the Sales Managers to produce Business and Functional Requirements for a Sales Datamart.
• Participated in Primary and Secondary Research to determine User Requirements and Goals and converting them into Business and Functional Requirements.
• Participated in meetings with the management team and the SME(Subject Matter Experts)
• Responsible for regular interaction with the Credit Card Division to gather Market Data to base the Market Analysis.
• Conducted Requirement analysis and Design Walkthroughs with the designers, developers and management staff.
• Assisted in defining the loading strategies. Identified/documented data sources and transformation rules required populating and maintaining data warehouse content
• Created test cases and Test templates and guidelines to be used by the QA team.
• Analyze and document the level of effort for all Stages of all DW projects. Researched sources and identified key attributes for Data Analysis. Assisted in creating Business Objects reports as per user specifications
• Wrote SQL queries to perform Data Analysis and Data Validation
Client: UncommonGoods, NYC, NY Nov 1999 - April 2001
Role: QA Analyst/BA analyst
UncommonGoods is an online retailer for home goods. They feature medium to high quality domestic merchandise like items for the bedroom, bathroom, kitchen and dining room. I worked QA Analyst testing various Ecommerce application functionalities and web based applications with shopping cart functionalities. I served a dual role as a software tester as well as gathering requirement from the Stakeholders. This website went live in Sept 2000.
PHASE I:
1. UGoods WEBSITE - Tested online GIFT REGISTRY application GIFT TOOLKIT. This is a tool made of sub-modules Personal Wedding Site, Timeline, Task Manager, Guest List Manager, Budgeter and designer (one of a kind) items, which were designed to help customers plan and manage their gift selections.
PHASE II:
UGoods Imports - Tested website database search engine for UGoods Imports section. This is a third-party application that allows users to search for items on the website by keyword, and brings up results by price, brand, category or collection. This search was launched into production in 2001.
PHASE III:
1. UGoods One of a Kind WEBSITE - This was a sub-module. Tested gift card processing, Left Nav and Cross Browser functionality on Internet Explorer, Mozilla Fire fox, Opera, Netscape and Safari (Mac)
Responsibilities:
• Reviewed the Business Requirement Document and prepared the Application Test Plan based on the BRD.
• Generated the Test Scripts and Test Cases based on the Functional Requirements.
• Created a Requirements Traceability Matrix using Microsoft Excel to make sure that all the requirements have been covered in the test cases.
• Created test cases using Quality Center for different phases of PLM (Product life cycle management).
• Created test cases for JDA merchandising system such as PO management, Automated replenishment, distribution center management
• Performed Smoke test, Integration, Functional, Positive and Negative, Regression, System and End-To-End tests on the registers and controller.
• Tested company’s purchase orders, inspected goods and packing lists data from international manufacturers in backend AS400.
Contact this candidate