SUMMARY:

• 8+ years of SAP Business Objects (BO) experience which includes 2 Life Cycle Implementations
• TEMPHas extensive experience in working wif multiple projects encompassing multi - cultural teams from diverse geographical regions.
• Experience working for corporations across diversified industry verticals includes Pharmaceutical, Retail, Manufacturing.
• Extensively worked on Lifecycle Manager, publishing reports to roles and portal, broadcasting workbooks, reports to end-users, user interfaces, Experience in providing the security using Authorizations for various requirements.
• Marked experience in generating customized queries using Restricted and calculated key figures, Variables, Conditions, Exceptions and Report Filters.
• Worked on performance tuning by using delta loads, process chains and creating aggregates, carried out day-to-day monitoring, fixing loads etc.
• Hands on experience in Business Object reporting particularly skilled in working wif BO versions
• Established and worked on universes using universe designing tool and Created BICS connection over BEx queries using Information design tool.
• Worked extensively on Web Intelligence,QAAWS,Live office.
• Interacted wif the end client for gathering requirements and developed functional specifications.
• Actively participated in developing training material and User Guides.
• Adept at creating, organizing, publishing and scheduling reports using Central Management Console.
• Created reports for analysis using Web Intelligence via Web Intelligence Rich Client and via Bi Launch Pad.
• Worked on SLA scenarios to make query suitable for Business Objects enterprise server reports.
• Extensively used Designer, Business Objects Dashboard Manger and Desktop Intelligence.
• Experienced in Business objects universe designing (OLAP Universes), BICS, IDT, UDT, Crystal reports, Visual intelligence, Design Studios, Explorer, Analysis, Business View Manager, Mobile BI, Infoview and Business Objects Enterprise (BOE).
• Hands on experience in creating BO Xcelsius dashboards involving all sorts of selectors and prompts wif particular focus on dynamic visibility,Business intelligence analytics platform and KPI’s to large-scale multi layer reports.
• Used Import wizard\Upgrade Management tool extensively for migration 6.5 to BO XI R2 to XIR3 and 4.0\4.1 and also package BI content into Business Intelligence Application Resource (BIAR) format for backup or Change management.
• Involved in End-User training on Navigating reports, Live office, Post Go-Live maintenance manuals, Web Application Designer, Portals.
• In depth understanding ofSAP R/3functionality (SD, MM, PP, FI, CO-PA), CRM & SRM, Standard Business Contents and Data Modeling (star schema, extended star schema, flat structure and multi dimensional data modeling) in Sap BI/BW.
• Worked wif databases like SQL server, Oracle, Sybase.
• Proficient in OLTP extractions of SAP LO-Cockpit, SD, FI, MM, HR, CO-CCA generic extraction, flat files & using DB Connect for legacy data.
• Extensively worked in designing and configuring back-end components including Extractors, InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, InfoCubes, MultiCubes, ODS/DSO, InfoSets, InfoPackages, Datamart and Data Transfer Process (DTP), SAP HANA.
• Strong experience wif OLAP reporting in BW.
• Expertise in naming standards,writing modeling guidelines,developing user training material and training users on utilizing,training and administering BW queries.
• 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.
• Proficient in writing ABAP User exits for transaction data and complex routines in start routine, end routine and update routines.
• Expertise in working wif BEx Analyzer in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• 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.
• Documented functional specifications, technical specifications, test cases, test results and production support documents.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate TEMPeffectively wif Team members, developers, clients and end users in a diverse environment.

TECHNICAL SKILLS:

Reporting: BusinessObjects5.x/6.x/XI 3.x/BI 4.0/4.1, Desktop Intelligence, Dashboards, Web Intelligence, OLAP Intelligence Reports, Crystal Reports XI, Advance analysis for office, Java Reporting Components, COM Reporting Components

Operating Systems: Windows 9x/2000/XP/Vista, 7, UNIX, MS-DOS

Language: C, C++, Java, SQL, PL/SQL, Visual Basic 6.0

Database: Oracle 8.x/9.x/10g/11g/12g, SQL Server 7.0/2000, MS Access, Teradata

ERP Packages: SAP ECC 6.0, R/2,R/3, R/4,4.7

Data warehouse: BI 7.3, BI 7.0, BW 3.5

Web/Application Servers: IIS, Apache v2, Tomcat 4.1

Administration: CMS, Supervisor, CMC (Central Management Console)

PROFESSIONAL EXPERIENCE:

Confidential

SAP BI/BO Consultant

Environment: s: Business Objects 4.0/4.1,BW 7.3,Oracle 11g, MS SQL Server, Crystal Reports, Dashboards, Web Intelligence, Info view,.BEx Analyzer

Responsibilities:

• Actively interacted and scheduled meetings wif the business users to gather the reporting requirements, performed gap analysis and developed design documents.
• Efficiently lead small to large sized teams in various assignments
• Worked as Production Support Lead for the Business Objects Reporting environment.
• Created intricate queries by incorporating Free Characteristics, Calculated Key Figures,Restricted Key Figures and Variables.
• Defined variables using SQL related functions so as to design customized multiple dimension reports.
• Created BICS connections using Information Designing Tool and formed both .unx and .unv universes using Universe Designing Tool.
• Performed database health checks and tuned the databases using Teradata Manager.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database
• Looked into integrity issues and exported universes to the CMC (Central Management Console) to make resources available to users and groups.
• Wif the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks wif queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design.
• Designed versatile, flexible reports using Web Intelligence components like conditions, operators and functions and integrated these in Live Office Work Sheets.
• Enabled dynamic report linking by passing variables (prompts) between reports.
• Worked wif Crystal Reports for generating and formatting wif Standard, Summary, Cross Tab and grouping reports.
• Worked on Run update installation software and Run promotion management tool in upgrade process from 4.0 to 4.1
• Designed intricate dashboards involving dynamic visibility by employing a variety of selectors and charts.
• Developed BEx queries for reporting on InfoCubes, ODS and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting.
• Created BI OLAP universes over BEx queries using Universe Designer, published the reports on the web using Web Application Designer (WAD).
• Experienced in gathering and analyzing the requirements from end-users and creating multifaceted Ad-Hoc reports using Business Objects Desktop Intelligence.
• Extensively worked on formatting Business Objects reports to meet the user’s requirements using Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Contexts, Alerts.
• Worked on application servers, Mobile BI and performance optimization giving various publications.
• Worked on both Business objects 3.1 and 4.1 for data federator and multisource universes respectively.
• Extensively Worked wif Explorer, SAP Live Office to create connections between WEBI and Xcelsius Dashboards, Design Studio, Visual intelligence. Worked on different structures, INFOVIEW to create Web Intelligence Reports over BO Universes.
• Worked wif migrations and content security, performance tuning concepts and user interfaces.
• Trained Super Users to develop ad-hoc queries in BI Query Designer. The training included creating queries from various sources such as InfoSets, MultiCubes, use of aggregations and creating input parameters among other items.
• Responsible for development and extraction of data from ECC source system into BI from SD, MM and FI modules.
• Responsible for implementing FI-GL using Business Content DataSources and Cubes to deliver the Balance Reports.
• Designed and maintained InfoCubes, MultiProviders, RemoteCubes, ODS objects wif consistent star schema and efficient multi-dimensional data modeling techniques.
• Extensively created custom cubes and DataStore objects by enhancing the business content also developed Write Optimized DSO’s for EDW layers and Standard DSO for Consolidation Layers.
• Created Generic DataSource in the ECC source system to facilitate Inventory Accuracy Rate reports like Quantity Difference, Quantity Count.
• Migrated users and roles using Lifecycle Manager..
• Configured Data Manager Packages to upload flat file using Conversion file and transformation files.
• Created Analysis Process Designer (APD) to extract pricing data into CSV file format for further analysis by using data transformations.
• Performed automated deletion of PSA and Change Log tables using Process Chains to improve the Data Management.
• Proposed and installed BW Statistics to monitor the Load and query performance on cubes and enhanced the performance by building aggregates on required objects. Injected BW statistics event in the process chain for Data collection.
• Implemented Compression and Partition techniques for cubes to improve the query response time. Proposed archiving strategy for future based on Time characteristics.
• Worked on the implementation of BI Accelerator. Involved in identifying cubes for BIA, Creating indexes and performing BIA index reorganization.
• Created reports from purchasing data sources like Purchase Orders Quantities, Purchase Order Values, Open/Closed Purchase Orders, % of confirming PO, Amount outstanding, and Confirmed Quantity.

Confidential, Detroit, Michigan

SAP BI/BO Consultant

Environment: s: SAP BI 7.3, Windows 2003 Server, SQL SERVER, BEx, Business Objects (XI). WEBI, Crystal reports, Dashboards

Responsibilities:

• Involved in full cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Experienced in migration from Import wizard and LCM in Business Objects 3.1.
• Worked extensively on reporting and transactional structures, Database layers.
• Worked on Teradata dual active systems project. To support data center and Teradata dual active system efforts, worked wif the team to clone jobs, programs and Teradata tables and make sure both Teradata systems get updated simultaneously and in sync all the time.
• Installed Teradata drivers for the teradata utilities.
• Created BW OLAP Universes on top of BW Queries to access the BW data in Business Objects. Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports and worked on Analysis and Visual intelligence.
• Lead the production support team to handle issues wif the reports and the universe.
• Designed interactive and easy to interpret reports by incorporating exemptions and conditions.
• Designed customized reports and queries for priority customers and cost centers.
• In order to create single report retrieving data from different queries linked universes and merged dimensions at Web intellige
• Connected WebI reports to the Dashboards using Live Office, QAAWS and BI services and used these report’s data for designing specific and interactive dashboards.
• Worked extensively on designing dashboards wif BI WAD and dashboards displaying dynamic visibility.
• Worked on validating the existing reports each time the Business Objects environment is upgraded.
• Experienced in using the Report Conversion Tool to convert Desktop Intelligence reports into Web Intelligence
• Created Interactive Dashboard reports for carrying out analysis of the various aspects of profit and cost centers
• Worked on direct connection between SAP BW Bex query to Webi by BICS connection in BO 4.1.
• Created WEBI reports and crystal reports and deployed them through info view wif BW universe as source.
• Scheduled reports using scheduler infoview as well as CMC.
• Designed and developed Business Objects Universe for Aging report.
• Performed Referential Integrity Check for both the Master Data and Transaction Data at DTP and transformation levels.
• Exported XML output for BW queries as a source for Xcelcius dashboards and worked on Design Studio.
• Worked in coordination wif the basis team to Transport (DEV to PROD) the objects.
• Created necessary documentation throughout the project implementation. Conducted User Training for end users about the navigation features possible in the reports.
• Developed InfoSpokes using Open Hub service to extract data from BW into .CSV format.
• Created custom InfoCubes for company wide Sales, Delivery, Billing and Purchasing wif various aggregate periods (business day of the year, business day of the month etc.)
• Migrated DataSources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Performed Remodeling on already existing InfoCubes to add new keyfigures and characteristics.
• Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression and other performance improvement techniques.
• Responsible for compression and partition of certain cubes for enhanced performance. Proposed archiving strategy for future based on Time characteristics.
• Improved query performance and data load using OLAP cache.
• Created Price Purchase Variance (PPV) and Foreign Exchange Exposure (FX) reports. Created FI reports “Overdue analysis (Aging report)” “Payment History”, “Due date for net payment”.
• Generated Cost Center “Internal Order” report which provides an overview of the incurred costs and consumption quantities on an internal order group during the reporting timeframe and the fiscal year. Also developed reports such as Actual costs, Plan/Actual, Target/Actual.
• Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BW Queries. Built code for specific User exit variables and replacement path variables to capture the requirement for Year-to-date, Quarter-to-date and Month-to-date.

Confidential, Orange, CT

SAP BI/BO Consultant

Environment: s: SAP BI, Crystal Reports XI, Business Objects Xi/3.1, Designer, Web Intelligence, Windows 2003 Server, Teradata BEx, Business Objects (XI).

Responsibilities:

• Designed and developed various financial reports and later also customized the report using Report designer. The reports were based on the FI-GL Income statement, Balance sheet, Cash flow and Assets Management.
• Created report in Demand Planning Forecast Deconstruction which allows the business users to break down the forecast by size and distribution center.
• Created Universes and exported these to CMS for making it available to BO end users.
• Designed reports using universes as main data providers and created intricate queries using sub queries and loop prompts.
• Appended newly designed objects to Requests and Tasks and Transport them to Quality Analysis and Production system.
• Worked extensively on WAD (Web Application Designer) for creating and formatting web templates and created me-views for these templates.
• Developed customized and flexible queries using Web Intelligence, filters for multidimensional analysis of the relevant data.
• Worked wif SAP Workforce Management for carrying out Business Forecasting and Analytical Analysis.
• Automated reports for weekly, monthly and yearly schedule using Crystal reports.
• Formed and maintained Report to Report Interface..
• Developed Activity vs Non Activity Forecast reports for business users which is to determine if the activity based forecast increases the statistical forecasting accuracy.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports
• Worked on Info Burst tool to burst the reports for business users, most of the bursting was done at quarter end and year end
• Developed Dashboards and Score cards for detailed analysis using Performance Management.
• Created complex reports by linking data from multiple data providers
• Created Web services using query as web service
• Created dashboards and presentations from spreadsheets by using Crystal Xcelsius
• Experience in Data Quality, Data Services & Data Federator
• Extensively involved in conducting and monitoring test results for Unit testing and Functional testing of several user exits and routines and user inter faces.
• Main responsibilities include Development, Enhancement, User Problems, Process Chain and Job Monitoring activities. The major supported SAP modules were FI, SD, and HR.
• Created custom cubes and activated transfer structure, transfer rules, communication structure and update rules (both ODS and InfoCube level).
• Created ABAP Routines in transfer rules and update rules for updating the Characteristics and Keyfigures according to the requirements.
• Extensively Worked on extracting HR data sources to develop the data model for Organizational Management (OM) and Personal Administration (PA), where using dis data model reports were developed for the Business users.
• Created process chains to automate the scheduling of data extraction, ETL process, Monitored data loads.
• Developed Error DTP’s on Standard DTP for Error Stack.
• Involved in Performance enhancement features such as Cube Repartitioning, Indexing, Remodeling, maintaining Aggregates, Rollups and cube Compression. Responsible for enhancing the performance of system by addressing time consuming loads by fine tuning code or system parameters based on situation.
• Created HR reports for the scenarios like Average head count, Number of fixed-term employees at the end of month or quarter, Age distribution, Average service years, Gender ratio %, Starters % (YTD), Leavers % (YTD).

Confidential, Houston, TX

SAP BW/ BO consultant

Environment: s: SAP BW 7.0, Business Objects 3.0, Designer, Web Intelligence, Info view, Windows NT, ASP, SQL Server

Responsibilities:

• Analyze the reporting requirements wif the business users and come up wif the technical specifications for the BO Reports.
• Generating the Standards and templates for the reports, interfaces and the universes.
• Creating, maintaining and modifying the universes using Business Objects designer for CBR.
• Creating, maintaining and modifying the business critical reports using the Crystal Reports.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Created trend reports wif charts and Bar Graphs on crystal and exported them to live office.
• Created Prompts for end users to enter the values of his own criteria to view the data using 6 different prompts which includes Division, year, Multi Unit.
• Performed both Unit and System integration testing of the Data marts.
• Testing of reports in Development Environment populating data from production.
• Using live office we had self service access to current information, updatable data in user documents, spreadsheets and presentations.
• Worked Extensively in Crystal SDK, JRC component and familiar wif integrating complex report containing Parameters and sub reports wif Java.
• Used Crystal Management Console for scheduling the reports which are saved in different format like Excel and PDF Format and tan e-mailed to the Users.
• Published reports using Info view, and trained users for ad hoc reporting.
• Fixed several Defects in existing reports, created production release notes.
• Worked on BEx Query Designer in designing queries using Filters, Variables, Navigational Attributes and Structures to facilitate flexible, performance tuning concepts, QAAWS, detailed drill down data analysis to required level of information.
• Worked wif Web Application Designer (WAD) for creating web templates for FI, PP modules, transactional structures. Created complex web templates, used interactive charts, and tables.
• Worked extensively on reporting for the extracted data and involved in creating role based security and authorization for all objects.
• Solved issues/tickets regarding Queries/workbooks. Used different techniques to resolve issues about queries and query output and satisfied the end users wif the output results.
• Responsible for design, development and extraction from R/3 source system and Flat file to BW.
• Handled assignments where the responsibility was to activate standard InfoCubes and create custom cubes.
• Designed custom cubes and Operational DataSources, developed delta management functionality and optimal use of update rules keeping query performance in view.
• Worked on HR Personal Administration, to report on Head Count, Personal Actions, Recruitments and Salary Distribution by cost center etc.
• Enhanced Master DataSources for Employee to get additional data like base location, University, highest level of qualification to suit the business reporting requirements.
• Created reports for FI module like sales and profit, Reconciling data in CO-PA, Purchase price variances (PPV).

Confidential, IL

BW BO Developer

Environment: s: SAP BW 3.5, SAP R/3, Desktop Intelligence, Web Intelligence, Info view, CMC, NET, SQL SERVER, DB2

Responsibilities:

• Business Objects XI R2 Administration and handled clustered environment wif 400 users.
• Created Technical design documentation for universe and ensure the thorough and accurate testing.
• Interacted wif business analyst and users to identify reports requirements and transform it in to reports specification and develop reports.
• Creating new jobs, workflows, data flows, data stores, functions, and transformations in Business objects - Data Integrator.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and also working on Toad to tune the SQL.
• Created complex objects and condition and resolving loops using context and alias.
• Created complex reports using multiple data providers, filter and breaks. Created complex variable and formula.
• Development of performance dashboards enabling business intelligence reporting (BI) including benchmarking, metric identification
• BO System usage monitoring, BO Security design and implementation, BO Central Management Console, BO Info View.
• User Creation and Security at different levels of Hierarchy in management.
• Implement Data Level Security in Universe, Folder, and Application wise.
• Worked wif Import Wizard. Created Daily and Weekly BIAR Files. Import and Export One Environment to Other Environment. (Groups and Users List and Universes and reports and Dashboards.)
• Involved in writing Unix Shell Scripts for Automated process of Scheduling.
• Created Purchase order control report, dis report will show the statuses of Purchase orders and Sales orders in particular the third party purchase orders and sales orders.
• Developed an interactive report to list the purchase orders details for a vendor dat TEMPhas interactive drill down options to give the details of vendor from vendor master.
• Designed making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• TEMPEffectively designed and presented reports.
• Developed process chains to automate the initializing of data upload processes.
• Formed ODS objects for capturing erroneous data.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Created variables for Currency Conversion Types and used variable offsets for comparing data between periods and for value ranges
• Created reports which display sales order and line items, which needed to be delivered on a particular date.
• Created variables wif user/sap exits, calculated key figures, formulas and structures in query development, working wif workbooks, exception reporting, conditional reporting.
• Extensively involved in production support issues involving data loading, monitoring, and batch issues.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Designed and developed custom ODS objects, InfoCubes for Inventory data and activated Update rules for these data targets.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies) for Materials and Sales arenas.
• Extracted the data using logistics from Sales and Billing DataSources to populate the Custom InfoCubes dat evaluates quantities and values for sales orders, deliveries and returns, and invoices.
• Created InfoPackages wif Full Loads, Delta loads, Initialization wif/wifout data transfer etc. Tested the data loadings, delta loads and verified data wif R/3 side.
• Worked on creating start routines and end routines in update rules to ensure proper loading of data.

Confidential, Houston Tx

SAP BW/BO Developer

Environment: s: SAP BW 3.5, SAP R/3, Oracle 8i, Environment: Business Objects XIR2/6.1.2/6.5 (Supervisor, Designer, Broadcast Agent, Web Intelligence, ZABO, Weblogic. Info view, Auditor)Westlake makes chemical and plastic products, They are a quality manufacturer and dependable global supplier of petrochemicals, plastics and building products.

Responsibilities:

• Interacting wif Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Developed Business Object Universes using Designer and Business Objects for the reporting solution for Operational reporting System.
• Potential usage of alias, context, and shortcut join concepts to overcome the loops.
• Created Complex Reports Based on the Revenue Data like Revenue by Segment Area, Bills Charged, Bills Adjustments, and Top 10 Revenue Products.
• Created Detail and Summery reports for Total text Messages send, Roaming charges, Direct Connect per second, for the frequency Monthly, Daily, and Weekly.
• Created reports dat limit the reports to display information for particular measures by designing Complex Filters.
• Created Reports like, Reports by Product, Reports by Customer, and Reports by Time (Year, Quarter, and Month Date).
• Extensively built queries on InfoCubes, MultiProviders, InfoSets using BEx Analyzer and Web Application Designer (WAD).
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates on top of the cubes to improve the query response.
• Maintain the list of all the activities for all the tickets until it is closed down. Validated data consistency in reporting wif Data Target against PSA after loading them to data targets.
• Designed and implemented configuration changes for both load performance and query performance optimization.
• 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.

Confidential

SAP BO Developer

Environment: s: SAP BW 3.0, SAP R/3, SD, Flat files

Responsibilities:

• Gathering the reporting requirements wif the business users and come up wif the technical specifications.
• Generating the Standards and templates for the reports, interfaces and the universes.
• Creating and modifying the universes using Business Objects designer for Sales and Distribution System.
• Creating, maintaining and modifying the business complex reports using the Business Objects Reporting
• Created Custom Hierarchies in the universe to Perform multidimensional analysis.
• Develop reports using Universes and Stored Procedures as the main Data providers.
• Implement Row Level Security, and Object Level Security based on the Divisions and Markets.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Created Sales trend reports wif charts and drill down on charts.
• Performed both Unit and System integration testing of the Data marts.
• Involved in migrating universes from SQL Server to Oracle.
• Understood the Client requirement, prepared the technical specification of the report requirements.
• Extensively used BEx Analyzer, created queries wif Variables, restricted key figures, calculated key figures, conditions, exceptions etc.,
• Designed documentation for queries using BEx Analyzer Reporting tool for presentations.
• Extensively involved in the job scheduling and monitoring of info packages using SAP BW Administrator Workbench.