SUMMARY:

• Over 18 years of IT experience with 14 years of functional and technical expertise in SAP Business Information Warehouse, Business Objects Reporting, HANA and BW on HANA.
• Functional knowledge of different areas in SAP including MM, FI and SD from a reporting perspective.
• A good understanding of BW architecture and its various components required for delivering solutions. Involved in delivering multiple BW projects from a design/development perspective.
• Expertise in Business Objects 3.x and 4.x in various tools like WEBI, Dashboards, Lumira and Analysis for Microsoft Excel.
• Excellent Knowledge of SAP BW components like ADSO, Composite Provider, Info Cubes, DSO Objects and Transformations.
• Expertise in data Extraction from SAP ECC, SAP CRM and Non - SAP Systems.
• Experience in BW Performance Tuning by maintaining Aggregates, Compression, Partitioning and Indexing of DSO Objects.
• Excellent knowledge in SAP Business Objects XI R3/3.x, BOBJ 4.x like UDT,IDT, Lumira, Dashboard(Xcelsius), Web Intelligence(WEBI) and AO Reports using various SAP BW components as data sources.
• Expertise in designing and developing OLAP Universes, BICS connections using BW as source.
• Extensively worked on Design/Development of complex Process chains.
• Worked extensively on Open Hub to export data.
• Experience in Query Designer, BEx Analyzer, Bex Web Analyzer and Web Application Designer (WAD).
• Good Understanding of COPA, Finance, Logistics data (Purchasing, Inventory and Sales) in SAP ECC.
• Good knowledge in ABAP/4 Programming and Function Modules within the BW context.
• Experience with Analysis Process Designer (APD).
• Effective in executing multiple tasks and assignments on time or ahead of schedule.
• Worked in a validated environment.
• Worked on data modeling, data provisioning, reporting, and security authorization aspects of SAP HANA 1.0.
• Good working experience on HANA Enterprise - Modeling including Attribute Views, Analytical Views, Calculation Views, SQL Scripting, Table Functions.
• Good understanding of Variables and Input Parameters in HANA Modeling and CDS Views..
• Experienced implementing SAP Business Objects 4.x reporting on top of SAP HANA using WEBI and Lumira.
• Good understanding and experience in providing security restrictions on models using Analytic Privileges.
• Understanding of overall HANA Security.
• Working knowledge of ADSO, SAP HANA-Optimized InfoCubes, Consuming HANA models in BW via composite providers and vice versa.
• Good understanding of replication technologies like SAP LT, remote access via SDI adapters.
• Involved in export/import of information models from source to target systems.

PROFESSIONAL SUMMARY:

Senior SAP BW BOBJ HANA Solution Architect

Confidential, New York City, NY

Responsibilities:

• Responsible for end to end analysis, design and development of the following reports.
• Created fiori time entry stats reporting in AO and Lumira dashboard to analyze the usage.
• Worked on Multiple Lumira dashboard projects like BOKPI and Vendor Analysis.
• New Gross Billings and Revenue report.
• Indian Ledger P&L reporting.
• Indian Ledger Balance Sheet reporting.
• Net WIP Reporting.
• Worked on multiple enhancements and bug fixes to the existing reports.
• Sales extract status fix which involves creating generic extractor to get necessary data to update in BW.
• Add estimate creation date to DSO Estimate and Actuals Data ZSD13. Enhanced the extractor structure in ECC.
• Project and WBS Element User status and System status.
• Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.
• Created generic data source for custom requirement and enhanced data sources as required.
• BW on HANA Upgrade(BW 7.5)
• Created ADSO’s and Composite Providers for reporting and Dashboards as per user reporting requirements.
• Implemented new LO Extractor for Purchasing, Invoice Verification, Sales Document Condition which will be delta load in ADSO.
• Worked on upgrading the multi providers to the composite provider.
• Worked on upgrading Standard InfoCubes to SAP HANA-Optimized InfoCubes.
• Worked on upgrading BW 3.5 data flows to BW 7.5 data flows.
• Hybrid Modeling.
• HANA Native
• Created new Calculations views for reporting.
• Merged the data from different systems and created Information views for reporting.

Environment: SAP BW 7.x, SAP ECC 6.x, HANA1.0, BEx, BOBJ XI 4.x, ABAP/4 Development Workbench, MS SQL Server 11.00.6020.00.

Senior SAP BW BOBJ HANA Consultant

Confidential, Woodcliff Lake, NJ

Responsibilities:

• Responsible for requirement gathering, analysis, design, development and implementation of SYNC Account Lifecycle Dashboard.
• Worked with Basis team to implement SAP Business Objects 4.x platform.
• End to end analysis, design and development of SAP Dashboard 4.x.
• Created SAP BW BEx queries needed for Dashboard.
• Created SAP BO WEBI Reports for details data drill down from SAP Dashboard.
• Created BICS connection in SAP BO Platform to connect to SAP BW BEX Queries.
• Worked with portal team to launch the SAP Dashboard through SYNC Portal.
• Worked on Data Acquisition for K360 Dashboard.
• Created BEx Queries for K360 Dashboard.
• Created Openhub to generate and transfer SAP BW data.
• Created Meta Chain and Process Chain to schedule the jobs.
• Created configuration to load real time SAP CRM data in HANA database.
• Created Attribute, Analytical and Calculated views based on Account life cycle reporting requirements with COPA data sourced from SAP ECC and SAP CRM data.
• Created Universe, WEBI reports and Dashboard using the HANA Information views.
• Business Benefits: Partners are now able to see opportunities, engagements data in real time and make better decisions.
• BOBJ Reporting (WEBI and Dashboards) based on composite providers with historical and master data from BW on HANA and real time from HANA enterprise.

Environment: SAP BW 7.x, SAP ECC 6.x, SAP CRM 7.x, HANA1.0, BEx, BOBJ XI 4.x, ABAP/4 Development Workbench, MS SQL Server 10.50.2500.

Senior SAP BW/BI BOBJ Consultant

Confidential, Princeton, NJ

Responsibilities:

• Responsible for gathering business requirements from users to design and develop all P2P reports.
• Activated P2P extractors in ECC and responsible for initial data loads into SAP BW.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from Master Data and Transactional Data.
• Extensively involved in setting up of procedures for extracting data from SAP ECC using Generic Extraction.
• Enhanced DataSources and populated ZZ fields in ECC user exit using BAdI’s.
• Created InfoObjects, DSO, InfoCubes, MultiProviders, Datasources, Extractor, Transformation and DTP’s as per report requirements.
• Designed and Developed Bex Queries using Query Designer.
• Built formula variables and processing variables using replacement path and customers exit.
• Used ABAP for Data Source enhancements and extensively used ABAP Routines in Transformations to load and update data into Data Targets.
• Developed Universes in Designer using SAP BusinessObjects XI 3.x.
• Designed and Developed WEBI Reports and Xcelsius Dashboards using SAP BusinessObjects XI 3.x/4.0.
• POC using BOBJ Design Studio to showcase usability to the business community.
• Designed and developed extracts into SQL Database using SAP BOBJ Data Services(BODS) from NON SAP Data Sources.
• Analyzed and developed data mappings, transformations, control logic, design and run the jobs using Data Services Designer and the Job server respectively.
• Developed the Process chains to automate the data upload into data targets.
• Extensively worked on Analysis Process Designer (APD).
• Responsible for thorough data validation using different unit test cases using HP Quality Center 10.0.
• Responsible for documenting Functional and Technical Specifications for the Reports developed.

Environment: SAP BW 7.x, SAP ECC 6.x, BEx, BOBJ XI 3.x, BOBJ 4.0, ABAP/4 DevelopmentWorkbench, MS SQL Server 10.50.2500.

Senior SAP BI/BW BOBJ Consultant

Confidential, New Brunswick, NJ

Responsibilities:

• Responsible for deploying reports related to STRIVE financial application and Local Sales Reporting (LSR) SD logistics application.
• Gathered user requirements, by conducting user meetings and getting signoff on the requirements.
• Extracted sales data from queries into data targets using APD.
• Developed Crystal reports for weekly sales reporting.
• Prototyped BOBJ Universes and WEBI reporting to team and created Xcelsius Dashboards using Universe and QaaWS.
• Used Open Hub to generate multiple sales, cost and ICPs extracts for external customers.
• Enhanced BSP as per user requirements to implement business rules and bug fixes.
• Worked extensively on distributing reports with SAP Information Broadcaster.
• Deployed reconciliation reports between LSR and GPSG.
• Created IMS interface to store the customer and payer information send to the external users.
• Deployed MBOX secure file transfer interface.
• Performed Data Loads by using process chains. Worked on performance tuning by activating BW Statistics, Compression of Info cubes and Indexes.
• Involved in Transportation of all Objects like: Info objects, Query’s, RRI, DSO objects, Crystal Reports etc into BI production system after validation and testing the same in development system.
• Day to day level 3 support activities.
• Logistics Reports

Environment: SAP BI7.x, BW 3.5,SAP ECC 6.x, SAP R/3 4.6c BEx, ABAP/4 DevelopmentWorkbench, Oracle 10.x.

Senior SAP BI/BW Consultant

Confidential, Horsham, PA

Responsibilities:

• Performance tuning by generating aggregates and fine tuning the ABAP routines.
• Performed analysis, design, development and implementation of standard/customized Info cubes and DSO objects in FI and MM modules.
• Created DTP’s, Process Chains and Meta Chains to automate FI and MM loads.
• Created Purchase price variance report comparing purchase price with the vendor invoice price.
• Created COPA report to display Total NET Sales, Total Actual Spending and Gross Variances for a given company code and fiscal year/period.
• Analysis of R/3 COPA, FI and MM configuration as part of creating FDS.
• Enhanced standard extractor 0fi gl 4 to extract purchase order information.
• Enhancements to standard purchase order extractors and CCA extractors.
• Performance tuning by generating aggregates and fine tuning the ABAP routines.
• Implemented new BADI for virtual characteristics and key figures.
• Created Transformations to resolve special character issues.
• Created Generic Extractor in R/3 to pull NON SAP data.
• Open Hub to generate extracts in MM and FI modules.
• Created Jump to Targets for financial and cost center reports.
• Created dashboard using WAD to display financial charts.
• Used Variable exits for various reports.
• Created Transactional Info Cubes for BPS Layouts.
• Created BPS Layouts, Planning Profiles, Planning Areas, Planning Levels, Planning packages and Planning layouts and modified as per the requirements.
• Unit and Integration testing for all reports developed
• Helped in doing Operational Qualification testing for other operational reports.
• Educating, transitioning and power users
• Involved in End-To-End Validation effort which includes documenting URS, FDS and DDS, writing PQ and OQ scripts.
• Logistics Reports

Environment: SAP BI7.0,SAP R/3 4.6c,BEx, ABAP/4 Development Workbench,, FI, Oracle 8i/8x,AIX.

SAP BW Consultant

Confidential, CT

Responsibilities:

• Working with UBS as a member in the data warehouse team.
• I have been involved in multiple BW projects from design to implementation, sourcing data from SAP and NON-SAP systems for UBS’s Trading and Commodities division.
• Projects that I have been involved with are
• Risk Management Reporting
• Financial Reporting involving
• Accounting Transactions By GL Month Reports
• Financial Lists by due date
• Finalized account transactions by GL Account Reports.
• I was involved in pulling financial data from SAP and NON SAP Systems. Involved in implementation and production support.
• Master data harmonization from SAP and NON SAP Systems in BW.
• Designed and developed various BW Objects including Info Cubes, ODS’s, Master Data, Info Sources, transfer rules per reporting needs.
• Activated Standard Business Content In Finance to prototype various finance reports for user feedback.
• Trouble shooting and resolving all the Data Load issues and making sure that the latest Data is available to all the Users as per SLAs in Prod.
• Developed Start routines and update rules to implement business rules for master data, ODS’s, and Cubes.
• Developing Queries per user Requirements.
• Created transactional Info cubes to merge the FIGL data entered using SEM-BPS.
• Have written many Bex Customer Exits to satisfy user requirements including Variable exits and virtual key figures/characteristics user exits.
• Involved in Enhancing Finance extractors and writing user exits in R/3 to populate them.
• Created Generic Extractors to pull Costing data from R/3
• Used CO-PA reporting in prototyping by activating COPA Extractors using KEB0.
• Performance tuning using Aggregates, Rollups, Partitions and Compression of Info Cubes.
• Research OSS Notes for issues related to Standard BW.
• Process Chain Maintenance and Scheduling.
• Delegating the Development tasks to the Offshore Team, Coordinating with them to clear any Functional Doubts and providing technical help to complete the assigned tasks as per the set Deadlines.

Environment: SAP BI7.0, BW 3.0A,SAP R/3 4.6c,BEx, ABAP/4 DevelopmentWorkbench,, FI, Oracle 8i/8x,AIX.

Sr. Programmer/Analyst

Confidential, FL

Responsibilities:

• Designed and developed SAP to UNIFY (Inbound) Interface using PowerBuilder, Sybase, JAVA and UNIX.
• Responsible for the design, development and enhancement of various screens in UNIFY applications using PowerBuilder.
• Wrote Java Classes to create files that will be sent from UNIFY to SAP.
• Wrote Java Classes and Sybase stored procedure’s to update reconciliation report in UNIFY application.
• Maintained software change control using ClearCase.

Environment: PowerBuilder 6.5/7.x, PFC, Java, Oracle 8.x, Sybase 11.x/12.x, UNIX, ClearCase, Windows XP