Business Objects Consultant Resume
SUMMARY:
- Confidential has over 15 years’ experience with SAP Business Objects.
- He is a Certified SAP architect and developer.
- He has experience is all areas of a reporting project including gathering report requirements, installing, and configuring the software, developing reports with Web Intelligence and other products, and UAT/Testing.
- He has extensive experience in all aspects of building analytics on healthcare, sales, finance, and other ERP systems (PILGRIM, TRACKWISE, MCKESSEN, ORACLE, MICROSOFT, JD EDWARDS, and SAP).
- He has worked with Qliksense building numerous dashboards for companies. He has expert knowledge in Web Intelligence, Crystal Reports, Dashboards 4,2, Information Design Tool(Universes), Administration (CMC), and Business Objects Architecture.
- Confidential is an expert in SQL as well as Datawarehouse design.
- Confidential has trained users at many companies using knowledge transfer as well as classroom training.
- Confidential 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.
- Experienced in all aspects of installing and migrating to Business Objects XI R2 - 4.2 (Windows and UNIX)
- Experience with administration of XI release 2-4.2, including CMC, Central Control Management, CMC, RAS,INFS, All server Processes, server creation, User creation, etc
- 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)
- Business Objects 6.5, XI, XI R2, XI 3.0 XI 4.2 (Universes, developed over 1500 reports, 190 universes, and 100 dashboards using
- Qliksense 3.1, 3.2 dashboard development
- Qliksense Cloud AWS
- Design Studio 1.1, 1.2, 1.3
- Information Design Tool (IDT)
- Data Services ETL - 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
- Data Services development 3.1-4.2
- Data Services 4.2, Installation, Maintenance
- 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)
- SQL Advanced Queries
- Oracle 10G, 11 G
- SQL Server Analytical Services
- SAP BW Cube design
- SQL Server, Oracle 11, DB2, Netezza
- Experience with installation of SAP Integration Kit XI R2, 3.1, 4.1
- 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.1
EXPERTISE:
Business Objects Developer XI R2, 3.1, 4.0, 4.2
Business Objects Architect XI R2, 3.1, 4.0, 4.2
Qliksense Developer
WORK EXPERIENCE:
Confidential
Business Objects Consultant
Responsibilities:
- Lead developer to create 80 reports for Clinical Observations, Pathology, and Dosing)
- Installed and Configured Business Objects 4.2 SP5
- Installed Dev, QA, and Prod on multiple servers to allow for load balancing and fault tolerance
- Installed and configured all Tomcat services, updated XMX, XMS settings
- Configured all Business Objects services (Webi Report servers, CMS, Job Servers)
- Implemented Single sign on though AD, configured Kerberos
- Used Promotion Manager to move all universes and reports from 4.1 to 4.2
- Tested all universes and reports after migration
- Designed and created the Provantis universe and migrated them from Provantis 9 to 10
- During creation of universe I implanted row level security, multiple contexts for subject areas, derived tables, and complex joins
- Used all functionality of Web Intelligence to develop the reports such as contexts, merging dimensions, and most functions
- Was administrator of the Business Objects environment and troubleshooting performance and other technical issues
- Maintained the Business Objects environment
- Solved all tickets related to Business Objects.
Confidential
Qlik Sense / Business Objects Consultant
Responsibilities:
- Responsible for gathering business requirements and technical specifications from users.
- Involved in designing, developing, testing, publishing, maintaining, and supporting QlikSense applications for workplace operations and the financial group at Bloomberg
- Designed and developed QVDs, QVWs, QVFs using the following source systems: Oracle, SQL Server, Excel files, Sales Force & SAP
- Involved in the requirement analysis and identifying sources and targets.
- Created QlikSense dashboards using different components: List Boxes, Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Bar charts, Combo charts, Straight tables, Pivot tables, Buttons, Containers.
- Created PixelPerfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.
- Created tasks and scheduled the jobs in NPrinting server.
- Involved in performance tuning of QlikSense apps for faster data reloads and efficient response times.
- Involved in analyzing the data and defining Key Performance Indicators (KPI).
- Developed Proof of Concepts for Direct Discovery feature to load the data from SAP.
- Assisted in installation and configuration of QlikSense servers.
- Involved in optimizing the existing data models and load scripts to improve the performance.
- Simplifying complex expressions in the dashboards and improving front end.
- Implemented section access to make the application available to the desired users.
Confidential
Qlik Sense / Business Objects Migration Consultant
Responsibilities:
- Design and created Concussion Injury Dashboards, Knee and Ankle Injury Dashboards, Box Office Dashboards, and Sponsorship Dashboards
- Used the most advanced Set Analysis in the Industry
- Worked with the Extension team to design extensions
- Set up section level security so each team see their own data
- Designed and created QVDs and the data models for all dashboards
- Used over 100 customized extensions
- Used Qliksense Cloud version in AWS and configured the application
- Used Amazon S3 in the Cloud for file storage
- Dashboards that I built were used in the yearly combine where all team owners go to draft players
- Dashboards that I built were presented to a meeting of all 32 team owners
- Injury dashboards and data that was analyzed caused rules and turf of stadiums to be discussed to lower injuries
- Worked with executive level and team owners to help them determine requirements and mockup of future dashboards
Confidential
Business Objects Migration Consultant
Responsibilities:
- Recreated 220 reports from SAP Business Objects into Qlik sense
- Installed and configured Qliksense
- Set up security at the stream level as well as section level within QVDs
- Pop Designed and created complex QVDs for Sales, Invoicing, aging, purchase orders, and others
- Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models for Sales Reporting
- Worked with users and stakeholders to determine requirements and created requirement documents
- Created design and technical specifications
- Used table calculations to compare client data to projection data leveraging Running total, Percent Difference, and Moving Calculations
- Qlik user interface: charts, graphs, tables, expressions, properties, tabs, layout
- Qlik scripting, data analysis and Qlik data models
- SQL/Data knowledge: Data acquisition and manipulations skills in SQL-compliant or other data sources.
- QVD knowledge: Developed QVDs with QlikSense to provide a scalable, reusable, metadata-driven data layer
- Developed effective QlikSense data models and self-service BI capability using QlikSense
- Utilized scripting language to meet complex business requirements
- Extract, transform and load data from multiple data sources into the Qlik application
- Designed, build, test and debug Qlik solutions based upon specified requirements
- Utilized source control tools, follow deployment process
Confidential
SAP Business Objects Architect
Responsibilities:
- Installed distributed Business Objects Enterprise to 10 UNIX/Windows servers to achieve fault tolerance and scaling for up to 6000 users
- Deployed Developed security architecture for 4,000+ users and 300 groups
- Worked with C Level Executives designing and implementing custom solutions. Created and implemented policies and best practices around the entire development lifecycle, migration strategies, and security structures.
- Implemented many Single Sign-on solutions, optimized architecture, and integrated disparate technologies.
- Worked to create long term strategies to manage and expand existing Business Intelligence Systems.
- Designing migration and upgrade plans to move from older releases of Business Objects to 4.1
- Developed methodologies for troubleshooting and administration around Business Objects systems
- Explain product road maps to help client understand product direction and outlined how they could take advantage of those products to maximize the value of their existing IT infrastructure.
- Created best practices, policies and procedures for migrations and promotions from CE9 and CE10 to BOEXI R2, XI 3.1 for over 100 different application groups and several thousand users
- Evaluated existing architecture and infrastructure and proposed changes to conform to overall corporate strategies and policies
- Configured and documented installation process for Performance Management
- Configured and documented installation process for Tableau 7.0 Server
- Installed and customized Tableau Server components
- Testing/verification of Tableau Server environment
- Software maintenance considerations for Tableau Server
- Resolved common Tableau Server problem issues
- Responsible for all Business Intelligence SAP projects
- Create best practices for Business Objects and Datawarehouse implementations
- Worked on reporting, dashboard, and architecture projects in the SAP Business Objects space
- Worked on Product Placement Project developing Dashboards with Dashboards 4.1 and Design Studio 1.3
- Developed 17 dashboards and Analysis applications to be used by sales reps and territory managers
- Lead architect on Business Objects 4.0 implementation
- Signed off on estimates, project plans, requirements documents, and testing procedures for all BI projects
- Led team in all phases of development and signed off on all development work
- Lead architect on all Business Objects projects
- Lead on SAP integration project
- Business Objects lead on SAP ERP implementation
Confidential
SAP Business Objects Architect
Responsibilities:
- Installed and configured Business Objects 4.0
- Led BI project which migrated reports from OBIEE to Business Objects 4.0
- Designed and developed dashboards using Design Studio for dashboard POC
- Migrated Reports, Users, Universe to 4.0 environment
- Configured SSO though to SAP BW using SNC and kerberos
- Analyzed Oracle Dashboards to create timeline for migration and data support
- Analysed OBIEE subject areas based on new reporting requirements
- Analyzed Design of the physical and logical models in Physical and Business Model & Mapping Layer of OBIEE
- Recreated Drill-downs such as Employee Service Level, Narratives, and Aggregations for Salary in Business Objects to mimic BMM layer of OBIEE Administration tool.
- Migrated reports such as IP tracking report, New Services Provided, Customer Details per Borough, prompts for city and zip for a report of a state or borough, and dashboards such as Customer Details Page, Service Detail Page and Rate per Service Page
- Create Ortho/Endo Sales dashboards against historical data to provide 17 KPIs at different levels of analysis
- Created Infrastructure for NCEP and CAPA reporting on Pilgrim compliance application
- Worked with executive management to design and develop Web Intelligence/Oracle Reporting environments
- Configured Business Objects server processes to enhance performance according to best practices
- Installed SAP integration kit to integrate Web Intelligence with SAP R/3 as well as SAP BW
- Configured LDAP security to work with Business Objects 4.0 and Oracle
- Worked with C Level Executives designing and implementing custom solutions. Created and implemented policies and best practices around the entire development lifecycle, migration strategies, and security structures.
- Implemented many Single Sign-on solutions, optimized architecture, and integrated disparate technologies.
- Configured and documented installation process for Data Services
- Configured and documented installation process for Design Studio
- Used Text Analysis to parse text and extracts address parts and complaints about the following entities (customers, products)
- Recognizing entities and facts about them involves natural language processing (NLP),
- Created project plan for steps necessary to create the plan and pass it on to other members of the company
- Created policies on how security is created ensuring that members are held accountable for own division
- Created detailed security model outlining the roles and responsibilities for each group in the entire life cycle of developing reports
- Sizing Requirements Document
- Created and Configured multiple Job servers and Webi Report severs
- Gather requirements regarding from end users and managers on report needs as well as dashboard needs
- Analyzed current SAP and SAP BW landscape to determine existing BEX queries and cubes that can be utilized in the Business Objects space
- Created Data architecture on the BW side for best integration with Business Objects
- Ensure hierarchies, calculated/restricted Key figures, and other data elements were utilized correctly for use with Business Objects Web Intelligence
- Worked extensively with BW developers to improve performance when using Business Objects as a front end
- Developed best practices on how to best develop BEX Queries and Infocubes to take advantage of Web Intelligence functionality
- Verified authorizations on key figures related to row level security within Business Objects.
- Developed Multicube and BEX Queries on Pilgrim FDA application DW side to be used in Web Intelligence reports and Xcelsius
Confidential, Memphis, TN
SAP Business Objects Architect
Responsibilities:
- Installed Business Objects 3.1 on a clustered environment to support 2000+ users
- Deployed Business Objects to support users in US, Canada, France, Germany, Australia, UK, and Japan
- Created reporting to support different language needs using translation manager and unicode
- Created Business Objects clustered environment (Production) as well as configured load balancing between the web servers
- Created QA and development environments
- Lead on Voyager Project - Installed Voyager, worked through issues and resolved with fixpacks and service packs
- Installed fixpacks 1.1,1.3,1.6, 2.1 and Service pack 2.0 to resolve Voyager issues
- Worked with SAP consultants to develop customized LAFixpacks specific to Confidential ’s Voyager implementation
- Configured SSO for Voyager through kerberos
- Created SQL server cubes for use with voyager, applied hierarchies, measures, dimensions, and MDX row level security
- Worked with executive management to design and develop Voyager reports
- Configured Business Objects server processes to enhance performance according to best practices
- Installed SAP integration kit to integrate Web Intelligence, Crystal Reports 2008, Voyager, and Dashboard Builder with SAP R/3 as well as SAP BW
- Installed Qlikview 9
- Used Oracle Business Intelligence suite to migrate dashboards from Xcelsius to Oracle dashboards
- Configured and documented installation process for Intelligent Search in a sandbox environment
- Used Intelligent Search and TA to search emails for related customer information on product defects
- Integrated QlikView Server into existing environment
- Installed and customized QlikView Server components
- Testing/verification of QlikView Server environment
- Software maintenance considerations for QlikView Server
- Resolved common QlikView Server problem issues
- Installed SAPJCO and GUI tool to interface with SAP
- Configured SAP integration kit on the business objects side setting up all transports needed for full access
- Configured AD, LDAP, and SAP authentication as well as single sign on
- Set up Business Objects security for over 2000 users using inheritance
- Set up a Business Intelligence Center of excellence for SAP and Business Objects
- Redesigned Ortho DW on top of Oracle 11
- Designed and created Oracle DW pulling directly from SAP R3
- Developed over 35 Web Intelligence reports against the Oracle data warehouse
- Set up all procedures relating to security, life cycle development, administration, content management, and instance management
- Gather information regarding the business requirement from users to develop info cubes, Multi cubes, infosets and queries.
- Developed project See through Profitability(COPA), AR and AP(FI AR,FI AP) reports using query designer and web application designer(WAD)
- Extensively used Calculated and restricted Key figures to develop reports
- Worked on MM Cube 0PUR C01 loaded data into that successfully. Developed reports price trends over last three months, D&B Billing documents per creditor, purchase order value by vendor over a time
- Worked extensively with BW developers to improve performance when using Business Objects as a front end
- Developed best practices document on how to best develop BEX Queries and Infocubes to take advantage of Web Intelligence functionality
- Verified authorizations on keyfigures related to row level security within Business Objects.
- Worked as Business Intelligence liaison during implementations of SAP in Germany, Japan, and Australia
- Developed Multicube and BEX Queries on all sales and inventory reports for Germany, Japan, and Australia
Confidential, Philadelphia, PA
Business Intelligence Architect
Responsibilities:
- Successfully performed different roles and responsibilities as: Business Objects Developer, Administrator, Architect, and Project Lead
- Interfaced with Business Objects vendors on technology, support, and licensing issues. In constant contact with the Business Objects account manager at Shire
- Performed the following project management related activities for several different
- Developed and maintained project plans and schedules, scheduled status meetings in collaboration with the Manager.
- Created presentations and other project updates for meetings. Maintained change control processes making use of tools like change tracking tools from Remedy.
- Spearheaded the Business Objects 6.5 to XI 3.0 migration project on 12 servers. Designed and implemented the roadmap for migrating Business Objects the deployment from 6.5 to XI 3.0 and successfully implemented integration with SAP BW
- Performed the following tasks as part of the BO XI 3.0 Migration effort:
- Individually installed and implemented a high-availability, fault-tolerant environment using internal CMS clustering capabilities in
- Business Objects XI 3.0. Installed and configured the Tomcat / Apache web server. Directed migration of Reports and Universes from
- 6.5.1 to XI 3.0 using the Import Utility and conversion of .Rep (full client) reports to WEBI reports in XI 3.0 using the Report conversion tool
- Managed and configured the XI 3.0 Environment using the CMC and CCM utilities.
- Designed and implemented the security in XI 3.0 as per business requirements for 3100 users.
- A member of the Business Objects center of excellence team whose goal was to ensure all of Shire’s BI projects were following best practices as well as conforming to the underlying BI goals for the company
- Set up best practices for all Business Objects development and administration
- Worked on Finance AR AP 11i project implementing reporting best practices
- Created life cycle development plan and versioning techniques
- Supported Voyager application for 70 users
- Resolved Voyager performance issues with improved SAP BW cube design
- Presented demos of XI R2 and XI R3 to users for acceptance of projects
- Responsible to approve UAT of Business Objects deliverables
- Analyzed Business Objects implementation and gave performance recommendations
- Created POC using the OBIEE Suite of products to connect to HR data for reporting
- Install and configure SAP integration kit to interface with SAP BW and BEX Queries
- Business Intelligence Enterprise Edition 11G
- Installed and Configured Oracle Business Intelligence Enterprise Edition for HR reporting
- Designed and Created 8 HR reports pulling data from PeopleSoft
- Designed HR Dashboards using OBIEE OLAP connecting to HR data to show KPIs, Goals, and Targets
- Created multiple universes against SAP BW, Infocubes, and BEX queries
- Created multiple universes against the sales DW using Oracle as a backend
- Created Webi and Crystal reports against the Sales DW
- Created Analytics, Voyager reports against SAP BW, Infocubes, and BEX queries
- Integrated Crystal Reports 2008 with SAP ODS and infosets within R/3
- Configured SAP authentication within Business Objects
- Decided on tools used in specific projects including Performance manager, Xcelsius, Crystal reports, Web Intelligence
- Created training plan using Knowledge Accelerator and classroom training
- Required to interact with management and end-users, identify business requirements, and analyze reports in FI-CO and SD functional areas.
- Worked extensively in creating Balance Sheet, P&L, Cash, Gross Margin, Monthly Sales, Open Orders, Back Orders, DSO Analysis, Overdue, Payment History reports using structures, formulas, and cell definitions
- Worked with 0PA CO1 info cube from HR module to develop reports with BEX
- Used Cell-Definitions, Structures, Exceptions, Conditions
- Used Restricted (RKF) and Calculated Key Figures(CKF), Formula Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer to develop
- Worked extensively with BW developers to improve performance when using Business Objects as a front end
- Worked on performance tuning using aggregates, rollups, Partition, Compression, and Indexes as they work within Business Objects
Confidential
Business Objects Consultant
Responsibilities:
- Installed and configured Business Objects R2 for 800 users
- Tested and redeveloped 1700 reports after migration to web intelligence
- Configured Web Intelligence Report Server, CMS Server, Webi Job servers, and additional servers to enhance performance
- Deployed Business Objects XI R2 on 5 64-bit servers configuring Oracle 10G
- Assessed security and rewrote on BusinessObjects XI and configured to LDAP security
- Maintained Business Objects on 6 servers with multiple CMS, WEbi Job and report servers
- Clustered Business Objects services and implemented fault tolerance
- Redesigned and redeveloped all universes using Business Objects XI R2 best practices
- Created roll out and training plan procedures
- Taught 10 classes of 20 on the Business Objects XI R2 environment including Webi, CMC, and universe design
- Created lifecycle procedures using best practices (Dev, UAT, Production)
Confidential, Chicago
Business Objects Consultant
Responsibilities:
- Configured and documented installation process for Data Integrator XIR2
- Configured and documented installation process for Xcelcius 4.5
- Created project plan for steps necessary to create the plan and pass it on to other members of the company
- Created policies on how security is created ensuring that members are held accountable for own division
- Created detailed security model outlining the roles and responsibilities for each group in the entire life cycle of developing reports
Confidential, Lyndhurst, New Jersey
Business Objects Consultant
Responsibilities:
- Migrated Crystal 10 platform to Business Objects XI
- Completed Business Objects sizing analysis for 580 users
- Installed Business Objects XI on 4 servers and configured servers for fault tolerance
- Configured web server to fix memory leakage issues
- Created backup procedures for the Business Objects environment
- Developed Reports and Dashboards on the Business Objects XI environment
- Rewrote SDK on new environment
- Set up AD authentication
- Migrated all content to new platform
- Troubleshoot platform, Had issues with migrating Authentication
- To provide development and support for the Administrative Data Warehouse (ADW)
- Designed and created operational and strategic reporting and analytical reports and dashboards on mainly Lawson ERP data
- Developed numerous SQL Server data bases and specialized workflow applications, data integration (ETL) code and processes, data marts, and OLAP cubes
- Performed analysis, design, development, and ongoing support of various BI-focused applications and solutions, with an emphasis on development and maintenance of .NET applications and OLAP cubes