PROFESSIONAL SUMMARY:

• Overall 10+ years’ experience in which 5+ years’ experience as SAP Consultant various modules working on POC's, leveraging businesses to take competitive advantage with real - time reporting. Which includes 3 full Life Cycle Implementations and production bug fixes in various domains like Retail, healthcare, and manufacturing.
• Extensively worked in the areas of Sales and Distribution (SD), Finance (FI) and controlling (CO), HR, PP, Materials Management (MM), and Inventory Management (IM) and have in-depth business process knowledge.
• Involved in Development, Documentation, Requirement analysis, End user documentation, and Data extraction, Data modeling, Data loading, Reporting and Production Support.
• Excellent professional experience in Software Development Life Cycle that includes requirement gathering, design, project implementation, system test and implementation, user support and training.
• Experience with HANA development.
• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting); Working Knowledge on SDI (Smart Data Integration)
• Worked on SAP HANA Data provisioning technology including SAP LT,SDI/SDA, Data Services-BODS, DXC; Received Data from Multiple modules-FICO, MM, SD.
• Experience in importing Meta data, Table definitions, performing initial load and Replication, Resuming and Suspending data loads using SAP HANA studio.
• Configured the connection in LT replication server between SAP source system (ECC) and HANA; Data provisioned CO-PA related data. Demonstrated to the end user's utilization of the HANA views in the front end tools such as SAP Business objects - Web Intelligence.
• Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions as needed.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as SAP Business Object Explorer and MS Excel.
• Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
• Responsible for peer review for regression changes before moving the change from a development system to another development system.
• Coordinated and resolved Data Quality issues for smooth migration to production
• Strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema.
• Motivated self-starter with excellent communication, presentation and interpersonal skills, willing to travel 100% and work in challenging and cross-platform environments.
• Team player with demonstrated collaborative working relationship.
• Transported objects from DEV to QA catalog and content objects using delivery unit mode.
• Involved in the production support, and interacted with the Reporting developers to change the code of the Tables based on their reporting requirements

TECHNICAL SKILLS:

ERP Packages: SAP ECC 6, SAP ECC 5, SAP ECC 4.7

Expertise: Programming, problem solving, Design patterns, Research and development, Mentoring/Training, Testing

SAP Technical: BI BW,BOBJ,BODS, HANA, ABAP, SAP BW/ 4 HANA: SAP HANA Design Studio, SQLScript, CE Functions, PL/SQL

SAP Modules: SD,MM,IM,PP,PS,HR,FICO(GL,AR,AP,AA,CCA,PCA,COPA)

Database: HANA 1.x, Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2000/7.0, MS Access,DB2,Teradata

ETL tools: Informatica, Tableau

Versions: SAP BW - 7.0,7.3,7.3(HANA Powered),7.4, BOBJ - 4.1/4.0, SAP ECC - 4.7,5.0,6.0, SAP HANA - 1.0/2.0, SAP Net weaver - 2004S

PROFESSIONAL EXPERIENCE DETAILS:

Confidential

SAP BWHANA Analyst

Responsibilities:

• SAP BW/4 HANA Modelling for ADSO and Open ODS, Extraction and loading of data from Sales Stats
• Designing SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) using transactional and Dimensional Data.
• Extensive understanding of FI-CA, CO, IS-U Billing, IS-U Customer Service and IS-U Device Management.
• Involved in requirement gathering for development, Data modelling and designing reports as per the requirement. Also Involved in Installing BI Technical Content.
• Installed Business Content for standard Info objects, Info-Sets, Info-Cubes, and Multi-Providers etc.
• Worked extensively on Open hub, Informatics tools to download data to the Third-Party Tools from BW
• Performed analysis, design, development and implementation of standard/customized Info-Cubes and ODS Object.
• Establishing connectivity between the SAP BW Info-Cubes/BEX Queries with Tableau 9 and designing Tableau queries for the end users.
• Redesigned HANA Attributes Vies, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• Worked on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning
• Used WEBI to connect with the SAP HANA Database, in designing new Reports for bringing summarized view of large volumes of data.
• Worked on Complex information models and implemented using SQL Script.

Environment: SAP HANA 1.0, SPS10, SPS12, BW 7.4, 7.5, SAP BOBJ 4.2 SP2/SP3/SP5, SAP XS engine, Informatica, Service now, DCS, XA - data providers, SharePoint, Tableau.

Confidential, Topeka, KS

SAP HANA Modeler

Responsibilities:

• Designing SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) for Sales and Inventory scenarios.
• Worked on Complex information models and implemented using SQL Script.
• Developed complex HANA Information models and achieved MPP (Massive Parallel Processing) by using different column views in SQL script Calculation views.
• Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and creating reports on HANA data.
• Created Attribute views, Analytic views, and calculation views as a part of SAP HANA Modelling using HANA Studio. Implemented the business models using SAP Tables
• Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
• Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading; Data provisioned data from multiple Modules like FICO, MM and SD.
• Involved in creating Generic Extractors using Table and view.
• Involved in designing the Graphical Star Schema View by following the necessary standards to deploy optimized Info Cube Data Model both at the Database level and Reporting Level.
• Promotion of HANA code to production using export/import of information models and delivery units. Involved in transports using Delivery Units; Transported Universe from one System to another system.
• Creation of local and secure connections and Universe in IDT; Created universe using IDT and report development in WebI.
• Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, WebI, Business Explorer(BEx) and various reporting tools like XCelsius, Analysis for Office, Lumira.

Environment: SAP HANA 1.0, SPS10, SPS12, BW 7.4, 7.5, SAP Data Services SAP BI 7.1/7.3, SAP BOBJ 4.2 SP2/SP3/SP5, ECC 6.0, BOBJ Explorer 4.1 SP3/SP5, Dashboards Design Studio, Oracle 10g, DB2, MS SQL Server 2008.

Confidential

SAP HANA Data Modeler

Responsibilities:

• Working as reporting lead, played a vital role in SAP BI/HANA/BO Global Implementation of a team of 10 members (offshore 6 and onshore 4).
• Coordinated with team, Business Users, Technical Developers and ECC Business Analysts.
• Involved through all phases of Requirements Gathering, Gap Analysis, Blue printing, Functional/Technical Specs, Development, Go-live, rollout and post implementation support of SAP BI in APO, COPA, FI, MM, SD Implemented according to SAP.
• Lead global cross-functional project teams, as big as 9 resources, of onshore and offshore model while interacting with client, corporate sponsors and business end-users to manage scope, schedule and cost of projects.
• Interacting with business heads and users to provide better solutions and explaining the capabilities of the BI and HANA.
• Worked on native SAP HANA application modelling and development using HANA studio; Data Modeler, Developer, HANA Administration Perspectives.
• Heavily used Attribute views, Analytical views, column store/row store tables, analytical privileges, data provisioning, HANA SQL Script, calculation views, calculated columns, filter expressions, data pruning, triangulation etc.
• Extensively involved in creating HANA Analytic views, Calculation views using Graphical and Scripted views, Stored Procedures and performance tuning of the calculation views and import/export of code to other environments, HANA Change Management., HANA Security roles.
• Hands-on experience on SQL scripting, building TC SQLs to validate the results and troubleshooting issues.
• Worked on SAP SLT and Smart Data access (SDA) for SAP Data Integration.
• Design and implement the Data Provisioning using HANA SLT, SAP SDA and file import using HANA Studio for data acquisition from sources system into SAP HANA and create HANA Schema and data tables and load/replicate data into target tables and apply the data security and configuration of HANA import server .
• Interacted with Functional Analysts and Business Users in gathering reporting requirements and involved in functional spec discussions and project plan.
• Involved in planning, design, development, and implementation and production deployment of reporting solutions for various business process.
• Actively involved with Basis tem in upgrading the BOBJ environments to BI 4.1 SP6 and BI 4.2 SP1, SP2 and SP3 environments and post upgrade validations.
• Extensively worked on Web Intelligence reports suite in Business Objects, creating universes and reports on top of HANA Calculation views, Oracle DB, Excel Sheets as source, Web Services.
• Worked extensively on the BI tools, Business Objects, Crystal Reports, Lumira, Design Studio, Power BI, Micro strategy, Advanced Analysis for Office (AAO), Bex Query/ Analyzer and HANA reporting.

Environment: SAP HANA V1.0, HANA Studio, HANA SQL, SAP BI 7.1/7.3, SAP BOBJ 4.0/4.1SP2/SP3/SP5, ECC 6.0, BOBJ Explorer 4.1 SP3/SP5, Dashboards Design Studio, Oracle 10g, DB2, MS SQL Server 2008.

Confidential

Jr SAP Consultant

Responsabilités:

• Designed, Developed and Debugged Various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting - Accessing Analytical and Calculation views from EXCEL.

Environment: SAP Business Objects 3.1 and 4.0 (Crystal Reports Enterprise, WEBI, Dashboards IDT, BODS, Visual Intelligence) and HANA, SAP ECC.

Confidential

Operational manager

Responsibilities:

• Coordination and supervision, review financial statements and data.
• Improve process and policies in support of organizational goals, Formulate and Implement departmental and regulatory policies.
• Assist in recruitment and placement of required staff, the establishment of organizational structure.
• Interact with customers to understand their business need and priorities, providing daily support to address client requests and inquiries, Maintain follow-ups, Involve in negotiation and quotation.
• Proactively inspects sales activity and efforts among sales associates, Ensuring The quality and quantity of sales effort.

Confidential

GIS Consultant

Responsibilities:

• The digitizer and technical decision makers of Confidential Data Provider based on the principles of Geographic Information Systems (GIS).
• Design a variety of databases using data modeling techniques. Provide specifications for software and hardware to facilitate the needs of the City regarding GIS.
• Coordinate directly with all city departments to develop and maintain specific GIS data and analysis.
• Comprehensive documentation and share knowledge to all members of the team that have different background and technical knowledge
• Manage photo / video / image assets for GIS (collaborating with marketing team, buying, searching, library, and sharing assets).
• Synthesize complex and/or diverse information by Collecting, researching data and present in coherent way.
• Actively manage and communicate regular project status to the appropriate parties; proactively manage project issues, risk and opportunities to minimize impact on delivery of projects and budget.
• Performing crises intervention activities and managing problems in a calm and tactful manner;
• Adept at interpreting complex regulations and translating them into “doable” tasks.
• Anticipate possible opportunities to accelerate the program through a different path or approach, or possible issues that can be proactively addressed before they have negative impact on the programs.