Scott Ramer

Scott Ramer Email and Phone Number

Lead Software Engineer @ JPMorgan Chase & Co.
Federal Way, WA, US
Scott Ramer's Location
Federal Way, Washington, United States, United States
Scott Ramer's Contact Details

Scott Ramer work email

Scott Ramer personal email

Scott Ramer phone numbers

About Scott Ramer

I have over 14 years of experience in Microsoft Access and Excel. Whether it's building an Access database or Excel Spreadsheet from scratch, or taking over a legacy product and enhancing it, I am the go-to person for the job. My passion is automation, and building tools that help users maximize their productivity by creating tools that do as much of the heavy lifting as possible. Additionally, I construct all my tools with a focus on stability and longevity. What good is a tool if it breaks within a few weeks or months. Many of my user tools have been used daily for over 5 years and still going strong. I'm always looking for new challenges. Some people may claim that VBA is obsolete. While there are obviously more powerful tools available, VBA is readily available and baked in with existing Microsoft Office products, so I don't need to look for additional tools to do a job that can be done with VBA.

Scott Ramer's Current Company Details
JPMorgan Chase & Co.

Jpmorgan Chase & Co.

View
Lead Software Engineer
Federal Way, WA, US
Employees:
213060
Scott Ramer Work Experience Details
  • Jpmorgan Chase & Co.
    Lead Software Engineer
    Jpmorgan Chase & Co.
    Federal Way, Wa, Us
  • Jpmorgan Chase & Co.
    Business System Analyst
    Jpmorgan Chase & Co. Apr 2021 - Present
    Seattle, Washington, United States
  • Southern Nevada Water Authority
    Business Systems Analyst
    Southern Nevada Water Authority Feb 2019 - Nov 2020
    Las Vegas, Nevada Area
    • Performed business process analysis and collaborated closely with departmental subject matter experts to identity database application requirements for the department. to determine best possible database design solution• Designed, constructed, documented, implemented and maintained multiple business applications utilizing the relational database MS Access, data tables, queries, VBA, SQL and HTML
  • Unitedheath Group
    It Systems Analyst
    Unitedheath Group Jun 2014 - Feb 2019
  • Acuity Solutions, Llc
    Software Consultant
    Acuity Solutions, Llc Mar 2014 - Jun 2014
    Las Vegas, Nv
    Software Consultant
  • Wyndham Vacation Ownership
    Analyst
    Wyndham Vacation Ownership Jun 2010 - Mar 2014
    Las Vegas, Nv
    Responsible for accurate monthly, quarterly and annual timeshare assessment invoicing for250,000 customer accounts as well as out of cycle collection billing. Additional duties: Responsible for all departmental Owner Correspondence and Deed-Back Requests, Process Owner-to-Owner property transfer requests for Preferred Status Exchange resorts.• Developer and Administrator for WVR Client Revenue Management SharePoint Web-Site.• Designed, developed and administered Microsoft Access 2007 database utilizing Access tables, queries utilizing SQL commands, as well as MS Query that mined data from two separate Oracle records management databases, greatly improving assessment invoicing analysis and data set discovery.• Created Microsoft Access 2007 database utilizing Access tables and queries including SQL commands that streamlined billing process increasing productivity by 50%. • Streamlined monthly foreclosure reporting process through creation of customized Microsoft Access 2007 database / Microsoft Excel 2007 hybrid program utilizing VBA, macros and MS Query. Reduced processing time from 50 hours to 1.5 hours.• Managed all departmental Access 2007 databases to ensure maximum system availability and efficiency.• Assisted with departmental budget analysis utilizing Excel formulas and VBA macros, increased accuracy of department budget to 2%
  • United States Air Force
    Production Control Supervisor
    United States Air Force Aug 1985 - Aug 2009
    Nellis Afb, Nv
    • Trained and supervised 8 direct reports• Investigated maintenance related issues and created detailed reports for analysis• Documented and maintained aircraft maintenance records utilizing the Automated Maintenance Data Collection System for historical data analytics• Developed customized maintenance tracking SQL database to increase productivity• Responsible for creating PowerPoint presentation for daily management meeting• Created work schedules for all assigned personnel.• Trained and supervised 14 aircraft mechanics and monitored daily activities to maintain all assigned aircraft in an operational status• Work center Technical Order Distribution Officer, responsible for administration and upkeep of technical order library• Troubleshot maintenance problems and inspected aircraft for appropriate repairs

Scott Ramer Skills

Microsoft Excel Sharepoint Databases Access Visio Sql Vba Access Database Visual Basic Data Analysis Database Administration Database Design Data Mining Business Objects Microsoft Sql Server Analysis

Scott Ramer Education Details

  • Itt-Technical Institute
    Itt-Technical Institute
    4.0
  • Itt-Technical Institute
    Itt-Technical Institute
    4.0

Frequently Asked Questions about Scott Ramer

What company does Scott Ramer work for?

Scott Ramer works for Jpmorgan Chase & Co.

What is Scott Ramer's role at the current company?

Scott Ramer's current role is Lead Software Engineer.

What is Scott Ramer's email address?

Scott Ramer's email address is sc****@****hoo.com

What is Scott Ramer's direct phone number?

Scott Ramer's direct phone number is +170221*****

What schools did Scott Ramer attend?

Scott Ramer attended Itt-Technical Institute, Itt-Technical Institute.

What skills is Scott Ramer known for?

Scott Ramer has skills like Microsoft Excel, Sharepoint, Databases, Access, Visio, Sql, Vba, Access Database, Visual Basic, Data Analysis, Database Administration, Database Design.

Who are Scott Ramer's colleagues?

Scott Ramer's colleagues are Rahul Ulman, Debora Henretta, Deepika Sidhwa, Diana Walters, Julie Campbell, Satyabrata Behera, Agios Marlyn.

Not the Scott Ramer you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.