ResumeLogin
Search for: Jobs   Resumes
Keywords or title City, state or zip code
QA Post Job For Free
Posted by: Name is not set.
Posted date: 9/19/2009
Contact Info: ******@*******.***
Show Contact Info
Salary: Market
Country: United States
State: Pennsylvania
City: Newtown
ZIP: 18940
Email: duk0n3@r.postjobfree.com
Resume Text: Milin Parekh
Email: duk0n3@r.postjobfree.com
Mobile: 626-274-****
Visa Status: Permanent Resident/ Green Card

PROFILE

Software testing professional with 10+ years experience in Healthcare and Pharmaceutical industry.
Proficiency in Software testing, Data warehousing, Data transformation, Data modeling, data migration, OLTP, Problem analysis, issue resolution, organization, planning and time management.
Experience in Functional and Data management workflow process. Conduct high level research and technical analysis in a complex environment.

Work in production support environment, on call for 7x24 supports. Understanding of HIPAA and HL7.

Worked for Various Organization like
* Children Hospital of Philadelphia Philadelphia, PA
* City of Hope (Hospital) Duarte, CA
* Kaiser Permanente (Provider and Insurance) Pasadena, CA
* ST. Mary’s Hospital Athens, GA
* Blue Cross and Blue Shield of Georgia Atlanta, GA
* CIGNA Bloomfield, CT
* Zandu Pharmaceuticals Works Ltd. Mumbai, INDIA

TECHNICAL SKILLS:

Application: EPIC products (Cadence, Prelude, ADT, ED-ASAP, HOV, Ambulatory, Willow, Radiant, Beacon, Remote In-Basket, Inpatient clinical, OPTIME, ClinDoc, HIM, CPOE, HB, PB), OPAS, PARRS, ECS

Testing tools: Test director, Winrunner

Languages: SQL, PL/SQL, Pro*C, COBOL

Scripting: UNIX Shell Scripting

RDBMS: Oracle 8i, Sybase, Cache (Chronicles)

Reporting tools: BRIO designer, Oracle Reports and Crystal Reports.

Operating Systems: UNIX (HP-UX, Solaris, AIX, DEC Alpha), Windows 2000/NT

Data Modeling tools: ERWIN and Power designer

ETL Tools: Oracle EDMS

Other Tools: TOAD and SQL Navigator

Functional Knowledge: Healthcare, Healthcare Insurance and Pharmaceutical Industry.

PROFESSIONAL EXPERIENCE
CHILDREN HOSPITAL OF PHILADELPHIA QA Analyst Feb-09 to Present

Currently working with Children Hospital of Philadelphia (CHOP) on Testing EPIC systems and CLARITY.
* Clarity Testing: Identify and Review scope for CLARITY Spring 2005 to 2007 upgrade with Clarity team.

* Worked with Clarity report Analyst on Clarity requirements for Clarity testing.

* Created Clarity Test Plan and represent to key stake holders.

* Mentor QA team members on Testing Clarity reports in Crystal report format.

* Managed Clarity defect management and Clarity QA meetings.

* Managed Clarity Status reporting meeting twice a day.

* Interface Testing: Created Interface Test Strategy and Interface Test approach plan.

* Mentor QA team members on various Interfaces within CHOP.

* Created CHOP wide Interfaces VISIO Diagram.

* Good Understanding of 270/271, 835/ 837 transactions and HL7 Messages.

Environment: EPIC Testing (ASAP, ClinDoc, Pharmacy (Willow), Radiant, Oncology (Beacon), Interface Testing (CardioIMS, CBORD, MEDITECH, PowerScribe, PACS Phillips ISite, Pyxis, ChartMaxx etc), Bridges, EGate, Quality Center, HIPAA and HL7

City of Hope (Duarte, CA) CIS QA Lead May-08 to Jan-09
* Develop application testing approach for multiple products being implemented in City of Hope for Phase-1: Eclipsys Sunrise Access Manager (AM), Eclipsys Enterprise Scheduling (ES), Eclipsys Sunrise Clinical Manager (SCM), Eclipsys Sunrise Record Mgmt (SRM) and Eclipsys Patient Financial Mgmt (PFM).

* Managed 4 QA testers, 4 Application team members and 12 UAT team members.

* Managed testing scope, timelines, budget & resources.

* Created weekly team-building sessions and cross-training sessions to boost morale and productivity.

* Developed Functional application testing scenarios for volume/performance testing using Load Runner.

* Assist in the planning of Phase II budget, resources, schedule & scope.

* Managed the development of test scenarios for cross functional systems.

* Facilitate daily integration & test status meeting.

* Created SQA Standard Operating Procedures (SOP) that includes:

- Testing Life Cycle
- Functional Test Strategy
- Functional Test case Template
- Test Plan Template
- Performance Test Strategy and Performance Test Plan Template
- Test Reporting & Metrics
- Defect Management
- Checklists: System, Regression & User Acceptance Tests
- Acceptance Criteria

* Selected & purchased Quality Center and Load Runner for enterprise performance testing of web and client server applications.

* Establish communication plan for sharing test environments with multiple parallel testing projects.

* Responsible for full range of application testing: unit, regression, functional, integration and stress testing in order to prepare systems for migration into production.

* Collaborate with Eclipsys and other system vendors, internal CIS implementation and ITS department
Application support staff to plan and execute work.

* Develop healthcare related performance scenario using Load Runner.
*
* Organize meetings with business users, subject matter experts, project managers and executive teams to facilitate:
- Resource Coordination
- Issue Escalation & Resolution
- Status Reporting
- Milestones & Deliverables

* Oversee and participate in execution of testing and defect management activities; able to
Prioritize and assign work to close and retest repaired defects

* Provide project management support to plan testing activities, report issues, risks and status

* Conduct meetings, organize work and required activities, and assist in oversight of consultants/ vendors to ensure project's work is carried out.

* Oversee development of Automation Frameworks by Automation Tester and QA Best Practices.
* Experience in working in traditional waterfall and "agile" processes.
* Quickly and efficiently understand business processes and is able to strategically organize an automation effort based on the requirements and functionalities.

Environment: Eclipsys Products - Sunrise Access Manager - AMXA, Sunrise Enterprise Scheduling SES, Sunrise Clinical Mgr (SCM), Sunrise Record Mgmt (SRM), Patient Financial Mgmt (PFM), E-Link, HP Quality Center, Cache, HIPAA, HL7, Quality Center, QTP and Load Runner.


Kaiser Permanente (Pasadena, CA and Oakland, CA)
Technical Lead- Information technology (EPIC Care Everywhere Testing) Oct-06 to Apr-08

Responsibilities specific to Northern California (NCAL) Care Everywhere testing in Testing environment – Chart sync, Charge Homing, EPIC (Cadence-Scheduling, Prelude-Registration, HOV, Epic Care Inpatient, ADT, ED (ASAP), Epic Pharmacy, Ambulatory, Ambulatory interfaces, Optime, Clindoc, Hospital billing, CDA Remote Inbasket, EMPI, Merge and Un-merge), Bridges Interface, WQ, Mercury Quality Center, Test Director, Cache, IBM AIX, HIPAA and HL7.

Handling both Southern California Region (6 deployments) and Northern California Region (6 Deployments).
I had the opportunity to go to Northern California (Oakland, CA) for 3 weeks to transition of NCAL workflows and test cases to a team in Southern California.

I had the opportunity to mentor hospital staff includes RNs, LVNs and physicians in the Baldwin Park, CA (Kaiser) hospital for 2 weeks, which helped me explore more opportunities and solve their major concern.

Executed NCAL Care Everywhere track test cases consists of 14 tracks 8 Ancillaries which consists of seasonal drops (twice per year), K Package drops (five times per year), miscellaneous adhocs (anytime dependent on need) and Patient safety related adhocs and issues.

Serves as Subject matter expert (SME) on Care-Everywhere module for NCAL Region for 14 tracks and 8 Ancillaries (Cadence, Prelude, HOV, ADT, ED, Ambulatory, Optime, Ambulatory Ancillary, PB, PB E2E, HB, Inpatient Pharmacy, CDA RIB, CPOE, Clin Doc) and Ancillaries (PARRS, MRMS, TRSS, RegPlus, RILIS, Transcription, CareVue, EKG, IRGS–Genetics, KITS-SKIN and Immunization).

Validate the Data, Environment, Security roles, WQ setup, Ancillaries related information and make sure we have all information require in order running test cases more efficiently and timely manner for K111306 package, K011507 package, K030507 package and K051407 package regression, release notes includes Patient Safety Adhocs.

Understanding of HL7 interfaces standards.

Environment: EPIC (Cadence, Prelude, HOV, Epic Care Inpatient, ADT, ED, Epic Pharmacy, Ambulatory, Ambulatory interfaces, Optime, Clindoc, Hospital billing, Remote Inbasket), Bridges Interface, Charge Homing, Quality Center, QTP, Test Director, Cache, Oracle 9i, IBM AIX, HIPAA and HL7


IGATE Mastech
Kaiser Permanente (Pasadena, CA)

Sr. Functional Analyst/ Manual Tester (EPIC Care Everywhere Testing) Jul-05 to Sep-06

Responsibilities specific to Southern California (SCAL) Care Everywhere testing in Testing environment – Chart sync, Charge Homing, EPIC (Cadence, Prelude, HOV, Epic Care Inpatient, ADT, ED (ASAP), Epic Pharmacy, Ambulatory, Ambulatory interfaces, Optime, Clindoc, Hospital billing, CDA Remote Inbasket), Bridges Interface, Champs, OPAS, ECS, Charge Homing, Mercury Quality Center, Test Director, Cache, IBM AIX, HIPAA and HL7.

Provides comprehensive technical and operational support for EPIC products which includes Care Everywhere execution in testing environment.

Provides detail analysis, validation and correction of data within the Care Everywhere support and associated modules assigned.

Acts as operational/data liaison with departments to identify and resolve operational workflows issues related to technology, and issues related to data, data integrity, and interfaces.

Understanding of HL7 interfaces standards.

Environment: EPIC (Cadence, Prelude, HOV, Epic Care Inpatient, ADT, ED, Epic Pharmacy, Ambulatory, Ambulatory interfaces, Optime, Clindoc, Hospital billing, Remote Inbasket), Bridges Interface, Champs, OPAS, ECS, Charge Homing, Quality Center, Test Director, Cache, Oracle, Legacy Systems, IBM AIX, HIPAA and HL7

Paramount Software Technology Inc.
ST. Mary’s Hospital (Athens, GA)
EMR Application support Mar-02 to June-05

Responsibilities specific to Clinical Information Analyst – EMR Application Support.
Provides comprehensive technical and operational support for the Electronic Medical Record (EMR) systems in production support.

Providing application analysis and support, interface integration, maintenance and support, and customized application solutions for the EMR application. System upgrades and maintenance. Review and investigate undefined patient interface records using the EMR interface. Develop competencies in interface technologies such as HL7 and XML.

Provides detail analysis, validation and correction of data within the EMR application and associated modules as assigned.
Acts as operational/data liaison with departments to identify and resolve operational workflows issues related to technology, and issues related to data, data integrity, and interfaces.
Understanding of HL7 interfaces standards.

Environment: Oracle 8i (8.1.6) /8.0.5/7.3, Pl/Sql, SQL Loader, ERWIN v3.5, Korn Shell, SQL Navigator, Sun Solaris v2.8, HIPAA and HL7

Paramount Software Technology Inc.
Blue Cross and Blue Shield of Georgia (Atlanta, GA)
Production Analyst Apr-00 to Feb-02

This project is used by hospitals and Doctors to track the Patient Diagnosis and medications.
This system has interface with other system like Claims and Complaints Systems and also deals with the members visit the Providers and Physicians out of network. Good understanding and exposure to HL7.

* Coordinated in the development of the ETL process to build the ODS (Operational Data Source).
Worked on daily incremental and weekly catch-up data loads from OLTP systems to the various Operational Data Source (ODS) in production support.
Participated in formulation of a workflow for data quality validation of targets after incremental ETL using PL/SQL, Pro*C and UNIX shell scripts.

* Responsible for performing data modeling work (including conceptual, logical and physical modeling
Activities) in creating and updating data models in ERWIN. Worked on database forward and reverse engineering. Completing the data deliverables (e.g., logical data model, data entity, and attribute definitions, entity relationship diagram, data usage plan) ·

* I was responsible for all data and process related issues and status-daemon related issues. Conversion and loading of the legacy data through SQL*Loader, Kshell into Oracle database.
Involved in preparing documentation for various processes in production support.

Environment: Oracle 8i (8.1.6) /8.0.5/7.3, Pl/Sql, SQL Loader, Pro*C, ERWIN v3.5, Korn Shell, TOAD, SQL Navigator, VISIO, IBM AIX, Access, HIPAA and HL7

Paramount Software Technology Inc.
CIGNA (Bloomfield, CT)
Clinical Support Jan-99 to March-00
Claim processing system

Developed system requirements for a huge repository of data from various source systems, which needed to be stored for long periods of time. Competency in source data mapping and the development of transformation rules for the selected data. Involved in determining what data would be stored from the Claim systems. Gathered the data and mapped to the appropriate attributes within the Data Warehouse for consistent, definition and structure.

Processed claims for CIGNA’s HMO and Managed Care product.
Reviewed HMO claims to determine the nature of the claimant's illness or injury. Determined coverage provided under claimant’s plan of benefits. Utilized all available information to adjudicate claims accurately and timely. Provided telephone coverage to Member Services as necessary.
Good understanding and exposure to HL7.

Facilitate and conducted JAD session, which were required to get requirements to the detailed that was needed. Completed the gap analysis with the data coming in on 837 transactions. Mapping from the 837 data fields to the ACAS HMO, & Dental fields within our claim systems.
Completed BSE Methodology for testing the HIPAA Standard Medical Code sets in our claim systems

* Worked as a data warehouse consultant in the production support team, on call for 7x24 supports with pager and cell for CIGNA data warehouse (CDW) of approx. 4 terabyte of data.

* Responsibilities includes successful transmission of data from the OLTP claim and billing system (TRIS) from various places to CIGNA HQ based Bloomfield, CT via Autosys, Unix shell scripting (Korn), pl/sql and SQL loader.

* Troubleshooting of scripts, validating, processing and supporting of scripts. Research user needs and code fixes and enhancements in Korn shell, sqlplus, pl/sql for Request Queues.

* Coordinate with IT Operations in Atlanta for routine data warehouse operations. Responsible for standardized data loading and data output generation to meet project needs.
Experience in automated data processing utilizing UNIX scripts.

Environment: Oracle 8i, Pl/Sql, Korn Shell, ETL, SQL Loader, TOAD, HP-UX 11.x, Autosys, HIPAA and HL7

ZANDU Pharmaceuticals Works Ltd (Mumbai, INDIA)
Programmer / Analyst Jun-96 to Dec-98
Financial Accounting system

Development of the FA System for pharmaceutical company which comprises of Cash payment/ receipt journal voucher, purchase expense, sales transaction, outstanding-receivable/payable
Team consists of six members using COBOL, C, Oracle, and Developer 2000 to design and implement a FA system. Creating stored procedures, triggers, creating forms, reports creation & testing.

* Conversion and loading of the legacy data through SQL* Loader, using Unix Korn shell scripting.

* Developed several ad-hoc user-requested reports, back-end procedures, and triggers in PL/SQL.

* Converted data from COBOL/C to Oracle/ PRO*C database.

Environment: Oracle 7, Pl/Sql, Korn shell, Developer 2000, PRO*C, Crystal reports, SQL Loader,
Dec-Alpha Unix, Digital Unix-OSF1/ v 2.0, Microfocus-Cobol v 4.5, Win-NT 4.0, Novell
Netware 4.11, Win-95

ZANDU Pharmaceuticals Works Ltd (Mumbai, INDIA)
Programmer Jun-96 to Dec-98
Developed Payroll system for leading pharmaceutical company

* Designing file descriptions, defining alternate keys using split key method for indexing purpose to get
Better random access and designing screen layout including validation.

* Reading an entity relationship diagram (ERD) and converting from an ERD to tables, relations and constraints.

* Created stored procedures, Database triggers using PL/SQL that was used in the reports and customizing the system according to organizational prerequisites.

* Data conversion from Paradox/ COBOL to ORACLE in the defined tables as the old system was on COBOL. Conversion and loading of the legacy data through SQL* Loader, using Korn shell.

Environment: Oracle 7.3, PL/SQL, Forms 3.0, Reports 1.1, Microfocus-Cobol, Paradox, Dec Alpha
UNIX, MF-COBOL, Turbo C, MS-DOS, Novell Netware 4.0

EDUCATIONAL QUALIFICATIONS:

Education: Bachelor’s Degree in Computer Engineering

Professional Training: Mircostrategy DSS Agent, DSS Architect, Oracle 7.x, Developer 2000, C, UNIX, Micro-focus COBOL, HP Quality Center

Professional Qualification: Oracle Developer [Oracle, Developer 2000, UNIX, C & COBOL]



Resume Business Analysis Experience Accomplishments

Business Analysis Experience in CITY OF HOPE and KAISER PERMANENTE

CITY OF HOPE:

When I joined City of hope, Client did not have QA team. I took this as a challenge to build QA team from scratch. My main task were
1) Scanning resumes of different candidates for QA Team
2) Interviewing and hiring QA team members within QA Team.
3) Evaluate different Testing tool and Performance testing tools
4) Decision to buy best testing tool and Performance testing tool.
5) Implementation of Quality Center 9.2 (Testing tool)
6) Identify Redundancy within QA and within group of CIS.
7) Understanding Requirements and Workflows
8) Prepare Requirement Matrix and make central repository to test
9) Development of Test Strategy and Test Plan
10) Development of Test cases for all ECLIPSYS modules

Client had no BRDs (Business Requirements Documents), SRD (System Requirements Documents), SRS (System Requirement Specification), SRDs (System Requirement Documents) or any workflows Diagrams to build test cases in May 2008.

Process teams who are supposed to designed workflow diagram were behind schedule.
FYI…Process team designed workflows were specific to business only, but were not specific to ECLIPSYS (EMR) related.

I took this challenge by showing EXTRA MILE ATTITUDE and trained my staff to address this issue because I did not wanted development of test cases schedule to go behind because of this issue. We were highly depending on the process team. QA team did not get much help from Process team because of number of issue: Lack of resources and Transition between team members in Process team.

I motivated QA team members to document all workflows for testing purpose which is used only for testing team and verified by each SME (Subject matter Expert).

I met with each SME (Subject Matter Expert) and Business Analysts to understand the requirements and workflows which were specific to City of Hope and also documented them with their approval.

Identify and Review of requirements for Phase-1, Phase-2 and Phase-3.

I had to train and mentor one of my team members who were not from healthcare. And I also made sure that he is productive and he understood the workflows and wrote test cases.

Handled HL7 introduction training to QA team members.

Cross trained all QA team members in ECLIPSYS module.

Responsible for Testing ECLIPSYS module and HL7 testing on message and segment level.



Resume Business Analysis Experience Accomplishments









Resume Business Analysis Experience Accomplishments

KAISER PERMANENTE: (Business Analysis Experience)

Serve as Technical Lead in Southern California Region for all EPIC Care Everywhere modules which involved all EPIC modules. Serve as Subject matter Expert (SME) and Lead EPIC Care Everywhere with 4 team members.

Kaiser, Southern California (SCAL) Management gave me opportunity to go Northern California (NCAL) to transition all EPIC Care Everywhere modules to SCAL:

Prelude
Cadence
Inpatient
ADT
Ambulatory
Ambulatory Ancillary
HOV
Remote InBasket
HL7 Message Validation in Workqueues (WQ) in Bridges
ED (ASAP)
Pharmacy
Optime
CPOE
Clindoc
Hospital billing
CDA Remote Inbasket
EMPI-Identity
Merge and Un-merge

* Built QA team from scratch.
* Mentor QA Team members on Healthcare domain and Workflows
* Cross trained all QA team members in EPIC EMR.
* Involved in Business Analysis specific EPIC Care Everywhere scenario
* Responsible for Testing all EPIC module and HL7 testing on message and segment level.



Resume Business Analysis Experience Accomplishments



Resume Business Analysis Experience Accomplishments
Accomplishments at City of Hope
1) Scanning resumes of different candidates for QA Team.

2) Interviewing and hiring QA testers for QA Team.

3) Evaluated different Testing tools and Performance testing tools.

4) Negotiated with Software Vendors for a discounted price of 50% on Testing Software and 15% on yearly software support fees which saves company's $55,000 and saved $16,500 year over a period of 3 years.

50% Discounts for Testing Software, = $55,000
Yearly Support fee ($16,500) * 3 (Total Yrs) = $49,500

5) Negotiated on Consultant rates with Consulting companies/ Recruiters for Consultant services required for City of hope for over a period of 1 year.

Direct savings of $15/hr * 2080 hrs (Total hrs/Year) * 2 Consultants = $62,400 on a yearly basis.

6) Purchased best testing tools for QA team to save cost over period of time.

7) Implementation of Quality Center 9.2 (Testing tool) and Load Runner.

8) Identifying Redundancy within QA and within group of CIS.

9) Understanding Requirements and Workflows.

10) Preparing Requirement Matrix and making central repository for testing.

11) Development of Test Strategy and Test Plan.

12) Lead the efforts for development of Functional Test cases for all ECLIPSYS modules.

13) Development of Performance Test strategy for all ECLIPSYS modules.


Milin Parekh
Email: duk0n3@r.postjobfree.com
Mobile: 626-274-****
Visa Status: Permanent Resident/ Green Card




Similar resumes:
business analyst resume - 261
qa analyst resume - 30
warehouse - 6450
oracle developer resume - 90
financial analyst resume - 165

Similar jobs:
warehouse - 805
accounting - 4155
sales - 10158

Jobs vs Resumes

Support
PostJobFree

Become
a
Premium Recruiter

Only $20/month

©2009  PostJobFree.com - Home - Fresh Resumes - Post Job