Summary

Over ** years of IT experience in SAP Business Intelligence (BI) which includes 8 years of extensive experience in Business Objects. Expertise in Business Intelligence Architecture and Components like Queries, Extractors, Info Objects, Info Sources, Update Rules, Transfer Rules, Info Cubes, Info Packages, Authorization, Modeling, Extraction and Reporting. Expertise in Business Objects components like Universe Designer, Web intelligence Rich client, Live Office and Xcelsuis. Experience in Qlikview on creating dashboards using various connectors like SQL, OLAP and Custom connectors.

Involved in the scope of implementations using Accelerated SAP methodology from business blueprint phase till Go-Live of the project and created necessary documentation for the knowledge transfer to the support team after MTP [Move-To-Production].

Strong business and technical experience in conducting work shops, requirements gathering, BW landscape, signing of the systems, GAP analysis including Designing, development, implementation, and installation of Business Content for Financial Reporting.

Extensive experience in professionally interacting with all levels of the user community. Effective in executing multiple tasks and assignments ahead of schedule with excellent communication skills.

SAP BI Expertise

Expertise in architecture, Design, Development and Administration of Business Intelligence Applications with SAP BI tools 3.1/4.0/4/1.

Expert in Design, Development and Administration of Business Intelligence applications with QlikView 11.0/11.2.

Strong knowledge in SAP BI aka BOBJ cluster based deployment and administration such as performance tuning, content management and security

Strong knowledge in Qlikview cluster based deployment, administration, and document repository and user management.

Experience in authoring design standards and conducting design reviews of dashboards front end application deployments.

Involved in complete life cycle implementation of SAP BW including architecture, modeling, design and development of BW info providers and other objects, data extraction from SAP and non-SAP products, BW data access using Business Explorer and extensively used BEx Analyzer Web Designer for creating Reports.

Experience in authoring design standards and conducting design reviews of dashboards front end application deployments.

Expertise in Business Warehouse Components like Extractors, Info Objects, Info Sources, Update Rules, Transfer Rules, Info Cubes, Info Packages, Authorization and Modeling.

Expertise in front-end Business Warehouse Components Queries, calculated key figures, restricted key figures, exceptions, conditions, RRI etc.

Experience in authoring design standards and conducting design reviews of dashboards front end application deployments.

Sound knowledge of object oriented programming

Highly self-motivated, team player, outstanding organizational and interpersonal skills with result oriented dedication towards goal achievement.

Self-motivated, innovative, hardworking, dedicated, able to learn quickly, excellent presentation skills and committed to work in a diverse environment

Experienced in providing Technical Training of SAP Business Objects and QlikView to category teams.

Experienced in Creating Tableau Dashboards and sheets.

Mentoring team members

Skills

Languages / Development Software’s

SAP BW 7.0/3.5(SEM-BW)/3.1C/3.0B/2.1C,

BIA, SAP Business Objects XI 3.1, BI 4.0, BI4.1, Qlikview 11.0/11.2 SR9, Tableau 8.x, 10.1.2, SAP R/3 5.0/4.6C/4.5B, Workplace 2.0 C, SQL, HTML, XML, Java, MS FrontPage, MS SQL Server 2000/7.0, Access, Oracle 9i/8i/8.0.

Operating Systems

WINDOWS 98/95/2000/NT/XP

Reporting / Designing Tools

Business Explorer, Web Application Designer, Universe Designer, Web Intelligence Rich Client, Dashboard Design (Xcelsius) Query as Web Service, Live Office, Central Management Console, Info View, Crystal reports, Mobile BI MS Visio.

Additional Skills

MS-Office Suite (Word, Excel), Xcelsius 2008, Test Director 8.0. U-perform.

Experience

Colgate-Palmolive, Morristown. NJ. July 2007 -- Present

Environment: SAP BW release 7.0, Windows XP, Query Designer, Business Objects XI 3.1, 4.0, 4.1, Webi Rich client, Crystal Reports, Dashboard Designer. Qlikview 11.0/11.2 SR9.

Colgate-Palmolive - Colgate-Palmolive is a global leaders in cleaning products, with thousands of technical experts on staff and an ever-growing number of patents. Trusted brands for dental care, personal care, home care and pet nutrition.

Responsibilities:

SAP BI (Business Objects) Administrator/Developer 2008 - Present

Responsibilities:

Designing and Administrating SAP BI (BOBJ) landscape.

Experienced in designing and developing SAP BI tools such as Universe designer, IDT, WebI, Dashboards, Analysis Office for Excel, Explorer, SAP Design Studio and Lumira.

Investigation of new SAP BI technologies.

Develop Proof of Concepts for Business Object technologies

Successfully lead the upgrade activities from BOBJ 3.1 SP2 to SAP BI 4.0 SP5 through 4.1 SP5.

Used 5-Step Methodology to create a project plan for upgrading our BOBJ landscapes.

Designed BOBJ security strategy and created groups with rights to manage folder level security and development access.

Successfully deployed and managed 4.1 explorer landscapes.

Migrated BOBJ contents from 3.1 to 4.0 landscape along with explorer information spaces using the Upgrade management tool.

Worked closely with SAP to fix bugs and optimized BOBJ CMC services to optimize performance.

Successfully conducted design reviews and helped teams to design and build BOBJ artifacts such as dashboards and webis.

Worked closely with business users to identify and articulate their requirements with a focus on key performance indicators and ensuring that the IT solutions developed and delivered meet or exceed expectations.

Designed and developed various Executive Dashboards using Dashboards (xcelsius) using Live office connections.

Trained category teams and enabled them to develop dashboards and ad-hoc reports using SAP BI tools.

Played a key role in the design and development of Executive dashboard suite providing visibility to Sales, P&L and Marketing information for Executives.

Designed and developed P&L explorer information spaces and created exploration views to enable self-service for quick and high level slicing and dicing.

Involved in developing Web Intelligence documents for Divisional Dashboard using Custom variables objects, Filters, breaks and other Webi functionality.

Involved in Creating Crystal reports for several finance reports.

Lead the Mobile BI project to configure and Set up Blackberry devices Globally, for all of Colgate Blackberry users in distributing the daily Flash Finance reports.

Expertise in using LCM/Promotion Management tool to move all jobs to Test and Production management

Successfully implemented CTS+ for Business Objects and also integrated Business Objects with Solution Manager to automate all promotions to Test and Production environment.

Worked closely with SAP product support and development organizations to support to fix bugs, and resolve issues.

On call on 24/7 production Support to resolve all production issues.

Tableau Developer 2015 – Present

Responsibilities:

Developed a POC comparison dashboard to compare the functionality and key differences between Qlikview and Tableau.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending

Generated Dashboards with Quick filters, context filters, Parameters and sets to handle views more efficiently.

Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Demonstrated Tableau Tool to IT and BusinessUsers to show the key features of Tableau as a BI tool.

Qlikview Administrator/Developer 2013 - Present

Responsibilities:

Working as Qlikview Administrator primarily managing test and production landscape, design reviews lead, content management including mastrer data repository, user security, and system tuning and performance optimization.

Work closely with Qlikview support team to trouble shoot system/application related issues/bugs

Documented best practices and standard guidelines for dashboard development.

Successfully lead and managed Qlikview landscape upgrade from 11.0 to 11.2 SR9 and deployed clustered environment.

Successfully conducted stress and volume testing to measure performance and reliability of the system post upgrade.

Worked with DiSquared to build custom ABAP solution to acquire BW data via BW Query into Qlikview.

Developed and supported Utilization dashboard to have better visibility on Qlikview utilization.

Successfully conducted QlikView designer and developer training for Interns and category teams.

Worked with business to gather and document feedback on their visualization needs. It was necessary to make ensure that users had visibility to data in an informative & effective presentation to facilitate decisions to process improvement.

Lead the initiative to set up repository level security on qlikview landscape for managing developer/user access.

Created Qlikdeveloper and Qliksupport groups to manage developers and production support groups.

Fostered strong relationships with Qlik ensuring pro-active support and access to key support & development resources when needed.

Mentored the team members.

SAP BW Developer July 2007 - Present

Responsibilities:

Working with Global BI (Center Of Excellence) Team as Business Process Analyst.

Working as a proactive member of BI Strategy Team.

Setting global standards for SAP BI interaction in organization.

Handle both back end and front end issues in BW/BI

Extensively involved in Data Modeling, Extraction and Reporting

Involved in the design and build of the data model

Created Multi Providers, Custom Cubes, InfoSources, Info Objects, Transfer Rules and Update Rules for Inventory KPI Management and complex queries to properly manage the Inventory based on Future Demand

Extensively worked on xRPM 4.5 and cProjects Business Content Installation, Standard and enhanced Extractors and data sources and Queries and report’s Enhancements for Role, Demand, Relation and Actuals

Involved in creating/maintaining Aggregates, indexes and Rolls ups.

Involved in creating cubes for Flash reports with complex Update Rules and Routines.

Extensively Worked in Query Designer, Web Application Designer and Bex Analyser.

Involved in creating Structures, Variables and Views in Query Designer.

Involved in creating reports with Restricted Key Figures, Calculated Key Figures and Filters.

Worked extensively in loading data into Info Providers using Full load, Init and Init deltas.

Lead End User training and Knowledge transfer sessions across global Divisions.

Created Process chains, maintained and also Monitored the Scheduled Jobs.

Created Transports and Imported to Test and Production systems.

Involved in the POC of Business Objects and Pilot of BI Accelerator .

Extensively involved in the Production support break fixes and Master data maintenance.

Participated in the Testing of the upgrade of Business Warehouse to Enhancement Pack 1.

Supported and tested the BD2 conversion of production environment.

Prototyped several designs for Dashboard using Business Objects tools.

Lead the POS application upgrade to use BIA, and have strong knowledge of BIA functionality.

Pro active part of the On Call BI production support.

Possess excellent interpersonal and communication skills, and have the ability to manage a team and be an efficient team player.

Accenture, Florham Park. NJ. Feb 2007 – June 2007

Client: Dow Automotive Auburn Hills, Detroit, MI

SAP BW/BI Consultant

Environment: SAP CRM 5.0, SAP BW release 7.0, Windows XP, BEx Analyzer.

Dow Automotive is a leading supplier of plastics, adhesives, sealants, vehicle structure enhancements, acoustical management materials, films and fluids for the global automotive industry, serving tier, OEM and aftermarket customers. The organization was formed as a business group of The Dow Chemical Company in 1988 and in 1999 was named as an industry-focused business unit. At the same time, Essex Specialty Products, Inc., a wholly owned subsidiary of TDCC was also integrated into the DA organization. In January 2001, Dow Automotive acquired Gurit-Essex AG and its business groups, which like Essex and its other global affiliates has served the automotive industry since 1960.

Responsibilities:

SAP BI Architecture Specialist Developing BI 7.0 Architecture for sales planning solution that includes harmonization of diverse external data. Architecture includes a layer of DSO (formerly ODS) objects, then InfoCubes, up to a multicube for reporting..

Extensively Involved in Methodology that includes business feasibility study, requirements gathering, fit/gap analysis, functional design, technical design, development, testing and training.

Extensively worked on ETL from CRM, Flat files and XI.

Involved in gathering the Business requirements and Reporting requirements.

Involved in Demonstrating the Front end capabilities if BI.

Created custom DSO’s for Lead Header, Lead Item, Opportunities Header, Opportunities Item, Activities Header and Activities Item from CRM Objects.

Extensively worked on Installing Business Content, Creating Data sources, Data Transfer Process and Transformation.

Created a Sales History Info cube for Sales Planning, for Actual Vs planned reporting.

Accenture, Florham Park. NJ. Sep 2006 – Jan 2007

Client: Wyeth, Great Valley, PA.

SAP BW Consultant

Project: Pursuit Management

Environment: SAP R/3 ECC 5.0, SAP BW release 7.0, Windows XP, 7.0 Query Designer, Report Designer, Analyser.

Wyeth (NYSE:WYE) is a global leader in prescription pharmaceuticals, non-prescription consumer health care products, and pharmaceuticals for animal health. Wyeth's products are sold in more than 145 countries, and its product portfolio includes innovative treatments across a wide range of therapeutic areas. Wyeth's worldwide resources include 52,000 employees, manufacturing facilities on four continents, and a unique research and technology base encompassing small molecules, biopharmaceuticals, genetic engineering that will give us the next wave of innovative therapies; and vaccines. With this depth of resources, Wyeth will continue to lead the way in the development of novel therapies that address critical global health needs.

Responsibilities:

The scope of this project involves reporting solutions for Sales and Distribution and financial data analysis, which includes the replacements of the legacy systems financial and logistics reporting to SAP.

Conducted User Requirements Gathering workshops and interacted with the Management and Business Users to identify Business Requirements.

Interacted with the Management team and end users for designing the data models

Designed and Created estimation model for BW implementation based on the scope of the requirements and prepared technical specification documents.

Created multi providers to combine sales and billing data to give the users the flexibility to create cross functional reporting.

Parallel loading of data through different Info Packages to the same Data Targets using Process chains to improve the load performance.

Worked with the business end users to gather requirements and created Business Requirement documents (BRD).

Extensively worked on Data Transformation Process DTP.

Accenture, Florham Park. NJ. Feb 2006 – Aug 2006

Client: GMAC, Detroit, MI

SAP BW Consultant

Environment: SAP R/3 4.6C, SAP BW Release 3.5, Windows NT, BEx Analyzer, CO-PA,CO,PCA.

Accenture is a global management consulting, technology services and outsourcing company. Committed to delivering innovation, Accenture collaborates with its clients to help them become high-performance businesses and governments. With deep industry and business process expertise, broad global resources and a proven track record, Accenture can mobilize the right people, skills and technologies to help clients improve their performance.

Responsibilities:

Involved in scoping of the project using Accelerated SAP methodology from business blueprint phase till the GO-LIVE of the project and created necessary documentation for the knowledge transfer to the support team after Move-To-Production.

Involved in implementing the SAP BW FI/CO module for NAO profitability analysis.

Extensively involved in Detailed Design and Architecture of FI/CO module based on the user requirements and suggested the best practice guidelines during the process.

Extensively involved in Data Modeling, Extraction and Reporting for FI/CO module.

Involved in Maintaining Info Objects, custom data sources, Info sources, communication structures, transfer structures, transfer rules, update rules, Info packages and Process chains and scheduling the data requests.

Customized Business Content according to client’s requirement.

Worked with Open Hub Services and extensively involved in creating InfoSpokes.

Involved in Transporting of Info Provider data to Desktop computers and External systems using open Hub/Info Spokes

Created Functional and Technical design documents based on user requirements.

Worked with offshore team in providing the guidelines for developing the cubes based on the business requirements.

Involved in Creating Custom ODS objects and Cubes for PCA and CCA.

Generated reports depending on the clients requirements with Restricted Key Figures,

Calculated Key Figures, Exceptions, Conditions, Variables and Filters.

Developed complex queries using BEx Analyzer and embedding into workbooks and scheduled reports using Reporting Agent.

Used Full, Init and delta update mechanisms for uploading the data to BW from R/3 for specific data selections.

oProvide Documentation on Best Practices for Support and Maintain after GO-LIVE

FMC Corporation, Philadelphia, PA. Jun 2005 – Nov2005

SAP BW Consultant

Environment: SAP R/3 4.6C, SAP BW Release 3.5, Windows NT, BEx Analyzer, FI-CO, MM,SD, DB-Connect.

FMC Corporation is one of the world’s foremost, diversified chemical companies with leading positions in agricultural, industrial and consumer markets.

Responsibilities:

Extensively involved in Data Modeling for FI module.

Maintained InfoObjects, custom data sources, Infosources, communication structures, transfer structures, transfer rules, update rules, Info packages and Infopackage groups and scheduling the data requests.

Customized Business Content according to client’s requirement.

Activated Business Content for standard FI Asset Accounting infocubes, Annual Values and Annual Values and Transactions (0FIAA_C01, 0FIAA_C04) InfoSources (0FI_AA_C01, 0FI_AA_C03, 0FI_AA_C04, 0FI_AA_C05 and 0FI_AA_C06) and Info Objects.

Involved in creating a Custom Seciality infocube in SD.

Extract data using R/3 and flat files as data source

Used delta update mechanisms for uploading the data to BW from R/3 in specific data selections.

Extensively involved in working with FI-SL (Financial - Special Purpose Ledgers) extractors.

Created custom infocube in FI for Strategic Sourcing Infocube.

Generated reports depending on the clients requirements with Restricted Key Figures,

Calculated Key Figures, Exceptions, Conditions, Variables and Filters.

Created optimal user exit variables and calculation for financial reporting.

Developed front-end queries and reports using BEx Analyzer, BEx Browser, Infoset Query, BEx Web Reporting tool and Web Application Designer

Contact this candidate