SUMMARY:

• Over 7 years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation.
• Extensively worked in Client-Server application development using Oracle 8.0/8i, 9i, 10/g, PL/SQL and SQL PLUS, Oracle Forms/ Reports 10g/6i.
• Extensive experience in application data modeling and building data warehouse architecture Star Snowflake schemas and ER Diagrams using Microsoft Visio, Erwin and IBM Rational Rose data modeler tool.
• Extensively Worked on Oracle Database creation, Table Space management, Export Import Backup, Performance tuning, Tuning Init.ora file.
• Working knowledge of SQL Trace, Explain Plan and SQL Loader for performance tuning and database optimization.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Expert in maintaining data integrity using various constraints and database triggers.
• Supported DBA to Take Back up, Monitoring Performance and Tuning Activities.
• Extensively used QUEST Tools TOAD, Navigator and SQL PLUS.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Experience using Red Hat Linux, Ubuntu, and Sun Solaris.
• Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory.
• Controlling Access: Granting and revoking permissions to users, groups and roles on various objects.
• Also involved in exporting and importing of data using utilities like Export, Import, Data Pump Export and Data Pump Import.
• Good team player with strong technical, analytical and people skill for effective software development.
• Communicate complex topics clearly and concisely, both verbally and in writing, tailoring communications to fit the audience.

TECHNICAL SKILLS:

EXPERIENCE:

Confidential

Oracle PL/SQL developer

Responsibilities:

• Involved in development of process using SQL LOADER, PL/SQL Programming.
• Extensively used tools like SQL PLUS, SQL Developer, Toad and PL/SQL developer for programming purposes.
• Worked on shell scripting to kick off the SQL Loader control files to load the data into database/multi environments for existing application usage.
• Responsible for development, implementation and Support of various RDBMS oracle based IT projects specially related to ETL, Data warehousing, and Data marts, reporting. Various batch jobs.
• Worked closely with business and product group to enhance functionality of pre-paid platform to implement various clients requirement.
• Worked with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure, played liaison role with customers as well with other business segments
• Total Responsibility for all development and implementation of Database Oracle RDBMS , work that includes OLTP.
• Have good knowledge on Exadata and Exalytics.
• Responsible of Provisioning, Storage Management, Patching and Validation and Diagnostics.
• Developed and implemented ETL Components based on the filter rules to obtain needed data from different source systems for calculating required metrics using Informatica Power center.
• Hands as well sound Knowledge of ORACLE RDBMS, extensive SQL, PL SQL, DB physical modeling, Data analysis.
• OLTP reporting using analytical quires, Reports. Excel pivoting.
• Prepared test Scenarios and Test cases in Rational Quality Manager and involved in unit testing of mappings, system testing and user acceptance testing.
• Defect Tracking and reports are done by Rational Quality Manager.

Environment: Oracle 11g, PL/SQL, OLTP, Windows 8, SQL LOADER, TOAD, UNIX Shell Scripting, Oracle SQL Developer, SQL Plus, OLAP, SQL, MS SQL Server 2008.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in designing and development of data warehouse for the corporate data repository.
• Created and maintained Database Objects Tables, Views, Indexes, Sequences, Database triggers, stored procedures .
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Developed SQL loader scripts to load data in the custom tables.
• Analyzed data, designed and developed Oracle FORMS 10g queries, layout, report triggers, parameter form, data models etc.
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Developed and optimized SQL queries using TOAD Explain Plan utilities.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency.
• Run batch jobs for loading database tables from flat files using SQL Loader.
• Used Version Control tools like Microsoft Visual SourceSafe for Source Control.
• Developed Materialized views and Ref Cursors for reporting purpose.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose.
• Worked closely with users and developers team to resolve issues in the developed reports.

Environment: Oracle 9i, SQL, PL/SQL, SQL Plus, SQL Loader, Oracle, TOAD, Erwin 7.2, Microsoft Visual SourceSafe, Putty, UNIX, Shell scripts.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Oracle Apex Application from Scratch.
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, indexes.
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 10g.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Developed UNIX Shell Scripts for to run SQL Queries for Auto Reports.
• Designed, Developed and Tested application in UAT environment and Deployed in Production.
• Provided Productions supports and ongoing user supports for the application.
• Designed Development Documentation and Support Documentations.

Environment: Oracle 10g, Oracle FORMS/REPORTS 10g, Designer10g, Oracle APEX, Oracle Application Server 9i, Discoverer 9i and UNIX Scripting.

Confidential

Oracle Developer

Responsibilities:

• Gathering system requirements through client interactions.
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Created database objects like Tables, Indexes, Sequences and Views etc.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints. Coding of documents in XML for data transformation.
• Developed test procedures to Unit test the application.
• Worked on Oracle OLAP tool to produce analytic measures, including time-series calculations, financial models, and forecasts.
• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing
• Performing the tests on the newly coded procedures and documenting the same.
• Preparing technical documents using the functional specifications.
• Building PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated SQL Loader using shell scripting.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 8.3, SQL Plus, TOAD, SQL Loader and Windows 2000, UNIX shell scripting.