Accomplished professional with 14 years of experience designing, implementing and troubleshooting large scale database solutions in the retail industry. Previous clients include Target, Home Depot, and Wal-Mart. Proven ability to effectively manage project teams, including defining goals, building extensible data-driven solutions, and guiding developers and business owners throughout the entire lifecycle. Core competencies include:

• Effective communicator when discussing technical and business related issues
• Strong technical writing skills
• Productive and supportive team player
• Accomplished project manager
• Experience in logical and physical data modeling
• Experience in designing, deploying, and maintaining large database solutions
• Expertise in troubleshooting and optimizing SQL Server for large enterprise solutions.
• Excellent problem-solving skills

• Redesigned, developed and implemented complex systems for identifying payment errors. System included ETL process, data warehouse 20TB , reporting, and frontend application. Data warehouse used for running reports, sorting and filtering data, storing and manipulating result sets. System was modular and scalable. T-SQL code had low coupling and high cohesion. Implemented at Connolly Consulting using Windows Server 2003 with SQL Server 2000 x86, AI-64 2005 x86, x64 with Access 2002 frontend.
• Optimized ETL process. Received extracted data structure: EDI X12, DBMS backup, flat file encoding: EBCDIC, Unicode, ASCII via ftp and tape hardware: 3480, 3590, LTO, DTL software: NovaXchange, IMdrive . Multiple datasets SAP on Oracle DB2, Informix, IMS were transformed and loaded into SQL Server using DTS, SSIS, Data Junction, and Pervasive Data Integrator. Rewrote T-SQL code used to identify and delete duplicate data. The result was decreased disk IO and CPU consumption, smaller log growth, and reduced data fragmentation. Benchmarks for 1M rows were 20 faster 100M rows were 1500 faster.
• Redesigned, developed and implemented system for building datasets that drove reporting. T-SQL code contained complex business requirements used to reconcile cost, charges and allowances at invoice and item level. Modular design made system agile and extremely fault tolerant enabling system to be stopped and restarted at any point. System trapped and retained row-level information about the logic used to generate each dataset. Enabled end users to understand, correct and improve the implementation of the business requirements. Increased accuracy of the data and its rapid deployment resulted in increased productivity and profitability of the auditors.
• Redesigned, developed and implemented system used to generate reports. First rewrite was implemented on SQL Server 2000 and reduced runtime and log file growth. Second rewrite used new functionality in SQL Server 2005 and reduced pressure on tempdb. Benchmarks for 1M row were 50 faster 2B row was 9600 faster e.g. 14 days to 3.5 hours . Increased performance enabled additional reports to be deployed which increased productivity and profitability of the auditors. Enhancements made to this process were propagated across all retail clients.
• Designed, developed and implemented T-SQL algorithms for identifying duplicate payments. The new algorithms reduced the number of false positives without increasing the number of false negatives. Existing reports were also optimized reducing runtime and footprint on the server. Enhancements made to this process were propagated across all retail clients.

• Highest point of escalation for SQL Server at Connolly Consulting. Responsible for troubleshooting, performance tuning, and optimizing SQL Server used in development and production.
• Developed best practices for database design, development, and implementation including writing agile and scalable T-SQL code. Trained and supported data analysts, developers, and IT support staff. Supported over 30 instances of SQL Server and was primary contact with Microsoft for all escalation issues related to SQL Server.
• Designed, developed, and implemented a T-SQL code tuning contest for Connolly Consulting that consisted of stored procedures and views. The code represented examples of poor-performing code that had been identified and tuned during the four years of troubleshooting T-SQL code for the company. Participated in the post mortem evaluation of the optimized code that resulted in a deeper understanding of how to write better code and how to identify and optimize poor-performing code.

• Supervised the migration from SQL Server 2000 to 2005 for Connolly Consulting. Designed and implemented test environment used for benchmarking and for identifying issues related to upgrading existing systems and processes. Included in the migration was the implementation of partitioned tables. Developed T-SQL code used to create and maintain partitioned tables. Transferred knowledge through written documentation and trained data analysts, developers, IT support staff, and management.

• Designed and implemented a system for searching client email for Bottom Line. System included an ETL process through which email and its attachments were loaded into SQL Server, full-text indexing, and UI to search email and attachments. System implemented on Windows Server 2003 with SQL Server 2000 VB.NET 2.0 frontend .

• Supervised staff of 30 as Audit Manager of the Target Audit Center for Howard Shultz Associates. Administered budget of 6 million. Key activities included managing client relationship at multiple levels of management created monthly reports submitted to client and company regarding current profitability and trends supervised applications development Visual FoxPro 6.0 .

Confidential

Senior Associate

Business Technology Manager

Senior Data Analyst

Connolly Consulting is a financial services company that conducts audits for the recovery of lost revenue due to overpayments and missed allowances. As Senior Data Analyst, I designed, implemented, and maintained a data warehouse. I also supported other analysts through training, troubleshooting, and query tuning. As Business Technology Manager, I provided SQL Server support across all groups, including data and business analysts, developers, and SQL Server administrators. I also led the migration from SQL Server 2000 to 2005, and conducted training on SQL Server 2005. As Senior Associate, I audited Wal-Mart transactions looking for overpayments and missed allowances. I also created requirements and specifications for audit related applications, and supported SQL Server 2005 through mentoring business and data analysts.

Confidential Director of Operations, Wal-Mart Audit

Bottom Line acquired by Apex Analytics is a financial services company that licenses auditing software and conducts audits. I managed data support team that was responsible for the acquisition, conversion, validation and optimization of data. This included hardware management, data mining, data normalization, and creating software tools. I designed, built and optimized data warehouses containing tables over 1 billion rows. I created reports for auditors and senior management that identified potential recoveries. I designed email search application to import email into SQL Server and used full-text indexing.

Confidential

Director of Software Development

I managed applications development for the design, development, and implementation of software used for auditing accounts payable transactions. My duties included gathering requirements, writing specifications, and conducting proof of concept tests. I designed a reporting system for identifying potential duplicate payments. Other duties included drafting Requests for Proposal, building partnerships with client's IT department, and managing the acquisition and ETL of client data.