We provide IT Staff Augmentation Services!

Oracle Pl-sql Developer Resume

Parsippany, NJ

SUMMARY:

  • Nine years of IT experience including five years of Onsite - USA experience
  • Worked with Deloitte on Confidential (PLCB) as Oracle Retail Techno-functional Consultant.
  • 7 years of global experience in Oracle PL-SQL Development, Oracle SQL Programming
  • Worked as Retail Oracle Developer to support Oracle Retail Applications.
  • 7 years of global experience in Oracle ERP Design, Implementation and Production support including team management in 24/7 model.
  • Design, Development, and testing expertise in RICEW (Reports, Interfaces, Conversions, Extensions, and Workflow) components utilizing Oracle Forms builder, Report builder and Oracle SQL developer.
  • 7 years of experience developing Oracle PL/SQL database objects (packages, triggers, procedures, functions, views, sequences).
  • 7 years of experience with Oracle technologies (performance tuning like Explain plan, SQL tuning, etc.). Understand and interpret the reports generated from tools and action plan to overcome performance issues.
  • Technical Expertise in Oracle Retail modules including RMS, SIM, Allocation, RPM and ReIM.
  • Conversion Lead for Oracle Retail Modules from Version 12 to version 13
  • Work on critical production issues in Retail environment to ensure zero downtime.
  • Have been working on Gathering requirements and doing effort and resource estimations for various change requests and new enhancements rose by client.
  • Prepared and Participated in various Retail knowledge transfer sessions to explain Technical and Functional aspects of various Retail modules and business processes.
  • Customized Oracle Retail suites to meet client requirement. Worked on customizing seeded Oracle APIs and created Custom APIs to meet the business requirements.
  • Have worked as RMS technical team lead to coordinate and delegate work assignment with off-shore team to utilize global talent and capabilities in a cost efficient manner
  • Have been doing assessment and review the code done by peers to ensure that they are as per quality standard and in-line with performance tuning guide-lines
  • Expertise in enterprise-wide implementation of Oracle Retail latest versions
  • Extensive experience in designing and implementing the solution involving integration strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.

TECHNICAL ENVIRONMENT:

  • Retail Merchandising System
  • Store Inventory Management
  • Retail Integration Bus
  • Retail Price Management
  • Retail Sales Audit
  • Retail Data Warehouse
  • Allocation
  • Oracle E-Business Suite 12
  • Oracle Business Intelligence suite 11g and 11g
  • Oracle fusion middleware (10g and 11g)
  • Oracle Database (10g and 11g)
  • Oracle Retail Integration Bus (Version 12 and 13)
  • Oracle Apps R12: project experience
  • Oracle RDBMS: project experience
  • Oracle Fusion Middleware: project experience
  • Oracle Fusion Applications: training
  • Oracle BI - Enterprise edition 10g: project experience
  • TOAD: expert
  • SQL Developer- expert
  • SQL/PL SQL: expert
  • Oracle Forms: expert
  • Oracle Reports: expert
  • Unix shell: project experience
  • JDeveloper: project experience
  • BPEL: project experience
  • XML/XSL: training
  • Oracle 11g/10g/9i RDBMS: project experience
  • Oracle iAS 10g: project experience
  • Oracle Fusion: project experience
  • Oracle RETEK Middleware - RIB - project experience
  • SOA: project experience
  • Microsoft Excel: expert
  • Microsoft Word: expert
  • Microsoft Power Point: expert
  • Microsoft Project: expert
  • Microsoft Access: expert
  • Microsoft Visio: expert

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Oracle PL-SQL Developer

Responsibilities:

  • Contribute to Overall Architecture and Data model of Vendor Portal by participating in regular meetings/discussions with the Development, Functional, and Infrastructure team
  • Develop and maintain system documentation, including technical specifications, data mapping, program logic and flowcharts
  • Participate in various projects and new initiatives; develop/ deploy and make suggestions as a technical resource involving Oracle 10g/11g Database Server, as well as performing duties such as documenting requirements, sources - to- target mappings, and program logic, designing solutions, testing, and implementation
  • Develop, execute, and manage Oracle PL/SQL programs units procedures, functions, packages and database triggers
  • Develop Unix shell script to develop Batch program as Interface

Confidential, Harrisburg, Pennsylvania

Oracle Retail Techno-functional Consultant

Responsibilities:

  • Have Formulated the overall Conversion approach for Retail Application after regular meetings/discussions with the client, functional, and infrastructure team
  • I was leading Retail Conversion module in PLCB Upgrade project (Conversion of PLCB data from retail version 12.0.6 to 13.2.4). This part of the project was the most critical. In total, we successfully completed seven mock runs of Retail Conversion in non-production environments. The production conversion run was successful with no major issue. This conversion activity was critical component of PLCB Upgrade project, as Oracle had no standard approach for converting Retail Version 12 to Retail Version 13.
  • As a Conversion Lead, I was leading consultant across the teams. The conversion team had 5 members. Two of them were DBAs. One resource working from offshore and one resource from onsite. I supervised two DBAs for successful conversion run. I was also guiding/mentoring personnel from client who were involved in Conversion.
  • I have also developed Generic Conversion Approach/Module to use for Retail Conversion. This program can be run in parallel threads based on hardware resources. This module was core part of Retail Full and Delta Conversion. With this module, we were able to convert 396 tables in less than two hours.
  • Because of Database Size (more than 1.5 TB), Retail Conversion was initially taking more than two weeks to complete. But with continuous improvement, we were able to complete Full conversion in less than three days and delta conversion in less than 12 hours. This was well acknowledged by Client.
  • I was responsible for converting 1.5 terabytes of data, organized into 1000 different tables, into the new system. In early planning sessions, this was identified as one of the highest-risk activities of the project. Could it even be done? Oracle certainly wouldn't give us any help.
  • I was able to manage the project by using both onsite and offshore resources, and coordinating directly with several different functional teams. By suggesting agile conversion architecture, I was able to accommodate changes throughout the process, including the final go-live weekend.

Oracle PL-SQL Developer

Confidential

Responsibilities:

  • Develop, execute, and manage Oracle PL/SQL program components such as a procedures, functions, packages and database triggers
  • Design, develop and test complex Retail Application reports utilizing Oracle BI Publisher, and Oracle Reports
  • Setup BI Publisher reports to Run as Scheduled Processes
  • Integrate BI Publisher reports with RMS Application
  • Modify Data model, parameters and Layout of out-of-box BI Publisher reports to meet customer requirement
  • Participate in various sessions as a technical resources involving Oracle PL-SQL, as well as performing duties as documenting requirements, mapping and program logic, designing solutions, testing and implementation
  • Design and development of customized retail batches using primarily PL/SQL batch processing
  • Learn and master Data model of Oracle Retail Applications
  • Develop, design, and troubleshoot new and existing Oracle Application interfaces, applications and extensions
  • Experienced in using tools like TOAD, SQL PLUS for design and development
  • Proven ability to troubleshoot and trace data related issues throughout the architecture and in analyzing how Oracle resources are being used during SQL executions.
  • Analysis, design, programming, testing, implementation and production support of Oracle PL/SQL objects and stored procedures
  • Development of UNIX shell scripts as required
  • Worked on Documenting environment setup required for Oracle Retail Version 13
  • Worked with client and functional team to capture and list all affected customizations because of version upgrade
  • Have reviewed code developed for production support and worked on merging it with Upgrade code
  • Worked on Initial assessment of upgrade project to identify key transformations and risk associated with projects
  • Have been pro-active to fix post go-live issue to ensure minimal or no downtime worked on new enhancements and change requests with established engagement scope, quality standards and timeframe
  • Played important role in implementation and in stabilizing Client environment post go-live. I have worked with Client in analyzing various issues and with little/no help I was able to resolve these issues.
  • Monitored critical Interfaces and Batch Jobs, and have taken corrective and pro-active actions to ensure minimum impact of business. I have also set various alerts in Appworx - UC4 scheduler to make monitoring more effective.
  • Worked on Gathering requirements and doing effort and resource estimations for various change requests and new enhancements raised by client
  • Detailed knowledge of RMS Data-model, Standard APIs
  • Extensive knowledge of RMS Tables, PL-SQL source code (Packages, procedures and functions). Seeded oracle APIS.
  • In-Depth functional knowledge of RMS Application including foundation Data, Replenishment, Purchasing and Item Maintenance.
  • Good Understanding of Retail Sales Audit module including batch-jobs and Integration with other modules.
  • Comprehensive knowledge of functioning and configuration of RMS Batches
  • Developed customized forms and modified standard forms based on client’s requirement
  • Designed and developed Full and Delta Conversion approach for Data Conversion from RMS 12.0.6 to RMS 13.2.4
  • Configured User and access level security and Application Roles for RMS
  • Configured and Developed customizes BI-publisher Reports for RMS
  • Reviewed one-off patches and Patch-set for RMS
  • Designed and developed Conversion approach and customized data-seeding for SIM
  • Detailed knowledge of SIM Data-model, Standard APIs, PL-SQL source code (Packages, procedures and functions)
  • Comprehensive knowledge of SIM functionality including Setup, Deliveries, Transfers, returns and Inventory adjustment
  • Good knowledge of functioning of SIM Batches
  • Migrated Users and Role setup from SIM version 12.1.3 to SIM version 13.2.4
  • Configured customized BI-publisher reports for SIM
  • Configured SIM Web Services for external client and Oracle Fusion Middleware.
  • Reviewed one-off patches and Patch-set for SIM
  • Reviewed one-off patches and Patch-set for RPM
  • Good Knowledge of Allocation Functionality including creating and personalizing Allocations
  • Detailed knowledge of Allocation Data-model, Standard APIs, PL-SQL source code (Packages, procedures and functions)
  • Designed and developed Full and Delta Conversion approach for Data Conversion from Allocation 12.0.6 to RPM 13.2.4
  • Configured User and access level security and Application Roles for Allocation

Hire Now