SUMMARY

• 7+ years of experience in Software design, development and implementation of Oracle, SQL, PL/SQL applications.
• Excellent knowledge in Oracle 8x/9x/10g/11g SQL and PL/SQL.
• Experience in Relational Data Base Management Systems (RDBMS).
• Extensively worked in Client - Server application development using Oracle 11g/10g/9i/8i Forms 9i/6i, Reports 10g/6i/6.0, SQL, PL/SQL.
• Experience in writing SQL queries, functions, packages, cursors and stored procedures, database triggers using PL/SQL in Oracle.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Proficient in designing, modeling, creating and maintaining oracle database.
• Involved in query performance of slow SQL statements by implementing Index, using FORALL and BULK COLLECT.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Experienced in working with utilities like SQL * loader, External tables, import, export to extract large volume of data.
• Expert in Oracle database and GUI design and development of high performance technical solutions to meet the challenging business demands to the clients.
• Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like to generate back-end and front-end reports.
• Experience in Application Development using Forms, Reports and Discoverer.
• Strong experience in Oracle Workflows.
• Experience in application development using various advanced features of Oracle like Collections, Table Functions, Dynamic SQL, Object types and Records.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Experienced in data analysis, data modeling, development, testing and documentation of projects
• Has good experience with Object-Oriented Design, application design and development using SQL (SQL*Reports, complex queries, views, group queries, tree queries, nested query, sub queries), PL/SQL (Functions, Procedures, Triggers, Packages and Oracle inbuilt packages.
• Excellent working and conceptual knowledge of PL/SQL, HTML and XML Technologies.
• Knowledge of Database design, E-R diagrams.
• Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance
• Experience in UNIX shell scripting.
• Worked on ETL- extraction, transformation and load.
• Possess good communication skills.

TECHNICAL SKILLS

DATABASES: Oracle 11g/ 10g/ 9i/ 8i, MS SQL Server 2000, and MS ACCESS

ORACLE TOOLS: SQL * Plus, SQL developer, APEX, PL/SQL Developer, TOAD, SQL Tool, SQL * Loader, Developer 2000 (REPORTS 6i/9i /10g, FORMS 6i/9i/10g), SQL Navigator, PowerBuilder.

ETL TOOLS: SSIS - SQL Server Integration servicesOPERATING SYSTEM Windows 2000/03/ NT/XP, Unix

LANGUAGES: C, SQL, PL/SQL, JAVA, VB.NET, C++, Perl Scripting, UNIX Shell Scripting.

DATA MODELLING TOOLS: Microsoft Visio 2003, Designer 2000

DATA ANNALYSIS: Requirement Analysis, Business Analysis, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

DATABASES: Oracle 11g/ 10g/ 9i/ 8i, MS SQL Server 2000, and MS ACCESS

ORACLE TOOLS: SQL * Plus, SQL developer, APEX, PL/SQL Developer, TOAD, SQL Tool, SQL * Loader, Developer 2000 (REPORTS 6i/9i /10g, FORMS 6i/9i/10g), SQL Navigator, PowerBuilder.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr Oracle Apps Technical Consultant

Responsibilities:

• Involved in the maintenance and enhancement of the application.
• Maintained good rapport with Business Analyst & Business Users to identify information needs as per business requirements.
• Document the business process flows.
• Schedule meetings and present technical issues to business users and developers.
• Performed discussions with data modeler to update the data model for new requirements.
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Designed/developed tables, views, SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Used PL/SQL tables, array structures as a part of oracle collections.
• Involved in partitioning of very large tables. Used list and range partitioning.
• Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility.
• Create & maintained box jobs using Shell Scripts.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Communicate issues and progress to project manager.
• Involved in Production Support and troubleshooting data quality and integrity issues.
• Solving day-to-day problems, giving support to the users.
• Ensuring quality and compliance - we will review deliverables, validate testing results and coordinate and conduct User Acceptance Testing to ensure compliance with requirements and applicable laws, regulations and guidance.

Environment: Oracle 11g, Oracle Application Servers, PL/SQL, OLTP, Windows NT, SQL*LOADER, and TOAD.

Confidential, Boston, MA

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Extensively used SQL PLUS, SQL Developer and PLSQL developer for programming purposes.
• Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Involved in writing PL/SQL scripts.
• Extensively involved in creating Indexes to improve query performance.
• Created views, procedures, and functions, packages in the Oracle Database using PL-SQL, SQL/PLUS, and SQL Developer.
• Designed and developed Database Tables, Triggers, Cursors, Ref Cursors created Stored Procedures, Functions and Packages for implementing business logic and to meet business requirements.
• Extensively involved in Query Performance Tuning by creating the Indexes and rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Developed related PowerBuilder Objects like (windows, data windows, User Objects) and Database Objects like (Stored Procedures, Packages, functions, Tables etc) using PL/SQL programming.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Conducted Code Reviews in PL/SQL Procedures, Functions and Triggers.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Coordinated with DBA in improving Database Performance.
• Experience with Data dictionary and Normalization techniques.
• Involved in importing and exporting data into Excel.
• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Involved in Production Support and troubleshooting data quality and integrity issues.
• Created UNIX Shell scripts for automating the execution process.

Environment: Oracle 10G/11g, PowerBuilder, SQL * LOADER, OLAP, Toad, MS-Windows, Clear case, UNIX Shell Scripting.

Confidential, Hartford, CT

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Involved in development of process using SQL* LOADER, PL/SQL Package, TOAD
• Involved in Oracle development (Data Base) by creating Oracle PL/SQL Functions, Store Procedures, Triggers, Packages, Records and Collections.
• Involved in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning.
• Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
• Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and V arrays), and performed Error Handling.
• Designed CUSTOM forms and reports in order to meet the Business requirements.
• Participated in Performance Tuning using Explain Plan, Hints& TKProf.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader
• Fixed Bugs during development/testing and Production phases.
• Fixed errors ad hoc reports using Discoverer 10g.
• Performed SQL performance tuning.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values using Discoverer 10g.
• Involved in Technical Documentation, Unit test, Integration Test and writing the Test plan.
• Used Forms Compare tool to compare the difference between forms.
• Worked on Perl scripting.
• Involved in mapping data from DB2 to Oracle server.
• Worked on Java to develop front end applications.

Environment: Oracle 9i, Oracle Reports 6i, APEX, SQL developer, OLAP, SQL * Loader, Java.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Designed and developed the interface program to Import item master using SQL*Loader, PL/SQL package and Import through Concurrent program.
• Involved in customization of Oracle Forms, Oracle Reports
• Created views, procedures, and functions, packages in the Oracle Database using PL-SQL, SQL/PLUS, and TOAD.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Made Forms customization on various existing forms.
• Developed many complex reports using Oracle Reports 6
• Maintained and developed user requested features to a web based Warehouse Catering System. The system allowed users to schedule, edit, and manage the corporation’s entire upcoming warehouse catering events.
• Designed and developed front-end applications using Oracle Forms 6i.
• Extensively used SQL Developer for database access and PL/SQL Development and SQL tuning.
• Developed Ad-hoc reports as per the requirement in Oracle Reports.
• Process payments automatically and manually in case of exceptions.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: SQL * Loader, Oracle Reports 6i, SQL, PL/SQL, OLTP, Toad.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in designing the logical data structures, wrote triggers, functions, and stored procedures using ref-cursors in PL/SQL and optimized SQL queries.
• Written code based on specification and did unit and integration testing of the code.
• Used Explain Plan and created indexes to tune queries.
• Wrote shell scripts to execute the anonymous PL/SQL code and ftp file.
• Actively participated with DBA to utilize performance management issues.
• Did presentation in the quality review meetings for reviewing technical design and code.
• Studied the various processes written using PL/SQL, shell scripts and mainframe programs (HBI and MVS).
• Performed internal documentation as an undocumented code leaves many issues open for future and results in more maintenance cost.
• Involved with UNIX Shell Scripting.

Environment: PL/SQL loader, SQL *Loader, Developer 2000 (Reports 6i), OLTP.