Professional Summary:

• Over 8 years of IT experience. 6 as oracle Developer, 1 year in Oracle Applications involved in complete SDLC including analysis, design, development, testing, implementation maintenance of application software
• Experience in Designing and Development of OLAP and OLTP applications and experience in building Interface/conversion/data migration in client/server OLAP environment
• Extensive experience in coding, testing, developing, enhancing, and implementing applications.
• Extensive experience working with different relational databases Oracle, DB2 and SQL Server.
• Excellent skills in implementing ETL Packages using SSIS 2008/ 2005
• Strong Experience in Database UNIX OS troubleshooting.
• Developed flashy dashboard reports for executive management using Crystal Xcelsius 4.5
• Huge experience in developing Oracle PL/SQL packages and object types.
• Proficiency in using UNIX shell scripts for testing the application.
• Experienced in working with utilities like SQL Loader, External Tables, extract and load large volume of data
• Extensive knowledge in Oracle Scheduler Windows Scheduler
• Experienced in UNIX shell scripting, Error Handling By Using Exceptions
• Excellent working skills in SQL Server and crystal reports
• Excellent communication skills and ability to lead a team
• Excellent Knowledge in Oracle - Performance Fine Tuning and troubleshooting
• Proficient working in Oracle 11g/10g/9i/8i databases using SQL PL/SQL Stored Procedures, Functions, Packages and Triggers
• Expertise in developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• In-depth Knowledge of Schema Objects Tables, Global TemporaryTables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database links and Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling, Type.
• Extract, Transform and Load legacy data into Data warehouse and develop analytical SQL queries to generate reports using data in Data warehouse and Data marts
• Expert in Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning.
• Experience in Migrating Code to different Environments from SQL Plus interface.
• Good experience in Data Warehousing this includes data analysis, data manipulation, and programming, testing, implementation and report generation
• Knowledge of Job scheduling tools Autosys,D-series,CRON to create, modify, troubleshoot jobs, schedule and automate daily/weekly/monthly/quarterly jobs
• Hands on experience in using UNIX and Shellcommands, Shell scripts to create jobs, automate processes, moving processes to background and monitoring processes.
• Very good working knowledge in ERWIN, TOAD, PL/SQL Developer tools.
• Experience in providing production support using Service Now tool and provide critical and normal patches for technical and business related bugs
• Participated in Presales activities of Mahindra Satyam.

Technical Skills

• RDBMS : Oracle 11g/10g/9i/8.1.x,DB2, SQL Server 7.0/2000/2005, MS Access
• Database Tools : PL SQL 2.0, SQL Plus 9.2, Forms 6i/5.0, Reports 3.0
• ETL Tools : Informatica 9.1.0, Ascential DataStage Standard Server Edition 7.5.1
• Reporting Tools : Crystal Reports XI,Actuate 9, SQL Server Reporting Services SSRS
• Scripting : Shell Scripting
• Languages : .NET SQL, PL/SQL, MySQL, WinSQL, Unix
• GUI Tools : Visual Basic, Oracle Forms and Reports, Oracle Toad, Developer, Putty.
• ETL : Datastage, ETL
• Data Modeling Tools : Rational Rose, Erwin
• Multimedia : HTML/DHTML, MS Office, Adobe Photoshop, XML
• Other Utilities : Toad 10.1.1.8, PL/SQL Developer, Visual Source Safe, PVCS, CVS, RationalClearCase, HP Quality Center, AscentialVersion Control, Starteam, Control-M
• Operating Systems : Sun Solaris 5.8, Red hat Linux, UNIX, Windows NT

Professional Experience

Confidential

Oracle Apps Technical Consultant

Roles and Resposibilities

• Understanding the current system of ADBandProvidingtechnical solutions, Database design for P3MF ADB Project.
• Prepared MD.40 Build and coding standards document.PreparingMD.060 Data base design document and Understanding the Functional design documents, Work allocation to team
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functionsandpackages 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.
• Extensively involved in UNIX Shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes.
• Worked on Remedy 7.5 to solve work Orders for production support
• Review the code MD.070 and TE.020 documentsprepared by team

Environment: Oracle Applications 12.1.3, Oracle 10g, Toad 8.5,, FTP, Oracle Enterprise Linux 5, Windows XP, UNIX, Putty

Confidential

Oralce/APEX Developer

Roles and Responsibilities:

• Created Stored Procedures, Packages, Materialized Views, and Indexes for implementing the business requirement.
• Worked as OralceApex developer Oracle Application Express .
• Solid understanding of inheriting PL/SQL object types, casting PL/SQL object types into descendant types, converting PL/SQL object collections into a result set, bulk operations and pipelined functions
• Created the reports for marketing group based on the Customer Experience data, which was collected by an application called n-view using Crystal Reports XI.
• Involved in design and development of management statistical reports using Crystal Reports XI R2.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Extensively worked on Query Optimization and Performance Tuning of databases.
• Deployed SQL Code and Reports to QA Dev Prod.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Managed user access, created and managed new security accounts.
• Extensively used Bulk Load, Collections, Ref Cursors and UTL FILE.
• Optimized the Query performance using Explain Plan and Hints.
• Designed the ETL jobs using Informatica to Extract, Transform and Load the data into the Oracle Staging Tables.
• Involved in resolving the defects identified in DIT, SIT and UAT environments.
• Created UNIX Shell scripts as an interface to invoke Oracle stored packages.
• Implemented automated batch scheduling using Control-M for loading inbound feeds, processing relationships and crediting and generating Outbound Feeds.

Environment: Solaris 10, Linux, Oracle 11g/10g, PL/SQL, Toad, UNIX Shell script, Control-M, Informatica, HP Quality Center QC , ClearCase and PVCS, MS SQL Server 2005/2008, SSIS, SSRS, Management Studio, ERWIN, Windows 2003, Visual Studio 2005/2008, Excel Macro 2007/2003.

Confidential

Oracle Developer

Roles and Responsibilities:

• Developed Stored Procedures, Packages and Materialized Views for implementing the UI application.
• Extensively used External Tables, Merge Statement and Global Temporary Table GTT
• Bulk Load, Ref Cursors, No Copy complier hint and VARRAYS
• Involved in Performance Tuning of the existing Stored Procedures using various Optimization techniques such as Explain Plan, Hints, Indexes, DBMS STATS, TKPROF and Autotrace.
• Involved in ownership data retrieval, smart target data generation and contact data processing.
• Implemented automated batch scheduling using crontab.

Environment: UNIX,Oracle 10g, PL/SQL, Toad, UNIX Shell script, and ClearCase

Confidential

Oracle/PLSQL Developer

Roles and Responsibilities:

• Handled Very Large Database VLDB with the Database size of 7 terabytes.
• Created Stored Procedures, Functions Packages for implementing the reporting requirements.
• Designed and implemented Account variance, Claim tracking, Claim Aging and several client facing reports for EDI and FNX fee negotiation system .
• Developed and customized reports using Crystal Reports XI.
• Used the oracle advanced features like External Tables, Merge Statement and Global Temporary Table GTT
• Optimized the Query performance using the Oracle utilities like TKPROF, Explain Plan and Autotrace.
• Involved in the recovery of Tables and data using Flashback Table, Flashback Transactions, Flashback Transactions Query, Flashback Versions Query, Flashback Query, Flashback drop Techniques

Environment: HP UNIX,Oracle 10g, PL/SQL, Toad, UNIX Shell script, Crystal Reports and VSS

Confidential

Oracle Developer

Roles and Responsibilities:

• Involved in the design for data acquisition and created technical specifications for the application.
• Designed the ETL jobs using Ascential DataStage to Extract, Transform and load the data into the Oracle based WSI Advanced Marketing Platform Data warehouse.
• Developed PL/SQL scripts, stored procedures, triggers to implement complex ETL transformations in Oracle 10g
• Used the oracle advanced features like External Tables, Merge Statement and Global Temporary Table GTT
• Involved in Partitioning for very large tables with millions of records.
• Used the techniques such as Bulk Load, Ref Cursors, No Copy complier hint to improve performance.
• Involved in design the operational process flow for the ETL jobs in Datastage.
• Designed and implemented jobs using DataStage Job sequencer.
• Executed periodic operations in DataStage Director and its run-time engine to schedule, validate, run and monitor the resulting executable versions.
• Used UNIX Shell scripting for different audit purposes as well as for running the PL/SQL scripts.
• Used Crontab for scheduling the jobs and batch job for loading the data.
• Used the Hints, Indexes,Analyze Commands, DBMS STATS,TKPROF, Explain Plan and Autotrace for Query Optimization
• Participated in building the error handling logic and Quality Metric design using the PL/SQL.

Environment: Ascential DataStage Standard Server Edition 7.5.1, Oracle 10g, PL/SQL,Erwin4.1.4.4003, AIX UNIX, Unix Shell script, Toad Ascential Version Control.

Confidential

Oracle Developer/Support Analyst

Roles and Responsibilities:

• Understanding and Analysis of the requirement specifications of the client.
• Designed and developed PL/SQL functions, stored procedures, cursors, packages, triggers.
• Involved in writing complex queries to generate processes as per client request.
• Created Sequences to generate unique numeric values.
• Tuned complex SQL statements, complex joins co-related sub-queries which were taking too much time to run by using Explain Plan and Hints.
• Rebuild Indexes for better performance during query execution.
• Wrote extensive Exception handling procedures to handle exceptions.
• Involved in creating different kinds of partitions for managing large tables.
• Used TOAD for creating PL/SQL and SQL Scripts to debug and test the code
• Enforcing data Integrity using integrity constraints and database triggers as per data model.
• Utilizing Built in Oracle Packages like UTL FILE, DBMS OUTPUT for better debugging.
• Generated Unix shell scripts to automate batch jobs and loading process.

Environment:UNIX, Windows XP, Oracle 10g, PL/SQL, Toad 9.0, HP Quality Centre, Autosys Job Scheduler

Confidential

PL/SQL Developer/Database Designer

Roles and Responsibilities:

• Used Dynamic SQL for DDL commands in PL/SQL.
• Creating and managing schema objects like tables, indexes, views, synonyms and clusters.
• Actively involved in detail design, development and testing phases of SDLC.
• Interacted with user to identify the user requirement from various groups/level of user and defined Entity relations ship diagram.
• Used various kinds of control structures including case, decode, if-then-else, for loops, while loops while developing procedures.
• Wrote Cursors for acquiring information to be used in calculations written in stored procedures.
• Writing Unit Test Cases and Test Scripts for Manual Testing.
• Debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database

Environment:Oracle 9i, PL/SQL, UNIX, Toad 8.0, Windows NT 4.0, Oracle D2K Form 5.0

Confidential

Oracle Developer

Roles and Responsibilities:

• Evaluated the tools for Data migration Oracle Migration Workbench and Stored Procedure migration Swiss SQL and SQL Ways .
• Handled Very Large Database VLDB with the Database size of 5 terabytes.
• Migrated the Stored Procedures using Swiss SQL.
• Analysis of DB2 procedures and converted to oracle PL/SQL Procedures for the ETL, NMR Modules.
• Used the Oracle utilities like TKPROF, Explain Plan and Autotrace for Query Optimization.
• Created Partitions on database tables for quick accessing of Details.
• Involved in taking regular database backups using Data Pump utility.
• Involved in Unit testing and Integration testing for the ETL and NMR Modules.
• Involved in the System testing, Data Analysis and support for NMR application.

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripting, Sun Solaris 5.8, VSS and PVCS