We provide IT Staff Augmentation Services!

Sr. System Support/development Administrator Resume

Reston, VA

SUMMARY:

  • Over 15+ years of strong analysis, design, development, testing, UAT support, implementation and post implementation support experience in Oracle applications 11i and R12 EBS Suite. Solid data conversions, interfaces, customizations development and implementation experience in Oracle Financials as well as Oracle CRM 11i, R12 modules. Excellent business system analysis on Purchasing, iProcurement, iExpense, Order Management, Inventory, Oracle shipping, Core and Service Contracts, Oracle Workflow, Accounts Payable, Account Receivables, HRMS, Employee Self Service, Fixed Asset, Project Accounting, Cash Management, Oracle Asset Tracking. Excellent development and support skills all RICEW objects, PL/SQL, EDI Gateway, BI Publisher, and OA Framework.
  • Excellent experience in developing Extensions, Data conversions, Interfaces and up gradation of Oracle 10.7, 11i.03, 11i.5.9, 11i.5.10 and R12 Financials and CRM modules.
  • Well experienced in Oracle Fusion cloud in HCM and P2P.
  • Worked in OA Framework to change the self - service display format and developed extensions to enhance web page look and navigation. Developed data entry screens using Oracle Fusion Middleware.
  • Excellent experience in Federal contracting specifically Oracle Purchasing and iProcurement integration with Compusearch PRISM.
  • Implemented full life cycle projects in Procure to Pay, Order to Cash, Supply Chain Management, Inventory, Shipping, Federal Financials, iProcurement and core purchasing module.
  • Carried out end to end integration between iProcurement, purchasing, Payables, Fixed assets, HR, Project Costing, quoting, TCA, Pricing, Order Management, Inventory, Accounts Receivables and GL.
  • Strong Shell Scripts, kron Jobs, SQL, PL/SQL, Workflow, Forms, Reports, Alerts, Triggers, XML/BI Publisher development skills.
  • Designed and developed complex XML/BI Publisher reports by incorporating Data Templates, data definitions, Layout template in PO, OM, WSH, INV, AP, PA and most of the EBS modules.
  • Experienced in designing and maintaining of change management documentation, SOX Audit documentation, Unit test and UAT documents.
  • Knowledge of Discoverer 10g/11g Administrator and development Experience, including maintenance of Business Area and Work Book.
  • Documented design, development, test methodologies and test plans in most of the projects.

TECHNICAL SKILLS:

Oracle Tools: Oracle Forms 10i, Reports 10i, Workflow 2.6.3.5, TOAD, DataLoad, JDeveloper.

Operating Systems: UNIX, LINUX, Windows NT 4.0, Windows 95/98/XP/2000 server.

Fusion: BPEL, IDM, BPM, APM, BI

Database: Oracle 6.x/7.x/8.x/9.x/10g, SQL Server 7.0/2000, DB2, MS Access.

Web Technologies: HTML, ASP, Java script, Java.

Web Servers: IIS, Apache

Reporting tools: SQL Report Writer, Crystal Reports, SQR Reports, Oracle Report 6i, Writer 2.5, Oracle Discoverer 9i/10g/11g, BI Publisher, SQL Developer, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. System Support/Development Administrator

Responsibilities:

  • Developed shell scripts to transfer files from external servers to internal servers for daily currency rate exchange, Pride/Rivermine invoices, Scanone invoice.
  • Assigned folder and BI report permissions to end users
  • Gathered requirements and converted reports from PSFT HR into Oracle HCM cloud and developed new reports.
  • Developed reports such as Time and Labor, Talent Management, Absence Management, Payroll, Recruitment, Enrolment reports in HCM.
  • Developed and scheduled new hire, re-hire, weekly employee termination reports in HCM.
  • Built parent and child data groups for HCM data extracts.
  • Expert in Fusion HCM and P2P functionality.
  • Designed and developed interfaces for file transfers for PO’s, ANS, external invoices using Mulesoft between internal and external systems to Oracle Fusion replacing EDI.
  • Created reports using subject areas in Fusion OTBI.
  • Developed and maintaining requisition and invoice import process.
  • Developed and implemented requisition/PO/Invoice approval gates and continued support.
  • Primary support for Blackboard HCM and P2P daily support.
  • Developed and loaded PSFT GL data into Oracle Fusion GL.

Confidential, Austin, TX

Sr. Oracle Apps Lead Consultant

Responsibilities:

  • Converted Inventory Master Items, Item Org Assignment, Categories, Sub-Inventories, Locators, Item instance from ServiceNow into Oracle EBS.
  • Performed customer data conversion from ServiceNow system to Oracle applications.
  • Gathered requirements on new enhancements and customization based on business needs.
  • Researched sourcing and blanket purchase agreement functionality and implemented with ease.
  • Developed and imported iSupport users, Contracts, Service Requests into Oracle CRM.
  • Enhanced and extended the Agent Dashboard page for custom functionality in Oracle OAF.
  • Excellent in supporting end users in financials and CRM modules on production support issues.
  • Developed data conversions and interfaces between ServiceNow to Oracle CRM. Performed data conversions for Customer locations, Service requests, Tasks and Notes.
  • Developed and implemented PO, ASN, Sales Orders using Oracle EDI.
  • Imported product master data from ServiceNow into Oracle EBS using PL/SQL.
  • Supported end users and business users with data and functional issues on a daily basis.
  • Developed financial statements, barcode reports, summary other verity of reports using Oracle Report Builder.
  • Strong in troubleshooting the issues and recommending quick solutions to team and business users.
  • Documented Oracle AIM documentation for analysis, design, development, testing and migration.

Confidential, DC

Sr. Oracle Apps Lead Consultant

Responsibilities:

  • Demonstrative knowledge on Confidential core federal financial processes
  • Performed complete analysis of Oracle financial application modules GL, AP, AR, Fed Admin, PO and integration and interfaces between Oracle EBS and G5, CPSS, CCMS, Treasury’s IPAC, CIR, SF224, e2 Travel System, DOI.
  • Prepared document to recommend interfaces between Oracle financial system to other shared services, Treasury, Department of Interior for Payroll, Centralized Receivable System (CRS), e2 Travel System, and Grants (G5).
  • Developed and implemented interface between Treasury’s Invoice Payment Program (IPP) and Oracle FMSS.
  • Analyzed “As-Is” process of contract acquisition, commitment, obligation, invoice and voucher payment, purchase cards, contract closeouts and monitoring with in Procure-to-Pay. Documented data migration and interfaces.
  • Designed and developed PO, ASN and other electronic file transaction using Oracle EDI.
  • Performed design and development interface between IPP Invoice, CPSS credit card invoices into Oracle Payables.
  • Extended OAF pages so the requisition can accept multiple funding sources. Also to accept multiple distributions in requisition level. Developed custom payment history form to view the grants payment history.
  • Gathered requirements to build repository, dashboard using OBIEE, BI Publisher reports to create financial statements, reconciliation report for Cash, Treasury, HR and Payroll and other.
  • Developed PL/SQL package, procedures to call from BI Publisher reports. Developed financial statements, TROR reports using BI Publisher.
  • Developed BPEL process to implement real-time transaction processing between Grants and CPSS systems to DOE’s Oracle FMSS.
  • Designed and developed FRICEW objects
  • Developed and implemented interface between IPAC and Oracle EBS.
  • Designed interfaces between Treasury’s CRS, CIR, pay.gov, CARS and EBS.
  • Performed analysis and design on complete data warehousing and business intelligence for DOE’s financial statements, reports, periodic reconciliations.
  • Designed interfaces between Treasury Agency Location Codes (ALC’s) and EBS for cash reconciliations such as SF224, Fund Balance with Treasury (FBWT).
  • Analyzed DOE’s improper payments and integrated grants, vendors and EBS to eliminate them.
  • Prepared Oracle AIM documentation like BR100, MD50, MD70, MD120, and TE.20 for all new development and enhancements. Performed object deployments by fallowing standard methodologies in multiple instances for unit and business user testing.

Confidential, Washington DC

Sr. Oracle Apps Consultant.

Responsibilities:

  • Performed Analysis, Design and Development for CRM 4.5 release implementation to enhance the existing functionality.
  • Designed and developed complete POA (Power of Attorney) custom functionality in Oracle Application Framework (OAF).
  • Developed POA Agent Dashboard, Create, and Update and submit POA, approve POA custom pages in OAF.
  • Developed Agent, Authorizer approval hierarchy.
  • Customized Teleservice Agent Dashboard and Mass Update pages by extending VO and Controller to in corporate custom functionality.
  • Developed and implemented Customer conversion in TCA.
  • Enhanced functionality of Contact Center form. Performed several forms personalization and customizations in Contact Center form.
  • Designed, developed and implemented BI Publisher reports such as List of agents and supervisors, Agents with no supervisors, Pending POA approval report.
  • Performed analysis, design and development on multiple FRICEW objects to enhance the current contact center form bug fixes and customizations.
  • Generated WSDL files and displayed POA data in third party web page ‘MyPBA’ using SOA and BPEL of Oracle Fusion Middleware.
  • Developed new form to display POA information on Contact Center form.
  • Developed Interfaces between Genesis system and Oracle EBS.
  • Maintained version control of the complete code and fallowed standard code migration process.
  • Proficient in documentation of MD50, MD70, MD120 Oracle AIM standard methodologies.
  • Assisted DBA during code migration into multiple instances.

Confidential, Cleveland. OH

Sr. Oracle Technical Consultant.

Responsibilities:

  • Performed Supplier, Supplier Sites and Supplier Contact data conversion from WAM to EBS system.
  • Developed Invoice Interface from various external systems to R12.
  • Performed analysis, design development and implementation of Item Import, Assign Items to Category, Assign Items to Organizations, Assign Items to Sub-Inventories and Locators, Load Item On-Hand quantities data conversions from WAM to EBS system.
  • Designed and developed Data Conversions, Data Integration from WAM to EBS using SOA, BPEL process.
  • Designed and developed BPEL process to integrate WAM-EBS-WAM transactions processing and controlled with BPEL Process Manager using Oracle Fusion Middleware.
  • Performed analysis, design development of Standard PO Imports, BPA import, iSupplier user registration login account data conversions from WAM to EBS system.
  • Designed and developed RICEW objects using PL/SQL packages and stored procedures.
  • Customized invoice printing process based on Invoice Type.
  • Expert in AP Check Printing in pre-printed stationary. Developed, Customized and implemented BI Publisher templates and reports for Invoices, Positive Pay, Dunning Letters.
  • Well experienced in Oracle forms, OAF page personalization’s.
  • Performed Analysis, design, development of complete custom functionality in OAF pages.
  • Excellent in View Objects (VO), Controller (CO) and other OAF customizations using extensions.
  • Developed and Implemented ADP Benefits to Oracle AP Interface
  • Performed analysis, design development on Employee Interface to Synergen.
  • Developed and Implemented HRSS Workflow customization.

Confidential

Report Manager

Responsibilities:

  • Excellent in HRMS data migration development and implementation like Employee people, Employee Assignments, person address, special information.
  • Derived list of approvers based on user defined rules and maintained a history of approvers to perform transferring employees, Expense Authorization, Invoice payments, PO and REQ approvals.
  • Customized and integrated workflow in Purchasing, Invoice and account generator for additional notifications to finance department. Customized account generator workflow in projects.
  • Developed Project interface to reverse the existing expenditure items for supplier invoices in Payables.
  • Performed complete SDLC to implement R12 Time and Labor, Payables ACH Payment file processing.
  • Excellent in troubleshooting the production support issues, providing workaround and finally the perfect solution to any end user issues.
  • Configured, performed setups, gap analysis, testing and implementation of iExpense.
  • Performed HR data conversions and developed interfaces like benefits enrollment for employees and dependents.
  • Gathered requirements, analysis, design, development and of BI Publisher report in HR, iExpense,
  • Implemented Employee self service, compensation workbench, Salary, Grade and Leave absence management.
  • Prepared Oracle AIM documentation like BR100, MD50, MD70, MD120, and TE.20 for all new development and enhancements. Performed object deployments by fallowing standard methodologies in multiple instances for unit and business user testing.
  • Excellent implementation knowledge in technical and functional areas of SLA with all other sub ledgers.
  • Very good in communicating and explaining the functionality and resolution for any new development, enhancements or production support issues.
  • Performed OA Framework extensions by adding new columns, custom pages, or calling custom web page from standard oracle page.
  • Configured and performed setups to FSG reports to generate financial reports in Report Manager.
  • Expert in FSG report setups, Row Set, Column Set, Row Order, Content Set, Display Set.
  • Expert in Report Manager Administration, template design, report publishing, Issues and performance troubleshooting, report repository.

Confidential

Solution for Enterprise Asset Management

Responsibilities:

  • Performed analysis, design, development, testing and user training as a techno-functional for Enterprise Asset Management and Advanced Supply Chain Management.
  • Developed and implemented Automatic Receiving Inbound Interface for PO’s and IR/ISO’s coming from external systems as a custom ROI for serialized and non-serialized items.
  • Developed and implemented PO ASN receiving from supplier and sending acknowledgments using EDI.
  • Excellent knowledge of Order to Cash and Internal Sales order functionality in Order Management.
  • Developed UNIX shell scripts for Inbound and Outbound programs for incoming and outgoing data files.
  • Worked on Sales Order extensions to custom generate tracking numbers during pick release, ship confirm process.
  • Worked with BOM, WIP business object public API’s to develop item assembly interfaces, importing mechanics, revising the components, move transaction interface.
  • Implemented AR using auto lock box with importing, validating, matching receipts. Performed automatic receipts.
  • Performed Workflow customizations in PO approval and Inventory item areas.
  • Performed Purchasing setups like Buyer, approval groups, approval assignments, Document Types, Approval Workflow. Implemented complete Blanket Purchase agreements.
  • Developed Declining Balancing Report to show decremented Blanket Agreed amount for each release amount in BI Publisher.
  • Development Stamp Invoice Label Report, Stamp Shipping Label Report which can be scanned by the bar code scanners at the time of sales order ship confirm process.
  • Developed package procedures to extract data from OBIEE repositories to build reports.
  • Developed HR, Inventory Location Outbound interface to transfer locations to external systems using UTIL file.
  • Excellent in preparing Oracle AIM documentation like BR100, MD50, MD70, MD120, TE.20.
  • Excellent experience in report development using BI Publisher.
  • Developed reports using PL/SQL and machine language to print barcode labels which are specific to Intermec and Tech Printers.
  • Performed analysis, development and implementation of interfaces, conversions, BI publisher reports in PO, OM, INV, and WMS.
  • Good experience in migrating Oracle objects like tables, indexes, forms, reports, package, procedures, and lookups, DFF from one instance to another instances using migration tools and validating the objects.
  • Performed WMS profile setups, defined shipping label format, assigned printers to documents, defined shipping methods.
  • Performed forms personalization to ensure the security of the system and data access to only specific orgs for which user belongs to.
  • Developed and implemented enhancements, customizations, extensions in OAF. Migrated OAF objects from one instance to another instance.

Confidential

Lead Oracle Consultant

Responsibilities:

  • Performed adequate research in PO, Order Management, Shipping, INV, iExpense, GL, AP, Assets, PA modules for the R12 upgrade.
  • Gathered and identified functional and technical requirements for the smooth upgrade to R12.
  • Excellent in keeping track of change management documentation on all aspects of the applications upgrade to R12.
  • Configured all sub ledgers for R12 SLA to perform smooth transaction processing to GL.
  • Performed complete unit testing of the R12 functionality for the modules PO, OM, Shipping, INV, iExpense, GL, AP, Assets, and PA modules.
  • Worked with BOM, WIP business object public API’s to develop item assembly interfaces, importing mechanics, revising the components, move transaction interface.
  • Developed interfaces, conversions, reports in Quote to Cash functionality.
  • Worked on various forms personalization in Oracle forms as well as in OA Framework.
  • Developed Custom Min Max planning report to consider pending, on-hold, Frozen PO’s as supply.
  • Performed enhancements Requisition Import, Pick confirm, Ship Confirm, Requisition (Purchase and Internal) receiving interface, PO receipt interface, Move Order creation and transaction interface, Material transactions load to Oracle, Inventory Item Organization assignments.
  • Designed and developed new Oracle forms and customized existing forms using CUSTOM.PLL.
  • Designed and developed Purchasing, Order Management, Shipping and Inventory reports using Discoverer.
  • Introduced custom Pick Slip, Pack Slip reports with ‘BARCODE’ to scan easily at the inventory warehouses using scanners. Developed Postscript PO report which prints in PDF and ghost view formats.
  • Performed setups for the Pick Release process. Implemented organization wise pick release process with custom bar code pick slip report printing.
  • Developed and implemented item, price list data conversions. Worked with Advanced pricing, formulas, modifiers.
  • Designed and developed custom workflow to create multiple Blanket PO’s for a single sourcing rule. Customized workflow to send notifications to receiver and other specific users.
  • Single handedly implemented complete Blanket Purchase order process for many suppliers.
  • Excellent in preparing SOX audit documentation in every step of the SDLC like gathering requirements, Analysis, Design, Development, approval documentation of Unit Test, UAT and user training.
  • Designed and developed complex reports in XML/BI Publisher using Data templates, data definition in PO, OM, WSH, INV modules.
  • Performed complete analysis, design, development and implementation of iExpense module from start to end.
  • Designed and developed Employee expense history report in BI publisher and integrated it in OA Framework.
  • Worked in OA Framework to customize the iExpense web pages to hide unwanted columns.
  • Designed and developed Cash Management Reconciliation Open Interface by loading external flat files into Oracle interface tables using SQL*LOADER.
  • Performed in-depth research, analysis and gathered all required entities for the implementation of Oracle Asset Tracking module which integrates Purchasing, Order Management, INV, Assets, PA, GL, Services, and Install Base modules.
  • Excellent functional and technical knowledge on Purchasing, OM, Shipping, INV, Assets, PA modules.
  • Helped users to close the monthly accounting, purchasing, inventory periods by resolving the pending transactions.
  • Excellently coordinated with entire team to bring the Oracle back to XO from Oracle hosting.
  • Prepared perfect documentation on each module forms, reports, interfaces, data conversions, concurrent program, alerts, and Cron jobs during the entire transition.
  • Performed rigorous unit testing. Coordinated with business users for UAT approvals during the transition.
  • Prepared Functional specifications, Technical specifications, testing documentation for Unit test and UAT.
  • In depth Analyze, design, develop, unit test, UAT, user training and implementation experience in Oracle applications upgrade from 11i.03 to 11i.5.9.
  • Performed complete SDLC on many interfaces like Requisition Import, Pick confirm, Ship Confirm, Requisition (Purchase and Internal) receiving interface, PO receipt interface, Move Order creation and transaction interface, Material transactions load to Oracle, Inventory Item Organization assignments.
  • Developed and implemented AP Invoice import process by bringing the invoice data from external system.
  • Performed data conversions on Vendors, Jobs, Positions, Employees, HR locations, Item Categories, Inventory items, GL code combinations from legacy systems to Oracle database.
  • Created Key and Descriptive Flexfields for Purchasing, GL, Order Management, Inventory modules.
  • Developed interface to synchronize the data between Oracle and email exchange server.
  • Written Alerts in PO, OM, INV modules for various requirements.
  • Performed start to end research, analysis and implementation on iExpense module.

Confidential

Oracle Consultant

Responsibilities:

  • Performed integration between the modules like Oracle Quoting, Service Request, Teleservice, TCA, Field Service, Pricing, Bill of Material, Order Management, Contracts, Receivables, Fixed assets and Sales Online.
  • Configured Quoting, Contracts, and Sales Online setups for 11i.5.8 to 11i.5.9 upgrade support. Customized Quoting and Sales Online home page by providing standard quoting reports as well as Sales Online Home page.
  • Defined Employees, Jobs, Roles, Positions and Position Hierarchy. Defined contract lookups and status codes. Defined contract articles.
  • Performed data conversions for TCA Parties, Party sites, Party locations and Party accounts using TCA Api’s.
  • Developed customizations and interfaces to integrate Teleservice with TCA and Order Management.
  • Implemented PeopleSoft to Oracle HR Interface for purchasing conversion of Position Hierarchy to Employee / Supervisor Hierarchy.
  • Developed PeopleSoft to Oracle interface for Employees, HR Locations, Default Expense Account, Position, Employee Supervisor assignment.
  • Implemented Open Position Interface by assigning a supervisor where the supervisor column is null for the employee.
  • Developed and implemented Open Invoice Interface by getting the external invoices into Oracle Receivables.
  • Involved in configuration and profile system option setups. Workflow proxy routing setups, Sales Online Homepage setups and customization.
  • Configured Oracle Sales Online, Quoting, Sales Contracts by setting up the System Profile options, Lookup codes, setup employees, Import employee as resource.
  • Created Role groups, Role types, assigned Roles to resources, imported resources from HR.
  • Performed employee reporting hierarchy, created Flexfields for Oracle Sales Online.
  • Customized and developed ADVO Depreciation Projections Report and Extract.
  • Designed and developed ADVO Asset Additions Report and Extract.
  • Performed customization of Quote to Contract approval workflow. Designed new workflow functionality ADVO 35 day waiver.
  • Designed and developed reports data in various data formats.
  • Developed and implemented OA Framework for Sales online self service display format and extensions for new columns.

Confidential

Oracle Apps Consultant

Responsibilities:

  • Performed SDLC in the Oracle Federal Procurement and iProcurement, General Ledger, Compusearch (PRISM), Implementation and Customizations in Workflow.
  • Configured and Implemented Federal procurement and contracting for the Federal Agencies like Forest Service (FS), Natural Resources and Conservation Service (NRCS), Food and Safety Inspection Service (FSIS) with Multi-Org Functionality.
  • Designed and developed requisition interface to send employee and procurement data to PRISM acquisition system.
  • While supporting Help Desk performed user New Vendor load, Job Codes, Account Code entry, solving requisition problems and Purchase Order issues.
  • Involved in Multi-Org setup for USDA agencies. Setting up Locations, Organization, Inventory Organization, and Activating OCI Alerts to send the Procurement data to PRISM.
  • Assigned Responsibilities to users, setting up Jobs, Approval Groups, Approval Assignments, document types, Purchasing Options, Receiving Options, and purchasing periods.
  • Define Locations, Setting up Employees, Assigning employee to the users. Assigned employees as buyers.
  • Designed and developed custom workflow process for all expense related requisitions for special approvals and notifications.
  • More than 2.7 Mil Job codes are validated by developing code and loaded into production using SQL*LOADER.
  • Involved in user training support and on site support.
  • Custom designed and developed reports like List of employees, with User id’s and supervisors, buyers list, Location List, Requisition Status report, Pending Purchase orders etc,.
  • Designed and developed code to load external vendors into Oracle database. Also wrote a script to send Vendors to PRISM (Acquisition system).
  • Activating OCI alerts for sending Ship-to-locations, Requisitions, Vendors, Users, to PRISM and Activating the Alerts which send data, Purchase Orders status, Requisition Status to Oracle Procurement Core applications.
  • Participated in the execution of upgrade process of Oracle Applications 11i family pack G to Family Pack I. Performed rigorous functional and technical testing of Family pack I.
  • Involved in complete Family pack I testing worked with Oracle support for the application solutions.
  • Defined Accounting Key Flex Fields for General Ledger Accounting flex fields, defined Calendars, Currencies and Set of Books.
  • Defined Human Resource Key flex fields like Jobs, Approval Groups, Position, Locations, Organizations, Inventory Key Flexfields, System Item Flexfields, Item Category, Item Catalog, Unit of measure class.
  • Written DataLoad macros to load employees, jobs, locations, vendors, UOM and Users.

Application tools used: Oracle Applications 11i.5.7, Forms 6i, Reports 6i, MS Project, Visio, HTML, UNIX, Apache, JSP, JavaScript, SQL, PL/SQL, TOAD, Data load, jInitiator, Sql*loader.

Confidential

Sr. Programmer Analyst.

Responsibilities:

  • Performed complete SDLC in the modules Procurement, iProcurement, Human resource modules.
  • Performed Configuration of Procurement and iProcurement by setting up Purchasing options, Accounting Options, Jobs, and Approval Groups.
  • Developed new workflow and customized workflow like ‘PO Acknowledgment’, ‘Notify Buyer of PO Acknowledgment’.
  • Customized iProcurement web pages using AK developer region, Self-Service Framework.
  • Developed and Implemented Requisition import and PO import process from external legacy systems.
  • Developed and implemented Vendor load process.
  • Developed and implemented interfaces for HR Positions, Employees, HR locations, Jobs, Employee and supervisor assignments.
  • Performed Flexfields setups for various documents like Requisitions, PO’s and Blankets.
  • Performed setups and implemented Blanket Purchase Orders for many approved vendors.
  • Defined Shifts, Calendar setups, Assigning resources to calendar, assigning calendar to the shift. Performed escalation management.

Confidential, Phoenix, AZ

Sr. Oracle Consultant

R esponsibilities:

  • Developed Master and Detail Forms Libraries template for multiple usages to customize the Oracle Sales and Incentive Compensations.
  • Defining and assigning the global parameters to work in between different forms. Developed API’s and enhanced existing API’s for new financial requirements.
  • Performed error handling when errors occur while version changes or migrating to the new applications.
  • Developed new reports according to the business requirements of the client using Oracle Report writer 6i.
  • Secondary updates are done to update the partial tables for reporting purpose. Importing of data from external files using xml gateway.
  • Incorporating form level and database level triggers and stored procedures. Building libraries for the multiple instances of the oracle forms.
  • Database analysis and reporting using oracle discoverer and presenting the data on the web based forms.

Software used: Oracle Applications 11i(5.3,5.4,5.6,5.7), Jinitiator, Java, JSP, HTML, Java Script, Forms 6i, Reports 6i, SQL, PL/SQL, XML, Discoverer, Apache Web server.

Confidential

Programmer Analyst.

Responsibilities:

  • Modified the existing Oracle Financial Forms to proposed business requirements. Strong Integration check has done to the module with customized forms
  • Free data flow design, development, testing and implementation is done to the new forms.
  • Written form level validations, stored procedures and back-end packages which update the secondary database tables for reporting and analysis.
  • Wrote package to separate and group header and line information into another two staging table.
  • Wrote package to validate, insert, check duplicate, and delete duplicate order information from header and line. Imported Orders by using process order API. Generating new customized reports according to the business requirements.
  • Pl/SQL stored procedures are used to integrate the custom code to the regular applications code. Used SQL*LOADER to load data into staging table.
  • Inconvenience Wrote procedure to handle errors & insert to a custom table. Wrote package to separate and group header and line information into another two staging table.
  • Wrote package to validate, insert, check duplicate, and delete duplicate order information from header and line.
  • Imported Orders by using process order API. Generating new customized reports according to the business requirements.

Software used: Oracle Applications 11i(5.3,5.4,5.6), Jinitiator, Java, JSP, HTML, Java Script, Forms 6i, Reports 6i, SQL, PL/SQL, XML, Discoverer, Apache Web server.

Hire Now