SUMMARY

• SAP HANA/BW/BOBJ Architect and CSM with 12 years of extensive experience in IT industry playing various key roles in Architecture, Design, and development and managing Onsite - Offshore Teams.
• Over 11 years of extensive experience in SAP BI/BW includes Data Modeling, ETL, Report Development, ABAP, Upgrades and Support.
• Expert in architecting and deploying global EDW solutions by following SAP best practices including LSA and LSA++ architecture, utilizing the standard business content and customer platform standards.
• Involved in 4 complete life cycle implementations of BW, which includes requirement gathering, gap analysis, technical design, data modeling, and development, data extraction, report development and transporting the build through the landscape.
• Developed Business process documentation including Technical Design Document, Functional Design Document and performed Gap analysis.
• Experienced in Pre and post HANA migration activities in the Dev, Staging and Production systems - Post-migration optimizations including query and data load performance, info cube optimization, ABAP code optimization, BEx query settings, HANA DB parameters, column store table distribution, DB partitioning, etc.
• Experienced in Native HANA modelling in creating Attribute Views, Analytical views, Calculation views creation and Projection, Join and Union creation in HANA calculation views. Filters, restrictions, calculated measures, restricted measures in HANA views
• Developed InfoObjects, InfoSources, InfoPackages, DSO’s, DTP’s, Transformations, InfoCubes, SPO’s, Infosets, MultiProviders, Composite Providers and Advanced DSOs.
• Extensive experience in Performance Tuning using Aggregates, Rollup, MultiProviders, Indexing, Partitioning, Compression, debugging and monitoring capabilities using Query Trace, BW Statistics, Monitoring etc.
• Hands-on experience in ABAP debugging, tuning, along with BI extractors enhancements and user exits.
• Worked on implementing the BWA Accelerator and its performance improvement.
• Worked on multiple BW upgrades and support pack implementations; Expertise in regression testing and issue resolution during upgrades, SPAU/SPDD corrections and pre/post upgrade validations.
• BEx expertise in front-end Business Warehouse Components like Queries, Workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries, Info Set Queries and Web Application Development.
• Strong working experience in Business Objects (BOBJ 4.x) components.
• Strong experience in data provisioning using SLT, Smart Data Access and BODS.
• Full understanding of business environment, excellent communication skills, leadership qualities and ability to work proactively in a fast paced environment.

TECHNICAL SKILLS

• SAP HANA
• BI/BW (NW 2004s
• 7.4
• 7.3
• 7.0
• 3.5/3.1C/3.0B)
• BPC NW10
• BEx
• WAD
• BODS
• SAP R/3 (5.0
• 4.7
• 4.6C/4.6B/4.6/4.0B)
• FI/CO
• MM
• PP
• PM
• SD
• CRM
• SCM
• ABAP/4
• MDM
• C
• C++
• VB
• SQL
• PL/SQL
• JAVA
• JavaScript
• Visual Composer
• BOBJ
• Crystal Reports
• Xcelsius
• Solution Manager
• Tableau
• Visio
• Oracle 9i
• MS-SQL Server
• DB2
• DB6
• Quality Center
• Unix
• Windows NT 4.0
• 2000
• XP.

PROFESSIONAL EXPERIENCE

Confidential, GA

Sr SAP HANA BW Lumira Architect

Responsibilities:

• Responsible for the delivery of the Finance and Inventory management dashboard for all the regions.
• Worked with the users to understand the existing solution and gathered new requirements.
• Developed the models for Finance and Inventory including the forecast data from SAP and Flat files.
• Developed both script based and graphical based HANA views to source the data for the Lumira dashboard.
• Developed the interface for the end users to upload the Finance manual adjustments data into BW.
• Developed the dashboard with custom scripts for all the regions providing the ability to view and compare Finance actuals and Forecast data.
• Build the data tower using Lumira designer for SCM group to analyze the Delivery Accuracy, Purchase order Accuracy and Invoice Accuracy.

Environment: SAP BW 7.4, SAP HANA 1.0 SP11, SAP ECC 6.0, BOBJ 4.2, Lumira 2.0

Confidential, NC

SAP HANA Solution Architect

Responsibilities:

• Responsible for the delivery of the Finance Summary and Detail Trial balance reports for all the sites.
• Analyzed and developed complex HANA models for the sites that are on sap and non-sap systems.
• Merged and cleansed the sap and non-sap data and provided a unified solution in HANA.
• Developed both script based and graphical based HANA views to achieve complex financial reports.
• Optimized the HANA views to reduce data latency, memory consumption to improve the report performance.
• Developed Time dimension in HANA with all the necessary flags to achieve rolling trends in the Webi reports.
• Developed BOBJ Webi reports based on the HANA views.
• Promoted the HANA views to production via HALM.
• Prepared the documentation, supported the UAT for the sites already developed and working on development for remaining sites.

Environment: SAP HANA 1.0 SP11, SAP ECC 6.0, BOBJ 4.2.

Confidential, CO

Sr SAP HANA BW BOBJ Lead

Responsibilities:

• Prepared the functional specs and Report data definitions for the HANA migration project.
• Identified and replicated the relevant tables into HANA for reporting requirements.
• Developed the HANA views and reports for MILK weight component analysis, Drip to Silo Reports, Top 20 problem route and MILK Exception reports.
• Analyzed, created functional spec and designed the HANA views for Mis-rotated batch report based on Batch and Inventory movement data.
• Designed and developed the HANA models to support the Recall and Problem product reports.
• Developed the HANA views to combine the Sales and CRM data to deliver the Customer Impacts reporting solution.
• Generated time slices in HANA studio with SQL scripts for calculating time characteristics in HANA views for reporting.
• Developed the Web Intelligence reports consuming HANA views.
• Analyzed and Resolved the BWA performance issues for the existing applications.
• Redesigned the backend data flow for purchasing reports in existing BW environment.
• Enhanced the purchasing Extractor to bring in the Contract information.

Environment: SAP BW 7.4, HANA SP09, SAP ECC 6.0, BOBJ, Theobald.

Confidential, GA

Sr SAP BW HANA Tableau Lead

Responsibilities:

• Lead the BW optimization project to support the BPC go live and HANA migration project.
• Managed offshore team of developers and provided the support.
• Analyzed the BWA landscape and reduced the BWA memory consumption to optimum levels.
• Analyzed BW applications and gained 25% database size by removing the unused data in preparation for HANA migration.
• Established and documented the standard operating procedures to maintain healthy BW system.
• Analyzed and optimized the front end BEx and BOBJ Webi queries by implementing the parameters and applying ideal settings.
• Established BW housekeeping activities for the optimal performance of BW system.
• Analyzed and optimized the BW Data loads and improved the runtime performance.
• Developed a near real time BW Batch jobs health Dashboard in TABLEAU.
• Developed custom ABAP programs, interfaces, Direct Update DSO’s, MP’s, Bex queries for the Dashboard.

Environment: SAP NW 2004s BW 7.4, SAP ECC 6.0, BOBJ 4.1, BODS, TABLEAU, BWA 7.2 rev 22.

Confidential, PA

SAP HANA BW Architect

Responsibilities:

• Architected and implemented the Logistics, Legacy HR, QM and SAP Simple Finance Reporting solutions in SAP BW on HANA as part of PROJECT ONE implementation.
• Created Backend and Frontend reporting solution in BW on HANA for the existing Legacy applications.
• Identified required tables in the Legacy DB for reporting and enabled BODS replications to HANA system.
• Developed HANA views on Legacy DataMart data in HANA.
• Merged the Legacy data HANA Views and SAP BW models to provide a unified reporting solution.
• Developed HANA views to support complex reporting requirements of Finance.
• Created custom BW data flows utilizing BW 7.4 objects Advanced DSO’s and Composite Providers using HANA BW modelling tools.
• Created user training manuals and conducted training workshops.

Environment: SAP NW 2004s BW 7.4, SAP ECC 6.0, BOBJ 4.1, BODS, HANA SPS07, S/4 HANA

Confidential, OR

Sr SAP BW BOBJ Solution Architect

Responsibilities:

• Worked on the SAP BW upgrade from 7.01 to 7.4 SP08.
• Analyzed the BW landscape, business needs, product availability and prepared the project plan for the SAP BW upgrade from 7.01 to 7.4 SP08.
• Prepared the BW systems for the upgrade and performed the impact analysis for BOBJ and third-party systems.
• Analyzed the side effects notes and performed all pre-upgrade tasks.
• Performed SPAU and SPDD adjustments.
• Working on the change requests and aligned the work along with the on-going upgrade activities.
• Created custom transformations, DSO, Infocubes, SPO’s, Multiproviders, Open Hubs and APD’s.
• Enhanced the Delivery schedule line extractor to fulfill a short ship scenario.
• Developed Order Book Report to analyze the credits of the customer.
• Developed Open invoices and Invoices aging report.
• Used standard template and customized it to build the Dashboard using Design Studio for the Sales Analytics.
• Worked with Gauges, Bar charts, Stacked Bar charts, Cross tab reports to build Sales Overview Dashboard.
• Designed and built various Bex Queries for the Components and added as Datasources in Design Studio.
• Developed Projected Trade Forecast and Trade Spend Management reports in Bex and BOBJ Webi on CRM, APO and ECC data.
• Worked on the performance improvement of Backend and frontend objects.
• Worked on the cut over activities for the proposed upgrade go-live.

Environment: SAP NW 2004s BW (7.01, 7.4), SAP ECC 6.0, BOBJ 4.1, Design Studio, SAP AFS 6.0.

Confidential, CA

Sr SAP BW HANA BOBJ Consultant

Responsibilities:

• Analyzed, Designed and Developed the Drug Safety Supply Chain Act (DSCSA) Reporting and Archiving compliance project to trace drug from supplier source through to the distributor.
• Responsible for the design, development and maintenance of HANA data models (Attribute view, Analytical View and Calculation views), data provisioning through SLT, Import, export and migration.
• Identified and replicated the Customer Information and History data from ECC into HANA using SLT on a scheduled basis.
• Developed complex script based HANA views to derive transaction history levels and Lot numbers information.
• Developed BOBJ Webi intelligence reports for customer History and Customer Information for both internal users and external users consuming HANA views.
• Prepared the technical design documentation and user training manuals.
• Followed agile methodology and made sure the sprints are completed in time.

Environment: SAP NW 2004s BW (7.3, 7.4), SAP ECC 6.0, SAP BWA 7.20, BOBJ 4.1, HANA SPS07, SAP Data Services 4.1

Confidential, NC

Sr SAP BW BPC Developer

Responsibilities:

• Worked on the FSR (Finance Systems Roadmap) Project and supporting the production systems.
• Worked on the performance improvement of GL data loads and implemented the changes.
• Worked with the LOB on the requirements for the EZRec application. Designed and Developed the EZRec monthly and Daily balance files data flow applications for the downstream operations.
• Worked on developing optimized GL data flows for the FPP GL services.
• Designed and developed the custom objects and data flows for the Account Payable implementation in BI as part of release 4.
• Designed and developed the custom objects (Infocubes, DSO’s, SPO’s, Transformations, DTP’s, APD’s and OHD’s) and programs in BI for the profitability data extracted from Bank Analyzer system for various banking products.
• Implemented complex ABAP routines in Infopackages, Transformations and in front end custom variables.
• Analyzed and remodeled the EOD Marker designs for all ledgers for various sources.
• Worked on the performance improvement of Front End BEx queries.
• Created BEx template queries on Profit data for various products.
• Analyzed and developed the GL Recon queries in BI for ECC and Insight data.
• Working on the Bank Analyzer Profit loads streamlining and performance improvement.
• Worked with SAP on various OSS messages raised to fix the issues in the system.
• Analyzed and remodeled the Monthly and Daily Balance Infocubes for all ledgers.
• Analyzed the BWA landscape, index distribution, performance parameters, and failover strategies.
• Worked on Indexing the data into BWA and resolved the indexing issues.
• Worked on the BWA performance analysis and Index related issues.
• Supported the BPC 10 NW production system and resolving day to day issues to meet the SLA’s.
• Monitored the daily production jobs, fixing the issues of MRF/WRF processes for GL line items and for all ledgers/Sources.

Environment: SAP NW 2004s BI 7.3 SP5, SAP ECC 6.0, SAP BWA 7.20, Bank Analyzer, Windows XP.