SUMMARY

• Overall 10 years of experience in SAP technology with ASAP methodology, including project preparation, requirement gathering, gap analysis, as - is, business blue print, realization, post go live user support and end user documentation and training under deadlines. Extensive experience in business processes across the following modules: MM, SD, and PM, QM, HR, FI/CO and APO Demand Planning functions.
• Participated in initial assessment sessions for GAP analysis, as-is and To-be processes for SAP BW/BI areas for various client projects.
• 6 years of experience as a SAP BI/BW Consultant, 3 years as ABAP/4 Technical consultant, 5 years as BOBJ consultant and 3 years as BODS consultant.
• Involved in 4 full life cycle BI/BW implementations, 2 enhancement projects, 1 upgrade and 3 post go-live support projects in BI/BW and 2 SAP R/3 ECC implementations.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.2(BODS).
• Data Extraction: Proficient in Data Extraction from SAP R/3 (FICO, MM, SD, PM and QM,HR), UD & DB, flat files and BW using extract structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors using function modules and Views.
• Data modeling: Extensively worked in Net weaver 2004s Business Information components in Data modeling for info objects, Info Providers(Info cubes, DSO’s), Multi providers, multi cubes and info sets, transformations and Transformation routines (field routines, start and end routines), DTP’s,.
• BW enhancements: Customized standard business content extractors and enhanced data sources in various applications using BADI / user exits. Extensive experiences in Transfer rules/ update rules. Writing exits for the purpose of master data reconciliation using APD (Analysis process Designer).
• BW Transports: Extensively involved in monitoring the extractors, data loads and reports before going into production and transporting the BW objects from development into quality and finally to production systems.
• BW Reporting: Expertise in Front-End Business Warehouse components like Query designer, BEx analyzer, Reporting agent, Variables, Jump query analysis using RRI. Created custom queries using conditions, exceptions, variables, structures, Restricted and calculated key figures.
• Performance tuning: Extensive experience in query and load performance using aggregates, Rollups, Indexes, Partitions and Info-cube Compression techniques. Evaluated statistical performance on OLAP using BW statistics. Proficient in interpreting and writing complex ABAP routines to improve the load performance.
• Testing: Performed unit testing on the complete data flow of the model developed from source system through BI, UAT (user acceptance testing) and data validation testing and prepared documentation. Planned the cut over activities before go live and performed the downtime activities.
• Production Support: Experience in production support and issue resolution that involved debugging of data uploads, update routines, transfer routines, transformations routines, and process chains scheduling and monitoring of the data loads.
• Experienced in Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, and Business Objects Enterprise (BOE).
• BPC: Extensive experience with SAP BPC 10.1 NW (BPC Standard, BPC Embedded) BPC 10.0 & 7.5 NW and its integration with BW.
• Experienced in migration of BPC 7.5 MS to BPC 10.1 NW HANA (HEC)solution.
• BOBJ: Experienced in designing and developing the Universe and updating the existing Universes using BO 3.1 and BI 4.1, OLAP and relational connections, BICS connections.
• Expertise with the new functionality of BI BOBJ 4.1 and its tools.
• Created various WEBI reports in BO3.1 and BI 4.1, Dashboards and Crystal reports using SAP BW backend for SAP MM, SD and PM modules.
• Involved in documenting functional specifications, technical specifications, test cases, test results and production support documents.
• Good communication skills, interpersonal skills, self-motivated, quick learner, and team player.
• Ability to recruit, interview and present final hiring recommendations for team members to meet overall project objectives; provide recognition and feedback on team member’s performance.
• BODS: ETL and Data Profiling experience from source systems including SAP application/SAP BW, Flat Files and Legacy systems using SAP BODS.
• Expert in Data Migration processes including extraction, transformation and generation of load ready data files in LSMW format and IDOC.
• Experience integrating SAP BODS source code repositories to Team Foundation Server as source control.
• Exposure to OLAP, OLTP, Data warehouse and Data mart development .
• Strong understanding of Data Warehouse concepts: Star Schema, Snowflake Schema and Multi-Dimensional models for query and analysis requirements.
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services.
• Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

SAP BW, BO, BODS, BPC, HANA Technical Development Lead

Environment : SAP ECC 6.0, SCM 7.0, SAP BW 7.4, BODS 4.2, SAP BPC 10.1 (HEC), HANA 1.0, SAP BI 4.1.

Responsibilities:

• Worked with Functional SAP/ERP teams closely on the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team.
• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, and perform change management/training for BO Reporting and applications.
• Worked as a design coordinator on BPC migration project and successfully migrated BPC 7.5 MS to BPC 10.1 NetWeaver on SAP HANA Enterprise Cloud (HEC).
• Worked on end to end design for BPC 10.1 migration on cloud which includes Automation of data loads into BPC, data migration design/conversion of historical data, security set up and change control process.
• Worked on BOM comparison report using BODS 4.2 that compares the SAP BoM data against Legacy to ensure that the plant level BOM Allocation and De-allocations are in Sync.
• Worked on BODS design which utilizes a Vehicle Repository in MDM which will source Vehicle characteristic/option data from both AS400 (Legacy) and SAP ECC (Current/Future).
• Worked on design/configuration to set up real time ECC IDOC in BODS environment to receive Idoc from SAP.
• Worked on BODS design/development on TMS project which provides Purchase Orders and STO from ERP to Lean logistics.
• Set up BODS connection to SAP BW to pull financial data for EMEA via open hub.
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP BW
• Worked on implementing HANA Side Car Sales Analytics using pre-defined and custom virtual data models and built visualizations for Sales data.
• Worked on migrating SAP BW system from DB2 to HANA Cloud and was involved in Architecture design and end to end upgrade/migration.
• Worked on design and development of HANA Attribute views, Analytic view, Calculation views, Procedures using SQL Script and calculated engines along with security design.
• Experience in SAP UI5 and OData services.
• Worked on setting up real time data replication from SAP ECC to SAP HANA through SLT.
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP BW
• Worked on design and development to Interface the Production order data, Wholesale and intercompany data, Retail sales data for APO-DP which is the key input for forecasting production and sales.
• Worked on QM hold reports which involve complex modelling based on Task, activities, defects and inspection lot details.
• Worked on Demand planning CVC Exception report which will help the planners to correct master data and realign forecasts.
• Worked on Cost for Pricing (CFP) report which involves the Dataflow build on Sales documents and Variant configuration.
• Designed and developed different STP reports like Report to compare price of PO, PIR, Scheduling agreement and PR.
• Worked on Aged NCM Report and Quality notification report to track scrap transactions.
• Designed and developed COPA to FI Reconciliation report to analyze COPA FI balances by Profit center, Company Code and GL Account.
• Worked on FI- AR reports like Direct debit utilization report.
• Worked on both versions of SAP BPC i.e . both Net Weaver and Microsoft platforms.
• Provided Web Intelligence training to end users
• Developed new reports in Crystal Reports Enterprise and Web Intelligence.
• Created OLAP connections and configured SSO connections for connecting from BW to BOBJ.
• Worked on BOBJ security by giving application level security and folder level security depending on the type of requirement for different users.
• Worked on SAP system upgrade Environment Readiness project.
• Lead the offshore team assigning the upgrade activities and task which includes documenting and implementing the cutover steps to prepare the BW system for update execution and also post upgrade steps.
• Architect SAP Business Object 4.1 solutions to support the business reporting needs for Global Template ("GT") Environmental Readiness project and scaled out robust landscape based on the enterprise requirements and was involved in Install and Configure the SAP Business Object 4.1 Landscape.
• Provided the road map for the new security model for Global BI landscape.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.1 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Developed Webi reports and Dashboards for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Assessment on existing 3.1 land-scape and came up with migration strategy then migrated BO3.1 reports into BI4.1 environment for HDFS.
• Responsible for the SAP BOBJ Design Studio Data Visualization development lifecycle from design through implementation and production support
• Designed critical Dashboards and stories based on customer requirements using SAP Lumira.
• Worked on several BI reporting tools like Design Studio, Dashboards, Lumira, Business Objects explorer, Analysis for OLAP and also Power BI, Qlikview, Tableau.

Confidential, Milwaukee, WI

SAP BI-BO consultant

Technical Environment: SAP ECC 6.0; SAP BI 7.3, CRM, FI, SD, and Query Designer.

Responsibilities:

• Worked on complex Finance Travel and Expense reporting.
• Worked on enhancing standard T&E extractor 0FI TV 01 by BADI to get additional field to meet the reporting requirement.
• Created complex BEX report to be broadcasted via email to all users in a role.
• Worked on enhancing standard F4 restriction BADI to restrict the F4 employee report selection drop down based on Manager’s org unit hierarchy.
• Created complex Travel and expense report which involves complex customer exits to meet the reporting requirement.
• Worked on adjusted billing and booking dataflow with complex security model on the reporting side.
• Worked on CRM opportunity history dataflow to capture weekly snapshots of new created and changed opportunities.
• Responsible for providing solutions for 3X to 7.3 migrations of BI data models for SAP BW HANA.
• Worked on HANA sizing and cleanup activities to make system ready for migrating BW system to BW on HANA.
• Worked on migration of 3X complex data flows to BI 7.3 and validation of new 7x flow with the existing 3x flow.
• Worked on migration of 3X BEX Queries to 7X BEX Queries.
• Worked on migration of 3X data flows to 7.3 dataflow pertaining to FI, SD and SCM.
• Worked on clean-up of BW data for Pre-migration which includes cleanup of BI background messages, Archiving request admin data, cleaning PSA and change log tables, Re-org of BEX Workbook and Broadcaster.

Confidential, Milwaukee, WI

Senior SAP BI-BO consultant

Environment : SAP ECC 6.0, SAP CRM 5.0, SAP BI 7.0, APO, SCM, CO-PA, FI, SD, MM, PPDS, QM, BEx Analyzer, Query Designer, BO Designer (XIR 3.1, WEBI (XI R 3.1), Crystal reports 2008.

Responsibilities:

• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Participated in functional review for approving functional specs and design review session’s onsite-offshore delivery model to ensure technical designs.
• Activated Business Content Objects (Data Sources, Info Objects, Info cubes, and DSOs etc) and also developed customized objects as per the requirement.
• Involved in activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO-PA, SD and QM.
• Created APO extractor on different planning areas and developed BW data flow.
• Created Function modules Generic Extractor for Routing Master data and extensively worked on complex routine involved to meet the user requirement for Routing comparison data.
• Was involved in creating many complex OLAP variables, DTP routines(ABAP).
• Worked on Capacity Information Extraction from APO live Cache through Function module Generic Extractor and developed complex ABAP program for User selections criteria.
• Worked on CO-PA redesign which involves addition of more fields with complete different flow and was involved in complete end to end testing for all the developments assigned.
• Worked on Partitioning of Infocubes to meet the performance requirements.
• Worked on CVC dataflow which involved complex lookup’s from DSO’s and master data in the routines.
• Worked on FM Extractor for Material Forecast report to extract BOM Exploded data for Cost Estimates and worked on BW dataflow which involves complex lookups and build WEBI reports on top of BEX.
• Worked on Variant configuration data sources and BW dataflow related to VC Characteristics.
• Extensively worked on Material movements (MM) data flow with complex look up logic and created Parts by Supplier report on WEBI
• Created many Hierarchy, text and attribute datasources with the flow and did complex look-up from the master data tables.
• Worked on ABAP related custom data flows which involves complex ABAP program,Function modules, complex start and end routines.
• Worked on
• Was actively involved in all the cutovers and took corrective measures to analyze the failed transports.
• Build Transactional and Master Process Chains for periodic upload of data.
• Extensively used Crystal Report XIR2/2008 for creating complicated reports including parameter based reports, graphical reports, sub-reports, formula based, well-formatted reports, analysis reports, drilling reports, data reports along with LOV.
• Created Universes over BEx queries using Universe Designer.
• Created various BOBJ WEBI and Crystal reports.
• Created users and user groups, provided access to different users as per their requirements using Central Management Console (CMC). Involved in managing users, groups, folders and published reports using Central Management Console.
• Ensured timely and good quality delivery of the project, which was well appreciated by the client

Confidential

SAP BI-BO consultant

Environment: SAP ECC 6.0, SAP CRM 5.0, SAP BI 7.0, CO-PA, FI, SD, BEx Analyzer, Query Designer, Web Application Designer, BO Designer (XIR 3.1, WEBI (XI R 3.1), Xcelcius 2008, Crystal reports.

Responsibilities:

• Installed Business Content for Financial and Profit Center Accounting Info Cubes and customized the FI-GL, FI-AR, FI-AP and PCA business content cubes for meeting the business requirements.
• Dealt with extractions involving standard COPA data sources, CRM data sources, PCA, CCA, FI-GL and SPL.
• Worked on Enhancing the Extractor 0CRM COMPLAINTS I and worked on dataflow using standard DSO 0CRM COMP and built a report.
• Worked on development and enhancements involved to build a Long tool down (LTD) report, in which data is extracted from R3 and CRM system using different data sources.
• Created Generic data source with Function module Extraction method on both ECC and CRM system.
• Worked on Enhancements of various infoobjects depending on the requirement.
• Extracted data from 0EC PCA 3 (profit center Actual line items), 0CO OM OPA 4 and CRM datasources and loaded the data into DSO’s, Infocubes and Infosets and built service contract report according to the requirement.
• Extensively worked with FI - GL, AR, AP, COPA data sources for extraction and loading of data from FI to BW.
• Developed many complex ABAP enhancements like User exit functions,ABAP enhancements in CRM,ECC-BI CMOD,Generic extraction and also in BI data modelling like start routine and End routine.
• Extensively worked in LO-Cockpit Extraction and customized extractors.
• Handled accounts payable cubes (0FIAP C03), accounts receivable cubes (0FIAR C03) as a part of SAP BW implementation
• Master and Transaction Data extraction from Flat files and loading into InfoObjects, DSOs and InfoCubes.
• Enhanced business content InfoObjects (0BPARTNER, 0COSTCENTER, 0FUNC AREA, 0FUND) by adding new attributes and added code in User-exits to populate the data.
• Customized existing financial Info cubes, ODS and Multi providers according to business needs in SAP BI
• Worked on building and monitoring of BWA (Accelerator) and debug BEX queries to validate the performance improvement.
• Created reports using Business Explorer (BEx), Web Application Designer (WAD), Reporting Agent, Calculated/Restricted Key Figures, Structures & Cells, Hierarchies, User Exits, Characteristic/ Formula/Hierarchy/Hierarchy-Node/Text Variables, Conditions, Exceptions & Currency Translation, Web templates and pre-calculated web templates.
• Developed Universes using SAP BI/BW Queries as Source Data
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Creation of the universe with Classes, Objects and Condition Objects
• Customized LOVs in Universes for quicker performance of reports
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as Source

Confidential, IL

SAP BI-BO Consultant

Environment: : SAP ECC 6.0, SAP BI 7.0, FI-AR, FI-AP, FI-GL, FI-SL, CO, MM, IM, ABAP/4, BEx Analyzer, Query Designer, Web Application Designer, BO Designer (XIR 3.1, WEBI (XI R 3.1), Xcelcius 2008, Crystal reports.

Responsibilities:

• Involved in the full life cycle implementation which includes Gap Analysis, design, development, testing, implementation and support.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA),General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA) and customized them as per the client requirement.
• Developed write optimized DSO’s for EDW layers and standard DSO for consolidation layers and created direct update DSO’s and APD for creating history data and for snapshot scenario reports.
• Developed transformations with start routine, update routine and end routine and involved in the creation and maintenance of DTP and InfoPackages for loading data in to data targets.
• Created generic data sources with Function module extraction method.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement for US and Turkey.
• Dealt with extractions involving standard COPA data sources, PCA, CCA.
• Worked on Accounts payable cubes and accounts receivable cubes and enhanced the performance (Modeling, Data load) from other systems and did currency conversions for Country specific.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source.
• Generated month to date and year to date reports for MM and FI and monthly distribution reports for Human Resources
• Created formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Created exception aggregations, cell editors, formula variables, RFK’s and CKF’s in the queries.
• Extensively used WAD and published reports on Enterprise portal as iView
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Involved in the migration and deployment of the universes and reports across multiple domains.

Confidential

SAP BI-BO Consultant

Technical Environment: SAP ECC 6.0, SAP BW 7.0, FI, CO-PA,APO, BEx Analyzer, Query Designer, Web Application Designer, BO Designer (XIR 3.1), WEBI (XIR 3.1), Xcelcius 2008

Responsibilities:

• Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.
• Extracted and uploaded data into InfoCubes from Data Sources like Actual Cost through delta extraction (0C0 OM CCA 9) and Internal Order through delta extraction (0C0 OM OPA 6)
• Extracted the data from HR data sources like 0HR PA OS 1, 0HR PA CM 1 (Staffing Assignments) and loaded into Infocubes 0PY C02 Payroll data, 0PABN C01 Benefits.
• Extracted data by creating Infoset Query extraction method.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx.
• Generated Export Data Sources to transform data from one InfoCube to other InfoCube.
• Managed and monitored data loads with full upload and delta mechanism.
• Created Infoset for master data to enabling querying on data.
• Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and Multiproviders.
• Developed single and multiple dash boards and score cards using Business Objects.
• Created Master/detail reports, cross tabs, charts and applied slice and dice, implemented different levels of hierarchies for drill techniques.
• Involved in designing Universe and migrating existing ad hoc ‘Crystal Reports Explorer 11’ to Web I.
• Defined BO Classes, Objects in the Universe and defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Enabled dynamic report linking by passing Variables (prompts) between reports Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them.

Confidential, CA

SAP BI/BO Consultant

Environment: SAP NW 2004S/BI7.0/ECC6.0/CRM4.0/BOXI 3.1/BEx/MM/SD/FI/CO/PP

Responsibilities:

• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Analyzing the Function Inputs. Interacting with functional team to resolve the issues in the given objects.
• Development of technical specifications for the developments assigned.
• Ensuring a high quality solution for all the delivered objects to the client within the schedule.
• Customized existing financial Info cubes, DSO & Multi providers according to business needs in SAP BI.
• Created Contexts and Aliases for resolving Loops and Traps in the Universes.
• Involved in resolving issues relating to pre implementation of Reports.
• Implemented different level of hierarchies for drill down reports.
• Analyzed data using Slice and Dice and Drill Mode methods to build Reports.
• Controlling Reports data by working with Universe and Queries using Filters, Sorts and Rankings.
• Created Cross-tabs, Metrics and Charts etc.
• Used various Functions like Prompt (for user defined queries), Where (For creating conditional filters), and Select.
• Involved in writing detailed level documentation for reports and universe design.
• Provided end user training for basic and advanced reporting skills.
• Used schedule functionality to send reports to different users and groups.
• Involved in performance tuning of reports that were running slowly. Did performance tuning at the report level, Designer level and database level.
• Developed Dashboards for detailed analysis using Application Foundation.
• Involved in migration of 6.5 to BOXIR2 version and creating the new security model for the XIR2 Security Model.
• Dealt with the new functionalities and features of the BOXI R2 version.
• Interacted with the end users and provided Production Support.