SUMMARY

• Have 7 years of experience in SAP BW/BI using: BW 3.5; BI 7.0, Have 4 years of SAP BI 7.3. Have 5 years in SAP Business Objects. Have 7 years in SAP: R/3 ECC 5.0 and ECC 6.0. None SAP Source Systems.
• Expertise in Configuration and Development of SAP BW/BI components like Info Cubes, DSO Objects, Info Package, Data source, Info Objects, Multiproviders, infoset, Virtualprovider,
• Expertise in Data Extraction, Transformation, and Loading. (ETL), Full/Delta uploads. Update rules, Transfer rules, Events, Creating and Monitoring Errors in PSA and DTP, modifying the error records and reloading the data.
• Expertise on DSO, and Info cube administration and monitoring. DSO administration and maintenance, Performance improvement. Performing Aggregate, Compression and Process Chain.
• Expertise in job scheduling tools, and Process chains, Scheduled, Monitored and managed data loads with full update and Delta mechanism.
• Experienced on Business Content, LO Cockpit, and Generic Extractions. Uploading master data, and transactional data, both from flat files and SAP R/3, ECC Systems. Involved in identifying and activating the necessary Business Content.
• Experts on Bex query designer, Bex web analyzer, Columns, Rows, local structures restricted key figures, Variables, Exceptions, and conditions, calculated key figures, restricted key figures, Structures, Variables, Workbooks and SAP BW /BEx report development.
• Experts on reporting and using analysis tools. Performing Information Analysis in BEX Analyzer, Broadcasting. Defining Bw workspaces, Working with Commands. Creating Planning applications.
• Experts on Reporting with the SAP - BO. Sap Crystal Report. Web Intelligent, Dashboards, BO analysis. Sap BOBJ,
• Experts in advanced Features, things like Open Hub, Analysis Process Designer, and Remodeling.
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.
• Implemented 2 full life cycle BI projects for FI/CO, SD, MM, HR modules
• Followed and implemented ASAP methodology

TECHNICAL SKILLS

SAP ERP: SAP ECC 6.0, SAP BI/BO

REPORT Tools': SAP BEx, WAD, Query Designer. Reporting Tools SAP BEx Query designer, Report designer, BEx web analyzer, Business Objects 4.0/XIR3/R2,Desktop Intelligence, Dashboard, Web-Intelligence, Info View, Universe Designer, IDT, UDT, Crystal report enterprises, (BOBJ)

Operating Systems: Windows 98/2000/2003/ XP/Vista, UNIX, Other Tools: MS VISIO, MS Outlook, MS Word, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential - Houston

SAP BO Developer

Responsibilities:

• Creating a reporting using BEx Query designer, defining filters, creating characteristic structures, and key figure structures, like ( Restricted key figures, calculated key figures) Creating Selections and Formulas.
• Generating reports and performing data analysis using BEx Analyzer tools, analysis toolboxes and BEx design tools, like(conditions, exceptions, and etc) Performing information analysis in Bex analyzer, like applying filters and navigation options thing like ( Back one Navigation Step and back to start, Drilldown, swap, convert to formula, Sorting and etc)
• Designing Business Objects Universes . RELATIONAL Universes and OLAP resources using IDT, Things Like Local project, Session, Data Foundation and Business Layer and publish the universes to the CMS repository to make resources available to the users.
• Designing Business Object Universes using Universe Design Tool ( UDT), like Personal connection, Secured connection, Shared connection and export the universes to the CMS repository to make resources available to the users
• Building a report based on BEx queries using the Rich Internet Application accessible from the BI launch pad and Web Intelligence Rich Client installed from the SAP Business Objects suite by using BICS connection.
• Creating a web Intelligence documents using Web interface, Rich Internet Application interface within the BI launch pad. and Web Intelligence Rich Client, a standalone interface depending with client request.
• Building a Web Intelligence reports using various prompts, report filters like Equal to Operators, Not equal to Operators, greater than operator, and less than operator and etc. Using swap a row or column, Breaks defined, Sorting, Alerting, Ranking, Drill-down, Creating charts, Highlighting data using conditional formatting, Filter by measure, Ranking data, Publishing, and sharing reports
• Creating reports Crystal Reports Enterprises tool with Standard, Summary, Cross Tabs, grouping, Sorting, totaling data, formulas, parameters, Alerts, formatting data elements, and etc.
• Restricting the data using the Prompts and filters. Graphical reports Developed using Cross tab, PIE and BAR Charts with Drill down option using Drill down Report and also using in combining the cross tab and vertical bar charts.
• Creating a Business Object Dashboard using different data source connectivity, like Web Service query, Web service connection, Sap Netweaver Bw connection, Crystal Report Data consumer, Interface Connection, Live Office and BI consumer service BICS
• Developing a Business Objects Dashboard reports (formerly known as xcelsius) using different visual components like (charts, containers, selectors, Single values, maps, texts.
• Building a unique Business Object dashboard using different properties like drill down, Behavior, appearance and Alerts, and so on. Using Art background components to make a report to be unique and clear to understand.
• Publish the dashboard, Save spreadsheet model and visualization file, Export as e.g. Adobe PDF, Excel, word, and Microsoft power point to the users.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Report.

Environment: SAP Business Objects 4.0 CSV files, flat files, Excel Safe. Vantage ERP

Confidential, Dublin, OH

SAP BI/BO developer/ Consultant

Responsibilities:

• Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DSO’s, Info Cubes, DTP, Info package, transformation, Multiproviders, and Infosets.
• Activated and installed required objects from Business content.
• Worked on extracting the data using LO Extraction and Generic extraction.
• Day-to-day responsibilities include analysis of data requirements and translation of these requirements into dimensional data models.
• Involved in Production support system like Process chain monitoring and ticket handing.
• Uploading master data and transactional data both from flat files and SAP R/3 Systems.
• Monitoring and Error handling in PSA like modifying the error records and reloading the data.
• Involved in front-end BI Components like Queries, Formula, Variables, Calculated Key figures, restricted key figures, Structures, Selections, Exceptions, and Conditions Developed Queries using Filters, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies, etc.
• Creating BW reporting using BEx Query designer, BEx Analyzer, BEx WEB Application Designer
• Involved in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using Business Objects 4.0/XIR3/XIR2/6.5.
• Exposure to Business Objects XI Enterprise suite using Desktop Intelligence, Designer Web Intelligence reporting.
• Creating reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, grouping, sub reports etc.
• Creating reports using Infoview with Graphical,bar pie charts, Cross Tabs, sections,breaks and publish reports also etc.
• Designing Business Objects universes, complex BOBJ reports both full client and Web Intelligence Reports.
• Develop Xcelsius (Dashboard) and Crystal Reports
• Performed the Integrity check and finally exported to the repository.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Used supervisor module for disabling / enabling access to documents and access to universes.

Environment: SAP BW, BI 7.0, BO, SAP ECC 6.0, Windows 2003

Confidential, Boston, MA

SAP BI/BO Developer

Responsibilities:

• Extensively worked in Business Information Warehouse Info Cubes, DSO Objects, Data sources, Info objects.
• Worked with PSA in monitoring the data transfer from source system into BI.
• Created Info packages and scheduled them in order to load Master and Transactional data from SAP R/3 as well as flat file source system into BI.
• Created several DSO objects which act as data staging.
• Configured Data sources in R/3 by using LO Cockpit (LBWE) initialized the setup tables.
• Involved in Data source Enhancements.
• Involved in the upgrade preparation of BW Extractors from R.3 4.7 to ECC 6.0. Checked the validity and consistency of all Extractors prior to and post upgrade.
• Involved in identifying test scenarios, i.e. extractors, process chains, user exits and programs
• Involved in Managing of Info Cubes, which involves Info Cube Content, Performance issues like Indexes, Statistics, Compression of Info Cube and Rolling up the data to the Aggregates.
• Designed various BEx Reports using Formulas, Selections, Structures, Calculated Key Figure and Restricted Key Figure.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Involved in migration and deployment of the universes and reports acrossmultiple domains
• UsedBusiness Objects DeveloperSuite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Designed and Build Universes, Classes and objects for Category Management System.
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the Objects like Dimensions, Details and Measures, which are grouped into Classes and Checked the Integrity of the Universes. Also created some universe level filters.
• Exported the universes to the repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Use of Reporter, Designer, Query Panel and Data Provider; handling of ODBC issues
• Worked on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• Developed three types of reports like Graphical Reports, Data Dump Reports and formatted Reports in Web Intelligence as per the requirement from clients.

Environment: s: SAP BW, BI 7.0, BOBJ, SAP ECC 5, 6.0, Windows 2003

Confidential, Huntsville, AL

SAP- BW/BO Developer

Responsibilities:

• Involved and developing different type of objects like Info objects, Info cubes, DSOs, DTP, Transformation &Multiproviders.
• Exposure on Data loads on which run daily and weekly basis and various process chains that are running in BI 7.3 system.
• Data Sources, Maintaining the Extract Structure, Generating the Data Source.
• Worked on BEx Query Designer in designing queries using Columns, Rows and Free Characteristics detailed drill down data analysis to required level of information.
• Involved in frequent client meetings to discuss project status.
• Created Start Routines, transformation routines for ODS and Info Cubes
• Created Process chains for all Master data and transaction data loading from acquisition layer to data warehouse layer, and finally to architected data mart layer.
• Optimize system by means of RRI, compression, aggregation, partitioning, line-item dimension.

Environment: s:: SAP BW, BI 7.0

Confidential

SAP BI/BOBJ Developer

Responsibilities:

• Documentation in the area of change management.
• As a team member I was a part of the BW Admin team which involved data load administration, transports management and handling problem tickets.
• Contribution to Support Role.
• Actively involved in life cycle implementation of SAP BI in SD and MM.
• Created InfoCubes based on data extracted from different modules like SD, MM.
• Involved in creating functional specification documents and technical design documents.
• Creating and Managing dataflow using DTP, Transformation and Info packages.
• Monitor the data loads from various source systems like R/3, by means of process chains.
• Analyze the errors in the data loads and report to the corresponding team.
• Manage master data, text and hierarchies.
• Manage the data targets by having the correct and up to the date data.
• Reconstruct the data requests from PSA in case of data load failure.
• Roll up data from infocubes to aggregates, edit and maintain the aggregates.
• Re-initialization of business area in case of inconsistency in data targets.
• Importing transports from the development systems to the production system.
• Perform pre-manual and post manual actions while importing the transports.
• Study and analysis of cross transporting. Designed Technical spec as per the functional spec with Universe and reporting solutions.
• Designed Business Objects Universes. Used Contexts and Alias to resolve the Loops.
• Developed reports using various functions, operators, report filters and variables.
• Worked on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• Created reports containing formatting options such as Grouping, Sorting, Alerting, Ranking, Field highlighting, Drill-down, Parameter prompt.
• Designed a complex report with 15 tabs with multiple queries underlying.
• Worked with the Business analysts and Subject Matter Experts to thoroughly understand the different business processes and data at various sources.
• Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Exported the universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Worked on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• Developed three types of reports like Graphical Reports, Data Dump Reports and formatted Reports in Web Intelligence as per the requirement from clients.
• Created reports containing formatting options such as Grouping, Sorting, Alerting, Ranking, Field highlighting, Drill-down, Parameter prompt.
• Developed reports using various functions, operators, Calculation

Environment: SAP BW 3.5: BI 7.0, SAP Business Objects XIR3(BOBJ)

Confidential

SAP BW/BOBJ Consultant

Responsibilities:

• Involved in the requirements gathering, data analysis and data modeling.
• Developed Multidimensional Data Models using Extended Star Schema.
• Worked extensively on AWB in creating and activating the InfoObjects, InfoProviders, ODS, InfoSources and Data Sources.
• Developed Transfer and Update rules per the Technical Specifications.
• Created the Aggregates to improve the query response time.
• Loaded the master data from flat files.
• Created InfoSets to provide the reporting off of the ODS for higher granularity.
• Created MultiProviders.
• Extensively worked on the BEX analyzer, BEX Browser.
• Developed flexible queries using filters and navigational attributes.
• Defined Calculated Key Figures, Restricted Key Figures, and Formula Variables for customized reporting using BEx Analyzer, Query Builder, and BEx Browser.
• Designed and Build Universes, Classes and objects for Global Long-Term Forecasting system.
• Created reports containing formatting options such as Grouping, Sorting, Alerting, Ranking, Field highlighting, Drill-down, Parameter prompt.
• Developed reports using various functions, operators, Calculation

Environment: Business Objects XIR2(Designer, web intelligence, desktop intelligence)Data Stage 8.0v,CSV files, flat files, IBM AIX, Oracle 10g, Toad 9.0