Satya Dev

SAP HANA Analytics Developer

Phone: 609-***-**** LinkedIn: https://linkedin.com/in/satdev

Professional Summary:

Experienced in design, development and maintenance of SAP HANA persistent models (Schemas/Tables/Views), Information Models (Attribute Views, Analytic Views, Calculation Views, SQL Script based Calculation Views & Decision Tables)

Experience with advanced HANA data-modelling using SQL Script, SQL CE Functions, SQL Script Scalar/Table Functions, SQL Script Procedures, Advanced Joins (Reference/Temporal/Text), Hierarchies & Text Search (Full text search, Freestyle search, Fuzzy Search)

Strong modelling & business analysis experience for insurance/re-insurance industry data

Experience with implementation and customization of SAP HANA Live views

Strong expertise with ETL tool SAP LT (Landscape Transformation) Replication Server (SLT) in loading data into HANA database from SAP & Non-SAP sources

Experience in setting up & configuration of SLT

Worked on SAP HANA Security including User Management, Roles, and Privileges

Experience with SAP HANA Data Administration including managing schemas/data model objects & import/export of HANA Catalog Objects/Content objects

Experience installing/troubleshooting/administration of various components of SAP HANA including SUSE Linux & SLT in VMWare/Bare-metal for POC/prototyping & test environments

Extensive experience with Business Objects Reporting Tools including WEBI Reports, Crystal Reports, Dash Boards, Analysis for Office, Lumira Visualizations/Stories & Report Conversion Tool

Experienced in Creating Business Layers, Data Foundation Layers, Multi-source Universes, Parameters, LOVs in SAP Business Objects Information/Universe Design Tool (IDT/UDT)

Strong Business Objects Administration experience including BO Tools Installation/Configuration, Setup and Maintenance of BO Enterprise environment, Creating & Managing groups/user profiles, migrating universes using Promotion Manager

Professional Certifications:

SAP Certified Application Associate – SAP HANA (Certificate ID: 001*******)

SAP Certified Application Associate - SAP Business Objects BI Platform 4.1 (ID#15763827)

SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.2 (ID# 001*******)

Education:

Masters in Technology Management (Specialization in Information Technology & Analytics Management), University of Bridgeport, Bridgeport, Connecticut, USA

Bachelor of Technology in Electrical & Electronics Engineering, Jawaharlal Nehru Technological University, India

Technical Skills:

Databases & ETL Tools: SAP HANA 1.0 SPS08-SPS12, SAP HANA 2.0 SPS00-SPS02, SLT, DXC

BI Tools: SAP Business Objects 4.1, XI 3.1, Crystal Reports 2013, BI Launch Pad, CMC, CCM, CMS, Web Intelligence, Business View Manager, SAP BI/BW 7.0, Live Office, Analysis Office (SBOP-AO) & Lumira

Languages: SQL, PL/SQL, SQL Script, CE Functions, SQL Script Scalar/Table Functions

Soft Skills:

Communicated with the project managers and team members about the latest developments in the project and trained people about troubleshooting the common errors that occur in the data model development

Involved in gathering the requirements with the business users and team members and translated these into technical specifications for designing universes.

Initiated and participated in the sprint meetings with the team members and identified areas for improvement and recommended corrective actions.

Professional Experience:

Catlin Re-Insurance (Atlanta, GA), HANA Analytics Developer – From June 2014

Reinsurance DataMart Project:

As part of Reinsurance DataMart project team member, modelled, built, validated HANA information models with SAP ECC modules FS-RI (SAP Re-Insurance), FS-CD (SAP Insurance) & Non-SAP data sources. Below are some of the specific functional datasets for which the data models and Business Objects (BO) Universes, WEBI/Crystal reports are developed.

Treaty & Facultative Financials

Receivables/Payables

Financial Reporting that includes Premium, Loss, Reserves & Expenses

Loss Reporting that supports ULRs (Ultimate Loss Ratios)

Reserve Analysis (Reserves data Captured from SAP FI/CO)

During the initial stages of the project, loaded data into SAP HANA mostly from flat-files both manually and automatically using SQL code

For Final Project phase, Configured SAP LT Replication Server to bring data from ECC (Reinsurance & Insurance Data) & SQL server (AM Best business partner rating data) into SAP HANA

Setup and configured Real-time & Batch SAP LT Replication Server (SLT) connections & Jobs for replicating SAP ECC data in SAP HANA

Analyzed, identified, tested SAP HANA Live Views for Insurance and Reinsurance industry solutions using SAP HANA Live Browser, Analysis for Office & Lumira

Configured SLT for replicating the necessary ECC tables using SLT configuration files generated from SAP HANA Live Browser

Extended/Customized SAP HANA Live Views using SAP HANA Live Extension Assistant & SAP HANA Studio for a) SAP HANA Live for Reinsurance Management b) SAP HANA Live for Insurance

As part of upgrading Reinsurance DataMart solution from HANA SPS08 to SPS12:

Migrated Attribute Views & Analytics Views to Calculation Views

Converted most of the SQL Script based Calculation Views to Graphical Calculation views with Table functions

Manual end-to-end validation of HANA DataMart models by comparing output of HANA calculation views with reports on the source (SAP BW, SAP ECC & Non-SAP sources)

Automated some of the manual testing by building complex HANA calculation views that combined and compared the aggregated source data (SAP BW, SAP ECC & Non-SAP Sources) & SAP HANA calculation views

Monitoring and Troubleshooting data loads in HANA environment

Created Security templates and implemented them for Creating Users, Roles, Privileges, Schema Grant options for various development and test activities

Being involved in different HANA versions, identified the rapid changes and additions of features in SAP HANA & maintained the best modeling practices document for the HANA team

Reinsurance DataMart Prototype:

Developed & Presented End-End Scenarios from loading data to reporting in SAP Business Objects Analysis for Office (AO) & SAP BO/Lumira for the reports below

Profit & Loss/Balance sheet Reports That can be drilled down to LOB (Line of Business)/Class of Business (COB) level

FS-CD/FS-RI/FI-CO consolidated report that includes Reinsurance Objects (Policy level information) that ties it with FS-CD objects (Open Accounts Analysis) and FI-CO objects (General ledger)

Fraud Detection Report that allows text search across all the available data in HANA

Responsible for creating 100x times data used for during the development cycle of Reinsurance DataMart

Benchmarked the initial load times and report performance times for models handling with more than 300mil records models and optimized the models/SQL scripts to get the best initial load times as well as best report performance

Catlin Re-Insurance (Atlanta, GA), Business Objects Developer Apr 2013-May 2014

Involved in SAP R/3 & BW report requirement analysis

Participated in database modeling for SAP BW DSOs (Data Store Objects), Info Cubes & Info Providers (master data objects)

Developed Business Objects WEBI Reports/Crystal reports with BEx Queries and BW Info Objects as data sources

Created ad-hoc and standard reports using Multiple Data Providers, Dimension Merges, Master/Detail, Cross tab, Multi-Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries and Combined Queries (Union, Intersection, Minus).

Created reports in Crystal Reports 2013 using formulas, Grouping, Parameters, cross-tab, sub reports, parameter values.

Created/Modified Business Objects Universes, Classes, Objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.

Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases

Cap Gemini (Atlanta, GA), Business Analyst Feb 2012-Mar 2013

Analyzed Reinsurance Treaty, Underwriting Front-end Facultative master data to be converted to SAP

As part of conversion testing, Wrote SQL & PL/SQL Queries from multiple Legacy systems

Provided statistical reports on the conversion activities from load to load

Design and executed manual test cases for correctness and completeness of data conversion

Assisted quality assurance team to design automated test cases based on PL/SQL Queries from Legacy and SQVI Queries from SAP

Worked with end-users on day-day reconciliation data issues between SAP R/3 and SAP BW

Performed SAP BW Report testing using BEx Analyzer & BEx Web Analyzer

Responsible for manual loading/trouble shooting of bordereaux transactions into SAP

Extensively involved in automating the manual bordereaux load process by providing mapping/trouble shooting scenarios/testing services

Designed end-end process for bank account reconciliation for troubleshooting missing transactions in SAP R/3 as part of the bank statement automation process

Extensively involved in developing SAP Queries using SQVI for business analysis and ad-hoc business reporting

Arch Insurance Group (New York, NY), Business Analyst Mar 2011-Jan 2012

Modelled data to load ODS (operational data store) client tables with the data from other legacy systems

Responsible for assumed facultative business process. Duties included inputting, and reconciling monthly and quarterly to the general ledger

Production of weekly, monthly, and quarterly reports to upper management for status and forecasting for the purpose of reinsurance exposure

Similar duties as above for ceded facultative premiums except paying to brokers

Assist in ceded treaty for reporting purposes. Duties included creating bordereaux reports, statements and rendering accounts to reinsurers on a monthly basis

Extensively used pivot tables in excel to perform data analysis and reporting

References: Available on request

Contact this candidate