EXECUTIVE SUMMARY:

• Around 10 years of experience in SAP BI/BW/BOBJ including 4 years working as Lead consultant.
• Experience of working on different stages of BI - requirements gathering, project estimation, requirements determination, gap analysis, business process reengineering, issue resolution, configuration, training, go-live assistance and post implementation support
• Worked on APO DP for SAP BI.
• Have the exposure on Enterprise portal on publishing the reports.
• Trained in SAP HANA by SAP Lab
• Have worked extensively in Data Modeling, Data Analysis, Application Monitoring and Performance Tuning
• Have the ability t learn new Technologies and Business Process, and apply them where appropriate.
• Proven experience in analytics, Problem solving
• Self motivated, keen learner and team player
• Excellent communication verbal, written
• Experience of working in global environment APAC, EMEA and USA
• Ability to work independently with minimum guidance and easily adapt to changes
• Adept in Accelerated SAP Methodology covering entire project life cycle from concept through production.

Technical skills:

• Data warehouse / DWH : BI 7.31, BI 7.0, BW 3.5
• SAP R/3 Versions : ECC 6.0,4.6C
• SAP Extraction Modules : SD LO , IM, FI-CO, CO-PA, APO
• Reporting Tools/Designing tools : WAD, BOBJ WEBI, DashBOBJards, BEx Analyzer
• Database and Tools : Oracle 8i, HANA 1.x
• Operating Systems : Windows XP/2000/2003/NT 4.0/98/95 AIX
• Application Programs : MS Word, MS Excel, MS Power Point etc.

Skills:

• Business Object BOBJBJ
• Worked on Design Studi and Dashboards Xcelsius .
• Worked on Business Objects data Integrator Administrator for scheduling the jobs
• Used data flow, work flow, Conditions, scripts etc.
• Used Query transformation, Map Operation, Row generation, Merge Operation etc
• Worked on Data Integrator BOBJDS for populating the data's from source table to target table
• Worked on Web Intelligence reporting for generating reports based on the customer needs.
• Worked on BI Mobile for integrating reports based on the customer needs.
• SQL Skills:
• Used SQL commands during executing the query transformation in BOBJ DI.
• Used Toad for executing the SQL commands.
• Used group by, order by functions etc.
• Used join conditions t link the tables in order t fetch the data.
• Worked on creating tables, updating tables, Inserting and deleting records.
• Business Intelligence/Business Warehouse:
• Data Extraction:
• Installed Standard data sources from Business content data sources.
• Filling up of setup table, scheduling of data extraction int queue table using job control.
• Used unserialized V3 delta for Billing and Sales order standard data sources.
• Extracted data using LO extraction cock-pit, Generic data sources, FICO, COPA etc.
• Transport of Data sources t Production landscape.
• Replication of Data sources, transporting data sources.
• Creation of Info packages for full, init and delta update
• Scheduling of info packages
• Data Modeling:
• Installing Standard Infocubes, Data Store Objects, Infoobjects, Infosources, Transfer rules and Update rules from BI content repository.
• Creation of Custom Infoobjects, Infocube, DSO, Multiproviders, Transformations, Data Transfer process.
• Writing of Basic transformation routines, formulas, and Master data lookups.
• Created Aggregates for infocubes, Rollup and compression activities.
• Query Designing:
• Worked on Semantically portioned Objects.
• Worked on HANA optimized DSO and Cube's.
• Worked on Composite Inf provider, Transient Inf provider and Virtual Inf provider.
• BW on HANA:
• DashBOBJards creation of critical reports based on Functional Specification, defining series, category count on the chart item.
• Grouping of related Bex queries by means of Tab Pages and containers.
• Extensive usage of analysis item, Navigation panes, Filter panes, Drop down list BOBJxes, Map items, Chart items.
• Creation of web application templates t publish the developed queries in enterprise portal.
• Web Template Creation:
• Creation of exceptions, conditions based on business requirements.
• Modification t existing queries as the user requirement changes.
• Created Calculated key figures, restricted key figures, Formulas, selections.
• Creation of Characteristic variables, Text Variables.
• Creation of custom Bex queries based on standard and custom inf providers.
• Understanding the specifications provided by the functional consultants, interacting with end users t know the exact business requirements, suggest them the changes that are required and then develop the objects as per the revised specifications.

HANA Standalone:

• Worked on Attribute View, Analytical View and Calculation using graphical version.
• Worked on Schema creation and Package creation.
• Worked on configuring SLT SAP Landscape Transformation for establishing connection between SAP ERP and HANA system and als utilized data provisioning for loading the data int HANA.
• Worked on SAP Data services t connect SAP source system and Non-SAP source system t HANA and als t load the data int HANA.
• Have knowledge on Smart data access.

PROFESSIONAL EXPERIENCE:

SAP BW/BI/BOBJ Lead Consultant

Description: CONFIDENTIAL

• Technologies is a division of Honeywell Transportation Systems which produces upt nine million turBOBJchargers annually. CONFIDENTIAL
• manufactures turBOBJchargers for applications ranging from small passenger cars t large trucks, as well as industrial equipment, construction machinery and aircraft.

Responsibilities:

• Full life cycle implementation - Requirements gathering, Business Blueprinting, Project realization, Final preparation, and go-Live support
• Requirement finalization with the Customers.
• Created Categories, hyperlinks and incorporated icons for each application from BI Launch pad t BI Mobile.
• Developed System Architect Project management for migration of data and Objects.
• Configured the settings suitable for IOS device t incorporate customer specifications.
• Performed data extraction from LO, FICO, COPA, IM, QM and Generic data sources.
• Replicated the ECC tables using SLT and created the models using HANA Live studi . Generated the relevant reports by utilizing the BOBJ tools.
• Performed ETL activities using SAP BI 7.x, BW 7.31, BOBJDI BOBJDS and created HANA models using Views.
• Created reports for Sales, Finance and ISC and published the same int BI Mobile.
• Linked the PDF reports from BI Portal t BI Launch pad through Knowledge Management content.
• Developed Cost center reporting and different other metrics like Finance dashBOBJard, Team DashBOBJard, etc in SAP BOBJ Web Intelligence with complete self Data management service for users developed by Webdynpr where users can manage their own data without IT interruption.
• Developed the Costing metrics for leadership team for making what- If Analysis using Design studio.
• Generated reports for measuring Unrealized Gain / Loss and Realized Gain / Loss using SAP BOBJ WebI. Created the data model, established OLAP connection from BEx query using IDT Information Design Tool and generated the BOBJ WebI reports.
• Participated in Business user meetings, detailing reports delivered and solving relevant issues.
• Participated conducted status meetings and prepared status reports highlighting key issues and constraints and updating the status of work program items.
• Prepared test cases and performed integration testing for the UAT beneficial.
• Provided post Go-Live support based on the need.

Environment: SAP BW 7.0, BW 7.31, HANA 1.x, Business Objects 4.0 / 4.1, BOBJ Analysis, Web Intelligence, Xcelcius, Design Studi , ABAP, SAP FICO, SD, QM, IM, APO, MSSQL Server, Excel, MS office.

CONFIDENTIAL

SAP BW/BI/BOBJ Lead Consultant

Description:

Technologies is a division of Honeywell Transportation Systems which produces upt nine million turBOBJchargers annually. Honeywell manufactures turBOBJchargers for applications ranging from small passenger cars t large trucks, as well as industrial equipment, construction machinery and aircraft.

Responsibilities

• Evaluated Infrastructure requirement and suggested changes Project activities planning from BASIS, Application and Security team perspective.
• Project monitoring ensuring adhering deadlines.
• Reviewed the Pre Post upgrade activities from BASIS, Application and Security team perspective.
• Budget estimation and statement of work creation.
• Performed pre-upgrade and post-upgrade testing. Resolved the issues that faced during the upgrade.
• Performed BW upgrade from BW 7.01 SP08 t BW 7.31 SP7 for HANA Compatibility.
• Performed BOBJ upgrade from BOBJ 4.0 SP 05 t BOBJ 4.1 SP4.
• Tracked the team t ensure the upgrade completes successfully without any issues.
• Converted the existing BEx WorkBOBJoks available at the server level t BOBJ Analysis workBOBJoks and performed the End t End validation before and after migration t ensure there is n impact.
• Provided training on BOBJ Analysis t the users located globally.
• Participated conducted status meetings and prepared status reports highlighting key issues and constraints and updating the status of work program items.
• Prepared test cases and performed integration testing for the UAT beneficial.

Environment: SAP BW 7.0, BW 7.31, Business Objects 4.0 / 4.1, BOBJ Analysis, Web Intelligence, Xcelcius, Design Studi , SAP FICO, SD, APO, MSSQL Server, Excel, MS office.

CONFIDENTIAL

SAP BW/BI/BOBJ Consultant

Description:

Technologies is a division of Honeywell Transportation Systems which produces upt nine million turBOBJchargers annually. Honeywell manufactures turBOBJchargers for applications ranging from small passenger cars t large trucks, as well as industrial equipment, construction machinery and aircraft.

Responsibilities

• Responsible for reviewing the EWA report and took the necessary actions based on the report. Responsible for planning, coordination of technical environments, process readiness, user setup, transports, configuration dependency and all over Performance improvement of the systems.
• Performed different Performance tuning techniques t control the data inconsistency, volume and lack of rapid reporting executions. Performed performance improvement activities like aggregate creations, cache mode analysis, re-partition, compression, Table Re-org and Archiving.
• Managed Supported support tickets for worldwide customers.
• Monitored Jobs using BI Monitor and Process Chains. Handling tickets and solving issues in the area of Data Extraction from R/3, Flat File, Data Staging and BEx Reporting.
• Performed data extraction and data staging with LO-COCKPIT.
• Handled data Loading for all Modules.
• Created Multi-Providers using Inf Cubes, ODS Objects and Inf Objects, which are useful for Global Reports for all Regions.

Environment: SAP BW 7.0, BW 7.31, Business Objects 4.0 / 4.1, BOBJ Analysis, Web Intelligence, Xcelcius, Design Studi , ABAP, SAP FICO, SD, QM, IM, APO, ISC, MSSQL Server, Excel, MS office.

CONFIDENTIAL

SAP BI Consultant

Description:

Resource Information system HRIS . This is MIS system for HR covers the modules of Employee demographics, Attrition-retention rate, Vacancy Tracker, Recruitment tracker, Employee actions, Employee Competency.

Responsibilities

• Co-ordination between TCS and TAFE, tracking the project, Gap analysis for

Capturing data, Data sources creation, Modeling cubes t meet requirements, Data transfer process and Transformation mapping, developing bex queries, Authorization objects, web application templates development.

• Supported for creating Authorization objects for the relevant aggregate authorization objects for the BEx query t display data.
• Installed and activated the standard BI statistics related content. Faced several challenges on the course of implementing BI statistics.
• Developed BI application usage BEx query on standard Infocube t analyze the user usage.
• Data source Master and Transaction replication, Transferring of data and transporting of objects t production landscape.

Environment: SAP BI 7.0, SAP HR, ABAP, Excel, MS office.

CONFIDENTIAL

SAP BI Consultant

Description: CONFIDENTIAL

information system for Sales and Marketing TIMS . This is a system for Marketing covering all the basic modules relating t marketing such as Retail sales, Channel Funding, Cluster, Forecasting, Market development and Product Promotion.

Responsibilities

• Worked on LO Data sources, Generic data sources.
• Modeled the cubes s as t cater the needs of output MIS reports.
• Created Process chains.
• Created start routine, User Exits.
• Monitored daily data loads and solved the issues.
• Created BEx Map integration using BEx Map facility available in WAD.
• Loaded different files t geographically represent the locations in the map.
• Prepared test cases and performed integration testing for the UAT beneficial.
• Provided post Go-Live support based on the need.

Environment: SAP BI 7.0, SAP SD, ABAP, Excel, MS office.

CONFIDENTIAL

SAP BW/BI Consultant

Description: It is one of the largest and longest-established independent SAP Consultancies.

Responsibilities

• Involved in the design, development of Inf Cubes, Multiprovider, Operational Data Store ODS , Aggregates, Inf Objects, Data Sources, Inf Sources, Inf Providers, Transfer rules, Update rules, and generic data sources.
• Worked extensively on LO Cockpit extractions loaded the data from R/3 t BW and used Initialization with delta update and full update methods.
• Extensively worked on utilizing PSA for effective loads and Error Handling.
• Created Queries, Web Templates and WorkBOBJoks using BEx Tools t facilitate Reporting needs of the Users.
• Configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workBOBJoks.
• Involved in Enhancement activities Data Source, DSO and Cube .
• Involved in creating inf objects.
• Written routines in the transformation.
• Involved in customization and enhancements of Reports.
• Designed and developed various Data targets and Inf providers like ODS, Inf cubes, Inf objects and Multiprovider in BI 7.0.
• Involved in designing and customizing technical speciation and end user documents.

Environment: SAP BW 3.x, BI 7.0, ABAP, SAP FICO, SD, QM, IM, APO, ISC, MSSQL Server, Excel, MS office.