SUMMARY

• 12+ Years of professional experience engaging with the business stake holders to understanding business needs and provide solutions.
• 9 Years of experience in SAP BI 7.0.Currently working on BW on HANA 7.4 version, BOBJ Suite 4.1 and HANA native modelling.
• Involved with 5 full lifecycle BW implementation projects.
• Implemented 3 end to end full - life cycles using ASAP and Waterfall methodology across various modules in SAP BI/BW/BOBJ projects.
• Worked on SAP HANA Studio, Data Modeling using Attribute Views, Analytic Views and Calculation Views.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira and Business Objects reporting suite.
• Strong Understanding of the Architecture of SAP BW 7.X Versions & Core Data Warehouse Concepts and strong Experience in Data Modeling, Extraction, Transformation & Loading of Data using SAP BW
• Provides detailed technical documentation, procedures, troubleshooting, disaster recovery steps, monitoring and decommission steps to ensure world class service delivery.
• Tracks and communicates all identified issues with regard to applications (installation, patch and upgrade)
• Technically involved with Architecture Design, Develop/Build, and Optimize Solutions/Applications on SAP HANA. Also participated in BW on SAP HANA, BI Analytics and Report Integration on SAP HANA.
• Coordinates user acceptance testing of patches and the scheduling of the patch application to the client’s production environment and accurately documents activities in Remedy/Service Now tickets
• Experience in project analysis, gathering user requirements, technical design and customers.
• Experience with onshore /offshore support teams.
• Experience with Quality compliance Documentation like IQ, OQ and PQ requirements.
• Experience in Project Management, Budgets, resource management,
• Excellent communication, interpersonal skills, positive work attitude and self-motivated to work independently as well as in a team. Solid understanding of both business processes and technical development.

TECHNICAL SKILLS

• Data Warehouse: BI 7.0, BW 3.5, BW on HANA 7.4, BOBJ 4.1, 4.2, ABAP, BODS, Tableau
• Operating systems: Windows 97/2000/XP/Vista/7, MS DOS, Oracle, SQLERP Packages, SAP ECC 5.0, 6.0, R/3 4.6, 4.7, EHP7 and EHP8
• SAP Modules: FICO, COPA, MM, PP, PM, SD and Vistex
• Reporting Tools: BEx Analyzer, BEx Query Designer, WAD Crystal reports, Desktop Intelligence, Web Intelligence, Dashboards, CRM on Demand (iView)
• Other ERP/servers: Oracle CRM on Demand, IMS Health, Nucleus 360, D&B, Sage, Mainframes, Great Plains server

PROFESSIONAL EXPERIENCE

Confidential

Sr.SAP BI/BW Analyst

Responsibilities:

• Managed BW on HANA 7.4 and Business objects implementation as a project Manager/Architect.
• Managed Technical upgrade for BW on HANA 7.4 SP09 to SP14 and Business objects 4.1 SP05 to SP07.
• Managed a team of team of 7 BW developers and successfully delivered 70+ reports in 18 months.
• Successfully delivered 6 Dashboards for Finance, Vistex, SCM and Sales & Marketing.
• Single point of contact for all Analytical queries.
• Worked with several users and interacted with them to gather requirements and transformed them using multi-dimensional data modelling techniques.
• Successfully consolidated reporting in BI in cross system environment where MDM is a central hub for harmonized master data (single point of truth for all master data of an Enterprise). This helped the business user community in cost reduction and gain competitive edge through MDM supported BI analysis in scenarios like Vendor Evaluation, Global Spend Analysis, and Top N Customer Analysis.
• Worked extensively on Advanced DSO’s, Composite providers and HANA native modelling views.
• Trained 200+ end users (Super users and Analytics team) for Business Objects reporting capabilities.
• Successfully integrated to oracle CRM on demand for Sales reps reporting.
• Successfully integrated third party data providers like IMS health (Contract compliance reports) and Dun & Bradstreet (customer credit limits).
• Successfully archived and integrated the historical data in as per the TSA agreement
• Worked with the legacy systems users to understand the huge volume of legacy data stored on the oracle systems as wells as Mainframe DB2 systems and designed the arching structure on the BI system to store the huge volume of legacy data
• Managed middleware server for Oracle on Demand CRM system. Successfully integrated and supported the interfaces from SAP, IMS health, I contracts to CRM system.
• Managed major incident processes and drive to rapid conclusion by managing resources across teams and providing excellent and timely communications through service alerting.
• Daily monitoring of Help Desk tickets, investigating, implementing solutions, and advising end-users on the resolutions.
• Managing offshore Team activities and assisting with any design/data load/technical issues.
• Analyzed and activated Relevant Business Content and setup R/3, Flat File and BW as source systems.
• Manage multiple source systems like flat files/ECC/DB connect etc.
• Manage cross functional dashboard reports (Finance, Supply chain, Sales and Marketing, Plant production and R&D).
• Support Adhoc request for designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to the required level of information.
• Reconciliation of data from various sources including legacy systems as Present Data ware houses.
• Support for data load, validation, performance monitoring and tuning.
• Involved in Weekly, Monthly, Quarterly and Annual Data Loadings and performed Repeat Deltas, Repair Full Requests on need basis.
• Performed day-to-day administration, performance analysis, Universe, Web Intelligence, Crystal reports and problem determination and resolution, database reorganizations.
• Support the BASIS and Security team with Business Objects Security requests and report promotions.
• Support existing open hubs and APD’s for CRM and IMS health.

Confidential

SAP BW Consultant/Architect

Responsibilities:

• Managed complete life cycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing (UAT) to Go live production support.
• Worked on Financial Reporting requirements for GL, AR, AP and COPA modules.
• Worked extensively on LO Cockpit, application specific and generic extractors.
• Created new data model with multi-providers to improve query performance.
• Activated and installed Business Content Objects for FI, MM and enhanced Business Content.
• Created an Aggregate schema to improve the Query Performance drastically.
• Worked on standard extractors for FICO, SD and MM modules.
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to BW and to report using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user/function exits.
• Defined the currency manually in the BI system that is coming from two different R/3 source systems.
• Designed and developed over 10 FI-CO reports in BW.( Cash Collection, AR Aging, AP, WIP Report, GL Summary etc)
• Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show the Invoicing amount of the respecting periods.

Confidential, Valpak, FL

SAP BI 7.0 Consultant

Responsibilities:

• Worked on various BI 7.0 specific features including Data store Object (Standard, Write optimized, Direct update), Remodeling, DTP, Transformations, Info Sets, Data Warehouse Workbench, Process chains, Monitors, BI Reporting, Business Content, Generic extraction
• Responsible for interacting with Functional Team to validate data in R/3 and BI.
• Worked with several users and interacted with them to gather requirements and transformed them into a data model with the concept of star schema.
• Analyzed and activated Relevant Business Content and setup R/3, Flat File and BW as source systems. Reconciliation of data from various sources including legacy systems as Present Data ware houses.
• Created Process Chains to automate the Master and Transaction data loading process, Rollups of Aggregates, periodic Deletion of PSA data. Monitored the data loading.
• Migration of Flow from BW3.5 to BI7.0 version which includes data source migration, transformations in place of update and transfer rules and Query migration, creation of DTP in place of Info package to load data to the target.
• Involved in Weekly, Monthly, Quarterly and Annual Data Loadings and performed Repeat Deltas, Repair Full Requests on need basis.
• Provided support for data load, validation, performance monitoring and tuning.
• Involved in scheduled Roll Up of data from aggregates into InfoCubes. Compressed the InfoCube data for better performance
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data loads.
• Worked on LO cockpit for Maintenance of extract structures for Orders, Billing & Deliveries.
• Worked on extractors in Procurement & Inventory Management in MM.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to the required level of information.
• Scheduled Bex Information Broadcaster to e-mail BEx reports to users on periodic basis.
• Involved in support project team to resolved the tickets for various issues
• Resolved the tickets according to the SLAs.
• Involved in resolving the system generated tickets.

Confidential, Jabil Circuit, FL

SAP BI Consultant

Responsibilities:

• Identified data sources based on end-user reporting requirements..
• Involved in Data Modeling, data extraction, designing, creating, maintaining and analyzing Info-Cubes, DSO,DTP,ODS objects, Remote Cubes, Multi Providers, and Info-Sources, Extract Structures, Update rules and Transfer rules.
• Design, Customization & development of InfoCubes, ODS,DSO,DTP, InfoSpokes, Hierarchies, User Exits, Data sources, update rules, transfer rules and start routines.
• Worked with BEx Analyzer and BEx Query Designer for developing reports and worked on Web Reporting using BEx Web Publisher and created Web Templates for various scenarios using Web Application Designer, RRI report, creation of variants, replacement path variables, conditions, exception aggregates and variable offsets, customer exit variables.
• Experience in Data Modeling, R/3 and Non R/3 Data Extraction, BEX Reporting (including Web Reporting), Functional Analysis, Design, Implementation, Troubleshooting and Performance Tuning.
• Provided SAP Security design, SAP Sales and distribution module configuration, and support for SAP Net Weaver systems running BI 7.0 (Net Weaver 2004s) and Supply Chain Management, FI and ECC CO-PA.
• Performed day-to-day administration, performance analysis, Universe, Web Intelligence, Crystal reports and problem determination and resolution, database reorganizations.
• Developed various start routines, update rules and transfer rules.
• Optimized the performance of data targets by loading the data through proper selection criteria and maintained the request for each data load to compress it in the future and maintaining proper aggregates.
• Conducted and participated in a series of sessions to gather information and data flow between the various system in Ecolab and established mappings for their conversion to BI.
• Responsible for SCM, and SD Procurement, Inventory Management and Order Fulfilment.
• Analyzed source system for procure to pay process like requisitioning set up, Material, Business Partner, and Vendor master workflow, Document imaging, automated Expense Processing Solution, Check Print Solution and order to cash electronic card payment, customer service improvement and credit management workflow and Order to Cash.
• Worked in the areas of MM-Purchasing and extracted data from Data Sources like 2LIS 02 ITM, 2LIS 02 SCL.
• Worked on LO-Cockpit Extraction for the Inventory Management i.e. 2LIS 03 BX, 2LIS 03 BF and 2LIS 03 UM.