Responsible for compiling, analyzing, and completing the OMWI Quarterly and Annual Reporting. I transformed their 12-week process into a process that currently takes less than 5 days.Responsible for gathering, analyzing, and reporting various monthly metrics reporting.Analyze and maintain data consistency across various systems.

Manage and coordinate a team of professional Customer Service Representatives. Complete sales, sales invoices, and reconciliation. Utilize Microsoft Office and X-1 system to track, analyze and report statistical data. Coordinate Accounts Receivable and Accounts Payable documentation. Responsible for Airport Security and Compliance. Schedule car rental, catering, and limo service for customers. Provide a quality customer service experience for all of our visitors.

Part-Time position with Elliott Aviation/Modern Aviation at the Des Moines International Airport working nights and weekends. Provide excellent customer service, handle account payments, arrange hanger, catering, car rentals, and various other services for our customers. Completed daily balancing and close.

As part of the Vulnerability Central Operations team:•Utilize quality tools and process definition to re-engineer technical processes for greater efficiencies•Managed large-scale weekly production process rendering data into actionable items which are passed to other teams within the department. This enables those units to directly and quickly resolve detected vulnerabilities.•Develop custom reports, complete analysis, and make recommendations for Vulnerability Remediation•Engaged in large-scale infrastructure system-scanning using QUALYS tools which search for known vulnerabilities which are aggregated into large datasets for further analysis by the assessment team• Complete ping-testing of nonresponsive machines, database management, procedural formulation and implementation, and existing process efficiency enhancement

Managed a team of 8 highly skilled individuals responsible for Bureau reporting to NCCI and ISO,Managed budgets, projects, and daily processes to ensure compliance with regulatory requirements. Expert in MS Excel. Created vLookups, pivot tables, and macros to analyze data and draw conclusions.Utilized MS Word, Outlook, and SharePoint for daily processes, presentations and budget planning.

Onboard and support of six Program Managers writing boutique insurance.Develop and implemented a data repository for admitted and non-admitted business.Managed the statistical and data reporting processes for P&C business.

Managed a team of ten Statistical Data and Reporting Analysts.Provided oversight of internal and external resources.Coordinated P&C, WC, Crop/Hail and A&H statistical and data reporting of our Program business.Oversaw and approved payment of surcharges, fees and various department expenses.Utilized MS Word, Excel, PowerPoint, SharePoint and Cognos for daily processes and presentations.Monitored regulatory changes at state and federal levels to ensure accuracy and compliance. Employed effective management and communication skills to build relationships on all levels.Participated in the planning, development, and implementation of new products.

Managed a team of six Statistical Reporting Analysts, four of which are in remote locations. Provided oversight of external resources through the use of key performance indicators (KPIs). Coordinated P&C and A&H statistical reporting of our Program/MGA business written on Admitted and Surplus Lines paper. Implemented the use of SharePoint to organize and track data calls and their requirements as well as comply with records retention requirements.Utilized effective management and communication skills to build relationships on all levels. Created presentations for internal and external customers using PowerPoint, Excel and Visio. Performed data audits and/or research regarding filings, reconciliations, or inquiries Monitored regulatory changes at state and federal levels to ensure accuracy and compliance. Identified, analyzed and facilitated actions necessary to comply with regulatory or bureau changes. Participated in the planning, development, and implementation of new products.

Documented the statistical reporting process for our admitted and nonadmitted carriers.Populated the SharePoint site with all known data calls. Over the past 12 months, this has increased on-time reporting performance from 84.22% to 97.44%.Created reusable queries in Excel and Access with formulas, vLookups, and Pivot tables designed to increase proficiency, accuracy, and consistency.Performed data audits and research regarding filings, reconciliations, and inquiries. Escalated issues accordingly to the AVP, Regulatory Compliance.Identified, analyzed and facilitated actions necessary to comply with regulatory changes.Assisted in the, planning and implementation of new MGA or TPA implementations.RenRe merged with QBE in October 2011.

Accomplishments: Received a Continuous Improvement Award for initiation and work on multiple projects to improve efficiency and performance in our area.Created Hyperion Brio and TSO queries to gather required data requests for internal and external customers.Completed data extraction, compilation, analysis, and reporting to the state and ISO..Provided data management, data analysis and technical report generation support to the product area to help assess business and product performance and development.Proficient at working with large amounts of data in Brio, Microsoft Excel and Access. Manipulate Data using Excel functions such as Pivot Tables and V-LookupsWork effectively with partners in IT and Operations to define business requirements and create methods to improve efficiency of the statistical reporting process.Complete ad hoc reports due to special requests from the state insurance departments.

Created and maintained personal lines rule/rate manuals for use by agents, state insurance departments, and internally.Prioritized and prepared filings based on state regulatory requirements.Recommended, designed, and created methods to improve efficiency of the filing process.Responded to special requests from the state insurance department for additional information

Researched, analyzed, interpreted, and evaluated statistical data for rate reviews.Designed custom Brio queries with pivot tables to calculate effects of various rating and/or coverage changes.Constructed Excel spreadsheets for analysis of data as well as for determining effects of various rate revisions.Analyzed industry information for competitive analysis, including identification of significant variation in rating plans among companies and programs.Presented relevant findings, conclusions, and recommendations to our Regional Offices and upper management.Prepared proper filing letters, exhibits, filing forms, and memorandums based on state regulatory requirements.Planned, developed, coordinated and implemented new programs, process, concepts, and procedures for our products.Designed/created methods to improve efficiency of the rate review process.

Managed projects to enhance the company's yield management system and corporate strategiesTrained and supported system users and worked collaboratively to develop and promote the use of best practices. Provided excellent service to internal customers.Understood and communicated complex systems as an effective liaison between technical and non-technical departments.Prepared and presented financial analysis for use in long-range strategic planning.Developed analytical skills necessary to recognize patterns in data, draw conclusions, and make recommendations for actions to improve effectiveness and efficiencies.Transmitted information timely, accurately, and understandably in written and verbal formats.Earned AINS Certificate in General Insurance - AICPCU

Allied Insurance became a member of Nationwide in 1998.Answer policy coverage and billing questions for insured and agent.

Interviewed, hired and trained new employees on the Apollo system. Prepared annual and monthly budgets, schedules, and station audits. Prepared work schedules and checked time sheets for staff. Conducted automated ticket sales, cargo sales, lost luggage, phone reports, and passenger analysis. Completed Haz Mat and Emergency Procedures Training every 6mos.

Responsibilities included all aspects of a ticket agent, gate agent, ramp agent and airport office accounting clerk. Operated System I reservation system including ticketing, seat assignments, and lost luggage search. Airport Office Accounting Agent duties for completing the daily, weekly, monthly accounting reportsResponsible for safety and well-being of minors traveling alone. Made arrival and boarding announcements. Handled oversales, delays and cancellations. Completed Hazardous Materials and Emergency Training Procedures.