Brian Mohl Email & Phone Number

Work At Home

• Develop reports in Visual Studio using queries and stored procedures I create from SQL Server
• Help maintain the database and set up SSIS packages to run jobs and reports.
• Ad hoc reports and responsibilities which include importing data files and technical assistance among many.

Murray, NE

• Maintain the books and financial reports, run payroll, and do all business taxes.
• Communicate with all internet and email leads.
• Sales and marketing, including maintaining website and other marketing strategies.

Greater Omaha Area

In charge of all aspects for our SiSense BI software. Create Elasticubes, Dashboards, and administrate security, access, and functionality for all users.Create queries and procedures in SQL Server 2016 to pull data into SiSense and other reporting tools including creating reports in SSRS.Backup DBA including helping with ETL processes to import data into.

Greater Omaha Area

• Develop reports in Visual Studio using queries and stored procedures I create from SQL Server
• Help maintain the database and set up SSIS packages to run jobs and reports.
• Ad hoc reports and responsibilities which include importing data files and technical assistance among many.
• Maintain the SharePoint site including access, reports, and updates.

Greater Omaha Area

• Run claim reports for clients and associates for Medicare using SAS, Sequel and Excel.
• Analyze claim data for integrity and performance efficiency.
• Continuous Report Development, Data Mining, and critical thinking on various projects and procedures for overall business efficiency including updating macros, SQL/SAS language, and processes.

• Run Standard and Ad Hoc reports for Clients and Associates within the employee benefits department using Sequel Database extracts, Excel, Access, and PowerPoint.
• Update Scorecards and Dashboards and analyze report data for integrity and improvements.
• Continuous Report Development, Data Mining, and critical thinking on various projects and procedures for overall business efficiency.

• Maintain the books and financial reports; input and file sales tax for business.
• Work with Finance Companies on customer loans, and set up own company loans and amortization schedules.
• Sales and marketing, including maintaining website and other marketing strategies.

• Review the inventory, manage the money and staff, buy supplies and ensure that the bar meets legislative directives.
• Prepare taxes including sales, payroll, quarterly, and yearly taxes. Bookkeeping on a daily basis. Set up own payroll system in Excel, ran, and distributed.
• Market, advertise, and customer service to increase business.

Omaha, NE

• Update, test, and review rates and rating systems. Provide rating assistance to Field Reps.
• Calculate financial projections for Mutual’s Dental product on revenues, expenses, and claims.
• Design reports, analyze Dental figures, track groups, and miscellaneous projects and responsibilities.

Urbandale, IA

• Review contracts and rates for accuracy, proper language, and detail. Set up, analyze, and calculate rates for fee schedules to providers.
• Claim analysis: test and review claims to make sure they are paying correctly, and determine a rate if claim payment is incorrect.
• Assist in multiple projects with addition of new company and contact for all Microsoft technical questions.

Des Moines, Iowa Area

• Review loans to verify all needed documents are included in the file.
• Speak with closing company to verify information and confirm closing time.
• Receive final documents and close file in system.

Lincoln, Nebraska Area

• Create Databases in Access, build queries and create reports in a business presentable format. Reports such as: Financial, Loss Ratio, Production, Claims, Trends, and Forecasting.
• Import and Export data from other companies and within databases. Design graphs and charts from data to show trends and profits or losses.
• Handled Reinsurance and Profit sharing accounts. Sent out quarterly statements and year-end cession reports.
• Experience in the role of Underwriter and Cancellation Clerk during my term with Heritage Warranty Insurance.

Sun Prairie, WI

• Studied weather patterns for catastrophic occurrences. Used data and software from weather department to gather data and assist in correlations and final results. Organized data in complex spreadsheets from SAS.

Master'S Degree, Data Modeling/Warehousing And Database Administration

Bachelor Of Science (B.S.), Finance, Mathematics Minor