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 DeveloperResponsibilities:
- 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.