Sr. Bi Back End Developer Resume
4.00/5 (Submit Your Rating)
Hopkins, MN
SUMMARY
- SAP BI consultant with over 9 years of IT experience in SAP BW version 3.5, NW 2004s BI 7.0, 7.4 experience and 3 years of experience in SAP Business Objects 4.0, 4.1 versions.
- Around 3 plus of experience in SAP Enterprise HANA Development.
- Experience in designing the data modeling in different levels in End2End SAP HANA solutions
- Expertise with SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
- Experience with Data Extraction Transfer Loading (ETL) using SAP BODS 4.0
- Experience in using the SQL scripting, Stored Procedures in HANA Studio to fulfill complex business requirements.
- Knowledge of SAP HANA SPS 09/10/11 including good hands on work experience in HANA.
- Technical proficiency in various areas of SAP BI/BW like Modeling, Extraction, Reporting with expertise in handling implementation and Support projects, resolving user incidents.
- Expertise in BW Development spanning across the ECC application areas FI, CO, SD, MM, PP, HR etc. Expert in handling SAP BW front - end tool BEx Query Designer, Analyzer and WAD.
- Experience with SAP HANA Migration & Optimization HANA sizing and performance tuning.
- Experience with SAP HANA Security including User Management, Roles, and Privileges.
- Expertise in Design, Development and Deployment of Business Objects solutions for Corporate reporting requirements and involved in a full life cycle implementation of SAP BI/BO.
- Proficient in Business Objects tools - Universe Designer / Information Design, Web Intelligence, Xcelsius live office, Dashboard Design, Crystal reports and CMC.
- Experience in creating Test Scripts - Unit/Functional Integrating Testing, Creating Test Plans and End User Documentation and Training Materials.
- Trained End Users in SAP Business Objects tools like Universe, WebI, Dashboard/ Xcelsius 2008.
TECHNICAL SKILLS
- SAP HANA 1.0, 2.0 / NATIVE HANA
- SAP BI / BW - 3.5, 7.0, 7.3, 7.4, 7.5
- SAP BUSINESS OBJECTS - 4.0, 4.1, 4.2
- SAP SLT, SDI, DXC
- SAP HANA LIVE (Analytics)
- SCRUM /AGILE METHODOLOGY
- MICROSOFT POWER BI
- SAP BODS - 4.0
- SQL/PLSQL
PROFESSIONAL EXPERIENCE
Confidential - Hopkins, MN
Sr. BI Back End Developer
Responsibilities:
- Architect, Design and Develop near real time Data Warehouses and BI solutions using SAP HANA.
- Translate Complex business requirements into scalable technical solutions meeting Data Warehousing standards.
- Extensive SAP Implementation experience using AGILE & ASAP methodologies with Project Preparation, Blueprint, Realization, Go Live and Post Implementation Support.
- Expertise in SAP HANA data modeling using Attribute View, Analytical View, Calculation View, CDS Views, Stored Procedure, SQL Scripting, Table Functions, Decision Tables and Analytical Privileges.
- Strong knowledge and expertise in Data provisioning techniques SAP SLT, DXC, SDA & SDI.
- Built Smart Data Access to get the data from Non SAP database to built complex models in Cost Centre Plan Vs Actual, Wrap Rate, Site Dash Board.
- SLT table replication configuration for enterprise HANA which includes table replication, data filtration (Include programs), table columns selection, Data load conditions and Table replication partitions. Identifying table size before replication which will help to take table replication decision.
- Expertise in Native HANA hands-on development experience creating SAP HANA information models.
- Proficient in interpreting and writing complex SQL Procedure and translating business needs into Data Modeling and Reporting Solutions.
- Experience in SAP OTC (Order to Cash) and PTP (Procure to Pay) Business Process KPI’s reports.
Confidential - Wichita, KS
Sr. SAP BI/BOBJ/HANA Consultant
Responsibilities:
- Involved in Architected and Designed solutions for replacing the old SAP BW system with SAP HANA Enterprise using SLT and BODS.
- Experience with AGILE methodology and working in a globally distributed team structure.
- Built HANA models for SAP SD, GL, FI-AR, FI-AP, and Inventory and built reconciliation queries between SD, FI-GL and Inventory.
- Integrated SAP and Non SAP Data through SLT and Data Services into HANA DB
- Built complex SQL Procedures to fulfill Business requirements.
- Configured Smart Data Access (SDA) in HANA in order to access big tables into SAP enterprise HANA views instead of SLT replication.
- Involved in hybrid concept between BW powered by HANA and HANA Enterprise.
- Hands-on experience working with SAP BW on HANA features, Standard and Custom SAP BW Extractors, Complex transformations using ABAP, advanced DSOs, Composite providers, exposing BW models as HANA views, Mixed scenarios, HANA Analysis process in BW and LSA ++.
- Created Transient Providers and Analytical Index to import HANA Models into BW using T-Code RSDD HM PUBLISH.
- Created Complex WEBI reports for Finance and Accounting, Sales, Merchandizing and Marketing and Operations.
- Extensively worked with performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making the customized Query to the Report generated Query.
Confidential
SAP BW/BOBJ/HANA Consultant
Responsibilities:
- Involved in creating the Custom Cubes and Extracted data from SAP R3 system for various Info Cubes including Billing, Sales, Delivery, FIGL, FIAP and Purchasing.
- Uploaded Master data and Transactional data from SAP R/3 via Data staging to PSA, ODS and Info Cubes.
- Handled tickets regarding Extractions, Performance Issues and also load failures like monitoring of Info packages and analyzing. Worked on incidents related to CS data flow.
- Designed BEx Queries using Structures, Cells, Variables, Static and Dynamic Filters, Restricted and Calculated Key Figure in Query Designer.
- Created OLAP Universes on SAP data (Info cubes / BEx queries) and Relational Universes on Non-SAP data using the Information Design Tool.
- Design and created Universes for Sales, Billing, FI-AR, FI-AP reports using Business Object as front end and SAP BW as source.
- Tuned and Enhanced Universes with SQL Queries for the Report Performance.
- Resolved loops and Traps, created complex Reports, Cross Tab and Master Detail reports by using.
- Created complex WEBI reports with multiple queries, Custom Sql, using Complex functions, merging dimensions at report level, Drill down, Drill up, Drill across and Complex filters etc.
- Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
- Extensively usedCalculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts inCreating Reports, Formatted old reports, Generated charts and Bars etc; as per Business requirements usingXcelsius 2008.
- Provides daily support and resolves complex or highly complex technical issues after Go-live period related to WEBI and Dash Board reports. Works with SAP Principle Developer to define system Scope, Objectives and Solutions based on user needs and Documents detailed Design of Components/Aspects of the software
- Developed Attribute views, Analytic views and Calculation views for Sales and Finance tables replicated from ECC to HANA via SLT.
- Experience of working with BW models in HANA eclipse environment such as Composite providers, Advanced DSOs using BW objects exposed as HANA views.
- Utilized LCM (Life Cycle Management) tool for promoting/migrating WEBI reports and Universes from development to production environment.
Confidential
SAP BW Consultant
Responsibilities:
- Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Blueprint, Development, Testing, Go-live and Post Go-live support.
- Understood the business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business requirements.
- Enhanced Business Content to meet the requirements and created custom Info Source/Data Source, ODS, and Info Cubes.
- Involved in security and technical upgrade to BI 7.0 during the implementation of BO 4.0 in Co - Ordination with Basis team.
- Involved in modules majorly Accounts payable (AP), Accounts Receivable (AR), Sales and Distribution (SD) in order to enter billings in R/3 tables and pulling to BW for reports to end users and sales team by customizing them as per the client requirement.
- Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution modules Sales Order 2LIS 11 VAHDR / VAITM, Shipping/Delivery 2LIS 12 VCHDR/VCITM and Billing 2LIS 13 VDHDR/VDITM.
- Involved in performance enhancement features such as Cube Indexing, maintain Aggregates, Rollups and cube Compression & Partition.
- Expertise in BI related ABAP programming for writing the User exits using CMOD and in writing the Start routine, End routine, Expert routine and Info object routines.
- Creation, Transportation, Scheduling and Monitoring of Process Chains and worked on performance tuning techniques like creating process chains to delete PSA and Change log table on regular intervals.
- Handled Various Post Production Support Issues related toShort Dumps, Data Loading, Monitoring, Database Space.
- Expertise in front-end Business Warehouse components BEx Analyzer, Query Designer for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
- Implemented Virtual Key Figures and characteristics, Customer Exit Variables, Formula Builder and Bex broadcaster.