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 internal and external data sources - Automate processes wherever possible - Provide expertise on technical projects relating to data analytics

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• Developed Python scripts for the Data Science team in connecting to offsite databases (SAP Hana)• Developed essential Tableau dashboards to replace aging and inefficient excel reports.Duties:1) Automate existing reports using Python & VBA2) Collaborate with the Data Science team on cross functional projects (API interfacing, technical documentation, dashboard & code optimization)3) Build Tableau dashboards for clients for quick exploratory analysis of financial data4) Migrate excel based reports to modern data visualization tools5) Document existing processes and procedures.

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 dashboard capabilities.- Dashboard scripts were updated to reflect new server migration changesDuties:1) Research, document, and report innovative ways to adapt new technologies to augment our processes2) Develop and maintain physician network integrity dashboards3) Assist with server migration tasks4) Insure dashboards are updated and accurate in their reporting standards5) Collaborate with co-workers from different teams on cross-department projects

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- Documentation was created and organized which was then used to help troubleshoot breaks in data models and key Tableau dashboards- Designed, organized, and conducted a lunch & learn seminar to teach Python to coworkersDuties:1) Validate and prepare hospital data for monthly clinical close & publication for business owners to review and make data driven decisions2) Collaborate with business owners, business intelligence, and ETL teams on current and future data projects3) Analyze hospital performance & publish findings in recommendation reports for hospital administrators4) Become a subject matter expert on hospital blood transfusion consumption and internal compliance5) Develop and improve SQL queries to connect dashboards to production databases used for clinical data storage 6) Design and construct live Tableau Dashboards to report on KPIs; blood transfusion compliance, blood transfusion volume for directors across 20 hospitals

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 tasks and areas for improvement3) Develop programs utilizing VBA

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 advice/consulting on efficiency and technology4) Assist in finance/accounting & decision support with general ledger deletion of obsolete assets5) Share programming skill and techniques

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) Record Keeping8) Assisting in the improvement of internal controls9) Error finding and discrepancy reconciliation10) Process & Procedures

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 reconciliation10) Process & Procedures

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) Researching environmental conditions 4) Developing marketing strategies 5) Designing and developing a marketing plan

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