|
Experience/Project Work
|
Industry: Consumer Products
Project Description/Scope: End-to-end BI implementation supporting a full SAP ERP implementation project
Role: Solution Architect Duration: 1 year
Responsibilities/Deliverables:
- Project Prep/Blueprint: Gather and analyze reporting requirements, map to potential solutions, and deliver BI strategy
- Realization: Install and configure BOE environments, develop reports, and universes.
- Final Prep: Test BI solutions, develop and conduct end user training
- Go-Live Support/Run: Knowledge transfer to the customer, perform change requests, end user training
Achievements:
- Developed a BI solution that integrates both new SAP ERP data and historical/non-SAP data sources.
- Implemented a new BI solution to replace and enhance existing reporting, ad-hoc analysis, and information delivery systems. Developed reports serving customer service, finance, marketing, and sales as well as executive reporting.
- Integrated roll-out of the BI solution in parallel with SAP ERP solutions
Industry: Department of Defense
Project Description/Scope: Develop pilot implementation of dashboards and reports, establishing new design patterns for future BI development. Integrate SAP BW reporting to Business Objects, demonstrating the analytical capabilities of existing BW technology and investments.
Role: Solution Architect Duration: 9 months
Responsibilities/Deliverables:
- Design and develop mock-up dashboards to explore options for presentation and analysis of SAP BW data.
- Develop pilot dashboard, demonstrating the development process and connectivity of Xcelsius to SAP BW to the customer.
- Deliver best practices and guidance for sustainability and future development of BI functionality.
Achievements:
- Created 18 mock-up dashboards demonstrating a variety of data and presentation possibilities.
- Provided guidance on installation and configuration of the Business Objects Enterprise environments supporting development, testing, and production.
- Developed financial dashboard connected to existing SAP BW objects, delivering new analytical capabilities to executive decision makers on spending execution and budget.
- Created sample Explorer Information Spaces to demonstrate and utilize data discovery capabilities of Business Objects.
Industry: High Tech & Electronics
Project Description/Scope: Business Objects Enterprise performance assessment
Role: Solution Architect Duration: 2 weeks
Responsibilities/Deliverables:
- Review BOE environment and usage, identify potential performance improvements, provide recommendations for projected growth
Achievements:
- Delivered findings and recommendations for performance improvements in the application, intelligence, processing, and data tiers in the BOE architecture
- Validated recommendations by modifying selected Business Views and Crystal Reports
Industry: High Tech & Electronics
Project Description/Scope: Install new Business Objects XI 3.1 environment and integrate with SAP BW.
Role: Solution Architect Duration: 4 weeks
Responsibilities/Deliverables:
- Install and configure BOE XI 3.1, Data Federator, and SAP Integration Kit environments and client tools.
Achievements:
- Installed and configured the environments that enabled report development, testing, and training for an enterprise migration and implementation of SAP ERP and BI.
- Delivered guidance on BI architecture, security, development roles, and utilization of reporting tools.
- Delivered WebIntelligence training to report developers.
Industry: Telecommunications
Project Description/Scope: Install new Business Objects XI 3.1 environment and migrate content and functionality from existing environments.
Role: Solution Architect Duration: 3 weeks
Responsibilities/Deliverables:
- Install and configure BOE XI 3.1
- Migrate content and security
- Deliver forward-looking advice
Achievements:
- All functionality was migrated and tested in the new environment
- Delivered guidance and training on administration and universe design to new administrators of the BOE system.
Industry: Agriculture/Biotechnology
Project Description/Scope: Integrate and migrate SAP BW reporting to Business Objects, leveraging existing BW technology and investments while implementing new Business Objects systems to enhance reporting and analysis. Develop pilot implementations of all Business Objects tools (WebI, Dashboards, Crystal Reports, QaaWS, LiveOffice, etc.) and establish design patterns for all future development.
Role: Solution Architect Duration: 9 months
Responsibilities/Deliverables:
- Implement 3 HR Dashboards (Xcelsius) allowing the leadership teams to analyze headcount, hire, separation, diversity, and performance trends and metrics for all levels of the organization.
- Implement Environmental Safety and Health dashboards (Xcelsius) allowing leadership teams to track and manage accident incidents and severity across all levels of the organization.
- Implement Security Transaction reports allowing the SAP security team to audit user activity and security role usage.
- Implement CRM reports allowing call center managers to monitor performance of customer solutions.
- Develop Global Infrastructure dashboard (Xcelsius) allowing IT leadership to track and manage performance and availability metrics for their network and communications systems.
- Define and implement the security model for the Business Objects Enterprise system supporting reporting and analysis for the global organization.
- Support Business Objects development and administration teams at all locations - India, Latin America, Europe, and North America in development practices and standards.
Achievements:
- Established patterns for new and existing SAP BW report migration to Business Objects.
- Implemented dashboards (Xcelsius) and reports for multiple clients utilizing existing SAP BW BEx queries.
- Empowered multiple development teams to deliver new reporting and analysis solutions to clients.
Industry: Healthcare/Pharmaceuticals
Project Description/Scope: Migrate reporting and analysis from Business Objects 6.5 to XIR2, and implement new dashboard and analysis capabilities.
Role: Senior BI Consultant Duration: 5 months
Responsibilities/Deliverables:
- Migrate/convert operational account management reports in Desktop Intelligence to WebIntelligence XI R2.
- Resolve report performance issues existing reports were taking hours to run
- Restore account manager confidence in reports from the Teradata date warehouse data elements had no business definitions, warehouse data did not match transactional data
- Create Universe to support ad-hoc reporting, provide custom training to empower account management to create their own reports and analysis without requesting IT resources.
Achievements:
- Account managements reports and universes successfully migrated to WebIntelligence.
- Reports run magnitudes faster universe, ETL code, database security model, and indexes optimized.
- Business definitions delivered for all reports and universe elements. Researched discrepancies between data warehouse and transactional reports. Updated ETL code to reflect new business rules to be reflected in reporting.
- Empowered account managers to perform 90% of ad-hoc report requests. IT reporting support for account management reduced by 10X and is limited to only the most complicated requests.
Industry: Healthcare - Insurance
Project Description/Scope: Migrate and consolidate reporting from multiple databases to one Oracle data warehouse. Migrate existing reports to standard WebIntelligence and Crystal Reports, hosted on a new consolidated Business Objects portal. Update reporting to reflect new transactional claims processing systems and processes.
Role: Senior BI Consultant Duration: 19 months
Responsibilities/Deliverables:
- Gather, consolidate, and document report needs and requirements from all business groups to manage the development effort. Analyze report requirements and determine the appropriate Business Objects solutions to be utilized for each requirement.
- Develop dozens of standard Finance and Analytics WebIntelligence and Crystal Reports.
- Create development standards and practices for report design, universe design, content management, and Business Objects administration.
- Develop Crystal Business View to support Crystal Reports.
- Perform QA and regression testing on reports and ETL as it migrates to the new consolidated solution.
Achievements:
- Over 1000 existing reports documented and matched to a new, standard solution.
- Operational reports developed and deployed on the new Business Objects solution.
Industry: Car Rental
Project Description/Scope: Enable marketing analysts to leverage deployed Business Objects solutions.
Role: Senior BI Consultant Duration: 2 Weeks
Responsibilities/Deliverables:
- Data Warehouse universe design changes to address performance, usability, and data reliability issues.
- Custom training for end users in Desktop Intelligence and Web Intelligence.
Achievements:
- Provided improvements to the universe that would restore credibility to the Business Objects solution.
- Empower end users to utilize the investment made in the Business Objects solution in their day-to-day analysis.
Industry: Gaming / Hospitality
Project Description/Scope: Consolidate reporting from multiple company sites to one upgraded Crystal Enterprise environment.
Role: Senior BI Consultant Duration: 2 Weeks
Responsibilities/Deliverables:
- Provide custom Crystal Reports training to analysts located at various sites in the US.
Achievements:
- Empower end users to continue effective analysis as their client software is updated from 8.5/10/11 to 2008.
- Establish standard best practices in report development to ensure consistent reporting across all sites.
Industry: Healthcare - Insurance
Project Description/Scope: Develop and administer Business Objects reports and dashboards against data warehouse and transactional systems.
Role: Business Objects Analyst Duration: 25 months
Responsibilities/Deliverables:
- Maintain and optimize universe against the Siebel CRM system.
- Develop reports that provide customer analysis for Sales and Finance users.
- Develop executive dashboard.
- Manage Business Objects system changes user access requests, upgrades, incidents.
Achievements:
- Restored confidence in Business Objects reporting solution performance and reliability issues with Siebel CRM reports resolved.
- Delivered custom training to empower end users to leverage Business Objects for personal ad-hoc analysis.
|
