We provide IT Staff Augmentation Services!

Sr Pl/sql Developer Resume

NJ

TECHNICAL SKILLS:

Databases: Oracle (SQL, PLSQL), MS SQL Server(T - SQL), Teradata (SQL ASSISTANT)

Scripting: UNIX Shell Scripting

GUI: Oracle Forms 6i/9i and Reports 6i/9i

Languages: PLSQL, CORE JAVA, UNIX, C, C++

ETL&BI: Knowledge on Informatica, Cognos and DWH concepts

Tools: SQL Developer, TOAD, SQL plus, PUTTY, WINSCP

EBS: Oracle CRM (Teleservice, CRM foundation, Install Base, Service Contracts, Call center, Field Services), oracle PIM, oracle Inventory

Operating Systems: Windows 7, Windows Vista, XP, UNIX, Linux

Ticketing Tools: BMC Remedy

Version Control: CVS, Git, TFS

Data Modeling: Sql Developer, Toad

WORK EXPERIENCE:

Confidential, NJ

Sr PL/SQL Developer

Responsibilities:

  • Worked primarily on development of new CR’S
  • Worked on Bug Fixes and Production break fixes
  • Unit testing and Support to SIT and UAT
  • Sql developer integration with GIT. Code check in and out from sql developer to GIT.
  • Worked on performance tuning by restructuring the existing packages.

Environment: Oracle Database 12c, SQL Developer,PL/SQL, SQL, HP ALM,Java, Angular Js, React Js, postman,git, jira

Confidential, Florida

Lead PL/SQL Developer

Responsibilities:

  • Worked on MYSQL to oracle migration.
  • Excel to oracle query migration.
  • Supported team on oracle queries.
  • Wrote procedures for trade in and trade out files.
  • Wrote procedures for cash out flow when the plan is matured.
  • Worked on creating Sql developer data model for plan intake project.
  • Created logical and physical data model using Sql developer data modeler.

Environment: : Oracle Database 12c, PL/SQL, SQL, REST/SOAP API

Confidential, Florida

Sr PL/SQL Developer

Responsibilities:

  • Worked primarily on Outage and Reward scripts
  • Supporting emergency CR’s
  • Improved the performance of the application by rewriting the SQL queries.
  • Adhoc reports has been provided upon request
  • Debugging Procedures & Functions and improving the Performance of Application.
  • Used the CVS for version control and for tagging the CR’s
  • Preparation of Unit Test cases and upload the same to confluence
  • Completed all the CR’S based on 15day release cycle plan, it included support of existing CR’s and developing for new CR’s.

Environment: : Oracle Database 12c, SQL Developer, PL/SQL, SQL, TOAD, UNIX, GitHub, Confluence, JIRA, CVS, HP ALM

Confidential

Sr PL/SQL Developer

Responsibilities:

  • Worked primarily on Commercial statement generations scripts
  • Developed/tuned complex package for CS statements. This involved developing database objects like procedures/packages, functions, triggers, bulk updates/inserts.
  • Performed Unit testing, System testing for the Data Integrity and the functionality of the newly created business requirements for commercial statements.
  • Worked on testing 5 modules of commercial statements.
  • Worked on reconciliation of main frame files with oracle files.
  • Developed UNIX shell scripts to generate the delta process for the daily test run.

Environment: Oracle Database 11g, SQL Developer, PL/SQL, SQL, TOAD, UNIX, Git, Confluence, Jira, Exadata

Confidential, New York, NY

PL/SQL Developer

Responsibilities:

  • Developed PL/SQL Packages, Procedures, Functions and Triggers as per Business Requirements.
  • Performance tuning of the stacking application.
  • Worked mostly on Interface issues
  • Prepared the documents and posted in Share point
  • Developed process improvements using the Bulk Collect and FORALL (Bulk Bind) methodology.
  • Completing unit and integration testing of the jobs for GP Archiving.
  • Performed SQL tuning using Explain Plan, Hints and indexes.
  • Used WITH clause to improve the performance of Cognos Reports queries
  • Debugging Procedures & Functions and improving the Performance of Application.

Environment: Oracle 11g, UNIX, Toad, Putty, Revitas

Confidential

PL/SQL Developer

Responsibilities:

  • Be the first Point of Contact for all the client escalations, Be the bridge between onsite and offshore team and responsible to handle the sync up calls between onsite and offshore.
  • Identifying and documenting the technical issues and the approach to resolve the same.
  • Assigning and working on incidents to team based on priority/Availability.
  • Handled/ monitored all movement of codes (code-migration) to several testing and Prod environments.
  • Using BMC Remedy tool to accept tickets raised by various Business/IT-Users and converting them as IT enhancement requirement by discussions with the business representative.
  • Groomed freshers on the functionality of the application
  • Attended the P1/P2 bridge/ Onsite/Offshore Sync up calls.
  • Preparing the management updates by sending the daily status report

Environment: UNIX, Oracle 10g, Oracle Apps R12, PIM, Inventory

Confidential

PL/SQL Developer/ BA

Responsibilities:

  • Provided SIT and UAT Support.
  • Providing Adhoc Reports.
  • Worked with release managers on adjusting the cr’s in current release cycle.
  • Involved in business meetings and prepared BRSD and followed up with business on sign off BRSD.
  • Involved in Database design, entity relationship modeling and dimensional modeling using Star and Snowflake schemas.
  • Worked on PL/SQL stored procedures, functions and packages for moving the data from staging area to main tables.
  • Participated in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Environment: UNIX, Informatica, Obiee, Sap Bo, Teradata, Oracle 11g

Confidential

PL/SQL Developer

Responsibilities:

  • Involved in configuration and processing designing of many new Service Requests.
  • Represented CRM team in the meetings with business regarding Operational Issues.
  • Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
  • Coordinating with other Modules wrt to Interfacing issues.
  • Support to IVR, Scripting & SMS applications.
  • Worked extensively on Dynamic SQL, Bulk loading, Bulk processing.
  • Worked on POS interface file processing
  • Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Performance tuning of Oracle Databases and User applications.
  • Improved the performance of the application by rewriting the SQL queries.
  • Worked on packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
  • Involved in brain storming sessions with the Business Users to gather requirements.
  • Prepared and Documented the technical specifications.
  • Prepared requirement traceability matrix to map the business requirements to functional specifications.
  • Involved in knowledge transfer sessions for other dependent/cross functional and support teams to ensure that the application under development confined to the business requirements and any changes in design/requirement are communicated and shared.

Environment: UNIX, Oracle 9i, Forms 6i, Reports6i, Oracle CRM11i (Service contracts, Tele sales)

Hire Now