SUMMARY

• Around 7 years of experience with expertise in Data Base Design, Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8i, SQL, PL/SQL.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools such as Ab Initio, ODI, Informatica and Erwin.
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Triggers, Database Links and Database Directories.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections, Records, Object types.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD, SQL*plus, iSQL*plus, SQL Developer.
• Strong experience in SQL, PL\SQL and used in RICE(Reports, Interfaces, Conversions and Extensions) components.
• Experience in providing solutions of capacity, replication data issues.
• Expertise in Oracle Developer/ PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System.
• Good programming knowledge in Oracle 11g/10g/9i, Oracle developer Suite10g (Oracle Forms, Oracle Reports).
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, Triggers, cursors and views for processing data, enforcing referential integrity and needed business rules.
• Experience in creating different kind of partitions on large tables and creating indexes in order to improve performance. Worked on several Oracle provided packages such as UTL FILE and DBMS JOB.
• Tuning SQL queries using explain plan, tkprof, sqltrace.
• Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
• Worked on Oracle Forms 10g/9i/6i Reports10g/9i/6i.
• Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• 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.

TECHNICAL SKILLS

Languages: Oracle SQL* PLUS, PL/SQL,Oracle - Financial Management, Pro * C, C, UNIX Shell Scripting.

Databases: Oracle 11g/10g, 9i, 8i, 7.x/SQL Loader, MS Access

Tools: & Utilities: SQL*Loader, SQL, PL/SQL, SQL*Plus, SQL Navigator, Toad, Erwin, TKPROF, Autosys, Winscp, SVN, PVCS, DB Artisan 8.5.5

GUI Tool: Oracle Forms 6i and Reports 6i

OS: SUN Solaris, UNIX, LINUX,Windows98/NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, New Hyde Park, NY

Oracle Developer

Responsibilities:

• Creating PL/SQL Procedures, Functions and Packages.
• Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Used Bulk Collect to implement the performance of multi row queries.
• Working on extracting the data from the flat file and loading them in to the database by scheduled procedures (ETL) through external tables, SQL loader and table function.
• Extensively worked on UTL FILE package to create and load data files.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Generating reports using PL/SQL Procedures.
• Automated all the manual jobs and tracking daily event log reports.
• Working on Production Support issues.

Environment: Oracle 10g/11g, SQL, PL/SQL, SQL*Loader, Subversion

Confidential - Saint Paul, MN

Oracle Developer

Responsibilities:

• Developed Stored Procedures/Functions/Packages as per the business requirements for new package types for qualified borrowers.
• Worked with ETL and Java developers and created Procedures/Functions/Packages for frontend and for backend.
• Modified the procedures/Packages to generate the xml files by using UTL FILE oracle API.
• Loaded daily data into the staging tables in the database using SQL loader and external functions (ETL).
• Developed new procedures/Package to generate the xml files for generating the borrower documents.
• Rewrote the entire Docs code using Dynamic SQL by using Metadata for facilitating the new packages per Business requirements.
• Involved in creating application documentation such as Technical Design Documents and Unit Test Plan.
• Extensively involved in the performance issues with large volume of database tables and gathering the new stats using Advance Oracle Pl/SQL features to fix the performance issues.
• FTP/SFTP used for sending the xml files to Lender live (Third party Company) for generating the borrower documents.
• Extensively provided on call support for Production Issues in the Business/Non Business hours.
• Supported Data migration from one environment to another.
• Worked Unix/Linux SA to schedule jobs on cron tab.
• Used Latest Version of Toad tool to develop ORACLE SQL and PL/SQL Programs.

Environment: SQL Navigator 7.0, PL/SQL, Oracle 10g/11g, XML, Toad 10.6, ETL/Informatica Power Center, Winscp, SVN, Putty Manger, UNIX Shell Scripting, Sun Solaris, Linux, Windows.

Confidential, Hartford, CT

Oracle PL/SQL Developer

Responsibilities:

• Created tables, Partioning tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms, Procedure, packages for the business application development.
• Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS.
• Implemented table partitioning and sub-partitioning to improve performance and data management.
• Worked with Oracle Enterprise Manager, Net configuration assistant.
• Created database links to retrieve data from multiple servers.
• Created public synonyms on the database links for easy reuse.
• Involve in Tuning, Performance, and Optimization of queries and standardization of the code.
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Written database triggers for automatic insertion of tables on different schema
• Used features like bulk collect to process large amount of data in data base.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Experience with different backup strategies using Export/Import utilities.
• Used Packages DBMS JOB, DBMS PROFILER.
• Involved in Tuning, Performance, and Optimization of queries and standardization of the code.
• Preparing Design documentation and getting approval from the client.
• Creating Stored Program Units in the Functions, Triggers and procedures for implementing complex database intensive business rules.
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Created different kind of Charts in the reports for the purpose of Analysis.

Environment: Oracle 10g/9i, SQL Developer, PL/SQL, Data Modeler.

Confidential, NYC, NY

Oracle PL/SQL Developer

Responsibilities:

• Spearheaded software development process for multiple projects, leading and mentoring a team of developers
• Developed and modified PL/SQL packages to manage the alerts as they traverse through different stages
• Developed complex SQL script, Analytical Function using Cursors, Procedures and Triggers
• Created Requirement Traceability Matrix to trace requirements throughout the development process
• Created Materialized Views and tuned the data.
• Created partitioned tables, partitioned indexes for manageability and scalability.
• Developed Unix shell scripts to analyze data written in XML Files and store them into tables and vice-versa
• Involved in the preparation and authorization of test plan
• Involved in the preparation and execution of test Cases and reporting test results
• Involved in the preparation and maintenance of Requirement Traceability Matrix
• Involved in Functional, Regression and System Integration testing
• Defined test cases, created Test Scripts, analyzed bugs by interacting with the QA team to fix errors
• Tested input data arriving from different countries and standardized them using data mining tools like discovery
• Provided support for implementation and User Acceptance Testing
• Authored User Guide Documents followed by clients for multiple applications.

Environment: Oracle 11g/10g, SQL*PLUS, MS-Office, PL/SQL, Data Modeler.