Professional Summary :

• Around 10 years of experience with expertise as Oracle SQL / PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server.
• 8 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, and Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created 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 forOLTP 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 ETL techniques and Analysis and Reporting including 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:

Databases: Oracle 8i/9i/10g/11g SQL, PL/SQL, Stored Procedures, Triggers , MS SQL SERVER 2000/2005/2008, DB2/UDB, Teradata, SAP Tables and MS Access. Operating System : UNIX AIX, Windows XP/2000/NT/95/98 Servers : RS 6000 AIX 4.3.3, IBM Infinity Server, Domino R5 5.0.8 Server, Domino R6 6.0 Server, Intel X 255 series servers, LTO 3853, Fast 200, TSM server, AIX, Win NT Databases : Oracle 9i/10g/11g, DB2 UDB , MS SQL, CM : Start team, Visual Source Safe VSS 6.0, TOAD Other Tools : Crystal Report, Rational Rose, TOAD, Putty, Telnet, Load Runner, WIN Runner, PVCS tracker, PMIS project management information system

Professional Experience:

Confidential

Responsibilities:

• Gathered project requirement information from users and thoroughly analyzed the requirement
• Involved in all phases of SDLC Software development life cycle from design to support
• As part of ETL process, loaded data from Oracle tables into target Oracle based Enterprise Data Warehouse
• Created Tables, SQL scripts, indexes, Views, Sequences as per the database design
• Created Packages, Stored Procedures, Functions as per the ETL framework design
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility
• Responsible for monitoring and troubleshooting daily processes in Production environment
• Prepared Unit Test plans for data validation
• Fine tuned database, queries, transformations and mappings for better performance
• Responsible for unit testing and validating the data loaded in to Target tables by using excel, SQL queries in TOAD, SQL Plus and by generating reports using Business Objects
• Designed new database tables and modified existing ones to meet business information needs. Created and modified indexes, synonyms as necessary
• Designed and Maintained Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions

Environment: Oracle 9i/10g, SQL Server 2008, PL/SQL, SQL, SQL Plus 9.2, Toad 9.1, Informatica 8.6/8.1, Business Objects 6.5, OBIEE Oracle Business Intelligence 10.1.3.4.1 , Windows XP, Sun Solaris

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.
• 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: VB 6, Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL Loader, SQL Navigator, Crystal Reports, TOAD

Confidential

Role : 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.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• 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.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• 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 PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

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

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in developing SQL Loader scripts for data loading.
• Created Shell Scripts to automate batch jobs.
• Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, TKPROF, Explain Plans and Trace Sessions.
• Rebuilding the Indexes for performance of SQL Queries with the help of INDEX STATS.
• Replication done by Materialized view.
• USED Pragma Exception INIT directive to associate selected exception name with oracle data base error number and used RAISE APPLICATION ERROR to error message at run time.
• Used BULK SQL and BULK BINDING to minimize the execution time of PL/SQL code.
• worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program
• Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation, and Tuning computation-intensive PL/SQL Code. .
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance
• Worked on PL/SQL Tables, Records and Collections.
• Created database objects like tables, views and used them to generate reports based on requirements using crystal reports.
• Worked on Database Link to import/export data.
• Used Pragma Exception INIT directive to associate selected exception name with oracle data base error number
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

Environment: Oracle 11g, UNIX/LINUX RHEL5, Oracle Enterprise Manager, Win CVS, ERWIN 3.5, Toad 7.5, Crystal reports 9.0, ASP.NET 4.0.

Confidential

Oracle Developer

Responsibilities:

• Maintain and modify existing Pentaho jobs and Python scripts to pull Omniture data and load into the EDW.
• Create Informatica transformations to fetch contract sales data from data sources flat files, oracle into the oracle applications warehouse.
• Create Pentaho jobs to pull listing information from MLS's and load them into the listing database.
• Create Pentaho transformations to de-dupe listing information from MLS's.
• Involved in troubleshooting and maintenance of production environment
• Analyze and compare Omniture data with internal click stream data.
• Write PL/SQL Stored Procedures, Functions, and Packages according to the ETL requirement.

Environment: Pentaho Data Integration, Informatica 8.6, Oracle 10g, SQL Server 2008, Windows XP, Toad 9.1, SQL Plus 9.2

.

Confidential

Oracle Developer

• Responsible for the analysis, designing and coding of the SQL scripts as per business need.
• Handled the client problems and troubleshoot and fixed the bugs on pro-cobol and SQL
• Ensured assigned tasks are complete within the timeframe established by the project plan
• Developed and Optimized Stored Procedures and Functions for power builder
• Wrote conversion scripts using SQL, PL/SQL, stored procedures,
• Resolved and fine-tuned mal-performing data queries
• Unit testing with support during product testing
• Use cases and component diagrams for cross functional units
• Bug fix / Maintenance and Overnight batch support with effective root cause analysis
• SQL tuning/Scripting
• Audit reports and Improvement plans on workflow management
• Developing new modules which were time critical
• Improvement plan for reduction of incoming tickets and reusable mail drafts for good written communication
• 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.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.