Srini Tata

E-mail: acvc5m@r.postjobfree.com Cell:

423-***-****

SUMMARY

> A dynamic Data Warehouse (DWH) Designer & Developer with 10+

years of Data Warehousing experience with specialization in

Business Objects Data Services(BODS), PL/SQL with vast

experience in Healthcare and Financial Verticals

> Expertise in all phases of software development life cycle:

Business Requirements Analysis, Design, Development, Testing,

Build Creation, Release Management, Support, Configuration

Management

> Thorough knowledge of DWH concepts with complete hands-on

experience in conceptualizing designing, building, testing and

building Enterprise Data Warehouses from multiple source systems

> Well-versed with extracting data from various types of sources

such as Flat Files (CSV, PSV, Fixed Width), XML Files, Oracle

(8i, 9i, 10g), MS SQL, Siebel CRM, MS CRM, and SAP (using ABAP

a.k.a R/3 transform)

> Experience in dimensional Star Schema and Snowflakes Schema

methodologies

> Very Strong Oracle skills that include build/maintain PL/SQL

scripts, Stored Procedures, Triggers, Packages and Functions.

> A very effective team player who can work closely with both

business users and technical groups of the client

> Ability to understand the business needs and provide the best

technical solutions

> Very strong written and communication skills that help the

communication within the team be effective

> Ability to perform root cause analysis that can help identify

the problem and fix it appropriately

TECHNICAL SKILLS

ETL Tools BODS 11.5, BODS 11.7.3.2, BODS 12.2, and BODS 4.2,

Informatica PowerCenter, PL/SQL

RDBMS Oracle 9/10g/11g, Informix, SQL Server 2000/2005, my

SQL

Languages C, PERL, JAVA 2, JSP/Servlets, HTML, SQL

Scripting PERL, Shell

Database TOAD, SQL*Plus, PL/SQL Developer, Microsoft SQL

Clients Enterprise Manager/Profiler/Query Analyzer, Oracle SQL

Developer

Source Control Visual Source Safe, Rational Clear Case, SVN

Utilities MS Office Suite, Dreamweaver, Aqua Logic BPM, Rational

Clear Quest, ERWIN (Data Modeling)

Operating Microsoft Windows, Linux, Unix, Solaris

Systems

Project Summary

Aug 2009 - March 2016

Delta Dental of California, San Francisco, CA

Role: ETL Lead/ Designer / Sr. Developer

Projects:

> ESP Integration

> Enterprise Streamlining Project (ESP) Conversion

> Provider 360

> NPF Import/Export Rewrite

> Enterprise Data Warehouse (Group Profit & Loss Datamart)

For these projects - Oracle was the Target; Oracle, Flat files, Oracle

Financials were source systems

Role and Responsibilities:

> Responsible for creating the build, consolidating the install

plan, working with Release Engineering team to have timely and

smooth releases - this includes coordinating with various team

members to make sure timelines are adhered to

> Interacted with the Business Analysts to understand various

elements of the Legacy data/other systems data and how they map

into the target structure - and created design documents

accordingly

> Providing estimates based on the gathered requirements for

enhancements and change requests - as and when they arrive

> Designed the various ETL Jobs (various ETL Jobs - dependencies

amongst them - scheduling them, etc) to load target from the

source databases (Metavance, Oracle Financials, various Delta

Dental internal systems, Flat Files, etc.)

> Created BODS Jobs, Work Flows, Data Flows - made use of the BODS

Query, Merge, Map Operation, Pivot, Riverse Pivot, Case, Table

Comparison, Data Quality and SQL transforms in creating the data

flows

> Used BODS Data Quality transform to cleanse/format the address,

etc from various source systems

> Coordinate the resolution of technical and operational issues -

be it Production Support or a Triage call (to resolve a very

high priority production issue)

> Used SVN/Clearcase for source control - check-ins, check-outs

for all the files such as ATL files, DDLs, DMLs, Shell scripts,

etc.

> Worked with Offshore resource to complete some modules and also

integrate that code into the actual code base on-site

> Used TOAD for Oracle and BODS Management Console for validating

data and monitoring the job progress during unit/integration

testing

Environment:

> Oracle 10g, Oracle 11g, BODS 12.2 (4.2), PL/SQL, BODS Designer,

BODS Management Console, Unix, Putty, TOAD, SVN, Sharepoint

June 2008 - August 2009

Silicon Valley Bank, Santa Clara, CA

Role: ETL Designer/ Senior Developer

Projects:

> Enterprise Integration Bus (EIB)

> PS/GL Financials

> Market Analysis Database V2 (MAD V2)

> UBS Multi Currency Deposits Migration

For these projects - Oracle was the Target; Oracle, MS SQL Server,

Flat files, PSGL were source systems

Environment:

> Oracle 9i, Oracle 10g, BODS XI (11.7.3.2), PL/SQL, BODS

Designer, BODS Web Administrator, BODS Web Services, Sagent, SQL

Server, Windows XP Professional, Win 2K Server, BO XI R2, TOAD

and Aqua Logic BPM, PSGL, Sharepoint

May 2004 - December 2007

GE India Innovation Center, Hyderabad, India

Role: ETL Developer

Projects:

> GE Fanuc Post Sales Metrics Data Mart

> GE Fanuc Enterprise Information Portal (EIP)

> GE Fanuc Embedded Reporting System (ERS)

For all these 3 DWH projects - Oracle was the Target and MS SQL

Server, Flat files, Seibel CRM, SAP were source systems

Environment:

> Oracle 9i, BODS XI, PL/SQL, BODS Designer, BODS Web

Administrator, MS SQL Server and Flat Files, Seibel CRM, SAP,

Windows 2K Server, Win 2K Professional, BO XI R2, Erwin, and

PL/SQL Developer, TOAD

EDUCATION

> Bachelor of Technology in Computer Science and Engineering from

International Institute of Information Technology - Hyderabad,

India

Contact this candidate