Sql Server Data
Resume:
SAI KRISHNA TARAPAREDDY
***********@*****.***
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