SUMMARY:

• I have spent the past 20+ years of my career architecting and building total IT solutions that are a superb fit for my clients based upon the factors that my clients consider integral to their business.
• I want the client to be happy with the solution as well as comfortable with the architecture. I always take into consideration future growth when determining the best fit for my clients.I am a very decisive and thorough manager.
• I communicate well at all levels and believe firmly in communicating directly with the end - user to determine what would make their jobs easier. I frequently suggest new technologies aimed at streamlining their processes and making the overall workflow smoother and more cost effective to the company.
• I aggressively expand my knowledge of new technologies and look for the appropriate applications for their use and I’m excited by the challenges that they present.
• My core strength has been Oracle but I love diversity and have eagerly pursued opportunities in other technologies so that I can offer my clients a broad spectrum of possibilities based upon their need.
• I’m highly motivated and dependable and enjoy working in a team environment. I have a very diverse skill set that enables me to function in many different capacities as well as understand another team players perspective.

TECHNICAL SKILLS:

• Linux/Unix
• Windows 9x/NT/2000/XP/Windows 7
• Oracle -
• Database Administrator ~ Developer ~ Functional Analyst ~ Technical Analyst ~ Architect
• Database7,8,8i,9,10g
• Development ToolsSQLPLUS
• Toad
• SQL Navigator
• PL/SQL Developer
• Oracle Reports
• Oracle Forms
• Oracle Warehouse Builder
• Discover 2000
• Oracle Portal
• SQL Loader
• ApplicationsERP Financials and Manufacturing 10.7, 11, 11iTechnical and Functional
• Custom Applications
• SQL Server -
• Database Administrator ~ Developer ~ Functional Analyst ~ Technical Analyst ~ Architect
• Database 2000, 2005, 2008 R2
• Development ToolsSSMS
• SSRS
• SSIS
• ApplicationsCustom Applications
• Informatica
• .NET Framework
• .NET Compact Framework
• Java Script
• CSS
• HTML

PROFESSIONAL EXPERIENCE:

Confidential - Kings Mountain NC

Technical Resource Manager

Responsibilities:

• Support and Customize Oracle ERP (Financial and Manufacturing)
• Helped in the designing Enterprise Solutions based on Parkers vision
• Architected solutions that will be easily reconfigured to adapt to changing technologies/applications
• Use .NET handheld application for warehouse shipping system
• ASP.Net Customer CRP Application
• Oracle and SQL Server Database Administrator
• Developed Interface Solutions using SQL Server Information Services
• Determined best solutions for Parker based on platform, cost, durability, expandability, future use
• MQ Series Solutions for near real-time purchase order visibility to vendors
• Designed conversion, cut-over and contingency plans
• Daily monitoring of database performance and health
• SQL Tuning based on explain plans
• Train the Trainer on High Performance Teams

Confidential - Charlotte NC

Team lead

Responsibilities:

• Utilized Oracle Warehouse Builder and PL/SQL in Oracle (Unix) to extract data from many OLTP systems into a large centralized data warehouse (OLAP) used for executive reporting.
• Worked closely with project managers to determine time and resource allocation and budgetary issues and concerns
• Designed and architected Data Warehouse solutions, writing technical specifications and training co-workers on new techniques used to streamline coding effort and provide better technical support
• Installed and configured Discoverer 2000 web and desktop and trained users on how to use the tool to drill down/up for their reporting requirements

Confidential - Charlotte NC

Senior Technical Developer

Responsibilities:

• Architected Oracle on Unix Microstrategy data warehouse solution
• Extracted, transformed, scrubbed and loaded data from many sources to create centralized reporting across the bank “W”
• Helped various business units standardize on calculations shared across the bank
• Developed High Level and Low Level Design Documents
• Communicated with off-shore resources daily for questions, design issues and any changes or enhancement request
• Determined business request to be in scope or out of scope and started developing future project request in a phased approach determined by level of difficulty and time determinants
• Utilized Six Sigma methodology

Confidential - Charlotte NC

SQL Server Database Administrator

Responsibilities:

• Monitored database health
• Developed stored procedures and functions for developers
• Tuned SQL Scripts for improved performance

Confidential - Charlotte NC

Consultant

Responsibilities:

• Worked with the Business Unit to determine requirements
• Determined technology to be used based on need, scope and financial analysis
• Architected Large Data Warehouse solution from the ground up
• Wrote and communicated technical requirements to a team of the developers
• Utilized Oracle OLAP Advanced Functions in reporting
• Monitored database performance
• Performed database maintenance tasks for on-going support
• Wrote support and training documentation and trained end-users on product

Confidential - Charlotte NC

Technical Lead, DBA Oracle and SQL Server

Responsibilities:

• Designed Oracle Solution to parse XML files prepared by a web client
• Designed best way to integrate new web technology into and existing OLTP application without interrupting or interfering with daily processing and performance
• Migrated SQL Server from one box to another re-architecting security to use application roles instead of domain authentication
• Reconfigured all DTS Packages and Jobs to utilize global variables passed from the job to dynamically specify server name and various other components that were different in different regions.
• Designed custom interface to migrate data from Oracle to SQL Server using dynamically created extract scripts from database tables and objects that create the Select statement sent across to Oracle through Linked Server Openquery functionality
• Configured environment of both boxes to allow open interfacing between databases
• Designed custom security structures
• Optimized code by reviewing all database objects to utilize indexes or materialized views
• Interpreted execution plans for index utilization, ran statistics, pinned continually executed packages in SGA for Oracle
• Sized databases and determine storage capacities for objects, added datafiles to tablespaces, determined which file structures to distribute data to for optimal performance, built clustered and non-clustered indexes

Confidential - Charlotte NC

Technical Manager

Responsibilities:

• This was a third party product installation that Pomeroy was contracted to implement
• Worked closely with Sheriffs Department IT personnel and others to determine system requirements and gap analysis
• Data Conversion of Offender Management System from Mainframe to Oracle using sql*loader to extract, transform and load
• Database Administrator
• Installed and Configured Oracle 9i Database and Application Server
• Created daily backups using import and export utilities
• Created roles and user accounts and established grants and public and private synonyms to reference
• Performed Capacity Planning for Production Environment
• Architected and developed solution to Interface Offender Management with other agency systems
• Wrote Enterprise Java Beans

Confidential

Technical Specialist

Responsibilities:

• Managed full life cycle development of custom accounts payable module integrated into
• Oracle Financials 11i using Developer Forms and Reports 6i and PL/SQL
• Designed Logical and Physical Data Models for Transactions Data Warehouse
• (TDW) loaded from legacy systems using Informatica ETL
• Designed and Loaded individual Data Marts used for reporting using Oracle Business Objects
• Tuned database
• Involved in capacity planning
• Performed knowledge transfer to Project Management
• Developed documentation and trained employees on use of the system

Confidential

Manufacturing Industry

Responsibilities:

• Development of a custom application using vb.NET Compact Framework for handheld solution
• Windows and Web Services for communication between wireless device and database servers

Confidential

Technical Manager

Responsibilities:

• Oracle Data Warehouse Implementation using RDBMS 8.1.7
• Designed and built a solution that translated existing legacy databases into procedures used to load the data warehouse where investor and mortgage analytics information was reported
• Communicated requirements to team and supervised timeline, scope, budget and deliverables
• Performed knowledge transfer to client through mentoring program
• Worked closely with business to standardize on functional calculations across the board
• Ongoing database maintenance and health checks
• Built indexes and materialized views to enhance performance

Confidential

Manufacturing

Responsibilities:

• Technical liaison between business users, technical developers and reporting team
• Performed Gap Analysis
• Designed custom solutions for gap areas
• Converted data from existing system using Oracle’s standard open interfaces and API

Confidential

Discoverer Administrator

Responsibilities:

• Set up the entire Administrative End of Discoverer 4.0 using the Web for user ad-hoc reporting
• Database was a highly customized Oracle Manufacturing Environment

Confidential

Development Manager

Responsibilities:

• Technical Manager of Oracle Financials Implementation 11.0.3
• Translated Business Requirements into specifications to be utilized by development staff
• Project Management including billing, deliverables, status reporting directly to Steering Committee
• Developed 33 Interfaces including
• AP Open Interface
• Journal Import Interface
• AP Invoice Import Interface
• Cash Management Reconciliation Interface.
• Developed 21 GL and AP Customizations
• Conversion of GL, AP, and FA databases from three disparate legacy systems (GEAC, Lawson and Oracle)
• Responsible for developing Functional and Technical Specifications with Business Analysts
• Supervised team of developers
• Developed and Maintained Project Plan using Microsoft Project
• Aided architecture team in defining the logical and physical data models for the custom area for processing, error validation, and audit packages
• Helped other development teams in data synchronization across databases using a series of database triggers, packages and database links
• Worked closely with database administrators to determine sizing requirements and timing feasibility based upon interface and load planning

Confidential

Consultant

Responsibilities:

• .Com developer for an Oracle Financials Implementation
• Helped design and build interfaces and conversion scripts for post implementation of HR Module
• Integrated HR module with ADP Payroll System and various other legacy systems
• Utilized Oracles HR API Packages for the Interfaces
• Performed Initial Employee Load

Confidential

Oracle Financials Integrator

Responsibilities:

• Lead Designer/Developer for a rapid .COM implementation of Oracle Financials, Purchasing, Inventory and Order Entry
• Architected, Designed and Developed Interfaces between Web Order Entry and Oracle Financials 11i
• Customized several Accounts Receivable reports in Oracle Reports 4.5