PROFESSIONAL SUMMARY:

• 9 years of IT experience, with 7 years of effective SAP BI experience in designs specification, development, performance tuning, (backend and frontend) in SAP BI (Business Intelligence)/BW (Business Information Warehouse)/BO (Business Object), HANA (High performance Analytical Appliance).
• 1 years with SAP HANA
• Experience with HANA database
• Involved in one End to End implementation
• Familiarity with SLT tool, TDMS, LTR.
• Used of SLT for data extraction on SAP based platforms, BODS with Non - SAP databases.
• Used of Import and Export for transport.
• Created different views such as Attribute, Analytic and calculation views
• Familiarity with HANA design studio
• 5 years with SAP BW
• Experience in all phases of BW Implementation using ASAP methodology, three full life cycle implementation which include Requirement gathering, Gap Analysis, preparing technical and functional specification, business process analysis, data modeling, data loads, unit test, integration testing, user, and production support.
• Experienced in Data Extraction from SAP ECC (SD, MM, PP, CRM, HR and FI/CO), using custom and standard extractors with enhancements including LO-Cockpit.
• Expertise in the creation of Infosource, infobjects maintenance, developing and enhancing DSOs, Infocubes, MultiProviders, Extractors, Datasource and complex transformations.
• Experience in ETL process, Transformation Rules, Routines and Data Transfer Process (DTP).
• Maintenance, Installation and Enhancement of Business Content objects.
• Experience in Process chains management as well as Monitoring and scheduling the batch jobs.
• Expert in performance Tuning (Query and Data Loading): Aggregates, Compression, Roll-Up, Indices.
• Extensive knowledge of BEx Analyzer, and BEx Query Designer for developing reports.
• Experience in data loading (Full /Delta Up-Load) and Monitoring of data.
• Experience in calculated and restricted key figures, Variables, Exceptions and Conditions in BEx Query.
• Strong analytical, conceptual and problem solving skills to evaluate complex BW technical and functional problems and apply knowledge to identify appropriate solutions.
• Good understanding of Data Modeling using BW Extended Star Schema.
• Involved in managing of Infocube, which involves Infocube content, performance issues like Indices, Statistics, compression of Infocube and rolling up the data to the aggregates.
• Involved in the data extraction of LO-Cockpit.
• Good understanding of ASAP methodology.
• ABAP exposure thru start, update and end routines, currency conversion
• Good team player, Strong team orientation & leadership qualities, hardworking and enthusiastic.
• Experience with Non-SAP source of data extraction using Universal Data Connection (UD Connect)
• Familiarity with SAP search engine (OSS)
• Good experience of IP from planning models that incorporates data stored in Infocubes, views of data in Multiproviders, aggregation levels, characteristic relationships, methods used for changing data
• 4 years with SAP BO
• Hands on Business Objects clients tools, Webi, Advance Analysis Crystal Report sand Xcelsius
• Experience in creating report in BO, using query, block, global, and predefined level filters
• Great knowledge of UDT and IDT tools
• Experience in creating Universe, Universe connections
• Great understanding of BOBJ transport mechanism(Import Wizard, Life Cycle Manager LCM)
• Great knowledge of BOBJ migration ( Import Wizard, Upgrade Management Tool)
• Experience in writing simple SQL queries
• Use of Informatica, MSBI, Datastage, BODS, SLT for ETL purposes.

ENVIRONMENT:

• SAP BW 3.5, SAP BI 7.0, 7.1,7.3, R/3, 4.6c, 4.7 ECC 5.0, 6.0, Netweaver 2004, BEx Analyzer, Web Application Designer, FI, CO, MM, CRM, HR, SD, PP modules etc.
• SAP Business Objects 3.1 & 4.0, 4.1, 4.2( Web Intelligence, Universe Designer, Crystal Reports, Xcelsius Dashboard
• HANA SP08, SP09, SP10

EXPERIENCE:

Confidential, Plano, TX

SAP BO ADMIN

Responsibilities:

• Use of CMC
• Ensure system as well as data integrity
• Create users and group
• Maintain user, group and objects and delete unused objects
• Setup profiles
• Setup securities
• Create and maintain access levels
• Assist and resolve user issues
• Ticketing
• Assign access level

Confidential, Houston, TX

SAP BI/BO/HANA Consultant

Responsibilities:

• Used of SLT for HANA integration
• TDMS thru LTR for replication of data into HANA
• Created and worked with different views such as Attribute views, Analytic views and Calculated views.
• Used of the Controller Modules as well as Write Data
• Hana Studio
• Full end to end implementation with HANA
• Use of Hierarchies with hierarchy levels in Attribute views
• Familiarity with Package privileges, analytical privileges
• Used Webi tools in BO 4.1 to generate year wise, state wise, sales reports
• Used of UDT and IDT tools
• Created projects, connections, and published connections to repository
• Created data foundations
• Inserted tables, made joins and resolved loops
• Created classes, objects, hierarchies
• Used of transport mechanism such as Import wizard and Life Cycle Manager
• Used of Live office
• Worked with CMC and CCM
• Extensive reports created with Webi
• Created different type of filters such query level filters, report level filter, predefined filters
• Used of breaks and sections in the report
• Extensive used of sorting, ranking, conditional formatting
• Used of graphical chart linked with report created
• Use of drill to drill on the report to different levels in order to analyze report at a year, quarter, months level as well as state, city, and branch level.
• Involved in complete life cycle implementation of SAP BW using ASAP methodology as a team member, converting Functional Specifications into Technical Specifications and then to realization.
• Analyzed the requirements and identified the suitable business content for SD, MM and had the standard infocubes, DSO’s, Multicubes and various other relevant objects installed and activated.
• Used full features of BI 7.4 (DTP, Transformations, and DSO).
• Developed BW Queries, Testing and transporting through landscape.
• Extensive work on translation keys & Function modules for (DSO)
• Involved in testing extractors, data loads and reports before transporting into production.
• Enhanced extract structures by adding new fields and populating them
• Created the process chains to automate the data loads for transaction, master, text, hierarchies.
• Performed standard, application specific and generic extractions such as LO Cockpit.
• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW.
• Extensive work on Design & Development of Custom Cubes, DSO Objects, Multiproviders and Infosets; Enhancements.
• Delta Management.
• Modeled Data targets according to the reporting requirements.
• Performance Optimization by Tailoring Transfer Structures, Communication Structures, and Update Rules using routines and Start Routines.
• Developed various MM and SD reports such as DSO Analysis, Customer Sales Trend, Actual Contribution margin in Sales, Incoming Orders Analysis and Product Profitability Analysis in SD.
• Worked with SAP Open Hub service for sending the data from BW to External Systems.
• Provided complete end user and knowledge transfer to permanent staff.
• Unit testing for a particular unit that was developed
• Integration testing to check the DSO, Cubes, Multiproviders that were built
• Regression testing across the board
• User acceptance testing to make sure reports are working as needed for the end users

Environment: HANA SP10 BO 4.1, SAP BI 7.4, ECC7.0 MM, SD, SAP Netweaver 2004s

Confidential, Houston, TX

BW Developer

Responsibilities:

• Worked in BO for reporting, designing universes, setup parameters, build queries
• Inserting tables, making joins, resolving loops through used of aliases or contexts
• Creating classes and objects
• Hierarchies setup
• Extensive Webi reporting
• Used of break, section, ranking
• Worked on Object maintenance
• Worked on Role maintenance
• Worked on Authorization maintenance
• Conducted End user
• Involved in analyzing BI Data Load Schedules for SD, MM Master data and transaction data.
• Developed Process Chains to load Master data and transaction data, scheduled the process chains for daily, weekly and monthly loads. Monitoring the process chains in the development box
• Experience in production support, data loads, validation and trouble shooting of transaction data and master data, change management, transport management, roles and security, system checks, performance tuning and process chain
• Worked in BEx Analyzer in building queries and saving workbooks and created custom queries using Conditions, Exceptions, Variables and Structure and created aggregates for frequently used queries, RRI - Jump queries and trained End-users
• Worked extensively with BEx Analyzer and Query Designer. Developed queries and workbooks using BEx Analyzer according to end users requirements.
• Customizing the reports by creating variables, exceptions, and conditions, restricted and calculated key figures in queries.
• Involved in different types of testing: Unit, Integration, Smoke, Regression and User acceptance
• Use of SQL queries for Selection, Update, Insertion and Deletion of fields.

Environment: Net weaver 2004 BW, Enterprise Portal, SAP BI 7.3, ECC6.0, SAP BO 4.0, Modules implemented: SD, MM

Confidential, Minneapolis, MN

SAP BI Consultant

Responsibilities:

• Worked in functional areas FI-AR, FI-AP, FI-GL, SD, MM, HR and Logistics (SD&MM) for backend development and front end reports.
• Installed standard FI-GL, FI-AP, FI-AR, SD, and MM from business content. Developed ODS and Cubes based on the data sources 0FI GL 4, 0FI AR 4, 0FI AP 4, 2LIS 11 VAHDR, 2LIS 11 VASTH, 2LIS 11 VASTI, 2LIS 11 VAITM, 2LIS 11 VAKON, 2LIS 11 VASCL.
• Used generic extraction to extract data
• Designed custom InfoCubes for company wide Sales, delivery, billing with various aggregate periods, Designed Multi-Cube based on Sales, Delivery, Billing cubes, ODS.
• Extensively used BEx analyzer to create queries and workbooks, Used process chains to schedule batch jobs, monitoring and error handling.
• Worked with Flat File Interface in loading corresponding Master Data Order / Delivery, Extracted data from flat files for Master data and Transactional data. Mapped R/3 fields to BW InfoObjects in transfer structure during the creation of transfer rules.
• Created Info-Packages and scheduled night jobs to run using the BW scheduler and handling Process Chains, Created communication structure and Info-Sources, creating update rules using different options (source Info-Object mapping, constants, routines, automatic master data read). Designed and created several Queries using BEx Analyzer, with drilldown functions, calculated key figures using formulas and variables.
• Optimized load performance and query performance.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data.
• Included DTPs in the Process Chain for that automatic scheduling of data loads.
• Translated new requirements into Functional Design and relayed information to team members.
• Involved in the requirement analysis gathering meetings and was solely responsible for developing technical and functional specifications
• Worked on Finance extrators and enhanced some already existing programs
• Supported production and fixed issues that developed.
• Use of IP to define the scope of a full implementation

Environment: SAP Netweaver 2004s, SAP BI 7.0, ECC 6.0

Confidential, Houston, TX

SAP BI/BW Consultant

Responsibilities:

• Involved in complete life cycle implementation of SAP BW using ASAP methodology as a team member, converting Functional Specifications into Technical Specifications and then to realization.
• Analyzed the requirements and identified the suitable business content for SD, FI/CO and had the standard infocubes, ODS’s, Multicubes and various other relevant objects installed and activated.
• Used full features of BI 7.0 (DTP, Transformations, and DSO).
• Developed BW Queries, Testing and transporting through landscape.
• Extensive work on translation keys & Function modules for (ODS) to do Currency conversions.
• Involved in testing extractors, data loads and reports before transporting into production.
• Enhanced extract structures by adding new fields and populating them with the user/function exits in CMOD.
• Created the process chains to automate the data loads for transaction, master, text, hierarchies, currency exchange rate tables.
• Performed standard, application specific and generic extractions such as LO Cockpit and FI/GL extractions.
• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW.
• Extensive work on Design & Development of Custom Cubes, DSO/ODS Objects, Multiproviders and Infosets; Enhancements on Accounts Receivables (AR) cube 0FIAR CO2.
• Delta Management.
• Modeled Data targets according to the reporting requirements.
• Performance Optimization by Tailoring Transfer Structures, Communication Structures, and Update Rules using routines and Start Routines.
• Developed various FI/CO and SD reports such as DSO Analysis Current Period, Days overdue Analysis, Customer Sales Trend, Actual Contribution margin in Sales, Incoming Orders Analysis and Product Profitability Analysis in SD.
• Worked with SAP Open Hub service for sending the data from BW to External Systems.
• Provided complete end user and knowledge transfer to permanent staff.

Environment: SAP BI 7.0, FI, MM, SD, SAP Netweaver 2004s

Confidential, Houston, TX

SAP BI Analyst

Responsibilities:

• Created BI data architecture for ECC integration.
• Involved in decision making process for system landscape set up.
• Designed and recommended BI architecture and integration with SAP and non-sap systems
• Trained client IT team on concept of data warehousing, Business Intelligence and Analytics.
• Trained client IT team on details of the ETL process, OLTP and OLAP in BI 7. Also covered data modeling (Star schema concepts), strategic reporting and analytic, performance tuning etc.
• Fresh SAP implementation with ECC 6, and BI 7 including new dimension products; third party Point of Sale (POS) system to be integrated with ECC 6.0 and BI 7 for reporting and analytics.
• Involved in requirement gathering and realization phase currently. Day to day tasks involve 3.X migrations to RSDS emulations, Datasource
• Created multiple mockups and reports using Query designer.
• Provided recommendations for overall system design and involved in dialog with Process team regarding new requirements and related issues.
• Gathered requirements and developed several queries based on new FIGL Datasources. Queries included internal earning statements, external earning statements, balanced sheet, profit and loss and the use of cell editor and customer exits.
• Set up generic Datasources for complex financial reporting and profitability analysis.
• Designed large and complex Financial, Sales and commission reports for the entire company
• Created new objects to accommodate legacy source requirements including targets and necessary translations.
• Evaluated system settings and made recommendations to Basis regarding profile parameters, Data packet sizing necessary to deploy portal for the BI reports.
• Developed web templates for use with queries and deployment in Portal.
• Created several flexible end user authorizations based on the new Analysis Authorization to facilitate a more client complex security paradigms.
• Responsible in migrating 3.x authorizations to the new authorization concept.

Environment: SAP Netweaver 2004s, SAP BW 3.5, SAP BI 7.0, ECC 6.0, BEx Analyzer, Web application designer, Modules Implemented in BI: SD, MM, FI/COCRM

Confidential, Omaha, NE

SAP BI Analyst

Responsibilities:

• Worked in functional areas FI-AR, FI-AP, FI-GL and Logistics (SD&MM) for backend development and front end reports.
• Validated all the variables, formulas, text variables, restricted and calculated key figures, custom exits.
• Designed complex queries for Account Ledger using variables, calculated key figures, filters and conditions, Exceptional Aggregations.
• Understanding the client requirements and project functionality.
• Created Customer exit variables as per requirements in Reports.
• Used Report Designer tool for formatting queries.
• Involved in designing, developing Info Cubes, ODS objects, and loading data into them.
• Prepared technical documentation as per deliverables and Interacted with users for gathering information on reporting requirements.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
• Used Report Designer to format the Reports.
• Involved in Creation of DSO Objects and also worked with various options, which involves activating data in DSO and also updating the data in DSO to subsequent data targets.
• Creating SD, MM and FICO Bex reports and run in Bex Analyser saving as work books by using excel formulas.
• Involved in maintaining Multi-Providers for Purchasing Data and Sales Overview.
• Included the newly created DTPs in the Process Chain for that automatic scheduling of data loads.
• Used generic extraction (RSO2) to extract data from SAP R/3 to BW
• Involved in Creation of Reports such that the execution time is evenly distributed throughout the Report using Restricted Key Figures, Calculated Key Figures, Variables, Exceptions & Conditions and Structures.

Environment: SAP Netweaver 2004s, ECC 6.0, Modules Implemented in BI: SD, MM, FI/CO, WM