PATRICK C. GESELBRACHT
**** ****** ****** ******, ** 80211
*.***********@*****.*** 303-***-****
OBJECTIVE
Secure a full-time position as a Oracle Database Developer/Administrator in database architecture, development, integration and /or maintenance.
EDUCATION
Purdue University, West Lafayette, IN
Bachelor of Science in Electrical and Computer Engineering, May 2004
COMPUTER SKILLS:
Software: PL/SQL, t-SQL, Java, Javascript, ASP, ASP.NET, C / C++, VB, VB.NET, Python, Shell Scripting, Ant, Coldfusion, CSS, VHDL, HTML, XML, Assembly
Applications: SQL Developer, SQL Plus, SQL Loader, SQL Enterprise Manager, Toad, Informatica, DB Unit, Vizio, Crystal
Reports, Cruise Control, Visual Studio, VS.NET, Eclipse, jEdit, PSPad, SVN, CVS, Source Safe, AutoCAD, OrCAD, Matlab, MS-Office (Access, Excel, Word, and PowerPoint), Adobe (Photoshop, Illustrator)
Operating Systems: Windows (9x, 2000, NT, XP), Linux (Ubuntu), UNIX, Macintosh (Leopard)
Areas of Expertise: Healthcare, Telecommunication, Automotive
EXPERIENCE
Perficient Inc. Denver, CO September 2007 - Present
Senior Technical Consultant
Client Assignment: Large Telecommunications and Marketing Company
• Developed a custom PL/SQL & Informatica ETL data migration solution parsing data from malformed Word documents & comma delimited vendor data to a normalized Oracle database
• Integrated Oracle data into ODS & EDW business intelligence & reporting systems
Client Assignment: Large Health and Human Services Company
• Designed, refactored, and integrated an Oracle database solution per software & architecture requirements
• Developed a custom PL/SQL ETL data migration solution from a denormalized t-SQL database to a normalized Oracle database. Tuned code, Oracle parameters & system hardware for performance.
• Nominated by peers and received an Individual Excellence Award
Client Assignment: Large Telecommunications Company
• Designed and implemented database & software quality assurance test suites
• Built and maintained a continuous integration environment
A1 Enterprise Inc. Santa Cruz, CA May 2005 – September 2007
Technical Consultant
Client Assignment: Large Construction Company
• Project Lead for a materials tracking system using VB 6.0, Excel, and Microsoft SQL Server in a Citrix Environment
• Developed and maintained a resource & task management website using coldfusion, javascript, AJAX, DHTML, and Microsoft SQL Server
Client Assignment: Small Real Estate Company
• Developed and maintained a project management website using ASP, VBScript, javascript, and Microsoft SQL Server
• Developed and maintained marketing website using ASP.NET and javascript
Data Tracking Solutions Inc. Kokomo, IN April 2004 – December 2005
Chief Technical Officer
• Developed and marketed a database system to track sensitive information and generate reports for the Department of Corrections using VB.NET, ASP.NET, SQL server, Crystal Reports, and Microsoft Access
Double Gelix Inc. Oak Park, IL July 2004 – October 2004
Technical Consultant
• Developed and marketed a database and reports system to track state mandated special education student information using Microsoft Access and Microsoft Word
Delphi/Delco Electronics Kokomo, IN May 2004 – January 2005
Software Engineer
Simulation and Modeling
• Developed serial communication models to emulate diagnostic controllers for Keyword 2000, RS-232, CAN, and AVT protocols.
• Integrated serial communication models to create a simulation environment for ABS systems
Software
• Maintained a Visual Basic program used to generate random waveforms and process system messaging based on a GPIB communication between a Host PC and a Power Supply connected to a Product Under Test
• Developed an update to the waveform generation software, replacing the GPIB control with an amplified analog voltages from a National Instrument card to the Product Under Test
• Designed and implemented a TCP/IP handshaking scheme to interconnect a system simulator with the waveform generator
Hardware
• Designed and implemented a circuit and corresponding embedded software to compliment a microprocessor controlled communication bus corruption tool including flash procedures and module drivers
Delphi/Delco Electronics Verification Lab W. Lafayette, IN January 2003 - May 2004
Software Engineer
Simulation and Modeling
• Completed diagnostic input/output verification for various BCE controllers using the Pi Technology Autosim Simulator
• Created C++ scripts for each test scenario according to the Product Definition Specifications
• Used Simulation Executive to run a series of automated test scenarios and evaluate the results
Software
• Created Visual Basic programs to automate functionality of system engineers
• Provided continued support and updates for Visual Basic software