Career Objective:

Seeking a position as an application developer using Oracle 7.x/8.x/8i,/9i/10g, PL/SQL, SQL Plus, SQL Reports, SQL Loader, Designer2000/6i, Oracle Developer1.x/2.1/6.0/6i Forms 4.5/5.0/6.0/6i/9i, Reports 2.5/3.0/6.0/6i9i

Summary:

• Over 13 YEARS of IT experience along with active involvement in all the phases of the software development life cycle such as database design, data analysis, development, performance tuning, integration, implementation and support for databases in Client/Server n-tier enterprise and Internet/Intranet environments.
• Expert in SQL queries, PL/SQL Procedures, Packages, Functions, Stored Procedures ,Cursors, Triggers, Interfaces and Data Conversion using PL/SQL, SQL plus, TOAD, SQL Navigator and SQL Loader.
• Experienced in working on Distributed Oracle database 7/8i/9i/10g/11g.
• Good working knowledge on Developer 2000
• Experience job scheduler in unix.
• Experience in JAVA, J2EE and JSP
• Well versed in creating Database objects including tables, views, indexes, packages etc in Oracle
• Experience in UNIX Shell Scripting for executing SQL LOADER, PL/SQL code and other Unix commands.
• Involved in Unit Testing, Integration testing GUI testing, and providing Production Support.
• Strong knowledge in Data Warehousing concept using PL/SQL, Manual ETL, UNIX Shell Scripting, Crystal Reports.
• Excellent communication, quantitative, analytical skills and ability to work either individually or as a member of a team
• Leadership Skills
• Managed a team of 10 people.
• Knowledge transition to the team members and training to the End users.
• Proficient in analyzing and translating business requirements to technical requirements and architecture
• Strong database skills and development knowledge
• Experience in leading and managing teams. Was a member of the board which determines the scope of a project, priority of a defect, and finalizes hot fix releases
• Extensive experience in handling CRs, onsite offshore interaction and co-ordination
• Worked as a Team Lead for offshore team members and have experience of handling multiple projects at a time
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Technical Skills:

Operating Systems : Sun Solaris, Windows NT/2000/XP

Languages : Progress 9.X

Database : SQL, Oracle PL/SQL, MFG pro ERP

Tools and Utilities : Developer 2000 Form 6i and Report 6i , Crystal Report and VB

Application : Oracle Application AP, AR, Inv, OM

Professional Experience:

Confidential

Sr. Oracle Developer and Analyst

Responsibility

• Involved into creating new procedures, functions, triggers, and packages based on the new process.
• Provided Test Data to QA team to validate front end application. Also performed unit testing.
• Involved into creating new procedures, functions, triggers, and packages based on the new process.
• Implemented materialized views.
• Involved in performance tuning SQL PRODUCTION queries.
• Involved in Datamodel design using Erwin.
• Creation of users, roles and indexes etc.
• Developed Package to copy whole schema from one environment to new environment.
• Involved in lots of data structures.
• Uploading data from one env to other env using SQL LOADER
• Trapped the errors using Exceptions handlers and pragma for the projects.
• Involved in code review process with development and QA team for analysis and logic explanation
• Process
• Provide support to Java team for all database development issues
• Analysis of Production data/bugs and provide fixes.
• Maintain Development and QA database environment.
• Done lots of debugging process for the projects.
• Implemented UNIX Shell scripts to run the process regularly
• Develop SQL scripts for Releases and deploy the same in various environments

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting using Sun Solaris, SQL PLUS

Confidential

Oracle Developer and Analyst

Responsibility:

• Implementation of new application creating the various existing processes for new applications
• Involved into creating new procedures, functions, triggers, and packages based on the new process.
• Created the integration process with the 3rd Party
• We had give support for internal application which is developed in Oracle Reports Report 6i
• Wrote PL/SQL functions, cursors, triggers and embedded them in PL/SQL packages.
• Designed and developed the Data Model for Integration process.
• Designing new DW structure along with data mapping with new application.
• Designing Data conversion/Interface with the use of SQL Loader, and Open Interface, and convert data.
• Scheduled the jobs using BMC software
• Designed and developed the reports using SQL Server Reporting Services
• Provided Test Data to QA team to validate front end application. Also performed unit testing.
• Performance tuning and optimization on SQL queries using Explain Plan, Indexing and Hints.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting, Toad, SQL PLUS, DataStage ,D2K

Confidential

Oracle Developer and Analyst

Responsibility:

• Created Indexes, Materialized Views needed for the project implementation.
• Created global temporary tables for the ARS Reports needed.
• Created Ad-hoc and On-Demand Reports for the end users.
• Regularized the reports for daily/weekly/monthly basis.
• Used lots and lots of Analytical function needed for the reports to built.
• Customized existing application in Forms 6i
• Implemented critical Surveillance Reports using Oracle Reports Builder Report 6i
• Involved on weekly status meetings and presented the projects to the Leads.

Environment: Oracle 10g, PL/SQL Developer, Report 6i

Confidential

Oracle Developer and Analyst

Responsibility

• Prepared Understanding and technical document
• Created Indexes, Materialized Views needed for the project implementation.
• Wrote SQL, Procedure as per the business logic
• Design Report in Crystal report and per user request
• Prepared unit test case and executed in Dev and QA environment.
• Involved on weekly status meetings and presented the projects to the Leads.

Environment: Oracle 10g, PL/SQL Developer, Toad and SQL PLUS

Confidential

Technical Consultant

Responsibility:

• I worked on Finance and Manufacturing Module as developed
• Customized forms and reports as per business need
• Involved in Working with SQL Plus 8i, PL/SQL 8.X programs and developed the new complex Forms and modified the existing forms with Forms 6i and developed new reports with Oracle Reports6i.
• Support the overall reporting infrastructure, with specific focus on the Business environment.
• Designed, developed, and tested the reports, which provides user access to scheduled reports, adhoc reports, report preferences and report parameters.
• Development of large scale, complex applications involving on-line and batch environments
• wrote numerous PL/SQL Procedures, Functions and Triggers in different places while using the Oracle Forms6i and Reports6i.
• Wrote numerous Backend Triggers for Complex Business rules for user level.
• Written numerous backend Stored Procedures and Functions, these programs will execute at Server level through Batch mode.
• Used Oracle Built-in Procedures and Functions while developing the Oracle Forms and Reports.
• Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.

Environment: Oracle 10g, PL/SQL Developer, Toad and SQL PLUS, Forms 6i and Reports 6i, Oracle apps 11i

Confidential

Technical Consultant

Responsibility:

• Involved in requirement phase to collect requirement from the user
• Developed customization program in progress database
• Wrote progress code in Finance , Purchase Order, Sales Order and Work order module in MFG/PRO
• Developed reports in PO Report, Job reports , WO reports and many reports in Progress Database
• Developed complex code and generate Purchase order report in pre printed stationary
• Involved in Working with SQL Plus, PL/SQL programs and developed the new Forms and Reports using Forms5.0 and Reports3.0.
• used PL/SQL procedures and Triggers in different places while using the Oracle Forms5.0 and Reports3.0.
• Involved in designing of complex reports using Oracle Reports3.0 and SQL Reports to generate different types of reports

Environment: MFG/PRO, Progress Database, Oracle, SQL PLUS, forms 6i and Report 6i

Confidential

Oracle Developer

Responsibility:

• Involved in Database design
• Developed functions and procedures using Pro C.
• Developed complex calculations Programs in Pro C.
• Involved in Working with SQL Plus, PL/SQL programs
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files.

Environment: Oracle, SQL PLUS, Pro C and VB

Confidential

Technical Consultant

Responsibility:

• Involved in Working with SQL Plus, PL/SQL programs and developed the new Forms and Reports using Forms6.0 and Reports6.0.
• Used PL/SQL procedures and Triggers in different places while using the Oracle Forms6.0 and Reports6.0.
• Involved in designing of complex reports using Oracle Reports6.0 and SQL Reports to generate different types of reports like Material details, Stock Details, etc.

Environment: Database, Oracle, SQL PLUS, forms 6i and Report 6i