RANDY KIRKSEY Email: adiimd@r.postjobfree.com

PO Box 957742 Duluth Georgia, 30095 Phone: 678-***-****

OBJECTIVE: To pursue a challenging career in Information Technology, developing systems that improve business processes and increase return on investment.

CAREER SUMMARY: An intelligent IT Professional with years of professional experience in Application Development, Quality Assurance, and Database Administration. Past experiences allow me to work on different platforms using a variety of software development tools. The qualities of Analysis, Dependability, and Thoroughness have enabled me to advance and excel through Database Administration, Agile processes, Quality Assurance and Application Development.

WORK EXPERIENCE

Senior Developer Hood Container

May 2020 – Present Atlanta GA 30329

Wrote Power BI Dashboards,SSIS packages, Stored procedures, User-Defined Functions to manipulate Amtech data in SQL server

Wrote Food Buy Reports and Data Exports using SQL Server, SSRS, Stored Procedures, and T-SQL

Generated periodic reports based on the cost analysis using SQL Server Reporting Services (SSRS) and Excel.

Troubleshooting performance issues and fine-tuning on SSIS packages, queries and stored procedures.

Wrote SSIS packages and created maintenance plans to automate repetitive tasks.

BI Database Developer Professional Insight

November 2016 – March 2020 Atlanta GA 30329

Wrote Power BI Dashboards,SSIS packages, Stored procedures, User-Defined Functions to manipulate eCommerce data in SQL server

Rewrote\Wrote Supply Chain\ Food Buy Reports and Data Exports using SQL Server, SSRS, Stored Procedures, and T-SQL

Created Data Visualization Dashboards to display Cost and Volume allowance using SSRS, Stored Procedures and T-SQL

Generated periodic reports based on the cost analysis using SQL Server Reporting Services (SSRS) and Excel.

Providing consultation and mentoring on SQL Server development to our development teams.

Installing, configuring, administering and securing our development and testing database environments using Actifio.

Troubleshooting performance issues and fine-tuning on SSIS packages, queries and stored procedures.

Wrote SSIS packages and created maintenance plans to automate repetitive tasks.

Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.

Led team of production DBAs supporting eCommerce B2C website utilizing SQL 2012, SSRS, Power BI,SSIS and Actifio

Lead DBA \Database Developer Northrop Grumman

November 2006 – November 2016 Atlanta GA 30329

Wrote SSIS packages, Stored procedures, User-Defined Functions and triggers to manipulate ADT Application data in SQL server

Rewrote Import Staging and Incidence Conversion Application using SQL Server, SSIS, Stored Procedures, and T-SQL

Generated periodic reports based on the expenditures analysis of the data using SQL Server Reporting Services (SSRS) and Tableau.

Going through the clients' requirements and coming up with database design and application architecture using Visio and Enterprise Architect.

Providing consultation and mentoring on SQL Server development to our development teams.

Installing, configuring, administering and securing our databases as well as our clients' production database servers.

Troubleshooting performance issues and fine-tuning on queries and stored procedures.

Implementing and administering database replication, log shipping between SQL Server databases as well as dissimilar databases.

Wrote SSIS packages and created maintenance plans to automate repetitive tasks.

Migrating Databases from SQL Server from SQL Server 2008 and Oracle to SQL Server 2014.

Setup and maintenance of appropriate database and application monitoring.

Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

Providing highly available database and application infrastructure according to EDLC requirements using SQL Active/Passive clustering configuration, load-balancing, etc.

Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.

Perform performance tuning and analysis on VLDB(3TB)

Led team of production DBAs supporting distributed mission-critical applications utilizing SQL 2012 and Oracle 11

Provide technical support for 58+ production SQL Servers geographically positioned from California to Puerto Rico

Led team of development DBAs/Database Developers building the MJP applications utilizing T-SQL, SSIS, SSRS

Responsible for daily monitoring of MS SQL Server activity, error logs, NT event logs, space usage and security

Responsible for testing, Installing and configuring MS SQL CDC

Responsible for implementing and testing a backup and disaster recovery Plan for SQL Server Databases

Providing custom-tailored backup/restore and disaster recovery plans for production servers.

Proficiency in Database Administration with server configuration, performance tuning, and maintenance with outstanding troubleshooting capabilities.

Configured Replication, Backup/Recovery, Disaster recovery planning and Security Management. Configured Service Broker and Table partitioning for Promis, ARCHE and ADT Projects.

Technical Manager Matria Healthcare

January 2004 – October 2006 Marietta GA 30004

Wrote Stored procedures, User-Defined Functions and triggers to manipulate Sales Prospect data in SQL server

Streamline Sales Prospect Process to increase productivity and reduce turnaround time for pricing and contract procurement

Analyze Healthcare prospect data using Excel and OLAP Cubes for SQL Server 2005

Created ETL project maps to manipulate data using Data Junction, T-SQL, SQL Server and VB

Rewrote the Sales Prospect Log Application using C#, SQL Server, ADO, DTS, Access, and T-SQL

Wrote an Adhoc application to generate Reports and manipulate data using VB.net, T-SQL, and Excel

Generated quantitative reports from internal and external client(s) data to analyze complex claims, financial and eligibility data and prepares recommendations for action using Oracle, SQL Server, Stored Procedures, DTS, OLAP Cubes, TSQL Excel and VBA.

Developed data models to identify the factors associated with various claims outcomes and to provide an interpretation of such associations using OLAP Cubes, Visio and Excel.

Lead team in right-sizing servers and providing for growing hardware needs for internal and third-party applications

Provide mentorship for junior DBAs and developers

Prepared and interpreted analyses of data relating to health care insurance claims and healthcare related data using Data Junction, Access, DTS, Oracle, SQL Server and VB.

Created and Managed Data partitioning, Snapshot isolation, database mirroring, DDL triggers, Online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD, dedicated admin connection for the TRAX System

Created medical statistical analysis applications and technical support in automating claims, analysis processes to identify trends and recommends improvements to the VP of Business Development.

MILITARY

Specialist (SPC/P) United States Army

February 1989 - February 1992 Fort Bliss, Texas, 79921

Mainframe Programmer

Maintained and modified DB2, COBOL batch and interactive modules

Used COBOL/CICS in a MVS Mainframe Environment

Transportation Specialist

Responsible for the daily work schedule and training of 7 personnel

Awards

Army Commendation Medal Southwest Asia Medal Army Service Ribbon

Honorable Discharge Good Conduct Medal National Defense Service Medal

PROFESSIONAL QUALIFICATIONS

LANGUAGES: COBOL, JAVA, DotNet Technologies (VB.Net, ASP.Net, C#, F#), .net Core,R

MAINFRAME: OS/MVS JCL/Roscoe Emulator, IBM 370/390 Mainframe, Panvalet / File-Aid / Platinum, TSO/ISPF/SDSF/Clist, Xpediter, DB2/IMS/SQL using SPUFI, VSAM Files

DATABASES: Microsoft Access, Progress SQL, SQL Server, Vision index Files, Oracle, T-SQL,PL/SQL, OLAP, MYSQL,SSAS

SOFTWARE APPLICATION: SSRS, Crystal Reports, Microsoft Office, DevExpress, Tableau,Visio, Microsoft Project,Data Junction, TOAD, Active Reports, Embarcadero DBArtisan. XML SPY, Map force, Enterprise Architect, Sharepoint, RedGate, Power BI, SSDT, Conflence, Softlayer,Dynatrace, ACTIFIO, TFS, GIT, JIRA, SLACK, GITKRAKKEN

INTERNET: CSS, Photoshop, HTML, XML, javaScript, DHTML, ASP, Dreamweaver, Web services, XSL,AJAX

OPERATING SYSTEM: Windows 7/8/10, Windows 2008/2012/2016 Server, Red Hat Linux, Azure

EDUCATION

Masters of Science in Information System Management

Keller Graduate School of Management, Atlanta, Georgia

Graduation: November 2001

Bachelor of Science in Computer Information Systems

DeVry University, Atlanta, Georgia

Graduation: October 1996

Certified Scrum Master(CSM) January 2011

Certified ITIL Foundation September 2016

Contact this candidate