SUMMARY

• Over 6+ years of experience in Information Technology Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL,SQL Developer, SQL PLUS.
• Proficient in writing PL/SQL Packages, Stored Procedures, Triggers and Cursors. Developed various applications, using Oracle built - in packages
• Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques
• Extensively used Oracle Analytical functions like ROW NUMBER, FIRST VALUE
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, Code Review, coordinating user training and user testing, Project demonstration, Implementation, Maintenance
• Experience working with Production and Development environment
• Work experience in UNIX, Windows 95/98/XP/2000/7
• Developed Forms using Core Java Concepts.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files
• Experience in Installing Software’s and Configuring Databases
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL
• Have experience on backend systems running Oracle Databases and working with large database
• 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.
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3.
• Experience in developing Strategies for Extraction Transformation Loading (ETL) mechanism using INFORMATICA tool.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.

TECHNICAL SKILLS

DW Tools: Informatica Power Center 8.6

Databases: Oracle 10g / 11g,MS Access, UNIX, Oracle Forms And Reports

Languages: SQL, PL/SQL, C, Java and JavaScript,T-SQL

Applications: Microsoft Office - Word, Excel, PowerPoint.

Operating Systems: Windows XP / VISTA / 7, UNIX, Shell Scripting

Web Technologies: HTML, CSS, DHTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, South Brunswick NJ

Oracle Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Development and Implementation
• Front-end Subscription Request form was developed using Core Java tool namely Ciboodle.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader
• Designed Forms for raising a Subscription request using Oracle Forms10g.
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming for different modules with the help of both Onsite and Offshore team.
• Participated in Performance Tuning with the team.
• Written stored procedures, functions and packages for application development
• Developed stored procedures, views, DDL triggers, cursors and user defined functions
• Expert in analyzing/troubleshooting and providing technical support for Oracle applications and their interfaces
• Scheduling Execution of PL/SQL Procedures using Unix Shell scripts for updating of Base tables from Transaction Tables
• Developed Dynamic Queries using Execute Immediate.
• Copying of data from production to system test and development by using DB LINKS
• Involved in unit testing and system testing while the code is moved to production
• Helped BI team to create the views which can be used for their reporting purpose.
• Created Mappings and Workflows using Informatica.
• Worked on transformations like Lookup, Filter, Expression, Aggregator, Router, Source Qualifier, Sorter, Sequence Generator, Rank, Lookup, Normalizer etc.

Confidential - Princeton, NJ

Oracle Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Designed forms for raising a voucher request using Oracle Forms10g.
• Involved in the continuous enhancements and fixing of production problems.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Confidential, New Brunswick NJ

Oracle Developer

Responsibilities:

• Gathered Business Requirements from the client and translated the business detail in to technical design and specification
• Designing and developing data models by coordinating with the Offshore team.
• Developed various backend application programs such as Views, Functions, Triggers, Cursors, Procedures and Packages using SQL and PL/SQL
• Responsible for creating functions to be used for calculations. Written database triggers for monitoring the data migration
• Developed algorithm and PL/SQL code for efficient retrieval and manipulation of complex data sets using PL/SQL packages
• Written PL/SQL procedures and functions while migrating the data from the source legacy systems to the Oracle.
• Extracted and transformed source data from different database like Oracle, SQL Server and flat file into oracle.
• Developed packages for ETL purpose in data warehouse environment, to extract data from the production systems
• Created and modified database objects like tables, views, and constraints
• Implemented business logic using stored procedures to increase performance
• Tuning the SQL statements by creating indexes
• Created stored procedure and function in PL/SQL to increase the performance of Forms on web server

Confidential

Oracle Developer

Responsibilities:

• Participated in the full software life cycle
• Participation in weekly design reviews and walkthroughs with project manager and development team
• Using Swing Concepts in Java Front End Forms were designed.
• Worked on database design with the team
• Writing PL/SQL code using the technical and functional specifications
• Generated SQL and PL/SQL scripts to install create database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
• Involved in writing PL/SQL Packages, Functions and Stored Procedures and Data Base Triggers
• Developed complex queries to retrieve the data
• Documented business rules, functional and technical designs, test cases, and user guides.
• Involved in the debugging and error handling
• Monitored the database growth on daily basis. Established backup and recovery strategies
• Performed Tuning by creating Indexes. Used TOAD, PL/SQL developer tools for faster application development
• Measured the performance of the shell scripts by getting the expected results
• Prepared test cases for testing procedures. Involved in unit testing and Integration testing of the Modules
• Involved in Production support and Maintenance.

Confidential

Oracle Developer

Responsibilities:

• Involved in System Analysis, Design, Coding,Development and Implementation.
• Creation of database objects like Tables, Views, Materialized views, Procedures and Packages using Oracle tools like PL/SQL, SQL* Plus
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling
• Written stored procedures, functions and packages for application development.
• Developed SQL, PL/SQL programs to keep the Master and lookup tables up to date on a daily basis.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers, cursors and user defined functions.
• Automating data loading, extraction, report generation using PL/SQL coding.