Career Summary:
Highly motivated problem solver with proven technical abilities, increasing responsibilities and a strong results record. Areas of expertise include: ETL development, data analysis, application conversions, end-user reporting and application development.

Education:
B.S. in Computer Science with a minor in Mathematics

Professional Experience:

Confidential, Salt Lake City, Utah
ETL Engineer / DataBase Analyst
November 2009 to April 2012

• Primary Architect of the Acteea Data Mart database as well as Lead Engineer responsible for all ETL design and development. Utilized Talend Open Source 4.0.2 and Postgres 9.0 database functions to create an ETL process which inserted and updated records through a staging database on to the Enterprise eCommerce Analytics (EeA) SaaS application runtime database.
• Provided professional services to eTail customers lacking the technical knowledge of their data. Obtained access to the client\'s database in order to analyze and extract the required data elements to load the EeA application.
• Worked with the client\'s technical staff to resolve data discrepancies that surfaced during the ETL process or after their data was ETL\'ed into the EeA application.
• Performed the duties of a database administrator on all of the company\'s Postgres databases. Tuned queries, created database objects, ran backups and restores, added referential integrity to the schemas, utilized UUIDs in the database model.
• SQL expert in Postgres, advanced SQL knowledge in SQLserver, MySQL and Oracle.
• Author of the "Quick Start Guide" and "Technical Specifications" white papers which provides merchant's with a detailed description of data requirements when on-boarding for the EeA product.

Confidential, Bluffdale, Utah
Functional Business Analyst, Project Manager, contract consultant through TEKSystems,
September 2009 to November 2009

• Product manager for the Money Merge Account application.
• Wrote functional business requirements detailing the Money Merge Account web application engine. Analyzed the Visual Basic source code to provide logic point documentation for the development team. Used Axure and Microsoft Visio to create prototypes and graphical flowchart representations of the code.

• Project Manager and Technical Business Analyst responsible for system analysis and business requirement documentation for converting 12 GE Money Visa/MasterCard internal applications to American Express credit card processing. System modifications were made to: Oracle PL/SQL routines, ETL, the output format of draft-5 EDI files, re-branding of applications, add application security, meta-data, auto email generation processes and application source code. Platforms affected were Oracle, Windows and the IBM mainframe.
• Architect and Project Manager for implementing an MS-Access database and Business Objects Client Tracking application. Took 17 Excel spreadsheets generated daily by various data sources and tied them together into a single application to provide instant, accurate and flexible access to client information by Account Management Specialists.

Confidential, Salt Lake City, Utah
Director of Information Technologies/Project Manager, April 2004 to June 2008
Database Analyst/Business Intelligence Analyst, March 1999 to April 2004

• Database Administrator for the university's 5 Oracle 9.2.0.8 and 10g Advancement databases with 450,000+ donors and alumni. Daily activities included: test system refreshes, loading of graduate data from the university's PeopleSoft system, unloading/reloading of data-mining information, EDI file processing, PL/SQL programming, end-user reporting, checking data integrity scripts, enterprise performance monitoring, cold and hot backups, exports and disaster recovery. Tools included SQLDeveloper, Oracle Enterprise Manager, Crystal Reports 9 and Windows Task Scheduler.
• System Administrator for Oracle. Installed, upgraded and patched the 5 Oracle subsystems in the department. Experience with installing Oracle versions 7.3.4, 8.7, 9i, 10g.
• Project Manager for the successful conversion of an out-dated DOS-based application to a multi-tiered web-based architecture (Sungard Higher Education's ‘Advance Suite'). This included analysis of RFI/RFP documentation; data mapping; hardware, network, security and software design; project management; purchasing; end-user reporting; system installation, maintenance and upgrades; disaster recovery and end-user training.
• Business Analyst/Report Writer: worked directly with the end-users to gather requirements, design and deliver market-targeted reports and provided data mining analytics using Crystal Reports 9, MS-Excel and Oracle SQL. Supported the entire software development life cycle for the department and campus. Wrote end-user documentation and presented training sessions on application and reporting functionality.
• Director of Information Technologies responsible for the daily operation of the department's hardware and software environment, including 87 Windows desktop and laptop computers and 18 servers. Server environment utilized HP Proliant DL 580 G5 hardware running Windows 2003 Server, McAfee Enterprise HIPS, Tripwire Enterprise, Windows Terminal Server, Windows Virtual Server, Oracle 9i/10g and HP Data Protector. HP Pavilion desktops and laptops were utilized, running Windows XP Pro, McAfee Total Protection and MS-Office 2003.
• Responsible for all fund-raising applications and their reporting environments used campus-wide and within the department.

Confidential, Salt Lake City, Utah
Database Administrator March 1998 to September 1998
Confidential Salt Lake City, Utah
Contract consultant through Systems West, October 1994 to March 1998

• Oracle Database Administrator for the 911 emergency databases serving 14 million customers throughout the western United States. Provided production support for 21 Oracle systems on various UNIX platforms and installed database components for application upgrades.
• Developed Korn shell scripts to monitor databases and automatically alert level one support when acceptable performance or capacity parameters were threatened or errors occurred.
• Business Process Analyst assigned to reduce the length of the nightly and weekend CA-7 batch cycles by tuning automated execution dependencies within CA-7 and JCL parameters. This effort resulted in cutting 47 minutes from these nightly cycles, allowing for greater application availability for end users, production supports' ability to meet their up-time goals and significant cost savings.
• Installed major application releases on UNIX, Windows and MVS platforms.

Confidential, Richardson, Texas
Systems Programmer/Database Administrator/Application Programmer, January 1991 to October 1994

• Database Administrator for Oracle, DB2, DB2/2, IMS and SQLServer. Provided database technical support during application release installation, tuned application SQL, wrote JCL for batch jobs, monitored database backups and system logs, participated in disaster recovery exercises.
• Installed and maintained DB2, CICS and CA-1 on an IBM 3090-600 mainframe using SMP/E.
• Designed, developed and implemented a client-sever application for testing assembled HVAC units at the company's factories and research lab. Analyzed the current mainframe system, wrote design specifications, interviewed engineers for functional and business requirements, developed the application using the most current API tools (Wonderware and C++), worked with the engineering team to test the application, provided documentation and post-production support.
• Team member in the development of a client-server ‘work in progress' application to replace an outdated mainframe system. Worked with the research lab engineers to design the user interface, mapped data and developed programs (using C++) to convert data from a proprietary file format structure into the Oracle back-end. Application GUI was developed using Gupta SQLWindows.