Summary of Qualifications:

• Over 8 years of IT and Management experience in Software Development Life Cycle (SDLC) and Project Life Cycle working as Business Analyst.
• Experience in working with Epic Software (KP Health Connect) in major health care industries like Kaiser Permanente.
• Experienced in interviewing business users and customers, providing recommendations to resolve issues for various business/technical groups and defining strategic solutions to business problems in a multiple project environment.
• Efficient in MS Project for planning and status reporting.
• Experience in developing functional specs through JAD sessions and user interviews.
• Experience with Analysis and Design (OOAD) using UML, Rational Unified Process (RUP), the Waterfall life cycle, Agile, Rational Suite (Rational Rose, Rational Requisite Pro).
• Strong in developing Use Case Diagrams and creating Use Case Specification Document (USD).
• Expertise in managing multiple projects and teams with an excellent track record.
• Exceptional ability to identify, analyze and implement opportunities for organization development and growth.
• Working experience in a cross-functional team environment.
• Heavily involved in gathering data mart and data warehouse requirements from business users.
• Strong experience in documenting existing process, analyzing business requirements, working with requirements traceability matrix, re-engineering business processes and designing.
• Expertise in Business Process Modeling, Business Process Improvement Requirement Engineering, Reengineering Analysis System Development and Validation Methodologies.
• Experience in Quality Assurance of client server and web-based systems with focus on Healthcare (HIPPA).
• Comprehensive experience in business analysis, gap analysis, cost/benefit analysis, testing, development of business requirements specifications, and project planning working with project managers and business sponsors.
• Actively involved in developing, executing and managing User Acceptance Testing (UAT).
• Ability to meet deadlines and handle pressure coordinating multiple tasks in project.
• Used Agile methodology of system development and fully coordinated the scrum and sprint activities.
• Work experience in data warehousing projects dealing with ETL (extraction, transformation, load) using Oracle and DataStage
• Dealt with data mapping issues between various source systems and staging area and data-marts.
• Worked with Business users to come up with Reporting Requirements. Reports were developed in Cognos.
• Proven skills in the areas of Enterprise Content Management and Business Process Management.
• Good knowledge of RDBMS and SQL with experience in Data analysis and reporting.
• Excellent interpersonal and organizational skills

Technical Competencies:

Languages: PL/SQL, C/C++, XML, HTML, VB 7
Packages: MS-Visio,MS-Project2000/2003,RationalSuite(Rose,RequisitePro,ClearQuest), Clarity, IBM WebSphere Application Server 5.x, 6.x.
RDBMS: MS SQL Server 2000, Oracle 9i/10g, MS Access
Operating Systems: Windows XP/NT 4.0/2000/98, UNIX
Methodology: OOAD, UML, RUP, Business Modeling and Data Modeling.
Networking Skills: LAN/WAN Design/Architecture, TCP/IP, Ethernet, PC/Server Assembly
Office Suite: MS Office (MS-Word, MS-Power Point, MS-Excel, MS Outlook)

Professional Experience:

Confidential,CA Jan 08 - Present

Role: IT Project Systems Analyst/ Solution Consultant

1 - Project Description: KPNS Upgrade
Kaiser Permanente Patient Notification System (KPNS) Upgrade Project consists of multiple project sub-tracks all focused on improving communication between KP members, their physicians and other health care delivery staff, thereby improving health outcomes, patient satisfaction, and supporting the Clinical Strategic Goals (CSG) for Southern California.

SCAD team deals with all the projects that initiates and implements in Kaiser Permanente environment in Southern California. The role of Solution Consultant is to assess IT impacts and risks, and translates client business requirements into specific systems, applications, or process designs. Their responsibilities include consulting with Business Partners to define scope, requirements, develop solutions alternatives and estimates, ensuring compliance with National System Strategy and other architectures and standards.

Role & Responsibilities:

• Gathered requirements and wrote business requirements document
• Worked with the data modeler to come up with logical and physical data model
• Wrote support model documentation for this project.
• Identified and proposed to the users the modules that must be built in-house and modules that need to sent to ASPs (Application Service Providers).
• Wrote the Logical Solution Design document for the in house development modules
• Created diagrams for the web interface to the application.
• Wrote system transition strategy document to capture all the aspects of the retirement of AARS (Automated Appointment reminder System).
• Worked with various teams to come up with the interface documents.
• Conducted one-on-one sessions and group meetings to gather the requirements and come up with logical solution designs.
• Involved in the waiver request approval process for the successful completion of this project.
• Received approval from EA (enterprise Architect) team for the vendor after submitting the waiver documents.
• Wrote Waiver Request document, Application Security Checklist and ASP Screening Questionnaire.
• Followed up and conducted meetings to get the approval for the vendor for this project.

Environment: MS Visio, Windows 2000/XP, MS Office (Access, MS Excel, Outlook), Clarity, Caliber RM, DB2, Starteam, Java/J2EE, Remedy

2 - Project Description: Confidential,
OneLink is one of several national initiatives focused on integrating Kaiser Permanente’s Finance and Supply Chain systems and standardize processes across the organization, resulting in greater efficiency and cost effectiveness. The project addresses replacement of the IVIS General Ledger and ASI Materials Management System (MMS) in Southern California by the PeopleSoft 8.9 Finance & Supply Chain Oracle Platform.

Role & Responsibilities:

• Conducted one-on-one sessions and group meetings to gather the requirements and come up with logical solution designs
• Wrote Logical solution design document, which captures the impacts of OneLink implementation on each KPHC module (OpTime and Inpatient)
• Provided assistance in creating LSDD that captures the impacts of OneLink implementation on KPHC Outpatient module.
• Conducted Research and analysis on implementation of OneLink (People Soft Module) on Supply chain modules and finance modules in KP.

3 – Project Description: Confidential,
The Medication Barcoding Administration Project implements the existing HealthConnect functionality that allows the clinical individual administering medications to confirm that the correct medication and dosage is being given to the correct patient. The process includes scanning the patient armband barcode and the barcode on the intended medication in order to allow HealthConnect to compare that data to the patient’s orders and Medication Administration Record (MAR) and confirm that the correct medication and dosage is being administered to the correct patient.

Role & Responsibilities:

• Reviewed Business Requirement Document
• Created matrixes to compare the barcode scanners
• Visited hospitals to analyze and identify the working atmosphere
• Contacted different vendors for the barcode scanners to evaluate the pricing, functionality and usability of barcode scanners.
• Tested different barcode scanners for usability, functionality and infrastructure adaptability.
• Recommended the barcode scanner based on the results of usability testing, Wintel Engineering certification and after careful evaluation of other products.

4 - Project Description: Confidential,

This project will establish a standard for a cardiology waveform and image archiving and communications system (CPACS) and cardiovascular information system (CVIS) with a goal of having an integrated and interoperable system for Kaiser Permanente Southern California. This project will be dependent on a Cardiology CVIS/CPACS SST process to select a system in support of existing information and workflow needs. These needs include but are not limited to interfaces with all cardiology modalities and other supporting cardiology systems, interfaces with KP HealthConnect, and other NSS such as image distribution and management.

Role & Responsibilities:

• Gathered requirements and wrote Business Requirement Document
• Create workflows and process flows of the existing cath (Hospital outpatient visit) and echo procedures

5- Project Description: Confidential,

Epic provides an integrated suite of applications – scheduling, billing, ambulatory, Inpatient, etc which all reside together leveraging common libraries, similar look & feel and smoother workflows.

The CMSS Print To Epic – Integrate is an ongoing program designed to provide KP Health Connect the tools to improve the Southern California Complete Care Clinical Imperatives. During 2007, the Panel Management Tool (PMT) which included the Proactive Office Encounter was developed and piloted. The Panel Management application on HealthConnect™ is designed to provide PCM professionals with a tool that identifies their specific panel of patients. The Panel tool includes all adult patients greater than 17 years of age from chronic condition populations; CKD, CAD, HF, DIABETES, CVD, HTN. The tool also includes asthma patients between 18 and 56 years of age, and all pediatric asthma patients between 5 and 17 years of age. In addition, it also contains all patients who are due for a cervical, breast or colorectal cancer screening, regardless of their chronic condition status.

Role & Responsibilities:

• Gathered requirements and wrote various requirement documents for enhancements of panel Tool.
• Gathered requirements and wrote requirement documents for the enhancements of Complete Care Management Summary Sheet
• Conduct meetings and facilitated meetings to gather requirements and identify the possible alternatives.
• Evaluated the solutions and proposed solution alternatives to the user.

6- Project Description: Confidential,

This project is to automate tracking and managing sales and inventory on gift shops in SCAL.

Role & Responsibilities:

• Gathered requirements and wrote business requirements document
• Worked on the concept phase and wrote concept description document.
• Drew network architecture diagram
• Select application solution and implement automated systems for non-patient business at POS and
• Identified and drew current workflows for each Gift Shop
• Involved in the waiver request approval process for the successful completion of this project.
• Received approval from EA (enterprise Architect) team for the product after submitting the waiver documents.
• Wrote Waiver Request document and Application Security Checklist
• Followed up and conducted meetings to get the approval for the product from an external vendor.

7- Project Description: Confidential,

KP ON CALL program helps SCAL Kaiser Permanente members by providing high quality, cost effective, urgent and emergent nurse triage services. When a member has a condition that requires medical attention, instead of going to the hospital, member can call KP ON CALL program and talks to a Registered Nurse to identify the severity level of her condition (triage the condition). Based on the information member provides, RN will refer the member to the type of care member needs.

Role & Responsibilities:

• Gathered requirements and wrote business requirements document
• Draw workflows and process flows
• Conducted meetings and one on one session with users to gather requirements
• Wrote Logical Solution Design document for the interface

Client: Confidential,CA Jul 07 – Dec 07

Role: Business Systems Analyst

Project Description:
Retiree drug Subsidy program allows the plan sponsors to receive a 28% subsidy for the gross eligible amount of each retiree who are eligible. This project was to generate and transmit a reconciliation report to CMS for each plan sponsor, which indicates the amount they will be eligible to receive subsidy for. As part of this project, an online application was also built for business users to track the reconciliation process of each plan sponsor, to approve, stop, and to redo the process from any process step of the reconciliation process. This also allowed the business user to view and maintain some of the key tables in the database.
Role & Responsibilities:

• Involved in understanding the current business process and in defining scope of the project.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through interviews (group and one-on-one) along with JAD sessions.
• Generated use cases for the application
• Identified the issues with RDS Extract system and done an impact analysis for using the same system for Reconciliation
• Did gap analysis between the new system and the RDS extract system
• Identified and documented risks, issues, assumptions, key decisions and action items in IRAAD document.
• Resolved issues and mitigated risks by working with business users, and other stakeholders.
• Gathered requirements from business user, helped business PM to complete the BRD.
• Researched the CMS website and helped business team in formulating business rules.
• Developed the logical data model with the help of data architect.
• Worked with EDI team, developers and production support team at various stages of the project.
• Dealt with ETL (extraction, transformation, and load) processes using Oracle and DataStage.
• Gathered requirements for building online application.
• Generate prototypes for online screens using Visio and PowerPoint.
• Wrote conceptual design document based on the Business requirement document
• Done extensive data analysis and converted the full logic to plain SQL codes and pseudo codes and put it in data selection strategy document
• Manually generated reconciliation reports using Excel and Access
• Wrote SQL queries to extract claims and eligible member level information from databases
• Design and streamlined process to facilitate annual reconciliation of plan sponsors.
• Done data mapping and data analysis to identify the data sources and data fields to be selected.
• Worked with external entities to figure out the mechanism of receiving files and to update it in the database (Secure Email - ISecure).
• Worked with external entities along with the business users to receive files and the content of the file that is necessary.
• Collaborated with EDI group to create and transmit the files (CSV format) via FTP to CMS.
• Worked with the architects and developers to design an efficient system
• Ensures that the application met user and management expectations.

Environment: Test Director, SharePoint, Oracle 9i, Java/J2EE, MS Visio, Toad, Datastage

Client: Confidential,IL Sep 05 - May 07

Role: Business Analyst

Project Description:
The System is called Team Center Enterprise which is a BPLM (Baxter Product Life Cycle Management) System centrally manages and Supports the Change Control Process used to Manage Large Amount of Product Data and Documentation. I focused on working on the Change Management module and focused on customizing it according to Baxter functionality. My job involved extensive research of the existing processes and mapping out new ones in order to make this Change Management automation initiative efficient.
Role & Responsibilities

• Fully responsible for requirements gathering and documentation.
• Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
• Involved in Validating the System in Accordance with 21CFR Part 11
• Created use case narratives to record Subscription business rules.
• Analyzed the business rules for the international user subscription and impact of localization.
• Implemented SDLC which included requirements specifications, design, analysis and testing.
• Wrote Use Cases, prepared use case diagrams (using Rational Rose) and followed Rational Unified Process at every stage of the process.
• Used Agile methodology in the project development.
• Experience with RUP methodology and used Rational Test Suite for various phases of RUP.
• Provided technical Expertise on the use of Rational Clear Case and Requisite pro, which were used for Data archiving and Requirements Management.
• Defect Tracking with Clear Quest, Configuration Management with Clear Case.
• Involved in preparing test plan and test cases based of functional requirements using Rational Test Manager.
• Developed test scripts and documenting test processes.
• Work experience in maintaining datamarts dealing with ETL (extraction, transformation, load) using Oracle and Informatica.
• Dealt with data mapping issues between various source systems and staging area and data-marts.
• Worked with Business users to come up with Reporting Requirements. Reports were developed in Cognos.
• Monitored and created the defect tracking process and reported bugs to the development team.
• Produced functional specifications and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed test plans and test cases according to business requirements.
• Handled change requests were carried out using Rational Clear Quest
• Maintained Test Matrix with the test results obtained.
• As a point person responsible for resolving business rules/conflict resolution for the development team.
• As member of system architecture team designed and reviewed user interface.
• Developed Business case and assessed the ROI.
• Identified Actors, Activities, Artifacts and Workflows and developed use case diagram using Rational Rose.
• Participated in Automated regression and Non-Functional test plans.
• As a point person need to train and guide the testing team during test script preparation.
• Involved in identifying the base testing efforts on a prioritized feature schedule.

Environment: Rational Tools Suite (Rose Requisite Pro, Clear Quest, Clear Case), Windows 2000/XP, Microsoft Office (Word, Access, Excel, Outlook), Java/J2EE, MS Project, Mercury Test Director 8.0, PVCS Tracker, Forms Design software i-32 5.1 and 6.0, Oracle 9i.