Srinivas Jammalamadaka - Senior Application Engineer

Recommended expert

Alphen aan den Rijn, Netherlands

Experience

Jun 2024 - Apr 2025

11 months

Würzburg, Germany

Senior Application Engineer

DRV (Deutsche Rentenversicherung)

Administration of SAS & SPSS software packages and their system environments like Windows & Red Hat Linux.
Troubleshooting issues recorded by CheckMK, software updates, patches, system and application monitoring.
Memory management and performance optimization.
Technologies: SAS 9.4 software (Enterprise Guide, Management Console, Environment Manager, etc.), SPSS, Red Hat Linux, Windows, data preparation for IFRS 17 processes.

Sep 2023 - Apr 2024

8 months

Munich, Germany

Big Data and Process Mining Engineer

Telefonica

Improving silent factoring processes related to risk analytics.
Process optimization using Celonis and adapting data models with SAP PowerDesigner.
Business process management and analysis and data modeling.
Scoring and model development in Azure DevOps and Databricks environments.
OCPM modeling using Celonis.
Transition of insurance accounting to a unified framework according to IFRS 17.
Technologies: Celonis (process mining tool), ARIS V10, SAP PowerDesigner, TOAD, Azure Cloud & DevOps, Databricks, GIT DevOps, SQL, PL/SQL, Python, yED, Oracle, Windows, SAS 9.4.

Aug 2022 - Jul 2023

1 year

Frankfurt, Germany

SAS developer

Finanz Informatik

Gathering requirements from business units and developing solutions for the mainframe production environment.
Development in the SAS environment for regulatory reporting requirements of banks and savings banks.
Handling tickets from daily runs.
Building robust data models, data warehouses, ETL processes, quality assurance, and data governance.
Technologies: SAS 9.4, SAS Enterprise Guide, SAS Macro, SQL, SAS DI Studio, Windows, mainframe, OSPLUS, IDz, TSO, ETAPS, ISPF, JCL, REXX, ENDEVOR, RACF.

Sep 2021 - Dec 2021

4 months

Amsterdam, Netherlands

Risk Data Analyst & Business Analyst

ING Bank

Data preparation for credit risk reporting, credit risk migration, and RWA analysis.
Credit risk portfolio analysis based on IRB and AIRB to determine PD, LGD, EAD, and M.
Analysis of data quality measures for dashboard reports.
Modeling multi-entity risk processes according to OCPM in process mining.
Transition to IFRS 17 to modernize insurance accounting.
Technologies: SAS Enterprise Guide, SAS Visual Studio, SQL, Windows, Oracle DB, SAP Fieldglass, Confluence, Citrix, Power BI.

Jul 2019 - Jul 2022

3 years 1 month

Wiesbaden, Germany

Team leader (Application Operations Manager)

Statistisches Bundesamt Wiesbaden

Maintenance, administration, and support of the department in the use of SAS and R software.
Handling change requests and problem solving via ticketing and request tools.
Performing system & application updates and documentation.
Maintenance & further development of SAS stored processes.
Technologies: SAS 9.4, SQL, Windows, Oracle DB, VMWare, ARIS, Linux, yED, R software & RStudio, Windows virtual machine, MS Visio, SAP Fieldglass, Citrix, SAS Enterprise Guide, SAS DI Studio.

Feb 2018 - Jan 2019

1 year

Frankfurt, Germany

Data Analyst

Deutsche Bank

Business analysis & data management (data modeling & ETL routine adjustments), data mining.
Implemented control processes required by IDD guidelines using SAS software.
Entered and updated validation steps in ADONIS.
Ensured data quality and enhanced the data set in the existing DWH.
Conceptual design of ETL and extension of existing data models as part of a CRM strategy.
Modeled multi-object regulatory processes in line with OCPM modeling in process mining.
Technologies: SAS 9.4, SQL, Windows, UNIX, ADONIS, Sybase Power Designer.

Oct 2016 - Jul 2017

10 months

Mönchengladbach, Germany

SAS Tester

Santander Bank

Supported the IFRS 9 project by handling testing activities, creating test cases and documentation.
Reviewed the input interface and liaised with business units and the development team.
Applied Scrum methodology to prepare data for account scoring, credit risk, and calculation of risk parameters (PD, LGD, EAD) & mortgages per IFRS 9 standard.
Adapted the existing data model, and extended and tested ETL processes for campaign management and CRM.
Technologies: SAS 9.4, SAS Enterprise, SAS Base, SAS Macro, Jira, HP ALM, Confluence, Sybase Power Designer.

Jan 2016 - Aug 2016

8 months

Düsseldorf, Germany

Data Mining & Mathematical Consultant / Model Development

ERGO Versicherungen

Business analysis & data management (data modeling & ETL routine adjustments), data mining.
Captured business requirements and developed solutions for accident, property, legal protection, and liability insurance.
Integrated product extensions into data models and documented ETL routines.
Created the GDV statistics for property insurance.
Technologies: SAS, SAS Enterprise Guide, SAS Visual Studio, SQL, Windows, MS Access DB & Forms, Citrix, Sybase Power Designer, SAS VIYA.

Feb 2015 - Mar 2015

2 months

Duisburg, Germany

Data Mining & Mathematical Consultant / Model Development

Exactag

Examined customer behavior during online, app & tablet shopping (customer journey).
Developed statistical methods for cross-channel and cross-device marketing & advertising.
Developed models for record linkage problems and dynamic attribution models.
Analyzed online touchpoints to assess the impact of advertising on conversion.
Applied cluster analysis, Bayesian statistics, machine learning and probability theory.
Multi-object event modeling (user + device + session + campaign) similar to OCPM.
Technologies: Hadoop, Python, SQL, Windows, Rapidminer, Software R & R Studio, MySQL, KNIME.

Sep 2014 - Jan 2015

5 months

Düsseldorf, Germany

Report & BI Architect

Vodafone

Continued existing reporting (Excel Think Cell) and implemented/transferred it to SAP BO via the Web Intelligence Rich Client.
Took over, improved and standardized existing reports from the Teradata DWH.
Automated reports with SAP BI - SAP BO and Information Delivery Tool as a step towards CRM reporting.
Coached team members.
Technologies: Teradata DWH, MS Access DB, SQL, Windows, SAP BO Crystal Reports 4.1, Information Delivery Tool, Think Cell Reporting, SAP Business Objects 4.1 (Universe-Design-Tool, Web-Intelligence-Rich-Client), SAP BI.

Jan 2014 - Jul 2014

7 months

Frankfurt, Germany

SAS BI Architect

Deutsche Bank / HCL

Restructuring an existing SAS DWH to comply with new security guidelines (IT governance and audit compliance).
Adapting batch processes (JCL, SAS Base, SAS Macro) in a mainframe environment.
Revising business rules and checking/extending data historization.
Designing and implementing data modeling and ETL routines.
Coordinating outsourcing and handing over to an offshore team in Bangalore.
Technologies: SAS mainframe installation, SAS Foundation 9.3, JCL, TSO, ISPF, SAS Base & Macro, SAS 9.2, MVS, Linux, Windows, z/OS, Sybase Power Designer.

Jul 2013 - Dec 2013

6 months

Meerbusch, Germany

SAP BW Consultant

Business Cybernetics

Functional use of SAP BW (data modeling, ETL, reporting & analysis) and basic ABAP programming.
Performing error analysis on existing developments and fixing issues.
Working in a live system environment with sample data and installing miniSAP for testing.
Technologies: SAP BW data modeling, SAP BW ETL, SAP BW reporting & analysis, ABAP.

Jun 2013 - Jun 2013

1 month

Berlin, Germany

Teradata Consultant

Groupon

Creating standard reports and ad-hoc queries in Teradata.
Retrieving data with SQL and creating Excel pivot tables.
Technologies: SQL, Teradata, Excel pivot tables.

Jan 2013 - Apr 2013

4 months

Meerbusch, Germany

SAP BW Consultant

Business Cybernetics

Learning SAP BW data modeling, ETL, reporting & analysis, and ABAP programming.
Troubleshooting and fixing issues in existing developments in a test environment (miniSAP).
Technologies: SAP BW data modeling, SAP BW ETL, SAP BW reporting & analysis, ABAP.

Mar 2012 - Dec 2012

10 months

Braunschweig, Germany

SAS Consultant & Developer

VW Financial Services

Recording work orders, troubleshooting, incident and release management for SAS users.
Adjusting ETL processes and extending the data model.
Organizing and improving a job chain of 380 individual jobs using Scheduler and Flow Manager.
Providing data for analysis in machine learning and data mining.
Technologies: SAS 9.2, SAS 9.3, SAS Management Console, SAS DI Studio 3.4, SAS Enterprise Guide, AIX, Windows, Platform Flow Manager, SAP BW, HP Quality Center (HPQC), Sybase Power Designer.

Mar 2011 - Sep 2011

7 months

Neu-Isenburg, Germany

Subproject Leadership and Coordination

eprimo

Analysis and development of data for marketing campaigns.
Subproject management in evaluating and recommending data mining tools.
Development of response models for analytical campaign management.
Analysis of past campaigns to plan new initiatives.
Conducting statistical analyses (clustering, machine learning, decision trees, regression analysis).
Training and coaching staff in sales management and controlling.
Technologies: KNIME, DynaMine, MS SQL Server, MS SQL Server Studio, DynaCampaign (CRM tool), SAP CRM, SPSS Clementine, SAP APD.

Dec 2010 - Feb 2011

3 months

Saarbrücken, Germany

SAS FM Report Developer

SaarLB

Development of risk and profitability reporting for the controlling department.
Extraction of dimensions from Excel reports and setup in SAS FM Studio.
Populating dimensions and key figures with data using SAS DI Studio.
Creation of automated standard reports in Excel by connecting to FM Studio.
Technologies: SAS FM Studio, SAS DI Studio, SAS Enterprise Guide, Excel macros.

Sep 2009 - Nov 2010

1 year 3 months

Mönchengladbach, Germany

ETL Routines Developer

Santander (ISBAN)

Analysis, monitoring, and error investigation during the migration of Basel II servers.
Analysis of the month-end load run and support of users in the new environment.
Execution of KPI projects: analysis and expansion of the existing data model.
Mapping new requirements to data elements and developing ETL processes using SAS DI Studio and SAS Base.
Data preparation for calculating risk parameters (PD, LGD, EAD).
Technologies: SAS, SAS Enterprise Miner, SAS Enterprise Guide, SAS Base, SAS Macro, SAS DI Studio, HPQC, Sybase Power Designer, Tortoise.

Jan 2009 - Mar 2009

3 months

Düsseldorf, Germany

Data Mining, Statistics & SAS Consultant

Vodafone

SAS scripting for client-server applications on UNIX systems.
Development of survival models to calculate probabilities.
Conducting survival analyses to study customer behavior (churn analysis).
Determining survival probability and baseline hazard.
Technologies: SAS, SAS Enterprise Miner, SAS Enterprise Guide, SAS Base, SAS Macro, DB2, UNIX.

Apr 2008 - Aug 2008

5 months

Basel, Switzerland

Cognos Power Play Developer

Novartis

Conceptualization, design, and development of data models and reporting.
Development of data models with Sybase Power Designer for Oracle instances.
Creation of Cognos Transformer models and Power Cubes for reporting.
Technologies: Oracle 10g, SQL, SQL Navigator, TOAD 9.5, Cognos 7.4, Cognos Power Play, Impromptu, Cognos Macro, ReportNet, Sybase Power Designer.

Oct 2007 - Feb 2008

5 months

Troisdorf, Germany

Cognos & Business Intelligence Specialist

TNT

Planning, designing, and developing Cognos Power Cubes and reports.
Creating Cognos Transformer models for controlling and finance departments.
Technologies: Oracle 8 & 9i, SQL Metify ABM, Cognos 7.4, Cognos Power Play, Impromptu, Cognos Macro, IBM Cognos Query Studio/Report.

May 2007 - Sep 2007

5 months

Darmstadt, Germany

SAS Data Analyst

Musicload, T-Online

Developing SAS programs and macros for customer, marketing, and data analysis.
Setting up the foundation for CRM.
Building response models, doing regression analysis, and multivariate statistics.
Using decision trees and machine learning.
Coaching and training client staff.
Technologies: SAS Software Version 9, SAS Base, SAS Macro, SAS Stat., SQL, Oracle 9i, Enterprise Miner.

Oct 2006 - Dec 2006

3 months

Düsseldorf, Germany

SAS Data Analyst

Citibank

Statistical data analysis and development of response models.
Writing SAS programs and macros for customer, marketing, and data analysis.
Performing regression analysis and applying machine learning.
Technologies: SAS Software Version 9/8, Hummingbird Connectivity Tool, SAS Base, SAS Macro, SAS Stat.

Jun 2005 - Feb 2006

9 months

Düsseldorf, Germany

Business Analyst & Data Analysis, Testing, Development

Vodafone

Gathering requirements for sales and marketing.
Analyzing data and collecting business requirements for the existing data warehouse.
Creating test cases, performing tests, documenting, and tracking issues.
Technologies: Teradata, Sybase Power Designer, Sun UNIX, Ab Initio, SQL, Quality Center (HPQC), DB2.

Jan 2005 - Feb 2005

2 months

Bonn, Germany

Data Analysis, SAS Developer

T-Mobile

Database marketing and data analysis.
Creating analyses for statisticians and programming SAS macros.
Technologies: Oracle, Quest Tool, Sun UNIX, SAS Base, SAS Macro, SQL.

Feb 2004 - Apr 2004

3 months

Bonn, Germany

Data Warehouse Project & Business Intelligence

DHL

Conduct a preliminary study and as-is analysis.
Define reporting structures and gather business requirements from various departments.
Recommend a suitable reporting tool.
Technologies: MS Office, Visio, MS Project, Cognos, MyEureka, MicroStrategy, Oracle, NCR Teradata, SAP BW.

Aug 2003 - Oct 2003

3 months

Munich, Germany

Technical & Management Consultant

Pharma - Fujisawa

Set up sales reporting by gathering requirements from sales managers.
Identify relevant tables in the Oracle database and consolidate information.
Expand data marts into Cognos Power Cubes using Cognos Transformer.
Create standard reports with Cognos Query and deliver them via Cognos Upfront on the intranet.
Technologies: Cognos PowerPlay v7, Transformer v7, Architect v7, Upfront v7, HTML, XML, Oracle DB.

May 2003 - Jul 2003

3 months

Cologne, Germany

Technical Consultant

KMCglobal

Complete installation and configuration of Cognos PowerPlay on a Windows Server.
Enhance an intranet portal using Upfront.
Create initial reports using Cognos Transformer and Query.
Technologies: Windows NT, Cognos PowerPlay, Transformer, Architect, Upfront, HTML, XML.

Jan 2003 - Apr 2003

4 months

Cologne, Germany

SAP BW Consultant

Infovision Europe GmbH

Develop ETL routines and extract ODS data into flat files.
Test InfoSources, InfoObjects, and InfoCubes.
Provide data and import it into Cognos PowerPlay to form OLAP cubes.
Compare reports with SAP BEx Analyzer to check for meaning and accuracy.
Technologies: SAP BW, BEx Analyzer, ABAP, OLAP, BAPI, ODBO, Cognos PowerPlay & Upfront.

Oct 2002 - Dec 2002

3 months

London, United Kingdom

Supply Chain Analysis as a Pre-study for Trade Consulting Concept & Business Process Analyst

Softnet Technologies Ltd.

Conduct a business process analysis.
Create a process model as groundwork for a data warehouse project.
Technologies: Windows 2000, MS Office, Visio, MS Project.

Mar 2002 - Sep 2002

7 months

Cologne, Germany

Project Manager, BPM

Medason GmbH

Conducting a supply chain analysis and building a customer database for e-commerce.
Business process analysis and building a corresponding database based on the resulting data model.
Technologies: MySQL, MS Access, MS Office, Dreamweaver MX, PHP, MS Project.

May 2001 - Feb 2002

10 months

Essen, Germany

Project Management, Coordination and Control

Management Consulting (PwC)

Planning, designing and implementing a Knowledge Management System based on Lotus Notes.
Project coordination across Germany to integrate the department into the existing Knowledge Management System.
Technologies: Windows NT, SAS Base, SAS/SQL, Lotus Notes DB, MS Access, UNIX.

Aug 2000 - Apr 2001

9 months

Stockholm, Sweden

Senior Consultant, BI Developer

Ericsson Radio Systems

Data warehouse project for a supply chain management strategy.
Consolidation of data from operational sources like SAP R/3 into a stable data base.
Installation and configuration of the Cognos PowerPlay Enterprise Server.
Conducting client training.
Technologies: SAS Base, SAS/SQL, Lotus Notes DB, MS Access, UNIX, SAP R/3, IBM Cognos.

Mar 2000 - Jun 2000

4 months

Frankfurt, Germany

ETL Analysis and Design

Mannesmann Arcor

Conducting a source system analysis with accountability for results.
Designing the extraction, transformation and loading process (ETL).
Technologies: Windows NT, SAS Base, SAS/SQL, Lotus Notes DB, MS Access, UNIX, DB2.

Oct 1999 - Dec 1999

3 months

Heidelberg, Germany

Application Developer

SAS Institute

Programming with SAS AF/SCL and developing an add-in tool for the SAS Warehouse Administrator.
Designing and developing mappings of SAP BW metadata to SAS Warehouse Administrator metadata.
Creating InfoCubes in SAP BW based on data from the SAP R/3 module.
Checking data quality.
Technologies: SAS Base, SAS AF, SAS Warehouse Administrator, SAP BW, SAP R/3, UNIX.

Jun 1999 - Sep 1999

4 months

Frankfurt, Germany

Application Developer

Allgemeine Deutsche Direkt Bank

Programming with SAS AF/SCL to speed up projects.
Performing configurations in the SAS Warehouse Administrator and making backend adjustments.
Technologies: Windows NT, SAS Base, SAS AF, SAS Warehouse Administrator.

May 1999 - Jul 1999

3 months

Stuttgart, Germany

Application Developer

VPV Versicherung

Programming tasks in SAS Base and AF/SCL (object-oriented 4GL language).
Contributed to a SAS Controlling Data Warehouse project.
Performed backend programming and customized tools.
Technologies: SAS Base, SAS AF, SAS Warehouse Administrator, SAS/SQL.

Feb 1999 - Jun 1999

5 months

Münster, Germany

Application Developer and Consultant

Buchungszentrale für Rheinisch / Lippische Sparkassenbund

SAS backend programming in SAS Base.
Designed and developed a frontend tool in SAS AF/SCL.
Developed front-end tools for payment processing and credit rating statistics in direct collaboration with the client.
Technologies: SAS Base, SAS AF, SAS EIS, SAS/SQL, PowerPoint.

Jan 1995 - Dec 1998

4 years

Katlenburg-Lindau, Germany

Postdoc, Theoretical Physicist, Natural Scientist, Data Analysis

Max-Planck-Institute für Aeronomie

Contributed to the CELIAS sub-project of the international NASA SOHO mission to study the solar wind.
Analyzed satellite data on the solar wind using IDL (Interactive Data Language).
Identified physical phenomena by pattern matching in data.
Developed a nonlinear mathematical model.
Published results in scientific journals.
Technologies: VMS, UNIX, OSF1, IDL, Gnuplot, FORTRAN, Xfig, LaTeX.

Summary

Through my previous roles and experience, I am used to thinking across disciplines, considering user-specific aspects, documenting system solutions, taking responsibility, and acting entrepreneurially.

In addition, my broad knowledge and past work allow me to quickly understand a technical problem. My fast learning ability, flexibility, and team skills are my key strengths.

Furthermore, my core competencies lie in data warehouse, 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 am increasingly applying my skills in predictive analytics and applied mathematics. I am shifting more and more toward data mining, predictive analytics, and applied mathematics. In projects, I have performed regression analyses, decision trees, survival analysis, inventory analysis, and queue analysis.

Predictive analytics and statistical data analysis help improve marketing processes, CRM, and campaigns. In this way, I have also built solid knowledge in these areas. Additionally, I have expanded my tool knowledge to SAP BW ETL, SAP BW modeling, and SAP BW reporting.

In my work in data analysis, DWH & BI, I have dealt extensively with 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. As shown in my resume, my professional focus is increasingly moving toward credit risk modeling & management and analytics for the financial services industry. My work includes data preparation for credit risk, IFRS 9 and IFRS 17 calculations, scoring, RWA analyses, and development of regulatory risk and reporting processes in banking and insurance environments.

Skills

Industry Knowledge

Industry
Service Providers
Telecommunications
Banks & Insurance
Pharmaceuticals
Energy

It Skills

Windows 7/xp/2000/me/nt/95/98
Ms-dos
Linux, Vms
Unix
Mvs, Jcl
Sas 4gl Languages (Sas/scl & Sas Base)
Sql / Transsql
Python
R Software
Odbc
Api
Oracle (9i & 10g)
Ms Access 2000
Sas Spds
Mysql
Ms Sql Server 2008, 2010, Sql Management Studio
Sybase Powerdesigner
Mind Manager
Sas 9.4, Sas/base, Sas Macro
Sas Enterprise Miner
Sas Enterprise Guide
Sas Fm Studio
Sas Di Studio
R Software & Rstudio
Hadoop (Hdfs, Mapreduce & Hbase, Eclipse)
Toad (Sql Client)
Process Mining Tool Celonis
Aris - Bpmn
Sap Powerdesigner – Data Modeling
Microsoft Azure
Databricks
Jupyter Notebook
Anaconda Analytics Environment

Methodical Skills & Business Know-how

Data Warehouse & Etl Development
Business Intelligence (Bi), Olap
Business Process Management (Bpmn)
Data Modeling
Process Mining

Data Mining & Statistical Data Analysis

Sas Base & Macro, Enterprise Miner
Knime (Open Source Solution)
Rapid Miner
R Software (Open Source Solution), Rstudio

Leadership Skills

Project Management (Pmi)

Consulting Focus

Databases
Conceptual Design
Implementation
Organizational Consulting
Project Leadership
Training And Coaching
Consulting

Hardware

Pc
Sun
Silicon Graphics
Vax

Operating Systems

Ms-dos
Ms Windows 9.x
Ms Windows Nt/2000
Unix
Vms
Linux

Programming Languages

4gl Languages Sas/af (Scl), Sas/base, Sas Macro
Html
Xml
Pascal
Sql
Cognos Macro Language

Databases

Access
Mysql
Oracle 9i
Sas Database

Data Communication

Microsoft Standards

Ms Office
Ms Project
Visio

Methods

Project Management
Conceptual Design
Data Modeling

Professional Associations & Organizations

Aps (American Physical Society)
Ieee Computer Society
Pmi (Project Management Institute)
Who Is Who International

Business Processes / Cross-functional Processes

Scm
Crm
Data Warehouse And Business Intelligence
Knowledge Management
Professional Services Automation (Psa)

Standard Software

Data Warehousing
Data Mining
Sas Warehouse Administrator
Sas Base
Sas/eis
Sas/scl
Sas/af
Sas Sql
Cfo Vision
Enterprise Reporter
Enterprise Guide
Enterprise Miner
Latex
Mind Map (Mindjet)
Knime

It Solutions

Data Warehouse And Business Intelligence
B2b (= Business To Business Application)
A2a (= Application To Application), File Transfer, Integration Process And Loading
Data Extraction, Cleaning, Transformation And Loading (Etl Process)
Business And Data Modeling
System Analysis And Design
Psa (Professional Services Automation)
It Strategy And It Architecture

Special Skills