Data Quality Assurance

Mr. Hiren A. Desai, MBA

** ************ *****, ******, ******** 19702

Tel: 302-***-**** Email: acvn99@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/hadesaillc

Objective: Senior data warehouse analyst position.

Qualifications:

Over 19 years of IT industry experience in hospital/healthcare, payer/provider insurance, pharmaceutical, chemical and consumer product industries with focus on ROI.

Domain knowledge of healthcare subject areas such as revenue cycle management, productivity, patient profiling and HCM based on Epic EHR, PeopleSoft Finance, PeopleSoft HPM, Kronos, McKesson HPM, and Epic Star Mart (Cogito) and Stratajazz.

Over 14 years of data warehouse, business intelligence, data planning and self-service reporting experience.

Over 12 years of master data management and data quality profiling techniques using enterprise tools such as Oracle SQL Developer, MS SQL Server Management Studio, PL/SQL, MS Excel and MS Access.

SAP BOBJ IDT 4.1, WebI 4.1 and Dashboard 4.1 development and deployment experience. Upgrade experience from SAP 3.x to SAP 4.x environments with universe, reports, and capacity planning.

Business intelligence reporting tools experience with BOBJ’s Web Intelligence, Dashboard and Crystal Reports, MicroStrategy, Cognos and QlikView and Qlik Sense.

SDLC, agile and waterfall methodology experience with primary focus on software development, functional specifications, UI/UX, and quality assurance.

Quick adaptability to an in-house methodology, relationship management, and demonstrated communication skills.

US Citizen

Professional Experience:

St. Elizabeth Hospital, Edgewood, KY

Subcontractor for TOP Consulting, Inc., Columbus, OH

Senior Data Warehouse Technologist February 2014 - Present

Architected, designed and delivered multi-terabyte data warehouse solution for a value based reporting initiative on technology platforms consisting of QlikView 11, SAP BOBJ 4.1, Oracle 11g, SQL Server 2008 and Informatica 9.5.1 PowerCenter for ETL process. Integrated data sources from EPIC/Clarity, PeopleSoft Finance, PeopleSoft HCM, and McKesson Pharmaserv. Enforced HIPAA compliance standards for the EHR solution.

Designed and delivered four SAP BOBJ universes consisting of Epic Hyperspace data system as well as Star Mart (previously Cogito) in a self-service reporting solution for a community of 50+ end users. Universes developed with Information Design Tool 4.1.

Developed corporate reports for over 300 business users, include C-level executives, with BI tools such as Web Intelligence 4.1, SAP Dashboard 4.1 and QlikView 11.

Led business solution design and delivery team consisting of a senior business analyst, BOBJ administrator, and Informatica/Oracle 11g ETL team members. Collaborated with senior data architect to ensure feasibility of technical solution for the business needs.

Designed and developed QlikView data models for Service Line Summary and Expense Dashboard to automate Excel based manual reports. The dashboards for C-level leadership provide insight into financial and operation performance of the organization.

Delivered artifacts include, SQL stored procedures, technical design for data mart tables, business requirements, semantic layer universe design document, report design document, and user training guide.

AstraZeneca Pharmaceuticals, Wilmington, DE

Contractor for NTT Data, Bala Cynwyd, PA

Service Consultant December 2012 – February 2014

Provided deep dive business and data analysis, requirements gathering and quality assurance services to the client in support of an Enterprise Data Warehouse solution with reporting services in MicroStrategy web and mobile business intelligence reporting environments.

Led quality assurance testing of MicroStrategy Mobile dashboard reports validating technical solution against business requirements. Utilized IMS Health data to generate analytical models to assess KPI on a weekly and monthly reporting basis.

Wrote SQL stored procedures to validate HealthCare Customer Master. Worked with the project sponsor to identify script accuracy, completeness, and verified qualitative and quantitative results. Developed SQL scripts to analyze, product master, DDD+, APLD, and dimension/fact table analysis for data analysis to support new data feed needs.

Worked with outsourced IT vendor’s DBAs, data architects, BI developers (offshore/onshore), and ETL developers to assess data gaps, enhancement opportunities and priority based issues resolution to ensure that business request and requirements met on time.

Computer Sciences Corporation, Berwyn, PA

Principal Consultant August 1997 – December 2012

Delivered insurance claims aggregation solution in Oracle 11g data warehouse for a consortium of health insurers, employers and 3rd party data suppliers in support of neutral pricing business intelligence reporting. Wrote SQL scripts to test data quality of the inbound UB92, CMS, provider and prescription flat files. Built a master list of providers de-duplicating records based on national identifiers such as NPI, DEA Number, name, address, and specialties.

Delivered SAP ECC 6.0 ERP solutions in a multi-phase global implementation for a multi-national chemicals industry client.

Delivered financial data warehouse reporting system based on Oracle 10g and Hyperion Financials for a consumer products multi-national client.

Energy Concepts, Warren, NJ

Cost Analyst February 1993 – August 1995

Provided utility cost management consulting service to retail clients nationwide.

Worked with utility providers to lower electricity, gas and water cost identifying tier rate qualifiers.

Technology & Systems:

SQL Server Management Studios 2008, Oracle 11g/10g, SAP IDT 4.1, SAP BOBJ 4.1, QlikView 11, IBM DB2, Netezza, Microsoft Desktop Productivity Tools (Access, Excel, Word, PowerPoint), Citrix XenApp

Epic 2014, Epic Clarity, Epic Star Mart v12, PeopleSoft Finance 9.3, PeopleSoft HPM 9.3, McKesson HPM, McKesson Pharmaserv, SAP ECC 6.0 EHS, MM and SD

Education:

Master of Business Administration, The University of Delaware December 1997

Bachelor of Business Administration, The University of Texas at Dallas May 1992

Affiliation:

Healthcare Information and Management Systems Society (HIMSS)

The Data Warehouse Institute (TDWI), Scottsdale Institute

Other: References available upon request Willing to travel

Contact this candidate