SUMMARY

• 6 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
• Extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning.
• Involved in all phases of software life cycle - Requirement gathering and Analysis, Databasedesign, Databasedevelopment, Applicationdevelopment, Test, Implementation and Support.
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports), Forms and Reports 9i, Oracle Developer Suite10g.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development using Toad, SQL Plus, and PL/SQL Developer.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Strong Data warehousing experience specializing in RDBMS, ETL Concepts also performed ETL procedure to load data from different sources into data warehouse using InformaticaPower Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Good experience with Agile Scrum Methodology and Experience in Export, Import and SQL*Loader Utilities.
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Ability to explain technical concepts and communicate with users and system administrators at all levels. Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Extensive experience on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/ 8i/8.x/7.3,DB2,Sybase

GUI’S: Developer/2000(Forms10g/9i/6i & Reports10g/9i/6i),owb

LANGUAGES: SQL, PL/SQL, C, HTML, XML, java script

ADMINISTRATION: SQL*Loader, Export, Import.

Tools: TOAD,SQL*PLUS, SQL*NAVIGATOR, SQL DEVELOPER, Putty, VI Editor, forms Builder, Reports Builder, Procedure Builder, Graphics Builder, Import & Export utility, Erwin

OPERATING SYSTEM: Windows7/NT/XP/2003/2000, UNIX,SUN SOLARIS

ETL: InformaticaPowercenter 8.6.1, 7.2

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Oracle Pl/Sql Developer

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Wrote Package containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
• Worked on sequences, functions, synonyms, views, indexes, triggers, packages, storedprocedures, roles and granting privileges on OLTP server.
• Involved in Creation of tables, Partioning tables, Join conditions, correlated sub queries, nested queries, views for the business application development.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Analyze, design, and modify the existing educational Data Warehouse’s data structures in Oracle Database.
• Modify and develop new ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities.
• Experience with merging data files coming from the customer into the existing data warehouse.
• Worked with Oracle Enterprise Manager, Net configuration assistant.
• Logical and Physical data modeling using ERWIN.
• Created the indexes and analyzed the table for better performance.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks
• Moved the tables to different table space and rebuild the indexes.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Developed Unix Shell Scripts and loading data into the Database using SQL* Loader.
• Copying of data from development to test and production by using utilities like Export/Import.
• Used Explain plan and TK PROF for Tuning the SQL statements by creating indexes. Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Experience with Pl/SQL Tuningusing DBMS PROFILER.
• Extensive use of Optimizer Hints to tune the Sql Queries.
• Worked extensively on Exception handling to error handling and tracking.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Wrote the shell scripts and scheduled with using cronjob for the database backups and old archive log deletion. Also done the logical backup (database structure export only) of the development instances every day using shell script
• Extensive experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Involved in unit testing, integration testing, system testing.

Environment: Oracle 11g, Windows 7, Crystal Report XI, PL/SQL, SQL Navigator, SQL*Loader, SQL*Loader, Erwin 4.14,Oracle Enterprise Manager

Confidential, Downers Grove, IL

Oracle Pl/Sql Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Created process force and deployed into run time depository using ware house builder
• Involved in logical modeling and physical modeling of application.
• Used multiple operators (union, router) for loading data using owb.
• Having strong knowledge in creating and maintaining the owb
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule the information of cron entries.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas. worked with bulk collect to Implement the performance of multi row queries
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code).
• Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
• Upgraded to Forms 10g, Reports 10g, maintained and troubleshoot Oracle Forms and Reports.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Generated various analytical reports using Microsoft Access.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

Environment: Oracle 10g, Toad, SQL * Loader, Toad, PL/SQL Developer, SQL*PLUS, UNIX Shell Scripting, Oracle Reports, HTML, and XML, Informatica.

Confidential, Boston, MA

Oracle Pl/Sql Developer

Responsibilities:

• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
• Altering the database Objects to synchronize it with the new Schema created.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer, SQL* Plus, Toad.
• Involved in creating triggers, views and Materialized views based on the client Requirements.
• Understanding the business logic to modify existing SQL Code and Performance Tuning.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Used AutoSys Scheduler for batch scheduling.
• Involved in writing procedures, functions, triggers, and packages for new requirements.
• Created Records, Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Participated in Performance Tuning using Explain Plan and Tk-Prof.
• Developed and customized number of reports using Oracle Reports and Forms.
• Created number of database Triggers according to business rules using PL/SQL.
• Developed ad hoc reports using Discoverer 4i.
• Analyzing tables and indexes for performance tuning- Seasoned in optimizing Query performance using explain plan, SQL Trace and TKPROF utility.
• Involved in code reviews of other team members.
• Writing scripts for Data Staging, Loading and cleanup process.
• Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 10g, PL/SQL, SQL* Plus, SQL * Loader, TOAD, Oracle Reports, HTML, XML, Windows XP.

Confidential

Jr. Oracle Pl/Sql Developer

Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader - for different cases)
• Explain Plan, TKPROF was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Involved in creation and updates of several SQL packages and Procedures
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables
• Developed SQL*Loader programs &PL/SQL scripts to load legacy data into Oracle Apps.
• Developed reports using Reports 6i.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Participated in database development like creating PL/SQL triggers, packages, procedures function.
• Handling errors using Exceptions.

Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL Loader, SQL.