Experience Summary

• Over7 years of IT experience in Development, System Analysis, Design and Testingof business applications using Oracle 11g/10g/9i.
• Extensive programming knowledge in PL/SQL, SQL Plus, TOAD, SQL Loader.
• Experience in development ofTrigger,Procedures, Functionsand Packages.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object and Collection, Bulk Collect etc.
• Experience in Oracle Data Warehouse, ETL Process Basic lavel.
• Experience in development and maintenance of data warehouse initiatives and reporting needs for the business.
• Expert in Data Conversion, Add-hoc reporting, Data Analysis and validation.
• Experience in design and development of end user Reports using Crystal Report, Business Objects, Report Builder
• Extensive knowledge in Pro C, Apex, shell scripting.
• Proficient in transforming data from various sources flat files,mainframe, Oracle to Data warehouse using SQL LOADER and External table.
• Competency in manual testing of User acceptance testing.
• Experience in code migrations from Development to QA, QA to UAT Stage and Stage to Production Environment.
• Experience in Query Optimization, Debugging and Tuning for improving performance of the applications.
• Experience in analyzing Data flow Diagram, ER Diagrams.
• Extensively involved in designing Database schemas
• Experience in using Version Manager PVCS .
• Experience in Oracle Developer Forms 10g Report Builder , PL/SQL, SQL etc based multi-tire application development
• Extensively worked with all aspect of in-house system deployment for organization experience in developing customized software solutions.
• Experienced in all phases of the system development life cycle SDLC
• Experience in Documentation that involves functional specification, user Manual and technical review.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

Technical Skills:

Professional Experience:

Confidential

Role:Oracle PL/SQL Developer

Responsibilities:

Prepared program Specification for the development of PL/SQL procedures and functions. Created Custom Staging Tables to handle import data. Created custom triggers, stored procedures, packages and functions to populate different database. Developed SQL loader scripts to load data in the custom tables. Run Batch files for loading database tables from flat files using SQL loader. Created UNIX Shell Scripts for automating the execution process. Developed PL /SQL code for updating payment terms. Created indexes on tables and Optimizing Stored Procedure queries. Design, Development and testing of Reports. Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application. Created Indexes and partitioned the tables to improve the performance of the query. Involved in preparing documentation and user support documents. Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 11g, SQL Plus, SQL Loader, PL/SQL, TOAD 9.5, UNIX

Confidential

Role:Oracle PL/SQL Developer

Responsibilities:

• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Involved in data modeling Physical and logical models using ERWIN and TOAD tools.
• Involved in moving the data from flat files to staging area tables using SQL Loader.
• Implemented Complex business Logic as per the client requirement.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Used Ref cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables.
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL plus.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Effectively handled serious errors like Mutating table error using multiple triggers and Pragma autonomus transaction.
• 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 performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• 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.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.

Environment: Oracle 11g, SQL Plus, SQL Loader, PL/SQL, TOAD 9.5, UNIX

Confidential

Role : Oracle PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System design documents, Flows, Test Plan preparations and Development of Business Process and Work Flow charts.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Involved in Creation of tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonymsfor the business application development.
• Created Materialized viewsto calculate aggregated data, such as Sum of monthly revenue.
• Developed complex ORACLE stored procedures and packages to calculate borrower's debt ratio, property taxes, mortgage insurance, regular/ irregular payments, etc.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed / modified PL/SQL code like stored procedures, packages for interfaces.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed PL/SQL code for updating payment terms.
• Supported DBA team for the data migration from oracle 9i to 10g.
• Creation of Forms, Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS List of Values and record groups at various points in runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Development of PL/SQL program units and sharing them among multiple applications for processing business logic in the database.
• Testing all forms, PL/SQL code for logic correction.

Environment: Oracle 9i/10g SQL, PL/SQL , SQL loader, Toad 9.0.1, Forms/Reports 6i, UNIX

Confidential

Role:Oracle PL/SQL Developer

Responsibilities:

• Understanding and documenting business rules, input/output requirement and data sources.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Creating database objects And Developing and modifying PL/SQL packages, functions and procedures, triggers.
• Extract data into Oracle table using SQL LOADER and EXTERNAL Table.
• Transform the source data to the Target table.
• Writing Complex SQL script, Analytical Function.
• SQL tuning.
• Data Analysis and validation.
• Improved query performance by query optimization - tracing the query execution plan explain plan .
• Unit testing.
• Implement Logical design to Physical design.

Environment: TOAD, MS Visio. MS Project, SQL Navigator, SQL Developer

Confidential

Role : Oracle PL/SQL Developer

Responsibilities:

• Analyzed Internal External Source systems and Business Requirements to develop Health Insurance Claims Data warehouse LOGICAL AND PHYSICAL MODEL Facts and Dimensions and Business Process Model.
• Developed back end interfaces using Tables, PL/SQL packages, stored procedures, functions, Collections, Object types specifically for financial reporting.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems by using Hints, Indexes, Partitioning and analyzing the Stats updates.
• Extensively used the Triggers, Indexes, Views and Materialized Views for the Application design.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Performed subsequent alterations using SQL, PL/SQL to make any changes on adhoc requirements.
• Implemented Business Rules using PL/SQL Procedure/Packages with complex water fall calculations.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Developed PL/SQL Procedures, Functions and Packages for Business Intelligence.
• Actively involved in Data Mapping of tables from Source system to Target system, including preparation of Entity Relationship Diagram.
• Generated cubes from the data warehouse for the analysis purposes.
• Normalized and De-normalized entities for the Data Warehouse.
• Involved in Data Extraction, Transformation and Loading ETL process from source to target and worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Worked on Production support for the backend database and reporting applications.
• Involved in importing Source Tables from the different databases.
• Used UNIX Shellscripts KORN for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to the user with regard to operational aspects.

Environment: Oracle PL/SQL, SQL, 10g/11g, Oracle Forms, SQL Loader, ERWIN, ETL, Informatica, Visio, Rational Rose Clear case and Clear Quest.

Confidential

Role : Oracle PL/SQL Developer

Responsibilities

• Create and maintain tables, views, procedures, functions, and packages.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 9i
• Developed screen layouts, report layouts using Forms and Reports and participated in implementation.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Successfully manipulated Stored Procedures, Functions and Packages using TOAD.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Designed and developed various reports using Oracle Reports 9i.
• Created and used Table Partitions to further improve the performance while using tables containing large amount of data.
• Used Designer 2000 for Data Modeling, Design Specifications and to analyze Dependencies.
• Assisted in debugging Visual Basic.NET components
• Developed PL/SQL packages using Oracle Standard/ Custom Exceptions.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures. The filter conditions for the Queries were dynamic in nature and included lexical parameters.

Environment: PL/SQL, SQL LOADER, SQL PLUS, ASP, HTML, PVCS, TOAD, Java, Developer Suite 6i/9i Forms, Reports , Windows NT 4.0/2000, UNIX shell scripting.