Experience

NexGen Technologies, Inc.

• United States
• Information Technology & Services
• 1 - 100 Employee

• SENIOR DATABASE DEVELOPER / DBA

  • Nov 2017 - Present

  • PL/SQL module development and support managing the life cycle of over 60,000 oil, natural gas, and geothermal wells and their associated sites on Federal and Native American lands providing $7.6 billion in annual royalty payments to federal, state, and tribal governments. Packages included full lifecycle drilling plans, royalty production, inspections, land reclamations, and environmental issues. • Provided database management for the 151 million acres of federal land available for livestock grazing • MS SQL Server database lead for scientific and recreational land use projects. • Development lead on a conversion project to simplify the overall land lease and application process managed by 43 different field offices • Provided database administration support, including performance tuning, patching, version migration, and mentoring of junior development staff. Show less



Nordstrom

• United States
• Retail
• 700 & Above Employee

• DATABASE ENGINEER

  • Aug 2013 - Oct 2017

  Provided data management development and support services for the credit division of a large retailer with more than 300 stores in the US and Canada. • Technical leader on an employee/onshore/offshore development environment, providing oversight of code and process development, deployment, and performance management. • Created database objects (tables, indexes, compiled code), SQL and SQL*Loader scripting, and Perl utilities to manage data Extract, Transform, and Load (ETL) operations in Data Warehouse, Online Transaction Processing, and Operational Data Store-type databases. • Stepped in to provide logical-level (up through tablespace level) Database Administration and architectural support for 21 databases in five different development groups, the largest being 42Tb in size. Through data and process analysis identified 3Tb of data to remove and hundreds of old scripts for performance improvements. Worked with Senior DBAs to commission or decommission servers, VMs, and databases using vCommander and manual processes. • Provided user administration, technical training, SOC I and II guidance, and role administration in both PCI and PII environments to hundreds of technical and business users. • Created automated Business Intelligence (BI) reports to deliver settlement audit information to internal stakeholders. • Managed system vulnerability remediation (Windows and Linux) using manual installs and pre-developed Chef Packages. Show less



Great-West Investments

• United States
• Financial Services
• 500 - 600 Employee

• SOFTWARE ENGINEER

  • Jul 2006 - Aug 2013

  Created business intelligence solutions for one of the nation’s largest retirement plan recordkeeping systems. • Incorporated PERL, UNIX scripting, PL/SQL, and Crystal Reports to create external-user initiated reports detailing retirement plan assets, demographics, and participant activity for 31,000 government and private sector organizations with over four million active participants. • Provided government-mandated auditing feedback for dozens of city, county, and state defined benefit plans. • Developed ETL processes using SAP Data Integrator and client-directed query capability using Infoview. • Constructed PERL/DBI-based reconciliation reporting to provide multi-tab, color coded Excel workbooks with variable worksheet, column, and formatting definitions. Show less



Citi

• United States
• Financial Services
• 700 & Above Employee

• SENIOR LEAD ANALYST

  • Apr 1999 - Jul 2006

  Responsible for systems design, code development, and process integration for a major credit card and business solutions partner. • Management of Crystal Reports and Oracle PL/SQL code for the Diner’s Club franchise reporting and information sharing systems, which allowed for data entry, reporting, and marketing coordination of the 67 DCI franchises. • Developed secure transmission, data load, and reporting systems to manage 1.2 million cardholders of in 75,000 corporate clients worth $15.6 billion annually. Integrated UNIX, SQL, PL/SQL, SQL*Loader, Connect:Direct (NDM) and JAVA to receive data from worldwide sources, load and validate the data, and provided reports based on hierarchical or functional account grouping on a scheduled or ad-hoc basis. Show less



United States Army Reserve

• United States
• Armed Forces
• 700 & Above Employee

• OFFICER

  • May 1990 - Jun 2000

  Lead military teams ranging from five to 38 people and up to $15 million in equipment in roles such as logistics evaluator, unit commander, and transportation officer. Responsible for planning, evaluation, operational performance, and personnel development. Lead military teams ranging from five to 38 people and up to $15 million in equipment in roles such as logistics evaluator, unit commander, and transportation officer. Responsible for planning, evaluation, operational performance, and personnel development.



Lockheed Martin

• United States
• Defense and Space Manufacturing
• 700 & Above Employee

• Technical Support Analyst

  • Jul 1997 - Apr 1999

  TECHNICAL SUPPORT ANALYST - JULY 1997-APRIL 1999 CONTRACTOR, SUPERIOR TECHNICAL RESOURCES - NOVEMBER 1999 – DECEMBER, 2004 Created and enhanced a U.S. Government Special Compartmentalized Information (SCI) personnel security database and its related web-based user interface. I continued to support the application as a part-time contractor through the end of 2004. • Project management and systems analysis, including requirements gathering and forming consensus among ten separate corporate subsidiaries using Prototyping and Rapid Application Development methodologies. • Database Administrator for an Oracle 7.3.3 database on both UNIX (Solaris) and Windows NT servers. • Developed Oracle-based data load processes using multiple information sources and formats. • Database and web development, creating HTML display and data entry pages using Oracle Webserver 2.1 for facility access control, increased security personnel productivity, and data manipulation. Show less



Union Pacific Railroad

• United States
• Rail Transportation
• 700 & Above Employee

• MARKET MANAGER/ACCOUNT REP

  • Apr 1991 - Dec 1996

  Performed data analysis and utilized relational databases to support business development, operational oversight, and strategy formation for a $140 million transportation market. Performed data analysis and utilized relational databases to support business development, operational oversight, and strategy formation for a $140 million transportation market.