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 BI implementations 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
• Vast experience using SAP ASAP methodology in SAP BI /BW, BO, ABAP/4, Business Objects (Reporting & Data Services), SAP HANA - database design, development, installation, configuration, upgrade and performance.
• Expert is managing multiple projects - well versed in different aspects of the projects such as 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.
• Work experience in handling multiple clients within the landscape, Transport Management, Configuration and set up of the clients (Sizing, Solution manager, transport path, Authorizations & initial configuration).
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting. Also trained on XSJS, OData, web services.
• HANA SQL SCRIPTS & DATA SERVICES - Strong experience on Creating SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like - Tracing, Using the SQL Script Debugger.

SKILLS:

• SAP BI BW 3.X / 7.0 / 7.3
• SAP BOBJ 3.X / 4.X
• SAP HANA
• S4 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
• Lumira Design, Discovery
• Design Studio
• Micro strategy
• Web App Designer
• RoamBI
• Crystal Reports
• Power BI
• Lumira
• Qlik View
• Data Stage
• BO Data Services

WORK EXPERIENCE:

SAP BI BO HANA Architect

Confidential

Responsibilities:

• Architected and developed solution “how to consolidate multiple reporting systems to one global reporting system” and bring ROW (rest of the world data), this is Green Field implementation.
• Managing team project, planning, working with stake holders, vendors, working with leadership and sharing status every week, cadence meetings, working with different teams to make this foundation build success. Defining Strategy, Road Map and Data Migration plan for SAP BOBJ and SAP HANA.
• Blueprint phase (Roadmaps, Requirements, Scoping, Resourcing, Selecting Vendor, Project Planning, costing, Roll out plan, FD and TD, Cadence meetings, work with business etc.,)
• Involved in trouble shooting S4 views for Finance, supply chain and c4c, including HANA views, data services data jobs, data flows and automation.
• Designed and developed SDA based operational reporting for event tracking and installation on standard CDS views based reporting for finance.
• Responsible for SAP BObj, SAP Lumira including design, discovery, migrating to Lumira 2.0., connecting to S4 HANA, BW, Excel and MySQL sources.
• Acquire, prepare data using Lumira discovery, extend these documents to Lumira designer and build visualizations using Lumira designer, also supporting offline scenarios.
• Data base Migration using DMO of SUM. Complex SAP HANA Models as a part of side car approach, includes SAP HANA, S4 HANA and CRM.
• 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 & S4 HANA Development), training 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
• Redesigned BW Objects (LSA++) and improved Performance of reports runtimes and data loads. Designed new a DSO 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 S4 HANA and Non sources using SLT and Data services.
• 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.
• Defined and deployed SAP Lumira server and client architecture including servers, scheduling service, web application and API’s.
• Define and built numerous design studio and Lumira story boards for controlling, financials, service and team productivity. A glossary of metrics and KPI’s were published.
• Leveraged variety of Lumira design and discovery features such as collaboration and sharing for role based changes and additions to story boards, pictograms for representation of data points, geo charts for analyzing location based growth, location analytics, offline reporting etc.
• Used variety of functionalities and workarounds to leverage BW security to restrict access to uses within a Lumira design dashboards.

Principal Consultant

Confidential

Responsibilities:

• Work with Account/Sales teams to manage the pre-sales process with clients and provide the leadership throughout the sales-cycle from initial qualification to closure of the deal - activities include inputs to RFP’s, RFI’s, RFQ’s, creation of assets for demonstration, POC’s, POV’s.
• Play an advisory role to customers and prospects and provide thought leadership & IT/ Business transformation recommendations in various innovative technology areas such as Business Warehouse, Business Analytics, Mobility, Big Data, Data Quality, Data Management and Data Governance Initiatives.
• Worked closely with sales to understand their pipeline, sales process, prospects and their needs. Assist sales team to put presentations and literature for sales material.
• Provide technical demonstrations of software’s, complex projects for technical and non-technical audience including the c-suite.
• Worked on setting up SAP BI, BO, and HANA developments systems for developing multiple uses cases on HANA for a professional services client.
• Designed and architected a HANA use case for inventory (AR, WIP) analysis, which usually takes 45 minutes to run and reduce the run time to less than 10 seconds.
• Worked on all SAP HANA aspects (Foundation layer, Analytical views, Calculation views, Attribute views, import servers, scheduling of replication etc.) in conjunction with SAP ECC using SLT and data services.
• Worked with SAP BI and BOBJ Business users, architects and involved in requirement gathering, analysis and creation of best practice architecture
• Assisted in installation of SAP SBOP 4.0, Tomcat Application Server, Dashboards and corresponding Server and client components, tested, documented, maintained the Database, Application and Web tiers and ensured they are working in Development, Testing and Production environments
• Created multiple universes for Financials and supply chain, using the analytical and calculation views of SAP HANA
• Created queries and reports, Web Intelligence (WebI) documents/reports, design studio, BO Explorer views on top of the Universes created using the Designer
• Involved in designing, developing, testing Front End Solutions, Leveraged the web service tools within SAP SBOP platform and developed a custom app on iPad for mobile access of the reports.
• Worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles.
• Involved in developing and conducting extensive Unit testing, Integration testing, Regression testing, User Acceptance Testing and documentation
• 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.

• 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 training 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 training 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 Training 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.