SUMMARY:

Oracle Applications Developer with more than 26 years of experience in the design, development, and implementation of Client/Server applications. Has utilized Oracle Forms 4.5/6.0/6i, Oracle Reports 2.5/6.0/6i, 10 G Forms,10G reports, BIP, SQL*Loader and PL/SQL to develop and enhance a variety of manufacturing applications. Excels in writing database triggers, stored procedures, and packages. Extensive experience in conversion, interface, and customization development to Oracle Applications including Financials, Manufacturing, and Human Resource modules on 10.7/11i. Extremely experienced in using AOL standards and coding standards in product development for Oracle Process Manufacturing GEMMS Physical Inventory and Process Operational Control.

TECHNICAL SKILLS:

Hardware: IBM PC’s and Compatibles

Networks and Operating Systems: MS Windows 95, Windows XP, Windows 72000/NT 4.0, SCO Unix, Sun Solaris, HP - UX

Languages: C, SQL, PL/SQL, COBOL, Shell Scripts

Database: Oracle 7.x/8i, 9i, 10G FoxPro 2.6

Software and Tools: Oracle SQL*Plus, Oracle SQL*Loader, Oracle Developer 2000/6i, Oracle Forms 4.5/6i, Oracle Reports 2.5/6i, MS Visual FoxPro 3.0, Turbo Analyst, Toad, StarTeam, Service IT.

Applications: Financials (10.7 / 11i Accounts Payable, Accounts Receivable, General Ledger), Oracle Process Manufacturing (GEMMS), Purchase Order, Manufacturing, Order Entry, Bill of Material, Human Resources, Inventory, Loyalty

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, MN

Senior Oracle Applications Developer/ Report Developer

Responsibilities:

• Involved in researching oracle seeded API’s and PLL’s and modifying oracle seeded forms using CUSTOM.PLL for various modules. Forms such as Sales Order / Order Organizer (OEXOEORD), Price and Availability (OEXOEAVA), Peoples Form for HR, Batch Element forms for Payroll are few of the customizations.
• Developed various dynamic zooms on Sales Order form based upon the fields. As a reports 6i developer, developed and maintained various reports for Order management, HR and Payroll. Created various wrapper scripts using UNIX shell for concurrent programs.
• Developed and maintained various interfaces for different modules using Oracle Seeded Open API’s. During the development process of PL/SQL programs and reports, performance tuning was the top priority. Also involved in a JAVA project, End User Handoff Project which was a custom project based upon Oracle’s Drop ship Module. Learnt Java / HTML /Java Script and IFRAME technology on the project.
• Created a web form for this project which was used to handle discrepancies from the orders created by the end user. Was also responsible for registration of forms/reports/interface and attaching them to proper menus/request groups for concurrent programs. Created various value set for concurrent program definitions and DFF’s.
• Participated in other small projects such as upgrading existing decision support forms to forms 10G. All of my activities and contribution required close interaction with the Business Analyst/Users and come up with design/solutions and develop technical documentation. All of these activities had to follow company standard and SOX policies.

Senior Oracle Applications Developer ( Workday )/ Report Developer

Confidential

Responsibilities:

• Primary role involved converting 44 countries data and provide close to 55 flat files to workday system.
• The files contained employee information, payroll data, addresses, benefits.
• The whole conversion process involved reading a consolidated file and loading 715 columns into a staging table.
• Used conversion technics such as reading the data, validate the data and translated the data.
• All errors were reported to the business for corrections.
• Once corrections were done, the process was rerun to see the errors were eliminated.
• Maintained translations tables and validation tables.
• Had to use dynamic SQL due to high number of the columns.
• Wrote Interface script to load Workday Labor information to be imported to the legacy labor application using several Oracle seeded API’s.

Senior Oracle Applications Developer

Confidential

Responsibilities:

• Senior Oracle Application Developer, participated in implementing EMEA WMS system.
• Primary role involved Writing a batch process to process all eligible shipments in R12 and validating, translating transferring the data to WMS system.
• This was a scheduled batch process which would run few times a day.
• Generated 14 CFD such as customer specific packslips using Crystal reports.
• The work involved working closely with business analysts.
• Participated in US WMS implementation.
• The work involved writing a interface for distribution orders to be transferred to the new upgraded WMS system.
• The transfer of data for both regions was done using SOA middleware.

Senior Oracle Applications Developer

Confidential

Responsibilities:

• As a RICEW team member, developed various conversion extract scripts for Inventory Items, item costs, Item categories, Employee conversions from Oracle R11 to be imported into Oracle R12 for all regions.
• Conversions involved extracting data from Oracle R11 and validating, translations and generating pipe delimited file to be fed to Oracle R12.
• Developed various BI publisher reports. Basically, converted few of the R11 reports to Oracle R12.
• Wrote various forms personalization’s and Custom PLL’s.
• Wrote scripts for post conversions to get the delta records for Catalog Group Item Update, Cost Management, Inventory Category, Product Branding, Product Strategy PIM Update.
• Migrated Oracle Alerts from R11 To R12. This required to write around 90 FNDLOAD (Upload and Download) scripts.

Confidential, Bloomington, MN

Senior Programmer / Analyst

Responsibilities:

• Responsibilities included developing custom forms and reports for modules Work in Process and Order Entry(11i) The major features for Pool Tool module includes developing forms/reports and integrating it with Oracle Work in Process Module. This module has the following function.
• Assign and re-assign jobs to production lines, view total sheets assigned to each production lines, dynamically find jobs and related information to determine jobs to release to the shop floor.
• Created query forms for Order Entry module. Also involved in developing scripts to update templates for inventory items for specific organizations. These modules are still in the testing phase Tools used are Oracle 8i, Forms 6i and Reports 6i, pl/sql and Oracle Applications 11i.

Confidential, Arden Hills, MN

Senior Programmer / Analyst

Responsibilities:

• Responsibilities included writing interfaces for different vendors and supporting the Humanic software in the day-to-day activities.
• Loaded open enrollment benefits data into the Humanic Application after the enrollment process was completed.
• Analyzed and validated the data and generated error reports from the load.
• Used PL/SQL and Oracle Forms 4.5 to develop scripts and interfaces, and generated data files in various formats for different vendors .
• Understanding the database schema was essential to achieving the task.
• Also involved in providing data to Oracle 11i Advance Benefit module.
• Created concurrent programs to load data into custom tables and provided query forms for the load.
• Maintained tight deadlines to ensure the medical cards were generated on time.
• Utilized Oracle 7 (7.3.4.2.0)/8i, PL/SQL release 2.3.4.2.0, and Oracle Forms 4.5/6i during this project.

Confidential, Eden Prairie, MN

Senior Programmer / Analyst

Responsibilities:

• Was involved in supporting the development of custom reports for General Ledger module and performed responsibility set-ups. Wrote database procedures and functions for day to day routines.
• Implemented security features for Retek and used stored procedure to encrypt and decrypt password.
• Mentored 3 junior programmers responsible for reviewing code before it was moved to production. Served on an on-call rotation with Accounts Payable invoices, and open interfaces.
• Researched the internal table structure to fix reoccurring issues with the process.
• Tools used included Oracle Forms 6i, Oracle Reports 6i on an Oracle 8i (8.1.6.2.0) database.

Confidential, Boston, MA

Programmer / Analyst

Responsibilities:

• The system also had the facility to create templates and reports for a particular organization including the person (s) under it. The templates were then assigned to other users in the form of packages.
• Other activity involved writing stored procedures, functions and database triggers. Utilized Oracle Forms 6i, Oracle Reports 6i on an Oracle 8i database. Also used Native Dynamic SQL to find reports along with the parameters and values.

Confidential, Minneapolis, MN

Programmer / Analyst

Responsibilities:

• For the SouthWestern Bell project, developed the system to load various files and generate reports and points. Every month BI receives various confidential files and these files were processed using the business rule provided.
• Based on the processing, the points are awarded and then can be redeemed through direct deposits, gift certificates or merchandising.
• Also developed various forms to process data in addition to developing the customer service interface for the information coordinators. Used Oracle Forms 6.0, Oracle Reports 6.0, and SQL*Loader. Assisted in fixing bugs in production.
• Worked on the Premier Reward Application Program. This system includes redemption of points based upon number of transactions done by Confidential .
• The files were sent to the client every month and processed using the business rule specified then the points are awarded in terms of perks and cash.
• Developed the complete check printing process.
• Developed various complex forms using Developer 6.0 and Oracle Reports 6.0 to generate reports.
• Developed stored procedure, database triggers, and a Unix process to load files on regular interval. Also used dynamic record groups for processing.
• Was also responsible for developing Interactive Voice Recognition (IVR) to capture the store visits and the survey information provided by sales representatives.
• The sales representative and stores files were loaded using SQL*Loader/text io/utl file handling.
• Numerous stored procedures were developed using PL/SQL to achieve code modularity and reusability. Various reports including the work force of sales representatives to different stores were generated using Oracle Reports 6.0. Assisted in fixing bugs in production.

Confidential, Edina, MN

Application Object Library Administrator

Responsibilities:

• Migrated Oracle Applications AOL objects to various worldwide databases and monitored the process for proper sequencing.
• Assisted the Developers in understanding the migration process.
• Performed AOL setups for third party tool (Chain Link Migrator) when a new database was created.
• Provided support to the Developers, performed troubleshooting, and wrote Shell Script and AWK scripts to maintain the files.
• Set up cron jobs for background processing. Performed Alert migration.
• Used SQL and PLSQL to query data from the Foundation Tables.
• Wrote database triggers, stored procedures, and packages.
• Used an Oracle 7.x database on a Sun Solaris platform as well as Oracle Applications AOL Migration, Chain Link Migrator, PL/SQL, SQL, Oracle Forms 4.5, Oracle Reports 2.5, SQL*Loader, Creating Responsibilities; and Registration of Forms.

Confidential

Software Engineer

Responsibilities:

• Implemented Query Find Windows, Special Menus, Alternate regions for new forms. Followed APPS coding Standards and User interface. participated in the testing and documentation of the Physical Inventory module.
• Was one of the team members in Quality Control who tested AOL standards and Code Walks for a variety of modules, including System, Costing, Production Management, Formula Management, and Laboratory Management. Application Object Library (AOL); Creating Responsibility for Physical Inventory; Registration of new forms for Physical Inventory.