Created SQL queries to mine asset tracking and disposal status data from multiple large Teradata database views.Performed ‘root-cause’ analyses of strategic business issues and identified solutions to mitigate future risk of recurrence.Developed reports based on requests from internal clients for asset lifecycle and disposal status or dashboard metrics.Eliminated errors and improved performance through reuse of macro-enabled Excel reports.

Used OBIEE to produce new, and modify existing, reports and analyses to support Annuities Servicing requests.Created complex queries in SQL Developer to meet time-critical ad hoc requests.Automated manual tasks using Excel and VBA.

Implemented management objectives and regulatory reporting requirements using VS 2013/SQL Server 2016.Reviewed change requests from regulatory reporting team; conducted impact analyses.Modified and created stored procedures as needed to fulfill change and support requests.Identified and initiated process improvements when reviewing functional design of code.Developed SSRS dashboards for server metrics and KPI analysis.Migrated eligible database objects to utilize In-Memory OLTP optimization.

Performed gap analysis, data mapping and report validation for EIW data warehouse; converted assigned report logic from SAS and TeraData into SQL for use by the Automation team; optimized long-running report query, reducing response delay from minutes to seconds.

Analyzed and converted reports from Oracle BI into SSRS; supported Oracle Discoverer users; developed user certification verification and tracking system using Excel and Exchange automation.

Performed analysis of SAS and Excel reports; documented and converted SAS scripts into SQL Server stored procedures as data sources for the Automation team to create generic SSRS reports for production deployment.Developed and supported Production and Ad Hoc reporting as well as analytics for executive, compliance and internal clients within Home Mortgage. Identified bottlenecks and corrected code issues in queries, stored procedures and SQL Agent jobs, improving performance of assigned projects by an average of 67%.Met and exceeded expectations: As the generic format would not meet a client's requirements for a mission-critical custom Excel dashboard having multi-parameter drill-throughs to six separate detail reports, I delighted the client by exactly recreating its look-and-feel in SSRS while improving 'at-a-glance' visibility by dynamically displaying all matrix totals (vs pivot table filters), developed as an end-to-end solution deployed to a UAT Sharepoint portal on an accelerated timeline, thus reducing the Automation team backlog by providing them with an implementation-ready, scripted package.

Planned and performed technical tasks, such as setting up SQL server 2012 databases, associated with the implementation of McKessson solution sets, working remotely with clients and internal resources at the client site. Managed the technical tasks (e.g., database configuration and administration) associated with the implementation of the business solutions in complex environments, ensuring the timely and successful completion of the project deliverables. Consulted with clients in planning and executing technical tasks such as conversions using BCP and SSMS, interfaces, integration, issue resolution, assessment of system environment readiness, software installation and configuration. Partnered with the Development team identifying application defects utilizing TFS source code, IntelliTrace in Visual Studio 2013 (for web apps), and SQL diagnostic tools such as Profiler and Execution Plans, then supplied optimized solutions using advanced SQL techniques.Accomplishments: In order to ensure user acceptance until the critical errors in the initial release of Direct Messaging web services could be addressed in later builds, I succeeded in reverse-engineering the app, deducing the intended logic and developing a set of stored procedures to provide the missing functionality, all in less than 2 weeks. By analyzing the users workflow, I corrected the practicably unusable stored procedure that fills the Recipient list by filtering it to offer only organizations having a valid direct address. As a result, over 120 facilities were able to move forward and meet their Meaningful Use Stage 2 (MU2) attestation goals.Provided recommendations on process improvements related to conversion and setup procedures and lead the efforts to create and implement solutions. For example, I took the initiative to contact the ZetaFax vendor and our Sales team to ensure users knew what required licenses to order and budget for during contract negotiations.

Developed complex multipage report based on an existing 1.4 MB Excel worksheet app, taking over after the initial project was several months behind schedule. Created new database objects (tables, views and stored procedures) and modified existing ones to support displaying key performance indicators and metrics for each of four data source systems, using a single set of tabular and graphical visualization report regions to present data at four different hierarchy levels. Designed and implemented tables, views and functions to enable Regional Sales Managers to perform proximal analysis of the current banking center assignments for each of his or her sales reps. Accomplishments: Optimized slow-running stored procedures by utilizing indexed table variables, CTEs, and taking advantage of recent SQL Server enhancements, resulting in as much as a 60% improved performance. Provided expertise, guidance and sources for both database and reporting best practices; presented the available options for report security, offered advice for the preferred access control methodology and collaborated in its implementation.

Created SQL Agent jobs and performed regular backups; installed patches, replicated data across servers, planned and implemented data migration across environments. Planned, scheduled and coordinated SQL Server 2005 / SQL Server 2008 analysis and design of supported applications. Reviewed and modified existing stored procedures, SSIS packages and other Transact SQL related queries. Developed new SQL components to solve customer needs with data; designed schemas, built tables, FKs, PKs, etc. Built data structures that met business needs in general, the design of which was used by developers and DBAs to implement the actual application.

Produced report specs and requirements from client descriptions as well as existing legacy reports. Developed over a dozen Area Manager reports for tracking field rep performance and metrics, ranging from simple tabular detail reports specifically tailored for Excel, to complex summary reports offering numerous detail drill through reports. Improved user experience and proficiency by providing logical defaults and intuitive cascading parameters, displaying only options that are actually available, eliminating selections which would return no results. Enhanced readability and comprehension by utilizing data visualization techniques, such as contrasting backgrounds and subtle data sectioning. Created SSIS flat-file export packages as source for an automated dialer system. Accomplishments: Designed and implemented first role-based security system for SharePoint portal, restricting access for each Area Manager to his or her own field reps, while allowing Division Supervisors to view everyone. Advised adoption of task assignment system for change control, logging of batch jobs for error handling and documented reporting best practices and guidelines.

Produced initial report specifications from Excel prototypes; analyzed data warehouse to identify data missing from fact and dimension tables; created sharable stored procedures, views, functions and table types; developed multiple table- and matrix-based reports for access through ‘Teacher’ and ‘Principal’ Sharepoint portals; deployed and administered reports on ReportServer. Accomplishments: Corrected guidelines and generated implementation documentation; applied principles of data visualization by Edward Tufte and Stephen Few during report design, increasing legibility and comprehension by eliminating “noise”; utilized linked reports to support concurrent development and reduce maintenance; proposed graphical improvements for future enhancements.

6-month (+?) contract building regulatory and decision-support reports, using Microsoft SQL Server and Visual Studio BIDS. Reverse-engineered Business Object reports into web-based interactive solutions.

Converted legacy reports and designed new Business Intelligence reports using SQL Server Reporting Services distributed on an enterprise-wide web portal supporting role-based access to over 60 separate clients; created templates and models, establishing team standards using corporate-compliant fonts, branding and colors; supported and enhanced legacy apps during .NET migration.Accomplishments: Created and deployed first production reports in SSRS converted from Actuate using drill through, drilldown and data-context conditional formatting; primary lead for the conversion of the Logos Reports application from PowerBuilder8 to SSRS, enhancing legibility and preventing paper waste; participated in the Brokerage Management System conversion project from CFMX to ASP.NET/C#, improving stability and scalability; eliminated section20 database contention by creating a standalone database for BMS.

Developed application interfaces and control classes in VB.NET and C# for use with a .NET rewrite of a legacy lockbox application. Enhanced the existing Visual FoxPro product by optimizing queries and eliminating redundancies. Initiated company-wide GUI standards, providing accessibility features while maintaining a consistent "look and feel".Accomplishments: Rewrote check imaging component, improving performance by a magnitude of order; implemented source control to maintain versioning and enable enforcement of code security policies.

Developed and maintained decision-support applications, automating financial data flow and outputting reports for the board of directors using Actuate; analyzed client requests and specifications for application enhancement and development; provided production support for several mission-critical applications; participated in ongoing .NET and team cross training.Accomplishments: Identified and provided work-arounds for errors present in early Actuate releases and modified base code using RogueWave to provide redirection of debug output. Created proof-of-concept C# application using .NET Interop toolkit. Rewrote charge-off and recovery (Co/Re) application, reducing production cycle by 4 days; web-enabled high-usage DOS application, eliminating expense of seat licenses and dependency on remote access software; authored intranet website using InterDev and ASP, allowing clients to access information directly, reducing inquiries by approximately 75%.

Developed in-house tracking and library applications; provided specialized 365/24/7 contractual support for multiple clients with mission-critical applications; led weekly team training and technical update sessions; authored numerous technical articles for Microsoft on-line knowledge base.Accomplishments: Mentored over 60 support technicians; first engineer to author article in an external trade publication; reduced training budget expenditure by developing in-house multimedia training application; maintained a 98% correct call coding average.

Provided technical support for developers using FoxPro for DOS/Windows/Mac; led support team training and provided ad-hoc mentoring within the team; developed software examples and provided documentation for inclusion with new releases.Accomplishments: Streamlined callback methods, improving turnaround time by 30%; ran the computer lab at the first annual Fox DevCon in Toledo; proofread the entire first edition of the Visual FoxPro 1.0 set of manuals, resulting in a corrected second edition that had 3% fewer pages with a decline of over 68% error-related calls.