We provide IT Staff Augmentation Services!

Sql Developer Resume

3.00/5 (Submit Your Rating)

Smithfield, RI

EXPERIENCE SUMMARY:

  • Around 9 years of experience in Oracle PL / SQL, Unix, Data Warehousing concepts and IBM Mainframe(COBOL, DB2,JCL,CICS).
  • Strong customer interaction skills and good hands on knowledge in Requirements gathering, Analysis, Estimation and Planning
  • Currently working as the Onsite co - coordinator and overseeing the work of 15 offshore developers
  • Highly skilled and shown eminence in all phases of a Software Life Cycle - Requirements, Analysis, Documentation, Design, Build and Testing / Support - in the process of implementing a Data Warehousing/Retail solutions.
  • Experienced to translate reporting and analytical needs into technical solutions
  • Involved in Performance maintenance and tuning, PL/SQL optimization of various Oracle objects for the creation and maintenance of data warehouse.
  • Experience in building and maintenance of a Data warehouse.
  • Possess expertise with Oracle stored procedures, packages, and functions
  • Strong knowledge in Oracle Cursor management, Exception Handling and also Experience in performance tuning (PL/SQL) using Explain Plan, Indexing and Hints and optimizing the oracle objects like Packages, Procedures and Functions.
  • Experience in building and maintenance of a Retail applications.
  • Involved in the analysis and solving of several Adhoc Production Request / issues
  • Received the ‘Bravo’ award for the month of June-2013. This award is given to a single employee for outstanding performance in each Business Unit every quarter.
  • Good knowledge on object oriented programming concepts.
  • Ability to work simultaneously on multiple projects, work independently as well as a team member.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g / 10g / 9i, TOAD 9.6, SQL*Plus, Oracle Applications, IBM DB2

Programming Languages: SQL,PL/SQL, UNIX, COBOL, IBM DB2, JCL and CICS

PROFESSIONAL EXPERIENCE:

Confidential, Smithfield, RI

SQL Developer

Responsibilities:

  • Working on Oracle to Exadata migration project(ADS/RXIMG Compliance application migration).
  • Working on the Project Build/hands on and go live activities.
  • Interface with internal team, including offshore to carry out onsite specific tasks like design walk through, code build, knowledge sharing etc.
  • Understanding User requirements from Business & communicating to Offshore.
  • Creating design documents.
  • Involved in developing various PL/SQL packages, procedures and functions.
  • Query optimization and performance tuning.
  • Planning and prioritization.
  • Unit testing, Integration test and Release testing.
  • Code Reviews.
  • Involving in the Database Modeling & Impact Analysis for the requirements given.
  • Involved in the optimization of various SQL and PL/SQL Indexes, Hints and other basic tuning techniques
  • Involved in deploying the developed components in production and supporting during its warranty period.

Confidential

SQL Developer

Responsibilities:

  • Creating design documents.
  • Involved in developing various PL/SQL packages, procedures and functions.
  • Query optimization and performance tuning.
  • Planning and prioritization.
  • Unit testing, Integration test and Release testing.
  • Code Reviews.
  • Involving in the Impact Analysis for the requirements given.
  • Involved in the optimization of various SQL and PL/SQL Indexes, Hints and other basic tuning techniques

Confidential

SQL Developer

Responsibilities:

  • Creating design documents.
  • Involved in developing various COBOL, CICS, EZT programs which involves JCL and DB2.
  • Query optimization and performance tuning’s
  • Planning and prioritization.
  • Unit testing, Integration test and Release testing.
  • Code Reviews.
  • Involving in the Database Modeling & Impact Analysis for the requirements given.
  • Monitoring of jobs and coordinating with onsite.

We'd love your feedback!