SUMMARY

• SAP HANA/BIBW/BODS/BOBJ Consultant with 10 years of experience.Certified in SAP BW and BOBJ
• Professional experience in analysis, design, development and implementation of business applications that includes SAP BW/BI/HANA/BOBJ and strong exposure towards other ERP Systems
• Involved in Multiple Projects which includes Full life cycle implementations, upgrade, Enhancements and Post Production Support in the areas of HR, Logistics, Inventory, PM, PP, SAP CRM HCM/HR and SAP SRM Modules.
• Worked in Manufacturing, Retail, and Entertainment, Pharma, Oil & Gas Equipment, Services, Public sector and Utilities Clients.
• Having around 4 years’ of experience on HANA and SLT and Business Objects Data Services
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View
• Hands on experience in HANA modeling. Created multiple schemas and table definitions.
• Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Experience on Business Objects tools like webi, dashboards.
• Experience in working multiple projects and managing them.
• Hands on experience in developing SAP Business Objects solutions over SAP BI/BW using WEBI, Universe, Lumira, analysis office and Design studio
• Experience with Onshore - offshore business model with managing On shore delivery as a Team Lead.SAP BI Expertise:
• Proficient in data modeling using BW extended star schema model and evaluating Requirements and implementing BI solution for Clients
• Extensive Experience Implementation, Developments as well as Production Support projects
• Performed extensive Logistic extractions, Finance and generic extractions
• Worked on queries using Bex Analyzer and Bex browser.
• Extensively used Multiproviders, structures, variables, exceptions, and conditions, restricted and calculated Key Figures in reporting. Experience in Performance Tuning.
• Proficient in handling support projects. Analyzed and corrected production problems as they occur in the SAP BW system.
• Hands on Experience in implementing BW 7.3 & BW powered by Hana 7.4 Graphical Data Modeling objects such as Hybrid InfoProvider, Composite InfoProvider, Semantic providers
• Report development on manufacturing modules like SD MM, PM, QM and integration experience with FICO.
• Experience in the OLTP extraction of data of SAP LO-Cockpit, MM, generic extractions, Enhancements and extraction from flat files, non-SAP systems and DB connect.
• Worked in new features of SAP BI security like Analysis authorization.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Extensively worked on SAP ECC as a source system for generating reports using BEx Query DesignerHANA Skills:
• Worked on HANA Studio objects Creating Information Models, Attribute View, Analytical Views, and Calculated Views.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views and Good understanding of LSA++ Architecture
• Worked on NLS, HAP process, Sybase IQ database, Enable DP server for SDI and Enable Script server for SDQ
• Worked on SDQ cleanse and geocode directory, Install DU HANA IM DP (Data provisioning) and Install and Register Data Provisioning Agent
• Remote source and Data replication and monitoringBW/BI - IP Skills:
• Experienced in BI-IP (Integrated Planning) tool - development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables
• Ability to build process chains for any IP Planning functions / Sequences / Data loads.
• Familiar with BI IP Best practices and standards
• Assisted and worked on Web templates, aggregation levels and planning functions for the implementation of Integrated Planning
• Modeling Planning Applications using SAP BI Integrated Planning (IP). Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application DesignerBOBJ/BODS Skills:
• Experience on SAP Business Objects 4.0, Web Intelligence, OLAP Analysis and Universe Design
• Integrated BO with SAP ECC and SAP BI 7.0 to build Universes.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Experience on Data integrator and Data Services.
• Experience on Lumira, Tableau dashboards and Design Studio.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. SAP HANA/BI/ IP & BOBJ Consultant

Responsibilities:

• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Delivered and manage the design and implementation and blueprint for the logical and physical design and implantation in a fully integrated enterprise environment
• Worked closely with IT and business partners thought leaders to ensure delivery of the client.
• Involved and exposure on working with Business and IT organizations
• Implementing a custom end-to-end solution using SAP HANA and Design and Development of HANA data models
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies and Created and apply analytic privileges with HANA studio.
• Loading data into table definitions, suspending data loads, resuming data loads using SLT. Creating information objects(packages, attribute views, analytic views, calculation views Graphical )
• Experinced in working on real time info cube
• Experience in build process chains for IP planning functions /sequences/data loads
• Financial planning through planning sequences and input ready queries.
• Data extraction from ECC systems and planning it in BI IP systems
• Proactive in finding issues and seeking and implementing solutions.
• Hands on Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges
• Involved working with content models, attributes and measures, hierarchies and Monitoring and troubleshooting data loads.
• Creating Custom Views on top of ECC on HANA and BW on HANA as per the requirements
• Loading data into table definitions, suspending data loads, resuming data loads using SLT. Creating information objects(packages, attribute views, analytic views, calculation views Graphical )
• Involved working with content models, attributes and measures, hierarchies and Monitoring and troubleshooting data loads.
• ETL design, analysis and development, writing technical specifications.
• Created Repositories, Users & assigned the security in the Multi-Team Environment
• Worked on the IDOC’S, Batch/ real time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects
• Worked on the Data Quality, Address cleanse transformations for cleansing the data.
• Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer.
• Designed and implemented SAP HANA info models using Attribute Views, Analytic Views, Calculation Views Restricted and Calculated Measures, Input Parameters, Variables, Stored Procedures, CE Functions and SQL script.
• Loading data into table definitions, suspending data loads, resuming data loads using SLT.
• Involved working with content models, attributes, measures, hierarchies, Currency conversions and schema Mapping. Experience in Text Search with different options via SQL and created Decision Tables in SAP HANA Studio
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Worked on Dimension Filters, Cascading Filters, Panel and charts to develop Dashboards using design studio
• Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition and Provided end user training
• Worked with Tableau on system statistics and performance reports

Environment: HANA 1.0, ECC 6.0, SAP BI 7.3/BW powered by HANA 7.4 and BO 4.1 FI, Logistics, BOBJ tableau and Lumira

Confidential, Chicago, IL

Senior SAP HANA/BW/BOBJ Consultant

Responsibilities:

• Involved in SAP BW 7.4 implementation for FI-GL, AP, AR, AA modules.
• Involved in preparing Technical Design specifications for the FI report requirements.
• Involved in development of BW Objects InfoObjects, DSO, InfoCube, Multiprovider, Transformation, DTP, OHD, APD, Datasource, and Infopackages.
• Involved in HANA Modeling Activities for specific report requirement to achieve the real time reporting for high volume data.
• Involved in HANA activities to provide the solution for BW-HANA mixed scenarios.
• Involved in development of HANA objects Attribute Views, Analytic Views, Calculation Views to implement the real time data reporting directly from ECC through HANA Side car approach.
• Involved in importing of BW Models into HANA for specific report requirements.
• Involved in SAP HANA Data provisioning activities to load the data from ECC & Non-SAP source system Datastage through BODS ETL Based replication methodology.
• Performed data transformation and load into SAP HANA database from ECC, SQL Server sources using SAP Business Objects Data Services (BODS) and SAP Landscape Transformation (SLT). Involved in Batch job scheduling in BODS.
• Developed BODS jobs, data flows, workflows and data store creation and scripts with the platform transformations.
• Implemented appropriate BO reporting tools for report requirements using Design Studio, and SAP Lumira tool
• Developed dashboards in design studio 1.5 that is reporting on SAP HANA platform using data sources Attribute views.
• Worked on connectivity with SAP HANA Systems using an HTTP Connection
• Developed Dashboards using Paradigms: WYSIWYG Layout, Drag & Drop on SD and FI Area.
• Created Pivot Table (Crosstab), Charts, Filters, Inputs, and Mapped the Data Source in respective components by writing the simple scripts in script editor.
• Involved in TUT, SIT, UAT activities to fulfill the gaps in the system.
• Experience in Environment synchronization to maintain consistency across the landscape.
• Experience in Defect Management in SIT & Hypercare support activities.

Environment: HANA 1.0 SP9, SLT, BODS 4.1, ECC, SAP BI 7.4, BEx Analyzer, BEx and BOBJ 4.1, Design studio

Confidential

Tech SAP BI/BW Consultant Lead

Responsibilities:

• Lead the Technical team and delivered all deliverables well before the time
• Transportation of BW data flow from Dev to QA and then to Prod.
• Worked on HR Reports such as Employee Master, Employee Movement and Leave liability using Business Objects Webi.
• Worked on data extraction from DB System for Inventory and sales.
• 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 (SD) module (Sales Order "LIS 11 VAHDR/VAITM", Shipping/Delivery"2LIS 12 VCHDR/VCITM", and Billing "2LIS 13 VDHDR/VDITM").
• Extracted data from MM inventory (material management- 2LIS 03 BF data sources), and PP (Production Planning and controlling) modules and compared with POS-DM data.
• Worked on Inventory Data Sources like 2LIS 03 BX and 2LIS 03 BF.
• Developed Reports like Inventory Aging, Delivery Status report and Open/Back Order Report.
• Worked on Generic extractors to pull the Sales, Contracts, Delivery and MM Data from legacy systems using DB and UD connection
• Extensively involved in data reconciliation between various systems SAP ECC, Legacy Systems

Environment: SAP BI 7.1,NetWeaver 2004s, BEx Web Analyzer, Web Application Designer, BI Accelerator, SAP ERP 6.0 FI/CO,SD, MS Office 2007, MS SQL Server, BO XI

Confidential

Senior SAP BI/BW Consultant

Responsibilities:

• Worked on Fit/ Gap analysis for an existing Sales Reporting solution on the BI system including a system analysis part
• Prepared Functional and Technical design documents
• Extensively worked with Planning Workbench, Planning Layouts, Planning Sequences in BI IP
• Worked on FI-AR, AP, GL, AA extractors and reports
• Developed sales reports on YTD, MTD, Overall sales analysis, sales by product, Top 5 products on sale etc.
• Experience in the OLTP extraction of data of SAP LO-Cockpit, MM, generic extractions,
• Enhancements and extraction from flat files, non-SAP systems and DB connect
• Created Web templates using WAD
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multiproviders.
• Used BW Accelerator (BWA) to Index BW Data for faster query performance.
• Created formatted financial reports using Crystal Reports and Adhoc Reports for sales, finance, purchasing using Business Objects Webi and Created dashboards for financial, sales, purchasing KPI’s.

Environment: SAP BI 7.0/FI/SD. BEx Analyzer, and SAP R/3.

Confidential

SAP BW Consultant

Responsibilities:

• Developed Capital Spending Report using Generic Extraction which is used to track the costs incurred on each Internal Project for the Confidential .
• Worked Extensively on LO extractions and Generic Extractions and CRM - Sales, Services reports
• Extensively worked on in performance tuning by using Indexes, DB statistics, compression of Info Cube and maintaining and rolling up the Aggregates.
• Worked Extensively on Reporting using Bex Analyzer such as free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Structures, Exceptions, Filters, Conditions, Report To Report Interface
• Worked on Enhancing the Customer Exits for newly added Query variables and newly added R/3 fields.
• Worked on BI Analysis Authorization.
• Proficient in using standard security administration tools such as Profile Generator for Authorization Profiles/Roles Administration and User Administration.
• Process all 2nd level IT support tickets, which related to BW data loading, reporting WAD, etc.
• Update the Break-Fix business process document with all process changes.
• Review the Break-Fix business process document periodically.
• Provide support during Maintenance delivery, Release delivery and other special activities.
• Create a Query Fast Track Transport for Power User in IWX (BI-Sandbox).
• TCS in the role of Change Manager to create/release bug fix transport requests in IWE.
• Update the Authorizations business process document with all process changes
• Review the Authorizations business process document periodically and Analyze missing authorization
• Assigning appropriate profile to the concerned users required, get the approval and forward to User
• Admin team and get it assigned accordingly and Implementation of OSS Notes.
• Worked with functional consultant for mapping the source data (R/3) to target Data Sources in BI. Configured Custom cubes, Aggregates, queries.
• Monitored the development of data model to satisfy the functional requirement by implementing queries and cubes using business content.
• Worked on transformations to translate the business processes into end reporting objects.
• Worked extensively on extractors 2lis 11 vahdr (Sales) delivery, billing and shipping,
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and distribution area.
• Designing the data model to extract the data from SAP R/3 and resolving the data loading errors based on user requirements, creating the customized queries.
• Involved in Data Modeling, Extraction loading and reports creation in BEx Query designer.
• Involved in performing production support activities
• Actively involved in Rectification of Load failure Errors like Master Data Loads, Transactional Loads.
• Manually loading data to data targets on daily basis, Weekly basis and monthly basis.
• Transfer Data from R/3 to BW using Generic Extractors like database tables and function modules.
• Created a report according to the requirement from the client with some of the restricted key figures & with other objects.
• Monitoring of process chains and refreshments for every month.
• Monitoring of Portal servers and solved App support Mails.