Oracle Developer

VIJAY M. AHIRE

*** ********, ******, **-*****

Cell: 818-***-****

Email: ******@*****.***

PROFESSIONAL SUMMARY

Over 18 plus years of extensive experience as Team Lead & 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 as Oracle Applications Developer in Oracle Retail Merchandising System (ORMS) & Oracle Retail Price Management (ORPM)

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 Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP).

Expert in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.

Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)

Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers, UNIX shell script.

Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export.

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 Oracle BI Reports, PL/SQL, Forms, Reports, Workflow Builder.

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.

Extensive knowledge of Oracle APEX (Application Express).

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

TECHNICAL SUMMARY

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

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

ERP: ORACLE E- Business Suits-R12 (Supply Chain Management, Order Management, Advance Pricing), ORACLE CRM.

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

RDBMS: Oracle 10g, 9i, 8i, 8.X, 7.X, 6.X

Application Server (Middle Tier): Oracle Application Server 4.0.8

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

Microsoft Tools: MS Word, Excel, Power Point, SharePoint 2010.

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

EDUCATION

BS Computer Engineering Pune University, Pune, India

MS Computer Engineering Pune University, Pune, India

Fundamentals of JAVA UCLA

PROFESSIONAL EXPERIENCE:

The Wet Seal Corp, Foot Hills Ranch, CA Aug 2014 – Current

Sr. Analyst/Team Lead

As a Sr. Applications Developer I am involved in development and support of Oracle Retail Merchandising System (ORMS) & Oracle Retail Price Management (ORPM). ORMS enables retailers to better manage, control and perform crucial day-today merchandising activities from new product introduction to automated replenishment to financial inventory valuation. ORPM provides retailers with a complete rules-based pricing execution engine that supports regular pricing, promotions & clearance across all selling locations & channels.

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 Order_Update to capture changes in order_update_log table when records are Updated/Deleted.

Created Oracle reports Flash Summary Report, Style & Color Change Report, Blackberry Flash Sales reports etc.

Created Unix Scripts to run Batch reports.

Develop & modify Oracle BI Reports.

On call production support.

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

OptumRx (United Health Group), Carlsbad, CA Sep-2008 - July 2014

Sr. Applications Developer

As a Sr. Applications Developer I was involved in development and support of Integrated Prescription Information System (IRIS). IRIS is one of the most critical applications which has functionality to create single and multiple prescriptions, to create order header & order lines, custom Prescription Form, custom Sales Order Form, Auto Refill Program, Auto Fax Generation Program, ePrescription, Adjudication etc.

Data Conversion:

Converted over Terabytes of data from Legacy system to Oracle.

Involved in following Data Conversion activities:

Bringing legacy data from flat files into Oracle staging tables using SQL*Loader.

Design and development of conversion packages applying business rules to cleanse data.

Creation of 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.

Testing of converted data using 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& Customized standard forms through custom.pll.

On daily basis supporting 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.

Troubleshooting the production issues on various applications replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.

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

First Marblehead Corporation, MA May-2006 – Aug-2008

Team Lead

As Team Lead I was involved in Requirement gathering with end users, Converting requirements into design and communicating with developers, training the end users for application called Web Front End (WFE) application for The First Marblehead Corporation in Boston, MA. The First Marblehead Corporation is leading Private Student Loan Corporation.

WFE is useful for students to apply online loans, Management to track loan details.

Converted user requirements into technical specifications.

Created standard templates & 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,

Good knowledge of Data warehousing (Informatics and business Objects) and Oracle Financials.

Commonwealth of Massachusetts-DOR (Massachusetts State) 11/2004 to 04/ 2006

Sr. Software Developer

Developed a Legal System, which helps attorneys & 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 have been approved.

Designed Database-ERD, Data Integrity, Indexing.

Developed Oracle Form-9i & Report-9i.

Created generic modules for team use.

Wrote PL/SQL packages, procedures, functions & trigger in Oracle 9i.

Tested application by creating unit test cases.

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

EMC, Hopkinton, MA 05/2003-11/2004

Sr. Software Engineer

DAVE (Design Assurance Verification Engineering) System. This system helps multiple quality assurance departments exchange data & generate reports.

Oracle 9i Database design- created tables, Indexes, Sequences & 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 & Report 9i), Visual Basic, MS Access, UNIX, Windows

MSU Software Consultants, CA 03/2002-05/2003

Sr. Software Engineer

Accounting System

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.

Identify / Analyze/ Develop Forms6i & Reports6i.

Created & maintained documentation according to standards.

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

Warner Music Group Burbank, CA 01/2001-03/2002

Data Analyst

Daily Global Sales System (GDSS): Keeping track of global sale of music records.

Provided system requirement analysis and specifications.

Developed technical designs once functional requirements have been approved

Created data models using CASE tool ERWIN.

Applied experience in production database availability, DBMS monitoring and tuning, production on-call support, database procedure analysis, development and implementation, as well as database security support.

Created Database objects like tables, views, users, Schema etc. & assigning roles/privileges in Oracle 8i using PL/SQL.

Defined Data Mapping & data transfer strategies

Wrote Unix Shell Scripts

Developed unit test customizations and extensions to meet technical specifications.

Environment: Oracle 8i, PL/SQL, ERWIN, TOAD. HP-UNIX, Windows-2000

Warner Bros. Los Angeles CA 08/1999-12/2000

Leading Front End Application Development Team

Executive Management Information System II:

Wrote database packages, functions, procedures & 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 & 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 & Reports-6.0), Crystal Report, Oracle Graphics 6.0 Oracle Designer 6.0, PRO*C, SQL Navigator, ERWIN

Dendrite International Inc. Morris Town NJ 07/1998-08/1999

Sr. Programmer

SB-Monthly Data Processing:

Worked with SQL Navigator for performance tuning

Wrote Database Objects such as packages, functions, procedures & 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

MBT (Mahindra British Telecom) Pune, India 11/1994 -07/1998

Team Leader

Planning and Assignment & Configuration System (PACS):

Created Design specifications based upon a complete system analysis

Designed functional & 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 & 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

Contact this candidate