We provide IT Staff Augmentation Services!

Bi/hana Platform Solution Architect Resume

OBJECTIVE:

Seeking a role in SAP BI environment to utilize SAP BW, BOBJ and SAP HANA skills

SUMMARY:

  • SAP certified BW and ABAP expert with over ten years of working experience in SAP BW, ERP, BusinessObjects & HANA Analytics implementation projects and currently working as BI Solution Architect in a fast paced SAP environment.
  • Having diversified cross functional and cross industries experience which includes Oil & Gas, Public Sector, Manufacturing and Commercial Services environments with excellent blend of SAP functional expertise in FICO, FICA (PSCD), SD, MM, PS, EHS, PM & HR with industry domain knowledge, experience and APICS CPIM and PMP s.
  • Experience in delivering end to reporting solutions using SAP ERP, third party databases, SAP BW, HANA DB plateform and BusinessObjects toolset, working in different capacities and roles like developer, designer, project lead and solution architect.

PROFESSIONAL EXPERIENCE:

BI/HANA platform Solution Architect

Confidential

Responsibilities:

  • Working as a key resource on SAP Business Suite on HANA database migration project implementing HANA Analytics migrating from BW data warehouse
  • Performing gap analysis for reporting and dashboarding & requirement gathering, analyzing HANA Live views to find suitable business content and enhancement gaps and assisting in tool selection for reports and dashboards for using WebI, DesignStudio and Lumira on HANA modeling views
  • Responsible for designing and developing HANA modeling artifacts like Attribute, Analytical & Calculation views and enhancing & customizing HANA Live views to cater business requirements
  • Responsible for designing and implementing security concepts for HANA to BOBJ platform connectivity and customizing user access for BOBJ platform
  • Designing reports, dashboards & storyboards using WebI, DesignStudio and Lumira using HANA models

BW/BI Solution Architect

Confidential

Responsibilities:

  • Responsible for scoping and functional requirements gathering by engaging and interacting with business users, SMEs and functional experts
  • Responsible for documenting functional requirements into FTDs (functional design documents) and blue print documents utilizing diagrams, process flow charts, data flow charts, simplified calculation scenarios, screen shots and other visual and graphing techniques
  • Responsible for developing, testing and supporting BI end to end reporting solutions and functionalities including BW data warehouse backend configuration using BW Administration WorkBench, front end query and report developments using Business Explorer Query Designer version 7.x integrating with BusinessObjects 4.0 BI platform toolset using BICS connectivity
  • Extensively involved in reports and Dashboards designing and developing using SAP BusinessObjects Web Intelligence (WebI) 4.x, SAP BusinessObjects Dashboards 4.x, SAP Crystal Report for Enterprise and Crystal Reports 2013, SAP Analysis for OLAP
  • Responsible for BusinessObjects 4.0 BI platform configuration, and administration including security model design for object level access, promoting BI objects through landscape using (LCM) Life Cycle Management, BI launchpad customization.
  • Recently completed BW 7.31 upgrade and BusinessObjects 4.0 implementation projects as a key resource and redesigned various existing data flows using (SPO) Semantically portioned objects to improve query performance
  • Configuring and implementing BW data modeling including transactional and master data targets, ETLs for data extraction from SAP modules including FI, CO, HR, CATS, SD, PS and Non SAP data sources including DB connect, UD Connect and Flat File connectivity
  • Continuously involved in performance improvement opportunities to improve extraction and query performance by tuning ABAP code, redesigning process chain for long running loads and remodeling data targets and front end query and reporting objects chains
  • Supporting non standard business data extraction requirements by enhancing standard SAP extractors and writing ABAP code for custom extractors
  • Playing key role in advising and decision making on architecture design and development and functionality adoption for ERP and BW solutions and also taking part in analysis and planning in HANA database adaption initiative

Senior SAP BW Consultant/BI Lead

Confidential

Responsibilities:

  • Took part in analyzing current state and scoping and requirement gathering for future state and documenting processes and specs in functional and technical design documents,, business process flows, and dataflows using flow charts, functional Design documents (FDDs), Technical Designs Documents (TDDs) Report Design Documents(RDDs), Information Design Documents (IDDs), Decision Supporting Documents(DSDs), Complex Configuration Documents(CDDs) and Enhancement Detail Documents(EDDs)
  • Involved in activating Business Content and configuring and developing BW data modeling objects using Administration Workbench, developing reporting functionalties and testing by executing test plans, planning and executing multiple cutovers cycles
  • Played a key role on BI central team involved in Hardware migration, Database migration, OS migration and system upgrades for BW 3.5 to SAP NetWeaver BW 7.x ECC6.1, CRM 2007, SRM 7.0including validation for data extraction for SD, FICO, HR,CATS, PM, EHS, MM and rollout for Analysis Authorization, Business Explorer 7.x Frontend rollout
  • Involved in SAP NetWeaver Business Explorer 7.x (BEx) Query designing and integrating it to BusinessObejects 4.0 for Dashboard development using BusinessObjects Dashboards 4.0
  • Managed resources and development and testing activities with onsite and offshore team from India and coordinating smooth working between teams to meet highly tight deadlines
  • Provided expertise and advise in system design and architecture and functionality development and maintaining standardization and best practices by engaging and involving developers and leading BI central team responsible for setting up landscape for the final consolidation project, BW accelerator (BWA/BIA) implementation, planning and execution of complex multi staged cutover plan

Senior Technology Consultant

Confidential

Responsibilities:

  • Planned, advised, designed and implemented functionality and SAP BW & Cognos reporting architecture to accommodate highly increased data volumes resulting from Medical Services Plan Health Care Card project
  • Performed data volume analysis, hardware sizing and designed Data Warehouse model using backend compression, cube splitting and Business Explorer 7.x Query custom routing based on MultiProvider techniques to drastically reduce database access time and improve BEx Query performance
  • Coordinated implementation of Database and hardware upgrades with Basis and Infrastructure teams and business owners for User Acceptance Testing (UAT) and change management communication and
  • Performed project scoping and series of functional requirement gathering workshops with Revenue Services BC and Ministry users for their new reporting requirements and developed, reviewed and delivered final functional and technical design documents outlining and including reporting descriptions, definition, flow charts for business processes, data flows and samples on very tight time line
  • Completed SAP BW data models including data storages, dataflow ETLs and Process Chains using Administrator WorkBench
  • Completed on time development of identified reporting functionalities, unit testing, integration testing and UAT coordination, Cutover execution and technical specs for PSCD backend ETL & Business Explorer frontend for BW - Cognos and backend ALV reports

Senior Technology Consultant

Confidential

Responsibilities:

  • Supported SAP R/3 4.7 to ECC 6 and BW 3.5 to SAP NetWeaver 7.0 upgrade project as a key BW resource involved in DataSource and extractor validations, analyzing SPDD and SPAU lists and fixing object conflict issues, performed RSRV, RSUPGRCHECK checks and fixed inconsistent objects
  • Supported Basis team during system preparation in running tasks on ASU execution checks and fixing issues
  • Performed RFC connectivity, load consistency and extraction unit testing. Responded critical failure recoveries and applying OSS notes to the upgraded sandbox and development systems
  • Created issue logs, transports, check lists, test case scenarios, integration test case documentations
  • Analyzed and adjusted required objects in extract programs & data dictionary Performed unit testing and supported integration test case scenarios validation and document results by using Quality Center and Solution Manager
  • Performed go live cut over tasks to synchronize deltas in production system

Senior Technology Consultant

Confidential

Responsibilities:

  • Delivered end to end SAP BW backend and BEx reporting solution as a lead BW developer for SAP rollout for Ministry of Employment & Income Assistance
  • Analyzed user requirements and identified reporting gaps to develop new reports
  • Designed ETL, using Standard, custom and generic extract and DataSources
  • Activated business contents and identified and created required custom InfoObjects to complete InfoSources, provided DataSource/InfoSource transfer rules mappings, update rules providing data massaging through formulas and complete ABAP routines
  • Developed custom InfoCubes, ODS objects and MultiProviders
  • Developed Process Chains to automate data uploads and synchronize work flows
  • Supported production control, monitored load failures, provided quick fixes and enhancements reported on service center tickets
  • Applied performance tuning and regular maintenance using aggregates, OLAP Cache, indexing, compression and cube partitioning techniques

BW Consultant

Confidential

Responsibilities:

  • Engaged to delivered end to end SAP BW reporting solutions for Account receivable, AR Aging, Sales Analysis and Profit Center Accounting reports
  • Performed requirement gathering and documenting them into functional specs
  • Performed backend configuration and development with Workbench including activating business contents, designing and developing 3,x data flows using Standard and custom extractors, ETLs with DataSources, InfoSources, Transfer Rules, Update Rules, enhancing and developing new InfoCubes, ODS objects, InfoSets and MultiProviders
  • Supported production control, monitored load failures, provided quick fixes and enhancements reported on service center tickets
  • Assisted the business analysts in conducting User acceptance test scripts
  • Created Technical documents for completed reports for clients document repository according to SAP best practices

BW Consultant

Confidential

Responsibilities:

  • Designed and implemented Sales analysis, Forecast analysis, Forecast error tracking reporting solutions and provided SAP BW to the end users
  • Activated, enhanced and adjusted SAP delivered objects to satisfy requirements
  • Created custom ODS for staging data for purchase and planned order item data
  • Loaded DP and SNP planning area live cache data from APO for analysis in BW
  • Developed custom cube to stage data from cubes containing historical plan and actual data, introduced calculated KeyFigures and additional characteristics required for complex error tracking reporting rollups by loop back process
  • Provided complex reports required for days of supply target and actual inventory, Forecast and shipping history comparison, forecast bias and error tracking reports

BW System Analyst

Confidential

Responsibilities:

  • Supported business community for their day to day to operational and ad hoc analysis needs, creating BEx queries, Workbooks and reacting to production issues for smooth operations
  • Interacted with the key business users and business analysts on the SD, MM, FI and PP modules in gathering reporting requirements and translated them into functional and technical specifications
  • Developed flexible queries using Filters, Free Characteristics, and Navigational attributes in the BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels
  • Analyzed and corrected production problems as they occur in the SAP BW system
  • Monitored data loading Info packages, analyzed the reasons for frequent failures of Info Package and manual editing
  • Scheduled and monitored Periodic Data loads from SAP R/3 to BW through delta uploads using Process chains
  • Created and activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (at ODS and Info Cube level)
  • Filling and deleting of setup tables in the Sales, Delivery and Billing LO extractors and experience with Generic extractors
  • Installing Business Content Info Cubes and Info Sources
  • Activating Data sources in SAP R/3 and mapping them to Info sources with transfer rules

ABAP Consultant

Confidential

Responsibilities:

  • Worked as an ABAP development team member supporting ABAP workbench development for Screens & Menu to develop transactions and SAP queries with focus on MM and SD module reporting Designed, created and maintained Data dictionary objects like customized tables, structures views, objects, data elements and domains applied buffering techniques and indexes for performance optimization
  • Created and modified ABAP reports, queries for operational report requirements
  • Participated in SAP ABAP Workbench, worked on various ABAP Work Bench development tools, prepared, modified and tested codes, devolved reports and queries
  • Developed demo projects to gain application expertise to achieve ABAP consultant
  • Supported BW team in monitoring nightly BW data loads, developing BEx queries and completing BW backend enhancements in response to business reporting and ad hoc data requests

Hire Now