Don Leone

*** ******** **, ************, ** *****

Cell: 618-***-****

acrtxj@r.postjobfree.com

mailto:acrtxj@r.postjobfree.com

Quality Statement

Seasoned SQL Server DBA/Developer with 15+ years’ experience within Fortune 100 companies in the following industries: financial, software, telecommunications, healthcare and media. Don offers extensive experience from highly technical, fast–paced IT groups and is driven by innovation, the opportunity to provide solutions and the desire to improve performance.

Education and Training

Microsoft Certificate of Achievement Designing Database Solutions with Microsoft SQL Server 2012

Microsoft Certified Technology Specialist .NET Framework 4, Data Access

Microsoft Certified Technology Specialist .NET Framework 4, Web Applications

Microsoft Technology Associate Database Administration Fundamentals

Microsoft SharePoint 2010 SharePoint Designer Applications

Master of Science, Computing and Information Systems – SIU-Edwardsville

Bachelor of Science, Business Administration – Marketing – SIU-Edwardsville

Intermediate & Advanced SQL Server 2005 System Administration – University of Missouri – St. Louis

Intermediate & Advanced C# Application Programming – Washington University

Technical Summary

Database Application Development

SQL-Server 2005, 2008 R2, 2012 SharePoint, JQuery, SPServices

SQL-Server Triggers, Stored Procs, Functions, Tuning ASP.NET C# MVC, File I/O, ADO.NET, WCF, LINQ

SQL-Server DTS, SSIS, SSRS ASP.NET C# AJAX Framework, Web Services

SQL-Server Transact-SQL ASP.NET C# Web Forms, Win Forms

ETL, Warehousing, Migration VB.Net & C# SSIS Scripting

PowerShell Scripting Cold Fusion MX, PHP, LAMP

Oracle SQL/PL-SQL, MySQL AJAX, CSS, XML, XSL, XHTML, HTML

Key Accomplishments

●Built an entire database and reporting system to better track virtual machines worldwide. This allowed these machines to be deployed, deallocated as well as more easily determine need for OS updates. Doing so saved the company well over $50,000 per year.

●Administer databases for both development and production environments. Migrate databases for deployment from 2008 development servers to 2012 production servers.

●Responsible for data collection and reporting for all statistics related to virtual devices deployed to end users within the company. Data and reports are used by senior leadership teams in day to day decisions.

●Create dynamic, SharePoint Applications with data transfer to SQL Server for normalizing and reporting. The focus of these applications is automation, efficiency and reporting. Utilized to forecast staffing needs driving cost savings.

●Deliver real-time Dashboards and Applications to decision makers for staffing adjustments across division in financial industry.

●Create ETL processes to warehouse data deployed in Business Intelligence Applications

●Create databases utilized for HR dashboards to forecast staffing based on projects.

●Developed and enhanced HR employee self-service web portal with a user base of 26,000+ employees.

●Developed, enhanced and maintain mission-critical financial application handling monetary transactions from and to third parties.

●Enhanced and deployed medical registration application allowing patients to pre-register for a variety of services.

●Created module to automate the creation and maintenance of employee access requests for new hires, transfers and terminations for 26,000+ employees reducing manual tasks and errors dramatically.

●Developed web-based automated ticketing application. This saves more than $10 million annually by reduced support staff. This application drove the transition from a phone-based help desk to a self-service web-based system for 300,000 users.

●Developed a web-based automation application and portal from zero client-base to more than 5,000 users at an exponential annual growth rate. Growth was driven by marketing to clients’ needs and adding enhanced versions of their applications to our suite.

●Deployed major enhancements to benefits application for annual enrollment of 26,000+ employees.

●Migrated databases from various versions of SQL Server from 2000 to 2014. Also worked to migrate from SQL Server to Oracle.

●Instrumental in identifying processes that are suited for automation and/or improvement and execute change.

Employment History

9/2014- Present

Microsoft, St. Louis, MO

Preferred Field Engineer – SQL Server DBA

●Provide advanced on-site and remote technical troubleshooting support and problem resolution for Microsoft Premier Customers.

●Resolve complex issues escalated to the highest levels of management while ensuring satisfaction with Microsoft software by setting customer expectations, devising and implementing action plans and professionally communicating to all parties involved.

●Act as a trusted advisor to customer while providing proactive services such as Training and Workshops, Heath Checks, and other custom proactive deliveries.

●Develop and utilize database health and monitoring tools to analyze, improve and monitor data infrastructure.

●Provide expert knowledge on SQL best practices, including index structures, partitioning, DMVs, clustering, replication, database mirroring and log shipping.

●Provide 24/7 on call support for clients.

●Provide experiences with not only SQL Server, but BIDs, SSRS, SAS, SSIS, competing databases, service broker, SAN management, .NET Web/Windows application development.

11/2013 – 8/2014

Bank of America, St. Louis, MO

Asst. Vice President, SQL DBA and Developer

●Solely responsible for all database administration, data collection, normalization, query development, tuning and business logic as well as report development.

●Build SSRS reports and dashboards for executives for decision making and monitoring.

●Automate data loading and report deployment to decrease reliance on staff time.

●Develop and utilize database health and monitoring tools to analyze, improve and monitor data infrastructure.

●Provide 24/7 on call support for entire suite of applications.

●Utilize SQL Server SSRS, SSIS, PowerShell and other tools to design, develop and implement data collection.

06/2011 – 11/2013

Bank of America, St. Louis, MO

Officer, SharePoint SQL Developer/DBA and SharePoint Developer

●ETL Developer and DBA importing data from various sources, normalizing and maintaining database stars, datamarts and cubes. Utilize T-SQL, SSIS, PowerShell, JAMs and other means to import form flat files, databases, spreadsheets, and various remote sources.

●Automate processes and develop mechanisms to allow dynamic input to make applications flexible to clients.

●Create dynamic SharePoint applications utilizing JQuery, SPServices, Workflows for automated applications.

●Work with business partners to analyze, implement and monitor data infrastructure.

●Provide 24/7 on call support for entire suite of applications.

●Utilize SQL Server SSRS, SSIS, Analysis Services to design, develop and implement data sets and future enhancements.

●Builds action plans and drives execution.

●Server as DBA and developer for SQL Server 2005 & 2008 databases.

02/2008 – 06/2011

BJC Web Development and SharePoint Group, St. Louis, MO

Application Developer

●Application developer on a suite of medical, financial, corporate applications, and human resource applications.

●Provide 24/7 on call support for entire suite of applications.

●Work with leadership developing next generation ERP solution.

●Identify, provide analytics to support development and refinements to business and HR strategy.

●Develop and deliver recurring monthly reports to create executive dashboards/ scorecards.

●Created HR modules for sale of unused time off, W2 self-service and other employee self-service applications.

●Deploy major enhancements to existing employee benefit application used for annual enrollment as well as administration.

12/1999 – 01/2008

AT&T Operational Tools Team, St. Louis, MO

Senior Analyst

●Application developer on a team responsible for 50+ applications with a user base of 300,000.

●Key developer of a web-based problem reporting application and automation application/portal, similar to igoogle.com

●Automate workflow tasks and continually provide methods that result in efficient staff time.

●Work in mission critical environment providing 24x7 on-call support to above applications and servers.

●Project manager for a suite of 15 applications. I serve as the client liaison, requirements manager and point of contact for clients and users.

●Application developer producing a suite of applications to automate tasks for a base of 40 that grew to 400 users in 12 months.

●Created and rolled out SBC Launchpad, Intranet portal, that received more than 300,000 page hits from only 400 users during its first six months.

●External network access subject matter expert for peers, clients and management.

●Member of escalation prevention team and project manager for competitive external clients.

●Provide on call support 24x7 for priority one issues.

●Evaluated and set up connectivity for competitive external clients to company network.

Software/Technologies

SQL Server Data Tools, BIDS Languages: C#, VB.NET, T-SQL

Apex SQL SQL Server Management Studio 2005-2016

Red Gate Visual Studio 2005- 2013

Resharper Enterprise Architect 8

Toad for Oracle IIS 6.0 & 7.0 Administration

SVN, VisualSvn Remedy, Vantive

Team Foundation Server JAMS job scheduling tool

SharePoint Designer 2007 & 2010 PowerShell Scripting

Awards Interests

Bank of America Silver Award (5) Running, Cycling, Antique Oddities, Playing Guitar

Bank of America Gold Award

AT&T CIO Achievement Award

Contact this candidate