SUMMARY:

• Over 11 years of IT experience in SAP Business Intelligence (BI) which includes 8 years of extensive experience in Business Objects. Expertise in Business Intelligence 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.
• Expertise in 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 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.
• Mentoring team members

TECHNICAL 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, 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.

PROFESSIONAL EXPERIENCE:

Confidential, Morristown. NJ

SAP BW/BI Senior Business Process Analyst

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.

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.

Confidential

Qlikview Administrator/ Developer

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

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.

Confidential, Florham Park. NJ

SAP BW/BI Consultant

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

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.

Confidential, Florham Park. NJ

SAP BW Consultant

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

• 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.

Confidential, Florham Park. NJ

SAP BW Consultant

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

• 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.
• Provide Documentation on Best Practices for Support and Maintain after GO-LIVE

Confidential, Philadelphia, PA

SAP BW Consultant

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

• 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