SUMMARY

• Over 11 years of SAP BI/BW with three complete full - cycle Implementation Experience as Techno-Functional consultant, Lead and an Architect with Fortune 500 companies in Pharmaceuticals, Manufacturing and Banking sectors.
• 4+ Years of experience in SAP BOBJ which includes Webi, Crystal Reports, IDT, Universe and Dashboard Design (Xcelsius).
• Good knowledge on SAP HANA.
• Experienced in SAP BI/BW: SAP Net Weaver 2004s BI/BW 7.3 and BW 3.5. Involved in design, development, implementation, and enhancement of SAP BW applications and objects.
• Experienced in ABAP for SAP BI/BW including Data Source enhancements, Generic DataSources, User Exits, BADI, Start Routines, End Routines, Field Routines, Expert Routines and Variable Exits.
• Managed implementation and delivery of complex SAP BI solutions, working closely withbusiness and technology teams to understand requirements and facilitate adoption of implemented solutions.
• Supervised and coordinatedall phases of BI solutions implementation including: planning, development, training, deployment, post-implementation support, and enhancements as related to SAP BI.
• Worked with SAP BI/BW modeling, extraction and reporting in integration with SAP ECC 6.0 modules, such as SD (OTC), MM (P2P), PP, FI/CO, and SEM, CRM.
• Worked extensively with SAP BI/BW Modeling components like Info Cubes, DSO/ODS, Info Objects, PSA, Data Source, Info Source, and Transformations.
• Comprehensive knowledge of Data Warehousing Workbench. Expertise in BI Content services consisting of Business rules, Metadata, Reference data, Extractor programs for SAP systems, Process chains, Roles and other data objects.
• Proficient in SAP and Non-SAP data extractions including BI/BW Content extraction, logistics cockpit configuration and customization, CO-PA Data Sources and Master Data, Hierarchies extractions from SAP and flat files and data loads using Process Chains.
• Experienced in performance tuning for data loading as well as reporting by applying techniques like indexing, compression and partitioning.
• Knowledge of, BI Authorizations, BI Statistics, Archiving, Event chains and Open hub.
• Worked in SAP Business Explorer (BEx) tools, such as BEx Analyzer, BEx Query Designer, Web Application Designer (WAD) and built queries and workbooks using conditions, exceptions, filters, Calculated Key Figure (CKF), Restricted Key Figures (RKF), Variables, Structures and Selections.
• Worked with BI Accelerator (BWA) to improve the read performance of BI Queries on InfoCubes.
• Knowledgeable in ASAP implementation methodology from requirement gathering to go-live, production support.

TECHNICAL SKILLS

Data Warehousing: SAP BI/BW 7.X, SAP BW 3.5

SAP Modules: MM, PP, SD, FI/CO, PS, BPS, BCS

Languages: ABAP, HTML

Database: Oracle 8/8i,10i/9i

Tools: Webi, Crystal Reports, IDT, Universe and Dashboard Design (Xcelsius), BEx Query Designer, BEx Analyzer, WAD, SAP Solution Manager, BEx Broadcaster.

PROFESSIONAL EXPERIENCE

Confidential — Basking Ridge, NJ

SAP BI Lead

Responsibilities:

• Involved in requirements gathering and finalized the reporting requirements for SD and FI users within B2I project.
• Created functional design documents (FD) and received approval for each stage from respective approver.
• Developed SAP BOBI 4.0 reports in Web Intelligence reporting tool (Webi), such as SEM Reporting Statistics for Management and provided Drill-down ability for Hierarchical characteristics.
• Developed SAP BOBI 4.0 using Dashboard Design/Xcelsius Dashboard for senior management which was for Quote to Cash Process.
• Created Universe and Connections using Information Design Tool (IDT) and integrated SAP BW and non-SAP systems to SAP BO BI Enterprise for Sales In/Sales out Reporting.
• Transported development to test and productions systems using Life Cycle Management (LCM).
• Updated BEx queries and SAP BOBI 4.0 reports in order to in corporate changes in Profit Center and CO-PA implementation to reflect the changes in the existing reports and made available on BI Launch Pad (InfoView) for business users.
• Established standards, processes, security, and governance methodology for business intelligence framework and work closely with Client staff to help them implement the same.
• Developed WebI Reports from BEx queries for Comparative Tax Provision Variance for Actual-to-Plan and Income Tax Variance Analysis for Actual-to-Plan-to-Forecast, Exception and Validation reporting sourcing data from TaxStream Tax Provision of ONESOURCE/Thomson Reuters, and SAP SEM and IP.
• Prepared project plan, architecture and design for Contract reporting.
• Designed and developed generic dataSource with function module extracting the contracts and billing plan related data.
• Conceptualized design and created DSO for contracts and billing plan.
• Lead an offshore team of four BW developers and engaged in handover meetings getting status updates for assigned development.

Environment: SAPBOBJ 4.0, SAP BEx Suite, SAP BW/BI 7.3

Confidential — Wilmington, DE

BI/BW Design Lead

Responsibilities:

• Involved in requirements gathering and finalized the reporting requirements for PP and QM users within One Confidential project - Global Consolidation.
• Created functional design documents (FD) for backend, semantic layer and reports and received approval for each stage from respective approver.
• Resolved current issues of KPIs like BOM Accuracy, Inventory Record Accuracy (IRA), Production Schedule Performance (PSP) and Production Schedule Stability (PSS) by addressing them in new Backend design.
• Participated in workshop to understand shop floor reporting requirements.
• Created PoC in HANA Studio in order to combine data of LIMS and ECC and to test Real Time Reporting capabilities.

Environment: SAPBOBJ 4.0, SAP BEx Suite, SAP HANA, SAP BW/BI 7.3

Confidential — Jersey City, NJ

SAP BI/ BW Senior Developer

Responsibilities:

• Designed and developed generic DataSource with function module extracting pharmaceutical batch related information that contained parent batches and their child batches along with their manufacturing stages.
• Developed generic DataSource with database view for pharma batch classification data that extracted information related to manufacturing success rate in the initial production batch run.
• Conceptualized design and created DSO for pharma batch run and created reports for business users displaying information on production batch deviation.

Environment: SAP BI 7.0, PP, SAP ECC, ABAP, SAP BEx Web, BEx Analyzer, BEx Query Designer

Confidential — Toledo, OH

SAP BI/BW Team Lead/Architect

Responsibilities:

• Prepared project plan, architecture and design for PO Sourcing application which was mainly utilized to measure supplier’s delivery performance and buyer’s activity performance.
• Lead an offshore team of four BW developers and engaged in handover meetings getting status updates for assigned development.
• Participated in brain storming meetings for KPI determination and finalized important KPIs, such as average number of delayed deliveries and average number of days in delayed deliveries.
• Created documentations for object mapping, functional and technical design specifications for InfoProviders, and business content DataSource enhancements.
• Developed plan for cutover activity which included clearing of the queues, deletion of setup table, refilling of setup tables and other related steps.
• Prepared and maintained cookbook containing list of transport requests to track the changes for ECC as well as BW, which was utilized by BASIS during of go-live.
• Involved in post go-live activities like stabilization and handover to support.

Environment: SAP BI 7.0, SAP ECC, MM (P2P), ABAP, SAP BEx Web, BEx Analyzer, BEx Query Designer

Confidential — Phoenix, AZ

SAP BI/BW Team Lead

Responsibilities:

• Enhanced logistics data flow for Sales Order item and Billing item which included enhancement in DataSource and changes in InfoProviders, transformations, routines and BEx reports.
• Modified Booking and Backlog logic via exit programs of Sales Order associated with generic DataSource.
• Discussed and finalized changes needed in reports of CRM (MDF area) and modified InfoProvider as well as workbook according to agreed changes.
• Enhanced Opportunity Item DataSource of CRM and modified respective InfoProviders and reports for Opportunity Analysis.
• Designed and developed Dashboard for Opportunity Analysis and published on Enterprise Portal for senior administrators for decision making.
• Created BICS connections with BEx queries and used them to create WEBI as well as Crystal reports.

Environment: SAP BI 7.2, SD, CRM, SAP ECC, ABAP, BEx Web, Analyzer, Query Designer, Broadcaster

Confidential — Portland, OR

SAP BI/BODS Consultant

Responsibilities:

• Gathered requirements to analyze the data from various legacy systems for the purpose of migrating the same to SAP.
• Designed and developed multiple jobs and workflows based on migration strategy finalized in requirement analysis.
• Developed data mapping and data load frequency schedule to accomplish legacy data migration to SAP system and automated end-to-end process.
• Worked on BODS Toolset such as Designer, Management Console, Repository Manager, Server Manager and other suite of tools.
• Designed and developed BODS components such as Projects, Jobs, Workflows, Data Flows, DataStores and Transformations.

Environment: SAP BI 7.0, SAP ECC, BO, OLTP, Oracle 10i/9i, Windows 2003.

Confidential — Benton Harbor, MI

SAP BI Senior Developer

Responsibilities:

• Analyzed production issues and resolved them according to priority within SLA with focus on corporate finance reporting.
• Managed and prioritized production support activities in the Onsite/Offshore model and managed regular handover meetings for coordination of day to day activities.
• Fixed the warranty mix issue of Confidential appliances that was long pending and in unresolved state for many months before my undertaking.
• Involved extensively in debugging of end routine and expert routine and improved the code from performance perspective.
• Designed and developed BEx queries using BEx Query Designer as well as modified existing BEx queries according to client requirements.
• Created BO Universe for financial reports on top of BEx queries and developed ad-hoc financial reports that were created from BO universe using WEBi.
• Modified the calculation of Currency Effect within end routine which was calculating the difference in key figure values due to change in currency rates.
• Involved in implementation of SAP notes while implementation of IFRS where SAP standard program was changed.
• Coordinated with BASIS and functional resource during note implementation.
• Fixed an ABAP report of SCM which had dynamic internal tables.

Environment: SAP BI 7.0, FI/CO, SEM, APO, SAP ECC, ABAP, SAP BEx Web, Analyzer, Query Designer

Confidential — Beaverton, OR

SAP BSA Lead

Responsibilities:

• Approved production support request for various cross functional activities to ensure avoidance of adverse effects in BW environment due to functional changes.
• Analyzed the SAP BW production issues of GTM (Go-To-Market division) sales and resolved them according to priority within SLA.
• Governed various Confidential specific processes like Freeze Calendar Update and DQI (Data Quality and Integrity) check to ensure that source systems and BW are in sync.
• Participated in on-call rotation for support and provided prompt attention to batch delays.
• Involved extensively in authorized futures restatement process which was customized BW process of Confidential calculating important key figures utilized by planning applications.
• Involved in unit testing, integration testing seeking UAT approvals during SAP R/3 upgrade from 4.7 to ECC 6.0.
• Conducted End user training.

Environment: SAP BI 7.0, SD, SAP ECC, ABAP, BEx Web, Analyzer, Query Designer, Broadcaster, BO

Confidential — Raleigh, NC

Responsibilities:

• Interacted with the business users directly, gathered business requirements, and analyzed and compiled deliverables for various multi-dimensional queries and reports.
• Enhanced and modified business content DataSources, InfoProviders, reports and transformations after understanding and documenting the requirements from SRM (P2P), QM and PP area.
• Created documentations for object mapping, functional and technical design specifications for InfoProviders, and business content DataSource enhancements.
• Improved Sales Item DataSource to upload the Sales Order item data along with style numbers so users can do sales analysis with respect to style numbers.
• Scheduled batch jobs data load coming from various source system.
• Modified FI business content base cube, virtual cube and function module according to client’s requirement in order to satisfy the requirement of balance-sheet report.
• Created Process Chains for master and transaction data load.
• Generated BEx Queries for Warranty Report, Inventory Aging, Sales representative efficiency, and Vendor delivery efficiency.

Environment: SAP BI 7.0, SRM, QM, PP, SAP ECC 5.0, ABAP, BEx Web, Analyzer, Query Designer

Confidential — New York, NY

SAP BI Analyst

Responsibilities:

• Participated in the end user discussions to get a thorough understanding of the front end reporting requirements.
• Involved in scrum meeting in order to resolve the Production issues.
• Played vital role in finalization of SLA.
• Created various reports for SEM- BPS and SEM-BCS from virtual cubes.
• Worked with the BI Accelerator to improve the read performance of BEx queries on InfoCubes.
• Extensively involved in implementation of GAAP- Switch process for NY branch.
• Extensively Involved in Standardization of ETL process of NY Branch.
• Developed different queries based on calendar day week, month and year in order to obtain any combination of reports from the InfoCubes.
• Used Information Broadcaster to pre-calculate and distribute reports to end users and also used to distribute templates created with WAD to end users.
• Provided end user support for system and process issues as they arise in the course of day-to-day business.

Environment: SAP BI 7.0, SEM, SAP R/3 4.7, ABAP, BEx Web, Analyzer, Query Designer, Broadcaster

Confidential

SAP BI Developer

Responsibilities:

• Participated in the end user discussions to get a thorough understanding of the front end reporting requirements.
• Gathered data from the functional specs to implement custom made InfoCubes to cater their requirements.
• Created InfoObjects, InfoCubes, Data Store Objects, and DataSources and transferred data from Data sources to Data Providers by Data Transfer Process to load transaction data into InfoCubes using Transformation rules.
• Created BEx queries for Planned vs. actual reports for monthly, quarterly and annual analysis; interactive Bex-Query for SEM-BPS was also created.
• Setup the Process chains for data flow control.
• Created Aggregates and repartitioned InfoProviders for performance optimization and efficient utilization of data.
• Troubleshot problems and determine solutions. Implement fixes and small enhancements.
• Monitored and optimized performance of information queries and reports.

Environment: SAP BI 7.0, SEM, SAP R3 4.7, ABAP, BEx Web, Analyzer, Query Designer, Broadcaster

Confidential

SAP BI/BW Consultant

Responsibilities:

• Extensively involved in setting up of procedures for extracting data from SAP R/3 using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements.
• Managing LO Cockpit (LBWE). Scheduled and Implemented delta mechanism for periodic loads.
• Analyzed the info cubes and maintained the aggregates to improve the reporting performance for BEx reporting.
• Built formula variables and also processing variables using replacement path and customers exit.
• Designed and developed numerous BEx Reports and Info Set Queries on the developed Info Cubes, ODS Objects.
• Created, scheduled and monitored Info Packages and creating process chains to load data from R/3 and flat files, aggregate rollups, index maintenance, master data and ODS data activation.
• Improved and optimized query performance by Info cube maintenance involving aggregate, rollups, Compression/collapse, partitioning the info cubes.
• Checked the inconsistencies and repaired using the Transaction code RSRV & also monitored the Query performance by using Transaction code RSRT.
• Scheduled timely deletion of data from PSA to improve the performance.

Environment: SAP BW 3.5, R/3 4.7C, SD, BEx, WAD, Windows 2003

Confidential

SAP BI/BW Consultant

Responsibilities:

• Responsible for data modeling of the Sales and Distribution Module, and Master data (Customer and Material Master), for the SAP Business Information Warehouse (BW).
• Gathered data by consulting with the functional specs and decided to implement custom made InfoCubes to cater their requirements.
• Worked extensively with Administrative Work Bench (AWB).
• Customized the InfoCubes (Basic Cube, MultiCube), Info Source and InfoObjects.
• Sound knowledge in extending the Business Content based on requirements
• Implemented data extraction and data staging using both LO Cockpit and enhanced the structures using user exits to support the business needs.
• Tailored transfer structures, communication structures and update rules based on the requirements and scheduled the Info-packages for data loads.

Environment: SAP BW 3.5, SAP R/3 4.6c, FI/CO, SD, MM, PP, SAP BEx Analyzer and Explorer, BEx Browser

Confidential

SAP BI/BW Consultant

Responsibilities:

• Involved in the star schema design with multiple dimensions and fact tables.
• Involved with BASIS in setting up connectivity between SAP BW and R/3 systems for data extraction.
• Monthly & Weekly extractions are scheduled using Info Packages on Sunday nights & End of month by using after jobs & after events.
• Set up transfer rules, wrote transfer routines, start routines, and updated routines.
• Set up statistics/aggregates rebuild and event-chains to notify end-user of report availability.
• Created ODS structures, Info-Cubes, custom Queries, etc.
• Take the requirements from Finance, Procurements Process Owners and fine tune with End Users.

Environment: SAP BW 3.5, SAP R/3 4.6c, FI/CO, SD, MM, PP, SAP BEx Analyzer and Explorer, BEx Browser