SUMMARY

• Overall12 years ofITexperienceas developerin Oracle Products
• Expertise in Oracledeveloper(SQLand PL/SQL).
• Andhavingexperience on UNIXShellScripting.
• Thorough experience on software developmentmethodology, Qualityand Process.
• Expertise in the OracleDBAactivitiesand knowledgeon OracleTools. Knowledge in Oracle Golden 12c
• StrongcommunicationandManagementskills and Leadershipcapabilities Extensive experiencein supportingand developingthe Applications with the OracleData Base and schedulingthe DBjobs.
• Experience in controllingthe UserPrivilegesand monitoringthe Securityand Auditissues.
• Experience in the performanceTuning, ErrorHandlingand generatingthe Reports.
• 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 modelling for OLTP and dimension modelling for OLAP.
• 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.
• 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.

TECHNICALSKILLS:

OracleTools: SQL Developer, SQL *Plus, SQL*Loader,TOAD

ETLtools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power

Databases: Oracle 11g/10g/9i, MS Access,SQLServer,DB2/UDB,Teradata, SAP Tables and

Laguages/Utilities: SQL, PL/SQL, Unix shell scripts,PERL Scripting, Java, XML,HTML,JSP, C,C++ and Cobol

Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B DataTransformation, Informatica Power Exchange Informatica 9.1.0Developer/Analyst, TPump, Fast Load, BTEQ

OperatingSystems: UNIX/LINUX, Sun Solaris, WINDOWSNT/XP

Middleware: Oracle Identityand AccessManager OIM, OAM,Sun Java System,Sailpoint

PROFESSIONAL EXPERIENCE

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

Confidential

Responsibilities:

• Developed PL/SQL procedures,functionsand packages forprocessingbusinesslogic in the database.
• Procedures and packages being called by using the Shell Scripts,perl scripting, which was written in Unix.
• Perlscripting was used to execute the C and C++ programs which in turn shell scripts are going to execute the data extractions.
• Scheduled the batch jobs to execute the DB jobs using the DB schedulers.
• 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.
• 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.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• 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
• Writingunit/integration testcases anddonetheunittesting/Integrationtestingto achieve the functionality.
• Leadingthe DBteam, coordinatingwith frontendteamand deliveredthe good qualityDefectfixingduringSystemIntegrationTesting(SIT)and UserAcceptanceTesting(UAT).
• Providedthe postproduction supportand preparedtheknowledge basedocumentforsupport people tocrossverifythefiles.
• Developed newmodules, whichenhancedand improved thefunctionalityof the

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting

Confidential

Responsibilities:

• Developed PL/SQL procedures,functionsand packages forprocessingbusinesslogic in the database.
• Preparedthe UnittestCases and coordinated with theQAteamto testthetestcases.
• Perl Scripting was used to execution for batch jobs in C and C++.
• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using ParallelQueries, Javastoredprocedure, 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.
• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.
• Used SQL Server SSIStool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.
• Designed and developed Oracle forms & reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• 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 datastructures.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Developed UNIXShellscripts to automate repetitive databaseprocesses.

Environment:Oracle10g, LinuxE2.4TOAD7.6,OracleDeveloper,OracleIdentity Management OIM Confidential

Confidential

Responsibilities:

• Application, supportedthe dailyproductionissueson Oracle,PL/SQL, and
• LDAP (workingontickets).
• Perl Scripting was used to execution for batch jobs in C and C++.
• Involved in bugfixesoftheapplication on Priority.
• Responsible for project planning and managing a full lifecycle APS implementation of Identity Matching (Discovery through Production) using Initiate Master Data Service as subscriber data warehouse and identity matching engine.
• Developed Solution Architecture pertaining to overall Enterprise and Business Architectural models.
• Responsible for planning and managing a technical team consisting of 8 resources in identification and remediation of incorrect SSO data forall the Oracle users.
• Road mapped 5 year Identity and Access Management architecture and work streams for presentation
• Implemented Oracle Identity, Access, Identity Federation and Role Manager (previously Bridgestream) in a Proof of concept environment.

Environment:Oracle10g, LinuxE2.4TOAD7.6Oracle Developer

Confidential

Serverto APS Server

Responsibilities:

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using ParallelQueries, Javastoredprocedure, 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.
• Involved in creating UNIXshellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.
• Perl Scripting was used to execution for batch jobs in C and C++.
• Used SQL Server SSIStool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.
• MaintainingOracle business flows oftheapplication.
• Deployed the code successfullyon Production Server.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows 2000, Toad

Confidential

Responsibilities:

• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.

6Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows 2000, Toad

Confidential

Responsibilities:

• CodingPL/SQL Procedures, Functions, PackagesandShellScripts.
• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using ParallelQueries, Javastoredprocedure, HTPPackage and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.
• Used SQL Server SSIStool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.