JOHN MCDONALD
HOUSTON TX ****4
*********@*****.***
Technical Skills
•Operating Systems: Windows 95/98/NT/2000/XP/Windows 7, 10, Unix, Open VMS
•Application Packages: MS Office, Advanced user of Excel and Access, CICS, FTP Pro, Macro Script writing, SQL Server 2008R2/2013, SSIS, SSRS, ASP.NET Web Applications, Objectif Lune, Remote Server Support
•Supported and upgraded .NET application through TSQL script, XML script writing, stored procedure update resulting in front end website version upgrade
•IIS Scheduling for XML data filtering used in .NET web applications
•DTS Tool Knowledge, SQL Import/Export
•Basic ETL Experience for Organization requirements
•iNetpub file knowledge, understanding of webconfig XML file related to .net applications
•SQL Business Intelligence to update reporting and jobs
•Hardware and Support: Custom builds of personal computers, laptops, servers and rack mount servers, server clustering, hard drive rack configuration of server drives and digital drives as well as the testing of these products
•Exceptional trouble shooting and problem solving skills concerning all of the above
•Technical Support: Web sites, web development, Corporate Business Analyst II, Support Analyst I
•Healthcare Technical Support HL7 Patient filtering and coding (HCA)
•XML adjustments for healthcare document control (HCA)
•Healthcare web base management and support (HCA)
•Error code break fix and site performance optimization (HCA)
•Following Health Insurance Portability and Accountability Act (HIPAA) guidelines and constraints
•Healthcare web based upgrades using SQL stored procedures and XML file replacement or XML code adjustments (HCA)
•Share Point database link and administration
•Excel VBA Embedding for SQL script
•Excel formula manipulation
•Excel V-Look up, H-Look up
•Excel conditional formatting
•Strong understanding of Power Point Presentation
Experience
Uber Eats Delivery July 2019 to Present
Driver
Pick up, making sure order is correct
Drop off in a timely manner
Car and Truck Flipping Aug 2018 to Present
Diagnose, Repair and Sell – Self Employed
Diagnose problems
Repair systems and mechanical problems
Light body work repair
Advertise and find buyers for completed vehicles
Deutsche Post DHL Group – Supply Chain Aug 2014 to July 2018
DBA/Database Analyst
Team of 5 supporting over 150 SAP users
•Maintained SQL server functionally
•Managed daily, weekly and monthly uploads
•Created, inserted, deleted, replaced, and updated data using T SQL statements - This included Tables, Columns, and Data
•Worked closely with Finance team to verify and update data in MySQL
•Wrote custom SQL script for ERP system (SAP)
•Updated SSIS and SSRS using SQL Business Intelligence (BI)
•Created and updated stored procedures for automation
•Used Excel VBA Embedding for SQL script
•Applied use of Expert level Excel formula manipulation and automation skills across wide range of operational and financial data reports
•Worked heavily with Excel V-Look up, H-Look up within reports
•Connected with vendors to gather information of custom reporting needs
•Trained employees on application changes
•90% Remote/Telecommute
•Scheduled SSIS to automate reports
•Assisted with any SQL Builds, updates, scripting or queries
•Consulted with VP of Finance and Operations GM regularly regarding needs for supply chain and financial data/reports
Sysco Corporation – Contractor April 2014 to July 2014
Application Tools Specialist
•Built custom reporting suites in Excel for SharePoint
•Used SQL Business Intelligence to update reports when needed
•Assisted with any SQL Builds, updates, Scripting or Queries
•Consulted with VP of Finance on any needs for business line data
MS Energy Services - Contractor April 2013 to February 2014
DBA Specialist
•Created oil & gas custom drilling report data Queries
•Used Access VB Scripting
•Used Access Expression Building
•Created Macros and set up form building
•Regularly used Basic VBA scripting with Programmers Notepad
•Installed and configured SQL Server
•Used Excel formatting, formulas, macros and graph manipulation daily
•Embedded SQL script into Excel for ease of data imports
•Daily access to SQL data imports to keep current rig information
•Exported data from Excel to Power Point for quarterly presentations
•Created multiple and varying Power Point presentations for upper management team
•Analyzed directional drilling data using Access and Excel
•Constantly adjusted SQL, Access and Excel statements using knowledge of “the human factor”
•Reported Rig Data and Well Completion Data in Excel and Power Point
GL-Noble Denton Oil & Gas - Contractor February 2013 to April 2013
Access Database Specialist
•Created oil & gas custom financial reporting data queries
•Built custom queries for reporting to VP of Finance
•Used Access VB scripting
•Used Access Expression Building
•Created macros and form building
Precision Document Solution (HCA, Healthcare) March 2012 to February 2013
DBA/Systems Administrator
•Supported and Developed eDemand website for administration and reporting
•Implemented new site versions and enhancements of eDemand website
•Used custom web based filtering through VB Scripting
•Used Web Config custom coding
•ETL Organization Requirements
•Installed and configured SQL database, created SQL server queries, basic TSQL statement writing; Select, insert into, update, delete, where, order by
•Gained DTS Tool Knowledge, SQL Import/Export
•Administered and Updated stored procedures
•Used SQL AD group configuration conforming to HIPAA
•Remote Server Management, Internet Information Services (IIS) server management
•Managed SQL server upgrades and configuration
•Troubleshot and corrected any SQL error codes
•Pulled custom reports for monthly billing
•Created Excel spreadsheets for finance to bill clients
Hewlett-Packard August 2011 – March 2012
Server Lab Technician
•Installed server OS (Windows 2008 and Linux) on HP ProLiant Systems
•Installed and configured HP network and serial switches
•Installed and configured HP server side hardware
•Server Cluster Builds, Rack U42
•Cabled, installed and organized server racks
•Hardware and OS trouble shooting
•Used Putty to run configuration and stress test on servers
•Remote ilo support
US Bank – Voyager Fleet Systems May 2005 – June 2011
Systems Administrator/Business Analyst
•Web Site Support:
•Provided Access online support – Bank Card, Fleet Commander Online support
•Supported enrollment issues and or problems with the web site.
•Analyzed areas for site improvement, handling Siebel trouble tickets for site problems, and developed site updates
•Financial Reporting:
•Provided custom reports using MS Access/MS Excel Advanced User, Advanced Query Tool
•Used MS Access Database to run Ad-Hoc queries for our clients’ needs
•IBM Mainframe CICS:
•Support of mass fleet card implementation
•Built and ran macro scripting to add/update information to the IBM mainframe for fleet card accounts
•Created queries to confirm data loads and accuracy
•Database Management/DBA:
•Updated and maintained database tables to insure data integrity
•Added updates to client tables and tested data integrity
•Hardware and Software Issues:
•Handled all of 6th Floor hardware and software issues
•Set up Oracle configurations and connections
•Trouble shooting of all PC hardware issues
•Installation of Peripheral Devices:
•Hard drives, memory, CD drives, motherboards, processors, video cards, network cards
•Server installation and configuration