SUMMARY:

• Over 10+ years of SAP BW/BI, HANA, Technical (ABAP),Migration and Integration Consultant who has completed four (4) full cycle SAP implementations through various projects including preparation, blue - print, realization, testing, go-live, production support and upgrades.
• I am a dynamic and goal oriented person. I expertise in diverse areas of SAP, which is always a value addition to any team.
• I always desire to deliver simple design solutions following SAP’s run simple campaign with high standards of work ethics and professionalism using latest SAP best practices.
• My technical expertise and experience in data migrations, data integration will help any end-to- end SAP implementation.

CORE COMPETENCIES:

• SAP HANA
• SAP BW/BI, MM, SD & ABAP
• Customer Support
• Enterprise Architecture
• Project Management
• Systems Analysis & Design

PROFESSIONAL EXPERIENCE:

Confidential, Dalton, GA

HANA implementation & Integration consultant

Responsibilities:

• As part of the SAP team, worked in the design, development, testing and deployment aspects of the SAP HANA in order to deliver an agile Business Intelligence environment.
• Performed HANA Master Data modeling with Attribute view and delivered many Calculation Views, Analytical Views based on requirements of on-demand and real-time access to financial, operational and sales information at the detailed level in multiple reporting layers using Transactional data.
• Developed data models for the operations, PP, Global sustainable, Quality management tables in HANA.
• Knowledge on SAP delivery and integration of various modules in S4/HANA Configuration for faster setup and shorter development/deployment cycles.
• Knowledge in Consolidation of systems ERP, CRM, SRM, SCM etc for S4/HANA
• Proposed, designed and built a SAP HANA solution that replaced existing decentralized manual process for Account Payable report.
• Worked on open SQL based calculation views to distinguish Actual & Plan revenue in CO-PA Analysis and executed row level authorizations.
• Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange rates application.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Configured Trigger Based Replication using SAP LT(Landscape Transformation) NW 7.02. SAP BODS ETL tools
• Developed Webi reports and dashboards for different operations and finance KPI’s like Project planning, quality management, warehouse management, Material management, Global Sustainable metrics, Value management.
• Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings
• Developed the security model, Naming conventions, folder structure for HANA 1.0, BOBJ 4.0 and established the recommended SAP best practices guidelines for developing Universes, reports and dashboards from HANA data sources.
• Consumed SAP Hana views on IDT to deliver business layer using web intelligence and dash boards Xcelsius with proven experience in reporting complex scenarios.

Confidential

BI/BW Senior Consultant

Responsibilities:

• Actively involved in a global business improvement program called SANKALP, which will define, implement standardized group-wide business process architecture and associated Master data for the parameterization in SAP BW to improve performance and operational efficiency.
• Expertise in basic SAP BW components like Info Cubes, Multi providers, Info Source,Dso’s, Info Objects, Update Rules and Transfer Rules.
• Involved in setting up procedures for extracting data from SAP R/3 using Generic Extraction and used LO, CO-PA, PCA, FI-GL, FI-AP, FI-AR extractors for extracting logistics and FI related data into BW.
• Assisted in configuring BO Data Integrator as a Source system and also used it to send transformed data from Oracle to BW. Created generic extractor to combine R/3 data into BW. Enhanced the extractor for Inventory Management and Purchasing under SANKALP project.
• Experience in developing SQL, PL/SQL procedures and other components of Database applications Skilled in using TOAD and SQL Tools for performance maintenance of Database applications.
• Generated Transactional Data Info sources and Master Data Info source (Texts, attributes and Hierarchies) and created process chains to automate the transaction/master data loading from SAP and Non-SAP sources.
• Reconciled Inventory and purchasing data from BW to R/3 for existing Production report and created Info objects, Info Cubes, Multi providers & defined several transformations as per the need.
• Created and scheduled Process chain for daily Delta loads, resolving issues related to data and technical front in SAP BW .
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Managed Client BW environment to co-ordinate development, testing and transports to Production.
• Re-initialization of business area in case of inconsistency in data targets and resolved many issues/errors while upgrading(production systems) by replicating and activating data sources in updated BW system

Confidential, Calgary, CA

BI/BW Consultant

Responsibilities:

• As a BW Consultant, involved in all the day-to-day support, monitoring and new development activities in BW for MM, SD, FI and CO modules.
• Assisted in project planning BW application and acted as a facilitator for functional and technical work streams and created DSO, transformations, data transfer process, Info Sets and Multi Providers.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains. Worked very well on high, medium and low priority ticket and met SLA.
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions)
• Updating the customer on the status of the tickets posted by them and maintaining the history of those tickets.
• Good experience in PL/SQL and SQL in Oracle 10G/9i environments
• Worked on performance issues like creation of Indexes, Compression, Aggregates and Roll up and handled the errors during data load to data targets.
• Extended Transaction data & Master data by appending new data elements using enhancement component, Scheduling of Process Chains for periodic data loads to various Info Providers.
• Well versed in using Data Services Designer to ETL from multiple sources including Flat Files, Excel workbooks, XML; SAP ECC and third-party tools through DataStore setup and custom transfer program
• Created and released several BW transports and BEx Transports to move objects from Dev to Prod and involved in Production support for delta and full upload of Transactional and Master Data.
• Created BW aggregates for faster query execution and developed Process-Chain batch scheduling for automatic multiple data Source delta loads.
• Used Reusable Structures, Exceptions, Variables, Filters, Restricted & Calculated Key Figures in Queries in BEx.
• Involved in documentation and training end-user

Confidential

SAP MM Functional Consultant

Responsibilities:

• Configured the Materials Management module such as defining and assigning various components of the company and material master data, info records, source lists, purchasing and inventory management.
• Set up plant parameters for inventory management, tolerance limits on goods issues and receipts.
• Customized plant parameters for MRP and consumption based planning and defined MRP groups and controllers.
• Customized the conversion of purchase request to purchase orders
• Configured Inter and Intra company stock transfer
• Configured goods receipt and issue for all stock categories and special stocks viz. consignment, third party and sub-contracting.
• Master data such as functional location, equipment, work centre, maintenance task list and maintenance strategy, maintenance planning and scheduling
• Development of production order layout.
• Assisted technical team to develop interface for inventory movements with SAP and other legacy systems.
• Setup creation of outline agreements - scheduling (delivery/forecast delivery) and contracts (Value/quantity based)
• Post Go-Live support for inventory transactions coming from legacy system through Confidential for Purchase Order, creating Inbound / Outbound delivery, shipments, trouble shoot and fixed failed Confidential
• Carried out unit testing and integration testing with all possible business scenarios. Communicated status, issues and impacts to business team leadership, relevant client sponsors and process owners
• Post Go-Live support, prepared training documents and trained end users.