SUMMARY:

• 17 Plus Years of Professional Experience in Analysis, Technical Design, Development, Implementation, Testing and support of Business Warehouse Solution, HANA and Business objects.
• This Includes Around
• 13 years in SAP BW,
• 13 Plus years in SAP BW - ABAP,
• 4 plus years in SAP HANA (Native and BW on HANA), and SLT,
• 6 Plus Years in SAP Business Objects and BODS,
• 3 plus years in SAP BPC,
• 5 years in J2EE, Client server and AS/400 applications.
• SAP HANA Certified, US Citizen with Secret Clearance.
• Implemented 7 Full life cycle BW projects includes SAP SD, MM, Billing, Inventory Management, warehouse management(WM), EWM(Extended Warehouse Management), CO-PA, Retail, SAP AFS, CRM (lead management, opportunity management, Sales, Service and Marketing), FI-CO, PP, C projects, Project Systems, FI-GL(Old and New Extractor), FI-AR, FI-AP, Funds Management (SAP FM), SAP QM, Plant Maintenance, inventory management, SAP LO, HR (HCM), Asset Accounting (FI-AA), Cost Center Accounting (CCA), Variant configuration extractors, SAP Solution Manager, SAP ABAP, BW 7.x Upgrade, Extracted data from Hyperion, SQL Server, Cognos and Flat Files
• Implemented 3 Full Life Cycle HANA implementations and POC’s, including BW on HANA, Side Car HANA and HANA migrations.
• Implemented 5 Full life cycle SAP BO Implementations (BI launch pad(Info View),BI workspaces(Dashboard Builder), Dashboard Designer(Xcelsius), Explorer4.0, Web Intelligence, Universe design tool(Universe Designer), Business Intelligence Consumer Services (BICS), Information Design Tool, Crystal Reports, BO Analysis office for Excel, SAP Lumira 1.31 and SAP Design Studio 1.6
• Implemented 3 Full life cycle BPC Implementations (Financial Planning, Budgeting, Forecasting and Reporting, Sales Revenue Planning, Sales Cost Planning, Sales Volume Planning, HCM Planning).
• Strong analytical, interpersonal, team oriented and problem solving skills.
• Responsible for Resource Management, Client Relationship Management, Problem Solving & Escalation Management, Lead the offshore team.
• Ability to multi-task and self-prioritize workloads
• Highly motivated and work independently in a highly collaborative environment with strong results with little or no oversight.
• Experience working in various Project Methodologies - Water fall and Agile
• Research issues leveraging SAP Notes.
• Create and manage execution of development timelines on-time and on-budget.
• Manage onshore and offshore development resources.
• Involved in cut-over activates, after go-live support, user training and Production Support.
• Worked with Users/Managers to gather the requirements.
• Develop the BW/BO/HANA standards, processes, and procedures
• Performed Design and configure applications, Blue Printing, Participate in the gathering of functional requirements, Fit-Gap analysis, Prototype the solution for the client, Creation of Technical/Functional specification Documents, system configuration, customization, back end technical designs, unit test plans, Integration test plans, user documentation, Cutover Plans and Peer Reviews.
• Ability to manage projects (meeting minutes, project plans, communicate with the business, prioritize tasks, etc.)
• Conducted workshops and presentations to validate business requirements and solutions with the end user community. Developed business process. Conducted training for end-users.
• Develop methodologies, templates, tools and services to offer value added solutions to customers.
• Documentation, training and knowledge transfer of the application.
• Review of business processes and corresponding mapping into IT architecture

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW

E nvironment: SAP BW Version 3.X, BW7.X, Web Application Designer, Query Designer, BEx Analyzer and Visual Composer.

Responsibilities:

• Practical Experience with LSA++ modeling in BW 7.4+
• Experience in working with BW Artifacts (Cubes, DSO, Transformations, Multi-Provider, Composite providers), Info Objects, Info Sources, Info Packages, Transfer Rules, Update Rules, Process Chains and ETL jobs, Roles, User Authorization, security, Error handling, Delta updates, Data Marts, Transformations, DTP, Routines, Start routine, end routine, UD connect and DB connect, Aggregates, BW Statistics on Cubes, Remodeling of Info Providers, coding of ABAP in start routines, transfer routines, Extractor Enhancement programs.
• Experience in working with Composite providers, Advance DSOs, HANA optimized DSOs, Open ODS views, APD and Info sets
• Worked with Open Hub services for creation of Info Spokes for sending the data from BW to External Applications.
• Develop and implement best practices and standards
• Experience in BW Financials implementation of General Ledger including New GL, Accounts payables and fixed assets modules
• Proficient with planning, Implementation, troubleshooting and performance tuning support of SAP Business Information Warehouse. Analyzed performance statistics and recommended improvements.
• Scheduling and periodic monitoring of extractions through Info Packages and Process Chains. Created Process chains to automate Master data and Transaction data loads.
• Activate the Business Content Data Sources Enhanced the Business content based on requirements and Extract the data from Flat files and custom Extractors.
• Experience with BW upgrades from BW 3.X to 7.X
• Developed, extracted CRM reports in lead management, opportunity management, Sales, Service and Marketing.
• Extracted the data from SAP BPC, SAP WFM to BW via DB Connect.
• Implemented SAP HR and CO-PA, SD, CRM, MM, FI- AR, FI-AP, FI-GL, FM, Billing Modules.
• Installed the business content extractors and extended business content extractors. Tested extractors using extract checker program. Deleting & installing data from setup tables for specific application components.
• Implemented Number range buffering, while loading full load of data from R3 into info cubes
• Loading the data from SAP R/3 and historical data from flat files.
• Experience with BW Performance tuning at data loading, reporting before Go-Live.
• Maintained aggregates and indices for improved performance.
• Responsible for BW and BO Security
• Extensively used the Tcodes like RSRT, RSA3, RSA5, RSA6, RSA7, RSMO, RSPC, RSRV, SE09, SE11, SM37, ST22 Etc.
• Worked with Debugging Fox Formulas, Planning functions, manual planning layouts.
• Experience with Currency Conversions in the Data Modeling and reporting level.
• Strong understanding of SAP user exit programming principles, Function modules and the ability to develop enhancements using ABAP and BADI’s.
• Handled postproduction support and development of new design cycles simultaneously.
• Experience in developing BW queries using BEX query designer, BEx Analyzer, Navigational attributes, Jump targets (RRI), Variables, Hierarchies, WEB Report Templates, Custom Queries using Variables & Structures, Calculated key figures, restricted Key figures, conditions, raising Exceptions, workbooks, Info Set Query, Query designing, Filters, Exceptions, Web Application Designer,
• Developed queries, workbooks and used RRI jump queries (RSBBS) to drill down to other queries.
• Excellent troubleshooting skills, transporting the objects Using STMS from Development, Quality, and Production environments.

SAP HANA

Environment: SAP HANA SP10

Responsibilities:

• Certified in SAP HANA
• Trained in TZHANA, HA901R(SAP HANA-CO-PA Accelerator), TZH300, TZH200, TZBWHA(BW on HANA)
• Very good understanding of HANA Architecture
• In-depth knowledge and hands-on experience of HANA security/user setup configuration.
• Working Experience and showcase solutions built with BW on HANA environment.
• Translate Business KPIs into HANA models
• Experience collecting business requirements, conducting blueprinting workshops, writing technical specifications.
• Worked with onshore and offshore development resources and review the HANA models and reports.
• Experience in SAP HANA data modeling using Attribute View, Analytic View, and Calculation View(scripted and Graphical), Hierarchies.
• Experience with HANA Objects creation using SQL Script, CE Script ( Stored Procedures and Calculation Views ),Trouble shooting and debugging
• Created semantically partitioned object, composite provider on top of HANA views.
• Created Web intelligence and Analysis office for excel reports on top of HANA views.
• Executed BW on HANA pre-migration / post-migration tasks
• Experience with HANA Database Migration using DMO
• Experience with SAP ECC table data model and analysis
• Experience in implementing SAP Landscape Transformation (SLT) to load and replicate data in scheduled or real-time mode from an ECC into SAP HANA
• Experience using SAP HANA Direct Extractor Connection (DXC) and ODP
• Hands on experience in using SAP BODS (Business Objects Data Services) and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA
• Expertise in joining multiple data sources virtually in HANA
• Involved in BW 7.3 Upgrade and migration of BW objects into HANA optimized objects
• Strong HANA SQL Performance tuning skills and model performance tuning.
• Experience with SAP HANA Administration including managing schemas, data model objects, import/export content
• Experience with SAP HANA Privileges, Security including User Management, Roles, and Privileges
• Experience Build the reports with BO Analysis office, SAP Lumira, SAP Design Studio and Tableau.
• Hands-on experience in modeling scenarios and activities such as adding a system, creating schemas, importing table definitions, adding connections.
• Experience handling integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration, etc.

SAP Business Objects

Environment: Business objects 4.1, BI launch pad, Dashboard Design, Explorer, Web Intelligence, Universe design tool(Universe Designer), Business Intelligence Consumer Services (BICS), Information Design Tool, Crystal Reports, BO Analysis office for Excel, SAP Lumira, SAP Design Studio 1.6, Tableau.

Responsibilities:

• Experience in Migrate Business Intelligence Content to SAP Business Objects BI platform 4.0 and 4.1
• Design and build BI reports using Web intelligence, SAP Analysis office for Excel, Design Studio, SAP Lumira
• Created and BICS connections to access the BW queries through Web Intelligence.
• Created the User training documents on SAP BO tools.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Designed and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Prepared Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management Using Xcelsius and SAP Design Studio.
• Hands on experience with Business Objects Integration with SAP BI 7, Universes and Created Complex and Ad-Hoc Reports using Web Intelligence.
• Experience with using BEx queries and BOBJ reporting tools
• Experience working with LDAP authentication, SNC and SSO configuration

SAP Business Objects Data Services

Environment: BODS 4.0

Responsibilities:

• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Strong experience in SAP Data Migration, ABAP, LSMW, Data Quality, Data integration, Data Quality, data architecture and Data Management.
• Experience in Data Provisioning using Data Services ( BODS ) to HANA
• Created Jobs do the periodic extractions using BODS.
• Strong experience in using BODS as an external system for ETL between ECC and BI.
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Utilized Lookups table Joins, Match, Merge transforms and custom functions.
• Strong experience in cleansing the data using Data Quality transforms.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Experience in integrated SAP and non-SAP data with DS data flows, some with complex transformations
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool

Confidential

SAP BPC

Environment: BPC NW 7.0, BPC NW 7.5 and BPC NW 10

Responsibilities:

• Responsible for Project Blueprinting and Scoping, development and maintain the BW Backend Development, Report Development, BW Security, BO, SAP BPC and few basis jobs and manage the team members.
• SAP Business Objects Planning & Consolidation (BOPC) MS 7.5, NW 7.0, 7.5 and 10.
• BPC Data Model (Application, Dimensions, Properties)
• Data Manager (Data/Conversion/Transformations, DTS and SSIS Packages)
• Input Schedules/Reports/Journals, Advance / Work sheet Logic
• Business Rules (Currency Conversion, Eliminations, Automatic Adjustments & Validation)
• Work Status, BPF, Security, Custom Measures
• Copy packages to copy the forecast, plan, and budget data
• Worked with the Business users to understand the Planning requirements and identified and configured BI related objects for planning.
• Created reports using EVDRE and advance formatting
• Hands on experience with BPC Script Logic, Customized FX logic, Cube-to-cube transfers within BPC, Automatic Adjustments, Balance Carry forward, Account Transformation, Macros to enhance User-Interface and Navigation.
• Prepare functional, technical specification for Planning, consolidation reports.
• Exchange rate Maintenance
• Load Creating Dynamic Range Exchange Reports and Schedules
• Defining Modeling Requirements and Creating Input Templates
• Creating and Developing Budgeting Business Process Flows
• Setting application set status, Adding new application sets
• Top down and Bottom up planning, Allocation and Elimination
• Go-live and post go-live production support
• Created Xcelsius dashboards for executive cockpit to report KPIs at various aggregations
• Reconciled the data of BPC consolidation and planning extracts with BI, ECC applications.
• Designed and developed transformation and conversion files for loading Transaction data into BPC