JUAN MILLS
BUSINESS SYSTEMS ANALYST
TECHNICAL SKILLS
PSQL Test Cases Excel Migrations Business Intelligence Microsoft products
Planview Data Integrity Database modeling VMS DBMS MySQL Oracle Reporting Azure DevOPs Sharepoint
EDUCATION/CERTIFICATIONS
Northeastern State University
Bachelor’s Degree
Medical Billing 8 years experience
EXPERIENCE
BH Management Services, LLC
June 2023 – Current
Make Ready Technician
● Responsible for Make Ready Inspections, repair, replacement of appliances Final sign off before move-ins are approved
KForce IT
May 2022- Nov 2022
Contract Employee Kforce working for client GM Financial Business Systems Analyst
● Worked within an Agile Scrum Team, to gather requirements/estimate project size, scope, and dependencies.
● Created User Stories/Features/PBI's Product Backlog Items using Gerkin syntax for the Scrum team for Multi client projects.
● Received training in SAFe practices for Agile and Exams with Pluralist receive several Badges including for Agile Scrum.
● Received training in SMART Communications/Cloud for existing and creation of Templates for projects.
● Manage print vendor client for regulatory compliance for Final Checklists and Signoffs.
● Using SQL for Data Analytics and Validation to reserve and conditioned Test accounts for Post Repossession (Federal Regulatory Compliance using SQL (TDM) Test Data Management Application. QA/UATD environments.
● Used Production Mock up data for testing.
● Assisted with Regression Testing for System Migration from Thunderhead to SMART Communications system.
● Identified Scenarios for Testing various Types.
● Assisted with Deployment and Remediation of deliverables to Live Production.
● Tracked and Validated testing efforts for other departments.
● Obtained Signoff Approval for Federal Regulatory Compliance of IRS Tax form 1099C/1095C as Coordinated with Leadership internal and External. UDR Management
Sept 2021- Feb 2022
Maintenance Tech
● Responsible for Repairs, Inspections, and installations of appliances and hardware of over 1100 apartment units.
BH Management Services, LLC
March 2019 – June 2021
Make Ready Technician
● Responsible for Make Ready Inspections, repair, replacement of appliances
● Final sign off before move-ins are approved
Liberty Group
Aug 2017 – Feb 2019
Make Ready Technician
● Responsible for Make Ready Inspections, repair, replacement of appliances
● Responsible for pools, fountains, and spas
● Final sign off before move-ins are approved
● Training the porters
● Monitoring the progress of temp/contractors
Greystar Property Management
Oct 2016 – June 2017
Make Ready Technician
● Responsible for Make Ready Inspections, repair, replacement of appliances
● Responsible for pools, fountains, and spas
● Final sign off before move-ins are approved
● Training the porters
● Monitoring the progress of temp/contractors
St. John’s Hospital (Regional Medical Lab)
Salaried Employee July 2001 – June 2003
Business Analyst, Script Writer, Business Objects Report Writer
● Created scripts for Bank Deposit Automation in one week
● Successfully completed the project in less than one month
● Increased Revenue by more than $1 Million+
● Developed Business Intelligence Reports for Regional Medical Laboratory.
● Managed Charity Case accounts for Hospital
● Wrote-off charges at my discretion.
NDCHealth Clearinghouse
Business Analyst
Contract Employee TEK System's working for client NDCHealth from July 2003 – December 2003
HIPAA, OLAP, VMS, VAX, ERP
● Data Interface
● Modified Data Structures
● Reported to management using OLAP reporting tools
● Maintaining HIPAA Regulatory upgrades for PERSE and WebMD Saint Francis Health System
Salaried Employee September 1999 – June 2001
Business Analyst, Data Interface, Pascal and Oracle Tester
● Performed Data Integrity Validation for patient Demographics and Physician Fee Reimbursement for the Entire State of Oklahoma
● Solely responsible for Advanced Satellite Encryption, ERP/OLAP case management.
● Held Exclusive access to Highly Advanced Satellite Encrypted IDX work case management site.
● Given access to the Satellite Key that changed every 2 minutes.
● Partnered with Lead Programmers and System Engineers on debugging code, validating data interface, and sign approval for IDX commercial software in LIVE Production for Managed Care division of SFHS.
● Reported findings to case management team for analysis & provided authorization for completion.
● Responsible for System Migration for the Saint Francis Health System's managed care division.
Celerity IT
Contract Employee August 2005 – January 2006
Business Systems Analyst
XML, JAVA, OLAP, ERP, HIPAA
● Worked with Clearinghouse Client for authorization for production ready data configurations.
Family Medical Care
Fulltime Employee December1998- August 1999
Account Executive
Medicare and Medicaid, CPT and Diagnosis coding
● Corrected specific Psychologist Diagnosis and CPT coding of patients for authorization of payment
● Doubled Psychologists monthly revenues within 3 months (from $30k-
$60k/mo.)
● Held exclusive access to physicians highly confidential records
● Managed retirement patient claims
● Authorized extensions on payments