VIVEK SINGH

San Jose, CA

P: 314-***-****

Status: H1B

E: abqe4a@r.postjobfree.com

Employer Details:

Pravin

abqe4a@r.postjobfree.com

Sierra Infosys Inc

Office:

Summary:

Successful SAP BI Professional with around8 years of diverse and extensive experience encompassing wide range of skill sets, roles and industry verticals with hands on experience in SAP BW/BO Analysis, Architecture, Design, Development, Deployment, Performance Tuning, Go-live and Support activities. Experienced in working in a globally diverse setups and organizations

Specific Expertise Includes:SAP Certified Application Associate – HANA 1.0 C_HANAIMP_10SAP HANA: Experience in SAP HANA architecture, first ever pilot project in South-east Asia. Good Conceptual understanding of HANA product positioning and its integration with SAP BW and ECC. First-hand experience inECC data transfer through SLT replication, data load using Information Composer and analysing data in HANA Information Modeller.Hands on exposure to BW 7.3 and its features. Involved in Customer validation exercise for BW 7.3. Good awareness of BI 4.0 capabilities and its integration with BW 7.3Implemented 5 full life cycle BI projects for FI/CO, SD, MM, PP, QM, APO, SCM and HR. Extensive experience in business processes across these modulesFollowed and implemented ASAP methodology.Involved in migration process from BW 3.5 to BI 7.0. Strong Knowledge in BW Upgrades to BI 7.0/2004s.Experience in BW / BI configurations from ECC and R/3 systems, good knowledge of SAP structures and Tables in ECC and R/3 environments.Experience in creating Universes using Business Objects Universe Designer and Reports in Web Intelligence and Crystal ReportsBusiness Analysis: Strong Business Analysis skills aided by deep understanding of core functions and processes across various modules of SAP including SD, MM, FI, CO,PP,QM, etc.Data Modeling: Experience in Installation and customization of Business Contents based on user requirements. Extensively built data models using standard and custom InfoCubes, DSOs, DatasourcesData Extraction:Performed extensive CO-PA, FICO, LO Cockpit and generic data extractions. Built DB Connect and UD Connect datasources for non-SAP extractions. Expert in Classification datasources for Materials, Vendors, Customers, Batch and Variant Configuration.Performance Enhancement: Experience in performance enhancement features involving queries and data loads using Aggregates, Partitions,and data Compressions. Strong knowledgeon OLAP Performance analysis using BI statistics.Reporting: Expertise in SAP BW and Business Objects reporting suite. Hands on experience with Front-end BW Components which involve constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures.BW Transports:Successfully led and Co-ordinated Cut-overs for several projects by moving ECC and BW objects across landscapes. Identified expert in handling sensitive LO-Cockpit and ECC outage transports. Proficient in handling pre go-live measures for new implementationsDevelopment of data transfer mechanisms from BW to other systems via Open-hub and PI interfacesKnowledge of BW security and analysis authorizations. Report distribution expertise with SAP Information Broadcaster including Exception and role based broadcasting.Excellent production support and debugging skills, experience in resolving trouble tickets, monitoring loads, enhancements and change requests.Conducted training for end-users. Developed business process documentation.Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability

Technical Summary:

SAP Datawarehouse

SAP BI 7.0 (NW 2004’s), SAP BW 7.3, BW 3.x, Business Objects 3.1, SAP HANA: Information Modeler, SLT Replication.

Languages

SAPABAP/4, SQL

Databases

Oracle, SQL Server, Microsoft Access

ERP

ECC 6.0, ECC 5.0, R/3 4.7, R/3 4.6C

Portal

SAP NetWeaver Portal

SAP Modules

MM,PP, SD, FI-CO,SD, QM, APO, HR

Reporting tools

SAP Business Explorer (BEx) Analyzer, Web Analyzer, Web Application Designer, SAP Visual Composer, Business Objects Xcelsius, Web Intelligence, Universe Designer and Crystal Reports

Project History:

Palo Alto Networks San Jose, California

Lead BI Consultant July 2012 - Present

Responsibilities:Design BI architecture and reporting strategy for a new implementation on BW 7.3 and BI 4.0Integrate Legacy data using DBconnect and BODS for historical reportingImplemented data models for SD, FI, and MM (Purchasing and Inventory)Developed BEx queries and Webi reports for historical and current analytical needsWorked on harmonization of master data between legacy and SAP systems

Aegis Limited – Essar Group Ontario, Canada

SAP BI Senior Consultant / Tech lead March 2011 – June 2012

Aegis Limited is the IT Solutions and Services arm of $20 Billion Essar Group. Essar Group is a multinational conglomerate corporation with several listed businesses in UK, US, India and operations in more than 20 countries across five continents.

Role:Interfaced with Group CIO and Business Heads for their reporting needsInvolved in various pre-sales activities for BI solutions and building the BI CoEServed as an SME for the entire technical delivery of all Reporting and Analytics solutionsArchitected BI data models across variety of functional areas including SD, FICO, PP and MM Worked with SAP on the first ever HANA pilot in South-east Asia

Projects Implemented at Aegis Limited – Essar Group:

BI Implementation – Essar Steel Algoma, Canada

Algoma Steel, a billion dollar steel manufacturing enterprise was acquired by Essar Steel and Aegis was handed over the responsibility to integrate its transactional and reporting systems with Essar Steel’s SAP landscape. The reporting piece involved delivering more than 100 reports in BI and SAP

Responsibilities:Understanding business challenges and translating them into requirements and development of Analytics and Reporting Queries according to Business Requirements.Worked closely with the Algoma Steel business in categorizing their operational and analytical reporting needsSpear-headed the business blueprinting exercise along with the SAP business process experts. Developed EDW architecture for the new roll-outDesigned functional and Technical specifications for Implementation and Development of BO Universes, Webi Reports over SAP BW.Performed initial configuration of new BI 7.0 landscape including instance setup, defining source systems for ECC and establishing necessary RFC connectionsWorked extensively on Data Model designs which involved creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data etc. and also in ETL (Extraction, Transformation and Loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc. Also involved in new features of SAP BI security like Analysis authorizations.Developed over 30 custom DSOs, Infocubes, and multi-providers Developed for SD, MM, PP and FICO reportsImplemented custom business logic through ABAP start and endroutines

HANA Pilot – Essar Group

Essar group chose the SAP HANA platform to strengthen its BI investments and realize the potential of in-memory analytics for fast and improved decision making. Essar group in collaboration with SAP India, undertook a HANA pilot to demonstrate its business value and real-time analytics potential and the results were presented in TechEd 2011

Responsibilities:Identified Reporting Use cases to be implemented in HANACreated Schema, tables and populated data using SQL editor in HANA StudioDemonstrated SLT replication capabilities on ECC tables. Loaded flat-file data via Information ComposerDeveloped Analytical, Attribute and Calculated views, designed universes and created Webi reports based on HANA models

Executive Reports – Stock, Sales & Production – Essar Steel

The Consolidated Executive BI reports for Stock, Sales and Production were developed to replace the legacy EIS reporting system in a bid to project BI as the enterprise wide reporting system and offer a panoramic view of the entire logistics within the Steel business.

Responsibilities:Involved in full life cycle implementation, which included Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Go-live and Post Go-live support.Lead and mentored the technical team throughout the development process. Worked closely with the delivery teams and the business stakeholders to ensure timely deliveryDeveloped Enhancements for Sales Orders, delivery and Conditions datasources to extract all the required data for Sales reports. Built generic datasources to extract production planning data from custom tables.Implemented EDW layer with 16 DSOs to support SD, MM and PP transactional data storageDeveloped14 new Infoproviders, 6 multi-providers, and 3 Infosets to support SD, MM, and PPInitialized Inventory extractors and Infocubes for initial loads, developed data flow for all Steel Plants. Implemented Custom logic using start and end routinesUtilized the Analysis Process Designer (APD) to populate direct update DSOsfor distributing summarized reportsDeveloped 12 process chains to automate the master and transaction data loadsCreated over 20 BEx queries and assigned them to roles by specific plantsInstalled BI 7 Technical content to enable BI statistics for tracking usage and performance.Troubleshoot extractor performance, tuned BW queries by building aggregates and optimizing data models. Fixed delta issue with 2lis_12_vcitm by modifying SMOD code.Conducted end user training sessions for various business departments, and documented the whole project. Assisted in defining SAP Security Guidelines.

Monsanto, St Louis, MO, USA January 2008 – February 2011

SAP BI Tech Lead – SAP Business Intelligence Team

Monsanto is headquartered in St.Louis, Missouri, in the United States, and has locations aroundthe world. The Locations are variously administrative and sales offices, manufacturing plants,seed production facilities, research centres and learning centers – all parts of the corporate focus on agriculture and supporting farmers.

Role:

SAP BW Architecture: Facilitated business process definition and modeling for SAP/BI development.Involved with brainstorming sessions for design and architecture improvements as well as the development practices for SAP BI environment

Coordination: Co-ordinated cross functional project teams during the entire life cycle of SAP BW Projects. Worked successfully in close coordination with business users, SAP functional, SAP Basis, Security and ABAP teams for delivery and maintenance of BI solutions

Leadership: Led cross-functional teams for delivering large scale projects. Mentored the off-shore development team as well as Involved with interviewing developers and helping them with the on-boarding process

Involvedin all phases of Project life cycle of BW Projects, including requirement gathering and analysis, data modelling, technical design and development, data extraction, report generation and transports.Integrated various Business Applications like SCM / APO (DP & SNP), FI/CO, CO-PA, SD, MM (Purchasing, InventoryManagement), PP etc. with BW using new BI 7.0 techniques and also with BW 3.x systemsEvaluated and improved existing designs and BW data models within Monsanto’s BW environment and made process improvementsProposed the Enterprise Data Warehouse architecture which was adopted as a development standard for Monsanto’s global BW landscapeWorked on Proof of Concepts for the evaluation of BI /BW Accelerator through extensive testing for its impact on BI Query runtimes and other factors. Worked on several Business Objects proof of concepts

Projects Implemented at Monsanto, USA

American Seed Application Integration Project

Role: Tech Lead, Architect, Business Analyst, Lead Designer and Developer

Environment: SAP NetWeaver 2004’s, SAP ECC 6.0, OTC (Sales, Billing, Deliveries), Inventory, CRMand Accounts Receivables.

Description:American Seeds Inc was formed with 26 regional seed companies acquired by Monsanto with around $1B in sales. All brands operated across 4 different IT platforms with no integration with Monsanto’s platforms. The business wanted to integrate the entire regional reporting environment into Monsanto’s existing SAP BI platform to provide a common foundation for access to cross channel grower data.

Responsibilities:Interviewed the business users across 18 different brands to understand their reporting needs and map them to Monsanto’s existing reporting platformBrainstormed design sessions with various Business Analysts across multiple functional areas to understand the ECC design so as to map out the source tables and data flow for BI extractionCo-Architected the entire data warehouse platform and the reporting model for the new set of companies/brandsImplemented Enterprise Datawarehouse layer with 27 DSOs for SD, MM, PP, QM, FI, AR and AP transactional data storage.Developed18 Infoproviders for supporting the reporting needs. Developed DB Connect datasources to fetch data from legacy Oracle databases.Implemented Custom delta extraction using SMOD enhancements for Sales order to extract data from VBPA table.Implemented 6 Openhub and 4 PI interfaces to transmit data to be consumed by external applications Made several improvements over the existing reporting environment using latest SAP BW and Business Objects technologies.Developed 12 generic BEx queries to serve as datasources for BO UniversesDelivered 35 different reports using different front-end tools from the Business Objects Suite. The reports were spread across several functional areas like Order-to Cash, Accounts receivables, Inventory Management, Quality Management, CRM etc.Implemented a Custom security model for the Project utilizing analysis authorizations and LDAP access to provide data level security on BO Web Intelligence Reports.

Procurement BW reporting and data cleansing Implementation

Role: Project Lead, Business Analyst, Data Modeler and Lead Developer

Environment: SAP NetWeaver 2004’s, SAP ECC 6.0, FI (General Ledger, Account Payable), MM

(Purchasing)

Description:Re-design of the previously failed Procurement reporting implementation. Monsanto Company’s Procurement business needed a reporting system to providehigh level visibility on PO and non-PO spend by accurately combining information from variousAccounts payable and Purchasing systems within the company.

Responsibilities:Led the development and coordinated the project team for global implementationCo-ordinated a cross-functional project team across different world areas (4 time-zones) which involved SAP Business Analysts, business representatives, BI developers, data analysts and ABAP developer. Drafted a Project Plan with the phase wise completion and milestones including individual responsibilities for project team membersInterviewed business users across the globe to find out data issues in the SAP transactional system and flaws in the purchasing business processes. Worked with the data staging team, business users and the SAP functional experts on data cleansing by implementing BW reports for minimizing master data duplication for Vendors, eliminating usage of obsolete plants and company codes, implementing better usage of material group and Purchasing Org master data. Implemented a EDW layer by developing 21 DSOs for storing data for MM-PUR, requisitions, FI-AP, FI-GL, tax information.Implemented a complex custom logic using end routines to process Purchase related invoices and local tax calculationsImplemented delta queue based generic extractor using BTE (Business Transaction Event) and function modules. Developed 13 Infocubes, 5 Multiproviders and 4 Infosets for supporting Procurement Reporting needs across 4 global regions including North & South America, Europe and Asia-PacificDelivered 16 Global reports based on BEx / Web Analyzer that sufficed the need of all the world regions. Also delivered an geo-spatial interactive dashboard using Web Application designer for the Procurement business executivesDeveloped Region and Company code based security roles utilizing analysis authorizations

Monsanto Supply Chain Reporting Implementation

Role: Business Analyst,Lead Developer, Data Modeler

Environment: SAP BI 7.0, SAP SCM (APO) 5.0, SAP ECC 6.0, Sales and Distribution.

Description:Monsanto’s Seed and Traits business needed a consolidated supply chain reporting platform to analyze planning and forecasting accuracies against actual sales.

Responsibilities:Coordinated the reporting requirements with business users across multiple business units and geographical locationsDeveloped a Project plan for the 32 week Project.Designed and architected the reporting solution for the Supply Chain Reporting Platform for Monsanto’s Seed and Traits business encompassing business units like Vegetables, DPL Cotton, and Row Crops etc.Generated export Datasources on SNP / DP Planning Area for BW reportingImplemented DSOs, InfoCubes and Multiproviders for SNP and Demand Planning report RequirementsDeveloped Remote Cubes to read real-time Live Cache data directly. Developed several performance evaluation queries to monitor forecasting accuracy against actual sales / shipmentsDeveloped Consolidated reports combining forecast data from APO with Sales and Stock data from ECC to evaluate stock at hand based on the Sales ForecastLed the cut-over activities during project go-live with efficient co-ordination

Seeds and Chem. Sales Volume Reports

Role: Business Analyst, Data Modeler and Developer

Environment: SAP Netweaver 2004s, SAP ECC 6.0, CO-PA (Profitability Analysis), SD (Sales & Distribution), SAP Netweaver Portal and MS SharePoint

Description:Monsanto’s Finance executives required reporting capability to gain insight into newly started Seed Treatment business and seed pricing strategy and also have the ability to track seeds and chemical volumes shipped to the customers on a daily basis.

Responsibilities:Interacted with users and financial analysts from the Seed and Chem. Business to understand reporting needs across the boardCustomized SD & CO-PA DataSources and developed custom Multiproviders, InfoCubes and DSOs based on the data model for the reporting requirementsDeveloped highly customized reports in BEx Analyzer and Web Templates in the BEx Web Application designer for Graphical representation. Implemented complex ABAP routines, user-exit variables, formula variables, calculated and restricted keyfigures. Developed iViews based on WAD templates and worked on integrating those iViews with SAP NetWeaver and MS SharePoint portal

Coca-Cola, Atlanta, GA, USA May 2006 – August 2007

SAP BI Technical Analyst, Data Modeler

Project: Playbook

Environment: SAP Netweaver 2004s, SAP xRPM, SAP Visual Composer, SAP Netweaver Portal

Description: Coca-Cola’s Program Management and Leadership team needed a reporting tool and online portal for tracking all the project status and facilitate resource management to maximizeonshore/offshore resource utilizations.

Responsibilities:Developed a reporting and Project tracking tool Playbook using SAP Netweaver 2004sDesigned queries to be used in the Playbook. Worked with ABAP developers to develop BAPIs for displaying xRPM transactional data on SAP Netweaver PortalBuilt online dashboard for Project tracking and Status Reporting using SAP Visual ComposerFacilitated flow of data from SAP BW, xRPM to Visual ComposerDeveloped a tool to track onshore/ offshore resource utilization for the Program ManagersCreated training materials for the Playbook & the online Dashboard. The training materials were accepted as documentation standards for Coca-Cola’s BI platformDelivered training to the leadership team consisting of Program and Development Managers

University of Missouri, Rolla, MO, USA August 2005 – May 2006

Data Warehouse Designer

Role and Responsibilities: Managed the entire SAP BW landscape at the University and hosted the university competency centerDeveloped reports on the legacy DatawarehouseDeveloped Balanced Scorecards in SAP SEMCreated Data Mining models and APDs for various analytical needs of the University ManagementExtracted data from APO, ECC, non SAP sources like Oracle DB

Reliance Industries, India July 2004 – June 2005

Reliance Energy wanted to automate the IT infrastructure and contract management with indigenous software.

Role and Responsibilities:Developed and Implemented SAP BI reports for Sales, delivery and billing in both operational and analytical formats for accurate sales interpretationImplemented the Personnel Administration and Payroll reportsImplemented capacity planning and Master Production Scheduling for Indian and African Business Units.Implemented Vendor Procurement and Spend Analytics with data from FI, AR and AP moduledata.Provided support and enhancements for existing data models and reports

Educational Qualifications: M.S. in Information Science and Technology, Missouri University of Science and Technology, USAGraduate Certification Program in ERP, Missouri University of Science and Technology, MO, USAUMR – SAP Certificate of Excellence from SAP America’s University Competency CenterB.E Information Technology, University of Mumbai

Contact this candidate