We provide IT Staff Augmentation Services!

Sap Bi Hana Lead Architect Resume

SUMMARY:

  • Extremely motivated information technology professional with a concentration in Business Intelligence/Data warehousing/ETL. Highly diligent, creative, performance driven, goal oriented, attentive and a flexible team player. Successfully worked with several full life cycle SAP implementation projects. Adept at working proactively in a fast - paced environment. Capable of managing several tasks while leading cross-functional teams to meet and exceed team goals. Proven consulting and business skills requirements within Business Intelligence arena.
  • Over 16 years of IT experience in BI Could Analytics, business analytics and Data Analysis including Big Data, Data Science, Design Thinking and IOT solutions.
  • Lead 8 years of SAP BI/BW Data Modeling, Extraction, BEx Reporting, Analysis, Performance Tuning, and Production Support.
  • Over 5 years of experience in implementing SAP BOBJ on SAP HANA solutions.
  • Over 2 years of experience in implementing SAP BOBJ Cloud (Analytics Cloud) with SAP Digital Board Room.
  • Lead Design Studio, S/4 HANA Live BOBJ Reporting, Lumira 2.0 and predictive analytics.
  • Architected and successfully implemented FIORI integration with SAP BI (Design Studio/Lumira/WEBI and BEX).
  • Lead Architect for UI/UX by applying Design Thinking strategy.
  • Over 3 years of experience with SAP Business Objects Data Services (BODS).
  • Over 8 years of extensive experience in Business Objects 4.0/3.1/XI R2, Universe Designer, Web Intelligence, BI Launchpad, Desktop Intelligence, LCM, CMC, Xcelsius, live office and QaaWS.
  • Industry Experience in IT, Healthcare, Public Sector, Financial Services, Manufacturing, and Food Services.
  • Strong knowledge of best practices and ASAP/Agile Methodologies.
  • Experienced in SAP HANA Data Provisioning methods - Trigger based SAP Landscape Transformation (SLT), Log based SAP HANA Sybase Replication, ETL based SAP BODS replication and SAP HANA Direct Extractor Connection (DXC).
  • Experienced in Data Modeling using SAP HANA Studio - Data Modeling, development of Attribute Views, Analytical Views, Calculations Views, SQL Script, Hierarchies, creating Restricted and Calculated Measures, Filters, Input Parameters/Variables, SQL Script Procedures and Currency Conversion.
  • Experienced in SAP HANA Studio, Administration including managing schemas, data model objects, import/export content and SAP HANA Security including User Management, Roles, and Privileges.
  • Experienced in ETL using SAP BODS and replicated data from ECC 6.0 tables into SAP HANA. Experienced with all the transformations (SQL, Query, Merge, Map Generation etc.) and Loading data into table definitions, suspending data loads, resuming data loads.
  • Proficient in SAP BW operations- Data Extractions, Data Load Management, Data Source Enhancements, Data Loading (Full/Delta), Open Hub Service, Performance Tuning, Aggregates, BW Transports, Advanced Process Designer (APD), Business Content installation, OLTP Extractions etc.
  • Extensively worked with Finance teams using PowerBI.
  • Extensively worked with logistics teams using geo-mapping capabilities in Tableau, Lumira and Qlikview.
  • Analyzed the GAPs in SAP provided Business content extractors and Data sources to enhance them based on the business requirements using ABAP code.
  • Experienced with Transporting between different environments of BW Objects, BEx Objects, Roles and Workbooks.
  • Worked on Central Management Console (CMC), Created Users and Groups and setting the rights, Implemented Report and Folder Level Security, importing SAP roles and enabled SAP authentication.
  • Worked with SAP BPC Environment Shell, Data Loading, Reporting, Scripts, Excel Based Add-in and Web based Reporting.
  • Prepared Functional specifications, Technical specifications, Test cases, Test results, Go Live Plan, Upgrade documents, knowledge transfers and Production support documents.
  • Excellent Communication, Organizational, and Interpersonal skills.

TECHNICAL SKILLS:

SAP BW: BW 7.4 on HANA DB, 7.3, 7.0, 3.5, NW 2004s

SAP ERP: ECC 6.0/5.0, R/3 4.6C,, CRM 5.0

ETL: SAP BODS 4.2

Analytics: Microsoft Power BI, Tableau, Qlikview

Business Explorer Suite (7.x/3.5): Query Designer, Analyzer, Report Designer and Web Application Designer

Business Objects Suite (3.1/4.0/4.1/4.2 ):Design Studio 1.6, Lumira Discovery, Lumira Designer, Lumira 1.38/2.0, Explorer, Fiori Crystal Reports (2008/2011), Information Designer Tool (IDT, 4.2)/Universe Designer Tool (UDT, 4.x), Desktop Intelligence (DeskI), Web Intelligence (WebI), Xcelsius/Dashboards, SAP BPC 10.0

Administration: SAP BOBJ CMC, SAP CMS, SAP HANA DB

Technical: ABAP/4, C, C++, Java, MS Visual Basics

Databases: SAP HANA 1.0 SP09, Oracle 9i/8i, MS Access, SQL, Teradata, GeoDatabase

Other Software: GIS Applications (Analysis and Mapping Tools), MS office Suite, Advanced Macros programming in Excel with VBA. MS-Office Suite

Operating Systems: Windows 7x/2000/XP/Vista/7/8, Linux

PROFESSIONAL EXPERIENCE:

Confidential

SAP BI HANA Lead Architect

Responsibilities:

  • Developed and implemented HANA and BI strategy
  • Approved all Functional specs for daily production reports, plants quality reports and executive dashboards.
  • Developed HANA development document
  • Developed BI development document
  • Conducted initial trainings to business users for Cycle 1 testing
  • Approved HANA views and also tested offshore developer’s views and approved to move to QA.
  • Collaborated with Sales, Manufacturing and Finance teams from Functional spec development through report development in an agile manner.
  • Implemented design thinking and user experience strategies.
  • Lead BOBJ, Cloud Analytics and FIORI development activities
  • Implemented Sales team predictive analytics reports with SAP cloud analytics with BI and Lumira.
  • Monitored defects and assigned to developers using defect tracking tool - JIRA
  • Finance Team analytics with PowerBI and Analysis for Excel.

Environment: SAP Analytics Cloud and SAP Digital Boardroom Release 2018.07, SAP HANA 1.0 SP12, SAP BOBJ 4.2 SP 05, BW 7.4, BEx, Enterprise Portal 7.0, Report Designer, SAP R/3, ECC 6.0 on HANA, Crystal Reports, Xcelsius, WebI,, Design Studio 1.6, Lumira 1.38/2.0, Explorer, FIORI, PowerBI

Confidential

SAP BI Senior Architect/Project Manager

Responsibilities:

  • End to end design and development of Operations (Energy and Capacity Utilization) dashboards for all the sites in the US.
  • End to end design and development of Commercial Account Manager Dashboard using Design Studio with link to several detailed WEBI Reports. Underlying BEx queries for WEBI reports were also developed.
  • Developed Business Objects (BO) Landscape document.
  • Designed new BO Implementation plan and requirements gathering for operations dashboards.
  • Set up BO client tools for Dev, QA and Production BO systems and connect to corresponding BW systems.
  • Prepared a guidelines document for installation of BO client tools for developers, power users and SAP team in-house. SAP HEC - Tunnel and In-house network tunnel connection issues with HEC environment were fixed, SAP notes applied and BI Launchpad Web service was configured.
  • Created technical users and assigned roles in all the three BO systems for the offshore developers.
  • Completed several POCs for BO reporting tools, Dashboards for a sample RTY report, Convert BEx workbooks to Analysis for Office, WEBI reports, Created Relational, OLAP and excel connections to BI Platform and tested, Excel to BW Workspace and consumed in Design Studio, Live office connection to WEBI and Xcelsius dashboard for live connection to excel data source, 3-Month Rolling Americas Commercial Report using Crystal Reports, AP/AR in Crystal and etc.
  • Participated and reviewed the negotiations of new contract with SAP for upgrade and migration of BW. Greenfield implementation of SAP ECC 6.0 from R/3 version 4.6C for all the plants in three continents.
  • Worked on contract negotiations with SAP vendor and other IT vendors.
  • Designed and managed upgrade and migration of BW 7.0 to HANA Enterprise Cloud (HEC) BW 7.4 version.
  • Designed and delegated BW HEC upgrade migration test plan.
  • Prepared the BW system for migration by eliminating errors related to ABAP Analyzer program for update rules. Participated in cut-over, pre Go-Live and post Go-Live activities and monitored the progress. Managed meetings with SAP HEC team for installing all the tools in the HEC environment.
  • Designed and developed HANA Live Views for Dashboards in the new BO Environment
  • Trained developers on HANA modeling techniques (Schemas, Packages with Security, Analytic Privileges, Synonyms, Calculation views, Users and Roles).
  • Designed and managed Data model management, migration of data models to different environments using Delivery Units.
  • Developed BW Workspace to connect to excel data source for Design Studio applications and presented a demo to the developing team.
  • Developed and presented to the IT team the BO tools usability based on the audience and the requirements.
  • Set up data templates for PI data extraction load into BO environments for to be consumed by BO reports.

Environment: SAP HANA 1.0 SP9, BI 7.0/7.3,BW 7.4, BEx, Enterprise Portal 7.0, Report Designer, SAP R/3, ECC 6.0 on HANA, BI 4.1 Platform, Crystal Reports, Xcelsius, WebI,, Design Studio, Lumira, Explorer, Qlikview, Tableau

Confidential, Louisville, KY

Sr. SAP BI Consultant

Responsibilities:

  • Extensively worked on developing Information models such as Attribute View, Analytical Views and Calculations Views (Graphical and Script based) using SAP HANA Studio per the business requirements.
  • Created Schemas, Packages with Security, Analytic Privileges, Synonyms, Users and Roles.
  • Worked on SQL Scripting, wrote several stored procedures.
  • Worked on real time data replication using SAP SLT replication process.
  • Worked on non-structured/structured data replication using SAP BODS ETL process into SAP HANA database.
  • Worked on Data model management, migration of data models to different environments using Delivery Units.
  • Created Data stores, batch/real-time jobs, work flows, data flows and use complex transformations like Query, Row generation, Case, Validation and Merge as per business requirements to load the data into SAP HANA database using SAP BODS.
  • Worked closely with users to gather requirements and build functional and technical specifications on multiple projects.
  • Extensively worked with extracting SQL data to BW using DB Connect. Involved in creating SQL views to extract data into BW.
  • Wrote ABAP code to create a CSV file from master data InfoObject in hierarchical format to create a manual hierarchy for Profit Center InfoObject.
  • Modified existing Workbench objects and created new objects to transition reports from Crystal Enterprise to BW. Created custom extractors for master data and text data load.
  • Designed enterprise data warehouse model with DSO as the initial layer in BI and the loaded into further targets such as other DSO’s and Cubes.
  • Wrote routines in Update Rules, Transfer Rules, Transformations (Start routines and End routines).
  • Created process chains for automating data loads. Was part of weekly data load monitoring group.
  • Extensively worked with APD to load data from Bex queries to Transactional DSO.
  • Created Multi Providers and Info Sets for reporting. Created Aggregates to improve query performance. Involved in upgrading BW 7.0 to BI 7.3. As part of the upgrade was involved in testing data loads.
  • Remodeled existing finance cubes to add new fields and define data loads to the new fields without having to drop existing data in the info providers.
  • Installed BI Statistic cubes from Business Content and loaded cubes for statistical reporting.
  • Extensively used Cell Editor, Restricted Key Figures, Calculated Key Figures, and Global/Local structures in BW reporting to create complex reports.
  • Extensively created workbook queries to perform complex statistical calculations on detailed data in excel and transferred the results to multiple tabs on a worksheet.
  • Proficient in creating user exit variables. Worked with maintaining help documents for BW reports in portal knowledge management.
  • Gathered the business requirements and prepared Technical Specification documents.
  • Created various report using the Universes as the main data providers.
  • Created Classes, Objects, Reusable filters, Cascading list of values (LOV) and custom hierarchies for drill down purposes in Universe and used in Web Intelligence.
  • Created Universes and Web Intelligence reports using BEx Queries.
  • Created Dynamic prompts and cascading lists of values using parameters in various Crystal Reports.
  • Developed Crystal Monthly variance reports with the publishing controls based on the user hierarchy ( Corporate Region Districts Business Centers)

Environment: SAP HANA 1.0 SP6, BODS 4.0, Visual Intelligence, BI 7.0/7.3,BEx, ECC 6.0 (FI, GL, AR, AP, PCA, HR), Enterprise Portal 7.0, Report Designer, ECC 6.0, BO 4.0, Qlikview, TableauCrystal Reports, Xcelsius, WebI,, SQL, Meditech (Healthcare related system), SAP BPC 10.0, Oracle, UNIX, Visio.

Confidential, IL

Sr. SAP BODS BI Consultant

Responsibilities:

  • Worked on Data Replication into SAP HANA database from SAP source systems.
  • Experienced in BODS 4.0/4.1, Data Cleansing using Data Quality and installing data quality address directories for cleansing various country related data.
  • Experienced in loading flat files from non-SAP source systems and SAP.
  • Worked on BODS Data services 4.0/4.1 Objects / Transformations such as Data Flows, R/3 Data Flows, Query, SQL, Hierarchy Flattening, Validation, Flat File Format, Validation, Table Comparison, Map Operation / Scheduling and Supporting Data Integrator Web Admin.
  • Experience in HANA based BI reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins. Experience with HANA scripts while creating complex SQL views for custom based HANA applications for software licensing.
  • Created Write-Optimized DSOs, and Direct Update DSOs.
  • Created Transformations and Data Transfer Process(DTP) on DSO and InfoCube
  • Created BOBJ Reports using Crystal Reports, Webi and dashboards using Xcelsius.
  • Created Daily Sales Analyzer Dashboard (Dashboard designer) using Pie Chart and Bar Charts.
  • Worked on CMC and Promotion Management to move objects from DEV to QA and PROD.
  • Configured the publishing of Crystal Reports in combination with SAP BI.
  • Worked on performance, tuning for scheduled and preview of reports. Worked on Security setup, roles, user folder security and other administration tasks.
  • Testing of BI InfoObjects, DSOs, Cubes and Data validations.
  • Created reusable structures, Restricted Key Figures, Formulas and BEx Reports and published in Web.
  • Created Daily Sales Reports and Finance Reports(G/L Balances and Gross Margin)
  • Created Multiproviders and all reports are based out of MPs and are published in portals.
  • Worked on Cut-over activities and data validations and post go-live support.
  • Created Universes and Web Intelligence reports using BEx Queries.
  • Designed Universes using SAP Business Intelligence 7.3 and SAP R3 data sources and developed reports in Web Intelligence, Xcelsius Dashboards and Crystal Reports.

Environment: SAP HANA 1.0 SP4, BODS 4.0, Visual Intelligence, BI 7.0/7.3,BEx, ECC 6.0, BO 4.0, Xcelsius, WebI, Crystal Reports, Oracle

Confidential, Monroe, NJ

Senior SAP Business Objects Developer

Responsibilities:

  • Extensively developed Universes for OLAP and relational data sources.
  • Worked on several reports using Crystal reports, WebI, Dashboards and other BO tools.
  • Involved in gathering of requirements with the business users and managers.
  • Archived universes, reports and users from earlier version BO tools (XIR2 and XIR3) using Import Wizard and BIAR files.
  • Created inventory accuracy Dash Boards (Xcelsius) and for management reports for inventory management and wages and costs report from cost center accounting.
  • Extensively involved in development of Universes and troubleshooting loops by aliases and contexts. Also experienced in SQL joins, cardinalities, views, aggregate conditions, LOVs, and hierarchies.
  • Developed variance, effective and complex reports with Drilldown, Sub-Reports, cross tab reports, Parameterized Reports and Formula Reports using Crystal Reports.
  • Created Dashboards with the selection criteria defaults by user role to help pre-select a subset of data that is most critical and most relevant for the users.
  • Experienced in working with SAP Business Explorer (BEx) and Published reports to 500 users and resolved issues which occurred while trying to publish the reports from CMC.
  • Experience in creating several reports in WebI with Business Objects functionalities like Breaks, Alerts, Filters, Variables, Formulas, Ranking, Query Prompts and Drill filters.

Environment: Business Object XI 4.0 SP2/3.1 SP4/ R2 SP5, SAP BW, BEx Analyzer, Upgrade Management tool, Life cycle manager, Crystal enterprise, advanced analysis, Information Design Tool (IDT), BICS, BEx Query Designer, WebI, Excel, QaaWS connectivity, Apache Tomcat 6.X, Dashboard, Oracle 10g, MS SQL 2005, Teradata, Qlikview, Tableau

Confidential, PA

Senior BW Consultant

Responsibilities:

  • Extensively used Analysis Process Designer (APDs) to generate files from the BI system which were then distributed to various departments of the commonwealth using FTP.
  • Established connections and created universes using Business Objects X1 3.1 on Bex queries for IT Spend dashboard. This dashboard allows to do various spend analysis across the commonwealth.
  • Created WEBI reports on the universes that feed Xcelsius.
  • Gathered user requirements by conducting workshops to design, develop a public facing web based Vendor Payment Inquiry tool.
  • Created Functional and Technical specifications based on user requirements.
  • Extensively created Transformations, DTPs, DSOs, Cubes, and Multi providers.
  • Extensively wrote ABAP code in start routines, end routines, and individual transformation routines.
  • Wrote routines in Infopackages to filter data loaded to BI targets.
  • Installed standard extractors and created custom extractors for Grants Management module. Wrote custom routines in BI targets.
  • Analyzed and created a how to document to replace a standard field currently being used in Funds Management to enable cross functionality between funds management and grants management modules.
  • Extensively created process chains and worked to improved performance of data loads and queries.
  • Was part of the daily data monitoring team to monitor and fix data load issues.
  • Extensively created queries, workbooks, RRI queries, replacement path queries, variables, structures, restricted and calculated key figures.

Environment: SAP BW 3.5/BI 7.0, ECC 6.0 (FM, GM, HR), Query Designer, BEx Browser, BEx Analyzer, Business Objects XI 3.1, Oracle, UNIX

Greenbrier Companies, WA

Senior BI Consultant

Responsibilities:

  • Involved in technical requirements gathering from business users and prepared presentation for SAP team.
  • Extensively involved in activation of required business content for FI-AR, FI-AP, MM and SD Modules.
  • Developed customized InfoProviders, InfoObjects, DSOs, Infosets and Multiproviders.
  • Verified the developed objects with the Business content and conducted Gap Analysis.
  • Developed Transformations and DTP objects for FI-AR, FI-AP, MM, SD and custom developed cubes
  • Worked with LO-Cockpit Extractions: 2LIS 02 ITM (Purchasing Data Document Item Level), 2LIS 02 SCL (Purchasing Data Document Schedule Line Level), 2LIS 11 VAHDR (Sales Document Header Data), 2LIS 11 VASTH (Sales Document Header Status), 2LIS 11 VAITM (Sales Document Item Data).
  • Performed the data loads for LO data sources all the way from set up table deletion, filling of set up tables, Initialization of delta’s, full loads and delta loads.
  • Extensively worked on loading data from ECC/R-3 system into BI (PSA) via Infopackages.
  • Developed reports for Open Sales Orders, Vendors Overview and Deliveries Fulfillment Rate.
  • Extensively created process chains and worked to improved performance of data loads and queries.
  • Extensively created queries, workbooks, RRI queries, replacement path queries, variables, structures, restricted and calculated key figures.
  • Created Universes and Web Intelligence reports using BEx Queries.
  • Developed ad-hoc reports by gathering requirements from the business users.

Environment: SAP BI 3.5/7.0, ECC 6.0 (FI, AP, SD, MM, FM, GM, HR), BEx Query Designer, BEx Analyzer, Business Objects XI, Desktop Intelligence, Oracle, Windows

Confidential, Santa Clara, CA

BI Consultant

Responsibilities:

  • Involved in full lifecycle SAP BI 7.0 implementation with CRM 5.0 as source system.
  • Extensively interacted with SAP Active Global support team on BI 7.0 Data modeling, Extraction and Reporting related issues.
  • Involved in support ticket system resolve group
  • Checked the process chains loading
  • Developed Transformations and DTP (Data Transfer Process) for data loading.
  • Drafted Functional and Technical specifications. Also involved in preparing test scripts and user manuals.
  • Coordinated Unit Testing, Integration Testing and User Acceptance testing phases of the project.

Environment: SAP BI 7.0, SAP CRM 5.0, BEx Analyzer, Web Application Designer, Enterprise Portal 7.0.

Confidential, Fairfax and Charlotte

Sr. Software Developer

Responsibilities:

  • Developed Floodplain Mapping System GIS database using VB Script and MS Access DB.
  • GIS applications for federal, state and local government projects.
  • Benefit Cost Ratio Application development and trained end users to support decision making of local city/county projects.
  • Stream lined survey data dumps into a database and wrote calculation codes for data processing to use in the FEMA floodplain mapping projects.
  • Lead team of developers to convert the client requirements into applications for daily data processing tasks and automated them with Java, VB and MS Access DB platforms.

Environment: GIS Python Scripts, Access DB, Java, VB, VB script and Excel Macros

Confidential, NC

Developer

Responsibilities:

  • Involved in development of GIS applications for geodatabase maintenance of inventory of city wide infrastructure.
  • Prepared extensive PowerPoint Presentations to familiarize users with crystal reports.
  • Prepared the crystal reports project plan by gathering user requirements.

Environment: GIS (ArcView 3.2/8.0), Geodatabase, Spatial Analyst, MS Access DB

Hire Now