OBJECTIVE

• Around 10 years of rich experience SAPBW/BI and HANA experience playing various key roles in Process Analysis, Implementation, Designing, Testing, deployment, support.
• To become a contributing SAP BI consultant in an organization for its success, by applying the best business practices, through innovative solutions, and constantly updating my skills.
• Anenergetic, self - motivated and Performance driven Computer application professional with an enriching experience managing all aspects of Business Intelligence.
• Able to use own initiative and work as part of a team. Proven team role skills, including performing and motivating other staff to achieve company objectives.

SUMMARY

• As partof myexperience in SAP BW/BI/HANA Consultant and worked on both implementation &production support projects as detailed below.
• Worked on BW version 3.5 / 7.0/7.3 versions.
• Knowledge of crystal reports.
• Worked on Info Cubes, MultiProviders, Operational Data Store (ODS)/ Data Store Object (DSO), Transformations and DTP.
• Created and activated communication structures, transfer structure, transfer rules (for both ODS and Info cube).
• Worked on extracting master data and transactional data from flat files and SAP ECC.
• Worked on Extraction of data from SAP source systems using LO Cockpit Extraction, Generic Extractions and including installation of Business Content.
• Worked of the advanced concepts like Semantic partitioned object (SPO) and Composite providers.
• Worked in Layered scalable architecture ( Confidential ).
• Working experience on performance tuning using Aggregates, Rollup, Compression, Partitioning.
• Expertise in report generation-worked on BEX-Analyzer in building Queriesusing Conditions, Exceptions, Calculated key figure,restricted key figures and Variables.

CORE STRENGTHS

• Excellent communication and presentation skills.
• Task oriented.
• Ability to work independently.
• Ability to lead, manage and motivate a team.
• Dynamic, affable, self driven achiever with a proactive attitude.
• High levels of persuasiveness and strong analytical skills with ability to work constructively towards opportunities.

TECHNICAL SKILLS

Data warehousing: SAP BW 3.5, BI 7.0 and 7.3.

ERP: SAP R/3, ECC 6.0

Operating system: Windows, NT and 2000.

Reporting Tool: BEX Analyzer. Web Intelligence,Crystal reports.

Tools: & Packages: MS Office.

PROFESSIONAL EXPERIENCE

Confidential

Environment: SAP BW 3.X, 7.0, 7.3 & 7.4, SAP BO 4.2, ECC 6.0, BO 4.0.

SAP BI/BO LEAD

Responsibilities:

• Good Hands on implementing BO solution on SQL server/.Net, BW and HANA data bases based source systems.
• Designed and Developed the whole BO solution from scratch to report on various data bases.
• Good work experience in the field of Business Intelligence in domain of Finance/Banking, Manufacturing, Oil and GAS using SAPBusiness Objects.
• Specialize in Reports Development, Universe Design & Development and administration.
• Have experience in migrating reports from UDT to IDT.
• Have migrated system from BO XI R3 to SAP BI 4.0.
• Have upgraded system from SAP BI 4.1 to SAP BI 4.2.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise inBusiness ObjectsEnterprise Products SAP BO4.1 (Universe Designer, Desktop Intelligence, Web Intelligence, LaunchPad, Explorer, LCM, CMS & CMC)and its deployment.
• Excellent data-analysis skills and ability to translate specifications into a working Universe and/or Report.
• Designed and developed highly formatted reports in Webi.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Installation and configuration of Xcelsius and designing complex reports and dashboards in monitoring business metrics.
• Experienced in Training & Supporting end-user reporting needs usingBusiness Objects.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Developed and tested attributes/facts/metrics for Service Delivery Insight report according to the business requirements in Micro strategy.
• Expertise in Desktop creating and integrating Micro strategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations.
• Created migrations packages and assisted during promotions from Dev to Clone to UAT.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal kills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Having basic understanding of Lumira and Predictive Analysis.
• Good understanding of Agile Methodologies.
• Expertise inSAP BWArchitecture including Data Sources, Info Objects, Info sources, ODS Objects, Info Cubes, Info Packages, Hierarchies, DTP and Transformation process.
• Proficient in Data staging using ODS before transferring data to required data targets.
• Developed the Process chains to automate the loading process and monitored them.
• Involved in checking workload and Process Chain log to monitor running of chains.
• Extensively worked in Data Extraction from Multiple SAP and non-SAP Systems using
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques.

Confidential

Environment: SAP BW 3.X, 7.0,7.3 & 7.4 on HANA, SAP HANA, ECC 6.0, BO 4.0.

SAP BI HANA/Technical Specialist/ Business Analyst (SAP HANA)

Responsibilities:

• Gathered and analyze the requirement to replicate the ECC content to HANA using data provisioning.
• Created blueprint for Technical/Functional specifications and standard modeling documents for HANA.
• Strong experience in carrying Functional, integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products
• Established the best modeling and recommended strategies and architecture forSAP HANA.
• Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT).
• Build SAP FI, SD data to build information model for user consumption (Attribute view, Analytical view and Calculation view).
• Created multiple models in HANA such as model consisting of replicated SAP tables VBAK, VBAP, VBUP and VBUK.
• Created HANA information models (Attribute views, Analytical views, Calculation views, and Column/Row based tables) in HANA design studio for efficient data integration.
• Developed Real-Time Information models to support SLT replicated tables for SAP ECC.
• Build Schemas, analytic privileges and granted permissions for BI users.
• Identified expensive statements using HANA monitoring traces for performance optimization.
• Worked onSAP Hanasecurity and analytical privileges for user access to different reports.
• Transported objects by creating delivery units between SAP landscapes.
• Build Informatica mappings to load Customers data from SAP BW application tables for various business units into HANA tables.
• Performed full and delta loads based on MD5 checksum and scheduled workflows.
• Performed trigger based data replication using SLT technique for SAP ECC SD, FI.
• Involved in creating transformation in SLT for enhancing BP Role, BP Status and business required fields.
• Data Load via SAP BW extractors (DXC) to HANA from EDW.
• Build universes on top of HANA information models for Webi/Dashboard reports.
• Customer Sales Analysis for Denied Party Screening (Sales organization Drilldown, Business Unit Drilldown, Customer Type).
• Customer Touches/Visits Reporting (The purpose of this report is to allow Business users to have transparency into the level and type of activity that is occurring with our customers, prospects and suspects.
• This can provide insight into how effective and frequent the marketing and sales activities are for different cross sections of the customer base).

Confidential

Environment: SAP BW 3.X, 7.0,7.3 & 7.4 on HANA, SAP HANA, ECC 6.0, BO 4.0.

SAP BI HANA/Technical Specialist/ Business Analyst (SAP HANA)

Responsibilities:

• Expertise in Order-To-Cash and integration to other SAP modules (MM, PP, FI/CO, IM, WM) in all business scenarios.
• Hands on experience in configuration of various business processes like designing, configuring and customizing S & D functionalities.
• Good working knowledge in Lead-to-Orderprocess.
• Knowledge Acquisition, Offshore Knowledge transition, Play back sessions.
• BW data load monitoring.
• BW periodic cleanup activities.
• Process chain automation of sales data.
• Developed outbound and automation process
• Automation Job scheduling of BW and interface jobs.
• History Data movement from Initial Year to Data mart layer and loading huge volumes with in data mart layer and reconciling the data with Current & History DSO's.
• Carried out an extensive analysis on pre and post HANA implementations for Go/NO GO situations.
• Lead the Preparation, Pre - migration and post - migration Activities while migrating to HANA.
• Documented the Analysis capturing the benefits of implementing/migrating to SAP HANA.
• Designed the new data flows on SAP HANA.
• Good hands on with creating creatical sales reports, Profit and loss and balance sheets reports.
• Good working knowledge in NEW GL,Leading ledger and CCA and PCA accounting.
• Worked on HANA and Bobj streamline project.
• Developed new Webi reports for new requirements in BOBJ 4.0 and BOBJ 4.1Rerouting Webi reports tocorrect Queries and rebuilding the reports.
• Migrating Webi reports from WAD reports.
• Modifying current reports to provide business requirement changes.
• Experience with BW 7.0.7.3 including both backend cube development and front end reporting
• Experience(BEx, Crystal, Web Intelligence, Xcelsius).
• Experience using Business Objects Universe Designer to create BO universes against BW as a datasources.
• Bobj migration of Bex Query views into Webi and crystal report.
• Migrating bobj 3.x universes into IDT bobj 4.0.
• Redesign bobj 3.x xcelsius dashboards from live office to BICS and Webi instances for faster reporting.
• Migrating Query views in to Bobj webi/crystal reports.
• Experience in developing Business Objects reports using Universe and BICS.
• Working with BOBJ on SAP HANA, making performance tuning Bobj reports to run faster on SAP HANA.

Confidential

Environment: SAP BW 3.X, 7.0,7.3 & 7.4 on Hana, SAP Hana, ECC 6.0, BO 4.0

SAP Hana/BI Consultant/HANA Business Analyst

Responsibilities:

• Performed clean-up activities for the premigration of BW on HANA implementation. Optimized BW cubes for HANA purpose.
• Handled all the Pre and Post migration activities.
• Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA. Interacted with the Finance Business Analysts on a daily basis for their KPI & report requirements. Managed, Configured and Performed Transports between multiple BW environments.
• Expertise in SAP R/3 in Sales & Distribution (SD) - Sales Order Processing (OTC), master data configuration, Availability Checking, Pricing, Revenue mapping with GL accounts, Sales Promotion and Sales Deals, Contracts & Rebate agreements, Output Determination, Product proposal, Free goods, Purchase Orders, Purchase Requisitions, Stock Transport Orders, Outbound and Inbound Deliveries, Picking, Packing, Transfer Order, Goods Issues, Goods Receipts, Billing, Batch Management, Variant Configuration, Route Determination, Inventory Management, Warehouse Management.
• Performed DTP temporary storage, DTP error logs, and temporary database objects. Help and programs to do this are found in SAP Notes 1139396 and 1106393 while migration.
• Used the program RSDDCVER DIM UNUSED to delete the unwanted diementions.
• Actively handled the requirements gathering and due diligence.
• Lead the design phase while interacting with the customer to enquire about the requirements and the changes to the current landscapes.
• Conducted the due diligence for the migration and new development of the BO webi reporting solution.
• Designed and architectured the BW system and BO reports and the statistics.
• Handled the END to END phase of BW and BO implementation.
• Created complex reports and charts to produce the amount of repossessions.
• Created reports that contained information detailed information on loan and lease accounts.
• Created a report containing loan, lease and combined account information by inserting 8 sub reports to display the information in one report.
• Created several crystal commands the produced reports containing collateral and assessment information based on shared variables and complex formulas. These reports also displayed a pie chart containing repossession summaries.
• Designed the data flow and reporting layout for the scratch developments.
• Involved in preparation of Functional specs, Technical Specs.
• Developed business critical reports based on SD and FI modules.
• Worked on the special reporting requirements.
• Building Webi reports on the Bex reports.
• Organized workshops in the Client location GE ED headquarters.
• Handling the Implementation and Support team, coordinating with the customer and end users for any issues and CRs.
• Handled Process refinement to achieve the requirement.
• Handled Challenges to implement single reporting solution across locations.
• Created reports in Visual composer.
• Created dummy reports to verify results
• Clean up loading to decrease statistics loading time.
• Created reports in BW WAD 7.0 version.
• Providing recommendation to user community and other developers on creating better and faster Adhoc and standard reports.
• Creating Crystal reports in Crystal reports enterprise on bex Queries for users.
• Understanding the current functionality available in the system.
• Understanding the current developed created in the system.
• Modifying current process to accommodate new process.
• Creating Info Cubes, DSO, info objects, info sets and process chains.
• Created Crystal reports on Queries for reporting to mimic the customer current report formats.
• Created Webi Reports on queries/ Universes to mimic current customer reports.
• Created Dashboards with drill in to Webi reports for system over view and detail line item reports.
• Created test shells and scripts.

Confidential

Environment: SAP BI 7.0, ECC 6.0, BO 4.0

SAP BI Consultant /BI specialist

Responsibilities:

• Involved in preparation of Functional specs, aligned with the Functional consultants also developed the HLD and DHDs.
• Worked on the Blueprint for Tax specific requirement.
• Developed the Excise duty reports for Australian Tax Authorities.
• Worked on the special reporting requirements useful to file the ED and GST taxes on regular intervals.
• Worked with marketing and sales to create a series of Crystal Reports. Instituted on-line reporting on the company intranet.
• Worked with Java programmers to develop a series of Oracle Reports.
• Building webi reports on the Bex reports.
• Training the end users on the BO reports and the procedures to be followed
• Developed and implemented the requirements of Confidential Australia and US.
• Aligning the development activities by conducting the calls with the core business users.
• Managing the master data changes.
• Data source enhancements.
• HPQC status updates and regular status changes.
• Technically involved in the responsibilities of security/authentication on folder level, object leveland row level access restrictions for the Universes (restrict data access to certain users or user groups) and Web Intelligence reports.
• Promote contents from development to test to QA to production environments using Promotional management Tool.
• Design and coordinate or build universes, classes and objects; Create cardinalities, contexts, joins and aliases.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus). Generated various Drill down reports and Alerts, and created graphical representation of reports such as Bar charts, Pie charts, combo charts as per End user requirements.
• WEBI: - Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data from the report. Extensively used Variables, Calculations, Sorted inputs, breaks, sections, variants, ranking, Drill down, slice and dice, complex filters, customized formulas and highly formatted page layouts.
• Involved in developing reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging common objects.
• Worked with business users to define and understand data access and reporting needs and help business users for the reports requirements.
• Trained power users in various Business Objects Tools such as Webi, life office, Business Explorer.

Confidential

Environment: SAP BI 7.0, ECC 6.0, BO 4.0

SAP BI LEAD

Responsibilities:

• Analyzing and correcting the production problems as they occur in the SAP BI system regarding extractions, performance issues and also load failures for permanent fix.
• Handling the Tickets/Service Calls raised by End-users and providing them faster resolution.
• Involved in Change Request includes new developments.
• Closely worked with client to format the reports/dashboards based on their requirements.
• Involved in integration testing and Business acceptance testing.
• Interacting directly with the Client for resolving errors, performing system changes, clarifying issues, status meetings, etc.,
• Documentation in the area of Change Management.
• Involved in Quarter end activities and Year end activities developments and same has to be move to further system and testing.
• Architecting reporting requirements into technical design and development. Created Info providers & BEx queries tosimulate/validate results achieved from Design Studio reports.
• Worked on the Business Objects (BO) - Crystal reports, Dash Boards reports and WEBI - Web Designer.
• Worked on the BO - Business Objects reports (Universes, Dash board and Cristal reports).
• Extensively involved in Design and Creating Processes Chains to automate the process of loading data into datatargets.
• Worked on the OLTP and OLAP Process.

Confidential

Environment: SAP BI 7.0, ECC 6.0, BO 4.0.

SAP BI Consultant

Responsibilities:

• Involved in Business Intelligence reporting solution.
• Gathering reporting requirements by participating in the blueprint workshops.
• Documenting functional, technical specifications.
• Monitoring of development activities and reporting to management.
• Designed Reports like Inventory Coverage report which displays past, present and future Inventory.
• Developed functional-technical solution specs, test plans and test strategy for developers.
• Identification of the source tables and data mapping from SAP source tables.
• Testing and validation of various objects and deliverables.
• Reconciliation of data between the backup cubes, PSA and BI Reports.
• Designed Info cubes and DSO’s for Staging of Forecast data.
• Designed master and transaction data loads in BI.
• Worked on the role templates.
• Worked on the manual and automated conversion of Web Templates from 3.X environment to 7.0.
• XML and HTML conversions.
• Training of Business Users about the new reports and reporting options using BEx.
• Managing cut-over activities during go-live.
• Involving daily base Tickets and Resolving P1, P2, P3 and P4 Level tickets.
• Involved in Enhancements, Maintain and Support Work Requests.
• Enhancement and production support to ensure service level expectations.
• Automated the data loads which are done manually in the project and so saved much time for the resources in daily monitoring of data loads.
• Created Process Chain for Cube Compression, PSA Deletion, Events and Rollups on Info cube.
• Providing daily Production support from Offshore.
• Monitored Data loads and failed data packets were analyzed and edited manually
• Experience in Info Cube managing activities like creating Indices, Rollup and compressing the data in Data Targets.
• Manual triggering of Process chains whenever the chain fails.
• Rectifying the data in the error stack and correcting the error records in the error stack and creating error DTP’s.
• Create Connections from Bex query into Webi directly.
• Eliminate use of Universe where needed.
• Created documentation for other users.
• Develop Main use template.
• Mentor interns into learning BOBJ.
• Created new roles and access in CMC.

Confidential

Environment: SAP BW3.5, ECC 6.0.

Support Analyst

Responsibilities:

• Involved in development of Master data objects like creation of update rules, transfer rules, data sources and infopackages as well loading data from respective source systems for both Attributes and texts, transporting the objects from development system to QA system.
• Info Package Management for data loads via IDoc or PSA, Flat file creation/load PSA (used to source data from legacy system into BI)
• Monitoring the automated jobs running in the background, fixing the failed jobs.
• Designed process chains for master data loading, transactional data loading and for regular PSA data deletion.
• Handled BW Prd Issues, Documented Guidelines and Improved performance of data loads.
• Involved in Loads monitoring Using RSPC, RSMO, SM37 and SM50.
• Loading data manually to the each cube on request.
• Adding new fields in the existing queries depending on the Customer requirement.
• Transporting request for the modified data.
• Checking the system performance, especially during the months of October, November and December as these are the busy trading months.
• Monitoring of daily loads in IST, as all the sales activities are updated in American standard time.
• Monitoring Process chains, Monitoring data loads.
• Check the files created for interfaces in AL11.
• Check the tickets and CRF assign to Offshore BI group and resolve depending on the Priority.