SUMMARY:

• Over 12 years of extensive SAP Business Intelligence and Business Warehousing experience (with2 years of SAP HANA) spanning a wide range of functional areas including Sales and Distribution, Ship and Debit, Finance, Purchasing, Logistics, Asset Accounting, and Material and Vendor master data. Juggled multiple complex projects with ease, including 4 full life cycle SAP implementations. Expertise in SDLC, Waterfall and Agile SCRUM methodology.

TECHNICAL SKILLS:

SAP BI/BW Versions:: BW 7.5 SP4 (HANA), S/4, BI 7.0, BW 3.5, 3.1C, 3.0B. ERP: 4.6C.

Front Ends:: Analysis for Office, BEx Analyzer, BEx Browser, Web Application Designer Design Studio, Net weaver, Crystal Reports (BOBJ),Tableau, Alteryx, Lumira, SAP Business Objects Suite (Web Intelligence, Analysis, Eclipse based HANA Studio)

Languages:: ABAP/4, SQL, PL/SQL

Operating Systems:: UNIX, Windows 95/98/2000/NT/10, DB2

Scripting Languages:: JavaScript, Kornshell, FTP Microsoft Office, Sharepoint

PROFESSIONAL EXPERIENCE:

Senior BI/BW Developer

Confidential

• Key resource to support migration of existing legacy BW environments (BI 7.0, BI 3.5) to new in memory optimized HANA platform (SAP BW 7.5 SP4, R/3 4.6C) to support a user group of over 5000 users. Redesigned and improved existing dataflows to encompass HANA strengths (in - memory optimization).
• Developed data architecture designs, technical specs with a focus on Finance/ Accounting / Ship and Debit / Asset Accounting /Logistics data-flow.
• Took advantage of latest HANA architecture to redesign and rebuild existing back-end data models, address pain points from the legacy system (enhancements/ redesigns).
• Created Advanced DSO (ADSO), Composite Providers, Transformations / DTP's, Open ODS, Hybrid Providers and eliminated infocubes/ MP’s, Infosets.
• Rewrote archaic ABAP in the Start-Field-End Routines using ABAP optimizations for HANA and HANA SQL scripts.
• Hands on HANA Modeling schema experience including experience in building attribute views, complex calculation views and analytical views.
• Tuned the performance of dataloads using semantic grouping. Automated Process chains using Control+M platform.
• Efficiently managed teams of various sizes(offshore and onshore) and worked with the team to achieve company goals. Worked with offshore resources so that the development can continue using “follow the sun” model.
• Created over 20 Business Objects Universes, Crystal Reports, WEBi reports and Tableau and Lumira dashboards.

Senior BI/BW Developer

Confidential

• Developed Near Real Time reports tracking inventory/ Sales order/ Deliveries for different ISCS partners.
• Drove business requirement gathering and gap analysis via conducting workshops, assessment of operational processes and analyzing how these can be implemented/improved within SAP
• Provide self-service individual reports via a portal to the external customers using Analysis workbooks.
• Create customized reporting solutions using BW Query designer and BOBJ - WEBi and Crystal Reports.
• Developed Productivity reporting to optimize warehouse staffing / performance at the time of picking/putting/replenishing/returns/movements of stock,etc.
• Provided BI trainings to associates, end user trainings to Client after Implementation . Activation, enhancements & Installation of Business Content for SD, FICO, MM, PP.
• Designed and Customized InfoObjects, InfoSources, created transfer structures, transfer rules, update rules, DTP, and Transformations, Routines for DSO, InfoCubes.
• Developed the ABAP Code in Start routines, Update rules, and Custom Extractors as per the business logic.
• Worked on Reporting Authorization objects and maintaining the Authorizations for hierarchies, custom user exits.
• Provide post production support, hyper care, off hours support during go-live
• Perform routine program modifications, performance tuning, indexing, problem solving, debugging, and unit testing.

Senior BI/BW Developer

Confidential

• Involved in the end-to-end migration of legacy mainframe system for billing, booking and purchasing into a single integrated SAP ERP system.
• Met with different business areas to understand the existing legacy functionality and created functional specification documents enlisting requirements, must-haves and process improvement opportunities.
• Consumed data from external datasources like flatfiles and non-SAP datasources like BODS and combined it with SAP R/3 data to provide robust reporting.
• Developed APD’s and Open Hubs to provide data extracts to external systems like BODS, Tableau, etc.
• Improved BW ROI and customer’s experience with BW by implementing BW Accelerator which improved Reporting performance by 50%.
• Created Aging reports for AP/AR to provide outstanding balance. Extensive knowledge in FICO - Finance & Controlling (General Ledger, AR and AP).
• Enhanced standard COPA extractors for the relevant Operating Concerns from SAP-R/3 into SAP BW and created corresponding Infosources and Infocube in BW.
• Created Balance sheet reporting, MTD/QTD reporting, SG&A reporting, PCA reporting
• Good understanding of SDLC, SAP implementation methodology and Agile/SCRUM methodology.
• Developed Profit and Cost Analysis (PCA) reports using standard business content and then enhanced it using customer ABAP
• Data migration (Open PO, Open AR, Open AP, Stock snapshot) of legacy system data to new SAP tables.
• Enhanced business content for Master data as well as transaction data.
• Created generic (View, FM, Info set Query) as well as standard extractors like COPA, GL, LO Cockpit.
• Created process chains, kornshell scripts, infopackages, DTP’s to load data into BW.
• Involved in developing front-end queries using Query Designer and Web Application Designer and publishing results on the web.

Sr BI/BW Developer

Confidential

• Extensively worked on implementation and configuration of SAP FI/CO modules- GL, AP, AR, Customer Master, Vendor Master, Controlling Area, Cost element & groups, Internal Order, Cost Center Accounting (CO-CCA), Cost center Profit center Accounting(CO-PCA) and Profitability Analysis(CO-PA) and R/3 as source systems for BI/BW.
• Developed load plans for huge volumes using Company Codes, GL Accounts, and number range combinations of R/3 logistics data (over 160 million).
• Involved in upgrade project from BW 3.5 to BI 7.0 (NW 2004s).
• Designed and Customized InfoObjects, InfoSources, Created transfer structures, transfer rules, update rules, DTP, and Transformations, Routines for DSO, InfoCubes.
• Carried out Transports to staging and production environments
• Comprehensive experience working with both onshore and offshore environment.
• Monitored, communicated and troubleshot issues with data integrity, data design, and functional and technical software issues.
• Performed Data Load Tuning by analyzing and adjusting, BW Statistics, Indexes, Data Packet Sizing, Number Range Buffering, Aggregates etc. Performed Query performance Tuning by analyzing and applying, aggregates, line item dimensions, data compression, Query read Mode, Bit Map Index, Partition a parallel query option.
• Resolve technical problems utilizing SAP OSS notes.

Sr BI/BW Developer

Confidential

• Created data modeling objects for Ship and Debit data to load Agreement Header/Line/Condition data.
• Determined the “Promo Spent” using Invoice and Ship and Debit data using a custom function module based extractor.
• Determine the “Promo Budget” from the Ship and Debit data using custom ABAP code. Calculate Claims Aging, Recon Claims Aging, Vendor Claims aging to figure out the Short pays, overpays, write offs, credit notes, etc. using aging buckets/ customer exits.
• Load Vendor Outbound Claim data via flat files and send daily automated reports directly to the Vendor for rebate claims.