SUMMARY

Over twelve plus years of IT experience with nine years in SAP HANA/BW/BI/BO with 3 full life cycle implementations.

Active participation in all phases of BW/BOBJ/Tableau projects including requirements gathering, Modeling, Development, Testing, Cutover, Training, and other Support activities.

Primarily focused on SAP BW end-to-end implementation, consistently playing key roles such as team lead, developer and analyst in various projects.

Strong team leading experience in various SAP BW 7x implementations over the past 5 years.

Experience with SAP HANA data modeling using Attribute View, Analytical View and Calculation view.

Worked on SAP HANA implementation project with SAP BW on HANA Landscapes.

Extensive experience working on Global projects with teams spread all around the World.

Experience in designing/developing InfoCubes, DSO Objects, InfoSources, InfoObjects, InfoPackages, Transformations, Aggregates and Monitoring.

Created reports using Business Explorer (BEx), Business Web Analyzer with InfoProviders such as InfoCubes, DSO Objects, MultiProviders, InfoSets etc.

To support the needs of external system, developed several APD’s and Open Hubs destinations

Extensively worked on Process Chains, Daily/Weekly/Monthly background scheduling of Process Chains, Monitoring, in both BW and APO systems

Very good understanding of APO BW concepts that are relevant to successful implementation of APO DP, SNP and GATP

Extensively worked with Business Objects Designer, WebI, and WebI Rich-Client (4.1).

Helped end users with query development and assisted other Consultants with front end support.

Excellent communication skills and ability to work effectively in fast paced environments.

SKILLS

ERP : BI 7.0/7.1/7.4 Netwever 2004 S, BW 3.5, ECC 6.0/ 5.0, SAP HANA 1.0 SP12

SAP Data Services

Reporting Tools : Business Explorer (BEx), Business Objects (4.2 SP 2), Information Design, SAP Design Studio 1.3

Languages : ABAP, C, C++

Databases : Oracle,SAP HANA, MS-Access, SQL Server and Teradata

Operating Systems : Windows 2000/NT/XP, MS-DOS, UNIX, Oracle 11x, My-SQL,

SQL server 2008, SQL server 2012

PROFESSIONAL EXPERIENCE

Client: Bunge Limited, St. Louis, MO June 2014 – Present

Role: SR. SAP BW consultant

Bunge Limited (formerly Bunge International, and prior to that Bunge y Born) is a global agribusiness and food company, incorporated in Bermuda, and headquartered in White Plains, United States. As well as being an international soybean exporter, Bunge is also involved in food processing, grain trading, and fertilizer. The company has over 35,000 employees at 400 facilities in 40 countries.

Responsible for gathering requirements for Global KPI/Treasury/FSCM/Spend/PCA/SRM projects.

Responsible for Modelling, Development and Production.

Responsible for Application Support and minor enhancements/code fixes.

Responsible for working/coordinating with different regional BW teams (NA, Brazil, Argentina, EMEA, Asia) to move necessary data to Global BW box.

Created Generic Extractors, Generic Data Sources and enhancements.

Built PTP Dashboards using the BOBJ 4.2 SP2 Reporting Tools connected to Bex queries.

Created Open Hub Destinations and APD’s using BEx queries as source.

Support Tableau team for dashboard reporting.

Managing Global off-shore/on-site resources.

Identifying performance issues and providing solutions by business areas.

Preparing estimates and proposals for upcoming projects.

Client: Copart, Dallas, TX Oct 2013 – June 2014

Role: Sr.SAP HANA Reporting Analyst

The Company’s business model is to act as an intermediary between the Sellers (Auto Insurance Companies or Fleet Services or Dealer Services) to help them sell their damaged / totaled vehicles to Buyers (Dismantlers or Rebuilders) through the On-line / Mobile Copart Auction Systems (CAS). As part of HANA implementation, I was involved in including requirements gathering, data modeling, development, testing and documentation etc.

Responsible for gathering requirements with regards to Seller / Operational / Company Metrics Reporting and created the Functional & Technical Specification documents.

Extensively worked on HANA modeling and HANA Application Development (Using Native XS & Database client interfaces)

Involved in creating the External / Internal Users Workflow for the proposed C2 Seller / Aurora Seller driven Reports.

Participated in hands-on modeling of Attribute, Analytic and Calculation Views using Projection / Aggregation / Join / Union approaches using the graphical model within SAP HANA Studio.

Created Analytical Views to support multi-dimensional reporting by joining Fact table (data foundation) to modeled dimensions (attribute views), selected attributes and measures.

Created calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE studio.

Built the Loss Type and Vehicle Type Reports using the SAP Design Studio 1.2 and 1.3 / HANA XS Reporting Tools connected to SAP HANA Calculation Views.

Extensively worked on the Microstrategy 9.4.1 Architect and the Microstrategy Web / Desktop Reporting tools to develop the Loss Type and Vehicle Type Reports using the Microstrategy 9.4.1 Reporting Tool connected to SAP HANA Calculation Views.

Completed POC to confirm the connectivity from SAP Design Studio 1.2 / Microstrategy 9.4.1 to Sybase IQ demo database.

Client: Novellus Systems, Inc., San Jose, CA Feb 2012 – Oct 2013

Role: Senior BI-BO Consultant

Novellus Systems is one of the leading semiconductor manufacturing companies. As part of ERP implementation, I was involved in full life cycle BW/BI implementation including requirements gathering, data modeling, development, testing, go-live, post go-live support, user training, documentation, change management etc. in SD, MM, FI modules.

Responsible for gathering requirements along with the functional team and developing the Functional & Technical Specification documents.

Responsible for designing and development of Purchasing and Finance reporting requirement.

Worked on the customization of InfoCube, InfoSets, DSO, MultiProvider and InfoObjects as per requirements.

Extensively worked on Transformation Routines, Start Routines, and End Routines as per the requirements and for the lookups from DSO to data targets. Testing and Debugging of routines.

Developed BEx queries for reporting on InfoCubes, DSO and Multi Provider by defining calculated key figures (CKF), restricted key figures (RKF), structures, exceptions and conditions, variables.

Worked on deployment of Webi reports and Xcelcius dashboards.

Developed and modified Universes using BO Universe Designer to get data from BW Info Cubes & Queries, and created reports using Webi.

Extensively created and used alerts, rankings, sorts, and drill-down in reports.

Managed the Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CMS.

Involved in troubleshooting and resolving of BO problems in the day-to-day users/developers activity pertaining to Reporter, InfoView, Broadcast Agent Scheduler and administering user groups and permissions.

Client: Volvo Power Trains, Greensboro, NC Jun 2010 – Jan 2012

Role: Senior BI-BO Consultant

Volvo Powertrain is the Volvo Group Strategic Center for powertrain and one of the world’s leading engine manufacturers.

Developed reports using query designer, BEx analyzer and web application designer.

Extensively worked in generating reports on Finance Invoices and MM Invoices. Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show the Invoicing amount of the respective periods.

Designed and developed process chains for master data loads and transaction data loads with the help of InfoPackages, the Process chains were scheduled for periodic loads.

Worked on BI 7.0 testing, Involved in postproduction support activities in monitoring the daily data loads, fix report issues and reconciliation issues.

Expertise in creation of BEx Queries, structures, variables, calculated key figures, restricted key figures and RRI reporting.

Extensively worked on Crystal Reports to build standard reports, cross tab reports and wrote formulas to calculate the group summaries based on the group levels for various account types.

Extensively worked on Creating Dashboards & Web Reports Using Web items Like Tables, Charts, Drop down Box, Radio buttons, Check Group, Label, Filter and Text Elements.

Environment: SAP BI 3.5/7.0, ECC 6, Crystal Xcelsius 2008, Crystal Reports 2008.

Client: Bell & Howell Postal Automation, Irving, TX

Role: SAP BI Analyst Jan 2005– Jun 2010

Developed reports using query designer, BEx analyzer and web application designer.

Extensively worked in generating reports on Finance Invoices and MM Invoices. Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show the Invoicing amount of the respective periods.

Designed and developed process chains for master data loads and transaction data loads with the help of InfoPackages, the Process chains were scheduled for periodic loads.

Worked on BI 7.0 testing, Involved in postproduction support activities in monitoring the daily data loads, fix report issues and reconciliation issues.

Expertise in creation of BEx Queries, structures, variables, calculated key figures, restricted key figures and RRI reporting.

Extensively worked on Crystal Reports to build standard reports, cross tab reports and wrote formulas to calculate the group summaries based on the group levels for various account types.

Extensively worked on Creating Dashboards & Web Reports Using Web items Like Tables, Charts, Drop down Box, Radio buttons, Check Group, Label, Filter and Text Elements.

Role: Software Engineer, Coding Accuracy System Jan 2002 – Dec 2004

Support and enhance NT and DOS based postal address lookup software systems. Enhancements included required changes to algorithms for annual USPS certification process (CASS).

Improved the Sort Rate of UK Post/MERLIN by improving address block detection, text recognition, line formation.

Coordinated with different teams to report/resolve issues quickly.

Upgraded existing install shield project from install shield 5 to install shield 9.

Responsible for developing new install shield projects in install shield 9 and maintained old ones.

Responsible for analyzing, maintaining, coding, and testing programs

EDUCATION

BS in Computer Science,

Nagarjuna University, India

PERSONAL

Excellent analytical skills Hard worker Fast Learner Team Player

Contact this candidate