SUMMARY

• HANA / PMP Certified SAP BIBW/HANA Consultant having 18+years of IT Experience implementing business intelligence/analytics and enterprise applications, including 6+ years in SAP, with 2+ year in HANA.
• Professional Experience in data - to-decisions solutions and order-to-cash SAP business transformations, Project Management, SDLC, Strong Interpersonal skills, Innovative Team Player, Fast learner and Result Based Worker with strong focus on Customer Satisfaction.
• 18+ years of experience in Information Technology in analysis,design, development, testing andimplementation ofWeb-based,Client/server applicationsand SAP Systems and Infrastructure Support.
• Over 6 years of extensive working experience in SAP BIBW area as SAP BIBW Data Analyst/Architect in SAP BI Net weaver 7.0/7.3, SAP ECC 6.0 & R/3 (4.7), SAP BO 4.0.
• Including 8+ years’ experience in InfrastructureSupport and in Agile Scrum development.
• With good Exposure and Experience asTechno-Functionalin R/3,BIBW, enables to address some of teh challenging issues with BW/HANA effectively.
• Involved in full life cycle implementations for different modules in SAP BI/BW which InvolvesDevelopment, Testing, Documentation, Requirement Analysis, End User Documentation, Data Extraction, Data Modeling, Data Loading, Reporting and Production Support.
• Involved in building Reports using SAP BO 4.0 and Integrating BO with BI and HANA.
• Good experience in SAP HANA Data Modeling using Attribute View, Analytic View, Calculation View and Decision Tables.
• Good Knowledge in LT replication, ETL replicationandDirect Extractor Connections.
• Worked extensively in business processes across various SAP functional modules like SD, MM, FI/COand exposure to other SAP Functional Modules.
• Hands on experience in HANA modeling. Created multiple schemas,SP and table definitions and in Applying Analytic Privileges.
• Extracted teh Data from ECC 6.0 and loaded into SAP HANAthruBODS4.0(using Data Store /WorkFlow / Transformations)as an ETL tool for Data Qualityand with SLT Replication,Loading Data into table definitions, Suspending Data Loads, Resuming Data Loads.
• Creating Information Objects/Views (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Good Knowledge and Experience in User Management, security and Performance in HANA.
• Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Expertise in BW7.0/7.3 components like Extractors, Basic Transactional and Virtual InfoCubes, DSO(ODS),Multiproviders, Transformations, DTP, Remodeling of teh Info Cubes, DSO, Data Sources,Data Source Enhancement, Multi-Providers, Info Sets, Transfer Rules, Update Rules, PSA, Open Hub Service, Data Mart, BW Transports, Process Chains, and BI content.
• Extensive experience in SAP BI 7.0/7.3 and Good business knowledge across different SAP modules and Knowledge in BW Accelerators, Star Schema, Extended Star Schema, Dimensional and Fact tables.
• Experience in teh OLTP Extraction of Data from SAP ECC, Generic Extractors, Enhancements and extraction from flat files, non-SAP systems and DB connect and Open Hub Services, to push data out of SAP BI.
• Expertise in teh front end business warehouse components like BEX analyzer, Query designer, Universe,Web Application Designer, Web Reports, WEBI, Dash Boards and Crystal Reports.
• Generated reports on teh MultiProviders, InfoProviders and InfoCubes using Restricted key Figures,Calculated Key Figures, Structures, Characteristic Variables, Text variables, Formula Variables, etc.
• Resolved performance issues by writing stored procedures and command objects in crystal reports and Performed unit testing, system integration testing, and user acceptance testing at various levels.
• Proactive team player with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.
• Efficiently managed teams of various sizes and worked with teh team to achieve Client's goal.

TECHNICAL SKILLS

Business Warehousing: SAP BW 7.0/ 7.3, SAP HANA Studio

ERP: SAP ECC 6.0/4.0

BW Reporting: BExAnalyzer,Query Designer,Report Designer, Crystal Reports Enterprise/2011, Business Objects Universe,Cognos Impromptu /Power Play, Microsoft’s SSRS, Web Intelligence

Functional: SD, MM, FI-AR-, FI-AP

Database: SAP HANA, MSSQL 2008, MS Access 2010, Oracle, DB2

Operating Systems: MS Windows Server 2003/2008/2008 R2,Windows XP, Windows 7, MVS on Z/OS 1.10

Programming Languages: SQL, ABAP,SQL,PL/SQL,T-SQL, C#,.Net, VB Scripts,Powershell

ETL Tools: SQL DTS, SSIS, Informatica

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAP HANA and BI Consultant

Environment: ECC 6.0, BODS 4.0, BO 4.x,HR, SAP HANA 1.x,Crystal Enterprise,Web Intelligence.

Responsibilities:

• Involved in providing BI solutions for various reporting analysis using BO and Hana Modelling for creating needed informational views for data/report analysis.

Confidential, Aurora, CO

SAP HANA, BODS and BI Consultant

Environment: SAP BW 7.0/7.3, SAP ECC 6.0, MM, SD,BEx Analyzer, Query Designer, BO Universe, SAP HANA 1.X, Business Objects Data Services 4.0, Crystal Reports Enterprise, Web Intelligence.

Responsibilities:

• Gatheird and analyzed teh requirement to replicate teh ECC content in HANA usingdata provisioning.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Established teh best modeling and recommended strategies for BW environment and architecture forSAP HANA.
• Integrated BW 7.3 and BODS 4.0 with SAP HANA1.0.
• Created Technical specifications and standard modeling documents for HANA.
• Performed datamodeling and developed Analytical views for teh transactional data, Attribute views for teh master data, and teh calculation views as final model in HANA Studio.
• Developed data models for operations Material Management, Quality management, Sales order tables in HANA.
• WroteStored procedures on Calculation View using SQL/CE functions.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed teh security model, Naming conventions, folder structure for HANA 1.0 and BW 7.3 and established teh recommended SAP best practices for developing IM DSO, IM Info Cubes in HANA data sources.
• Involved in different phases of Business Blueprint, analyzing business process, interacting with end users, key person and identifying reporting needs.
• Involved in BW Modelling, Scheduling and Maintenance process.
• Extracted Master and Transaction Data from Flat files and loaded into Info Objects, DSOs and InfoCubes to Multiprovider.
• Created intermediate write optimized DSO Structures in BW 7.3 to improve performance while loading data.
• Created Process Chains for automation of data load and data target administration and monitored teh processes and Created Reports related to Sales-Delivery, Purchase orders,Inventory Management and Finance for various Analytical Process to aid teh business flow and process.