SUMMARY

• me am a Senior IT professional with a record of delivering innovative, accurate, and complete IT solutions and superior business benefits. me have been acnoledged for excellent technical skills, technical aptitude, systems design, systems delivery, problem identification, problem resolution, planning, and communication skills. Additional skills and passions include:
• Passion for successDatabase Engineering, Development, Reporting, Conversion, and Integration
• Excellent communicator Performance Engineering
• Thrives on challenges Information Engineering and Systems Design, Development, and Implementation
• Excellent problem solverCall Center Management and Operations Support

PROFESSIONAL EXPERIENCE

Confidential - Cincinnati, Ohio

Database Developer

Responsibilities:

• Developed, tested, and implemented software to automatically generate preventative maintenance service contracts for teh P&G Professional Services group. dis is a core function of teh business unit and eliminated teh numerous hours consumed each week to create these Service Contracts manually. Crontab entries, Linux Shell Scripting, and Oracle packages and procedures were utilized on dis project.
• Executed weekly ETL processing. Made numerous upgrades to teh Oracle SQL involved in dis processing. Generated reports listing errors in teh data delivered from teh 3rd party data provider and mailed these reports to same to continually improve teh process.
• Executed monthly Dashboard processing. dis information was utilized by top management to gain insight into teh overall performance of teh business unit. Made data extraction and reporting changes as required.
• Developed and performance tuned over 30 PL/SQL procedures used to perform QA of various Segmentation data housed in teh data warehouse. Teh QA process detects irregularities in teh data when compared week-over-week or year-over-year.
• Performed table modifications in teh Load, Build, and Warehouse databases and teh associated data mapping required toward dis effort.
• Provided operational support of teh ETL processing. Worked with onsite DBAs during most of dis time.

Confidential - Cincinnati, Ohio

Lead Database Developer

Responsibilities:

• Successfully implemented a MSSQL data staging area comprised of over 90 tables. dis warehouse stores our most critical KPI data and is aggregated to all product levels defined within teh company. Most data were loaded via PL/SQL, some larger data loads performed via SSIS.
• Developed over fifty PL/SQL scripts to extract, transform, aggregate, and load dis data. Performance-tuned these PL/SQL scripts and included performance metrics and error detail capture written to performance and error tables.
• dis data staging area provides teh data for our newly developed suite of executive Dashboard reports/screens and teh source data to our Data Warehouse and Dimensional Data reporting.
• Developed numerous functions to serve as teh approved source for much of teh company’s most important data.
• Provided SQL design, performance tuning, and relational database design mentoring to staff.

Confidential - Beavercreek, Ohio

Lead Database Developer

Responsibilities:

• Supported a large Oracle database for a major U S Air Force System of record.
• Developed all Database Design Specifications required in support of teh application development changes being delivered.
• Managed teh creation, configuration, and delivery of all database Tables, Functions, Triggers, and PL/SQL scripting developed by teh database development team.
• Analyzed requirements, designed solutions, and developed scripting of all Extraction and Transformation processes necessary to deliver teh financial data feeds required by teh Pentagon for their bi-annual Presidential budget reporting.
• Performed extensive data analysis to uncover problems introduced by new application development work. Developed all PL/SQL ETL scripting, Functions, and Triggers required to recover corrupted data.
• Provided all ETL scripting required to load new Oracle tables from various MS Access, Excel, and Word sources.
• Successfully completed 190+ SQL reports and received four letters of commendation from customer and management for same.

Confidential - Cincinnati, Ohio

Atlys Reporting Team Lead/Lead Database Developer

Responsibilities:

• Successfully led a team of seven Atlys Core Reports developers. Captured all requirements and provided design to teh team.
• Reduced SQL run time from 4-24+ hours to 20 minutes-or-less in 16 reporting scripts. Performance-tuned numerous other SQL reporting scripts of lower severity to 20 minutes-or-less.
• Delivered SQL performance tuning materials to my team and to offshore reporting teams.
• Recognized as an SQL development, and performance tuning subject matter expert. Consulted DBAs and other groups on same.
• Prepared and Presented teh Atlys Finance Reporting Solution to all new and potential clients.
• Designed performance team’s core Unix Application Performance Monitoring and Reporting tool.
• Recognized as a PERL and shell scripting subject matter expert.
• Successfully migrated our Unix Application Performance Monitoring and Reporting tool to a more powerful UNIX machine. Migration Plan was later adopted by Corporate Governance as a model migration plan.
• Successfully led teh Logical Database Modeling team for a large Material Management system integration effort.
• Successfully led teh ETL team for a large Material Management system integration effort.

Confidential - Fairborn, Ohio

Sr. Systems Designer/Database Administrator/Logical Database Design Lead

Responsibilities:

• One of only two lead designers for teh DMMIS project. Responsible for teh execution side of teh MRP system.
• DMMIS was teh world's largest Repair Manufacturing system in teh world at teh time. Demonstrated skills, noledge,
• and aptitude dat allowed me to progress from Shop Floor Control subsystem associate lead to a position as Lead Designer
• f teh execution side of dis project within less than two years.
• Successfully performed TOTAL Database maintenance and ETL tasks.
• Successfully consulted all development teams and provided final approval for all database changes.
• Successfully led teh DBA Design Team responsible for models, design, development and definition of all SUPRA DB files/views.
• Successfully provided all project evaluation and proposal compilation for all bids awarded to teh district office.
• Successfully managed all on-site consultants, performed performance reviews and directed employee transitioning at project end.
• Air Force base closures and downsizing resulted in Ciscorp’s decision to discontinue operation of dis district and me was one of three (of more than 100) consultants offered employment by Grumman Data Systems.