Kasra Rostamkhany

Developing DCM, DS3 and Facebook API's using Python; as well as ODBC drivers (MySQL and SQL Server) and ETL frameworks within Python. Developing BI dashboards using excel power pivot and power query along with VBA. DSP data automation from Adform, Rocketfuel and BetGenius using python and VBA. Engineering a framework in order to link DSP cost data to DCM conversion data (floodlights). Lead for data delivery and insight within the biddable team across all markets and brands.

DCM reporting API, ETL and data automation in Python| Maintaining data warehouse in MySQL and SQL Server| SSIS for ETL| Advanced SQL for ETL or ad hoc analysis| Developing BI dashboards in Tableau and Datorama| Working with survey data and visualizing results in Tableau| Tableau server management| Tableau desktop custom SQL queries, variables, bullet graphs and etc| Building custom VBA tools for Data cleansing, analysis and automation.

Creating Excel Dashboards and Budget Management Tools using MS Excel & Access| Analyzing performance data in order to spot trends and advice on investment opportunities| Building MS Access databases to store cross channel performance data| Data automation through use of Excel & Access VBA| Building custom tools scripting in Excel VBA at request| Data cleaning, validation and analysis with VBA| AdWords, Bing, Google Analytics and Kenshoo.

Managing domain forwarding and DNS configuration| Analyzing data with excel, pivot tables, VLOOKUP’s and formulas| Attending the events; supervise/troubleshoot the scheduled appointments| Creating the registration processes for events, surveys and online membership applications| Creating custom ad hoc reports| Creating html email templates for various purposes| Supporting the team across the membership and general database management| Performing imports and exports to main database.

Modules include: Analysis of Variance, Time Series Modelling and Simulation, Regression, Stochastic Processes, Calculus of Variations,Games and Networks, Numerical Solution of Differential Equations, Linear Programming.