SUMMARY

• 13+ Years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (Sql, PL/SQL).
• Expertise in Client - Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL *PLUS, SQL Developer, SQL*LOADER, APEX 4.0/4.2/5.0, Forms 6i and Reports 6i.
• Solid experience in translating business requirements into creation of Database Objects.
• Proficient in writing Complex SQL Queries, Normalization, Database Design, creating Indexes, Triggers, Sub Queries, Joins, Procedures, Cursors, Functions, Packages, Experience in Oracle supplied packages such as DBMS SQL, DBMS JOB/DBMS SCHEDULER, UTL FILE., Dynamic SQL, Records and PL/SQL Tables, Exceptions.
• Worked extensively on Ref Cursor, External Tables and Collections. Experience in advanced PL/SQL concepts like Bulk collect and for all.
• Loaded Data into Oracle Tables using SQL Loader.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, Hints and Indexes.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as BIRT.
• Created Shell Scripts for invoking SQL.
• Experience with APEX Administration, APEX Development and Web services Experience with JavaScript Validation used for APEX Design.
• Experience with JQuery used for APEX Functionality. Experience with HTML, CSS used for APEX.
• Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Involved in Oracle DBA Activities like Export, Import Dump Files, Table space Creation, User creation, Data pump, Assigning Roles, Oracle installation, Monitor Server Performance and Tuning.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Significant experience in 24/7 Production Environment Support.

TECHNICAL SKILLS

Operating System: Windows, UNIX, Linux.

Databases Environments: Oracle 9i, 10g, 11g, 12c, MySQL 5.1, Informix 11x.

Reporting Tools: Actuate BIRT, Birtihub.

Front End: APEX 4.0/4.2/5.x.

Other tools: Forms 6i, Reports 6i, JavaScript, JQuery, AjaxKnowledge in Joomla.

PROFESSIONAL EXPERIENCE

Confidential

Oracle pl/sql developer

Responsibilities:

• Creating Web services using pl/sql and APEX 5.x.
• Involved in the maintenance and enhancement of the application.
• Creating table spaces, tables, views, scripts for automatic operations of the database activities.
• Coded various stored procedures, packages and triggers to in corporate business logic into the application.
• Used the technical document to design the database tables.
• Gather Database and User Level Statistics and Analyze Overall System Performance.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Used DBMS JOB/DBMS SCHEDULER to automate the PL/SQL procedures and packages.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Involved in Unit Testing Stored Procedures and Functions.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, per the requirements.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend Procedures and Functions using PL/SQL.
• Contributed with database designs and assisted in increasing response time for APEX reports.

Environment: APEX 5.x, Oracle SQL, PL/SQL, SQL*Loader, SQL Developer, Oracle Fusion, Web services

Confidential

Senior System Analyst (Oracle PL/SQL)

Responsibilities:

• Responsible for purging and archiving the production databases.
• Responsible in developing UNIX shell scripts to administer the system.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Involved in Unit Testing Stored Procedures and Functions.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Supported QA activities, test plans and performance enhancement techniques.

Environment: Oracle SQL, PL/SQL, SQL*Loader, SQL Developer, web logic.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Installation, Creation and support of Oracle 10g/11g database environments.
• Involved in the maintenance and enhancement of the application.
• Maintaining Logical and Physical structure of the database.
• Creating table spaces, tables, views, scripts for automatic operations of the database activities.
• Coded various stored procedures, packages and triggers to in corporate business logic into the application.
• Used the technical document to design the database tables.
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping
• Created control files for SQL*Loader.
• Gather Database and User Level Statistics and Analyze Overall System Performance.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Develop UNIX shell scripts to administer the system.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Responsible for purging and archiving the production databases.
• Used DBMS JOB/DBMS SCHEDULER to automate the PL/SQL procedures and packages.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Communicate issues and progress to project manager.
• Performed logical backup using export and import utilities.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Involved in Unit Testing Stored Procedures and Functions.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend Procedures and Functions using PL/SQL.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Contributed with database designs and assisted in increasing response time for APEX reports.
• Designed application framework and developed Oracle APEX Application.
• Provided APEX guidance and support to technical staff on application maintenance and SDLC process.
• Used Oracle APEX 4.0/4.2/5 for designing application structure.
• Formulated oracle process, data retrieval methods and SQL code blocks.
• Designed and evaluated applications, and provided architectural input apps.
• Coded, tested and troubleshot software applications.
• Conducted unit testing and maintained data extractions and object models.
• Supported QA activities, test plans and performance enhancement techniques.

Environment: Oracle SQL, PL/SQL, APEX 4.2/5, SQL*Loader, SQL Developer, BIRT Report.

Confidential

System Analyst (Oracle PL/SQL)

Responsibilities:

• Developed stored procedures to extract the data from different sources and load it into Oracle Database.
• Created data mapping files for the data coming from different web services.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Developed procedures using Dynamic SQL.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Worked with Development team and architect to build data model for staging area.
• Importing and exporting the data into multiple environments.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Utilized SQL*Loader to load flat files into database tables.

Environment: Oracle SQL, PL/SQL, SQL*Loader, SQL Developer.

Confidential

Senior System Analyst (Oracle PL/SQL)

Responsibilities:

• Expertise in developing forms using Oracle Forms 6i/9i.
• Expertise in developing forms using Oracle Reports 6i/9i
• Expertise in deploying reports on Reports Server and troubleshooting Reports Server.
• Experience in Report Security issues.
• Experience in Leading a Team for development of reports and Backend Development.
• Proven skills in SQL tuning and enhancing application performances.
• Proficient in server side programming like Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
• Worked extensively with SQL Loader using control files for data ware housing and data loading into oracle database tables.

Environment: Oracle SQL, PL/SQL, Forms 6i/9i, Reports 6i/9i, SQL*Loader, SQL Developer.