About InfoBuild India

1. About InfoBuild India Badhri June 30, 2010

2. 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

3. 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

4. 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

5. Off-shore Manager Team Lead Developer On-shore Manager Team Lead Developer • Governance Model Escalation Path Project Planning Execution Path Benefits: Faster Decision making, well defined Execution and Escalation Paths

6. Communication Plan

7. Process Flow

8. 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. • Data Issues • Received only the query as req. for the report • Long running queries • Key Learning: • Merging of files • SQL Pass through • Inventory, Sales and Finance Domain • Executing Multiple Procedures in a Singe Report Key Issues & Risks: • Technology: • WebFOCUS 7.1.6 • Teradata • Windows XP • Delivered around 150 reports

9. 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: • Got good exposure to Report Assistant and ASG Safari tools • Inventory, Sales and Finance Domain • Key Issues & Risks: • Remote Desktop for Safari Application • Report Assistant Issue • Remote Desktop reboot • Technology: • Report Assistant • ASG Safari • Delivered 560 reports

10. Project Information: Visteon DataMigration and Corporate Reporting Projectfor Visteon Corporation, US. Jan 2008 to till date 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: • Manufacture Domain • Adv. Graph Reports • HTML Layout Painter • Dashboard • Report Caster • Key Issues & Risks: • Data Issue • Connectivity • Technology: • WebFOCUS 7.6.4 • iWay DataMigrator 7.6.4 • Delivered 40 reports and 25 ETL flows for different systems

11. 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

12. 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)

13. 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

14. VISTEON Engagement team

15. 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

16. 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

17. Staff Ramp up • Highlight: • 0% Attrition • Able to ramp in short duration • Training the resource to meet the project deliverables.

18. Team Structure WebFOCUS 11 6 DataMigrator

19. New joiner Induction Framework Live Project Job Shadow Pre-Assessment New Joiner Evaluation Induction Program Class Room Study Materials

20. 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: 513-967-7090 Fax: 801-757-1388 Blackberry PIN: 302871AD