We provide IT Staff Augmentation Services!

Oracle Soa Technical Consultant Resume

PA

SUMMARY:

  • 10 years of Experience as an Oracle Fusion Middleware (SOA) Consultant, Oracle Technology Consultant, Oracle Business Analyst.
  • Extensive experience in Oracle E - Business suite Applications, SCM and CRM modules including Inventory (INV), Order Management (OM), Bills of Material (BOM), Work In Progress (WIP), Material Requirements Planning/Forecasting (MRP), Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), Purchase Order (PO), Sys Admin and AOL.
  • Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Extensively worked on the Oracle Fusion Middle Technology.
  • Tools worked on: Reports 6i, Discoverer Reports, PL/SQL Reports, XML Publisher Reports, STT, XML, XSLT, Oracle BPEL JDeveloper, Oracle OSB, and Oracle ESB.
  • Comfortable working with Testing, Debugging, and Deployment of Applications.
  • Proficient in developing Oracle PL/SQL packages, stored procedures, functions, triggers and cursors.
  • Was a part of Center of Excellence initiatives (R&D projects) and many POCs for the projects at Practice level.
  • Was a part of Center of Excellence initiatives (R&D projects) and many POCs on R12 for the projects at Oracle Practice level.
  • Performed Data Conversion from Flat files to Oracle using Oracle SQL* Loader, Datastage.
  • Experience in Performance Tuning and Optimization of Oracle Scripts.
  • Excellent conceptual and working knowledge of Oracle Database Design and Development, Object Oriented Design (OOD), SQL, PL/SQL, UNIX Shell Scripting, XML.
  • Strong experience in client interaction and understanding business application, business data flow and data elements
  • Experience in design and development of reporting environments
  • API: Worked on Oracle APIs to convert data from legacy systems into Oracle ERP.
  • AOL: Worked on AOL, registration and customization form through CUSTOM library, Standard packages and reports in Oracle Applications as per business needs.
  • Open Interface: Extensive experience in Oracle open interface tables. Held positions where major responsibilities included coding and unit testing reports, interfaces, conversions & enhancement programs.
  • System Administration: Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
  • Experience in Design and Development of Reports, Interfaces development of Oracle financial modules.
  • Proficient in designing, writing Technical and functional Specification documents, gathering end user and business requirements and GAP analysis
  • Well conversant with all the phases of Software Development Life Cycle (SDLC) and AIM Methodology.
  • Trained on various R12 features like MOAC (Multi Org Access Control), SES (Secure Enterprise Search) Integration Repository, RBAC (Role Based Access Control) XML Publisher, Business event Systems (replacing Workflows).
  • Define user requirements, functional requirements and develop functional designs and Technical designs for custom modules.
  • Create end-user documentation to provide training to end users especially in Oracle Fusion Technology and BPEL.
  • Experience in System Requirement Study, System Design, Database Design, Programming, Testing and Implementation.
  • Experience in Oracle Discoverer reporting functionality and features, including LOV s, functions, aggregations, parameter utilization, and drill down.
  • Involved in coding comprising of Dynamic Triggers, Stored Procedures, Functions, Packages, SQL tuning, Templates and Classes
  • Expert in execute unit test scripts, Quality Assurance Testing, support function and user acceptance testing
  • Domain expertise: Manufacturing and Oil & Gas Plants and Telecom Industry.
  • Worked as an Offshore Lead in my recent Projects and Managed a Team of 4 People.
  • Proven ability to deliver output on time and detail oriented.
  • Ability to learn new skills and take on greater responsibilities. Good analytical, problem solving, interpersonal and communication skills.

TECHNICAL SKILLS:

ERP: Oracle Applications (INV, WIP, BOM, OM, Shipping, AP, AR, GL, FA, AOL, Sys Admin), Oracle Install Base.

Oracle Tools/Utilities: TOAD, SQL Plus, PL/SQL Developer, PVCS

Programming Languages: C, PL/SQL, SQL, XML, XSLT, Business Process Execution Language (BPEL), Web Service Definition Language (WSDL), HTML, XML

Other Tools: Forms 6i,Reports 6i, Discoverer Reports, XML Publisher Reports, XML, XSLT, Oracle BPEL JDeveloper, Oracle ESB, Toad, SQL Plus, SQL Developer, PVCS, Mercury Quality Center, Kintana

Operating Systems: UNIX, Windows 95/NT/2000

Oracle Databases: Oracle Databases 8i, Oracle 9i, Oracle 10g and Oracle 11g

PROFESSIONAL EXPERIENCE:

Confidential,PA

Oracle SOA Technical Consultant

Environment: Oracle 11g, Oracle SQL, Oracle PL/SQL, Oracle Fusion Middleware.

Responsibilities:
  • Ensure collaboration of development activities for interfaces.
  • Developed Oracle Fusion middleware services that are responsible for transportation of messages from source systems (RMS) to one or more target systems. It enables information flow from RMS to a multitude of applications at Ascena.
  • Involved in integrating RMS to other applications using a) Retail Integration Bus (RIB) layer that is used for real time message publication and b) Batch process that is used for daily refresh of data from RMS.
  • Revised and documented the changes, updated trackers for IFD (Interface Functional Design) and IFDM (Interface Functional Design Mapping) documents for PO interfaces.
  • Interacted closely with business folks to review the requirements and understand the functional requirements.
  • Adhered the project development guidelines and common framework. The technical solution involves ability to serve multiple landing zones, multiple brands and multiple destination systems.
  • Allows addition of brands and landing zones via database update with no change to middleware services. Supports file sequencing, message sequencing and transaction grouping. Leverages common framework smart routing, retry mechanism, and notification system to alert appropriate teams based on level of failure.
  • Involved in development of carton manifest/trailer manifest and Item, Item BOM, Item Xref interfaces from RMS to WMS which comprises of the following services: Message pick up services, Smart routing of messages, Incoming flat file to XML converter service, Transformation services, outbound smart routing service & file format conversion utility service, Delivery services.

Confidential,Dallas, TX

Oracle Technology Consultant

Environment: Oracle 11g, Oracle SQL, Oracle PL/SQL, Oracle R12, Oracle Applications, Oracle EBS.

Responsibilities:
  • Ensure coordination of the development activities between offshore and onsite teams.
  • Ensure adherence to standards and deadlines.
  • Responsible to track project changes and produce updated site based schedule as agreed with business team and project management
  • Responsible to take input from the business teams, DBA’s and project engineers to develop and maintain the detailed schedule.
  • Involved in production support for Revenue Management Project for customers/locations/contracts/Pricelists, Contract Approval Process, Termination/Extension of the contracts, billing, flat billing, usage billing, base billing, invoicing, and revenue recognition.
  • Support transactional data from different line of businesses to Oracle Apps.
  • Involved in Month-end billing for all the Brinks customers.
  • Provide support on inbound and outbound Oracle Fusion Middleware interfaces to and from Oracle EBS to legacy logistics system like iTrack, Heat and iCash.
  • Involved in reviewing the architecture and providing technical solutions for customer contract extracts, usage billing programs, set up customer deployment flags, Brinks SLA validation program, People soft extract program for GL accounting.
  • Review and Resolve HVOP & Auto Invoice Exceptions and month-end billing exceptions.
  • Validate and modify Revenue Summary Reports, validate people soft extracts, program to email/mail invoices to customers, Invoice extract program for all the deployed customers.
  • Involved in performance tuning of data extracts to dataware house team.
  • Resolve contract billing exceptions, fuel surcharge exceptions, auto-invoice exceptions for service contracts.
  • Involved in defining new AME attributes in Oracle SSHR provide customized approvals processes.

Confidential,Columbus,Ohio

Oracle Fusion Consultant

Environment: Oracle 11g, Oracle SQL, Oracle PL/SQL, Oracle R12, Oracle Applications, Oracle EBS.

Responsibilities:
  • Utilize ad hoc reporting and analysis to answer key business questions, analyze historical trends, and compare performance metrics.
  • Involved in technical discussions, gathering requirements, designing and developing employee payroll reports.
  • Involved in customizing payroll costing report and employee payroll deduction reports according to WI standards.
  • Involved in Implementing Oracle Approvals Management (AME). The AME rules and conditions always override any other workflow attribute settings that apply to approvals.
  • Involved in AME implementation is to relieve users of unnecessary manual tasks, as well as provide an integrated, consistent, company-wide solution for Self Service Human Resources approvals and data management.
  • Involved in creating new approval management rules and modified seeded transaction types and modified Oracle Self Service approvals for address changes for employees.
  • Involved in defining new AME attributes in Oracle SSHR provide customized approvals processes.

Confidential,MI

Oracle SOA (Fusion Middleware) Consultant

Environment: Oracle SOA, Oracle 11g, Oracle SQL, Oracle PL/SQL, Java front end, Oracle Applications, Oracle EBS.

Responsibilities:
  • Understanding the business process, technical design and current SOA technical design.
  • Involved in gathering requirements, re-designing, and issue resolution to the various issues.
  • Providing Conceptual solution design documentation as part of the project deliverable.
  • Debug invoice reports generated based on usage to the publishers.
  • Involved in reviewing the present technical architecture and design of the invoicing process.

Confidential,Lenexa

Oracle SOA Consultant / Oracle Technology Consultant/ Project Coordinator

Environment: Oracle 10g, Oracle SOA 10g (10.1.3.4), SQL, Oracle Fusion Middleware, Oracle BPEL, Oracle ESB.

Responsibilities:
  • Understanding the business process and suggesting changes in the technical architecture.
  • Providing the best cost effective solution for upgrade from 9i to 10g and from single instance to RAC cluster environment.
  • Involved in providing drawbacks in the design, suggestions for redesigning the processes.
  • Involved in providing solutions and redesigning BPEL processes to improve sever performance.
  • Provided technical evaluation on the server performance and the metrics for CaseOne and CaseCentral onto the existing CaseViewWeb RAC cluster.
  • Proposed solutions for performance issues and existing issues. Provided the list of queries and view definitions for performance tuning and faster execution of queries in the database.

Confidential

ORACLE Lead Technology Consultant / SOA Programmer Analyst

Environment: Oracle 10g, Oracle SOA 10g (10.1.3.4), SQL.

Responsibilities:
  • Understanding the business process and SOA interface design.
  • Providing conceptual solution guide for ESB and BPEL timeout issues.
  • Involved in providing debatching solution for ESB file adapter, drawbacks in the design, suggestions for redesigning the process.
  • Provided configuration changes to ESB file adapter to limit the number of polling threads, to read files ordered by time stamp, to throttle the number of files being processed by ESB file adapter.
  • Provided configuration changes to dequeue adapter in BPEL process.
  • Recommended the timeout values at BPEL console configuration level, at Application Server level, at EJB level, increasing JTA and JMS timeouts in ESB container, at Apache server configurations.
  • Proposed changes to BPEL processes for better performance and for faster execution time.
  • DB script modifications to purge scripts to purge BPEL instance data in Dehydration database.
  • Provided the list of queries and view definitions for performance tuning and faster execution of queries in the database.

Confidential,Chesepeake,VA

Oracle SOA Consultant, Oracle Apps Production Support Analyst

Environment: Oracle 10g, Oracle Apps 11i manufacturing, Order Management and purchasing modules.

Responsibilities:
  • Understanding the manufacturing business related to the Confidential division and to provide Post- Production support and Customizations to shipping and logistics.
  • Involved in conversions of Inventory items from legacy systems to Oracle Apps.
  • Involved in gathering the technical requirements from users and work through development and testing.
  • Involved in developing and customization of Oracle Reports, discoverer reports and customization of Oracle Workflows.
  • Involved in Production Support Issues, Change Requests, supporting CR’s.
  • Involved in supporting SOA (BPEL) interface for CHP using Oracle Fusion Middleware Technology.
  • Involved in analysis on the business flows and providing the solutions adhering to the client’s standards.

Confidential, Dallas,TX

Oracle Production Support Consultant / Analyst

Environment: Oracle 10g, Java Application

Responsibilities:
  • Understanding the architecture of the systems related to SPINCO to provide Production Support to the SPINCO systems.
  • As a part of Tier 2 Support for Confidential , I was involved in resolving Single User issues.
  • Involved in Production Support Issues, Change Requests, supporting CA’s.
  • Coordinating with the Verizon folks on the top issue tickets rose.
  • Resolved issues pertaining to the Cron jobs for ISP Provisioning.
  • Involved in coordinating, testing - Database and Application changes for Monthly Releases for VIPR UP application.
  • Participated in the business discussions, and designing the Flows for Project North.
  • Involved in analysis on the business flows and providing the solutions adhering to the client’s standards.

Confidential,Dallas, TX

Oracle PL/SQL Developer / Analyst

Environment: Oracle 10g, Java Application

Responsibilities:
  • Understanding the architecture of the systems related to SPINCO and RETAINCO to design, develop, and implement the SPINCO systems.
  • SpinCo - SUNLDAP - Update with an attribute. As a part of SSO/Portal system requirement, need to update the SUNLDAP with vzcspinco attribute with a value of FTW.
  • Identify the tables based on .com/.net/dne/dnr/dns category and segregate the data in 5 data bases.
  • Involved in designing the strategy for all databases related to VIPR/UP in RetainCo environment will be segregated based on the user list (VZ ID, BAN) provided by SSP (.NET and DNE/DNR/DNS users) and also the user list (USERNAME) provided by eReg (.COM USERS). The SpinCo data will be removed from the tables identified for segregation.
  • RetainCo Environment: Involved in designing the strategy for all databases related to VIPR/UP in RetainCo environment will be segregated based on the user list (VZ ID, BAN) provided by SSP (.NET and DNE/DNR/DNS users) and also the user list (USERNAME) provided by eReg (.COM USERS). The SpinCo data will be removed from the tables identified for segregation.
  • Involved in designing, developing the Database segregation for ISP Provisioning.
  • Involved in testing of the VIPR UP application for Project North.
  • Participated in the business discussions, and designing the Flows for Project North.
  • Involved in analysis on the business flows and providing the solutions adhering to the client’s standards.
  • Was a part of Center of Excellence initiatives POCs on R12 apart from the project assignment.

Confidential, San Jose

Oracle Apps Technical Consultant / Project Coordinator

Environment: Oracle Applications 11i (11.5.8), Toad, SQL Plus, PVCS, Kintana, Mercury Quality Center.

Responsibilities:
  • Understanding the customer requirements, analysis, design, development and implementation of TAA products into the system
  • Gather and define business requirements, Improve business processes.
  • Involved in development, testing and enhancement of the report - TAA Consumption report for Q2FY09.
  • As a technical lead, participated in status meeting and walkthroughs.
  • Involved in Planning, Implementation, Testing, and Documentation.
  • Involved in the design and development of PL/SQL Reports.
  • Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
  • Participated in the business discussions and designing the Functional design document and the technical design.
  • Involved in IT testing and was a key resource as a part of business testing
  • Involved in writing test plans and testing the application.
  • Involved in Code Review, Code Walk Through, and Unit Testing.
  • Involved in the migration activities using Kintana and PVCS and Pi-tool (Go-Live activities).
  • Verified that acceptance criteria had been met for all development/modifications, followed and enforced standardized change control procedures to move new interfaces/modifications into/out of production.
  • Involved in Architecture Review meetings in designing reports for the TAA products.
  • Involved in analysis on the gaps in business and providing the solutions adhering to the client’s standards.
  • Designed report tables to store temporary report-processing data, and used by the back-end report-processing program. These tables were very important and they had to be designed as per the requirement of the back-end program to ensure the main requirement of this project - “speed”.
  • Was a part of Center of Excellence initiatives POCs on R12 apart from the project assignment.

Confidential,San Jose

ORACLE APPS BUSINESS ANALYST / ORACLE PL/SQL DEVELOPER

Environment: Oracle Applications 11i (11.5.8), Toad, PL/SQL Reports, SQL Plus.

Responsibilities:
  • Involved in providing the analysis on the enhancements of Automated Vendor Payments (AVP) processes, a customized payment tool.
  • Involved in client interaction and understanding business application, business data flow and data elements
  • Involved in Business requirements analysis and standardization
  • Involved in various business discussions and Architecture Review meetings to ensure that the technical solution adheres to the Oracle Architecture standards and Business gaps.
  • Involved in development and testing of DF Exception Report and Recon Report which are key reports for the AVP business users and Cisco’s Contract Manufacturers.
  • Modified existing stored procedures and packages to in corporate effective migration of data from amongst the production, testing, and staging databases.
  • Involved in providing technical and functional analysis on the 13 day buildable backlog report.
  • Participated in status meetings and walkthroughs.
  • Involved in Planning, Implementation, Testing, and Documentation as per AIM Methodology.
  • Actively participated in managing the off-shore team and getting the deliverables from the resources on time.

Confidential,San Jose

Oracle SOA Consultant

Environment: Oracle Applications 11i (11.5.10), Toad, SQL Plus, Kintana, PVCS, Mercury Quality Center.

Responsibilities:
  • Involved in testing and enhancement of interface - SIID SOA Interface.
  • Modified BPEL process, existing stored procedures and packages to in corporate effective migration of data from amongst the production, testing, and staging databases.
  • Also used PVCS to modify the existing pl/sql scripts and to push the new code to the testing databases. The PVCS is mainly used to keep the history of all the code changes that have been made to an original codebase. Also involved in checking in and checking out of the codebase from the SSH servers using PVCS at the local machine.
  • Integration and implementation of the system, including testing and troubleshooting.
  • Detected and Corrected bugs during system integration and user acceptance testing.
  • Involved in Code Review, Code Walk Through, and Unit Testing.
  • Involved in documentation of User requirements and Testing of developed modules.
  • Participated in the transition and Go-Live activities.

Hire Now