Sr. Bi Lead/solution Architect Resume
5.00/5 (Submit Your Rating)
SUMMARY OF EXPERINCE:
- SAP Certified Business Intelligence (BW/BOBJ) - Platinum level
- Senior SAP BI/BW/BOBJ consultant with 15 years of experience in SAP environment, with 10+ years as a SAP BW/BI Consultant and 5+ years as a SAP BOBJ techno/functional consultant.
- Involved in the implementation and integration of BW HANA, BI4, BOBJ, BOXI, SAP ECC and multiple legacy systems integration.
- Utilized Business-Objects BI 4.2 SP3 tools; Information Designer Tool (IDT), Microsoft AnalysisExplorer, Interactive Analysis, BI Launch Pad, Dashboard and Advanced Analysis
- Lead end to end solutions delivery of large scale reporting applications on HANA
- Architect, Design and develop near real time Data Warehouses and BI solutions using SAP HANA.
- Excellent experience in Near real-time data induction using SLT.
- Adept at design & development using HANA modeling techniques.
- Benchmark application performance periodically and fix performance issues.
- Translate complex business requirements into scalable technical solutions meeting Data warehousing standards
- Provide subject matter expertise to support reporting needs for the multiple functional areas.
- Conduct Design and code reviews Implemented SAP BW Super queries (Composite & Virtual)as data sources for BOBJ Universe development.
- Expert in HANA data modeling, data architect, designing, creating & maintaining info-cubes, ODS, Info-sources, data-sources and extract structures, queries using BEx analyzer and BEx web.
- Business Intelligence Competency Center (BICC) setup including BICC organization and staffing and building cross-functional team with specific BI tasks and roles.
- Data cleansing, data harmonization, data taxonomy, and data enrichments to/from BI.
- Hands-on experience on BI covering reporting requirements for Record to Report (RtR), Procure to Pay (PtP), Plan to Make (PtM) and Order to Cash (OtC).
- Integration from SaleForce.com, Hyperion to BW and directly to BusinessObjects XI 3.1 using Relational UDT and BI 4.0 using Direct Connect.
- Utilization of SAP-BW out-of-the-box business content in providing corporate and operational reporting requirements.
- Hands-on experience in integrating Salesforce.com with CRM, ECC and BI using Channel Partner and Lead/Opportunity Management.
- Defined reporting gaps in comparing required reports to business content and SAP transactional standard reports.
- Developed reports specific to SRM; Procurement, shopping Carts, Bidding, Service and CRM; Sales, Quotation, Sales Contract, Sales Order Analysis, Case Management and Campaign Management.
- Publish reports on web/portal using BW/iView templates.
- Modified standard and created custom info-source/data-source, ODS, and info-cubes
- Maintained and created aggregates and hierarchies (both time dependent and time-independent).
- Involved and led multiple full life cycle implementations of SAP BW and BOBJ reporting.
PROFESSIONAL EXPERIENCE
Confidential
Sr. BI Lead/Solution Architect
Responsibilities:
- Manage scope, costs and schedules to approved plans. Ensure that projects and program activities are adequately staffed in a timely manner, and allocated in an optimum manner.
- Ensure proper track management, execution, and cross-track coordination.
- Monitor progress, and provide guidance and oversight to global efforts, and implementation projects.
- Enable SAP Fiori Launchpad designer to configure system wide tile for navigation
- Work with Users Expectations (UX-role-specific business catalogs) and cloud-based HANA4S in addition to BW on HANA.
- Lead end to end solutions delivery of large scale reporting applications on HANA
- Architect, Design and develop near real time Data Warehouses and BI solutions using SAP HANA.
- Excellent experience in Near real-time data induction using SLT.
- Adept at design & development using HANA modeling techniques.
- Working knowledge of SAP Fiori apps “HTML5” in addition to Gateway/oData protocol implementation and Web via Fiori User Interface (UI).
- Create roadmap in upgrading SAP BW to Cloud and assisted in conversion of SAP-ECC to HANAS4 core applications.
- Conduct formal reviews at the completion of each phase to determine if progress and quality of the effort is sufficient to recommend to the program leadership readiness to begin the next phase.
- BO front end reporting development using Webi, Lumira, Dashboard and Analysis for Office.
- Familiar with data architecture including data ingestion, pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing.
- Real time experience in Hadoop/Big Data related technology experience in Storage, Querying, Processing and analysis of data.
- Ability to deployHadoopcluster, add/remove nodes, keep track of jobs, monitor critical parts ofcluster, configure Name-nodehigh availability, schedule/configure &take backups.
- Manage rollout schedule, project priorities and ensured alignment with other initiatives.
- Contribute to other project requirements when needed including business strategy and risk management & resolution.
- Work with the 3 C’s, Global Business Process Owners (GBO) and Subject Mater Experts (SME) to define solutions and provide best practices.
- Provide readiness assessment and recommendations for the go-live planning and delivery.
- Gathering Business requirements & convert them into Blueprint & translating Functional Specifications into Technical Specifications.
- Coordinating efforts in connecting BODS to HANA, A4O to HANA, SSO, and SQL to BW on HANA and making sure all team members are connection to development.
Confidential
BI/BOBJ Lead/Solution Architect
Responsibilities:
- Directly involve in Enterprise Data Warehouse (EDW) design and implementation of 5-wave SAP global project covering Asia, South America, North America, Europe and Far East.
- Act as BusinessObjects (BOBJ) solution architect in defining SAP BW to BusinessObjects integration.
- Travel globally to assess, document, and analyze reporting requirements to generate FRICEW list.
- Setup BusinessObjects project roadmap, strategy and blueprinting and work with off-shore teams (India, Hong Kong & UK).
- Provide BI techno/functional reporting solutions in the area Sales, Supply Chain, Planning, Forecasting, Procurement, Inventory, and Enterprise Asset Management & Material Cost
- Evaluate and identify the critical business processes that are most likely to realize significant improvement as a result of utilizing SAP HANA
- Worked with 5 Work Streams team concept that included: OTC, P2P, P2M, WHL, and FICO.
- Establish a “current state” baseline and demonstrate a “projected state” that can be realized through the use of SAP HANA
- Provide the unique roles that business and IT each play in building the SAP HANA business case
- Define the guidelines for ensuring stakeholder buy-in and support before bringing the case to executive decision-makers
- Assist SAP functional team to define business processes, define gaps and provide gap resolutions.
- Provide SAP best reporting solutions using SAP transactional reports and BI reporting platform.
- Utilize 5 phase SAP ASAP methodology that include IT1, IT2, UAT, regression testing & cut-over.
- Provide technical solution for integration to/from BusinessObjects 3.1 & 4.0 to SAP & other external systems such as Infomatica, Salesforce.com, MDM, APO, CRM, PS and SCM.
- Work with IT management to define & prioritize BI activities, project planning and resource allocations.
- Design and implement BO Universe to fit globally and providing 1000+ reports from multiple Universes.
- Compare reporting requirement objects to global template in order to define reporting gaps.
- Work with ETL systems such as Infomatica (LZ, ADS & DM layers) to stage global data repositories.
- Map and define reporting objects to metadata repositories in order to extend global reporting platform.
- Convert BusinessObjects 3.1 UNV to BO 4.0 UNX using BO integration and migration tools.
- Utilize IDT (Project Layer, Connection Layer and Data Foundation Layer & Business Layer.
- Utilize BO 4.0 Explorer, Interactive Analysis, BI Launch Pad, Dashboard & Advanced Analysis.
- Ensured proper adoption of BusinessObjects policies, procedures, methodologies and standards for efficient and effective implementation.
- Monitored progress, and provide guidance and oversight to global efforts, and implementation projects.
Confidential
BI/BOBJ Lead/Solution Architect
Responsibilities:
- Directly involve in BusinessObjects project roadmap, strategy and implementation.
- Act as BusinessObjects (BOBJ) solution architect in defining SAP BW to BusinessObjects integration.
- Define implementation solutions for Funds Management and financial reporting.
- Provide best practices and solution architect in utilizing BusinessObjects XI 4.0 covering IDT technology.
- Provide steps and procedures in BusinessObjects project scope, design, implement, test and roll-out.
- Provide functional, technical specs and design solution documents for gathering requirements, data modeling and landscape.
- Provide POC (Proof of Concepts) for the IT managers integrating SAP BW data sets to BusinessObjects design layers.
- Provide sample of templates for BusinessObjects Executive Dashboard on Funds Management, and financial budgeting and logistics.Assess current SAP BW (OLAP) reporting system in order to provide reporting solutions and integration to BusinessObjects (BOBJ) including installation and configuration of BO XI 4.0.
- Architect the Integration of financial and sale data sets from Hyperion to BW into DSO layers and Cubes and utilizing BusinessObjects XI 3.1 using OLAP UDT and BI 4.0 Relational IDT semantic layer to create Webi and Dashboard reports.
- BusinessObjects 4.0 tools utilization for reporting requirements.
- Create Excel workbook-based application design and creation of BI presentations in PowerPoint utilizing Microsoft Analysis for ad-hoc reporting.
- Provide vision, planning and coordination of SAP BusinessObjects reporting development such asProject Management: Timeline, Planning, Scope, Resource Allocation & Project Budget.
- Area of reporting need: Funds Management, Enterprise Asset Management, Budget Formulation, Cost, GL, AR, AP and Logistics.
- Manage Proof of Concept (POC) project that included SAP ECC, BW and BOBJ integration.
- Ensure proper adoption of BusinessObjects policies, procedures, methodologies and standards for efficient and effective implementation.
Confidential, CA
BW/BOBJ Upgrade Solution Architect
Responsibilities:
- Directly led BW 7.01 to 7.3 upgrade project
- Provided BW upgrade project plan that included “assessment, clean-ups, pre-upgrade, upgrade, post-upgrade and go-live
- Provided vision, planning and coordination of SAP Business Intelligence (BI), SAP Business Objects (BOBJ) development activities both off-shore and in-house groups.
- Ensured proper adoption of policies, procedures, methodologies and standards for efficient and effective implementation.
- Managed Integration activities between old BW to new BW covering reporting for Gathered BI reporting requirements covering Record to Report (RtR), Procure to Pay (PtP) and Order to Cash (OtC), Warehouse and Logistics (WHL).
- Provided general upgrade guidance to the BW team, BOBJ team and technical Basis team
- Upgrade Roadmap using Solution Manager with the following tasks and activities:
- Reviewed detail Info on Upgrade for SAP NW 2004s Support Rel. 2 ABAP
- Reviewed & Document Additional Support Packages for SAP NW 2004s
- Resolved problems with Support Package in Basis latest Release 6.20
- Checked for the latest SNOTE correction prior to the upgrade and run Cleanup background jobs
- Activated all Info-Objects and check Status of Info-Objects
- Checked Outstanding or terminated table conversions and remove Temporary BI tables
- Migrated BI Authorization to 7.30
- Technical BW Backend Testing
- Functional BW Front-end Testing
- Provided vision, planning and coordination of SAP Business Intelligence (BI), SAP Business Objects (BOBJ) development activities both off-shore and in-house groups.
- Ensured proper adoption of policies, procedures, methodologies and standards for efficient and effective implementation.
- Managed Integration activities between Salesforce.com, CRM and ECC to BI platform.
Confidential, TX
BOBJ/BI/BW Lead/Solution Architect
Responsibilities:
- Directly managed the off-shore software development group and on-shore IT Shared Services group.
- Acted as BW BusinessObjects (BOBJ) solution architect in defining and integrating SAP BW with BOBJ.
- Created RICEFW list of reports in order to prioritize and scope out the reporting requirements. Determine BW reporting gaps and work with subject matter experts in defining gaps
- Created both functional, technical specs and design the data model in BW to meet reporting requirements.
- Provided corporate reporting solutions in Enterprise Asset Management and Financial reporting using SAP-BW business content.
- Gathered BI reporting requirements covering Record to Report (RtR), Procure to Pay (PtP), Plan to Make (PtM) and Order to Cash (OtC), Warehouse and Logistics (WHL).
- BOBJ xi 3.1 integration with BOBJ 4.0 and SAP BW utilizing OLAP layer and RDBMS data foundation.
- Utilized SAP HANA to create relational connections and optimize HANA-based Universes.
- Created Web Intelligence reports and Dash boarding for financial and logistics.
- Assisted BusinessObjects (BOBJ) teams in installing, configuring and integrating SAP BW to BOBJ.
- Integration from SaleForce.com & Hyperion to BW and directly to BusinessObjects XI 3.1 using Relational UDT and BI 4.0 using Direct Connect.
- Provided vision, planning and coordination of SAP Business Intelligence (BI), SAP Business Objects (BOBJ) development activities both off-shore and in-house groups.
- Managed Integration activities between Salesforce.com, CRM, Project System and ECC to BI platform.
- Ensured that projects and program activities are adequately staffed in a timely manner, and allocate in an optimum manner.
- Developed Financial Enterprise Assets, Consolidated, P&L, Income Statement, Trail Balance reports.
- Ensured proper track management, execution, and cross-track coordination.
- Monitored progress, and provide guidance and oversight to global efforts, and implementation projects.
- Conducted formal reviews at the completion of each phase to determine if progress and quality of the effort is sufficient to recommend to the Program Leadership readiness to begin the next phase.
- Sign-off reporting Blueprint, design, implementation and go-live phases.
Confidential, CA
BOBJ/BI/BW Lead/Solution Architect
Responsibilities:
- Directly managed on-site and off-site reporting development team.
- Provided visions and road map for both enterprise wide and operational reporting.
- Acted as SAP BW and BusinessObjects (BOBJ) solution architect in defining reporting requirements and meeting with stakeholders to gather reporting requirements.
- Area of focus: in FI-GL, FI-AR,FI-AP,CO-CCA, PCA, WBS, COPA, MM-PUR, MC, PS and SD.
- Activated SAP BW reporting objects such as ODS, Cubes, Multi-Providers, and BEx Queries for the following business areas: FI, CO, SD, MM, PP, PS, CRM and APO.
- Walked through installation procedures with BASIS team in Integrating SAP BW to BOXI 3.1 and upgrade to BI4 utilizing IDT (Information Designer Tool) in addition to implementing following objects:
- Determined gaps and developed task list to meet new custom requirements.
- Worked with Salesforce.com and CRM team to develop cubes for Sales analytics in regards to channel, opportunities, sales, billing and marketing.
- Implemented key features of SAP- BW that included, requirement gathering, blueprinting, realization, testing and go-live.
- Worked SAP-BW business content in activating reporting objects foe Enterprise Asset management, Inventory, procurements, logistics and warehouse management.
- Provided reporting governance and ensured proper adoption of policies, procedures, methodologies and standards for efficient and effective reporting implementation.
- Utilized BusinessObjects Data Services and In Memory Appliance (HANA) for large volume of data
- Set priorities and ensured alignment with other projects and initiatives.
- Managed off-shore resources, scope and schedules in order to meet the client expected deliverables.
Confidential
BOBJ/BI/BW Lead/Solution Architect
Responsibilities:
- Directly managed the Software Development group’s part of IT Shared Services group.
- Acted as BW-Business Objects (BOBJ) solution architect in defining and implementing BW integration to BOBJ and data flow deign.
- Determined gaps and developed to-be processes to meet new requirements.
- Provided vision, planning and coordination of SAP Business Intelligence (BI), SAP Business Objects (BOBJ) development activities for in-house groups.
- Worked SAP-BW business content in activating reporting objects for Enterprise Asset management, Inventory, procurements, logistics and warehouse management.
- Managed the Proof of Concept project that included SAP ECC, BI and BOBJ integration.
- Ensured proper adoption of policies, procedures, methodologies and standards for efficient and effective implementation.
- Integration from SaleForce.com, Hyperion & Micro-Strategy to BW and directly to BusinessObjects XI 3.1 using Relational UDT and BI 4.0 using Direct Connect.
- Oversaw rollout schedule, project priorities and ensured alignment with other initiatives.
- Managed scope, costs and schedules to approved plans.
- Managed Integration activities between Salesforce.com, CRM and ECC to BI platform.
- Ensured that projects and program activities are adequately staffed in a timely manner, and allocated in an optimum manner.
- Ensured proper track management, execution, and cross-track coordination.
- Monitored progress, and provided guidance and oversight to global efforts, and implementation projects.
- Conducted formal reviews at the completion of each phase to determine if progress and quality of the effort is sufficient to recommend to the Program Leadership readiness to begin the next phase.
- Completed and signed-off reporting Blueprint phase that included functional specs, technical specs and test scripts.
Confidential
BOBJ/BI/BW Lead/Solution Architect
Responsibilities:
- Directly managed the software development group’s part of IT Shared Services group.
- Established standards in software development and integration to allow IT groups to develop software for the benefit of organization leveraging the core ERP Applications and Integration (EAI) capabilities.
- Provided support and oversight development groups to facilitate compliance with standards that protect the integrity and availability of operational environments as new software components design and implement.
- Worked SAP-BW business content in activating reporting objects for Enterprise Asset management, Inventory, procurements, logistics and warehouse management.
- Promoted the use of innovative technologies that provide benefits to both internal and external customers as they interact with organization core platforms.
- Provided vision, planning and coordination of all software development activities for in-house groups based in Canada and other locations.
- Managed the fiscal budget and capital investments in the core custom developed platforms.
- Developed BusinessObjects LOAP Universes, Relational Universes, Web Intelligence reports, Crystal reports and Dashboards.
- Assisted BI team in getting ready for upgrading BOXI 3.1 to BI 4 utilizing IDT (Information Designer Tool), EPM (Enterprise Performance Management) and EIM (Enterprise Information Management).
- Defined Universe classes, measures and LOV objects. Export/import reports to/from CMS and publish them into the EP.
- Performed Proof of Concept (POC) for SAP ECC to BI to BOBJ and non-SAP to BOBJ using Federator to merged and created enterprise reporting platform.
- Used best practice scenarios for configuration of Universe parameters setup and BW-BOBJ integration and connection.
- Involved in many small to large SAP BW/BI/BOBJ implementation projects utilizing 5-phase project methodology.
- Assisted organizations over last 7 years (Nike, Clorox, Nestle, NASA, Army, Perrigo, Fossil, VW, Domtar, and FPL) in SAP BW/BI project implementations and configurations.
- Leading mid to large teams organizing requirement gathering, design, development, testing and go-live of SAP BW/BI/BOBJ application systems.
- Provided "hands on" leadership in development and support of SAP BI solutions.
- Provided technical-functional directions and leadership to team and groups.
- Worked collaboratively with business, subject matter experts, end users and IT management to ensure that business requirements are met through proper systems configuration.
- Established standards in software development and integration to allow IT groups to develop software for the benefit of organization leveraging the core ERP Applications and Integration (EAI) capabilities.
Confidential
BW/BI/BOBJ Architect/Lead
Responsibilities:
- Responsible for detailed functional and technical requirements and design for the metrics,KPI analytics and dashboarding based on SAP BI/BOBJ from two SAP systems and various external (legacy) systems
- Responsible for all deployment and project planning activities for the BI/BOBJ implementation including technical design and realization of backend (InfoCubes/ODSs), queries. Provided all query development, testing and training documentation for end and power users
- Area of focus: in FI-GL/AR/AP, CO-CCA, PCA, PS-WBS, HR-CATS, MM-PUR, MC and SD.
- Data cleansing, data harmonization, data taxonomy, and data enrichments to/from BI.
- Contributed to BI/BOBJ related Security and Basis activities (provided transformations specifications, security requirements, etc)
- Integration from Hyperion to BW using flat file and MDM.
- Activated BI business content backend and frontend reporting for all business areas
- Worked with the Global Business Process Owners (GBO) and Subject Mater Experts (SME) to define reporting solutions and provide best practices
- Led ongoing technical and functional activities in the project & Involve in preparing functional and technical specifications
- Prepared the fit/gap analysis by comparing the requirement with sap delivered objects
- Worked in LO Cockpit to extract the data from ECC related to Purchasing Inventory Controlling and shipment.
- Provided readiness assessment and recommendations for the go-live planning and delivery
- Provided support to go live activities including query development, production support team process and training
- Responsible for the functional requirements and quality assurance of the solution; Created and executed testing strategy and detailed test scripts
- Area of focus: in FI-GL, FI-AR,FI-AP,CO-CCA, PCA, WBS, COPA, PS, MM-PUR, MC and SD.
- Utilization of Master Data Mgt (MDM) for taxonomy and to alignment, harmonize, data cleansing and enrichment of both Vendor mater and Material master to BI.