Oracle Apps Dba-security Resume
SUMMARY:
- Over 10 years of varied Oracle project experience. Past projects range from IT to Automotive up to projects for the Olympics. I’ve implement, supported or managed projects for such companies as Ford, MCI, Confidential, Confidential /Visa, Confidential, Confidential and Hitachi. Proficient Oracle E - business Applications DBA; experienced in implementations, upgrades and production support. Accomplished and fluent in the methodologies of project management; managing projects with budgets upwards of 5 Million dollars and 45+ team members. Liaison to clients, meeting to determine new requirements, then planning, implementing and delivering Oracle E-business system integrations.
- Management of client/customer expectations by communicating project status and resolving concerns. Managing team s through open communications, conveying essential information to necessary members; coordinating tasks and responsibilities. Giving expert input when necessary. Review of open issues, action items, facilitating team meetings; and negotiating creative solutions to issues that may impact project timelines.
TECHNICAL SKILLS:
Others Tools: Installation of Oracle Applications R12 and 11iApplication System Administration UMX Oracle User Management RBAC E - Business Security Application of Application and Database patches Maintenance of Applications and Databases (Oracle Application and Custom) 10G iAS Oracle RAC 10g BPEL Installation of Oracle 9i Server on SUN Solaris Development DBA responsibilities including code drop Export and Imports Database Cloning Installation of application development tools and utilities Configuration of SQL Net TCP/IP services for establishing connection between client and server Creation of database users, creation of database roles and profiles Backup and Recovery using Veritas and Oracles RMAN Creation of backup process Performance Tuning RBAC UMX
ORACLE MODULES: Workflow Business Intelligence IPayments Discoverer Administrative Utilities (AD) Alerts Applications Reporting Workflow XML Gateway EDI/e - Commerce Gateway Supply Chain Exchange Inventory IProcurement iSupplier Portal Order Entry OM Suite: Order Management Purchasing Shipping Supplier Scheduling Warehouse Management Applications Desktop Integrator Assets Cash Management Collections Customers Online General Ledger Global Accounting Engine Global Financials Internet Expenses iStore iPayment Multiple Reporting Currencies Payables Benefits HR Intelligence Human Resources iRecruitment Payroll Self-Service HRMS ADI Time and Labor SETS/UTILITIES: Oracle 8i, 9i, 10g 10g Application Server 9i 10g RAC Mobile Server AS Portal AS Mobile AS Wireless AS Web Cache Oracle Financials 11.0.3 - 11.5.10 Adpatch / Adadmin Oracle Enterprise Manager Oracle Developer 2000 Oracle Forms 4.5 / Reports Oracle Designer Discoverer 4.1.47 Business Objects Paradox Access ADI SQL SQL-PLUS Shell ScriptingSYSTEMS/PLATFORMS: Linux R 3, 4.0 HP3000 SUN Solaris 2.6, 2.7, 2.9 Windows 95,97,98,NT,2000 Applications System Administration Applications Technology Stack Concurrent Processing Multiple Organizations Architecture (Multi - Org) National Language Support - NLS Self-Service Web Apps & FrameworkOTHER SKILLS: MS Power Point Word Excel Word Perfect 5.1 - 6.0 Lotus Quartro Pro Quicken Paradox 7.0 MSFrontPage Internet Exporter, Netscape * CC Mail 8.0 / Lotus Notes MCI Mail / MCI Lotus Express IBM Profs, and Auto 8-D Some AutoCAD, and WERS (Often conducted classes for City of Atlanta employees Outlook, Outlook Express
PROFESSIONAL EXPERIENCE:
Confidential
Oracle APPS DBA-Security
Responsibilities:
- Advise and layout plan on Upgrade to 11.5.10 with and Implementation of Oracle UMX. Phase one of implementation starting with OLM providing guidance on how to implement UMX in environment with focus on way forward to implement UMX across additional modules coming in Phase 2. Modules coming online in phase2 to include, Human Resources, Accounts Payable, Accounts Receivable, Inventory, and General Ledger, Phase 3 to follow.
Confidential
Oracle APPS DBA-Security
Responsibilities:
- Conducted an assessment of current User Access Management and their utilization of RBAC for the current Financials implementation and additional modules being sought. Conducted a review of current responsibilities, roles and business processes to assess if the issues around the implementation of RBAC. Delivering an understanding of UMX and RBAC to help client to determine the way forward in its user access management strategy. Client has a projection of more than 15,000 responsibilities. Given that fact, the client wants to pursue a move to a full RBAC and UMX implementation and needed a feasibility study. Reported on the benefits that the client would gain in global implementation of RBAC.
Confidential
Oracle APPS DBA-Security Administration
Responsibilities:
- Phase one in a global Oracle R12 reimplementation of Oracle E-business suite (Current implementation is US and France). With the migration from 11.5.5 to R12 utilization of Oracle’s latest security feature UMX and RBAC. Data Security utilizing MOAC, RBAC and UMX with Oracles Human Resources, Payables, Receivables, Cash Management, GL, Process Manufacturing, Inventory, Procurement, and Order Management. Developing security requirements for global release UMX and RBAC setup and administration. Detailed functional and data security to meet SOX requirements.
- Implemented MOAC allowing for access to more than one operation unit without switching responsibilities or Roles in the new security Model RBAC.
- Complete configuration of definitions of security profiles, global profile, business groups, legal entities (new in R12) Profile options for Business Group settings. Request Group, Request Sets, Menus, Functions, in the new security model permissions, permission sets, and Grants.
Confidential
Oracle APPS DBA-Security
Responsibilities:
- Detailed functional “core security” - (Function Security, Data Security and Role Based Access Control) definitions are required in order to address the Information Assurance Controls ECAN-1 and ECPA-1, as outlined for the Department of Defense. New Implementation of Oracles E-Business Suite 11.5.10. With Single Sign On and Caccard security. Utilization of Financials, Order Management, Mobile Field Services, Contracts, BIS, Workflow, Supply Chain, Developed Security and Design for complex security requirements utilizing RBAC (Role Based Access Control) security and Oracle Workflow for Oracle E-Business 11i for multiple deployed instances with BPEL data sync and Mobile Field Services.
Confidential
Oracle Apps DBA
Responsibilities:
- Restructured and brought back on track failing project upgrades in Oracle Applications 11i environments. Added Single Sign On, iRecruitment, iProcurement, iExpense, Self Service HR, Incentive Compensation, Pay Roll and enhancements to AP, AR and GL modules, Custom Discoverer reports, Interfaces in to Global instance. Patching and Cloning of database instances. Managed out sourced company of Production Maintenance of Oracle Databases and Oracle 11i Application instance by resolving technical issues within both Oracle Applications and 10g environments, Application maintenance and administration.
- System, performance, alert logs and flash recovery area monitoring. Performance tuning and java error resolution. Coordination with other business functional groups affected by applications and changes. Managed implementation of extensions during the global development to go live process. Coordination and management of testing, and migration of extension objects to outsource production support team.
Confidential
Oracle Applications DBA
Responsibilities:
- Installation of Oracle 10g instance and Oracle Applications 11i environments with Mercury’s ITG (formerly Kintana) Implementation. German and French NLS and MLS configurations, and Single Sign On. Maintained Oracle Databases and Oracle 11i Application instance by resolving technical issues within both Oracle Applications and 10g environments. Application maintenance and administration. System, performance, alert logs and flash recovery area monitoring. Performance tuning and java error resolution. ITG application Implementation and Administration. Coordination with other business functional groups affected by applications and changes. Management and coordination of instance strategy and implementation of CLEMI’s during the global development to go live process. Coordination and management of testing, and migration of CLEMI’s/RICE objects through the instance workflow to outsource production support team.
- Installation and configuration of 10g RAC on Dell/EMC SAN. Installation of 10g iAS, Upgrade and Migration of Oracle 9i and 10g databases. Upgrade Migration of Oracle Application 11.5.7, 11.5.8, 11.5.10 from HP-UX, Solaris, and Window 2000 server platforms to Linux.
Confidential
Oracle Applications DBA
Responsibilities:
- Responsible for the smooth operation of DBA support. Management of Oracle onDemand and coordination of instance strategy and implementation of customizations and functional setups during the global development to go live process. Coordination and management of testing, and migration of customizations through the instance workflow to outsource production support team
Confidential
Oracle Applications DBA
Responsibilities:
- Installation and configuration of 10g RAC on Dell/EMC SAN’s and 10g iAS with Single Sign On
- Utilization of Mobile Field Services for All clients above except The FL. Childrens Trust.
- Upgrades and Migration of Oracle 9i and 10g databases.
- Upgrades Migration of Oracle Application 11.5.7, 11.5.8 and 11,5.9 to 11.5.10 from HP-UX, Solaris, and Window 2000 server platforms to Linux.
- MLS, NLS environment conversions.
- Vendor evaluation and package selection processes, assisted in the creation of market analysis, RFI / RFP, gap analysis, evaluation scorecards, and solution recommendations.
- Identified and managed scope of the project while capturing functional, technical, and requirements. Using a variety of techniques interviews, surveys, business process engineering, joint application development (JAD) sessions, case and scenario development.
- Collaborated with project team in requirements prioritization.
- Ensured that requirements matched deliverables and met the needs of stakeholders..
- Defined system attributes, external interfaces, constraints, and other non-functional requirements.
- Escalated issues and barriers to Stakeholders.
- Maintained requirements in repository
- Coordinated approvals and sign-offs of key deliverables.
- Reviewed quality assurance and technical documentation to ensure they satisfy the business requirements.
- Served as knowledgeable resource to stakeholders and other IT associates regarding product capabilities, business processes, change impacts, and integration with other systems.
- Installation and configuration of 10g RAC on Dell/EMC SAN’s and 10g iAS
- Upgrades and Migration of Oracle 9i and 10g databases.
- Upgrades Migration of Oracle Application 11.5.7, 11.5.8 and 11,5.9 to 11.5.10 from HP-UX, Solaris, and Window 2000 server platforms to Linux.
- Installation of Oracle 10g Application server with web cache
- Racking and Installation EMC SAN .
- Installation of Oracle 10g RAC on Linux EMC SAN.
- Installed Oracle Applications 11.5.10
Confidential
Oracle Applications DBA (remote support)
Responsibilities:
- Install and configuration of Oracle Applications E-business suite 11.5.10 in a Linux environment. Installation of Oracle Apps iStore and configuration of ipayment to work with the Student Baan application.
Confidential
Oracle Apps DBA \Technical Project Manager E-Learning
Responsibilities:
- RFP process
- Gap analysis and Process Development
- Vendor Evaluation and Due diligence
- Management of
- Definition and design of business processes
- Configuration of application software to support processes
- Managed the mapping of t o Map existing data to new system
- Development of test plans and scripts f business process owners and end users f system processes, software, data and users
- Change Control
- Sarbanes/Oxley adherence
- IT architecture policies
Confidential
Oracle Applications DBA
Responsibilities:
- Created testing plan and schedule for implementation and deployment of upgrade
- Managed collection of testing scripts and functional business practice critical to business continuation.
- Application security audit including Sarbanes/Oxley preparations
- Managed the testing and resolution of functions after upgrade.
- Audited systems module by module to record an accurate accounting of customizations in systems.
- Audit and Reconciliation of Production and Development systems to achieve an accurate accounting of Customizations currently in Development and not in Production.
- Post Audit Managed customization movement via Kintana
- Audited Issues Database “RICE” and Drove resolution of open issues and outstanding issues
- Managed new issues and desired customizations.
- Prioritized task and project plan to align with corporate goals reducing resource and development costs.
- Provided technical guidance for program personnel and project guidance and direction to development team.
- Managed project activities, and assignment of tasking to program personnel. Supervised on-going technical efforts while managing project performance.
Confidential
Oracle Apps DBA
Responsibilities:
- Implemented Oracle E-Business 11.5.9 implementation that encompassed the e-business suite Including AP, AR, GL, HRMS, Self Service, CRM,, XLM-Gateway, Supply Chain, Order Capture, Advance Planning /Scheduling and a with special emphases on Discoverer, Workflow, iProcurement, and BIS. Provided a wide range of technical data management across 4 instances. Responsibilities include maintaining, tuning, and monitoring the operating efficiency and technical integrity of database management systems. Creating and maintain database environments for development, quality assurance, integration, integration II, interfaces, conversion, patch, test, and production. Synchronization of all database environments via cloning. Managing and installing database and application software via rapid install and upgrades via adadmin. Monitoring and participated in capacity planning and space management.
- Provided backup and recovery, disaster recovery, and problem resolution. Including disaster recovery via standby database. Interacting with and supporting internal business software development personnel and external vendors. Worked with developers to develop custom applications and interfaces in CUST TOP. Assisted project teams in an Oracle 11.5.9 E-business suite implementation. SOX security audit and prep.
Confidential
Oracle Apps DBA / Manager
Responsibilities:
- Managed code drops and deployment of product and development support of oracle 8I databases for a customized real time banking financial application. Installation, maintenance, and support of Oracle E-Business Suite 11.5.5 in a Multi-Org and Multi-Currency, MLS and NLS enabled environment. Making use of AP, AR, GL, and FA. Deployed and maintained production and development Oracle8i databases supporting a customized application, using High Availability Veritas Clusters, Oracle Hot Standby, Oracle Enterprise Manager, and Veritas, Netbackup with Oracle Recovery Manager. Enhanced system security through the use of Oracle's standard and advanced security features. Performed Oracle8i upgrades throughout development, qa, test, and production environments. Maintained and documented roles and user accounts, database tablespaces, tables, and indexes, packages, PL/SQL packages and procedures, and database triggers.
- Ensured daily backups, during development and production. Provided rotating 24x7 on-call support. Prepared instructional materials for many of the systems structure. Daily duties included reporting status of Databases to ensure they are up and running. Reporting and inspection of alert logs, tablespace monitoring, and partitions that span 10 instances. Reported on procedures, policy and status of Oracle databases in a 24x7 production environment (backup/recovery, instance cloning, database security, database tuning and tablespace management, performance tuning). Gained experience on a large-scale integration project Developed and maintained project plans. Made recommendations, and maintained the resource budget for additional staffing to meet project deadlines. Assed the performance of staff and interfaced with upper management, clients, and subcontractors. Monitored subcontractor's activities to ensure compliance with spend plan and schedule.
- Provided overall project guidance and direction to the development team through both the CIO and CTO. Provided technical supervision and guidance for all program personnel. Managed .project activities, and assignment of tasking to program personnel, supervising on-going technical efforts, and managing program performance. Established and Negotiated work schedules, defined task assignments, risk assessments and risk mitigation strategies.
Confidential
Oracle Apps DBA
Responsibilities:
- Managed several project implementations of Oracle Applications. Met with clients to ascertain their needs and requirement for Oracle, and Oracle Financials installation. Supported client and Installation team throughout the installation, maintenance, and support of Oracle Financials, and HR in a Multi-Org and Multi-Currency environment. Use of AP, AR, GL, INV, FA, Discoverer, Workflow, and BSI (Business Service Intelligence). Reported on the Installation and maintenance of four Instances of 11i Financials Applications on Sun Solaris. Created and maintained reports of roles and user accounts, database tablespaces, tables, and indexes. Outcomes of daily backups, during development and production. Reported on necessary recovery after development test to successfully support Financials Go Live. Key player in procuring Oracle Database products to power company's internal systems and client needs.
- Participated in and heavy relied upon in company for decisions in regard to Oracle products only person in the company who'd work with oracle products prior to purchase). Helped in contract negotiations with Confidential . Including giving recommendations on products to purchase, number of license to purchase. Company resource on abilities of products to fulfill customers (internal and external) needs. Worked on a development team that created all internal systems for company. Main player in the Data Architecting of company internal systems such as Trouble ticketing, Workflow, Customer Network Management system
- Company Intranet, all are powered by Oracle 8i database. Installed five production Oracle 8i production databases on Sun Solaris. With fifteen test and development systems. Responsible for five customer production instances. Including Backup and Recovery, Disaster Recovery, Performance Tuning, and SQL analyzation at customer request.
Confidential
Oracle DBA
Responsibilities:
- Managed the development of a Web base infrastructure planner and move application using Oracle Forms and Reports. Coordinated with Developers and to create database procedures, triggers, and PL/SQL packages. Coordinated with Sr. DBA to create new views as needed for application. Users input hypothec information and viewed output for expected growth to aid in pre-planning space needs for new hires.
- Facilities planners used system to prepare for growth expectations and to view current space restrictions. Maintained documentation of created and maintained, roles, user accounts, database tablespaces, tables, and indexes, packages, PL/SQL packages and procedures, and database triggers. Ensured daily backups, during development and production.
Confidential
Applications Engineer/ Oracle DBA
Responsibilities:
- Responsibilities include maintenance of Traceability, a central data repository that traces product configuration along the supply chain. ATM (Automated Tracking Machine) used to track bugs (flaws) during the development process. Areas of maintenance include disaster recovery and/or system failure, user lockouts, project creation, creation of tables and links to be used with query tool. Work with Sr. Programmers to correct software errors and implement changes to programs. Assist in enhancement to business applications. Write and revise user manuals and procedures via visual displays. Convert data from project specifications and statements of problems to applications, and to maintain and modify application. Confer with supervisors and representative of department concerned with program to resolve questions of application intent, data input, output requirements and inclusion of internal checks and controls.
- Provide technical assistance to technicians in application setup and configuration. Enter code changes into system to correct errors. Analyze performance indicators, such as system’s response time, number of transactions per second, and number of program being process at once, to ensure that application is operating efficiently.
Confidential
Project Manager / DBA
Responsibilities:
- Launched a pilot project at/for the 1996 Olympics for Visa. Liaison to Vice President of card products, Visa, Olympic Venue management, and four Area Card Product Sales Directors in the implementation of sales and marketing plans for Visa Cash stored value. Successfully managed project generated the sale, distribution and installation of 5000 point of sale locations and one million disposable smart cards that yielded 3.2 million in national sales. Managed a team of administrative support staff, 8 teams, and 12 technicians. Indirectly supported a national sales team. Liaison between client merchants and VP; as a liaison between suppliers, installers, technicians, and VP. Created, developed, and implemented an equipment and merchant, distribution, reporting, and tracking system for merchant support, installation, and maintenance. Planning and implementation of on site promotions and live remotes for the sales and marketing plans for
- Data maintenance and installation planning for 5000 point of sale locations 380 CDM (card dispensing machines) that yielded 3.2 million in national sales. Acted as a liaison between client merchants and VP, as well as a liaison between suppliers, installers, technicians, and VP. Created new designs and layouts for card promotions and marketing strategies. Created, planned and organized live remotes and card giveaway marketing events. Monitored and managed field installation efforts. Evaluated work and performance progress of filed technicians. Assessed technical, cost, and scheduled performance as they related to the overall project objectives. Reported and coordinated the client's management team ensuring that the project objectives were met. Managed the relationship between client(s) and potential clients. Preparing written and verbal project reviews. Created reports and presentations for management and customer review as required. Additional responsibilities included supervision of administrative support staff, 8 teams, and 12 technicians.
Confidential
Engineering Design Change Control Coordinating Analyst
Responsibilities:
- Analyzed proposals and change request. Made clear and decisive decisions on the feasibility and necessity of engineering design change for 150 engineers on the DN Taurus and Sable line. Orchestration of presentations and live and recorded media coverage of the launching of the DN Taurus and Sable) including written and printed material (on-line presentation, brochures, etc.). Coordinated with other Analysts in the planning of Vehicle Drive test, endurance testing and wind noise testing necessary to get to JOB1. Maintained Engineering Design Change Control, Fit & Finish databases and Concern Matrix for Body, Chassis, & Powertrain. Timely issued Change Control reports and counts. Entrusted with the responsibility of coordinating with air traffic control, and scheduling flights of the company plane.
Confidential
Human Resources Coordinator
Responsibilities:
- Processed of new hires for MCI Business National and International Accounts. Posted and maintained job openings for National Accounts Division. Created relocation and new hire packages that are currently used throughout the company.
- Co-authored created Human Resources manual. Conducted sessions for Recruiters, and Hiring Managers. Composed offer letters to new hires, scheduled drug testing, coordinated background investigations, and was privy to confidential information.
Confidential
Business Manager
Responsibilities:
- Administrative responsibilities included customer service, human resources, data entry, accounts payable, accounts receivable, and duties as a buyer (having direct interaction with vendors), obtained quotations, examined bids, initiated purchases, established strong credit histories and traveled to seek out new products. Updated system with new products and/or product changes. Collaborated with CEO and CFO to create a viable support system. Created resources necessary to resolve service and/or billing problems. Prepared proposals and interfaced with advertising agencies. Handled new high-end accounts ensuring customer satisfaction.
- Conducted courses. Created and implemented successful stress reduction program. Analyzed reports and utilized information to implement necessary polices to ensure increased revenue. Prepared, projected and completed sales reports on a daily, weekly, monthly and quarterly basis. Responsible for the supervision of 12 store employees.