Senior Oracle Developer Resume
SUMMARY
- More than 10 years of progressive experience developing and designing PL/SQL implementations with small and large applications
- Developed Multi - tiered Business Application using Oracle Development Tools.
- Performed SQL and PL/SQL tuning and Application tuning using various tools.
- Extensive experience working with Oracle 8i/9i/10g/11g with Web logic server including PL/SQL programming.
- Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries and Packages.
- Experienced to write efficient, complex queries against very large data sets.
- Experience in Oracle E-Business Suite R12.
- Experience in working on SQL Loader, UTL FILE for ETL operations.
- Experience in an Oracle environment using Oracle Development Tools (Oracle Forms/Reports, SQL, PL/SQL).
- Experienced in designing of logical and physical models of data using data modeling tools such as Erwin and ER Studio.
- Have knowledge of Java, C++.
TECHNICAL SKILLS
Databases: SQL, PL/SQL, SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries and Packages,Oracle Forms and Reports 6i, 10g, 11g with Fusion Middleware WebLogic Server,Oracle 6/7/8/9i/10g/11g,UNIX, LINUX and Windows.
ADF development using: JDeveloper as ADF Faces, ADF Task Flows, ADF Business Components, Web Services.
Data modeling tools: Erwin and ER Studio, JDeveloper 12.1.2.0, Oracle Forms 6i/10g/11g, Oracle Reports 6i/10g/11g.
Database: Oracle 6/7/8/9i/10g/11g/12c.
Application Server: Oracle 10g IDS, Fusion Middleware Web logic server.
Operating System: Windows Server 2003,2008, Windows 2010, Red Hat Linux 6.0
Database Design: ER-Studio, Erwin.
Database Query: SQL Developer, TOAD.
PROFESSIONAL EXPERIENCE
Lead Oracle Developer / PL/SQL Developer
Confidential
Responsibilities:
- Involved in full development cycle Planning, Design, Development, Testing and Implementation.
- Developed, managed and stored a wide range of information about tangible and intangible assets in the system.
- Developed integration process module of system with in-house developed General Ledger System.
- Developed PL/SQL triggers to Add, Dispose and Transfer Fixed Assets . Created PL/SQL Cursors, procedures and functions to calculate the depreciation processes.
- Converted this system from Oracle 6i to Oracle IDS 10g by using SQL and PL/SQL procedures.
- Creation of database objects like Tables, Views, Synonyms, Procedures and Packages using Oracle Tools like SQL*PLUS,PL/SQL Developer and TOAD.
- Extensively used the advanced features of PL/SQL like Records, Tables, Object Types and Dynamic SQL.
- Developed complex database objects Views, Stored Procedures, Functions and Packages by using SQL and PL/SQL.
- Developed the termination, partial termination and maturity processes by using PL/SQL Triggers, procedures and Functions.
- Developed Journal voucher, Receipt vouchers and payment vouchers generated by system in different processes of disbursement and receive rentals.
- Created Triggers, PL/SQL Stored Procedures, Functions and Packages to develop the monthly accruals process.
- Developed list of assets, lease type wise, duration wise, amount wise, daily and monthly rental about 200 reports.
- Developed and maintained the Lease Management System software for SAUDI PAK LEASING COMPANY, JS BANK LIMITED and ATLAS HONDA PVT. LIMITED.
- Migrated the Desktop Oracle Forms and Reports 6i Application to Web Based Oracle 10g/11g live application by creating PL/SQL procedures, functions and packages.
- Delivered functional specifications for the new solution integration as a SME for Oracle EBS.
- Strictly adhered to GE six sigma toll-gate methodology to deliver a complete project cookbook covering end to end implementation.
- Conducted interactive session with key business stake holders while consulting on business processes and policies.
- Closely worked and coordinated with the technical teams to deliver the solutions as per the functional designs and customizations.
Functional Consultant
Confidential
Responsibilities:
- I was working as a Functional Consultant.
- During my working period I have been involved in the Functional Training of Financial Modules.
- I was working with General Ledger Module and stand setup from Chart of Accounts, Entering Values and Creating Ledger, Assigning Responsibilities, Creating Users and JV Entries.
- Conduct design workshops and functional process workshops in all financial areas.
- Provide status and issue reports to the Project Manager on a regular basis.
- Develop end-user documentation and training materials.
- Define testing scenarios and develop test scripts.
- Manage a volume business i.e. many deals in a given period. Fusion CRM internal tool is used to follow up opportunities.
- Interact with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions.
- Identify functionality gaps and develop solutions to them.
Senior Oracle Developer
Confidential
Responsibilities:
- Developed and implemented system called CAMS (Consumer Asset Management System).
- Developed all the screen for customer information, CIB verification, NADRA Database verification
- Approval and Payment schedules during tenure by creating PL/SQL Triggers, Cursors, Procedures and Functions.
- Created various DDL and DML statements using SQL and PL/SQL.
Oracle Developer
Confidential
Responsibilities:
- Created PL/SQL procedures, Functions, Packages and developed Land Management System for Confidential as a member of a skilled team.
- Designed and developed reports to control the Inventory, Allotment, Balloting, Leasing, Mutation and Transfer of Plots process about 80 reports.
- Designed logical and physical models of data by using ER-Studio.