SAI KRISHNA TARAPAREDDY

314-***-****

ace46s@r.postjobfree.com

SUMMARY

. Experienced in Microsoft Technologies and worked as a Tech Lead in Data

services\Data Analysis team. (Data Analysis, Web services and Stored

Procedures).

. SAP HANA Certified Application Associate.

. Worked as SAP HANA data modeler, SAP BOBJ(WebI, Universe,BODS)

. Have Strong DB skills (Oracle,Sql Server,DB2)

. Strong data analysis experience.

. Developed many tools, products in C#, VB.NET to help junior developers

to improve productivity, uniformity and turn around time.

. Visual Studio 2010/2008/2005 / 2003 (WCF,C# 4.0/3.5, LINQ, VB.NET,

ASP.NET, ADO.NET, SOA, AJAX).

. Designed and Developed web sites using ASP.NET Web Services, XML,WCF

. Designing databases in MS Sql Server 2008\2005\2000,Oracle

. Developed Oracle Packages using Oracle 10g, 9i, PL\SQL. and helping

developers in SQL performance tuning.

. Reference data skills and ETL experience.

. Harvest, CVSNT and VSS as code repositories and AntHill Pro as

deployment tool.

. Good experience with ETL Tools: DTS, Ascential Data Stage.

. Production support.

. Involved in conversion projects (VB to VB.NET, C#, ASP.NET and

Mainframes to C#).

. Programming and Database model knowledge of financial subject areas

like Account, Securities, FC/REPS, Branch and Positions.

. Involved in Analysis, Design, Development, Testing and Maintenance of

many financial project life cycles.

PROFESSIONAL EXPERIENCE

Company HCL-AXON

Duration July 2013 - March 1 2014

Position SAP HANA Modeler

HANA - POC 1 (Converting Customer Profile BW Cube as HANA Models and

Analyze the performance improvements)

Responsibilities

Analyzing BW Customer profiling (based on Hydro One data model).

Creating corresponding master, transactional tables in HANA

Loading data into HANA tables using CSV files & using BODS

Developing information models (Attribute, Analytical, Calculation views)

Exposing and consuming these models onto BOBJ Reporting tools (Explorer

& WebI).

HANA - POC 2 (Side Car Approach, HANA Enabling EMF Framework

application)

Responsibilities

Identifying EMF ECC tables that are used in the ABAP application.

Creating ECC tables on to HANA.

Extracting the data from ECC as excel files and loading on to HANA

tables.

Modifying ABAP code to connect to HANA tables as secondary DB.

Analyzing performance of the ABAP application.

Wells Fargo

May 1999 - Jun 2013

Senior .NET\Database Programmer (.NET\DB)

Projects:

Client Financial Review (Visual studio 2010,VB.NET,C# 4.0,SOA,WCF,Entity

Framework, Oracle, Pl\Sql)

CFR is developed to automatically analyze the client's financial position

for each quarter based on some indicators and key figures in database.

. Involved in developing WCF web services to fetch data from ODS and

perform business logic to generate the multiple reports.

. We have followed Wells Fargo's SOA standards in this project.

. Developed packages and stored procedures on the backend.

KnowYourCoustomer-II (KYC-II) (VS2010, VB.NET, C# 4.0, ASP.NET, Oracle,

DB2, Pl\Sql)

KYC-II is an application that's part of Supervision and Compliance

application group. Every night a batch process will determine the accounts

that need to be flagged and alerted for different reason. That account will

be loaded in to KYC database and those are viewable by users and analysts

through the KYC web app.

. Involved in designing the database

. Developed packages and stored procedures on the backend, coding the

Website using ASP.NET.

Report Catalog (VS 2008 (C#,ASP.NET),SQL Server,Oracle,DB2,AJAX)

This is a one stop shop that caters many users and group related to actuate

reports.

It shows all the details about all Actuate Reports. Here you can find out

all the information about each report and its properties, statistics,

capacity forecast and impact analysis.

. The Data analysts, App teams hugely benefit from this because they can

use this for Impact Analysis (if they plan to change a DB table, they

can find out all the reports that use the table and see if there is any

impact to them, Which is otherwise manual and time consuming).another

feature of this website is sample report template for each report and

for any missing template we can upload the files.

IRSCB (IRS Cost Basis): (SQL, Oracle and DB2)

Usage: by IRSCB department (for TAX related information),First Clearing

house, BETA to reconcile differences.

Future state: As this is an ongoing activity for each year especially at

the starting of the year for TAX info, we are investigating how best we can

automate it.

. Wrote complex queries against BDW, ODS Tax lots, Account and Securities

tables using different filters based on the dynamic business

requirements. The results are used to compare the data against BETA

values and to catch any differences. Without this process risk of data

validation increases.

. Used session tables to increase the performance of these queries.

SOA Data Services (VB.NET,C#,WCF, Oracle 10g,Pl\Sql,DB2)

. Responsible for developing C# web services for enterprise applications

for application teams. These web services will expose different data

services (oracle packages\stored procedures) for different subject

areas like

o Accounts (ECN,Red\Blue,RetreiveAccountDetails)

o Securities

o Trades

o Positions

o Employee and Branch (Org)

o FC (Financial Consultants)

SOA Request Website(C#,ASP.NET 3.5,Oracle 10g)

. Developed a website where all service requesters, data analysts can

enter their requests; fill in the data mappings and all other service

related information such as status, dates, cost center info etc. This

website has many features like Try services before some app teams

decide to use, Usage logging reports, SLA Contracts, Service Outage

and Usage Document. Developer can get the WSDL of their services from

here.

Stored Procedure Generator Tool (VB.NET,C#, WinForms.NET, Oracle 10g, TOAD)

. Wrote a tool in C# to generate code for Oracle packages based on some

inputs from SOA infrastructure tables that the service requesters will

put in through SOA Inventory website. This maintains the uniformity of

code with standards enforced all the way. This reduced the development

time of oracle packages from days to hours.

. Developed a dynamic web report generator using ASP.NET 2.0. Developed a

template in a way that it only takes some minutes to develop any

report. All we need to have is an underlying SQL.

The key features of this are

o You can dynamically choose what fields\columns you want to see on the

report

o You can dynamically filters like WHERE, IN, LIKE clauses.

o Can be extended easily to go against different data sources.

Password Change Utility(C#,ASP.NET 2.0,Oracle,SQL Server,Oracle, Sybase)

. Developed this small webapp to enable users to change their database

passwords, The DBAs and ADMIN group can use this tool to change

passwords for all. All the activity like who changed, when, success or

failure etc will be recorded in a table.

HostScans (C#, VB.NET, SqlServer, Oracle, Sybase, ADO.NET)

. This is a windows service that scans all the Oracle/SQLServer/Sybase

servers in our department everyday and updates statistics on

Databases, Users, Connection, Roles, and Role members.

. Was a helpful tool for all the DBAs and Security Department.

WebHMDB (Host Management Data Base) C#, ASP.NET

. Website used to manage information about Database servers, Instances,

Databases, Logins for SQL, ORACLE database servers. All the DBAs use

this to see dynamic reports directly from system tables.

GATEWAY CD R1 ETL (Data warehousing using Assential ETL Tool, MQ Series,

Oracle)

. Data mappings, Data Extractions, Transformations and Data Loading

using Ascential Data Stage ETL tool.

. Involved in Transforming and Loading the AccountRef Data from Himalaya

Servers to ODS (Open Data Source) which is a Oracle 9.1

SQL Data Access Block (VB.NET, ADO.NET, SQL Server2000, Windows 2000)

. Wrote a ADO.NET Data Access Component for SQL Server/Oracle

developers. This is a wrapper on top of the .NET objects. Through this

component they can get Data Adapters, Datasets, Data Readers,Data

Tables and Data Rows back from the database.

This component also includes the implementations of

o Execute NonQuery

o Execute DataSet

o Execute DataReader

o Execute Scalar

o Execute XMLReader

Resource Allocation Reports (VB.NET, ASP.NET, ADO.NET, SQL Server2000,

IIS6.0, Windows 2000)

This project contains two parts.

. Part1 is exporting a excel file to a text file and parsing the text

file for some key words, like resource name, time, projectnm, manager

etc and saving the information in to SQL Server database.

. Part2 is showing that data in to web forms using ASP.NET. These

reports include reports by project, resource name, manager, activities

etc

Up Time Details (VB.NET, ASP.NET, ADO.NET,SQL Server2000, IIS6.0, Windows

2000)

This is a live Up time Status of the each Sql server in the enterprise. Can

drill-down to minute level statistics on each server.

. DBA's and Manager scan Know How many connections were open at any time

Know what is the Percentage of DB uptime

Web Monitor (VB.NET, ASP.NET, ADO.NET, IIS6.0, Windows 2000)

This is a live real time monitor, which displays the status of COI server

piece to the production control users.

Through this they can

. Know which reports are currently in process.

. Any alerts (errors) while process

. How many reports processed in any selected date.

. Details of any reports

. Hot list reports

. Administrative Functions to Super Users.

COLD OPERATIONS INTERFACE (COI) (VB 6.0, SQL Server 2000, Crystal Reports,

Windows NT)

The main purpose of this project is to control the flow of report

processing.

COI takes all reports one by one and process them through 3 stages 1.

Reconcile 2.Convert 3.EOD. Convert & EOD processes invoke the StorQm

(Which is a 3rd party tool to convert reports) executables and they create

their corresponding logs and COI stores all the info it need to database.

The EOD was done using DCOM architecture.

The COIMONITOR is the front-end for COI Server processing which always

watches the database. It lets the users know what is currently running on

the server. It also enables them to view the details of report Information.

Mainly involved in software development of client/server programs using

Visual Basic & SQL Server.

. Other responsibilities include low level designing, Code development,

. Testing and implementation.

. Third party controls like StorQm, Sheridan 3d Control, SSTab

. Using ADO

. Using COM/DCOM components for business rules

. Production Support

. Writing Stored Procedures

. Writing Mail Components

. Developing COIMONITOR

. Used Crystal Reports as reporting Tool

. Involved in DBA activity for COI Database (Designing, Creating

Databases)

. Using DTS for Data transfers between different SQL Servers

(Production, Staging, Development)

. Using Back up procedures

. Writing triggers on tables.

TAXONOMY (VB6.0, Crystal Reports, SQL Server2000 (Stored Procs, DTS etc)

Windows2000)

EAP TAXONOMY Component is a highly visible application that is used by

Managers and Domain Chairs in the enterprise.

This project enables the management to come to a consensus on all products

in the Enterprise. The SQL Server Database contains all the information

about all these products. This information is presented in a " Tree View "

model to the managers. Through Taxonomy each product goes to 6 stages. Each

stage represents the Status of the product. Through TAXONOMY they can

project all the dates for all these six stages (from Research to Retired).

There are many reports that can be generated from the Application.

. Used crystal reports as the reporting engine.

. Developed various kinds of reports.

. Created DTS Jobs for getting Data from different sources in to SQL

Server.

. Developed complex stored procedures and triggers.

INTELLISTOR MAIL SYSTEM (IMS) VB6.0, SQL Server2000, SQL Alerts

IMS is an automated mail system component used to mail different users

based on different conditions. In AGE we use 3rd party tool called

INTELLISTORE to process thousands of firms priority reports Daily. And

thousands of brokers through out US will be looking at them. This utility

sends mails to those users who are subscribed to this system whenever any

report they are interested in completes processing. This enables them not

to be in waiting for the reports.

PLATTER TRACKER (VB.NET, SQLServer2000)

This application tracks the entire platter drive and stores the information

in to database. This runs as a scheduled task daily at 5 am. This

application gathers all statistics about platters. Each platter is a folder

in the drive. For each platter the Created Date, Modified Date, Last

Written Date, Total Space, Available Space are updated each day.

DISK FREE SPACE (DFS)(VB6.0, Oracle 8)

DFS is an application runs once a day at 6 AM and updates the Database. It

gathers information about all the Servers in our Department. It collects

the Data about all drives on specified servers. All these servers and

drives are kept in a Configuration file.

EDUCATION

1993 - 1997 Andhra University Vizag, AP, INDIA

Master Of Computer Applications

Contact this candidate