Varun Kumar Uppaluri

508-***-****

acosz2@r.postjobfree.com

SUMMARY

As a Senior Warehouse Administrator / Tech Lead / DBA Proficient in finding

ways for technology to add value to business operations and match company

objectives to produce supportive solutions. Over 17 years' experience

managing enterprise Application software/database implementations and

process improvement projects. Excellent track record in understanding

business requirements, Design cost-effective technology solutions, and

implementing solutions on time and on budget.

SKILL SUMMARY

Enterprise Application Development Expertise in BI, EDW

Project and People Management Netezza data warehouse

Data Warehouse Administration Oracle & SQL databases

IT Strategy & Planning Process Improvement

IT Cost Reduction Team Leadership

Application Architect Application & User Security

On Call Support Vender Management

Technical Leadership: Coached, mentored and lead personnel within technical

team environments. As a DBA, Project Lead and an Application Architect

actively contributed to the evolution of best practices, standards and

procedures for databases, applications and data warehouse environments.

Analyzed business needs to provide technology solutions.

Management Roles: Experience in managing small to large teams in private

and public sectors including IT and Non-IT. Being a believer of

improvement, made sure that the team members are given right opportunities

at the right time, thus facilitated successful project implementations.

Also managed production support teams as well as development teams using

pro-active management Methodology.

Project Management: Experience in managing projects for Public and Private

Sectors. Delivered high quality projects within the scope, on time, and on

budget. Extensive experience in managing enterprise IT project life cycle

through all phases. Experienced with various project management activities

like requirement analysis, procurement, sharing and team building, stake

holder communications and relationships, project planning, conducting

status meetings and continuous design improvement meetings, risk/impact

analysis and scope/change management.

Technical Netezza Warehouse Performance Appliances (Mustang 10100XL,

TwinFin N1001-010,020 & Striper N2002-020) Oracle 9/10/11i

databases, ETL Informatica 8.1.1/9.1.0, MS Project

2000/2003/2010, SQL Server, Analytical Tools (WinSQL,

Aginity Workbench for Netezza 4.0, Toad & Oracle SQL

Developer), Oracle eBusiness suite EBS, Oracle BI Tool

Discoverer, Oracle forms, Crystal reports, Websphere,

WebLogic, HP/enterprise monitor tools, Quality center,

performance testing tools

Processes Agile, Rational Unified Process (RUP), Scrum, SDIP, COMiT

Varun Kumar Uppaluri

508-***-****

acosz2@r.postjobfree.com

PROFESSIONAL EXPERIENCE: July '14 -

Current

Cablevision Systems Corporation, NY

Sr. DBA Netezza (Consulting)

. Netezza PROD Appliances (TF48, TF24, TF12 & Striper48) Regular

Maintenance & Monitoring make sure optimum performance & availability and

also perform Root Cause Analysis on issues.

. Automated all Maintenance & Monitoring job onto Oracle java based Appworx

Scheduler.

. Implemented Best Practices to improve performance & availability.

. Implemented WLM creating resource groups, allocating resource, assign

users to groups, Priority and job max settings

. Involved Software upgrade NPS 6.0.5.P4 to 7.0.4.4-P1 all three PROD

Appliances.

. Involved implementing Hadoop with HAWQ @ AWS with Redshift

ITD Boston, MA Dec '07 - July '14

Appliance Administrator/Application Architect/DBA

. Netezza Appliance Administrator Responsible for making sure all 16

databases performance, Backup & Restores, Host Backups and Data & Object

migrations with in the Appliance.

. Monitoring and Optimize Performance by altering Zone mapping and making

sure rearranging data segments and temp segments for data loads and user

queries.

. Responsible for high volume of data loads daily using bulk load process

utilizing NZLoader, NZMigrate & Informatica

. Perform daily and weekly maintenances nz_groom, Host catalog re-indexing,

Host Backups, nz_genstats, nz_health, nz_backup & nz_restors (Full &

Incremental)

. Applied Hot-bug fixes and also version patches for Netezza, Oracle, SQL

server and Informatica in Windows environment.

. Monitoring Daily Performance Metrics and take appropriate actions if I/O

out of Performance Metrics range.

. Created and Monitored WLM for Netezza Appliance to manage Work Load for

data loads and user query performance by creating and allocating resource

to resource groups.

. Managed Commonwealth Warehouse Netezza platform install & upgrade version

3.1.2, 4.0.2 (P1), TF 6.0.5 (P6), 7.0.4.4 (P1) & Striper 7.0.2, 7.0.4.4

(P1)

. Warehouse Lead Responsible for team of 15 to 28 members onsite and

offshore and Venders coordinating troubleshooting hardware and

performance issues and delegating tasks.

. Lead for Classic_mmars, MMARS, HRCMS, LCM, PMISCAPS, & U_MASS SQL Server

warehouse migration to new platform Netezza 4.0.2 (P1) & TwinFin 6.0.5

(P6)

. Administered Informatica PowerCenter V8.1.1 ETL development and upgrade

Informatica PowerCenter V8.1.1 to V9.1.0

. As Admin Managed Informatica 9.1.0 Repository & User Administration

through Admin Console.

. Managed Security FrontEnd application for Commonwealth user UAID's &

Roles maintenance

. On-Call support for CIW 24/7 load cycles

. Highly involved in Two CIW Major Infrastructure Upgrade Projects

recently one is in supporting role and second one is in Lead Role to

completion

Handling Vendor Management by dealing with IBM Netezza & Informatica to

resolve Post production upgrade issues and troubleshoot issues by creating

and follow through PMR.

Heavily involved in Vender Management

Heavily involved in Vender Management

Varun Kumar Uppaluri

508-***-**** acosz2@r.postjobfree.com

Dept. of Revenue, Boston, MA

Jun '04 - Dec '07

Sys Programmer/Sys Supv, PDPP (DBA/Tech Lead)

. Tech Lead Liaison, Analyst in the Office of Tax Policy Analysis (OTPA),

within the Massachusetts Department of Revenue.

. Tech Lead responsible for loading data from external data sources from

RMVA, DET, Bank Deposits into Lock-box Daily into Revenue EDW warehouse

. Supervised the development and maintenance of web based dynamic MassTax

applications

. Technical Lead for group creating MassTax EDW Revenue warehouse managed

about 15 consultants and 10 state employees

. Worked as a Liaison between Office of Tax Policy Analysis and RSI

(Revenue Solutions, Inc.) for developing of new Enterprise Data Warehouse

. Created and Maintain OTPA data warehouses with Oracle, and other

databases as needed

. Involved in development of Revenue Dashboard using Cognos 8 BI.

. Download the data from data warehouses for senior economists and Managers

to Created forms and reports in Oracle 9i, Microsoft Access, and SAS.

. Creating White Sheet and Flash Reports using Microsoft Access and Excel

from various sources and posting on DOR web site every month

. Responsible for designing and developing and Maintaining Discoverer 9i

EUL and Reports to accommodate senior economists and Data Managers

. Responsible for designing and developing software and database

applications to accommodate users' needs

Accenture Technology Solutions, Wellesley, MA

May '03 - May '04

Application Specialist/ Project Manager Consulting

Projects:

EMC (World Largest Data Storage Company) Westborough, MA

. Developed about seven Product Models for EMC Go to Market Project using

Oracle Configurator Developer version 11.5.9 (19-59). Responsible for

Design and Development of Models, and Writing Rules

. Responsible for BOM Refresh, Creating Item Types in Item Master and

Publishing Models Local and Remote.

. Managed Group of five members in US and Support Group of six from India

to make sure round the clock Development.

. Responsible for Taking care of TAR's with Oracle Development

Group.

. Responsible Testing, Bug fixing and Re-Publishing Models

every day.

Tyco SimplexGrinnell, MA

June '01 - May '03

CRM Implementation Group Lead/Project Manager

. Managed Oracle Application Release 11i and Database 9i implementation

(CRM Foundation, Sales Online, Marketing Online, Contracts, Customer

Service, and TeleSales)

Varun Kumar Uppaluri

508-***-**** acosz2@r.postjobfree.com

. Used Oracle Portal iProjects for implementation scheduling

. Managed implementation group of Developers and Oracle Consultants for a

total group size of fifteen both Functional and Technical

. Scheduled and Organized end user group and functional Manager group

meetings to gather functional specks

. Performed Data loads for the Oracle HR Module from People Soft HR and

Legacy systems. Loaded Customer and Contracts data into Oracle

Application Staging tables using SQL*Loader, PL/SQL and Informatica.

. Designed and Created Interfaces from People Soft HR to Oracle HR and

Legacy into Oracle Customers and Contracts

. Designed and Created WorkFlows for Sales & Marketing using Oracle Work

Flow 2.6 version

. Created Five Sales & Marketing Reports using Oracle Reports 6i

. Created Discoverer 4i reports for Sales and Service reps

. Created end user layer for financials to store metadata for Discoverer

reports using 4i

. Performed Q/A activities to ensure that reports meet the functional

specification

. Responsible for conducting weekly status meetings to make sure deadlines

were being met. Dealt with third party vendors like D&B [1]and Blue-Light

to obtain scrubbed Customer Data and Sales Lead data

MIT Cambridge, MA

August '99 - May '01

DBA/Application Developer Level 3

. Designed and Developed database schema for RolesV2 Application using

Oracle7.3.4 and 8i(8.1.7)

. Performed data loads from RolesV1 using various methods SQL*Loader,

PL/SQL Procedures, and Perl Scripts

. Created PL/SQL Triggers to check Authorizations to Add,

Delete, and Update data

. Created four useful Audit Trail report from Roles Application

using Perl scripts

. Created web pages showing Roles Application Schema and Audit Trail

information using HTML, CGI and Perl DBI

. Responsible for Data Warehouse daily data loads and Created Oracle

Reports from Warehouse using Brio 5.5

EDUCATION

M.S. Health Sciences & Information Management, Howard University

B.S. Biology & Chemistry, Nagarjuna University, India

Technical Training:

. PMI (State sponsored Program) from UMASS Boston May '08

. Cognos8 BI Tools

June '06

. BASE SAS Windows 9.1 Umass, Lowell

Sept '04

. Oracle Release 11i Use and Administer CRM Foundation

Oct' 01

. Oracle Discoverer 3.1 Admin course

March' 00

. Data Warehousing using Microsoft SQL Server 7.0

March' 99

Contact this candidate