Hector Saenz Email & Phone Number

Houston, Texas, Us

Lead Date Engineer/Programmer Analyst: Project managed server upgrades spanning multiple Server OS, Citrix XenApp, App version on real, VM servers and Virtual Desktop Infrastructure (VDI). Design and create reports and dashboards using Crystal Reports and Tableau running on Sql Server, Oracle, and local MS Access dbs. Teamed with clinical and financial resources to create special data-marts to help streamline and quicken the reporting using Business Object, Tableau to support the healthcare trend in Population Healthcare Management and Patient Centered Medical Home. Support equipment that interface with EMR including EKG, Vital signs, Radiology. Project Manager - TQ Appeals/Denials System, EPSi Decision Support/Cost Accounting System Programmer/Analyst - Interfaces, reporting,based on Delphi, VB, TSql, DTS, SSIS- Wrote program that decreased EPSi loads from 4-days to 4-hrs- Wrote program to allocate and apply Lump payments to patient accounts based on user criteria. - Wrote program to interface between EMR to Referral program - Wrote program to facilitate identifying and updating costing RVU's. - Wrote program to give management a way to monitor database resource use by users - Developed extracts to migrate between Sql Server to Oracle Based EMRS - Wrote program using TCPIP to communicate between Main frame and Windows based systems. - Wrote extracts to automatically update datamarts used for daily dashboards and reporting. - Developed Python scripts using rest API's, Geocoding, XML Excel update and conditional formatting to simplify and automate the combination, cleansing and distribution of reports and data and update SSIS configurations dynamically. Converted scripts to Windows Exe's.EMR experience include Cerner, GE-Centricity Practice SolutionsLanguages include: C#, Delphi, VBA, Python, SQL scripting, Database: Sql Server, Oracle, SnowflakeBI tools include: Business Objects, Crystal, Tableau, Tableau-Prep, Alteryx and Crystal Rps,

Us

Responsible for Hospital Budget, Financial Statements and development of Cost Accounting system on TrentStar. Assisted in conversion of HBOC financial system which required writing a special interface. Designed reports for tracking Appeals/Denials process. - Wrote interface program that allowed migrating all detail trail balance information into a new Accounting system. Our facility was the only facility that that level detail!

Implemented and managed HCM Decision Support system, Developed yearly budgets. Configured cost accounting system based on combined RVU and RCC methods. Modeled reimbursement contracts based on multiple algorithms including DRG, Per-Diem, HCPCS and ICD9 and capitated population based. Created probability reports and audit reports that identified underpayments. Created what-if scenarios to assist with insurance contract negotiations. Managed process for calculating and posting contractual adjustments. - I wrote a program that queried the detail A/P accounts to identify insurances which did not comply with payments deadline contract agreements which stimulated millions in payments.

Managed General Ledger, Accounts Payable, Payroll systems and personnel.Developed hospital budget.Managed Third Party reimbursementManaged Yearly SEC and Internal Audits.Wrote programs as needed to expedite Bank Rec's, GL closing, Third Party Rec's. - on my first week wrote a program and reconciled 9 months of PR and AP bank reconciliations...in time for our upcomming internal audit!

Completed Financial Statements.Assisted with Budget, Medicare costs reports.Prepared special analysis, ROI, Pro FormasSupported the Data Center.Supported the G/L, A/P, P/R.

Project managed projects related to tank farm safety, warehouse design and build. Worked on preventive maintenance system/program.

Master Of Business Administration (Mba), Business/Commerce, General

Bachelor Of Science (Bs), Business/Accounting

Bachelor Of Science (Bs), Mechanical Engineering