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.