SUMMARY:

• A highly accomplished SAP HANA Architect with 15 years of SAP BI experience and certified in SAP HANA, SAP BOBJ 4.0 and ITIL.
• Extensively worked in HANA data modeling, performance tuning, SAP SLT replication, SAP Data Services (BODS), Smart Data Access (SDA), and creating information objects in information modeler (i.e., package, procedure, analytic privilege, attribute view, analytic view, and calculation view).
• Expert on working with procedures, SQL script and creating HANA views via CE functions.
• Working knowledge of S/4hana embedded analytics.
• Extensive experience with SAP BOBJ reporting solutions, Dashboard, SAP Design Studio, Analysis of office, information design tool (IDT) modeling and WEBI reporting.
• In depth experience in architecting and developing semantic layer in IDT on HANA models and views.
• Extensively worked on HANA Live which includes implementing business content scenarios and extending vdm (Virtul data model).
• Experience working on HANA security model by creating profile, maintaining and assigning profile for the users.
• Experience working with SAP BPC integration with SAP BI.
• Worked extensively with SAP BW on HANA modeling, performance tuning, LSA++ architecture, and development that include standard/custom extractors, user exits (ABAP), Info provider, transformation, routines, variable exit, and reports.
• Worked in different SAP functional areas, (FI (New GL), CO (CO - PA), SD (Logistics), MM (Inventory), CRM, SRM, and HCM) to develop SAP BI architecture and modeling solution.
• Experience working with SAP BW on HANA modeling scenarios like SPO (Semantics Partitioning Objects), transient info providers and composite info providers.
• SAP BW to HANA migration experience that includes preparatory work and post implementation modeling.
• Worked on three full life cycles for SAP HANA (Native) implementation, one sustains project.
• I worked on multiple full life cycles for SAP BW on HANA, SAP BO 4.0 project, SAP BI 7.0, and 7.3 upgrade projects.
• Good communication, leadership, and team collaboration skill.
• Worked extensively on requirement gathering, user workshop,, release management and also have onsite offshore model leading experience.
• I am seeking role with a company that values innovation, proficiency and adaptability.

TECHNICAL CAPABILITIES

APPLICATIONS: SAP version 3.1, 4.0 B, 4.6 D, ECC 6, SAP BW 2.0, SAP BW 3.0 B, SAP BI 3.5, BI 7.0, BI 7.3, CRM 5.0, CRM 7.0, SAP BO 4.0,4.1, SAP HANA SP1,5,6

REPORTING TOOLS: Bex Reporting, Web Application Designer, WEBI, Dashboard, Analysis

ETL: SAP BI/BW, SAP HANA,SAP HANA LIVE, SAP BODS

MODELLING TOOLS: SAP BW, SAP HANA(Native), SAP BO 4.0, Power Designer

DATABASES: Oracle 8i, DB2, Tera data, SAP HANA

FRONT ENDS: Java, Sapgui, SAP BOBJ

OPERATING SYSTEMS: Windows NT, 95, 98

LANGUAGES: ABAP/4, SQL, SQL Script,JAVA

OTHERS: HTML, Web Essentials

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Architect

• Working as SAP HANA Architect /modeler for Confidential analytical reporting system.
• Extensively worked on Hana architecture /modeling/ETL/Reporting requirement for fleet related projects that includes using ETL (SAP BODS), SAP Dashboard, Business Object and Design Studio 1.6.
• Extensilvely worked on streamlining Confidential health card dashboard project and align them with Hana enterprise data warehousing layer.
• Extensively worked on complex Webi reporting and desing studio dashboard (Design Studion 1.6).
• Worked on desiging reporting, modeling and implementation strategy for poduct development team to avoid development of redundant Hana models in HANA and performance efficient reporting in BOBJ tools.
• Worked on creating strategy for reporting team to start building performance efficient dashboard in SAP Dashboard and design studion using Business Intelligence Web Services /APOS and avoid rework to reproduce WebI to support new dashboard tools.
• Worked on project plan and different deliverables to make sure project is delivered by time and within allocated cost.

Confidential

SAP HANA BW/BOBJ Architect

• Working as HANA / SAP BW / BOBJ Architect /modeler for BPM (Business partner managemtn) project using data from SAP and Non SAP system.
• Extensively worked on Hana Modeling for different project requirement creating analyticalview, star join based calculation view and joning data from SAP BW/ECC and Non SAP system.
• Extensively worked on complex Webi reporting and desing studio dashboard (Design Studion 1.6).
• SAP hana performance tunning by choosing right development model and restricting the data at base projection level.
• Worked on Single flip and Double flip based hana modeling to make sure data is available to users seemlesly without any interruption in report availability.
• Worked on creating stored procedure and materialized view to improve performance for hana models and overall reporting system.
• Worked on BODS to extract data from Confidential connectivity Oracle data warehousing system into hana.
• Worked on project plan and different deliverables to make sure project is delivered by time and within allocated cost.

Confidential

SAP HANA/BW/BOBJ Architect

• Working as HANA / SAP BW / BOBJ Architect /modeler for different releases and projects.
• Architecting, developing and delivering different complex and critical customer requirement s that includes dashboard, reports and interfaces.
• Working on complex data model for SAP hana Architecture utilizing calculation, analytical and attribute views. Creating information model (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Worked extensively on complex BODS data migration from SAP, Non SAP and data files.
• Extensively worked on modeling and architecting solution in SAP BI that includes dataflow development in SAP BW, working with modeling tools and ABAP for transformation. Data source creation and enhancements in SAP R/3 using standard and custom functionality.
• Working on monthly and weekly by developing work plans, estimates, and status to measure and manage projects within budgeted scope, schedule, and resources.
• Working on dashboard using SAP latest SAP UI based dashboard release for design studio.
• Working on different areas like report development (WEBI), Data source enhancement and creation (Custom and Standard), user exit (ABAP) and modeling (Administrative workbench).
• Working on complex Analysis of office (Analysis for OLAP and excel) as reporting tool via connecting backend data source as bex reports.
• Working on SAP BPC integration with SAP BI by creating transformation / package and loading the data in BPC.

Confidential / Confidential

SAP HANA /BOBJ Architect

• Working as HANA BOBJ Architect /modeler for different projects like finance data warehousing, sales data warehousing, government pricing, and dashboard.
• Experience working on HANA security model by creating profile, maintaining and assigning profile for the users
• Work extensively on hana studio (Attribute view, analytical view and calculation view) to delivery reporting requirement for user and sourced from SAP via SLT and Non Sap system via BODS.
• Worked extensively on data extraction tools to get data from different data sources like SAP using SLT and non-SAP data using SAP BODS.
• Experience working with procedures, SQL script and creating HANA views via CE functions.
• Working on dashboards using design studio/HANA/BODS (Business Object data services) to provide end to end solution for different dashboards like financial dashboards, system availability dashboard and sales dashboard.
• Working on complex BODS data migration from SAP, Non SAP and data files.
• Working on complex data model for SAP hana Architecture utilizing calculation, analytical and attribute views. Creating information model (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Working on complex procedure using SQL that includes data updation using complex business rules.
• Worked on SAP BW 7.3 (BW on HANA) and HANA mixed scenario exposing hana models to SAP BW7.3 and design studio for complex dashboards.
• Worked extensively on analysis of office as reporting tool for different analytical and complex reporting and backend data source as HANA query and bex reports.
• Worked on SAP HANA Cloud Integration for data services to efficiently and securely use ETL (extract, transform, and load) tasks to move data between on-premise systems and the cloud.
• Worked with SAP Lumira for publishing sap hana views and creating interactive reporting.
• Working on SAP BPC integration with SAP BI by creating transformation / package and loading the data in BPC.

Confidential, Carlsbad, CA

SAP BW BOBJ (Dashboard/ Design Studio) Architect

• Architecting and developing start to end solution for Confidential international release by using BI/BW modeling, BOBJ, Dashboard and design studio.
• Architecting, developing and delivering different critical dashboard for business like manufacturing dashboard, SRM vendor spend analysis for US and international regions.
• Formulating and implementing migration strategy for BOBJ from 3.x to 4.1.
• Migrated OLAP and relational universe and reports from 3.1 to 4.1.
• Creating user documents for SAP BO 4.0 and process of migrating existing user reports from 3.x to 4.0.
• Extensively worked on SAP design studio to accommodate dashboard on existing manufacturing and financial reports.
• Working on SAP BPC integration with SAP BI by creating transformation / package and loading the data in BPC.
• Creating document for SAP design studio for team members.
• Providing support during UAT, Go-live and Hyper care.

Confidential, Chicago, IL

SAP HANA (Native)/BW /BOBJ (Dashboard/Design Studio/WebI)/ Architect

• Architecting and developing solution for SAP BI as data warehousing layer and BOBJ 4.0 client tools (WEBI, Dashboard, and Analysis) as semantic layer.
• Working as SAP BI architect and developer for complex BW/HANA/BOBJ 4.0 environment for sap BI implementation projects and rollouts for ECC, SRM and CRM.
• Working on plan for rolling out SAP HANA for international geographical location based on framework from North America.
• SAP BW HANA modeling and optimization scenarios including Hybrid scenarios/ implementing LSA++ architecture.
• Architecting and developing SAP BI Dashboard (Xcelsius), Web I for various complex requirements. It includes discussing final reporting tool like Web I, Analysis or Xcelsius.
• Implemented best practices for SAP BOBJ and BW wherever applicable for modeling and reporting in order to improve performance.
• Provide user and technical staff and documentation for same.
• SAP BI 7.3 system upgrade (Dual Maintenance) for Confidential international system.
• Extensively worked on modeling and architecting solution in SAP BI that includes dataflow development in SAP BW, working with modeling tools and ABAP for transformation. Data source creation and enhancements in SAP R/3 and CRM using standard and custom functionality.
• LSA++ (SAP HANA) vs. LSA architecture assessment for SAP BI system based on existing model and system design.
• Experience working on HANA Live by implementing business content scenarios and RDS for HANA i.e. COPA and side Car implementation testing.
• HANA data modeling, including SAP SLT replication, importing table definitions, and creating information objects in information modeler.
• Experience working with procedures, SQL script and creating HANA views via CE functions

Confidential, FREMONT, CA

SAP BW/BO(Dashboard/WebI) 4.0 ARCHITECT

• Complete global integration project involving finding right technology mix for user reporting requirements
• Architected solution includes data from SAP, non- SAP system, and solution development in SAP BW as data warehousing layer and BOBJ 4.0 client tools (WEBI, Dashboard, and Analysis) as semantic layer
• Architect and implement solutions for quality initiative project to consolidate data in business warehouse from SAP and non-SAP, and choose reporting tool client in BOBJ based on client requirement
• Modeled solution in SAP BW with mix of IDT modeling for long text other non-SAP unstructured data
• Implement security in SAP BOBJ (Universe data level security) and SAP BW for BICS reporting
• Implement best practices for SAP BOBJ and BW wherever applicable for modeling and reporting
• Provide user and technical staff and documentation for same
• Work on different semantic layer in BOBJ, OLAP (BICS reporting), relational and multiple-source universes
• SAP BW data modeling, IDT universe, long text reporting solution, and security at backend and semantic layer (BOBJ and BW)

Confidential, IRVINE, CA

SAP BI/SAP BO 4.0 Architect/HANA

• SAP BI Architect for material handling unit customer and dealer reporting project, including SAP BW/SAP BO 4.0 system implementation.
• Streamlined and fixed SAP BW performance issue and implemented layered architecture (LSA) approach for modeling
• Implemented long text solution via BW and SQL data integration
• Applied dynamic security solution via BW DSO to avoid CMOD coding and avoid performance issue
• Worked extensively on information design tool modeling, creating multisource universe, data foundation, and business layer to achieve unique security requirement for Confidential
• Contributed significantly to WEBI report using custom LOV, navigation path (hierarchy in 3.1), and all latest features of SAP BO 4.0
• Assisted with XCelciusdashboard for SAP BO 4.0 for Confidential customer and dealer reporting requirements, created directly on bex queries and universe
• SAP BW-HANA implementation and architecture review from LSA++ prospective.
• Implemented reporting solution to jump from SAP BO 4.0 web I reports to SAP R/3 invoice
• Provided advanced SAP BI, HANA and SAP BO 4.0 to Confidential ’s SAP BI team
• Prerequisite and system design for Confidential acquiring SAP HANA vs. BWA as possible solution for resolving performance issue and reducing maintenance support.
• Implemented report publication/scheduling (Reports Cache) functionality to reduce initial performance impact for dealer and customer reporting and WEBI reports
• Contributed to various WEBI reports using calculation contexts, applying almost every available formatting feature, ranking, sorting, breaks, prompts, sub-queries, data tracking, Alerter, creating complex formulas/variables, projecting charts, cross tab reports, drill down reports
• Implemented security for SAP BOBJ users

Confidential, MINNEAPOLIS, MN

SAP HANA (Native)/BW/BO Architect

• SAP BW - CRM project deployment, leading blueprint and realization phase of program as architect.
• SAP BW architecture and data modeling for SAP CRM module, including building data model via BDOC-based CRM’s standard and generic extractors.
• Built BW architecture using standard SAP methodology LSA++, layered architecture.
• Conducted performance-tuning for long running extractors and implemented SAP best practices to reduce data latency.
• SAP HANA and SAP BO modeling based on data from SAP BW, CRM, and non-SAP systems.
• Defining and implementing SAP HANA data model and architecture for scalability and performance point of view.
• Architecting and developing semantic layer in IDT on HANA models and views.
• Worked on SAP HANA (SAP in-memory computing) to provide ad-hoc reporting solution, e.g., creating views in Information modeler, data migration from SAP BW to SAP HANA and reporting for long text (7,000+ char.)
• Experience working with procedures, SQL script and creating HANA views via CE functions.
• Collaborated with BO data service team to analyze and implement SAP best practices for data loads into HANA issue resolution
• Development as necessary with BODS / ETL / SQL Script Tool and ABAP.
• Administer, monitor, troubleshoot, analyze and resolve technical problems within HANA environments
• Create SAP ECC/CRM table data model and analysis, design data models and analytical apps, and implement SAP SLT replication schemas in SAP HANA.
• Experience working on HANA Live by implementing business content scenarios and RDS for HANA like COPA.
• Worked on HANA security models by creating profile, maintaining and assigning profile for the users.
• Worked as Side car for SAP BW CRM related data source and architect data mart migration by BODS.
• Assisted with hands-on development, coordinating deployment with offshore development team
• Collaborated with CRM functional team to implement best optimized, long-term reporting solution (SAP BI)

Confidential, BUFFALO GROVE, IL

SAP BW Sr. Consultant

• Worked as SAP BW consultant including requirement gathering, effort estimation, and providing design documents for solution for development.
• Performed modeling and development for SAP FICO COPA Line Item Reporting (e.g., COPA volume reporting) and SAP FI extractor (FI-GL, FI-AR, FI-AP).
• Contributed to SAP SD module business content based and generic extractors.
• Created and maintained project documentation, including detailed work plans and process flows for BI 7 upgrade.
• Managed workload, estimated effort for tasks, and worked with business users on meeting priorities/goals.
• Led offshore and onsite team members to reduce project risks, maintain budget, and track progress to defined schedule.
• Completed monthly and quarterly release as cutover manager.

Confidential

SAP BW ARCHITECT/MODELER

Confidential, BURBANK, CA

• Played crucial role in understanding specific customer requirements in order to architect solutions.
• Fulfilled new enhancement requests, emergency break fix, performance tuning of application, and normal day-to-day activities and troubleshoots.
• Completed development and break fix for COPA Line Item reporting.
• Developed business content and custom extractor-based requirement for SAP module (SD, FICO, and HCM).
• Deciphered business processes and functionality of existing SAP R/3 systems and implemented data model/reporting/web reporting for SAP business warehouse based on user enhancement request.
• Conducted user and knowledge transition with team for newly added architecture and solution.
• BI cubes for projects include cloning of standard SAP extractor to custom extractor without affecting existing extractor delta and functionality.
• Enhanced project extractor and report to include user and system status, and last/current activity period.
• HCM master data bex and web reporting for Org Unit, Personnel Area, Personnel Sub-Area, Employee Group and Employee Subgroup.
• Added fields (HCM Documents: Field Group Definition) to enable audit log for changes in fields
• Implemented project to make monitoring time and time quotas easier with web-based reporting that enables managers to see breakdown of hours charged by employees and remaining vacation of employees.

SAP BW ARCHITECT/MODELER

Confidential, CULVER CITY, CA

• Designed architecture for statutory and joint venture ledger reporting.
• Redesigned and built architecture for special ledger summary and detail, applying solution for special ledger summary, new architecture, cumulative balance, and ITD amount.
• COPA Line Item reporting.
• Configured classification data based on business requirement for SKU reporting.
• Designed and configured LO extraction cockpit of purchasing scenario for spends analysis reporting.
• Formulated disaster recovery plan based on best practices for BI architectural component.
• Involved in all phases of project preparation, blueprinting, configuration, and development, integration testing, cutover, and to go live.
• Developed monthly and quarterly release as cutover manager, developing work plans, estimates, and status to measure and manage projects within budgeted scope, schedule, and resources.
• Strategized cutover planning and implementation for different project roll-out for international territories.

Confidential

SAP BW CONSULTANT

Confidential, WILMINGTON, DE

• Created and maintained info objects, custom data sources, info sources, communication structures, transfer structures, transfer rules, update rules, info packages/groups, and scheduled data requests
• Appended data source structures to include new fields, wrote ABAP code in user-exit to fill extraction structure, and created custom info objects, characteristics, and key figures
• Performed data cleansing in PSA, error handling using PSA, multi-cubes, query development
• Loaded master data and transaction data, monitored data loading into info cube, conducted validation with respect to BI data, and created queries using BI Analyzer

Confidential

SAP ABAP CONSULTANT

Confidential

• Supplies Reporting File: Interface to provide data to supplies division for ad-hoc reporting
• SAP Order Tracking System (interface): web-based application that allows sales personnel to view current status of machine orders via Internet
• SAP Script Layout: Various script layouts, standard and customized
• Reporting-A/R Transaction Register: Listed all transactions registered in A/R system