Wade Walker
Managing Director, Methodata
SUMMARY
1. Global project experience (Europe; Australia; Japan; USA; Canada)
2. Team formation, coordination and management
3. Project management
4. Effective technical <=> business bridge – actively foster understanding, communication and agreement between diverse groups and stakeholders
5. Definition, architecture & implementation of information technology strategy/vision
6. Conceived and developed detailed structured methodology for data migration (“ClearView”).
7. Definition of business needs & translation to technical requirements
8. Technical data migration expert & strategist (implementation, QA, audit)
9. Business intelligence data structures and implementation (ETL/OLAP/DB)
10. Individual and group mentoring and training
Key Points :
• 10 years as a Business Intelligence and Data Management specialist
• Developed and branded structured approaches and methodologies in the domains of data migration, business intelligence, definition of business requirements and Web Analytics.
• Developed structured approaches to data profiling, quality and auditing
• Strong advocate of definition of, and adherence to, corporate standards of development and business rules. Believe in ongoing QA and audit processes to ensure conformance
• Interfaced with all levels of organization, both on the business side and technical side; Encourage bilateral communication and can communicate complex ideas with an accessible approach
• Effective communicator across cultural and geographic barriers;
• Broad understanding of the decisional tools market. Able to intelligently combine technologies to leverage diverse vendor strengths while balancing budget constraints
Industries :
Finance (2.5 years), Manufacturing (2 years), Public sector (2 years), Packaged Goods (1.5 years), Utilities (1 years), Pharmaceutical (1 year)
10 contactsLead Technical Consultant and Data Migration and Data Warehouse Specialist. Responsible for Methodata’s business relationship development and marketing, team leadership, technical development and implementation, technical quality assurance and data migration audits.
Data Migration Architect; Developer and owner of templated Methodology for Data Migration. Business Intelligence and Data Warehousing strategy, architecture and implementation.
Provide courses in Data Migration tools such as Informatica, Sunopsis and Datastage. Developed and provide custom course named "Good ETL Design"
Expert in Data Migration tools such as Informatica and Datastage.
Skilled in OLAP tools such as Business Objects, MS Analysis services, Microstrategy
Examples of Corporate Successes:
• Maintain international portfolio of clients in Switzerland, EU and Middle East
• Interviewed and hand-selected highly compentent pool of external consultants
• Negotiated and established successful synergy-based partnerships with leading consulting companies in Switzerland and the Middle East
• Successfully positioned Methodata as a BI and data migration competency centre, providing high-level and high-quality services to partner companies and clients
• Nurtured and achieved a reputation of excellence with clients and business partners
• Definition of corporate strategy for service offerings
• Developed and branded structured approaches and methodologies in the domains of data migration, business intelligence, definition of business requirements and Web Analytics, and packaged them as products
Examples of Project Successes:
Banque Cantonal Vaudoise / Unicible (Data Migration Team Lead) – DataStage, FERMAT
• Defined corporate standards of development for data migration
• Defined technical requirements specifications based on analysis with business resources
• Planned, designed, and developed complex data migration from >140 sources
• Established, documented and structured methodology to maximize reusability of components and ensure development standards (ClearView)
• Advocated and implemented approach of data centralization and re-use
• Created repository of re-usable mapping processes to accelerate development
• Performed quality control and standards adherence audits on developer’s deliverables
Serono (Geneva) – Multi-Phase Global Financial Data Warehouse – ETL Lead (Informatica)
• Defined Functional & Technical requirements ETL Architecture and Methodology
• Integration of Informatica routines for loading to Hyperion Essbase
• Defined Corporate ETL Standards & Conventions conforming to the ClearView Methodology
• Migrated Informatica v6 to v8.1.1; Validation & optimization of existing workflows
SITA (Geneva)– HR Data Mart Requirements (Informatica, Business Objects)
• Working with global HR, provided series of structured requirements workshops
• Defined Database architecture and OLAP reporting requirements
• Defined strategic roadmap for HR reporting
Givaudan (Geneva) – DataStage, SAP PACK
• Developed bidirectional interfaces between SAP and external databases
• Defined new ETL Global standards of development and Naming Conventions
• Implemented Methodata’s ClearView ETL Methodology
• Participated and contributed to Proof of Concept for IBM SAP PACK
• Oracle Data Integrator (ODI) Technical Workshop
• Developed & Delivered 2005 series of ODI Technical Workshops
Centrica (Leicester, UK) – SAP Data Profiling / Migration (DataStage, ProfileStage)
• Mentored large Data Migration team, starting up multi-year SAP migration project
• Developed and implemented templated methodology to Data Profiling;
• Delivered custom ETL course (Good ETL Design)
Philip Morris SA (Lausanne) – Training (DataStage)
• Technical training – (DS Fundamentals, Good ETL Design (Custom Course))
Powergen (Nottingham, UK) – Training (DataStage/ ProfileStage / ETL Best Practices / SAP Pack)
• Provided Technical Training to Development Team in Nottingham, UK
• Responsible for coordination and alignment of technical and business teams in Lausanne, Rome, Tokyo and Melbourne for complex global BI project
• Responsible for ensuring alignment and integration of technology developed by team
• Performed project planning and control; Developed and enforced standards and methodology for project delivery
• Defined business requirements and technical architecture
• Developed core technical deliverables – ETL, OLAP and database
• Provided technical training (Informatica Powercenter/PowerMart) to senior consulting team (Grenoble, France)
Examples of Practice Development successes:
• Founded new Western Canadian Data Warehouse Practice
• Developed proposals & developed and estimated project work plans for major clients
• Developed new Western Canadian team to five professionals in first four months of practice.
• Collaborative definition of team’s training plans and career goals
• Generated revenues >$1.2 million Q1 2001.
• Developed western software partner strategy & developed vendor relationships.
Examples of Project Successes:
• Analyzed 40 disparate data sources (SAP, Peoplesoft, Custom) and developed data management strategy for a major telecom company
• Collaborated on development of global data model for large North America telecom
• Analyzed proprietary tool and developed strategy for global rollout for global
• Proposed, founded and developed Central Region Data Warehousing Practice
• Built and developed highly competent team of five professionals
• Responsible for utilization, training and career planning for team
• Definition of practice strategy in eBusiness, Knowledge Management & BI
• Planned, costed and led technology projects across North America
• Performed project requirements definition and business analysis.
• Worked with and supported three regional offices to develop their local markets
• Collaborated with directors of Western and Eastern BI practice to form cohesive strategy and offering
• Generated nearly $1 million in revenue in first few months of practice creation.
• Definition and migration of data from a variety of sources for clients(Informatica).
• Developed reports in a variety of OLAP tools.
