Robert Lukas Email & Phone Number

Reporting and analysis in the insurance division.

Mesa, Arizona, United States

• Created greater visibility into operational metrics, identifying revenue gaps and cost concerns by creating over 200 SSRS and Power BI reports using PL/SQL and T-SQL scripts that pulled data from Oracle and SQL Server databases, warehouses and cubes.• Provided 180+ clients an in-depth view to manage, reconcile and grow their programs by creating statistical, revenue and waterfall reports using SQL, Excel, SSRS, Power BI and SharePoint embedded in proprietary applications.• Supported Accounting with month-end A/R data files to collect on monthly billing averaging $15M and assisted clients and Account Managers in identifying issues and providing solutions to increase revenue 5-10% per year.• Used both Agile SCRUM and Kanban methods for development, along with taking on the role of team lead to increase the knowledge of other programmers on the data environment, scripts and applications.

Mesa, Arizona, United States

• Supported and improved Oracle based applications by creating test SQL scripts and logs to monitor and enhance DMV, violation, printing and billing processes by removing manual interventions.• Created ad hoc and production reporting using PL/SQL, SSRS and Excel either standalone or within SharePoint that provided instant and reliable metrics and focused data lists to measure, monitor and increase program objectives.• Collaborated with Accounting, Operational Support, Legal, Marketing and Account Management to provide guidance and insight into the processes and data flow to support and enhance strategic decisions.

Scottsdale, Arizona, United States

• Created and maintained SQL Server database for Fleet Division containing over 1.5 million records used to create KPI reports reviewed monthly by management.• Supported Accounting with reconciliation of billing and payment for Fleet clients totaling over $10 million.

Phoenix, Arizona, United States

• Managed a variety of data management tasks and created multiple monthly reports using Microsoft software, Oracle SQL and mainframe VSE, for team associates and group leaders.• Generated reports including monthly group revenue, job and record volumes, ad hoc client usage and file transmission reports using SQL, Excel, Access and VBA scripts.• Created VB/VBA macros for internal use and client use, also to improve efficiency in reporting of data extracted from Oracle and Microsoft SQL Server databases.

Phoenix, Arizona, United States

• Managed all steps of the processing in a large project for a key customer that generated between $800,000 and $1,200,000 in revenue per year.• Client contact included working with Assistant VP and Senior Banking Officers along with List Management and Technical Support.• Additional special projects included working with the Phoenix site accounting group to produce pretax statements for multiple divisions by querying corporate databases using Essbase and Excel.• Created VB macros in Microsoft Excel, Word and Access as a Solutions Developer to generate reports used in other groups within internal division, and for the client.

Tempe, Arizona, United States

• Collected and analyzed customer purchasing patterns using SQL and Excel, along with Account Managers’ sales activities to increase ROI. • Produced weekly and monthly status reports for Controller, Vice Presidents and Directors of Sales and Marketing Departments using Excel, Access and Word. • Created customer and prospect lists used for mailings and other reporting functions.

Tempe, Arizona, United States

• Managed over 500 computer VAR (value added reseller) accounts in the western region of the United States with individual credit lines ranging from $1,000 to $4,000,000. • Analyzed financial statements of VARs to establish satisfactory credit lines. • Collected on past due accounts and reconciled when necessary using Windows based programs such as Excel and Word.

Bachelor Of Business Administration - Bba, Accounting And Finance

Liberal Arts And Sciences, General Studies And Humanities