Data Warehouse

Pushkar Basappa

****, ** ****** ****, ********* J 81, Gainesville, FL 32608

Website: http://www.cise.ufl.edu/~pushkar/ Email: abo8il@r.postjobfree.com Mobile: 352-***-****

Objective

Seeking a full-time opportunity in the field of computer science and engineering that leverages my skills, creativity, technical

knowledge and professional experience.

Education

Master of Science, University of Florida, Gainesville, FL. [Dec 2011]

Major: Computer Engineering. GPA: 3.53/4

Bachelor of Technology, National Institute of Technology Karnataka, India. [2008]

Major: Information Technology. GPA: 7.53/10

Professional Experience

Teradata Corporation [May Aug 2011]

Engineering Intern

Research and Development, Quality Assurance Solution Integration Team, CA

Projects

Ecosystem Customer like ETL test harness

Tool simulating customer like workloads and ETL processes using User Defined Functions.

Development of LoadStreams and LoadTasks using Teradata Load Utilities.

Design and Development of different phases of the tool like, script creation, package creation, ETL coding, custom

Teradata UDF creation, error detection, error handling, data logging and job scheduling using Linux CRON.

Created a comprehensive installation and programmer s guide for the tool.

Technology: Shell Script, C, Teradata Utilities FastLoad, MultiLoad, TPump, Teradata Parallel Transporter, Teradata Stored

Procedures, BTEQ, CRONTAB, ClearCase.

Oracle Corporation [2008 2010]

Applications Developer

Health Sciences Global Business Unit, India.

Projects

Enterprise Healthcare Intelligence Operating Room Analytics and Provider Supply Chain Analytics

Development of dashboards, reports, and OBIEE repository.

Design of Star Schema for Data Warehouse and Data Mart.

Implemented benchmarks and targets feature for the complete enterprise data warehouse product, by creation of multiple

views on existing imported physical tables.

Technology: OBIEE, SQL, MS Visio, JavaScript.

Oracle Healthcare Data Warehouse Foundation comprehensive Healthcare Data Warehouse Solution

Designed Patient Subject Area involving the logical modeling of data warehouse tables.

Deployed the data model for the concerned subject area by creating scripts and loading business test data.

Involved in documentation of user development guide describing various design and development processes.

Technology: SQL Data Modeler, SQL, PL/SQL, SQL Developer.

Business Intelligence Tool Integration

Worked on integrating two of the most popular business intelligence tools while creating a product for Quintiles, one of

world s largest Customer Research Organization.

Creation of OBIEE dashboards, reports and repository for the product.

Integration of Virtual Private Databases with OBIEE to enable differential information sharing with clients.

Merging of existing Cognos Product with OBIEE dashboards.

Technology: OBIEE, SQL

Computer Skills

C, C++, Java, JavaScript, HTML, CSS, SQL, PL/SQL.

Computer Languages:

Eclipse, Oracle Business Intelligence Enterprise Edition(OBIEE) 10.1.3.4, Oracle SQL Data Modeler,

Tools:

Oracle SQL Developer, Informatica Powercenter 8.6, Oracle Data Integrator 10.3, Microsoft Visio

2007, FL Studio 8, Sony Sound Forge 8.0.

Windows, Linux.

Platforms:

Related Coursework

Concurrent Programming, Computer Architecture, Analysis of Algorithms, Advanced Data Structures, Bioinformatics, Database

implementation, Individual study on spatial databases, Computer Networks, Database Management System, Distributed Database

Systems, Graph Theory.

Projects

[2011]

Representation of Spatial Objects and predicate calculation on Spatial Data Types

Implementing spatial object representation using originally designed spatial data types from the paper

published by Dr. Markus Schneider in 2009 titled Topological feature vectors for exploring topological

relationships .

Technology: C++, Java, HTML.

[2011]

Database Implementation

A system level implementation of a Relational Database System in Linux platform. Involves development

of various data structures to handle processing of large volumes of data, coding the mechanisms to handle

various database operations like Select, GroupBy, Distinct etc.

Technology: C++.

[2011]

Data Extractor

Developed a program to perform an IP and domain name search by parsing the data present in emails for a

problem described by MailShell, an internet security firm.

Technology: C++.

[2010]

Parallelized Protein Sequence Aligning and Phylogenetic tree construction

A Multi-threaded implementation of phylogenetic tree construction and protein sequence alignment

program using Dynamic Programming algorithms like Needleman Wunsch Global Alignment and Neighbor

Joining.

Technology: Java, C++.

[2009]

ETL tester and Data Loader

Created an ETL testing tool to verify the coding of business rules and verification of business data

transformation from transactional database source systems to target data warehouse tables in ETL codes.

Technology: PL/SQL.

[2008]

Process Migration in a Distributed Computing Environment

One of a kind demonstration of migration of half-baked processes in a distributed computing environment

using a non-checkpoint recovery based system. The system can be used for load balancing in distributed

computing.

Technology: Linux, Assembly language.

[2006]

LAN-CHAT

Thread based implementation of chat program demonstrating client-server programming. Also implemented

voice over network along with conventional text chat application.

Technology: Java.

[2006]

Software Defined Radio

Researched on network protocol algorithms suitable for ad-hoc networks and implemented Bellman-Ford

routing protocol to be implemented in a Software Defined Radio.

Technology: C.

Achievements and Other activities

[2002]

Selected as a National Talent Search Examination Scholar.

[2005]

Runner up in Shristi for showcasing an innovative idea to harness tidal energy.

[2005]

Runner up in Enterprise, for showcasing innovative methods for tapping renewable sources of energy.

[2008]

Joint Convener of Rural Innovators 2008 and Executive member in Engineer 2008, a national technical

symposium.

Contact this candidate