**** **** ******

Silver Spring

MD *****

Email: acus6j@r.postjobfree.com

Ph: 408-***-****

Pritesh Vishwanath

SUMMARY

Software Engineer with 7+ years of IT experience primarily in Database development (Oracle),ETL(using PL/SQL) and MS.Net programming, in addition to working on cloud projects using Hadoop. Self-starter, team player keenly interested in exploring new, challenging areas. Responsible for mentoring junior engineers, designing, defining and prototyping work. Over 3 Years of experience working in Agile Software Development model.

LinkedIn: https://www.linkedin.com/in/pritesh-vishwanath-4ba05817

EDUCATION

● Master of Science, Computer Science, Texas A&M University, Dec 2011.

● Master of Science, Computer Science, University of Mumbai, June 2006.

● 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.

Work Experience History:

● Senior Software Developer, Vanguard Group-Pennsylvania [Jan 2014 - Present] (Consultant)

● Oracle Database Developer, Ucare-Minneapolis [Aug 2013 – Dec 2013] (Consultant)

● Senior Associate(Tech Lead), Cognizant Technology Services-San Francisco [Aug 2012 – May 2013] (Consultant)

● Software Developer, McKesson Corporation-San Francisco [Jan 2012 – Aug 2012] (Consultant)

● Intern-Quality Analyst, IBM-San Jose [Jun 2011 – Aug 2011] (Internship)

● Associate Consultant, Datamatics Global Services Limited – London,UK [Mar 2007 – Dec 2009]

● Software Programmer, Hewlett-Packard-India [Jun 2006 – Mar 2007] (Consultant)

● Intern -Developer, Citigroup - India [May 2005 – Nov 2005] (Consultant)

Visa Status: H1B

SKILLS MATRIX

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

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

Databases : Oracle 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.

PROJECTS:

● FIMA Project [Vanguard Group]

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.

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

● Affordable Healthcare Act Exchange Project [UCare]

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.

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

● Common Data Model [Cognizant Technology Solutions]

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.

● Paris Engine SOR Consolidation [McKesson Corporation]

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

● Infosphere BigInsights [IBM Corporation]

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.

● BUPA Database Development

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.

● SwiftForm Migration Tool [Hewlett Packard]

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