SUMMARY:

• SAP BI/BW/HANA/BODS/BOBJ/FIORI/BPC and Certified SAP ABAP Professional with 9.5 years of experience in IT Industry. Possess a strong technical background with hands on experience in both development and Support in Data Warehousing and Business Warehousing. This combination makes him an excellent liaison between technical teams and business partners.
• He excels at gathering requirements and capturing them in documentation. He has a strong comprehension of business process and is familiar with proposing process improvements.
• He is well organized and very analytical.
• Dynamic and proactive professional with knowledge of SAP ERP package; dexterous in implementing SAP - ERP Program as Project team member.
• Hands on experience in ERP Functional requirement analysis and gathering, development, BRD preparation, data mapping, customization and issue resolution troubleshooting, data extraction, ETL Methodology, Performance issue optimization and all phases in SAP Methodology - testing and Go-Live activities includes the entire architecture.
• Extensive Knowledge on all Project Management tools such as PM Smart tool, Budget and Forecast tool, and also good knowledge on Team handling.
• Expert in Data-Modeling, Data Extraction, Data Loading, Scheduling, Monitoring, Reporting, Support Pack Upgrade and Performance Tuning.
• Managed sap functional core modules such as: configuration activities, Preparation of Gap Analysis and workarounds for SAP implementation and Success Factors process.
• Business Process Mappings, Business Process Design, Functional Specifications, Functional/Technical Testing.
• Worked with onsite, remote, and off shore resources utilizing agile methodologies in order to meet project objectives. Proficient in the use of SAP support portal, SCN, SDN, OSS and related tools for research and maintainability purpose.
• Functioned as a liaison between the technical and business partners by using communication skills and technical background to assist in bridging any gaps between both groups.
• Expertise in performing SQL Data Analysis on massive data feeds for retrieval and validation of data output, coordination of data migration and validation.
• Coordinated SAP system and business processtraining, including creation of detailed SAP transaction work instructions and process flow diagrams, for clients and end-users.
• Developed prototypes using Microsoft Visual Studio in order to assist in demonstrating functionality to the Customer Team.
• Modeled current business processes and proposed process improvements utilizing Visio workflow diagrams.

SKILL:

LANGUAGES/SOFTWARE/MODULE: SAP BI/BW, SAP HANA, SAP ABAP, SAP BODS, SAP BPC,SAP BOBJ, FIORI, SAP BO, OBIEE, Hadoop, Java Struts, EJB, Servlets, JSP, HTML, Crystal Report, Deski, Webi and Qlikview.

TOOLS: REMEDY, SHAREPOINT, TIDAL, UCF, CONTROL M and IBM Tivoli.

METHODIOLOGIES: AGILE, ASAP and Waterfall.

DATABASE: SQL Server, Oracle and Unix.

INDUSTRIES: Logis tics, Finance, Life Science, HealthCare and Telecom.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Responsibilities:

• Technical Lead & Solution Architect for multiple SAP Gateway-based mobile applications including FIORI.
• Cross platform Confidential SAP HCM Mobile Application - Time Sheet, Absence, Travel Management, Approvals.
• Google Glass application - Confidential Assist for real time technical support assistance - integrated with SAP SCM using Gateway.
• Visual Showroom - iOS and Android mobile application integrated with SAP SD using Gateway
• Led design, Basis, ABAP, FIORI and front end team of 15 members (8 onshore and 7 offshore) to design, wireframe, development, configuration, testing and implementation of Data Services on SAP Gateway system to create SAP based mobile applications for iOS and Android operating systems
• Followed SAP best practices to design, develop and configureSAP back-end ECC system for HCM (Hire to retire, Benefits, Organization Management, Time Management) and Travel and Expense modules to work with front-end Mobile application using SAP Data services
• Integrated Time Management and Travel management with Finance and HR for further processing.
• For Time Management defined Break Schedule, Rules for Variance, Daily Work Schedule, Period Work Schedule, Employee Subgroup Grouping, Grouping for Public holiday Calendar, set work schedule rules and work Schedules, Generated Quotas via time evaluation.
• Co-ordinated the work involved to create Add-on with all the backend configuration and ABAP transports and move the Add-on to a vanilla system for ICC certification. This certified application is now on SAP store
• Co-ordinated between system administrators and BASIS team to apply support packs and upgrade the ERP server to ECC 6.0 Enhancement pack 6 via Solution Manager.
• Managed project schedule, execution and resources to meet SAP solution delivery time linesincluding training the team on SAP HR processes e.g. Travel and Expense, Time sheet, Leave request etc., Employee Benefits, creating middleware processes using SAP Gateway
• Implemented standard Fiori applications using SAP prototyping kit for employee and Approval application for mangers to help them access SAP servers on any platform and from anywhere

Confidential, CA

Responsibilities:

• Preparation & documentation of report’s Functional and technical specification. Reviewed project budgets and resolved discrepancies, requirements gathering, oversaw project teams and client deliverables
• Creation of Management reports to SAP BW on HANA. Confidential wants to create Management flow in SAP BW 7.4 on HANA to improve performance of loading and reporting.
• Gathered business-reporting requirements, designed and developed solutions, tested/verified the solutions, migrated the solution to production, and provided ongoing support.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views. Involved in Implementing LSA Architecture in BW Landscape and LSA++ data model in HANA System.
• Strong experience in using BODS as an external system for ETL between ECC and BI.s
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using BEx Analyzer, Designed and developed several workbooks and global Views.
• Hands-on experience in Dimensional and Relational Data Modeling: Star Schemas, Extended Star Schemas, Normalization, De-normalization, Performance Indicators (KPI) and other OLAP considerations.
• Creation of Reports such that the execution time is evenly distributed throughout the Report using Restricted Key Figures, Calculated Key Figures, Variables, Exceptions, Conditions and RRI concept. Fluent inSQL Codingusing different software tools such asMYSQL Editor, TOADandMS SQL Server Management Studio 2008.
• Developed SAP HANA Data Modelling by using of HANA Studio. Developed data models for SD, MM, and PP in SAP HANA.
• Developed SD, MM, and Finance work flow using BRF. Also taken care of shopping cart and PO flows using BRF.
• Integrated SAP BPC Data Manager Packages with SAP BI process chains. Extract data from SAP and non - SAP systems into BPC/BI/BW with ETL tools.
• Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.
• Involved in SAP BPC implementation, configuration, and upgrade and environment management. Developed custom Process chains to support master data and transaction data loads from BI to BPC.
• Involved in SAP BPC 10.1 Planning/Budgeting/Forecasting implementation from Blueprint to implementation and going live.
• Functional Design of legacy systems to BPC interfaces and also worked on migration of SAP BPC 7.5 to 10.1 reports.
• Support BPC upgrade from 7.5 to 10, upgrade and also involved in review and testing.
• In R/3 side, Documented Inbound and Outbound Order process flow as per Business process requirements.
• Provided the technical guidance & knowledge transfer of effectively using BODS4.0
• Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.
• Worked on Data source 2LIS 03 BFto deliver data for material movements from MM Inventory Management (MM-IM).

Confidential, TX

Responsibilities:

• Involved in Pre & Post upgrade activity such as report comparison results in BW and HANA Systems.
• Involved in testing and reconciling the data coming from third party system to SAP.
• Checking inactive objects (Info cube, DSO, Info Objects, Info Sets, DTPs Transformations, Update rules) and cleared all the open Transport Requests.
• Extract the data from all source system to target after upgrade and reconciled the same. Worked on both Standard and Customized Generic extractor creation and enhancement.
• Involved in the plug in upgrade activities like clearing the LBWQ/SM13 and RSA7 queues on R/3 and support pack upgrade activities on BI.
• Extensively involved in monitoring the process chains and info package groups and resolving the post upgrade production issues.
• Worked with Basis team for BI system configuration. Raised OSS note with SAP and implemented the notes.Also as per the client requirement, I have implemented various OSS note along with its prerequisite correction instructions.

Confidential, CA

Responsibilities:

• Daily monitoring of the process chains. Resolving frequent failures on data loads. Escalation according to the business process (Communication Channel & Execution Channel).
• Worked on Reconciliation issues and resolve the data issues in BW system.
• Given better suggestions on existing process chains to avoid the maximum time consuming on data loads.
• Experience in Complex Allocation Logics, Elimination Logics and Currency Translation Logics.
• Co-ordination with Onsite Team for timely deliverables and closure of incidents and the clarification.
• Validated and Documented Inbound and Outbound Logistics Process. Also worked on the Material Management flow and its data sources.
• Involved in the integration of BODS with SAP and Non SAP data sources.
• Involved in high-level discussion with the customer to understand the requirement of the Change Request.
• Involved in SAP BPC implementation, configuration, and upgrade and environment management. Developed custom Process chains to support master data and transaction data loads from BI to BPC.
• Involved in SAP BPC 10.1 Planning/Budgeting/Forecasting implementation from Blueprint to implementation and going live.
• Functional Design of legacy systems to BPC interfaces and also worked on migration of SAP BPC 7.5 to 10.1 reports.
• Support BPC upgrade from 7.5 to 10, upgrade and also involved in review and testing.
• In R/3 side, Documented Inbound and Outbound Order process flow as per Business process requirements.
• Involved in SAP BPC 7.5 Planning/Budgeting/Forecasting implementation from Blueprint to implementation and going live.
• In ECC side, Documented Inbound and Outbound Order process flow as per Business process requirements as part of SD flow.
• Worked on the creation of OBIEE new reports and also enhanced the existing as per the client’s requirement.
• Managed and monitored data loads with Full, Init, Repair-Full and delta mechanism in Production System post transports of enhancements/changes.
• Reconciling the data of SAP BPC Consolidation and Planning Extracts with SAP BI and ECC applications.
• Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction. Worked on both Standard and Customized Generic extractor creation and enhancement.
• Developed SD, MM, and Finance work flow using BRF. Also taken care of shopping cart and PO flows using BRF.
• Using SLT, tables are loaded to SAP HANA catalog and on top of it the information models like attribute views, analytical views and calculation views are built.
• Worked extensively on BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
• Involved in HANA data modelling and composite provider creation and also got good understand of different joins and unions used in the HANA modeling e.g. Inner join, Outer joins, Referential joins etc.
• Carrying out Performance tuning by using Run Time Analysis and SQL Trace Tool
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions based views for report requirements.

Confidential, NJ

Responsibilities:

• Extensively involved in BOBJ Backend migration and Frontend migration from 3.5 to 7.0. Worked extensively on the Finance modules (CCA/WBS/GL/FI-AP, AR/PO, COPA and FICO) Extractions for BOBJ Migration Project.
• Involved as a single point of contact for all ABAP and OO ABAP related issues. Conversion of Field level, start routines into transformation start routines for increasing the performance of the Data Loading using ABAP OO - OOPs Concept.
• Expertise in Reports (Classical, Interactive and ALV), Module Pool Programming, and Data dictionary objects, BADI, BAPI, User exit, SAP Scripts and Smart forms.
• Frontend migration - Query harmonization, compression of query by using Meridian Tool. Taken up the responsibility for implementing Meridian tool and enhancement of the tool as per the project requirements for all ERP projects across cognizant.
• Created a tool to post the file to an application server in the customer required formats for ASR Contingency Project.
• Worked on BOBJ Migration and involved in creation of XCelsius report and Crystal reports. Also coordinated with the team on enhancing the SAP BEX Query.
• Designed BW Info cubes factoring periodic (Monthly/Biannual) restatement of data. Also implemented Metrics pertaining to Moving Average Total in the back end design. Presented the idea for Moving Average price and published them in SDN.
• Developed BEx Queries to cater to custom requirements such as displaying latest ‘X’ month/weeks of data, Growth % over past data etc.
• Worked on creating a Universe from the existing query using Universe Designer in BO Reports. Also expertise knowledge on the Logistics flow and data source.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Scheduled and published the business objects reports based on the user requirements. Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Carrying out Performance tuning by using Run Time Analysis and SQL Trace Tool
• Reviewed Transport requests and mediated/coordinated their movement across the System landscape and Formulated Cut-Over Plan for production go-live.
• Created and enhanced OLAP universes using BEx queries, and developing webi reports. Also supported/created Webi reports with the following functionality sub queries, alerters, charts, filters, and merged dimensions, etc.
• Extensively worked in designing Business Objects Universes, creating complex reports using Web Intelligence and Deski.
• Designed and Enhanced the Transaction Data Flow and Master Data Flow with additional fields and also implemented some flow in LSA Architecture.
• Extensively involved in the Performance Tuning of Queries using BIA, Aggregates, table partitioning, Indexing, statistics, Compression and query cache maintenance.
• Technical discussion with BI Architects on the solutions proposed. Fit gap analysis to harmonize the backend model and Queries and Process Chains.
• Daily tracking of the deliverables and communicate to project management and involved in KT and Sign-Off meetings.

Confidential, NY

Responsibilities:

• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW Reporting and applications.
• Involved in their major developments for their Prestigious Clients Touchstone and Walmart.
• Involved in Performance enhancement features such as Cube Indexing, maintaining Aggregates, Rollups and cube Compression.
• Carrying out Performance tuning by using Run Time Analysis and SQL Trace Tool
• Handled Various Post Production Support Issues related to Short Dumps, Data Loading, Monitoring, Database Space. Also involved in fixing all data load failure and process chain failures.
• Worked with the legacy systems users to understand the huge volume of legacy data and involved in moving the data from UNIX to SAP using the ABAP program.Also understood the logic and changed the routine logics in existing flow to OO ABAP.

Confidential, MA

Responsibilities:

• Accountable for managing the entire domain of SAP including implementation and documentation.
• Involved in modifying & building new functionalities in reports and modifying Scripts and Smart forms as per the Client’s requirement.
• Carrying out Performance tuning by using Run Time Analysis and SQL Trace Tool
• Expertise in Reports (Classical, Interactive and ALV), Module Pool Programming, and Data dictionary objects, BADI, BAPI, User exit, SAP Scripts and Smart forms.
• Performed complex testing, debugging, coding and analysis operations. Developed new system initial technical designs after business requirement review.
• Involved in the creation of Sales Order, Purchase Order as part of Sales and Distribution, Maintenance and Creation of Material in Material Management.
• Involved in full life cycle of the project starting from Requirement Gathering, Technical Design Preparation, Coding, Testing, Review and Go-Live Activities.
• Involved in Core Java, Struts and OOPs Coding for new requirement and ticket solving.
• Involved in object oriented design, design patterns using web technologies like JSP, servlet,EJB, struts, Hibernate.
• Prepared the requirement and functional specifications and Test cases.
• Involved in modifying existing functionalities in various screens.
• Involved in Maintenance & Production support of the project.
• Involved in Unit, Integration and Regression testing for various modules of project.
• Involved in Quality Work, Auditing and increased the PQI score for my project to around 85%.