SUMMARY:

• 15 plus years of results - driven solutions architect experience
• Headed teams and executed complex global SAP BW BI / BOBJ, HANA projects across various industry domains. Highly skilled in resource management, implementation methodologies, Issue/conflict resolution & rescue operations.
• Proven leadership track record in enterprise global BIimplementations
• Successfully led cross functional project teams from implementation through steady state delivery
• Very strong techno-functional skills in SAP BI, BO and HANA implementations
• Ensured consistency in solution design of Data Warehouse applications across the enterprise, as well as conformance to audit/regulatory requirements and industry best practices
• Superior communication skills
• Very strong problem solving, issue resolution and facilitation skills. Ability to effectively communicate with senior management, clients, and technical and management resources at all levels internally and externally

TECHNICAL SKILLS:

Skills: SAP BI BW 3.X / 7.0 / 7.3 SAP BOBJ 3.X / 4.X SAP HANA ECC 6.0 SAP R/3 4.6c/4.0 SAP CRM SAP BPC SAP SCM ERWIN, VISIO Solution Manager SAP ABAP/4 JAVA HTML, DHTML C, C++, VB SQL Server MS - Access Business Explorer Business Objects XI 3.X, 4.x Xcelsius, Dashboards Design Studio Micro strategy Web App Designer RoamBI Crystal Reports Lumira Qlik View Data Stage BO Data Services

WORK EXPERIENCE:

Lead Consultant

Confidential

Responsibilities:

• Data base Migration using DMO of SUM. Complex SAP HANA Models as a part of side car approach,
• Maintained Dimensions for Consolidation, Created Models for Consolidation and Reports in the EPM Add-In Microsoft Excel Interface and in EPM Add-In Microsoft Excel Interface
• Developed Account-Based Calculations for Reclassification and Managing Journals
• Configure and Run Currency Translation, Intercompany Bookings, Run Balance Carryforward and Business Process Flows (BPF’s).
• Involved in replication scenarios on SAP landscape transformation (SLT) with operational reporting and data mart scenario - HANA Modeling, Optimization
• SME in SAP HANA - BoH, BOBJ on HANA, HANA Studio (Side Car & Enterprise HANA Development), to Business and end users/shared services.
• Analyze Data in the EPM Add-In, Sorting, Filtering, and Ranking Data, Analyze Data with Account Types and Measures, Plan Actual Variance Analysis, Plan Actual Variance Analysis for local members, reporting on multiple sources, Creating Cell-Based Reports with Advanced Functions.
• Created EPM Functions for Dynamic Filtering, Periodic/YTD Variance Report out of box reports
• Create Reports with the EPM Add-In for Microsoft Word and Microsoft PowerPoint, Created Dashboards with Live Data and used Business Process Flows for Reporting and Drill Troughs for BW Queries
• Configured Real Time Info Cubes and related Planning Components, Setting Up Direct Input Data Store Objects for Planning in, Created ADSOs for Planning, Created Composite Providers for Planning Model BPC Local Providers
• Created DSO Planning Functions, Set Up Data Audit and Configured Work Status
• Complete BOBJ 3.0 reports Migration to BOBJ 4.1, redesigned Webi, Crystal, Dashboard and Design Studio Reports. Development of Lumira Story Boards. Migration BW 7.0 to BW 7.4, converted BW Objects to newer version. BPC Planning Layouts redesign to newer version of BPC 10.1 and reports.
• Building the carry forward and account transformation business rules, top down allocations, Budgeting
• Sales/Revenue Planning, Capital Expenditure Planning, Headcount/Staffing and Expense Planning
• Redesigned BW Objects (LSA++) and improved Performance of reports runtimes and data loads. Designed new aDSO Planning for direct update templates,
• Utilized Aggregation Level Maintenance in the BW Modelling Tool, local queries in BPC Embedded
• Redesigned existing un-used Cubes/DSO to newer providers such as composite, transient, virtual and advanced DSO’s
• Agile Modeling such as Open DSO Views - consuming external data sources without staging and without the need of separate of a BW persistence of the data.
• Developed Views, SQL Procedures, Joins, SLT Configuration and customization, data provisioning, security in HANA, encryption, logging and monitoring using HANA Studio, Extracted SAP and Non sources using SLT and Data services.

Principal Consultant

Confidential

Responsibilities:

• Developed Adoption Roadmap for SFIN and FIORI, Leveraging HANA Live for reporting and Analytics, Upgrade to latest EHP. Financial planning and analysis, Accounting and Financial close is in full scope of this project and the solution implemented on premise. Provided Real time analytics and faster financial close.
• Provided Best Practices for implementing S/4 HANA SFIN and SAP Update Manager with Data Migration Option (DMO) for Data Migration, Checking Custom Code, Activating Business Functions, Consistency Checks, Installation and Upgrade, Customizing SAP GL, New AA, Controlling, Migration of house bank of accounts, Data Migration (Partitioning Universal Journal Line items, regenerating CDS Views, Migration of Cost Elements, Enrichment of Data, Migration of Balances, Calculation of Depreciation and total Values, Migration with near Zero downtime).
• S/4 HANA Post Migration Activities such as - Run Reconciliation Reports to check data consistency, Validate Business Processes, Status of Application Indexes transfer, Fill and display of due dates in ERP Financial Documents, filling offsetting accounting ERP Documents, Testing Multi-dimensional reporting capability, testing closing improvement etc.,
• Developed Custom Views in BW on HANA enterprise and consumed in BOBJ reports
• SQL Procedures in HANA Studio and Integration with QlikView using ODBC and Direct connectivity using BOBJ tools including Lumira, Developed VDM’s using Smart Data Access between Hadoop, BW and HANA
• Migrate BW Objects to 7.4 and creating planning layouts (re-creation) and intercompany eliminations.
• Created custom and out of box security roles and authorizations, working with security to build role matrix
• Data Services and LT Configuration and real time replication scenarios to BW and BPC 10.1
• Data Integration, Data Profiling, Data Cleansing, and Data Integration and Data Conversion capabilities using Data Services and non-sap applications to SAP HANA
• Developed Predictive data sets and models which are out of box and custom using SQL (PAL)
• Blue printing, requirement gathering & creating documentation and closely working with Business in this process
• Re-designing BW/BPC data modeling, report & input template development, script logic, data loading process both BW and BPC, transformations, BPC security design and administration
• Developed Adoption Roadmap for SFIN and FIORI, Leveraging HANA Live for reporting and Analytics, Upgrade to latest EHP. Financial planning and analysis, Accounting and Financial close is in full scope of this project and the solution implemented on-premise. Provided Real time analytics and faster financial close.

SAP BI PM / Lead

Confidential

Responsibilities:

• Played an instrumental role in assessing the existing systems, evaluating the BI strategy and involving in sales activities with the client and SAP for Business Objects purchases.
• Provide leadership from a BI implementation stand point and involved in architecting the whole design of the BI architecture in to be system.
• Worked with off shore team as part of BO upgrade, developed new sales and FI reports in the upgraded system, deployed on both PC and mobile.
• Led & worked on project planning, blue printing, defining scope, time estimation, resource estimation, hiring the resource & managing the project budget and timelines including an offshore team for support during implementation and post go live.
• Successfully implemented Sales, finance, inventory reporting on both PC and Mobile using SAP Business Objects and Mobile BI Solutions.
• Worked on Sales and Financial dashboard for executive committee, using Qaaws.
• Designed a security framework within Business Objects for various roles within the organization

SAP BI BO Lead / PM

Confidential, IL

Responsibilities:

• Leading SAP BI BO implementation as part of the rescue effort to build and stabilize the SAP BI and BO environment.
• Worked on project planning, blue printing, defining scope, time estimation, resource estimation, hiring the resource & managing the project budget and timelines.
• Architect and develop functional and technical specs for Sales, MM, FI and CRM reporting needs.
• Developed functional and technical specs for Sales, Financials, Inventory and CRM info cubes, BI reports, BOBJ universes, BOBJ reports.
• Worked with on-site and offshore resources to develop the info cubes or multi-dimensional models within SAP BI, Universes using BOBJ universe designer, Webi and Xcelsius dashboards.
• Created customer 360 dashboards and Pipeline analysis dashboard using SAP ECC and CRM data.
• Managed on site and offshore resource for developing and deployment of all SAP BI and BO development and reporting needs.
• Performed multiple testing cycles using the onsite and offshore team for regression, volume testing of data models and testing the reports for user acceptance
• Led the client to build a center of excellence to manage and govern the landscape.
• Provided leadership to define the strategy to choose right tools and solutions, keeping in mind the companies goals.

SAP BI Architect

Confidential

Responsibilities:

• Leading SAP BI BO implementation right from inception, worked on blue printing, defining scope, time estimation, resource estimation, on both SAP BI and BO sides of the project.
• Conducted workshops for various streams of reporting such as sales (QTC), financials, inventory,P2P CRM and legacy reporting needs.
• Identified 320+ reports that need to be consolidated and integrated into the SAP Business Warehouse, performed gap analysis across the BI content and identified the gaps and effort that is needed to customize the standard content to meet the needs.
• Helped basis and security team to install the BI landscape, BI client tools and developer security for SAP BW and SAP BOBJ.
• Effectively managing onsite (3) and offshore (4) development team to minimize the implementation cost and to meet the milestones.
• Worked with the executive team and the sponsors (Both Client & Consulting) to identify the priorities for phased delivery of BI reports using BOBJ
• Worked with SAP support team closely to resolve and provide solutions for various BOBJ issues or bugs.
• Built various info cubes with complex data flow in sales, SAP BI reports that are used to create OLAP universes in SAP BOBJ for further reporting as WEBI reports and or explorer.
• Worked on developing a solid security framework for row level security based on the user login using ABAP, Analysis variables and BOBJ User security.
• Was responsible for multiple test cycles and multiple cutovers in alignment with SAP ECC cutovers for regression, volume testing and user acceptance testing.
• Was responsible for migrating the developed data models, reports, universes etc. to Quality and Production Systems.
• Successfully delivered the SAP BI, SAP BOBJ system for the user community and provided support as on need basis.

SAP BI Lead Consultant

Confidential, IL

Environment: SAP BW 7.0, SAP Net weaver 2004s, SAP R/3 6.0, SAP CRM, BOBJ XI 3.1.

Responsibilities:

• As a SAP BI Lead - worked extensively on the reporting needs based on the legacy reports / screens, end user requirements and analytics within the new SAP System.
• Involved in all phases of the implementation - Blue Printing, Setting up the landscape, Feasibility study, Sizing, Requirements gathering, Design, Development, Deployment and Support.
• Created various solutions such as APD’s for report extracts to feed CRM System for further analytics, Open Hub for high volume extracts, reports for segmentation in SAP CRM system, reports for visible system for planning etc.
• Designed the data model for generating tax reports, collection reports, dispute reports & analytical reports in SAP CRM such as segmentation queries, Campaign Reports, Analysis by Target Groups & Marketing Elements to build campaigns or target groups in SAP CRM system, CRM activity analysis to log and track the sales team work.
• Worked very closely with Business users, end users, SAP Functional resources, SAP Basis & SAP Security; played an important role in defining security roles, Authorization objects & reporting roles within SAP BI.
• Implemented the finance accounts receivables reporting to provide credit limits comparison to the open accounts receivable balance for the customers or groups and also provide aging trend reports.
• Implemented the finance accounts payable reporting to provide the spend analysis and cost development reporting.
• Designed a solution to integrate CRM target groups, campaign data with sales & shipment data in ECC.
• Designed and developed a solution for Employee Administration, Payroll, time and attendance as part of workforce management.
• Developed solutions to integrate Collection data, Finance, Dispute & fraud management data for analytical reporting based on collection Specialists or collection groups.
• Extensively worked on troubleshooting various issues within BI, ECC & CRM for better enhancement methods, load failures and long runtimes for load and reports.
• Worked on configuring BOBJ, Business Objects WebI, DeskI&Xcelsius. Helped to design complex reports using the latest functionalities in Business objects XI 3.0.
• Built complex reports integrating time and payroll using the HR multicube, for quarterly, annual overview.
• Worked on generating complex reports integrating SD and CRM data such as Current season sales by last season bought, sales by target groups, customer outbound information for number of customers mailed etc using info sets, structures within reports, user variables.
• Generated various extracts using APD’s and Open HUB for Optimization and a third party ABACUS reports.
• Performed the statistical setup for loading all the historical data in BW for MM, Purchasing and SD.
• Extensively worked on customizing Business Partner attributes from Marketing attributes & historical customer & prospect information.
• Designed and developed the automation of loads, extracts and also flat file loads based on ABAP/4 programming variants.
• Extensively worked on bringing out the suppression rules logics within BI and produced a report for decision making of the CRM team so as to decide which Catalog to send out to the customer. The report spanned on historical and current SD info based on Sales Org, Season and the dollar value the customer last purchased.
• Worked on design and development of Click information, customer outbound within CRM and worklist items, dispute Items and Collection Items in ECC.
• Successfully delivered the objects stabilized the system and fixed the defects as parts of post go live.

SAP Netweaver 2004s Solution Consultant

Confidential, OH

Environment: SAP BW 3.5, BW 7.0, SAP Net weaver 2004s, MDM, SAP R/3 6.0.

Responsibilities:

• Worked extensively on multiple landscapes for developing and supporting the upgrade from BW 3.5 to BW 7.0.
• Migrated all master data objects from BW 3.5 to BW 7.0 including the data flows, process chains and info package groups.
• Implementation of Scenario using (MDM Console, MDM Import manager, MDM Data manager, MDM Syndicator, MDM Publisher).
• Extensively worked on transport connection and ABAP workbench for transporting, changing and assigning the data packages.
• Was responsible for enhancing various data sources including master data sources and transaction data sources as part of the migration. Enhanced data source for appending fields in to the structure and filling them using User Exit.
• Monitored daily, weekly and monthly loads using process chains. Defining of Process chains for interdependent processes with tasks like Data loading, Index maintenance, Master data & ODS activation in achieving the best possible performance.
• Extensively worked on identifying error messages, problem solving, trouble shooting and OSS notes.
• Extensively worked on transformations and other data flow processes to transfer data from existing 3.5 systems to BW 7.0 System.
• Worked extensively on assigning the resource, time to various tasks and managing the same.

SAP BI Stream Lead

Confidential, Long Island, NY

Environment: SAP BW 3.5, BW 7.0, SAP Net weaver 2004s, SAP R/3 6.0, CRM 4.0.

Responsibilities:

• Life cycle implementation for SAP CRM and SAP R/3 ( inventory data), Involved in all the phases of implementation prototyping, gathering business requirements, design, architecture, development, deployment of the reporting requirements and support.
• Extensively worked on the Gap analysis to meet the current and future business requirements for call activity, connTrans and Inventory reporting.
• Was responsible for the design and architecture of the data model and underlying structures.
• Extensively worked on Call Activity (CRM), Home Office POC, Inventory (MM) and prototyping the same. Proposed and implemented a reporting solution for running reports on the web, broadcasting and background scheduling.
• Performed a health check for the existing BW system and proposed numerous solutions to improve the design and performance.
• Worked on redesign of the current data model for better performance of the reports.
• Worked extensively on CRM data sources such as Call Activity, Prescription Activity, Rx Credits, NGPS data, Inventory, Disbursement etc.
• Design and Development of Data targets in BW 7.0 for sourcing activity, Inventory and Master data.
• Extensively worked on transformations (Start Routines, End Routines, Expert Routines) etc to load data into various data store objects, Info cubes and master data objects.
• Worked on data extraction of SAP R/3 system using various extractors and non-SAP systems. Also worked on extending some of the extract structures by adding fields.
• Extensively worked on Query designer, Report designer, Web application designer for dashboard reporting and Enterprise Portal for providing access to the end users.
• Performance tuning using Aggregates, Rollups and Compression, Creating jump targets on various reports using RSBBS.
• Extensively worked on various web items in web application designer, customizations and also publishing the same on portal.
• Extensively worked on adding intelligence in the reports by creating exceptions, conditions and thresholds, worked on various techniques in query designing and report building.
• Conducted on the reporting techniques and needs.

SAP BW Architect, Crystal Reports, MSI Consultant

Confidential, Columbus, OH

Environment: SAP BW 3.5, SAP R/3 4.6, Crystal Reports 10, Micro strategy 8.0and Windows XP.

Responsibilities:

• Full life cycle implementation of SAP FSD, FI, MM and xRPM right from interacting with the business users, gathering the requirements, working on the requirement docs, preparing the functional specs, Transferring the functional spec into technical specifications and coming up with the relationship model.
• Extensively worked on Basic, Virtual, Multi cubes and ODS to generate the best possible functionality of the reports.
• Worked on customizing the business content cubes as per the requirements; used ABAP programs in Transfer, Update rules and enhancing the standard extract structures for different transformations and Logical updates into various data targets.
• Extensively worked on generating complex reports in BEx such as Balance Sheets, Income Statements, Store P & L, Cost Statements, Project Execution Management Reports and Portfolio Management reports using Structures, cell definitions, conditions, exceptions, Offsets etc,.
• Extensively worked on setting up the variants for the reports to run them in the background using Broadcaster functionality in SAP.
• Initially worked on a pilot implementation of crystal reports to see the feasibility of generating Financial Statements (Balance Sheets, P& L and Income statements).
• Drive the business to use Business Explorer to build and run the financial statements. Proposed and implemented solutions to achieve the same.
• Extensively worked on various report building techniques, customizing and formatting using Business Explorer
• Worked on automating the loads using process chains, info package groups and batch scheduling.
• Helped Basis to resolve various transport issues, installing the new support packs and OSS notes.
• Extensively worked on the transport connection to migrate the development from DEV to QA and PRD. Followed a definite process to keep all the systems in sync.
• Worked on customizing the web templates for xRPM to make it more users friendly and more accurate to the requirement.
• Worked closely with SAP Global support to resolve some of the performance related issues and to resolve some of the bugs.
• Worked very closely with APO team to pull data into BW and generate planning reports.
• Extensively worked on extracting data from APO into BW to generate various reports such as resource capacity, material availability report etc.
• Helped PIPE team to maintain mater data in BW for look up at the time of process error records coming in from POS transactions.
• Worked closely with Cognos planning team to get the historical data and master data for their planning system using Open Hub feature in SAP BW.
• Extensively worked on tuning the BW system by setting up various parameters, building aggregates, Installing statistics, creating indexes, physical partitioning of the data providers etc.
• Worked closely with business People and end users for and usage of the reports.
• Worked on Post go live support for Phase 1, moved on to Phase 2 for the implementation of retail and for more brands.
• Worked on DP and SNP modules on technical side, programmed on Planning Book, Planning Area, Info Object, Data View, Production Process Model (PPM), Transportation Lane, CIF Process and have done the programming with variety of order in APO.
• Experience and good knowledge in Reading planning book, Updating planning book for specified key(s), Deleting transactional data from planning book, Safety stock calculation based on Planning book data, Char Combo Creation, Deletion from Planning Book, Linking planning book, data view, planning area, info objects.
• Worked on Stock uploading from R3 to APO product Master, planning book and Program to transfer Safety Stock from Simulation Version to SAP R3
• Sound knowledge of function modules, tables and transactions used in APO.
• Worked on Micro strategy reports for sales and inventory reporting.

Senior SAP BW, Crystal Report Consultant

Confidential, MA

Environment: SAP BW 3.5, SAP R/3 4.6, Crystal Reports 10, Micro strategy 8.0and Windows XP.

Responsibilities:

• Installation, configuration and design of Crystal reports 10 and Crystal Enterprise 10 on client and server respectively.
• Extensively worked on BEx Reports, accessed and formatted the same in Crystal reports 10.
• Automation of the Crystal reports on Crystal enterprise for daily, weekly schedules in various formats such as Adobe, Excel and Crystal Report.
• Configuration, Maintenance of all the servers involved such as Job Server, Reports Server etc.
• Extensively worked on development and design of executive reports in BEx, Used various BEx formatting techniques and Excel Functionalities.
• Extensively worked on Cell definition, Exceptions and Global Conditions in BEx.
• Worked on configuration change of the existing multi-provider to get the right data.
• Conducted session and workshops for Functional and Business users in the following areas:
• Business Explorer and Report Designer
• Crystal Reports integration and accessing reports from SAP BW Instances.
• Various data restricting techniques, conditions and the usage of cell definition in BEx.
• Formatting techniques and types of reports in Crystal Reports, Business Explorer and Excel.
• Automation and schedule of reports on crystal enterprise, accessing the report results in the default location or changing the location etc.
• Transportation of BEx and Crystal reports throughout the landscape.
• How to set up, configure and view web desktop etc.

Senior SAP BIW Consultant

Confidential, PA

Environment: SAP BW 3.5, SAP R/3 4.6, Crystal Reports 9i and windows XP.

Responsibilities:

• Extensively worked on web application designer and BEx to develop a diagnostic web tool for IS. (Sales, Marketing and Finance).
• Involved in creating a dashboard with exceptions for various reports such as Portfolio, Flag, Season, Brand, Customer and Flag Reports.
• Extensively worked on RRI configuration, OSS notes application, Customer exits creation and debugging.
• Designed the web architectural model for the diagnostics tool and implemented the same.
• Designed and created various info cubes and ODS for staging and reporting on IRI and Nielsen data.
• Reviewed the business requirements for PCA and CCA, designed and configured the data models as per the reviewed document.
• Design for Sales and Distribution Order Status to include complex business rules, CO-PA, CCA, PA/PCA integration, Internal Orders Info Cubes and Info Sources.
• Extensively worked on fine-tuning of the reports, used various tuning techniques which include building aggregates and also data distribution.
• Developed new roles to control the authorizations of users on the BEx and Administrator workbench.
• Handling all the three types of requests like severe, moderate and small impact production issues.
• Extensively worked on transports, roles and other security related issues.

Senior SAP BW & Crystal Reports Consultant

Confidential, MI

Environment: SAP BW 3.5, SAP R/3 4.6, Crystal Reports 9i and windows XP.

Responsibilities:

• Design, Development and Deployment of various reports in BEx, Web and Crystal Reports.
• Developed complex reports such as linked sub reports, un-linked sub reports, passing the parameters to linked sub reports, drill down to detailed reports, cross tab reports and Mock cross tab reports in Crystal.
• Proposed and implemented a process for handling the crystal reports throughout the landscape to maintain the roles in sync in different clients.
• Extensively worked on payroll and time management reports, customizing the business content as part of fit gap analysis.
• Modified or created some of the queries in BEx as per the specifications and layout needed in Crystal.
• Set up the reports to run in the background using the Crystal console / Crystal enterprise.
• Developed various reports in BEx to generate the weekly order, daily order, weekly shipment, daily shipments etc.
• Configured alert monitor / reporting agent and the CCMS for monitoring the jobs/reports running in the background.

Senior SAP BW Consultant

Confidential, Waterford, NY

Responsibilities:

• Integration of 3.1 business analysis requirements with the existing classic 4.6 BW designs.
• Have good experience in setting up the project plan, designing the functional, technical specifications, testing plan and production migration plans.
• Analysis, Design and Deployment of Inter-company Sales reports for drop ship and Position Reports.
• Worked on reinitializing the cubes involved after doing the configuration changes for the same, extensively worked on CTS and RFC’s for transporting and connecting different clients.
• Worked extensively on custom data sources and custom cubes to meet the client’s requirements/to integrate the OSI Business with the existing Classic Business.
• Worked on various profit center groups, profit centers etc, Extraction and analysis.
• Extensively worked on reporting /web reporting; Used exceptions, restriction, Customer exits, etc to create flexible reports.
• Delivered demo and for various business users on the developed reports and cubes.

Senior SAP BW Consultant

Confidential, Calabasas Hills, CA

Responsibilities:

• Complete life cycle implementation of SAP BW for SD, FI-CO, MM and Purchasing modules.
• Completed the feasibility study of the current business process and identified the relevant areas for customization.
• Extensively worked on the current data model to identify the reason for reduced performance, considered redesign of few objects and also used performance tuning techniques as needed.
• Extensively worked on Extractors to pull in Open deliveries, which is very critical for management Analysis.
• Extensively worked on multi providers to produce one single report for Open deliveries, Open sales order and also stock on hand at a summarized level.
• Extensively worked on customizing these multidimensional models to meet the end user requirements and also designed custom ODS objects to handle item level data for profit center accounting.
• Reviewed the business requirements and determined the configuration changes for CO-PA, PCA and ECCS.
• Design for Sales and Distribution Order Status to include complex business rules, CO-PA, CCA, PA/PCA integration, Gross Profit Variance Analysis, Production Orders and Internal Orders Info Cubes and Info Sources.
• Initiated and developed the use of process chains to run the periodic loads and other processes.
• Developed a multi dimensional model for sales to report on Open Sales orders, returns etc.
• Developed various other multi dimensional models for Deliveries, Material movements, Profit Center and Sales Overview with the help of the business content models.
• Extensively worked on enhancing the business content /custom data sources for CO-PA and LO Cockpit to meet the business requirements, worked on function modules, ABAP coding and error handling for the same.
• Developed various alerts for various recipients depending on the end result of the processes for better monitoring.
• Extensively worked on fine-tuning of the reports, used various tuning techniques which include building aggregates and also data distribution.
• Extensively worked on transporting the developed content to various clients that lies within the landscape.
• Efficient in handling the support problems after going live.
• Developed web based queries for the users within the intranet, used HTML and JAVA for customizing the reports.
• Conducted sessions and workshops for the SAP Analyst group within the following areas:
• Data Warehousing Concepts, Business Warehouse Architecture.
• ABAP Data Dictionary and Workbench tools.
• Data Modeling.
• Mentoring on R/3 subjects within the context of BW in FI-AA; FI-AP; CATS; Material Management; Inventory Management; CCS functional and technical layout.
• Online Support Service sessions.
• CTS (Transport).

Senior SAP BW & Crystal Reports Consultant

Confidential, Cleveland, OH

Responsibilities:

• Extensively worked on query development and formatting techniques in both BEx and Crystal Reports.
• Designed and created various project system and financial reports, which include Budget analysis, Budget comparisons and also balance sheets.
• Involved extensively in defining flexible queries using filters, Variables, exceptions, restricted key figures and calculated key figures in BEx Analyzer to facilitate data analysis in a summarized or a drill down fashion to give detailed level of information.
• Extensively worked on Crystal Reports and Crystal Enterprise in all the phases, which include Installation, Development, Testing and Scheduling.
• Used various formatting techniques for formatting Cross tab, mock cross tab, Drill down and OLAP reporting.
• Detailed reporting and published several web reports and queries using BEx analyzer and WAD.
• Worked on Reporting, used BEx Analyzer for normal Query Definition and Info Set query for reporting.
• Generated numerous drill-down reports for end users using BEx Analyzer for SD, MM, and FI modules.
• Developed reports on Product Cost Controlling and Activity-based costing Based on Info Cubes from BW Business Content, made required modifications and extracted data from SAP R/3.
• Used all features in BW 3.0 like cell definition, key figure restriction, conditions and exception reporting.