Scott Ramer Email & Phone Number

Federal Way, Wa, Us

Seattle, Washington, United States

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

Las Vegas, Nv

Software Consultant

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%

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

Bachelor'S Degree, Information Technology Project Management, 4.0

Activities and Societies: National Technical Honor Society

Associates Degree, Computer Network Systems, 4.0

Activities and Societies: National Technical honor SocietyGraduated Magna Cum Laude and Class Valedictorian