PROFESSIONAL SUMMARY:

• SAP BW/HANA Consultant with 13+ years of experience working in SAP BW/BO/BPC/BODS/ HANA - and played different roles like Project Lead, Team lead & Team Member at both onsite and offshore locations.
• Worked in the full Life cycle Implementation projects right from the Requirement gathering, Designing Functional and Technical specs- Blueprint Design, to the Go-live
• Have 10+ years experience in SAP BW on BW Modelling, Extraction and reporting which includes BEx suite and BO Reporting Tools and hands on experience in Building and development of the SAP BW objects ( Info Objects, Cubes, ADSO, Open ODS views, Composite providers, Process chains, DTP, Info packages and transformations ) in the realization phase of the project and transforming them in to the reporting requirements of the business and also experience working in BW 7.4 on HANA and have good knowledge on the latest functionalities of SAP BW/4HANA
• Have 5+ years hands on experience working on SAP HANA Data Modeling, Integration, Data provisioning (SLT, SDA, SDI and BODS), monitoring the back end activities, User management, security, SAP HANA SQL script and HANA Live
• Have extensive knowledge in building virtual data models with CDS views and consuming HANA Live views and exploring the SAP HANA Live VDM using SAP HANA Live extension assistant and also in activation and enhancing of standard XS OData services
• Have good understanding in SAP HANA Cloud Platform (APIs, OData, RESTFUL) Architecting, developing, implementing and installing SAP HANA CLOUD
• Have 6+ years experience working with SAP BO Experience working with Business Object Tools - Universe Designer (IDT & UDT), WEBI, Xcelsius (Dashboards), BO Explorer, Crystal Reports, Analysis Office, Lumira and BO Design studio
• Have hands on e xperience working on SAP BODS in creating Jobs, Work Flows, Data Flows, and SQL scripts using various Transforms to successfully load data from multiple sources into a desired target
• Experience working on one project in SAP BPC 10 in designing models for the Budgeting, Forecasting & Consolidation for major Oil and Gas Client
• Experience working with the Business team to understand and help prioritize data and information requirements
• Experience working as SAP Delivery Lead in enforcing leadership and working with business subject matter experts, developers, and quality assurance staff to ensure that deliverables are met on a prescribed time
• Experience working with Prince2, Agile / Scrum methodologies
• Have Experience working with SLA driven SAP BI Production Support, New Development & Testing, Minor and Major Enhancement of the Datasources and experience writing routines using ABAP
• Worked with Confidential for more than 3 years in the design and development of Business By Design product
• Have Good functional knowledge in SD, MM, PP, FI-CO-GL, AP, AR & CRM
• Involved in the Application Transition Engagement Projects consists of Due-diligence and Knowledge transfer, documenting the issues and training the end users
• Experience working on Manufacturing, Utilities, Oil & Gas, Retail, Finance, Telecom, Food and Product Development domains
• Experience working across different geographical area Australia, USA, UK, Germany, Philippines & India

TECHNICAL EXPERTISE:

Project Management: Open Project

SAP: SAP BW 7.0, 7.3, SAP BW 7.4 on HANA, SAP HANA, SAP Business Objects 4.0,4.1,SAP ECC, SAP MDM, SAP ABAP, SAP BODS 4.2 ( Data Services),SAP HANA, SQL Server 2008 R2, Dashboards 4.0, Design Studio, Analysis for office,Lumira,crystal reports, SAP BPC 10

Ticketing Tools: SPC, Remedy,ServiceNow,HEAT

EMPLOYMENT HISTORY:

Confidential, Irving, Texas

SAP HANA Consultant

Technology: SAP HANA, SAP BO 4.1, SAP BODS, Analysis for Office, Tableau

Responsibilities:

• Building HANA models ( Attribute / Analytical / Calculation Views ) for the SAP Finance Data foundation project maintaining the entire data for Finance Data Ops team for Confidential
• Worked on the Confidential retail BW project in deploying new objects and remodeling of existing retail landscape, Creation of return orders, sales, procurement
• Worked on the sales tax reconciliation, Inventory goods movement and procurement data flows and making sure data is available to users
• Design, implement and monitor of SAP SLT replication in SAP HANA real time synchronization
• Worked on extraction and loading of data of data using SLT,SDA, SDI and BODS
• Worked on the SAP BW simplification project in merging existing BW solution to HANA and developing new solutions for Confidential tech and Digital by building HANA models and CDS views for the finance and retail solution
• Worked on SDA / SDI in creating the flow graphs for accesing the data remotely
• Worked on the SAP HANA Data Administration including managing schemas, data model objects, import/export content
• Support activities - On demand load scheduling and monitoring using autosys and working in close with the AWS team in making them understand the SAP BW/HANA objects for the development of snowflake models
• Interacting with the business end users and identify new business requirements and change requests in BW & HANA space and implementing the solution
• Worked towards in defining the methodology, tools and processes by conducting PI and retrospective planning
• Reports and Visualizations creation using Tableau and Analysis for Office

Confidential, Dallas, TX

SAP HANA Consultant

Technology: SAP HANA, SAP BO 4.1, Design studio, Lumira, SAP BODS 4.2, SQL server

Responsibilities:

• Interacting with the business end users and identify new business requirements and change requests in HANA space and implementing the solution
• Working closely with the business and working on the issues based on the priority and business impact
• Experience working with technical, cross functional teams and sales teams to drive growth initiatives in the SAP HANA space providing strategic direction and long-term vision for the SAP HANA implementation
• Worked towards in defining the methodology, tools and processes to ensure successful customer adoption Position and Deliver transition roadmaps between on-premises and Cloud solutions
• Architecting the analytics platform with SAP HANA & BW as major component, data services for ETL and BOBJ for Reporting
• Worked as HANA Technical Analyst to convert their traditional DB based analytical models to HANA models and to build new solutions using LSA++ architecture on both HANA Enterprise and BW on HANA systems. I was also responsible to lead their offshore HANA Development team
• SAP HANA Data Modeling - Worked in creation of attribute, analytic and calculation views(Type DIM/CUBE/CUBE with star join), procedures and SQL scripting
• Data Provisioning - Implemented data replication using SLT, ETL based using Data Services, flat files loading, smart data integration (SDI) and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA and creation of flow graphs
• Experience working in building virtual data models with CDS views and consuming HANA Live views and exploring the SAP HANA Live VDM using SAP HANA Live extension assistant
• Worked in creation of CDS Views for operational billing excellence, Margin assurance and creation of OData services and consumption
• Worked in creation of Composite providers, Advanced DSO (ADSO), Open ODS views for consumption of the HANA models in BW
• Experience working on the migration of BW cubes to HANA optimized
• Worked in the migration project of upgrade and migration of BW to HANA DB
• Knowledge on the latest SAP BW/4HANA functionalities
• Experience working in providing effective change management, incident management, risk management and continuity planning utilising best practices in systems support and service delivery, within the ITIL framework
• Worked in administrative activities like User management, creation of roles & security and developing analytical privilege
• Experience working in Importing and exporting functionalities of SAP HANA and native HANA transports
• Creation of Business layers in Information Design Tool
• Reports and Visualizations creation using SAP Lumira, Design studio and Analysis for Office

Confidential

SAP HANA Consultant

Technology: SAP HANA, SAP BW 7.4 on HANA, SAP BO 4.1, SAP IS-Utilities, SAP Dashboard 4.0, SAP Data services 4.2, Analysis for Office, ABAP, Microsoft SQL Server 2008

Responsibilities:

• Working closely with the business and working on the issues based on the priority and business impact
• Worked in gathering business requirements for SAP HANA and SAP BW on HANA Project
• Worked in Native HANA modeling in development of models to support BI reporting and analysis deliverables with the use of Attribute Views, Analytical Views and Calculation Views( CE Function), Calculation View (SQL script) and CDS views
• Integrate the data from non-SAP systems of acquired entities to SAP and maintain the reporting data integrity and security by developing reporting solutions in native HANA and BW on HANA
• Developing of SAP HANA information models based on the tables
• Creating definite configurations for the selected tables of ECC for Data replication process in SAP LT replication server
• Worked in administrative activities like creation of users, roles and managing
• Worked in Importing and exporting functionalities of SAP HANA
• Experience in developing script based calculation views using SQL Script
• Hands on experience in developing Composite Providers, Advanced DSO's, Open ODS Views for consumption of HANA models
• Creation of Bex queries and establishing BICS connections for WEBI reports and transforming the WEBI reports data as source for the dashboards using web services
• Involved in the requirement gathering and development of the IT performance, CPMO and field services Utility dashboards
• Developed HR Analysis dashboard for Employee Annual, Personal leave and sick leave using source as BW queries and developing WEBI reports and using web services to land the data in dashboards

Confidential

SAP BPC Consultant

Technology: SAP BPC 10.0, SAP BW, Microsoft SQL Server 2008

Responsibilities:

• Configuring Application Management models as per business requirement
• Design and Implementation of Treasury, Operations, General Administration, Business Planning and Loans repatriation models
• Conducting play back meeting to the users and reviewing the existing models and doing enhancements as per the requirements
• Managing Data Manager Extraction from BW system to BPC system for both Transaction data & Master data using Process chains and data manager packages
• Designed script logic for allocation of treasury finance to various base level companies
• Created Dashboards for Plan data, Budget allocation and forecasting
• Providing access to users based on the Hierarchy level, category and Entity level
• Creation of Business Process Flows(BPFs) in BPC to monitor progress of users, send email notifications, assure consistency and uniformity
• Created interfaces from and to BPC and BI data using Import and Export data manager packages with transformation/conversion files
• Creation special input schedules for posting high level adjustments after consolidations with worksheet logic
• Reconciling the data of BPC consolidation, planning extracts with BI, ECC application

Confidential

SAP HANA Consultant

Technology: SAP HANA, SAP BO 4.1, SAP BODS 4.2

Responsibilities:

• Worked on Data modelling using SAP HANA studio in design and development of attribute view, analytical view & Calculation views
• Worked in configuring and leading SAP HANA project implementation which include administration of SAP HANA, HANA Security Model Design, HANA Landscape Transformation Replication Server (SLT) Configuration
• Worked in Importing and exporting functionalities of SAP HANA and native HANA transports
• Responsible for managing, maintaining, and understanding of user requirements for stakeholders including Test Strategy, create test plans, business scenarios
• Worked with the BI competency to drive growth initiatives in the HANA space and providing strategic direction and long-term vision for the HANA investment
• Working on Data Services Management Console to schedule and execute jobs for extraction of Non SAP data to HANA DB
• Worked in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users and user groups

Confidential

SAP HANA/BW Consultant (Lead)

Technology: SAP BW 7.3 on HANA, SAP HANA, SAP BO 4.0, SAP ECC 6.0, SD, MM, FI, CRM, SAP BPC,SAP SCM, ABAP,SAP BODS, Analysis for office, SQL Server 2008 R2

Responsibilities:

• Leading the offshore team and ensuring SLA is met and conducting review meetings on daily basis
• Worked in creation of Attribute, Analytic and Calculation views, working with BODS & SLT replicators, Authorizations in HANA using the HANA Studio
• Worked in developing script based calculation views using SQL Script
• Creating definite configurations for the selected tables of ECC for Data replication process in SAP LT replication server.
• Replication of the selected tables of SD from ECC to SAP HANA.
• Performed transformations during the replication process.
• Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity
• Worked in the BW migration project
• Providing Proposal for the splitting of existing BW system based on company codes which are spread over worldwide by working with the Presales and Functional team
• Design and development of the SAP BW objects as per the change requests generated
• Scheduling the Data loads Using Process Chains
• Creating, Monitoring and Error Handling of Process chain
• Creation of queries, query variables, formulas using BEx Query Designer
• Rectification of load/replication failure errors during the replication process.
• Handling the issues experienced while transporting the newly developed objects across the landscape
• Performing the pre and post deployment tasks and checks after deploying the transport related to the project to further environments
• Working with the user authorizations and assigning them based on the business areas and hierarchy
• Design and build of reports using SAP BO Web Intelligence and Analysis for Office
• Providing KT sessions to the end users and the team members on the new issues encountered with the database model
• Involved in the project team and troubleshooting the issues of end users
• Scheduled data loads to BW from SAP R/ 3, Monitored data loads which are running hourly, daily, weekly & monthly basis

Confidential

SAP BW Security Consultant

Technology: SAP BW 7.3

Responsibilities:

• Worked in preparing the estimates by consulting with external stakeholders and presales team
• Providing proposals for the new security enhancements to be done
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation of new BI security
• Design and development of the roles based on the user Hierarchy
• Creation of Analysis Authorization objects and assigning
• Comprehensive use of Profile Generator to generate roles and assign roles to end users
• Creations different BI roles (Junior, Team Member & Expert Level ) and assigning Authorizations based on the level
• Using analysis authorizations to control access to BI data at multiple levels (Characteristic, Info cube, Hierarchy levels)
• Transportation of roles across the landscape

Confidential

SAP HANA Consultant

Technology: SAP HANA, SAP BOBJ, ECC, SQL Script

Responsibilities:

• Creation of SAP HANA Information Models using Attribute, Analytic and Calculated Views
• Setting the SLT configuration and replicating the tables from ECC
• Worked in developing script based calculation views using SQL Script
• Exposing created HANA views for reporting and showing the business the change in performance for new HANA implementation projects
• Worked with the pre sales team in providing the technical leadership and drive the delivery of strategic software partner applications on the HANA and BW platforms
• Conducted workshops and trained the internal team in COE on SAP HANA

Confidential, Manila, Philippines

SAP BW/HANA/BO Techno Functional Consultant (Lead)

Technology: SAP HANA 1.0, SAP BW 7.0,BO 4.0, SAP ECC 6.0, FI-GL,CCA, SAP CRM,, ABAP,SAP BODS

Responsibilities:

• Performed extensive work with project proposals for upgrade of the existing BW system and preparing the time line, budget and resource allocation plan
• Ensuring the delivery of customer requirements are done and supporting the offshore team
• Monitoring of the CCA and FIGL process chains
• Performing the month end activities for the FI data in 2 stages from 5th of every month
• Resolving the customer issues like - No data available in reports, Reports not matching with the source systems, ODS activation related issues
• Done enhancements like adding Info Objects, adding hierarchy and changing variable list of reports
• Involved in the extraction of the CRM data
• Analysing the root cause for long running process chains and finding the root cause analysis and applying permanent fixes
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer
• Involved in the Extraction of data using SAP BODS by building projects, workflows and data flows from various sources
• Enhancement of the CRM data sources as per customer requirement and development of BO dashboards
• Involved in the transition of KT, Forward and reverse shadow for the new members
• Designed & Developed Universe & WEBI Reports
• Administrative tasks are performed like deploying reports & dashboards and Migrating them from the testing server to production server
• Responsible for designing, building, testing, and deploying Dashboards, Universes and BO reports using Web Intelligence through Business Objects.
• Worked on scheduling and publication of reports
• Worked on the HANA POC for Confidential Telecom in understanding the Current Implementation and Business requirements
• Replication of approximately 40 tables from ECC to SAP HANA using SAP LT replication server, building HANA models, consuming the models using the and developing reports to project the business in performance of the reports with their existing reports

Confidential

SAP BW/BO Techno Functional Consultant (Lead)

Technology: SAP BW 7.0, SAP ECC 6.0, FI, SD, MM,PP,CRM, SAP BO, IP, SAP ABAP

Responsibilities:

• Performed Due Diligence of current Confidential (UK) SAP BW system
• Created resource loaded project plan during Due Diligence defining issue, risk and decision processes, conducting deliverable reviews and resolving client complaints
• Gathering the current system details for new business acquisitions
• Conducted performance monitoring, product evaluation and profitability analysis
• Done the detail Analysis of migration of data and from various sources to BW system
• Capturing the system complexity for detailed analysis
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables
• Worked with the sales team in the effective generation of data and feasibility studies necessary as basis for new product development
• Supported the project manager for on-going activities as well as planning and estimating additional work and subsequent phases
• Capturing the system complexity for detailed analysis
• Involved in the transition of knowledge to the offshore on modules MM, PP, FI, CRM, BO

Confidential, Charlotte

SAP BW/ BO Techno Functional Consultant (Lead)

Technology: SAP BW 7.0, SAP ECC 6.0, SAP BO, SAP MM,PP,FI,SAP ABAP

Responsibilities:

• Gathering Requirement from the Customer for the development of the KPI’s
• Design and development of the Blueprint
• Ensuring the delivery of the KPIs are done in phased manner leading team involving in problem solving, configuration changes, testing and system documentation
• Created project plan for the development of the KPI’s and detailed estimates for the Implementation of the KPI’s and post support activities
• Development of the complete flow of data from R/3 to BW for the MM and PP modules
• Design and Development of Supplier performance, POTD, Production efficiency and Inventory performance KPI’s
• Implementation of the standard BI content for the MM and PP modules and enhancing the data sources as per customer requirement
• Involved in the design and testing of the KPI’s before the G0-live
• Responsible for the creation of Finance and Business Areas Universe Business layer which will be used in creation of WEBI reports
• Responsible for the creation of WEBI reports and Dashboard designs based on business and functional requirements of the client
• Testing of Universe Business layer design, dashboards and WEBI reports using test case scenarios for quality assurance and quality control before deployment to Production system.
• Post-production support in front-end side (WEBI, Universe and Dashboard Design) for the deployed SAP BOBJ system.
• End user training to the customer on the reports
• Development of the reports and publishing in the portal

Confidential, NJ

SAP BI/ BW Techno Functional Consultant (Lead)

Technology: SAP BW 7.0, SAP ECC 6.0, SD, FI, MM,SAP ABAP

Responsibilities:

• Gathering requirements from the end users for the development of FI, Sales, MM reports
• Involved in the project team and troubleshooting the issues of end users
• Manage user and functional requirements and produce appropriate design documentation
• Done the reconciliation of data in SAP BW system to check the Integrity and validation of data from various sources
• Worked on remodelling of Info cubes to improve the performance issues using Aggregates, Rollup, Multi Providers, Indexing, Partition, and Compression
• Scheduled data loads to BW from SAP R/ 3, Monitored data loads which are running hourly, daily, weekly & monthly basis
• Worked towards in identifying security requirements, including creation of new roles and/or addition to existing for a given line of business
• Worked on performance related issues by Creating Aggregates, Partitioning, and Compression

Confidential

SAP BI Technical Lead

Technology: SAP Netweaver 2004s (BW 7.0), ECC 6.0, SAP R/3 4.7,SAP BO,ABAP

Responsibilities:

• Working on a BI Content Activation
• Worked on the Design and development of the BW objects as per the design document
• Involved in the Upgradation of the systems for next level of patching for the SAP BYD product
• Implemented the SAP Patches and notes for next level of upgradation
• Developed the Hot fixes for critical production issues occurred
• Involved in the product development of new SAP Business by Design (BYD) right from the patch level SP0 to latest version FP 2.0
• Involved in Production Monitoring of SAP BI/BW application with the more that 85 process chains and performed performance tuning activities, document the issues and train the end user
• Worked extensively in resolving the issues reported in BCP and SPC tools
• Involved in the TCO team for the reduction of issues in the customer production systems
• Involved in the SWAT team and monitoring the production issues of customer systems and documenting them and reporting them to expert support group
• Worked in the direct support group and resolving the issues based on the priority
• Involved in the creation of Universe and BO reports and publishing to portal
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirement
• User Management
• Business content Deployment
• Supporting the customers according to their requirement
• Managing the process chains and monitoring
• Basis Administration tables and transaction code quick references
• Working on the Automated process of content activation
• Resolving the errors on content activation
• Designed, developed, debugged and managed Universes
• Developed training material and Mentored employees on the Business Objects products