We provide IT Staff Augmentation Services!

Solution Architect, Senior Oracle Developer Resume

4.00/5 (Submit Your Rating)

Tempe, AZ

SUMMARY:

  • Confidential is a Senior Oracle EBS SCM/HRMS/Finance Techno Functional Consultant for Hitachi Consulting and is a member of the Application Technology practice.
  • With over 12 years of consulting experience, Confidential has designed and built Oracle Custom solution for Modules HRMS/Finance(General Ledger (GL), Accounts Receivable(AR), Accounts Payables (AP) HCM Core and Payroll (HRMS) for clients that address critical business needs with intuitive and accessible user experiences across numerous platforms and corporate environments.
  • As a thought leader, he has inspired and led both clients and user experience developers to turn abstract concepts, problems, and other ideas into tangible roadmaps and solutions with depth and texture that can be consumed, touched, and manipulated.
  • His creations produce working environments that are productive, useful, beautiful, and fun.
  • Confidential is a true user - advocate and leverages this passion, his user experience talents, a wealth of past experiences, and the knowledge of other thought leaders in this space to create user experiences that consistently exceed the expectations of his clients.
  • His client list includes multiple Fortune 500 companies across Manufacturing, Government/Public Sector, Retail,, and Food Beverages.
  • 4 years of project management experience.

KNOWLEDGE:

Technologies: SQL, PL/SQL (10g & 11g), Oracle Forms and Reports (9i & 10g), SQL*Loader, XML Publisher, Workflows, Trace and Explain Plan, Custom PLL, Forms personalization’s, OAF extensions and personalization, JAVA, ADF

Functional Expertise: Oracle Order Management, Shipping, Receivables, Inventory, Purchasing, Payables, TCA, General Ledger, Core HRMS, Payroll, Time and labor, SSHR, Field Service(CRM)

Industry Expertise: Manufacturing, Government/Public Sector, Retail,, Food Beverages, Marketing

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, AZ

Solution Architect, Senior Oracle developer

Responsibilities:

  • Extract Data from Oracle EBS to SAP from all Oracle HR modules OLM, Core, Payroll,OTL.
  • Build adhoc Oracle HR quries.
  • Developed AME’s and HR User hooks for absence management.
  • Build Customer program to compare employee data between Oracle and HANA SAP.
  • Tuning reports and SQL concurrent programs.
  • Oracle Technical Architect for all Oracle projects.
  • Perform all setups, including Adding new Install base attributes, flexfield’s lookups, value sets.

Confidential, Windsor, CT

Scrum Master, Solution Architect,Project lead

Responsibilities:

  • Initiate daily scrum meetings, Sprint planning meetings, and sprint reviews.
  • Lead a team of 20 to complete user stories and get accepted by users by the end of stories.
  • Building a custom and external ADF(11.1.1.2) application for the client extending Oracle R12 AOL functionalities.
  • The custom application includes 12 ADF screens, 4 synchronous webservice call to Fuse.
  • Gather requirements, assistingusers in writing “User stories”, and mock screens.
  • Identifying gaps and exception scenarios in requirements, resulted in more robust application.
  • Wrote Solution architecture document, Which includes scope, 8 cross functional business flow charts, data architecture diagrams, System flows, Risks, Assumptions, afterrequirements gathering wasperfumed.
  • Configured and used EBS SDK for Java to integrate/share Session’s between Oracle EBS R12 and External ADF application. Access ADF screen from EBS function menu, access context and session variables in ADF screen, logging out ADF screen log’s out EBS session.
  • Perform all setups, including Adding new Install base attributes, flexfield’s lookups, value sets.

Confidential, Phoenix, AZ

Technical Architect, Techno-Functional,Project lead

Responsibilities:

  • Extract Data from Oracle EBS to SAP from all Oracle modules OM, PO, HRMS, AP, AR, Projects, BOM, WIP, and GLModules. (Last 6 months Client moved away from Oracle EBS to SAP).
  • Lead and Manage, Offshore and On-Site team across Global platform.
  • Oracle Technical Architect for all Oracle projects.
  • Coordinate daily with offshore team on status updates.
  • Conduct meetings with onsite functional team to understand businessrequirements and issues.
  • Initiate weekly status calls with client on development progress.
  • Analyze and identify Table/View changes while upgrading to R12 on custom objects.
  • Used Hitachi APP grade tool to identify table changes in new an old tables to be changed.
  • Create MD70 technical specification documents and follow-up with offshore for development of custom objects.
  • Review code developed by offshore team before handing the object to functional resource for testing.
  • Designed and developed Workflows extensively in Order Headers, Order Lines, purchasing, and GL.
  • Extensively done OA framework extensions, and personalization.
  • Used Interfaces to import data into Inventory, open sales orders, open PO and general Ledger.
  • Oracle Forms customization using Custom.pll and personalization’s.
  • Converted all custom RDF reports to XML Publisher reports.
  • Quick (Same day) complex reports development for all user base on demand, including HR/Payroll, Finance, OM, PO, ASCP, MRP, BOM, WIP, often using analytical functions.
  • Designed and developed Oracle EM-shipment’s report with 200 columns, used by finance business Analyst’s and users.
  • Designed and developed interface from Demantra (Forecast system) to oracle and oracle to Demantra, High complexity level.
  • Replaced legacy BI systems to Cognos BI, which includes 4 main reports, Bookings, Billing and Backlog reports.
  • Designed and developed interfaces for Kinaxis (similar to Oracle ASCP) Planning system.
  • Conduct POC for various projects from Agile reports, Intercompany process, to share point.
  • Technical architect for Intercompany and interorg development project.
  • Coordinated with external systems like BENETRAC, FEDILITY, and KRONOS for HR data transfer programs.
  • Developed AME’s and HR User hooks for absence management.
  • Implemented oracle learning module.
  • Build EIT structure for capturing bonus % for executing employees.
  • Build SIT structures and use it in SSHR pages for storing extra employee information.

Technologies: Oracle Workflow, Forms, XML Publisher,OA Extension and personalization, OM, PO, ASCP,HRMS, Payroll, AP, AR.

Confidential

SCM/HR Tech Lead

Responsibilities:

  • Developed Order/RMA import interface.
  • Developed OTL interface between thirds party swipe machine to timecards and payroll integration in oracle.
  • Developed custom workflows in SSHR, for approval and notification on specific actions.
  • Developed Interface for Demand fulfillment integration between Oracle and Siebel.

Technologies:SQL/PLSQL, XML Reports, Workflow, OA Personalization, Conversions, UTL File programs, Core HRMS, OTL, SSHR,ASCP,OM,PO

Confidential

Tech Lead, HRMS Techno-Functional, Onsite Coordinator

Responsibilities:

  • Design and code EIT Structure for Online Vacancy, Leave Encashment.
  • Migrated 10 SIT structures from legacy, such as visa, passport, life insurance, labor card information.
  • To Build User Hook’s, which adds custom validation to Standard API’s for various.
  • Absence types such as, Annual leave in combination with leave encashment, Hajj Leave.
  • To Build and migrate AME’ Rules, Approval Groups, conditions and attribute for 30Approvals
  • To build User / SSHR Responsibility creation script.
  • Personalize OA Page’s for all EIT and SIT structures.
  • To lead a team of 4 to handle 15 reports, 7 alerts.
  • Direct Client side Technical contact, while UAT and go live at onsite.
  • Creation of new Payment method according to UAE Patch and end dating existing one.

Technologies:Oracle Applications 11i, Reports 91, OA Personalization, Workflow, AME,SSHR, Alerts, User Hooks, EIT’s, SIT’s

Confidential

HRMS/OTLArchitect

Responsibilities:

  • Developed 3 AME’s on approval for enrolment of class, External, and cancellation.
  • Developed 5 XML reports on Courses, Classes, Enrolment status, Learning path and learning history.
  • Developed 4 Conversion for Courses, Offerings, Classes, Enrolments and competencies Elements.
  • Developed an Alert to send an E-mail for all eligible employees, whenever administrator creates an Announcement.
  • Developed an SMTP Concurrent program to send mail to manager whenever administrator changes the status of an enrolment. Implemented through a trigger.
  • Developed a Workflow from scratch to send notifications to a group of managers based on category (Maintained in UDT) whenever a class is created, with a DFF flag saying “Yes” for notification. Implemented through Trigger.
  • Documented all the above objects using MD70.

Technologies:Oracle Learning Management, SQL/PLSQL, Workflows, Reports, AME’s, Conversions, Alert, UTL SMTP

Confidential

Techno functional SCM, Onsite Coordinator

Responsibilities:

  • Closer of tickets raised by user on distribution modules.
  • Writing ADHOC SQL queries as request by user.
  • Report modification as by user requirement.
  • Form personalized order lines and header form, inter-organization, sub inventory form, quality sample form.
  • Tuning reports and SQL concurrent programs.
  • Documenting all the changes from CR creation, requirement spec, Solution Design, unit test, user test and production migration.
  • Key person for the crucial P1 shipping issues at the user location.

Technologies:Oracle Applications R11I, AOL, Reports 10G, PL/SQL Reports, Order Management, Oracle Inventory, Accounts Receivables, Oracle shipping, Oracle Purchasing, Oracle Receivables. SQL/PLSQL, Forms Personalization, XML Reports, Interfaces, Workflow, Order management, Purchasing, Financials

Confidential

SCM/FIN Techno Functional

Responsibilities:

  • Analyze and identify Table/View changes while upgrading to R12 on custom objects.
  • Change R12 context settings on custom objects.
  • Used Hitachi APP grade tool to efficientlyidentify the difference in new an old tables to be changed.
  • Developed report on order Acknowledgement, Invoice, Bill of lading, Delivery Note, Transfer voucher, finished goods dispatch report, Customer statement of account, Billing history report, Customer aging, PO Print, material issue note, AR item Transaction report, lot wise inventory report, In XML Publisher.
  • Workflow customization to delete all price adjustment lines for zero adjusted lines.
  • Workflow customization to consolidate the entire price adjusted lines to single line while interfacing.
  • Form personalized order lines and header form, inter-organization, sub inventory form, quality sample form.
  • Tuning various complex reports like Customer aging and pay slip reports.
  • Creating Business Events and Event subscriptions for Workflows.
  • Sales Orders Interface, Customers interface, Invoices Interface, Receipts Interface.

Technologies:Oracle Applications R12, AOL, Reports 10G, Forms 10G, PL/SQL Reports, UNIX, Order Management, Oracle Inventory, Accounts Receivables, Oracle shipping, Oracle Purchasing, Oracle Payables and HRMS, XML Report, Workflow, Forms personalization

Confidential

Techno Functional SCM (OM/PO)

Responsibilities:

  • Analyze and identify Table/View changes while upgrading to R12 on custom objects.
  • Change R12 context settings on custom objects.
  • Used Hitachi APP grade tool to efficientlyidentify the difference in new an old tables to be changed
  • Developed reports for different counties, according to the requirements (both SQL and RDF).
  • Modified existing reports according to the requirement.
  • Writing Ad hoc quires for sales persons and Confidential customers.
  • Prepared MD070 and MD120 using standards of AIM.
  • Interacted with the customers to understand the requirements.
  • Testing the reports.
  • One of the members of the production support team.
  • Tuning SQL queries.
  • Registering the concurrent programs.
  • Creation of value sets.
  • Documenting the work done.
  • Coordinate with offshore resource.

Technologies:Oracle Applications 11i/R12, AOL, Reports 6i/10G, Forms 6i/10G, PL/SQL Reports, TOAD, UNIX, Order Management, Accounts Receivables, Oracle Field Service, sales reporting, Oracle Purchasing, Accounts Payables

Confidential

Senior Oracle Apps Developer

Responsibilities:

  • Developed Order validation package to load data to interface tables in Order entry and run order import to load data to the base tables.
  • Developed packages, reports, value sets, triggers, tables, indexes, synonyms, sequences, views and lookups.
  • Sales Orders Interface, Customers interface, Invoices Interface, Receipts Interface.
  • Sales Order, RMA and Quote Workflows.
  • Bill of Lading XML Publisher Report’s; invoice Report’s, Aging Report’s.
  • Design the BPEL Process Manger Interface to Oracle Order Management and Oracle B2B.
  • Replaced XML gateways with Advanced Queuing concept.
  • Written PL/SQL code for generation of B2B messages (3A6, 3B2 etc.,), error messages (BAM), exception handling and relevant messages in the log files.
  • Creation of some scheduled programs.
  • Member of testing and production support teams.
  • Prepared MD070 and MD120 using standards of AIM.
  • Executing test cases and preparing test plans.
  • Creation and modification of Discoverer Reports.
  • Changing the Zoom Form (Additional Customer Information).
  • Involved in customization of forms using CUSTOM.pll
  • Customized workflow to capture the changes.
  • Tuning SQL queries.
  • Created and modified the wrapper program which wraps call(s) to the custom Pre-Order Import, Order Import, Post Order Import, Order Validation and Auto Booking Programs with necessary validations.

Technologies:Oracle Applications 11i, Order Management, AOL, Flex fields, Oracle 9i, Developer 2000, Forms 6i, Reports 6i, PL/SQL Stored Procedures, Database Triggers, TOAD, Discoverer, Workflow Builder, Visual Source Safe, UNIX. Oracle E-Business Suite 11i, DBMS-Oracle 10g, Oracle workflow 2.63, Oracle BPEL Process

Confidential

SOA/BPEL Developer

Responsibilities:

  • Development of the BPEL process manager for B2B Integration between Oracle B2B and Oracle Applications 11i (OM), Developing of XSLT for XML Transformation.
  • Involved in preparation of design documents and installation guides.
  • Extending the functionality of messaging in Order Management by replacing XML gateways with Advanced Queuing concept.
  • Participated in code reviews and unit testing.
  • Prepared unit test cases and test scripts.
  • Performing testing by simulating the customer work environment.

Technologies:Oracle Fusion Middleware, Oracle BPEL Manager, Oracle B2B, Oracle BUS. Oracle EAM, XML, XSLT, XSD and Document Editor.

We'd love your feedback!