Shireesh Reddy Mettapalle

+919*********

acggxv@r.postjobfree.com

[pic] Technical Lead

Technical Lead with 12 years of IT industry experience. Excellent

technical, analytical, communication and presentation skills. Keen

understanding of business priorities, genuine team player committed to

managing operations and projects in cost-effective manner. Experience in

managing onsite and offshore teams. Easily interfaces with higher

management executives, vendors, and business users.

* IT architecture (DWH, OLAP, OLTP) *

Automation/Innovation * Domain knowledge in

Finance, Services & Marketing * Change/Scope Management

* Good exposure to Oracle,

Teradata, OBIEE & Hadoop * Solutioning/Design/Problem solving

* Strong

expertise in SQL & UNIX shell scripting * Data Analysis

& Dimensional data

modeling

Accomplishments[pic]

. Lead Data Integration Enablers for building the automated solutions

for ETL code check & performance check tools, these tools resulted in

reducing the standard related errors and improved the code quality and

saved ~ 160 Person Days each per quarter.

. Successfully launched DOT - Disti Automation Tool to improve 2-Tier

service contract opportunities for Cisco and the distributors, post

implementation this solution contributed to increase the business by

20M per annum Vs earlier manual reports.

. Contributed & recognized for building the next generation talent pool

within my group.

. Recognized for consistent success in delivering IT Projects,

developing the processes to streamline the operations and enhance

strategic improvements to align with organization's objectives.

Professional

Experience[pic]Cisco Systems, Inc, Bangalore

Jan 2013 to Till Date

Technical Lead

Brief description of the projects:

GTC: Transforming GTC's reporting capabilities by building a new Data

warehouse that will consolidate processes related data that is residing in

different systems. This new data warehouse will provide accurate, secure,

and trusted solution that can be flexible, scalable and integrated to

support & enhance reporting abilities through front end reporting tools.

SSC: The objective of the SSC Initiative is to leverage EDW Platform as

single source of truth for all the reporting requirements coming out of

Service Supply Chain. Currently the process for extracting data from Xelus

and preparing New Buy Budget and Status reports is tedious and causes

excess costs for Cisco. If the process for preparing these reports is

automated, comes from a single source of truth, and displayed in a user

friendly format, it will lead to more insight and better decision making

capabilities and planning for Cisco's Service Supply Chain. Ultimately,

this will increase the value for Cisco's customers and stakeholders

Responsibilities:

. Analyzing & understanding requirements and providing the management

with a detail design of how the system and data would flow through.

. Designing & creating complex mappings using various transformations

and developing strategies.

. Validate source data is consistent with data mappings

. Participated in requirement gathering session with business users to

understand and document the business requirements and the goals of the

project

. Worked on data profiling and data validation to ensure accuracy

between source and DW

. Resolving issues which are related to the development phase.

. Developed and maintained technical documentation regarding the

extract, Transformation and load process.

. Adding issues and providing resolutions to the issues in the issue

tracker which raise during the development, QA & UAT stages.

. Implemented Proof of Concept (POC) projects using agile methodology in

the EDW sandbox environment, exhibited the same for the business

groups for their buy in before implementing the robust & full-fledged

solutions.

Cisco Systems, Inc, San Jose, CA (Client) Apr 2012 to

Dec 2012

Technical Lead/IT Analyst SRS Consulting Inc

Client: Cisco Systems, Inc, San Jose, CA

QBR (Quarterly Business Review): QBR is an ongoing Run the Business review

and it's an executive level dashboard providing convenient, centralized

access to the most important organizational metrics including Finances,

Employee Experience, Operations, Market Share and Software.

Responsibilities:

. Analyze data requirements and develops ETL solutions to support Data

Warehouse initiatives.

. Participate in database design discussions, collaborating with Data

Architects and reporting Specialists to ensure the database designs

are accurate and that they support efficient reporting

. Assist in the identification and resolution of inefficiencies in ETL

designs

. Validate the ETL designs for accuracy and performance, identifying

opportunities for improvement.

. Analyze the impact of source system data design changes as they relate

to existing ETL solutions and makes appropriate changes to existing

ETL solutions

. Perform analysis to prevent data redundancy across systems and employs

data integration best practices

. Perform data profiling, understands source data, and designs ETL

solutions to accommodate any nuances that may exist

. Work with implementation team to ensure smooth deployment of packages

and ensures resolution of outstanding issues

. Created dashboards and reports in OBIEE Answers.

Cisco Systems, Inc, San Jose, CA (Client) Oct 2007

to Mar 2012

Technical Lead/IT Analyst Links Technologies

& IT Objects LLC, San Jose, CA

Disti Automation Tool (DOT): Sucessfully executed & implemented a UNIX

based solution engine. Disti Automation is a "2 Tier quote and Order"

initiative, which is designed to drive increased revenues and profitability

for distributors around the world through more automated and streamlined

processes. Distributors have a demand for accurate and current reporting on

uncovered, renewable and eligible product inventory. This tool eventually

helped to increase the opportunity/business by 20M per annum (compared to

earlier manual reports).

Marketing Data Warehouse (MDW) was a data migration project from ODS to EDW

(3NF model). MDW provides reporting capability to business data from an

analytical, rather than operational perspective.

As a Technical Lead/IT Analyst was responsible for analyzing &

understanding requirements and providing the management with a detail

design of how the system and data would flow through. Designing & creating

complex mappings using various transformations and developing strategies.

Resolving issues during the development & test phases. Perform technical

analysis and recommended IT solutions including defining business problem

statement, current state analysis, risk analysis, business impact analysis,

technical designs & business process flow diagrams.

Charles Schwab, San Francisco, CA (Client) Aug

2004 to Sep 2007

Team Lead/Systems Analyst iGATE Global Solutions

LTD

Successfully developed decision support systems (Credit Card Banking &

CLEARS+). As a tech lead responsible for understanding the Business

Requirements. Communicating effectively with the client & with the users.

Creating the ETL Design specifications which help as LLD for the ETL

development. Developed and maintained technical documents. Monitoring

progress of specific testing activities against plan, and successfully

completing testing activities within the requisite project timeframes.

Career Note: Additional experience as an ETL/Database Developer for Texel

Consultancy in Bangalore

Education

[pic]

Master of computer science, S.V.University, Tirupathi.

Technical Skill Set

[pic]

ETL Tools : Informatica 9.x/8.x/7.x, Hadoop

Languages : SQL, PL/SQL, UNIX Shell scripting

Operating Systems : UNIX, Windows

Tools : TOAD, Teradata SQL Assistant, SQL Loader, ER

Studio

Databases : Oracle, Teradata, MS Access

Dimensional/Data Modeling : Star / Snow-Flake Schemas, logical &

physical data modeling

Job Scheduling : Autosys, Dollar U, Informatica Scheduling

BI Tools : OBIEE, Excel

PM Tools : OpenProj

Contact this candidate