Summary:

• 7+ years of progressive experience as an Oracle PL/SQL Developer in the areas of Analysis, Design, Implementation and Testing.
• Expertise in using Oracle 9i/10g/11g (XML-DB and TimesTen) databases.
• Strong experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers and Indexes.
• Well-versed in using tools like SQL*Plus, SQL Developer and Toad.
• Experience in designing, modeling, creating and maintaining Oracle database using data modeler Sql Developer Data Modeler (2.0/3.0).
• Very Strong in resolving performance issues in SQL, PL/SQL by using Explain Plan, TK Prof, Hints and Index Creation Techniques.
• Experience in handling all XML specific storage models (Unstructured, Structured - Schema Based and Binary XML-11g )
• Solid Experience in working with Bulk Binds, Bulk Collects, Oracle Collections like Index-by tables, Nested tables and Varrays
• Experience in UNIX Shell Scripting.
• Excellent team player with problem-solving and trouble-shooting capabilities.
• Possess good communication and inter personal skills to interact with all levels of management.

Technical Skills:

Oracle Tools:

SQL*LOADER, SQL Developer, SQL Developer Data Modeler, JDeveloper

Third Party Tools:

TOAD, FileZilla, Putty, PLSQL Developer

Languages:

SQL, PL/SQL, T-SQL, DB2

Databases:

Oracle 11g/10g/9i, SQL Server 2005-2008

Microsoft Tools:

MS-Visio , MS-Office

Operating System:

UNIX (Solaris, AIX), Windows 9x/XP/VISTA.

Internet Languages:

HTML, JavaScript, XML, XML DOM, XML Schema, XPath, JSON

Work Experience:

Confidential,San Jose, CA Aug’11 to Till date
Oracle XML-DB Developer

Responsibilities:

• Coordinate with business users in gathering business requirements and translating them to technical specifications for the IronPort Data Migration.
• Developing and Maintaining Oracle Integration Packages to transfer data across different databases and sources for the EDMS (Enterprise Discount Management System)application.
• Responsible for creating and maintaining PL/SQL packages for the SEARCH functionality of the EDMS application.
• Developing PL/SQL Server Stored Procedures, Functions and Triggers based on the database requirements.
• Prepared Proof of Concept (POC) Environment, Configuration of the Lucene Domain Indexes in Oracle 10g.

Environment: Oracle Database 10gR2, Oracle Applications R11.5.10.2 (OKC, CSI), TOAD 9.1, Java/AJAX, JavaScript, Spring, Log4j, Dhtmlx grid, Eclipse, HP-Quality Center

Confidential,Ann Arbor, MI Nov’10 to Jul’11
Oracle XML-DB Developer

Responsibilities:

• Worked extensively in Oracle 11g Binary XML database.
• Worked on Querying and manipulation of the content using XQuery/xPath and XSLT
• Developed Drop Off Packages as an Outbound Interface to provide Data to the dependent Environments.
• Extensively Used the DBMS_XMLGEN and DBMS_XMLSTORE package to generate and insert XML files in Oracle 11g.
• Involved in the Re-Design of the XML Schema for the Content Store XML-Database.
• Developed PL/SQL API’s to provide the linking information in the form of XML’s.
• Monitored Indexes (XMLType: XMLIndex) and analyzed their status for performance tuning and query optimization
• Responsible for Re-Outbounding the Content Store Documents to the E-Feeds Pipeline.
• Responsible for SQL tuning and optimization using Explain Plan, TKPROF utility and optimizer hints.
• Creating and translating business process specifications into design specs and XML business rules.
• Automated Korn Shell Scripts to generate the Router Reports on a daily basis.

Environment: Oracle 11g R2 XML-DB R11.2, SQL, PL/SQL, PERL 3.0, SQL*Loader, Java, SQL Developer Data Modeler 3.0, HP-QC, UNIX(Solaris)

Confidential,Miami, FL Mar’ 10 to Oct’10
Oracle XML-DB Developer/ Data Modeler

Responsibilities:

• Designed the XML database for Conditional Assessment and defining the various data elements for the system based on the requirements.
• Developed an out-bound interface to the SAMS Application.
• Extensively Used the XML SQL Oracle (Extract, ExistsNode, ExtractValue, XMLSequence, AppendChildXML) functions to generate, insert and manipulate XML files in Oracle 11g XML-DB.
• Developed a PL/SQL package to provide an interface for the SAP-ONE payment processing system.
• Extensively Designed the Contracter Management Module for the Demand Side Management Application.
• Configured the TimesTen Cache groups and assigned them to Cache Grids for real time access of data at the application tier.
• Responsible for SQL/PLSQL package tuning and optimization of the already existing code.
• Translated business requirements into code changes (existing procedures/triggers).
• Performing detailed analysis of the ETL processes including Oracle stored procedures and packages, Informatica mappings , Kshell scripts.
• Developed automated Korn Shell Scripts to schedule the load of flat files for Conversions and Interfaces.
• Gave technical presentations on Oracle XML-DB and TimesTen database operation

Environment: Oracle 11g R2 XML-DB, TimesTen (IMDB Cache) R10.2, SQL, PL/SQL, SQL*Loader, CONTROL-M (4D), Java, SQL Developer Data Modeler 1.0, Informatica Power Center 8.5, HP-QC, UNIX(AIX).

Confidential,Houston, TX Dec’ 09 to Feb’ 10
Oracle Developer

Responsibilities:

• Developed SQL*Loader Control File according to the mapping information to populate the custom load tables.
• Developed PL/SQL program to perform Data Validations in the custom staging tables for the validation of the purchase order.
• Developed a Custom Package which parses and compares fields from a xml using DBMS_XMLDOM package.
• Developed and Optimized Contractor Management package making use of Bulk Collect and Bulk Insert features in PL/SQL.
• Developed Shell Scripts to archive, move files from staging directories to custom top for automating interfaces.
• Responsible for performing code reviews.
• Involved in fixing bugs during system testing and also in Post-Production Support of the PL/SQL code developed in 10g.

Environment: Oracle 10g XML-DB, SQL, PL/SQL, SQL*Loader, Oracle Applications R12.0.3, Informatica Power Center 8.5, ERwin, UNIX, TOAD

Confidential,Datyon, OH Mar’08 to Jul’ 08
PL/SQL Developer

Responsibilities:

• Developed and tuned SQL, PL/SQL Triggers and Procedures.
• Worked with Application Team and Testing Teams to ensure interfaces and data loads are accurate as per the design specifications
• Responsible for performing code reviews.
• Used dynamic SQL for DDL commands in PL/SQL.
• Used PVCS to check-out and check-in modules for version control

Environment: Oracle 9i, SQL, PL/SQL, SQL Navigator, Toad, Forms 6i, Reports 6i, Discoverer 9i, UNIX

Confidential,New Delhi, India Apr’ 03 to Mar’ 07
PL/SQL Developer

Responsibilities:

• Involved in Analysis, Design, Coding and Testing of the Application.
• Prepared ER Diagrams and Data Flow Diagrams based on the Requirement.
• Developed User Interface using Oracle Forms and customized the existing Forms for Enhancements.
• Used SQL*Loader to load bulk data from various Flat files.
• Used PL/SQL programming to develop stored procedures, functions and database Triggers including Standard packages like DBMS_SQL, DBMS_JOB and UTL_FILE.
• Involved in fixing bugs during system testing and also in post-production Support.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Forms 6i, UNIX Shell Scripts, Toad

Education:

• M.S in Electrical Engineering