Summary:

• Around 8 years of experience as Oracle Developer in complete software development life cycle with active participation in database design, development, reporting and administrative tasks.
• Expertise in Developing applications using iDS:Forms11g/10g/9i/6i Reports10g/9i/6i, Oracle Designer10g for Data modeling.
• Extensive experience working with Oracle databases 8i/9i/10g/11g Back - end Programming using SQL, PL/SQL, Packages, Stored Procedures, Functions, Packages, Database triggers for Oracle 10g/9i/8i and also SQL queries/reports.
• Experience in ODBC and JDBC programming, Unix shell scripting, including development of Unix Shell scripts
• Expertise in SQL and PL/SQL programming, developing complex code units and using the latest features to optimize performance Bulk Binds, Materialized views, Inline views, Global Temporary Tables .
• Good programming and debugging skills in PL/SQL, SQL, Dynamic SQL and UNIX shell scripting
• Strong skills in writing technical and functional documents defined by the business requirements
• Gathering the requirement from the BA and according that prepare the DFD and ER Diagrams
• Retail, Banking, Investments and Healthcare industry experience.
• Knowledge in web logic server application
• Performed Application and SQL statement tuning using Explain Plan, Optimizer Hints and Partitioning etc
• Usage of utilities such as SQL Loader, export, imports.
• Designed static HTML web sites
• Knowledge in Agile .
• Knowledge in C and .Net
• Follow SDLC Rules in all the project
• Excellent Communication, interpersonal skills. Worked in team environment with Managers, team leads, internal customers, other departments
• Experience with Data Modeling using Oracle Designer/Erwin Tools and performed activities such as configuration of Applications and sharing/unsharing them across multiple applications. Created complex E-R diagrams, Data flow diagrams, Server model configurations and implementations. New repository creations and migrations.

SKILLS:

Software :

Oracle Enterprise Edition 11g/10g/9i/8i on Unix as well as Windows XP/2000/NT, Oracle Forms 11g/10g/9i/6i, Oracle Reports 10g/9i/6i, SQL Plus, PL/SQL, Stored Procedures/Functions, SQL Loader, HTML, JAVA, JDBC, Portal, Database Triggers, Instead of Triggers, Packages, LOB's, Data Modeling using Oracle Designer 10g/6i/6.0/2.x/1.x, PVCS Version Manager, Star Team, PVCS Tracker

Hardware /OS:

SUN Fire Unix Systems, Windows 2000/98/95, Sun Solaris, HP 9000 Unix

Tools:

SQL Navigator 4.x, TOAD,DBA Studio, SQL Trace, SQL Plus

PROFESSIONAL

EXPERIENCE:

• Design the technical specification and documentation
• E-ACCESS support for development and enhancement in PLSQL and JAVASCRIPT
• Development of PL/SQL code by using Packages, Stored Procedures/Function and database level triggers
• Generation of DDL's and Tables, data reorganization to enhance performance
• Database and Application Tuning
• Developed PL/SQL Stored Procedures/Functions to meet the business needs.
• Developed PL/SQL Packages to facilitate financial applications.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance using EXPLAIN PLAN, TKPROF and SQL TRACE.
• Tables and Indexes Creation, Clusters, data reorganization to enhance performance
• Maintenance of Production Test Databases

Environment: Oracle Database 11g, TOAD, Windows XP

Oracle Forms Developer

Confidential

• Project Covered California for Agents CCFA mission is to provide SHOP Small Business Health Options Program Agents or marketplace to process the online application process simplified thru . This unique portal allows all the applicants to process their application fast and efficiently and then the SHOP agents upload the set of applications thru a batch process to CoveredCA portal. This process involves many modules to facilitate easy process for all the states and for all the SHOP Agents.
• Installed Oracle 11g Database and Installed Web Logic Server also configured both front end and back end.
• Developed Forms10g coding standards as per the Application needs.
• Configured webutil for Upload and Download files.
• Developed PL/SQL Stored Procedures/Functions to meet the business needs.
• Developed PL/SQL Packages to facilitate financial applications.
• Development of Forms10g/Reports10g in order to provide user interface.
• Developed Forms based on PL/SQL Stored Procedures to implement complex business functionality.
• Developed Object Libraries to maintain standards in Forms.
• Used PL/SQL bulk insert to insert the data into multiple table.
• Developed utilities to Upload/Download Client Local files to the iAS server and perform Database changes according to the contents of the files using WebUtil package.
• Developed various Reports to meet the customer needs.
• Modified the existing reports using Oracle discoverer to meet the business needs.
• Web based Development using iAS10g, Forms10g/9i/6i, Reports10g/9i/6i.
• Development of Database level triggers to update data into multiple tables.
• Developed Menus in such way that users can access the forms through menus.
• Development of single form to run all the Reports as central point.
• Developed List of values to populate data in certain conditions based on Record Groups.
• Databases and Application Tuning Maintenance of Production Test Databases

Environment: Oracle Database 11g, Forms11g, Reports 10g,TOAD, Windows8

Confidential

• CVS Caremark/Pharmacare is the nation's premier integrated pharmacy services provider. It delivers quality drug formulation to their patients through retail and mail dispensing.
• The SPRACS system based in Oracle Forms and Reports. The system is internal application used by Pharmacy employees and IT users to view, modify and analysis of patient's consumption profiles.
• Created Oracle Multiple Oracle Forms 10g and Reports 10g and deployed.
• Developed Oracle Forms using templates and Object libraries.
• Manipulated Stacked and tab canvas programmatically.
• Manipulated Windows programmatically by moving and resizing windows in Oracle Forms.
• Implemented Timer, record group and Lov in Oracle Forms.
• Implemented Multiple Oracle Forms and pass parameter values while invoking Forms.
• Developed Oracle Forms using text items, check boxes, display items, list items, radio groups in Oracle Forms.
• Used Form properties and triggers to control insert, update and deletes of table data.
• Developed Oracle Forms using mater-detail triggers, navigation triggers, message-handling triggers and interface event triggers.
• Developed Oracle Forms using Mouse event triggers and System variables.
• Developed Custom Menus using Menus and menu items in Oracle Forms.
• Developed Multiple Blocks Forms and deployed.
• Developed Menus and implemented security through menu roles.
• Created PL/SQL packages using collections like Nested tables and Varrays.
• Created PL/SQL packages using ref cursors and dynamic SQL.
• Created PL/SQL packages using new features like table functions.
• Created Stand alone Procedures and Functions to call from User interfaces.
• Created database Triggers for inserting primary keys and auditing of user records.
• Improved SQL queries by tuning SQL queries.
• Improved PLSQL program unit's performance by batch processing process.
• Improved PLSQL program unit's performance by tuning PL/SQL.
• Developed Unix Shell Scripts and called from PL/SQL packages.
• Administered Oracle Database by creating Schema objects, partition tables and indexes.
• Exported and Imported Oracle Data using Data Pump export and import utility.
• Replicated Database using Oracle Advance Queue.

Environment: Oracle Database 11g, Forms11g, Reports 10g,TOAD, Windows XP,Linux

Confidential

MI Oracle Developer

• Designed the technical specification and documentation
• Debugged PL/SQL Code, Performance Tuned bad SQL's, Developed Procedures, Functions and Packages for the business need
• Owned all the Application Deliveries that TCS performed on behalf of APP as an Onshore Coordinator Aloca APP and TCS
• Migrated COBOL Reports to Oracle Reports
• As a Onshore Coordinator Alcoa APP TCS, owning all the Application Deliveries that TCS is performing on behalf of APP
• Initiated formulated project status tracking tools and ideas where taken by client TCS team performed greatly in conversion and testing phase and based on the recommendation from Client, tried to get some more projects for TCS in other areas in APP IT
• Arranging Weekly Status Call, Monthly meeting between customer TCS, preparing the status reports and presentations, periodic feedback of the team from client are some of the activities, ensuring Customer Satisfaction
• Development of Unix Shell scripts, Unix shell scripts run the stored procedures/functions from Unix
• Worked on the technical areas like help understanding customer requirements on forms, reports changes testing and acted as an onshore technical co-coordinator between customer and TCS offshore team
• Troubleshoot Oracle Forms, Reports and PL/SQL code in the production environment

Environment: Oracle Database 11g, TOAD, Windows XP/ Linux 5

Confidential

• Design the technical specification and documentation
• Development of PL/SQL code by using Packages, Stored Procedures/Function and database level triggers
• Generation of DDL's and Tables, data reorganization to enhance performance
• Database and Application Tuning
• Development of Unix Shell scripts, Unix shell scripts run the stored procedures/functions from Unix
• Using Data mapping tools to transfer data between source databases to destination database

Environment: Oracle Database 11g, TOAD, Windows XP

Confidential

Oracle Developer

• Monitor and with investigated issues with production applications.
• Monitor ticket queues and resolve technical operation issues related to Forms/Reports and PL/SQL.
• Development of New Orders, Orders monitor, and Search orders complex Forms.
• Created Object Libraries to provide enterprise level Application standards such as Canvases, Date, Number formats, smart Triggers, Visual attributes, Classes etc.
• Troubleshooting of existing Forms/Reports to fix issues and enhance of new functionality to meet business needs.
• Worked with Tech Writers to provide forms/Reports functionality for documentation purposes.
• Development of Master/Detail forms to display accounting details. Developed many Entry level forms.
• Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development
• Fixed tickets in Forms Reports.
• Developed List of values to populate data in certain conditions based on Record Groups
• Development of dynamic Reports using Lexical Parameters.

Environment: Oracle Database 10g, Forms11g/10g/9i, Reports 10g/9i, Windows XP, Sun Solaris

Confidential

Reports Developer

Confidential

• Mediware has a proud legacy in blood banking and continually releases advanced technologies designed by seasoned blood bank specialists that improve efficiency and patient safety. Our Closed Loop products for hospitals and stand-alone blood centers manage blood and biologic materials from donor recruitment, through collection, testing, distribution, storage and transfusion
• Developed Forms 10g /11g to meet the business needs
• Created existing Forms and prepared new Forms
• Development of Master/Detail forms to display accounting details. Developed many Entry level forms.
• Development of PL/SQL code by using Packages, Stored Procedures/Functions, and database level triggers.
• Finding out possible Forms development screens and combinations.
• Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
• Developed various Reports to meet the customer needs.
• Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
• The LifeTrak software includes Donor, Lab and Distribution modules to provide the most comprehensive blood management solution available for blood centers, testing facilities and other organizations collecting, manufacturing or testing blood products.LifeTrak is used by many of the most prestigious blood suppliers including the Blood Center of Wisconsin and Carter Blood Care, where the product was originally developed.
• Display SSN based on parameter mode either 4 digits or full 9 digits ssn
• Generated Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
• Changed Chapter Id condition based on location
• Developed of Master/Detail forms to display accounting details. Developed many Entry level forms.
• Created PL/SQL code by using Packages, Stored Procedures/Functions, and database level triggers.

Environment: Oracle10g, Forms11g/10g/9i, Reports 10g/9i, Windows XP, Sun Solaris Unix server v10

Confidential

Oracle Developer

• Cal State Relocation needs a product which facilitates the administration and communication between the Clients, Agents, and the Brokers. This product can be accessed over the internet. Clients can key in their personal information along with their Mortgage details.
• Migrated code using PVCS into Development, QA and Production environments.
• Developed of Custom screens using Forms10g based on Stored Procedures to implement complex business functionality, Tab canvases.
• Created Views based on Multiple Tables and performed data changes using Instead of Triggers for the underlying tables.
• Developed of Unix Shell scripts to monitor cron tab jobs UNIX shell scripts run the stored procedures/functions from UNIX
• Development of code using Packages, Stored Procedures/Functions to facilitate business needs.
• Performed database tuning using EXPLAIN PLAN, TKPROF and SQL TRACE, enabling session specific trace using DBMS MONITOR.
• Developed Object Libraries to maintain standards in the Application.
• Usage of bulk inserts to insert the data into multiple tables.
• Created Materialized Views to transfer data from OLTP Database to Warehouse databases in order to perform reports by the Reports Team.
• Created Snapshot logs to keep the incremental changes and scheduled materialized views to refresh daily.
• Created more than 25 MViews in Data warehouse environment which are critical to the Reporting system and applied the fast/on demand refresh methods.
• Developed Reports10g/9i to meet the business needs.
• Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
• Using Data mapping tools to transfer data between source databases to destination database.
• Web based Development using iAS10g, Forms 10g/9i/6i, Reports10g/9i/6i.
• Developed List of values to populate data in certain conditions based on Record Groups.
• Developed Menus in such way that users can access the forms through menus.
• Development of Database level triggers to update data into multiple tables.
• Data modeling using Designer10g- Creating table definitions, developing E-R Diagrams, DFS's and Reverse Engineering etc.
• Support external systems by using DBMS SQL and Scheduled jobs by using DBMS SCHEDULER Packages.
• Databases and Application Tuning
• Generation of DDL's out of Erwin/Designer Tools and deploying in the production databases.
• Tables and Indexes Creation, Clusters, data reorganization to enhance performance
• Knowledge in AWR Oracle Report generation from Oracle Instance
• various procurement and receivables applications like Smart Plant Materials and great plains
• Maintenance of Production Test Databases

Environment: Oracle Database 10g, Forms11g/10g/9i, Reports 10g/9i, Windows XP and Sun Solaris v10

Confidential

• Cal State Relo needs a product which facilitates the administration and communication between the Clients. Client information feed into database using MS Access.
• Created MS Access database and tables
• Design and development of many form screens and reports according to business needs
• Maintenance of Access databases and bug fixing
• Performed huge real state arithmetical operations as per the business
• Performed Import Export to SQL Server.

Confidential

Role: Oracle Developer

• The objective of this project is to convert the Legacy system into Oracle Database as backend and Forms 9i and Reports 9i as front end. This is an accounting project which involves lot of accounting activities such as account receivable and account payable. Need to restructure this application into Oracle environment.
• Analysis on current system to convert from Legacy system to Oracle.
• Finding out possible Forms development screens and combinations.
• Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
• Development of PL/SQL code by using Packages, Stored Procedures/Functions, and database level triggers.
• Development of Master/Detail forms to display accounting details. Developed many Entry level forms.
• Development of UNIX shell scripts as needed to perform the Oracle jobs and system monitoring.
• Migrating forms from Forms 5.3 to Forms 6i and Forms 9i.
• Assisted in finding objects interdependencies on packages and tables and development of PL/SQL, Packages, SQL, and Forms10g/Reports10g etc.
• Usage of PL/SQL EXTERNAL TABLES for reading data from the Excel File, which has been generated from the Legacy Systems to transform into Oracle Database Tables.
• Application Tuning to improve the performance by using SQL Trace, Explain Plan and TKPROF, Indexes, and Hints.
• Understanding of Data Flow processes of Legacy and Oracle systems. Development of Data flow diagrams to facilitate the business needs.
• Use JDBC connection to connect the database from Java applications using servlets.
• Wrote many java interfaces and applets for user interaction.
• Development of Test cases and performed Unit testing on the application.
• Meet with the Users and understand the business needs and presented mock ups before the development of Forms.
• Create and design reports using Oracle discoverer.
• Modified the existing reports using Oracle discoverer to meet the business needs.
• Creation/Modification of DDL's from Oracle Designer9i.
• Development of E-R Diagrams using Oracle Designer9i.
• Created Views based on Multiple Tables and performed data changes using Instead of Triggers for the underlying tables.
• Databases and Application Tuning
• Generation of DDL's out of Erwin/Designer Tools and deploying in the production databases.
• Tables and Indexes Creation, Clusters, data reorganization to enhance performance
• Maintenance of Production Test Databases

Environment: Oracle Enterprise Edition - 10g/9i Database, Designer 10g/9i/6i. Windows 2000

Confidential

Role: Oracle Developer

• The purpose of this project is to computerize employee hires and payroll system information process into Inventory management system IMS . The Inventory Management System which is fully computerized process, this project will take care of hiring and firing new employees, Monitoring user's logged timings and salary computation based on the time tracking system information provided.This project maintains the information about all the employees Logging Time, Logout Time, and Monitor Time Tracking Information, it includes the below Project Modules such as- store employees profile, generation of computerized Pay slips, Sick, Vacations days monitoring and offer letters generation and maintenance. Supply of Information about employees, logging information, and creation of new Vendors and invoice payment options etc.
• Developed Forms10g coding standards as per the Application needs.
• Developed PL/SQL Stored Procedures/Functions to meet the business needs.
• Developed PL/SQL Packages to facilitate financial applications.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance using EXPLAIN PLAN, TKPROF and SQL TRACE.
• Usage of DBMS SCHEDULER to run the job processes at nights to make customer postings to the database.
• Development of Forms10g/Reports10g in order to provide user interface.
• Developed SQL Reports for their day to day process and these SQL Reports are invoked from batch scripts as well as Forms 10g.
• Developed Forms based on PL/SQL Stored Procedures to implement complex business functionality.
• Developed Object Libraries to maintain standards in Forms.
• Used PL/SQL bulk insert to insert the data into multiple table.
• Migrating Forms from Forms6i to Form9i and Forms9i to Forms10g using Migration tool.
• Wrote Database PL/SQL Triggers as needed to meet business functionality.
• Created Global temporary tables to handle session specific data.
• Developed utilities to Upload/Download Client Local files to the iAS server and perform Database changes according to the contents of the files using WebUtil package.
• Developed various Reports to meet the customer needs.
• Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
• Using Data mapping tool to transfer data between source database to destination database
• Using Data-driven mapping transfer two data sets and will discover substrings, concatenations, arithmetic, case statements as well as other kinds of transformation logic.
• Developed the web-pages to make them Cross platform and browser independent.
• Generate reports using Oracle discoverer.
• Support to .Net developer from database using MSQL
• Based on COBOL Reports Logic I converted to Oracle Reports.
• Modified the existing reports using Oracle discoverer to meet the business needs.
• Web based Development using iAS10g, Forms10g/9i/6i, Reports10g/9i/6i.
• Development of Database level triggers to update data into multiple tables.
• Developed Menus in such way that users can access the forms through menus.
• Development of single form to run all the Reports as central point.
• Developed List of values to populate data in certain conditions based on Record Groups.
• Databases and Application Tuning
• Maintenance of Production Test Databases