Robert Walch
Senior Solution Architect, Business Intelligence & Information Management at Vertex Computer Systems
- Location
- Cleveland/Akron, Ohio Area
- Industry
- Information Technology and Services
As a LinkedIn member, you'll join 150 million other professionals who are sharing connections, ideas, and opportunities. And it's free! You'll also be able to:
- See who you and Robert Walch know in common
- Get introduced to Robert Walch
- Contact Robert Walch directly
Robert Walch's Overview
- Current
-
- Senior Solution Architect, Business Intelligence & Information Management at Vertex Computer Systems
- Past
-
- Senior Data Warehouse Architect at New York Community Bank
- Senior Manager at Wipro Technologies
- Senior Architect and Data Analyst at Cardinal Health
- Principal Consultant at SAIC (Science Applications International Corporation)
- IT Project Manager at S&P Solutions, Inc
- Internet Services Director at INCOM Integrated Computer Systems, Inc
- Education
-
- The University of Akron
- Recommendations
-
6 people have recommended Robert
- Connections
-
99 connections
- Websites
Robert Walch's Summary
Certified, solutions-driven Project Manager, Solutions Architect and Data Analyst with extensive experience in Business Intelligence, Data Warehousing, Database Architecture, Data Analysis and Data Modeling within Fortune 50 corporate IT and banking environments. Advanced level of technical experience coupled with highly refined business acumen is demonstrated by repeated success in the analysis, design, development, and management of innovative, technology-driven solutions in portfolios exceeding $750 million that dramatically improve accuracy and directly support and promote long-term business growth. Influential leadership and communication abilities, experienced in coordinating cross-functional international teams and managing internal and external resources. Direct, hands-on experience in Fortune 50 corporate environments in both the United States and Europe. Excellent communication skills, experienced in presentations to senior corporate leadership.
Specialties
Information and Solutions Architecture
Database Architecture
Business Intelligence
Business Analysis
Data Analysis and Profiling
Data Modeling
Data Warehousing
Project Management
Technical Management
Environments include: MS SQL w/SSIS, Oracle, Business Objects, UAPM, Altris, MS Access (w/VBA), MS Excel (w/VBA), SharePoint (w/Workflow), SAP Data, Visio for Enterprise Architects, ERWin, Informatica
Key experience in multi-systems combined data analysis and process design.
Robert Walch's Experience
Senior Solution Architect, Business Intelligence & Information Management
Vertex Computer Systems
Privately Held; 201-500 employees; Information Technology and Services industry
January 2012 – Present (5 months) Twinsburg, Ohio
Senior data and business intelligence architect, senior analyst and solutions architect for the Cleveland, Ohio based IT consulting and support firm. Provide data warehouse, architecture, business intelligence, data analysis and solution architecture support within the banking industry in Cleveland, Ohio. Integral in the initiation and development of the Business Intelligence practice within Vertex.
Key Achievements
Data and technical architecture, data profiling and application enhancement for risk management for PNC Bank in the in the Cleveland, Ohio data center.
Senior Data Warehouse Architect
New York Community Bank
Public Company; 1001-5000 employees; Banking industry
May 2011 – January 2012 (9 months) Cleveland, Ohio
(Contract Role) Data warehouseing for regional retail bank. Develop architectures for data warehouse revisions and upgrades, revise table specifications and design solutions for medium and large data warehouse projects. Projects include data integration for acquisitions, internal problem solving analysis and functional improvements.
Key Achievements:
Drove in-depth analysis effort to determine cause for authentication failure for new user ids within the Data Warehouse. Performed script analysis and lead development team correcting the issue.
Lead large project effort to integrate new database source data into existing data warehouse resulting in major revision to schema and tables.
Expanded metadata libraries for undocumented schema.
Senior Manager
Wipro Technologies
Public Company; 10,001+ employees; WIT; Information Technology and Services industry
October 2010 – April 2011 (7 months)
Senior Manager, Business Analyst and Project Manager for the Business Intelligence and Information Management Practice specializing in Business Intelligence and Information Architecture solutions for Fortune 100 companies. Provide business and data analysis, and project management for worldwide financial investment and securities investment banking corporation US Headquarters in New York metropolitan area. Client-facing project and staff management roles in the financial and banking industries wealth management.
Key Achievements:
Develop the master Business Intelligence Engagement Plan for the BIIM group within Wipro.
Data analysis, analytical database design and Project Management in Securities data management systems.
Enterprise Data Modeling.
Senior Architect and Data Analyst
Cardinal Health
Public Company; 10,001+ employees; CAH; Hospital & Health Care industry
February 2010 – November 2010 (10 months) Columbus, Ohio Area
(Contract Role) Senior Analyst and Business Intelligence Architect at Cardinal Health in Columbus, Ohio providing data analysis architecture and process improvement design for the Asset Management division for hard and soft assets enterprise wide.
Responsibilities include architecture for the interfacing of multiple database systems to improve the accuracy of the Asset Management and Software Licensing analysis. Environments include CA Unified Asset Portfolio Management (UAPM) environment, SAP, Altris and Active Directory, including the design and architecture of interfacing reporting environments connecting MS SQL, UAPM and MS Access to MS Excel, SSIS and other data interfaces including SharePoint.
Key Achievements:
Solution Architect for enterprise-wide computer asset inventory initiatiative to perform on-site inventory of all computer, peripheral and networked assets within the Cardinal Health enterprise in North America and interface collected data with enterprise asset management systems.
Re-developed architecture of the enterprise-wide asset management reporting database application to improve accuracy and reduce effort levels for weekly and monthly asset status reporting. Re-design architecture and interfacing of reporting environment with UAPM SQL back end and improved accuracy to zero variance.
Interfaced UAPM, Altiris and Active Directory to develop a highly accurate Software Licensing Analysis System and accurately assess installed licensed software enterprise-wide for a world-wide network of over 30,000 pc's and servers.
Developed various smaller reporting applications interfacing with multiple corporate back-end systems including Clarify Help-Desk ticketing and SharePointe to improve workflow processes and overall business analysis accuracy.
Principal Consultant
SAIC (Science Applications International Corporation)
Public Company; 10,001+ employees; SAI; Information Technology and Services industry
August 2001 – April 2009 (7 years 9 months)
Perform business analysis and business intelligence functions for Fortune 50 firms as well as internal efforts for SAIC including working within government regulated space. Performed direct business and financial analysis on multi-national portfolios and hard fixed assets. Establish working relationships with clients and cross-functional internal and external teams to locate, analyze and present specific analytical data.
Key Achievements:
Drove business analysis functions and Business Objects support for the IT Portfolio Group of Pfizer Pharmaceutical corporation. Included in this function was detailed financial business analysis and forecasting for over $750 million in IT projects over 4 years.
Designed data model and deployed database management system for large site fixed asset and soft asset re-deployment and decommissioning for Pfizer site closure program. Performed hard asset financial depreciation analysis.
Performed analysis and data mining from multiple source systems (Oracle) for the design of a Business Objects Universe reporting system for production analysis of gas wells in the central United States.
Principal architect and developer of database application managing forensic research and performed the analysis of clinical study data in the US and EU for Pfizer. (Pharmaceutical regulated space).
Spearheaded successful development of Employee Resource Information Catalog, enabling seamless program management for $500 million+ programs; drove architecture design, development, and implementation.
Developed the architecture and managed the deployment of Employee Capabilities Database application, enabling accurate and efficient management analysis of skills of over 40,000 staff members.
Led comprehensive redesign of client/server applications to Web-based applications, recovering over $1 million in license fees.
Business Intelligence lead for Downstream bp intranet infrastructure and web applications management and support.
IT Project Manager
S&P Solutions, Inc
Privately Held; 51-200 employees; Information Technology and Services industry
March 2000 – August 2001 (1 year 6 months)
(Contract Role) Performed full lifecycle project management services on consultancy basis for SAIC and BP. Conducted high-level and detailed business analysis as well as managing design of software solutions aimed at offering connectivity and document management for multiple worldwide facilities.
Key Achievements:
Contracted to SAIC, conducted extensive research and managed the development of Intranet site strategy to manage optimization of 3D visualization facilities and support services . (HIVE bp intranet web site.)
Supervised and directed team in production of site, traveling extensively while providing direct and remote resource management of teams; Hired directly by SAIC.
Internet Services Director
INCOM Integrated Computer Systems, Inc
Privately Held; 1001-5000 employees; Information Technology and Services industry
June 1997 – March 2000 (2 years 10 months)
Directed development teams in numerous project-based efforts, ensuring firm's successful entry into highly competitive ISP market. Cultivated strong relationships with key business decision-makers to establish Internet strategy, while overseeing project management, architecture design, and development. Supervised leased line installations while designing Intranet and LAN environments.
Robert Walch's Skills & Expertise
- Oracle
- SQL
- Business Objects
- Oracle Discoverer
- Erwin
- UAPM
- Altiris
- Toad
- Informatica
- Data Warehousing
- Data Analysis
- Data Mining
- Database Design
- Data Modeling
- Business Intelligence
- Information Architecture
- Solution Architecture
- Microsoft Office 2007
- MS Office Suite
- MS Project
- Access
- Excel
- Visio
- ODBC
- IT Strategy
- IT Management
- IT Operations
- Windows 7
- Red Hat Linux
- Mac OS X
- Pharmaceuticals
- Oil&Gas
- Retail Banking
- Investment Banking
Robert Walch's Certifications
-
Certified Project Manager
- Project Management Leadership Group
-
Certified Business Intelligence Professional
- ICCP.org
Robert Walch's Education
The University of Akron
Mathematics, Computer and Physical Sciences
1975 – 1978
Robert Walch's Additional Information
- Websites:
- Interests:
-
Enterprise Information Management -- Information Architecture, Data Modeling, MDM - Data Warehousing, Business Intelligence, Business Analysis Looking to relocate.
- Groups and Associations:
-
PMI, PMLG
-
- Honors and Awards:
-
Commendation from Pfizer Pharmaceuticals (2)
Contact Robert for:
- career opportunities
- consulting offers
- job inquiries
- expertise requests
- reference requests
- getting back in touch
View Robert Walch’s full profile to...
- See who you and Robert Walch know in common
- Get introduced to Robert Walch
- Contact Robert Walch directly
Not the Robert Walch you were looking for? View more »
