SUMMARY

• 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Embarcadero ER Studio, ERWIN, Toad Data Modeler.
• Very good experience in Data warehouse concepts, ETL.
• Strong experience in creating Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization CBO .
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in working with ETL tools-informatica.
• Hands on experience with the Reporting tools such as Cognos.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS

Oracle 7.x/8i/9i/10g/11g SQL, PL/SQL, Stored Procedures, Triggers , MS SQL SERVER, 2000/2005/2008, DB2/UDB, Teradata, SAP Tables, MS Access, Informatica Power Center 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame, Oracle Change Data Capture CDC , AB Initio 1.8 , SQL Loader, Business Objects Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5, Business Objects Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5, SQL, PL/SQL, Unix shell scripts, Java, XML, C, Cobol, AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ, UNIX Sun Solaris, LINUX, HP UNIX, AIX , Windows NT/98/95/2000, Windows XP.

CHRONOLOGICAL SUMMARY of Experience

Confidential

PL/SQL Oracle 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.
• Developed operational and transactional data models logical and physical using Erwin 7.3.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• 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.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Partitioned the fact tables and materialized views to enhance the performance.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Updated ERWin meta model to support data quality and integration.

Environment: Oracle 11g, SQL Plus, TOAD, SQL Loader, Erwin 7.3, SQL Developer, EXPLAIN PLAN, AUTOTRACE, SQL Trace, TKPROF, PL/SQL, Shell Scripts, UNIX, Windows XP

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for dataware housing. Extracted data from the XML file and loaded it into the database.
• Used Informatica Power Center for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created management analysis reporting using Parallel Queries, Java stored procedure, HTPPackage and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Designed and modeled data warehouse in normalized schema. ERWin
• Designed and developed Oracle forms reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle SDLC .
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, ERwin, Informatica, SQL LOADER, Oracle Streams 10g Replication , SQL PLUS, HTML, SQL Server SSIS, TOAD, ETL, XML, HP-UNIX shell scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API's like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Used Oracle JDeveloper to support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Worked on ERWin 7.2 Data Modeling.
• Responsible for the Star schema data model ERWin .
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved in Logical Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications.
• Used SQL Loader as an ETL tool to load data into the staging tables.
• Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Provided user training and production support.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, ERWin 7.2, Visual Basic 6, Reports 9i, SQL Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in interacting with the end-user client to gather business requirements.
• Resolved application problems to maintain high level of customer satisfaction.
• Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL Loader.
• Managed tables, indexes, constraints, views sequences, synonyms and stored program units.
• Developed database triggers required for the Integrity constraints.
• Created Logical and Physical Models using ERWIN.
• Performed performance tuning and query optimization.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Written PL/SQL cursors for transaction processing.
• Written Queries for the management in the form of stored procedures and packages.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Developed batch programs in Pro C and wrote Scripts to run them on Unix Cron Scheduler.
• Created partitions on the tables to improve the performance.
• Extracted data from Flat files, Oracle and SQL server sources.

Environment: Oracle 9i, Solaris 5.9, SQL Developer 1.1, Serena PVCS, Oracle, Enterprise Manager, Windows 2000, Oracle forms 9i