Summary

• Around 10 years of extensive experience in the Information Technology industry serving as a Developer, Programmer and end-user training with multiple teams of software professionals in a development environment.
• Expertise in Oracle databases (11g/10g/9i/ 8.x/ 7.x), PL/SQL programming, SQL loader, SQL tuning, database tuning, building Complex Queries, etc.
• Extensively worked on client-server application development using Oracle 10g/ 9.x, 8.x, 7.x, and Forms 10g/9i/6i/4.5, Reports 10g/9i/6i/2.5 ,Graphics, PL/SQL, SQL, ADF, Jdeveloper .
• Expertise in writing stored procedures, packages, triggers for oracle 11g/10g/ 9.x, 8.x, 7.x.
• Experience in PL/SQL programming in developing advanced Object Relational Database objects, Packages, Triggers and Subprogram units.
• Experience in Data Migration using SQL-Loader, day to day DBA activities such as Import-Export, user maintenance and performance tuning etc.
• Experience in UNIX commands, VI Editor, Shell scripting and FTP.
• Experience on Oracle R12 Applications System (Financial Application Module)
• Experience with Oracle Application upgrade from 11i to R12.
• Possesses expert knowledge of the Oracle open interface tables and APIs.
• Hands on Administrating Oracle Database (Installation, Upgrading, Security) to latest versions.
• Worked extensively in writing PL/SQL procedures, Functions, Triggers, Cursors.
• Design, development and deployment of large software applications in both Client/Server and Web Server Environment.
• Excellent inter-personal, organizational, oral and written communication skills. Can work in a team or independent without supervision.

Technical Expertise:

Database

Oracle 11g/10g/9i/8i, PL/SQL, SQL, SQL PLUS, Performance Tuning, Capacity Planning, Installation, Upgrade, Migration, Backup & Recovery, Security, ODBC, ADO, DAO, OLE DB, DTS.

Applications

Oracle Forms and Reports 10g/9i/6i ,Oracle BI Publisher, Oracle BI Discoverer, Erwin 3.5/4.1, MS Visio, Crystal Report 8.5/9, Rational Rose Enterprise, UML

Language

Java, HTML, XML.

Operating Systems

Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional/NT 4.0 Server, UNIX (Sun Solaris), Red Hat Linux, UNIX Shell Scripting

Development Tools

Tool for Oracle Application Developers TOAD, Embarcadero Rapid SQL.

ERP Modules

Oracle R12/11i , GL,AP,AR,AOL

Education

• M.BA
• B.Sc. Engineering in Electrical & Electronic.

Certification

Oracle Certified Professional (OCP) Oracle 9i

Confidential,Irving, TX Jan 2011- to date
Senior Oracle PL/SQL Developer

Responsibilities:

• Worked with Data Modeling using Microsoft Visio and Rational Rose.
• Backend Programming (Functions, Procedures, Packages, Database Triggers) using Oracle 11g
• Version Control Software Win CVS maintain.
• Developed PL/SQL stored procedures to gather and present data.
• Created Dynamic SQL queries.
• Data extraction from flat file , Sybase to Oracle
• Developed SQL queries, PL/SQL programs, Oracle Reports and UNIX shell scripts for client requirements
• Develop and maintain the documentation to support the team and business.
• Screen designing using Forms 10g and developing reports using Reports 10g and Graphics.
• Crontab scripts for data export / import.
• Creation of schema objects through Erwin tool, transferring data from non-Oracle platforms to Oracle database using SQL * Loader
• Worked on Oracle EBS R12 Financial Module (GL,AP,AR)
• Forms Customization/Personalization, Customized Reports, Concurrent Process.

Environment: Windows 2003 Enterprise Server/ Virtual Server ,Sun Solaris, Oracle 10g, Oracle Forms 10g ,Oracle Reports 10g, Oracle BI Publisher, Oracle BI Discoverer , Oracle Application Server , QVCS, VISIO 2007, PL/SQL Developer, SQL Loader, Export/Import, TOAD, Ms Visio, UNIX Shell Scripting.

Confidential,Louisville, KY Jan 2010- Dec 2010
Senior Oracle Developer

Project Description: Healthcare Recoveries & TransPaC Solutions software developed & modified using Developer Suite 10g , Single Sign on.

Responsibilities:

• Backend Programming using Oracle 11g.
• Web based application development using oracle forms 10g with application server .
• Modified, maintained and developed the PL/SQL codes to develop new enhancements.
• Develop and maintain the documentation to support the team and business.
• Responsibilities as an oracle developer include management of the queries, enhancement and support service issues.
• Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.
• Performed unit testing for the scripts.
• Screen designing using Forms 10g and developing reports using Reports 10g and Graphics.
• Wrote packages, stored procedures, functions and other PL/SQL blocks for automations in processing and loading data in to tables.
• Creation of schema objects through Erwin tool, transferring data from non-Oracle platforms to Oracle database using SQL * Loader
• Developed SQL queries, PL/SQL programs, Oracle Reports and UNIX shell scripts for client requirements
• Created documents which detailed the various functional and technical problems encountered in solving production problems.
• Version Control Software QVCS maintain.
• Worked on Oracle EBS R12 Financial Module (GL,AP,AR)
• Oracle Application upgrade from 11i to R12.
• Responsible for Data conversion from legacy system to Oracle modules.
• Implemented all modules using AIM methodology.
• Developed control files for SQL *Loader, PL/SQL programs and Unix Shell Scripts for loading, data mapping, data conversions and validating the data into the interface tables from the legacy system.

Environment: Windows 2003 Enterprise Server/ Virtual Server , Sun Solaris, Oracle 11g, Application server 10g, Oracle EBS R12,Oracle Forms 10g ,Oracle Reports 10g, Oracle BI Publisher, Oracle BI Discoverer ,QVCS, PL/SQL Tools, Oracle ADF, Jdeveloper, Erwin, SQL Loader, Export/Import, TOAD, Ms Visio, UNIX Shell Scripting, Business Objects

Confidential,NY Jun 2007- Dec 2009
Oracle Developer

Project Description: Data Conversion from Access 97, FoxPro, SQL Server to Oracle 10g
Forms & Reports design using Oracle Developer Suite 10g
Responsibilities:

• Worked with Data Modeling .
• Backend Programming using Oracle 10g,
• Web based application development
• Screen designing using Forms and developing reports using Reports 10g.
• Wrote stored procedures, functions and other PL/SQL blocks for automations in processing and loading data in to tables.
• Wrote Unix Shell script to monitors Oracle instance performance, tablespace, users and objects, and send email to pager automatically.

Environment: Windows 2003 Enterprise Server/ Virtual Server , Citrix Server 4.5, Sun Solaris, Oracle 10g, Oracle Forms 10g ,Oracle Reports 10g, Oracle ADF, Jdeveloper, Oracle Application Server , XML, Erwin, SQL Loader, Export/Import, TOAD, Ms Visio, UNIX Shell Scripting, Business Objects,

Confidential,MA Mar 2006-May 2007
Oracle Developer

Project Description: Asset Back Securitization System (ABS)
As an Oracle developer was involved in ABS System. ABS System (Asset Back Securitization System) is oracle based software, it’s provide output to the clients Profitable Deal Execution, Risk Mitigation, Leverage a proven securitization infrastructure, Maximize the liquidity of portfolio, Manage capital ration, Minimize operation risks and Retain more cash.

Responsibilities:

• Developed operational plan for ETL, Data Loading and data cleaning process and wrote scripts for automation using shell scripting.
• Worked with Data Modeling (both Physical and Logical Design).
• Backend Programming using Oracle 10g/9i,
• Screen designing using Forms 6i and developing reports using Reports 6i and graphics..
• Wrote stored procedures, functions and other PL/SQL blocks for automations in processing and loading data in to tables.
• Wrote Unix Shell script to monitors Oracle instance performance, tablespace, users and objects, and send email to pager automatically.
• Oracle Performance Tuning.
• Involved in designing database, modeling database and maintaining database
• Creation of schema objects through Erwin tool, transferring data from non-Oracle platforms to Oracle database using SQL * Loader
• Involved in Monitoring, Tuning, auditing users, assigning roles and privileges, backup and recovery.
• Involved in partition designing and table space and table partitioning for data warehousing purpose.
• Created perfect Models for database structures, created star/snow flake Schemas, sizing of schemas including Tables, Indexes, tablespace size calculations, specifying extent sizes to database objects.
• Wrote stored procedures, functions and other PL/SQL blocks for automations in processing and loading data in to tables.
• Wrote SQL Loader scripts for bulk load operations in Tables.
• Developed shell scripts for the execution of different module procedures for batch processing.
• Automated production support activities by writing automation scripts using UNIX Shell Scripting to generate business critical reports (Daily, Weekly and monthly) and directly sending these reports to respective departments.
• Using Business Objects, company seeks to help clients improve efficiency, align company strategies, strengthen profitable relationships and enhance products and services.

Environment: Sun Solaris/HP-UX / NT, Oracle 9i,Oracle 10g, Oracle Forms 6i/9i ,Oracle Reports 6i/9i, Erwin, SQL Loader, Export/Import, TOAD, Ms Visio, UNIX Shell Scripting, Business Objects

Confidential,Feb 2000- Dec 2005
PL/SQL developer / Database Administrator

Project Description: The transaction data is extracted from the various branches across the country, which Uses a system called CDAS and developed Reports for the project, which is the most Comprehensive, intranet powered information management system ever available to the ATM Transactions financial Services, and is able to efficiently manage and integrate all of their financial, and administrative data Services. FTP component was developed internally. Providing secure, Intranet based ATM Transaction management system.

Responsibilities:

• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 9i, Developer 2000, Forms 6i, Report 6i, Report Builder and PL/SQL.
• This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database.
• Define database structure, mapping and transformation logic. Creation of External Table scripts for loading the data from source.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Effectively involved in Functional and Technical documentation for Report development as per business needs, developed stored procedures for the reporting needs, converting regular reports into HTML, Excel and PDF formats.
• Used TOAD and SQL navigator extensively.

Environment: Oracle 9i, SQL, PL/SQL, UNIX Shell Programming, Forms6i, Reports6i.