Summary
=========

Have a reasonable understanding of the ITIL process and have worked on a service support Incidents, Change management procedures, SLA responses

Competed Oracle Certified Database Professional OCP certification.

Database Development with around 3+ Years of experience in Oracle PL/SQL as Developer using most of the Oracle related tools under UNIX and Windows environments.

Experience in Requirement capturing, System analysis, Logical and Physical data modeling, Development and Implementation of software applications. 

Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.

Expertise in Unit Testing, Integration, Functional, System, Performance, Load, Regression Testing and Validation Testing.



Responsibilities
==================

Created Partition tables by range using date column to increase the performance.

Created public database links to access the data from remote databases.

Scheduling Jobs through Crontab.

Wrote database triggers for automatic updating the tables.

Worked on SharePoint portals to share documents (check in/check out) Process.

Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.

Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.

Developed procedures using Dynamic SQL.

Resolving the issues on priority basis.

Responsible for Analyzing and Implementing the Change Requests .

Involved in handling the changes in compiling scripts according to the database changes.

Data conversion from flat file to intermediate tables using SQL*Loader,Data mapping

Gather Database and User Level Statistics and Analyze Overall System Performance.

Written Unix shell scripts for data files handling, FTP and executing the SQL*Loader.

Author Release notes Document to instruct the DBAs on the order and method of implementing the releases/projects.

Co-ordinate with the testing and QA teams to ensure smooth delivery of the releases and projects

Work with the QA team to perform root-cause analysis for issues in the new release


Awards and Achievements
========================

Received 'Pat on the Back' Award for customer delight, quality and delivery

Been Nominated & Awarded “Pat on the Back” award (For significant achievement in day- to- day working & is applicable to individuals who demonstrate exceptional presence of mind, thinking on their feet or personal sacrifice in critical situations) from the Ops team & from the Business unit.

Personal Achievements
======================

§ Valuable Contribution Award for ITP Data Migration Project in Q2 -- 2015.

§ Awarded by 'STAR -- Pat on the Back' award for working on Complex Reconciliation and Document & Reference Module in ITP Data Migration Project.

§ Won the 'STAR- Dream Team' award of the year 2014 for 'ITP Data Migration Project'.

§ Awarded by 'Letter Of Appreciation' from BICoE for Equity BO Redesign Project.

§ Won the 'STAR- Dream Team' award of the year 2006 for 'Project Cornerstone - HLR Data Mart' project.


Awards: Awarded 3 times Valuable Contribution Awards and once Pat on the back award while working with different clients for effective handling deliverables and handling assigned work




https://www.1keydata.com/datawarehousing/data-modeling-levels.html






 Technical Skills:

    Databases : Oracle 9i/10g/11g, Ingress, SQL Server
    Programming Languages : Shell Scripting, SQL, PL/SQL, C, JAVA
    Packages : VB
    Operating System : UNIX, Windows
    Technology : OpenRoad
    Data Mining Tools : Discovery
    Text Formatter : TROFF, GROFF
    Testing Tool : Mercury Test Director, HP Quality Center, JMeter
    Source Control Tools : Clear Case, Subversion
    Support Tool : Service Center
    Monitoring Tool : Autosys Workload Control Center
    Web Technologies : XML, HTML, DHTML
    Product : SAP Testing