Oracle PL/SQL Developer

Pritesh Vishwanath *******************@*****.*** 502-***-****

Professional Summary

Software Engineer with 9+ years of IT experience primarily in Database development (Oracle),ETL(using PL/SQL) in Analysis, Design, Data Modeling (Logical and Physical) and MS.Net programming, in addition to working on cloud projects using Hadoop.

Over 5 Years of experience working in Agile Software Development model.

Expert in creating database objects such as Table, Views, PL/SQL Packages, Stored Procedures, Cursors, Functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.

Experience in Extract Transformation and Load (ETL) using the Oracle dblink.

Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, SQL*Trace and Table partitioning.

Extensive experience in developing UNIX Shell scripts and scheduled jobs on UNIX server using Control-M utility.

Self-starter, team player keenly interested in exploring new, challenging areas.

Responsible for mentoring junior engineers, designing, defining and prototyping work.

Certification:

● Microsoft certification for ASP.NET 2.0(70-528- Developing Web Applications with Microsoft ASP.NET 2.0 and C#). Scored 929/1000.

● ITIL (Information Technology Infrastructure Library) Foundation Certification.

Technical Skills

Languages : PL/SQL,VB.Net, C#

Operating Systems : Linux, Windows NT/XP/7, Unix(HP-UX 11.31).

Databases : Oracle 12c/11g/10g, SQL Server 2008, DB2.

Web based Applications : ASP.net 2.0, ASP 3.0, JavaScript, VB Script,JSP and HTML

File Systems : NTFS,Hadoop Distributed File System (HDFS).

Tools : Toad, SQL Developer, Visual Studio 2010, JUnit, Jira, SVN, Oracle Reports,

Control-M, SUPRTOOL.

Professional Experience:

Vanguard Group-Pennsylvania Jan 2014 - Present

Senior Software Developer

Project: FIMA [Vanguard Group]

Responsibilities:

Working as a Software developer at Vanguard in an AGILE Dev model my tasks include writing Oracle Procedures[PL/SQL] and programs in C# and to facilitate the various financial transactions and write Unix scripts which are called from Control-M jobs to process Vanguard ETF's. These Unix scripts in turn call .exes which have the core business logic.

Extracted Market Analysis Bloomberg data for specific BONDS from Bloomberg as a reference for Middle Office.

Improved efficiency of code using Explain plans and GATHER_PLAN_STATISTICS hint.

I was also extensively involved in Physical data modelling tasks like designing, creating tables, normalization(3NF), creating indexes etc.

Created External tables to import data from .csv files into the Core system.

Environment: Oracle 11g, Oracle 12c, Unix Shell scripting,VB.Net, C#.

Ucare Minneapolis Aug 2013 – Dec 2013

Oracle Database Developer

Project: Affordable Healthcare Act Exchange [UCare]

Responsibilities:

As an Oracle Developer in the AHA [Obama Care] project I was involved in writing Managed Member Health modules.

Tasks included writing PLSQL (stored procedures, triggers) UNIX shell programs, Batch Jobs deployment and writing Oracle reports. I also performed ETL using PL/SQL techniques.

Used SQL Loader and External tables to import data into Internal systems.

Environment: Oracle 11g, UNIX -Shell scripting, AppWorx, SUPRTOOL, ETL (PL/SQL), Oracle Reports.

Cognizant Technology Services San Francisco Aug 2012 – May 2013

Senior Associate (Tech Lead)

Project: Common Data Model [Cognizant Technology Solutions]

Responsibilities:

Wrote numerous Oracle Stored procedures that would process the customer claims for Blue shield of California.

Daily tasks would include filtering and loading data from different formats of data sources into Database Tables and also writing numerous queries for extracting result sets.

Timely Query optimization was also required to be done using Joins and indexes in an effective manner.

Generated reports using Oracle Reports for CCMS application.

Environment: Oracle 11g, SQL Developer, Oracle Reports.

McKesson Corporation San Francisco Jan 2012 – Aug 2012

Software Developer

Project: Paris Engine SOR Consolidation [McKesson Corporation]

Responsibilities:

The Paris [Promotional Accounting Rebate Incentives System] Engine (PE) is envisioned as a complex database application meant to produce rebate statistics.

Wrote numerous stored procedures that would calculate rebate sets, apply waivers, cull out sales transactions and finally determine the rebate amounts.

Environment: SQL Server 2008

IBM San Jose Jun 2011 – Aug 2011

Intern-Quality Analyst (Internship)

Project: Infosphere BigInsights [IBM Corporation]

Responsibilities:

InfoSphere BigInsights is designed to help IT professionals quickly get started with big data analytics using Hadoop Distributed File System (HDFS).

My work was to determine the scope and verify the functionalities of various Infosphere BigInsights Components.

It focused on the DB2 Integration via JAQL in the LUW and Z OS and also the configuration.

As a QA Intern my job was to write Test Scripts in JAQL (JSON a Query Language) that would verify if all the DB2 supported functionalities are working fine after the Integration.

Worked on the setting up and configuration of Flume and wrote scripts to modify the existing nodes on Flume with number (add/remove) and roles (master/slave).

During my tenure I have logged in a few very critical defects which were later fixed by the development team for the Final release of the product.

Environment: JAQL,DB2, Hadoop Distributed File System (HDFS), Flume, Linux,Jira, RTC, RQM,DB2,Oracle 10g.

Datamatics Global Services Limited London, UK Mar 2007 – Dec 2009

Associate Consultant

Project: BUPA Database Development

Responsibilities:

I was actively involved in the database designing and development creating of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.

The tables were normalized up to 3 NF and also proper Referential Integrity rules were followed using data constraints and triggers.

Used HINTS, BULK COLLECT to achieve performance improvement. Also did query tuning and optimization by using Query Tracing and Explain Path.

Environment: Oracle 10g.

● Energy Monitoring and Temperature manufacturing systems. [Radiotech Co UK]

GNET24 is a web based system which acts as the end point of numerous transmitters of various types, which broadcast environmental readings from fixed locations. The system provides reporting and analysis functionality for end users. There are a number of transmitter types which report a variety of measurable temperatures which are reported in tables, graphs and emailed alerts where appropriate.

Environment: ASP.Net 3.0, C #, JavaScript,VBScript, HTML, SQL Server 2008.

● Reporting tool manager [Datamatics Global Services Limited]

I developed tools for the accounts team for executing reports and generating statements on a daily, biweekly, monthly basis for their in house operations. I also developed various SQL Queries to fetch complex data from different tables in remote databases using joins, database links. Some of the tasks required writing PL/SQL stored procedures and triggers to complete the required operations.

Environment: Oracle 10g.

●Advanced databases Project - KDD Cup [MS Project]

The Database dump of the Knowledge data discovery [KDD] was used to create OLAP cubes and dimensions keeping in mind the final goal of the project - to maximize the profit. For the design of the OLAP CUBE more focus has been given on the information of the areas important to the project by extracting data through Data Discovery. The OLAP data structure helps in determining which attributes were to be chosen for faster analysis of data.

Environment : SQL Server 2008.

● BUPA Websites [Datamatics Global Services Limited]

Web Technologies (WT) project is about enhancement, development and support work of various websites that comes under category e-Business Solution (solution to enhance business of BUPA UK). WT covers various aspects of business of BUPA. My task also involved addressing change requests and defects raised by clients in a timely fashion. Various sites like BUPA Care homes, BUPA International, Consultants Online etc were a part of this project.

Environment: ASP.Net 3.0,C#, JavaScript, VBScript, Oracle 10g, TOAD, HP OPENVIEW 4.5.

● Query Engine [Datamatics Global Services Limited]

I was responsible for the smooth and hindrance free functioning of one of BUPAs many search based information website, BUPA Care homes, which aims at providing residential and nursing homes information to the users.

Environment: ASP.Net 3.0,C#, JavaScript, VBScript, Oracle 10g, TOAD, HP OPENVIEW 4.5.

● Web Leads [Datamatics Global Services Limited]

The volume of Insurance Quotes being ordered via BUPA is very high. Querying and obtaining

information of this magnitude tends to become very difficult for various call centers. In order to ease this further, various Batch jobs are executed to make the Customer Web Leads available to BUPA Call Center application. This is done by directly interfacing the application with the database for customer Quote Information entered through the Global BUPA International Website (http://www.bupa-intl.com).

Environment: ASP 3.0, JavaScript, VBScript, Oracle 10g, TOAD, HP OPENVIEW 4.5.

Hewlett-Packard India Jun 2006 – Mar 2007

Software Programmer

SwiftForm Migration Tool Hewlett Packard

Responsibilities:

Developed an ASP based migration tool that provides an interface to transfer data from a legacy financial system to Infosys’s Finacle system.

The project helps the user to import, export, add, edit, delete, search and validate the data and migrates the converted data to Finacle system.

The tool also provides module wise reporting and business rule validation.

Environment: ASP 3.0, JavaScript, VBScript, HTML, Oracle 9i

Contact this candidate