Post Job Free

Resume

Sign in

Cobol Intelligence Developer

Location:
West Bloomfield Township, MI
Posted:
April 28, 2022

Contact this candidate

Resume:

248-***-****

adqwsu@r.postjobfree.com

**** ****** **** **** **********, MI 48324

PRIYANKA MULHERKAR

SOULUTIONS ARCHITECT

University of Michigan Health System

Dear Sir / Madam

20th May 2021

1500 E. MEDICAL CENTER DRIVE ANN ARBOR, MI 48109

I am writing to apply for Manager, Quality Analytics Data Management position at University of Michigan Health System. I have over 20 years of experience in Health Care industry, with about 10 years of experience as a Manager in Data Warehouse / Reporting. I have extensive experience and working knowledge in the areas outlined in the job description.

In my current role as a Business Intelligence Architect at Trinity Health, I support the EPIC Clarity and Caboodle databases. I act as a leader for the Business Analysts, Business Intelligence Developers, and the ETL Developers in the Cogito Team. I have certifications as a Business Intelligence Developer (Clarity- Access and Clinical Modules) as well as a Badge of a Data Courier. I took up this position so that I could learn Epic and become more technologically savvy. In my previous role as a Senior Manager at Trinity Health I proved to be an efficient, enthusiastic, and strong leader. During my 10 years as a Manager / Senior manager, I was valued highly by my supervisors, my peers, as well as my team members and was very proud to always be rated in the top 2% in employee engagement scores.

University of Michigan Health Services would benefit from my skills in the following areas:

High level of standards and eye for excellence

Strong work ethic and leadership skills

Positive and motivating attitude even under pressure

I believe that U of M Health Services will be a great success for years to come, and my extensive experience will help your establishment well into the future. My time spend in this industry has prepared me for such an opportunity, and I sincerely hope that I can contribute soon as a member of your team.

It would be my privilege to discuss the Manager, Quality Analytics Data Management position in more detail. I am happy to come by whenever its more convenient for you. Thank you for your time and I am looking forward to hearing from you.

Sincerely,

PRIYANKA MULHERKAR

HIGHLIGHTS

Manager IT Applications with over 20 years of Healthcare IT experience (clinical, managed care, and revenue).

BS – CIS

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 Data Courier Certified

TECHNICAL SKILLS

Access

Amisys

BASIC

CCL

Cerner

COBOL

Data warehouse

Excel

HTML / XML

Informatica

JAVA

JCL

KSAM

Micro focus COBOL

Microsoft Word

MPEiX

MS-ACCESS

NASCO

ORACLE

PL/SQL

Powerhouse

PowerPoint

Program File Editor

Qedit

QUERY

QUERY

Reflections FTP

SQL

SUPRTOOL

Teradata

TURBO IMAGE XL

UNIX

Unix Shell Scripting

Vi

Windows 95/98/2k/NT

TRAINING AND CERTIFICATIONS

EPIC BID / Clarity – Access & Clinical, Data Courier

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 Solutions Architect)

Working with the Cogito Business Intelligence Team –

oSupport data extracts from various source databases – Chronicles, Clarity, and Caboodle.

oSupport as an investigation lead to facilitate discussions with EPIC Application Teams.

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 administrative 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 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 cleanup 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