PROFESSIONAL SUMMARY:

• About 6 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications and Data warehouse environments using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance AnalysisandSQL query tuning using Query Optimizer, Indexes, Clusters, SQL Access Advisor, Hints, Explain Plan, and Tk - prof
• Involved in all phases of software life cycle- Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and Support
• Extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning
• Strong knowledge in front end development using oracle forms/reports6i/9i/10g
• 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
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance
• Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development using Toad, SQL Plus, and PL/SQL Developer
• 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).
• Scheduled complex cron jobs on UNIX platform using crontab format
• Good experience with Agile Scrum Methodology and Experience in Export, Import and SQL*Loader Utilities
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data which is stored at the OS level
• Experience with oracle supplied packages likeDBMS SQL,DBMS JOBandUTL FILE
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Experience with Data modeling using ERWIN 4.0/3.5.2.
• Experience in Data Migration across various databases as well as within the same database across different systems
• 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).
• Good knowledge of Database Administration.
• Extensively used DBA Utilities, RMAN, Oracle Enterprise Manager, and Export/Import, Performance Monitoring, Backup & Recover.
• 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

TECHNICAL SKILLS:

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

GUI’S: Developer/2000(Forms10g/9i/6i/5.0/4.5&Reports10g/9i/6i/3.0/2.), 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

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages and Procedures accordance with Business Requirements and also to extract the data from different sources and load it into data warehouse
• Involved in redesign of the Application according to the new business requirements by creating the Partitioned tables and indexes for better performance of application.
• Involved in tuning SQL queries by using EXPLAIN PLAN.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Created various generic procedures using DBMS STATS and Rebuild Index to generate the statistics of tables and improve the performance.
• Developed many process improvements using the Bulk Collect and FORALL (Bulk Bind) methodology and also by using hints for queries.
• AUTONOMOUS TRANSACTION PRAGMA is used in the procedures to control the transactions.
• Involved in developing UNIX shell scripts for Loading Database Tables, running SQL files, Packages and Procedures.
• Loading data from flat files into database tables using SQL* Loader.
• Involved in creating the Command line, Box and File watcher jobs using the scheduler tool AutoSys 4.0 and AutoSys r11.3 versions.
• Designed the ETL mappings using Informatica tool for loading data from flat files into data warehouse.
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, maintenance, reorganization, and recovery of databases.
• Involved in unit and integration testing of the jobs and prepared documentation.
• Responsible for writing high quality and well documented code according to standards and documentation of various processes.
• Worked with a team which Upgraded Oracle DB 10g to Oracle 11g.
• Responsible for Analyzing and Implementing the Change Requests.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 10g/11g, Oracle SQL Developer, SQL Navigator, SQL * Loader, SQL*PLUS, Solaris, AIX, UNIX Shell Scripting, Informatica Power Center, SSH Tectia, AutoSys 4.0 and AutoSys r11.3.

Confidential, Hartford, CT

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Supporting legacy systems with backups of all cases to/from parallel systems.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.
• Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.
• Created Shell scripts to generate oracle reports and send to e-mail.
• ER diagrams are developed using TOAD Data Modeler.
• Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.
• Involved in creating and maintaining Partitioned Tables and Indexes for better performance of application
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Involved in handling the changes in compiling scripts according to the database changes.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

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

Confidential, Kansas City S

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.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• 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 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 9i/8i, Reports 6i, PL/SQL, SQL Loader, SQL