Post Job Free
Sign in

Data Sql

Location:
Houston, TX
Salary:
70000
Posted:
August 09, 2019

Contact this candidate

Resume:

JOHN MCDONALD

**** ******* *****

HOUSTON TX ****4

832-***-****

*********@*****.***

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



Contact this candidate