Summary

• Over Eight years of experience in IT industry in development, testing, implementation, Maintenance of Client Server applications using Oracle products.
• Experience in all phases of Software Development Life Cycle SDLC including analysis, design, development, testing, documentation, implementation and maintenance.
• Strong analytical and conceptual skills in database design and development in client/server applications.
• Expertise in working with Oracle 11g/10g/9i, TOAD, SQL Navigator, SQL Loader, Forms 10g/9i/6i and Reports 10g/9i/6i/ for both development and customizations as per client specifications.
• Expert in the development of stored Procedures, Functions, Packages, Triggers and Indexesto implement business logic.
• Extensive technical and functional expertise in Oracle Applications R12/11i.
• Implementation and technical expertise in Oracle E-Business Suite Financial, Manufacturing Supply Chain modules like OM, GL, AP, AR, PO, BOM, INV, WMS,WIP and FA modules.
• Strong PL/SQL programming skills and expertise with performance tuning and bulk binding techniques.
• Good Working Experience in Forms 6i/9i/10g Reports 6i/9i/10g for both development and customization of several Reports as per client specifications.
• Experience in using Composite Data Types in Oracle.
• Knowledge in schema structure design and involved in estimation and optimization of data storage.
• Experience in migration and conversion from Flat Files to Oracle using Oracle SQL Loader.
• Proficient in designing, developing and implementing solutions.
• Involved in review and Gap Analysis of Functional Requirement Documents. Creation of Technical Documents and related Test Case Document.
• Involved in project planning, scheduling, System design, Functional Specification, Design specification, coding and system test plan.
• Experience in developing and deploying reports using Oracle Discoverer 4i and Reports 6i.
• Experienced in providing production support and investigating and resolving system defects and fixing bugs.
• Team player with excellent interpersonal skills and ability to work individually as well as part of a team.
• Working Knowledge on UNIX Shell Scripting.
• Good working experience in XML/BI Publisher and Discoverer Reports.
• Experience on Logical Physical design of Databases, Data Modeling, Conceptual Design and Data Architecture and extensive use of Erwin and MS VISIO as a modeling tool. Understanding of Star Schema and Snowflake Schema.
• Work closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

SKILL

Languages :SQL, PL/SQL, Shell Scripts, XML, HTML, DHTML, C/C , Java, VBA, VB.Net

Databases :Oracle 8i/9i/10g, SQL Server 2000, MS Access, Sybase.

Packages :MS Office Word, Excel VBA , Access, PowerPoint, Visio, Front Page

Operating Systems :Windows NT/9X/2000/XP, UNIX, LINUX, MS-DOS

Oracle Tools :PL/SQL Developer, TOAD, SQL Loader, Oracle Reports 6i/9i/10g, Oracle Forms 6i/9i/10g, Erwin 4.1.

Reporting Tools:Reports10g, 6.i/2.5, Discoverer 9.i/4.i/3.i Discoverer Admin Desktop

Open Source Tools :CVS, PVCS, VSS

Professional Experience:

Confidential

Role : Oracle Developer

Responsibilities:

• Worked on complete SDLC system development life cycle including system analysis, high level design, detailed design, coding and testing
• Involved in creating of various database objects like Packages, Procedures, Functions, Views.
• Developed a custom package for monitoring the system and updating through email alerts.
• Modified existing Tables, Scripts, Views, Packages and procedures as per the user requirements.
• Performed code fixesfor various changes in the procedures and functions.
• Involved in improving the performance of the code.
• Modified existing forms and reports as per requirement.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL Plus and PL/SQL.
• Responsible for offshore / onsite coordination.
• Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.
• Troubleshooting, 24x7 Production support
• Design, development and testing of Reports using Report 10g.
• Implemented the Unit Test for various packages, forms and reports.
• Developed forms for study maintenance and query direct applications which are required in the study research process.
• Involved in Performance tuning of the discoverer reports.
• Performed a complete system test for verification after the changes.
• Extensively worked with Toad, SQL Plus, Form builder 10g, Report builder 10g, Microsoft Applications.
• Prepared the necessary documentation and design specifications of project.

Environment: Oracle 11g, Form Builder 10g, Report Builder 10g, Discoverer 10g, Toad, UNIX, SQL Plus, Packages, Procedures, Functions, Views, Tables, Triggers, Live Link repository, MS Office.

Confidential

Role : Oracle Developer

Responsibilities:

• Responsible for conducting user requirement meetings and gathering information from the end users for reporting system and analyzed all the existing system .
• Responsible for Creating the tables, enforcing the Constraints Indexes.
• Expertise in designing and creation of database objects like tables, views, PLSQL stored procedures, Functions, Packages
• Extensively used Sub-queries and Joins in stored procedures.
• Extensively worked on PL/SQL code in creating various versions for different databases and created new code for the new clients as per the requirement.
• Used SQL Loader to migrate flat filesdata to Oracle Tables.
• Worked with Putty and HP quality center for version control.
• Created UNIX shell scripts to run jobs.
• Created PL/SQL Procedures, Functions and Packages in Pl/sql.
• Extensively used Discoverer administrator and Discoverer desktop versions.
• Responsible for Developing the New Reports using Reports 10g.
• Involved in enhancing pre-existing code by implementing closing tickets raised by cross functional team requirements.
• Worked with business group to create the functional requirements
• The database design responsibility included the conceptual data model design using ER diagrams, logical database design and physical implementation of the database using star schema.
• Made necessary changes to existing Database Objects and added new whenever required.
• Created complex database triggers using PLSQL.
• Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
• Done unit testing and module testing.
• Prepared the necessary documentation and design specifications of project.

Environment: Windows XP, Oracle 10g/9i ,PL/SQL Procedures, Packages, Triggers, Oracle Forms and Reports 10g, Oracle Application server 10g, UNIX, PL/SQL Developer, SQL Plus, Putty, ERWIN, Toad, HP Quality center version control

Confidential

Role : Oracle Developer

Responsibilities:

• Created complex functions, stored procedures and packages by using PL/SQL.
• Extensive testing done after migration to ensure the accuracy timely processing of data.
• Generated script for validating the data before it is inserted into the tables.
• Extensively created sub-queries and joins in stored procedures and functions.
• Used SQL Loader to convert the data from CSV to Oracle tables.
• Created Reports using XML Publisher.
• Used tool ATT One Ticketing System AOTS .
• Worked on trouble tickets to fix the issues reported by the end users.
• Created UNIX shell scripts to run nightly jobs and monthly jobs
• Worked with users and business group to create the functional requirements.
• Created Interface using forms to get the financial details in to the application.
• Used forall and bulk collect functionalities to improve the performance.
• Worked on table partitioning and index creation to improve the performance
• Developed scripts for QA and Business Team to ensure the Quality of the applications.
• Involved in extensive coding in Oracle Forms/Reports 10g.
• Involved in developing the Receiving Notification form which notifies the users on their orders.
• Rectification of errors reported during System Test and User Acceptance Test.
• Documentation of the work assigned.
• Worked with Oracle development team to fulfill their design requirements.

Environment: Windows NT, Oracle 10g/9i ,PL/SQL Stored Procedures, Packages, Triggers, REF Cursors , Oracle Forms and Reports 10g, SQL Developer, AOTS ticketing system , Toad

Confidential

Role : Oracle Developer

Responsibilities:

• Design and develop PL/SQL Packages, Procedures and Functions, Cursors, Partitionetc
• Analyze customer requirements and design technical requirements as needed and/or requested
• Responsible for the modification/enhancements/maintenance in the existing PLSQL packages, procedures and functions to establish standards and the deployment on production environment
• Worked extensively in database development for new releases and implement changes to the Data Model
• Created procedure for data clean up
• Interacting with business users and participating in meetings to gather functional and non-functional requirements with business experts
• Responsible for designing and creating scripts for DB objects such as tables, indexes, views, sequences, object types etc.
• Worked on Oracle forms and reports 10g to develop the application. Reports include the number of orders received, dispatches, etc.
• Heavily optimized the code for high performance using bind variables, bulk collects
• SQL tuning and optimization of queries using explain plan
• Developed PL/SQL code for various levels of front-end validations
• Documented business rules, functional and technical designs, test cases, and user guides
• Involved in Analysis and Design of Logical and Physical Database and related objects
• Developed a report using Reports 10g for listing the customers who visited the center
• Sub-queries and joins were extensively used in stored procedures
• Used PL/SQL and SQL Loader to import /export data from various sources
• Worked with the support team to fix the issues from users

Environment: PL/SQL 10g, Packages, Procedures, Functions, Oracle Forms and Report 10g, SQL Tools, Toad, Shell Scripting, Windows XP Professional, ERWIN, Putty, SQL Loader

Confidential

Role : Oracle Developer

Responsibilities:

• Developing control files, SQL Loader scripts, Oracle import and export scripts for data loading and backup of Oracle data
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers
• Worked on tickets to fix the issues reported by the end users
• Optimized the performance using PL/SQL table types and record types
• Involved in designing the data model logical/physical by creating new objects and by using existing objects of the data mart as per the business requirements
• Developed SQL scripts for Extraction, transformation and Loading of Data and designed source Entities for Oracle
• Generating software upgrade scripts for cross functional teams
• Heavily involved in writing Test Cases and Unit Analysis and Testing UAT to test each and every logical branch of the stored Procedure.
• Responsible for Developing the New Reports using Reports 10g.
• Developed Discoverer workbooks and work sheets for reports.
• Involved in trouble shoots Discoverer tool related issues and limitations in Desktop Version.
• Wrote SQL queries to developed test data for use during test execution
• Worked on complete SDLC Software Development Life Cycle including system analysis, high level design, detailed design, coding and testing.
• Participated in meetings to gather functional and non-functional requirements with experts and end-users
• Generated various reports using Reports 6i like loan reports, savings report, fixed deposits etc
• Analyzed the performance of the SQL queries and created the scripts for indexes

Environment: Oracle 9i/10g, SQL, Reports 10g, Discoverer 9.i,WINDOWS XP, SQL,PL/SQL, SQL Loader, Toad, PL/SQL Developer, Oracle d2k forms and reports

Confidential

Role : Oracle Developer

Responsibilities:

• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Orecle8i as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL Plus and PL/SQL.
• Created various Database triggers using PL/SQL.
• Worked with various functional experts to implement their functional knowledge into working Procedures
• Worked on optimizing existing procedures and functions using PL/SQL.
• Created various Database triggers using PL/SQL.
• Developed Stored Procedures, Functions, Triggers and Packages using PL/SQL for incorporating the validations in Oracle database.
• Involved in the preparation of user Requirements and functional specification of the systems
• Developed and deployed ad-hoc reports Using Oracle Discoverer4.1.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors, Partitionsand Triggers.
• Designed and developed user interfaces for customers using Developer 6i Forms

Environment: Oracle8.0/8i, Forms 6i, Reports 6I, Designer 2000, Discoverer, Visual Basic 6.0, SQL Loader, Shell Scripting, Oracle Reports