PROFESSIONAL SUMMARY:

• Overall Twelve plus years of IT, functional experience with knowledge in Implementation, Upgrade and Support in SAP BI/BO/BODS/HANA. Experience in SAP HANA - Data Modeling, data provisioning, Reports development and SAP HANA Modeler.
• Worked on SAP HANA Modeler (HANA Design studio), Designing Schemas, and Creating Packages, Attribute View, Calculation view, Analytic Privileges, Stored Procedures, CE functions and model consisting of replicated SAP tables.
• Strong expertise in SAP HANA Data Provisioning and Replication techniques like SLT, SAP BODS 4.0/4.2 and Direct extractor connection (DXC)
• Experience in SAP BOBI 4.1, 4.2 building Universes, Dashboards, and WEBi Reports by extracting data from HANA information Views, BEx Queries and SAP BW cubes.
• Experienced detailed design, hands-on configuration, system test planning, system test execution, User Acceptance Test planning (UAT) and execution, super user training, Go-live and Production support. Worked on Blue Print, Data Modeling, Designing, Documentation, Development to till Go Live and Support.
• Extensive experience and expertise in SAP BI/BW Extraction (Generic /Standard), Modeling and Reporting (i.e. Back-end and Front-end). Good at implementing SAP BW with different SAP data source, Worked as Solution Architect for various BW Landscape.
• Strong in Configuration of Data targets, Data sources, Info objects, Key figures and Multi providers
• Configuration of Transfer Structure, Transfer Rules, start routines, Transfer routines, Update routines and End Routines.
• Experience in analytics of corporate performance, employee time management, and predictive analysis. Experience in advanced analytics like executive dashboards, scorecards, alerts, subscription push reporting, predictive analysis, etc.
• Worked on SAP BO Universe Design, Web Intelligence, Crystal Reports, Lumira and Xcelsius.
• Expertise in front-end Business Warehouse (Bex Suite) components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Customer Exits, Variables, Exceptions, Conditions, RRI, Ad-hoc Queries.
• Development experience of Extractors, Info Objects, Info Sources, ODS Objects, Basic Info Cubes, Transactional Info Cubes, Info Packages, Volume sizing estimates and establishing Data classes, Roles and Authorizations, Info spokes.
• Enabled Single Sign on (SSO) feature, imported SAP BI roles into Business Objects, enabled automatic imports of SAP BI users, managed users, applications, security, Universe management, groups in Central Management Console (CMC).
• Development, testing, documentation, requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support. Involved in building reports using SAP BO 4.0 and integrating BO with BI and HANA.
• Strong on End-to-End SAP BW Configurations and Customizations from Extraction experience.
• Experience in OLTP extractions of SAP LO-Cockpit, FI-GL, FI-AP, FI-AR, SD, MM, PP, CO-PA, HR generic extractions and non-SAP source systems. Experience in extraction from Flat files, SAP data marts, Non SAP data sources.
• Good knowledge of SAP BW/4HANA on SAP/4HANA Architecture and modeling techniques.
• Excellent communication and presentation skills. Reputed for dedicated teamwork, solid work ethics and Commitment to achieving various Goals and key objectives. Good academic performance, analytical, and problem-solving skills.
• Experience with functional designs, converting functional designs into technical designs, detailed design, hands-on programming, performance tuning of RICEF objects, SQL, PLSQL, ABAP tracing, ETL and Data Mining.
• Focused on reuse, granularity, modularity, compos ability, componentization and interoperability or applications and technologies. Good understanding of Sprint, Scrum and Agile dev. and delivery.
• Communicate effectively with client, project management and team members.
• Experience in technical and functional upgrade. Serviced identification and categorization, provisioning and delivery, and monitoring and tracking.

TECHNICAL SKILLS:

SAP: SAP Net weaver 2004s BI 7.1 Ehp1/7, SAP BW (3.5/3.1C/3.0B), Visual Composer, SAP BOBJ/BO (XI 3.1/4.0/4.1), SAP ECC (5/6), SAP R/3 (4.7/4.6C/4.6B/4.5B), BODS, HANA, SLT, HANA Live, Lumira

Operating Systems Sun Solaris, HP-Unix, Win NT 4.0, Windows 95/98/2k/XP/Vista/7

RDBMS: Oracle10/9/8.x, MS SQL Server 2000, MS Access, Azure Data Lakes

Tools & Utilities: ABAP/4, SQL, IDOC, RFC’s, DB connect, Switches, Routers, Remedy

Web Technologies: HTML, XML, ASP, JavaScript, VBScript, Servlets

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. SAP BOBJ/BODS/HANA Consultant

Environment: SAP BI 7.4 SP09, SAP BOBJ/BO (XI 3.1/4.0/4.1), ECC 6.0, Oracle, Business Explorer, SAP HANA Modeler 1.0, BODS 4.2, AIX, MS SQL Server 2012, Rapid Mart, Lumira, Tableau 8.2, Agile

Responsibilities:

• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Strong experience in using BODS as an external system for ETL between ECC and BI.
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data using Data Quality transforms.
• Developed ETL and reporting solutions for Top X Expired Quals, Qualification Compliance Trend Chart, Org Unit Data Chart, Road Map Action Plan, Expired and Expiring Quals, Compliance by category Chart and Expiring and Expired Quals chart for all Business Units for Training Qualifications Compliance.
• Experience creating schemas in HANA modeler and developed Calculation/Attribute views
• Experience in HANA Modeler, Data provisioning using SLT, DXC, BODS, and Flat Files.
• Experience in Export/Import wizard, hierarchies, Restricted and Calculated measures, Variable, input parameter, SQL Script, procedures, Currency conversions, hyperlinks, Joins and Managing Modeling content.
• Responsible for understanding, in collaboration with business representatives, how different data elements are used by the business in production systems, and how those data elements then should be reflected in reports. Along with the ability to translate raw data and information sources into practical, usable reports and other vehicles that support decision-making.
• Worked independently with little direct supervision effectively in a highly complex, entrepreneurial and often in high-pressure environment.
• Experience SAP Lumira Datasets, Visualization, Stories and Documents.
• Experience building Lumira acquiring data from Excel, SAP HANA Views, Universes and text file.
• Analysis of Office installation and setup, Configuration with BW Bex queries and RDBMS connections
• Experience working as onshore lead responding client issues during US working hours and updating weekly/daily ticket status update of offshore team to management.
• Showcase the reports to the business after meeting the enhancement requests and resolving the issues and get an approval / sign-off for the report to GO LIVE into Production
• Strong interpersonal and communication written & oral skills to translate business requirements into technical solutions.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Data modeling (Dimensional & Relational) concepts including Star-schema modeling, Snowflakes modeling, fact and dimension tables.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.
• Worked on medium and high priority production tickets related to report design, data loading and data reconciliation as per the SLA with client.
• Worked on reports like HR data reports which showed the hourly rate of employee and Annual Salary. Developed custom extractor to fetch Timesheet data table to show snapshot of all status in time.
• Developed reports like employee head count which would give count of employee based on their Manager and work center, company code and region.
• Used Business Objects 4.0 to create various Universes with RDBMS as underlying data source and developing reports in Webi. Upgrade Reports, LOV’s, Prompts, Schedules and Merged Queries.
• BODS Job Server Configuration, setup, Repository development configuration with database, Creating and configuring job server, assigning jobs to job server, Job server scheduling using DS Administration console, Production support and development.
• Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT)
• Developed Real-Time Data Information models to support SLT replicated tables for SAP ECC.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Confidential, Union City, CA

SAP BOBJ/BODS/HANA Architect

Environment: SAP BI 7.4 SP09, SAP BOBJ/BO (XI 3.1/4.0/4.1), ECC 6.0, Oracle, Business Explorer, SAP HANA Modeler 1.0, MS SQL Server 2012, Rapid Mart, Tableau 8.x

Responsibilities:

• Full Life Cycle Implementation Solution Architect starting from Gap Analysis, Requirement gathering, prototyping, Realization, Go-Live to Support for HANA.
• Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT)
• Developed Real-Time Data Information models to support SLT replicated tables for SAP ECC.
• Transported objects by creating delivery units between SAP landscapes. Developed ETL jobs with heavy transformations for data acquisition from SAP ECC and Non SAP systems.
• Responsible for understanding, in collaboration with business representatives, how different data elements are used by the business in production systems, and how those data elements then should be reflected in reports. Along with the ability to translate raw data and information sources into practical, usable reports and other vehicles that support decision-making.
• Worked independently with little direct supervision effectively in a highly complex, entrepreneurial and often in high-pressure environment.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Experience creating hierarchy, measure, calculated measures, sorting, filtering, calculations, variables, and functions in SAP Lumira.
• Experience building Lumira acquiring data from Excel, SAP HANA Views, Universes and text file.
• Analysis of Office installation and setup, Configuration with BW Bex queries and RDBMS connections
• Experience working as onshore lead responding client issues during US working hours and updating weekly/daily ticket status update of offshore team to management.
• Showcase the reports to the business after meeting the enhancement requests and resolving the issues and get an approval / sign-off for the report to GO LIVE into Production
• Strong interpersonal and communication written & oral skills to translate business requirements into technical solutions.
• Experience in Advanced modeling concepts including Filter Operations, HANA SQL (CE), SQL Scripts, Procedures and Decision Tables.
• Worked on medium and high priority production tickets related to report design, data loading and data reconciliation as per the SLA with client.
• Experience in configuring SAP ECC, SAP BW systems with Data Services system.
• Experience in Upgradation from SAP-BODS 3.2 to SAP-BODS 4.2. Good Knowledge of Data Warehouse Concepts including Schemas, Dimensions and Facts.
• Experienced in Various Transformations like Validation Transformation, Merge Transformation, and Case Transformations etc. Involved in the preparation of test scripts, Unit testing, Source code reviews and performance tuning of objects during system and integration testing.
• Extensive experience in implementation of ETL methodology in Data Extraction, Transformation and Loading. In-depth knowledge of SAP R/3 system with expertise in LSMW, BAPI, and IDOCs.
• Knowledge on Address data cleaning on SQL, UNIX. Strong believer in team work, building cordial relation with people inside and outside the organization, self and fast learner.
• Worked on reports like HR data reports which showed the hourly rate of employee and Annual Salary. Developed custom extractor to fetch Timesheet data table to show snapshot of all status in time.

Confidential, Waltham, MA

SAP HANA/BOBJ/BI/BW Consultant

Environment: SAP BI 7.3 SP09, FI, SAP BOBJ/BO (XI 3.1/4.0/4.1), ABAP/4, ECC 6.0, Oracle, Business Explorer, SAP HANA Modeler 1.0, Unix, AIX, BODS 4.1, Lumira

Responsibilities:

• Involved in Full Life Cycle Worked as BI Solution consultant for various projects starting from Gap Analysis, Requirement gathering, prototyping, Go-Live to Support.
• Involved in HANA POC to validate the Master Data and Transaction Data Tables with multiple Analytical view, Attribute View, Calculation View, Restricted Measures and Calculated Measures.
• Created analytic and complex calculation views using SAP HANA modeler.
• Experience in SAP HANA data modeling using attribute view, analytical view and Calculation view.
• Worked on SAP HANA data provisioning using SAP LT replication server (SLT) and data server.
• Worked on SAP HANA provisioning, Delivery units and schema mapping.
• Worked on reporting techniques such as creating calculation views, managing attributes mappings, creating analytic privileges, adding variables, using system-generating joins.
• Created information Model in SAP HANA and created reports in BOBJ 4.1 for Sales and distribution modules towards Comparative Analysis for Actual Sales and Planned Sales
• Created roles and assigned them to users of HANA. Stored data in columnar and row store in Database.
• Developed and modified triggers, packages, functions and stored procedures for data conversions
• Experience in Lumira viewing, cleaning, manipulating and sharing data.
• Experience in Lumira Visualization-Creating charts, compose room-Creating stories with visualization.
• Created multiple Graphical Calculation Views including Projections, Joins and Unions
• Experience working as onshore lead responding client issues during US working hours and updating weekly/daily ticket status update of offshore team to management.
• Showcase the reports to the business after meeting the enhancement requests and resolving the issues and get an approval / sign-off for the report to GO LIVE into Production
• Involved in Production support activities like automating data loads and fixing all type of data loading issues on High priority. Handled various production support as well as ad-hoc user requests.
• Worked on medium and high priority production tickets related to report design, data loading and data reconciliation as per the SLA with client.
• Optimized the reports at the universe level and report level to enhance their performance which involved working on SQL parameters, aggregates and joins.
• Created Business Layer using Data foundation and defined @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Created the WebI reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions and Formulas etc. and several Queries (Union, Intersection, Minus)
• Worked with WebI for creating complicated reports including sub-reports, graphical reports, formula based, well-formatted reports, drilling reports, along with LOVs and data reports.
• Developed Crystal Reports and formatted the same with respect to the requirements, added parameters, special fields and used multiple data sources to create the reports.
• Created different Ad-hoc and Complex Canned Reports using Master/detail, Cross Tab and Charts for graphical representation in the reports.
• Developed executive dashboards using Xcelsius/Dashboards with Live Office, QAAWS and BICS connectivity’s.

Confidential, Stow, MA

Sr. SAP BI/BW BOBJ Consultant

Environment: SAP Net weaver BI BW 7.0/7.3, FI, SD, SAP BOBJ/BO (XI 3.1/4.0/R2/6.5), ABAP/4,ECC 6.0, Oracle, Business Explorer, SAP HANA Modeler SLT 1.0, SAP Design Studio 1.0, OER, P2P

Responsibilities:

• Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases of SAP BW -SAP BOBJ development project.
• Extensively worked on BW7.0 Data design and Data modeling, also worked on Tracking, managing and assisting with the defect resolution .
• Hands on Experience in Business Analysis skills to work with users to migrate current reports to new BI system.
• Worked with various data sources like SQL, SAP BW Bex Queries for BOBJ and Tableau front end report and dashboard development.
• Experience in designing and developing complex web intelligence ad-hoc reports and fine-tuning the reports using calculations, user variables, multilevel breaks, sorting, drill, slice/dice and alerting
• Experience in upgrade from 7.0 to 7.3, BEX Broadcasting and upgrade Admin Cockpit.
• Worked on reports like Demand Planning, Planned Orders, Workflow Metrics, Inventory Management to extract data from ECC from 2LIS 03 BF Goods Movement and 2LIS 03 UM Stock Revaluation.
• Developed data model for NPD intellect for Canada and US data, Gift Card Transactions, Bose Payment Plan, IS-Retail, Sell Thru Quota, Sell in Quota.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Designed Functional and Technical specifications for Implementation and Development of Sales and finance BI reports.
• Design schemas in HANA modeler and developed Calculation Views Attribute/Analytic using tools on HANA models for a Pilot Project.
• Active participant in full-cycle implementation of SAP BW and BOBJ (from project planning to go-live and post go-live support).
• Thorough knowledge of Security permissions, authorization objects, and roles within SAP BW and BOBJ, including SAP Authentication.
• Experienced with providing users with access to data by building reports and queries using tools including SAP BW BEx Query Designer/Analyzer, IDT, Crystal Reports, Business Objects Web Intelligence, reporting with MDX integration and/or other enterprise reporting tools.

Confidential, Commack, NY

SAP BI/BW BOBJ Consultant

Environment: SAP Net weaver 2004s BI 7.1 Ehp1/7, FI, SD, SAP BOBJ/BO (XI 3.1/4.0/R2/6.5), Visual Composer, ABAP/4, ECC 6.0, Oracle, Cogon’s, Informatica, Business Explorer, BCS, BPC, Crystal Reports.

Responsibilities:

• Lead as functional consultant to delivery and qualify SAP BI/BW definition and requirements, gap analysis, technical design build/development, testing and roll-out. Implemented SAP BW with different SAP data source. Used Cognos and Informatica for ETL & reporting.
• Active participant in full-cycle implementation of SAP BW and BOBJ (from project planning to go-live and post go-live support).
• Worked on Health plans for example chronic diseases coverage, physically and mentally challenged.
• Worked on reports related to State Health care reporting where Frx would report the expenses based on events the physicians and doctors attended which can be filed against rebate in income tax.
• Created reports Finance “Days Overdue analysis”, “FX Monthly”, “FX Global Exposure”, “Payment History by Document Type” and “DSO Analysis by Period” reports.
• Experience in creating Multi currency, Balance Sheet analysis, Profit & loss and cash flow statements.
• Design schemas in HANA and developed Calculation Views Attribute/Analytic using tools on HANA models.
• Generated Cost Center “Plan/Actual” report which provides an overview of the situation of primary and secondary costs and “Internal Order” report to provide an overview of the actual and planned costs incurred during reporting time frame on certain internal orders.
• Used SAP BW for DataStage to extract, transform and load (ETL) the data from various data sources FI/CO, SD, MM, and HR including the legacy systems and developed reports.
• Experience implementing break/fixes, report enhancements, debugging, troubleshooting and performance tuning (load failures/deadlocks) various complex issues.
• Hands on experience with Sap BW/BOBJ i.e. BW 7.3 and BOBJ 4.0 with Webi, Dashboard, AO.
• Worked on enhancing data sources like 0CA TS IS 1 and 0CA TS IS 2 for Timesheet data for approval and Timesheet Data Approved from CATSDB Table.
• Experience in Unit testing, system testing, integration testing and performance testing. Hands-on development experience with Business Objects WebI, Universe Designer, Live Office, Query as a Web Service (QaaWS), Lifecycle Manager, and Xcelsius.
• Experienced with providing users with access to data by building reports and queries using tools including SAP BW BEx Query Designer/Analyzer, Visual Composer, Crystal Reports, Business Objects Web Intelligence, reporting with MDX integration and/or other enterprise reporting tools.
• Experienced with enterprise-wide data modeling, database design, and building data structures and data mapping routines in SAP BW to support the data and reporting requirements for all areas of the organization.

Confidential, LA, CA

SAP BW/BI BOBJ Consultant

Environment: SAP ECC 6.0, SAP BI 7.0, SD, MM, PP,FI, PCA, SCM, ABAP/4, IP, Business Explorer, Xcelsius, Crystal Reports with MDX, BOBJ/BO (XI 3.1/3.2), WEBI, Query Designer, Report Designer

Responsibilities:

• Involved in the Blueprinting phase, gathering business requirements, analyzing existing SAP system and other interfaced systems and participated in the ETL architecture of Finance and Controlling modules using BI Administration workbench.
• Involved in Full life cycle implementation of BW BPS involves transitioning from BW-BPS to BI- IP.
• Worked extensively on FI-CO, SD, HR, COPA. Loaded the data from ECC to BI and used initialization with delta update and full update methods. Used SAP BW for Data Stage to extract, transform and load (ETL) the data from various data sources HR, PP, SD, and FI.
• Extensively worked for BW-CRM integration area like Services, Survey Confirmations, IBase, Activities, Opportunity management and ECC Logistics and FI.
• Created Generic Extraction from user defined tables and created transformations using ABAP routines.
• Designed and created complex process chains to automate the data load and data target administration.
• Developed Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.
• Created WEBI reports with Variables, Prompts and Complex Calculations to get Alerts for Xcelsius Dashboards.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.

Confidential, Houston, TX

SAP BW/BI Consultant

Environment: Sap Net weaver 2004S, ECC5.0, SAP BW 7.0, SD, FI,MM, Oracle 8i, Windows NT

Responsibilities:

• Involved in the development of the user requirements, testing, initial phase of production and thereby possessed a good understanding of complete life cycle implementation of SAP BW.
• Extensively involved in installing and customizing the standard BW business content to pull information from various source systems including SAP R/3, Oracle and flat files to load the data into InfoProviders.
• Worked on custom reports like vendors without materials, materials without vendors, spend data by material group, consolidated spend history, and purchase price variance.
• Customized InfoObjects to match report requirements by creating variables in BEx and creating InfoCubes based on the data content. Created MultiCubes such as Demand cube, Supply Cube and Inventory Cube.
• Created the required InfoSources (for flexible upload and direct upload) and InfoPackages to load the appropriate data into ODS via PSA for data staging. Uploaded transaction data into ODS objects from flat files and Oracle 8i. Multiple ODSs then fed the data into the InfoCubes and InfoObjects.
• Created and maintained transfer rules, transfer routines, update rules, and update routines to maintain data consistency.
• Designed and built the generic data source on VEKP, LIKP tables of R/3 by creating view on both tables on delivery numbers and document types. Wrote user exits and customized delta built up for these DataSources using V3 update.
• Created Conditions, Exceptions, Structures, and Variables to use them in BEx Reporting.
• Worked with Info Package groups and Process chains for effective scheduling and automation of various data loading processes.
• Developed authorization objects and profiles to restrict the access to the data model and queries.
• Worked with OpenHub feature for creating InfoSpokes in extracting the master data of the logistics, and material for exporting to a different SQL server.
• Responsible for the creation of Naming Convention document and other Documents for InfoCubes, ODS Objects, InfoSources, InfoObjects.

Confidential, Louisville, CO

SAP BW/BI Consultant

Environment: SAP R/3, BI7, BW 3.5, APO 5, SRM 4.0, ABAP/4, Business Explorer, MM, FI, CO-PA

Responsibilities:

• Involved in complete life cycle update (from preparation, business blue printing, realization and go-live) of SAP BW & APO in SD, MM and FI modules.
• Performed LO-Cockpit extraction to pull data from Sales and Distribution SD module into the BW system. Customization of datasources in CO-PA, LIS, HR, FI/CO and LO Cockpit to match the business requirement.
• Extracting the data from MM (Material Management 2LIS 03 BF data sources), and PP (Production Planning and controlling) modules.
• Wrote reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping details and partner function details. The tables used were VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, and MARA.
• Help project team in extracting data, interfacing BW with APO. Loaded Demand Planning and ATP relevant data from I2/APO into BW.
• Created ABAP routines in Update rules, Info Objects. Used custom exits in creation of Variables. Used debugging process for verification of extraction process.
• Worked on BI 7 for GATP relevant reporting on APO and Prepared the Sizing document by using Quick Sizer tool.
• Designed the Data flow for extracting Sales and Shipment Data from R/3 to APO/BW.
• Extracted data from the Planning Area (DP). Involved in Creating Planning Area's, Planning Book and generating CVC.
• Designed and developed several BEx Queries for LAG reports (ACTUALS VS FORECAST).
• Performed CTM Job for transportation. Filled Setup Tables.
• Built an interface by using tscopy for master data load in SNP from legacy database.
• Installed Business content for Sales & Operations Planning of SCM PP in BW side.

Confidential, Canonsburg, PA

SAP BW Consultant

Environment: SAP 4.7, BW 3.5, ABAP/4, Oracle 8.0, UNIX, Business Explorer, SD, MM, FI, CO-PA.

Responsibilities:

• Analyzed, designed and implemented OLAP cubes and reports in SD, MM and FI/CO modules based on end-user requirements.
• Designed, developed and implemented Info Sources for BW.
• Responsible for Sales and Distribution, Purchasing, Inventory Management, FI and CO InfoCubes.
• Extraction for LIS, LO Cockpit, SD, FI-GL, FI-SL and CO-PA modules.
• Used BW Content extractors to extract data from SAP R/3 to BW. Generic R/3 Data Extraction.
• Created/Modified Info-Sources for Master Data (Attribute and text) and Transaction Data.
• Modified the user exits to populate the custom fields added to the Datasources. V3 Updates, controlled by pull/push principle from OLAP system. Created/Modified and activated Transfer Rules and maintained Communication Structures. Created and Scheduled Info-Packages for Delta Initialization and Delta data loading.
• Loaded transaction data into PSA, updated data to ODS from PSA and activated ODS for reporting.
• Created Info-Packages group to schedule Info-Packages to load master data.
• Developed custom Bex Queries against the InfoCubes and ODS objects using Bex Analyzer.
• Extensively used calculated and restricted Key Figures. Created variables for the queries.
• Created Drill through Queries from summarized InfoCube report to detail ODS data.
• Published reports on the Web using BW Templates.
• Trained Power users on utilizing, developing and administering BW Queries.

Confidential, San Antonio, TX

SAP BW Consultant

Environment: SAP BW 3.0b, SAP R/3, Oracle 8i, SD, MM, FI

• Worked with Business Content as well as Creating Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains
• Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1).
• BEx Query Reporting, using Business Content, Generic extraction. Designed Three Info cubes with daily and Monthly Granularity, extraction from PSA.
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates to improve the query response.
• Dimensional modeling and extended star schema modeling.
• BEx Browser, BEx Analyzer, info objects, info cube, loading business content for BW, loading data via Flat files, developing data extractors.
• Administrating through BW Administrator workbench. Developed basic cubes for sales.
• Used ODS to stage the data before transferring the ODS contents to the Info Cube, Done ODS reporting to give details of delivery items and schedule line items.