SUMMARY

• Expert in key database aspects such as Indexing, Performance Tuning and Relational Database Design, Data Modeling
• Expert in Oracle 8i/ 9i/ 10g/ 11g/ 12c, MySQL & SQL Server databases
• Expert in Oracle Development Suite 10g, Oracle EBS, ETL
• Expert in Oracle Portal, Oracle Form Builder & Oracle Report Builder, SSRS, SSIS
• Expert in PL/ SQL programming, packages, stored procedures, triggers, cursors
• Expert in SQL Queries, T - SQL, SQL stored procedures and functions on SQL Server
• Query Optimization and Performance Tuning
• Expert in Angular JS, Bootstrap, jQuery, Ajax, Scrum, XML/ XSLT, HTML, HTML5, CSS, Adobe Experience Manager
• Expert in MS Visio, MS Office, MS Project, Confluence Wiki
• Has worked on C/C++, Java Technologies (Java, JSP), ASP.Net, C#, Visual Studio 2010
• Has experience in a Linux or UNIX environment
• Expert in Confluence Wiki programming, Wiki charts & reports, macros, plugins
• Has worked on Velocity Template Language for Wiki programming
• Experience in SDLC and Quality Assurance methodologies
• Experience in Data warehousing and ETL testing
• Has noledge of Computer Science fundamentals, data structures, algorithms and object-oriented design and systems architecture
• Experience in Web Accessibility and Usability Testing
• Experience with Big Data/ Hadoop/ Spark/ Hive environments
• Experience with Web Services, Web API, and/or WCF
• Experience with MVC, web service interfaces and middle-tier components

PROFESSIONAL EXPERIENCE

Company Name: Confidential

Oracle Developer

My Responsibilities:

• Design and develop Oracle, MySQL & SQL Server database’s schema for MMS
• Maintain/Support current Oracle and MySQL database in IC-CAP/WaferPro
• Query Optimization and performance tuning
• Designing & maintaining business logic for ICCAP product in teh database using PL/SQL and C/ C++ programming

Company Name: Confidential

My Responsibilities:

• Prepared database design for this project in Oracle using Microsoft Visio
• Created Oracle database objects like tables, synonyms, database links, triggers, inserted data & updated, cursors & dynamic SQLs using SQL queries & also did query optimization where ever required
• Design and develop Search Form and Report using PL/SQL programming and Oracle Portal
• Designed teh PDF and RTF generator for teh same report using Java Server Pages (JSP)

Company Name: Confidential

My Responsibilities:

• Prepared database design for this project in Oracle using Microsoft Visio
• Created Oracle database objects like tables, synonyms, database links, triggers, inserted data & updated, cursors & dynamic SQLs using SQL queries & also did query optimization
• Design and develop Search Form and Report using PL/SQL programming and Oracle Portal
• Designed teh PDF and RTF generator for teh same report using JSP

Company Name: Confidential

My Responsibilities:

• I worked on teh registration form to redesign it to look more like an A.com form, and to has it serve both teh Wiki KC and teh classic KC. This project was more intricate than expected. I re-designed teh whole website using PL/SQL Programming, Oracle Portal, JSP and JavaScript
• I also created a web-based status report (updated daily) which listed teh edit status for all pages. This was an invaluable tool for Technical Support in order to measure their progress on editing/reviewing their technical articles. This report was designed in PL/ SQL Programming, Oracle Portal, JSP and JavaScript.

Company Name: Confidential

My Responsibilities:

• Creating reports using Oracle Portal and Oracle Reports
• Designing & maintaining PL/SQL code for Search forms
• Confluence Wiki programming for creating reports
• Velocity Template Language for creating user interface
• Wiki macro & plugins for designing forms
• Analyze, Design & Test software to simplify view & evaluation of various reports

Company Name: Confidential

My Responsibilities:

• ASP.Net programming using C# for tying licenses with subscriptions/ supports
• Prepared database design in Oracle for License & Subscription Renewal module
• Designed UIs for “Tying License with Subscriptions” module using ASP.Net (C#)
• Designed to localize ASM website for different culture languages

Company Name: Confidential

SQL Developer

My Responsibilities:

• prepared database design for this project in Oracle
• created Oracle database objects like tables, synonyms, database links, triggers, inserted data & updated, cursors & dynamic sqls using SQL queries & did query optimization where ever required
• used PL/SQL programming skills to design packages for a pure web-based automatic token generator & evaluation license generator using Oracle 8i/ 9i/ 10g database in PL/ SQL developer & JDeveloper
• designed frontend licensing forms & reports using Oracle Forms, Portal & Reports
• implemented functionalities like pop-up calendars for picking dates, auto-populating drop-down fields & callouts to display help for filling teh fields on forms using HTML, JavaScript & Ajax
• prepared design documents for this project on Confluence Wiki

Company Name: Confidential

My Responsibilities:

• prepared database design for this project in Oracle using Microsoft Visio
• created Oracle database objects like tables, synonyms, database links, triggers, inserted data & updated, cursors & dynamic SQLs using SQL queries & also did query optimization where ever required
• used PL/SQL programming skills to design packages for automatic license generator in Oracle 8i/ 9i/ 10g database using PL/ SQL Developer, Web Toolkit & JDeveloper
• designed frontend licensing forms & reports using Oracle Forms, Portal & Reports
• implemented form validations & certain functionalities like date-picker calendar, auto-completing input fields & tooltips/ callouts using web technologies like AJAX, JavaScript & HTML
• prepared design documents for this project on Confluence Wiki

Company Name: Confidential

Oracle DBA

• worked as DBA for a period of 1 year & performed all teh DBA & networking-related tasks in Agilent in parallel with database development task as part of resource sharing
• maintained Oracle Application Servers
• upgraded Oracle Application Server & Database from Oracle 9i (9.0.2.2) to Oracle 10g (10.1.2.0.2)
• migrated database from MySQL to Oracle 9i/ 10g

Company Name: Confidential

Oracle DBA

• developed applications Automatic Order Load, License & Codeword Generation for Agilent’s software products, Customer Mapping & Cleanup, Order Auto Load Report Maintenance & Repair, Customer self-service applications such as License Renewal and Support Contract Renewal systems, Marketing Customer Information system to analyze customer trends in purchasing our products using Oracle 9i, Oracle 10g, Oracle Portal, Oracle Forms & Reports, PL/SQL Developer & JDeveloper, HTML, AJAX, XML, JavaScript
• database Designing in Oracle using Microsoft Visio
• software Engineering Project Documentation for each project on Confluence/ Wiki