Data Entry Sql Server

THOMAS G. RACKLEY

***** ****** ***** **. - ****** TX 78738 512-***-**** cell - *********@*****.***

Software Support,Dev/Analysis/Access,SQL

IT/Software Support professional with 19+ years of experience in gathering business requirements, design, implementation, deployment, support and maintenance of in-house and client applications.

TECHNOLOGY

MS Project, MS Access, MS SQL, Excel

In-house software support

Client support local and remote

Software Support Training

VB, VB.Net, .Net 4.5

C# - Maintenance

SQL & Oracle (SP, Triggers, Indexes, Replication…)

EDUCATION & TRAINING/CERTIFICATES

BACHELOR OF SCIENCE - COMPUTER SCIENCE

Minor: Statistics

University of Central Florida - Orlando, Florida

PROFESSIONAL EXPERIENCE

Programmer Developer/Analyst Premier Research, TX Dec 2016 – Jul 2017

Major Functions: Create a new and improved program in VB.Net &, Oracle and Citrix. Performed maintenance on C# programs.Current program was built in Excel (no Database). No flexibility. Recruitment Projection Model (V4.2). This program takes estimated dates, countries to be used and comes up

with how long a study will take to prove a drug viable to use (there is a lot more to this program but this is the basics). The software is very heavy in date ranges,

Seasonal variations, adjustment factors, computations and graphing to make a sound decision. DeveExpress was used as a 3rd party tool.

Software/SQL/Oracle Developer(Contractor) Signature Science LLC, TX APR 2015-Jul 2016

THOMAS RACKLEY Page Two

Major Functions: Migrate a very unique costing from VBA/Excel/Macros program to VB.Net 2013, .Net 4.5 and Oracle. Introduced TFS as a software versioning tool. Collect and analyze the

project’s business requirements. Prepared a detailed SRS (Software Requirements Specifications) document, user interface guides and change request documents. Informed stakeholders on the progress of the project during weekly scrum meetings. Additions and deletions of project tasks were also handled during the scrum meetings. Work is being accomplished on and off site. Each

scrum meeting showed changes from the week before. The costing system is used by Signature Science LLC in projecting government bids.

SQL/Reports/Support IAS, TX Sep 2013 - Aug 2014

Major Functions: Collect and analyze the project’s business requirements, Prepared detailed requirement specifications documents, user interface guides, and functional specification documents, maintained client support software (ASP.Net and C#). Created SSRS and Crystal Reports for scheduled and ad hoc reports utilized by management and users.

Programmer Analyst HearUSA, FL Jan 2012 - July 2012

Major Functions: Performed enhancements to in house programs created Crystal Reports and Excel files for management.

Senior Engineer/Software Developer Portrait Innovations, NC May 2008 - Dec 2010

Major Functions: Oversight of all internal and external infrastructures with responsibility for data storage (SAN) Networks, Phone System, SQL Data Bases which also included Merge Replication, Virtualization of Help Desk and DR (Disaster Recover), all maintenance (apply patches, Create Stored Procedures, Triggers, Indexes…), Migrate from 2000 to 2005 to 2008 and Virtualize all small SQL DB’s. Responsible for the management of Portrait Innovations Senior System Engineer and SQL DBA. Responsibilities also included creating Best Practices documents for developers and infrastructure. Managed IT Infrastructure budget.

Senior Developer Portrait Innovation, NC Aug 2007 - Apr 2008

Major Functions: Responsibility for all phases of software design and development for developer of applications used for the front end web face to the client, all in house supporting application and data manipulation applications; excellent knowledge of system life cycle methodologies (SDLC);key role in IT department growth and development, including staff hiring and guidance; collaboration with clients on product specifications, problematic issues and user training; delivery of technical presentations; product

THOMAS RACKLEY Page Three

development and management. Collaborated with 3rd party vendors, to achieve project completion in a timely manner.

Lead Software Developer/SQL DBA Choicepoint, NC Mar 2000 - Jul 2006

Migrated Monitoring system from VB6 to VB.Net. The monitoring program allowed for

customized (process, data and hardware) monitoring 24/7. Used C#, VB.Net, ADO.Net,

Visual Source Safe and SQL Server 2000.

Migrated Data Entry program from Delphi to VB.Net. The VB.Net program allowed users to perform data entry and verification locally (no interruption) before committing to production server through process programs.

Led Development team in design and development of a Secure Client Data Entry and Retrieval site. Used C#, VB.Net, ASP.Net, ADO.Net, VBScript, JavaScript, Visual Source Safe and LDAP/SQL Server 2000.

Created process programs that would spawn new instances if the current program that was under a heavy load - VB.Net, ADO.Net, Visual Source Safe and SQL Server 2000.

Designed a database to house Choicepoints proprietary Theft Data. This data was accessed through https real time from Kiosks and customized data entry web sites.

Migrated many in house VB6 programs to VB.Net enhancing the functionality of each to access both the Production and Archive databases and Report Servers.

Designed and created Archive database which was updated weekly through DTS packages allowing the production database to remain lean.

After acquisition, Led Development team in finishing and enhancing a three year long Drug Testing project utilizing VB.Net, ASP.Net, ADO.Net, VBScript, JavaScript, Visual Source Safe and SQL Server 2000.

Created replicated databases for Report Servers allowing for Quarterly and Yearly reports to run without affecting the production database.

Completed a multitude of Client Specific enhancements utilizing VB, VB.Net, ADO.Net, ASP.Net, Visual Source Safe and SQL Server.

Senior Developer/SQL DBA Choicepoint, NC Mar 1995-Feb 2000

Major Functions: Responsible for each phases of software design and development of applications used to perform background checks for banking, retail and airline clients; excellent knowledge of system life cycle methodologies (SDLC); key role in IT department growth and development, including collaboration with clients on product specifications, problematic issues and user training; delivery of technical sales presentations and product development.

Created the Client setup program utilizing VB 6, RDO/ADO, Visual Source Safe and SQL Server 7.0. This program was created to allow users to easily setup a client with customized products. This program also allowed users to customize EBI (Data Entry) Screens for each client. This program logged tracking

information of changes that were made during client customized setup. All changes were verified and data accounted for with this program.

Created a Monitoring program to monitor (Processes, FTP overload, Timing, Row counts…) 24/7. This program allowed for staging of on-call persons with flexible notification (email, text message…). Utilized VB 6, RDO/ADO, Visual Source Safe and SQL Server 7.0.

Created Data Entry program for in-house users. This program was created to allow screen customization per client without touching the code. Training to use this Data Entry program was cut in half because of data validation and correction help. Utilized Delphi and SQL Server 6.5.

Created Teleform process programs customizable for each client. This program allowed users to just verify the information faxed in while business rules were applied in the background. This program made Data Entry very fast and accurate for clients using Teleforms. Utilized 6, RDO/ADO, Visual Source Safe and SQL Server 7.0.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate