Robert Singer Email & Phone Number

California, United States

Irvine, Ca, Us

Created, maintained and enhanced Executive Summary and Management Reports and Field Reporting designed to provide visibility of key performance indicators timely, efficiently and accurately.• Developed turn-key SAS/Access/Excel Reporting Model used to track business trends. Streamlined reporting process resulted in saving over 2 1/2 hours of report processing time per day for over 70 reports. • Created tools to filter data automatically using VBA for Excel. Process saved time in the creation of reports and provided end users a way of verifying that the data was accurate.• Designed Excel charts for easy upload into monthly Power Point slides. Automated process resulted in a savings of over 8 hour per month processing time for a 30 page Power Point Executive Performance Presentation.Specialties: Automotive Finance Mortgage BankingFinancial ModelingAdvanced Access, Excel, Power PointSQL Power UserBig Data, SAS, SQL ServerApplications DevelopmentDatabase DesignData Analytics Project ManagementProcess ImprovementsCompetitive AnalyticsReport AutomationData Mining & Analytics

Irvine, Ca, Us

Maintained department’s pricing scenarios. Executed monthly program launch through rate analysis, file upload, and end of month billing. • Developed Pricing Engine upload tools utilizing MS Access, VBA for Excel and SQL. Pricing tools streamlined the creation of CSV’s and allowed more efficient validation of monthly bulletins.• Reprogram VBA macros as needed to accommodate program structure changes. Creating CSV’s insured that monthly programs were processed timely and efficiently.• Created and maintained Database of vehicle residual values using a combination of VBA Forms, Macros and Query functions. Process improvement save 4 hours per month processing time.Specialties: Automotive Finance Mortgage BankingFinancial ModelingAdvanced Access, Excel, Power PointSQL Power UserBig Data, SAS, SQL ServerApplications DevelopmentDatabase DesignData Analytics Project ManagementProcess ImprovementsCompetitive AnalyticsReport AutomationData Mining & Analytics

Irvine, Ca, Us

Created and provided technical support for internal subvention billing system. Maintained SAS and MS Access databases libraries for department. Technical support for all Access, SAS and VBA for Excel Systems.• Created and subvention billing system that included over 20 forms used to import, export, validate data and generate reports from Daybreak and LeasePak. • Developed over 20 automated billing reports using VBA for Access and VBA for Excel which saved our billing analyst 16 hours of processing time per month. • Created residual database and developed MS Access form based system for importing ALG data, validating import and exporting data used for input in our Blaze Engine that save approximately 12 hours of processing time per month.Specialties: Automotive Finance Mortgage BankingFinancial ModelingAdvanced Access, Excel, Power PointSQL Power UserBig Data, SAS, SQL ServerApplications DevelopmentDatabase DesignData Analytics Project ManagementProcess ImprovementsCompetitive AnalyticsReport AutomationData Mining & Analytics

San Dimas , Ca, Us

Developed and maintained various business applications for water company:Maintained and developed business applications written in Access, SQL, and Visual Basic. • Enhanced Capital Projects Management System (CPMS2). Work involved using data extraction, transformation and loading (ETL) of text data.• Developed and maintained GSWC’s mandated Safety Database used to track the safety training requirements of company employees.• Developed Effective Metering System used to monitor meter flow and accuracy rates of large meters and determine their replacement.• Developed and maintained ad hoc weekly and monthly Accounts Receivable Aging Reports using MS Access, Excel. Heavy use of Access and Excel Pivot Tables.• Guest lectured at American Water Works Association (AWWA).Specialties: Advanced Access, Excel, Power PointSQL Power UserBig Data, SAS, SQL ServerApplications DevelopmentDatabase DesignData Analytics Project ManagementProcess ImprovementsData Mining & Analytics