Led the end-to-end migration of RGP’s SQL Server Reporting Services (SSRS) from legacy systems to the latest SQL Server 2019 platform, ensuring a smooth transition while maintaining high levels of data integrity and minimizing downtime in a fast-paced, dynamic development environment.Proactively troubleshot, debugged, and optimized over 50 existing SSRS reports, improving performance, enhancing user experience, and aligning output with evolving business requirements and organizational objectives.Partnered closely with the Lead Data Analyst to manage and resolve complex report-related tickets, ensuring prompt resolution of issues and contributing to a significant reduction in ticket backlog and report generation time.Utilized advanced SQL and SSRS best practices to update and enhance data warehouse dimensions, integrating additional data mappings into the SQL Server Analysis Services (SSAS) environment, improving data accessibility and reporting accuracy.Conducted rigorous regression testing of OLAP cube reports, identifying and rectifying issues to ensure consistent and reliable data reporting across various business units.Led quality assurance efforts for external data integration, meticulously comparing and validating data extracted from Workday with internal reports, ensuring alignment and accuracy to support key business processes and decision-making.

Led the development and enhancement of SSRS reports catering to diverse business functions including accounts management, claims, underwriting, operations, sales, and executive management. These reports serve as pivotal decision-making tools, ensuring streamlined operations and informed strategic planning.Responded promptly to dynamic business needs by crafting on-the-fly T-SQL queries, facilitating ad hoc reporting requests from various departments. Collaborated closely with actuaries and underwriters to meticulously identify and rectify data inconsistencies within the data warehouse. Leveraging SQL scripting, provided ongoing maintenance and optimization of both warehouse and transactional systems, ensuring data integrity and reliability.Engineered comprehensive SLA dashboards using Power BI, enabling the SVP & COO of Accident & Health Insurance to monitor delivery metrics across critical business domains including Marketing, Travel & Accident Business Development, Underwriting, Claims, and Accounts Management. Played a pivotal role in expanding the existing data warehouse by collaborating with the software development team to establish new data stores tailored for underwriter data, facilitating the development of a cutting-edge underwriting reporting suite. Additionally, coordinated with software development to update essential system-generated documents, including billing statements, quarterly sales newsletters, and confirmation of benefits, ensuring alignment with evolving business needs.Spearheaded the oversight and troubleshooting of insurance data file SSIS packages responsible for seamlessly importing partner policy and claim data into Arch's Vertical Operations software. Provided crucial support to overseas data teams by creating over 100 integrity checks to validate the schema of newly developed data stores, ensuring data accuracy and consistency across global operations.

Developed and delivered customized ad hoc reports tailored to client and internal needs, including state-certified high school transcripts, honor roll listings, and student lesson completion summaries for a diverse range of partner schools. Internally, supported Pearson invoicing processes and provided insightful statistics crucial for public relations initiatives.Collaborated closely with educators and school administrators to establish and maintain comprehensive student attendance reporting systems for over 15 partner schools, ensuring compliance with stringent state and district attendance standards. Engineered a suite of reports specifically designed for the curriculum department, enabling the identification and rectification of data inconsistencies within the Connexus system. Partnered with fellow members of the SQL reporting team to identify common data metrics and develop a robust data warehouse solution. This collaborative initiative aimed to streamline reporting processes and empower end-users with the ability to perform ad hoc reporting, paving the way for enhanced efficiency and data-driven decision-making in future releases.Utilized Power BI to design and deploy attendance reporting and analytics solutions for school leadership, supporting their next-generation online education platform. Implemented a suite of data integrity checks within Power BI for the curriculum department, enabling the identification of errors and discrepancies in course and lesson content within the current online education system. Leveraged Power BI to analyze and visualize customer response times across multiple internal departments, including Enrollment, Help Desk, and Placement Services. By providing actionable insights into service productivity, these analytical reports contributed to the optimization of customer service operations and the enhancement of overall customer satisfaction.

Responsible for the creation and maintenance of over 40 system reports within PROTECT Records software that provide police departments and emergency dispatch departments the ability to analyze police offense and arrest records, dispatcher call handling performance and dispatcher call volume.Assisted the Director of Software Development and Project Management in the process of grooming new report projects to be presented to customers for future software updates.Improved search performance throughout PROTECT Records software through the use of materialized views in PostgreSQL, which dropped search loading times from nearly two seconds per search to under 0.2 milliseconds per search. Improved the on-site customer database backup process with the Software Development team by moving from generic SQL scripting to the PostgreSQL backup format, improving the restoration speed of customer data to be used for development, testing and customer software troubleshooting.Responsible for maintaining SQL database scripting for testing environments used by the Software Development team.Sole member of the Software Development staff responsible for the conversion of customer geospatial location data. The data is implemented within the PROTECT product suite to provide emergency dispatchers the ability to map emergency call locations as well as locate the nearest respondents through PROTECT’s satellite image interface.

Sole report specialist responsible for the generation of executive management reports that provide oversight on claims and financial processing for the Debt Collection Management department, responsible for $8 billion in collections for the Department of Justice. Also responsible for implementing the Remedy Statistics Report, which provides weekly Help Desk support ticket counts, breakdowns of support tickets by category issue, as well as providing monthly trends on Help Desk support tickets for upper management of the Consolidated Debt Collection System (CDCS) project.Create ad hoc reports requested by CDCS end users such as litigating components, AS-14 and SES level government executives via SQL query, as well as using Oracle Discoverer to create and share reports with these users.Investigate current system report queries and diagnose issues regarding them when quality concerns are raised by litigating components and AS-14 and SES level government executives.Assist end users with document generation, which allows CDCS users to generate collection notice documents using SQL queries and Word or WordPerfect templates. Assistance generally is in the form of creating and modifying SQL queries, creating and editing the templates, as well as answering general questions. Created collection demand letter SQL queries and WordPerfect templates for the Case Processing team, these documents are generated for the National Collection Intake Facility (NCIF) to be sent to 30,000-40,000 debtors each month.

Implemented SSRS reports for CEO, including the Account Verification Services (AVS) Performance To Budget, which allowed him to track projected monthly AVS budgeted usage statistics versus actual monthly usage. This report was prominently displayed on the Executive Dashboard. Implemented reports for VP of Sales, including the Source/Industry Report and Hot Button/Attrition Reason reports, which provided the sales staff with industry statistics on current customers to help determine future leads, as well as key reasons why customers chose to pick their services or leave them. Created DTS packages and stored procedures to provide customers with raw bank data files for use in their custom applications, streamline internal data updates, and aid in monitoring internal services. Managed the daily operations for Lyons research department, supervising a team of two research specialists. During that time, over 20 new data integrity checks were implemented. Provided customer relationship management support for sales staff.

Provided technical assistance to resolve customer issues with the company's payments software within the Microsoft Windows environment. Assisted in the implementation of the company's software to be compatible with a client's standalone workstation or network infrastructure. Diagnosed and repaired malfunctions within a client's Microsoft Access or Microsoft SQL Server database relating to the company's software. Provided internal desktop support for fellow employees, both on-site and remotely. Assisted in client supply fulfillment and inquiries.

Conducted thorough research pertaining to financial institutions through internal merger and name change reports, as well as research projects such as annual international SWIFT wire code updates and FDIC bank closure updates.Accurately and efficiently entered routing, address and contact data for over 60,000 bank records obtained from research into a customized Paradox database.Provided first level customer support for bank routing data web service products.Assisted in monthly bank routing number software update fulfillments.Documented and monitored process of weekly archiving of research paperwork.