We provide IT Staff Augmentation Services!

Bi/hana Consultant Resume Profile

Jacksonville, FL

Experience summary

  • Having Around 10 Years of professional IT experience, with over 9 years dedicated to SAP BI/BO which includes Around 6 Years of US Exp.
  • Three full cycle implementation of SAP BW 3.0b, 3.1c, 3.5, BI 7.0 ,ECC 6.0,SEM-BPS,SAP-IP ,Upgrade from 3.5 To BI 7.0
  • Strong skills in SAP BW 7.3, BW 7.4 ,BW Powered by HANA, HANA, SAP BO WEBI, Crystal, and good knowledge in BO-DS.
  • ABAP/4 Programming.
  • Expertise in application specific LOGISTICS cockpit, LIS, CO-PA Cost center accounting analysis, product cost controlling analysis, and sound knowledge on cost center planning FI-SL Special Purpose ledger , generic data extraction from SAP R/3 SD Order to Cash process, deliveries, MM, FI, PP Application components . And Sound knowledge on FI/CO module.
  • Involved in the preparation of business blueprint. Analyzing the business process ,Interacting with end user, key persons identifying their reporting needs
  • Involved in Functional spec designed, Strong experience in converting Functional specs to Technical specs and involved in preparation of business blueprint documentation.
  • Having sound knowledge on Different ETL Tools I.e BO DI /BO DS , reporting tools, i.e Cognos , Xcelcius dash board .
  • Having a experience in end-user training in reporting, preparation of training materials and in-house training on SAP BW to SAP ABAP Programmers. Interacted with end-users extensively with end-user in solving trouble tickets
  • Well versed in data staging PSA and ODS to InfoCubes , data monitoring RSMO , data scheduling.
  • Load monitoring for master data, transactional data, troubleshooting high, medium, low severity data load issues and aggregates filling, data availability for reporting.
  • Extensively built queries on InfoCubes, ODS objects, multiproviders, using BEx analyzer.
  • Worked on Web reporting, Information Broadcasting.
  • Strong work experience with Business explorer, BEx Query Designer, Web Application Designer WAD .
  • Well-rounded in Crystal reports, Crystal Enterprise. Experienced in designing and integrating key BW reports to the web environment.
  • Expertise in data design models, star schema and extended star schema.
  • Strong knowledge and experience of BW authorization profile setup to meet business.
  • Worked extensively on SAP R/3 using ABAP/4 programming language.

Skills Profile:

ERP : SAP R/3 4.6c, 4.7 EE , ECC 6.0, BW- CRM, APO, SRM,

BW-EP, Dash Boards

Data Warehousing : SAP BW 3.0b, 3.1c 3.5, BI 7.0, BW 7.3, BW 7.4 , BW Powered by HANA,

SAP HANA 1.0 SP4 to SP7

DSS/OLAP TOOLS : Business Objects 4.0 SP5, XI R3, XI R2, Crystal Reports.

Reporting : Bex Reporting, Web Reporting, Report designer BI 7.O , Information Broad casting, Visual composer, Cognos 8i

Planning : SEM BPS,BI-IP,SAP BPC

Utilities : Rational Clear Case, Test Director, Toad 2.

Work Summary

Confidential

BI/HANA Consultant

  • Designed and implemented SAP HANA project on Supply and Demand business area. Developed SAP HANA models using Attribute View, Analytic View and Calculation View. Worked on extraction using Replication framework from EDW, SAP Data Services 4.0 and SAP landscape transformation SLT .
  • Designed Data Quality management tool with SDA Smart Data Access and SAP HANA
  • Performance optimization Partition, Query Pruning.
  • Experienced in CTS mechanism for transport movement
  • Expertise in SAP Business Objects Analysis Office 1.4 Excel and OLAP edition MDX applications.
  • Worked on SAML authentication between Business Objects 4.0 and SAP HANA 1.0 SP7
  • Involved in data extraction using Smart Data Access SDA , Direct Extractor Connection DXC through business content extractors.
  • Real time replication using SAP LT Replication Server SLT and batch load based Data Extraction using SAP Business Objects Data Services.
  • Hands of experience in SAP HANA data modeling, creating Attribute View, Analytic View and Calculation View and SAP HANA programming including SQL, SQL Script and CE functions.

Confidential

SAP Senior BI BOBJ Consultant

  • Fine tuning of daily transaction loads make use of parallel load load balancing.
  • Involved in PM Reports PM Work order process /Cost/Measurement phase 1 20 reports back end Staging/Integration/Reporting layered architecture , front end design Bex and WEBI reports , fixing UAT issues, Preparing and Executing cutover activities.
  • Post completion of critical data loads, Automation of Email communication to Business users.
  • Performance tuning has been done to GL BPC data load and data load time brought down from 30 minutes to 14 minutes.
  • Involved in the testing of BW HA implementation, post live activities.
  • Data load monitoring and fixing data load failures.
  • Designed back end, front end for CAPEX Actual and commitments drill through reports from BPC to BW.
  • Involved in the CAPEX APPS backup automation.
  • Designed GL BPC data flow in BW HANA POC Box BW 7.3 Powered by HANA .
  • Involved in FI AR Aging enhancement, FI GL Quantity enhancement.
  • Involved in BW 7.3 Upgrade.
  • Involved in FI GL line item implementation.
  • Involve in the Analysis of Integrating Tronox ECC and South Africa Exaaro system ECC data
  • Automation of PM data loads by using Process chains.
  • Created PM Dashboard back log, overdue queries and part Of PM Dash board team.
  • Resolving Incidents, reporting data quality issues.
  • Installed BW load, reporting Statistics cubes.
  • Involved in BOE service pack post upgrade testing and involved in BOE/ Bex reports performance tuning.
  • Involved in FTS production, consumption report BW Backend and BOE report design.
  • Acted as a WEBI report developer for Plant Maintenance WEBI Reports. Used OLAP universe as well as BICS connections to create the reports.
  • Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts.
  • Worked on Performance tuning of the BI-BO reports.
  • Involved in the Sales Orders/Deliveries / Billing , Purchasing backend and front end design.
  • Worked on Performance tuning of the BI-BO reports.
  • Worked on Performance tuning of the BI-BO reports.
  • Created Information Spaces using Information Design Tool against SAP BI/BW Cubes.
  • Used drill analysis in Business Objects which will allow the user to view data at a more detail level, than current level.

Confidential

  • Designed Manual input queries, aggregation levels, Actual/Budget/LE/3YP Reports.
  • Designed innovation dataset ,innovation rate overview ,innovation validation reports
  • Redesigned the planning architectures as per the periodicity changes.
  • Built Transactional cubes in BW for Planning and Basic cubes for actual data. Enhancements for extraction of data, Creating some custom info Objects, calculated key figures, custom transfer and update rules. Built Query / Structure with Bex Analyzer with Calculated key figures using various filters restrictions for SEM use.
  • Development of Planning functions, Parameter Groups: formula, Copy, Repost, Revaluate, Currency Translation, Distribution, Allocation etc . Used the Fox converter to build formulae.
  • Development of Planning Sequences and Macros for Excel Layouts, variables in planning functions
  • Development of Planning areas, Multi-planning areas for Actual and various planning versions, Planning Levels, Planning Packages, Planning Folders.

BI/BO Reports developer

Confidential

Responsibilities:

  • Created various Complex reports for billing cycle application.
  • Created various 3D pie charts, Pie charts, Bar Charts, Line Charts.
  • Used drill analysis in Business Objects which will allow the user to view data at a more detail level, than current level.
  • Generated drill down reports using Business Objects at zone level, product level, borrower level.
  • Created and use the variables on existing objects to customize the Business Objects reports.
  • Extensively worked with alerts, filters and conditions in Business Objects.
  • Created Master Detail, Cross Tab reports to view the data in analyzed way.
  • Created templates to generate different styles of reports, which are not, belong to Business Objects standard documents.
  • Created calculated data items, filters and prompts in universes to maintain the consistency in the reports created by other developers.

Confidential

Role : Application Technical Support Specialist

Project Role Description

  • This project is about R/3 System upgrade from 4.7 to ECC 6.0.
  • My responsibilities include
  • Taking care of BW System changes and end to end testing of BW System.
  • Running the test scripts as per the quality center and updating the results in Mercury QC
  • Resolving the tickets during pre upgrade and post upgrade testing.
  • Experience with new features of Net Weaver 2004s BI DTP, Transformations, Open Hub, new DSO features, new front-end tools, integration to portal
  • Extensively worked on report designer and BI 7.0 reporting.
  • Involved in various upgrade activities like alpha conversion check, consistency check, and applied oss notes.

Confidential

  • Extensively Worked on SAP NW2004s BI Transformations Data Transfer Process
  • Activated Standard Business Content Info providers Info cubes and DSO's , Created Transformations and DTP's.
  • Extractions - Extracted data from LO Logistics Cockpit, CO-PA and Generic Data Sources from Views and Function Modules, DB connect and Flat Files.
  • Experience in production support, data loads, validation and trouble shooting of transaction data and master data, change management, transport management, roles and security, system checks, performance tuning and process chains.
  • Created reports with Charts bar chart, Pie chart etc , Cross-tabs and Sub reports.
  • Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.
  • Worked in BEx Analyzer in building queries and saving workbooks and created custom queries using Conditions, Exceptions, Variables and Structure and created aggregates for frequently used queries, RRI Jump queries and trained End-users.
  • Good functional knowledge of Sales Distribution Sales Orders, Deliveries, Billing , MM Purchasing Inventory Management , FI and general business process of SAP R/3.

Confidential

BW Senior reporting Specialist

  • Generated the following BEx Reports.
  • IAM Annual Operating Plan AOP
  • IAM Forecast
  • IAM Capital Expenditures CAPEX
  • IAM Expense by Area
  • IAM Profit and Loss P L
  • IAM Revenue
  • IAM Productivity by Station
  • IAM Productivity Indicator
  • IAM Contracts Expiring this Month.

Confidential

Senior BI BW Techno Functional Consultant/ Cognos

  • Initialization of opening stock data source 2LIS 03 BX , Initialization of statistical set up of movements 2LIS 03 BF , and revaluations 2LIS 03 UM and loading into BW into STOCK MOVEMENTS CUBE 0IC C03
  • Extract structures, data sources. Transporting data sources and replicating at BW side
  • Industry sector, transaction and process key maintenance for inventory. Maintaining and activating
  • Setting update mode and loading deltas into cube
  • Compressing requests and setting suitable marker updates.
  • Testing the validity of the data at r/3 and BW data by executing the queries and verifying with R/3.
  • Involved in the Different phases of business blueprint. Analyzing the business process, Interacting with end user, key persons identifying their reporting needs
  • Assisting in Functional spec designed Strong experience in converting Functional specs to Technical specs and involved in preparation of business blueprint documentation.
  • Having a experience in end-user training in reporting, preparation of training materials.

PM: Plant maintenance reporting

  • Involved in gathering PM performance indicator requirements and converting them it in to functional specifications.
  • Station backlog
  • Age of backlog
  • PM compliance
  • Work order life cycle status
  • Pro vs. Reactive.
  • Installed the content cube and customized the extractions PM ORDER ATTR, 0PM CO3, 2LIS 17 ORDER and loaded the data into BW.
  • Designed queries and workbooks according to the layout of respective plants pertaining to performance indicator for each and every plant.
  • Created RKF, CKF, characteristic variable, text variable, formula variable with different processing types like replacement path and user exits.
  • Designed graphs, charts for each output of the query.
  • Transported the workbooks across the landscape and involved in end user training.

Confidential

Senior Reporting Specialist Business Intelligence.

  • Created GL Accounts, Sales, and Human Resource reports on SAP-R/3 and SAP-BW cubes, and BW Queries.
  • Involved in BW Standard Business Content activation for FI/CO, and HCM for different business report requirements.
  • Created Business views, and Filters for different Controlling areas and Chart of Accounts for General Ledger GL Accounts , Account Receivable AR , and Account Payable AR for different report requirements from SAP-R/3 by utilizing the SAP DDIC structures.
  • Involved in debugging data foundation, Business Element and Business Views and maintaining in production reports for changed user requirements, for existing reports
  • Created different types of reports, like Master/Detail, Cross Tab and Chart for analysis .
  • Involved in Performance tuning of report execution in business objects.
  • Developed various crystal reports like standard reports, summary reports, and cross-tab reports, charts and graphs which were used by the various departments in the Company.
  • Excellent working experience in Business Object Data Integrator 11 with different kinds of objects like Batch, real time jobs, different kinds query transforms, data stores, query tuning, and data extractions and loading from Mainframes, DB2, Oracle, MS-SQL, and Flat Files.
  • Worked on Crystal report performance tuning for huge volumes of data problems in production, with working closely with DBA's.
  • Worked on extractions from various diverse systems using Business Object Data Integrator for different kind's reports and data analysis for the business and user requirement.
  • Worked on dashboards manager in claims and billing areas.
  • Involved in testing of objects in warehouse and online databases for any issues which may be from ETL or reports.

BW HR HCM Reporting:

  • Gathering the requirements, preparing technical, functional documents of workforce metrics and performance appraisals.
  • Developed ETL process for personal administration cube 0PA C01, Performance appraisal Info set 0PAH IS02 to generate work force metrics reports such as separation rate, hire status of the organization based on gender, minority, and leadership.
  • Designed and customized info set 0PAH IS02 by using left outer join of ODS and employee master data..
  • Designed and customized Performance appraisal rating Reports , Average rating reports based on Business unit and Ranking.
  • Designed the Personal administration, Aprraisal report workbook, tested the reports, transported across the landscape, Upgraded from BW 3.5 to BI 7.0.
  • Created restricted, calculated KF, structures, characteristic, text, formula variables, user exits, exceptions, conditions, workbooks and graphs.
  • Handled SSN,Payroll ,rating authorization issues .
  • Extensive experience in handling Enduser,power user issues and trained on BEX ,HR reports.
  • Strong integration knowledge of BW-HR .
  • Involved in training power users and end users and resolves many user issues. Experience with new features of NetWeaver 2004s BI DTP, Transformations, Open Hub, new DSO features, new front-end tools, integration to portal
  • Experience with new features of NetWeaver 2004s BI DTP, Transformations, Open Hub, new DSO features, new front-end tools, integration to portal
  • Transported the workbooks across the landscape and involved in end user training.

Hire Now