Worked closely with release managers to analyze and improve change management procedures CCC Harvest

• Application user creation / responsibilities assignment
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Created and managed the Database objects and schemas. Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re - schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Created a number of database instances for development, testing and production.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc. Applied RDBMS patches using Opatch
• Lead implementer of Oracle Order Entry, Oracle Receivables, and Oracle Sales and Marketing,, Responsible for application setups, testing, and end user training.
• Responsible for Oracle application setups, testing, and end user training.
• Oracle EPR Company Project Lead for Oracle Order Entry and Oracle Receivables.
• Responsible for managing all company invoices.
• Responsible for managing the processing of all company orders.
• Manager of Order Administration and Pricing, including 5 direct reports.
• Database migration from Oracle 9i to 11i, Copy/Clone of Oracle application environment using Rapid clone, Database Refresh
• Upgraded Oracle Applications from 11.5.7 to 12.00, Installation of Oracle 12G

Tasks : Functional Oracle E-Business Suite Analyst Consultant - IT. Working 50 Functional and 50 Technical within Oracle Applications. Environment: Oracle E-Business Suite R11i Installed Base CSI, Service Contracts/Contracts Core OKS/OKC, Trading Community Architecture TCA, Accounts Receivable AR,

Role: Oracle DBA, Project management, analysis, implementation, Oracle CRM support, Oracle Apps Consultant, Implementing CRM modules into the existing R12 instance, Interfacing data to external third party systems.

Platform: Sun Solar / HP Unix / IBM Unix

Subject: Analysis and Definition for implementation of Ebusiness Suit 12I, Implementation of 10g and RAC

Job: Freelancer

• Business: Designs and produces programmable logic devices PLDs, and software tools for these devices. Provides world-wide solutions, support, and service for PLDs.
• Implemented Oracle Customers Online OCO/IMC module. This included enabling Data Sharing and Security DSS for OCO and Customer Standard in AR so that users would not be able to modify restricted data as per SOX requirements
• Post-production troubleshooting and analysis of business process issues within: Service Contracts OKS, Install Base CSI, and TCA/Customer Master. Gather requirements, write functional MD050 and technical MD070 specifications, provide recommendations for user challenges, and implement process and system modifications. Utilized Oracle's Application Implementation Method AIM approach, and documented the process using AIM guidelines. Business: Designs and produces programmable logic devices PLDs, and software tools for these devices. Provides world-wide solutions, support, and service for PLDs.
• Short-term resource augmentation to assist with the implementation of Oracle E-Business Suite R12 system. Working in most of the mid-project business analyst tasks:
• a Performing Configurations, b Writing up functional specifications for conversions, interfaces, and reports by working with users on requirements and creating high-level technical design documents, c Generating test scripts,
• d performing tests prior to user approval and
• e Producing training materials, etc.. This phase of the project focuses on implementing a set of the Oracle CRM modules such as Tele service /Case Management CS and Install Base CSI

Project Characteristics: Implementing CRM modules into existing R12 instance

• Interfacing data to external third party systems.
• Analysis and Definition for implementation of Ebusiness Suit 12I, Implementation of 11g and RAC
• Analyze, design and data model solutions for business needs in cooperation with various levels of business and systems personnel.
• Perform database analysis, design, coding, testing and implementation of database structures.
• Functional consultant to implement AP, AR, GL, PO, INV, CM andmodule.
• Experience in Distribution, Manufacturing, and Financials: Order Management OM/OE/ONT, Shipping Execution WSH, Inventory INV, Bill of Materials BOM, Spares Management CSP, Field Service CSF, Electronic Commerce/EDI Gateway EC, Accounts Receivable AR, Customer Intelligence OCI/BIC, Accounts
• Payable AP, General Ledger GL, Purchasing PO
• Handle 20 UNIX box with 200 TB size of database.
• PeopleSoft Infrastructure Design
• PeopleSoft System Maturity
• Infrastructure Upgrades
• PeopleSoft Upgrades
• Integration Setup between PeopleSoft and Non-PeopleSoft applications
• Shell Scripting and Control-M batch Design
• PeopleSoft Performance Tuning at various tiers
• Regular PeopleSoft Admin activities
• PeopleTools 8.49/8.50, PeopleSoft HCM 9.0/FIN9.0/CRM9.0/Portal9.0/Portal9.1
• Oracle 10g, Solaris 10, WebLogic 9.1, OBI, Control-M, i3, HP PPM ITG
• Implementation of 10g and RAC
• Upgraded Oracle Applications from 11.5.7 to 12.00, Installation of Oracle 10G
• Customers receive licensing information from a custom licensing web portal data interfaces from Oracle Install Base IB to this portal so it can presented to customers .
• Worked with Application Developer on data conversion for Installed based and Warranty information for previous Oracle transactions and third party source information.
• Upgrade/Regression Testing 11.5.6 to 11.5.8 including multi-org Order Management, Inventory, Purchasing, Accounts Receivables.
• Trained super-users and end-users on CRM application functionality.
• Created CRM Training/Desktop Documentation and Integrated Test Scripts.
• Project Manager for implementation.
• Implemented/Configured/Tested Oracle Depot Repair including Installed Base: Multiple Repair Types.
• Implemented/Configured/Tested Oracle Service Contracts: Service Items, Usage Items, Warranty Items, and Counters.
• Implemented/Configured/and Tested Oracle Tele-Service: Multiple Request Types, Tasks, and Service Charges, 11.5.8
• Provides new and certified re-use telecommunications and networking equipment to help you manage and expand your network infrastructure.

Project Characteristics: Interfacing new orders from Siebel into 11i Order Management OM Customer information interfaces to/from Siebel and 11i via an Oracle Customer Data Hub CDH system Service Contract SC renewals are quoted/processed in Siebel where the information about the prior year's SC products pricing is systematically pulled from the 11i SC module When SC renewals are ready to bill, information is submitted from Siebel into 11i SC and billed in 11i AR.

• Working in the same role on a follow-on project to update the licensing model within all of Wind River's internal business systems Oracle E-Business Suite 11i and Siebel .
• Designing changes to the existing Oracle Applications E-Business Suite R11i system and it's related custom sub-systems including Siebel and a custom licensing customer portal . Executing the full project life cycle: requirements gathering, design, configuration changes, technical specifications, generating test scripts, documentation, training, etc.. Primary Oracle modules involved: Contracts/Service Agreements area Service Contracts and Contracts Core OKS/OKC and Install Base IB/CSI . Also considering impacts to: TeleService CS, iSupport IBU, and Customers Online OCO/IMC .
• Project Business Objective: Automate the sales of software TERM licenses within Oracle.
• Platform: Sun Solar / HP Unix / IBM Unix
• Role: Project management, analysis, implementation, Oracle CRM / HRMS and Oracle E-Business
• Suite Techno Functional Lead. Working 50 Functional and 50 Technical within Oracle
• E-Business Suite.
• Tasks: Environment: Oracle E-Business Suite R11i 11.5.9 Service Contracts/Contracts Core OKS/OKC, Installed Base CSI, Siebel, Oracle 9i: PL/SQL, SQL. Toad, Windows XP. Business: Designs, produces, sells, and supports embedded software products.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• Review database access code and recommend tuning opportunities.
• Write code to access database.
• Advise less experienced team members in all phases of the assignments and assist in the coordination of team activities. Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Install, test, evaluate, implement and maintain DBMS related system software and tools.
• Design and implement database backup and recovery procedures RMAN .
• Monitor and tune database performance including SQL tuning. Implement effective database security practices and procedures. Implement complex enterprise changes as they pertain to the database environment.
• Develop, document and enforce database standards and procedures.
• Maintain and improve high availability and disaster recovery.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.
• Load and extract formatted data in and out of database ETL .
• Migrate data to other databases
• Recover lost databases.
• Database storage management.
• Finest granularity approach to Oracle implementation and de fragmentation.
• I/O distribution analysis.
• Capacity planning, capacity monitoring and management.
• Perform transaction-sizing measurements.
• Managed day-to-day production databases.
• Possess a thorough understanding of Oracle fundamentals, concepts, utilities and applications.
• Seasoned experience with Unix and a strong ability with Unix shell scripting.
• Experience working in large database environments.
• Calculate disk space requirements.
• Oracle's Enterprise Manager OEM, Stats pack Reports, Explain Plans, SQL Trace and TKPROF.
• Data guard, upgrades, patches, partitions, RAID arrays, etc.
• Oracle SQL Net Network Configuration.
• Installing and configuring the applications on multi node.
• Applications Upgrading, Cloning and Patching.
• Performance Tuning of Applications and database
• Functional consultant to implement AP, AR, GL, PO, INV, CM and

Worked closely with release managers to analyze and improve change management procedures CCC Harvest

• Handle 20 UNIX box with 200 TB size of database.
• Experience in Distribution, Manufacturing, and Financials: Order Management OM/OE/ONT, Shipping Execution WSH, Inventory INV, Bill of Materials BOM, Spares Management CSP, Field Service CSF, Electronic Commerce/EDI Gateway EC, Accounts Receivable AR, Customer Intelligence OCI/BIC, Accounts
• Maintenance Strategy for PeopleSoft HCM and CRM Environments
• Implementation of Application and PeopleTools bundles, Maintenance Packs
• Integration Setup between PeopleSoft applications
• PeopleSoft Installation, Build and Configuration
• Various PeopleSoft Configuration like Report Manager for List/Explorer view, WSRP,
• App Server Fail-over, App Server Fail-over for IB etc
• Troubleshooting handling customer cases to resolve PeopleSoft issues
• Unix Shell Scripting for PeopleSoft Admin activities.
• Implementation of 10g and RAC
• Upgraded Oracle Applications from 11.5.7 to 12.00, Installation of Oracle 10Gi
• Interface 11i OM order and 11i SC renewal entitlement information to the system providing electronic software downloads to customers Digital River Interface 11i AR invoices for both orders and SC renewals to Siebel system for use in technical support and reporting.
• Re-implement entire Order-To-Cash OTC process for both: A new software license sales perpetual licenses and term licenses so that Oracle 11i OM is used, as well as B maintenance/service agreement quoting and renewals so that 11i Service Contracts is used.

Project Characteristics :

• Planned and implemented the data conversion methodology and programs to bring Installed Base IB instances software licenses and Service Contracts SCs service agreements and maintenance from a legacy system into the Oracle 11i application. Designed an interface to send entitlement information from SC/IB/OM Oracle 11i to Digital River for Electronic Software Download entitlements and to Siebel for support entitlement verification .
• Techno-Functional lead analyst on the project to implement TIBCO's Maintenance Renewal process into the Oracle 11i application. Charged with all tasks related to implementing the Service Contracts SC/OKS/OKC and Install Base IB/CSI modules: gathering business requirements, identifying gaps, design solutions to resolve gaps in the standard Oracle system, configuration/setup, testing, training, and all documentation.
• Ebusiness Suit 12I, Implementation of 10g and RAC

Platform: Sun Solar / HP Unix / IBM Unix

Role : Oracle E-Business Suite CRM Business Analyst Consultant - IT. Working 70 Functional and

• 30 Technical within Oracle E-Business Suite. Project management, analysis, implementation, customer support, Oracle Apps DBA.

Tasks : Environment : Oracle E-Business Suite R11i 11.5.10 Service Contracts/Contracts Core

• OKS/OKC, Installed Base CSI, Oracle 9i: PL/SQL, SQL. Toad, HP ITG Mercury, BMC Service Request Management, CCC/Harvest CA Software Change Manager, Windows XP.

Business : Develops and sells integration software.

• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• Review database access code and recommend tuning opportunities.
• Write code to access database.
• Advise less experienced team members in all phases of the assignments and assist in the coordination of team activities.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Install, test, evaluate, implement and maintain DBMS related system software and tools.
• Design and implement database backup and recovery procedures RMAN .
• Monitor and tune database performance including SQL tuning.
• Implement effective database security practices and procedures.
• Implement complex enterprise changes as they pertain to the database environment.
• Develop, document and enforce database standards and procedures.
• Maintain and improve high availability and disaster recovery.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.
• Load and extract formatted data in and out of database ETL .
• Migrate data to other databases
• Recover lost databases.
• Database storage management.
• Finest granularity approach to Oracle implementation and de-fragmentation.
• I/O distribution analysis.
• Capacity planning, capacity monitoring and management.
• Perform transaction-sizing measurements.
• Managed day-to-day production databases.
• Possess a thorough understanding of Oracle fundamentals, concepts, utilities and applications.
• Seasoned experience with Unix and a strong ability with Unix shell scripting.
• Experience working in large database environments.
• Calculate disk space requirements.
• Oracle's Enterprise Manager OEM, Stats pack Reports, Explain Plans, SQL Trace and TKPROF.
• Data guard, upgrades, patches, partitions, RAID arrays, etc.
• Oracle SQL Net Network Configuration.
• Installing and configuring the applications on multi node.
• Applications Upgrading, Cloning and Patching.
• Performance Tuning of Applications and database
• Functional consultant to implement AP, AR, GL, PO, INV, CM and iProcurement module.
• Worked as PeopleSoft Administrator and Oracle DBA for production environments
• Installed various PeopleSoft Applications such as HCM, FSCM, CRM, Portal, EPM
• Implemented Maintenance Packs Bundles, PeopleTools Upgrades, Tax Updates, POCs,
• DST patches and Oracle database patches
• COBOL Compilation in Linux environment
• Performed Database Backups Cold/Hot/Export and Recovery
• Performed frequent Database Refreshes and Cloning
• Day-to-day PeopleSoft admin activities to support Production environments
• Troubleshooting handling customer cases to resolve PeopleSoft issues
• Functional consultant to implement AP, AR, GL, PO, INV, CM and iProcurement module.
• Managed coordination of application interfaces
• Provided 24/7 support and attended daily production status meetings
• Rendered assistance and training to database and development staff
• Migrated and/or implemented 11 9i RAC environments to 10g RAC.
• Utilized daily Oracle 10g grid, Tivoli monitoring, Change Management, and Software deployment tools
• Improved Partition Management and object statistic gathering

Worked closely with release managers to analyze and improve change management procedures CCC Harvest

• Implemented/Configured/Tested Oracle Install Base, Assisted with Oracle Contracts/Service Contracts. Created CRM Training/Desktop Documentation and Integrated Test Scripts. Trained super-users on CRM application functionality. Regression Testing 10.7 to 11.5.9 OM, INV, PO, AR. Worked with Application Developer on data conversion for Creating Service Requests, Install base and Contract/Warranty information.
• Implemented/Configured/and Tested Oracle Field Service: Service Requests, Tasks, Assigning Resources, Debrief, and Charges, 11.5.9
• Analyzed application performance and performed and coordinated OS, network, database, procedural, and application improvements, Analyzed and implemented improve database monitoring
• Performed and coordinated action plan tasks to improving production reliability and performance
• Performed and coordinated production activities between national and offshore DBA teams for day-to-day management 24 environments
• Applied and managed the application of DDL and DML patches daily
• Oracle Team Lead for 6 Oracle Financial Production environments, plus dev, QA, and other environments
• Analyst on a project to deliver Advent's software to customer as Electronic Software Downloads ESD . Working on integration between Oracle Applications and Intraware's SubscribeNet Electronic Software Delivery Solution
• Functional lead on the Oracle 11.5.8 to 11.5.10.2 upgrade project for the following areas: IB, SC, Advanced Pricing, and integration of Oracle to ONYX CRM.
• Functional lead on the Phase 2 project which will deliver a number of Service Contract enhancements, as well as preparing the system to interface data to a data warehouse OLAP .
• Working as a business analyst for the final 6 months of a project to expand the implementation of Service Contracts SC/OKS/OKC and Install Base IB/CSI . Involved in testing both standard functionality and custom functionality, working with Oracle on bugs, developing new business processes, writing training documentation, and configuring the application during go live.
• Manage programs in the Application Object Library AOL/FND that run all above processes, transfer files to and from Kmart, and have incoming files properly loaded into the Oracle Applications database Concurrent Manager .
• Changes to UNIX shell scripts that send files via an electronic messaging system EMS .
• Maintenance of custom returns processing code PL/SQL, SQL Loader . This code tracks the final disposition of returns salvage, charity, return to vendor, and associates inventory adjustments with accounting codes so costs can be tracked in the General Ledger GL .
• Trouble shooting of order and customer import into Oracle Applications from a web storefront database. Process uses the standard Order Import and Customer Import as provided by the Oracle Applications, in addition to custom built extensions.
• Implemented changes to the custom interface PL/SQL that sends pick tickets from the OE/OM module based on the delivery shipping model WSH to a vendor's warehouse management system WMS . Extensive architectural changes and enhanced error checking. Also enhanced the custom ship confirmation process which takes ship confirmations from the vendor's WMS, and loads them into the standard Oracle Applications interface tables Open Shipping Interface so the data can be populated via the standard Oracle API into the OE/OM module. This process also includes custom code to store multiple tracking numbers.
• Enhancements to a custom system that automatically creates Return Material Authorization RMA orders within the Order Entry/Management OE/OM module. Implemented a front end for internal users in Forms 4.5. Major revisions to the process which creates the RMA after many validations against various data including original order and invoice, previous adjustments and returns, and restocking fees so that the process automatically without user intervention receives the return into Inventory INV, and pushes the appropriate credit memo to Accounts Receivable AR, and creates the payment in Accounts Payable AP PL/SQL .

Environment : Oracle E-Business Suite R11i 11.5.10 Installed Base CSI, Service Contracts / Contracts Core OKS/OKC, Order Management OM/ONT, Inventory INV, Oracle 9i: PL/SQL, SQL. Toad, Windows XP.

Business: Develops and sells investment management software and portfolio data services.

Role: Oracle E-Business Suite Consultant Consultant - IT. Working 50 Functional and 50 Technical within Oracle Applications. Project management, analysis, implementation, customer

• support, Oracle Apps DBA. Analysis and Definition for implementation of Ebusiness Suit 11I, Implementation of 10g and RAC Environment: Oracle Applications R11 Order Entry/Management OE/OM, Accounts Receivable AR, Inventory INV, Accounts Payable AP, Purchasing PO, Application Object
• Library AOL/FND, Concurrent Manager, Flexfields, Oracle 8, 8i: PL/SQL, SQL,
• SQL Loader, Developer/2000, Forms 4.5 . UNIX Sun, Windows 2000, ClearCase,
• ClearQuest, TOAD, DBArtisan, Korn/C/Bourne shells.

Business: E-Retail B-to-C web storefront sales direct to end customers.

• Provided overall Production and Implementation Support for PeopleSoft Application
• Integration and Solutions on RAC environment. Administered the PeopleSoft Internet Architecture PIA . Setup, configuration, analysis and monitoring of production servers using PeopleSoft. Performance monitor, Assisted Real Architecture Cluster Oracle RAC implementation team Oracle 9i and oracle 10g 4-Node RAC Implementation in HP-UX . Performed Database Backups Cold/Hot/Export and Recovery. Performed Database Refresh and Cloning. Performed Database Upgrade from Oracle 9i to Oracle10g. Implemented MPs, Bundles, POCs, Oracle Database patches Installed PeopleSoft Applications FSCM 8.8, HCM 8.9 CRM 8.8 on PeopleTools 8.45/46 Installed PeopleBook and UPK Help Provided 24x7 on-call support.
• Managed Oracle Applications Concurrent Manager which processes 15,000 requests daily

Business : Develops and sells virtualization software. Designs and produces programmable logic devices PLDs, and software tools for these devices. Provides world-wide solutions, support, and service for PLDs.

• Customer Care CSC, CRM Foundation JTF, Application Object Library AOL/FND, Concurrent Manager, Flexfields, Oracle 8i: PL/SQL, SQL. Toad, Windows 2000 Oracle 9i: PL/SQL, SQL. Toad, Windows XP.

Task : Environment: Oracle E-Business Suite R11i 11.5.10 Service Contracts/Contracts Core OKS/OKC, Installed Base CSI, Order Management OM/ONT, Inventory INV, Bill of Materials BOM, Trading Community Architecture TCA, Service Contracts/Contracts Core OKS/OKC, Installed Base CSI, Order Management/Entry OM/OE, Accounts Receivable AR, Service Requests CS, iSupport Self-Service IBU,

Role : Oracle E-Business Suite CRM Business Analyst Consultant - IT. Working 50 Functional and 50 Technical within Oracle E-Business Suite. Project management, analysis, implementation, customer support, Oracle Apps DBA.

Subject : Analysis and Definition for implementation of Ebusiness Suit 11I, Implementation of 10g and

Platform : Sun Solar / HP Unix / IBM Unix

• Analyze, design, configure, test, and implement a pilot project to re-architect Xilinx's existing customer model into the Oracle 11i TCA Trading Community Architecture framework. Insure that TCA is implemented correctly, and new customers are structured properly, so that: 1 existing functionality and business processes in the areas of Orders, Contracts, Installed Base Instances, and Invoices are improved, and 2 future CRM module implementations can take advantage of this new TCA framework. Performed prototype implementations of the following CRM modules in an 11.5.9 instance: iSupport IBU, Service Requests CS, Customer Care CSC, Customers Online OCO/IMC, and CRM Foundation JTF .
• Post-production troubleshooting and analysis of Service Agreements/Contracts including Service Contracts and Contracts Core OKS/OKC modules, Install Base CSI, TCA, and tax issues with Contracts AR . Full life-cycle from requirements to specifications to testing to deployment using Oracle's AIM approach.
• Custom development to call standard APIs in the Installed Base CSI and Contracts OKC/OKS modules. This custom process updates installed base instances and contract records to reflect correct ownership information for drop ship orders PL/SQL .
• Design, prepare, and conduct workshops and training sessions for Service Contracts OKS module users to provide them with short cuts and point out lesser-known features so they can improve their day-to-day productivity.
• Delivers voice and data communications solutions for customers of all sizes including Voice over Internet Protocol technology, platforms and centric systems. Implemented / Configured / and Tested Oracle Depot Repair: Service Requests, Repair Orders, Sales Order Generation, 11.5.9. Implemented/Configured/Tested Oracle Install Base. Created CRM Training/Desktop Documentation and Integrated Test Scripts. Trained super-users on CRM application functionality.
• Analysis of system and process improvements allowing users to perform more transactions, in less time, with better quality. Areas researched include: Oracle Customers Online OCO/IMC module, TCA framework, Service Contracts templates, and other CRM areas.
• Techno-Functional consulting on the project to implement VMware's Order to Cash process into the Oracle 11i application. Charged with all tasks related to implementing the Service Contracts SC/OKS/OKC and Install Base IB/CSI modules: gathering business requirements, identifying gaps, design solutions to resolve gaps in the standard Oracle system, configuration/setup, testing, training, and all documentation.
• Designing and implementing the data conversion methodology to bring Installed Base IB instances and Service Contracts SC from a legacy system into the Oracle 11i application. Designing an interface to send entitlement information from SC/IB Oracle 11i to Siebel so those can be used by the support organization to verify a customer's right to support.

Project Characteristics: Converting customers from 3 legacy systems cleansing customer data with Dun and Bradstreet services.

• Interfacing Install Base and Service Contract information from 11i to a customer web portal and to a Siebel system for Service Request entitlement and tracking.
• Implementing iStore as part of this Order to Cash process this allows customer to place orders product and services on the web.
• Provided support for 34 production, test, development Oracle Apps 10.7, 11 and 11i environments across 10 EU countries. Oracle RDBMS versions 7 10g.
• Administered and Monitored Oracle Standby Server Data guard for production
• Pilot tested RAC 10g. Installed, configured, and maintained Oracle Application Server 10g Portal 10G, and CMSDK for 400 EU users.
• Provided user and developer support and training
• Created Oracle to Oracle database links and Oracle to SQL Server links using gateways
• Ran update scripts and performed other migration tasks for migration of SQL scripts forms, reports, and etc to production and test environments.
• Performance tuned and troubleshot SQL and PL/SQL
• Performed routine DBA tasks on 29 SQL Server 2005 databases including backup and restores
• Implemented new SQL Server environments for new applications.
• Routinely performed Oracle Application administration tasks using AD utilities adamin, adpatch, adclone, adrelink
• Implemented and setup Oracle Application Desktop Interface ADI .
• Apache Administration
• Performed database restores and cloning
• Functional consultant to implement AP, AR, GL, PO, INV, CM and iProcurement module.
• Installed and configured Deutsche Bank software for the transmittal of payments and reconciliation
• Design, Planning, Creation and Administration of PeopleSoft Instances
• Installation, Configuration and Maintenance of PeopleSoft Applications
• Applying Bundles - PeopleSoft Finance Application, PeopleTools and Oracle Patches.
• Application Server Load Balancing and Fail-Over Testing
• Application Server and Batch Server Level Traces
• SSL Secure Socket Layer and RPS Reverse Proxy Server Implementation
• Project Migration, Data Mover, Application Designer, Configuration Manager
• Cobol Compilation on Windows and Unix
• Contributed to define/implement technical and procedural standards for refresh
• database environments
• Application Messaging Setup ESA-HCM Interface
• Orders for new Service Contracts come from Siebel into 11i OM renewals are completed using the 11i Service Contracts module directly pricing occurs using Advanced Pricing QP .
• Customer Master re-engineered from 10.7 to 11i TCA with de-duplication, address verification and DUNS number assignment using Dun and Bradstreet DNB services. Converted the following data from legacy systems into 11i: Service Requests, Installed Base Instances and Systems, Service Contracts, and Customers.
• Re-implementation Oracle Applications from legacy 10.7 system and other custom and third party systems to 11i 11.5.9 .
• Global implementation for 12 operating unit dispersed in the Americas, Europe EMEA, and Asia APAC completed in 6 months

Project Characteristics:

• These activities where done within the R2i implementation methodology since this project was lead by BearingPoint.
• Worked on all phase of the project life-cycle: 1 Gathered all business requirements in the service provider/service logistics area. 2 Designed training materials to bring users up to speed with the standard system functionality. 3 Performed an initial configuration of the system to support training and demonstration activities. 4 Final design incorporated business processes throughout the Support organization. 5 Completed configuration and setup to meet these needs. 6 Three cycles of testing performed: conference room pilots CRPs 1 and 2 and user acceptance testing UAT . 7 Trained super-users. 8 Supported all go-live activities and post-production troubleshooting.
• Managed all aspects of implementing the Customer Relationship Management Oracle CRM suite within the Oracle Applications E-Business Suite R11i project included the following business flows: Call to Resolution, Click to Resolution, and Contracts to Renewal . Performed the full configuration, testing, documentation, training, and post-production support for the following modules: CRM foundation JTF: Tasks, Resources, and Escalation Management, the TeleService area Service, Customer Support, Enterprise Install Base, Service Requests, Solution Management System, Customer Care, Contact Center CS/CSS/CSI/CSE/CSC, ustomers Online OCO/IMC, Contracts/Service Agreement area Service Contracts and Contracts Core OKS/OKC, and iSupport IBU . Coordinated implementation details with 4 other functional track leads in the areas of Record to Report Financials, Procure to Pay Manufacturing, Order to Cash Distribution, and Recruit to Retain HRMS . The main business goal of implementing the CRM/Service modules was to effectively manage customer service contracts and entitlement.

Subject : Analysis and Definition for implementation of Ebusiness Suit 11I, Implementation of 10g and RAC

Platform : Sun Solar / HP Unix / IBM Unix

Role : Project management, analysis, implementation, customer support, Oracle Apps DBA. CRM Track Functional Oracle Applications Lead Consultant - IT.

Task : Working 50 Functional and 50 Technical within Oracle E-Business Suite. Environment: Oracle E-Business Suite R11i 11.5.9 Service Suite/TeleService/Service Requests/Customer Support/Customer Care/Installed Base CS/CSS/CSC/CSI/CSE, Customers Online OCO/IMC, Trading Community Architecture TCA/HZ, Service Intelligence BIV, Service Contracts/Contracts Core OKS/OKC, iSupport Self-Service IBU, CRM Foundation JTF, Application Object Library AOL/FND, Concurrent Manager, Flexfields, Oracle 9i: PL/SQL, SQL. Toad, Windows XP.

Business : Designs, produces, sells, and supports embedded software products.

• Assisted the client in an Oracle Financial 10.7 to 11.5.4 conversion.
• Updated database conversion from 7.3.4 to 8.1.7.
• Provided application and database support on development, quality assurance, and production environment on AP, AR, BOM, OM, OPM, HR, GL, PO, SE, INV modules of 11I, with primary focus on custom apps, iProcurement and Order Management which included Order Management, Shipping Execution, Advanced Pricing, Release Management .
• Implemented multi-org, multiple reporting currencies MRC and Euro as a Foreign Currency EFC, and NLS at the operating system, RDBMS, and Application layers.
• Wrote ksh/bourne scripts and PL/SQL stored procedures for reporting, maintaining, and performance monitoring Oracle applications, database and operating system.
• Performed cloning, performance tuning, and applied patches.
• Performed Oracle performance tuning on 30 Oracle databases on NT and Unix.
• Performance tuned Oracle running People soft.
• Implemented and tested site-wide disaster recovery across all systems using Veritas Backup Exec and RMAN.
• Conducted Oracle Database Administration training to junior DBAs
• Implemented capacity planning mechanism and standards.
• Improved documentation and implemented web-based documentation.
• Implemented scripts for database monitoring.
• Configured Oracle Enterprise Manager Console.
• Wrote web based system logging application to track Space Station configuration using WebDB Portal, Web Server PL/SQL Web Toolkit
• Implemented Oracle Financial 10.7 and OPM 4.10 worldwide.
• Monitored and maintained systems and supported users globally from several support centers.
• Performed Apps administration on version 11.
• Performed a system audit to evaluate system, RDBMS, Oracle Apps, and network.
• Provided system administration support on HPUX and citrix
• Administering four Oracle Financial 11 databases, and MS SQL Sever 7.0.
• Performed normal DBA/S A responsibilities
• Installed and configured of several Self Service Web apps including HR, ADI, and Oracle's Transparent Gateway.
• Assisted in the implementation of AP, PO, HR, and the implementation of third party software to the GL.
• Performed SQL Server DBA and IIS server administrator tasks
• Specified appropriate storage specifications for indexes, tables and table spaces partitioning in ERWin's case tool method.
• Created stored procedures and triggers. Installed and implemented a data load model between an IBM AS/400 and Oracle database using Data Stage.
• Performance tuned database, query optimized and stress tested Popular Club's production database using Oracle's Stat pack diagnostic and analyzing report which allowed me to anticipate unusual performance conditions by defining thresholds and alerts to respond to special situations as soon as they occur or to enable automatic database responses.
• Volume sized production database with over 45 terabytes of data. Specified I/O distribution using a capacity plan model and measured throughput. Setup backup and recovery procedures using RMAN.
• Utilized SUN Solaris Unix with RAC, Microsoft Windows XP Professional, Oracle 8i and 9i, Unix Script, SQL Plus, SQL DBA, OEM, Oracle's Export Import Utility, SQL Loader, RMAN, ERwin, Oracle's Discoverer Ad Hoc Tool, DataStage, TPC/IP and FTP.
• Supporting multiple MS SQL Server SQL Server 7 SQL Server 2000,SQL Server 2005 with large databases in a 24x7 production environment both in terms of SQL tuning and also server level tuning using various configurable parameters, running dbcc and running dbcc dbrepair if needed, must be able to understand existing perl and shell scripts and also code them when needed .should be familiar using third party tools such as DB Artisan, etc.
• Administering the MS SQL Server 2000 running on a windows with 2 nodes, applying the service packs as and when they are distributed, regular DBA activities like backup restoring of user system databases, running dbccs, update statistics. configuring different external services that can be linked to the server such as mail notification, DTS, etc

Business : Develops software systems that extended functionality of ERP systems. E-Retail B-to-C web storefront and telephone sales direct to end customers

• Support/Customer Care/Installed Base CS/CSS/CSC/CSI/CSE, Service Contracts/Contracts Core OKS/OKC, Field Service CSF, Spares Management CSP, CRM Foundation JTF, Trading Community Architecture TCA, Workflow, Application Object Library AOL/FND, Concurrent Manager, Order Management/Entry OM/OE, Shipping Execution WSH, Inventory INV, Order Capture ASO, Workflow, Application Object Library AOL/FND, Concurrent Manager, Flexfields, Oracle 8i: PL/SQL, SQL. UNIX AIX, SQLNavigator, Windows 2000.
• Tasks: Environment: Oracle E-Business Suite R11i CRM Service Suite/TeleService/Customer
• Senior Functional/Technical Oracle Applications Analyst Consultant - IT. Working 50 Functional and 50 Technical within Oracle Applications.

Role : Project management, analysis, implementation, customer support, Oracle Apps DBA.

Platform : Sun Solar / HP Unix / IBM Unix

Subject : Oracle DBA

• Development, configuration, and testing of interfaces from Neptium's various systems to Oracle Applications including the Order Management OM/ONT, Shipping Execution WSH, and Inventory INV modules among others PL/SQL .
• Techno-functional troubleshooting of the Shipping Execution WSH, Order Management OM/ONT, and Inventory INV modules within Oracle Applications. Working on issues related to pick release, pick confirm, deliveries, reservations hard, soft, ATP, backorders B/O, interfacing to 3rd party warehouse /packaging systems ALS and FedEx, and ship confirmations WSH, ONT, INV . Methodological identification of issues starting from order initiation to ship confirmation and closing of order line. Analysis of all scenarios/paths an order line can go through, and issues that may occur during the full lifecycle of an order. changes in configuration to Shipping, OM, and INV setups as needed to address issues, improve performance, and ensure proper flow of data to 3rd party systems.
• Analysis of customizations and enhancements: evaluate design, quality, stability and maintainability of custom code developed to fill gaps between standard Oracle Applications functionality and business requirements. Recommend and implement solutions as needed PL/SQL .
• Authoring SQL and PL/SQL scripts to analyze underlying data for inconsistencies and integrity issues focus on querying data associated with order lines, deliveries, delivery assignments, and reservations both custom and standard to find data issues, create a plan to resolve the problems, and then test and implement the solution.
• This project to implement Oracle 11i was terminated after the investigation, planning and training phases, so the project was not implemented in production.
• Managed all aspects of starting the Customer Relationship Management Oracle CRM suite implementation within the Oracle Applications E-Business Suite R11i project. Performed the initial configuration, testing, documentation, and training of the following modules: the CRM foundation JTF: Tasks, Resources, and Escalation Management, the TeleService area Service, Customer Support, Enterprise Installed Base, Service Requests, Solution Management System, Charges, Customer Care, Contact Center CS/CSS/CSI/CSE/CSC, Contracts/Service Agreement area what at that time was called Contracts for Service and Contracts Core OKS/OKC, Field Service CSF, and Spares Management CSP . Coordinated implementation details with 4 other functional track leads in the areas of Financials, Manufacturing, and Distribution. The main business goal of implementing the CRM/Service modules was to effectively manage customer service contracts, entitlement, and field service including charging customers as needed .
• Worked with users on business requirements in the service provider/service logistics area. Designed training materials to bring users up to speed with the standard system functionality. Performed an initial configuration of the system to support training and demonstration activities. These activities where done within the R2i implementation methodology since this project was lead by BearingPoint/KPMG Consulting.
• Administered Oracle Applications 10.7 SC with addition of extensive Y2k patching and ADP interfacing.
• Implemented Oracle Express Server, Oracle Financial Analyzer, self-service Web Applications including HR, Oracle Web Application Server.
• Modified and developed new functionality using Developer 2000, and management report using Discover. Acting as the Super DBA,
• Conducted Oracle Application Database Administration training to junior DBAs
• Installed, implemented, and administered Oracle Financial Analyzer 6.3 and Oracle Express.
• Interfaced OFA to the Oracle Financial GL.
• Designed the necessary attributes, cubes, dimensions, FDI's, models, solves, and reports.
• Responsibilities included Oracle Applications DBA of production and development Oracle Financial 10.7 NCA environments.
• Provided global support for users, developers and factories operations in the US and France.
• Implementation included standard modules, and many customization, as well as MRC, and NLS.
• Implemented and managed Legacy to Oracle Financial interfaces
• Installed and administered database, application, and web servers Assisted in a subsequent upgrade from 10.7 NCA to 11, and an upgrade to OPM 4.10.
• service contract sales.
• resellers reselling third party products and services maintenance/repair/service/support
• Business: Data storage solutions and services B-to-B indirect sales to end customers via

Tasks: Environment : Oracle Applications R11i CRM R10.7 NCA, R10.7, R10.6 Order Entry OE/OM, Service/Installed Base/Support/Contracts CS/CSS/CSI/CSE/OKC/OKS, Electronic Commerce/EDI Gateway EC, Accounts Receivable AR, Inventory INV, Accounts Payable AP, General Ledger GL, Purchasing PO, Bill of Materials BOM, Alerts ALR, Application Object Library AOL/FND, Concurrent Manager, Flexfields, Oracle 7.x, 8, 8i: SQL, PL/SQL Pro C, SQL Loader, Developer/2000, Forms 4.5, Reports 2.5, Designer/2000, Browser/Query Builder, Discoverer. C, C , UNIX Sun, NT, PVCS, Kintana/Chain Link Kintana Create/R I, Kintana Deliver/A I, O M, MS Access, Remedy Call Tracker, Lotus. Service/Service Online/Customer Support/Installed Base CS/CSS/CSE/CSI, iSupport Self-Service IBU, CRM Foundation JTF, Trading Community Architecture TCA, Customer Intelligence-OCI BIC, Universal Work Queue IEU, Customer Care CSC, Interaction Center, Workflow, Application Object Library AOL/FND, Concurrent Manager, Flexfields, Oracle 8i: PL/SQL, SQL, Workflow Builder, iDeveloper, Discoverer. UNIX Sun, Windows 2000.

• Project Lead/Functional Lead/Technical Architect Consultant - IT. Oracle Applications Development Team Technical Lead/Systems Architect/ Working 55 Functional and 45 Technical within Oracle Applications.

Role: Project management, analysis, implementation, customer support, Oracle Apps DBA.

Platform: Sun Solar / HP Unix / IBM Unix

Subject: Oracle DBA

• Lead a 3-member team in the accelerated implementation of Oracle Applications E-Business Suite R11i in 60 days. Performed the installation of the following modules: components in the Oracle CRM foundation JTF e.g., Tasks, Resources, and Interactions, the Trading Community Architecture TCA, the Service/Service Online and Support modules e.g., Install Base, Knowledge Base, and Service Requests CS/CSS/CSE/CSI, the iSupport Self-Service module IBU, Customer Care e.g., Contact Center CSC, Universal Work Queue IEU, and Customer Intelligence BIC/OCI additionally implemented shared elements of Accounts Receivables AR, Order Management OM/ONT, Contracts OKC/OKS, Inventory INV, General Ledger GL, and Human Resources HR/PER/HRMS to allow the full functioning of the CRM/Service components. Implementation focused on providing service support case management personnel the ability to efficiently track service requests trouble tickets based on entitlement and maintain field equipment configurations Installed Base .
• Responsible for all functional aspects of the project: Analysis of user business requirements Creation of a functional gap document Construction of a design document that includes: 1 connection points between Oracle Applications and other business systems and 2 the mapping of business processes within Oracle Applications Produced a configuration document to outlining all setups to achieve a system matched to the business processes including both Oracle Service/Support modules as well as shared Financial and CRM modules .
• Creation of test script documents lead the conference room pilot CRP phase of the project using these testing scenario documents.
• Wrote a training guide for users, and used this guide to conduct training sessions.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests Workflow Builder .
• Worked with Discoverer so users would have the ability to generate ad-hoc reports.
• Designed a custom Application Program Interface API to import service requests into Oracle Applications Service module based on events/problems that occur in a HP OpenView monitoring system PL/SQL .
• Coordination/Team Lead of 16-member development team on all technical aspects of implementing the Oracle Service module including Service, Support, Installed Base, and Contracts - CS/CSS/CSI/CSE/OKC/OKS all of which would eventually become a part of the CRM suite with customizations and extensions involvement in all stages of the system's development lifecycle 12 months project followed the Six Sigma 6 Sigma methodology for quality assurance.
• New functionality provides the ability to track all indirect sales information serial number, warranty, final end user, etc., sell extended warranty contracts both for support provided by GE Access, and reselling support from third parties, and customer request tracking including verifying entitlement, level of service, product configuration, etc. .
• Acted as a bridge between functional and technical aspects of the project connecting business user needs with system capabilities and required customizations interpretation of functional requirements interactions with users functional and technical gap, design, and specifications
• scheduling resource estimation and tracking testing implementation post go-live support. Development included: custom components to interface Service module to Order Entry OE/OM, Inventory INV, Accounts Receivables AR, and Purchasing PO data conversion from a legacy system customers and existing service contracts custom imports and exports of vendor data custom pricing module expanded use of the Accounts Receivables AR module to store end user information creation of a custom service contract approval cycle PL/SQL, Forms 4.5 .
• Manage all development aspects of an Oracle Applications R10.6 to R10.7 upgrade installation included 10 Financial and Manufacturing modules coordination of a 7-member development team evaluate and implement changes to all customizations and extensions.
• Directed a 4-member development team in the gap analysis, architecture, and interface design for integrating the new MOVE warehouse management system WMS a 3rd party product from Optum with the existing Oracle Applications installation.
• Analysis of upgrading from Oracle Applications R10.7 to R11i.
• Development of EDI exports and imports with the Oracle EDI Gateway EC and custom built extensions in Pro C, PL/SQL, and C /DBTools.
• Creation of various Oracle Alerts ALR to inform internal users of certain events, or to notify customers of account status e.g., all active service contracts .
• Evaluation and implementation of changes to financial reports and background processes Reports 2.5, PL/SQL to accommodate a modification in the fiscal calendar.
• Design and implementation of reporting components Forms 4.5 PL/SQL Reports 2.5 for Oracle Applications modules and parts of the custom CRM system.
• Development of database objects packages, procedures, triggers, views, etc. to provide custom functionality within the Oracle Applications, CRM, and data warehouse databases.
• Part of team assisting with a conversion from Oracle Financial version 10.5 to version 10.7.
• Implemented Multi-org capabilities of Oracle Financial to incorporate the company's Canadian operations. modeling databases for Business Objects, administration of Oracle user login scripts,
• Designed and developed interfaces from Oracle Financial to other core systems on Informix SE and Siebel, database cleanup,
• Installed Oracle patches, data synchronization among Oracle and non Oracle systems, and other related system and database administration
• Developed employee self- service VB/Oracle applications accessible from Honeywell's Intranet
• Solved problems associated with enterprise-wide application deployment.
• Managed 4 development and support teams consisting of more than 200 persons in four countries, which provided tactical support for corporate and departmental business initiatives worldwide.
• Supported over 1000 users and more than 40 production applications worldwide.
• Trained development staff in utilizing Arthur Andersen's Method/1 software and system deployment methodologies for the global configuration alignment of development and production SQL Server systems.
• Trained development staff in writing MS SQL Server SQL queries to improve data integrity and performance
• Cloned Prod to Dev, performed crash recovery, configured rollback segments, developed, tested and automated the hot and cold backups and applied patches.
• Looked into day-to-day activities of Production database, Monitoring its growth and performance.
• Maintained Development databases, Test databases and Applying Patches
• Developed Scripts for refreshing Development and QA databases.
• Refreshed of Development databases from Production databases
• User Management and gathering statistics on Database Objects.
• Monitored Hot and Cold backups.
• Monitored the growth of Table spaces to see the fragmentation and available space for growth. Check for log and trace files.
• Configured Oracle 7.3 Database.
• Performing Online Offline Backups of Databases.
• Resolving performance problems.
• Designed the Database for custom applications.
• Fine tuned Memory, I/O and Database Objects.
• Written scripts for daily and incremental backups. Written Database Packages, Procedures,
• Deployment'.

Tasks : Technical Editor for new Learning Tree course development 'Oracle 9iAS Administration and

Role : Project management, analysis, implementation, customer support, Oracle Apps DBA.

Platform: Window NT

Tasks :

Role : Project management, analysis, implementation, customer support, Oracle Apps DBA.

Platform: Window NT

Subject : Oracle DBA

• Coordination/Team Lead of 16-member development team on all technical aspects of implementing the Oracle Service module including Service, Support, Installed Base, and Contracts - CS/CSS/CSI/CSE/OKC/OKS all of which would eventually become a part of the CRM suite with customizations and extensions involvement in all stages of the system's development lifecycle 12 months project followed the Six Sigma 6 Sigma methodology for quality assurance.
• New functionality provides the ability to track all indirect sales information serial number, warranty, final end user, etc., sell extended warranty contracts both for support provided by GE Access, and reselling support from third parties, and customer request tracking including verifying entitlement, level of service, product configuration, etc. .
• Acted as a bridge between functional and technical aspects of the project connecting business user needs with system capabilities and required customizations interpretation of functional requirements interactions with users functional and technical gap, design, and specifications scheduling resource estimation and tracking testing implementation post go-live support.
• Development included: custom components to interface Service module to Order Entry OE/OM, Inventory INV, Accounts Receivables AR, and Purchasing PO data conversion from a legacy system customers and existing service contracts custom imports and exports of vendor data custom pricing module expanded use of the Accounts Receivables AR module to store end user information creation of a custom service contract approval cycle PL/SQL, Forms 4.5 .
• Manage all development aspects of an Oracle Applications R10.6 to R10.7 upgrade installation included 10 Financial and Manufacturing modules coordination of a 7-member development team evaluate and implement changes to all customizations and extensions.
• Directed a 4-member development team in the gap analysis, architecture, and interface design for integrating the new MOVE warehouse management system WMS a 3rd party product from Optum with the existing Oracle Applications installation.
• Analysis of upgrading from Oracle Applications R10.7 to R11i.
• Development of EDI exports and imports with the Oracle EDI Gateway EC and custom built extensions in Pro C, PL/SQL, and C /DBTools.
• Creation of various Oracle Alerts ALR to inform internal users of certain events, or to notify customers of account status e.g., all active service contracts .
• Evaluation and implementation of changes to financial reports and background processes Reports 2.5, PL/SQL to accommodate a modification in the fiscal calendar.
• Design and implementation of reporting components Forms 4.5 PL/SQL Reports 2.5 for Oracle Applications modules and parts of the custom CRM system.
• Development of database objects packages, procedures, triggers, views, etc. to provide Custom functionality
• within the Oracle Applications, CRM, and data warehouse databases.
• Installation of several 9iAS Servers for Edinburgh University
• Teaching various public courses for Learning Tree, including Oracle DBA, PL/SQL and Application Development and Tuning Courses. Oracle 8.1.7 to 9i upgrade for Southend NHS Trust.
• Application Performance Analysis and Team Coaching for Orchestria.
• Produced report recommending performance-testing approach for RADAR Recipe Development System to validate that it would perform adequately when rolled out to worldwide research and development facilities.
• Carried out initial performance analysis of third-party and in-house applications using Statspack and Trace facilities and recommended improvements.
• Developed load-testing scenarios using Wintask and Citrix Server Test Kit.
• Produced Oracle SQL and PL/SQL performance-related development standards.
• Short-term contract to cover staff shortage
• Evaluation of existing backup and recovery procedures, recommending and implementing improvements
• Upgrading several databases from Oracle 7.3.4 to 8.1.7
• Performance analysis of third-party application and recommending SQL improvements.
• Recommended move to Locally Managed/Uniform Extent table spaces and implemented first few databases
• Production of a report listing various high availability and recovery solutions for databases hosted by Orbital on behalf of their clients. I also implemented improvements to the short-term export-based solution.
• Analysis of current optimization model and recommendation to move to cost-based optimization. I was also involved in conducting stress tests to evaluate the success of this approach.
• Identification of poor SQL statements and creation of indexes or embedded hints to improve performance.
• Production of an informal list of SQL performance tuning guidelines to improve the quality of future code development.
• Evaluation, implementation and documentation of schema release procedures using Quest Schema Manager as a replacement for the existing Oracle Designer. The schema was particularly complex, consisting of more than 1800 tables.
• Sizing calculations, re-implementation of storage parameters and db reorganization to use uniform extents.
• Extensive monitoring and tuning activities during stress tests with both Media surface and MS Access code.
• PL/SQL Development and DBA training of permanent employees, both structured courses and coaching.
• Development of a procedure to refresh the database from mainframe extract files Pro C . Primary Unix Administrator and Oracle DBA
• 23 years experience as an IT consultant.
• 17 years experience with Oracle.
• 12 years experience with