SQL Server Information Technology
Resume:
MIKE MARTINEAC
Madison, Wisconsin 53711
*************@*******.***
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