Storage Console and Backup Manager Resume

SUMMARY:

10+ years of experience in Database Development.
Strong Knowledge in Database Architecture, Data Modeling, SQL, Pl/SQL scripting, Performance tuning.
Extensive work experience in Oracle 12c, 11g, 10g, Oracle 9i databases.
Experience in using UNIX platform with shell scripting.
Development experience in Oracle Financials Technical 11i and R12.
Experience in MongoDB.

TECHNICAL PROFICIENCY:

Database Applications: SQL, PL/SQL, Oracle12c/11g/10g/9i, Oracle Application 11i EBS suite, SQL Server, MongoDB.

Operating System: WINDOWS, UNIX

Tools: Oracle Developer, ER Studio, Toad, Rapter, SQLyog, Confidential, Oracle golden gate.

IT EXPERIENCE:

Confidential

Storage Console and Backup Manager

Responsibilities:

Working with product management teams and customers to turn business requirements into release product functionality using PL/SQL.
Developed database installation / upgrade processes
Engaged in translating business requirements into data models.
Performed high and detailed report based on customer requirements.
Developed Backup Manager for multiple vendors
Performance tuning & bug fixing for capacity manager, backup storage console
Involving in design and implementation of noSQL dynamic reporting tool.

Confidential

Storage Console and Backup Manager

Responsibilities:

Business Engine Support

Confidential

Responsibilities:

Modified Oracle Objects like PL/SQL Stored Procedures and functions to existing process for Data load coming from Up Stream (RDR) of BEN, BENIP and BENDW
Executed Confidential to Clarity migration activities
Interacted with users, gathered the Business Requirements
Created and managed jobs running under Confidential
Executed production support activities, e.g., DB refresh, report generation.
Created Informatica mapping to load data from Confidential to Confidential warehouse.
Involved in performance monitoring and tuning of SQL code.
Implemented Complex Queries for Report Generation.
Developed UNIX shell scripts to automate routine tasks.
Developed various Unix Shell Scripts to create report, custom FTP utility, file archiving for Confidential job.
Used explain plan to increase the performance of SQL statements.
Developed Triggers on tables to capture data where there is a change in the tables.
Coordinated with DBA in Creating and Managing tables, indexes, DB Links and User Privileges.
Extensively used PL/SQL advanced features like PL/SQL tables, collections etc.,
Participated in Peer code reviews and verifying coding standards.

Confidential

Sub Ledger Support

Responsibilities:

Confidential

Storage Console and Backup Manager

Responsibilities:

Developed short - hands, Portfolios, Aggregations and reports.
Implemented SQL trigger to maintain data consistency between source table and target table in Confidential database.
Involved in bug fixing for SQL queries and store procedures.
Involved in performance monitoring and tuning of SQL code.
Involved in Informatica mapping modifications.
Used External Table to load date from files provided by interfacing applications
Extensively used PL/SQL advanced features like PL/SQL tables, collections etc.
Wrote queries involving multiple-joins to generate user reports.

Confidential

Storage Console and Backup Manager

Responsibilities:

Designed and implemented SQL queries to show break up of KPIs (e.g. expenditure) at sub target groups and sub activities level in UI
Developed store procedures to cross compare KPIs across brands, regions, time
Involved in implementing change request and bug fixing for multiple modules
Used SQL*Loader to load data from flat files (excel/access) to Oracle database
Involved in performance monitoring and tuning of SQL code
Involved in writing test cases, unit testing

Global Reporter

Confidential

Responsibilities:

Interacted with users, gathered the Business Requirements
Designed and Implemented PL\SQL packages to developing a tool which partitions multiple 3G RAN tables which contain raw or summarized (DAY, WEEK, BH, WEEKBH) PM data from network elements.