Senior Oracle PLSQL Developer

Summary

Shreyash Wadekar

ade87a@r.postjobfree.com

+91-917*******

www.linkedin.com/in/swadekar

Pune, India

Self-directed and motivated Oracle developer with more than 10 years' experience working in the finance and retail industries, with extensive exposure to Oracle background. Highly skilled with gathering requirements and designing in traditional waterfall method and Agile framework. Possesses advanced team leadership and mentoring skills, liaising confidently with a diverse range of stakeholders to complete all tasks effectively and to the highest standard.

Roles

Senior Oracle Analyst Programmer/Team Lead

Oracle Developer

Oracle ERP Developer

Education

University of Pune - Bachelor’s in Computer Science.

Skills

Oracle 8i/10g/11g/12c/18c - PLSQL/SQL.

Oracle REST Data Services.

Oracle Forms and Reports Development.

Oracle Advanced Queuing.

PLSQL/SQL Performance tuning.

JReports.

Tools: SVN and PVCS, Mingle, Trello, JIRA and confluence, Toad, SQL Developer and PLSQL Developer.

Oracle 8i to 10g Migration/Upgradation.

Oracle Apex migration to Oracle Cloud.

Oracle Apex.

Basic knowledge on Oracle Cloud (ATP).

Oracle Apps (ERP).

Pro*C and basic knowledge of C.

Unix script.

Strong knowledge on Agile.

Strong knowledge on Waterfall method.

Assignments

February 2020 – Till Date: Senior Oracle Analyst Programmer - Student Loans Company (SLC), Offshore

Role and responsibilities:

Working as a Senior Oracle Analyst Programmer of offshore technical development team.

Created/modified tables, sequences, synonyms, triggers, Oracle queues, Oracle REST data services and other Oracle objects.

Used Explain plan and TOAD ‘PROFILER’ for analysing batch modules/packages/tuning SQL queries.

Working on POC on Oracle Forms to Oracle Apex migration and then migrating Oracle Apex application to Oracle cloud.

Responsible for creating demos and videos of Oracle Forms to Oracle Apex migration.

Created Autonomous Transaction Processing Database (ATP) on Oracle Cloud and building Oracle REST Data Services using Oracle Apex.

Training team members on Oracle REST Data Services.

February 2014 – January 2020: Senior Oracle Analyst Programmer/Team Lead, Student Loans Company (SLC), Glasgow (UK)

Role and responsibilities:

Worked as a Senior Oracle Analyst Programmer/Team Lead of onsite technical development team.

Acted as Technical Design Lead during one of the projects inception phases.

Created/modified tables, sequences, synonyms, triggers, Oracle queues, Oracle REST data services and other Oracle objects.

Created Oracle REST Data Services (GET/POST/PUT/DELETE) to perform business and functional operations.

Worked on Oracle 8i to Oracle 10g upgradation project.

Used Explain plan and TOAD ‘PROFILER’ for analysing process/packages/SQL queries.

Responsible for gathering technical requirement and creating design documents.

Assisted testers by developing procedures to generates test data.

Automated unit testing process by using DBMS_SCHEDULER.

Created complex packages/procedures for core finance modules.

Responsible for reviewing the code within the team.

Achievements:

Introduced Oracle advance queueing concept; in Student Loans Company by learning and successfully implementing in one of the projects.

Code Checklist Automation: Automated code checklist and coding standard checklist using TOAD functionality ‘CODE ANALYSIS’.

November 2011 – January 2014: Oracle Developer at First Data Corporation (FDCS).

Role and responsibilities:

Worked as a member of offshore technical development team.

Responsible for requirement analysis and producing design documents.

Developed/enhanced complex procedures, functions, packages, queries, and views for different transaction modules and business requirements.

Created/modified tables, sequences, synonyms, dB links, triggers and other Oracle objects.

Developed procedures which generates test data helping to resolve data issue in lower environment.

Developed reports for concept transactions extract from scratch using JReports tool.

Used tkprof utility for analysing session trace files.

Used Explain plan for analysing SQL queries.

Proactively suggested and implemented ideas for improving technical platform efficiency.

Worked with production support team on incident reports.

May 2010 – October 2011: Oracle ERP developer at Golfsmith.

Role and responsibilities:

Customizations, registrations and retrofitting of packages from 11.0.03 to R12.

Prepared Data Loader module for Loading Data.

Involved in the development of interfaces/ Conversions to import the data from legacy system into Oracle application base tables.

Worked on Data Conversion of Discounts, Purchase Order and Price Lists.

Developed HRMS interface code to load the Employee details into Oracle R12 system from UltiPro.

Developed and tested the interface and conversion scripts.

Prepared shell script and installation script to load customization in next instance.

Worked on EDI 997 which reads the data from comma separated .CSV file from the server and then inserts the data into custom table.

Customized commission rule and Copy Multi PO form using Oracle Forms 10g.

Registered the form in Oracle Applications.

Contact this candidate