Sql Server Data
Resume:
Bill McVey
Houston, TX *****
******.****@*****.***
www.linkedin.com/in/HireBillMcVey
SQL Developer
A Creative SQL Developer with experience in developing and successfully delivering database solutions in complex data environments using SQL Server, T-SQL, SSIS & SSRS and other tools in Supply Chain and Government environments(NASA).
HEWLETT PACKARD INC. 2006 – 2015
Strategic Development Mgr.
-Discovered and developed a new approach to accurately measure inventory pulls in excess of allotted supply. The new approach fixed a 7-year old problem with a notoriously inaccurate report.
-Collaborated with a statistician to develop a vendor allocation tool that used statistical optimization techniques to optimally allocate part purchases with challenging part qualification issues, while minimizing penalties from vendor contracts.
-Built a new database application to replace an excel workbook that analyzed and reported global Factory Cycle Time metrics to senior management. This eliminated 15 man hours a week.
-Designed and built a dashboard using a BI Tool called Qlikview to easily analyze master data issues. This replaced a 50 gigabyte excel application and reduced the run time from 1 hour to seconds.
-Analyzed and uncovered a flaw in reporting specifications that derailed a previous attempt at this application. Corrected the algorithm and developed the solution.
WYLE LABORATORIES 2001-2005
Software Development Analyst
- Created and maintained a database to help NASA’s Bioastronautics program track scientific publications and better answer Freedom of Information Act requests
-Developed a web application using Cold Fusion, web services and a SQL Server database to track the progress of various scientific countermeasure projects against established goals in NASA Human Spaceflight.
-Conceptualized and programmed eight biology-based educational games in Flash to teach intermediate and high school students various concepts in space biology, which were made available to teachers nationally through the web.
-Re-designed the NASA Life Science Data Archive 500 + page website from a HTML Table-based format to a more modern CSS-based website to bring the website into compliance with government accessibility standard (508)
.
GRADUATE RESEARCH ASSISTANT at MID CONTINENT TECHNOLOGY TRANSFER CENTER
1999-2001
- Developed a database tool that facilitated additional information requests for a three day NASA Technology Convention with over 10,000 guests and over 100 presenters.
- Programmed a Patent royalty database tracking system in ColdFusion, Access and Crystal Reports for NASA Patent Attorneys
EDUCATION
Masters of Business Administration (MBA) from University of Houston – Clear Lake
With a Concentration in Database Development.
Completed first Oracle Certification exam with 70% failure rate on first attempt.
Bachelor of Science - Finance from University of Florida
Completed upper level requirements for an additional minor in Economics
TECHNICAL SKILLS
Databases : SQL Server 2008/2012 including Performance Tuning, Query writing, Views, Triggers, Stored Procedures(T-SQL), and Agent Jobs, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), T-SQL, Microsoft Access, Oracle 8
Programming Scripts / Languages: SQL, VBA (Access & Excel), Visual Basic, Flash Action Script, Cold Fusion Script, HTML, CSS, XML, C#, .Net, VB.Net
Web Development: Cold Fusion, Flash (Action Script, Flash Remoting), HTML, CSS, VB Script, Java Script, Illustrator, Photoshop
Planning/BI: Qlikview 11, Microsoft Visio 2010, Project 2010, Microsoft Office, PowerPoint, Acrobat, SAP BW, MS Sharepoint, Crystal Reports
Contact this candidate