PROFILE:

• Over 16+ years of full life cycle implementations experience in SAP BW, BO, HANA.
• Over 24 years of Information Technology experience in requirements gathering, analysis, design, development, testing, documenting and implementation of business applications
• Extensively involved in Public Sector, Manufacturing, Bio - tech, Health Insurance and Banking applications
• Strong analytical, communication, interpersonal skills and able to adapt quickly to new technologies.
• Highly successful in managing multiple projects simultaneously.

SAP EXPERIENCE:

• HANA modeling using Attribute View, Analytic View, Calculation View and SQL Scripting
• BI Modeling - InfoProviders design, Datasources, Transformations, DTP’s, InfoSources, Creating Update rules, Transfer rules, InfoSets, Aggregates and Process Chains.
• Extensively worked on the SAP upgrades from BI 7.0 to BI 7.3 and also from 3.5 to 7.0
• BI Extraction - Extensive experience in activating and customizing LO Cockpit extraction (SD, MM (IM, Purchasing), PP, QM),
• Timestamp extractors FI AP, FI AR, FI GL, COPA and also Custom Extraction. Also extracted data from non-SAP systems using DB Connect, UD Connect.
• Used ABAP/4 extensively in Start routine, end routine, transfer, update routines, transformations and also for enhancing the BI Extractors.
• BI Reporting - BEx Analyzer, BEx Query Designer, Web Application Designer (WAD), Web analyzer, RKFs, Confidential, Variables, created custom queries using Conditions,
• Exceptions, Workbooks, Query views, Customer exits and RRI’s.
• Worked on SAP BusinessObjects (SAP BOBJ), Data Federator, Confidential designer, IDT, UDT, Webi,
• Confidential Reports, dashboards using Xcelsius, Design Studio, Confidential, SDK Custom Components
• Experienced in distributing queries using Information Broadcasting
• BW operations - Data load management, event processing, experience in automating dataloads using Process Chains, monitoring the process chains, data loads Confidential .
• Experienced in Data Load Performance Tuning and Query Performance Tuning by using Partitioning, Indexing, DB Statistics, Number range Buffering, SQL TRACE and RSRT.
• Played major role in transforming business requirements into technical/architecture design and working with diversified teams
• Implemented ASAP Methodology.
• Extensive hands-on experience in project proposals and project preparation, blueprinting, Proof of Concept, designing, developing, testing, user training and supporting BI system.
• Executing design reviews, establish standards for the designs and naming conventions etc.

TECHNICAL SKILLS:

SAP: SAP HANA, BI 7.3, SAP BI 7.x, BW 3.5/3.X, ECC 6.0, R/3 4.6C

Reporting Tools: BO 4.1 tools - Confidential 2.1, Design Studio 1.6, IDT, UDT, Webi, Confidential Reports, BEx Query Designer, BEx Analyzer, Web Application Designer WAD

Languages: ABAP, C, SQL, VS COBOL II, JCL, EZTrieve Plus

Databases: HANA, Oracle, HDB, DB2, SQL Server 2014

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Sr. SAP BI/HANA Consultant

Responsibilities:

• Lead efforts with internal customers to analyze and translate business requirements and functional specifications into technical specifications, created data flow diagrams and organized the design review meetings with Confidential sustainment team.
• Created Attribute Views, Analytic Views, Calculation Views and SQL Scripting in HANA
• Created HANA Calculation Views to access data stored in Hadoop using SDA.
• Used SAP VORA to archive cold data to Hadoop(HDFS), created data models in VORA
• Worked on SAP BusinessObjects (SAP BOBJ) reporting using UDT, IDT, Webi, Confidential Reports and dashborads in Xcelsius, Design Studio 1.6 and Confidential Designer and Discovery
• Created Custom Components in JAVA SDK needed for the Design Studio dashboards
• Created BO relational universes using Data Federator to report SAP and Non-SAP data in Webi
• Developed OLAP connection to SAP BW and BusinessObjects to generate OLAP Confidential
• Created SAP BEx queries and configured them to BO Confidential .
• Implemented the data extraction process on BI 7. 4 and BI 7.x that includes enhancing Extractors, user exits using ABAP in ECC.
• Created Multoproviders, InfoCubes, DSOs, Transformations, Start routines, End routines, InfoPackages, DTPs and Process chains.
• Transforming data to consolidate, cleanse and integrate data in Rules, Routines and Customer Exits
• Developed complex query definitions involving variables with replacement path, exception aggregations, conditions and custom exits using ABAP, CKF’s, RKF’s using the query designer.
• Extensively worked in handling ECC isolation activities for LO cockpit - cleaning up Delta loads, executing setup jobs to fill the cluster tables, make sure the data loads to BI, compress InfoCubes if needed (Inventory cube) and resume Process Chains to normal schedule.
• Involved in incidents regarding extractions, Performance Issues and also load failures like monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Extensive experience in ETL process with SAP and non-SAP source systems.
• Extensively worked on Performance Optimization of ETL, Cubes and Queries
• Transport Organizer - maintained transport throughout BI landscape, coordinated Cutover activities and transport backfills.
• Installed Business Content in SAP BI and ECC Systems