SUMMARY

• About 8 years of experience in Information Technology providing professional service as Oracle developer in planning, analysis, design, development, enhancement, testing and maintenance using Oracle database.
• Involved in system study, design, development, and implementation stages of various projects until the maintenance level.
• Grouping Sets, Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets/Analytical Functions.
• Extensive experience in writing Oracle PL/SQL Packages, Procedures, Functions, Database Triggers and SQL queries.
• Involved in full software development life cycle for PL/SQL, SQL and SQL*PLUS backend development for Data warehouse and OLTP applications.
• Experience in data migration using SQL*Loader and PL/SQL scripts.
• Experience in implementing Oracle Forms 6i/9i applications.
• Extensive experience in Analyzing, Designing, Testing, Documenting Database systems and Business applications.
• Good knowledge of Data Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity - Relationship Diagrams.
• Developed UNIX Shell scripting, korn shell scripting.
• Good Programming knowledge with Visual Basic 6.0, ASP, Java Script, VBScript and HTML.
• Involved in administrative roles like installing/configuring databases, creating databases, partitioning, creating indexes and migration of databases.
• Experience on different data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Understanding of Database Installation, Configuration, Support, Space management, and User management, Backup, Recovery, Oracle Net and Performance Tuning in the production database environment.
• Good knowledge in Relational Database Design and Development using Oracle 8i / 9i /10g.
• Good knowledge on SQL Navigator, PL/SQL Developer Tools, SQR reporting.
• Worked on unit and integration testing
• Assisted in various configuration and support operations which included Logical/Physical Backup methods.
• Assisted in performance testing of databases, creating indexes, creation and migration of databases.
• Thorough understanding of Database Concepts of Oracle 8i/9i/10g/11g and very good knowledge of performance tuning.
• Worked with unique and rare combination of Technical and Management skills, also a great team player..
• Strong communication and team skills with proven ability to work on projects with minimum guidance and specifications.

TECHNICAL SKILLS

Operating Systems: Windows 98 / 2000 / NT / XP, LINUX

Scripting: SQL, PL/SQL, and UNIX, Perl, Shell Scripting

Databases: Oracle 11g/10g/9i/8i, MS-SQL Server 7/2000/2005, MS Access

GUI: Forms 6i / 5.0 / 4.5, Reports 6i / 3.0 / 2.5

Query Tools: SQL*Loader, TOAD, SQL Navigator

Languages: C, C++, JAVA, HTML, XML, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, New York - NY

Sr.Oracle Developer

Responsibilities:

• Designed and built Base table load programs.
• Involved in design discussions on mapping of sources to the targets while identifying the required staging tables and transformations.
• Involved in creation of temporary tables.
• Developed PL/SQL scripts to support Data Transfer.
• Worked in creation of Tables using storage parameters and clusters.
• Worked in writing Sub Queries, PL/SQL procedures and Database triggers.
• Developed stored procedures, functions to check the data integrity in Intermediate tables.
• Designed and built Scrub to Base shell changes.
• Unit tested Base table load programs.
• Built one time logic for Transaction history executed 18 months of transaction history conversion and validated the conversion results.
• Control M Scheduling - Design the Production Job Streams, Create On-Line Requests for Control M and document the Control M Processes.
• Created PL/SQL packages, Stored Procedures, Functions and Triggers.
• Used Exception handling for validation of input and the ease of debugging and displaying the error messages in the application.
• Tuning of queries, procedures and functions for better performance using TKPROF and explain plan utilities.
• Loaded data using SQL Loader.
• Performed unit testing and integration testing.
• Involved in Production Support, Problem resolutions and Bug fixing.

Environment: Oracle 11g/10g, Windows XP, UNIX, PL/SQL, SQL, TOAD, OEM, SQL* PLUS, PUTTY, Control M.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Developed PL/SQL Packages, Procedures, Functions, and Database Triggers to meet the business requirements.
• Created PL/SQL Packages, Procedures, Functions with Dynamic SQL.
• Used Database trigger for making history of insertion, updating, deletion.
• Extensively used Nested tables, PL/SQL tables, Varrays to code Procedures and Functions
• Extensively used Bulk Collections to improve Performance
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Optimizing PL/SQL code and SQL queries (Using Explain Plan, Analyze, Indexes and Hints)
• Responsible for Unit Testing and Integration Testing of PL/SQL Packages, Procedures, Functions and Triggers.
• Proactively resolved QA,UAT and Production Issues

Environment: Oracle 10g, Oracle Forms 10g, Reports 10g, Designer 2000, SQL, PL/SQL, SQL loader, Unix Shell Scripts, Oracle Procedure Builder, HTML, XML

Confidential, Mt. Laurel, NJ

Oracle PL-SQL developer

Responsibilities:

• Involved in walkthrough sessions with Business Analysts and End users during Development phase
• Developed Triggers, Procedures, Functions and Packages.
• Produced detail design specifications of the system.
• Worked on implementing enhancements to business and logical data models to make the appropriate changes to the physical data model.
• Involved in writing Unix Korn Shell Scripts
• Worked on Performed tuning and optimization of Database Queries, Scripts and Procedures.
• Worked on Crystal Reports for reporting needs of application.
• Worked on converting and manipulating data using SQL Queries
• Supported development effort by building comprehensive data model and documenting Requirements.
• Worked on developing Crystal Reports to design and generate reports.
• Performed audits and System testing.
• Re-wrote stored procedures and optimized data warehouses.
• Involved in writing complex queries to generate reports as per client request as a part of production Support
• Wrote Unit test plans and test cases.

Environment: Oracle Database 9i, Forms 9i and Reports 9i, PL/SQL, SQL*Plus, TOAD, Windows NT, UNIX, PRO *C.

Confidential, Chicago, IL

Oracle Consultant

Responsibilities:

• Created custom table, triggers, stored procedures, functions, packages to modify the existing oracle database
• Created a series of procedures and functions for loan and facilities transactions
• Analyzed business functionalities related to back-end database interfaces and utilized PL/SQL developer tool to develop all back-end database interfaces.
• Involved in daily, weekly and monthly loading of data from Mainframe data sets to Oracle RDBMS.
• Developed triggers for error handling and to keep track of changes to the fields of tables when changes are made.
• Worked on the Stored Procedures, Functions and Constraints, Tables, Indexes and Tuned queries for performance.
• Tuning SQL queries using Explain Plan and SQL Trace.
• Created views which require complex joins and quick response time.
• Developed data entry forms using Forms Builder 6i.
• Carried out technical specification documents for back-end and interface with front-end.
• Modified Stored Procedures and Packages using PL/SQL.
• Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements.
• Defined relationships using primary keys and foreign keys for the entities and normalized the entities.

Environment: Oracle 9i, PL/SQL, Toad 8.0, JSP, JDBC, Windows NT, HTML, SQL*Plus, Discoverer, Crystal Reports, Forms & Reports 6i, Test Advisor, Test Director, Business Objects.

Confidential

Software Developer

Responsibilities:

• Actively participated in understanding business requirements, analysis and designing ETL process.
• Effectively applied all the business requirements and transforming the business rules into mappings.
• Translate customer requirements into formal requirements and design documents.
• Developed Mappings between source systems and Warehouse components.
• Used Informatica designer to create complex mappings using different transformations to move data to a Data Warehouse.
• Used aggregator, router, joiner, stored procedures, look up, filter, source qualifier and update strategy transformations extensively.
• Created reusable transformations and mapplets to use in multiple mappings.
• Prepare PLSQL scripts for data loading into warehouse and mart.
• Self-Review of Unit test cases, Integration test cases of all the assigned modules.

Environment: Oracle 9i, PL/SQL, SQL Navigator, Discoverer, Crystal Reports, Forms & Reports 6i