SUMMARY

• Over 7 years of experience in designing, developing and implementing database applications and solutions as ORACLE PL/SQL DEVELOPER.
• Strong knowledge in writing technical documents based on business requirements.
• Have expertise knowledge in Oracle Database and Oracle - RDBMS concepts for reporting solution for Operational Reporting System.
• Hands on experience writing queries, Stored Procedures, Functions, PL/SQL Packages and Triggers in Oracle and also reports and scripts
• Proficient working experience in SQL, PL/SQL, TSQL, Stored Procedures, Functions, Packages, DB Triggers and Indexes.
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Good Knowledge in RDBMS concepts and worked extensively on Oracle databases like Oracle 8i/9i/10g
• Working Knowledge on UNIX Shell Scripting.
• Working Knowledge on Autosys for job scheduling.
• Strong in using tools such as PL/SQL developer, SQL*Loader, TOAD and SQL*Plus.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Knowledge on DBA activities such as Performance Tuning, Backup and Recovery.
• Good Working Experience in Forms 6i/9i/10g & Reports 6i/9i/10g for both development and customization of several Reports as per client specifications.
• Experience on Logical & Physical design of Databases, Data Modelling, Conceptual Design and Data Architecture and extensive use of Erwin and MS VISIO as a modelling tool. Understanding of Star Schema and Snowflake Schema.
• Sound understanding of other Relational and Normalized databases such as MS SQL Server, Sybase and MS Access.
• Excellent understanding in the working of the Data Warehousing Environment, its Components and Architecture.
• Experience in Java and automating routine tasks using HTML, UNIX, Shell Scripting, and Java Scripting.
• Technical documentation of different lifecycle deliverables and user manuals.
• Worked on Logical design, Resource Planning, code development, testing, implementing and maintenance.
• Worked on 24*7 environments to provide production support.

TECHNICAL SKILLS

Programming Language: Java, SQL, PL/SQL, Shell Scripting and PERL.

Databases: Oracle 11g/10g/9i, SQL Server

Operating System: Windows, UNIX, Linux.

Oracle Tools: SQL Navigator, TOAD, SQL Developer.

SDLC Methodology: Agile.

Version Control Tools: Clearcase, SVN (Sub versioning).

Data modeling Tools: Erwin and Power Designer

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Oracle PL/SQL Developer

Responsibilities:

• Worked on ODE (On Demand Engine) which process the reads and meter control requests on Demand.
• Worked on the automation of the deploy process.
• Worked on creating the various monitors with predefined rules.
• Involved in creating schema objects like DB-links, synonyms, sequences, views, database Triggers, Stored Procedures and Functions.
• Worked on AutoSys for scheduling, monitoring, and reporting of jobs.
• Monitor Production Jobs to ensure successful execution.
• Use TOAD and PL-SQL to run SQL and PL/SQL code to manipulate the databases in all environments.
• Optimize and generate Explain plans for slow running Queries and modify them accordingly.
• Conversion of Oracle Reports to XML formats.
• Design, develop, review, test and rewrite programs and databases.
• Fixing the problems related to Oracle Forms, Reports and database Object (Packages and Procedures, Functions).
• Worked on localization of various data elements
• Worked on various performance improvements for the UI API packages for search and display details.
• Worked on Various Adapters to load the data into core tables

Environment: ORACLE PL/SQL, Java, Shell Scripting, Perl, PL/SQL, Oracle 11g, Toad, Eclipse, UNIX, LINUX and Web sphere and Web logic

Confidential, Irving, Texas

Oracle 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.
• 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.
• 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).
• Used Explain Plan, Analyze and Hints to tune queries for better performance and also Extensive Usage of Indexes.
• Worked with SQL loader and control file 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 multiple tables in OLTP and OLAP.
• Created database objects like SQL Queries, tables, Joins, Stored procedures using Oracle Utilities like PL/SQL, SQL* Plus, SQL Server.
• Data Warehouse is used for Data integration technology and processes that are needed to prepare the data for use.

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, Lincolnshire, IL

Pl/SQL Developer

Responsibilities:

• Involved in Coding, Data conversion, Development and Implementation.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Involved in creation of Sequences for automatic generation of numbers.
• Created tables, Functions, Triggers, procedures for creating some complex reports.
• Involved in all phases of SDLC including designing, coding and testing.
• Encrypted the PL/SQL code using wrapper.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Involved in writing unit test cases
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS to tune queries for better performance and also extensive Usage of Indexes.
• Loaded data from flat file into Database using SQL*loader.
• Used DBMS JOBS package for scheduling.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collect to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL Developer, SQL*PLUS, SQL Developer, PL/SQL Developer, Windows XP, MS Office 2010.

Confidential

Pl/SQL Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using SQL and PLSQL.
• 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.
• Created 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, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• 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 on the performance tuning of the programs, ETL Procedures and processes.
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions.
• Data migration and conversion done utilizing Oracle utilities: Export/Import.
• 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 11g, SQL Developer, SQL*PLUS, SQL Server, PL/SQL Developer, Windows XP, MS Office 2010.