PROFESSIONAL SUMMARY

About 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling Logical and Physical , and Development of client/server and multi tired applications using the Oracle Relational Database Management System RDBMS , SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance Analysis and SQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints,

Explain Plan

• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Implementation and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Proficient in PL/SQL programming Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collections, Multi Table insert, PL/SQL tables , Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Worked as a member in the design team for creating data flow diagrams and Entity relation modeling using Erwin tool.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
• Experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading ETL .
• Experience in Data Migration across various databases as well as within the same database across different systems.
• Good experience in developing Oracle Reports 9I/10G/11G , BI Publisher Reports for various components.
• Well-versed with different stages of Software Development Life Cycle SDLC .
• Well experienced working with Waterfall Agile Methodologies.
• Experienced in Tuning Queries for better performance with large volume of data.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

Confidential One is a diversified bank that offers a broad array of financial products and services to consumers, small businesses and Commercial Clients. It offers various kinds of Loans, like Home Loans, Education Loans, Credit Cards, etc. The current project requires all invoice documents to be converted into Electronic form with complete automation. The Front End of this application uses Oracle Applications. The Scope is Global , implementation will be multi-year implementation of Releases.

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering.
• Worked on Agile Methodology for this project, the cycle consists of Design Planning, Sprint Planning, Stand up , Demo and Retrospective.
• Each Sprint Planning is for 3weeks depending upon the business priority , Groomed stories will be taken developed and tested. Business decides the number of stories that can be completed in single sprint.
• Created Technical Design Documents for the Back End PL/SQL based on Business Requirement Documents and the Functional System Design.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Involved in moving the data from flat files to staging area tables using SQL Loader.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Built Complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using oracle tools like PL/SQL Developer.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Get all Design and Coding Reviewed and Approved by the concerned authorities.
• Provide support to Front End and fix defects in various stages of Testing i.e IST, ET and UAT .
• Perform Technical Validation on production Release day and send a Success/ failure report accordingly.
• Building the reports using XML Packages.
• Involved in developing SQL queries for developing ORACLE 10G Reports.
• Multi Task 4,5 TARS Projects at a time in a release.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code PL/SQL program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Involved in the Migration of Oracle Forms, Oracle Reports.
• Developed various reports by creating master detail report , custom validations with the help of triggers , solving the issues related to layout , repeating frames , etc.
• Used Crontab to schedule the shellscripts to run at particular time on a particular day.
• Worked on Form Personalization for disabling few fields , Making few field's Non updatable .
• Worked closely with users in gathering and analyzing requirements and providing solutions that meet their requirements.
• Well versed with developing reports in OBIEE.
• Worked in Oracle Applications Environment for registering Forms/ Reports in the front end.
• Worked on Oracle BI Publisher Reports to extract the Data from Custom tables as requested by the business.

Environment: Oracle11g, SQL Developer, TOAD, Oracle Forms 9i/10g/11g , Oracle Reports 9i/10g/11g, XML Reports, Unix, XML, Oracle Applications R11i/R12,OBIEE,WINDOWS NT.

Confidential

Oracle Developer

Confidential offers processing and distribution services for us manufacturing items. The Application is for conducting the daily and weekly basis Text, Email, Letter, Dialer and Auto agent campaigns for collections from various delinquent customers and also for loading the data into the data warehouse tables for reporting purpose.

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Created Technical Documents for all the components that are developed in the project.
• Implemented Complex business Logic as per the client requirement using triggers.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Involved in moving the data from flat files to staging area tables using SQL Loader.
• Modified and created existing and new reports using Oracle reports 10g.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Creation of database objects like tables, views, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL plus.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Registering various forms and reports in Oracle applications frontend.
• Maintenance and support for the existing Oracle Forms 6i and Oracle Reports 6i.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code PL/SQL program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Developed various Oracle Discoverer Reports from the data warehouse tables.
• Prepared daily reports from the invoice data received for different department like sales, marketing and monthly reports to extract the monthly sales information.
• Developed Master Detail, Detail reports using tabular and Group above reports.

Environment: Oracle 11g, PL/SQL, Toad, Unix Sun Solaris 2.6, AIX 4.3, WINDOWS NT Workstation, Crystal Reports, Oracle Forms/Reports 6i/9i/10g, OBIEE .

Confidential

Oracle PL/SQL Developer

Confidential is a leading provider of on-board and wayside signaling systems and communications solutions for global freight rail, passenger and urban transit industries. The system was used by Sales, Marketing and Services Departments to extract information for analysis, review and decision making. The Data Warehouse was built using PL/SQL for Extracting data from various source systems.

Responsibilities:

• Extraction of data from different flat files into Oracle Database using SQL Loader.
• Gather Business rules from the end users that are to be incorporated into the system.
• Created technical documents based on the design documents provided by the business.
• Worked on PL/SQL Tables, Records and Collections.
• Wrote PL SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions.
• Worked on Database Links to import/export data.
• Created Logical and Physical Models using ERWIN.
• Created Shell scripts for regular back up instance start and shut down.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Worked on Materialized view by creating an estimated cost and solved costing issues in Production release.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Developed multiple layouts in a single template to get the desired output using Oracle BI Publisher administrator.
• Changed existing logic within the packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Worked on DBMS SCHEDULER to automate jobs.
• Implemented triggers based on the business rules.
• Optimizing and fine tuning the Crystal Reports for efficiency.
• Used ADO, ODBC for accessing and retrieving the data from database to Crystal Reports.
• Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.

ENVIRONMENT: Oracle 10g, SQL Developer, UNIX Shell scripting, ETL, Oracle Enterprise Manager, HP-UNIX,ERWIN 3.5, Toad 8.0, Crystal reports 9.0, MS SQL server 2005.

Confidential

Jr. Oracle developer

Confidential is a diversified managed health care company that offers a spectrum of products and services through two operating businesses i.e, healthcare and Optum. This project mainly consisted of development of scheduled interfaces to source highly secured patient data from the Oracle base tables into the custom tables of the Data warehouse environment.

Responsibilities:

• Developed data model, SQL Queries, SQL Query tuning process and Star Schemas.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Involved in logical modeling and physical modeling of application.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Participated in client requirement sessions to analyze and gather business requirements.
• Used pl/sql tables, pragma autonomous transaction to avoid mutating problem in database trigger.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Worked on data conversion, loaded data from different Sources into the Temp data backup environment using SQL Loader and validated the data before loading it into oracle tables.
• Optimizing PL/SQL code and SQL queries using Explain Plan, Indexes and Hints.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Involved in designing of end user forms and reports using Oracle forms 10g Reports 10g.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Customization of existing forms and development of new forms using different form built in's, created LOV's and record groups.
• Worked with different triggers in forms like Block processing triggers, Interface event triggers, navigation triggers and validation triggers.

Environment: Oracle 10g, UNIX, SQL, PL/SQL, SQL Loader, Unix shellscript, ERWin, XML, Forms Reports 9i, PL/SQL Developer and Toad.

Confidential

Management Trainee

Confidential is a multi- national business process outsourcing and it services company. Inspirit is the internal project of genpact which was developed in order to cater the requirement specifications of Adding /Deleting/Updating the Employee to Inspirit database, opening an entry to process details like applying a leave, managing a leave request , cancelling a leave req , raise work from home order etc .

Responsibilities:

• Got trained by the Management on SQL, PLSQL and basics of forms and reports.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• created Tables and other database objects
• Performed systems analysis Dataflow Diagram DFD , Entity Relationship Diagram ERD and
• Gathered requirements from users, analyzed and translated into design.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Created SQL Loader control files for moving the data from Flat Files to staging area tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Developed SQL scripts to extract data for reporting.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.

Environment: Oracle9i, TOAD, SQL Developer, Oracle Forms/Reports, ERWin, UNIX ShellScripting.