SUMMARY

• Over 8+ years of IT experience in Implementation, Upgrade, Maintenance and Support in SAP BI/BW. Extensive experience in SAP BW - Data Modeling, Report development and expertise in Performance tuning.
• Expertise in various versions of SAP BW / BI with multiple implementation experience
• Experience with data integration ETL (Extraction, Transformation and Loading) from multiple sources in to Data Warehouse.
• Worked as a technical expert in SAP BW/BI and involved in two full cycles SAP BW Implementation from blue print to Go-live.
• Experienced in loading data from external source system like flat file (CSV), creating InfoObject bearing master data, Transformations, Data Transfer Processes, DSO, InfoCubes, Multiprovider and reporting using BEx Analyzer.
• In Depth understanding of multidimensional database architecture. Excellent knowledge in Star Schema, Snowflake Schema and SAP BW extended start schema.
• Experienced with BI Data Modeling, Data Extraction, Reporting, and Performance optimization.
• Extensively worked on all phases of BI/BW (Extraction, Transformation, Loading, Modelling & Reporting) and all components of BI/BW including Datasources, Infosource, DSO, ODS, Transfer/ Communication structures, Transfer/Start/Update routines, Infopackage, Update rule, Infocube, Infoset, Infospoke, Infoobjects, OpenHub, Datasource enhancements, Generic Data source, Extract structure enhancements, LO Cockpit, Bex Analyzer, Web Application Designer(WAD), ABAP etc.
• Involved in Data Load process, created Process Chains, and Data Validation.
• Extensive experience in creating BI data models (update rules, transformations, generic datasources, routines etc.) & BEx queries (CKFs, RKFs, Exceptions, and Conditions), workbooks and integrating them with BO tools
• Created canned reports, complex ad-hoc reports using Business Objects Web Intelligence tools.
• Functional experience in Sales and distribution, Leasing, HR, Core banking, Leasing, taxations, General Ledger, production, service etc.
• Excellent understanding of SOX and PCI requirements. Proficient with Agile Scrum Methodology.
• Experience in Design and Development of Queries, Reports and Workbooks, Web Application Designer (WAD), Web Report publishing using BEx Analyzer(RRMX) and BEx Query Designer and Crystal Reports.
• Worked on BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Design and development of Standard and Custom Info Cubes, Info Object and Info Sources, Extraction, Transfer Structures, Multi-Providers, Process Chains, Operational Data Store (ODS), Open hub service, User Exists and Business Explorer (BEx).
• Experience in OLTP extractions of SAP LO-Cockpit, CO-PA, CO-CA, FI-GL, FI-AP, FI-AR, MM, APO, Generic extractions and non-SAP data. Experience in Extraction from Flat files, SAP Data marts, SAP, Non SAP.
• Experience in OLTP extractions of SAP LO-Cockpit, CO-PA, CO-CA, FI-GL, FI-AP, FI-AR, MM, APO, Generic extractions and non-SAP data. Experience in Extraction from Flat files, SAP Data marts, SAP, Non SAP.
• Generated reports on InfoProviders and Multiproviders using Structures, Restricted Key Figures, Calculated Key Figures, Cell editors, Characteristic Variables, Text Variables, Formula Variables, Exceptions, and Conditions.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Good knowledge of Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Excellent working knowledge on SSIS.
• Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Good Knowledge on ETL tools like SSIS and Informatica Power Center.
• Extensive experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.

TECHNICAL SKILLS

ERP: SAP R/3 (ECC 6.0), SAP BW 3.5, BI 7.0 (NW 2004s)Business Objects XI 3.0,3.1, Business Objects BI Platform 4.0, SAP Business Objects Data Services

SAP modules: BW Net Weaver, MM, FI-CO, and SD.

Reporting: BEx Analyzer, WAD, Webi, Crystal Report, Crystal Xcelsius

Data bases: Oracle9i/10g/11g, SQL Server, Teradata, MySQL, DB2

Database Tools: SQL * PLUS, Toad for Oracle Base (10.6.1.3)

Office Tools: MS Word, Excel, Access, Outlook, Power Point

Operating Systems: Windows/XP/2002/2003/7, Unix.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SAP BW/BI

Responsibilities:

• Analyze end to end data flows from R3 all the way down the SAP BW reporting environment to track and fix all data issues which occurs in any of the BW Object like Infoobject master data, ODS/DSO, Info cube, Infoset joins, Multiprovider field selection etc.
• Enhanced the SO data sources to include customer department partner function and reloaded all the impacted object from R3 all the way to the DSO and modified the infosets, Bex and MDX queries to reflect the same.
• Running restatement process in SAP BW to correct Authorized Futures numbers in the impacted DSOs all the way down to the Infocubes using flat files and specially created Infopackages.
• Delete the sales docs which have incorrect values when compared to R3 from the InfoCubes and reload from base ODS.
• Using Setup tables in R3 repull the order data where the data is incorrect in both the cubes and the base ODSes.
• Worked on using transactional ODS (Direct Update) to stage application data in BW in its virgin state with minimal transformation except where required to confirm to DW data formats which decoupled environment to support high-volume loads into the other DW layers. Maintained TODS using custom code allowing for table partitioning and surrogate key assignments.
• Extensively worked on creating Bex queries to report various sales matrices for all the Geos globally using Structures, Variables, conditions etc.
• Performance tuning the long running Bex query for optimal output delivery using RSRT, ST05.
• Using BW statistics objects for performance tuning.
• Resolve reporting discrepancies between the reports and the underlying data sources.
• Ensuring that the Sales reporting applications are up and available to use in production
• Work with business and translate their needs to the Business Requirements documents and technical documents.
• Collaborate with the different technical teams in getting them delivered.
• Engage all the teams for the request and follow the software life cycle to have them developed and implemented in production.
• Provide exhaustive weekly project status reports to the management.
• Streamline the knowledge transition for new projects being implemented with the application handover process.
• Assess the risk factors that might impact the project and have mitigation plans which will be executed if the need arises.
• Work with the business and streamline the support process, identify gaps and bridge them.
• Built the technical and business competence of the team and equipped them well to provide smooth application support.
• Identifying design deficiencies and provide technical and functional solutions.

Confidential, Eden Prairie, MN

SAP BI/BO Developer

Responsibilities:

• Analyzing business requirements and developing queries and reports using BusinessObjects Webi, Crystal Reports and other web development tools like Infoview to provide Web-enabled data analysis solutions to business users.
• Extensively worked on business reports using BEx Query Designer as source for BOBJ reports (OLAP). Created Calculated and Restricted Key figure, Variable, Formulas, Selection and modifying/format the reports based on the user requirements.
• Involved in the Modeling Info Object with Master data, DSO and Infocubes to meet requirements.
• Created Aggregates, rollup and Multiproviders to optimize queries response time.
• Worked on the Universe Designer, Web Intelligence (Webi), Web Intelligence Rich Client and Crystal Reports.
• Created business reports using Crystal Reports functionalities like Charts, Cross-Tabs, Formulas, Parameters, Running Totals, Add Queries, Sub-reports and Drill down.
• Widely used Filters, Sections, Breaks, Variables, Sorts, Ranks, Alerter and Prompts to create reports on Webi and Crystal Reports that meet business user requirements.
• Applied Filters, Ranks and Alerter to restrict unwanted data, expose best and poor performers and highlight the data as required by users.
• Developed BusinessObjects reports using multiple Queries and combination of Charts and Tables.
• Created Crystal Reports based on existing Universes from Business Objects.
• Designed and organizedClassesandSubclassesaccording to the various Business requirements.
• Involved in discussion with business analysts and end user for Integration Testing of reports, documentation process and knowledge transfer
• Worked on reconciliation reports for data validation and exceptions handling.
• Trained Business end users onWebi (to create new query)andInfoview (view and run the reports on demand).
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions about interfaces.

Environment: SAP BI 7.0 Net Weaver 2004s, SAP ECC 6.0, BEx Analyzer, BEx Query Designer, Universe Designer, Webi and Crystal Reports.

Confidential, Houston, TX

SAP BW Consultant

Responsibilities:

• Actively worked on Designing, Modeling, data loading and testing of Master Data and Transactional data of content areas in SD (Sales & Distribution), Demand Planning etc
• Developed DSO objects to load Sales Order Data from the Data Source. Loaded Transactional Data into PSA and updated Data from PSA to DSO and Activated DSO Data for Reporting and Analysis
• Involved in installing business content from a request imported in development server
• Analyzed, designed and configured delivered, generic and custom BW data sources. Resolved issues of BW data extraction, data loading and reporting when integrating new development into a production environment.
• Designed and developed BW reporting architecture for an organization on an enterprise level, creation of functional requirements documents, design documents, tech and functional specs, pseudo code for ABAP development, test scripts and interfacing requirements with business users as required.
• BI development and modification which involved creation of Info Objects, Info cube, ODS, Info sets etc.
• Worked extensively on LO-Cockpit Extraction
• Involved in development/debugging of BI Extractors.
• Modifications according to design changes in BI environment.
• Creations of BI BEx queries as per the specifications.
• Testing of data compatibility between SAP R/3 and BI environment for all content areas

Confidential, White Bear Lake, Minnesota

SAP BW Consultant

Responsibilities:

• Gather and assess business information needs and prepare system and reporting requirements.
• Review and validate data loaded extracted, loaded, and transformed into the data warehouse for accuracy.
• Loading data manually on business requirement.
• Troubleshoot business issues and bring potential options to realization.
• Installed and activated the SAP BW Standard Info Cubes, ODS, Info Sources, Info Objects, BEx Reports and Web templates.
• Loading flat file according to the request of the user.
• Developed Infopackage and DTP for the data loads.
• Manually loaded data from source to target.
• Ensure to timely delivery of weekly and monthly report.
• To ensure team maintains timely movement of data into the data warehouse through management of data loads, resolving technical and timing difficulties as needed.
• Capture and analyze business needs and strategic information requirements
• Develop detailed analysis and design specifications with the Business Intelligence Application Developer and Data Architect
• Maintains support documentation for business users.
• Analyze and document business processes, business rules and metrics.
• Ensure to close the ticket within target period.

Confidential, Chicago

SAP BO Developer

Responsibilities:

• Interacted with Users and Business Analysts in gathering requirements and translate them to Technical specifications.
• Involved in preparation of project plan and installation of software’s.
• Used CMC to Import BW roles into BOE, create new Users, Groups, and Folders and assign them appropriate Log In and access rights depending on their Profiles ( As per BW Roles).
• Developing new universes based on SAP BW/BI BEx queries, Info cubes, Multi Providers.
• Developing WEBI, Crystal and Xcelsius Dashboard’s using LIVE Office, QAAWS.
• Created Crystal Reports using Crystal reports formulas, Grouping, Parameters, Hyperlinks, Sub Reports, Running Totals and Hierarchies to handle the end user requests.
• Developed publication to scheduled reports to run every day on a periodic basis.
• Developed Inventory, FIAR, Sales SAP Crystal Dashboards (Xcelsius) using Live Office, QAAWS.
• Documented use cases, Best Practices and involved in Unit Testing.

Environment: SAP BI 7.0, Business Objects XI 3.1,Webi,Crystal 2008,Xcelsius 2008,Live Office.

Confidential, CA

SAP BO Developer

Responsibilities:

• Interacted with Project Manager and Business Analyst to understand the requirements and modified universe to cater report specifications.
• Modified, tested and maintained universes.
• Extensively used multiple data providers for building reports.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Built Custom Hierarchies in universe to facilitate drill down in full client reports.
• Created and maintained Business Objects Web Intelligence reports.
• Analyzed BO full client reports using Slice and Dice, and Drill Down.
• Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Documented the deviations from the original specifications. And employed Enhancements on complex reports.
• Optimized the usage of user objects, conditions and universe level filters.
• As a Supervisor created Users and Groups.
• Experience in writing test cases and test scripts to validate the queries.

Environment: Business Objects 6.5, Oracle 8/9i, BO Designer, Web intelligence 2.6.x, Windows XP.

Confidential

SAP BW Developer

Responsibilities:

• Interacted with management for requirement gathering.
• Extensively involved in Activating Business Content for standard InfoCubes, InfoSources & InfoObjects of S&D and FI Modules as per the Client Requirements.
• Created and maintained Transfer Structures, Communication Structures, Transfer Rules and Updated Rules for InfoSources, ODS Objects and InfoCubes.
• Worked with the Transactional Data InfoSources to load data from SAP R/3 and Flat Files systems into SAP-BW.
• Created Info Packages and info Package Groups and Scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems into BW.
• Extracted Data from R/3 using Logistic, Generic, COPA extraction.
• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW.
• Worked with InfoCubes and ODS like Purchase, Customer, Deliveries, Sales Overview.
• Generated and Maintained Aggregates and Rollup activities on S&D InfoCubes as part of the InfoCube Management.
• Modified existing queries on various InfoCubes related to S&D. Extensively worked on Query Building, Filtering, Structures, Free Characteristics, Restricted Key Figures and Variables, Query variants using BEx Analyzer.
• Configured various Settings in Reporting Agent for Reporting Exceptions and Printing Query Results as Background Jobs.
• Developed Documentation for Meta Objects like InfoCubes and InfoObjects.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition and indexing of InfoCubesDeveloped Info Objects, InfoCubes, InfoSets, Multi-Providers, Operational Data Stores (ODS), Info Sources, Transfer Structures/Transformations, Transfer/Update rules and Process Chains.
• Worked on BEx Suite (BEx Query Designer, BEx Analyzer, Web Application Designer, and Web Analyzer).
• Worked extensively on Administration Workbench (RSA1).
• Created BO reports and dashboards.
• Designed custom master data enhancements for sales extractors.
• Developed complex loading procedure at the item level of detail.
• Worked on creating Multicubes, Multiproviders, Infosets.