PROFESSIONAL SUMMARY:

• 13 years of SAP experience
• 8 years of SAP Finance and Planning experience (FICO/BPC)
• 5 years of Confidential and 4 years of SAP BW experience
• 2 years of SAP Design Studio, Data Services/SDI and AMDP/CDS.
• 3 years of Nuclear Engineering and Core Design Experience
• 14 years of industry experience
• End to End Financial life experience cycle from Record to Report.
• Highly experienced in financial analytics in HANA and performance tuning of HANA models.
• Highly Experienced in BPC along with good understanding of associated financial planning analysis.
• Highly Experienced in using Data services (ETL) and Design studio (Front End)
• Highly Experienced in FI / CO Enterprise structure and Master Data and associated tables.
• Good Understanding of financial and Managerial Accounting theoretical concepts.
• Experienced in Conducting s in Confidential, BW on HANA, Data Services
• Experienced in S4HANA Finance.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Re - Defining the existing Enterprise Structure so as to suit the organizations needs more accurately.
• SAP FI (Enterprise Structure and GL Re-configuration) and activating SAP IMG structure for FI.
• Parallel Implementation of Classic GL (ECC) to New GL (ECC) and then to S4HANA Universal Journal.
• Re-Defining Business Partners.
• Assessment/cleansing and migration of FI master data using Rapid Data Migration with Data Services
• Migration / Validation / Testing from Existing FI tables to ACDOCA table.
• Migrating G/L settings and Defining Settings for Journal entry Ledger.
• Defining document types for posting in CO and ledger for Controlling Version.
• Defining offsetting Account determination.
• Redesign of Customer Master and Vendor Master as Business Partners.
• Configured New Asset Accounting.
• Created CDS views (Master data and Transactional) for S4HANA Embedded Operational Analytics.
• Converting 50 Embedded BPC slow running FOX Formula logic to Confidential SQLscript / AMDP
• Re Architecting some scenarios to take advantage of BW 7.5 features and data loading.
• Used CDS table functions implemented by AMDP.
• BPC 10.1 Embedded Planning included Revenue, Profit Center, Cost Center, Headcount/Salary, COGS, Capital (CAPEX), Depreciation Expense Planning, Sales, Vendor Cash Discount, Sell Margin, & Product Lines Model Planning.
• BPC 10.1 (Embedded) on BW 7.5 on HANA was used.
• Used the S4HANA generic adapter 0FI ACDOCA 10 for related transactional data.
• Simplified and lean Data model using minimal BW objects like ADSO and composite providers and field based modeling/info-objects.
• Simplified Data loading process with minimal staging (LSA++ Architecture).
• Designing the applications in BW-IP using Aggregation Levels, Filters, Planning Functions and Planning Sequence.
• Used Analysis for Office and created rich planning UI with Design Studio.
• Converting an existing IBM application based on Neteeza, DashDB, DataStage to HANA with SDI as the ETL tool.
• The application is being built simple and lean with speed the overall goal.
• A recoverable error handling framework is being built into the solution.
• SAP ADP was used for agile data changes for Customer, Supplier and Manufacturer Master Data.
• Instant view was generated off the Calculation view built on the ADP table joined with the FACT tables.
• Tableau was used for the front end.

Confidential

Responsibilities:

• Completed HANA Business Value Assessment, execution of pre-check technical assessments S/4HANA.
• Prepared the presentation for user community to educate about simple finance and impact on the current functionalities.
• Successfully configured and tested GL, AP, AR, Controlling/Planning as part of SAP Accounting powered by HANA Add-on, Cash Management S/4 HANA Add-on, and Fixed Assets modules in S/4HANA Finance and Confidential specific Fiori apps.
• In Cash Management, configured BAM (Bank Account Manager), setup BPs (Business Partners).
• Confidential is doing its first pilot with SDI for Confidential .
• The SDI would serve as a replacement for Batch Oriented Data Services and Real Time Replication of SLT with advanced transformation.
• The main goal of the project was to get performance improvement of the existing Exxon Models without layers of Materialization.
• Migration of existing BW to Enterprise on HANA.
• Studies on Master data and aligning to best practices of Data hub and Data governance
• Re architected 8 existing financial reports for performance improvement.
• The average improvement of the reports was 6X performance improvement
• Created a Performance optimization Guide that would serve all future Internal HANA developments.

Confidential

Responsibilities:

• Setup of FI Enterprise structure
• Creation of G/L Masters, Cash Journals, House banks and Maintaining Field Status Variant and Posting Keys
• Defining Fiscal year variant, Posting periods, Tolerance groups, Document types and number ranges
• Defining Interest Calculation Types, Defining interest rates, Assigning Accounts for Automatic Posting for Interest Calculations.
• Settings for foreign currency valuation (fluctuations in exchange rates)
• Creation of Customer/Vendor Accounts Groups, Number Ranges, and Customer/ Vendor Masters Creation
• Understand the existing legacy system and the parent SAP system and suggested solution design, configure and test for General Ledger Accounts (GL), AP, AR, Cost Center Accounting, Profitability Analysis, Profit center accounting and other related configurations.
• Interaction with user and client to understand there requirement and concern over existing system to identify system improvement points.
• Setting up Company code, Controlling area, Hierarchy and version with CO period
• Setting and creating masters like GL, Vendor, Customer, cost elements, cost centers, Profit Center.
• Data Migration using BODS.
• Implementation of Greenfield Embedded BPC
• Implemented solutions Revenue Operating Expense, Balance sheet, Flash, Head Count, Share Count and Capex solutions.
• Sensitivity and variance analysis was done on the models.
• Plan, forecast and actuals data was used by HANA models for dash board presentation by Design studio and Lumira and Excel.
• Standard BW-IP (PAK) enabled Planning Functions (HANA optimized) was used.
• Used SAP delivered content for Actuals and created Planning data cube for inputting the data. Designed MultiProvider on top of actual and planning cube.
• Design Aggregation Levels, Characteristic Relationships, Planning Filters, Planning Sequences, Data Slices, Input Enabled BeX Queries .
• Non-cumulative handling with delta calculation for calculating counts across time dimension/hierarchy in ADSO.
• Exception Aggregation was also explored.
• Simplified Modeling Using ADSO and Composite Providers.
• KPI reports were generated using mostly SQL based Calc views to generate calculated Dimensions to Overcome the lack of True Dimensions.
• Design Studio was used to overcome aggregation of measures/values while traversing up the TIME Hierarchy.
• Data Services was used to bring the data from Hyperion and other legacy application systems.
• High degree of automation was done including archiving/date stamping of files after pickup by BODS
• Phase I consisted of flight hours and fleet count KPI.
• Phase II consisted of financial KPI ( actuals/ plan / forecast ) from Hyperion and SAP data
• Phase II consisted of Pilot, Engineers utilization and combining with Phase I and Phase II models to get a coherent pic of company profitability, utilization etc.
• Profit center and GL account hierarchies was obtained from SAP. Intercompany Elimination accounts were obtained from Hyperion
• Front end was EXCEL.
• Design studio dashboards was created for displaying the KPI and also to circumvent the hierarchy rollup issue by firing query at different dimensional grain.

Confidential

Responsibilities:

• Migrated Models from legacy BW-IP/BPS to BPC Embedded on HANA.
• Used BW on HANA mixed modeling for design simplification and optimization
• Used SQLscript based Calculation views to develop complex allocations and extending to BPC via virtual providers.
• Rewrote existing ABAP based business logic to SQLscript for consumption in virtual providers.
• Created User Friendly Planning workbooks and reports based on AO.
• Created modularized Planning functions so that they can be reused in different planning sequences.
• Developed SAP Design studio to create frontends that exhibited both financial reports, graphs along with planning inputs.

Confidential

Responsibilities:

• Data Services was used to bring the data from ORACLE DB
• Much of the logic was ported into Data Services combining many ORACLE tables into sets of single HANA tables.
• HANA Window Functions was used to circumvent the earlier issue of doubling measures.
• The front end was delivered using BOBJ universe and WEBI.
• Existing reports on MS SQL is being converted to HANA models and Design studio replacing Xcelsius Dashboards.
• Created a Rich UI in Design Studio that could call multiple views including a RRI ( to external website ). A bug in the Design studio did not allow the final development to production.
• Ongoing work is reworking classical SAP BW to optimized mix modeling BW on HANA.
• BW Planning Functions logic embedded in ABAP is being modified to SQL scripts.
• Installed and Maintained SAP Data Services and Confidential including writing installation guides.
• Ongoing work is reworking classical SAP BW to optimized mix modeling BW on HANA.
• Installed Confidential SP8 and SAP BODS 4.2 (Production)

Confidential

Responsibilities:

• Configuring and Customizing Primary and Secondary Cost Element in Cost Element Accounting, Creation Cost Centers in Cost Center Accounting, Internal Orders, Profitability Analysis and Profit Center Accounting sub-modules.
• Created cost centers, activity types, statistical key figures, Cost Center Standard Hierarchy, cost center categories, maintained default account assignments and automatic account assignments, validations and substitutions, Distribution and Assessment, Direct and Indirect Activity Allocation.
• Internal Orders maintained order types, screen layouts, maintained order groups, status management, overhead costing sheets, maintained settlement rules, settlement profile, planning profile, budget profile, availability control etc.
• Profit Center Accounting maintained the master data, standard hierarchy Configured Profit Center Accounting planning included defining versions, planning layout, planning profile, plan allocations.
• Profitability Analysis (CO-PA) configuration.

Confidential

SAP FICO Developer

Responsibilities:

• Configured Financial Accounting Global Settings, (FI - GL), (FI-AR), (FI-AP).
• Configured the house banks (FI-BA), G/L accounts for Bank accounts and automatic payment program.
• Configured the Payment program with Selection of Banks, Payment methods, and Payment Forms.
• Worked extensively Lockbox Process.
• Coordinating the technical members of my team, so as to deliver the Objects on time with High Quality.
• Integration of MM and SD with FI account assignment.
• Worked on Integration aspects of FI-MM, FI-SD
• Preparation of Functional Specifications for generation of reports.
• Involved in Customization, Unit Testing, and Integration Testing in all FI processes
• Prepared End User documentation and trained End Users to understand the processes thoroughly.

Confidential (

SAP Big Data Architect

Responsibilities:

• Oil flow logs and sensor data is bought into HADOOP HDFS via Data Services.
• HIVE is used to parse the log data to extract key flow related parameters like flow rate, viscosity, co-efficient’ s and extract it into ORC format (Optimized Row Columnar).
• Sensor data is also formatted into a tabular structure within HDFS with key data like pressure, temperature, bore diameter etc.
• Ozzie is used to drive the entire workflow within HADOOP
• Data is pulled into HANA via nightly jobs by data services and modeled as views combining fact table from HADOOP with dimension tables from HANA.
• SDA is used to pull data from HADOOP (Federated approach) to model predictive analysis algorithms and visualizations in Lumira.
• Modifying HANA Live Content.

Confidential

Responsibilities:

• Designed and Architected solution for HANA Phase II and Phase III Implementations
• Developed HANA models and BODS flows for Phase II and Phase III.
• Created HANA and BW on HANA mixed models using Virtual providers.
• Moved SAP BW specific models to hybrid BW on HANA and pure HANA paradigm.
• Developed custom ABAP SLT for prepopulating data for performance optimization
• Found novel workarounds to multiple Problems/Issues.
• Created re-usable methodology for Recursive Hierarchy, custom SLT enhancements, HANA Performance Optimization techniques, HANA Stored Procedure calls by Data Services.
• Trigger stored procedures and data push via Data Services due to Lack of scheduling at the HANA DB level.
• Introduced lag in the incremental feed to counter latencies in data replication via real time SLT.
• Developed Write enabled Stored Procedures initiated by data services that would do the join on data chunked into smaller subsets and populating a table to counter crashing of HANA on joining Massive Tables.
• STL transformations were used to pre populate the tables with additional fields with the complex logic already built into the fields to counter performance degradation due to nested complex logic and IF statements in HANA models.
• Alter Scripts were used to create auto-generated columns to push calculations down to the HANA DB level and to convert and persisted Data-types needed for the joins. This was done to do join on different data types from disparate sources.
• Enable decimal shift feature in the HANA models and model time travel.
• Advanced Parent-child Hierarchy modeling, and using SPs to flatten and prepopulate the hierarchy data.
• Event based SLT transformation to counter parameter based SLT limitation of 3 input parameters.
• Eliminating Massive Joins by Doing Trick Unions with Constants to improve performance.
• Structuring the Enterprise as per Company Organization Structure.
• Creation of G/L Masters, Cash Journals, House banks and Maintaining Field Status Variant and Posting Keys
• Defined Fiscal year variant, Posting periods, Tolerance groups, Document types and number ranges
• Defining Interest Calculation Types, Defining interest rates, Assigning Accounts for Automatic Posting for Interest Calculations.
• Settings for foreign currency valuation (fluctuations in exchange rates)
• Creation of Customer/Vendor Accounts Groups, Number Ranges, and Customer/ Vendor Masters Creation
• Configuring Automatic Payment Program and Dunning for Vendors/Customers
• Configuring Input/Output Tax and Withholding Tax.
• Maintain the Versions for actual and planned postings
• Creation of Cost Centers and Definition of Cost Centre Hierarchy
• Creation of Activity types and Statistical key figures and Allocation, Distribution and assessment of costs
• Creation of Primary and Secondary Cost Elements with appropriate Cost Element Category
• Definition of Internal Orders Types, Order Masters and Settlement Profiles

Confidential

SAP PI Lead

Responsibilities:

• Acted as a Team Lead for the Middleware Migration Project that involved moving 76 interfaces in 6 months.
• Tracked team progress and held weekly peer review technical sessions.
• Implemented a documenting system that tied together Functional/ Tech specs, ESR and IB objects.
• Extensively used CIDX - IDOC/ RFC/ FILE/ JDBC/ SOAP data interchange - for uniform data exchange.
• Developed global UDFs for enhancing/ automating mappings.
• Extensively used SOAP sender/ Receiver adapters to channel interchanges via OSB for web service routing.
• Encapsulated CIDX as payload within a SOAP envelope, to pass parameters not available in CIDX.
• Developed Generic ESR objects that used value mapping and dynamic enhanced receiver determinations.
• Developed conditional multi receiver based Order Create, Order Response, and Order Change IDOC - CIDX scenarios.
• Created alerts for all 76 MM interfaces.
• Extensively used Seeburger PGP encryption module and SFTP for handling highly secure transactions.