SUMMARY

• Over 7 years of experience as a Oracle developer. Involved in complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Client/Server and web based environments.
• 4 years of production support experience.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language.
• Experience in using Oracle Forms 10g/6i/5.0&4.5, Reports 10g/6i&2.5,Oracle designer 6i/4.7,Oracle discoverer 10g for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader, Data Loader, SQL navigator, JDeveloper.
• Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Performed pl/sql development on financial systems.
• Good insight into the data model of Oracle Financials modules like Oracle Receivables, Oracle Payables, Oracle Loans, Oracle Assets, Cash Management and Oracle General Ledger.
• Knowledge of Oracle data dictionary views to understand schema objects, schema object relations, Schema Privileges, Roles and Restrictions.
• Use Collections like variable arrays, nested tables, Associative Arrays, Records and objects.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Expertise in optimizing, maintaining and troubleshooting database applications.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Exceptional ability to quickly master new concepts and applications (Researching identifying and resolving problems including partnering with vendor on resolution).
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Knowledge of Oracle streams architecture, built in advanced queuing packages to administrate Oracle ,streams and web based PLSQL applications.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.
• Proficient in writing UNIX KORN Shell Scripts.
• Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and Denormalization of Tables.
• Very good experience in production support
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.

SKILL SET

RDBMS: Oracle 11g/10g/9i/8i.

Tools: SQL *Loader, SQL* plus, TOAD, SQL Navigator, SQL Developer, Autosys, UTL FILE, SharePoint, WebEx, VI Editor, SSH, Erwin, Forms10g and Reports 10g.

Programming Languages: SQL, PL/SQL, C

Operating systems: UNIX, SUN Solaris, HP UX, AIX Windows NT/2000/XP, MS DOS

PROFESSIONAL SUMMARY

Confidential

Oracle Developer

Responsibilities:

• Studied user requirements and functional specifications. Converted User Requirements into formal Functional specification and Interfacing with client.
• Participated in the design and development of the project.
• Used Oracle designer to produce the ER diagrams, Dataflow,function Hierarchy.
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Used advanced SQL features like Inline views, advanced Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and other analytical functions in 10g .
• Wrote the extract program to generate the XML file with consumer details by order, which the dealers target for their business, using PL/SQL and automate the process using Unix shell scripts.
• Designed and developed complex procedures to handle errors and exceptions level using PL/SQL and SHELL scripts.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• Involved in Data loading and data migration Used SQL * Loader to load data from excel file into staging table and developed PL/SQL program to load data from staging table into base tables.
• Use Collections like variable arrays, nested tables, Associative Arrays, Records and objects
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in the monitoring of database performance in Enterprise Manger console.
• Supplied packages were used to extend the functionality of pl/sql programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL etc.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus,SQL Navigator, XML ,Shell Scripting, SQL*Loader, Shell Scripting, SQL developer, Data stage, Forms and Reports 10g,CSS,UNIX.

Confidentia

PLSQL Developer

Major Responsibilities:

• Studied user requirements and functional specifications. Converted User Requirements into formal Functional specification and Interfacing with client.
• Participated in the design and development of the project.
• Used Oracle designer to produce the ER diagrams,Dataflow,function Hierarchy.
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Used advanced SQL features like Inline views, advanced Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and other analytical functions in 10g .
• Wrote the extract program to generate the XML file with consumer details by order, which the dealers target for their business, using PL/SQL and automate the process using Unix shell scripts.
• Designed and developed complex procedures to handle errors and exceptions level using PL/SQL and SHELL scripts.
• Use Collections like variable arrays, nested tables,Associative Arrays, Records and objects
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures
• Supplied packages were used to extend the functionality of pl/sql programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL etc.
• Planned version control of production source code using Concurrent Version System (CVS).
• Using CAB for any production changes and attending the meeting to get an approval.
• Providing Post production support for XPO, OMS systems.
• Using remedy for ticket tracking.
• Developed database triggers to enforce security. Also implemented materialized views for remote instances.
• Responsible for application testing and support, version control, production staging and implementation planning, overseeing development efforts, support and training .

Environment : Oracle 11g/10g, Forms 10g, Reports10g, Designer 10g, SQL *Plus,XML, TOAD, PL/SQL, HP-UX, Windows NT/2000

Confidential

Oracle Developer

Major Responsibilities:

• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Designed and developed Oracle Forms & Reports using Forms10g/6i and Reports10g/ 6i. Including Forms based on stored procedures
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Use Collections like variable arrays, nested tables,Associative Arrays, Records and objects
• Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.
• Working Knowledge of MS Access advanced functions and VBA
• Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.
• Used UNIX Shell (Korn) Scripts for Extraction, Transformation and Loading of data.
• Providing support for the EWB systems.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment : Oracle 10g, Forms 10g, Reports10g, Designer 10g , SQL, PL/SQL, TOAD, SQL *Plus, Windows NT

Confidential

ORACLE Consultant

Major Responsibilities:

• Interacted with Business users, gathering and analyzing requirements
• Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into the GL interface Tables.
• Used UNIX Shell (Korn) Scripts for Extraction, Transformation and Loading of data.
• Created staging tables necessary to store validated data prior to loading data into GL interface tables.
• Created PL/SQL Packages, procedures and functions necessary for validations before loading records into GL interface table.
• Use Collections like variable arrays, nested tables,Associative Arrays, Records and objects
• Validation includes Source, category, code combination. Also checked for duplicates and nulls.
• Developed Database Triggers to enforce security.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in functions and procedures also used UTL files for producing flat files.
• Extensively used SQL and Pl/SQL queries to clean and filter the legacy data.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Creating Test scripts for the generated final Reports.
• Involved in writing Technical Specification Document.
• Creating Indexes, Views to improve the System Performance.
• Tested the Application to ensure proper Functionality, data accuracy, and that Modifications have no adverse impact on integrated system environment.
• Involved in the maintenance and support of existing applications with the users.
• Created Object Types in PL/SQL.
• Developed Complex SQL Queries, Packages, Functions, Procedures and Triggers in PL/SQL.
• Performed Unit Testing and involved in Tier 3 Red hat Support.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, Erwin, SQL *Plus, Forms6i, Reports 6i, Oracle Apps 11.5.8.

Confidential

ORACLE Consultant

Major Responsibilities:

• Associated and involved in different phases of System Development Life Cycle (SDLC)
• Interacted with business analysts to develop entity relationship diagram
• Created complex stored procedures and functions using PL/SQL.
• Database performance tuning for achieving high scalability and speed.
• Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages
• Involved in developing front end screens using forms 6i and generated reports using reports 6i builder.
• Involved in using Collections like variable arrays, nested tables,Associative Arrays, Records and object
• Written scripts to validate data in staging tables and developed SQL*Loader control files to load the data from flat files into the staging tables.
• Su pport developers with database objects, including tables, views, triggers and stored procedures as well as DDL, DML SQL queries.
• Provided technical support to end users like modifications in PL/SQL modules, User Interface based on the defects observed in testing and production pResponsible for coding and debugging and maintaining quality standards set by management.

Environment: Oracle9i , SQL, PL/SQL, SQL*Loader, Toad, Windows NT/XP, HP UNIX, Forms 6i,Reports 6i

Confidential

ORACLE Consultant

Major Responsibilities:

• Involved in Data Loading and Data Migration.
• Used Erwin to produce the ER diagrams.
• Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages.
• Implemented materialized views for remote instances.
• Involved in Query Optimization and Tuning tasks.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database.
• Making whole process run through Custom built ETL (SQL*Loader, Shell Scripting, PL / SQL Stored Procedures).
• Developed forms according to user requirements using Forms 6i.
• Designed and developed several matrix and master-detail reports with Oracle report designer.
• Developed Reports using Reports 6i based on client requirements.
• Generate SQL Scripts and create views for reports.
• Scheduled the jobs using cron jobs in UNIX.
• Performed Shell scripting in UNIX to automate the various processes.
• Prepare technical documents for all the programs developed & generated.
• Responsible in coding, trouble shooting and debugging.

Environment : SQL, PL/SQL, SQL * Loader, Windows 2000/XP, Oracle 9i, Forms 6i, Reports 6i, TOAD 6.4

Confidential

ORACLE Programmer Analyst

Major Responsibilities:

• Created database objects for the system like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures
• Developed Front-end forms depending upon the logic such as Master-detail form and complex forms for the application.
• Loaded data into various tables from Flat files, Access database as well as from Excel Spreadsheets using SQL*Loader.
• Developed stored procedures, packages and functions for the application that could be called by Forms & Reports.
• Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance.
• Written scripts to create Temporary tables in various schemas and Audit Transactions.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.

Environment: Oracle8i, UNIX, Forms 4.5 and Reports 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Toad