Sr. Oracle Developer Resume
MD
SUMMARY
- Having 7 years of IT experience complemented by analysis, design and developing skills.
- Experience in projects involving object oriented methodologies.
- Working expertise in Relational Database Systems like Oracle.
- Strong Programming experience in PL/SQL and DEVELOPER - 2000.
- Used Dynamic LOV by handling Record Group programmatically.
- Developed Forms Library to use as common object.
- MDI application with multiple windows and canvas interfaces.
- Used all important Form triggers and Built-in packages.
- Used Report triggers.
- Experience in development of Packages, Procedures, Functions and Triggers.
- Performance tuning which included creating indexes and modifying tables using Explain plan utility.
- Created materialized views.
- Created Public Synonyms and Database Links public/private.
- Hands on experienced with Oracle Forms 6i/9i/10g and reports generation with Oracle Reports 6i/9i/10g.
- Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref. cursors, Varrays, nested tables and Dynamic SQL.
- Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
- Proficient in Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, and Auto trace.
- Expertise in handling errors using Exceptions.
- Good experience of direct interaction with client.
- Versatile team player with good analytical and problem solving skills.
TECHNICAL SKILLS
Programming Languages: SQL/PLSQL, JAVA
Databases: Oracle11g/10g/9i
Tools: Oracle D2K, Oracle Developer Suite, Developer/2000 Forms 5.0/6i,10g & Reports 6i,10g, TOAD, SQL Developer, Pl/SQL Developer, JDeveloper, SQL*Loader, SQL*PLUS
BI Tool: Qlik View
Operating Systems: Windows XP/2000, UNIX
Web Technologies: HTML, XML
Office Applications: Word, Outlook, Power point, Excel
PROFESSIONAL EXPERIENCE
Confidential, MD
Sr. Oracle Developer
Environment: Oracle 10g, SQL plus, PL/SQL, Java, J2EE, Windows XP, Toad 9.0, Putty Connection Manager, Win SCP, Oracle Forms
Responsibilities:
- Created Oracle PL/SQL procedures and packages to transfer and process customers data.
- Wrote SQL statement for ad-hoc report generation and for data cleansing.
- Responsible for the designing the advanced SQL queries, procedure, cursor, triggers, scripts
- Used Advanced Oracle PL/SQL techniques like cursors and bulk collect for data retrieval.
- Tuned the complex SQL queries for the better performance.
- Used SQL*LOADER for loading the data into the database using control files.
- Prepared SQL scripts to validate the data in the Report.
Confidential
Sr. Oracle Developer
Responsibilities:
- Generated SQL and PL/SQL scripts to install, create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
- Performed analysis, design, coding, implementation and support
- Developed Stored Procedure, Package and Triggers for back end validations
- Developed procedures using Oracle supplied Packages for Notifications
- Developed additional localizations.
- Involved in migrating oracle from 9i to 10g
- Developed complex SQL queries using joins and correlated sub queries.
- Created indexes for faster access of data.
- Documented business rules, functional and technical design, test cases and user guides. Involved in debugging and error handling.
- Created TABLESPACE, schemas, tables, views and index.
- Created Data Flow Diagrams, Flow Charts, ER-Diagrams and Work Flow Diagrams in Requirement Collection, Analysis and Design for the required application.
- Coded and debugged triggers at various levels and involved in testing of each module
- Developed shell scripts for automating the batch programs.
- Tuned the stored procedures and the database for the better performance.
Environment: Oracle 10g, Oracle Forms & Reports 10g, SQL plus, shell Scripts, SQL, PL/SQL, PL/SQL Developer, SQL*Loader Windows XP, Toad 9.0, Putty Connection Manager, WinSCP
Confidential, NY
Oracle PL/SQL Developer
Environment: Oracle 10g, PL/SQL, SQL Developer, Java, J2EE, JDBC, UNIX, Toad 9.0, Oracle OWB, Clear Case
Responsibilities:
- Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per User requirements to make new enhancements.
- Developed and designed UI using Oracle forms developer tool.
- Designed and developed interfaces b/w Java (frontend) and Oracle (backend) using PL/SQL.
- Designed & developed reports.
- Prepared SQL scripts to validate the data in the Report.
- Participated in regular project status meetings related to testing.
- Performed Report testing by validating layout, data in the report.
- Performed Change Request whenever the customer needs to change their existing Business Rules or they may integrate a new rule.
- Seamless Client / Onsite Co ordination with the Offshore Team to proactively identify and mitigate risks / issues.
- Creating and maintaining project documents for the subsystem. Ensuring appropriate use of methods, tools and techniques within the team.
- Worked on SQL scripts to load data in the tables.
- Learned usage of ETL tool Oracle OWB.
- Developed OWB mappings and defined transformation code rules.
- Performed UAT.
- Source Code Version Controlling.
- Handling Problem Requests of end users.
Confidential
Oracle PL/SQL Developer
Environment: Oracle Forms & Reports Developer 6i, Oracle10g, PL/SQL, Windows XP.
Responsibilities:
- Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per User requirements to make new enhancements.
- Developed User Interfaces.
- Designed, developed and tested various Outstanding/CN/DN/Adjustment reports.
- Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
- Developed PL/SQL packages, procedures, functions.
- Designed and Developed forms & Reports.
- Prepared test cases and performed unit testing.
- Performed UAT.
- Overall Billing & Performance against Target
- Overall Collection against Target
- Combined Published Space
- Combined Realization Break-up Summary
- Party/Client Ledger etc-
- Implemented major MIS reports using Qlik View
Confidential
Environment: Oracle Developer Suite 10g, Oracle10g, PL/SQL, SQL plus, Windows XP, BI Tool Qlik View.
Responsibilities:
- Developed PL/SQL packages, procedures.
- Designed & Developed Procedure based forms.
- Designed & developed reports.
- Prepared SQL scripts to validate the data in the Report
- Performed Report unit testing by validating layout, data in the report.
- Creating and maintaining project documents. Ensuring appropriate use of methods, tools and techniques within the team.