Experience

Gebauer Company

• United States
• Medical Device
• 1 - 100 Employee

• Business Analyst

  • Jan 2018 - Present

  Provided unit data and trends, ad-hoc analysis and calculated commissions utilizing easy-to-digest Power BI visualizations and more basic Excel Pivot Tables in support of the Sales Department. Integrated existing sales data with exterior databases to provide a full picture of our customers to further marketing goals. Provided TSQL, PL/SQL, IQMS and Crystal reporting to help fulfill manufacturing goals. Provided unit data and trends, ad-hoc analysis and calculated commissions utilizing easy-to-digest Power BI visualizations and more basic Excel Pivot Tables in support of the Sales Department. Integrated existing sales data with exterior databases to provide a full picture of our customers to further marketing goals. Provided TSQL, PL/SQL, IQMS and Crystal reporting to help fulfill manufacturing goals.



Oswald Companies

• United States
• Insurance
• 300 - 400 Employee

• Business Data Analyst

  • Oct 2015 - Sep 2016

  Worked with both business and technology stakeholders in design of data integration to support key business functions and reporting requirements, performed analysis for data quality and completeness, served as a technical resource to determine the data points in the design of custom reporting, fielded incoming questions from end-users and escalated to the proper authority, developed SQL queries against existing data framework to expose data necessary for extraction, researched and recommended visualizations for data requested for internal and external customers, and monitored daily logs to assure regular scheduled execution of core systems.



SummaCare

• United States
• Insurance
• 100 - 200 Employee

• Associate Reporting Analyst

  • Mar 2011 - May 2015

  Provided analysis and technical expertise in support of the production areas of the company.Established and maintained reporting/analytical processes as aligned with corporate requirements to provide actionable intelligence to middle and upper management, as well as regulatory authorities. Maintained a working knowledge of relevant information systems, databases, data schemas, software packages, business operations to facilitate precise, reliable and accurate fulfillment of information needs.Built, designed and inspected reporting packages in a variety of formats with audience, performance, and use case in mind. Collaborated with upper management and production staff to organize, coordinate and fulfill reporting and analytical needs via education, explanation and interpretation.

• Administrative Processor (Vertexer)

  • Nov 2006 - Mar 2011

  Created and distributed reports for multiple departments utilizing Access, Excel, and other proprietary programs. Provided administrative data processing and basic analysis of a wide variety of medical insurance claims for a state insurance program. Proofread hundreds of medical insurance claims per day for errors and omissions to ensure timely and reliable service to external and internal clients.

• Underwriting Clerk

  • Apr 2006 - Nov 2006

  Created and distributed basic reports for both intra- and inter-departmental audiences.Categorized, filed, organized and delivered Underwriting paperwork to the proper location. Provided a variety of clerical administrative roles in support of the Underwriting department.



Mongoose Online Entertainment

• Director

  • Mar 2003 - Nov 2012

  Assisted in the administration, player relations, marketing, overarching plot and content development, and oversight of a 200 player text-based roleplaying game. Assisted in the administration, player relations, marketing, overarching plot and content development, and oversight of a 200 player text-based roleplaying game.



Various

• Temporary Positions

  • Jun 1999 - Apr 2006

  Various temporary positions, including logistics clerk, retail clerk, automotive parts assembly, and automotive parts room. Various temporary positions, including logistics clerk, retail clerk, automotive parts assembly, and automotive parts room.