EXPERIENCE SUMMARY

• Over 8 years of Experience in Analysis, Design, Development and Implementation of Business Applications using SAP BI/BW wif experience in various industry verticals such as Hi - tech, Manufacturing, Retail, Facility Management and Pharmaceutical Industries.
• Experience in Full Life Cycle implementations on SAP BI/BW following ASAP Methodologies which involves Blue print, Realization, Data Modeling, Data Loading, Production Support, Testing, Documentation, Requirement Analysis, End User Documentation and Reporting.
• Proficient in upgrading the system from BW 3.5 to 7.0 and 7.0 to 7.3.Involved in designing the BI architecture.
• Prepared Technical Specs and Functional Specs as per business requirements.
• Created several process related and architecture documents.
• Conducted workshops to understand Lexmark’s reporting requirements.Expertise in providing ongoing support after Go live and other support activities.
• Expertise in preparing test cases for unit testing, functionality testing and regression testing.
• Expertise in Testing/Verification and migration of developed solution to production.
• Planned and prepared cut over activities, check lists for pre/post go live deployment for multiple global rollouts.
• Worked on onsite/offshore model and played key role in managing team in India.
• Extensively worked in various functional modules like SD, MM, PP, PS, FICO, SCM- APO Demand Planning and Supply Network Planning, CRM and HCM.
• Extensively worked in various process flows such as OTC, PTM, PTP and BTR.
• Proficient in data extraction from SAP ECC for Modules such as SD, MM, PP, FI, PS, HR, and flat files using extract structures such as LO, FI, COPA and Generic Extractors.
• Expertise in data extraction and data consolidation from SAP ECC and Non-SAP sources such as J.D. Edwards and Oracle.
• Expertise in Performance tuning techniques such as aggregation, partitioning, Indexing and Housekeeping activities.
• Experience in Indexing BW Data using BWA (BW Accelerator).
• Proficient in developing reports using Bex Query designer and Bex Analyzer for functional areas like SD, MM, PP, FICO, PS, HR and APO.
• Experience in BI Analysis Authorization and assigning authorization through Role/Profiles.
• Experience in implementing BW 7.3 and developed info providers like SPO and Hybrid provider.
• Expertise in writing ABAP Code for Start Routine and End Routine.
• Expertise in enhancing Standard BW Content Extractors for Data extraction.
• Worked extensively in developing User Exits for Reporting.
• Experience in BI-BO integration, using OLAP Universe creation and BICS Connection.
• Experience in developing Webi Reports using tools like Web Intelligence Rich Client.
• Experience in developing Dash boards using Xcelsius and Crystal reports.

TECHNICAL EXPERTISE

ERP Applications: SAP BI 7.3, SAP BI 7.0, SAP BW 3.5, ECC 6.0

Languages: ABAP/4, SQL, C, C++, Java.

Other SAP Modules: Logistics(SD, MM, PP), FICO( New-GL, AR, AP, Travel, Treasury), COPA, Project Systems(PS), SCM-APO, CRM, HCM

Reporting Tools: BEx Query Designer, Bex Analyzer, WAD and Report Designer, Business Objects 3.x, SAP BOBJ 4.0 (Web Intelligence, Universe Designer, Xcelsius and Crystal Reports 2008)

Web: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Solution Environment: SAP BI 7.0; SAP BI 7.3, ECC 6.0, SCM 7.0, SD, MM, PP, PS, FI, and APO

SAP BI/BO Team Lead.

Responsibilities:

• Involved in gathering user requirements from all the regions of Lexmark.
• Worked on upgrade of the system from 7.0 to 7.3 and developed test scripts for the same.
• Developed info providers like Semantic Portioned Objects (SPO) based on regions and Hybrid Info providers.
• Worked on various process flows like OTC, PTP, PTM, and BTR.
• Created and maintained data flows for SD, PP, Purchasing, FI and APO (DP and SNP).
• Worked extensively on most of the SD data sources.
• Worked on Purchasing Data sources like 2LIS 02 ITM and 2LIS 02 SCL to create Non- Contract Order Report and PO Lead Time Report.
• Worked on PP Data source 2LIS 04 ARBPL to create production orders and yield performance reports.
• Worked on data sources like 2LIS 02 SGR, 2LIS 02 SCN, 2LIS 02 SCL to get Open PO Quantity
• which is used along wif APO SNP Flow to get Actual Receipts, Proposed Quantity and Committed Quantity.
• Developed APO SNP Reports like Supply Plan Delta, Supply Plan Snapshot, Ship Plan Delta and Ship Plan Snapshot.
• Developed APO DP Reports such as Hardware Quarterly Growth and Hardware Sigma Analysis.
• Worked on FI Data Sources like 0FI AP 4, 0FI AR 30, 0FI GL 14, and 0FI TV 01.
• Worked in FI areas like GL, AR, AP, Travel, Treasury and Developed reports like Treasury Forecast, AP Invoice Summary, AR Delinquency Report, Customer Aging Report, TEA Expenses Report, and Travel Expense Report.
• Developed Project System flow using WBS Element related data sources for Product life cycle Management (PLCM) functional area.
• Enhanced standard data sources according to the requirement.
• Experience in writing start routines and end routines using ABAP.
• Created Generic Data Sources using info set and Functional Module as per business requirement.
• Loaded Hierarchies from ECC and built the Custom Hierarchies as per the business requirements.
• Worked on Aggregates and Housekeeping activities such as PSA and DSO Log deletion.
• Used BW Accelerator (BWA) to Index BW Data for faster query performance.
• Created, maintained BWA Indexes and updated process chains in order to use BIA Indexes continuously in BW System.
• Created BW objects like Info Set, Open Hub Destination and Multi provider etc.
• Developed complex Queries in BEx for various modules like SD, MM, PP, FI and APO using Customer Exit Variables, Formula Variables, Structures, and Cells.
• Developed APO DP and SNP Reports using Bex Query Designer to view forecast data for future 78 weeks and Actuals for 52 weeks.
• Developed APO DP Reports such Hardware Forecast Accuracy, Hardware Forecast Evolution and Hardware Sigma Analysis.
• Developed APO SNP Reports such as Supply Plan Delta, Supply Plan Snapshot, Ship plan Delta and Ship Plan Snapshot.
• Performed functionality testing in BI to ensure data correctness between ECC and BI.
• Involved in writing Test scripts for testing, Data validations, and User manuals.
• Conducted training sessions for Lexmark’s users.SAP BO Report Development:
• Developed Web Intelligence 4.0 reports using BICS Connection.
• Created Reports wif several types of Graphical Representations such as Pie, Bar charts, and Graphs involving complex calculations.
• Created user Prompts, Conditions, Filters, Alerts, Breaks, and Sorts for various reports to specify the reporting parameters as per business requirements.
• Worked on advance features like set Section and subsections and merge dimensions.
• Used BICS Connection for Xcelsius dashboards.
• Developing Dashboards for SD and FI functional areas.

Confidential

SAP BI/BO Developer

Responsibilities:

• Involved in Implementation of Rollouts.
• Gatheird user requirements and prepared technical specifications as per the schema.
• Prepared Functional Specs for the reports to be designed.
• Worked in functional areas like SD, MM, PP and CRM.
• Involved in extracting data from LO, Generic and CRM Extractors
• Worked on Inventory Data Sources like 2LIS 03 BX and 2LIS 03 BF.
• Worked on SD Data Sources like 2LIS 11 VAITM, 2LIS 12 VCITM and 2LIS 13 VDITM.
• Experience in extraction of data from CRM Data Sources using CRM BWA.
• Worked in CRM Analytics, developed reports such as Sales Order Complaints Analysis and Orders/Confirmations wif Complaints.
• Developed Reports like Inventory Aging, Delivery Status report and Open/Back Order Report.
• Worked in Profitability Analysis (COPA) and developed reports like Revenue Reversals and Top 25 Customer listings.
• Created Generic Data sources using View, Info Set, and Functional Modules.
• Developed start routines, end routines and field routines for transformations.
• Involved in Performance Tuning techniques like Aggregates, Partitioning, Info Cubes Compression, etc.
• Involved in creation of new master data objects and enhancement of standard objects.
• Used DSO for data staging, before transferring the DSO contents in to the Data targets and did Operational reporting on DSO.
• Worked on Bex Query Designer and developed reports using Variables, Structures, Customer Exits and RRI etc.
• Created process chains and Meta chains to load data according to functional areas.
• Worked extensively on data loads using delta mechanism.
• Involved in handling change requests, problem requests, incidents and service requests.
• Analyzed and corrected production problems as they occur in the SAP BI system.
• Applied several OSS Notes when issues encountered.
• Ensured BI data quality, reconciliation and validation wif R/3 and external Source Systems, governance, and master/transactional data alignment/realignment.
• Experience in BI Analysis Authorization and assigning authorization through Role/Profiles.
• Expertise in Reports Generation using Bex Analyzer, building Queries and saving Workbooks (Excel Work Sheets), creation of Custom Queries using conditions, exceptions, variables & structures and created aggregates for frequently used queries.
• Created new reports after gathering requirements from business users and modified the existing ones using Web intelligence which are built on top of Universes.
• Involved in the designing and building of classes, objects and universes and exported them to CMS (Central Management Server).
• Developed crystal reports using charts, crosstabs, multiple sub reports and drill down features.
• Developed dashboards using various KPI’s for business users.
• Developed Dashboard Prototypes for C Level and Business Users.

Confidential

Solution Environment: SAP BI 7.0, SAP ECC 6.0, SD, MM, HR

SAP BI/BW Analyst/Developer

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing to go live.
• Involved in enhancing the standard data sources according to requirement.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
• Worked on HR data sources like 0HR PA 0 (Employee) and 0HR PA 1 (Personal Actions).
• Activated BI Content for Personal Administration (0PA C01, C02 Cubes) to analyze Personal data such as Head Count based on nationality, gender, Language, Personnel area employee group and organizational unit.
• Worked on HR Reports such as Employee Master, Employee Movement and Leave liability.
• Worked extensively on LO Cockpit structures like 2LIS 02 ACC, 2LIS 02 SCL, 2LIS 02 HDR and 2LIS 02 ITM to address different business requirements which also included enhancements.
• Created and Maintained Data flows and Reports for HR and MM Module and worked on routines.
• Worked on the OTC cycle flow as per the reporting requirements such as Vendor analysis, Materials management etc.
• Worked on Master Data Info objects related Employee, Customer, Vendor and Company code.
• Developed start routines, end routines and field routines for data modeling.
• Worked on performance tuning techniques like compression of Info Cube and rolling up the Aggregates.
• Used Open Hub Destination to store data from SAP BI to local databases for ad-hoc reporting purpose of ERP users.
• Experience in building Multi Provider and Info sets as per the query needs.
• Developed custom WAD templates for BI Statistics.
• Worked Extensively on Bex Query Designer and Analyzer and used features like Variables, Structures, Exception Cells and RRI.

Confidential

Solution Environment: SAP Net weaver BI 7.1, ECC 6.0, FI

SAP BI/BW Consultant

Responsibilities:

• Involved in, designing and developing reports, Integration testing, unit testing to go live and production support.
• 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.
• Handled accounts payable cubes (0FIAP C03), accounts receivable cubes (0FIAR C03) as a part of SAP BW implementation.
• Created process-chains to automate the Data Loads, Rollups into Aggregates, Creating and Deleting indexes to improve Load performance.
• Worked on Open Hub Services.
• Extensively worked on front end reporting by using BEx, WAD and publish report in portal.
• Worked wif Business users on regression testing the Monthly and Quarterly reports and fixing the issues occurred wif a team of developers.
• Developed transformations wif start routine, update routine and end routine and involved in the creation and maintenance of DTP and Info Packages for loading data in to data targets.
• Monitored Real-time data acquisition (RDA) through Daemon and involved in the RDA related data load error handling.
• Monitored SWAT alert console (Daemon and Process Chains of production System).
• Have Performed Go Live Checks before the release of BI system.
• Involved in Production Support, Data Load Monitor, and On Call for users.

SAP BW Consultant

Confidential

Responsibilities:

• Involved in up gradation of SAP BW 3.5 Flow to BI 7.0.
• Customized Info Cubes for SD (Sales Overview Cube 0SD C03) and FI-AP (Line item Cube 0FIAP C03) to meet business requirements.
• Involved in extracting data from LO and Generic extractors.
• Created Generic Data Sources using tables, views to extract data.
• Worked on Partitioning and Info Cubes Compression.
• Worked on ETL activities like Extraction from Source system, Applying Transfer rules and Update Rules and Loading data to Cubes.
• Loaded Hierarchy from R/3 and Flat files as per the business requirements.
• Used ABAP coding for Start Routines and Transfer/Update Rules to meet the customer requirements and worked on creation of Aggregates and hierarchies for the Info Cubes to access data in an efficient and ordered level.
• Created Process Chains for automation of data load and data target administration and monitored the processes.
• Loaded the data from ECC to BI and used initialization wif delta update and full update methods.
• Upgraded Bex Reports from 3.x to BI 7.0.
• Developed reports using Bex Analyzer and Workbooks using RKF, CKF, Variables and Exceptions.
• Generated reports on Multi Cubes to compare the plan/Actual production quantity.