SUMMARY

• Over 9 plus years of IT experience in the area of Analysis, Design, Development, Testing, Implementation and Production Support of various business application systems, Confidential E - Business Suite 11i & R12 Financials, Manufacturing and HRMS Modules.
• Over 4 plus years of extensive working experience as an Confidential Application Developer. Good command over Technical/Functional aspects covering Customizations and Interface/Conversion works in Confidential Applications. Worked extensively on AOL, Finance Modules (GL, AP and AR), Distribution Modules (Order Entry/Shipping (OM), INV, PO etc.), Confidential HRMS
• Experience includes Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical or functional issues
• Over 10 years of strong experience in Confidential 11g,10g/9i/8i, Confidential Forms 6i/5.0/4.5, Confidential Reports 6i/3.0/2.5, Jdeveloper10g, PL/SQL, SQL, SQL* Plus, SQL* Loader, Java, JSP and Confidential Tuning tools TOAD, SQL*Navigator
• Rapidly acquire new skills on the job and have excellent communication skills. Have Confidential good understanding of both functional as well as technical aspects of Confidential Applications.
• Good experience in Design, Data Mapping and development of Interface and Conversions in Confidential 11i E-business suite of Applications.
• Have worked with Design Documents (MD50, MD70)
• Good experience in working with Confidential Discoverer6i (Administrator and Desktop) and XML Publisher.
• Good Experience in working on SR’s with Confidential Support via Metalink.
• Good experience in Customizing Forms, Reports, Custom.pll, Designing Alerts, Creating Functions, Procedures, Packages, Triggers, SQL,PL/SQL and Forms Personalization(FP) in Confidential 11i & R12 E-business suite of Applications.
• Good experience in using the Application Desktop Integrator (ADI) / Dataloader, SQL*Loader for Data load activities.

TECHNICAL SKILLS

Confidential ERP: Confidential ERP Applications (R12,11.5.10,11.5.7,11.5.4), Order Management, Confidential Purchasing, Confidential Inventory, Accounts Receivable, Accounts Payable, General Ledger, AOL, System Administration, Confidential Workflow, Confidential HRMS.

Confidential Tools: Developer2K(Forms4.5/5.0/6i,Reports2.5/3.0/6i), Jdeveloper10g, Discoverer9i/10g, SQL* Loader, Export, Import, Explain Plan, TKPROF, XML Publisher

Databases: Confidential 8.x/8i/9i/10g/11g, MS SQL Server 2000, MS Access2000

Operating Systems: UNIX (Solaris 2.x, Confidential 10.x), Linux, Windows NT/XP

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

Other Tools: TOAD, PVCS, FTP, Case

PROFESSIONAL EXPERIENCE

Confidential, Bloomfield, NJ

Sr. Application Programmer/Manager

Responsibilities:

• Developed various customizations to Confidential applications to satisfy the business needs
• Lead IT department to support Confidential financial & supply chain modules
• Implemented EDI project to automate the Order processing.
• Supported all the users on daily basis on any given issue in the Confidential applications & IT related activities.
• Done the Conversion of Master Items in Confidential
• Involved in R12 implementation of different Modules WIP, Channel, Inventory, Financials & Purchasing.
• Participated in Steering committee meetings to give proper updates on the IT related activities
• Support the users on the Channel Rev & WIP to process the transactions to meet the Revenue requirements.
• Maintained proper documentation (MD50 & MD70) of all the changes that being made to the system.
• Managed the Off-shore team to satisfy the company needs.
• Developed various levels of management reports to show the forecasts, Sales & financials data.
• Involved in set up of Demantra for forecasting of the Sales. Also make sure the data is interfaced between Confidential and Demantra smoothly.
• Helped the business to set up Spread sheet server for financial report purpose.
• Supported the business on “Month-end” close of Financials and any other sub-ledgers and fixed all the issues quickly.
• Supported the Customer service to process the Orders smoothly and bill them.
• Helped the users on Auto-Invoicing, Payables invoicing& payments and transferring of transactions into GL.
• Rectified any system errors related to Un-posted transactions, Trial Balance, inventory, Drop-ship order errors to name few.
• Helped the users to set-up & make use of Web ADI to enter the journals into GL.
• Developed Customer facing Invoice document, Concur interfacing & ADP interfacing of payroll data.

Environment: Confidential Applications 11.5.10 & R12.1.3 (Supply Chain& Financials), Purchasing, Inventory, WIP, Channel Rev, Confidential 11g, Demantra, EDI, XML Publisher 10.1.3.2, Confidential Reports 10g, PL/SQL, Confidential Forms 10g, SQL loader, TOAD,Linux

Confidential, Oakland, NJ

Sr. Confidential Application Programmer/ Analyst

Responsibilities:

• Participated in Confidential R12 activities during the implementation process.
• Developed various Order Management Reports
• Created the interface for Bill Of Materials, Items, price lists and Customer Items from third party systems to Confidential as per client requirements. Participated in data analysis prior to conversion.
• Created SMTP email pl/sql program to send emails to users to notify of the new BOMs created in Confidential .
• Helped users to setup the price lists for the items in advanced pricing.
• Developed Packing Slip, Bill of lading, Pick Slip Reports using Xml Publisher
• Knowledge of Order Management and Financial Modules, Customers, Sites, Locations TCA and Suppliers in TCA.
• Functional knowledge of creating Sales orders, shipping, Auto invoicing or Order to cash
• Functional knowledge of Procure to Pay Cycle. Creating PO, PO Receipts, AP invoice against PO and check payments.
• Created open/closed PO orders report to run daily basis.
• Customized the AR Standard Customer Invoice, AR Aging Buckets report and AR Customer Statement as per client needs.
• Developed the AP Check Printing for payments using Xml Template. Did many iterations of testing with Bank before finalizing the template.
• Helped the users on the GL-period closing & Create accounting. Continuously assisted the client on Production support
• Developed GL Account Analysis reports by drilling down from XLA to Sub ledger transactions.
• And also developed various internal documents for users including Sales Order, Sample SalesOrder, Shipping Memo, Sales Fore casting & Sales Commission Reports.
• Created shell scripts to send the Customer Invoice through E-Mail.
• Guided/trained the other developers on the Confidential tool set.
• Created interfaces to transfer the data from Confidential to other systems on scheduled basis
• Helped users on the i-Procurement related issues.
• Modified the Standard XML views for PO communication documents(Procurement), such as Standard PO, Blanket PO and Blanket Release.
• Created DFFs to save additional Sales Reps information. Also helped other developers to load the data from other systems.
• Supported Client after go-live by fixing various document issues and interface issues.

Environment: Confidential Applications R12.1.3 (Supply Chain& Financials), Procurement/i-Procurement, Inventory & BOM Confidential 11g, XML Publisher 10.1.3.2, Confidential Reports 10g, PL/SQL, Confidential Forms 10g, SQL loader, TOAD,Linux

Confidential

Sr. Programmer Analyst

Responsibilities:

• Did conversion of employee Documents of Records into Confidential R12
• Developed Employee compensation, Fiscal Year reports using Confidential Discoverer.
• Developed custom OAF pages to approve part-time worker hours, used Java to create underlying Controller code. Used OADB Transactions to communicate with database from Java pages.
• Developed payroll automation script to transfer the employee benefits data from ftp server to Confidential R12 applications.
• Developed HR-FastFormulas to calculate employee PTO Accruals
• Generated the Employee Benefit feed files in the server using UTL FILE utility for the health care providers.
• Used Unix shell scripts for automation and data loading purposes
• Knowledge of Confidential HR and Payroll table architechture.
• Debug and developed several HRMS reports using Discoverer.
• Created APIs to load the employee balances into Confidential HR.

Environment: Confidential Applications R12 (HRMS, iRecruitement, Financials ), Confidential 11g,, XML Publisher 10.1.3.2, Confidential Reports 10g, PL/SQL, Discoverer10.1.2, Confidential OA Frame Work, TOAD,Linux, Confidential On-Demand, PVCS Version Control System

Confidential, Parsippany, NJ

Sr. Programmer Analyst

Responsibilities:

• Participated in writing the HRMS interfaces to transfer the employee information from legacy systems to Confidential R12 applications.
• Involved in fixing the R12 issues such as modifying the existing interfaces to reflect R12 data model changes. Ex: Suppliers & Banking Information.
• Developed GL Account Analysis report and Un-accounted transaction reports to drill down the transactions by Sub-Ledger accounting(XLA) using XML publisher.
• Involved in writing interfaces to transfer the Cost-Centers from legacy systems to Confidential R12 applications.
• Generated the Employee Benefit feed files in the server using UTL FILE utility for the health care providers.
• Knowledge of Sub-Ledger Accounting (XLA) feature in R12.
• Knowledge of Suppliers architecture integrated with TCA in R12.
• Knowledge of AR Customers architecture in TCA.
• Created APIs to load the invoices into AR.
• Used PGP to encrypt the Employee secured information before sending to the ftp server.
• Created Employee Profile and Information Reports using XML publisher and PL/SQL interfaces.
• Created technical and business specification using MD70s and MD50s.
• Knowledge of Sub-Ledger accounting to drilldown the sub ledgers up to line level.
• Involved in the personalization of the Confidential HR modules.
• Tuned the interfaces and reports using TK-PROF and Explain Plan utilities.
• Involved in fixing the Positive Pay files to handle the void-checks for banks.
• Fixed the seeded reports to accommodate Client’s customizations.
• Generated the Accounting info in the ftp server for Price Water Coopers using dynamic sql and shell scripts.
• Setup the flex fields for reporting purpose.
• Helped users to understand both technical and functional aspect of creating new-hires, re-hires and reverse terminated of the employees.
• Support the user both functionally and technically.
• Written test plans and UAT documents for users

Environment: Confidential Applications R12 (AP,AR,GL & HR, iRecruitement ), Confidential 11g,, XML Publisher 10.1.3.2, Confidential Forms 10g, Confidential Reports 10g, PL/SQL, Discoverer10.1.2, TOAD,Linux, PVCS Version Control System, Control-M.

Confidential, Montvale, NJ

Sr. Programmer Analyst

Responsibilities:

• Participated in writing the HRMS interfaces.
• Involved in the payroll costing and gl transfer, and then figured out the journal entries.
• Support the user both functionally and technically.
• Developed invoice reports, employee & balance reports using the xml publisher & Confidential reports.
• Developed interfaces to write the files to the server.
• Participated in Payroll support every week and make sure payroll finishes successfully.
• Setup the flex fields for reporting purpose.
• Involved in forms customization and personalization.
• Developed the documentation for R12 upgrade and involved inR12 upgrade preparation. Helped upgrade the forms for R12.
• Involved in performance tuning of reports & interfaces.
• Written multiple shell scripts and sqlloader control scripts for migration purpose.
• Created custom OAF pages to create jobs and stores online.Used custom tables and built the java pages using MVC architecture.
• Developed view objects, EOs and controllers for create, update and delete.

Environment: Confidential Applications 11i 11.5.10 & R12 (HRMS PAYROLL & Benefits,AP,AR,GL), Confidential 10g/11g, Forms6i/Reports6i, XML Publisher 10.1.3.2, PL/SQL, Discoverer10.1.2, TOAD,Linux, PVCS Version Control System, Control-M.

Confidential, Paramus, NJ

Sr. Programmer Analyst

Responsibilities:

• Involved on Customer conversion from mainframes to ERP (AR).
• Participated in people (employee) conversion from mainframes to Confidential ERP.
• Made personalizations and extensions to the screens using OAF (MVC architechture)
• Developed Employee profiles report.
• Knowledge of Confidential Financials.(GL,AP,AR)
• Involved in the OM functional setups such as price lists for each organization, shipping documents, printers, granting the roles to the users to access the shipping functionality.
• Involved in the Item imports and Item price lists migration.
• Developed many OM Reports using XML publisher tool as per the business people request and integrated the reports6i with XML P. Developed Delivery ticket and Pick list reports in Order Management to show the customers what items will be in the shipping.
• Maintained the MD50’s and MD70’s documents for business analysis and developing requirements.
• Developed GL journals report using Discoverer.
• Involved in the analysis and design of the OM reporting, which includes the Order quotation reports as well as Order Confirmation reports.
• Communicated with end users to get the business requirements and developed the code as per the users request.
• Automated the reports printing, to the particular report to print at the particular branch printer.
• Analyzed technical problems, data issues, reports and other custom packages.
• Co-coordinated with offshore team and explained the business requirements.
• Developed the various reports for Germany, such as Item movement’s reports and Invoice reports.
• Developed the AR invoice prints for each organization using XML Pub.
• Developed Sales Volume reports, in which the report will shows the Salesperson revenue by branch (location), Product Group, Revenue Category and Customer. Again this was done using XML Pub
• Involved in the functional setups such as different request groups for each organization and assign them to the org level responsibilities. Also created the Descriptive flex fields to satisfy the business needs.
• Involved in the functional setups such as different request groups for each organization and assign them to the org level responsibilities. Also created the Descriptive flex fields to satisfy the business needs.
• Used FNDLOAD tool to migrate the scripts extensively between development and QA environments.
• Proactively communicated with users to solve the onsite issues & bugs at the branch level.
• Written the unit test case documents for users to test the functionality.
• Fixed several bugs to existing reports and functionality.

Environment: Confidential Applications 11i 11.5.10 (OM, Inventory, HRMS, Projects, QP (Advanced Price lists), AR, AP, GL), Confidential 10g/9i, Forms6i/Reports6iXML Publisher 10.1.3.2, PL/SQL, Discoverer10.1.2, TOAD, Linux, RCS Version Control System, PLM (Project Life Cycle Methodology).

Confidential, Mahwah, NJ

Sr. Programmer Analyst

Responsibilities:

• Involved in the business edge design and analysis of the Selling, Booking and Ticketing.
• Created scripts for the object types, PL/SQL tables, tables to build the database.
• Created Interfaces, in ERP to load the Customer’s data and their Contact information from legacy systems.
• Created Confidential Concurrent Program to generate Confidential file in FTP server on Confidential daily basis for the outside Customers.
• Developed Synchronization Concurrent programs to synch the data from Custom database to ERP database.
• Developed Receipts related Interfaces depending on Business requirements and User requests.
• Involved in one full cycle of implementations, as Designing Development QA testing Prod Deployment.
• Communicated with the QA team to resolve issues when the system was up for testing.
• Involved in Performance tuning in the coding such as Hints, Explain Plan to produce better results.
• Use FNDLOAD tool to easily download/upload concurrent programs from one instance to another.
• Used Strong PL/SQL to develop packages. Used dynamic SQL/ Confidential supplied packages DBMS, UTIL and object types and nested tables to return the data.
• Used DB links to access the data from Custom Data base to ERP database.
• Created Snapshots to collect the latest data, refreshed periodically in the database.
• Involved in the complicated database design that includes Object types and table of object types and table types to generate the data in Receipts related tables, in which the data is coming from Confidential Java front end. Resolved many issues in this manner.
• Functional knowledge of Credit memos, Debit memos and Customer concepts and Transactions (Invoices) and Receipts concepts in AR.
• Knowledge of Transactional Detail Report in AR. Technical Knowledge of AR such as AR interfaces and AR tables.

Environment: Confidential 10g/9i, Forms9i/Reports 9i, PL/SQL, Discoverer, Star TeamTOAD, Business Objects, Bugzilla, Csupport, Confidential 11i (11.5.9), Financials (AP, AR & GL) Confidential is Confidential one of the biggest travel services company. Confidential ERP 11.5.9 is Confidential major applications to manage Financials, Order Management and Projects. Involved in the decoupling project, which is Confidential separate Order Processing system outside Confidential ERP, which synchronizes the data between Java front end and Confidential ERP.

Confidential, Summit, NJ

Developer

Responsibilities:

• Involved in the business edge design and analysis of the Order Processing System
• Developed extensive coding in Order Management.
• Did customizations to the Forms and Reports as per Client Requirement.
• Developed the API’s to call the database objects indirectly from the forms and reports
• Used the API’s for DML operations in the front-end development.
• Worked closely with the team in the development process.
• Used PL/SQL Developer to develop the API’s.
• Used the REF Cursors, packages, procedures and functions in the PL/SQL.
• Developed the calls from one Database to another, using snapshots and temp tables.
• Worked in the Inventory module to maintain the lots for drugs.
• Developed various reports for maintaining lots for drugs, shipment of drugs, return details of drugs, free goods drugs and sales order drugs.
• Developed the QA unit test cases for Order processing system.
• Participated in the QA to test the system before deploying it to QA team.
• Involved in full development cycle as Analysis & Design, Prototype, and Development Unit & Integration Test Cases.
• Used the PVCS technologies to secure the product development.

Environment: Confidential 9i, Forms9i/Reports 9i, PL/SQL/, Discoverer, PVCS, TOAD, Stored Procedures Celgene is Confidential multinational biopharmaceutical company, Involved mainly in Celgene’s Order Processing project which uses the custom forms, reports and interfaces. Interfaces are designed with great complexity and lots of business rules.

Confidential

Developer

Responsibilities:

• Worked in Product Improvement in Confidential Apps.
• Worked in product development for the client.
• Added customizations to the Forms and Reports using 6i tools.
• Developed Excel and PDF format reports from Confidential Reports.
• Worked in the Confidential migration using FNDLOAD (Pl/SQL) programs to migrate the data from one version to the other version.
• Participated in Confidential Applications migration for SYSADMIN, INV and AR modules.
• Developed the API’s PL/SQL procedures, functions and packages in the development.
• Provided API ‘s in the FNDLOAD programs to insert the data into the tables and update the tables.
• Wrote the technical specifications for product customizations. Used Microsoft Visio to develop the ER diagrams in the Technical Specs.
• Used ClearCase, ClearQuest and PVCS technologies to secure the product development.

Environment: Confidential 8i, Forms6i/Reports 6i, PL/SQL/, Discoverer, Confidential 11i, Applications 11.5.8 (SYSADMIN, Inventory, AR, AP, GL) Applimation is the global provider of enterprise data management solutions, in data archiving, Migration, data on demand, data subset products for Confidential, SAP, Confidential, Siebel and custom applications across multiple database platforms. I mainly worked in data migration products for Confidential ERP Applications.

Confidential, Wayne, NJ

Developer

Responsibilities:

• Helped the client in converting Applications from non-multi org to multi-org applications and doing QA for all Financial modules (GL, AP, AR, FA, iProcurement) and making sure all custom programs work well with multi-org enabled database.
• Did data requirement analysis, mapping and developed interface program with integrating Confidential HRMS Employee tables data to non- Confidential application using API’s for iExpenses implementation.
• Customized Invoice print report in Accounts Receivables according to the client’s requirements.
• Did the AR Interface to load invoice data to AR tables.
• Customized related Database views and Java class objects.
• Worked on Performance Tuning of SQL queries using EXPLAIN PLAN utility
• Developed reports using Discoverer 4i and Report Builder 6i
• Defined Key Flex field Structures
• Enabled Descriptive Flex field as Confidential part of Customization in AR Transaction form.

Confidential, Richmond, VA

Applications Consultant

Responsibilities:

• As an Confidential Implementation Technical Expert worked on conversions to transfer data from legacy system to Confidential applications by using SQL*Loader, developed PL/SQL code for validating data in temporary tables and populating into Confidential interface and base tables.
• Worked on Conversion of History Invoices. This conversion is done to provide historical information for invoices and prevent the user from entering duplicate invoices for particular Vendor.
• Involved in the analysis and design of the technical documentation, column mapping and data mapping. Involved in writing the code for conversions.
• Worked in the customization of reports like Invoice on Hold Report, Final payment Register report, Invoice history details Report.
• Developed Shell scripts.
• Customized Forms and Reports to client’s requirements in Accounts Payable, Order Entry and Accounts Receivable.
• Transferred the client’s legacy system data to ‘interface tables’ using SQL * Loader.
• Identification of patches needed to resolve critical production problems.
• Schedule, coordinate and assist in testing of patches, upgrades and program modifications.

Environment: Confidential 8i, Forms6i/ Reports6i, Solaris 5.6, Confidential GL, PL/SQL

Confidential

Confidential Developer

Responsibilities:

• The project aims at developing billing software for the telecommunication industry, comprised of various modules like marketing and sales, dealer management system.
• Integrated Billing and Inventory Software for TELCOS (IBIST)
• Creating primary objects (tables, view, indexes, roles)
• Enrolling users and maintaining system security.
• Designed and coded forms in Dealer management Module.
• Analyzed, designed and developed screens and menus for catering to the needs of the distributed database setup.
• Managing users/creation of user profiles.
• Created new reports for the Billing Inquiry, Summary reports and Inventory detail reports.

Environment: Confidential 7.3, Forms 4.5, Reports 2.5, SQL, PL/SQL