Troy Conner Email & Phone Number

Sterling, Va, Us

Sterling, Va, Us

Us

Built a data mart for political data synthesizing multiple data sources using Oracle 12.2, RHEL 7.4, and the Mulesoft Anypoint platform.Built an Oracle real-time scheduling system supporting ETL and messaging traffic. Designed a data warehouse and operational data store (ODS) capable of implementation in either Oracle or PostgreSQL. Performed as DevOps engineer for Oracle, Unix, and Linux systems.

Developed a data warehouse, star schema, and ROLAP system using Oracle, PL/SQL, and Unix.Developed components of a network health and incident reporting system on an Oracle/Linux platform.Designed and developed components of an Operational Data Store (ODS) on an Oracle/Linux platform. Managed a small team using Agile methods.Solved performance problems of an Oracle/Linux reporting system. Reengineered the database and a dozen PL/SQL and Korn shell modules. For Northrop Grumman, solved performance problems in a VLDB data mart and billion row Cognos cubes. Created a data mart in Oracle 11g and developed an ETL subsystem using Oracle Data Pump and and flashback databases. Developed a reporting subsystem using Oracle, Cognos Framework Manager and Cognos Report Studio. Developed a demo Business Intelligence application using Cognos Transformer and PowerCubes. Developed a data migration subsystem using Oracle 10g, and PL/SQL. Developed a high volume DSS database using Oracle 10g and PL/SQL. Also managed a team, performed production support, and designed the data model using ERwin. Maintained applications written in Python. Designed a data mart using dimensions, fact tables, and cubes.Organized and led a team of developers in producing a budgeting system using Oracle 10g and the Oracle Developer Suite 9i. Produced development and configuration management documentation and procedures. Used Scrum as a project management method.Managed two DoD software development projects using Oracle and a variety of front ends. Produced development and configuration management documentation and procedures. Implemented Scrum as a project management method. Reengineered an Oracle database, reducing response times from hours to seconds. Designed data mart for payroll reporting.

Falls Church, Va, Us

Produced data model and prototype for international criminal database using Oracle.Designed a Corporate Information Factory and components of a custom CRM system using Oracle. Produced the enterprise data model, operational data store, and data warehouse. Developed a code generator that produced 150,000 lines of PL/SQL code from Oracle and business metadata.Designed the server side of a commercial product that merged data from ERP, CRM, and legacy systems. Performed data modeling and physical database design, programming, and database administration using Oracle.Designed and developed a telephone billing system using Oracle. Managed a team of 6 developers and DBAs, delivering a complete system in less than two months.

Developed EAI module connecting Oracle Manufacturing and Oracle Financials and legacy systems. Supervised software developers, DBAs, and business analysts. Conducted performance tuning and other operations support activities on 12 Oracle databases. Developed decision support applications using Oracle Designer and Oracle Forms, C and OCI.

System architecture and development of an online advertising system integrated with Oracle Financials. Design and development of a report distribution system in the Oracle Financials C++ and OCI.Developed EAI/Decision Support Subsystem integrating Oracle Financials and Vertex. Developed data administration and configuration management procedures.