Rick Compton Email & Phone Number

Albuquerque, New Mexico, United States

Albuquerque, New Mexico, United States

Unm Comprehensive Cancer Center (Albuquerque, Nm)

Optimization Services (Albuquerque, Nm)

Provide support to the Optimization Services Technology Management (OSTM) team and act as a business liaison for initiatives impacting financial applications and technical infrastructure. Provide support for developers and OS teams to allow for the Corporate Shared Services Center (CSSC) functional teams to focus on daily accounting/operations to increase productivity and focus on the company’s success. Provided critical technical support to users during fiscal period close which ensured timeliness completeness and compliance with auditory teams, tool functionality and schedule for deliverables Implemented standardized templates for end user job aids and technical support knowledge base to help maintain OSTM tools, databases and processes Developed and maintained user security control process to adhere to GapTech information security protocols and SOX guidelines for finance applications

Global Enablement Services (Albuquerque, Nm)

Use Lean Six Sigma approach on projects to optimize business processes and increase resource efficiencies. Lead, support, develop and implement continuous improvement initiatives within the Corporate Shared Services Center (CSSC), Tax, Franchise and Corporate Controllers Group. Drive, identify, coordinate, and develop strong cross-functional partnerships to influence and nurture collaborative work environment. Support IT infrastructure on high severity incidents, pilots, Enterprise Resource Planning (ERP) upgrades, telecom and communication issues, and business communications and provide escalation with additional support teams as necessary. Planned, developed and implemented Extract Transform Load (ETL) processes to provide millions of rows of data from IBM Tririga Enterprise Lease Management System into SQL Server environments which led to compiled data sources and an optimized data warehouse which supporting global real estate lease tools for end users after the ERP system upgrade Supported future implementation of the new lease accounting guidance by the FASB/ISAB by building innovative yet simplistic data archiving process to archive Scheduled Rent information and resulted in saving IT cost from ERP limitations and limited resources Collaborated with development team on Robotic Process Automation (RPA) through Proof of Concept (POC) to build skills and when applicable incorporated into end-to-end solutions

Real Estate Processes, Strategic Initiatives (Albuquerque, Nm)

Provided detailed explanations and technical design documents on design, object relationships, functionality and stored procedures. Instilled collaborative work environment on business requirements, database designs, technical training, analysis and user support. Provided management with proposed EPR/IT system solutions that increase process efficiencies, data integrity and key control standardization. Upgraded 30+ MS Access databases to backend SQL Server environments to enable global users (300+) functionality and 24/7 availability for streamlined business processes Coordinated restatement of complex cash flow calculations for Right of Use (ROU) module to create detailed historic analysis of assessment for financial impact from proposed changes to existing lease accounting principles of accounting Led project to migrate data for 3000+ lease profiles and historic payments from SQL Server models to become system of record in IBM Tririga Enterprise Lease Management System and replacement of ERP system.

Real Estate Processes, Fixed Assets (Albuquerque, Nm)

Responsible for Asset Management system reporting and analysis from various data sources using MS Access. Prepared monthly fixed asset reports for both Gap Inc. business partners as well as internal and external auditors. Completed key control certifications on fixed asset additions, adjustments, retirements, and transfers through internal controllers group with zero material weakness or failures found. Completed key control certifications on fixed asset additions, adjustments, retirements, transfers through internal controllers group with zero material weakness or failures Decreased manual validations through improvements to 20+ databases, expanded automated processes which resulted in lower data redundancy and increased accuracy/currency of information Built ad-hoc reporting to extract Net Book Value from system of record due to failing Oracle asset registers during critical financial year end activities and therefore met PBC deliverables

National Training Center, Doe (Albuquerque, Nm)

Leveraged proprietary software as a foundation to build MS Access databases that provided enhancements to accounting, budgeting, finance, human resources, payroll processing and purchase services. Supported management through catalog of ad-hoc reports through MS Access and Excel based tools. Supported implementation of FRx reporting system to provide monthly corporate financial reporting and invoicing to Department of Energy (DOE) Developed, packaged and deployed Crystal Reports to meet changes to departmental requirements and service requests Upgraded legacy requisition database from MS Access 97 to MS Access 2000 and redesigning data-flow charts and graphical user interfaces (GUI) for purchasing department