SUMMARY

• 8+ years of IT experience in Design, Development and Maintenance of various software applications in client - server environment using Oracle Technologies & Data Warehousing on Windows Platforms.
• Experience in Data Extraction, Transformation and Loading (ETL) processes.
• Adept in Oracle, Oracle Tools and Utilities; SQL and PL/SQL.
• Used several tools like SQL*Plus, SQL*Loader, SQL Developer and Toad.
• Created database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database Links as well as Custom Packages tailored to business requirements.
• Experience in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.
• Experience in Data Migration processing including data loading from flat files to the database tables using SQL*Loader.
• Possess strong Documentation skill and knowledge sharing among team, conducted data modeling.
• Extensive experience in working for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify Logical entities.
• Worked on Oracle forms different version like 4.5/6i/ 10g.
• Experienced in Performance Tuning and Query Optimization using Explain Plan and re-designing of poorly designed process flow of data.
• Involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.
• Well versed in MS Office Suite such as Word, Excel, Access and PowerPoint.
• Involved in programming, debugging, and unit and system integration testing of modules.
• Very good Analytical and Problem Solving skills with strong communication and interpersonal skills.
• Highly-adaptable, flexible, team-player, pro-active and eager to learn and perform new tasks.

TECHNICAL SKILLS

Databases: Oracle Database 8i, 9i, 10g

Front End: Oracle Forms 4.5/6i, 9i, 10g, Oracle Reports 9i, 10g

Tools: SQL*Plus, Toad, SQL* Loader, SQL Developer, Oracle Developer, MS Visio, Text Pad

Version Control: PVCS, VSS

Web Technologies: HTML, XML

Operating Systems: UNIX, Windows 95/2000/NT/XP

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked in requirements and developed models according to the customer’s specifications and drafting detailed documentation for the same.
• Worked in PL/SQL to develop packages, stored procedures, functions and database triggers and views.
• Worked in Tuning SQL queries using Explain Plan improve performance of the queries.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Created scripts to load the data into staging tables from other database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in production support by efficiently debugging the production issues.
• Understanding the new features of oracle Database 10g and implemented the new suggestions for Improve Database performance.
• Worked on People soft SQR Code to create the Clients Reports.
• Took part into the Database Unit Testing for Report generation for Client.
• Worked on Unit Test case Preparation /Unit Test Results.
• Provided technical support to another team member to achieve tasks in time frame / another department teams as well.

Environment: Oracle Database 10g, Windows 2000, Windows NT, Unix,, TOAD, Oracle SQL Developer, pl/SQL Developer, Putty, Microsoft Outlook, Microsoft office 200, Lotus Notes 8.5, File zilla, Humming Bird, People soft SQR Code

Confidential, Detroit, MI

Sr. Oracle Developer

Responsibilities:

• Designed Time sheet/ payroll / store related table as per Client requirements.
• Developed Preliminary/Detailed level of Design Documents for requirements.
• Developed Time sheet/payroll related table for store mapping modules.
• Developed database Objects for payroll /timesheet /store Details Reporting like Procedure, Views, Cursors.
• Developed Oracle forms for Oracle Reporting purpose with dynamic settings
• Developed Timesheet Entering / Payroll Report generating forms.
• Developed Oracle Reports for Payroll/timesheet/store Details Reporting.
• Worked on SQL Loader to upload store related data received from Different stores.
• Extensively worked in Oracle Forms 6i /Reports 6i
• Worked in PL/SQL to develop packages, stored procedures, functions and database triggers and views.
• Created Database Links for Different Database.
• Worked on Transforming the data from once Schema to another schema tables to provide the access for reporting purpose
• Highly involved in preparing Unit Testing by preparing Unit Test case and execution.
• Created Unit test plan and Unit Test Results Documents.
• Worked on Production environment for execution of changes like scripts, new changed form, database Objects and UAT.

Environment: Oracle Database 10g, Oracle Forms 6i, Oracle Reports 6i, Windows 2000, Windows NT, UNIX, TOAD, Oracle SQL Developer, pl/SQL Developer, Putty, Microsoft Outlook, Microsoft office 2000.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Managing various databases which include performance tuning, designing and developing new database objects like stored procedures, triggers, indexes, etc.
• Gathered requirements, project scope management, worked on project estimates, resourcing, status updates, project plan updates, and team coordination.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Prepared Function Requirement Documents and documented the process events and best practices(FDD and TDD)
• Involved in optimization of SQL statements using Explain plan
• Wrote cursors and control structures using PL/SQL
• Worked on Oracle forms 4.5 to 6.0 and 6.0 to 10g migration.
• Defined standards set of Packages for Oracle forms events, Libraries and Properties.
• Developed and modified master data forms.
• Developed and modified the transaction data, query forms.
• Developed and modified the Menu forms,
• Developed the Tabular and Master details forms, Tab forms
• Modified the existing PL/SQL packages, functions, procedures.
• Provide the production supports.
• Developed the various type of reports.
• Developed the various type of GUI reports.
• Wrote Scripts for Creating the Database Objects to configure initial basic setup.
• Worked on Bulk Collection and Pl/sql table for getting optimal performance.
• Created Views, Dynamic SQLs, V-arrays.

Environment: Oracle Database 9i, 10g, Oracle Forms 4.5/ 6i/10g, Oracle Reports 4.5/6i/10g, Windows 2000, Windows NT, Unix, TOAD, Oracle SQL Developer, PL/SQL Developer, Putty, Microsoft Outlook, Microsoft office 98, Oracle 10g Application Server.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Create Triggers, Functions, Packages to provide backend security and data consistency.
• Create tables, indexes, sequences, other constraints as per the Client Standards into the correct Schema and Tablespaces
• Worked with SQL*Loader, Expdp/Impdp calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Created scripts (PL/SQL Developer) and process to convert 1 application from SQL Server Database to Oracle Database.
• Copying data from Production to Lower environments replacing all customer sensitive information with dummy data.
• Coordination with the access control team to grant the correct roles/grants to the user belonging to different groups.
• Coordination with the Release Management team to ensure the version control of the scripts execution in various environments from Development to Production.
• Generated Reports after extensive Data Analysis for the Top Management to enable decision making.
• This involved understanding of the client requirements for the Top Management and converting them into database requirement with the help of my knowledge of the database design.
• These reports/statistics/counts/data generated based on my Analysis was used to decide upon a lot of critical issues and requirements.
• Assisted the application development team with their Database related queries in order to optimize the performance of their queries and other DB related tasks

Environment: Oracle Database 9i, 10g,, Windows 2000, Windows NT, UNIX, TOAD, Oracle SQL Developer, PL/SQL Developer, SQL PLUS, SQLLDR, Putty, Microsoft Outlook, Microsoft office 98

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.
• Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
• Developed the data entry forms (Tabular, mater details)
• Developed the query forms (based on database or non-database block).
• Developed the data entry complex forms (master details with tabs )
• Developed the master reports.
• Developed the complex reports for various types of registers.
• Developed the group above reports.,
• Developed the group left reports.
• Sound Knowledge in understanding already existed packages, and worked with them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
• Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

Environment: Oracle Database 10g, Oracle Forms 10g, Oracle Reports 10g,Windows 2000, Windows NT, Unix TOAD, Oracle SQL Developer, pl/SQL Developer, Putty, SQL PLUS, Microsoft Outlook, Microsoft office 98

Confidential

Oracle PL/SQL and D2k(Forms) Developer

Responsibilities:

• Create the database sample tables.
• Create the database tables with adding the constraints like primary key, foreign keys, check constraints, not null columns.
• Create complete database design across application.
• Create ERD, DFD.
• Create database index in tables like bit map.
• Create the synonyms of tables in different schema.
• Create the data base Views.
• Create the materialize views.
• Create the Pl/sql tables
• Create the co-related and nested queries (PL/SQL queries).
• Create the Master template form for using to create the forms across applications.
• Create the pl/sql libraries to use in template forms.
• Create the Pl/Sql Packages to use in template forms.
• Create Menus and add forms objects.
• Create the system master forms to create the users, responsibilities, user rights, assigned the privileges, add the menus, add the reports and forms.
• Create Pl/sql packages, procedures, functions.
• Create various type of triggers form level, block level, item level triggers.
• Create the database triggers

Environment: Oracle Database 9i, 10g,, Oracle Forms 6i,9i, Oracle Reports 6i,9i,: Windows 2000, Windows NT, TOAD, Oracle SQL Developer, pl/SQL Developer, Putty, SQL PLUS, Microsoft Outlook, Microsoft office 98.