Health Care Data Warehouse

HIGHLIGHTS

Manager IT Applications with over ** years of Healthcare IT experience (Clinical, Managed Care, Revenue, Data Quality and Data Governance ).

BS – Computer Information Systems

MHA – Master’s in Health Care Administration / Informatics

Core responsibilities include managing team of 14 to 16 employees, managing projects, resource management, evaluating employees, managing the GSSP queue, giving estimates for new development and maintenance of CCL scripts, supporting and working with other Cerner teams, creating business and technical specifications, and creating policies and procedures for the team. Excellent analytical, organizational and communication skills with strong interpersonal skills & ability to work effectively independently as well as within a team environment.

EPIC BID Certified and Data Courier Certified

TECHNICAL SKILLS

Access

Amisys

BASIC

CCL

Cerner

COBOL

Data warehouse

Epic

Excel

HTML / XML

Informatica

JAVA

JCL

KSAM

Micro focus COBOL

Microsoft Word

MPEiX

MS-ACCESS

NASCO

ORACLE

PL/SQL

Powerhouse

PowerPoint

Powershell

Program File Editor

Qedit

QUERY

QUERY

Reflections FTP

SQL

SSIS

SUPRTOOL

Tableau

Teradata

TURBO IMAGE XL

UNIX

Unix Shell Scripting

Vi

Windows 95/98/2k/NT

TRAINING AND CERTIFICATIONS

EPIC BID - Cogito Fundamentals, Clarity Data Model, Caboodle Data Model. Access Data Model, Clinical Data Model, Revenue Data Model, Data Courier, Radar SQL

Essential Skills for New Leaders

Master’s in health care administration

Oracle SQL / PL/SQL

Unix Shell Scripting

Cerner Millennium / CCL Discern Explorer

Amisys Correspondence Generator, Amisys Pricing, Amisys Benefits

PROFESSIONAL EXPERIENCE

Trinity Health, Farmington Hills, MI

December 1999 – Present

September 2018 – Present (BI Sr Application Coordinator)

Working with the Cogito Business Intelligence Team and Cogito Reporting Team ( 60 people) –

oSupport cutover tasks – Chronicles, Clarity, and Caboodle.

oLead Data Courier activities for EPIC Application Teams.

oSupport Epic Upgrades

oLead Employee Satisfaction Action Plans

Involved in investigating and recommending technology and process improvements to increase staff efficiency. Ensure technology and tools are used to their full capacity. Involved in leading projects related to system integration and interoperability.

Working closely with The Cogito infrastructure technical team to establish inter departmental processes for the team.

Working on establishing Change management process and extraction and distribution process for the BI team.

Working on Upgrade and release management for Epic Upgrades and Supplemental Upgrades.

Certified as an EPIC BI Developer – Clinical Data Model, Access Data Model and Data Courier

December 2015 – September 2018 (Sr.Manager)

Manager for Data Warehouse –

oSupport data loads from various source systems into the data warehouse Team includes ETL Developers, and Data Analysts, BI Developers, and BI Analysts

oSupport Data Quality, Data Governance and Analytics team (Revenue and Clinical)

Involved in investigating and recommending technology and process improvements to increase staff efficiency. Ensure technology and tools are used to their full capacity. Involved in leading projects related to system integration and interoperability.

Involved in interviewing, hiring, and bringing new employees over board.

Involved in various management functions like evaluations, resource allocation, and creating promotion plans, working with the OTE for employee requirements and concerns.

Involved in resource management, budgeting, and strategic planning.

Point of contact for all the TIS teams for any project work, SOW creation, or estimation for number of hours for the team.

Involved in making sure adherence to HIPAA privacy standards and ensure compliance with system PHI privacy practices by self and staff.

Involved in training, conducting cross departmental meetings, and presenting in all staff meetings.

Involved in establishing and documenting procedures and process flows across various departments within Trinity Health.

Involved in identifying strength and weakness of team members, and provide guidance to ensure success of the overall collective team and individual team members.

February 2011 – December 2015(Manager)

Manager for Cerner CCL Reports Team. Managing 14 – 16 employees.

Involved in leading projects related to system integration and interoperability.

Involved in interviewing, hiring, and bringing new employees over board.

Involved in various management functions like evaluations, resource allocation, and creating promotion plans, working with the OTE for employee requirements and concerns.

Involved in resource management, budgeting, and strategic planning.

Point of contact for all the TIS teams for any project work, SOW creation, or estimation for number of hours for the CCL Team.

Act as a gatekeeper of medical records / patient clinical data into and out of Cerner ensuring data completeness, regulatory compliance, and data transfer.

Involved throughout the SDLC process.

Involved in training, conducting meetings, and presenting in all staff meetings.

March 2006- January 2011 ((Sr. Programmer/Systems Analyst)

Provided support to Cerner CCL Reports team.

Lead several small to mid size projects including Cerner upgrades, Surginet bundle, Nursing Bundle, and Genesis go live. Some of the job responsibilities included determining staffing needs from within the department and staying within the allocated project hours as stated in the Statement of Work.

Worked with several Cerner application teams and managers to ensure that all projects were on task and that the priorities were set up correctly for the issues assigned to the CCL team.

Worked with the triage team and given estimates for new development and enhancements of CCL scripts.

Worked with the manager to allocate resources to the GSSP issues for the CCL reports team.

Created policies and procedures for the CCL team.

Provided training in CCL, Discern developer, Visual developer, Ops scheduler, and Explorer to Cerner app teams.

Mentored several CCL team members.

Created reports using Cerner Control Language.

Written several update cleanups scripts to help out other Cerner application teams.

Supported Trinity’s 49 hospitals all over the country to trouble shoot their issues with Cerner application.

Created form retrievals, mpages, and genviews using Cerner Control Language.

Used Cerner tools to set up code sets, batch reports, ops scheduled jobs, and create ad hoc reports to be run from the Explorer menu and Powerchart.

Did troubleshooting and testing in using various Cerner applications.

Supported Trinity’s hospitals all over the country to trouble shoot their issues with Cerner application.

December 1999 – March 2006

Lead Analyst on Data warehouse Mars (Oracle database)

Created extracts for Hedis measurements and participated in yearly Hedis auditing.

Ad hoc reporting off of the relational database.

Create business and technical specifications for Oracle database development team as well as for the Amisys team.

Worked on database design and update of the Oracle database as well as the Turbo Image XL database.

Support all Amisys Subsystems

Lead Analyst on Amisys Premium Billing, Claims, and Capitation Payable

Developed, Coordinated and maintain EDI process for Claims, Enrollment, and Capitation for ABF Health vendor

Used MS Access 2003 as a managing tool

Developed and coordinated EDI process for Premium Invoices for Moore vendor

Supported and coordinated Amisys Release 11.01 schedules

Developed EDI process for Moore positive payment process

Modified Claims and Capitation programs for High Deductible Product

Lead on several projects and played a role of a project leader for the group.

Trained several employees within the department on SQL, Oracle, and other processes.

Followed the complete systems development life cycle while working on projects. This involved: analysis, designing, developing, implementing, and testing.

Did extensive testing of applications and trained users on using the applications.

Oak Soft Consulting Inc. Southfield, MI

Systems Analyst (August 1998 – December 1999)

Worked as a contractor in several Health care companies like Oshner Health Care and Mercy Health as a systems analyst.

Created ad hoc reports and maintained supporting documentation.

Developed and executed 3 system tests.

Applied Amisys version changes and database changes.

Compensation Advisory Organization of Michigan, Livonia, MI

Systems Analyst (August 1997 – May 1998)

Supported Y2K migration on HP3000.

Trained users and developing user and system documentation.

Modified existing database and programs to make them Y2K compliant.

Designed and developed database using Microsoft Access.

Developed user interfaces using Visual Basic.

Developed reports using Crystal reports reporting tool.

Oakland Community College, Farmington Hills, MI

Computer Center Assistant (August 1996 – August 1997)

Assisted students on various software applications including Microsoft Access, Visual Basic, and Microsoft Excel, Microsoft Word, and Microsoft Power Point.

Assisted students in programming assignments in C, COBOL, and Visual Basic.

Chrysalis Automation Systems, Bombay, India

Information Analyst (June 1992 – August 1993)

Developed inventory management system for process control products (PLC’s) using C.

Developed payroll application using C.

Maintained and updated accounts payable / receivable software installed at client sites (Using COBOL.

EDUCATION

Masters in Health Care Administration, University Of Phoenix, Michigan ( July 2013)

Bachelor of Science, University of Bombay, India

Associates in Computer Information Systems, Oakland Community College, Michigan

Contact this candidate