Certified BW Consultant

Anil Varre

ade406@r.postjobfree.com PH: 864-***-****

Professional profile

Expert level SAP BW/4 HANA/BOBJ/BODS knowledge with 16 years’ experience.

** *****’ experience in the Information Technology sector.

Developed BPC Standard objects on BW/4HANA..

Project Manager and BI Architect leading End-to-End implementations in SAP Activate, Agile and ASAP methodology.

Support Upgrades of BW7.0 to 7.3 and 7.3 to 7.4 in step-by-step approach of System preparation, SPDD, SPAU, and post upgrade activities.

Expert level data modeling and performance tuning of SPOs, and COPs on BW on HANA.

Highly effective in converting Business Requirements to Functional and Technical Specifications.

Experience in Full Life cycle implementations in modules of SD, MM, PM, CS, PUR, FSCM, Is-Utilities, FI-CA, Banking Services, Bank Analyzer.

Extensive experience and knowledge in ETL (Extraction, Transformation, Loading) from IS-Utilities, LO Cockpit, FI-AP, FI-AR, custom extractors and as well using BODS tools and SDA.

Expert level experience developing executive Dashboards and Webi reports using BOBJ, and Microsoft Excel for Analysis.

Experience in Unit testing, Functional and Integration testing of end-to-end data flow using Mercury Quality Center and HPQC.

Extensively used Service Now tool to log incidents, track defects, generate reports, create Change Requests.

ABAP and AMDP programming experience in Extractor enhancements in R/3, Start, Transfer, End and Expert Routines, conversion exits in BI.

Expert analytical skills coupled with interpersonal, communication, presentation and self-organizing skills with strong problem-solving abilities and effectiveness in working independently and as a committed team player.

Skills:

Industries:

Oil & Gas, Chemical, IS-Utilities, Banking, IS-Aerospace & Defense, Transportation, IS-Retail

SAP Systems:

ECC6.0, BW/BI 7.4, Solution Manager, Bank Analyzer, Banking Services, CRM, BODS. S/4HANA, BW4HANA, BODS, SolMan

BI/BOBJ:

BOBJ 4.2, Microsoft Excel for Analysis and Xcelsius

Programming Languages:

ABAP, SQL, AMDP, SQL

Awards:

Ingenuity “Silver” Award for best performance

Service Excellence Award for best performance

Spirit Award for best positive attitude

Fitness award for best individual score in two consecutive years

Education

Master’s in information technology, Wollongong University, Australia.

Advance Diploma in Computer Applications, IIS Web InfoTech, India.

Master’s in business administration, Osmania University, India.

Bachelor’s in computer science, Osmania University, India.

PROFESSIONAL WORK EXPERIENCE

PKGlobal, Seattle, WA Oct ’19 – Present

Client: Valvoline Instant Oil Change

Sr. SAP BW4HANA/BOBJ Architect

BW4HANA greenfield implementation from Oracle POS system

Designed End-End Solutions for Store Performance, Sales Performance reports using Analysis for Office and BOBJ-Webi

Developed BPC reports on Plan data using BW/4HANA objects

Used SDA API for extracting Data from POS thru custom Delta mechanism

Created Functions and called them in Transformations to handle invalid Chars

Used LSA++ approach and persisted data as low as possible and used Hybrid approach in data modeling

Created Calculation views for reporting and used them in Composite Providers

ABAP routines and AMDP scripts were written in transformations where applicable

Created BOBJ reports and Analysis reports

Lead offshore team on development activities, testing and documentation.

Environment: Oracle, BW4HANA, BOBJ, Analysis for Office

Nutrien, Love Land, CO Apr ’19 – Sep ‘19

Sr. SAP BW4HANA/BOBJ Architect

BW4HANA greenfield implementation from People Soft legacy system

Designed End-End Solutions for FI reports like Daily Accounting Summary, Actual Margin, Slow Moving Inventory reports

Worked on BPC objects on Plan data.

Used ACDOCA, traditional FI extractors and MM and PO extractors

ABAP routines and AMDP scripts were written in transformations where applicable

Created CDS Views for BW DataSources

Created Calculation Views and used in Hybrid Solutions in BW

Created aDSOs, Composite Providers and BW Queries

Created BOBJ reports and Analysis reports

Lead offshore team on development activities, testing and documentation.

Environment: S/4HANA, BW4HANA, BOBJ, Office Analysis, MM, SD, FI-CO, NLS

ATMOS Energy, Dallas, TX Jan ’18 – Apr’ 19

Sr. SAP BW4HANA/BOBJ Architect

Re-architecting BW7.3 solutions in BW4HANA in greenfield implementation

Re-gathering requirements as business is matured in last 5 years

Documenting Architecture diagrams and Functional documents after GAP Analysis

ABAP routines and AMDP scripts were written in transformations where applicable

Created aDSOs, Composite Providers and BW Queries

Created BOBJ reports and Analysis reports

Worked on NLS strategies and DTO (Dynamic Tiering Optimization) using SAP IQ.

Lead offshore team on development activities, testing and documentation.

Environment: ECC, BW4HANA, BOBJ, Office Analysis, IS-U, FI-CA, NLS

Costco, Issaquah, WA Aug ’17 – Dec ‘17

Sr. SAP BW4HANA/BOBJ Developer

Involved in gathering requirements and gap analysis

Worked on Technical designs and testing strategy

Developed BW Objects using Eclipse studio

Environment: ECC HANA, BW4HANA, BOBJ, IS-R, SD, MM, and IM Modules

ScanSource Inc., Greenville, SC Apr ’16 – Aug ‘17

Sr. SAP BW on HANA/BOBJ Architect

Lead activities between the Basis and BW teams to resolve HANA in-memory performance issues.

Re-converted Hana Optimized DSOs to Standard DSOs to fix some of in-memory performance issues.

Resolved Data loads performance issues between various DSOs by rewriting the ABAP logic.

Analyzed Server config settings and recommended all missing Server config parameters on both BW and HANA

Certified reports to comply with BI Certification project.

Created Data Lineage flow from BOBJ to ECC.

Fixed numerous production issues of BI reports.

Involved in day-to-day activities and resolved production tickets.

Environment: SAP ECC6.0, BI7.3 on HANA, Bobj4.2, and SD, MM, and IM Modules.

SaskPower, Regina, SK, Canada Jun ’13 – Jan ‘16

Sr. SAP BI/BW Architect

Gathered business requirements and created business blue print

Architected end-to-end solution based on blue print and documented using Visio

Liaison between the clients and developers to ensure the solution met business needs

Presented the solutions to the team and business units for final approvals

Modeled and lead the Process Chain Optimization project to optimize nightly batch loads

Assist in Support activities, Full Life Cycle Implementations, Enhancements

Implemented projects and enhancements in PM, CS, PUR, IM, IS-U, and FI-CA modules in Agile Methodology.

Supported ‘Support Pack Upgrades’ of BOBJ 4.0 to 4.1 and BW 7.0 to 7.3 and 7.4.

Created reports in Webi and in Microsoft Excel for Analysis.

Involved in end-to-end upgrade process that includes system preparation, SPDD, SPAU, and post upgrade activities.

Worked closely with BOBJ Admin to implement Security profiles and connection issues.

Expert in resolving transport issues, process chain failures, data load errors.

Involved in Migration project from 3.x to 7.x as a quality coordinator, and resolved issues while promoting to Production.

Efficient at ABAP coding to support transformations, extractor enhancements, reports, etc.

Used BODS tool to extract data from Non-SAP systems.

Environment: SAP ECC6.0, BI7.4, Bobj4.1, BODS, Enterprise Portal, and IS-Utilities.

ATB Financial, Edmonton, AB, Canada Aug ’12 – June ‘13

Sr. SAP BI/BW Architect

Gathered requirements, conducted workshops, Architected the solution for highly critical exception reports where data exists in two different source systems

Architect the end-to-end solution to create Internal Accounts balances by G/L report by joining Bank Analyzer and Banking Services data.

Architect the end-to-end solution create an exception report that shows transactional postings posted to suspend G/Ls by joining Bank Analyzer and Banking Services data.

Architect the entire solution to create Loan Statuses KPI Metrics report.

Architect the end-to-end solution to create Finance Static Report, which displays Actuals, Budget, forecast (Bank Analyzer data) for YTD and MTD.

Worked on enhancements of after go-live issues.

Created Webi reports in BOBJ 4.0.

Modified the existing Function Module(s) ABAP code as part of enhancements.

Handled on-call support for daily batch loads.

Worked on Archiving project (Data Volume Management)

Environment: SAP ECC6.0, Bank Analyzer, Banking Services, BI7.0, and BOBJ.

Enmax, Calgary, AB, Canada Jul ’12 – Oct ‘12

Sr. SAP BI/BW Developer

SaskPower, Regina, SK, Canada Jul ’10 – Jul ‘12

SAP BI/BW Developer/Team Lead

Lead the team in Support activities, Projects Full Life Cycle Implementations, Enhancements, Requirement gatherings.

Developed end-to-end Solution Architecture for new projects and enhancements. End-to-end is from SAP ECC to BOBJ Webi and Xcelsius Dashboards.

Implemented and supported CR&B (Customer Relationship & Billing) project in IS-Utilities module.

Implemented and supported SBM (Service Business Metrics) project in PM and CS modules.

Developed and supported FI-CA (Contract Accounts Payable and Receivable) Extractors, InfoCubes, BEx and Webi reports.

Done a thorough testing to make sure Webi reports are reconciled back with GL Accounts in ECC system.

Blueprint HR Modules – Personnel Administration, Time Management, Organizational Management.

Wrote ABAP code in Transformations, extractor enhancements, Reports,etc.

On-call support for all BW nightly batch loads

Experience with CPS (Central Processing system) that controls all ECC and BW batch jobs.

Developed Webi Reports using OLAP universes in BOBJ.

Environment: SAP ECC6.0, BI7.0, Bobj, Xcelsius, Enterprise Portal, and IS-Utilities.

Saudi ARAMCO, Saudi Arabia Jan ’10 – Jul ‘10

SAP BI Team Lead

Modeled, implemented and lead the project end-to-end.

Used SAP ASAP Methodology to deliver each phase of the project.

Created Project Charter and L1/L2/L3 Plans as part of Project Preparation phase.

Conducted Workshops as part of Blueprint phase and collected business requirements for further analysis.

Converted business requirements into Functional and Technical specs.

Created PowerPoint presentation on strategy for Reporting & Presentation approach.

Monitored weekly status updates and project timelines.

Environment: SAP ECC6.0, BI7.0, Adobe Flex, Xcelsius, Enterprise Portal, and IS-Aerospace & Defense

Farm Credit Canada, Regina, SK, Canada Sep ’09 – Jan ‘10

Sr. BI QA Analyst

Environment: SAP ECC6.0, BI7.0, Mercury Quality Center, Oracle9i, and Subversion

IBM Canada Ltd., Calgary, AB, Canada Apr ’05 – Sep ‘09

Managing Consultant – SAP Practice

IBM Canada Ltd.,

Client: Canadian Pacific Railway, Calgary, AB Mar ’09 – Sep ‘09

BI Lead

Worked on Mainframe programming code and analyzed the logic to replicate the same in BI environment as part of Mainframe system decommissioning.

Created estimates for development, testing, and go-live efforts and resource tasks.

Created functional design documentation for Government Regulatory reports by converting Legacy requirements.

Created extractor with ~600 fields and loaded to Write Optimized DSO.

Data extracted out from BI/BW into Flat files (Excel) using Open Hub Destination tool for business to play around with data for fine-tuning of requirements as part of enhancements.

Unit testing and Integration testing for data flow was done.

Created routines in transformations using ABAP OOP programming.

Created highly customized complex Extractor Function Module in Source system (ECC6.0) with help of ABAPer.

Environment: ECC 6.0, BI 7.0, Mainframes.

IBM Canada Ltd.,

Client: Suncor Energy Inc., Calgary, AB Jan’ 09 – Feb’ 09

BI Lead

Involved in requirement gathering and analysis.

Created Gap document and Business Design Documentation.

Created Functional Design Documentation for all identified reports and dashboards.

Created detailed plan to estimate resources and efforts.

Created BI data flow design solution architecture in Visio.

Responsible to communicate technical design documentation and functional design documentation with Business team and obtain sign-off.

Environment: SAP ECC 6.0, BI 7.0.

IBM Canada Ltd.,

Client: Petro-Canada Oil Sands Inc., Calgary, AB Aug’ 08 – Dec’ 08

BI Team Lead

Created Blue print for Reporting and involved in requirements analysis.

Created detailed plan to estimate resources and efforts.

Created BI baseline Configuration PowerPoint deck to configure the new BI system.

Configured the new BI system through Solution Manager.

Install the Business Content objects through Solution Manager for HR Modules – Personnel Administration, Organization Management, Time Management, PM, and FI modules.

Documented module wise detailed configuration plan as part of realization phase.

Environment: SAP ECC 6.0, BI 7.0, and Solution Manager.

IBM Canada Ltd.,

Client: Canadian Pacific Railway, Calgary, AB Oct’ 06 – Jul’ 08

Sr. BI Consultant/Team Lead

Worked on resource planning, project timeline estimates as a team lead and coordinated with offshore team (India) for BI Extractors ABAP work.

Involved in Blue printing, Gap analysis and BI backend configuration, design and modeling.

Involved in full life cycle implementation on FI-AR (Cash flow), Dispute Management, and Collections Management.

ABAP coding performed for BI standard Extractors like Customer Master, 0FI_AR_4 and for some generic extractors in R/3.

Lead thorough Functional and Integration testing in Quality phase and prior to go-live phase.

Worked on postproduction system for all day-2-day issues like data loads, Query data issues, performance issues and issue enhancements.

Worked with Basis in measuring system disk spaces, processes monitoring while data loads and query run time.

Worked on formatted reports using several workbooks.

Broadcasted workbooks directly to Users inbox using Information broadcast tool.

Using Pre Calc-Server broadcasted the queued up pre-calculated workbooks.

Created documentation each for Configuration, Design, Modeling, Loading, and Query development.

Environment: SAP R/3 4.7 and ECC 6.0, BI 7.0 and BW 3.5, EAI Web tool interface, Mainframes, Windows, SQL Server, and Pre Calc-Server.

IBM Canada Ltd.,

Client: Canexus Chemicals, Calgary, AB Jun ’06 – Sep ‘06

Sr. BW Consultant

IBM Canada Ltd.,

Client: Suncor Energy Inc., Calgary, AB Apr’ 05 – May’ 06

Sr. BW consultant

Philips Medical Systems, Boston, MA Aug ’04 – Apr ‘05

BW Consultant

Deloitte Consulting, Austin, TX Feb ‘02 - Aug ‘04

Sr. QA Analyst

Intel Corp., Hillsboro, OR Apr ’00 – Dec ‘01

QA Analyst

Contact this candidate