SUMMARY

• About 8+ years of expertise in the development of client/server and multi tired applications using Oracle Database, SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX
• Involved in gathering requirements, design, development, testing, implementing, support and documentation of business applications using Oracle technologies.
• Strong knowledge on various database concepts like Normalization and ER Diagrams.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and business rules.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Highly knowledgeable in SDLC methodologies (Waterfall & Agile).
• Implemented PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, UTL FILE to read and write the files.
• Optimized existing queries for better performance and less impact on database
• Extracted, Transformed and Loaded data from various sources into Data Warehouses.
• Expertise in using tools such as SQL*Plus, TOAD, SQL Developer and SQL*Loader.
• Good knowledge in creating DDL, DML and transaction quires in Oracle SQL and SQL Server Database.
• Proficient in shell scripting, unit testing, code migration/deployment, Pre and post production support, extensions, customizations and Maintenance.
• Have in - depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, PL/SQL scripts.
• Rich experience working with Data Stage ETL tool for the extraction, transformation and loading of data among different databases. Strong knowledge of ETL processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
• Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader.
• Proficient in building, migrating and customizing forms using Forms Builder 6i/9i/10g.
• Proficient in building, migrating and customizing Reports using Reports Builder 6i/9i/10g.
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import and UTL FILE to read and write the files.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan and TKPROF.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language and maintaining the DDL scripts
• Used DBMS PROFILER package which enables the collection of profiler data for performance improvement.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Expert knowledge in Analyzing, designing, developing, testing and implementing Relational database architectures.
• Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.
• Strong communication, interpersonal, analytical skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.

TECHNICAL SKILLS

DATABASES: Oracle 11g/ 10g/ 9i/ 8i,SQL Server 2005, MS ACCESS

LANGUAGES: SQL, PL/SQL, PRO* C, C++,Java, Visual Basic

DATABASE TOOLS: TOAD, SQL Developer, Oracle Enterprise Manager, SQL*Plus, SQL*Loader, Query Direct

ORACLE TOOLS: Forms Builder 6i/9i/10g/11g, Reports Builder6i/10g, Discoverer 4i/10g, XML, MARS Application

DATA WARE HOUSING TOOLS: Informatica Power Center 9/8, Visual Studio, ERWIN

SCRIPTING: Unix shell scripting, Java Script, PERL Scripting

OPERATING SYSTEMS: UNIX, LINIX, AIX, SUN Solaris, Windows VISTA/XP/2000/98

TICKETING SYSTEMS: SYSAID, HP Service Manager, JIRA, Rational Team Concert

CHANGE MANAGEMENT: Clear Case, Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, LAS VEGAS, NV

SR. ORACLE PL/SQL DEVELOPER

Responsibilities:

• Interacted with technical consultants, financial users and business analysts to understand the business requirements.
• Involved in designing and building new data mart.
• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views and SQL scripts using PL/SQL for new DataMart.
• Involved in performance tuning for the new data mart which included creating indices, table partitioning, SQL hints using explain plan utility.
• Wrote dynamic SQL queries in different procedures and packages to work on PIVOT function.
• Worked extensively on Exception handling to trouble shoot the PL/SQL code.
• Created PL/SQL based ETL process to transfer data from sources to data mart.
• Created various Mapplets in designer using Informatica Power Center Mapplet Designer.
• Worked extensively with oracle External tables to load data from flat files into data mart for further processing.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Extensively used cursors, sequences and indexes in the procedures.
• Responsible for creating mappings as per technical design documents.
• Used several Oracle provided packages such as UTL FILE, DBMS JOB, and DBMS SCHEDULER.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Involved in writing technical documentation, and writing test plan.
• Extensively used PL/SQL Collections for high performance of stored procedures.
• Modified Shell and PL/SQL scripts for regular maintenance and production support to load the data in regular intervals.
• Creating Index’s, passing hints, analyzing the table statistics and Table partitioning.

ENVIRONMENT: Oracle 11g/10g, WINDOWS 7, SQL, PL/SQL, SQL * Plus, TOAD, SQL*Loader, Shell Scripts,, SQL Plus, SQL Developer, UNIX, Windows XP, Informatica Power center 9

Confidential, ATLANTA, GA

SR. ORACLE PL/SQL DEVELOPER

Responsibilities:

• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.
• Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle by using Oracle SQL Developer.
• Performed Tuning by using various tools like EXPLAIN PLAN, DBMS PROFILER, Indexes, Hints etc.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
• Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading .
• Extensively used Oracle 11g features like RESULTE, Compound Triggers etc.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
• Designed and implemented client-server application using Oracle Forms Builder.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Developed various new reports from scratch utilizing Oracle Reports Builder for day to day validations.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus
• Developed PL/SQL Procedures & UNIX Scripts for Automation and running files in batch mode.
• Exported reports into various formats like XML, PDF, HTML, EXCEL and MS-Word.
• Create a risk plan and list all the mitigations.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Participate in requirements review, application design review and test plan reviews

ENVIRONMENT: Oracle 11g/10g, WINDOWS 7, SQL, PL/SQL, SQL * Plus, TOAD, SQL*Loader, Shell Scripts, SQL *Loader, SQL Plus, SQL Developer, UNIX, Windows XP

Confidential, RALEIGH, NC

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Developed database objects includingtables, Indexes, views, sequences, packages, triggers and proceduresto troubleshoot any database problems.
• CreatedSQL*Loaderscripts to load data into the temporary staging tables.
• CreatedCustom Triggers, Stored Procedures, Packagesand SQL Scripts.
• Involved in uploading of the data from flat files into Databases andvalidated the datawith PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Created custom PL/SQL procedures to read data from flat files to dump into Oracle database using SQL * Loader.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed DatabaseTriggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects includingtables andviews.
• Worked on variousbackend ProceduresandFunctionsusing PL/SQL.
• Developed the forms and Reports as per the requirements.
• Involved in Requirement gathering and creatingDataflow Diagrams, ER diagramsand database diagrams using Oracle Designer.
• Involved inShell scriptsto automate the loading, balancing and extraction process
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• Managing Version Control Tool like Clear Case and Start Team.

ENVIRONMENT: Oracle 9i/10g, PL/SQL,TOAD, MS Office, PLSQL Developer, SQL*Plus, SQL*LOADER, UNIX, Forms 10g, Reports 10g, Rational Team Concert, Informatica Power center 9, Quality Center

Confidential, MINNEAPOLIS, MN

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Developed back end interfaces using PL/SQL stored procedures, packages, functions, Object Types, DB triggers, Indexes and Collections.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Involved in accomplishing automated data extraction from various RDBMS via scripts, ETL in database usage and especially in data warehousing.
• Involved in development of User Interface Objects (Forms9i and Reports9i) and Testing of entire module.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Hands on experience working with error handling and performance tuning in TERA data queries and utilities.
• Developed Database objects like tables, Indexes, triggers for Reporting Database.
• Documented all the packages, procedures and functions involved in ETL process.
• Performed Database Application Level Tuning and Coordinated directly with the end users to understand the Business Requirements and convert them into functional and technical specifications.
• Proved to be a responsible resource to handle performance tuning of SQL queries andPL/SQLstored procedures using Indexes and optimizing hints.
• Responsible for migrating the folders, mappings and sessions from development to QA/production.
• Maintained performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, SQL Trace and TKPROF, Indexes and Clusters.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS & IOTs.
• Create reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Created reports using data providers like universes, freehand SQL.
• Good in optimizing SQL queries by reading Explain plan statistics.
• Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
• Implemented SQL*Loader direct path option for bulk inserts into database.
• Involved in designing new universes and modify existing universes using features like aliases, loops, contexts, joins. Creating dimensions, measures and detail objects which are grouped into classes.
• Involved in Unit testing the Oracle developed scripts.
• Used Oracle defined packages DBMS JOB, DBMS SCHEDULER for job scheduling.
• Modifying existing scripts for query performance using TOAD.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

ENVIRONMENT: Oracle10g, SQL, PL/SQL, UNIX, Toad, SQL * Loader, Forms 9i, Reports 9i, Business Objects XiR3, Visual Studio, UNIX Shell Scripting, Microsoft Office Tools.

Confidential, FAIRFIELD, NJ

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Worked with the Business analysts for gathering and business analysis.
• Understanding logical modeling and physical modeling of application.
• Involved in meetings with end users on enhancement issues for gathering the requirements and communicating the same to development teams.
• Customized SQL scripts, packages, procedures, cursors, tables, views, Reports, Forms, materialized views and functionsas per the business requirements.
• Customized various Forms and Report according to the requirements.
• Testing of production fixes in the test environments to ensure they have resolved given issue as well as ensure production fixes do not cause other issues.
• Worked on the designing by using tools like Erwin.
• Load operational data from DB2, SQL Server, flat files, Excel Worksheets into various data marts.
• Ability to design, develop, and conduct unit test plans to ensure application code is functioning correctly.
• Monitor operational environment to ensure internal and customer Service Level Agreements are meet.
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and for better performance.
• Performed Imported various Sources (File based ETL Loading and RDBMS), Created Targets, and Transformations using Informatica Power Center 9.1 Designer.
• Imported various Sources (File based ETL Loading and RDBMS), Created Targets, and Transformations using Informatica Power Center 9.1 Designer.
• Performed Informatica Code Migration from Development/SYSTEST/QA.
• Deployed Oracle Forms and Reports into Query Direct on daily basis.
• Proficient in debugging PL/SQL packages, procedures, functions, triggers, cursors, materialized views to troubleshoot issues.
• Performed Code Optimization and Performance Tuning of the application using Explain Plan, TKPROF, Indexing and Partitioning of tables.

ENVIRONMENT: Oracle 10g, SQL Developer, TOAD, Maestro, Query Direct, SQL Plus, Forms & Reports 10g.

Confidential

ORACLE DEVELOPER

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Worked on developing a financial application system to handle all the bank transactions using SQL,PL/SQL, Developer 2000(Forms4.5 and Reports2.5) on Windows environment.
• Maintained the system application design using Designer2000 tools.
• Used SQL*Loader to load the database from flat files.
• Created new Tables, Indexes, and Sequences where needed.
• Created database triggers for data security & Consistency.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Developed PL/SQL Packages and Database Triggers.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loader and PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.
• QTC/BV instances depending on the order number environment.
• Developed a custom program for sending survey emails to customers after the service request is closed.
• Extensively used theOracleutilities such as Export/ Import, SQL*Loader, SQL Trace, TKPROF and day-to-day activities of different databases.
• Design and Developed Customized Reports.
• Worked on enhancing the existing shell scripts for automating the process of refresh of data periodically.
• Updated tables without breaking the existing functionality.
• Worked on ETL tools like Power Center, which were used for data integration and also mapping the data.
• Created Developed an Interface for creating order details in to custom extension table and for creating the notes in the and used DB- links to connect to other local and QA databases.
• Developed new functionality in the existing application as part of change requests.
• Performance tuned DB queries.
• Developed an effective Error Mechanism for the application using PL/SQL routine to send automated emails, created Error-Log Tables and used Autonomous transactions, Locks.
• Performed unit and integration testing of the applications and PL/SQL modules and used SVN for version control in team development.
• Involved in Unit testing and Integrated testing.
• Developed user interfaces using Oracle Forms.
• Customized Reports using Reports according to client requirements.
• Developed Revenue reports like Monthly and weekly Revenue, Total Revenue and Monthly Transaction and Revenue Comparison Reports.

ENVIRONMENT: Oracle 9i, SQL, SQL*Plus, PL/SQL,SQL*Loader, Microsoft Access, Microsoft Excel, Developer2000 (Forms6i and Reports26i) and Unix Shell scripting

Confidential

ORACLE DEVELOPER

Responsibilities:

• System study of existing Hungama customer service agent management system.
• Requirement Analysis and development of use cases for the new application.
• Detailed Design of application and reports and other minor functionalities.
• Detailed design of html prototypes and functionality.
• Involved in database design and development and implementation in production.
• Unit testing and Integration testing of the application.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loader and PL/SQl package UTL FILE.
• Created and used DB- links to connect to other local and QA databases.
• Developed new functionality in the existing application as part of change requests.
• Performance tuned DB queries.
• Involved in Unit testing and Integrated testing.
• Created Unix Shell scripts for automating the execution process.

ENVIRONMENT: PL/SQL, Oracle 9i, ASP, ASP.Net, VB scripts, Windows NT