Data Warehouse Sql Server
Resume:
Right Time Global Data Warehouse Architect
Tushar Kale
Elk Grove, CA 95758
abnsu8@r.postjobfree.com
Phone: (C) 916-***-**** (R): 916-***-****
Summary:
Worked extensively on Knowledge Management (KM) framework to implement Data Warehouse/BI solutions for the Telecom, Banking, Staffing,
Education, Healthcare, Financial Services industries and the State Government. Handled projects over 12 years in the capacity of Project
Manager, Project Lead, Team Lead and Business Analyst/Functional analyst. Possess expertise in architecting, implementing and supporting
Enterprise wide mission critical data warehouse solutions with very large data sizes. Successfully implemented STAR schemas using Ralph
Kimball methodology.
Implemented DW/BI projects using Industry Best Standards in a timely manner. Worked through the complete lifecycle of projects- requirements
gathering specifications, analysis, design, build, test, deploy and train.
Certifications and Training:
1. Advanced Data Warehouse by Ralph Kimball
2. The Exploration Warehouse by Bill Inmon
3. Informatica Velocity
4. Sagent Data Warehouse Administrator - Advanced and Basic Data Mart Construction
5. SAS Rapid Datawarehousing
6. Brainbench – Data Warehousing Concepts Certificate Transcript
7. Intalio – BPMN, BPEL, BAM, BPEL4People
Tools and Techniques:
1. ETL Tools: Informatica PowerCenter Real Time Edition v8.6, Oracle Warehouse Builder, Sagent Design Studio, Sagent
Automation, Tivoli
2. Data Modeling: ERWIN, Designer 2000, Power Designer
3. Reporting: Business Objects XI R2, Crystal Reports XI R2, Sagent Reports
4. Project Management: MS Project, MS Visio, Kintana
5. Databases: SQL Server, Oracle, MS Access
6. Scheduling : IBM (Control-M), Sagent Automation
7. BI : MS - OLAP Server, Sagent Reports
8. Version Control: PVCS, Visual Source Safe, Subversion
9. Change Management: Remedy, Manage Now
10. ERP: Oracle Financial System
11. Quality Assurance: Quality Center
12. BPM: Intalio 5.2
Methodologies:
1. Informatica Best Practices - Velocity
2. Oracle Data warehouse Builder Methodology for Data Warehouse Implementation
3. SAS Rapid Data Warehousing Methodology
4. Sagent Enterprise Information Portal (E.I.P) Implementation
5. Rational Rose OOAD Approach
6. Common Warehouse Methodology(C.W.M)
7. Service Oriented Architecture(S.O.A)
8. Intalio Business Activity Monitoring(B.A.M)
Projects Designed, Developed and Implemented:
Franklin Templeton Investments, Rancho Cordova, CA June 2007 till date
Implement Near Real Time (Right Time) Global Data Warehouse Solution
Role: Technical Lead/Project Manager
Description:
In a Leadership role mentored onsite and offsite teams to architect and implement a NEAR REAL TIME PROPAGATION
ENGINE (NRT) for data movement using ETL between the transactional system and Global Data warehouse
Authored the Customer Solution Document (CSD), Technical Solution Document (TSD) and Low Level Design Documents
(LLD) for TOAR and the Global Datawarehouse applications
NRT was built using a combination of cyclic, non-cyclic, on-demand ETL jobs using IBM Control-M scheduling tool, Oracle
database and Unix shell scripts to propagate data every 15 minutes between the transactional system and separated Global
Datawarehouse system
Responsible for setting the direction for the team, planning the work efforts, reviewing and contributing to requirement gathering
and business acceptance testing (BAT) deliverables as well as providing status on the team’s progress
Modified the existing job and dependencies for reports and extracts on Street Books and the Global Datawarehouse
Participated in development of detail design and design walk through with appropriate focus groups and related users to verify
accuracy of design in meeting business needs
Tushar Kale Confidential Page 1 of 4 5/6/2009
Right Time Global Data Warehouse Architect
Proactively identified opportunities or obstacles concerning data needed and data accuracy by providing data cleansing
strategies through ETL transformation knowledge
Conducted detailed process and data analysis on source systems to develop Functional Design documentation(inclusive of but
not limited to Requirements, Source to Target Maps, Data Flow Diagrams, Report Mock-Ups and Data Samples)
Leading an onshore and offshore team to provide technical design and direction to answer technical questions
Participate in code reviews to ensure ETL code is reusable and meets Franklin Templeton Investments ETL standards
Worked closely with the Testing Services team to Unit test, Integration and System test of Propagation Engine
Perform analysis, design requirements, architect technical solutions, develop project plans, perform unit and integration testing,
work with users on UAT, implement solutions, document systems, and train users. Work closely with business users to define
requirements and architect new technical solutions
Developed, maintained and tracked Test plan, Test Lab and various phase defects using Quality Center. Confirmed to business
that business requirements are fulfilled as per the Requirements Traceability Martrix
Build Propagation Engine Prototype using Oracle Streams
Designed and managed change control requests to maintain scope and generate weekly reporting summary
Environment: Informatica, Oracle, Control M, ERWin, Quality Center, Subversion
Washington Mutual (WMCS), Pleasanton, CA April 2006 to May 2007
Implemented a Data Warehouse/Operational Data Store for WAMU Credit Card Company through Accenture
Role: Business Analyst/ Functional Analyst
Description:
Successfully completed all the tasks mentioned below in a timely manner
Reviewed and validated all Informatica mappings into and out of the enterprise data warehouse and data marts, inclusive of
initial and incremental client data loads
Written the Level of effort(LOE), detail design document, project plan, functional specification document(FS), FS walk through
with Business teams, fulfillment of Requirement Traceability Matrix (RTM) and development teams
Tuned the data movement jobs and queries to improve data load times and end-user data access response times
Developed ETL procedures to ensure conformity, data integrity, and compliance to standards
Prepared user requirement and source to target ETL mapping, documentation
Actively participated in build,develop, QA, deploy and maintain of projects- All the SDLC processes. Co-ordination the work
effort between client Business Requirements Manager and India Development Center
Oversees LOE process and complete ownership till completion. Successful completion of work orders. Completion of weekly
status reports and escalation to Technical Delivery Manager
Completed the following projects in schedule within budget
Enhanced Statement Capabilities(E.S.C) -TSYS Engineering
Email Vendor Management Enhancements - CheetahMail
Tivoli Log Audit Report
Annual Percentage Rate Cap Change
HSN Email Promotion
Credit Protection Rewrite
Addition of fields to TRIAD strategy
Environment: Informatica, Oracle, ERWin, Remedy, PVCS, TOAD
IMS Health (MedInitiatives Inc), Rancho Cordova, CA March 2003 to March 2006
A Data Warehouse for the Healthcare Industry for analyzing the claims
Role: ETL Specialist, Data Warehouse Initiative
Description:
My role was to build and manage the enterprise BI and data warehouse which provided the best of Financial and Web analytics.
Requirements analysis, design, extraction transformation and loading of transactional data for a major PBM based of East coast.
The daily claims files were received on the FTP server. ETL was quite complex as we used get the claims from one source and
eligibility from the other.
ERWin was the data modeling tool that was used to generate the logical as well as physical data models.
Work with the Meta Data Architect to ensure common definitions and integrated implementation of the meta data repository
I was the ETL specialist who designed the loading of the pharmacy as well as the medical claims.
Designed, developed and implemented complex transformations in hundreds of mappings and implemented complete back-out,
error handling and cleansing strategies to minimize business risk
Hands on role on the following –
Building the BI/Data Warehouse architecture
Model ODS and Data Marts
Designing of Staging Process, Presentation Layer for BI presentation layer to Portal Integration
Source analysis, Data profiling, Data staging, Data scrubbing, Meta data management, Data health management
Version Control
Assisted in developing the standardization processes and guidelines. E.g., Index Naming Methodology, Base view naming
methodology
The data was summarized at end of the month using Automation tool.
I had designed the automation load programs that would load the data on daily basis as well as running of summary at the end
of the month.
Tushar Kale Confidential Page 2 of 4 5/6/2009
Right Time Global Data Warehouse Architect
Developed the “Best Practices” for data and metadata design and development using Common warehouse Methodology
Environment: Sagent Design Studio, Sagent Reports, SQL Server, Windows 2000, ERWin, MS Project.
Designed a Data Warehouse for the Dental Industry
Role: Data Warehouse Architect, Data Warehouse Initiative
Description:
Work closely with Business Requirements Analyst to understand and document business needs for decision support data
Successfully implemented a completed design, developed the ETL of a datawarehouse for one of the biggest Dental provider in
mid west. Develop the Logical Data Model and the subsequent Physical Data Model
The data was extracted from the ODS- Daily transaction log was received on the FTP site.
Incremental transaction log was applied to the read only database. A complete restore process was run every night. Once
restore was successful the datawarehouse load was commenced.
I wrote the extraction, transformation and loading (ETL) programs that would load the data warehouse every night.
Environment: Sagent Design Studio, Sagent Reports, SQL Server, Windows 2000, ERWin, MS Project.
MailCode Inc. (Pitney Bowes Co), Lafayette, IN September 2002 - February 2003
A Data Mart for the Postal Industry that would analyze the flow of letters through the USPS postal stream
Role: Team Lead, Data Warehouse Initiative
Description:
Analysis Document, Requirements gathering, Design Document, Design of Logical, Physical Data Model, Star Schema
Dimensional Modeling using SQL Server 2000. Created the conformed dimensions and associated fact tables. Data warehouse
data was summarized every month.
A scalable Enterprise wide ETL Architecture Model that would incorporate other Data Marts.
Environment: SQL Server, Windows 2000, Data Transformation Services, MS Project.
A Fraud detection system for the Credit Card Financial Institution
Description:
An Intelligent Mail tracking solution that would help the Credit Card Institution to track the numbers of credit cards those were
successfully delivered to the customers.
Track the number of Credit Cards that were stolen from the USPS postal stream.
Environment: SQL Server, Windows 2000, Data Transformation Services, MS Project.
Department of Justice, Sacramento, CA May 2001-August 2002
Enterprise Architecture for the Department of Justice, CA for a Web enabled Data Warehouse and an ODS with Multiple Data Marts
Role: Technical Lead, Enterprise Architect
Description:
Formulation of Requirements gathering, Analysis Document, Technical Architecture Plan, Design Document, Design of Logical,
Physical Data Model, Star Schema/Dimension modeling.
Involved in Database design, dimensional data modeling, Sizing, Planning, System design, Testing, Documentation,
Implementation, support and maintenance and preparing pseudo code for development using tools such as Designer 2000
Expertise in SQL tuning, PL/SQL, used explain plan, trace and tkprof Oracle utilities. Also used Oracle enterprise manager to
find queries which are using most resources.
Assisted in the development of project estimates and project plans
Environment: Oracle Warehouse Builder, Oracle, Oracle Designer 2000, PL/SQL, Sagent Design Studio, Sagent Reports
Windows NT/2000, Sun Solaris, UNIX, CA-Unicenter, ODBC.
Spherion, Inc Fort Lauderdale, FL August 2000-April 2001
Architecture, Design and Develop a Web enabled Data Warehouse and an Operational Data Store for Spherion, Inc.
Role: Technical Lead, Enterprise Portal Architect
Description:
Managed, Designed and Developed Web based Data Warehouse. The design included the Data Warehouse and the
Operational Data Store (ODS). The task of the Data Mart team was to architect and the Data Mart environment to provide the
functionality for analytical reporting.
Sagent Administration, Sagent MetaLens and Sagent Weblink were used for the Data Movement and Data delivery to the web.
Environment: Oracle, PL/SQL, Sagent Design Studio, Sagent Reports, SQL Server, Windows NT/2000, Sun Solaris, UNIX,
Connix-ODBC, Visual Source Safe, ERWin, MS Project.
Hexaware, NJ May 2000-July 2000
Architect the Business Intelligence functionality implementation into an Enterprise Knowledge Portal
Role: Data Warehouse Team Lead
Description:
Business Intelligence capabilities were successfully applied to the Document Management Module to perform analysis such as
number of documents contributed per person/day, number of Documents contributed per group/day, number of documents
viewed per person/day and number of documents viewed not more than 500 times/week. These reports were used to categorize
the Documents into Good/ Bad Documents. The analysis results were used for performance tuning the system.
Knowledge Maps - Incorporated Knowledge Maps for various Business processes.
Environment: SQL Server, Windows NT/2000, Rational Rose, Visual Source Safe, MS Project.
Tushar Kale Confidential Page 3 of 4 5/6/2009
Right Time Global Data Warehouse Architect
Ruzuka Computers, India November 1999-April 2000
Strategizing the Methodology for implementing a Data Warehouse solution
Role: DataWarehouse Implementation Strategist
Description:
Implement a strategy for implementing a web based Data warehouse for a retailing organization. The design encompassed a
strategy to be used over two years’ data from the online transaction processing system.
To assist the organization in evaluating the various Datawarehousing tools.
Environment: SQL Server, Windows NT/2000
AT&T, India August 1996-October 1999
Architect, Design, Develop and Implement an Enterprise wide-Web enabled Data Warehouse
Role: DataWarehouse Technical Lead
Description:
Work with Data Warehouse vendors to provide hardware and software products, Systems Integrators and Management
Consultants
Build the Data Warehouse to integrate data from various ERP data sources such as Oracle Financials, Billing System-CABS,
and Network Management for cross-functional analysis.
Prepare the project plans and maintain project schedules.
This study included-analyzing the various tools, Hardware-servers, Management Consultants and Systems Integrators.
Designed the Data Mart for Finance department.
Environment: Oracle Financials, Oracle Designer, PL/SQL, SQL Server, Windows NT/2000, UNIX, Sun Solaris.
Implemented Oracle Financials Inventory Module
Role: Module Owner of Oracle Financials - Inventory System
Description:
Worked through the character-based version to the GUI based 11.0.3 version. The scope of project involved mapping new
systems requirements, configuring, testing and implementation
Tushar Kale Confidential Page 4 of 4 5/6/2009
Contact this candidate