SUMMARY:

• Sr. SAP Solution Architect and SAP S/4HANA, HANA, BW, Business Objects (BI/BO), ABAP Consultant with over 13 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.
• Experience in SAP BPC, worked on building Models and Environments, defining Dimensions, security, BW integration for loading Actuals data in BPC, managing the transport process across the system landscape.
• 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.
• 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.

TECHNICAL SKILLS:

SAP Skills: SAP Business Objects ( BI/BO), SAP ABAP, Fiori / UI5 SAP Business Warehouse (BW) 3.5, 7.0, 7.3 and 7.4 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

Tools: HP Quality Center (HPQC), Remedy

MS Suites: MS Office, MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SAP BW-BO Team Lead

Responsibilities:

• Experience in HANA, Reporting Layer and Connectivity options
• 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.4, 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.4, 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, Houston, TX

SAP Technical Team Lead

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 KP IT 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, Cleveland, OH

SAP Technical tem 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 InfoCube’s to facilitate various reporting requirements.

Confidential

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

Confidential

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

SAP Technical Consultant

Responsibilities:

• Responsibilities include Production support like handling the data load issues on a day to day basis which includes monitoring, bug fixes and minor enhancements and developing of adhocBEx reports.
• Worked with Business Users very closely to gather the requirements, review the functional specs and help them resolve the production issues by attending various meetings.
• Used the tools like HPSM to resolve the production issues in timely manner.
• Launching the data loads as per client requirement on daily basis.
• Scheduling BW jobs, monitoring these Schedules on Process Chains Monitor and BW monitor.
• Responsible for Monthly Period End process loads for data coming from R/3.
• Data Extraction from R/3 and flat file, loading the extracted data into BW data targets.
• Designed and Developed Process chains for automating the Batch data load of Claims, Premiums, Sales and Expense data coming from Mainframes system.
• Involved in Performance Tuning and Data Maintenance by creating and maintaining Aggregates, Compression, Partitioning and Indexing of Info Cubes.
• Coordinated the BW transport collection using the BW Transport connection on BW side. Managed the transports between Dev, QAS and PRD systems. Validated the transported objects upon transport.
• Generated reports using BEx (Business Explorer) with variables, exceptions, restricted key figures, calculated key figures, conditions, formulas, RRI interfaces, filters, drilldown methods.
• Performed periodic cleanup in PSA. Extracted and loaded data from SAP R/3 into Sales Order InfoCube using Data Sources.
• Effectively handled Flat file and master data loading to the DSO's and Cubes.
• Handled effectively the change requests for the DSO's and Cubes and queries.
• Worked on creating transport requests and Releasing to the test and production servers.
• Resolved many issues that came in production support.
• Coordinated with Users on the BEX queries, maintained Jump targets, variables; assigned workbooks to roles, Configured Bex Browser.
• 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.

Confidential

SAP ABAP 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