Project Data

Varun Vemala Contact

Phone: 408-***-****

Email : *****.***@*****.***

Profile

Objective

To build on my wealth of knowledge by learning new technologies and dealing with

challenging problems by providing innovative out-of-box solutions.

Experience

8 years

Key Skills

Proficient with a vast array of programming languages, concepts and technologies,

including:

HANA, Teradata, Oracle, Pro *C, PL SQL

C, C++, C#.NET,

HTML

HANA Studio, Eclipse, Toad, MS Excel,

Mac, Windows, UNIX

Experienced with tools and technologies like:

Shell Scripting, Perl,

Visual Studio 2005,

Data Warehouse

Waterfall Model

ASP.NET, XML

MS Access, SQL Server

Cloud Concepts

Agile Development

Work Experience

Infosys Ltd.

June 2006 - till date

Excellent track record in End to End delivery of multiple Medium to Complex

Projects involving multiple technologies and challenging clients like Apple Inc.,

SYMCOR, Canadian Pacific Railways etc.

Vast Hands on Experience in all phases of project lifecycle starting from

Requirements Gathering, Architecture & Modeling, Design, Coding/Development,

Implementation, Testing, Maintenance, Support and Documentation.

7+ years of extensive development experience in multiple databases - ORACLE,

Teradata and SAP HANA.

Skilled in UNIX operating system.

Well versed in design and build of utilities like Cron Jobs, Middleware

technologies like IBM MQ Websphere

Experienced in leading a team of 10, with varying experience and knowledge in

different technologies.

Competent in multiple domains including Retail, Railroad and Banking.

Excellent Communication and Presentation skills. Significant Problem-solving and

Analytical abilities.

Recent Projects

Treasury - Apple Inc.

4 Months

Treasury project in Apple was to build and deploy user reports to manage Apple

funds. Most of the data that were dealt with was highly confidential as it

involved investment strategies and market data for Apple Inc. and was directly

overlooked by CFO.

Business users needed to see the reports on real-time data in order to manage the

investments and design strategies with best possibilities. SAP HANA was considered

because of the processing speed and ability to generate reports on real-time data.

The technical scope of the project included:

Setting up of SLT table replication from SAP ECC to SAP HANA.

Design & Build multiple SQL Procedures as well as Attribute, Analytical &

Calculation Views in HANA to process the data through complex business logic.

Project the data through Analytical Views or Calculation Views to either BW

Infocubes or Excel AO Reports.

Opportunity Cost POC - Apple Inc.

3 Months

Opportunity Cost was a Proof of Concept built to check the technical feasibility

of introducing SAP NetWeaver Gateway to read SAP HANA models and generate oData

services, which will then be consumed by SAP UI5. Data will be presented to users

as charts and tables. Apple product sales data was used for this POC.

The POC objective was to analyze the payments made and to identify any missed

opportunities for discounts. It also included ability to identify any duplicate

payments that were made by mistake. Business users had the options to view the

data via multiple dimensions - Top 10 Vendors, Invoiced vs. Non-Invoiced, Direct

vs. Indirect, Early Payment vs. On-Time Payment vs. Late Payment, Quarterly data,

Yearly data etc.

The technical scope of the project included:

Setting up of SLT table replication from SAP ECC to SAP HANA.

Setting up of Repository and Project in SAP HANA, to enable revision history

maintenance.

Design & Build HANA SQL Procedures to process the replicated data through complex

business logic.

Design & Build HANA Calculation Views to call the procedure and project the data

after handling the required currency conversion.

COPA POC - Apple Inc.

3 Months

This Proof of Concept was developed to check the practical ability to build user

reports on massive real time Sales data. The prototype was to test if existing

manual effort in analyzing the COPA data could be reduced and also to check the

feasibility of increasing the quality of data displayed to the business users.

Data was loaded into HANA where all the intricate business logic was built in HANA

Models. BW Infocubes then consumed these models and final data was projected via

reports that were built as per user demands.

The technical scope of the project included:

Build HANA SQL Procedures to process the data through complex business logic.

Design & Build HANA SQL Procedures to process the replicated data through complex

business logic.

Design & Build HANA Calculation Views to call the procedure and project the data

after handling the required currency conversion.

Tune the HANA code to meet the Apple Performance benchmarks.

Inter Company Reconciliation - Apple Inc.

8 Months

Inter Company Reconciliation (ICR) was a project that helped Apple Inc. to manage

transfers of funds and documents between various other companies like Sony,

Google, Microsoft, etc.

The objective of this project was to identify the documents sent by various

companies and match them with the documents sent by Apple, based on multiple

rules. Any unmatched document was to be presented to the users through a front-end

tool for their matching criteria.

Finally a consolidated report was to be sent to multiple vendors and clients

describing the documents that were matched for a particular period and the

Financial Status with Apple Inc.

Every single document was to be treated as Highly Critical as it had a direct

impact on Apple brand value. All the deliverables were Highly Confidential because

of the market competition with Apple.

The technical scope of the project included:

Setting up of SLT replication from SAP ECC to SAP HANA.

Design & Build HANA SQL Procedures to process the replicated data through complex

business logic.

Design & Build HANA Calculation Views to call the procedure and project the data.

Schedule Cron Jobs on UNIX server to call various Procedures and process the data

on a regular interval.

Tune the HANA code to meet the Apple Performance benchmarks.

Media Decouple - Apple Inc.

1 Year

Media Decouple was a project built to improve the performance of the existing

system by making the entire process to run in a Parallel Mode.

The Project consisted of 106 Informatica Interfaces, each of which had a Unix

component to call the Autosys jobs and a Teradata component that hosted the data

being processed.

The objective of the project was to decouple the existing system and to run all

the possible sub-parts in parallel. It also included in separating the highly

critical interfaces from the other interfaces there by reducing the impact of

failures. The single job that was scheduled for the entire process was split into

a sequence of multiple jobs that were triggered to run in parallel.

After the project was deployed, Apple could see an improvement in processing time

by a factor of 60. Also the failure rate had reduced by 20%.

The technical scope of the project included:

Setting up of Data load from flat files into Teradata Tables through Fast Load.

Design new Teradata Procedures to process the loaded data parallely for multiple

interfaces.

Load the processed data into Tables and build multiple Views on the table to

project the data as required.

Create new Cron Jobs to call the loader programs on a scheduled basis for each

interface.

Design & Build monitoring Jobs and Procedures to check for any issues in the

entire setup for processing data parallely.

Parametric Reporting - Apple Inc.

4 Months

Parametric reporting functionality was the new Reporting Solution which was

implemented to enhance / provide a new way of retrieving required data in detail

level within a realistic refresh rate of 10 to 20 seconds. This project allowed

the user to apply the parameters in one pass, rather than applying it multiple

times for multiple views or reports.

The project objective was to implement an intuitive solution, which helped in

improving the end user reporting experience by overcoming the current limitations

on the huge reports, which require lot of data. It allowed the users to enter the

reporting suite and let them to ask questions by selecting parameters via a portal

and running this selection on demand.

The technical scope of the project included:

Building of new Teradata Procedures to implement Business Logic and load the data

into Tables.

Building of new Views on the processed data for users to access.

Set up Unix Cron Jobs to call the procedures as per the required schedule.

Subject Area Database - Canadian Pacific Railways

3 Years

The SADB (Subject Area Database) is the central repository of the entire corporate

data used by a huge set of applications in CPR (Canadian Pacific Railways).

Multiple applications interact and store their data in SADB. The purpose of this

database is to integrate all corporate data required by the organization and to

ensure the maximum availability of business validated data.

This project involved providing support and maintenance of 42 SADB applications

for Canadian Pacific Railways. It included solving production incidents and

handling service request from business users. It also and involved in

incorporating enhancements to applications on a regular basis to improve the

overall interaction with the database.

The technical scope of the project included:

Support and Enhancement of Oracle Procedures, Tables and Views

Monitoring of messages in IBM MQ Websphere

Support of various UNIX jobs and scripts.

Accolades

On the Spot Award by Infosys Ltd for developing innovative and automatic data load

tool

Award of Excellence by Canadian Pacific Railways for exceptional performance in

delivery

Award of Appreciation by Canadian Pacific Railways for outstanding improvement and

results in support & enhancement

Education

2002 to 2006

Bachelor of Engineering in Information Science & Technology

M.S. Ramaiah Institute of Technology, Bangalore

2000 to 2002

Pre University in Computer Science

Seshadripuram Pre University College, Bangalore

Personal Information

Date of Birth

15 April 1984

Nationality

Indian

Contact this candidate