Summary

I have over 10 years US experience in Oracle database development and proficient in Linux/Unix/Aix and Windows environments. Having technical expertise in Oracle sql, pl/sql coding, debugging and performance tuning of applications. Hands on work experience in design, development, testing and implementation of OLTP and OLAP applications. Developed lot of program units stored packages, stored procedures and stored functions based on business application requirement OLTP and worked on interface programs to generate multiple data files utl file and connected disparate applications. Change data capture CDC implemented using the date data type column in Oracle entities. Ref Cursor used to pass the data from Oracle backend to .NET frontend. Oracle utilities External table and SQL Loader used extensively to load data from external source feed into Oracle transient tables. Experience with storing and query with XML data type in DB. Familiar with Logical and physical data model concepts. Created/enhanced both functional and technical specification based on business requirements. Used most of the oracle schema objects including tables, views, synonyms, indexes, database links, database triggers, clusters, materialized views and etc. Table partition created for very large volume of data usually in multi millions. I am familiar in SQL tuning best practices. Collaborated with multiple team managers and within the team members effectively. Having good communication, interpersonal skills, analytical and organizational skills. I have worked as senior oracle professional with direct clients of Priceline.com, Verizon and Unilever. Currently working as senior Oracle pl/sql developer at Pearson PLC in New York City, NY.

technical skills

• RDBMS : ORACLE 11g/10g/9i/8i/8.0/7.3/7.1
• Languages: PL/SQL 11g/10g/9i/8i/7.3x/7x , SQL, XML, HTML, JAVA, J2EE, JDBC, JavaScript, CSS.
• Shell script: Korn Shell script, Bash shell script
• GUI/ Tools: Developer 2000 Forms6i/4.5/3.0, Reports6i/3/2.5
• ETL Tools : Informatica Power Center 6.1/5.1, and Talend Open Studio 5.5
• Data Quality: Informatica Data Quality IDQ
• Data Virtualization: Composite 6.2.3
• Data Model: Erwin, SQL Developer
• Messaging Protocol: JMS, MQ, Knowledge in AQ.
• Others : Toad, Sql developer, Sql navigator, Sql plus, Putty, Filezilla, VSS, VI editor

Project Detail

Confidential

Title - Senior Oracle Developer

Environment Oracle 11g, SQL, PL/SQL, SQL Developer, Toad, Composite data virtualization, Korn UNIX Shell, Putty, SVN, Erwin, FileZilla, Informatica IDQ, Talend Open Studio ETL , Jira

• Replication handled through Oracle set operator minus. Inbound source feed read by Oracle External Table utility and loaded into transient table for further process into staging tables where filter and formatting layer applied. Datahub receives customer data Oracle EBS, SAP and SFDC and product source data from ORACLE EBS, and SAP and stores it as master data repository in canonical form triple store. Application views have been created on top of canonical data based on source specific business needs and published to target systems. Datahub handled change data capture CDC based on date key column value of the inbound source data. If any updated information found in delta, for the existing records, it would be merged Update . Otherwise brand new records Insert would be created. Developed lot of oracle stored packages, stored procedures with bulk collect and stored functions and optimized SQL query for better performance. Used various analytical functions to handle complex logic of pl/sql case statement scenarios. Table Partition has been created for large volume of data in the tables identified based on tuning perspective. Best practices applied whenever write sql query and program units in the database. Actively involved in all phases of SDLC and worked in Agile Scrum-Sprint environment.
• User story development and implementation details logged through story number in Jira tool. Customer master handled through party model using SQL developer modeling tool. Source version controlled using Subversion tool SVN .

Confidential

Role - Senior Oracle Developer

Environment - O/s: Windows XP, AIX S/w: Oracle 11g/10g, Pl/Sql, TOAD, Korn UNIX Shell Scripts, MQ, Putty, Erwin, Maestro scheduler, FTP, PVCS, .NET.

Role:

• Worked as core pl/sql developer in Vital, Igloo and Maple leaf projects in Unilever.
• Developed lot of Oracle Stored Packages, Stored Procedures, and Stored Functions for AMPS business domain application.
• BULK Collections, set operators ref cursor used extensively in AMPS.
• Created multiple Rollup tables with help of analytical functions.
• Handled XMLTYPE to process the value in Oracle which sent from .NET application
• Design Functional Specification, Technical specification, Coding, Unit test, String Test and Integration test.
• Actively involved in data model design, creation and modification.
• Created staging tables to store data from flat files using External Table and SQL Loader.
• Created Korn UNIX Shell script to execute set of Oracle Stored Packages in order.
• Testing of conversion routines.
• Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace. HINTS used to force particular index, when joined with multiple tables
• Involved in Cutover Implementation of successful AMPS release module.

Confidential

Title - Senior Oracle Developer

Environment - Oracle 10g/9i, Pl/Sql, TOAD, SQL Navigator 4.0, Informatica 6.1, Korn UNIX Shell Scripts, Putty, FTP, CVS.

Role:

• Developed Oracle Stored Packages 17 , Procedures, and Functions for SSP conversion.
• Developed Mappings, Sessions, and Batches using Informatica ETL tools.
• Design Technical Specification, coding, and Testing
• Created staging tables to store data from flat files using SQL Loader.
• Created Korn UNIX Shell script to run Oracle Stored Packages.
• Testing of conversion routines.
• Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace. HINTS used to force particular index, when joined with multiple tables
• Involved in Implementation of successful SSP module.

Confidential

Title - Senior PL/SQL Developer

Environment - Oracle 8i/9i, Pl/Sql, TOAD, Informatica 6.1, Korn UNIX Shell Scripts, FTP, VSS.

Role:

• Developed Oracle Stored Packages, Procedures, and Functions for Data warehouse domain.
• Developed Mappings, Sessions, and Batches using Informatica ETL tools.
• Design Technical Specification, coding, and Testing
• Created temporary tables to store data from flat files using SQL Loader.
• Created Korn UNIX Shell script to run Oracle Stored Packages.
• Created adhoc query SQL files to spool data from both Filing mart and Warehouse tables.
• Testing of conversion routines.
• Tuned SQL Query for optimization in Oracle stored packages using HINTS.
• Done Optimization using Execution plan and TKPROF tool to analyze and fixed multiple time consuming SQL statements which was available in stored packages.
• Involved in Implementation of billing module.

Confidential

Title - PL/SQL Developer

Environment - Oracle 8i, Pl/Sql, SQL plus, Korn UNIX, Toad, VI editor.

Role:

• Developed Stored Pl/Sql Programs Packages, Procedures.
• Design Technical Specification, coding, and Testing
• Testing of conversion routines.
• Tuned SQL Query for optimization includes HINTS.
• Execution plan and tkprof used to analyze various time consuming SQL statements for optimization.
• Involved in Implementation of Aflewis Data Refresh

Confidential

Title - PL/SQL Developer

Environment Windows NT, Oracle 8i, Informatica, Toad, Erwin, Putty, Ftp and Visual Source Safe.

• Involved in coding, testing and implementation.
• Developed New Oracle Stored Packages used concepts of oracle built in packages Dbms SQL, Dbms Job Procedures and Database Triggers.
• Modified existing Stored Packages, Procedures and Database Triggers.
• Production Support to Auto- New Cars Web Site Team.
• Monitor the Offers to pass through multiple stages of Accept offer, Reasonability Review, Credit card validity, Sales confirmation etc..
• Preparing Customer Certificates for successful offers.
• Designing data entry screen, report generation, testing, documentation and implementation for Customer Certificates.
• Weekly once update chrome data affect core tables using Informatica, SQL loader and SQL scripts.
• Data loading using SQL Loader and Export/Import utilities.
• Bimonthly send faxes to dealers/franchise about updated business policy changes done through stored procedure.
• Tuned Sql Query to keep the application run very effectively.
• Created Scripts for Ad hoc job

Confidential

Title - Oracle Programmer

Environment - Windows NT, Forms4.5, Reports2.5, Oracle 7.3, UNIX, Humming bird, SQL plus, Ftp, VSS.

Role:

• Developed Screens design
• Developed Form Modules and link more than one form and done unit test and UAT.

Confidential

Title - Oracle Programmer

Environment - Windows NT, Forms4.5, Reports2.5, Oracle 7.x, UNIX, Humming bird, SQL plus, Ftp, VSS.

Role:

• Created Stored Packages, Stored Procedures and Database Triggers and done unit test.
• Developed Screens design.
• Execution plan and statistics of various SQL statements for optimization.
• Tuned SQL Query to keep the execution time at optimum level.