SUMMARY:

• More than 18 years of Technical and Functional expertise in SAP BI/BW versions 7.0. 3.5, 3.1c, 3.0b and 2.1c as an Architect, Lead as well as technical and functional consultant.
• Designed logical data models based on functional requirements and load strategy specifications to capture source data, data consolidation mechanisms and integration scenarios for reporting for SD, FICO, MM, APO, CRM, SRM, SCM and HR.
• Three (3) Years of functional and technical expertise in SAP CRM, Worked on Opportunity, Lead, Activities, Renewal and Survey.
• Eight (8) years of functional and technical expertise in SAP ECC. Involved in configuring CO - PA module for profitability reporting.
• Worked on Interfaces, RFC’s, BDCs, Interactive reports in ABAP, Report Painter, User Exits and SAP Script in FI, CO, HR, SD and MM modules.
• Expertise in front-end Business Warehouse components of Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Report Designer, WAD, I-Views, Web Items, Web Reports, CSS style Sheets, Java Scripting, HTML, Enterprise Portal.
• Working experience with Business Objects (BO) Universe and Crystal Reports reporting tool, Conceptual knowledge of BO Data Integrator (DI), Rapid Marts (RM) and other reporting tools like Xcelsius, Web Intelligence and Voyager.
• Conducted sessions for users in BW reporting, created manuals for the super users and end-users.

TECHNICAL PROFICIENCIES:

SAP BI NW7.4/3.5/3.x/2.x,BEx, SAP HANA 1.0 SP6, Business Objects Data Services 4.0 , SAP Lumira ,Visual Composer, Enterprise Portal, BO Suite, SAP R/3 version 3.x/4.x, ECC 6.0/5.0, SEM 3.5/4.0, SD, MM, HR, PP, APO, CRM, FI/CO, SRM, EBP,SCM, Oracle 9/8.i/7.3, SQL Server, Crystal Enterprise, ABAP/4, XML, MDX, FOX, SQL, Windows 2000/NT/ME/98, UNIX, Microsoft Project, MS Word/ Excel/ PowerPoint.

PROFESSIONAL EXPERIENCE:

SAP BI Project Lead

Confidential, Charollete, NC

Environment: SAP BI NW 7.4 SP 13,Hana SP 11

Responsibilities:

• Was part of Architect team working on SFR project system architecture design
• Was member of BW Core team and involved in designing several new project solutions, addressed several performance and production operation issues
• Worked on FI GL Line item, ADB extractors, APFA extractors, and custom extractor’s development, loading them to BW for reporting/planning and consolidation purposes.
• Worked in HANA modeling using HANA Artifacts such as Attribute Views, Analytical Views, Calculation Views, HANA SQL scripts, HANA Stored procedures, Table User Defined Functions, AMDP (ABAP Managed Database procedure), ADBC coding, ADSOs, Composite providers and reporting objects, DXC Ex
• Worked on establishing HANA development standards
• Worked on establishing Performance turning techniques in HANA Views, Creation of complex HANA SQL script based HANA views to flatten hierarchies to meet project needs.
• Worked on SLT project to configure and replicate ECC tables into BW HANA database.
• Worked on Archiving HANA data into SAP Sybase IQ database
• Integration of cold data from Sybase IQ data through SDA(Smart Data Access) and hot data from HANA into data modeling for reporting
• Worked on DXC Extractors
• Worked on several performances improvement projects. Performance tuning of Hot and cold data.
• Liaison between SAP and Confidential for project initiatives and issue resolution
• Liaison to performance testing team for all BW/BPC projects to address any performance concerns arises during integration testing phase
• Involved in many system upgrades such as NW 7.4SP7 to NW7.4SP13 upgrade, DB6 to HANA, BWA hardware swap between OBW to ABW, HANA SPS8 (85.05) to SPS11 (112.03) upgrades
• Worked on many performance optimizations and issue resolutions
• Worked on APFA extractors to extract cross-company expense items in third party AP invoices and AP credit memos flattened to their corresponding liability/payment items
• Worked on conversion of BPC audit data BW based reporting solution to HANA based solution
• Development of iGL reporting solution in BEX and UI5
• Supported BEX and EPM reports tools and addressed several performance improvements working directly with SAP. Worked on EPM drill through reports including across the systems. Used Tableau for query performance dashboard.
• Part of Dev tooling team that worked to harmonize development tools and reducing operational cost. Worked to establish maturity index and established 2017 goals for BI to improve operational excellence and reduce operational cost

Sr.SAP BI Architect

Confidential, Westlake Village, CA

Environment: SAP BI NW 7.4, Web DynPro, SAP MDM, SAP CRM - TPM, SAP Open Hub Interface, SAP HANA 1.X, Business Objects Data Services 4.0 , SAP Lumira 1.1.

Responsibilities:

• Built a full life cycle architectural design and implementation of data warehouse and business intelligence solutions for Confidential Company, Inc.
• Collaborate with businesses and teams to capture business requirements, evaluate solutions, define strategies, and guide the delivery of data marts and analytics to enhance enterprise planning and overall decision-making.
• Worked with Technical Architect to assist with the deployment and configuration of the system and also to produce estimates for the sizing of the data warehouse.
• Defined the standards for data modelling including content such as naming conventions for schemas, columns, abstract data types and standards for common data structures.
• Worked with the Business Analyst to understand the solution requirements, to select suitable solutions and propose new solution.
• Defined the security model that governs and controls user access to the system functionality and the data.
• Plan, track, and manage all aspects of multiple, simultaneous projects, from initial requirements gathering and blueprinting to design, build, testing, and go-live support.
• Worked closely with the data modeler to understand the data structures required to be populated and the business analyst and source system SMEs to understand and define data model to load logical volume Accrual, Incremental and Field Sales Target files into SAP BW for Promotion Planning Overview Report and Slotting Summary Reports.

SAP BI Project Lead

Confidential, Des plaines, IL

Environment: SAP BI 7.3,SAP CRM 7.0, Webi Xi 3.1, ECC 6.0, FI,SD,MM-PUR, DB2 and SQL

Responsibilities:

• Provided assistance to the project manager and other team members to produce and maintain project documentation templates, manage the project library, take minutes at meeting and manage time recording.
• Prepared Project Plan which defines the work schedule and resource allocation and also documenting the deliverables catalogue and managing the project costs.
• Provided hands on leadership, direction and guidance to design and develop a sustainable Enterprise wide Business Intelligence reporting framework and solutions
• Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders
• Assigning and managing work activities, meeting deadlines and developing project management reporting
• Developed cost estimates and timelines for detailed analysis, design and implementation
• Worked with SME’s and functional experts to gather detailed business requirements and drive functional and technical designs
• Created detailed solution documentation and presentations
• Managing support issues, ensuring performance optimization, planning and managing upgrades and enhancement packages
• Identified and executed business performance improvement initiatives.
• Responsible for transporting the objects up to Production Systems in ECC & BI
• Coordinated effectively with SAP Basis, Security and DBA team to resolve performance and data issues.

SAP BI Architect

Confidential, Richfield, MN

Environment: SAP BI 7.1,3.5, ECC 6.0, Bex 7.0, Enterprise Portal .

Responsibilities:

• Highly experienced in full lifecycle of SAP BI Retail implementation and involved in database Sizing, Data requirements gathering, Participation in Business Blueprint Workshops, Gap analysis, face-face to interactions with business teams and decision-makers to identify business requirements.
• Provided hands on leadership, direction and guidance to design and develop a sustainable Enterprise wide Business Intelligence reporting framework and solutions
• Lead the planning, data modeling, detailed requirements analysis and deployment of a project engagement for Inventory Management, Procure-To-Pay (P2P) & Revenue
• Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders
• Assigning and managing work activities, meeting deadlines and developing project management reporting
• Developed cost estimates and timelines for detailed analysis, design and implementation.
• Worked with SME’s and functional experts to gather detailed business requirements and drive functional and technical designs
• Actively Involved in Data modeling, Development, Data Extraction, Reporting, and Performance tuning, BI Statistics, Process Chains and BI Production Support and implemented using ASAP methodology.
• Developed and implemented the data approach, managed the detailed data work plan and data load plan, coordinate and manage the data load unit testing, Integration Test, Acceptance Test, Mock cutover and Production data load activities including overall cutover plan.
• Researched for SAP OSS notes when the production issues associated with the known problem.

Sr.SAP BI Arichitect

Confidential, Provo, UT

Environment: SAP BI 7,SAP CRM 7.0, Webi Xi 3.1, ECC 6.0, FI,SD.

Responsibilities:

• Highly experienced in full lifecycle of SAP BI CRM implementation and involved in Database Sizing, Data requirements gathering, Participation in Business Blueprint
• Workshops, Gap analysis, face-face to interactions with business teams and decision-makers to identify business requirements and define a Project Charter.
• Manage, align and conform KPI definitions from Legacy to SAP environment. Provide analysis, guidance and direction to COE regarding SAP BW and IS Retail configuration.
• Assisted Basis with performance and system configuration guidance regarding memory management and server group configuration, increasing Database performance and reducing memory overflow system errors.
• Stabilize a post go-live BW environment by correcting ETL logic, improving ETL performance and configuring ERMA data model.
• Researched for SAP OSS noted when the production issue associated with the known problem.
• Validated the functional requirements from the business analysts to make sure that what is being requested is in scope and can be delivered.
• Defined main components of the BI solution and strategies and guiding principles for analytics, data integration, data management.
• Defined the long term strategy and road map for business intelligence within an organization that aligns with the organizations overall business strategy.
• Proposed architecture conforms to the principles and guidelines of organizations enterprise architecture.

Sr.SAP BI Consultant

Confidential, PA

Environment: SAP BI, XI, ECC 4.6, BO XI 3.1, FI, MM, SD.

Responsibilities:

• Individually created entire design and scope document, Design Specifications for Implementing Confidential canada sales and Inventory .
• Understand the Risk & Controls and Technology strategy and in corporate into project/ work plans and resource/staffing plans for the delivery phase for the BI team.
• Designed a Data Model to meet the requirements from the Confidential business to create several BI Reports different SAP Modules.
• Extracted daily transactional data from External Source System (UPS) using XI Interface in the form of RFC’s.
• Worked on the Integration of SAP XI and SAP BI by creating generic classes, methods and XML Data source.
• Analyzed the business content in areas of Material Movement, Stock transfers, Inventory Aging, Inventory Snapshot, Inventory Adjustments and Goods Receipts.
• Worked on Cross - Application Performances analysis reports (CRM) which enables BI Business Users Activity Categories by Customer & Employee with an overview of the type of sales activities which work best for particular customers as well as an idea of how their employees work. You can also choose a time period for which you would like to display data.
• Derived the master data from SAP R/3 using the transactional data of external source system.
• Created few complex queries to meet the Confidential Canada sales, inventory and CRM requirements.
• Consolidated R/3, CRM and Data which got from XI Interface to meet the users requirements.
• Created new set of Web Intelligence and Business Objects Reports using complex formulae and sectioning the reports to meet the user requirements.
• Created/Edited Universes and applied row level and object level securities on groups and users.
• Created user objects including Dimensions, Details and Measures.
• Checked Universes for Integrity and exported them to the repository to make resources available to the users.
• Developed universes as per the requirements of the universe, deployed and maintained the universes. Troubleshoot if any issues were raised with the universes.
• Created web reports with multiple data providers and synchronized the data using merge dimensions option.
• Created objects using different Business Objects functions in the process of designing the universes.
• Developed Complex web templates and queries involving Customer exit, Web Design API interface with MODIFY CLASS, Client side programming with JavaScript and customized dashboards using Web Intelligence tool.
• Created interactive reports like Inventory status report and Inventory aging report.
• Documented the development by creating technical design specification.
• Developed BI knowledge transfer deliverable documents and conducted knowledge transfer sessions for client personnel.
• Worked on the BI reports to support French language.
• Working on design of a MultiProvider to consolidate the Confidential US and Confidential Canada data.

Sr.SAP BI-CRM Consultant

Confidential, PA

Environment: SAP ECC 6.0, BI 7.0, EP 7.0 CRM, HR, WAD 7.

Responsibilities:

• Worked on different CRM application involving Opportunity Management, Activity and Utilization Management, and Survey.
• Activity Cube enhancement with Survey Data (0SVY DATA 01) for Value engineering Section.
• Interfaced the Resource utilization cube with opportunity data for to analyze the actual days, hours taken by resource to create an opportunity.
• Re-modeled the data model and the data flow to optimize the performance of the Info cube dimensions by studying the Dimension to Dimension count ratio to balance the granularity homogeneously.
• Implemented complex Data Mart interface scenario with DSO updating several data targets
• Experience in Business Objects BO XI/R3.0 tool for Designing/Building/Managing Universes using Designer/Supervisor, building Ad-hoc/Canned reports using Full Client/ Web Intelligence, Report Developer and Crystal Reports.
• Developed and maintained complex process chain involving the complete data loading and activation scenario for several application.
• Created reports to Calculate Investment Vs Budget.
• Experienced with design, development and deployment of various reports in BEx and Web Application Server.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.

SAP BI-FI Lead Consultant

Confidential, WA

Environment: BI 7.0, SAP ECC 5.0, FI, CRM and HR.

Responsibilities:

• Project Blueprinting and Scoping for CRM Marketing and Campaign Planning using BPS
• Completely responsible for the Design and Configuration of the BW and BPS for the flow of actual and Budget/Forecast data to/from APO, R/3 and SEM/BW.
• Created the data model in BW to accommodate the Budget/Forecast data from APO, Plan Data from SEM and Actuals data from R/3.
• Extracted Internet Pricing and Congfigurator (IPC) information such as contract price, Manual price, and catalog price into BI for Enterprise Biding & Buyers reports.
• Integrated all the data in BW using Multi Providers and InfoCubes to create reports like Factory P&L, Income Statement and Sales and Production reports.
• Designed the Planning Layouts with Web Interfaces for Planning Sales, Departmental Expenses, Headcount, Overtime, FTE Hours and other Statistical Key figures at different levels of aggregation of Profit Center, Account, Material and Customer.
• Calculated the Budget Factory Cost, Cost of Sales, and Variable Expenses etc in BPS using the uploaded cost data and APO Sales and production data.
• Created real-time reports in APO using the remote cubes.
• Created planning applications for integration with CRM sales and marketing. Created several layouts for Marketing Element Planning & Campaign Planning with IPC using BI hierarchies uploaded from CRM.
• Create CRM planning profiles to use in BPS and assign to User Groups
• Worked extensively on BEx Analyzer. Used Navigational attributes, Filters, Exceptions, Conditions, Jump targets (RRI), Variables, Hierarchies, etc. Created Templates for WEB Reports.
• Managed the BI and SEM Security by creating Roles and Authorizations for different users.
• Conducted for End-users and Project Team members. Developed different BW and SEM documentations for different users based on their roles.
• Worked on the project plan with estimates for the ongoing BW implementation for HR reporting.
• Some of the Oraganizational Reports are percentage distribution of vacant positions and Overview Vacant Positions, Staff Positions etc.
• Developed Asset Accounting data model. Fed AA trasactions (transactions and annual values) and posted depriciations (period values) into respective datastore objects from tables ANEP, ANEA, ANLC and ANLP tables. These were further updated to annual and transaction infocubes summarized by cost centers.
• Developed 2008 Quaterly layering for Asset Accounting to enhance the performance of Assets reporting.
• Completely responsible for the Design and Configuration of the COPA, BW for the flow of actual and plan data to/from R/3 and BW.
• Designing COPA involves identifying the pricing conditions for Value fields, characteristic derivations and rules, transfer of billing documents, Enhancements required for Sales Analysis and Set up extractors for BW.
• Created Custom Infocubes/objects for the accommodating the global data available across the organization including CO-PA, CO-PC, CCA and CO-OM data from SAP and Non-SAP data using DB Connect and Flat Files.
• Worked on Stock Analysis and Intialization for Inventory management Reports.
• Designed the Planning Layouts with WEB Interface for Planning Sales at different levels of aggregation for different Sales Managers, Product Managers and the Regional Directors.
• Set up the methods for Retracting Plan data from BW back to COPA for the online reports built on COPA in R/3.
• Managed the BW Security by creating Roles and Authorizations for different users.

SAP BW/BI Lead Consultant

Confidential, NE

Environment: SAP BW 3.0b, SAP R/3 4.6c, SD, MM, Oracle 8i, UNIX

Responsibilities:

• Involved in the implementation of SAP BW, which includes Data-modeling, data extraction, generic extraction, data loading, scheduling, monitoring and web reporting for the MM, SD modules for the client.
• Responsible for design, development and extraction from R/3 Source system and flat file to BW for MM and SD modules & working with data flows.
• Handled assignments in the areas of activating cubes 0SD C01, 0SD C02 and a total of 9 custom cubes and 6 pre-delivered cubes were developed as part of the Global Deployment.
• Activated ODS (0SD O01, 0SD O02, 0SD O04) and its standard queries.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL.
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
• Designed ODS making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view. Other miscellaneous areas of work include activation of BW Statistics cubes, extensive work on custom-built hierarchies.
• Developed LIS customization, extract structures and data sources in sales material management to facilitate the data extraction to BW and to reporting using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user/function exits.
• Developed various queries for various categories like Brewing Process Loss, Brewing material Usage, Cost center variances, Warehouse Process Loss, Packaging etc.
• 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.
• Worked extensively on reporting for the extracted data and involved in creating role based security and authorization for all objects. Implemented BEx Broadcasting across the portal so that the Portal users can take advantage of the Knowledge management tools. (Like: Feedback, rating, downloads, discussion, subscription e.t.c).

SAP BW Consultant

Confidential, MA

Environment: SAP BW 3.5, SAP R/3 4.7, CRM 4.0, SD

Responsibilities:

• Served as SAP BW/CRM Techno-Functional Consultant
• Worked on different CRM application involving Opportunity Management, Activity Management, Service Processing and Survey.
• Good understanding of the CRMD tables for Header, Items, Business Partners and the products involved.
• Worked on new features in BW 3.5 involving the Enhanced web reporting involving the BEX Web items such as information broadcaster, Data provider information, and XML web item.
• Developed BW specific Function module extractor for different application in CRM to implement complex application logic at the source system level and keep the data flow in the BW environment smooth.
• Created a structure called customer classification extract structure containing customer number along with the classification fields.
• Unknown movements were mapped from Sherlock (Oracle DB) using DB Connect and bringing in the latest status information of these movements, based on Returned date.
• Created a generic datasource with function module based on this structure from table AUSP and KNA1 and used this datasource to update the classification data to Customer master.
• Enhanced Customer Master with Classification data like Stock reporting group, Pending closure date, Translation reliability, Closed location, Counterparts only, Products translation and Declaration characteristics.
• Re-modeled the data model and the data flow to optimize the performance of the Info cube dimensions by studying the Dimension to Dimension count ratio to balance the granularity homogeneously.
• Implemented complex Data Mart interface scenario with ODS updating several data targets.
• Developed and maintained complex process chain involving the complete data loading and activation scenario for several application.
• Developed Complex BEX templates and queries involving Customer exit, Web Design API interface with MODIFY CLASS, Client side programming with JavaScript and customized dashboards.
• BW has the limitation of 60 chars for an infoobject.One of the major development was to bring up the long text to the BW report involving Class, RFC to source and concatenating the columns to show up the long text in paragraph format. Involved in writing VB-code to generate COPA upload files for both R/3 and BW.
• Extensively worked on fine-tuning of the reports, used various tuning techniques which include building aggregates.
• Developed load strategy and created process chains to automate the process according to different load schedules - daily and weekly.
• Experienced with design, development and deployment of various reports in BEx and Web Application Server.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Created reports to compare actual Vs forecasted Sales and Daily sales tracking.
• Extensively used BEx analyzer, created queries with variables, filters, calculated key figures, restricted key figures, exceptions and conditions.
• Worked with end users in developing roles and personalized queries according to users so that they don’t have an option to view other reports.
• Experienced in development of Project Documentation, materials, requirement gathering, incorporating OSS notes and project management methodology.