Nick Perkins Email & Phone Number

Ontario, California, United States

Results - Thousands of publicly available documents from airports around the country were collected and curated for analysis - Executive level dashboards were created for upper management to identify areas for growth and improvement - Provided analytics expertise and advice to improve the company's data maturation.Duties - ETL documents and data from both.

Ontario, California, United States

Ontario, California, United States

Rancho Cucamonga, California, United States

• Wrote and optimized new/existing SQL Scripts for monthly report processing
• Performed Ad Hoc analysis & reporting on key metrics for Prop56 measurements
• Streamlined reporting process to improve accuracy and performance

Tampa/St. Petersburg, Florida Area

• Results:
• Developed ETL solutions with Python and REST APIs for business owners
• Developed Azure SQL Server Solutions to improve forecasting process
• Review, validate, and maintain accurate sales forecasts
• Developed VBA macros to automate critical Excel spreadsheet reports
• Standardized and documented existing processes

Orlando, Florida Area

Results:- Designed and built an Amazon Alexa based dashboard to test innovative ways to reveal critical KPI's quickly to key decision makers. (Python, AWS Lambda, and the Alexa Skills Kit were used)- Identified and cataloged trusted open-sourced data sets containing census, economic, and healthcare data for future use in augmenting our data analysis and.

Roseville, CA

Results:- Critical Tableau dashboards with executive visibility were published to provide insight into clinical & hospital performance- Consolidated related but separate dashboards into one universal dashboard for ease of use and maintenance- Efficient SQL queries were created/improved allowing for easier maintenance and increased performance.

Riverside CA

Write automation programs that save time, money, and ultimately stress for the school and its employees.Results:- Over a hundred hours saved in upfront data entry- Dozens of hours saved annually due to recurring tasks being automatedDuties:1) Provide efficiency and technology consulting services to faculty and professors2) Find and eliminate time consuming.

Glendale CA

Assist in resolving financial and technological issues.Results:- Assisted in developing a regional dashboard for four sister hospitals across California- Numerous tasks were eliminated or reduced due to my automation programsDuties:1) Assist in business intelligence tools (Tableau, Pentaho)2) Automate tasks and increase overall productivity3) Provide.

Served as interim accountant until suitable replacement is found.Results: - After previous accountant left, operations continued to run smoothly - Process and Procedures were improved with NCUA approvalCurrent Duties1) General Ledger Postings2) Bank Reconciliations3) General Ledger Balancing4) Month End Duties5) Accounts Payable6) Levy's and Compliance7).

Loma Linda, CA

Was hired part-time as an accounting assistant to head of Accounting, as a result of my hard work as an intern.Duties1) General Ledger Postings2) Bank Reconciliations3) General Ledger Balancing4) Month End Duties5) Accounts Payable6) Levy's and Compliance7) Record Keeping8) Assisting in the improvement of internal controls9) Error finding and discrepancy.

Loma Linda, California

Results:- As first intern in company history I helped establish a precedent for future interns.- Went from unpaid to paid after completing internship due to quality of work.DutiesAccounting 1) Posting journal entries 2) Bank reconciliation 3) File maintenance and organizationMarketing 1) Researching market conditions 2) Researching competitors 3).

Hartford, CT

Responsibilities 1) Programming laptops, desktops, and phones 2) Retiring old and outdated equipment 3) Customer service 4) Problem ticket handling 5) Communication and problem resolution