SUMMARY

• Dynamic Senior IS and BI expert with advanced technical knowledge and an excellent record of delivering both enhanced productivity and improved financial performance saving employers millions in operational and opportunity costs.
• 12 years combined experience as MSSQL DBA, Project Manager, and Team Lead up to 10 members.
• Implements powerful solutions using tested techniques focused on analysis, design and development of both Production Database Systems and Database Warehouses using traditional and Agile techniques.
• Superior team leadership and advanced understanding of project management principles necessary to ensure the successful outcome of systems development throughout the entire life cycle of the project
• Combines hands on practical application with extensive education to create and innovate in the workplace.
• Polished communication, presentation, training and customer relation skills able to relate effectively to people at all levels and convey complex technical information in an understandable manner.

AREAS OF QUALIFICATION

Programming Languages/Tools - OLAP, SSRS, DTS, SSIS, SSAS, Java, C / C , C .Net, VB.Net, ColdFusion, ASP.Net, VBScript, PL/SQL, TSQL, JavaScript, XML, Visio, MS Project, NDMP, HTML, Visual Studio, Flash, Dreamweaver, Active Directory, SharePoint

Databases / Reporting Services - SQL Server 2008, SQL Server 2005, SQL Server 2000, Access, Excel, Business Objects, ETL, Stored Procedures, SQL Profiler, Database Engine Tuning, Windows Clustering, MSSQL Replication

Expertise Project Management, Database Administration / Development / Architecture, CRM, Windows Server Management, Process Automation, Vendor Management, Systems Analysis and Design, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator Contract

• Administers SQL Server versions 2005 2012 and responsible for integration with Informix database systems. Also manages Team Foundation Server TFS installation along with SSRS and SSAS installations. Responsible for code migration promotion supporting multiple environments, importing and exporting data to and from SQL Server databases. Manages designs and troubleshoots all SQL server environments, SQL Agent jobs and services. Automated builds from Visual Studio 2005 and 2010.
• Responsible for new SQL development including creating tables, views, synonyms, complex stored procedures, scalar and table user defined functions in T-SQL, complex SQL queries, assisting with dotNET and MVC web development, Informix development. Additionally responsible for ETL development using SSIS and administering of the environment. Provides strong data analysis skills and database administration skills.

Confidential Senior Database Administrator

• Administered multi-terabyte, 24/7 MS SQL Server platform with in excess of 75 servers and hundreds of databases for nationwide telephony system used by the leading inmate facilities management company in the United States. This includes numerous databases, both transactional and warehouse, with data amounts from 1 to 2 TB. Provided team leadership and expert level knowledge in the administration, configuration and customization of the Securus production SQL Server environment. Optimized hardware and software configuration and design, calculated growth and capacity, established best practices, helped manage storage and lead database systems optimization.
• Developed powerful data management solutions using legacy DTS, SSIS, SSRS, SSAS and versions of SQL Server from 2000 to 2012. Created content for use in SharePoint and acted as an administrative resource for SharePoint 2010 portal. Utilized these tools to provide useful analytics for senior management, finance, accounting and various end users regarding the status and trends of the data found within Securus database systems providing invaluable BI resources used to evaluate and manage business practices.
• Managed and utilized numerous monitoring tools including Orion, perfmon, and Idera Diagnostic Manager to identify database performance issues and quickly resolve them. Also developed a suite of home grown tools and reports to proactively monitor Securus environments providing heads up alerts allowing DBA's to react to issues before they became problems. As senior DBA conducted training, knowledge transfer and mentoring to others as needed to ensure proper implementation and SQL code optimization.

Confidential Senior Database Application Developer Contract

• Managed the redesign of Lotus Notes / DB2 MVC based Enterprise national billing adjustment system create a new SQL Server 2008 / DB2 MVC based transactional system including data warehousing and reporting systems using SSIS, SSRS and traditional SQL based objects cable of moving 1000's of financial transactions daily.
• Saved Verizon an estimated 1 Million in vendor fees and customer over payments by successfully leading the migration of the Adjustment Data Warehouse ADW from an external vendor and managing both lights on support and all new or ongoing development for the application.
• Oversaw data processing and quality control, systems compliance, required updates for routine business changes and led major system updates as required, change control via existing systems support process and systems exceptions and issue resolution via existing systems support business process.
• Managed the redesign and development of the ADW system in the conversion from a ColdFusion based system with disparate backend systems to a .NET application using MSSQL Server.

Confidential Team Lead / Senior Database Administrator

• Drove T-SQL development, data warehouse design development, ETL, database operations, maintenance and database/data management tasks. Directed the installation, configuration, troubleshooting and maintenance of SQL Servers along with replication, backup, partitions, storage, and access.
• Planed, directed and coordinated activities including project management, testing, and implementation of system upgrades, enhancements, and bug fixes. Reviewed changes to ensure that no operational or functional areas are impacted. Forecasted and planed for supporting applications in a changing and complex environment.
• Lead the administration, development and security of Picture People's standalone and clustered SQL Server 2000 - 2008 production databases. Managed the installation, configuration, troubleshooting and maintenance of SQL Servers.
• Responsible for bringing new ideas and keeping the company abreast of new and innovative technologies.
• Carried out database capacity planning, design development and basic data modeling. Developed and enforced security measures including user privileges within the database environment. Monitored and optimized system performance using index tuning, disk optimization and performance tuning.
• Created T-SQL stored procedures and improve the performance of existing stored procedures. Wrote and improved SSIS packages. Worked with the following: on-line transaction processing OLTP data, on-line analytical processing OLAP cubes, SQL Server Analysis Services SSAS cubes, data warehouse, SQL Server Reporting Services SSRS reports, Common Table Expressions CTE , Merge commands, SharePoint dashboards, monitoring scripts, data modeling, and entity-relationship diagrams ERDs .

Confidential Senior Database Designer

• Maintained computer operating software, hardware, and network configuration within The Employees' Retirement Fund ERF . Analyzes network problems, and resolved technical difficulties. Provided support and assumes responsibility for day-to-day troubleshooting of The Employees' Retirement Fund LAN.
• Wrote ad-hoc information retrieval programs using Cognos, Crystal Reports, and/or SQL for use by management or other departmental staff.
• Investigated new technologies and makes recommendations on applicability to ERF systems assists in planning and implementing major upgrades or conversions to new.
• Evaluated and plans software and hardware purchases to maintain and improve internal IT systems. Prepared cost analyses of maintenance and enhancement of existing programs and hardware.
• Developed and updated documentation of programs and systems Performed critical application needs assessment, information gathering and recommend appropriate changes to business systems and database systems. Managed Cognos and Crystal Enterprise servers.

Confidential Project Consultant contract

• Led software project to analyze Century's core business application and provide solution for improving the capacity, speed and overall design in an effort to increase the revenue potential of Century's core product. Worked directly with and reported to Senior Management.
• Potentially saved Century millions in lost revenue with the establishment of backups and optimization routines and made recommendations on any areas where sever administration is lacking
• Performed critical application needs assessment, information gathering and recommend appropriate changes to business systems and database systems.
• Evaluated, redeveloped, and redesigned Century's Cold Fusion application code and TSQL code in SQL Server 2005/2008. Developed, tested and optimized ETL procedures. Evaluated table and database structure of Century's core application and optimized the performance of queries, indexes and stored procedures.
• Database Administrator / Cold Fusion Developer full-time
• Administers production database systems. Maintains all database maintenance including database optimization, backups, indexing, test systems, installations and server maintenance.
• Design and SQL and Cold Fusion code to replace, optimize or redesign existing application code.
• Manage Projects and redevelopment of core system design.

Confidential Database Systems Administrator Contract

• Administered, and maintained the production database environment. Researched and facilitated the procurement all necessary software and hardware for the department.
• Implemented MS SQL Clusters, Replication and Log Shipping. Directed version upgrades, maintained systems efficiency and troubleshoot using monitoring tools such as SQL Profiler, Spotlight, LiteSpeed or HP Sitescope, maintained database servers and ensured their availability for government and civilian use.
• Guided the maintenance or implementation of enterprise applications including Maximo 6.2 MXES EAM software, Lawson HR management software and MS SharePoint.
• Led Analyst for multiple projects and sub projects and provided direction and guidance on system upgrades, maintenance, updates, and upgrades of database servers.
• Ensured that performance tuning, query planning, bookmarks, index tuning and monitoring for deadlocking, paging issues, creation of backups and restorations took place.

Confidential Production Database Administrator Contract

• Managed complex project to create and implement two 8 node Windows/SQL Server clusters. Consolidated farm of 27 windows servers with SQL Server and migrate them to the clusters.
• Project planner and coordinator. Managed organizational resources including hardware, networks and development resources. Provided guidance in the areas of application and database requirements.
• Implemented and enforced database and windows security based upon best practices, SOX regulations, and company policies. Responsible for all aspects of security in the production environment.

Confidential Lead Database Developer Contract

• Lead DBA responsible for Maximo upgrade projects. This included migrating SQL Server 2000 databases for Maximo version upgrades, ETL all data as required, and creation of all DTS packages and job as needed. Instrumental in the successful upgrading of Maximo 5.1 software to version 6.2.