Srinivas J. - Data Modeling, Data Warehouse & BI, Data Science, Data Engineer & BPMN and Process Mining, SAS, Software R, SQL, Celonis, ARIS

Go to Website

Alphen aan den Rijn, Netherlands

Experience

Jun 2024 - Apr 2025

11 months

Würzburg, Germany

Senior Application Engineer & Administrator for Statistical Application Software (SAS & SPSS)

Deutsche Rentenversicherung

Administration of the SAS and SPSS software packages as well as the Windows and Red Hat Linux system environments.
Resolving errors reported by CheckMK.
Performing software updates, applying patches, and monitoring the system and applications.
Managing storage and optimizing the performance of statistical applications.
Working in an environment with SAS 9.4 (Enterprise Guide, Management Console, Environment Manager), SPSS, Red Hat Linux, and Windows.

Sep 2023 - Apr 2024

8 months

Munich, Germany

Big Data and Process Mining Engineer (Process and Data Modeling), Data Management

Telefonica

Improving processes related to silent factoring and risk analytics.
Using Celonis for process optimization and SAP PowerDesigner for adapting and further developing data models.
Responsible for business process management and analysis as well as data modeling within process mining and BPMN.
Supporting scoring and model development in Azure DevOps and Databricks.
Using Celonis, ARIS V10, SAP PowerDesigner, TOAD, Azure Cloud & DevOps, Databricks, Git DevOps, SQL, PL/SQL, Python, yED, Oracle, and Windows.

Aug 2022 - Jul 2023

1 year

Frankfurt, Germany

SAS Developer for Regulatory Reporting Processing (IRBA) in Mainframe and Linux Environments

Finanz Informatik

Gathering requirements from specialist departments in regulatory reporting (banks and savings banks) and developing technical solutions.
Developing SAS solutions in a development environment and handing them over to mainframe production processing streams.
Handling tickets from daily processing runs and analyzing errors.
Using SAS 9.4, SAS Enterprise Guide, SAS Macro, SQL, Windows, mainframe, OSPLUS, IDz, TSO, ETAPS, ISPF, JCL, REXX, Endevor, and RACF.

Sep 2021 - Dec 2021

4 months

Amsterdam, Netherlands

Credit Risk Data Analyst & Business Analyst

ING Bank

Preparing data for credit risk reporting and credit risk migration.
Conducting RWA analyses and credit risk portfolio analyses based on IRB and AIRB.
Defining and analyzing risk parameters (PD, LGD, EAD, M) and their variations.
Performing functional analysis and evaluation of data quality measures for data used in dashboards and reports.
Using SAS Enterprise Guide, SAS Visual Analytics/Studio, SQL, Windows, Oracle DB, SAP Fieldglass, Confluence, Citrix, and Power BI.

Jul 2019 - Jul 2022

3 years 1 month

Wiesbaden, Germany

Team Lead (Application Operations Manager) for SAS and R Software Administration, Maintenance & Support

Statistisches Bundesamt Wiesbaden

Leading the technical team for maintenance and administration of SAS and R software applications for the specialist departments.
Supporting the specialist departments in using the statistical software.
Handling change requests through a ticketing and request tool and solving technical and functional issues.
Performing system and application updates and creating documentation.
Maintaining and further developing SAS stored processes.
Working with SAS 9.4, SQL, Windows, Oracle DB, VMware, ARIS, Linux, yED, R & RStudio, Windows virtual machines, MS Visio, SAP Fieldglass, and Citrix.

Feb 2018 - Jan 2019

1 year

Frankfurt, Germany

Data Analyst, Business Analyst & Data Management for IDD regulatory processes

Deutsche Bank

Business analysis and data management with focus on data modeling and adjusting ETL routines.
Implementation of the control processes required by the IDD guidelines using SAS.
Maintenance and updates of the test steps in ADONIS for regulatory processes.
Improvement of data quality and data inventory in the existing Data Warehouse.
Conceptual extension of existing data models and building ETL processes for data sourcing for CRM strategies.
Use of SAS 9.4, SQL, Windows, Unix, ADONIS and Sybase PowerDesigner.

Oct 2016 - Jul 2017

10 months

Mönchengladbach, Germany

SAS Tester for Risk DWH & Data for IFRS 9 Risk Modelling

Santander Bank

Support of the IFRS 9 project in testing and data preparation.
Managing and performing test activities, including creating and documenting test cases.
Reviewing input interfaces and closely coordinating with the business unit and development team.
Using the Scrum method for agile project execution.
Preparing data for account scoring, credit risk, and calculation of risk parameters (PD, LGD, EAD) as well as mortgages under IFRS 9.
Adapting the existing data model and extending and testing ETL processes for campaign management and CRM.
Use of a mind-mapping tool, SAS 9.4, SAS Enterprise, SAS Base, SAS Macro, Jira, HP ALM, Confluence, and Sybase PowerDesigner.

Jan 2016 - Aug 2016

8 months

Düsseldorf, Germany

Data Mining & Mathematical Consultant / Model Development

ERGO Versicherungen

Business analysis and data management with focus on data modeling and adjusting ETL routines.
Capturing functional requirements and developing solutions, partly implemented by myself, partly by developers.
Working on accident, property, legal protection, and liability insurance topics, as well as product resolution in the automotive sector.
Incorporating product extensions into data models and documenting the ETL routines to be extended.
Creating GDV statistics for property insurance.
Use of Mindjet MindManager, SAS, SAS Enterprise Guide, SAS Visual Studio, SQL, Windows, MS Access DB & Forms, Citrix applications, Sybase PowerDesigner, and SAS Viya.

Feb 2015 - Mar 2015

2 months

Duisburg, Germany

Data Mining & Mathematical Consultant / Model Development

Exactag (E-Commerce & E-Business Marketing)

Analyzing customer behavior for online, app, and tablet shopping in the context of the customer journey.
Developing statistical methods to better solve the record linkage problem and for dynamic attribution models.
Analyzing cross-channel and cross-device marketing and advertising measures to improve conversion evaluation.
Use of methods like cluster analysis, Bayesian statistics, machine learning, and probability theory.
Use of Mindjet MindManager, Hadoop, Python, SQL, Windows, RapidMiner, R Software & RStudio, MySQL, and KNIME.

Sep 2014 - Jan 2015

5 months

Düsseldorf, Germany

Report & BI Architect, Report Developer & SAP BO / DWH Consultant

Vodafone

Continuing existing reporting based on Excel and Think Cell.
Building and migrating existing reports into SAP BusinessObjects using Web Intelligence Rich Client.
Using a BO universe as a data source and connecting to a Teradata DWH.
Taking over, improving, and standardizing existing reports, as well as automating them using SAP BI, SAP BO, and Information Delivery Tool.
Supporting the setup of CRM reporting.
Use of Mindjet MindManager, Teradata DWH, MS Access DB, SQL, Windows, SAP BO Crystal Reports 4.1, Information Delivery Tool, Think Cell Reporting, SAP BusinessObjects 4.1 (Universe Design Tool, Web Intelligence Rich Client), and SAP BI.

Jan 2014 - Jul 2014

7 months

Frankfurt, Germany

SAS BI Architect and Outsourcing Coordinator for Mainframe DWH

Deutsche Bank / HCL

Restructuring an existing SAS Data Warehouse in a mainframe environment.
Ensuring compliance with new security policies, IT governance, and audit compliance in the banking environment.
Analyzing and adjusting batch processes, JCL jobs, as well as SAS Base and SAS Macro code.
Revising business rules and reviewing and extending data historization.
Preparing and supporting the pilot and transition to an offshore regular operation (outsourcing to Bangalore).
Design, conception, and implementation including data modeling and ETL routine development.
Using Mindjet MindManager, SAS Mainframe Installation, SAS Foundation 9.3, JCL, TSO, ISPF, SAS Base & Macro, SAS 9.2, MVS, Linux, Windows, z/OS, and Sybase PowerDesigner.

Jul 2013 - Dec 2013

6 months

Meerbusch, Germany

SAP BW Consultant (In-house Training) – Functional Use of SAP BW and ABAP Basics

Business Cybernetics

Learning and practical use of SAP BW data modeling, ETL, reporting, and analysis in an in-house project.
Using a live system with sample data to develop and test BW objects.
Programming in miniSAP to solve example tasks and perform error analyses.
Reviewing existing developments and troubleshooting.
Using Mindjet MindManager, Windows 7, SAP BW data modeling, SAP BW ETL, SAP BW reporting & analysis, and ABAP.

Jun 2013 - Jun 2013

1 month

Berlin, Germany

Teradata Consultant (Vacation Cover)

Groupon

Creating ad-hoc queries on a Teradata database without extensive onboarding.
Building standard reports in Excel based on Teradata SQL queries (including pivot tables).
Using Mindjet MindManager, Windows 7, SQL, Teradata, and Excel pivot tables.

Jan 2013 - Apr 2013

4 months

Meerbusch, Germany

SAP BW Consultant (In-house Training) – Functional Use of SAP BW and ABAP Basics

Business Cybernetics

In-house project to deepen SAP BW data modeling, ETL, reporting & analysis.
Using a live system with sample data for development and testing.
Using miniSAP for programming and testing problem scenarios.
Conducting error analyses and fixing errors in existing developments.
Using Mindjet MindManager, Windows 7, SAP BW data modeling, SAP BW ETL, SAP BW reporting & analysis, and ABAP.

Mar 2012 - Dec 2012

10 months

Braunschweig, Germany

SAS Consultant & Developer – Data Warehouse & Data Mining Application Support

VW Financial Services

Logging work orders and performing error analyses in the SAS environment.
Incident and release management for SAS users in data mining and SAS programming.
Organizing and optimizing a job chain with about 380 interdependent jobs using a scheduler and Platform Flow Manager.
Maintaining, troubleshooting, and enhancing jobs based on business requirements.
Providing data for analyses, especially in machine learning and data mining.
Focus on data modeling and ETL development.
Using yED, Mindjet MindManager, SAS 9.2/9.3, SAS Management Console, SAS DI Studio 3.4, SAS Enterprise Guide, AIX, Windows, Platform Flow Manager, SAP BW, HP Quality Center, and Sybase PowerDesigner.

Mar 2011 - Sep 2011

7 months

Neu-Isenburg, Germany

Subproject leader and coordinator – operational and analytical campaign management (CRM)

eprimo

Subproject leadership in evaluating and recommending a data mining tool.
Development of response models for analytical campaign management.
Analysis of past campaigns and support in planning new campaigns based on results.
Execution and explanation of advanced statistical analyses such as clustering, machine learning, decision trees, and regression analysis.
Training and coaching of sales management and controlling staff.
Improvement of campaigns and analysis of customer churn behavior.
Use of KNIME, DynaMine, Mindjet MindManager, MS SQL Server, MS SQL Server Studio, DynaCampaign (CRM tool), SAP CRM, SPSS Clementine, and SAP APD.

Dec 2010 - Feb 2011

3 months

Saarbrücken, Germany

SAS Financial Management report developer for bank controlling

SaarLB

Development of reports for the controlling department (risk reports, profit and loss reports) based on customer requirements.
Extraction of dimensions from existing Excel reports and setting them up in SAS FM Studio.
Population of dimensions and metrics via SAS DI Studio.
Creation of standard reports in Excel and linking to SAS FM Studio for automatic data delivery.
Use of SAS FM Studio, SAS DI Studio, SAS Enterprise Guide, Excel macros, and MindManager.

Sep 2009 - Nov 2010

1 year 3 months

Mönchengladbach, Germany

ETL developer – DWH ETL development & data mapping in risk and fraud management (CRM)

Santander (ISBAN)

Analysis, monitoring, and error analysis during migration of a Basel II server.
Analysis of end-of-period data loads and support for users in the new environment.
Execution of a KPI project: analysis of the existing data model to map new requirements and KPIs.
Extension of the data model, data validation, and mapping of new requirements to data elements.
Development of ETL processes with SAS DI Studio and SAS Base, including testing and documentation of the data model and ETL processes.
Preparation of data for calculation of risk parameters such as PD, LGD, and EAD.
Use of Windows XP, MindManager, Unix, SAS, SAS Enterprise Miner, SAS Enterprise Guide, SAS Base, SAS Macro, SAS DI Studio, HPQC, Sybase PowerDesigner, and Tortoise (versioning tool).

Jan 2009 - Mar 2009

3 months

Düsseldorf, Germany

Data Mining, Statistics & SAS consultant – survival analysis & statistical data analysis

Vodafone

Script-based implementation of SAS, SAS Enterprise Miner, and SAS Enterprise Guide for client-server applications on Unix.
Development of survival models to calculate customer retention and churn probabilities.
Calculation of survival probabilities and baseline hazard functions to analyze customer behavior and churn.
Use of Windows XP, MindManager, Unix, SAS, SAS Enterprise Miner, SAS Enterprise Guide, SAS Base, SAS Macro, and DB2.

Apr 2008 - Aug 2008

5 months

Basel, Switzerland

Cognos PowerPlay developer & Oracle DB developer

Novartis

Concept, design, and development of data models and reporting solutions.
Creation of data models with Sybase PowerDesigner and implementation in Oracle instances.
Building Cognos Transformer models and PowerCubes for reporting purposes.
Development of reports based on Cognos 7.4.
Use of Windows XP, MindManager, SQL Navigator, TOAD 9.5, Oracle 10g, SQL, Cognos 7.4, Cognos PowerPlay, Impromptu, Cognos Macro, ReportNet, and Sybase PowerDesigner.

Oct 2007 - Feb 2008

5 months

Troisdorf, Germany

Cognos & Business Intelligence Specialist (Concept, Design & Development)

TNT

Development of Cognos PowerCubes and reports for controlling and finance departments.
Use of Cognos Transformer to model data structures.
Created reporting solutions with Cognos for business analysis.
Used Windows XP, MindManager, SQL Navigator, Oracle 8/9i, SQL, Metify ABM, Cognos 7.4, Cognos PowerPlay, Impromptu, Cognos Macro, IBM Cognos Query Studio and IBM Cognos Report.

May 2007 - Sep 2007

5 months

Darmstadt, Germany

SAS Data Analyst & Response Model Developer

Musicload, T-Online

Statistical data analysis and development of response models for marketing and customer analysis.
Developed SAS programs and SAS macros for customer, marketing and data analysis.
Built foundations for CRM structures.
Coached and trained client staff in response model development, regression analysis, multivariate statistics, decision trees and machine learning.
Used Windows XP, SAS 9, MindManager, SAS Base, SAS Macro, SAS Stat, SQL, Oracle 9i and Enterprise Miner.

Oct 2006 - Dec 2006

3 months

Düsseldorf, Germany

SAS Data Analyst & Response Model Developer

Citibank

Statistical data analysis and development of response models for marketing and customer campaigns.
Developed SAS programs and SAS macros for customer, marketing and data analysis.
Used regression analysis and machine learning methods.
Used Windows XP, SAS 8/9, MindManager, Hummingbird Connectivity Tool, SAS Base, SAS Macro and SAS Stat.

Jun 2005 - Feb 2006

9 months

Düsseldorf, Germany

Business Analyst & Data Analyst, Tester and Developer – DWH (Teradata & Ab Initio)

Vodafone

Gathered and analyzed requirements of sales and marketing departments for the existing data warehouse.
Performed data analysis and specified new or extended DWH functionalities.
Developed and tested DWH components including creating test cases, test execution, test documentation and error tracking.
Used Windows XP, Teradata, Sybase PowerDesigner (data modeling), Sun Unix, MindManager, Ab Initio, SQL, Mercury Quality Center (Test Director, HPQC) and DB2.

Jan 2005 - Feb 2005

2 months

Bonn, Germany

Data Analyst & SAS Developer – Database Marketing (Data Mining)

T-Mobile

Conducted analyses within database marketing.
Developed SAS macro programs to support a statistician in analyses.
Used Windows XP, Oracle, Quest Tool, Sun Unix, SAS Base, SAS Macro and SQL.

Feb 2004 - Apr 2004

3 months

Bonn, Germany

Data Warehouse & BI Consultant – Source and Target System Analysis

DHL

Conducting an as-is analysis of the existing reporting and data warehouse landscape.
Defining reporting structures and gathering reporting requirements from various departments.
Recommending suitable reporting tools.
Using Windows XP, MS Office, Visio, MS Project, Cognos, MyEureka, MicroStrategy, Oracle, NCR Teradata, and SAP BW.

Aug 2003 - Oct 2003

3 months

Munich, Germany

Technical & Management Consultant – Sales Reporting and Data Warehouse Project

Fujisawa (Pharma)

Building a sales reporting system for the sales department.
Gathering requirements with sales managers and identifying relevant tables in the Oracle database.
Creating data marts as Cognos PowerCubes using Cognos Transformer.
Generating standard reports with Cognos Query and delivering them via the intranet with Cognos Upfront.
Developing the corresponding intranet pages.
Using Windows NT, Cognos PowerPlay 7, Cognos Transformer 7, Architect 7, Cognos Upfront 7, HTML, XML, IBM Cognos Report, and IBM Cognos Query Studio.

May 2003 - Jul 2003

3 months

Cologne, Germany

Technical Consultant – IBM Cognos Developer / Consultant

KMCglobal

Installing a complete Cognos PowerPlay environment on a Windows server.
Configuring the environment and setting up an intranet portal with Cognos Upfront.
Developing initial reports with Cognos Transformer and Cognos Query and deploying them to the intranet.
Using Windows NT, Cognos PowerPlay, Cognos Transformer, Architect, Cognos Upfront, HTML, XML, IBM Cognos Report, and IBM Cognos Query Studio.

Jan 2003 - Apr 2003

4 months

Cologne, Germany

SAP BW Consultant & Cognos PowerPlay / Transformer Developer

Infovision Europe GmbH

Creating ETL routines and ODS extractions into flat files.
Testing InfoSources, InfoObjects, and InfoCubes in SAP BW.
Building OLAP cubes in Cognos PowerPlay based on SAP BW data.
Comparing generated reports with SAP BEx Analyzer reports for consistency and accuracy.
Using Windows NT, Cognos PowerPlay & Upfront, SAP BW, BEx Analyzer, ABAP, OLAP, BAPI, ODBO, IBM Cognos Report, and IBM Cognos Query Studio.

Dec 2002 - Oct 2002

-1 years -1 months

London, United Kingdom

Business Process Analyst – Supply Chain Analysis (Pre-study)

Softnet Technologies Ltd.

Conducting a business process analysis as groundwork for a data warehouse project.
Creating a process model to map supply chain processes.
Using Windows 2000, MS Office, Visio, and MS Project.

Mar 2002 - Sep 2002

7 months

Cologne, Germany

BPM Project Manager – Supply Chain Analysis & Business Process Analyst

Medason GmbH

Conducted a supply chain analysis and built a customer database.
Designed and implemented an e-commerce solution based on developed process and data models.
Created the data model and set up the database.
Used Windows 2000, MySQL, MS Access, MS Office, Dreamweaver MX, PHP, and MS Project.

May 2001 - Feb 2002

10 months

Essen, Germany

Project Manager – SAS, Lotus Notes Knowledge Management & Project Management

PwC (Unternehmensberatung)

Designed and implemented a knowledge management system based on Lotus Notes.
Worked on a nationwide project to integrate the department into the existing knowledge management system.
Planned the solution and managed project coordination and control.
Used Windows NT, SAS Base, SAS/SQL, Lotus Notes DB, MS Access, and Unix.

Aug 2000 - Apr 2001

9 months

Stockholm, Sweden

Senior Consultant & BI Developer – SAP BW & IBM Cognos PowerPlay Enterprise Server

Ericsson Radio Systems

Worked on a data warehouse project for a supply chain management strategy.
Consolidated data from operational sources (e.g., SAP R/3) into a central database.
Installed, configured, and customized Cognos PowerPlay Enterprise Server to meet client requirements.
Conducted client training on reporting and analysis.
Used Windows NT, SAS Base, SAS/SQL, Lotus Notes DB, MS Access, Unix, IBM Cognos Report, and IBM Cognos Query Studio.

Mar 2000 - Jun 2000

4 months

Frankfurt, Germany

ETL Analyst & Designer – DWH ETL Developer & Source System Analyst

Mannesmann Arcor

Conducted source system analyses to identify relevant data.
Designed the extraction, transformation, and load (ETL) process for the data warehouse.
Was responsible for analysis and ETL design.
Used Windows NT, SAS Base, SAS/SQL, Lotus Notes DB, MS Access, Unix, and DB2.

Oct 1999 - Dec 1999

3 months

Heidelberg, Germany

SAS Application Developer for Data Warehouse & SAP BW

SAS Institute

Developed with SAS AF/SCL and built an add-in tool for the SAS Warehouse Administrator.
Designed and developed a tool to map SAP BW metadata to SAS Warehouse Administrator metadata.
Built InfoCubes in SAP BW from SAP R/3 data and checked data quality.
Used Windows NT, Unix, SAS Base, SAS AF, SAS Warehouse Administrator, SAP BW, and SAP R/3.

Jun 1999 - Sep 1999

4 months

Frankfurt, Germany

SAS Application Developer for Data Warehouse

Allgemeine Deutsche Direkt Bank

Programming with SAS AF/SCL and configuration of the SAS Warehouse Administrator.
Support for project acceleration in the existing data warehouse project.
Implementation of backend adjustments.
Use of Windows NT, SAS Base, SAS AF and SAS Warehouse Administrator.

May 1999 - Jul 1999

3 months

Stuttgart, Germany

SAS Application Developer for Data Warehouse

VPV Versicherung

Programming tasks with SAS Base and AF/SCL in a controlling data warehouse project.
Backend programming and tool customization.
Use of Windows NT, SAS Base, SAS AF, SAS Warehouse Administrator and SAS/SQL.

Feb 1999 - Jun 1999

5 months

Münster, Germany

SAS Application Developer and Consultant for SAS Data Warehouse

Buchungszentrale für Rheinisch-Lippischen Sparkassenbund (heute: Sparkasseninformatik)

SAS backend programming in SAS Base.
Design and development of a frontend tool in SAS AF/SCL for payment transactions and credit rating statistics.
Direct collaboration with clients to gather requirements and implement solutions.
Use of Windows NT, SAS Base, SAS AF, SAS EIS, SAS/SQL and PowerPoint.

Jan 1995 - Dec 1998

4 years

Katlenburg-Lindau, Germany

Postdoc – Theoretical Physicist, Scientist, Data Analyst

Max-Planck-Institute für Aeronomie

Scientific staff member in the CELIAS subproject of the international SOHO project to study the solar wind (under the auspices of NASA).
Analysis of satellite data on the solar wind with IDL (Interactive Data Language) and identification of patterns that can be linked to physical phenomena.
Development of nonlinear mathematical models to describe the observed phenomena.
Publication of results in scientific journals.
Use of VMS, Unix, OSF1, Windows NT, IDL, Gnuplot, Fortran, Xfig and LaTeX.

Summary

Through my previous roles and experience, I am accustomed to thinking interdisciplinarily, considering user-specific aspects, implementing system solutions, taking responsibility and acting entrepreneurially. My broad knowledge and past work also enable me to quickly dive into a given technical problem. My fast learning ability, flexibility and teamwork skills stand out. Furthermore, my core competencies lie in data warehousing, business intelligence and data mining combined with statistical data analysis. Specifically, I have worked on response model development and regression analyses for analytical CRM.

In current projects, I increasingly apply my skills in predictive analytics and applied mathematics. Thus, I am shifting more into the areas of data mining, predictive analytics & applied mathematics. In projects, I have performed regression analyses, decision trees, survival analysis, inventory analysis and queue analysis. Predictive analytics and statistical data analysis serve to improve marketing processes, CRM and campaigns. In this way, I have built solid knowledge in these areas. Additionally, I have expanded my tool knowledge to include SAP BW ETL, SAP BW modeling and SAP BW reporting.

Within my work in data analysis, DWH & BI, I have been heavily involved in data management, data modeling (Sybase PowerDesigner, ErWin tool), ETL development and data acquisition from heterogeneous systems. I have 10 years of experience in this area.