We provide IT Staff Augmentation Services!

Sr Principal Consultant Resume

5.00/5 (Submit Your Rating)

Columbus, OH

SUMMARY:

  • Seasoned and analytical Information Technology Professional with successful 5 year track record as a Project Manager, 32.5 years of Confidential Database Administrator, 20 years Application DBA and 7 years of Confidential development and design experience. Background in consulting and software development life cycle management methodology with ability to create accurate client requirements and design, develop, test, deploy, manage, and maintain critical database solutions that improve operational effectiveness and profitability. A skilled project manager capable of setting expectations, developing realistic schedules, leading technical staff and cross functional teams, resolving critical path issues, and delivering quality results on time. An excellent communicator capable of interfacing at all levels.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Principal Consultant

  • Install, Configure, Patch and Maintain multiple Confidential EBS Release 12.2
  • Install, Configure, Patch and Maintain multiple Sunflower Instances
  • Install, Configure, Patch and Maintain multiple OBIEE R11g Instances
  • Install, Configure, Patch and Maintain multiple Markview and Kofax Capture Environments
  • Configure, Patch and Maintain 2 Confidential OID/OAM 11g instances
  • Refresh/Clone EBS and Sunflower instances
  • Integrate EBS, Sunflower and OBIEE for Single Sign - On
  • Troubleshoot and performance tune EBS, Sunflower and OBIEE Instances
  • Document all Installations, Patching and Configuration.
  • Assist Functional and Development Teams with Migrations, Tuning and debugging

Confidential

Principal Consultant

  • Upgrade Confidential Databases to 12c
  • Troubleshoot and performance Tune EBS release 10, 11i or 12.x.
  • Clone EBS.
  • Fresh implementations of EBS from concept to go-live in multi-language.
  • Upgrade EBS applications (release 11i, 12.0 and 12.1) to 12.2
  • Install OBIEE 11G, Informatica and DAC. Integrate the components with EBS and refresh the repositories when needed. Integrated with OID/OAM (Single Sign-On)
  • Install, Configure, Upgrade, Clone and Patch Utilities - Work and Asset Management (WAM 1.9 and WAM 2.1)
  • Install and Patch Customer, Care and Billing (CCB) 2.5
  • Install OID/OAM 11g. Integrate OAM with Confidential WAM and EBS 12.1.3
  • Implement, Upgrade and troubleshoot Weblogic Server 10.3.5, 10.3.6 and 12
  • Implement and enforce database security and monitoring using Transparent Data Encryption, Data Redaction, Database Vault and Audit Vault.
  • Responsible for performing SRR Scans/STIG fixes to Confidential environments
  • Research and apply patches following CM methodology to resolve issues and perform quarterly CPU/PSU patches.
  • Perform regular clones to meet Customer deadlines for projects and implementations.
  • Implement regular backup policy and disaster recovery using Confidential RMAN and available customer hardware.
  • Research and document CPU and PSU patching. Test and deliver patches and documentation to customer.
  • Proactively Monitor Customer database instances and Concurrent Managers.
  • Document all changes and report to customer on the status of their environment and any future action plans to keep them current with Confidential Support.

Confidential

Senior Application DBA

  • Upgraded Confidential CRS and ASM to 11.2 from 10.2.0.4 version
  • Supported 27 R12 Application with Financial and Manufacturing modules, 11 SOA Application Environments, 5 Infrastructure Environments and 2 GRID servers on a mixture of RAC and Single Node database Servers.
  • Responsible for cloning EBS from Production using various methods. RAC-to-RAC, RAC-to-Non RAC and Single Node to Single Node.
  • Responsible for performing SRR Scans/STIG fixes to Confidential environments
  • Researched and applied patches following CM methodology.
  • Researched and documented CPU and PSU patching. Tested and delivered patches and documentation to customer.
  • Upgraded RAC CRS from 11.1 to 11.2. Migrated the ASM home under the CRS HOME.
  • Provided third level support for Application Issues.
  • Enforced program design, coding, review, and testing standards and procedures

Confidential - Columbus, OH

Senior Database Lead

  • Supported Production 11i Application with Financial and Manufacturing modules
  • Implemented ASCP in Confidential Apps Release 12.1.
  • Implemented Grid Control for all Confidential instances with AMP3.1 pack, Data Masking, Performance and Tuning
  • Implemented and enforced SOX methodology for Confidential Applications and databases. Ensured data security and data masking rules to protect corporate data.
  • Performance tuning of Database and Application
  • Managed DBA team locally and offshore to provide 7x24 support for all Confidential instances.
  • Implemented Backup Recovery Strategy and Offsite Disaster Recovery Plan
  • Cloned and Patched all instance to support Change Management policies
  • Workflow Administrator.
  • Assisted Developers and Functional Analysts in troubleshooting issues.

Confidential - Atlanta, GA

Senior Consultant

  • Designed and implemented change management policy for corporations across the country.
  • Install and configure Quest STAT to track software changes to the Confidential applications. Built workflows to support corporate change management policies
  • Knowledge transfer the skills necessary to maintain STAT repository to DBA’s and System Administrators
  • Fully documented change management workflow and installation configuration.
  • Conducted formal training classes on the following classes
  • STAT Administration
  • STAT End-User
  • STAT Development

Confidential - Columbus, OH

Senior Database Lead

  • Company converted legacy AS400 Financials into Confidential 11.5.10 applications. Installed, configured and patched 11.5.10.2 Confidential applications
  • Cross trained other DBA’s and developers with Confidential database and development skills.

Confidential - Fairborn, OH

Senior Technical Consultant

  • Analysis and map legacy data to be loaded into the EPB dimensions. Troubleshoot data conversions.
  • Maintained existing 11i environments, including managing database operations, installing patches, and troubleshooting problems
  • Installed new 11i environments to support development and testing operations.
  • Documented installation and operations procedures for the production staff.
  • Responsible for performing SRR Scans/STIG fixes to Confidential 11i environments.
  • Coordinated with other development leads including interfaces, data, reporting, conversion, and architecture leads to ensure that all teams stay in sync with one another and share information throughout the design, development and test lifecycle.
  • Identified risks and issues along with possible mitigation steps for the Technical Manager.
  • Mentored and trained application developers on the software development lifecycle process.
  • Enforced program design, coding, review, and testing standards and procedures.
  • Managed the day-to-day design, develop, and test activities of the team.
  • Installed, patched and configured 11.5.10. Loaded EPB module in preparation for Proof-of-concept demonstration. Worked with the design team on the next spiral of the Air Force Budget Formulation System, tools included Designer 2000 and Rational Rose.

Confidential - St. Petersburg, FL

Senior DBA

  • Confidential Application 11.5.3 thru 11.5.9. Installed, upgraded, patched and supported company Confidential Applications. Provided 7x24 production support to 11.5.9 applications (Finance and Manufacturing). Technical lead on implementing iprocurement and iStore.
  • Extensive performance tuning to maintain Business Owners Service Level Agreements. Constant monitoring and tuning to meet these demands. Tuning included Custom code, Application patches and Database/Server adjustments.
  • Successfully converted 5 legacy systems into one 11i applications to support the North American Finance and Manufacturing operations.
  • Supported company Manufacturing and Inventory data warehouse.

Confidential - Tampa, FL

Consultant

  • Technical Director of Software Development for the PPBES program at MacDill AFB. Team consisted of 10 developers and 2 TQM Analysts.
  • Planning Programming Budgeting and Execution System and Management Information System (PPBES MIS). PPBES MIS is the government financial system that supports the security intelligence group at the United States Special Operations Command. Redesigned the existing PPBES database to enforce the Customers Business Rules and maintain data integrity using Designer 2000.
  • Redesigned a Web-front end for PPBES MIS using developer 2000 toolset. Implemented the database conversion at customer site.
  • Other duties included any installations, upgrades and backup/recovery of Confidential Software. Perform UNIX administration for 3 Sun Servers. Monitor and administrate the development network.

Confidential - Lakeland, FL

Enterprise DBA

  • Maintained and provided 7x24-hour support for all Confidential databases for all facilities worldwide. Upgraded and maintained/backup the production, development and month-end database for Chess (Chess is the corporate financial database that operates 7x24 for Breed Corporation).
  • Installed and Supported Glovia 5 Beta product in Lakeland and Italy. The Glovia databases ran on the HP 10.2 platform. The servers in the US were running Confidential v7.2.3 and in Italy 8.0.5. De-bug, Performance Tuned and backup shop floor database in Lakeland and Mexico. Install, debug and maintain helpdesk database on NT platform.
  • Performed NT administration on this server as well. Used Enterprise Manager with the Performance Tuning Pack.

Confidential - Chantilly, VA

Senior DBA

  • Developed STAT interface and re-engineer Database Design for Data Warehouse using Developer 2000 and Designer 2000. STAT is a statistical analysis tool to help predict the amount of data that will be generated across the WAN so the proper network can be budgeted for in future years. The front-end clients were Windows 95 and NT with the backend server on Sun's or NT.
  • Developed a Web interface to Confidential for the PACMEDNET survey using the Confidential Webserver 3.0. The survey was used to collect hardware and software information from the Government bases. The development was on the NT platform with Production on Sun Sparc Station. Provided full Database Administrator Functions, including Performance Tuning. Database versions 7.3.x on NT 4.0 and Solaris 2.5.

Confidential - Arlington, VA

Enterprise DBA

  • Confidential Financials - Managed Confidential Financials Installations. Installed, Upgraded and Maintained 3 Confidential Financial Databases. Started with Financials 9.x, Migrated to 10.2 and then 10.5. Worked with a team of 3 Systems Analyst and 2 Financial Analysts on customization and reporting requirements. The Confidential database was 7.x. The platform was a Sun Supercenter 1000 running Solaris 2.4. Used Forms 3.x and Developer 2000.
  • CellCAD - CellCAD was a tool used by cellular engineers to design a cellular network. Installed and Debugged Development Databases ( Confidential 7.x and Informix 5.x) on Sun Solaris 2.4 and NT platforms. Installed, Upgraded and Maintained the Corporate NT Domain. Provided 24-hour support on CellCAD and Unix Administration. Provided CellCAD training at the customer site and on-site troubleshooting. Co-authored the training manual for CellCAD software.
  • HelpDesk - HelpDesk is an application used to track customer incidents and their status along with bugs and patches. Led a team of 3 developers in designing and developing a customer support application (HelpDesk) in Lotus Notes 4.x on an NT 4.x platform. The modules included Helpdesk, Bug Tracking, Feature Request and Knowledgebase. Also co-authored the training manual.

Confidential

Technical Specialist

  • OIMD - On-line Incident Management System provided end-users immediate access to customer information in order to make better business decisions. Lead a team of 2 analysts on the design and implementation of OIMD. This was built with Confidential 6.x, SQL forms 3.0 on the A/UX platform. The system provided order tracking, incident reporting, bug tracking, order requests, future release requests and 'Hot-Site' tracking (Sites that are experiencing an above average amount of trouble calls).
  • Technical Support - Provided 7x24 Microsoft Support to the Government as a subcontractor to Microsoft. Products included MS NT, MS Word, MS Excel, MS Access and MS PowerPoint.
  • Technical Support - Provided Confidential and A/UX Support for WWMCCS (World Wide Military Command & Control Services) Community. Provided Microsoft Support to the Government as a subcontractor to Microsoft.
  • Performed in-depth technical analysis, diagnosis and resolution of technical problems particularly pertaining to relational database management, SQL Server and NT. Migrated the Confidential database for the WWS program. Tracked and solved conflicts between multiple vendor products on the WIS Workstation.
  • Developed specialized tools for use in the Customer Support Center. These include templates, training guides, decision support systems and customized reports. Assisted junior level support staff in training of analytical support. Followed up on open incidents and kept the customer informed of status.
  • Eagle - Eagle was a financial application written in COBOL on a Bull Mainframe. Updated and maintained the Traveletter database and updated the mainframe on a daily basis. Created a program to assist the accounting personnel in tracking employee relocation expenses and then compiling the data into a report that meets the Government standards. Both databases were in Dbase and uploaded to Eagle. Assisted with writing the conversion and SqlLoader scripts when this system was eventually replace with Confidential Financials.
  • Developed macros in Eagle that eliminated 93% of the manually generated invoices for Finance and Accounting. Assisted Customer Administrators with data input and queries on Eagle.

We'd love your feedback!