Transcript Slide 1

About InfoBuild India
Badhri
July 17, 2015
•
Agenda
•
•
•
•
•
•
•
•
•
•
•
Introduction
New Project Engagement
Project Process and methodologies
Governance Model
Communication Plan
Process Flow
Project Information
Resource Ramp up
Team Structure
New Joiner Induction Framework
Client Feedback
•
New Project Engagement
• Project Engagement meetings
• Hiring Resources for engagement ramp up
• Setting up connectivity between Offshore and Onsite
• Training for the specific client needs
• Project Details
• Overview
• Scope
• Project milestones
• List of deliverables
•
Project Process and methodologies
• Project Standards
• Development Model/Approach
• Coding Standard Documents
• Tools and Technology, and their version to be used
• Bug/Issue Resolution Process
• QA Process
• UAT Process
• Change Request Process
• Communication method (Phone/Email, etc) and the frequency (Daily/Weekly, etc)
• Project Walk Through on,
• Data Model of the Database being used (Done once)
• Data Dictionary of the Database being used (Done once)
• ETL and WF requirements walk through (Once for each document)
• Clarifications on questions/doubts on the document
• Issue management
• When Bugs/Issues raised by the Client, will go through Bug/Issue Resolution Process
• Change Request Management
• Any Change Requests raised by the Client, will go through the Change Request Process
•
Governance Model
• Off-shore
• On-shore
Escalation Path
Manager
Manager
Team Lead
Team Lead
Developer
Developer
Project Planning
Execution Path
Benefits:
Faster Decision making, well defined Execution and
Escalation Paths
•
Communication Plan
Participant/event
Item to Communicate
When
Means of
Communication
Sender for
Communication
Development team
On-shore/off-shore
Weekly WF Team Meeting
Weekly
Conference call
And Live meeting
Project Manager
Development team
On-shore/off-shore
Weekly ETL Team Meeting
Weekly
Conference call
And Live meeting
Project Manager
WF and ETL Development team
On-shore/off-shore
Status and progress
Daily
Conference call
And Live meeting
Team Lead
Subject matter experts
Business requirements
As needed
Meeting and
email
Team Lead and
PM
Development team (on-shore and
off-shore
Requirements walkthrough
As needed
Conference Call
and Live meeting
Team lead
Development team
Code walkthrough
For each
application
Conference Call
and Live meeting
IBI Tech Lead
Development team / configuration
management
Process changes
As needed
Conference Call
and Live meeting
IBI Tech Lead
Development team
Review of unit test results
For each
Application
Conference Call
and Live meeting
IBI Tech Lead
Process Flow
On Shore
Team
Process Model
Gather detailed
design
requirements
(together with
Architect)
Design work
with architectt.
Detail Estimate
(Fill in Detail
Estimate
worksheet/IBI
model)
UAT
User
Identifies any
issues in the
code or
requirement
Y
Off Shore
Team
•
Walk through of
design with
offshore. Clarify
Questions.
Offshore
Coding,
Testcases and
Update
Documents
Unit Testing
Re-work on
code,
Testcases and
Update
Documents
N
User Signs
Off
•
Project Information:
Microstrategies Conversion Project for Ace Hardware Corporation, US.
June 2007 to Nov 2007
Project Overview : Ace Hardware Corporation is the No.1
Hardware company in US. They are the manufacturers of Outdoor
living, paints, home goods, electrical goods, hardware items etc.
Ace Data warehouse especially designed to maintain entire
company’s data and to monitor the performance of the Business.
The Main Intention of this project is to convert the reports which
are already running in Microstategy to WebFOCUS 7.1.6.
Key Learning:
• Merging of files
• SQL Pass through
• Inventory, Sales and
Finance Domain
• Executing Multiple
Procedures in a Singe
Report
Key Issues & Risks:
• Data Issues
Technology:
• Received only the
query as req. for the
report
• Teradata
• Long running queries
• Delivered around 150
reports
• WebFOCUS 7.1.6
• Windows XP
•
Project Information: Report
Conversion Project (ASG Safari to Web Focus) for Dollar General, US. June 2008 to July 2008
Project Overview : Dollar General is a chain of variety stores
operating in 35 U.S. states. The chain operates about 8,205 stores
(as of June 1, 2007), and its headquarters is located in
Goodlettsville, Tennessee, a suburb of Nashville.
The objective of this project is to help Dollar General in
converting the old reports in existing ASG Safari software to Web
Focus. The conversion of the reports will help Dollar General to
save money and create and run reports with ease, which is inline
to the user requirements and needs.
Key Learning:
Key Issues & Risks:
Technology:
• Got good exposure to
Report Assistant and
ASG Safari tools
• Remote Desktop for
Safari Application
• Report Assistant
• Inventory, Sales and
Finance Domain
• Report Assistant Issue
• Remote Desktop reboot
• ASG Safari
• Delivered 560 reports
•
Project Information: Visteon
date
DataMigration and Corporate Reporting Project
for Visteon
Corporation, US. Jan 2008 to till
Project Overview: Visteon is a leading global supplier of
automotive systems, modules and components to global vehicle
manufacturers and the automotive aftermarket. Project is
consolidation of multiple Bill of Materials (BOM) structures
across enterprise into Global BOM Change (GBC) which Spans
multiple operational systems (SAP, QAD, DB2) into one single
ERP. This is achieved with the combination of WebFOCUS & iWay
ETL
Key Learning:
Key Issues & Risks:
Technology:
• Manufacture Domain
• Data Issue
• WebFOCUS 7.6.4
• Adv. Graph Reports
• Connectivity
• HTML Layout Painter
•
• iWay DataMigrator
7.6.4
• Dashboard
• Report Caster
• Delivered 40 reports
and 25 ETL flows for
different systems
• Visteon Corporate Overview
• Global Automotive Component Supplier
• Spun off from Ford Motor Company in 2000
• $11 Billion Dollar Company
• 40,000 Employees
• North American Offices in Van Buren Township, MI USA
• Technical Center in Chennai, India
• Information Builders – Visteon Relationship
• Visteon Relationship Started with Ford Spin Off
• Cloned Many Ford Systems
• Information Builders legacy products (FOCUS) were used
• Added newer components (WebFOCUS/iWay ETL) in 2004 for
•
•
smaller projects
Medium Investment in Mid 2007
• WebFOCUS
• Professional Services (Onshore)
Large Enterprise Deal with IBI in Late 2007/2008
• WebFOCUS Reporting
• iWay Data Migrator/ETL
• Professional Services Contract (Onshore/Offshore)
• High Level Projects
•Current Projects
•Global BOM Change (GBC) – Consolidation of
multiple Bill of Materials (BOM) structures across
enterprise
•Spans multiple operational systems (SAP, QAD, DB2)
•Combination of WebFOCUS & iWay ETL
•Migration to QAD
•Migration of multiple systems to single ERP
•Touches almost all Visteon systems
•Phased rollout over 2 years
•Supplier Relationship Management
•Customer Relationship Management
•Many smaller data migration projects
VISTEON Engagement team
VISTEON Manager
Nicole Davanzo
ONSHORE ETL TEAM
Jim Homan (Team Lead)
John Calappi (ETL Architect)
Raghu
ONSHORE WebFocus Team
Mary Sparks (Team Lead)
Ed Nowacki
OFFSHORE ETL TEAM
Badhri Veerabadhran (Team Lead)
Suburamanyam
Senthilvasan
Rosy Esther
Amarnath
INFRASTRUCTURE/SECURITY/MAINTAIN
Dave Beagan (Security)
Kyle Hachey (Infrastructure)
Jane Berman (Maintain)
Carry Darrow (Maintain)
OFFSHORE WEBFOCUS TEAM
Senthilnathan (Team Lead)
Sriraman
Sairam Ramesh (WF Admin)
• Technical Expertise in - WebFOCUS 7.6.4
•Managed Reporting Environment
•ReportCaster
•Dashboard
•Active Reports
•Drilldown Reports
•Tabular Reports
•Graph Reports
•Current Data Sources
•SAP
•Oracle
•Progress/QAD
• Technical Expertise in - iWay Data Migrator 7.6.4
•Created flows to move data from one system to another
system
•Data cleansing before loading the target
•Transformation on the source data
•Scheduling flows
•Data Sources
•SAP
•Flat Files
•Oracle
•DB2
•Data Targets
•Oracle
•SQL Server
•Excel
•
Staff Ramp up
9
8
7
6
Managers
Team Leaders
Sr. Developer
Developer
5
4
3
2
1
0
2007
2008
Highlight:
•0% Attrition
•Able to ramp in short duration
•Training the resource to meet the project deliverables.
•
Team Structure
Managers, 1, 6%
Team Leaders, 3,
18%
Developers, 8,
47%
Senior
Developers, 5,
29%
Managers
WebFOCUS
Team Leaders
11
Senior Developers
6
Developers
DataMigrator
New joiner Induction Framework
Job Shadow
Pre-Assessment
New Joiner
Induction
Program
Evaluation
Class Room
Study Materials
Live Project
•
Client feedback for Dollar
General Project
I would like to thank you for the outstanding work you did with your team for the Dollar General project. You
asked me to provide feedback, anything that could help your team grow to provide even better service for
future projects.
#1 Team was extremely flexible and helpful to respond to work hour changes. It is not easy to work 12 hours
away from the core of the project but you did everything to make me feel that you are available 24 hours a
day. Additionally, there were hardware availability issues and rather than waiting for schedule changes at the
client side, your team opted to change their schedule and work on weekends.
#2 Picked up the technology very fast. Report Assistant is not as widely used as other IB tools.
#3 Having you as a main contact who worked as un umbrella over the team worked great. I did have easy a
quick communication to/from individuals to/from your side, but when decision had to be made about issues
touching the whole “team”, you stepped in and made quick decision.
#4 I feel that asking questions about techniques is not as easy as it should be on your side. There are
channels within IB, FocalPoint, Tech Support site, other senior consultants, where answers are arm length
away. I didn’t see any entries from your team on Tech Support Site or Focal Point asking for help.
I hope the few item above gives you a few pointers to achieve another successful project.
Take Care and Regards,
Endre Pekarik
Information Builders
Engagement Manager - Central Region
Mobile:
Fax:
513-967-7090
801-757-1388
Blackberry PIN: 302871AD