Mark W Viola Email & Phone Number

Waltham, MA

• Developing, maintaining, and managing all analytic and operational business reports based on the MS SQL Server Reporting Services (SSRS), Microsoft Power BI, Solver, and MS SQL Server Management Studio.
• Constructing and maintaining data warehouses to support dynamic dashboard reports.
• Performing complex ad-hoc SQL queries when access to data is required to support internal and external client needs.
• Optimizing and tuning existing queries for efficiency and decreased database impact.
• Customizing and presenting reports using MS Excel (charting, graphing, and pivot-tables).
• Developing comprehensive forecasting and data modeling using data from diverse data sources including multiple SQL databases, Salesforce, Mitel, and imported data feeds.

Phoenix, Arizona Area

• Developed PL/SQL-based reports with Oracle Reports Developer to support Retail Lending.
• Used JavaScript coding to enable parameter-selection in online reports.
• Performed detailed analysis to provide business intelligence on home equity lending, vehicle finance, closings, and declines.
• Participated in company initiative to convert all reporting from SAS-based to SQL-based reporting.
• Performed extensive QA measures to assure reporting accuracy.

Phoenix, Arizona Area

• Processed and incorporated client input files into a variety of standard and ad-hoc data deliverables for pharmaceutical companies. Data reported: sales, prescription activity, market research, compensation statistics.
• Communicated with external and internal clients to ensure accurate incorporation of sales specifications and satisfactory resolution of inquiries.
• Used SQL and SAS to analyze data trending and quality-assurance analysis.

Master Of Arts, Clinical Mental Health Counseling

60-credit masters program emphasizing mental health counseling, research design, assessments, and program implementation.

Bachelor Of Science, Psychology