SUMMARY:

• I am working in BI Analyticsusing HANA SP 7,9,11, SAP BW 3.5/BI 7.0/BI 7.1/BI 7.3/BI 7.4 and BO (4.2 and XI 3.1) tools for over 10 years with various clients of different verticals like Manufacturing, Chemicals, Pharmacy, Retail, Products, Telecom etc. I haveexperience in Modeling,Query Designing and Query
• Reporting, creating WAD dashboards, Universe building, Data Foundation, IDT, WEBI Reports, Live office, Crystal, CMC, Xcelcius, Lumira, Design Studio, Analysis for Office etc. I have been trained and certified on SAP HANA and have data modeling experience with SAP BW on HANA, HANA Live and SAP HANAStudio application with experience on SLT, DXC, System Configuration, Schema Creation, Attribute views, Calculation views, Analytical Views, User Security, Privileges, Role creation, ODATA Services,BI HANA data extraction HANA Web application service and exposing HANA Applications to Cloud platform. I have worked and led teams during cutover and change management activities and creation of organization wide static and audio visual s.
• Experienced HANA studio data modeler including initial setup, creating attribute, calculation and analytical views, data base schemas, user/role creation, security,Analytic privileges, user integration services, SQL script,SLT,DXC,SDA
• Data/Object Modeling for Design, Development and Deployment of standard and custom BW, BW on HANA, HANAStudio Side car and HANA Live views and solutionmodels.
• Experience in data modeling for Finance New GL, Parallel Ledger Extraction, Accounts Payable, Accounts Receivable, Controlling, Profit Center Accounting, Asset Accounting,ECCS(Consolidation), Sales and Delivery, Human Resources, Purchasing,Production Planning, Plant Management, Quality Management,Inventory,SRM, APO, CRM, EC etc.
• Development using Business Objects4.2,4.1,4.0, XI R3.1/R2/R1/6.5,CMC, Designer, Desktop Intelligence, Live Office, Info view, Web - Intelligence XI/6.x, Auditor, Crystal Reports, Lumira Story Boards, Xcelsius 4.5/3.5, Design Studio
• SAP BW 3.5/BI 7.X, Integration with SAP ECC/BI/BW,Non SAP DB( Oracle,Teradata,DB2),Xcelsius Dashboards on SAP ECC/BI/BW, Explorer on BWA and Universe Designing (Relational & OLAP), IDT.
• Experience with defect tracking and creating test scripts and execution with HP ALM and Quality Center
• SAP trained and certified in SAP HANA SP9 application development.
• SAP trained and certified in SAP BO4.0 platform development and innovation.
• Delivered speaker sessions at SAP Tech-Ed on SAP Live office and Data services and authored various articles on SDN for various BI and BO methodologies.
• Strong experience in creating and delivering organization wide SAP s in SAP BW and BO domains.
• Won various s and accreditations for content development and delivery across Accenture
• 10years of experience in Business Intelligence using SAPBusinessObjectsBusiness Intelligence 4.1, SAP BusinessObjects Enterprise 3.1/R2, with InfoView, Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, Crystal Reports, Xcelsius, Lumira Storyboards, Central Management Console (CMC), Query as a Web Service(QaaWS), Live Office,Publishing Wizard, Import Wizard, Promotion Management, Design Studio, and Report Conversion Tool.
• Strong domain knowledge of Manufacturing,Chemicals, Retail, Public sector Pharmacy,Oil and gas,Telecom and Communication Industry.
• Experienced working on SAP HANA Data provisioning with SAP LT Replication Server (SLT), Data Services, Direct Extractor(DXC),SDA,Cockpit Functions for table filters & maintain table IUUC REPL CONT on LT server
• Experience in SAP HANA data modeling using HANA Studio, creation of Attribute Views, Analytical Views and Calculation Views(Graphical and SQL based), Analytic Privileges, SQL Scripts and Stored Procedures.
• Experience with HANA Live and HANA Sidecar Modeling scenarios, creation of virtual data models, enhancement and deployment of Query Views, Reuse Views and Private Views, design prompts & variables.
• Experience with currency translation and unit conversion in HANA, complex SQL scripts in calculation views
• Experience with creating Requirement gathering, Functional Designs, Technical Designs & Testing Documents.
• Expertise working in all phases of SDLC Life Cycle(Waterfall, Agile etc).
• Experience in Installation and Configuration of Business Objects server and client tools, Creation of repositories, license keys and security configurations. Performance tuning and optimization of BI solutions including capacity planning, migration procedures, and usage analysis.
• Experience with BW on HANA Data modeling in both ABAP and eclipse modeling environments, creation of ODS Views, Advanced DSO’s, Composite providers, Direct Content Extractors, BW HANA Views etc.
• Expertise on OLTP extractions from SAP R/3 for various modulestools such as FI/CO,FM, APO, SD, MM, HR, SCM, SRM, PP, PM,IS Utilities, CRM, SRM and SCM using LO Cockpit, CO-PA, LIS, Generic Extractors and non-SAP R/3 extractions like Teradata using DB connect, UD Connect and also extracting data using data services.
• Expertise in business warehouse components - Semantic Partion Objects, Composite providers, Advance Data Store Objects, Standard and Custom Info Cubes, DSO’s, Multiproviders, Info sets, Info packages, DTP’s and Transformations, ABAP Routines, Process Chains, APD’s, Process Chain email etc.
• Expertise in Data extraction, Modeling and Reporting of data from Non SAP source systems namely( Oracle,Teradata,DB2,SQL)and work with synchronization issues and data quality for multiple data providers.
• Technical hands-on expertise using OLAP tool Business Objects XI R2/XI 3.1/BI 4.0/ BI 4.1/BI 4.2(IDT,Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, Central Management Console, Designer, InfoView, Explorer, Xcelsius, Design Studio, Lumira Storyboards, Crystal Reports,Analysis for Office etc).
• Creation of Data foundation using IDT, designing universes on top of SAP and non-SAP data bases, creating stored procedures and free hand SQL.
• Good knowledge of multi-dimensional data modeling and web reporting features of data warehouses.
• Debug and address the performance tuning issues from the server and backend side for BW, BO and HANA .
• Created the reports using Crystal Reports functionalities like Add Queries (Command), Open Documents, Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Published Crystal Reports using Publishing wizard on to Info view and provided access to the end users.
• Expertise in using Delivery Units, Import Wizard,LCMand Promotion management, TMSto migrate ABAP,HANA Models and BO reports and models between different environments like development, testing and production.
• Created various Xcelcius and Design Studio Dashboards and Scorecards in Finance, Sales, Inventory, Quality Management, and Plant Maintenance domain utilizing various connections namely BICS, Live Office,QaaWs.
• SAP BO Mobile dashboards, scorecards and reports for various reporting metrics.
• Change management activities creating SAP user guides and audio visual documents and videos.
• Managed/Led On-Shore and Off-Shore Teams, led SCRUM meetings for successful SAP solution delivery.

TECHNICAL SKILLS:

BI tools: SAP BusinessObjectsand Business Intelligence7.0/7.1/7.3, Business Explorer, Web Application Designer, SAP BusinessObjects Enterprise XI 3.1 /R2, BI 4.1, Web Intelligence, Universe Designer, IDT, Desktop Intelligence, Infoview, Web Intelligence Rich client, Report Conversion Tool, Query Builder, CMC, QaaWS, SAP Crystal Reports, Crystal Enterprise, Xcelsius,Design Studio, BO Mobile, Import Wizard, Dashboards and Live Office.

Products: SAP ECC 6.x, BOBJ, SAP BI/BW 7.x,HANA Live, Microsoft Office, Camstasia studio

Data ModelingPhysical and Logical Data Modeling.

Project tools: MS Office Suite, MS Visio, MS Project.

Languages: ABAP,SQL, C, C++

PROFESSIONAL EXPERIENCE:

Confidential, Mosaic, FL

Lead SAP BW HANA/BO Architect

Responsibilities:

• Gathered HANA Modeling Requirements for various functional areas namely Finance (AP,AR,COPA,COetc), SD( Order, Delivery, Billing), Procurement, Production Planning, Inventory Reconciliation etc.
• Designed end to end KPI’s for Financial reporting related to Balance Sheet, Trial Balance, Payments, DSO, DPO, Invoice Processing, Accounts Payable and Accounts Receivable aging, COPA, Auditing etc.
• Determine the SOW of the Project, Time estimation and Project plan initiation and Kick off.
• Designed and developed master data change tracking reports using CDPOS and CDHDR tables.
• Worked on Complex information models creation of Attribute Views Dimensions, Analytic Views and Calculation views utilizing both Graphical and SQL Script functions using complex join and logic.
• Worked on creation of time-dependent data models and extraction of time dependent data in BOBJ.
• Worked on implementation of SAP HANA hierarchy’s (parent child and flat hierarchies), Procedures, currency conversion, and analytical privileges.
• Worked on creation of Fiscal and Calendar Time dimension Tables using stored procedures.
• Worked on Scripted calculation Views using CE functions to push down calculations into sap hana engine.
• Worked on performance improvement of HANA models by Join Optimization, Code Pushdown & Modeling.
• Creation of Packages and Schemas and Catalog data replication from various SAP and NON SAP data sources using SLT configuration& data type mapping for non-sap sources also,Data Provisioning using Data Services
• Migrated HANA content from Development, Testing environments to Production environment using HANA Lifecycle Management (HLM)..
• Using BODS designer to create source definitions, design targets, create jobs and developTransformations.
• Designed WebiInteractive reportswith complex formatting and WEBI dashboards using drill through and drill across methodologies.
• Experience in Designing Complex Universes in IDT based on HANA Tables and HANA Views.
• Designed and created Design StudioDashboards and Lumira Storyboards for Finance GL, CO, SD& PP.
• Responsible for overall delivery of Project and Tracking delivery of work to ensure timely delivery
• Daily and weekly status updates to the Management, Client engagement leads and PMO

Environment: SAP HANASP11, BO 4.2(WEBI, Crystal Reports), Design Studio, SAP Lumira, BO Mobile, Business Objects Analysis

Confidential, OH

Lead SAP BW HANA/BOArchitect

Responsibilities:

• Requirement Gathering Matrix, Functional Design and technical Design Creation of models and KPI’s related to Production Planning, Plant Maintenance,Quality, Finance, Inventory, Sales, Delivery, Billing etc.
• Completely manage Reporting tool identification and system installation strategy for Confidential Metallurgical.
• Worked on design and delivery of month end reporting, audit reports and new company merger reports.
• Initial System setup and testing of SAP BW on HANA and BO systems. Includes parameter configuration, RFC setup, SP identification and coordination between BW, HANA and Basis teams.
• Worked on HANA modeling in both ABAP and Eclipse perspectives.
• Creation of Project, Package Deployment and Schema creation for BW source system connection.
• Importing BW Models in to HANA using eclipse and designing of attribute, analytic & calculation views.
• Design, Development and Implementation of ODS Views, Advanced Data Store Objects, Composite providers, HANA Optimized Extractors, Info Cubes, DSO’s and Semantic Partition Objects
• Data Modeling of Advance Data store Objects and ODS views using eclipsetools.
• Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.
• Migrating standard Info Cubes to In memory optimized Info Cubes using migration Tool.
• Integrating various third party systems with SAP BI and data cleansing of master and transactional data and SAP HANA data extraction from SAP BW/SAP-ECC/Non-SAP(Oracle) Data sources using SLT and DXC.
• Configuration of Direct extractor connection in BW and monitoring of new operational data queues.
• Performance tuning and troubleshooting of HANA views &BO reports, monitoring dashboards &metrics.
• ABAP routines for end routines start routines and user exits for data massaging across functional areas.
• Designing of data provisioning method for near line and cache storage for real time data reporting.
• Worked on design and implementation of row level data security for financial reporting using proviliges.
• Setup of testing process for client and creation of test scripts and strategy for UTand UAT cycles.
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created C levelProduction Planning, CAPEX, Maintenance and Sales dashboards using design studio.
• Created WEBI, Crystal Reports and Lumira Storyboards objects by retrieving the data from HANA views and data foundation layer using IDT.
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business and applied advanced functionality to dashboards (gauges, sliders, and maps) and created interactive business calculators with Design Studio
• Mobile Server configuration and creation of Mobile specific analytics WEBI and Design Studio reports.
• Conducted End User sessions for WEBI, Analysis Office,Lumira,CrystalReports and Dashboards.

Environment: SAP BI HANA 7.3,Business Explorer Tools,BO 4.1(WEBI, Crystal Reports), Design Studio, SAP Lumira, BO Mobile, Business Objects Analysis

Confidential, KC

Lead SAP BI/HANA Architect

Responsibilities:

• Analyzed the business requirements and translated into data models including technical specifications.
• Development of reporting for HANA Live in sidecar scenario, working extensively on the Modeling, Data Replication of HANA Attribute, Analytic and Calculation views for operational reporting on GL, COPA,CCA,Purchasing, Material Ledger, Sales, Delivery and Billing.
• Worked on creation and enhancement of HANA virtual data models, Query, Reuse and Private Views.
• SAP HANA Data Provisioning, configuration and monitoring using SAP LT Replication Server (SLT) and DXC.
• Creation of table filters &field selections for data replication using LT cockpit and table IUUC REPL CONT.
• Creation of in memory calculation views using SQL script and Calculation Engine (CE) Functions.
• HANA Studio Modeling and Creation of scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies, prompts and variables.
• Implement and maintain Currency and Unit translation in HANA data models.
• Create and Grant Analytic privileges, maintain data restrictions and users in SAP HANA landscape.
• Testing and debugging of HANA data models using XS system browser.
• Creation of Delivery Units and creation of transports for migrating HANA packages, models and views.
• Integrating various third party systems within HANA and data cleansing of master and transactional data.
• Understanding of SAP In-Memory Computing Architecture, Column and Row store tables in SAP HANA.
• Created testing strategy for UT, SIT and UAT cycles.
• Creation of data validation / audit reports between HANA Live,ECC and EDW systems.
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Server-side parameter configuration and maintenance for optimum performance of BO reporting tools.
• Created Financial, Sales and Quality dashboards for various KPI’s in Finance and Sales domain.
• Created Data Foundation layer using IDT, Universes, classes, WEBI, Analysis for Office, Crystal Reports and Lumira Storyboards by retrieving the data from HANA views
• Creation of BO security roles, User management and design publications for WEBI and crystal reports.
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business and applied advanced functionality to dashboards (gauges, sliders, and maps) and created interactive business calculators with Xcelsius
• Conducted User sessions and creation of audio visual aids for end client team.
• Handled On site - Off shore Model and handled a team of sixconsultants and analysts, assigned work direction to consultants and lower level analysts

Environment: SAP BI 7.3,HANA Live, SLT,BO 4.1(WEBI, Crystal Reports,Lumira, XcelciusDashboards)

Confidential, NJ

Lead SAP BI/BOLead Consultant

Responsibilities:

• Interaction with business users and functional team members for requirement gathering, functional design, and technical design for SAP BI Clinical Supply Module.
• Enhanced existing dataSources to include the custom fields in extract structures and used user exits to populate the data.
• Working on creating Bex reports for various KPI’s namely Sales, COGS, Margin, Profitability Statements, Income Statement, Balance Sheet, Asset Accounting, Internal Orders, Accrual Recurring budgets, Sales by region, Budget Availability etc.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
• ABAP routines for end routines start routines and user exits for data consolidation across areas.
• Responsible for Design, Development and Implementation of Multi Cubes, Info Cubes, and Data Store Objects.
• Worked on various generic, LO cockpit and custom data sources namely 0FI GL 14, 0FI GL 10, 0FI AR 4, 0FI AP 4, 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 03 BF,, 2LIS 12 VCITM,, 2LIS 13 VDITM
• Identified and developed new Queries in BI.
• Created Process Chains to automate the data load and data target administration.
• Creation of APD’s to upload data into Direct Update DSO’s for implementing snapshot scenario
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider
• Used SAP Data Services(BODS), created transformations and mappings from Oracle DB) to perform master data cleansing and consolidating master data in SAP BI system.
• Conducted sessions with relevant teams for NW Portal Integration, OS, BackUp& DR Strategies
• Maintaining SOX compliance of SAP system for system audit purpose

Environment: ECC 6.0, SAP BI 7.1, Business Explorer Tools, Crystal Reports

Confidential, WA

Lead SAP BIHR Architect

Responsibilities:

• Analyze and configure BI 7.3 data environment to facilitate custom reporting and data analytics solutions.
• Build data model and reports for HR and Finance functional area namely Personnel Admin, Basic Pay time, Time Management, Quota Management, General Ledger, Accounts Payable, Accounts Receivable, Funds Management etc.
• Build and Implement HR structural authorizations to implement workcenter based security authorization.
• Analysis and build of hybrid providers, sematic partitions, process chains, data source enhancement using BADI, Bex queries etc.
• Create functional and technical design anddevelop HR,MM,FIBex queries for CognosBI reporting solution
• Analysis and build of hybrid providers, sematic partitioned objects, process chains, data source enhancement using BADI, Bex queries etc.
• Worked on activating and enhancing the SAP content data sources, data flows for Human Resources (0HR PA 0, 0HR PA 1, 0HR PA PA 1) Management (0PU IS PS 43, 0PU IS PS 31,0PU IS PS 33) .
• Created cross functional reports for management for headcount, payroll and time management KPI s and various financial reports for profitability, income statement, gross margin, Act - budget comparison reports etc.
• Selective Deletion program to cater to data loading from info type PA001 for headcount and personnel admin
• Lead onshore reporting team, tracking progress and status reporting along with liaising with offshore teams to ensure timely delivery of various BI deliverables.
• Extensively used MS Project, Visio, Access, Pivot Tables to create report project metrics to the leadership team.
• Perform performance tuning of, Finance(0FI GL 14, 0FI GL 10, 0FI AR 4, 0FI AP 4, 0FI AA 11), Inventory (2LIS 03 BX, 2LIS 03 BF),FundsManagement SAP BI reports and data loads.
• Involved in designing and implementing user security at query level and cube level.
• Legacy data extraction from teradata database and master data harmonization into SAP BW.
• Manage BI Transports and testing system preparation
• Evaluated BO 4.0 HR, FI and IM reporting (WEBI and Crystal reports 2011) using BICS connectivity
• Built User exits for all the applicable applications using CMOD to populate the data in variables
• Liaise and manage BI and Cognos Reporting Team.
• Maintaining SOX compliance of SAP system for system audit purpose.

Environment: SAPBI 7.3,BEx Query Designer, Cognos frame work manager and BO 4.0 reporting

Confidential, IL

Lead SAP BI/BO Architect

Responsibilities:

• Analyze and configure BW/BI 7.0 data environment to facilitate custom reporting and data analytics solutions.
• Worked on design, creation and delivery of consolidated reporting platform for CF and Terra post - merger.
  • Lead BI team during agile methodology development and ensure on time delivery of over 50 BI reports in 3 months using Agile methodologies. Worked on status tracking and co-ordinations between various testing, build and business teams utilizing scrum methodologies to ensure on time go live of BI project.
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master DataTransformations and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains, User Exits etc.
• Interact with business to gather requirements, prioritize work, develop enhancements to the existing systemcoordinate testing, and perform change management/ for BW Reporting and applications.
• Develop and drive the implementation of BW best practices and standards for the team.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Created Process chains for effective scheduling of various processes.
• Worked extensively on Business Objects XI 3.1, and BO4.0 and Web Intelligence reports using UNV and BICS.
• Created and maintained Business Objects reports in Web Intelligence Info View.
• Designed and developed standard reports, jump queries, cross-tab reports and hierarchical drill down reports.
• Used Central Management Console of Business Objects Enterprise to maintain reports scheduling tasks.
• Created queries and reports, Web Intelligence (Web I) documents in Info View and created Web Intelligence
• (Web I) reports on top of the Universes created using the Designer and IDT and using multi source universes.
  • WritingSQL queries and creating stored procedures in Oracle EDW system and creation of relational BO universe to create consolidated Income Statements, PL and Balance Sheet for Confidential .
• Central Management Console of Business Objects Enterprise to maintain reports scheduling tasks.
• Created Finance and Sales Xcelsius Dashboards using direct SAP connection and Qaaws

Environment: SAPBI 7.0,7.3, Business Objects XI 3.1, 4.0Web Intelligence, Xcelsius 2008, BEx Query Designer

Confidential, FL

Senior SAP BW/BI/BO Consultant

Responsibilities:

• Interacted with the project team and end users for designing the data models including functional specs.
• Analyzed the business requirements and translated into data models including technical specifications.
• Worked extensively in the Data Modeling of FI Info Cubes.
• Enhanced and the DataSources to include the custom fields in extract structures and used user exits to populate the data.
• Created new Data Sources for FI-GL,AP, AR, Consolidations, Controlling, Assets, and Funds Management.
• Working on creating Bex reports for various KPI’s namely Sales, COGS, Margin, Profitability Statements, Income Statement, Balance Sheet, Asset Accounting, Internal Orders, Accrual Recurring budgets, Sales by region, Budget Availability etc.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
• Responsible for Design, Development and Implementation of Multi Cubes, Info Cubes, and Data Store Objects.
• Worked on various data sources namely 0FI GL 14, 0FI GL 10, 0FI AR 4, 0FI AP 4, 0FI AA 11, 0CO OM OPA 1, 0CO OM CCA 20, e 0PU IS PS 43, 0PU IS PS 31, 0PU IS PS 33
• Managed and monitored data loads with full update and delta mechanism and optimized the performance by adjusting packet size and data selections
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created inventory accuracy Dash Boards (Xcelcius) and for management reports for inventory management and wages and costs report from cost center accounting.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider
• Created universes, classes, WEBI, Crystal Reports and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business and applied advanced functionality to dashboards (gauges, sliders, and maps) and created interactive business calculators with Xcelsius
• Created Analysis for Office workbooks as a replacement for BEx Workbooks
• Used SAP Data Services(BODS), created transformations and mappings) to perform master data cleansing and improve data quality in SAP BI system.
• Conducted User sessions with existing BEx End Users for Analysis for Office
• Created few WebI Reports for existing BEx Reports & Web Templates
• Conducted sessions with relevant teams for NW Portal Integration, OS, BackUp& DR Strategies
• Getting rid of BEx Web Templates by Analysis for OLAP
• Generated several Reports using BO Universe as data provider against multiple data providers
• Maintaining SOX compliance of SAP system for system audit purpose

Environment: ECC 6.0, SAP BI 7.1, BEx, Business Objects (WEBI, Universe,Advance Analytics,Xcelcius)

Goldshield

SAP BOBJ Developer

Responsibilities:

• Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
• Activated the Business Content for Accounts payable (AP), Accounts Receivable (AR), CostCenterAccounting(CO-CA), Supplier Relationship Management and customizing them as per client’s requirement.
• Created Generic extractors using Info set queries.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multiprovider, 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), Open Hub service etc.
• Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C03, and ODS such as 0FIAR O03, and 0FIAP O03 with proper transfer rules and update rules.
• Implemented SRM standard data flows for Purchasing Contracts and Shopping Carts using data sources namely 0BBP TD CONTR 2, 0BBP TD SC 1 and standard DSO’s 0PSSC D1, 0PSCTR D1
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Created Daily Sales Reports which involves Daily Sales Orders, Order Reasons, Customer Group and other important sales data.
• Created Universes over BEx queries and Info cubes of SAP BI using Universe Designer.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Customized LOVs in Universes for quicker performance of reports.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as iView.
• Extensively Worked in SAP Live Office to create connections between WEBI and Xcelsius Dashboards.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Developed performance testing on all application servers.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.

Environment: SAP NetWeaver 2004s BI 7.0, ECC 6.0, Business Explorer, HR, SD, FI-CO, ABAP,BOXI 3.1

Confidential

SAP Business Intelligence/BO Designer

Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• To understand the new SAP EC module which has been developed by Techni data and SAP and then support the SAP-EC solution.
• Develop New Classifier Types and Values and Map them to the EC system
• Worked on LO-Cockpit Extraction and customized extractors.
• Expertise in DataSource Enhancement, User Exits, Loading, Scheduling, Monitoring, Process Chains, Open Hub Service, Authorizations, User Profile Maintenance, Reporting Agent, Enterprise Portal Integration, Information Broadcasting and alert monitor.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Built User exits for all the applicable applications using CMOD to populate the data from the respective application tables
• Performed analysis, design, development and implementation of standard/customized InfoCubes and DSO Objects for SD, FI and SCM modules.
• Evaluated statistical performance using BW Statistics for optimization. Improved data load and query performance by using BI Accelerator (BIA), Compression, Aggregates, Indexes, optimizing Data packet size.
• Involved in designing and implementing user security at query level and cube level.
• Developed Universes using SAP BI/BW Queries as Source Data.
• Experienced with Xcelsius Content Management solution, Crystal Reports, Business Objects XI (Premium, Metadata Mgmt.), Business Objects Data Services and Objects Xcelsius Enterprise.
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as Source.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created reports using having Alerter, Ranking, Multiple contexts, custom built Hierarchies, Multiple sorts, filters and reports having complex formulae and logic.
• Created reports like, Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports.

Environment: SAP Environment Compliance, BI 7.0, ECC 6.0, Business Explorer, HR, SD, FI-CO, ABAP,BOXI 3.1

Confidential, NJ

SAP Business Intelligence developer

Responsibilities:

• Actively involved in the requirement analysis, data modeling and technical implementation
• Worked extensively in the finance modules like FI-AR (Accounts Receivable), FI-AP (Accounts Payable) and FI-GL (General Ledger).
• Installed Business content for FI-GL, FI-AR and FI-AP business content cubes according to the business requirement.
• Created ODS, Infocubes, MultiProviders, Infosets, Infosources, Transfer Rules, Update Rules and Infopackages.
• Created master data InfoSources for uploading attributes, texts and hierarchies.
• Created InfoCubes such as 0FIGL C01 for GL line item data and 0FIAP C01 for the AP line item data. Involved in the maintenance of the InfoCube
• Worked on the enhancement of the business content data sources by using append structures and user exits
• Experience in modeling and implementation of InfoObjects which include Characteristics, key figures, update/transfer rules, transfer/update routines, planning and implementing init/delta loads for master data and transaction data.
• Created start routines and end routine in transformations to update characteristics and key figures in InfoCubes.
• Created process chains for periodic upload of master data and transactional data and monitored data loads with delta update and full update mechanisms.
• Created complex BEx queries on InfoCubes as per the client requirement.

Environment: SAP BI 7.0, ECC 6.0, Business Explorer SD, FI-CO, ABAP

Confidential

SAP Business Intelligence Developer

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing to go live and production support.
• Developed BI solutions such as data models, information objects and info cubes for projects to fulfill business needs and requirements.
• Involved in complete life cycle implementation of SAP BI in SD and FI modules.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Worked extensively with LO Cockpit structures such as 2LIS 13 VDHDR, 2LIS 11 V ITM, 2LIS 11 VAITM and 2LIS 13 VDITM.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement.
• Content development for RTR, OTC and HR work streams.
• Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes; coding in start routines and end routines.
• Created process-chains to automate the Data Loads, Rollups into Aggregates, Creating and Deleting indexes to improve Load performance.
• Established standards, reusable data models and best practices for designing information cubes and objects for BI/BW landscapes.
• Developed flexible queries using filters and navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized fashion and also created Calculated and Restricted Key Figures, Structures, Conditions and Cell Definitions within queries, maintained Query settings Integrated and extracted data into BO Crystal Reports to generate reports from SAP BI system.
• Created financial reports, charts using Universes as the main data provider and reports such as Quarterly variance, Regional, Actual vs. Forecast, Balance sheets etc were developed.

Environment: SAP BI 7.0, ECC 6.0, Business Explorer

Confidential

SAP BW Programmer

Responsibilities:

• Developed BI solutions such as data models, information objects and info cubes for projects to fulfill business needs and requirements.
• Involved in complete life cycle implementation of SAP BI modules.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Content development for RTR, OTC and HR work streams.
• Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes; coding in start routines and end routines.
• Created process-chains to automate the Data Loads, Rollups into Aggregates, Creating and Deleting indexes to improve Load performance.
• Established standards, reusable data models and best practices for designing information cubes and objects for BI/BW landscapes.
• Developed flexible queries using filters and navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized fashion and also created Calculated and Restricted Key Figures, Structures, Conditions and Cell Definitions within queries, maintained Query settings Integrated
• Data testing using HP Quality testing tools including creation of test labs, scripts etc.

Environment: SAP BW 3.5, ECC 4.0, Business Explorer