Profile

• A multi-faceted SAP Consultant over 9 years of techno-functional expertise in SAP with specialization in SAP NetWeaver BI / BW and BO Tools such as Webi, Dashboard designer, Crystal Reports, Data Services and SAP R/3.
• SAP Certified BI/BW Professional
• SAP Certified BO Professional
• SAP Certified HANA Professional
• Experienced in migration projects from BW 3.5 to 7X and 7.x to 7.3 with HANA.
• Experienced in integration BO tools such as Data services, Webi, Crystal reports, Dashboard designer with the existing BW landscape to deliver enterprise reporting solutions and SAP Business Objects Mobile.
• Responsible for delivering multiple projects with budget ranging from 1 million to 5 million for different work streams such as OTC, PTP and FI etc.
• Responsible for conducting BI Best Practices for Data Migration and Data quality.

Technical

Strong in all aspects of BI: BI data modeling, data staging and Activating Enhancing standard Business Content, scheduling and process chains Partitioning Compression, OLAP Cache, secondary Indices, Pre-calculations etc.

• Upgrade Experience in SAP BW from 3.5 to BI 7.x and in depth knowledge of migrating data sources from BW 3.5 to BI 7.x and maintaining Transformations and DTPs.
• Proficient in Data Extraction from SAP R/3 FI/CO, MM, SD, PM and QM , flat files and BW using extraction structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors.
• Expertise in the front end business warehouse components like BEx analyzer, Query designer, Web Application Designer, Web Reports, WEBI, Xcelsius and Dash Boards.
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Extensively used Calculations, Variables, Prompts, Sorted inputs, Drill down, slice and Dice, Alerts for creating Business objects reports.
• Good exposure and knowledge of SAP modules such as FICO, CRM, HR, MM, PP, SD.
• Excellent in creating WEBI reports and Crystal reports and deploying them through Info view with BW universe as source and creating Inventory accuracy dash boards using Xcelsius.
• Expertise in designing, developing and deploying using Universe designer, web intelligence, desktop intelligence, info view, CMC, Workbooks.
• Extensive experience in creating reports with Charts bar chart, Pie chart...etc , cross tabs and sub reports.
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key businesses and enabled dynamic report linking by passing variables prompts between reports.
• Strong experience with resolving performance issues in crystal reports and excellent with unit testing, system integration testing, and user acceptance testing at various levels.
• Excellent team player with good logical reasoning ability, coordination and interpersonal skills.
• Solid communication skills have always been an asset in completing business venture and projects with success.

Skills

• Primary Skills: BI 7.3/7.0, BW 3.5/3.1c/3.0b, SAP R/3 ECC 6.0,5.0,4.7E/4.6C
• Secondary Skills: FI/CO, Logistics SD, MM, PP CRM, SRM, QM, HR, SCM, COPA, MS Excel,VBA
• Languages: ABAP/4, C, C ,PL/SQL
• Web Servers: IIS 5.0/6.0/7.0
• Database: SQL Server 2000/2005, Oracle 8i/9i/10g, MySQL, MS ACCESS.
• Operating Systems: Windows 95/98/NT/2000/XP/Vista, Windows 2000/2003 Server, MS-DOS, UNIX, LINUX
• Reporting Tools: BEx Analyzer, Crystal Reports, Xcelsius 2008, WEBI, DESKI, Cognos, BO 4.1
• Dashboards, MS-Excel.

PROFESSIONAL EXPERTISE

Confidential

Role: BI/BO Consultant

Environment: Business Objects XI4.1/XIr3.1, SAP BI 7.3, SD, MM, PP, HR, FI, SAP ECC 6.0, BPC 10, Designer, WebI, Publication Wizard, Import Wizard, Dashboard Manager, Web Intelligence and Info View, HANA, Windows XP, server 2003.

Industry: Confidential is a Japanese public multinational corporation primarily known as a manufacturer of automobiles, motorcycles and power equipment.

Contribution:

• Confidential is the Global Standardization Project implemented in Honda Corporation to bring the entire business on SAP. As a part of the core team, worked very closely with the Business Users.
• Involved in 2 Full Life cycle implementations R 1.0 for Japan and R 2.0 for NA .
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.

Responsibilities:

• Being a Senior BI Consultant, responsible for the development, support maintenance of SAP BI/BW version 7.3 connected to ECC 6.0 system with SAP FI, Logistics Modules and BPC 10.
• Implemented LSA Architecture and maintained design consistency all over the system.
• Extracted data for various data sources from Project Systems, Sales and Distribution, FI-AR, FI-AP, FI-GL, CO-PA data from R/3 to BI.
• Responsible for analysis, design and development of SAP BW backend components and front end reports dashboards.
• Performed backend design, construction and unit testing of backend components ODS, Transactional, Info Objects, InfoCubes, InfoSources/Data Sources, Master Data, Transfer Rules, User Exits, Update Rules to ensure data integrity and optimize system performance. Migrated 3.5 datasources to 7.0 datasources and created custom transformations.
• Widely used some of the SAP BW 7.3 features, such as Semantic Partitioned Objects SPO , Data Flows, Open Hub Destinations and Hybrid Providers. Implemented Dynamic partitioning in SPO using BADI.
• Customized standard business content extractors and performed enhancement of the data sources in various applications using BADI. Using PI/PO, dealt with legacy data.
• Created Interfaces for Data Transformation and Conversions in BPC for both Master Data and Transaction Data.
• Created Staging Cubes for both Finance and Project Systems in BI for BPC Data.
• Automated the both Master and Transaction Data loads from BI to BPC by creating custom process chains for loading into BPC. Created a Delta DM package for Finance Transaction data into BPC.
• Implemented BAPI for the BPC Retraction Process Plan Data to ECC.
• Additionally worked with the Business Objects Financial Consolidation BOFC Team in building the backend process flow in BW.
• Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries, Combined Queries Union, Intersection, Minus .
• Created reports using BusinessObjects Webi, Crystal Reports and other web development tools like Infoview to provide Web-enabled data analysis solutions to business users. Worked on the Universe Designer, Web Intelligence Webi , Web Intelligence Rich Client.
• Created different Business Object reports by merging dimensions for the Universes on Relational DB Connection and BICS Connection.
• Interacted with business to prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW Reporting and applications. Developed End User and Super User training manuals, job aids and presentations.
• Active participated in the Work-Shops and Road Shows performed in all the Honda Plants all over the United States and Japan.
• Develop and drive the implementation of BW best practices and standards for the team. Supported the on boarding and training of BW Power Users.

SAP HANA Developer

Responsibilities

• Conducted Workshops with General Managers and SME's for requirement gathering
• Created Proof of Concepts on SAP HANA Artifacts Analytic and Calculation View for the project

Confidential

Role: BI/BO Consultant

Environment: Business Objects XI4.0/XIr3.1, SAP BI 7.3, SD, MM, PP, HR, FI, SAP ECC 6.0, Crystal Reports XIR2/2008, Xcelsius 2008, Designer, WebI, Publication Wizard, Import Wizard, Dashboard Manager, Web Intelligence and Info View, HANA, Windows XP, server 2003.

Industry: Confidential is an independent, non-profit company performing research, development and demonstration in the electricity sector for the benefit of the public.

Contribution:

• Involved in the Full life cycle implementation, right from requirement gathering to Go-live.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Assisted Client's process teams for writing reports and performing Ad hoc Queries.
• Involved in HANA integration and modeling.

Responsibilities:

• Data Extraction from SAP FI, MM, SD, PP and HR of SAP R/3.
• Worked extensively on LO Cockpit. Loaded the data from R/3 to BW and used Initialization with Delta Update and Full Update methods.
• Involved in Activating Business Content for Standard Info Cubes, ODS objects, Info Sources and Info Objects of FI, SD and MM module.
• Worked with Info Cubes like Sales Overview, Delivery Services, purchase order and Info Sources like Sales Order and Delivery.
• Created BW Objects, Update rules and Info Packages, Data Targets and Multi providers in accordance to the application.
• Involved in building logistics reports and applying functions based on requirements.
• Built and distributed functional specification documents to BO developers and Business users across the organization.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server, MS Access and DB2.
• Interacted with Business users, Business Analysts to understand and document the requirements and transform them into technical specifications.
• Updated and maintained Universes based on changing user requirements and data source changes
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies. Used various functions such as Aggregate aware, prompt, select, LOV's, Index Awareness, Custom Hierarchies etc., in Designer.
• Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries, Combined Queries Union, Intersection, Minus .
• Created dashboards using Xcelsius 2008.
• Used various functions i.e. Select, Prompt, Where in the Designer for different report creation
• Synchronized data from multiple data sources in Web Intelligence
• Created and published various reports through Web Intelligence, Info view portal
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
• Analyzed data using Slice/Dice and Drill Mode
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe
• Analyzed existing database and designed Universe
• Upgraded from 3.5 to BI 7.x.
• Migrated data sources from BW 3.5 to BI 7.x and maintaining Transformations and DTPs.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports as per user requirements. Scheduled recurring daily, weekly and monthly reports.
• Assigned privileges to users and user groups to access and work with universes and reports
• Created templates to standardize the structure of corporate documents.
• Designed and developed Dashboard to provide visibility, alignment and insight across the enterprise.

Confidential

Role: BI/BO Consultant

Environment: SAP BI 7.3, SAP ECC 6.0, SAP BO 4.0/3.1.

Industry: Amgen discovers, develops, manufactures and delivers innovative human therapeutics. It is biotechnology Pioneer since1980.

Contribution:

• Full life cycle implementation, which involve Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Worked along with the Clients process teams in identifying and documenting necessary KPI and reporting requirements to build a reporting architecture.

Modeling:

• Built and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set.
• Data Source Objects are created for staging for AP, AR line item data, multi cubes and Infosets are created to satisfy reporting requirements.
• Enhanced CO-PA and FI cubes such as 0FIAR C02, 0FIAR C03, and 0FIAP C03 with proper transfer rules and update rules.
• Activated Business Content for Accounts payable AP , Accounts Receivable AR , Profitability Analysis PA , General Ledger GL , Special Ledger SL , Purchasing MM , Cost Center Accounting CO-CA , CRM activity items cube and customized them as per the client requirement.
• Migrated data sources from BW 3.5 to BI 7.x.
• ABAP programs are used to populate user exit variables. Reporting:
• Integrated BO with SAP ECC and SAP BI 7.3 to build Universes.
• Used BICS connections to make Webi, Analysis for OLAP reports.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Developed Business Objects Universes with classes, objects and condition objects. Hierarchies are implemented to support drill down reports.
• Customized queries using navigational attributes and filters in BEx analyzer and used customer exits as per client requirements.
• Using complex queries reports are created where universe is the main data provider for reporting.
• Several complexes-cross tab reports and sub-reports are published using Crystal Reports and Business Objects Reporter.
• Designed reporting templates with BEx Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition. Designed, developed, performed testing and implemented Crystal Reports, Webi, Xcelsius Dashboards . Cross tab and Drill down options are enabled using Crystal Reports.
• Xcelsius dashboards are created on top of crystal reports and live office. Webi Reports have been created deployed through Info View.
• Worked in QaaWS to create connections between Webi and Xcelsius Dashboards.
• Trouble shooting and tuning of the reports.
• Assisted end users writing reports and performing Ad hoc Queries.

Confidential

Role: Senior SAP BI/BO Consultant

Environment: SAP BI/BW 3.5/7.0, SAP ECC 6.0, FI-AR, FI-AP, FI-GL, FI-SL, MM,SD,MTO, CRM, COPA,SCM, HCM, HR, BEx Analyzer, Query Designer, Open Hub, Xcelsius, WebI, Crystal Reports, WAD.

Contribution:

• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL Extraction, transformation and loading activities like Extraction from Source system, Transformation rules, Data Transfer Process DTP etc.
• Created many complex and customized SD Order to Cash OTC reports which specific business requirements.
• Report development on manufacturing modules like MM, PP, QM and integration experience with FICO.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Migrated data sources from BW 3.5 to BI 7.x and maintaining Transformations and DTPs.
• Designed, developed and implemented Crystal Reports, Webi, Xcelsius Dashboards .

.

Confidential

Role: SAP BI Consultant

Environment: SAP BI-7, SD,MM, FIAR, FIAP, FIGL, HR,SAP R/3 ECC 6.0, Business explorer, Web application designer, Portal, Business Objects XI , Pharmaceutical industry.

Contribution:

• Involved in Production Support stages of the Full lifecycle Project implementation from Blue print to go-live.
• Created multiple BEx Reports based on user requirements in sales, delivery, billing customer analysis Reports.
• Created Web Intelligence reports using Business Objects WEBI.
• Generated the BEx Query reports in crystal report Designer.

Confidential

Role: SAP BI Consultant

Environment: SAP BI-7, SD, FI,HR, SAP R/3 ECC5, Business explorer, Web application designer, Portal, Business Objects and Crystal reports, Retail Industry.

Contribution:

• Developed flexible queries using filters, Free Characteristics, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Fixed and modified the existing reports according to the user enhancements.
• Created Cross-tab, Sub-reports and drill down reports using Crystal reporting tool.
• Used Crystal Xcelsius for Dashboard reporting needs with Query as a Web service as source.

Confidential Role: BW Consultant

Environment: SAP R/3 3.1C, SAP BW 3.5, ABAP/4

Contribution:

• Solution furnished client with capability to track production, order time, utilization, efficiency and attainment by work centers. Orders with an inventory adjustment were also tracked.
• Configured classification extractor to enhance Work Center business content InfoObject.

Confidential

Role: SAP BW Analyst

Environment: SAP R/3 3.1C, SAP BW 3.1C, ABAP/4, Oracle 9i

Contribution:

Designed Physical and Logical data models, Created BW objects InfoSources, InfoObjects, ODS Cubes, InfoSets, MultiProviders, Transfer/update rules and process chains .Created multiple queries for P/L and sales reporting. Defining query in BEx analyzer and presenting the result in workbook and integrating the workbook with BEx Browser.