RELATED/NOTABLE SKILLS:

Languages: ASP, COM / COM+, Java Script, C/C++, VB Script, Power shell, SNMP, Visual Basic, XML, RPG/400, VBA, HTML, JSON, Angular JS, JQuery, Node, RMON, ADO, XAML, SSRS, Confidential - SQL, PL-SQL, Java, Siebel 99/2000 Tools, RDO, Java Servlets, COBOL, DAO, MS Scriplets, JCL, XSLT, VSAM, DTS/SSIS, SSAS Data Cubes, Windows Services, WPF, WCF, Entity Framework, LINQ / PLINQ, C#, AJAX, SOAP Web Services, REST API, Salesforce APEX and SOAP Service, VB.NET, SSIS, VB.NET, Silverlight

Software/Packages Development: Visual Studio, SQL Server Management Studio, Visual Source Safe, Team Foundation Server and Builder, JIRA, GitHub, Visio, Visual Studio Automation testing, Macromedia Ultra Dev, Crystal Reports, SSRS, SSAS, SSIS, SQL Navigator, Sybase ECMap, ERWIN, Embarcadero ER/Studio, Embarcadero DT/Studio, Embarcadero DB Artisan, Adobe Photoshop, AutoCAD, Sparx Enterprise Architect, Cognos

Servers: Windows Server 2003, 2008 and 2012, AD Domain ControllersWindows Clusters, SQL Server Clusters 2000 through 2016 and AzureWindows IISDNS, DHCP, Exchange, Windows Communication ServerTeam Foundation ServerLinux, Apache, Astrisk, Novell, Siebel, OracleES9000 Mainframe, AS/400, F5

Office: Office 365, PowerPoint, Excel, Access Visio, Project, Jira, Confluence

PROFESSIONAL EXPERIENCE:

Senior SQL Server DBA, TN

Confidential

Responsibilities:

• Compressed a 1.4 TB database to 300 MB
• Automated Reporting and self - service reporting with SQL Server Reporting Services
• Replaced windows services with SQL Broker
• Tune and refactor queries and identified long running / high impacting queries using DMV
• Set Query standards and documented database processes.
• Set up SQL clustering with high availability with TDE enabled on the backups
• Set up remote disaster recovery location and preformed failover testing of the SQL clusters
• Set up F5 for web servers for production servers
• Corrected SAN storage allotment by correctly defining the LUNs and speed allocation of drives
• Set up VMWare web servers with Octopus deployment process
• Created metric reports for SQL environments
• Created database refreshment and obfuscation of data to Stage, QA and Dev environments.
• Created Audit process using SQL broker
• Created SSIS package to automatically email data to our customers upon request
• Upgraded SQL Server environment from SQL 2005 to 2014 and testing 2016 in Dev.
• Eliminated all deadlocks in the system.
• Performance tuned the SQL Servers by hand and using a few free tools from IDERA
• Moved dynamic generated Confidential -SQL to stored procedures and minimized the number of views used

SQL DBA, Franklin, TN

Confidential

Responsibilities:

• Encrypted SQL Server databases and backups.
• Created process where only certain users from specific servers can access encrypted fields.
• Identified and secured all SQL servers in the corporation
• Provided security and access reports of all user activities in all SQL Servers.
• Set up access to DB2 from within the SQL Servers
• Managed DB2 and Access databases.
• Identified and secured Security risks in the .net web site
• Set up Disaster recovery process and performed monthly failover tests
• Worked with the infrastructure and redefining their SAN LUNs to eliminate Disk IO contention on the SQL Servers and VMware hosts.
• Upgraded their SQL Servers from SQL 2000 to SQL 2014 and then ported system to SQL Azure.
• Set SQL Server monitoring with SQL Spotlight

Senior Software Developer, Franklin, TN

Confidential

Environment: C#, VB .Net, Salesforce, Cold Fusion, SQL Server, SSRS developer and Production Operations Admin.

Responsibilities:

• Created C# windows service to push and pull data from Medkinetics to Salesforce via SOAP and REST API.
• Created APEX and JSON code to save attachments in Sales Force and Medkinetics systems for provider credentialing records.
• Extended the SalesForce data model to retain board certifications and physician education/training for their credentialing.
• Packaged salesforce portals for deployment Confidential other hospitals.
• Build customize salesforce reports to identify physicians ready for re-credentialing
• Performed the local penetration testing and handled the security enhancement requests from salesforce to pass the Salesforce Security audits.
• Created normalized Kimball data warehouse for QPI and OPPE data files and SSRS Metric Reporting data marts
• SSIS conversion from SQL server 2000 DTS and 2005 SSIS to SQL server 2012 SSIS packages
• Upgraded SQL servers from 2000, 2005 to SQL Server 2012 Cluster with Always on availability mirroring
• Set up SQL server TDE database encryption
• Converted Confidential -SQL and dynamic SQL code in Cold Fusion to stored procedures.
• Created JSON Rest web service and created SOAP middle tier web service in c# for mobile development in JavaScript, node and bootstrap to interface.
• Modified reports in SSRS from plain text to dynamic gauges
• Created File processing .Net service to parse CSV files, provide data integrity testing, cell and row error reporting and bulk loading csv files into SQL Server databases
• Set up database development environment in Amazon Web Service
• Created Virtual test servers in VMware
• Tightened Web security and performed penetration testing on production web servers
• VOIP Phone setup
• Office 365 roll out
• SFTP server Administrator
• Production Systems troubleshooting hardware, software and tuning solutions for a 24x7 production environment.
• Train support and developers on more efficient Confidential -sql and .net coding practices
• Designed credentialing validation web crawler
• Created performance metric reporting for all sql server instances which was understandable by C band executives.

BI Systems Analyst Contractor, Franklin, TN

Confidential

Responsibilities:

• Completed SSRS Quarterly Reports project 2 months ahead of schedule.
• Tuned several long running ETL SSIS packages from several hours to 15 minutes.
• Assisted team in writing more efficient queries for their existing reports
• Converting SSRS 2000 and SSRS 2005 reports to SSRS 2008 R2
• Created Benchmark lookup and analysis tool in C# Silverlight 4 to generate custom charting and data exports for client reporting.
• Task/issue work order management system in AJAX and Silverlight to track tasks and provide current feedback to our customers.
• Build Data warehouse for their data mart reporting database.
• Developed several data cubes in Analysis Services and Cognos for client reporting
• Upgraded their SQL Server from SQL Server 2005 to 2008.
• Oracle expert in BI department
• Create ETL process to bring the Walgreens Oracle data to Take Care Health's SQL Server using SQL loader and SSIS.
• Manage and train the BI new consultants.
• Create enterprise ROI reporting for all of Take Care Health lines of service.

Senior Software Developer, Franklin, TN

Confidential

Responsibilities:

• Added PKI and CAC SSO to Confidential Communicator web site that has already been field tested.
• Resolved outstanding Text to Speech issue rendering issues.
• Harden current product operating system for the JITC testing.
• Provided Gold Disk, OPAL, Retina and port scans and established a weekly scanning processes
• Trained several employees how to patch and make code changes to prevent cyber penetration attacks
• Established a more efficient deployment model for Monthly patch process for existing systems
• Created a local J.I. Confidential .C. lab and showed the staff how to do the IA penetration testing
• Set up, configured and documented the Confidential communicator for the DITSCAP/DIACAP certification process
• SME for all SQL Server and Group policy issues on JITC installations
• Configured local and administered the Active Directory and LDAP environment for JITC lab
• Provided training as to how to code in C# 3.5 to VB 6 developers.
• Create custom change audit logs for their Commercial version of Confidential and RXT
• Provided new methods for keeping their databases schema and verifying they are in sync going forward.
• Used MS sync to synchronize SQL Server Databases
• Added WSE security to .Net Web Services.

SQL Server DBA / Database Manager, Pulaski, TN

Confidential

Responsibilities:

• Created .Net web application that looked and worked almost identical to SharePoint to track internal issue backlog.
• Implemented, Administered and created code builds for Microsoft Team Foundation Server 2008
• Optimized SQL Servers to Confidential 50% less CPU with existing hardware and over 250% more transactions growth.
• Converted existing tools and apps from Visual Basic 6 and VB.Net 1.1 framework to C# in 3.5 .Net Framework
• Provided training classes to bring existing developers up to speed in new coding standards.
• Implemented Microsoft DB Pro (GDR v2.0) to automate and standardize all database schemas on all SQL Servers
• Created MSI product deployment process to minimized configuration and speed up implementation process
• Implemented Quest Spotlight to tune and monitor production SQL Servers.
• Documented Data Flow, DTS packages, Data Dictionaries and Server inventory for seamless move from company Data Center in College Station, TX to outsourced Data Center in Dallas, TX.
• Aided in converting users and servers to new Active Directory domain name
• Provided network local network and server support.
• Managed several employees remotely in College Station, TX.
• Set up and enforced best practices for SQL Server coding and established a middle tier (business layer) for our products
• Migrated Team Foundation Server 2008 to 2010
• Migrated all SQL Server 2000 Servers to SQL Server 2008 including migrating DTS packages to SSIS.
• Migrated all reports from Crystal Reports to SQL Reporting Services.
• Converted several in house VB 6 applications to VB and C# 4.0 .Net Framework with Visual Studio 2010.
• Multi-threaded an in house ETL application that took 4 hours to run and cut its run time down to 7 minutes.
• Created Insurance quote data warehouse to resell monthly statistical analysis information back to insurance companies.
• Siebel 97 and Oracle 7,8i and 9 troubleshooting.
• Created custom SSIS components to FTP and Http post reports to several insurance company's web sites and FTP sites.

SQL Server DBA / Data Architect, Nashville, TN

Confidential

Responsibilities:

• Optimized Confidential stored procedures to be able to handle 9 million contact instead of timing out Confidential 250,000 contact
• Create SQL CLR dynamic group functionality which sped up the group list query from 2 minutes to 7 seconds.
• Team Lead of the SQL DBA team which consists of 5 other SQL DBAs (2 of which are junior level)
• Establish Confidential 's JITC (military security hardening) process
• Created the full Inno Setup installation package for the JITC Confidential Communicator Product
• Created an Oracle 10g and 11 conversions of our SQL Server product databases
• Converted several of the SQL Server Stored procedures and functions into CLR to optimize the dynamic hierarchal group lookup process.
• SQL Server support and Administration
• Provided migration paths from earlier versions of SQL Server 7 and 2000 databases and upgrade them to SQL Server 2005
• Performed JITC server and SQL Server security lock down process and certification
• Provided Ethical hacking testing solutions and Security policy management
• Physical and logical Data modeling using Enterprise Architect
• Created and currently implementing Physical UML Class model for first corporate product wide Data API Component for a universal connection to the SQL Server without directly accessing the SQL Server.
• Designed new Security access layer for then Confidential Portal to now use Windows and Active Directory authentication as opposed to a single SQL login to the SQL Server.
• Created Standard Data Dictionary per product version to code against
• Cleaned up misused XML scripts within SQL Server stored procedures.
• Optimized and created new Data migration scripts for Confidential 's tech support to migrate customer data from older version to our current Confidential 4.0 version.
• Provided Tier 3, 24x7 support for SQL Server, hardware and Telecom-Network Infrastructure support.
• Implemented VMware solutions to consolidate Physical Hardware infrastructure and create a quick means for standing up isolated customer data loaded, product specific server images versions for QA, Dev, training, and Help Desk support environments to test and fix system and data issues for our customers without troubleshooting on their production servers.
• Developed and tested our Windows network Security policy for our hosting sites.
• Developed TSQL scripts to clean up the MSDB instead of rebuilding the entire server which would fill up with backup and restore history info from log shipping eventually stop restoring database logs on our backup servers.
• Developed and enforce best practices for TSQL stored procedure coding standards.
• Setup and implemented more cost and time efficient means to build new servers from Acronis server images instead of always building and loading a new server from scratch.
• Implemented C2 auditing on the database servers.
• Developed process to keep track how compliant we are with cve mitre security exploits for Windows systems and how we implement security patches on our systems.
• Mentor Tech support staff members on how to look for problems in SQL Server that our customers see but are not necessarily data issues using SQL Management Studio and SQL Profiler.
• Developed and Implemented SQL Server 2005 Maintenance plans to keep the SQL Server databases running efficiently.
• Identified best SQL Server database file layout per drive spindle to optimize the reads and writes on our large hosted environments, so customers are no longer slowed down when a large or multiple call scenarios are started on the servers they are using.
• Converted DTS packages over to SSIS packages in SQL Server 2005.
• Architect for the future version of our product (code name Crossbow)

SQL Server Developer, Nashville, TN

Confidential

Responsibilities:

• Built SQL Server disk space analysis reports in SQL Reporting Services.
• Troubleshoot existing C# applications
• Create a C# application to ping, read SQL tables and the SQL DMO to validate SQL Server access for our end users is not interrupted and email production support if it had any issues.
• Migrate their 4 SQL Servers to an Active to Active SQL Server Cluster
• Created DTS packages to pull data from their Latin America AS/400 DB2 databases
• Created DTS packages to collect overall tread depth and original tire diameter from AS/400 DB2 and AS/400 production spec flat files.
• Created DTS packages to run SQL database Admin functions for 3 new databases.
• Troubleshoot production DTS package issues with pulling data from SQL Servers outside the corporate firewall.
• Migrated 3 QA databases to the Product Performance SQL Servers.
• Created a server disk space and database space utilization report for each of our servers and then email a SQL Server Reporting Service report on a weekly schedule to corporate production.
• Moved and monitored our current production schedules from SQL Scheduler and Windows scheduler to Cybermation scheduler.
• Created Connect Direct scripts to pull files to and from our SQL Server, AS400 and Mainframe systems.
• Analyze Mainframe DB2 tables to calculate overall tire diameters for their product Performance Information Warehouse.
• Created data pulls and data analyses for determining tread depth and overall tire diameter for the data warehouse.
• Documented and eventually automated the validation of SQL jobs that have executed every day.
• Performed Sarbanes-Oxley review of all our SQL and IIS Servers used by our applications.
• Provided Visio layouts of the current system and its data flows.
• Created data extracts from DB2, Oracle, SQL Server, Access databases, Excel spreadsheets and comma delimited files for collecting Tire tread analysis information.

Systems Architect, Nashville, TN

Confidential

Responsibilities:

• Coded 80% of the stored procedures and functions for the performance management application while working closely with the developers to make sure it is presenting the data appropriately.
• Built data layer tech specs for the project and updated the development tech specs with the data layer technology information.
• Troubleshot performance issues on the QA and Development systems
• Built unit tests for all of the stored procedures
• Created rollout scripts to build and populate the QA and production environments
• Provided .Net front-end system support for deploying the application to QA system from the Dev environment
• Created SQL Server Reporting Services reports
• Provided QA with database support in generating Active Directory and SQL Users from the applications
• Create DTS data imports and exports to and from development, QA and production SQL servers
• Create data type dictionary and UML Strongly typed UML API Data Interface to get to the SQL Server
• Built SQL server schema for the tracking changes to The Employee information and list changed employee information to Tacit's loading application.
• Built a hash matching stored procedure to look for changes in Deloitte's employee information on a daily basis.
• Provided schema analysis of Deloitte's and Tacit's SQL schemas to come together and work as one schema.
• Created data technical specs for the project.
• Create DTS job to execute the java application to process employee information changes to Tacit.
• Provided data feeds from Oracle into SQL Server.

.Net Data Access Architect, Columbus, Ohio

Confidential

Responsibilities:

• Set up and configures SQL Server 2005.
• Designed Harrington's insurance claims data warehouse schema and enterprise reporting
• Designed and coded DTS data feeds for extracting claim information from VSAM files on a mainframe.
• Coded .Net Assemblies for SQL Server 2005 to extract data from Java APIs from Meta Vance.
• Created ETL processes to pull data from Sybase, Oracle 8 and 9, Mainframe and Excel files to load into the SQL Server for Claims processing
• Developed Data factories to handle the interactions for various types of databases.
• Use Actuate, Crystal Reports, Business Objects and SQL Reporting services to repair existing reports and standardize the reports using Business Objects XI.
• Set up HIPPA complaint 837 EDI transactions to and from the Facets Sybase Database.
• Utilized SSIS to move data from Oracle, Sybase and DB2 into SQL Server 2005.
• Converted SQL Server 2000 DTS packages to SSIS packages in SQL Server 2005.
• Currently coding a generic ADO.Net data factory to feed the generic claim information from SQL Server 2005 to Harrington's internal applications and corporate website.
• Built EDI data access web service as a single generic data provider which pulls claims information from all of Harrington's legacy systems coded in VB.net 2.0 using Visual Studio .Net 2005 Team Share.
• Setup and configured Team Foundation server and SharePoint server and migrated both systems to SQL Server 2005.
• Built reoccurring-scheduling functionality in the SQL Server back end and a VB.Net Web Form UI configuration for our job tracking system.
• Corrected several Oracle PL-SQL Stored procedures, packages and views.
• Recoded a Java application to Oracle application, which convert HIPPA 837 to 835 outbound transactions into VB.net and SQL Server improving run time from 2 hours to 3 minutes.

Database Applications Developer, Columbus, Ohio

Confidential

Responsibilities:

• Created VB 6 application to load BOM (Bill of Materials) from focus prime data text file ftp from a Unix Server into SQL Server 2000.
• Created a Visual C++ application to build a inventory list of new parts added daily to Lucent's Agile system (on UNIX server) to a flat file which is then a scheduled in CRONTAB to FTP it into a Windows directory for a SQL Server DTS (Data Transformation Service) package that I built to load and process it into SQL Server production database.
• Created multiple DTS packages to pull Oracle 9i data tables from Lucent's GCIM system to our production SQL Server to add Risk part information for items on BOMs.
• Created export functionality of data from the data grid in our CID (Component Information Database) application to an excel spreadsheet.
• Created data cubes for multidimensional data analysis of risk and project statistics per component and circuit pack.
• Built Oracle 9i packages to preprocess data in GCIM before it is exported to SQL server.
• Scheduled a CRONTAB task to build and ftp an employee data file from PeopleSoft using Oracle to our SQL server for a DTS package to process into the CID database.
• Converted all backend VB 6 data loading to VB .Net and C# using Visual Studio .net 2002 to optimize the data pulling by multi-threading the Agile API connection from Agile Soft while also increasing the security and efficiency of the data connections through the .Net framework 1.0.
• Streamline their data transactions on the SQL Server by tuning and optimizing their store procedures, data model, space allocation, foreign key relations, triggers and metadata that has cut their nightly load times in half.
• Deployed Microsoft SQL Server™ 2000 Analysis Services to take advantage of OLAP to speed up their daily, weekly, monthly and yearly roll-up calculations.
• Implemented Project Server 2003 as an alternative and a test case for replacement of their current project management tool set.
• Added parent the child relation of components on a BOM for identifying the true part that risk is causing assessment.
• Demo SharePoint as part of the Project 2003 Server implementation as a one stop, user-friendly solution to track projects plans, communication paths, collaboration and documentation for their projects.
• Converted the CID application from using RDO Data connections to SQL Server to and ADO OLE DB connections to significantly speed up the data transactions to and from the database.
• Performed Sarbanes-Oxley review of the SQL and IIS Servers that are used by the CID application.

SQL Server DBA, Columbus, OH

Confidential

Responsibilities:

• Decreased the DBA Pager pages by 50% by documenting, consolidating and refining the stored procedures and data model schema.
• Integrated their CRM product with WebControl databases to allow customers to be seamlessly entered, tracked and contacted from one system.
• Developed and administered SQL training classes for the cold fusion developers to minimize query rewrites by the DBAs.
• Designed the data warehouse for the dealership sales information reporting using Embarcadero ER/Studtio, DT/Studio (ETL tool) and DB Artisan.
• Established SQL code reviews on all changes and new SQL code prior to being implemented on production SQL servers by the DBAs.
• Consolidated 5 independent production SQL servers into one SQL Server with an EMC SAN Solution to cut the code maintenance, server management, IO bus thru put and server rental costs.
• Created ERWIN data models for the Webcontrol and CRM products and updated them new enhancements as they were deployed.
• Designed and implement scheduled DTS packages to replace the overused transactional replications that were used try to keep the 1.5 terabytes of data in sync across all of the production SQL servers.
• Used DTS to pull text files of daily dealership inventory into the production SQL Servers.
• Built several DTS packages to synchronize data between our production servers in Columbus, OH and our disaster recovery servers in Irvine, CA.

Systems Analyst, Grenada, MS

Confidential

Responsibilities:

• Designed a SQL server database and its data warehouse to provide one central location for their sale cost information and sales orders to minimize the amount paper generated by faxing orders and estimates back and forth. It also provided the only location to look up sales cost information instead of having to look Confidential everyone personal access database to find the cost information.
• Created a Vb.Net web application that built an xml stream pushed to ASP.net through the .net framework security to make updates from their new internal SQL Server to their sales information access database on their outside sales computers via the internet.
• Modified their VB 6 outside sales application to send XML to the corporate .Net web services application sales orders to be put in SQL Server via the internet or stored in their local access database until they connected to provide online and offline cost information as the outsourced sales reps built new air conditioning coils.
• Coded a VB .Net application to measure temperature readings from an IEEE488 controller to DDE connection on a legacy application.
• Enhance a project task management web site to support uploading of documents and email functionality via ASP.
• Provide security analysis of potential Internet intruders and troubleshoot remote production IIS, COM+ and SQL Servers.
• Built an EDI interface to post new orders from the sales application and the SQL Server database to SAP R3 using the SAP EDI tools so the plant production could schedule new orders in SAP.

Microsoft Systems Developer

Confidential

Responsibilities:

• Built the data model for Confidential & Confidential Solutions Assets Management System (AMS) database in SQL Server.
• Designed, built and managed all SQL Server database tables and stored procedures supporting the site management and AMS.
• Built the Sybase database data warehouse to store ICMP Pings and SNMP data collected from all the SNMP enabled network devices.
• Imported data from Confidential & Confidential 's Vantive, which was an Oracle database into AMS across the VPN tunnels.
• Developed a VB COM application to clean up duplicates and pull new information multiple data sources Oracle, Sybase, SQL Server, Paradox, PVCS Tracker, MS Access and MS Excel spreadsheets into AMS and compared it to Confidential & Confidential 's internal system Vantive.
• Coded the ASP web front-end and reporting system for AMS and end to validate the Confidential & Confidential Inventory Bill to Bank One for the Bank One employees using Visual Interdev.
• Built an EDI map using Sybase ECMAP to process direct electronic billing per asset found in the Trinity Trend Sybase database directly to Bank One.
• Modified the ECMAP EDI transactions to electronically pay and send purchase orders for Confidential & Confidential external vendors to service Bank One infrastructure equipment.
• Verified and discovered new active network devices on the Bank One network through daily IP ping and SNMP polling to keep the AMS data accurate.
• Identified and reported any unauthorized network devices added to the network environment.
• Documented the past, present and future data flow of inventory as AMS was implemented.
• Coded and defined the asset moving process in AMS when they were moved between locations.
• Served as non-biases mediator in Vendor Management for Confidential & Confidential and its maintenance vendors in their re-negotiation of contract renewals.
• Built an inventory surveying process that was used to verify equipment quarterly Confidential each Bank One location.
• Standardize the web page format with CSS across all of the intranet web applications.
• De-compile and recompile java applets and servlets for a Unix Apache web server to make source code modifications.
• Convert a Java / Java Script site management application to a VB Script/ASP/COM+/Clustered SQL Server Intranet Application.
• I implemented and tested Confidential & Confidential 's first Microsoft SharePoint server for Project and Document management.
• Built customized XML and Microsoft scriptlets for the share point document management and web reporting services.
• I converted 2 out of the 3 main web applications to ASP.net for improved performance and control of the web applications while converting them over to a NATed secured socket site with certificate authentication.
• Managed and troubleshoot problems on the production and development IIS and SQL servers.
• Trained and mentored coworkers on how to program and manage VB, ASP, and SQL Server applications
• Built customized network and SLA reports for Confidential & Confidential and Bank one using Crystal Reports 8