Srini Yalavarthi

Ph. 630-***-****, E-mail. abh680@r.postjobfree.com

____________________________________________________________________________

__

SUMMARY

Multi-talented and action oriented hands-on manager and data warehouse

architect with 15 years of experience in client server, object oriented and

legacy applications with financial, medical, Insurance, Retail, Credit

Bureau, Telecommunications, Real-time Digital satellite networks and e-

Commerce background.

Strengths in data warehouse architecture, technical hands-on leadership,

enterprise applications research, analysis, proof-of-concept design,

prototype and development. Known for comprehending complex business

processes, decision-making skills, problem identification and recommending

best of the breed solutions.

SKILLS SUMMARY

O/S: HP UNIX, Sun Solaris, QNX, AIX, Windows, Wintel, VAX/VMS, MVS, Tandem

Languages &Tools: IBM DataStage, DataStage PX(7.x,8.01), ProfileStage,

MetaStage, Informatica, Cognos, Business Objects XI, C/C++, Oracle

8x/9i,10g, SQL Server 2000, Visual basic 6.0, TimesTen, ERWin, Teradata,

AutoSys, DB2, IMS DB/DC, Java, TCL/TK, PL/SQL, JCL, OSH, Vignette Story

Server, Web Logic, Sybase, Cold Fusion App Server, XML, Jscript, MQ

Series, Visio, Visual Interdev, Source Safe, Test Director, Content Share

(GVG), UML, Rational Rose 2000, TOAD, ER Studio, EMC infoMover, gdb, CVS &

Vertex.

Employment History

ASHTECH SOLUTIONS, INC., IL Apr'08 to Present

Technical Architect & Lead

Project: Baxter International Inc., Time On Therapy (TOT)

. Lead Architect for design and development of TOT (Time on Therapy) data-

warehouse, which is being delivered by geographically dispersed in-house

and outsourced vendors.

. Created ROM project estimates for business case. Assisted in business

case drafting.

. Managed enterprise application integration milestones & project risk

mitigations while working with PMO team to deliver on-time and within

budget.

. Led detail source to target specifications, master data specs, logical

and physical database design, development and integration and deployment

strategy.

. Worked with business segment owners to coordinate technical/business

transformation requirements gathering.

. Designed and led development of complex ETL jobs for data aggregation,

transformation, cleanse & load into DW using DB2, Oracle 10g, IBM Info

Server (DataStage).

. Designed/developed external processes for IBM DataStage jobs using Shell

scripts.

The Warranty Group (AON Warranty Group), IL Oct'06 to Feb'08

Sr. Technical Architect/Manager

. Architected Error Management system for automation of the enterprise ETL

processes at TWG to increase support team response time over 90%

. Lead Architect for detailed design and development phase of DDR and VIP

Enterprise data-warehouse.

. Lead the team of 12 architects and ETL specialists to deliver

architecture, application integration, interface design and data porting

strategies which outcomes 130K cost savings.

. Executed Project tasks on-time, managed project risks & technical

delivery challenges

. Architected/designed and ETL jobs development for source data

aggregation, transformation, cleansing, and loading in Data marts using

DB2, Sort, Merge, IPC, Webservices, Link Collector, Hash, Pivot etc.

. Designed/developed external processes for IBM DataStage jobs using Shell

scripts.

. Increased flow performance by 60% by optimizing mappings and sessions by

identifying bottlenecks and eliminating them.

ASHTECH SOLUTIONS, INC., IL May'06 to Sep'06

Principal Architect

Client & Project: McKesson Health Care, McKesson Medical (MMP)

. Lead Architect for design & development of McKesson HDE data-warehouse

with 6 ETL specialists.

. Responsible for gathering technical, business transformation requirements

and created mapping rules.

. Led ETL flow development for the source data aggregation, transformation,

cleansing, and loading

. Used shared containers to reuse the specific business logic in various

jobs to eliminate 30% of redevelopment

. Created ETL interfaces and gateways for backend database.

. Responsible for maintaining resources with in project budget and deliver

projects on time.

Bearing Point Inc. July' 04 to Apr'06

Sr.Technical Architect/Manager

Client & Project: Hawaiin Telecom, Enterprise Data conversion

Jul'05 to Apr'06

. Architect for the detailed design and development phase of Hawaiian

Telecom's enterprise data-warehouse.

. Managed/lead Conversion and CRM members to provide the best strategic

solutions.

. Architect and designed GEO process, to retrieve Geographical codes for

accurate tax calculations using Vertex APIs, C++, Shell, UNIX.

. Managed project risks, issues and changes. Esclate issues as necessary to

meet delivery commitments

. Responsible for Data analysis and Meta data management using

ProfileStage, and MetaStage.

. Wrote PL/SQL packages for backend data piping.

. Delivered project on time and 7% over budget due to scope creep.

Client & Project: Kellwood Company, Enterprise Data warehouse July' 04

to Jun'05

. Architect for the detailed design and development phase of Kellwood

Company's enterprise data-warehouse.

. Managed/lead team members and provided the best strategic solutions. Also

trained 4 to 5 engineers on various middleware/data warehouse

technologies.

. Responsible for Data analysis and Meta data management, routines,

import/export, scheduling using various warehousing tools.

. Re-architecture/designed back-end Oracle Data Management system for

Kellwood reporting system to increase storage and performance by 3 times.

Also responsible for DBA activities.

. Responsible for maintaining resources with in project budget and project

dependencies.

ASHTECH SOLUTIONS, INC., IL Aug '99 to Jul'04

Sr. Consultant/Development Manager

Client & Project: IBM Corp. Bell Canada Billing System Jan

'04 to Jul'04

. Responsible for gathering technical, business transformation requirements

and created detailed design document as per the business rules.

. Designed/developed ETL jobs for the source data aggregation,

transformation, cleansing, funneling and loading in Datamarts using IBM

Data stage, Parallel Extender (PX).

. Used IBM DS Parallel Extender for splitting the data into subsets, to

utilize all available MPP processors to achieve job performance.

. Developed external processes & OSH, DS Library functions for parallel

jobs using C++, OSH and Shell.

. Used DataStage Manager for exporting/importing metadata, jobs, routines

from repository

. Used DS Director & cron/dsjob to schedule server/parallel jobs that

controlled by DataStage engine. Also redeveloped jobs based job

monitoring results & performance statistics.

Client & Project: Experian Campaign Management Automation Feb'03 to

Dec'03

. Designed and developed client/server non-blocking Daemon (Stream Watcher)

using C, C++, Oracle, TCP/IP, Sockets and Unix internals.

. Managed/lead team of six to eleven database analysts/administrators and

developers.

. Developed OBTM/Mail hygiene component of 21 TB campaign management

warehouse for direct marketing using Oracle9i, PL/SQL, Unix shells.

. Responsible for development of CDI Data Aggregator and mover using EMC

infoMover, DataStage PX(ETL), Korn Shell, Oracle 9ir2 to stream datasets

from Main Frame to Unix automatically.

. Designed and developed spawning, intelligent error handling and

coordination of multiple processes (Multiple transfers/unpacks) using

Fork, Quest Qmaster, Sockets and shell scripts.

. Developed CRON jobs and EDI transactions (dynamic PL/SQL) for daily

transmissions to remote clients.

Client & Project: DirecTV Omni Event Engine (OEE) Oct'00

to Jan'03

. Lead development of DirecTV Digital Broad Casting Center Scheduling

system, which resulted in 5NINES availability by using Oracle8i, SQL, VB,

PL/SQL.

. Extensively used DataStage PX as data warehousing tool to perform ETL

operations. To develop various transformations and also transfer from

heterogeneous data source like SQL Server and Text files to Oracle.

. Developed ETL job for the source data aggregation transformation

funneling and loading using Data stage IBM Parallel Extender (PX).

. Designed/developed OEE Automation tools to reduce resources by 50% using

Multi Threading.

. Designed/developed feature for On-Air Schedules to interact with CFS

(Central File Server) by using TCP/IP, C++, Unix.

. Designed/developed Adaptive Learning Based networks fault management

system using VC++, Win APIs, GDI and MFC to reduce resource

conflicts/faults by 30%.

Client & Project: NetPerceptions Partner Extranet Aug'99 to

Sep'00

. Designed and developed NetPerceptions real-time content management system

to achieve 100% automation of partner content presentation to customers

using Vegnette,TCL/TK.

. Researched and designed Data modeling, Database Design with

authentication, ER Diagrams for Web Interface to facilitate content

delivery automation using Visio,Oracle.

. Developed automated web templates for easier content update by the

partners. These templates involve XML modules, JSP. Client side software

developed using C++.

. Designed and developed e-Business site from the scratch, which includes

Web Page development, Applets, Shopping cart and Back-end Oracle Database

interface using VB script, DHTML, JDBC, ASP.

. Developed a feature to monitor the site for user tracking and affiliates

to facilitate automatic authenticated routing. Trained in-house web

developers and support staff.

. Developed web CRM solution to track client orders/enquires using CGI &

JSP.

IT ONE PTE LTD, Singapore Sep 97 to Jul 99

Programmer/Analyst

Client: OCBC Bank Interactive Banking System Jul'98 to Jul'99

. Responsible for design/development of online banking system using JAVA

front-end forms with embedded HTML tags into servlets.

. Developed on-line interface for intra/inter-bank applications to reduce

branch visits by 20%.

. Developed a Web based CRM solution to track customers and enquires using

DHTML, VB script.

. Developed an application for loan maturity and rollover process to

eliminate legacy loan management system using Tandem, VB.

. Developed online help using OLE and HTML for LMS users, which resulted in

reduction of helpdesk calls by 60%.

. Created new Oracle database and application for LMS to automate loan

management.

Client: Delco Electronics (EDS) SALES ORDER SYSTEM Sep'97 to Jun'98

. Responsible for development of Sales Management System with EDI interface

to replace the existing mainframe based applications.

. Developed ad-hoc and GUI based monthly/annual stock balance and

management reports Oracle Forms and reports.

. Developed features for inventory and sales tracking systems for ease of

use to users.

. Created back-end Stored Procedures for generating invoices and product

quotations.

. Developed an Intranet module, which allows pre-authorized clients to

access DELCO network for sales and partner activities using Java, Oracle.

METAMOR GLOBAL SOLUTIONS Nov' 95 to Aug '97

Programmer/Analyst

Client: North West Airlines

Responsibilities:

. Developed Oracle based Pension management system to track active and

retired employee's pension accounts to reduce employee complaints by 90%.

. Developed drill down reports where the data maintainer can use employee's

social security number to review his pension payments and withdrawals

using Oracle, UNIX.

. Developed bi-weekly/monthly reports based on corporate banking

account/pension payouts using Forms and Reports.

. Trained support staff on newly developed system to reduce out-sourcing

budget by 35%.

Contact this candidate