We provide IT Staff Augmentation Services!

Sap Bi/bo Hana Lead Resume

TX

PROFESSIONAL SUMMARY:

  • Over 16+ years of IT experience SAP BI/BW, BO & ABAP, 4+ Years in HANA (Hands on exp) as a Lead Solutions Architect defining Reporting & Analytical solutions
  • Experienced and SAP certified HANA Consultant.
  • Excellent in - depth knowledge of SAP HANA architecture including Enterprise HANA, SAP HANA Cloud, Native HANA and BW on HANA, Sidecar.
  • Experience in creating HANA attribute, analytical, calculation views, SLT replication, SAP HANA LIVE 2.0 VDMs, SAP HANA Security including User Management, Roles and Privileges management, SDA/SDI, SQL scripts, Dynamic Tiering.
  • Good knowledge of SAP IBP (Integrated Business Planning) with focus in Demand, Inventory, S&OP
  • Hands-on experience in analysis and development of business applications, specifically in BPC,SD, MM,
  • FI, FM, COPA, PP, PS, HR, SRM, CRM, SCM, HCM, APO, CAR, TM, IP (Integrated planning).
  • Extensive experience working with ABAP.
  • Experienced in working with IS-Retail, AFS, Oil, TSW, modules.
  • Experience in working with End to End SAP POSDM including configuration.
  • Strong knowledge of SAP BI Data architecture, Star schema and OLAP reporting models.
  • Experience working SAP Business objects (Universe design, Design studio, Crystal reports, Webi,
  • Xcelsius Dashboard, BODI, BODS).
  • Experience working with dashboard designing tools such as Lumira, Tableau, Spot fire, SAP Dashboards etc.
  • Expertise in Infocubes, ODS objects, Open hub, Aggregates, Queries, Workbooks and BEx analyzer, process chains, Compression, partition, indexing, BI accelerator Reports SQL scripts.
  • Experienced developing Remote Cubes, BW Statistics, BI Security roles.
  • Excellent knowledge of ASAP Methodology and implementation.
  • Strong experience in conducting workshops, training sessions for users in BW reporting.
  • Defining the loading strategies, initial and delta data loads, scheduling and monitoring data loads.
  • Worked in implementation, roll-off, upgrade and maintenance projects.
  • Experience working with Integrated Planning (IP) Business Planning & Consolidation (BPC)
  • Experienced in developing ALE / EDI/IDoc, Workflow, BAPI, RFC Applications.
  • Experienced in coding for RICEF, Webdynpro objects.
  • Excellent communication, analytical and presentation skills with ability to work both in a team and individually.

TECHNICAL SKILLS:

ERP: SAP R/3,ECC 5.0/6.0 with SD, MM, FI, CO, PP, HR, IS-Retail/CAR, BW, APO, TMIS-Oil& Gas

HANA: HANA LIVE, SLT, Analytic views, Attribute views, calculation viewsCDS views, VDM, SQL Scripts, Stored procedures, HANA Security, LSA++, Hybrid modeling, Lumira, SDA, SLT, Sybase Replication, HANA XS

Net weaver: BI 7.X( LO Cockpit/ FI / IP/ BPC / Retail/CAR). XI 3.0, PI 7.0/7.1ABAP /4 Skills: ALV, OOABAP, SAP Script, Smart forms, Adobe print forms, Data Dictionary, ReportsDialogue programming, Web dynpro.

SAP Interfaces: RFC, BAPI, ALE, IDOCs, EDI, BDC, LSMW and Work flow, Data stage.

Business objects: BO XI R3/R4, Crystal Reports, Webi, Lumira, Live Office, Xcelsius, Dashboard, Fiori

Languages: ABAP/4, PL/SQL, C, C++, VB and JAVA.

RDBMS: Oracle 7.x/8x, MS Access.

Office Tools: MS Excel, MS Word.

Operating System: Windows NT/XX, UNIX, LINUX.

Non SAP tools: Tableau, Data stage, Informatica, Spotfire.

PROFESSIONAL EXPERIENCE:

Confidential, TX

SAP BI/BO HANA Lead

Responsibilities:

  • Provided consulting, Architect & development services for the business case development, requirements, planning, design and implementation of BI, HANA / HCI solutions for IBP - S&OP. Architected optimal solutions, best practices and process improvements. Developed rapid prototyping to facilitate requirements and design discussions.
  • Lead project teams in blueprinting sessions and develop future-state enterprise information architecture for SAP technologies. Worked closely with Practice Leaders and Project Management to coordinate the delivery of quality technical solutions that minimize technical risk.
  • Created HCI interfaces for Data loads into IBP core tables through the staging tables after integrity checks
  • Between ECC, APO, BW, IBP to assist S&OP process.
  • Implemented HCI data stores, metadata import, HCI data flows to map the master data attributes and also transactional KPIs.
  • Designed and developed HANA, HCI & BI solutions (Native & Hybrid) such as ADSOs, Composite providers, HANA LIVE, SDA/SDI from multiple data sources, hybrid data model, query, and dashboard. Other advanced analytics developed using Analysis for Office, Design studio, Tableau, Lumira aligned with IBP Tobe process
  • Monitored and fixed the HCI interface issues during Development, Go live, Hyper care.
  • Developed various process chains to load the data into S&OP and APO related ADSOs.
  • Improved BI / HCI governance (standards, templates and processes) and implemented HANA security standards.
  • Provided HANA SME in dynamic tiering for hot & cold data management, integrated test scenario planning and execution.
  • Implemented Security policies for BW on HANA and Native HANA models.
  • Managed and assigned activities within time, cost and technical objectives with internal or external resources.

Environment: SAP Net weaver- BI 7.5, HANA 2.0, ECC 6.4

Confidential, CT

Lead SAP BI/BO HANA

Responsibilities:

  • Lead project teams in blueprinting sessions and develop future-state enterprise information architecture for SAP technologies. Worked closely Practice Leaders and Project Management to coordinate the delivery of quality technical solutions that minimize technical risk.
  • Implemented Native HANA CAR2.0 (Customer Activity Repository) by integrating SAP CRM, POSDM and Legacy systems
  • Setup data replication from CRM, EEMS systems to CAR system using Informatica, SDA. Involved in mapping the source to target tables and data transformations using Informatica tool.
  • Developed various data models using SAP HANA LIVE for CRM and POSDM reports as per customer requirement.
  • Designed and Native Hana modeling for Attribute, Analytical and Calculation views and developed complex SQL scripts, Stored procedures etc.. per client requirement.
  • Involved in Cutover preparation and system preparation, GO LIVE, Hyper care
  • Worked with Attune consulting offshore team to develop HANA RDS solution for SAP CAR.
  • Extensively worked on data visualization for SAP CAR reports using Lumira, Dashboards
  • Created BOBJ universes and WEBI, Design studio, Analysis office reports as per customer requirements

Environment: SAP Net weaver- BI 7.4, HANA 1.8, ECC 6.4, POSDM, CAR 2.0, Oracle and AIX

Confidential, CA

Led BI/BO HANA Consultant

Responsibilities:

  • Define project scope, develop project plans, gather and document business requirements.
  • Lead project teams in blueprinting sessions and develop future-state enterprise information architecture for SAP technologies
  • Migrated BI 7.1 to BI 7.4 on HANA.
  • Integrated SAP BI and HANA data models with Tableau dashboards and developed various analysis scenarios.
  • Business data modeling implement and deploy SAP BI, BOBJ & BW on HANA solutions to achieve defined business goals. Implement end-to-end data warehousing and analytics.
  • Participated HANA strategy planning and HANA Box setup and development activities.
  • Created HANA Analytic views, Attribute views, calculation views, HANA security/user setup &configuration,
  • Developed Schemas, schema mapping, HANA programming including SQL, SQL Script.
  • Setup data replication from SAP system to HANA system using BODS.
  • Implemented complete HCM, SRM BI,COPA & FM reporting solutions as per client procurement processes.
  • Involved in Cutover preparation and system preparation, GO LIVE, Hyper care, Production support. Established connections between various systems and BI, HANA.
  • Enhanced FI(AR, AP, GL), HCM/HR (OM, PA,PY,TM), FM, SRM extractors and developed several reports as per customer need. Created BOBJ universes and WEBI reports, Design studio, Dashboard, Spitfire reports as per customer requirements
  • Helped the client Confidential to resolve critical performance issues during cutover.

Environment: SAP Net weaver- BI 7.3, HANA 1.4, ECC 6.0, HCM, SRM 5.0, Oracle and Windows NT

Confidential, FL

Lead BI/BO BPC Consultant

Responsibilities:

  • Lead team in the strategic direction set by senior management, to determine solutions to complex problems.
  • Assisted the client in resolving critical performance issues which were hampering the clients budgeting process.
  • Stream lined clients SAP BI system process and maintenance and achieved excellent throughput.
  • Participated in Confidential future HANA strategy and workshops.
  • Analyzing and customizing client planning processes (requirements analysis). Integration of reporting and planning applications using SAP BI.
  • Worked on the complex integration of HCM, FM, BPC budget and position control data and developed several reports as per customer requirements.
  • Enhanced several HCM/ HR, FI, SRM, BPC extractors and developed new extractors as well as per customer need.
  • Trained & Mentored full time Confidential employees in BI System performance tuning and system maintenance.

Environment: SAP Net weaver- BI 7.0, ECC 6.0, HCM,SCM 5.0, SRM, MY SQL and Windows NT

Confidential, WI

Lead BI/BO BPC Consultant

Responsibilities:

  • Define project scope, develop project plans, requirements gathering, analysis, Data Modeling, coding, testing, implementing and maintenance of the diverse systems and reporting needs for the enterprise.
  • Participated in H-D future HANA strategy planning and Native HANA & BWoH POC developments.
  • Analyzing and customizing client planning processes (requirements analysis). Integration of reporting and planning applications using SAP BI.
  • Configured BPC Appsets, applications, and dimensions.Configure and support Business Process Flows and Security, Script Logic and Calculations .
  • Provide support for end users of SAP BPC to include management of end user access, monitoring/resolving system performance issues, and uploading data.
  • Involved in Cutover preparation and system preparation, GO LIVE, Hyper care, Production support.
  • Enhanced BPC, FI, CRM, APO, COPA, HR extractors and developed reports as per customer need.
  • Helped the client H-D to resolve critical performance issues during cutover.
  • Created HANA Analytic views, Attribute views, calculation views, HANA security/user setup configuration
  • Involved in up gradation to BI 7.3. Migrated various data objects and Bex reports from 3.5 to 7.3 versions.
  • Developed BOBJ universes, WEBI and crystal reports, Visual Intelligence (Lumira) dashboards in COPA, APO, CRM modules as per customer requirements.
  • Worked on setting up connection between BI and tablue system and developed tableu reports and dashboards.
  • Involved in data replication to BW system from non-SAP systems using Informatica. Involved in mapping the source to target tables and data transformations using Informatica tool.
  • Worked on BI System performance tuning, Mentored junior team members and reviewed their development work.

Environment: SAP Net weaver- BI 7.3, HANA 1.0, ECC 6.0, SCM 5.0, HCM,CRM, APO, DB2 and Windows NT

Confidential, OH

Lead BI/BO/ POSDM Consultant

Responsibilities:

  • Worked in the world’s first implementation project for Retail Method of Accounting (RMA).
  • Worked on full cycle implementation of POS DM project at bigots including configuration of POSDM.
  • Leading the team members. Participating in the design, Data Modeling, development and testing of the SAP BI components to support clients' requirements and to integrate these designs into the overall client data strategy.
  • Configured POSDM & Integrated reporting and planning applications using SAP BI.
  • Designed various Info cube/DSO, multi-cube, Created custom data Sources for sales, discounts, gift card, merchandise card and inventory related transactions.
  • Created and maintained Process chains. Created several critical Bex reports and work books.
  • Worked extensively on Open hub to distribute BI data to Data stage and Teradata.
  • Developed solutions for RMA foundation layer, Stock shrinkage and applied several SAP Notes for the RMA solution.

Environment: SAP Net weaver- BI 7.3, ECC 6.0, RMA, Retail/POS DM Oracle and Windows NT

Confidential, OH

Lead BI/BO BPC Consultant

Responsibilities:

  • Participating in the design, development and testing of the SAP BI, BPC and Business objects components to support clients' requirements and to integrate these designs into the overall client data strategy.
  • Configure BPC Appsets, applications, and dimensions. Develop, modify, and manage input forms and reports for budgeting, forecasting, and financial reporting, Perform data integration with EVDRE and EVSEND.
  • Designed Info cube/ DSO, multi-cube architecture. Created custom data Sources for master and transaction data from legacy system.
  • Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections, created aliases to resolve the loops.
  • Designed Universes for Financial Billing system and Order processing, Created Objects and prepared Reports like financial reports, standard and adhoc reports.
  • Worked extensively on Business Content installation for CRM, FI,CO-PA, Generated CO-PA specific Data sources in ECC for Profitability analysis and customer relationship.
  • Created various Process chains and scheduled them using Autosys. Worked extensively on Openhub to distribute BI data to Legacy application such as Pegasus, PGL.
  • Built Bex reports for complete financial analysis product lines, regions, sales distributions, Cost center Accounting and Profitability.

Environment: SAP Net weaver- BI 7.0, ECC 6.0, CRM, BO XI R3, Oracle and Windows NT

Confidential, IL

Senior BI/BO Consultant

Responsibilities:

  • Involved in Full life cycle from blue print to post go live phase of the project. Involved in meetings with end users, Technical analysis of requirements and creating technical specifications, effort estimations. Object development, reviewing and testing, Technical documentation of the developed objects in the system.
  • Heavily Involved in Data warehouse design reviews for SD, MM, FI, HR, APO, CRM modules and suggested effective ideas. Installed Business content Objects based on user requirement.
  • Created Custom Transactional cube to load APO data. Worked with Overall Demand Planning Infocubes. Plan/Actual Comparison of Sales Quantities info cube and Order Forecast query.
  • Built universes based on BW Query and Cubes, Optimized report response times
  • Worked on Crystal reports and developed dashboards using Xcelsius and published it in PDF Version.
  • Created Directories along with security configuration. Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
  • Extensively used Query designer to created queries, variables, filters, calculated key Restricted key figures, etc

Environment: SAP Net weaver-BI 7.0, SAP ECC 6.0, BO XI R3, Oracle and Windows NT

Confidential, NC

Lead BW/BI Consultant

Responsibilities:

  • Technical analysis of requirements and creating technical specifications, effort estimations. Object development, reviewing and testing,
  • Coordinating with the offshore team and to assigning the requirements.
  • Implemented the standard Business content for SD, MM, AFS, SRM and modified according to customer needs.
  • Worked extensively on custom data sources and custom cubes to meet the client’s requirements.
  • Configured, enhanced and implemented various AFS specific, Inventory, Sales, extractors
  • Worked with formatted reports using Crystal Reports and Crystal Enterprise.
  • Extensively used BEx analyzer to created queries, variables, filters, calculated key figures, restricted key figures, charts and workbooks.
  • Involved in Post Go Live support and bug fixing activities.

Environment: SAP Net weaver 04 BI 7.0, SAP ECC 6.0 AFS, Oracle and Windows NT

Confidential, MO

Senior BW Consultant

Responsibilities:

  • Involved in setting up the project plan, designing the functional, technical specifications, testing plan and production migration plans.
  • Extensively worked on Design and Development of Cubes, ODS objects, Info objects, Multiproviders, Datasources and Infosets for reporting on Sales Order Data, Purchase Contracts, and inventory management
  • Involved in Partitioning and un partitioning cubes to improve performance.
  • Developed web based queries for the users within the intranet, used HTML for customizing the reports.
  • Extensively worked on fine-tuning of the reports, used various tuning techniques which include building aggregates, Routines, Function modules and also data distribution.
  • To ensure that development and security standards meets SOX compliance

Confidential, OH

Senior BW Developer

Responsibilities:

  • Involved in Requirement Analysis, data modeling and design, and technical implementation.
  • Developed multi-dimensional data models using star-schema and extended star schema techniques.
  • Worked with Retail/POS DM data sources to extract the data from SAP Retail to SAP BI. Installed POS stored Article/day/week/month cubes to do the analysis on recent and past point of sales.
  • Developed COPA, LO Cockpit, application specific and generic extractors & Bex Reports.
  • Tailored Transfer Rules and Update Rules using routines and start routines to meet requirements at optimum performance.
  • Implemented integration between Retail and POS DM of store financial transactions, store orders.
  • Developed custom BAPIs for bonus buys, promotional transactions and extended standard BAPIs for the additional fields.

Confidential

Senior BW Developer

Responsibilities:

  • Technical analysis of functional requirements and creating technical specifications, effort estimations. Object development (coding), reviewing and testing (unit testing). Technical documentation of the developed objects in the system.
  • Implemented and enhanced IS Oil TSW, CO-PA, LO Cockpit, GL, AR&AP data extractors as per Customer Needs.
  • Involved Supporting in IS Oil TSW including Stock Projection Worksheet (SPW), Three-Way Pegging(3WP), Berth Planning Board(BPB), Ticketing cubes and reports.
  • Developed Pricing Calculation and transportation and Distribution programs.
  • Design and coding interface programs to other systems as well as to diverse external systems, such as onboard truck computers, terminal automation systems (TAS), transportation planning systems.
  • Implemented BADIs/ user exits for enhancing the standard transactions.
  • Development of reports using OOABAP. Established connection between SAP BW and datastage ETL tool.

Hire Now