MIKE MARTINEAC

**** ********* **** - #**

Madison, Wisconsin 53711

810-***-****

aczze3@r.postjobfree.com

http://www.linkedin.com/in/mikemartineac

SUMMARY:

• Accomplished software developer with a decade of professional experience in the information technology industry.

• Self motivated, organized, and detail oriented individual, who is passionate about his work.

• Technical expertise: SQL, T-SQL, stored procedures, views, triggers, macros, functions, charts, reports, and spreadsheets.

• Able to navigate and query a relational database to assist in data analysis.

• Problem solver who continually works hard to contribute to the success of the organization.

TECHNICAL SKILLS:

• Languages: SQL, T-SQL, VBA (Visual Basic for Applications).

• Databases: MS Access, MS SQL Server.

• Tools: SQL Server Reporting Services (SSRS), MS Visual Studio, MS Management Studio, Crystal Reports, MS Excel, MS Word, MS PowerPoint.

PROFESSIONAL WORK EXPERIENCE:

REPORT ANALYST

TeamSoft, Inc., Middleton, Wisconsin

Contracted at American Family Insurance, Madison, Wisconsin

December 2015 to February 2016

• Automated a report builder and delivery system with VBA to assist over 3,000 insurance agents and managers nationwide.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Technical Environment: VBA, MS Access, MS Excel, MS Outlook, MS Word, MS Windows.

SSRS REPORT WRITER

Robert Half Technology, Middleton, Wisconsin

Contracted at Applied Tech Solutions, Madison, Wisconsin

March 2015 to May 2015

• Converted Crystal Reports to SSRS Reports.

• Configured SSRS to report from SQL Server Analysis Services multidimensional OLAP database cubes with DAX Expressions.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Technical Environment: SQL Server Reporting Services, SQL Server Analysis Services, MS Visual Studio, MS SQL Server, DAX, SQL, Crystal Reports, MS Excel, DAX Studio, MS SharePoint, Team Foundation Server.

REPORT ANALYST

Robert Half Technology, Middleton, Wisconsin

Contracted at Capital Newspapers, Madison, Wisconsin

March 2015 to March 2015

• Investigated a malfunctioning commissions report.

• Analyzed user needs, gathered information about the report, and examined any problems.

• Provided an alternative approach towards a resolution.

• Technical Environment: Crystal Reports, SQL, SQL Server, MS Excel, MS Word, MS Windows.

BUSINESS INTELLIGENCE SPECIALIST

Wisconsin Energy Conservation Corporation, Madison, Wisconsin 53719

January 2014 to July 2014

• Developed, deployed, and supported reporting initiatives for a company that specializes in energy products and services.

• Provided ad-hoc data requests and general assistance to fellow staff and programming analysts.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Created customized reports with MS SQL Server Reporting Services (SSRS) using a data warehouse while ensuring requirements have been met.

• Used SQL queries to provide datasets for reports with data warehouse and legacy data.

• Technical Environment: SQL Server Reporting Services (SSRS), MS Visual Studio, MS Management Studio, SQL, T-SQL, SQL Server, MS Access, MS Excel, MS Word, MS Windows, Team Foundation Server, Data Warehouse.

REPORT ANALYST

Beacon Technologies, Madison, Wisconsin

Contracted at Productive Programming, Black Earth, Wisconsin

June 2013 to August 2013

• Used programming skills to help a new company in the healthcare industry.

• Created data sets that were used when evaluating clients.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Processed client assessment data while ensuring requirements have been met.

• Developed complex views with TSQL.

• Technical Environment: SQL Server, T-SQL, SQL Server Management Studio, Care Compass, MS Excel, MS Windows.

REPORT ANALYST

University of Wisconsin Hospital and Clinics, Middleton, Wisconsin

December 2012 to February 2013

• Created reports per business, clinical, or operational requests.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Built data sets incorporating the Epic Clarity Data Model.

• Pursued certification coursework: Epic Clarity Inpatient Certification.

• Technical Environment: Crystal Reports, SQL Developer, Epic Clarity Data Model, MS Excel, MS Word, MS Windows.

MICROSOFT ACCESS DEVELOPER

TeamSoft, Inc., Middleton, Wisconsin

Contracted at JT Packard, Verona, Wisconsin

May 2012 to June 2012

• Successfully migrated Microsoft Access 2003 applications to Microsoft Access 2010.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Developed financial reports for the accounting department to improve revenue forecasting and analysis while ensuring requirements have been met.

• Created customized reports with MS Access to track revenue by region, product category, and contract type.

• Created user documentation.

• Technical Environment: MS Access 2003, VBA, MS Access 2010, Crystal Reports, SQL, MS Excel, MS Word, MS Windows.

REPORT ANALYST

Exacta Corporation, Madison, Wisconsin

Contracted at Scientific Protein Laboratories, Waunakee, Wisconsin

May 2011 to March 2012

• Developed financial reports for a biopharmaceutical manufacturing facility.

• Successfully migrated MS Access 97 reports to SQL Server Reporting Services 2008.

• Imported MS Access data into MS SQL Server.

• Created customized reports with MS SQL Server Reporting Services (SSRS) in MS Visual Studio while ensuring requirements have been met.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Created reports for the building maintenance department with Crystal Reports.

• Technical Environment: MS Access, VBA, Crystal Reports, SQL, T-SQL, SQL Server, SQL Server Reporting Services (SSRS), MS Visual Studio, Management Studio, MS Excel, MS Word, MS Windows.

SOFTWARE DEVELOPER

Beacon Technologies, Madison, Wisconsin

Contracted at CUNA, Madison, Wisconsin

June 2010 to September 2010

• Developed a Financial Reporting Tool to provide budget information for the Finance Department.

• Designed customized reports and forms with user entered criteria while ensuring requirements have been met.

• Imported data from multiple sources across the network into MS Access tables with VBA.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Technical Environment: MS Access, VBA, Crystal Reports, SQL, MS Excel, MS Word, MS Windows.

DATABASE MANAGER

Robert Half Technology, Middleton, Wisconsin

Contracted at Catholic Charities, Madison, Wisconsin

October 2009 to June 2010

• Repaired a malfunctioning database and restored its ability to produce critical reports while ensuring requirements have been met.

• Created and supported numerous types of reports for the Finance Department.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Created macros to import Microsoft Excel data into Microsoft Access tables.

• Developed reports to track the production volumes of professional social work agencies and assist in data analysis.

• Maintained demographic data for all programs and provided statistical reporting from it.

• Created user documentation and trained all staff on how to produce all reports.

• Technical Environment: MS Access, VBA, Crystal Reports, SQL, MS Excel, MS Word, MS Windows.

APPLICATION SUPPORT SPECIALIST

Robert Half Technology, Middleton, Wisconsin

Contracted at Rock County Human Services Department, Janesville, Wisconsin

May 2008 to November 2008

• Provided computer support of staff and acted as liaison for the Information Technology Department.

• Developed comprehensive user documentation for a data dictionary consisting of data definitions, data sources, user guidelines, company policies, and useful information for users while ensuring requirements have been met.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Programmed databases, wrote SQL queries, and provided reports as needed.

• Organized a complex library for the categorized documentation of frequently used Crystal Reports.

• Technical Environment: MS Access, VBA, MS Excel, Crystal Reports, SQL, SQL Server, MS Word, MS Windows.

DATABASE ANALYST

Office Team, Middleton, Wisconsin

Contracted at Wisconsin Petroleum Marketers & Convenience Store Association (WPMCA), Madison, Wisconsin

April 2008 to April 2008

• Designed and implemented an application to facilitate the registration of attendees at the annual convention.

• Technical Environment: MS Access, MS Word, SQL, MS Windows.

SOFTWARE DEVELOPER

Creative Financial Staffing, Madison, Wisconsin

Contracted at MasterGraphics, Madison, Wisconsin

February 2008 to March 2008

• Automated financial reporting that dramatically reduced the manual processes at month-end.

• Analyzed user needs, gathered reports requirements, and developed documentation.

• Created cyclical reports for the purpose of tracking actual sales, achieving of sales goals, and the analysis of sales commissions while ensuring requirements have been met.

• Programmed macros to import Microsoft Excel data into MS Access tables.

• Used database programming, report design, software utilization, organization, communication, teamwork, problem resolution, and detail orientation to support the reporting of commissions.

• Technical Environment: MS Access, VBA, MS Excel, Crystal Reports, SQL, MS Word, MS Windows.

EDUCATION:

Bachelor of Science in Computer Information Systems

DeVry University, Phoenix, Arizona, GPA 3.9

Course emphasis included: Software Programming, Database Management, Networking, Small PC Systems, Systems Analysis and Design, Web Design, Managerial Accounting, English/Technical Writing, Psychology, 900+ hours of practical lab experience.

CERTIFICATIONS:

Clarity Data Model - EpicCare Inpatient Certification

Epic Systems Corporation, Verona, Wisconsin

March 15, 2013

Contact this candidate