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 multiple projects.
• 6 years of experience as a SAP BI/BW Consultant, 3 years as ABAP/4 Technical consultant, 5 years as Confidential 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 Confidential, 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.
• Confidential : 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 Confidential 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

TECHNICAL SKILLS:

Data warehouse: BI 7.4, BI 7.0 and BW 3.5

ERP Packages: SAP ECC 6.0,5.0, SAP R/3 4.7 &4.6C

Reporting Tools: BEx Reporting, Report Designer, Business Objects (XI 3.1, 4.1) - web intelligence, Crystal reports, Xcelsius dashboards, Universe Designer.

Functional Modules: Material Management, Sales and Distribution, Plant Maintenance, Quality management, FICO, Human Resource, SAP APO.

RDBMS: Oracle 10g, MS SQL 2005 Server

Languages: ABAP/4 using ECC 6.0 and SQL.Operating Systems: Windows 9x/2000/XP/Vista, 7, MS-DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

SAP BW, BO, BODS 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.

• Worked with Functional SAP/ERP teams closely on the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team.
• 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 Confidential comparison report using BODS 4.2 that compares the SAP Confidential data against Legacy to ensure that the plant level Confidential 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 via SAP PI 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 Confidential 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 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 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.
• Developed new reports in Crystal Reports Enterprise and Web Intelligence.
• Created OLAP connections and configured SSO connections for connecting from BW to Confidential .
• Worked on Confidential 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 Confidential 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 Confidential 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.

Senior SAP BI-BO consultant

Environment: SAP Confidential 4.0, SAP ECC 6.0, SAP CRM 5.0, SAP BI 7.0, APO, SCM, CO-PA.

• Worked on complex Finance Travel and Expense reporting.
• Created Report Design documents (RDD for the reports and dashboards coming out of the Oracle 11g environment
• Joining all the data feeds (SAP BW, Oracle 11g, SQL) coming from different agency sources and combining them inside the Universe/Business Layer using Information Design Tool.
• 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.
• Development of Reports and Dashboards using Confidential 4.1 tools (Web intelligence, Crystal Reports Enterprise, Crystal 2011, Advanced Analysis, Information Design Tool and Dashboard Design (Xcelcius).
• Created OLAP connections and configured SSO connections for connecting from BW to Confidential .
• Worked on Confidential security by giving application level security and folder level security depending on the type of requirement for different users.
• 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.
• 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.

Confidential

Senior SAP BI-BO consultant.

Environment: SAP BI 7.0, SAP R/3 ECC6.0, BOE3.1 and SQL.

• To create Technical Specs in accordance with the client’s requirements for SD,MM, HR & QM modules.
• Worked on Confidential standard extractor for pulling Purchasing, Sale Order, Billing, Shipping and Plant maintenance data into BW system and created reports in BEX and Business objects.
• To activate Business Content Objects (Data Sources, Info Objects, Info cubes, and DSOs etc) and also develop customized objects as per the requirement.
• To create SAP BI queries, Web Templates, Process Chains etc.
• Designed entire dataflow for conceptualization of solution.
• To do the Unit testing and Integration testing after the developments.
• Coordinate and work with the Onsite and client teams on daily basis.
• Enhanced Standard data sources using BADI for HR, QM and SD modules as per the business requirement.
• Created Generic data sources for HR module for Master and Transaction data using Function Modules and Views.
• Worked on BI side Transformation level field routines, Start routines and End routines.
• Worked on DTP level routines for deleting overlapping and selected data requests based on time period.

Confidential

SAP BI-BO consultant.

Environment: SAP BI 7.0, SAP R/3 ECC 5.0, FI/CO, Business Objects XI R3/R2 Suite, Crystal Reports, Xcelsius, Designer, Reporter, Unit Test.

• Developed technical specifications based on the functional specifications to ensure the correct development of the solution to satisfy the business need.
• Responsible for developing BI data models and designs, configuring custom and delivered BI Content, analyzing BI reporting requirements, developing detailed reporting specifications.
• To activate Business Content Objects (Data Sources, Info Objects, Info cubes, and DSOs etc.) and also developed customized objects as per the requirement.
• Worked on Redesign of the COPA dataflow in order to provide additional flexibility, improvement in load performance and sustainability.
• Worked on extraction of data sources 2LIS 11 VAITM, 2LIS 11 VAHDR, 2lis 13 vdhdr, 2LIS 06 INV, 2LIS 17 3HDR, 0VENDOR ATTR, 0VEN COMPC ATTR, 0MAT PLANT ATTR, COPA extraction etc.
• Worked on Web-service data sources for Inbound (PI to OPS) and outbound flow for Demand Planning and Vehicle forecasting data in APO system.
• To create Technical Specs in accordance with the client’s requirements for SAP MM, APO, PM and COPA modules.
• Designed custom extractors for MM,PM and APO modules for Master and Transaction data using Function Modules, Web service, export method and Views & Activation of standard Extractor for data extraction from customized applications as well as standard applications, Implemented the delta functionality.
• To create SAP BI queries, and Process Chains etc.
• Worked on OLAP variables and TVARVC variables, BI side Transformation level field routines, Start routines and End routines.
• Collecting transport requests for the objects developed using transport connection and transport error resolution.
• Used Solution Manager for managing all the project related documents like functional and technical specifications.
• Created various Confidential WEBI and Crystal reports.
• Designed Confidential reporting solutions on top of SAP Integration Kit: Web Intelligence, Xcelsius, and Crystal Reports.
• Used report bursting techniques to deliver the formatted reports by email to the sales people.
• Modified ABAP reports for enhancing work order and notifications (User Exit and BAPI).
• Build Bex queries using Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.

Confidential, Milpitas, CA

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.

• Used Crystal reports 08 to develop reports based on the Bex queries with custom formulas to suite the requirements
• Developed Dashboards using Xcelsius. Created custom components using SDK to create data visualization in an effective manner
• Developed Adhoc reports using Web Intelligence. Involved in Infoview customization and optimization.
• Created Publications to schedule the reports on a nightly basis for creating instances which feed the reports.
• Used BIWS connectivity to publish web services data and developed Dashboards using those instances.
• 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 loaded data into the standard DSO 0CRM COMP and built a report.
• 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.
• 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.
• Customized existing financial Info cubes, ODS and Multi providers according to business needs in SAP BI
• Extensively worked in LO-Cockpit Extraction and customized extractors.
• Master and Transaction Data extraction from Flat files and loading into InfoObjects, DSOs and InfoCubes.
• Compressed the Info Cube data for better performance.
• Developed BW reports using BEx analyzer, created queries with variables, restricted key figures, calculated key figures, conditions, exceptions etc
• 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.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Developed Universes using SAP BI/BW Queries as Source Data
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as Source.

Confidential, Edwardsville, IL

Computer Programmer, Graduate Assistant

• Created Slice and Dice, Drill down and Cross Tab reports
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Developed technical documentation for all the reports
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting
• Tested the universes, reports and dashboards with different scenarios like query balancing, look and feel and formatting of the reports based on the specifications, before moving them to the production environment.
• 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.
• Assisted Students and helped them in understanding various modules and Programming concepts.
• Was involved in teaching various functionalities in Microsoft Office that can be used for testing.
• Created Process Chains and scheduled them in order to load Master Data and Transactional data from SAP R/3 as well as Flat File Source Systems into BW.
• 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.

Confidential

Computer Programmer

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

• Extensively involved in Activating Business Content for Standard InfoCubes, InfoSources & InfoObjects of SD and HR-Payroll Modules as per the Client Requirements
• Created InfoObjects, InfoCubes, and InfoPackages and developed Transfer structure, Communication Structures, Update rules and Transfer rules for InfoSources and ODS objects.
• Created Info Packages, Process Chains and Scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems into BW
• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW and debugged when required.
• Created Multi Provider on Sales Order/Delivery and Vendor Analysis Account Payable Line Item cube (0FIAP C03)
• Generated regular and customized data sources from APO DP planning areas Used Multiproviders and Infosets to extract data from tables and table joins.
• 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. Worked with users to understand their reporting needs.
• Generated Export Data Sources to transform data from one InfoCube to other InfoCube.