PROFESSIONAL PROFILE:

• Meticulous experience of 9 years in IT industry as a Senior SAP BI/BW, BOBJ and HANA Consultant involved in business requirements gathering, Design, Analysis, Coding, Development, Enhancements, Cutover and Testing with specialization in Warehousing techniques including data extraction, transformation and loading.Involved in all phases of software development life cycles including QA/QC activities. Possesses good verbal and interpersonal skills and a quick learner.
• SAP BI/BW consultant with 4 full-life cycle implementations and BW development experiences in fortune 500 companies.
• Strong experience in SAP Business Intelligence 7.4/7.3/7.0/3.5.
• Extensive experience in developing data models in HANA 1.0 SP2/SP7 8
• Strong experience in Business Objects 4.1/4.0/XI 3.1/XIR2.
• Strong experience in Data Warehousing, Business Intelligence concepts implementation.
• Experience in Five complete life cycle implementations in various industries for SD, MM, PP SCM , HR, CO and enhancements with CO-PA, FI-GL and followed ASAP methodology.
• Experience in supporting SD, MM, PP, HR, CO-PA, FI-GL , CO data.
• Expertise with Multi-Dimensional Model and Star Schema in SAP BW and Administration of BI/BW development Workbench RSA1 .
• Exclusive Experience in SAP BW connectivity with Universe Designer and Business objects Infoview using the SAP Integration Kit
• Strong Knowledge and Experience in Business Objects tools SAP Business Objects from 2007.
• Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expert in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test UAT and data accuracy test.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Extensively worked in Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, analysis reports, data reports
• Interacted with the client and expertise on enhancements and cut-over of SAP ECC 6.0 modules like Logistics SD, MM, PP as well as the ECC Upgrade Cutover.
• Designed and created Info Objects, Info Cubes, ODS/DSO Objects, Info Sets, Multiproviders, Datasources, Infosources, Process Chains, Transfer Rules, Update Rules, transformations, data transfer process.
• Front-end Development with BEx Query Designer Restricted Key Figures, Calculated Key Figures, Formulas, Exception Aggregation, Formula Variables, etc , BEx Analyzer, Views and Work Books.
• Worked on Data Modeling, Data Staging, Data Extraction and using LO Cockpit, Generic Extractor and extraction from non-SAP sources using Flat Files.
• Taken care of Routines i.e. Start Routine, End Routine, Expert Routine by using ABAP Coding.
• Involved in the upgrade of Enhancement Packs EHP4 Support Packages. Taking care of the BI system of Pre Post upgrade of Support Pack Enhancement Packs.
• Expertise in Datasource Enhancement, Generic DataSource using Function Modules, Business Content, User Exits, Scheduling, Monitoring, Process Chain, InfoSource, MultiProvider, InfoSet, InfoCube, DSO/ODS and Open Hub Service.
• Defined BO classes, objects in universe, Checked and resolved integrity issues and exported universe to the repository to make resources available to the users and groups

TECHNICAL SKILLS:

• Data Modelling: SAP HANA 1.0 SP02/SP07-08
• Data warehouse ETL Tools:SAP BI 7.0/7.3/7.4, SAP Business Objects DataServices 4.0/4.1
• ERP: SAP R/3 4.6, ECC 6.0 and SAP ABAP
• Tools: TOAD
• Operating Systems: Windows XP/NT, UNIX

WORK EXPERIENCE:

Confidential

SAP BI/BO and HANA Consultant

Responsibilities:

• Handling project planning, execution and management in tune with the core business objectives including risk management, effort / time / cost estimation
• Involved in SAP HANA implementation, SAP System Landscape transformation SLT .
• Worked on creation of Attribute, Analytic and Calculation Views for data consumption by BOBJ Explorer Extensively worked on Native HANA , SLT and HANA Studio
• Good Conceptual understanding of HANA product positioning and its integration with SAP BW and ECC. First-hand experience in ECC data transfer through SLT replication, data load using Information Composer and analyzing data in HANA Information Modeler.
• Utilized transaction LTR in ECC per SAP Landscape Transformation SLT when setting up data loads for SAP HANA Database. Utilized in ECC SD11 in creating data model models delivered specifically as Rapid Development Solutions RDS
• Implementing SAP HANA system with ECC Tables.
• Expert in understanding of the complete Architecture Data loading, Data modeling Reporting .
• Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
• Overview working knowledge with SAP BO Data services SLT replication methods.
• Worked as BI/BO consultant and gathered business requirements and deliverables for report requirements along with functional end users in the business areas.
• Fulfilled the business objects development needs for various departments. And also performed the day to day admin tasks.
• Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team
• Participating and finalizing the functional requirements from the business users
• Responsible in converting the functional requirements to technical designs
• Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.
• Involved in Upgradation of the System from BW 7.0 to BI 7.3
• Taken care of Pre Upgrade and Post Upgrade steps.
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Performed huge data loads into DSO and Infocubes from ECC as well as the other source systems
• Creating deleting the indexes before after Upgrade, checking the consistency of the Infoproviders ,InfoObjects Queries.
• Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Was involved in training the end users over the newly developed crystal and webi reports.
• Worked with end-users to gather and document requirements for a SAP Business Objects reporting solution
• Involved in designing Functional Specification documents.
• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
• Configured Metadata Manager to read and analyse large volume of BOE metadata.
• Coordinated and worked along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Involved in updating and maintaining existing Universes based on changes in user requirements and changes in data.
• Involved in creating new and modified existing Hierarchies in the universes to meet Drill Analysis needs of the user's.

Environment Development Production Support : SAP-BI7.0/7.3/7.4, ECC6.0, BOBJ 4.0/4.1 and HANA 1.0 SP2/SP07-08

Confidential

SAP BI/BO LEAD Consultant

Responsibilities:

• Taken initiative Ownership of the case and keep posting the updates of the case to the users till it satisfies the Client and User requirements.
• Involved in both the Activities monitoring and Production Support.
• Fix the identified problems, make necessary break fixes/enhancements in the development system and transport them to Production.
• Upgraded, enhanced and supported activities from BW 3.5 to BI 7.0 in Nw2004's.
• Supported the client by providing long-term solutions to the tickets by doing Root Cause Analysis.
• Automated the Process Chains and creating alert messages for the process in the Process Chain.
• Involved in Enhancements and validating of reports in EP.
• Handled the cases of priorities Normal, Urgent and BC Business Critical .
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Create OSS Notes, investigate and follow up with SAP.
• Monitor daily, weekly, monthly data loads on SAP BW Production systems. BW daily jobs consist of loading data into BW and extracts from BW using Info.
• Enhanced/Maintained Info Cubes, Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages as per the Business requirement.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Improved performance by creating Aggregates, Compressions, Partitions and Indexes using BW statistics and repaired the objects if any inconsistency using RSRV.
• Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.
• Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.
• Created universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Implemented the Object-Level Security and Row-level security in Universe. Implementing the Table Mapping in Universe to restrict certain data in a table to only one group of users.
• Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.

Environment Development/Production Support : SAP-BI7.0, SAP-BW3.5 ABAP/4, ECC6.0, SAP Business Objects 4.0/XI 3.1, Xcelsius 2008, Crystal Reports 2008

Confidential

SAP BI/BO Lead Consultant

Responsibilities:

• Design and analysis - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential solutions, implement enhancements to existing functionality.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included MM, PP SCM , PPM CO Extractions.
• Worked on logistics cockpit of SCM Modules i.e MM PP.
• Taken Care of the Pre Post Cutover activities for the data of MM PP.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis performance, clearing the tRFC's and Security provided the role name to assign to the users, checking the user authorizations and roles issues.
• Involved in taking the responsibility of the development till the go-live of the reports.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• As part of Information Consumer Layer making changes as per the user requirements and designed BEx Reports providing for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Involved in creating Start Routines End Routines ABAP Coding in transformations as per the Business requirement.
• Analyzed, Designed, development, coding and implemented multiple DSO , BW infocubes and multi-providers
• Using Real Time Cubes in Integrated Planning, Created Aggregation Levels and the reports for planning cubes.
• Added new infoobjects using Remodelling concept and involved in creating Process Chains.
• Using BEx broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Scheduled and Automated data loads from R/3 to BI and optimized the load performance by creating Aggregates.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.
• Created Web Templates and Web reports using WAD.
• Created and Maintained Info Cubes using RSA1 T-Code , Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages.
• Scheduled the Web Templates to make the InfoCubes data Available to the Portal Reports.
• Involved in Training the end users on BEx Queries and customer support to schedule the process chains.

Environment Development :SAP-BI 7.0, ECC 6.0, ABAP/4, MM, PP SCM , PPM CO,Business Objects XI 3.1, Designer, Web Intelligence and Info View.

Confidential

SAP BI Consultant.

Responsibilities:

• Design and analysis - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential solutions, implement enhancements to existing functionality.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included HR Headcounts Personnel Action PA-PA , Payroll Org. Management PA-OM , MM, PP, FI-CO Extractions.
• Taken Care of the Pre Post Cutover activities of SCM for the data of MM PP.
• Involved in taking the responsibility of the development till the go-live of the reports.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis performance, clearing the tRFC's and Security provided the role name to assign to the users, checking the user authorizations and roles issues.
• As part of Information Consumer Layer making changes as per the user requirements and designed BEx Reports providing for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Involved in creating Start Routines End Routines as per the Business requirement.
• Analyzed, Designed, development, coding and implemented multiple DSO , BW infocubes and multi-providers
• Using Real Time Cubes in Integrated Planning, Created Aggregation Levels and the reports for planning cubes.
• Involved in the upgrade of Enhancement Packs EHP4 Support Packages. Taken care of the BI system of Pre Post upgrade of Support Pack Enhancement Pack Upgrade.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.
• Created Web Templates and Web reports using WAD.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Worked on complex Crystal Reports that require running totals, sub-totals, sub-reports, prompts, cross-tab, multiple groups, hierarchical grouping and conditional display of groups, fields, and messages.
• Written free hand SQL queries using Oracle database and defined full client reports and webI.
• Created reports on web using Info View Portal and published the reports into info view for different groups and users.
• Extensively used calculations, variables, drill down, slice and dice, alerts in the creation of reports.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Expertise in writing and implementation of the packages, triggers, functions, views, materialized views and indexes using SQL.
• Prepared ad hoc supporting documentation for senior financial management.

Environment Development : SAP-BI 7.0, 3.5, Business Objects XIR2, ECC 6.0, ABAP/4, ECC6, HR, MM, PP CO

Confidential

SAP BI Consultant

Responsibilities:

• Design and analysis - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential solutions, implement enhancements to existing functionality.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included SD Orders , Billing , PS CO-PA Extraction.
• Taken Care of the Pre Post Cutover activities for the data of SD Orders Billing.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis performance, clearing the tRFC's and Security provided the role name to assign to the users, checking the user authorizations and roles issues.
• As part of Information Consumer Layer making changes as per the user requirements and designed BEx Reports providing for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Created Open Hub Destinations for sending the data to 3rd Party tool Metreo.
• Involved in creating Transformations ABAP as per the Business requirement.
• Analyzed, Designed, development, ABAP coding and implemented multiple DSO, BW infocubes and multi-providers.
• Added new infoobjects using Remodelling concept and involved in creating Process Chains.
• Using BEx broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Involved in taking the responsibility of the development till the go-live of the reports.
• Scheduled and Automated data loads from R/3 to BI and optimized the load performance by creating Aggregates.
• Created and Maintained Info Cubes using RSA1 T-Code , Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages.

Environment Development/Production Support :SAP-BI 7.0, ECC 6.0, ABAP/4, SD, PS, CO-PA

Confidential

SAP BW Consultant

Responsibilities:

• Taken initiative Ownership of the case and keep posting the updates of the case to the users till it satisfies the Client and User requirements.
• Involved in both the Activities monitoring and Production Support.
• Fix the identified problems, make necessary break fixes/enhancements in the development system and transport them to Production.
• Supported the client by providing long-term solutions to the tickets by doing Root Cause Analysis.
• Automated the Process Chains and creating alert messages for the process in the Process Chain.
• Involved in Enhancements and validating of reports in EP.
• Handled the cases of priorities Normal, Urgent and BC Business Critical .
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Create OSS Notes, investigate and follow up with SAP.
• Monitor daily, weekly, monthly data loads on SAP BW Production systems. BW daily jobs consist of loading data into BW and extracts from BW using Info.
• Enhanced/Maintained Info Cubes, Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources and Info Packages as per the Business requirement.
• Created process chains for data loading, delta uploading and periodical PSA deletion.

Environment Production Support : SAP-BW3.5 ABAP/4, ECC6.0