SUMMARY

• Over 5+ years of experience in design, development, implementing and unit testing of medium to complex applications using Oracle Developer. Possesses outstanding communication skills and is a proven team player.
• Good programming knowledge in Oracle 10g/ 9i/8i/8/7.x, Developer 2000 (Oracle Forms, Oracle Reports), PL/SQL, SQL*Plus, SQL*Loader, Informatica.
• Expert in Export, Import and SQL*Loader Utilities.
• Expert in writing complex PL/SQL queries, procedural logic, and data cleansing scripts.
• Have extensive experience in writing Stored Procedures, Functions, Triggers, application tuning, and database conversion.
• Worked on data mapping and technical design documents.
• Fair understanding of Oracle 11g and good experience in ETL process.
• Extensively worked on Migration data from Sybase/DB2 to Oracle database.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects
• Experience of database architecting, process flow diagram, Data flow diagram, ER diagrams.
• Experience in all phases of the Application Development cycle - Design, Coding, Testing, Maintenance and Documentation, Data modeling, configuration management.
• Have good work experience in UNIX, Sun Solaris, and Windows 95/98/NT/2000.
• Exposure in Essbase cube development, Analytical Integration Services (AIS), Financial Reports and Interactive Reports.
• Dedicated to successful project completion with the ability to work well as a Team Member.

TECHNICAL SKILLS

Operating Systems: UNIX (Solaris, HP, Linux), Windows (XP/NT/2000/98/95).

Programming Languages: C, C++, JAVA, FORTRAN, PASCAL, SQL, PLSQL

Database Tools: Toad, PL/SQL Developer, SQL plus, SQLDeveloper, Embarcadero,SQLNavigator,OracleDeveloper/2000(Forms9i/6i/5.0/4.5,eports9i/6i/6.0/2.5), Designer/2000,Discoverer/2000, Visual Basic5.0/6.0

Database: MS SQL Server, My SQL, MS Access, Teradata, Oracle

Scripting Languages: HTML, SOAP-XML, BPEL, DHTML, VB Script, JavaScript,XMLDBXPATH/XQUERY Application/Web Servers

Visual Studio, Web sphere v6, WebLogic8.1 Application Server, Sun System: Application Server 8.1, Tomcat 4.x/5.x

Business Intelligence Tools: Hyperion,OBIEE

Frame Works: COM, ADO.AJAX, Hibernate, Struts, Tiles, Spring, JSF, Log4J.

Database: MS SQL Server, My SQL, MS Access, Teradata, db2, Oracle.

Reports: Hps Reports,, Oracle Reports, Crystal Reports

Testing Tools: QTP,QC,TEST COMPLETE

Source Control: Visual Source Safe, Clear Case, Clear Quest, Star Team, PVCS, Tortoise CVS

PROFESSIONAL EXPERIENCE

Confidential, AZ

Oracle Developer

Responsibilities:

• Determined user report requirements and analyzed data sources.
• Wrote PL/SQL stored procedures and SQL queries to extract data from Oracle Financials, Purchasing databases and company's Job Order Tracking System to provide various information needed by business planning group to determine timely confirmation of purchase orders
• Developed Menu Model Diagrams and Input/output structures for the data entry screens
• Primary person for the logical documentation.
• Physical Design:
• Involved in developing the Process Model Diagrams to represent the Income Tax business processes.
• Involved in the development of the Function Hierarchical Diagrams, Entity Relationship Diagrams for batch as well as core modules.
• Developed Server Model diagrams for most of the data-entry forms.
• Developed program specifications and test plans based on the logical program specifications.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Orecle8i as back-end.
• Developed PL/SQL code for various levels of front-end validations in Designer 2000.
• Generated first-cut of the forms/reports from Designer 2000 and then refined them using Oracle Forms 4.5 and Oracle Reports 3.0.
• Intensively involved providing end-user s to tax officers and data-entry operators.

Environment: Oracle 10g, PL/SQL, SQL*Plus, HP-UX, Windows, QC, Toad8.6, Pl/Sql Developer, Business Objects

Confidential, Manhattan NY

Oracle Developer

Responsibilities:

• Worked on complete Project Life Cycle that includes requirement gathering, development, testing and production support.
• Worked in full development life cycle for the Design of data base
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Proficiency in PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTIL FILE, DBMS OUTPUT, DBMS SHEDULER.
• Used extensively the ETL process for the data load.
• Involved in analyzing and adding features like Create Directory, Data pump, and Hierarchical queries, Indexes (Bitmap and B-tree).
• Involved in Technical feasibility discussions, peer reviews and in unit testing
• Used Bulk Collect feature to improve performance.
• Written complex PL/SQL queries, procedural logic, and data cleansing scripts.
• Worked on Hyperion Essbase Cubes and Hyperion reports.
• Created the Partitions and Sub-Partitions on the Oracle tables.
• Involved in extracting large volumes of data from different data sources, performing transformations and loading that data and provided interface between Oracle and Hyperion tools.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Developed Drill-to-Detail (DTD) functionality for users that acted as an interface between the Essbase cubes and Oracle tables. Through this functionality users were able to view detailed information from summarized data in the cube.
• Automated the cube build process through maxl and running those maxl from UNIX shell scripting
• Created Shell Scripts to build dimension and load data from Hyperion cube.
• Troubleshooting and resolving issues in various aspects of the post production support

Environment: Oracle 10g PL/SQL, SQL Developer, Sql Navigator, Pl/Sql Developer, Toad, Shell Scripting, UNIX, Windows, Hyperion System 9 tools (Master Data Management, Essbase, IR reporting), CVS, Informatica.

Confidential, San Francisco, California

Oracle Developer

Responsibilities:

• Involved in the Screen Design Development and PL/SQL coding of the modules using oracle forms 6i.
• Worked with users to gather requirements and turning into technical
• Fine tuned PL/SQL codes and SQL statements. Support for daily production report run.
• Wrote PL/SQL scripts needed for new report staging tables. Deployed the reports to company's intranet using ASP web pages
• Test cases prepared for testing procedures
• Developed logical specifications in the form of Effect Correspondence Diagrams and mapping documents.
• Created stored procedures, packages and functions using SQL, PL/SQL for the reports. Used Bulk Collect feature to improve performance.
• Worked on Hyperion Essbase Cubes and Hyperion reports
• Used bitmap indexes, materialized views and partition tables to optimize the queries
• Used extensively Toad for writing procedures and tuning
• Developed the complete application of the above modules based on the Standard Template.
• The forms are created based on Tables, Stored Procedures and From Clause Queries.
• Written database Packages and Test plans.
• Involved in unit testing and Integration testing of the Modules.

Environment: Oracle 10g PL/SQL, SQL Developer, Toad, Pl/Sql Developer, Sql Navigator, Shell Scripting, UNIX, ClearCase, ClearQuest Windows, ANT, Hyperion System 9 tools (Master Data Management, Essbase, IR reporting), PCVS

Confidential

Oracle Developer

Responsibilities:

• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Involved in the data migration process to convert the sales and customer related data from oracle application database to oracle 9i database.
• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.
• Recommending system and database configuration.
• Used bitmap indexes, materialized views and partition tables to optimize the queries.
• Used Unix Shell Scripts and developed PLSQL procedures to extract and load data for month-end batch processing.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, I used these tools with EXPLAIN PLAN.
• Analyzing requirement of client, generating and designing reports.
• Used extensively Toad to create procedures and for explain-plan.
• Used PVC for version control.

Environment: Oracle 9i, SQL, PL/SQL, Discoverer, SQL*Plus Reports, SQL*Loader, Windows NT 4.0/XP, UNIX, TKPROF, SQL TRACE, EXPLAIN PLAN, TOAD, PVCS

Confidential

Oracle Developer

Responsibilities:

• Worked on complete Project Life Cycle that includes requirement gathering, development, testing and production support.
• Worked in full development life cycle for the Design of data base
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Proficiency in PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTIL FILE, DBMS OUTPUT, DBMS SHEDULER.
• Used extensively the ETL process for the data load.
• Involved in analyzing and adding features like Create Directory, Data pump, and Hierarchical queries, Indexes (Bitmap and B-tree).
• Involved in Technical feasibility discussions, peer reviews and in unit testing
• Used Bulk Collect feature to improve performance.
• Worked on Hyperion Essbase Cubes and Hyperion reports.
• Created the Partitions and Sub-Partitions on the Oracle tables.
• Involved in extracting large volumes of data from different data sources, performing transformations and loading that data and provided interface between Oracle and Hyperion tools.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Developed Drill-to-Detail (DTD) functionality for users that acted as an interface between the Essbase cubes and Oracle tables. Through this functionality users were able to view detailed information from summarized data in the cube.
• Automated the cubebuild process through maxl and running those maxl from UNIX shell scripting
• Created Shell Scripts to build dimension and load data from Hyperion cube.
• Used XML/DB, XPATH/XQUERY for the data transfers between the two server environments.
• Troubleshooting and resolving issues in various aspects of the post production support

Environment: Oracle 10g PL/SQL, SQL Developer, Sql Navigator, Pl/Sql Developer, Toad, Shell Scripting, UNIX, Windows, Hyperion System 9 tools (Master Data Management, Essbase, IR reporting), CVS, Informatica, core java, Oracle Reports, XML/DB, XPATH/XQUERY