Sap Project

Summary

• Over *+ years of experience in Business Intelligence using SAP Business Objects XI-R3.1/R2/6.x with Info view, Web Intelligence, Data Integrator & Quality, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008 Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, Business Explorer/Polestar XI 3.1, Publishing Wizard, Import Wizard and Report Conversion Tool.

• Strong Knowledge and Experience in Business Objects tools & SAP Business Objects from 2003 i.e. Over 7+ Years. Strong knowledge and Skill in Data Integrator & Data Quality Tools. Strong SAP ECC Knowledge in SAP ECC 6.0 (FICO,MM,PP,SCM,SD)

• Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.

• Best Project so far, Worked for Open Text Corporation developed VIM Interactive Dashboard, Which is currently going to be sold in around 120 Countries by SAP. Worked with SAP America and SAP China by following their Technical, Functional Specifications and Standards.

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.

• Extensive experience on Prototyping the new technologies like Business Explorer/Polestar XI 3.1,

• Used Live Office and QAAWS (Query as a Web Service) to feed live data into Xcelsius 2008 (both Dashboards & Scorecards). Used Charts, Sliders, Container, Tabs, Maps, Gauges, Radio Buttons, Toggle Functionality, Dynamic User Selections and Visibility.

• Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC), Managed Central Management Server (CMS). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems exists in the Crystal Reports.

• Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports.

• Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer, Data Modeling.

• Extensive knowledge in SQL & PL/SQL programming and trouble shooting

• Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.

• Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.

• Good Working knowledge of UAT Guidelines and Testing Project Deliverables against both Technical and Functional Specifications.

Technical Skills

BI Tools: SAP Business Objects XI 3.1, R1/R2 6.5.x,Crystal Report 9/10/ XI/ 2008,Xcelcius 4.5/2008, Info view, CMC, CCM, CMS, BEx Query, BEx Analyzer, Desktop Intelligence XI ,Full Client, Web Intelligence, Business View Manager, SAP ECC 6.0, SAP BI/BW 7.0, Live Office

ETL Tools: BO Data Integrator (ETL), Data Services.

Databases: SQL Server 2000/7.0/6.5, Teradata, Oracle 10g, 9i/ 8i, Access, DB2.

Languages: C, C++, SQL, PL/ SQL.T-SQL.

Products: SAP ECC 6.0/ BOBJ, SAP BI/BW 7.0, Microsoft Office, Erwin, Toad.

Education: - Bachelors in Computer Science at Gitams, Vishakhapatnam, India.

Masters in Business Information Science & Technology, Missouri University of S&T.

SAP,ERP Certifications from SAP and Missouri University of S&T.

United Health Group, Plymouth, MN Nov 2011- Till Date

Role: SAP BOBJ Developer

Project Details: I have been working with United Health Group a fortune 22 Company on maintaining its SAP Business Objects XI R2 Environment. UHG is a Huge Health Care Company based in Minnetonka, Minneapolis. I worked on Developing Cancer, Kidney and Women’s Health Universe, Webi Reports and Dashboards.

Responsibilities:

• Worked on SAP Business Objects XI R2. Work involved using Tools Universe Designer, Web Intelligence, QAAWS, Live Office, Info View, Xcelsius 2008 and Microsoft SQL Server 2008.

• Developed Xcelsius Dashboards for Kidney / Cancer / Women’s Health Projects using Universe Designer and SQL Server 2008 as the Source Database. Used a Combination of Detail, Summary and Derived Tables and simultaneously joins (Equi, Theta, and Outer), Cardinalities, and Contexts etc. to create the Universe to work for the associated Project.

• Created Universe Solving Traps and Contexts with using best working principles.

• Assigned @ BO Variable to implement User Level Security, Assigned Hierarchies to facilitate Drill Down and Scope of Analysis Accordingly.

• Used SQL Server 2008 excessively for Data Validation, Join Determination, Table Understanding, Metric Calculation, Testing, Verification and Data/Requirement Understanding.

• Worked on Gathering Requirements, Understanding technical specifications as required by the Project guidelines, the Scope and simultaneously developing universes, Reports and Dashboards.

• Created User Groups, assigned Folder level Security, and maintained BOBJ XI R2 environment based on project Requirements.

• Used Import Wizard to help Migrate Project Deliverables between Dev, QA and Production Environments.

• Had Performed Various BOBJ Admin Duties Ranging from Creating Users, Roles, Scaling Servers, Scheduling Jobs etc.

• Developed Webi Reports, Summary and Detail Reports, Using the Summary as the source for the Xcelsius Dashboards and the Detail is linked through Open Docs to view the User Selections from the Dashboard in Detail.

• Developed Xcelsius Dashboards Using the Source as Webi Reports, which were built on Universe, Imported the Webi Reports using Live Office.

• Created Dashboard User Interface Prototype for the different Projects based on User needs, Data Visualizations, Charts, Dynamic Selections & Visibility, Tabs, Alerts, User Selection Components, Multiple Drill Downs etc. as adequately required using Xcelsius 2008 Sp4.

• Worked on Data Modeling, and Design as per the requirements for building the dashboards in Microsoft Excel Using Excel Functions like Vlookup, choose, nested if conditions etc.

• Performed UAT and Handled various Issue resolution through Ticketing activities as the POC for the 3 Projects that I have worked for UHG

• Handled Project Responsibility for Verifying Project Deliverables against Both Technical and Functional Specifications.

• Worked towards assisting any defects, Performance issues in relation to SAP Business Objects Environment.

Environment: SAP Business Objects XI R2, Xcelsius 2008 SP3, Microsoft Excel Functions, Microsoft SQL Server 2008, Webi, Universe Designer, Live Office.

Pfizer, New York Aug 2011- Oct 2011

Role: - SAP BOBJ Developer

Project Details:- Pfizer, Is a top Fortune 32 Pharmaceutical company in the market. I have been engaged as a Architecture and Solution Engineering Consultant and simultaneously develop Power 2 Learn Dashboard Using Live Office & QAAWS on a universe already developed. I Maintained SAP Business Objects Environment Securing its Stability and Improving BOBJ Tool Set Performance and Environment.

Responsibilities:-

• Designed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client.

• Worked on Performance improvements for the earlier created Xcelsius Dashboards. Followed Best Principles and made some major workflow changes and successfully reduced Dashboard load time to 15 secs.

• Worked on SAP BOBJ EPM, Performance Manager for Dashboard framework.

• Build Xcelsius Dashboard Power 2 Learn using Live Office, & QAAWS Using Universe as the Source of data. Used Flash Variables, Extremely Extensive Dynamic Visualizations, Chart and Map Drill Downs.

• Used Open Docs to allow users to move from the Dashboard to its related detailed Webi report. And also from Webi reports to another reports using hyperlinks achieved through using OPEN Docs.

• Used User row level security for data in the Dashboard. Used BO User variables and also Flash variables such as CELogon token to provide Token exchange since dashboard is deployed outside Info view.

• Build Webi Reports as per the Requirements for the Manager Dashboard, Using Context Operators, Query Report Level Filter, Drill Downs, Variables etc. as required per the requirements.

• Worked on SAP BOBJ EPM, Performance Manager for Dashboard framework.

• Used Info view excessively to test Xcelsius Dashboards, Webi reports, in DEV, QA, UAT, and PROD Environments.

• Provided Architecture and Solutions Engineering regarding projects that were supposed to be implemented using SAP Business Object Tools, Such as Universe Designer, Web Intelligence, Crystal Reports, Xcelsius 2008, QAAWS, Live Office etc. accordingly to the architecture currently suitable for the client.

• Maintained Architecture for the BO XI R2 / 3.1 environments BO APAC, BO Emada for Canada, UK and USA for Pfizer Organization.

• Worked on Performance Enhancements for Xcelsius Projects built by other teams, by looking into various aspects like Architecture, Design, Server Scalability and Environment Load Handling.

• Provided User Training, Project Support, and Guidance all through the project.

• Served as POC for BO Testing against Deliverables based on requirements and project Specifications.

• Maintained Server and Architecture Environment based on project needs as required maintaining stable work environment.

Environment: SAP Business Objects XI R2/3.1/4.0,Xcelsius 2008 SP3, Excel Functions, SAP BI/BW, SAP Net weaver, Bex, Webi, Crystal, Universe, QAAWS.

Baker & Hughes,(Infosys) Houston, TX Jun 2011- Aug 2011

Role: - SAP BOBJ Developer

Project Details: - Baker & Hughes, Is top-tier oilfields Service Company, Baker Hughes delivers solutions that help oil and gas operators make the most of their reservoirs. I have been working as a SAP BOBJ Consultant through Infosys. I have worked under various projects related to Universe designing; Webi reports creation & Xcelsius Dashboard.

Responsibilities:-

• Build Xcelsius Dashboards using SAP BICS Connector uses SAP BW Queries to get data from SAP BW. Without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard. And Then Publishing these dashboards back on the SAP Portal since Dashboards made through BICS Connector are not accessible from Info view. Involved in Projects Namely

o OTD Customer Dashboard, Webi Report & Universe.

o OTD Supplier Dashboard, Webi Report & Universe.

o Shipment (Order Fulfillment) Universe & Webi Report Designing.

o HS&E (Health Safety & Environment) Webi reports & Dashboard Development.

• Used Open Docs to allow users to move from the Dashboard to its related detailed webi report. And also from Webi reports to another reports using hyperlinks achieved through using OPEN Docs.

• Worked on production support for solving issues related to Universe, Webi reports & Dashboards.

• Provided User Support, Training and Support for Soft Project hand over to Production Environment.

• Used Bex Queries all through the Project to build OLAP Universes, and Webi Reports & Xcelsius Dashboards.

• Worked on Bex Analyzer to test the above mentioned Xcelsius Dashboards, Webi Reports & Universe, to verify & test the Consistency of data all throughout the SAP BW & SAP BOBJ Platform.

• Used Info view excessively to test webi reports, verify CUID’s etc since the connection from dashboard to webi report etc have to be maintained.

Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008 SP3, Excel Functions, SAP BI/BW, SAP Net weaver, Bex Analyzer, Webi, Crystal, Universe, QAAWS.

Open Text Corporation, Philadelphia, PA Nov 2010- May 2011

Role: - SAP BOBJ Developer

Project Details: - Open Text Corporation, is a content management company; I have been their BOBJ Consultant working on creating their new product into the Market. I have worked extensively on developing Dynamic Open text vendor Invoice management Interactive Dashboard which is known as SAP Vendor Invoice Management by Open Text . This Dashboard is to be used in around 114 countries around the world. One Single Dashboard dynamically adjusts to various requirements without any modifications.

Responsibilities:-

• Build Xcelsius Dashboards using SAP Web services created from SAP Net weaver. Without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard.

• Various SAP Functional Modules have been used as a source and ABAP programming to extract, aggregate and deliver the data to Xcelsius using SAP Web services.

• Highly Interactive Dashboard completely based on dynamic user input and varying amount of information to analyze without limitations being provided to the user.

• Various other forms of dashboard development also performed including Data from SAP BW through Bex Queries, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.

• Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.

• Designed dashboard using best practices and advanced filtering techniques to dynamically filter and serve as the source for the dashboard.

• Optimized dashboard performance for speed of thought analysis even with large data volumes and simultaneously allowed user customization on the fly.

• Worked Extensively with Flash Variables, web services and made Generic Dashboards to enhance Performance in Situation to Decrease Load on the Parent Dashboard, and Designed Child Dashboards to Distribute Load among Various Child Dashboards to Mitigate the Performance Issues

• Used Complex excels functions and logics to support data requirement. Ex: - Vlookup, hlookup, choose, Nested IF’s, Value, ISNumber, ISNA, Match, Index etc to name a few.

• Built Password Protected Dashboard and Created a Scenario to Trigger Multiple Web Services on User Authentication.

• Built Many Static Dashboard Models during all my Work Requirement in due process to Create Generic Live Model Using Web Services, Flash Variables etc.

• Done extensive testing across various scenarios to see the dashboard working across multiple complex and varying scenarios.

• Used various Custom SAP functions exclusively for Xcelsius to help in this process to additionally implement thousand separators and decimal Operators to support various different number formats.

• Performed Extensive UAT and Functional and Technical Specification Testing following SAP Guidelines, Checklist and Standards.

Environment: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008 SP3, Excel Functions, SAP BI/BW, SAP Net weaver, Bex, Webi, Crystal, Universe, QAAWS.

Daimler Trucks, Portland, Oregon (A BENZ Company) Sep 2009 – Nov 2010

Role: - SAP BOBJ Developer

Project Details: - Daimler Trucks North America is the largest heavy-duty, medium-duty trucks and specialized commercial vehicles in North America. They have a very robust SAP infrastructure and had requirements dealing with SAP BOBJ to Build Universe, Reports, and Dashboards for various department needs.

Responsibilities:-

• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.

• Conducted Study to Build Universe’s Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.

• Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc, and also Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.

• Designed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client.

• Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using Webi, Xcelsius 2008.

• Developed new set of standard Web Intelligence reports against the new universe. Completed ad-hoc data requests as required.

• Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.

• Involved in writing scripts and also used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is a initial load or a bulk load.

• Creating complex Data flows with inner R/3 data flows and declaring parameters at different levels of Workflow.

• Creation of different data stores to get SAP tables.

• Used Business Objects Data Integrator XI R2 for ETL extraction, transformation and loading data from heterogeneous source system.

• Worked on Polestar to generate complex reports for the data required. Simultaneously export reports and making it easily available to Decision makers.

• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.

• Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Staked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.

• Performed ETL activities using Data Integrator and Data Services, by extracting data from various Sources.

• Design, develop, and implement Xcelsius dashboard against SAP BW data sources. Established the design pattern for all future Xcelsius development using Live Office and QaaWS as connectors

• Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008 and embedded Xcelsius onto Crystal Reports for better results and also provide users with clear understanding.

• Worked on certain issues and dealt with Info View, CMC.

Environment: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0, T-SQL, Oracle PL/SQL, Info View, CMC.

Contact this candidate