OBJECTIVE:

• Oracle Certified professional offering 16 + years experience including applications development database administration, EBS and Oracle Retail (formerly Retek) Implementation, data management and Production support.

SUMMARY:

• Installation Weblogic version 10x and performance & tuning on Weblogic.
• Installation and upgrade of Oracle Retail Application version (13x, 14x & 15) all the Modules.
• Installation of Linux, VMware Virtualization and installation of oracle retail as per company requirements.
• Application integration testing,, data conversion and functional enhancements.
• Definition of business requirements, workflow analysis, and application development.
• Preparation of project documentation, test plan, test scripts incidence reports, and sign off documents.
• Database administration and applications development using relational database technology.
• Data management including collection, enrichment, and procession.
• Production environment management providing high availability and appropriate database performance.
• Close coordination with development, systems and business units to implement new procedures.
• Preparation and maintenance of well - documented system and operational procedures.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Pro C*, C++, Java

Databases: Oracle RDBMS, 12c, 11g, 10g, 9i, 8i 8, and 7.x, SQL Server 2005

Application: Oracle Retail (formerly Retek) version 7, 8, 9, 10.11, 12, 13, 14, 15x

Suite (ORMS, ORPM, OReSA, OReIM, ORA and ORIB)

Oracle E: Business Suite version 10, 11 and 12

Suite (G/L, A/P A/R, O/M, P/O INV and Application Administration)

Oracle ADF (Application Development Framework)

Integration: BPEL, EDI, ORIB

Architecture: Web Logic Server 11gR1, Oracle Application Server 10g, J2EE, ADF BC, ADF, OAF

Front End: Oracle Forms 4.5, 5.0, 6i, 9i and 10g Oracle Reports 2.5, 3, 6i and 10g Retek RMS UI

Development Tools: TOAD, SQL Developer, Oracle Workflow, Enterprise Manager, Oracle Designer 6.0SQL Navigator, DBArtisan, EZDBA, SQL *Plus, SQL Loader, JDeveloper

Operating Systems: WNDOWS 98/2000/XP/Vista/Windows 7, UNIX(HP/UX, AIX, Solaris, Linux)

Others: Microsoft Package (word, excel, access, power point and project)

WORK EXPERIENCE:

APPS DBA / Oracle DBA

Confidential, Houston, Texas

Responsibilities:

• In process of installation of Version 15 Oracle Retail in DEV environment for evaluation for company to purchase the new version.
• Configured and installed weblogic 10.3.6 including deployments and monitoring.
• Support and configuration of Oracle Retail products including Orms, Orpm, Orim, OrAlloc and Orsim.
• SOX rules implementation and changing the password for all Retail Database & Application, Orms, Orpm, Orim, OrAlloc, Orsim and Orib.
• Install Oracle application patches in Orpm, Orim, OrAlloc and Orsim.
• Installation and configuration of Orib patches, support Orib issues, and configuration. Support Production issues with Orpm Batches. Increase performance on critical Orpm batches such as location move etc.
• Performance and tuning for number of slow running SQL queries for faster response time, Modified Store Procedure / Function and Packages for Orms and Oreim.
• Worked with Oracle Support to raise SR's, OWC to resolve issues. Created standards and documentation for installation, configuration and applying patches. Worked with external vendors to use Orib / Orms web-services.
• Configured RWMS to communicate with Zebra printers for label printing at the warehouse.
• Performed extracting and loading data using SQL*PLUS and SQL*LOADER from a data warehouse into text files under a Unix Platform which included Sun OS, AIX and Solaris.
• Worked with customizations for Orim and Allocations and created deployment documentation and standards for best deployment practices for retail J2EE applications.
• Worked on Orpm performance issues and Allocation performance issues.
• Worked on Orib by using RDMT, resolve Orib issues and re-process Orib errors.
• Managing 21 Web Logic servers and refresh activities on quarterly bases.
• Involved in installation and configuration of SQL server 2000 on Dell Servers. Applied patches and service packs to keep the database at current patch level.
• Create and Update number of stored packages, procedure and functions according to company requirements.
• Experience with supporting Month End Close and Year-End Close activities Ability and willingness to quickly understand the custom application environments and business processes and integration around the custom applications with Oracle Financials to take the ownership.
• Installed and configured Oracle EBS 12.4 in dev & TST environment.
• Designed and planned the Architecture for Dev, UAT and Production servers for both Databases and Application servers. Utilized SSL for all Oracle Retail Applications (MOM, Orib, Orwms, Orsim). Configured and customized startup and stop scripts for web logic and all managed servers utilizing python for both SSL and non-SSL environments

Oracle Technical Consultant

Confidential, Charlotte, North Carolina

Responsibilities:

• Manage and support the 8+ Oracle databases.
• Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities.
• Managing table spaces, data files, redo logs, tables and its segments.
• Maintaining data integrity also managing profiles, resources and password security, Managing Users, Privileges and Roles.
• Install Oracle software and patches. Tune SQL statement against database and its objects. Write script to monitor the database with shell and PL, SQL code or SQL PL, SQL code such as procedure, function, and package
• Enhanced MS-Access databases by improving user interface, introducing multiple-user access, and increasing security and stability.
• Responsible for Oracle 11g logical and physical databases design, implementation, and maintenance. Involved in all phases of database development, from needs assessment to QA/QC, design, and support.

Oracle Technical Consultant

Confidential, Jacksonville, Florida

Responsibilities:

• Support & customized Confidential third party vendor system as DSW Shoes in Orms and Orsim, and taking complete ownership responsibility from OLR to stabilize for Confidential .
• Designed and implemented new reason code process in Confidential third party vendor system as DSW Shoes in Orms and Orsim.
• Designed and Implemented ReTL Reports for data comparison between iSeries systems and Orms after go live.
• Provides expert knowledge on Oracle Database Administration, Oracle Application Server and Oracle Retail Applications during the Implementation Life Cycle and Post Implementation support during implementation time.
• Install & setup DEV / TEST database servers and clone Production DB to dev/test servers for developers testing ground, replicating number of different problems in dev/test for fixing problems other than production.
• After successful Implementation of Oracle Retail, follow transition process of (Orms) Oracle Retail Module and taking responsibilities from OLR to Confidential ownership.
• Customized and implemented Markdown, Promotion and Clearance process driven by UDA (Universal Product Code) to POS.
• Number of Forms Customization in Orms according to Confidential requirements.
• Designed and Implemented Auto Discount with two new forms, three reports, this is new customization other than Orpm in Oracle retail.
• Performance and tuning for number of slow running SQL queries for faster response time, Modified Stored Procedure / Function and Packages for Orms, Orsim, Orim and Orpm.
• Daily support for Production nightly UC4 batch and faster response for any program failure, built a Log system for common UC4 nightly batch failure and provide quick possible solution.
• Successfully handle ORetail purges (Orim invoice batch purge, Orms orders purge, Item purge, stock count purge, Tran data purge Orpm Future retail purge, Clearance data purge etc.

Oracle Technical Consultant

Confidential, Charlotte, North Carolina

Responsibilities:

• Designed Developed and Implemented new forms with new functionality and adds to the oracle retail Suite for store system.
• Modified ordhead form in Orms to call PO report by passing userid as cookie to avoid prompting userid when running the report. Location traits matrix(lotrm) form modified to import location traits from text file containing stores using WEBUTIL.
• Creating new reports in Orms for customer returns and customizes existing report for inventory investment and gross margin.
• Designed and Implemented (EDP) employee discount process includes 2 new forms and 3 new reports.
• Performance and tuning for number of slow running SQL queries for faster response time, Modified Store Procedure / Function and Packages for Orms and Oreim.
• Developing a Unit Test Plan based on the acceptance criteria of the store based on work request, business requirements and/or product specifications.
• Creating summary design to address fix/enhancement code change to support store’s acceptance criteria
• Using Orim for integration for pricing, promotion and clearance information between Orms and Orpm.

Oracle Technical Consultant

Confidential, Charlotte, North Carolina

Responsibilities:

• Providing Technical Support on EBS as a Sr. Consultant / Employee for Hearst (CMG). Charlotte NC.
• Performance and tuning for number of slow running SQL queries for faster response time, Modified various Store Procedure / Function and Packages for Different APPS Databases.
• Modifying various oracle application forms (EBS) and customized form according to user requirements and Follow Company’s standard customization procedure.
• Modifying various Companies’ Standard existing documentation according to the modification request by users and keeping as a current version in PVCS version Manager. After Unit test, System test and QA test ensure all the documentation attached with problem SCRs (System Change Request) in PVCS Tracker.
• Support our Team for SOX compliance Documents for Audit purpose and enforce our Company Database Security Policies.
• User Support is primary goal and dealing with day to day problems in oracle Application (EBS) as a front end and oracle Database as a back end.
• Implementation role in setup form server for Contract Database.

Oracle Technical Consultant / DBA

Confidential, Charlotte, North Carolina

Responsibilities:

• Providing Technical Support on EBS as a Sr. Consultant for TIAA-CREF. Charlotte NC.
• Developed and modified various Store Procedure / Function and Packages for Retirement, 401K and pension administration system.
• Creating tables, Denormalize database for reporting purpose, Using SQL Loader utility and load size of 60 to 80 GB of data load in multiple tables.
• Designed and develop financial control project and balance data between omni and irw two company’s customize database.
• Performance and tuning for number of SQL queries for faster response time.
• Refreshing Unit Testing, Integration Testing and System Testing Schemas by Import/Export Data.
• Modifying various oracle application forms (EBS) and customized form according to user requirements and Follow Company’s standard customization procedure.
• Implementation role in setup forms / Reporting Database Server on Solaris.
• Maintenance of DEV database and refresh every after two week.
• Refresh Database from PROD to QA on Monthly bases.

Oracle Technical Consultant

Confidential, Charlotte, North Carolina

Responsibilities:

• Data conversion from legacy System to oracle in RETEK “Retail Merchandizing System” (RMS) during initial Implementation process in version 8.0 and then update version from 9 to 10.
• Developed Tax codes report using UDA attached to items. Each item assigned with a UDA value which is used for tax purposes.
• Developed Cost changes, new price change, Pending price change reports and Supplier attributes report.
• Modified base Printfrm form to display Excel output generated from reports along with PDF in two separate windows. Base forms like itemattr, supattr, strattr, whattr forms are modified to support customized columns.
• Installed, Configured, Deployed and administered oracle Reports Server 6i and Forms Server 6i to deploy web forms for Retek RMS.
• Designed, developed and demoralize oracle reporting database for reporting purposes.
• Optimization of the different SQL Queries to insure faster response time and improve Retek batch performance.
• Using Autosys Utility to Schedule Batch Processing and on call for supporting Batch.
• Developed and modified various Forms and Report using oracle Forms and Reports 6i in RMS.
• Developed and converted customized Retek report, involved in creating Items, Price changes and clearances for Integration testing.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Developed and modified database procedures/functions, triggers, packages to enhance and improve functionality using PL/SQL. Involved in coding, unit testing, and end-to-end testing of the developed modules and developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Development team for the Item, vendor and inventory adjustments interfaces from RMS to WMOS supply chain management.
• Upgrading version forms 4.5 to 5.0 and from 5.0 to 6i, Reports 2.5 to 3.0 and 3.0 to 6i.
• According to Company Requirements Pro* C customization in Retek RMS & RDW.
• Applying new Patches in RMS and customising Retek forms according to user requirements.
• Developed test plans for unit, assembly and integrated systems tests
• Involved in Development of inbound / outbound interfaces from Retek RMS to Oracle Financial Applications.
• Upgrading version Oracle Financials Applications, General Ledger, Accounts Payable and Fixed Assets version 10.7 to version 11i.
• Support users in General Ledger, Accounts Payable and Fixed Assets in Oracle Financials Applications.

Oracle Technical Consultant / DBA

Confidential, Phoenix, Arizona

Responsibilities:

• Providing Technical Support and Performed as a Consultant on a client site for Tosco Corporation. on “Retail Enterprise Program” (REP) project implementation. Importing Exporting large size tables from production database to development for developers.
• Achieved more than 100% reduction in batch window-Optimized daily batch window that ran for 16 hours to 4 hours (optimized processes that took hours to run in minutes).
• Data conversion from legacy system to oracle applications API and interface tables
• Install and configure RMS version 8 Retek Application.
• Performed database cloning for Developers from RMS Prod database on Demand.
• Detailed installation & documentation for RMS Retek Application (Version 8) during Implementation Life Cycle and Post Implementation Support.
• Managed 2 Terabyte of data on 6 different development instances.

Oracle Technical Consultant / DBA

Confidential

Responsibilities:

• Providing technical support to clients (Ontario Hydro) which include importing and exporting data in oracle 7.3.5 and backup & recovery, data conversion, schedule commands, and installation of newer version of company’s products. Provided documentation for end-users.
• Developed store procedures, functions and packages for calculating pension systems. Conducted unit testing and system testing and data conversion using SQL Loader on a weekly basis to oracle.
• Installing a pension Contribution system’s new screens for (Govt. of Nova Scotia) using developer 2000 Forms 5.0 and Report 3.0.
• Installing Customizing Company’s PENFAX product based on client specifications and requirements.
• Performance and tuning for number of slow running SQL queries for faster response time, Modified Store Procedure / Function and Packages.
• Applying number of Oracle patches in database and PENFAX application.
• Installing Sun Solarise software and servers on client site and provide support.

Jr. Oracle DBA

Confidential

Responsibilities:

• Backup/Recovery of all the production and development systems.
• SQL Reports using SQL Plus and SQL to generate text format reports.
• Data migration including data cleanup, data preparation, data conversion, data download and upload.
• Create, Designed and Developed customer contract renewal model, using Oracle7.1 and Used SQL Loader Utility to populate tables, mainframe data used in text format and MS Access as front end tool, MS Excel, ISPS Tracking System, CRIS System, IAS System and TTS Tracking System.
• Create and developed Confidential contract ending database using Oracle7.3 as database and visual basic as front end tool, MS Excel, ISPS tracking system for country wide area managers and their account executives to provide customer contract ending information to renew the contract and this database is demoralize only for reporting purposes.