We provide IT Staff Augmentation Services!

Sql Developer Resume

SUMMARY

  • Extensive experience in Implementation, Customization, Migration, Production Support for various modules of Oracle EBS having prime focus on Accounts Receivable (AR), Accounts Payables (AP), General Ledger (GL),Order Management (OM), Inventory (INV), Purchasing (PO), Shipping (WSH), Bill of Materials (BOM), Work in Process (WIP), Install Base, Oracle Field Services.
  • Worked as an Oracle EBS Technical Consultant and performed Analysis, Design, Development, Deployment of Oracle EBS RICE (Reports, Interfaces, Conversions, Extensions) components in the domain of Oracle Application E - Business Suites.
  • Extensive Experience in loading Legacy Data into Oracle EBS through conversion program using shell scripting and Standard APIs.
  • End to end experience in CRP and UAT cycles to complete User Acceptance Testing with extensive involvement in R12 support and project upgrades, with strong abilities to troubleshoot and think critically.
  • Experience in creating Technical design Document (MD70), Test Plan for Custom Application designed and developed in integration with R12/11i.
  • Rich Experience in designing, developing, testing, performance tuning and troubleshooting PLSQL Procedures, Packages, Functions using SDLC (Software Development Life Cycle) Methodologies.
  • Good Working knowledge of Procure to Pay(P2P) and Order to Cash(O2C) Cycle.
  • Onsite Direct Client Interaction experience of more than 1 year in US.
  • Strong knowledge of Oracle SQL, PL / SQL, Oracle Standard API, Oracle Reports, Interfaces & Conversions.
  • Worked on AOL and system Administrator Tasks like creating Users, Responsibilities, Menus, Request set/Groups, Value sets, KFFs, DFFs, profile options & Concurrent programs.
  • Good Knowledge of Incident Management, Change Management and Problem Management Lifecycle and Processes.
  • Extensive experience in Oracle EBS integration with 3rd party applications through different middleware such as SOA, TIBCO, NASMOUNT Configuration etc.
  • Good Working Knowledge of different entities such as User Hooks and Business Events.
  • Self-Motivated with strong problem solving and interpersonal skills.

TECHNICAL SKILLS

Packages: Oracle Applications 11.5x/R12

Programming Languages: SQL, PLSQL.

Oracle Modules: Accounts Receivable (AR), General Ledger (GL), Order Management (OM), Inventory (INV), Purchasing (PO), Shipping (WSH), Bill of Materials (BOM), Work in Process (WIP), Install Base.

Oracle Tools: PLSQL Developer, Oracle Reports builder 10g/9i/6i, Oracle Forms builder 10g/9i/6i, Oracle Workflow Builder 2.6.3.5, Oracle BI Publisher, XML publisher, SOA services.

Database Tools: SQL *Plus, SQL * Loader, Toad, SQL Loader, WinSCP, Putty.

Operating Systems and Utility: Windows 7/8/10s

Project Management and Design Tools: Microsoft Visio, Bugzilla, HP ALM, Jira

Other Tools: BMC Control-M, Remedy Project and portfolio management, IBM Rational Clearcase, Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

  • Resolved diverse hot production functional/technical issues related to INV, OM, Shipping, Purchasing, BOM, WIP, Receivables.
  • Provide L2 level Functional/Technical support to business and worked as a part of team in 24x7 production environment.
  • Act as an Oracle US and Canada Onsite Support Lead and manages L1 resources at Onsite.
  • Helped users in various shipping related High issues and make sure that Delivery lines should get interfaced successfully and shipping should be completed successfully.
  • Prepare weekly timesheets and status reports to management in addition to maintaining a work task list ensuring desired SLAs are met for incidents raised by business.
  • Helped Business users to clear stuck transactions and make sure inventory period has been closed every month end.
  • Help less experienced team members on production support issues and project tasks.
  • Worked with off-shore development teams to communicate functional requirements for code development and test the same on completion.
  • Effectively communicates complex business and technical information to various audience levels including senior management, business community and staff members.
  • Handling problem tickets for recurring complex issues and doing problem management.
  • Worked on enhancement requests for modifying/extending existing functionality of components as per business need.
  • Worked on fixing issues with customizations, reports, interfaces, custom programs and PlSql Codes.
  • Tracked and logged solutions in incident report tool Remedy.
  • Worked with Change Management teams and support production movement of components.
  • Created functional and design documents that align with business requirements and best practices.
  • Followed Change management process to ensure smooth migration of changes to live instance.
  • Provided support and resolved incident related to 2rd party integration using SOA and Tibco.
  • Worked on Control M scheduling.

Confidential

SQL Developer

Responsibilities:

  • Involved in requirement gathering, FIT-GAP analysis & process study.
  • Collected project business requirement through meeting with business and understanding the expectation.
  • Worked on Supply chain orchestration, back to back supply order & Drop ship cycles.
  • Designed and Developed multiple Outbound interfaces such as Item Master Interface, Sales Order Details Interface etc. in order to extract data from Oracle and send to DHL system.
  • Designed and Developed Inbound interface (for eg, Expected Receipt Interface) in order to load data into Oracle through standard interfaces/API.
  • Designed XML Publisher Oracle Reports as per requirement provided by business.
  • Facilitated smooth testing during CRP & UAT phase and played a vital role in tracking/resolving all bugs which have been raised during these test cycles.
  • Interact with the business users through regular meetings and provided updates on all open issues.
  • Execute Super user training and preparation of training material.
  • Perform Enhancement in different Interfaces in order to generate data as per region specifications.
  • Worked on P1 (Critical) and P2 (High Priority) Bugs found during SAT and UAT and resolve them within SLA.
  • Perform cut-over and go live activities. Provided 3-month warranty support and assisted user in resolving issue and understanding new system developed.

Confidential

SQL Developer

Responsibilities:

  • Involved with business from very start to understand the GAP from Oracle ERP perspective and help them with FIT-GAP analysis.
  • Responsible to design new label templates and files in the software system Loftware.
  • Heavily involved in Data migration activities like data mapping from legacy and further final data migration to single global instance.
  • Performed enhancement in existing interfaces and implemented new functionalities as per business requirements.
  • Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.
  • Worked on reusing /developing/configuring interface to provide data transfer between Oracle and SAP using synchronous SOA services & oracle web services
  • Facilitated smooth testing during CRP & UAT phase and played a vital role in tracking/resolving all issues.
  • Interact with the business users through regular meetings and provided updates on all open issues.
  • Perform cut-over and go live activities. Provided 3 months warranty support and assisted user in resolving issue and understanding new system developed.

Confidential

SQL Developer

Responsibilities:

  • Designed and Developed New Outbound Interfaces such as Purchase Order Interface, Receipt Interface etc. which are used to triggers data through SOA middleware.
  • Successfully designed Custom Business Events which are used to invoke SOA web services which in turn generate Payload and transfer Payload to other Systems.
  • Designed and Developed New Inbound Interfaces such as Customer Maintenance Interface which are used to receive customer related data from through SOA Middleware and create and update new/existing customers at ERP end.
  • Payload procedure has been written from scratch for integration with SOA using advanced PLSQL object type.
  • Implemented Debatching logic in order to keep minimum load on SOA and avoid performance related issues at SOA end.
  • Developing testing scripts and supporting QA and User Acceptance testing
  • Completed the go-live including movement of code to production and provided warranty support for 3 months.
  • Troubleshoot and debug different issues related to Payload Generation Failure at SOA end.
  • Participated and Contributed in Technical calls and discussions with other vendors such as Delloite and resolve certain critical issues.
  • Perform Enhancement in different Interfaces in order to generate data as per Brazil specifications

Hire Now