SUMMARY:

• Sr. SAP Solution Architect and SAP HANA, BW, Business Objects (BI/BO), ABAP with over 14 years of experience in implementing Business Intelligence solutions across various industries.
• Worked on ODATA services, consuming the ODATA services and deploying the FIORI application on ERP system and HANA cloud platform.
• Experienced in SAP HANA end - to-end implementation thereby worked on real time data acquisition using SLT, Data Modeling in HANA - designing and building Attribute Views, Analytic Views and Calculation Views, HANA security and authorization, Importing BW models in HANA and SQL script.
• Extensive experience in writing Stored Procedures in HANA using SQL Script
• Strong Experience in Performance Tuning and Query Optimization. Identify bottle neck in performance in terms of reporting.
• Hands on experience in using SAP BODS (Business Objects Data Services), SLT and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA
• Expertise in Attribute Views, Analytical Views and Calculation Views (Graphical and Script).
• Good experience in Performance tuning using Plan viz.
• Performed loading data from flat file (CSV & Excel) into SAP HANA system.
• Hands on development experience with SAP Business Objects 4.X Reporting Tool Set
• Experience in designing and implementing security for SAP HANA.
• IT Experience in ERP-SAP ABAP/4 Programming including End-to-End life cycle Implementations, Roll-outs, Upgrades and Support projects.
• Worked across various modules of SAP ECC 6.0, SAP 4.7EE, 4.6C, 4.6B - FI/CO, SD, MM, PP, QM CRM, HCM, SCM, SRM with good functional knowledge
• Expert experience as SAP Business Objects BI 4.x, Crystal Reports, Lumira, Report Developer/Architect/Administrator, IDT, SAP BW (Bex Queries), Desktop Intelligence, Universe design, BO Migration/Conversion, SDK, SSIS, BMC/Remedy.
• Experienced in interacting with users to gather business requirements, create detailed high-quality Business Blue Print, Functional and Technical specifications. Experienced in preparing data modeling and design documents based on the business requirements.
• Extensive experience in Data Modeling, Extraction, Transformation, Loading (ETL), Enhancements, Operations. Implemented Back-end BW Component Extractors, Consolidated data Retractions to ECC/BW, DTP, Transformations, and Info Objects, Generic Data sources, Info Providers, Hierarchies, Info Sources, Transformations, Info Cubes, Multi-Providers, DSO, Info Packages, Info Cube aggregates, Scheduling, Process chains & RRI Interface using BW Administrative Workbench.
• Strong Experience in Inbound & Outbound interfaces, ALE configuration, IDOC and Mapping concepts.
• Pricing procedures with pricing routines/requirement routines/ VOFM configurations.
• Have knowledge of SAP-Workflow.
• Have worked on modules including SD, FI, MM, PS, PP, PM, HCM, APO.
• Exposure to BW-ABAP, HR-ABAP, APO-ABAP, SAP BPC, SAP HANA.
• Have knowledge of SAP Personas, Floor plan manager for WebDynpro.
• Experience in handling technical upgrade and Unicode conversion projects.
• Client centric with focus on delivering quality products on time and within budget.
• Strong planner and organizer with demonstrated ability to master new concept quickly, in corporate new technology and develop highly efficient business solutions. Highly motivated, eager to learn and take on new challenges.

TECHNICAL SKILLS:

SAP Skills: SAP Business Objects ( BI/BO), SAP ABAP, Fiori / UI5 SAP Business Warehouse (BW) 3.5, 7.0, 7.3, 7.4 and 7.5

SAP HANA: Reporting Tools: Web Intelligence, Crystal Reports, BO Explorer, Lumira, Analysis for OLAP/OfficeDashboards, Design Studio, BEx Query Designer, Web Application Designer (WAD)

Database: Oracle, HANA, SQL Server

Languages: ABAP, SQL script

Tool: HP Quality Center (HPQC), Remedy MS Suites: MS Office, MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SAP Consultant

Responsibilities:

• Interact closely with the Business team on gathering the requirements.
• Providing architectural advice for multiple teams across organization.
• Understanding the business process and creating the functional and technical specifications.
• Creating Attribute, Analytic and Calculation views based on the requirements.
• Export and Import of HANA views between different lifecycle systems through Developer mode as well as through Delivery Unit Activating HANA views
• Building data marts to generate KPIs in multiple departments across organization, which helps in analyzing and planning the business activities.
• Helping in building multiple management reports like offerings by service family, spend analysis and After the fact report etc.
• Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Developing Web Intelligence Reports using SAP BO 4.1.
• Co-ordinate with client and handled project related issues.
• Support and enhancements for existing ECC applications in the area of HCM, FI, SD, MM. Worked on new developments as per the requirements.
• Prepared Unit test reports for the developed applications.

Confidential

SAP Lead consultant

Responsibilities:

• Experience in creating various HANA models for complex reporting, KPI requirements.
• Experience in Designing Complex Universes in IDT based on HANA Tables and HANA Views.
• Experience in WEBi 4.x on HANA.
• Experience in Crystal Report for Enterprise with HANA
• Experience in Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
• Experience in SAP Business Objects BI 4.0 Explorer
• Experience in Designing Information Space based on SAP Experience in HANA Information Model using BO Explorer 4.0
• Experience in Exploring the Data using BO 4.0 explorer based on Information Spaces created on HANA
• Experience in Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection).
• Experience in Multi-dimensional Model in SAP BI 7.5, Data Extraction and Data Flow within SAP BI, New Data source Concept, Transformation in BI 7.4(ETL), DTP, upgrading dataflow from 3.x to BI 7.x, Business Content, Administration of InfoCubes and Aggregates, BI Accelerators, DSO and Virtual Cubes and Multi Providers.
• Experience in performance tuning for optimizing data loads and reporting.

Confidential

Lead SAP consultant

Responsibilities:

• Provide trouble shooting/root cause analysis and resolution paths for reports/universes
• Utilize Information Design Tool (IDT) both convert unv universes to unx format
• Utilize Universe Design Tool (UDT) and Information Design Tool to create Universes
• Work with senior executives and regional managers to elicit standard report and dashboard requirements
• Design and create business intelligence reporting solutions using SAP Business Objects 4.1 Enterprise Client Tools Tableau Desktop
• Built Audit dashboards showing User/Report/Server Usage
• Develop Webi/Dashboards based on Relational (Oracle/SQL Server) data
• Build Dashboards using Xcelcius/BO Dashboards
• Authored internal IDT/Promotion Management Developer and User guides
• Provide Business Objects support/training for client staff
• Worked very closely with ETL team to have necessary Views and data loaded for the creation of Reports
• Involved in UAT and Unit Testing Experience in Data Extraction (ETL), ECC Extractions Using BI 7.4 Dataflow, Generic Extractions, Business Content Extractions, CO-PA Extractions, LO-Cockpit Extractions (Logistics) and FI-SL Extractions (Financial special purpose ledger)
• Developed ALV reports including graphical ALV display and blocked ALV display reports for displaying and aggregation financial month end reporting data.
• Design, development of smartforms and scripts for printing invoices and payment programs including misc invoices, check printing for Latin countries.
• Co-coordinating with business, handling defects, CRs, working with offshore team to manage deliverables.
• Used the Jira Agile software tool for issue and project tracking
• Experience in performance tuning for optimizing data loads and reporting.

Confidential

SAP Technical Lead

Responsibilities:

• Utilized new BI 7.3, Dataflow, transformations and DTPs for all new developments.
• Developed numerous custom data sources using database views and custom function modules.
• Implemented new BI 7.3 security authorization objects.
• Experience in design studio for designing the application.
• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Involved in activating Business Content for Standard Info Objects, DSO, InfoCube’s related to FI, CO-PA, SD.
• Experience in upgrading to BI 7.0/7.3 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0/7.3.
• Involved in creating many complex OLAP variables, DTP routines.
• Generated CO-PA redesign which involves addition of more fields with complete different flow and was involved in complete end to end testing for all the developments assigned.
• Performed LO-Cockpit extraction for Sales Order, Sales Delivery, and Billings by extracting Standard Data Sources from the Business Content using LO-Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in the Info Cubes to facilitate various reporting requirements.

Confidential

Sr. SAP Technical Consultant

Responsibilities:

• Developed more than 200 FI/CO, OTC reports for current rollout 10, worked on complex SQL Statements, broadcasting these reports, complex comparative and trend reports.
• Created OLAP Universes, using different sources and multisource universe, managing universe with data foundation and business layers and optimization techniques using IDT tools. Used BICS for most the reports.
• Worked to increase scheduled reporting capacity, improving web response speeds, CMS (central management server) configurations, CMS clustering across subnets, working with QAAS. Used Combined Queries, created query based on another query, calculation contexts, creating formulas and used string functions.
• Resolved lot of issues with BI4.0 upgrades (SP02 to SP04)
• IT1, IT2, IT3 and UAT testing with functional leads, train functional users and planning to rollout BI and BW.
• Integration between APO and BW, loading the data from ECC to APO-BW cube using Standard extractors and generic depending on your data.
• MIRO screen enhancement using BADI to capture Progress estimate number for making payments to subs and suppliers once payment received from client
• Implemented workflow process for shopping cart approvals based on product category, project or discipline at line item level.
• Implemented schema process level controlled workflow using BRF+ events, expressions, standard SRM workflow template and schema level configurations
• Using BRF plus workbench, trigger workflow from BRF plus, BRF application exits, BRF plus function modules in SRM, shopping cart workflows, schema configurations and writing BRF formula functions.
• Worked on EHS and EQP module in developing custom workflows.

Confidential

Sr SAP Technical lead

Responsibilities:

• Worked as onsite technical team lead for HCM Implementation.
• Coordinated with Client team regarding all sort of issue of ABAP Development.
• Made the upgrade adjustments to the standard and custom objects.
• Adjusted all ABAP custom programs to make them Unicode compatible
• Execute reviews and pre delivery checks
• Coordinated with functional tem and client team regarding all sort of ABAP Developments.
• Prepared the data migration template for data mapping between SAP and legacy system
• Prepared technical specifications for SAP HR data migration and developed conversion programs to fill data into info types using quality driven methodologies.
• Maintained a consistent ahead-of-schedule for all deliverables.
• Prepared documentation
• Responsible for maintaining QMS Standards for CMM Level 5
• Worked as BI/BO consultant and gathered business requirements and deliverables for report requirements along with functional end users in the business areas. And analyzed to identify business content data
• Designed and developed custom Data Sources, Info Sources, Extractors, Info Cubes and DSO'S to fulfill user requirements.
• As part of the performance tuning created aggregates for info cubes.
• Involved in review for various objects and created test case and test plans in different environments.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked with ABAP programmers in creating ABAP codes for Transformation routines.
• Performed Master data and Transaction data extractions (SAP) and automated the data loads using Process Chains.
• Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
• Universal Design: Universe planning building and implementation, design methodology, development cycle Creating Classes, Objects, schema, store procedures.
• Web Intelligence: Created Advance multiple Reports, Ad hoc query, tables, charts, Complex Filters customized formulas and highly formatted page layouts.
• Dashboard: Creating chart with visualizing data range, Series, interactive model, map with graphics, Query as a Web Service.
• Deployed BO Reports/Dashboards in SAP Enterprise Portal.
• Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis using Explorer, Xcelsius and Dashboard.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Used multiple data providers such as Universe and personal data files in generating report.
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.

Confidential

Sr SAP Technical Consultant

Responsibilities:

• Worked as technical consultant.
• Analysis of specifications provided by the client.
• Developing various reports according to users’ requirement.
• Uploading of Master data from old system to SAP by writing BDC programs.
• Created SMART FORMS according to client requirement.
• Prepared Unit test reports for the developed applications.
• Used performance tuning tools like Runtime analysis to increase the performance of the object.
• Worked on various enhancements, BADIs
• Develop Inbound/Outbound Interface reports. This included uploading data from legacy systems from flat files and downloading data onto Text/excels files.
• Creation of Custom BDC Programs for the various info types wherever required.
• Modifying standard SAP Script forms as per requirements
• Development of User-Exits
• Involved in the development of various Custom ALV Reports as well as modification of various Standard Reports.
• Documented the issues, How to doc's for all the activities performed and data load steps based on the dependencies' following the SDLC SAP Best Practices.

Confidential

SAP ABAP Consultant

Responsibilities:

• Worked as technical consultant.
• Analysis of specifications provided by the client.
• Made the upgrade adjustments to the standard and custom objects.
• Adjusted all ABAP custom programs to make them Unicode compatible
• Execute reviews and pre delivery checks
• Coordinated with functional tem and client team regarding all sort of ABAP Developments.
• Prepared the data migration template for data mapping between SAP and legacy system
• Prepared technical specifications for SAP HR data migration and developed conversion programs to fill data into info types using quality driven methodologies.
• Maintained a consistent ahead-of-schedule for all deliverables.
• Prepared documentation
• Responsible for maintaining QMS Standards for CMM Level 5