Gary S. Crawford

**** ********* **.

Arlington, TX 76013

***/***-****

Email: ac2fd4@r.postjobfree.com

SUMMARY: Five years’ experience in corporate data acquisition, report development and creating automated process all enhanced by fifteen years of hardware and software support. Knowledgeable in Windows based applications, hardware systems and basic networks.

Currently seeking position as RPA Developer or Data Analyst.

EDUCATION: B.S.C.S. - Stephen F. Austin

SYSTEMS: Windows 7, Windows 10

PROTOCOLS: HTML, ODBC

SOFTWARE: Automation Anywhere, Win Automation, Microsoft Excel, Excel VBA, Power Shell, UFT, Microsoft Access, SQL, and Brio.

EXPERIENCE:

4/16-9/17 Contractor AT&T Digital Life

Automation Engineer (RPA Developer)

Duties: The automation of time-consuming, manual processes utilizing Excel VBA, Win Automation and Automation Anywhere. Typical automated processes using Automation Anywhere or Win Automation include downloading data from a SQL database in to an Excel spreadsheet, saving the spreadsheet on to a shared network folder and then distributing the spreadsheets via email. Some of these processes required launching and logging in to secured websites or secure, proprietary software and navigating those entities to retrieve or enter required information.

In most cases, manual processes involved the use of Excel, so converting those manual processes to automated processes required extensive knowledge of the features and the VBA macro language. My strong background in Excel proved to be very handy in creating some efficient, automated solutions for my clients which made them very happy.

It was estimated that my automation helped save our department around $500,000 in manual processes during the course of my time there.

6/03-2/16 PHARMERICA PHARMACY

Corporate Data Analyst,

Duties: Data acquisition and report creation for both internal and external customers utilizing Brio and/or SSIS, Excel & Excel VBA, and Access. Brio features most heavily used for data interpretation are table joins, grouping, columnar calculations, pivot tables, and data filtration techniques. The data is then exported to an Excel spreadsheet where the data is organized and summarized using a combination of custom VBA macros and other built-in powerful Excel tools. Once the report is finalized, a standardized, streamlined process is mapped out so the report can efficiently be produced on demand, easily read and utilized by corporate decision makers.

Maintain and update Excel VBA macro and SQL query libraries as business needs change.

Prior to being the Corporate Data Analyst, was involved in national data support of eighty eight corporate pharmacies where ALL patient prescriptions were analyzed to determine the best-cost drug for the patient. Once the best-cost drug is determined, the suggestion (along with an explanation) was sent to the patients’ doctor. The doctor then replied to the suggestion and the response was recorded in the database and the pharmacy was notified of any changes to the prescription.

In 2010, I assumed the responsibilities of the Corporate Data Analyst which include the creation of approximately two dozen daily, weekly and monthly reports in addition to any ad hoc requests from both internal and external customers. These reports require heavy usage of Brio and Excel.

Also maintain Access 2007 databases involving maintaining the data of approximately 500,000 doctors for custom data analysis. Created custom queries, table joins, And/Or logic, data summations and VBA code maintenance.

10/02-6/03 SUNSCRIPT PHARMACY

Certified Pharmacy Technician & Work station IT support

Duties: Filling prescriptions, Prepackaging medications, Emergency Kit Maintenance, Data Entry.

Left when company acquired by competitor for a better position

5/01- 2003 OPPORTUNITY UNLIMITED, INC.

Technical Support Engineer (Contract & Direct)

Duties: Install and maintain LAN’s. Support hardware/software installations, technical problem solving both as direct employee and as needed. Responsible for four locations and computer usage by forty plus recruiting staff members. Firm is a technology search and placement group.

11/99-4/01 STUDIO INTERACTIVE (division of PricewaterhouseCoopers, start up)

Technical Support Engineer

Duties: Responsible for all Hardware and Software involving Windows NT4, Windows 2000, and Windows 9x workstations along with part-time web page coding using HTML 4 and JavaScript. Set up, configured and administered Windows NT4 Server network. Firm developed custom web sites for corporate customers.

Reason for leaving: position dissolved due to recession

4/92-10/99 MICROSOFT, INC.

Software Support Engineer

Duties: Networking, PC architecture, MS DOS internals and memory handling.

Technical support for Windows 95, Windows 98, Excel (including second-tier support), VBA, Internet Explorer, Outlook and Office. Creation of Knowledge Base articles, product revision software testing, training new hires, product mentoring, and coding of web pages for a major Microsoft intranet site using HTML and JavaScript.

Left to join new start-up opportunity in graphic/display technology called Studio Interactive.

8/91-4/92 Moved to Colorado to be ski-instructor at Keystone Resort during 91-92 season. Left when position opened up at new Microsoft support center

5/89-7/91 COMPUTER TASK GROUP

Consulting Systems Engineer at IBM

Duties required knowledge of C language, MS-DOS internals and 8088 assembler language.

Duties: Responsible for code maintenance, debugging, and re-writing major features of IBM’s DOS Office Direct Connect (a user-friendly interface between a PC and a VM host, utilizing HLLAPI), Responsible for providing timely and reliable solutions to IBM’s largest customers, Wrote applications to aid in testing.

Reason for leaving: RIF of all consultants in IBM downsizing.

Contact this candidate