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
• Have worked on C/C++, Java Technologies (Java, JSP), ASP.Net, C#, Visual Studio 2010
• Have experience in a Linux or UNIX environment
• Expert in Confluence Wiki programming, Wiki charts & reports, macros, plugins
• Have worked on Velocity Template Language for Wiki programming
• Experience in SDLC and Quality Assurance methodologies
• Experience in Data warehousing and ETL testing
• Have knowledge 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

STRENGTHS:

Strong Analytical skills, Responsible, Organized, Hard working, Honest, Comprehensive problem solving abilities, Excellent verbal and written communication skills, Good Leadership Quality, Ability to learn quickly, Team facilitator.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

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

Confidential

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 the PDF and RTF generator for the same report using Java Server Pages (JSP)

Confidential

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 the PDF and RTF generator for the same report using JSP

Confidential

Responsibilities:

• I worked on the registration form to redesign it to look more like an A.com form, and to have it serve both the Wiki KC and the classic KC. This project was more intricate than expected. I re-designed the whole website using PL/SQL Programming, Oracle Portal, JSP and JavaScript
• I also created a web-based status report (updated daily) which listed the 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.

Confidential

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

Confidential

Software Manager

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

Confidential

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 the fields on forms using HTML, JavaScript & Ajax prepared design documents for this project on Confluence Wiki

Confidential

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

Confidential

Oracle DBA

Responsibilities:

• worked as DBA for a period of 1 year & performed all the DBA & networking-related tasks in Confidential 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 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

Confidential

Senior Software Engineer

Responsibilities:

• Designed websites using C#, ASP. Net, JavaScript, HTML technologies for clients of Confidential
• Designing and maintaining business logic inside SQL Server databases using PL/SQL Programming. SQL Query Optimization and Performance Tuning
• Worked for Confidential ’s client “ Confidential” & did Web Accessibility testing for web sites & software based on accessibility requirements mandated by Section 508 of the Rehabilitation Act, the Americans with Disabilities Act ( Confidential ), and country-specific international legislation of USA.
• Designed “ Confidential ” website which is a career/ job oriented website, being designed for an Confidential client based in USA. My work included designing of registration pages for non-professional & professional users and designed database Tables using ASP.Net and C# & Stored Procedures in SQL Server.
• Worked on “ Confidential ” website which involved online buying/ selling of properties in USA. I designed the front-end using ASP.NET grids and stored procedures inside SQL Server database to implement the business logic.
• Monitoring of ports, bytes and website, developed by Confidential for one of its clients.