Post Job Free

Resume

Sign in

Data Architect Customer Support

Location:
El Paso, TX
Salary:
41000
Posted:
May 16, 2023

Contact this candidate

Resume:

Raul Anton Munoz *** New York Ave. Apt **

El Paso, TX 79902

915-***-****

adw50b@r.postjobfree.com

Technical Certifications

Information Technology Infrastructure Library (ITIL) v.3 Foundations 2013

Previous Work Experience:

Data Architect--Chief Analyst at Texas Tech University Health Sciences Center (TTUHSC), Office of Clinical Informatics (OCI), May 2020 to May 2022:

General Duties:

Chief Analyst-Administrator of the Cerner HealtheIntent Enterprise Data Warehouse (EDW) implementation at TTUHSC El Paso.

oThe Cerner-EDW framework is an agnostic enterprise data warehouse with the capability of interfacing a wide array of data sources related to clinical and revenue-cycle-management workflows into a singularly integrated reporting platform. The Cerner-EDW implementation at TTUHSC El Paso serves to facilitate data-driven decision-making at all levels of its leadership, to closely monitor and gauge ‘quality-of-care’ and ‘value-based’ related metrics for all insurance contracts within the TTUHSC payer-mix, and to assess areas of improvement of the in-patient and out-patient clinical service delivery workflows at TTUHSC.

Chief Data Architect in charge of charting and interfacing various data integration projects into the Cerner-EDW Framework at TTUHSC El Paso.

The full description of my duties, projects and milestones are detailed below:

Operations of the Cerner-EDW Framework:

oIn charge of assembling, parsing, and uploading the requisite data sets into the Cerner-EDW Framework in the manner that most optimally reflects the clinical and revenue cycle management workflows at TTUHSC,

oAssembling and delivering clinical informatics reports gauging value-based care related metrics to private insurance payers,

oAssembling and delivering ad-hoc clinical informatics reports to multiple government insurance agencies to justify expenditures and financial obligations as outlined by their respective contract deliverables.

oIn charge of developing and conducting validation methodologies via the Cerner-EDW Reporting platform to gauge the quality and accuracy of the data sets uploaded into the Cerner-EDW Framework,

oIncreasing the degree of confidence in EDW clinical reports and dashboards, created via Cerner-EDW Reporting platform, by reconciling their respective output with that of their original data source,

Security and Access Management:

oKeeping track of EDW user-access requests,

oCreating, as well as terminating, EDW user accounts,

oIn charge of developing and implementing Security Management and Electronic Health Records data governance procedures and documentation, in accordance with the Federal HIPAA regulations and the internal policies of the Compliance Department at TTUHSC,

oCreating and drafting standard operating procedures in various formats of all the relevant functions and capabilities related to the Cerner-EDW Framework,

oCreating and maintaining an Access Management Matrix, as ordered by Federal HIPAA regulations and my department’s internal policies,

oPresenting monthly reports concerning the overall usage and frequency of access of the Cerner-EDW Framework to my departmental stakeholders.

Incident and Problem Management:

oConducting daily maintenance checks of the most essential functions of the Cerner-EDW Framework,

oSubmitting and monitoring service requests of any operational caveat uncovered during the daily operations of the Cerner-EDW Framework,

Working in conjunction with Cerner engineers to bring operational anomalies and caveats found within the Cerner-EDW Framework to a satisfactory resolution,

Presenting the progress and findings of active service requests to internal stakeholders,

The creation and implementation of the Cerner-EDW Framework--Process Perfect Plan Matrix to keep track of the progress of active service requests,

Training and Staff Development:

oDelivering instruction to TTUHSC medical providers on how to use the Dragon Medical One dictation software in both, a one-to-one basis and in a classroom setting,

oDeveloping and updating a proprietary syllabus for the Dragon Medical One product at TTUHSC,

oDeveloping and updating an instructional guide of Doxy.me, a virtual telemedicine platform,

Projects:

oClinical Workflow and Revenue Cycle Management-Data Integration Projects:

Enrollment Flat File Data Integration Project,

Scheduling Flat File Data Integration Project,

Business Payment Flat File Data Integration Project,

oGovernance Projects:

Developing the Cerner-EDW Framework Data Governance Policy for the TTUHSC El Paso campus,

oValue Based Contract related Projects:

HEDIS-Anthem Dashboard Project,

Agency/Entity:

Texas Tech University Health Sciences Center (TTUHSC)

Place:

El Paso, TX

Project Time-Frame

May 2020 to

January 2021

Project Type

Enrollment Flat File Data Integration Project—The successful completion of this project provides the data necessary for the creation of reports and dashboards containing key clinical KPI’s and metrics in real time via the Cerner-EDW Reporting platform. The whole of these reports and dashboards encompasses a fully automated framework designed to monitor, evaluate, and validate the deliverables of the ‘outcome-based payment’ contracts of the entire TTUHSC payer-mix.

Role

Project Manager/Chief Data Architect

Responsibilities

In charge of creating and integrating the overall data infrastructure of the Enrollment Flat File Data Integration project, as required by the flat file specifications provided by Cerner and the Electronic Data Interchange (EDI) industry standards; this made it possible to specify reports and dashboards containing key metrics reflecting all the aspects of the clinical workflows and revenue-cycle-management practices at TTUHSC in real time,

Validating enrollment flat files with output derived from their respective original data source on a routine basis,

Establishing the processes and workflows to be followed once the Enrollment Flat File Data Integration project was launched into full operations,

The drafting of all relevant documentation required to keep this project in motion to perpetuity,

Uploading the enrollment flat file data dumps, via the HIDUU Data Ingestion Tool, to be available in the Cerner-EDW Reporting platform, for the creation of reports and dashboards by the TTUHSC user-base,

Agency/Entity:

Texas Tech University Health Sciences Center (TTUHSC)

Place:

El Paso, TX

Project Time-Frame

November 2020 to

January 2022

Project Type

Scheduling Flat File Data Integration Project—The successful completion of this project provides the necessary data for the creation of reports and dashboards that include key clinical KPI’s and metrics, via the Cerner-EDW Reporting platform. These data sets are used to monitor, evaluate, and validate patient registration and scheduling related workflows as reflected in the daily operations of the TTUHSC clinics.

Role

Project Manager/Chief Data Architect

Responsibilities

In charge of creating the overall data ingestion infrastructure of the Scheduling Flat File Data Integration project, as required by the flat file specifications provided by Cerner and the Electronic Data Interchange (EDI) industry standards. This makes it possible to generate fully automated reports and dashboards containing key metrics reflecting all the aspects related to the current patient registration and scheduling workflows at the TTUHSC clinics in real-time,

Validating the instances of the scheduling flat files with output derived from their respective original data sources on a routine basis,

Establishing the processes and workflows for the ingestion and validation of the scheduling flat data sets once the project was launched into operations,

The drafting of all relevant documentation required to keep this project in motion to perpetuity,

Uploading the scheduling flat file data sets by means of the HIDUU Data Ingestion tool into the Cerner-EDW Report Writing module, to be available to the TTUHSC user-base for dashboard building and report writing purposes,

Agency/Entity:

Texas Tech University Health Sciences Center (TTUHSC)

Place:

El Paso, TX

Project Time-Frame

September 2021 to

January 2022

Project Type

Business Payment Flat File Data Integration Project—The successful completion of this project provides the requisite data for the creation of clinical reports and dashboards that include fundamental revenue-cycle-management related metrics and financial KPI’s via the Cerner-EDW Framework. This specific subset of analytical tools monitors, evaluates, and validates the revenue-cycle related workflows practiced by the TTUHSC-Medical Income Practice Plan. This project also supports the monitoring of deliverables as specified in the ‘outcome-based’ contracts of the entire TTUHSC payer-mix. To date, the most noteworthy aspect of this specific data integration project is that it garners an even richer and more in-depth level of analysis in respects to the dynamics of the revenue cycles at TTUHSC El Paso, than that of the previously implemented data integration projects.

Role

Project Manager/Chief Data Architect

Responsibilities

In charge of creating and integrating the overall data structure of the Business Payment Flat File Data Integration Project, in accordance to the specifications provided by Cerner and the Electronic Data Interchange (EDI) industry standards.

Validating business payment flat files against the output derived from their respective source databases on an ongoing basis,

Establishing the processes and workflows to be followed once the Business Payment File Data Integration project was launched into operations,

The drafting of all relevant documentation required to keep this project in motion to perpetuity,

To upload the data dumps at an established frequency basis, via the HIDUU Data Ingestion Tool, to be available in the Cerner-EDW Reporting platform for the creation of reports and dashboards by the TTUHSC user-base,

Milestones:

For the first time since the inception of the Cerner-Electronic Data Enterprise Warehouse project in 2015, my efforts made it possible to be able to design and implement fully automated reports and dashboards that reflect a highly cogent integration of clinical, registration, scheduling, and revenue-cycle-management data sources in an accurate, reliable, and meaningful fashion at TTUHSC El Paso.

Lead Revenue Cycle Management Analyst at Texas Tech University Health Sciences Center (TTUHSC), October 2015 to February 2020:

General Duties:

Coordinating, determining, and editing healthcare dashboards containing key performance indicators (KPI’s) used for gauging claim rejections, transaction claim edits, schedule influxes, financials, and provider RVU’s for the entirety of the Texas Tech University El Paso campus and part of the facilities within University Medical Hospital (UMC).

Conducting of quality performance capabilities following ITIL principles using tools such as SharePoint lists, libraries, and document repositories; all with the purpose of leveraging a higher effectiveness in utilization of the current Revenue Cycle management software in place, GE Centricity Business.

oThis includes the creation of process handling tools ranging from ‘user access’ request interfaces, change management tracking templates, help desk related functionalities, financial and general workflow healthcare reporting frameworks, and ‘Known Error library’ document repositories, among other best practice tools used within the spectrum of healthcare service delivery.

Fulfilling ad-hoc report requests using Structured Query Language (SQL) scripts, Excel array formulas and the general healthcare domain related knowledge in supporting the decision making of different inter-departmental stakeholders, administrators and extra-departmental entities such as SurveyVitals, GE healthcare, Conifer-Tenet and TTPA.

oWorking closely with the staff of Medical Practice Income Plan Accounting department in creating claim refund reports, net collection reports, RVU monthly figure statements, payment profiles and conducting financial trend analysis.

oConducting simple forecasts on important indicators such scheduled visits, arrived appointments, future payments, and charges at different frequencies (quarterly, monthly, weekly, daily, etc.…) using non-structural forecasting methodologies such as naive and ARIMA models.

oWorking closely with state institutions along with the in-house Compliance department in keeping my institution financial and service delivery practices in concert with any given government regulation related to healthcare.

Troubleshooting and assisting GE Centricity Business users with any issues preventing them from carrying out their daily duties.

Working closely GE Centricity Business engineers in monitoring, supporting, and troubleshooting all inter-operability interfaces between different Revenue Cycle and related electronic medical records programs using standard HL7 principles and programs such as Connectivity Manager, Qvera and Ensemble.

Collaborating in automating numerous reporting processes interfacing Private Health Information (PHI) records into HIPAA compliant FTP servers for various entities.

Collaborating with the in-house Centricity Business Training department in facilitating the development of relevant TTUHSC staff whenever a new scheduling or financial workflow was launched to operations.

Providing training sessions to key administrators of the TTUHSC El Paso Campus on medical, scheduling workflow and Revenue Cycle Management report writing software tools monthly.

Working closely with lead coder and her team of coders in developing and testing billing and coding related edits via the Transactional Editing System (TES) module in the GE Centricity Revenue Cycle Management product to prevent claims from having errors before these were sent to the payors and insurance companies, either by paper or by means of our in-house 835 Electronic Data Interchange Flat file parsing system,

oWorking closely with lead coder and her team of coders in developing ad-hoc reports and dashboards to monitor the claim rejections on a daily and weekly basis to create the relevant edits via the GE Centricity TES editing module, thus reducing the number of claim rejections, thereby decreasing our overall account receivables, and resulting write-offs.

Agency/Entity:

Texas Tech University Health Sciences Center

Place:

El Paso, TX

Project Time Frame:

October, 2015 to

September, 2016

Project Type

The implementation of a completely new Revenue Cycle Management software all across TTUHSC El Paso campus. This project essentially entailed the decentralization of the TTUHSC El Paso campus electronic medical records system among other financial and scheduling workflows from the previous revenue management software hosted at Lubbock, Texas by hosting it through a local and independent server.

Role

Project Support Analyst

Responsibilities

Creating various project and IT product management tools using SharePoint capabilities aiming to assist in the coordination of efforts of the project managers and project leads from TTUHSC El Paso and the General Electric Healthcare.

Creating critical financial reports and scheduling templates to assist medical billers/coders and schedulers once the final product was released into full-scale operations.

Creating electronic face sheet templates and forms according to the specifications of various departments to be ready for use upon the said product’s release.

Collaborating in the creation of the main building blocks of the new revenue cycle management system such as inputting all the related medical provider information into their respective dictionaries, determining fee-schedules prices, programming transaction editing system claim edits and setting-up the users’ access in accordance to their roles and rights, among others important tasks.

Assisting in the determination of different fields and the respective order of their branching for each of the modules comprising the new revenue cycle application/product under the direction and feedback of product consultants, testers, super-users and front-end staff.

Agency/Entity:

Texas Tech University Health Sciences Center

Place:

El Paso, TX

Project Time Frame:

October, 2016 to

January, 2018

Project Type

The implementation of a completely new training agenda covering medical, scheduling workflow and Revenue Cycle Management related informatics using various software report writing packages aiming to the integration of their use in supporting better managerial decision-making and more robust financial validation processes.

Role

Associate Project Leader

Responsibilities

Creating a holistic training agenda that covered and approached ‘concepts to master’ in areas related to medical, scheduling workflow and Revenue Cycle Management informatics.

Providing four-day trainings to the TTUHSC El Paso administrative body monthly.

oUsing pedagogical methods such the ‘KWL’ model in providing a more robust understanding of the concepts taught to the trainees.

Assessing trainees’ performance and deriving corrective strategies aimed to providing better lesson plans to future trainees.

Changing and tweaking the entire training agenda in following a continuous service improvement approach.

Warehouse Employee at Madecentro; November 2014 to June 2015:

General Duties:

Fulfilling customer orders by preparing them for delivery.

Receiving new arrivals of merchandise items by checking their physical integrity and re-counting them to avoid any inventory discrepancies.

Handling materials, product stock and merchandise into appropriate locations inside the warehouse.

Operating a forklift for unloading heavy orders received from flatbeds and trailers boxes.

Managing inventory by means of product brands and an alphanumerical coding system.

Acquiring product and industry base knowledge.

Customer Sales Representative at Mini-BMW of El Paso; June 2014 to November 2014:

General Duties:

Attain product knowledge on all the most recent models of the BMW and Mini-Cooper car brands ranging from product performance to new technological and cosmetic amenities.

Satisfactorily complete sales trainings concerning customer service, customer support and customer follow-ups after purchase.

Obtain working knowledge on the financial formulas used to determine monthly car payments, estimation of interest rates and to assess the risk associated to each of the customers in order to guide them to procure their most optimal option in terms of affordability and to prevent any significant budget setbacks.

Keep constant communication with potential customers when new options transpired that could possibly meet their expectations and needs in the future.

Keep close contact with clients with whom I previously closed a purchase within order to capitalize on any potential buyers that they may refer to me.

Continuously update product knowledge for any recently released car models into the market.

Provide superb customer support and follow-up to returning and potential buyers.

Input contact information and car specifications of potential and returning customers into the client database.

Project Manager Associate at Hewlett Packard; July 2013 to March 2014:

General Duties:

Track and oversee the progress of diverse projects of contractors as assigned by Hewlett-Packard in accordance to their respective contract deliverables; all pursuant to the standards set forth by the Project Management Institute (PMI) methodology.

Provided support to various senior project managers across the globe in delivering products and services to contractors by means of the “Product Life Cycle” mappings.

Provide analytical feedback and data driven decision strategies with statistical and inferential analysis, surveys and queries, among other relevant internal tools and templates.

Proofread and rectified technical documentation as ordered by the projects in point.

Executive Manager/State Program Evaluator and Auditor at Workforce Solutions Upper Rio Grande Development Board, July 2011 to August 2012:

(Spearheaded the creation of a new unit titled Integrated Compliance and Evaluation Section (ICES) for Upper Rio Grande Workforce Solutions Development Board in July 2011 under which I became a State Program Evaluator and Auditor in addition to already being a Labor Market Analyst)

General Duties:

Coordinate and manage a sum workforce of four hundred plus (400+) staff employees.

Deliver holistic strategic management and operational oversight in accordance with 2012the directives and guidance of the CEO and state-program performance dashboards.

Coordinate the Integration of Statistical Process Controls and reliability engineering principles such the Failure Reporting and Corrective Action System (FRACAS) and the Eight Discipline Process to meet service delivery for government economic development programs in three main aspects, financial expenditures, state program performance and service metrics. These included high caliber workforce development contracts such as the Workforce Investment Act (WIA) for Youth, The Workforce Investment Act (WIA) for Adults, ARRA Child Care, Texas Back to Work, Reintegration of Ex-offenders (RIO), (TANF) Non-Custodial Parent Work Development, Trade Adjustment Assistance (TAA), the On-the-Job training National Emergency Grants (OJT-NEGs), among others.

Create Quality Improvement Teams (QIT’s) and conducted quality improvement meetings with the aforementioned to monitor and evaluate the quality of the services delivered by state programs administered by the Upper Rio Grande Workforce Solutions Development Board following the rigid Eight Disciplines Process.

Conduct follow-ups of concerns generated in the Quality improvement meetings to assure resolution to caveats and better identification of problem root causes.

Coordinate the creation of a Process Perfect Plan matrix to document and oversee all quality improvement meetings and to monitor the opening and closing of concerns or problems affecting our service delivery process.

Coordinate the creation of program-contract performance dashboards to keep constant monitoring of state-program service delivery improvements; these included statistical process controls and forecasting.

Coordinate trainings for pertinent staff as needed to increase their respective skills sets and the value-added of my unit and the entire organization’s service delivery capabilities.

Coordinate strategic management for revamping existing infrastructures at organizational and departmental scales.

Conduct additional quality assurance analysis purposive to the data integrity of the databases for processes put in place for delivery of services by the Texas Workforce Commission and the US Department of Labor such as ‘The Workforce Information System of Texas’ (TWIST) and the ‘Work in Texas’ (WIT) job seeker and employee database.

Important Projects

Agency/Entity:

Workforce Solutions

Upper Rio Grande

Place:

El Paso, TX

Project Time Frame:

January, 2012 to

April, 2012

Project Type

The prevention of de-obligation of Federal Funding for the WIA/ARRA Child Care Contract by conducting a large-scale service Outreach recruiting effort in the Upper Rio Grande Region’s rural counties: Brewster, Culberson, Jeff Davis, Hudspeth and Presidio.

(Federal funding amount: 2,000,000 U.S.D.; project members: 20 employees)

Role

Lead Project/Executive Manager

Responsibilities

Kept track of the project’s progress by means of relevant ad-hoc performance analysis metric dashboards, extraordinary meetings and action plans.

Coordinate capital outreach efforts by means of rural job fairs, the provision of gas cards, among other transportation efforts in order to deliver child care services in the rural areas of Brewster, Culberson, Hudspeth, Jeff Davis, and Presidio counties.

Report the project’s findings and solutions to extant caveats to the agency’s CEO and the constituent Mayor of the city of El Paso at the time.

Work with the contractor of service delivery to achieve a convergent and sound strategic view.

Document every milestone that transpired during the project’s life.

Agency/Entity:

Workforce Solutions

Upper Rio Grande

Place:

El Paso, TX

Project Time Frame:

February, 2012 to

May, 2012

Project Type

Texas Back to Work (TBTW) state contract/program invoice recollection and securement to prevent de-obligation of funding and fraud (State contract funding amount: 800,000 U.S.D.; project members: 20 employees)

Role

Lead Project/Executive Manager

Responsibilities

Coordinate the formation of an integrated project team composed of members from accounting, quality assurance, business outreach services, program coordination and operational management units/departments to come to a common vision and plan of action.

Keep track of the project’s progress by means of relevant ad-hoc performance metric dashboards, extraordinary meetings and action plans.

Report project progress to the firm’s CEO.

Document every milestone that transpired during the project’s life.

Uncover extant process caveats and then coordinate sub-projects and minor action plans to solve them.

Coordinate outreach efforts with the integration of the business outreach services unit and the accounts payable department to procure all outstanding invoices; thus, preventing de-obligation of state program/contract funding by making program expenditures official.

Agency/Entity: Workforce

Solutions Upper Rio Grande

Place:

El Paso, TX

Project Time-Frame

February, 2012 to

May, 2012

Project Type

Accounts Payable department revamping project (project members: 15)

Role

Lead Project/Executive Manager

Responsibilities

Uncover existing caveats/inefficiencies in the accounts payable department.

Organize an integrated task force comprised of the accounting, accounts payable and Informational Technology (IT) departments.

Coordinate the application of relevant accounting software with the IT department to aid the Accounts Payable department in having more efficient invoice processing procedures.

Analyze the current accounts payable process in order to recognize and uncover extant caveats and opportunities of improvement.

We were able to shorten the invoice processing time from two months on average to two weeks.

Milestones:

The efforts of the unit I led during my time at Workforce Solutions Upper Rio Grande helped us to:

Heighten the quality-of-service delivery of the Upper Rio Grande Workforce Development Board to be number one in the state of Texas out of the 28 competing workforce development boards at the time.

Rank our agency to become number eight in the nation out of all functionally related the workforce development agencies according to the survey findings of ‘The Benchmarking Project’, an agency dedicated towards gauging the quality-of-service delivery of entities and agencies monitoring federal workforce development contract and initiatives at state and national levels.

Labor Market Analyst/Economist at Workforce Solutions Upper Rio Grande Development Board, November 22, 2010, to August 22, 2012

General Duties:

Prepare detailed reports regarding the prevailing labor market conditions in the region.

Provide and manage proprietary economic indicator databases at national, state, and regional scales.

Provide accurate labor market information to jobseekers and employers.

Monitor regional economic indicators via ordinary least squares, traditional and linear transfer function, and ARIMA models.

Conduct regional and county scoped industrial diversification studies based on location economic base theory and rigid industry cluster analysis.

To garner and compile an extensive library of regional economic development literature.

Write and run SQL queries to retrieve data from various workforce development databases for purposes related to service delivery cross-sectional and time-series trend analysis.

Provide regional economic/econometric feasibility studies fulfilling the requirements of various federal government grants for a more successfully probability of procurement of the same.

Write, proofread and rectify a significant amount of proposal segments that were to be included in federal, state and local government level grants, contracts and independently funded economic development initiatives.

Coordinate the entirety of grant hunting and drafting efforts.

Coordinate the conduction of surveys from outside organizations such ‘The Benchmarking Project’ from start to finish.

Participate in joint efforts with the defunct RedCo, El Paso Community College, El Paso Independent School District, the Paso del Norte Group under the OECD, the Federal Reserve Bank of Dallas, and the Manpower Group in providing relevant economic development data, insightful labor market analysis and the fulfilling of substantial survey instruments; all holistically purposive towards providing a comprehensive human capital strategy for guiding multilateral efforts in the El Paso del Norte region towards enabling new business formation.

Provide Texas State Senator Rodriguez with updated summaries of key economic issues affecting the counties of El Paso, Brewster, Jeff Davis, Hudspeth, Culberson and Presidio on an ad-hoc basis.

Aid Texas State Senator Rodriguez’s staff with the proffering of relevant regional economic research and analysis gauging the employment gainfulness of green occupations in the county of El Paso to procure a sizable grant for funding instructional programs to help dislocated workers residing in the county of El Paso.

Important Projects:

Agency:

Workforce Solutions

Place:

El Paso, TX

Project Time Frame:

June, 2011 to August, 2011

Project Type



Contact this candidate