PROFESSIONAL SUMMARY:

• HANA 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 Yrs 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 and PMP Certified.
• 18+ years of experience in Information Technology in analysis, design, development, testing and implementation of Web-based, Client/server applications and 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 Netweaver 7.0 / 7.3, SAP ECC 6.0 & R/3 (4.7), SAP BO 4.x.
• Including 8+ years experience in Infrastructure Support and in Agile Scrum development.
• With good Exposure and Experience as Techno-Functional in R/3,BIBW, enables to address some of the challenging issues with BW/HANA effectively.
• Involved in full life cycle implementations for different modules in SAP BI/BW which Involves Development, 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 replication and Direct Extractor Connections.
• Worked extensively in business processes across various SAP functional modules like SD, MM, FI/CO and exposure to other SAP Functional Modules.
• Hands on experience in HANA modeling and schemas, SP, table def. and in Applying Analytic Privileges.
• Extracted the Data from ECC 6.0 and loaded into SAP HANA thru BODS 4.0(using Data Store /WorkFlow / Transformations) as an ETL tool for Data Quality and 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.
• Expertise in BW7.0/7.3 components like Extractors, Basic Transactional and Virtual InfoCubes, DSO(ODS), Multiproviders, Transformations, DTP, Remodeling of the 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 the 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 the front end business warehouse components like BEX analyzer, Query designer, Universe, Web Application Designer, Web Reports, WEBI, Dash Boards and Crystal Reports.
• BOBJ: Good experience in creating reports with Crystal Reports, Web Intelligence and Dashboards based on universe created using UDT & IDT.
• Proactive team player with excellent interactive and interpersonal skills with good communication at all levels.
• Efficiently managed teams of various sizes and worked with the team to achieve Client's goal.
• Experience with SAP HANA Live and SAP BO Designer Studio for reporting on SAP Business suite

TECHNICAL SKILLS:

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

ERP: SAP ECC 6.0/4.0

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

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 Scripts, ABAP, PL/SQL,T-SQL, C#,.Net, VB Scripts, Power shell

ETL Tools: SQL DTS, SSIS, Informatica

PROFESSIONAL EXPERIENCE:

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

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content in HANA usingdata provisioning.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Established the best modeling and recommended strategies for BW & HANA architecture.
• 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 the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed data models for operations Material Management, Quality management, Sales order tables in HANA.
• Wrote Stored procedures on Calculation View using SQL/CE functions
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• 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 the processes and Created Reports related to Sales-Delivery, Purchase orders, Inventory Management and Finance for various Analytical Process to aid the business flow and process.

Confidential, Morton,IL

SAP BI Consultant

Environment: BW 7.0, 3.5, ECC 6.0, FI, MM, SD, ABAP.

Responsibilities:

• Extensively worked on BW Modelling, Scheduling and Maintenance process. Extracted ECC data from Sales Distribution (SD), Material Management (MM) and Finance (FI) for developing reports like DSO (Day Sales Outstanding Reports, Late Pay Metrics Reports) and procurement data from R/3 using data sources from MM,SD and FI - CO and Create Custom Data Sources using table/Views from ECC.
• Designed and created Multi Providers, Transformations, Update Rules and Transfer Rules and wrote ABAP routines in start routines, end routines to populate fields. Created reports related to FI, MM and SD like Global Top 10 past due, Global Top overdue, DSO Chart Analysis and
• Developed Dash Boards and reports using Query Designer and BEX analyzer to facilitate data analysis in a drill down and summarized way to give detailed level of information. Used BW Statistics, Query Monitor and created Indexes, Aggregates to Enhance Query Performance. Prepare a prototype based on the requirements and demonstrate to the Business Users.

Confidential, Moline,IL

SAP BI Consultant

Environment: SAP BW 7.0, SAP ECC 4.0, SD, MM, BEX Query Designer

Responsibilities:

• Used Data Sources, Generic Data Src, Flat File and Extracters to retrieve SAP ECC and Non - SAP data for reporting in SD, MM modules and company's legacy systems.
• Extensively worked on enhancements for populating the records to the newly added components in the Data sources. Prepared the Strategy, Scope and Analyzed the Business process to be modeled. Created the Technical specifications for BI Content.
• Modeling for SD and MM and created the end to end connectivity using Custom data sources, info sources and transformations. Activating and filling the Aggregates for better Performance. Transported BI Objects From Development System to Quality System and to Production.
• Developed Reports using BEX Analyzer / Browser to meet the business requirement.

Confidential, Bloomington,IL

Infrastructure Support Analyst / Co-ordinator/ Lead Developer

Responsibilities:

• Provide support to SMS 2003 Windows Software Distribution Infrastructure Hierarchy - Test center and Production environment. SMS
• Advanced Client Support on workstations and servers. TroubleshootDistributions, H/W, S/W Inventory issues Provided Problem Management support.
• Developed / Designed SF SMS HW/SW Client Health. Proactive SCCM client fix for proper HW/SW inventory. Develop a process for package management and MYPOD Tool and various Tools - PSUT, Admin tools, ART,SIU,ADS.

Environment: SMS 2003, SMS 2.0, VB, .Net, C#, SQL Server, DTS, Informatica, SSIS, SSRS, SQL Scripts