Even after almost 2 years... still exciting

Traffic Management, Colorado Department of TransportationTools: Oracle 11g, 12g, OEM, SQL, Developer/Modeller, CVS, VBox, Rackspace Cloud VM1. Hard Shoulder Running—I-70 Peak Period Shoulder Lane***Alternative option for traffic flow during peak periods during the ski season***System consumes toll fare schedules from toll agency, schedules toll eventsto trigger at the proper times, and activates toll fares onto Variable TollMessage Signs (VTMSes) to inform traffic shoulder lane is open or closed***Implemented process to evaluate priority rules of imported schedule data, and deliver the appropriate schedule and fares to the systemActive Traffic Management—US-36 and I-25 North***Oversaw data design and Oracle implementation of the Integrated CorridorManagement module for Colorado’s traffic management system***Solution integrates with data gathered from speed sensors to actively calculate speeds across corridor in real-time and recommend coordinatedmessage activations across all signs to safely manage traffic patterns

Catholic Health Institute, Metro State University, Oppenheimer FundsTools: Oracle Enterprise Manager (10-11g), SQL, Developer/Modeler, Plus, PL/SQL, RMAN***Configured 100+ database nodes to achieve enterprise monitoring of Oracle databases***Performed data modeling, Oracle patching, data model changes and scripting

Cable MediaTools: Oracle 10g, Oracle VM, VBOX, SQL, Developer/Modeler, SAP Hana Reference Model***Data modeling for application development, test creation, and Hana Training***Worked with analysts, developers, and testers in an Agile Development environment***Provided data models, data dictionary, and assistance in query writing for three teams***Kept naming conventions and definitions consistent across the development teams

RetailTools: Oracle 10g, SQL, Plus, Oracle Applications***Provided Oracle RDBMS and Oracle application support (Financials, Warehouse),including upgrades, patching, and production support***Mediated between application developers, system administrators, and DBAs to facilitate better communication and eliminate friction within a month

IT ServicesTools: Informatica***Designed ETL and data matching algorithms for a software company,writing state specific welfare administration software

***Managed installation and implementation of OBIEE for dashboards and Pentaho, for ETL

XM Radio, Depuy Orthopedics, Johnson & JohnsonTools: Oracle 10g, PL/SQL, Oracle 9i, Informatica***Created ETL architecture, processes, and procedures to combine information fromlegacy systems, department spreadsheets, and integration points with Johnson & Johnson***Achieved interoperability, spreadsheet-farm elimination, and Demand Forecasting

State Government, Business Enterprise Planning, Dynamics Research Group, eGreenbiz.comEnvironment: MS Windows, HP 9000, Oracle 8.0.5, Sun Solaris 5.6Tools: Access 2000, Erwin, VBA, SQL *Plus, PL/SQL, Quest Software (Spotlight, Spacer, Impact, TOAD)Business Enterprise Planning***Enhanced Access 2000 application by designing and implementing new entities,creating and improving forms and reports, and correcting invalid algorithms***Provided necessary documentation by reverse engineering Access tables to Erwin Dynamics Research Corp.***Provided support to PowerBuilder programmers for Child, Youth, and Family (CYF), Department of Youths and Corrections (DYC), and Child Welfare (CW) TRAILS systems***Helped PowerBuilder programmers to implement connection pool for ODBC access***Performed database recovery tests and production recovery (hardware failure),in order to validate the system’s recovery processes and procedures***Mentored programmers on PL/SQL and SQL*Plus use improve stored procedures***Tuned queries and database parameters to achieve higher transactional throughput***Upgraded to RDBMS from 8.1.5. to 8.1.7.2 to stabilize database availability eGreenbiz.com***Supported developers in an Oracle 8.0.5., Sun Solaris 5.6 environment***Designed and implemented extensions to the BroadVision schemaCompuware Computer Lab***Rebuilt pc towers using parts from 30 computers, which resulted in eight functioning computers, and installed the latest operating system onto each