SUMMARY

• Over 21 years of extensive experience as Team Lead and Oracle Application Developer, Database Developer & Designer.
• Extensive experience as Oracle Applications Developer in Migration, Customization, implementation, upgrade, Interfaces development and customization of Oracle e - Business Suite Applications. This includes system study, design, development, post implementation maintenance and production support of Oracle EBS. (R12).
• Expert Order to Cash (O2C) and Procure to Pay (P2P), INV, HCM/HRIS/HRMS.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Suite.
• Expert in developing & debugging RICE components (Reports, Interfaces, Conversions, Extensions) in Supply Chain Modules (OM, Shipping, INV, PO) using Oracle Forms, Oracle Reports.
• Expert in Oracle database programming using SQL, PL/SQL (Stored Procedures, Packages, Functions and Triggers), Data Loader, SQL*Loader, SQL* Plus, Oracle Import/Export, UNIX shell script,
• Experience in Forms creation and customization using Custom.pll and Forms personalization, Workflow Builder.
• Experience in Oracle Fusion Cloud Development for Coexistence module Talent Management & OIM.
• Experience working on Oracle Application Express (APEX).
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Worked with the business functional areas to research and identify the best technical solution to support business processes. Gap Analysis.
• Extensive experience in developing reports using BI/XML publisher, OBIEE & JIRA
• Experience in Data modeling using tools like ERWin & Designer2000.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher) on UNIX and Windows platforms.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production.
• Familiar with WORKDAY.
• I’m US Citizen.

TECHNICAL SKILLS

Oracle EBS: Oracle R12 - Supply Chain Management SCM (OM, Shipping, INV, PO), Order to Cash (O2C), Procure to Pay (P2P), Oracle CRM, HCM (Core HR, Benefits, Compensation, Learning & Development, Succession Planning), Oracle Application Express (APEX)

Oracle Fusion: Oracle Fusion HCM 11g

Other ERP: Workday

GUI: OBIEE, JIRA, Forms 10g,9i/6i/5.0/4.5, Reports 10g/9i/6i/5.0/1.3, Crystal ReportsOracle BI Publisher.

Operating Systems: WINDOWS XP, NT 4.0, WINDOWS 95/3.11, Linux, HP-UNIX.

Languages: Oracle PL/SQL, SQL * PLUS, PRO*C.

Tools: TOAD, SQL Developer, Unix/Linux shell scripts, BI/XML Publisher, PUTTYRDBMS Oracle 11g, 10g, 9i, 8i, 8.X, 7.X, 6.X

Data Modeling: Designer (2000, 6i), Erwin 3.5.2.

Others: TOAD, SQL*LOADER, SVN, PVCS.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle HCM LEAD ANALYST

Environment: Oracle 12c, EBS R12- HRIS, OBIEE/JIRA, APEX, HCM, Oracle Fusion, Workday.

Responsibilities:

• Analyzing, developing & supporting of several modules of HCM including Core HR, Benefits, Compensation, Learning & Development etc.).
• Lead design & Implementation of Succession Planning module to HCM Cloud.
• Extracted high Volume of HCM data from Oracle Fusion HCM database in CSV format.
• Worked with third party vendor, providing development requirement and monitor progress of Succession Planning module developed using Oracle Fusion.
• Implemented Succession Planning successfully.
• Developed test plan & user acceptance testing.
• Working with Benefits & Compensation team to streamline the process. Data Loading/Conversions using HCM Data loader (HDL) to load Job, Grade, Worker data, Work relationships data, Salary info.
• Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
• Working with Talent Acquisition team to load data Brass Ring & generate several reports using Oracle Application Express (APEX).
• Created several reports using OBIEE. Created schedulers to deliver report automatically.
• Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM.
• Worked with WORKDAY team to provide requirements.

Confidential, Santa Ana, CA

LEAD BI ANALYST PROGRAMMER

Environment: Oracle 11g, Oracle BI Reports/XML, SQL Developer, UNIX, EDI.

Responsibilities:

• Involved in analysis, development and product support of various Oracle based applications. Tristar is one of the nation’s leading resources for worker’s compensation, property and casualty program and risk control.
• Leads team of 3 Developers and monitoring and reviewing offshore product development team.
• Created interfaces for several clients to load data and generate automated reports.
• Created PL/SQL Packages for EDI transactions identifying state reporting requirements.
• Created & transmit mandated EDI claim reports to the division of Worker Comp within specified time frame to avoid potential state fines & penalties.
• Designed & developed HCM reports using Oracle BI/XML.
• Designed & Developed strategy to load HCM compensation data using Data Loader.
• Lead data conversion activity for new clients - analyzing client data, designing test plan to load data, and executing data conversion activity from end to end.
• Supported existing clients - troubleshooting daily problems, providing additional functionality to streamline support.
• Developed and modified Oracle BI Reports for various clients. Moved report to Dashboard.
• Lead Product deployment and post deployment activities.

Confidential, Foot Hills Ranch, CA

SR. APPLICATIONS DEVELOPER

Environment: Oracle EBS R12, Oracle 11g, Oracle Retail Merchandising System (ORMS) & Oracle Retail Price Management (ORPM) 13.1.6, Oracle Forms, Reports, BI (Business Intelligent) Reports, TOAD, UNIX

Responsibilities:

• Designed and developed PO interface program to import Supplier POs to Oracle.
• Working with the onshore functional design teams and business users to understand requirements and ensure solutions were designed and built within tight time scales
• Preparation & planning for System Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Managing offshore development and subsequent deployments of code to environments
• Structuring Roles and Responsibilities around the solution design
• Quality Assurance on all deliverables
• Regular reporting to Management
• Communicating Project Milestones to management
• Created interface MIS PO as extension to Order Details to get additional PO's functionality.
• Created database objects & package to support interface MIS PO.
• Changed Oracle Form.
• Created Oracle reports Flash Summary Report, Style & Color Change Report, Blackberry Flash Sales reports etc.

Confidential, Carlsbad, CA

SR. APPLICATIONS DEVELOPER

Environment: Oracle E-Business Suite (R12), Oracle 11g, PL/SQL, SQL* LOADER, TOAD, Oracle BI Publishersharepoint2010

Responsibilities:

• Converted over Terabytes of data from Legacy system to Oracle.
• Involved in following Data Conversion activities:
• Brought legacy data from flat files into Oracle staging tables using SQL*Loader.
• Designed and development of conversion packages applying business rules to cleanse data.
• Created interface programs to load data from staging tables to Oracle Interface tables and base tables.
• Created several UNIX shell scripts, wrappers and data conversion reports for Management.
• Documentation of all Data Conversion activities.
• Tested of converted data used Mercury Quality Center for testing and quality control.
• Designed and developed a custom extension that creates order from single or multiple prescriptions for a Customer. The extension creates one order line for each Rx passed in a collection to Order API.
• Created reports to bring Carrier/Account/Group's details.
• Created adjudication interface to check coverage details.
• Built custom Forms using Oracle Forms 9i/10g Builder to fulfill the business requirements.
• Customized existing Forms.
• Developed several Forms using TEMPLATE.fmb and Customized standard Forms through custom.pll.
• On daily basis supported system to run smoothly with less than 0.3 downtime.
• Modified CAG search Form, Universal Search Form.
• Developed Prescription History Report, Audit Conversion Report, Credit Card Reports.
• Developed Call Card Conversion and Local Eligibility Conversion programs.
• Troubleshot the production issues on various applications replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.
• Created procedures to provided data to Oracle warehouse views.

Confidential, Boston, MA

TEAM LEAD

Environment: Oracle 10g, PL/SQL, T-SQL, TOAD, ERWIN, Oracle Designer, Windows, Data warehousing

Responsibilities:

• Converted user requirements into technical specifications.
• Created standard templates and define nomenclature standards.
• Mentored project team to understand and assign tasks.
• Designed database using ERWIN and Designer 2000 for data modeling.
• Developed very complex procedures, functions and bundled them in packages to pull data from SQL SERVER and populate Oracle tables.
• Tuned PL/SQL, SQL for better performance using Explain Plan Method.
• Wrote complex T-SQL to pull SQL Server data and load into Oracle tables.
• Created Oracle Apex Application from Scratch for Student Survey system.
• Used Waterfall methodology.
• Generated documentation of work.

Confidential

SR. SOFTWARE DEVELOPER

Environment: Oracle 9i, Oracle Server 10g, PL/SQL, Oracle Developer (Forms 10g and Report 10g), SQL Navigator, Windows

Responsibilities:

• Reviewed functional designs, present technical recommendations and alternatives for FD.
• Developed technical designs after functional requirements been approved.
• Designed Database-ERD, Data Integrity, Indexing.
• Developed Oracle Form-9i and Report-9i.
• Created generic modules for team use.
• Wrote PL/SQL packages, procedures, functions and trigger in Oracle 9i.
• Tested application by creating unit test cases.