Keywords
Skills
John Manwaring is a Certified SAP Architect and Consultant specializing in many industries with an emphasis on healthcare, sales, and financial data. John Manwaring has extensive experience in Analytics and Business Intelligence. He has extensive experience in all aspects of building analytics on healthcare, sales, finance, and other ERP systems (PILGRIM, TRACKWISE, SPARTA SYSTEMS, ASSURX, SIEMENS MEDICAL SYSTEMS, PRACLE HEALTHARE, SAP HEALTHCARE, EPIC SYSTEMS, SIEMENS, MEDITECH, MCKESSEN, ORACLE, MICROSOFT, JD EDWARDS, and SAP 6.0). He is often invited and has spoken at conferences on analytical best practices. He is a certified Business Objects XI R2/3.1/4.0 consultant as well as a migration specialist. He has implemented Business Objects Enterprise at numerous companies on Windows and Unix environments. He has over 15 years’ experience in all products in the Business Objects suite of tools. He has expert knowledge in Web Intelligence, Crystal Reports, Data Integrator, Designer, Administration, and Crystal Enterprise Architecture. John has trained users at many companies using knowledge transfer as well as classroom training. John Manwaring has recently spoken at the Business Objects Insight User Conference on the architecture of Crystal Enterprise/Business Objects. He is also a regular speaker at Business Objects user groups throughout the country. John Manwaring has authored best practices for Business Objects development life cycle, migration, installation, and universe design. He has extensive experience implementing Business Objects on top of SAP ERP and SAP BW systems. He has also created Business Intelligence COEs at many companies and is considered an expert in the SAP BW/Business Objects integration field.
Project history
SAP Certified Business Intelligence Architect/Healthcare Analytics
Boston Scientific
Lori Cohen
Managing Director at LiquidHub
“I had the pleasure of working with John at Boston Scientific. He engineered an extremely complex Business Objects solution for ECAPA/CAPA - Pilgrim system in order to do any point in time comparision reporting. His work allowed flexibilitiy in reporting on that validated, quality system. He brought tremendous technical knowledge to the team as far as how flexible the...more
Smith & Nephew
Joe HenningsenRe-order
Information Management Maven, well versed maximizing business investment in BI, MDM, and ERP
“John is an exceptional BI consultant with very deep technical knowledge in the SAP Business Objects product suite. His range product knowledge, creative problem solving skills, and high quality of service results, made him a valuable asset to Smith & Nephew\\\'s Business Intelligence program.
Ravi Natla
BI Developer / Analyst
“John is a very skillful Business Objects professional and with vast years of experience, he is an asset to any company. I\\\'ve had the pleasure of working with John in very important highly visible project. He is through in reviewing business requirements and asking the right questions. His data analytical skills really helped us to deliver project without any defects. The...more
Business Objects Architect
Atari
Douglas Martin, PMP
PMO Delivery Manager at Morgan Stanley Dean Witter
“John is a consummate problem solver, architect and a \\\'get-it-done\\\' developer rolled into one. He takes the time to understand the true underlying business requirements and has skills to build comprehensive solutions to address the tactical and strategic needs of the organization.
Boston Scientific
Lori Cohen
Managing Director at LiquidHub
“I had the pleasure of working with John at Boston Scientific. He engineered an extremely complex Business Objects solution for ECAPA/CAPA - Pilgrim system in order to do any point in time comparision reporting. His work allowed flexibilitiy in reporting on that validated, quality system. He brought tremendous technical knowledge to the team as far as how flexible the...more
Smith & Nephew
Joe HenningsenRe-order
Information Management Maven, well versed maximizing business investment in BI, MDM, and ERP
“John is an exceptional BI consultant with very deep technical knowledge in the SAP Business Objects product suite. His range product knowledge, creative problem solving skills, and high quality of service results, made him a valuable asset to Smith & Nephew\\\'s Business Intelligence program.
Ravi Natla
BI Developer / Analyst
“John is a very skillful Business Objects professional and with vast years of experience, he is an asset to any company. I\\\'ve had the pleasure of working with John in very important highly visible project. He is through in reviewing business requirements and asking the right questions. His data analytical skills really helped us to deliver project without any defects. The...more
Business Objects Architect
Atari
Douglas Martin, PMP
PMO Delivery Manager at Morgan Stanley Dean Witter
“John is a consummate problem solver, architect and a \\\'get-it-done\\\' developer rolled into one. He takes the time to understand the true underlying business requirements and has skills to build comprehensive solutions to address the tactical and strategic needs of the organization.
Local Availability
Only available in these countries:
USA
SmartData Applications is a Visual Analytics Firm with Expertise in Healthcare, Financial, and Sales areas. We have prepacked dashboards/Reports and also customize them according to requirements. Our consultants are available immediately. Please visit smartdataapplications.com or call 1-845-401-4363
Other
BUSINESS OBJECTS ARCHITECTURE
? Experienced in all aspects of installing and migrating to Business Objects XI R2-4.0 (Windows and UNIX)
? Experience with administration of XI release 2-4.0, including CMC, Central Control Management, CMC, RAS,INFS, All server Processes, server creation, User creation, etc
? One of only 20 people certified in the architecture and migration of XI through to 4.0
? Sizing and tuning of Business Objects servers
? Clustering of CMS services as well as load balancing of Web Servers
? Create Business Objects architecture layouts for over 15 clients for up to 4000 users
? Created Best Practices for development life cycle (Dev, UAT, and Prod)
REPORTING AND UNIVERSE DESIGN
? Business Objects 6.5, XI, XI R2, XI 3.0 XI 4.0 (Universes, Developed over 1100 reports, 190 universes, and 100 dashboards using Xcelcius as well as Dashboard Manager Business Objects Application Foundation and Performance manager (Metrics creation, Set Analyzer, all analytical packages)
? Business Objects Supervisor and Designer, CMC Console
? Design Studio (Data Source - Bex Queries)
? Voyager 3.1
? Universe design, using context definition (measures and attributes) Crystal Reports
? Oracle SQL/PLSQL
? Cognos 8
? Qlikview 9
DATA INTEGRATION
? Data Integrator – Created numerous jobs, Dataflow, and Workflows
Created delta loads that incremented based on update and entry dates.
Used all of Data Integrator’s transforms including merge, Address Enhancement, and pivots
Installed Data Integrator and created repositories and configured job servers
? Rapid Marts – Installed numerous Business Objects Rapid Marts including Oracle Inventory, Sales, SAP AR, AP, Sales
? Data Services development 3.1-4.0
? Intelligent Search XI 3.0 SP1 Installation
? Text Analysis XI 3.0 SP1 Installation
? Portal Integration kits – (BEA, IBM)
? Data Services 4.0, Installation, Maintenance
DATABASE
? Advanced PL/SQL (cursors, procedures, packages, union queries)
? Advanced Microsoft Access (queries, all action queries, referential integrity, ODBC, pass through Queries, SQL (Union, select statements), all macros, form development, report Development (formatting, cross tab, all aspects of reporting)
? VBA functions, advanced expressions
? Erwin (database design)
? SQL Advanced Queries
? Oracle 11 G
? Oracle Business Intelligence Enterprise Edition 11G
? SQL Server Analytical Services
? SAP BW Cube design
? SQL Server, Oracle 11, DB2, Netezza
SAP INTEGRATION
? Experience with installation of SAP Integration Kit XI R2, 3.1 , 4.0
? Experienced with connecting Crystal Reports, Xcelsius, and Web Intelligence to SAP
? Experience with BW, SAP XI, and most ERP systems as a data source
? Experience with connecting to SAP info objects, SAP queries, and hierarchies
? Experience setting up SAP authentication within Business Objects 3.1, 4.0
SAP BW DEVELOPMENT
? Experience with SAP BW 3.5, 7.0-7.3
? Experienced with creating multi cubes, infosets and queries
? Experienced with performance tuning using aggregates, rollups, Change run, Partition, Compression, and Indexes as they work within Business Objects
? Experience reporting from COPA, FI_AR, FI_AP, FI_CO
HEALTHCARE ANALYTICS/ERP SYSTEMS
? Medical Suites – Siemens Medical Systems, Oracle Healthcare, SAP Healthcare
? CAPA - Pilgrim, Trackwise, Assurx, Spartasystems
? Compliance and Risk Management – ComplyHealth, Compliance360, Symantec
? EMR/EHR – EpicSystems, Siemens, Meditech, McKesson
HEALTHCARE BIG DATA
? Complex event processing -patient monitoring, proactive risk management
? MapReduce, Hadoop
? Commercial Distribution - GreenPlum, Cloudera
? NoSql Database – Hbase, Accumulo
? Unstructured, text data and text search and retrieval
? Experienced in all aspects of installing and migrating to Business Objects XI R2-4.0 (Windows and UNIX)
? Experience with administration of XI release 2-4.0, including CMC, Central Control Management, CMC, RAS,INFS, All server Processes, server creation, User creation, etc
? One of only 20 people certified in the architecture and migration of XI through to 4.0
? Sizing and tuning of Business Objects servers
? Clustering of CMS services as well as load balancing of Web Servers
? Create Business Objects architecture layouts for over 15 clients for up to 4000 users
? Created Best Practices for development life cycle (Dev, UAT, and Prod)
REPORTING AND UNIVERSE DESIGN
? Business Objects 6.5, XI, XI R2, XI 3.0 XI 4.0 (Universes, Developed over 1100 reports, 190 universes, and 100 dashboards using Xcelcius as well as Dashboard Manager Business Objects Application Foundation and Performance manager (Metrics creation, Set Analyzer, all analytical packages)
? Business Objects Supervisor and Designer, CMC Console
? Design Studio (Data Source - Bex Queries)
? Voyager 3.1
? Universe design, using context definition (measures and attributes) Crystal Reports
? Oracle SQL/PLSQL
? Cognos 8
? Qlikview 9
DATA INTEGRATION
? Data Integrator – Created numerous jobs, Dataflow, and Workflows
Created delta loads that incremented based on update and entry dates.
Used all of Data Integrator’s transforms including merge, Address Enhancement, and pivots
Installed Data Integrator and created repositories and configured job servers
? Rapid Marts – Installed numerous Business Objects Rapid Marts including Oracle Inventory, Sales, SAP AR, AP, Sales
? Data Services development 3.1-4.0
? Intelligent Search XI 3.0 SP1 Installation
? Text Analysis XI 3.0 SP1 Installation
? Portal Integration kits – (BEA, IBM)
? Data Services 4.0, Installation, Maintenance
DATABASE
? Advanced PL/SQL (cursors, procedures, packages, union queries)
? Advanced Microsoft Access (queries, all action queries, referential integrity, ODBC, pass through Queries, SQL (Union, select statements), all macros, form development, report Development (formatting, cross tab, all aspects of reporting)
? VBA functions, advanced expressions
? Erwin (database design)
? SQL Advanced Queries
? Oracle 11 G
? Oracle Business Intelligence Enterprise Edition 11G
? SQL Server Analytical Services
? SAP BW Cube design
? SQL Server, Oracle 11, DB2, Netezza
SAP INTEGRATION
? Experience with installation of SAP Integration Kit XI R2, 3.1 , 4.0
? Experienced with connecting Crystal Reports, Xcelsius, and Web Intelligence to SAP
? Experience with BW, SAP XI, and most ERP systems as a data source
? Experience with connecting to SAP info objects, SAP queries, and hierarchies
? Experience setting up SAP authentication within Business Objects 3.1, 4.0
SAP BW DEVELOPMENT
? Experience with SAP BW 3.5, 7.0-7.3
? Experienced with creating multi cubes, infosets and queries
? Experienced with performance tuning using aggregates, rollups, Change run, Partition, Compression, and Indexes as they work within Business Objects
? Experience reporting from COPA, FI_AR, FI_AP, FI_CO
HEALTHCARE ANALYTICS/ERP SYSTEMS
? Medical Suites – Siemens Medical Systems, Oracle Healthcare, SAP Healthcare
? CAPA - Pilgrim, Trackwise, Assurx, Spartasystems
? Compliance and Risk Management – ComplyHealth, Compliance360, Symantec
? EMR/EHR – EpicSystems, Siemens, Meditech, McKesson
HEALTHCARE BIG DATA
? Complex event processing -patient monitoring, proactive risk management
? MapReduce, Hadoop
? Commercial Distribution - GreenPlum, Cloudera
? NoSql Database – Hbase, Accumulo
? Unstructured, text data and text search and retrieval
