SUMMARY

• Over 7+ years of experience in IT field as Oracle PL/SQL Developer.
• Expertise in RDBMS concepts such as Schemas, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, Anonymous Blocks, Directories, Sequences, and Synonyms.
• Extensive experience in developing and modifying PL/SQLobjects such as Stored Procedures, Functions, Packages, Views, Materialized Views, and Triggers.
• Experience in working Oracle 9i, 10g, 11g and various database tools like TOAD 9.0 and SQL Developer.
• Hand full of experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Proficient in all the phases of Software Development Cycle (SDLC) and implemented various methodologies like Waterfall, Spiral, and Agile SCRUM.
• Working knowledge of Extract Transformation Load (ETL) process to transfer data between different databases.
• Implemented various Error/Exception Handling methods using system - defined exceptions and user-defined exceptions.
• Solid experience as DBA, Performance Tuning Specialist, PeopleSoft Administrator, Oracle DBA.
• Experience in Performance Tuning using Explain Plan, TKPROF, ADDM, Bulk Collects, and various types of Hints, Partitioning and Indexes.
• Excellent experience in creating Test Cases, Test Plans based on requirements.
• Expertise using defect tracking tools like Quality Center and Clear Quest.
• Involved in the continuous enhancements and fixing of production problems.
• Proficient used SQL queries for back end testing to validate the data mapping between the front end and the back end.
• Capable of working under pressure and with minimum supervision.
• Experience in Coordinating with offshore team on daily basis for Project Planning and Execution.
• Excellent problem solving, and analytical skills.
• Quick Learner, self-motivated, ability to work independently and as well as in a team environment with excellent team spirit.
• Diverse experience utilizing Java tools in business, Web, and client-server environments including Java Platform, Enterprise Edition (Java EE),

TECHNICAL SKILLS

Operating Systems: Windows 98 / NT / 2000 / 2003 / XP, Vista, and 7, Solaris, RHEL, AIX

Databases: Oracle, SQL Server, DB2, MS Access

Languages: C, C++, SQL, PL/SQL

Tools: TOAD, PL/SQLdeveloper,SQLDeveloper, SSIS, DBA

ETL Tools: Informatica

Web Technologies: HTML, XML

Testing: Manual, Automation

Testing Tools: HP Quality Center, Mercury QTP, Clear Quest

Packages: MS Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

PL/SQL Developer

Responsibilities:

• Analyzed System Requirements to create high level and detail design documents with the assistance of requirements team and Architects.
• Worked closely and supported members of teams such as Architecture, Change management, Database Management, Technical operations, System Test, UAT, Requirements and Business teams during entire life cycle of the project.
• Developed complex applications using Oracle 11g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions, Triggers, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Used concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Helped testing team in setting up environments by doing data refresh.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Developed Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
• As a key PL/SQL developer, defined the required analytics to design, develop financial routines, and assisted various work streams in identifying, and resolving data irregularities.
• Establish management reporting processes and requisite supporting technology.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
• Created SQL scripts to perform unit and component testing financial calculations such as, Interest receivables, Exadata.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Used Explain Plan, Analyze, Hints to tune queries for better performance and also Extensive Usage of Indexes.
• Worked with SQL loader and control files to load the data from external sources to different schema tables.
• Implemented features including Materialized Views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP.
• .Export/Import of Oracle databases
• Tuning of SQL quires

Environment: Oracle 10g/11g, PL/SQL Developer, SQL *Plus, MS-Office, Toad(9.0), MS Access, SSIS, Data Warehouse, ETL Tool, UNIX/LINUX, MS Office, Agile Scrum, Windows.

Confidential, Pittsburgh, PA

PL/SQL Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using SQL and PLSQL.
• Created database maintenance plans for the performance of database including database integrity checks, update database statistics, re-indexing and data backups.
• Interacted with Business Analysts and Users in requirement gathering.
• Translated user requirements into data flows, detail technical specifications and database requirements.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Developed, modified, and optimized complex queries for data retrieval and modification. Optimized and Tuned SQL Queries by running Explain plans.
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Involved in load testing by creating application users, modify application data, refreshing database for Load Runner and troubleshoot.
• Created tables with complex constraints applicable to the business rules.
• Created tables, Table spaces, schemas, views, packages, stored procedures, triggers, functions etc. using TOAD.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.
• Data migration and conversion done utilizing Oracle utilities: Export/Import.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Involved in implementations, maintenance and support of PeopleSoft HRMS projects.
• Wrote control files for data loading using SQL*Loader.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL *Plus, MS-Office, Toad, MS Access, ETL Tool, UNIX/LINUX, MS Office.

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

• Design Technical Specifications from Functional Specification (Detail Design) documents.
• Mapped the extracted data from source systems and load it into the target systems after applying the required transformations using ETL tool Informatica Power Center.
• Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Involved in Integration testing, System testing and Implementation.
• Proficiently developed test cases in Quality Center.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Migrated Projects from Development Database into QA Testing Databaseand then into Production on daily basis.
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle SQL & PL/SQL, TOAD, MS-Windows, SSIS.

Confidential, Mclean VA

PL/SQL 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 onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Creation of database objects liketables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential

PL/SQL Developer

Responsibilities:

• Created many Generic Stored Procedures, Functions, Database Triggers, Packages, tables, indexes, views, synonyms, sequences using SQL and PL/SQL.
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• Analyzed the system requirements and performed logical and physical design of the database.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
• Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
• Exception handling and cursor management in PL/SQL.
• Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
• Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
• Designed Conversion and Interface Programs using PL/SQL procedures and packages.
• Analysis, Development, Testing and Implementation using Oracle 10g/9i.
• Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), and SQL Server Integration Services(SSIS)

Environment: Oracle (9i/10g), PL/SQL, Oracle Performance Tuning, Forms & Reports, PL/SQL Developer, TOAD, Query Analyzer.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• UpgradedOracle 8i to 9isoftware in different environments for latest features and also tested databases.
• Developed and modifiedtriggers, packages, functions and stored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Worked on XMLalong with PL/SQL to develop and modify web forms.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creating indexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle (9i / 8i), SQL, PL/SQL, SQL*Plus,