Vishwanatha SB

Email: adaff6@r.postjobfree.com

mailto:adaff6@r.postjobfree.com: (M) +1-585-***-****

Professional Summary:

Over 7.5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB, UTL_SMTP and UTL_FILE.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using Range partition technique.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Worked extensively on XML table parsing.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience in SQL Performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan, SQL Trace, TKPROF and HINTS.

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Strong experience in Data warehouse concepts, ETL.

Groomed fresher’s in Functional and Technical (Testing) aspects of the project.

Ability to learn new modules and Technologies quickly and efficiently.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Working Summary:

S.No

Organization

Designation

Duration

1

Tata Consultancy Services

I.T. Analyst

March 2012 To Ongoing

Educational Summary:

Qualification

School/College

Board/University

Academic year

Results

BE [ME]

RYMEC, Bellary

VTU, Belgaum

2011

77.32%

12th

VKJJ, Siruguppa

Karnataka board

2007

65.5%

S.S.L.C

SVMS, Siruguppa

Karnataka Board

2005

86.05%

Strengths and Positive Points:

Ability to self-motivate and motivates others.

Hard Working and a team player.

Dedication and positive nature towards any situation.

Good Interpersonal skills, Management Skills, Commitment and Result oriented with a quest and zeal to learn new technologies and undertake challenging tasks.

Self Achievements:

Contributed well in TCS GMS project deliverables and stood as a member of "STAR TEAM" and received the TCS gems for the same.

Achieved the 'Star of the Month' award in TCS GRS project for taking the complete ownership of the RSDmart application along with regular development activities.

Contributed well in TCS MCKB project deliverables and stood as a member of "STAR TEAM" and received the TCS gems for the same.

Technical Summary

OPERATING SYSTEMS

Windows XP/7, Unix

LANGUAGES

SQL, PL/SQL, and Unix shell scripting.

DATABASES

ORACLE 9i,10g, 11g,12c (new features)

TOOLS & UTILITIES

PL/SQL Developer, Toad, Putty,VSS(Virtual Source Safe), SVN tortoise, BOM(Bill of Materials),winscp, SSH shell, MKS tool,OWB, BitBucket, AIX Shell

Professional Experience

Project #1:

Role : Developer

Title : ILI Operational Data Store:

Period : Oct 2018 to till date

Client : Prudential Insurance Company of America

Work location: Roseland NJ, USA

Team Size : 5

Technologies: Oracle PLSQL, SQL, UNIX shell scripting, Autosys

Description:

The Operational Data Store (ODS) is the logically unified focal point for enterprise operational (as opposed to analytic) information, an integrated set of near-real-time transactional detail information optimized for operational runtime and extract efficiency, standardized to asset of consistent definitions and formats and assembled to provide an enterprise-level perspective. It is ACORD data domain-oriented.

The operational data store is the hub for enterprise operational information. Data is loaded regularly in to the ODS from the primary administration and accounting systems and is stored at the transactional detail level.

The data from ODS is fetched through Views/Mat Views and loaded to Pre-staging Area of the Warehouse through db links. From Pre-staging area, it is then moved to staging area through PL/SQL packages. From there it is loaded to Warehouse where data is stored in the form of Facts/Dimensions.

The IL Data Warehouse contains current snapshot data in the Operational Data Store (ODS) and historical data in the history data store (IMD).

Onsite responsibilities:

Communicate with the client for collecting the requirements and document the same

Performing impact analysis, estimation and creation of detailed project plan

Preparing high-level design for the new requirement

Co-ordinate with offshore counterpart for timely delivery of the work items with the highest quality

Coordinate with other interfacing systems for any interface impact due to changes

Provide support for testing teams in validating the changes

Releasing into Production and providing support the same for specified duration

Maintain different versions of code using BitBucket.

Offshore responsibilities:

Co-ordinate with onsite team to get the requirements and clarify any issues

Prepare analysis document

Prepare technical specification documents

Prepare unit test plans

Perform unit testing

Document test results

Logging, maintaining and rectifying the issues

Report progress to onsite project lead and TCS management

Carry out quality assurance activities for all deliverables, so that code and the test results are delivered without any defects

Project #2:

Role : Developer

Title : Global Metered Services (GMS)

Period : Jan 2017 to till date

Client : Xerox Corporation

Work location: Webster NY, USA

Team Size : 5

Technologies: Oracle PLSQL, SQL, UNIX shell scripting

Description:

Xerox Corporation is using Siebel application, which interfaces with

Multiple Systems to gather meter-reading data. The Project involves enabling auto-replenishment of

Supplies, GMS global metered supplies requires consumption to be estimated for devices that do not

Communicate gas-gauge level information.

GMS requires a reliable unit of measure that can be used effectively to estimate consumption. The raw meter count needs to be validated as reasonable, rationalized due to varying device characteristics, and updated frequently enough to support the estimation process. Following the completion of the current requirements being gathered the next step is to develop a high-level design, detailed design, develop, and test the new functionality for Meter Count Cleansing in GMS. The project involves configuration of Siebel inbuilt resources and functionality and customization of already inbuilt Siebel features and customizations using various Oracle provided tools, development of new User Interfaces using Siebel Tools and Siebel EAI/Web Services components

Responsibilities:

Extensive Analysis of System Requirement Documents.

Participation in analysis and design meeting of the SRDs and client review meetings and weekly status meeting.

Preparing the functional design documents and reviewing with the client.

Development of custom components related to the modules.

Monitoring and optimizing the performance of the database.

Tuning the PL/SQL objects for perfection to reduce the run time.

Developing SQL loader scripts to load the source data.

Unit testing all the application components for providing quality assurance.

Developing Technical Design Document (TDD) and Unit Test documentation.

Test support for Testing Team.

Support Documents Preparation.

Project #3:

Role : Developer

Title : Common Device Database Systems (CDDS)

Period : August 2013 to till date

Client : Xerox Corporation

Work location: Hyderabad, India

Team Size : 6

Technologies: Oracle PLSQL, SQL, UNIX shell scripting

Description: The project involves analysis, design and development of Common Device Data Store (CDDS) application and Remote Data Warehouse (RDW) application for Xerox Corporation. Global Services and Applications Remote Services is used to maintain the reports of the printers, scanners and other equipment sold by Xerox Corporation. It is operated with many java and PL/SQL applications to maintain data like product usage information and product maintenance information etc. This Project is useful to improve the business process and economy.

Every machine (printers, Scanners etc...) sold by Xerox Corporation will report the usage information to Xerox Corporation. By this mechanism Xerox Corporation can meet the maintenance requirements of the particular machines further (Cartridge, ink, Papers etc…). All the applications in Remote Services, used to manage the data between machines and Xerox Corporation.

The Remote Services applications consist of the following applications.

1.REA

2.CDDS

3.DCS (Device Centric Service) Edge server - Application

4.CFA (Call For Assistance)

5.XECC (Xerox Enterprise Command Center)

6.RDW (Remote Data Warehouse)

7.My Support Portal (MSP)

8.Drivers & Downloads (D&D)

9.DMS

Responsibilities:

Collecting requirements and analyzing the impacts on the existing system.

Analysis and Scoping for the new implementations.

Development and Unit testing.

Monitoring and optimizing the performance of the database.

Tuning the PL/SQL objects for perfection to reduce the run time.

Developing SQL loader scripts to load the source data.

Scheduling Cron jobs and DBMS Scheduler jobs.

Test support for Testing Team.

Support Documents Preparation.

Preparing Release notes for the weekly deployment.

Project #4:

Role : Production support executive/Developer

Title : RS - connectivity Dmart

Period : April 2014 to May 2016

Client : Xerox Corporation

Work location: Hyderabad, India

Team Size : 2

Technologies: Oracle PLSQL, SQL, UNIX shell scripting

Description : The project involves analysis, support and development of RS connectivity D mart application. The RS_DMART (datamart) schema on the <database> is updated once a day with data from the Edge database. Once RS_DMART is populated, the RS_DMART_STG (datamart stage) tables are updated with the previous day’s data from RS_DMART. New Monthly tables for the full device list and country data are created once a month on RS_DMART_STG from XSM, RS_DMART, XE, XCL, GIS, SALSA and DSSP. With in the business predefined schedules Device Information comes from various sources (LCR-XE Countries, DMO, FDRS, OSSP, MTSS, XSAT etc) and will be loaded into various tables of rs_dmart_stg schema in RS DMART DB server using set of sequential business logic processes and validations (implementation in unix shell scripts and PL/SQL programming) and then generators required reports to the Business; Processing of input files involves both manual and automated; Support activities included in the scope are monitoring the daily/Monthly FEED processing, fixing the failures, communicating with associated business stakeholders for corrective actions, customization of existing PL/SQL Procedures (fixing/enhancements) etc;

Responsibilities:

Analysis and Scoping for the new implementations

Monitoring the Monthly jobs and daily jobs.

Monitoring the Monthly report generation jobs.

Developing SQL loader scripts to load the master data.

Scheduling Cron jobs.

Providing root cause analysis and resolution for Incidents.

Automation of manual jobs.

Development and Unit testing.

Deployment of the modifications.

Project #5:

Role : Developer

Title : Marketing Customer Knowledge Base(MCKB)

Period : Jan 2013 to July 2013

Client : Xerox Corporation

Work location: Hyderabad, India

Team Size : 4

Technologies: Oracle PLSQL, SQL, UNIX shell scripting

Description : A Oracle-based system that serves as a centralized repository of customer, non-customer, and equipment information. Used by various Xerox business organizations for sales, marketing, reporting, analytical, territory assignment, compensation, and planning purposes. MCKB interfaces with various systems, and data can be accessed through several marketing tools and applications.

MCKB acquires the workup /worksheet level data from 3rd party application Valuequix in the form of staging views through DB link, validate and calculate the required fields based on the inputs and load data into staging area then populate into MCKB/DSS permanent tables to generate reports. The Way Cool Tool is a web-based application that uses live MCKB data for establishment or customer searches and inquiries. The tool is used to verify establishment information such as names, address, establishment number, XNAC, Ultimate DUNS, sales assignment, and customer number alignment detail

Responsibilities:

Collecting requirements and analyzing the impacts on the existing system.

Providing the High level and low level estimates after necessary analysis for every specific task.

Providing the High Level and Low Level Design for each and every requirement.

Developed Procedures, Functions, Packages and Triggers as per the requirement.

Developed Shell Scripts to run batch processes.

Monitoring and optimizing the performance of the database.

Tuning the PL/SQL objects for perfection to reduce the run time.

Project #4:

Role : Production support executive/Developer

Title : Enterprise Person Information Warehouse (EPIW)

Period : Sep 2012 to Dec 2012

Client : Xerox Corporation

Work location: Hyderabad, India

Team Size : 2

Technologies: Oracle PLSQL, SQL, UNIX shell scripting

Description : EPIW is a global data ware house of Xerox corporation person data mainly used for Xerox enterprise reporting and productivity applications. ADP & SAP HR systems place the encrypted Inbound feeds in the file servers. We used to decrypt the Inbound feeds and load those date into the EPIW after performing the various transformations based on the business logic. Based on the requirement we will provide the outbound feeds to the end users of EPIW by giving access to the views build on EPIW data or SFTP the flat files generated. The various applications in XEROX interact with the EPIW to get the employee information.

Responsibilities:

Deploying Process Flows, mappings and other SQL objects using Oracle Warehouse Builder

Developing OWB Mappings and Process flows based on the new change requests (CR’s).

Developing stored procedures, Unix Shell scripts.

Developing SQL loader scripts to load the master data.

Scheduling Cron jobs and DBMS Scheduler jobs.

Providing root cause analysis and resolution for Incidents.

Automation of manual jobs.

Personal Details

Father’s Name : Veeresha B

Date of Birth : 20/01/1990

Languages Known : English, Kannada, Telugu, Hindi.

Sex : Male

Marital Status : Single

Nationality : Indian

Passport Details : Pass port No. : J9333540

Issue date : October 13, 2011

Place : Bangalore on

Valid : Up to October 12, 2021

Contact this candidate