SUMMARY:

• Over 20 years of extensive experience as Team Lead and Oracle Application Developer.
• Extensive experience as Oracle Applications Developer in implementation, upgrade and customization of Oracle e - Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS. (R12).
• Extensive experience in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Suite.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in HCM, Order Management (OM), Inventory (INV),
• Expert in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient in developing & debugging RICE components (Reports, Interfaces, Conversions, Extensions in Supply Chain Modules (OM, Shipping, INV, PO, WIP) using Oracle SQL, PL/SQL, Forms, Reports.
• Experience in forms creation and customization using Custom.pll and Forms personalization.
• Extensively experienced in Oracle PL/SQL Development I.e. Stored Procedures, Packages, Functions and Triggers, UNIX shell script.
• Experience working on Data Loader, SQL*Loader, SQL* Plus, Oracle Import/Export.
• 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.
• Proficiency with tools used to support Oracle Applications development including OBIEE, Oracle Application Express (APEX), PL/SQL, Forms, Reports, Workflow Builder.
• Extensive experience in developing reports using BI/XML publisher.
• 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 & Oracle FUSION.

TECHNICAL SKILLS:

Oracle EBS: Oracle R12 - Supply Chain Management SCM (OM, Shipping, INV, PO), Order to Cash, 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 Reports,

Oracle 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, PUTTY,

RDBMS: 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 DEVELOPER

Responsibilities:

• Analyzing, developing & supporting of several modules of HCM.
• Lead Succession Planning Project to collect the Requirement Analysis.
• Worked with third party vendor, providing development requirement and monitor progress of Succession Planning module developed using Oracle Fusion.
• Implemented Succession Planning successfully.
• 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 BrassRing & 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.

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

Confidential, Santa Ana, CA

LEAD ANALYST PROGRAMMER

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.
• 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.

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

Confidential, Carlsbad, CA

SR. APPLICATIONS DEVELOPER

Responsibilities:

Data Conversion:

• 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.

Supply Chain management (SCM)

Oracle Order Management:

• 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 to define system Profile Options, Descriptive and Key Flex fields.
• 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.

CRM:

• 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.

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

Confidential, Boston, MA

TEAM LEAD

Responsibilities:

• WFE was useful for students to apply online loans, Management to track loan details.
• 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.

Environment: Oracle 10g, PL/SQL, T-SQL, TOAD, ERWIN, Oracle Designer, Windows, Data warehousing (Informatics and business Objects) and Oracle Financials.

Confidential

SR. SOFTWARE DEVELOPER

Responsibilities:

• Developed a Legal System, which helps attorneys and DOR keep track of individual or organizational legal Issues.
• 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.

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

Confidential, Hopkinton, MA

SR. SOFTWARE ENGINEER

Responsibilities:

• DAVE (Design Assurance Verification Engineering) System. This system helped multiple quality assurance departments exchange data and generate reports.
• Oracle 9i Database design- created tables, Indexes, Sequences and constraints writing scripts to fix the issues in the migrated database objects.
• Responsible for performance tuning administration and security.
• Designed algorithms for processing of information streams and accounts.
• Developed unit test customizations, testing and impact assessment for Oracle bug fixes.

Environment: Oracle 9i, PL/SQL, TOAD. Oracle Developer (forms 9i and Report 9i), Visual Basic, MS Access, UNIX, Windows

Confidential, CA

SR. SOFTWARE ENGINEER

Responsibilities:

• Reviewed functional designs and present technical recommendations and created FD.
• Provided technical support and analysis of application modules.
• Designed the database objects required for the various business functions in Oracle 8i using PL/SQL.
• Identified / Analyzed/ Developed Forms6i and Reports6i.
• Created and maintained documentation according to standards.

Environment: Oracle 8i, SQL, PL/SQL, SQL Loader, TOAD. Oracle Developer (forms 6i and Report 6i), Oracle Discoverer 4i (admin), HP-UNIX, Win-NT

Confidential, Los Angeles, CA

Tech Lead

Responsibilities:

• Wrote database packages, functions, procedures and triggers in Oracle 8i using PL/SQL.
• Used SQL Navigator, Explain plan etc. for performance tuning.
• Created data models using ERWIN.
• Designed strategies for application and database backup and recovery.
• Developed Forms6.0, Report (6.0, PRO*C) for MIS.
• Created reports with embedding Oracle Graphics.
• Wrote UNIX Shell Scripts.

Environment: Oracle 8.0, Oracle Developer (Forms 6.0 and Reports-6.0), Crystal Report, Oracle Graphics 6.0 Oracle Designer 6.0, PRO*C, SQL Navigator, ERWIN

Confidential, Morris Town, NJ

SR. PROGRAMMER

Responsibilities:

• Worked with SQL Navigator for performance tuning.
• Wrote Database Objects such as packages, functions, procedures and triggers using PL/SQL.
• Developed Oracle Forms using Designer/Developer 2000.
• Developed Oracle Reports using Oracle report writer.
• Wrote UNIX Shell Scripts.

Environment: Oracle 8.0, Designer/Developer-2000, Crystal Report, SQL Navigator, HP-Unix

Confidential

TEAM LEADER-DEVELOPER

Responsibilities:

• Created Design specifications based upon a complete system analysis.
• Designed functional and Logical data flow of projects.
• Specified programming standards for forms conversion from 3.0 to 4.5. And for new development.
• Wrote Database Objects like libraries and procedures for GUI support and database using PL/SQL.
• Assigned tasks to project team and tasked with keeping track of work on weekly basis.
• Tested work in units, then modules, and then entire application.

Environment: Oracle 7.3, Developer/Designer-2000, Unix