• Provide support to various business units within the Hallmark organization by providing ad hoc and scheduled reporting, data extracts, research, and code development in an Oracle PL/SQL environment• My team and I were tasked with quickly learning a new system being utilized by the organization, and in the process identifying data discrepancies between it and the source systems, as well as providing detailed and complex reports to help the business units plan for future seasonal distribution.• Presented automation options and examples to help business units get the recurring reports they need promptly and with a self-serve option when available, cutting down on the units’ need to request and wait for their reporting needs.

Responsible for project in which we were phasing out SSIS pipelines and converting to Azure Data Factory. Duties included gathering requirements, planning, development and testing in pre-production environments, and working with end users to ensure quality and accuracy of new pipelines.Responsible for fixing, testing, and implementing SSIS packages intended for later phases that were broken to ensure all data flows at all levels were functioning properly.Developed and updated ad hoc reports in Power BI and SSRS for management and underwriting.

Create dashboards, connections, and integrations with Power BI to provide reporting tools to Dechra at an international level.Ad hoc requests to support Business Intelligence and IT teams

Primary support for Guardsman Franchise Auto, a new division within Amynta offering P&C insurance to franchised auto dealers.Varied duties include develop reporting tools in Excel and Access for distribution to division executives, assist Underwriting team with MVRs, agency communication/setup, handling monthly/yearly reporting and filing to state-level insurance departments.

Responsible for ensuring all data systems (source systems, data warehouses) were in synch by way of reporting dashboards, monitoring error reporting and alerts, and acting as a direct point of contact from field and home office associates.Development of ad hoc and recurring reports used by internal customers to analyze prospective clients, plan for renewals, and track productivity.

Implementation, maintenance, and documentation of systems integrations. Responsible for identifying broken integration processes, monitoring alerts, troubleshooting issues, and fixing them to ensure data systems communicated with each other smoothly and without error.Development of ad hoc and recurring reports used by district administration to analyze and plan for future actions.

Responsible for developing reports for all divisions of the AAFP, including acting as first point of contact, gathering requirements, discussing available options, code and report development, and delivery of the final product. Primary work is done in SSMS/SSRS but have done some dabbling in Power BI and Tableau as well.Quality assurance testing for data warehouse development. Ensure each system ties back to one another, all necessary data is accounted for and summarizes properly, and make recommendations and/or report errors or development needs based on findings.

Design, implementation, and maintenance of custom-built WordPress-integrated system to allow niche collectors to track, buy, sell, and value their collections. System built using WordPress, PHP, MySQL, CSS, JQuery. Responsible for monitoring and tweaking system performance, handling end-user questions and suggestions, data validation, troubleshooting any issues users have. Site promotion via social outlets (Facebook, Twitter, Instagram, other sites).Development of intuitive and user-friendly system helped user base grow to over 200,000 users and become a well-known resource within the community. Site received roughly 500,000 unique visitors and 10,000,000 page views per month at the time of selling the assets.

Created SQL integration packages in SQL Integration Services & SQL Management Studio to automate transfer of data to and from benefits vendors, as well as generate reports in SQL Reporting Services and ADP-R (and previously Cognos) for internal departments on a scheduled and ad hoc basis.Responsible for creating system data flow to and from systems, including table inserts/deletes/updates, creating views, functions, stored procedures, scheduled jobs.Worked with vendors to establish system connections and manage data transfers. Monitored transmission results to ensure there was never an interruption of benefits due to file/system error.Responsible for building reporting outlets to assist HR and Payroll departments in management of staff, payroll, and benefits. These included SSRS (stand-alone and later integrated into SharePoint), Cognos, and later ADP-R.Automated and refined processes and code by creating stored procedures, functions, and scheduled tasks within SQL databasesInherited duties as SharePoint administrator, becoming responsible for content management, security, and site maintenance. Involved in maintaining and troubleshooting training system integrated into SharePoint.

Designed and maintained various Property & Casualty and Finance & Insurance reporting systems using Microsoft Access to track business production, sales call activity, customer retention, metrics to goals, etc.Provided data and market support to executive-level staff, sales department, and underwriting department in a fast-paced environment. Provided customer service to both internal customers (field staff, executives, IT) and external customers.Maintenance of multiple databases and systems, providing technical support to call-in customers and employees, and providing general support to the executive, sales, and underwriting teams.Emphasis on data management, accuracy, and verification. Collaborated with all departments, acting as project manager and liaison between departments.