I help business people identify and automate relevant KPIs. Currently I develop ETL jobs in Python on a Linux environment. The data sources are SQL or MongoDb based. The Data Warehouse is based on Google BigQuery together with Google Data Studio. For custom visualizations or
Statistical Analysis: Providing insights to business people based on their specific data requests Use various analytical techniques - descriptive statistics, inferential statistics, survival analysis, regression, classification, event study, cluster analysis
A/B testing: Design A/B tests for various website features with the help of R and Monte Carlo Simulations Project the business ROI in terms of orders and traffic based on plausible changes Analyze the significance of the results using the appropriate hypothesis tests
Analyze development projects impact: Check the business impact of various implementations done on the website like filters use, listing algorithms, impact in conversion rate, user journey etc. Extract data from QlikView / Google Analytics or Google Cloud Platform - Big Query using SQL
Design and implement ETL jobs: Extract and combine data from various REST APIs via Python Create complex SQL queries on user-site interaction data from Big Query Create QlikView or Google Cloud Platform - Data Studio dashboards
Statistical Analysis: Providing insights to business people based on their specific data requests using various analytical techniques - descriptive statistics, inferential statistics, predictive or clustering analytics
Reporting: Developing new Tableau Reports using Tableau 10, SQL Server and OLAP Cubes based preexisting Excel Reports. Optimizing preexisting Tableau Reports for faster load times, better user interactivity and improved visuals. Creating ad-hoc Excel reports using data from Omniture and SQL Server to respond to management requests for specific data.
Feature Engineering: Parsing various information from multiple Excel or Text file using R to develop more insightful reports for the end users.
Data Quality: Identifying data inconsistencies, relating them to business causes and raising tickets to the BI Department to improve ETL Rules
Data Analysis - extracting process related data from various MySQL servers, - combining data in a relevant manner using QlikView 11 (backend) or Excel (PowerQuery), - analysing data using descriptive statistics & visualizations (histograms, boxplots, data sumaries), inferential statistics (hypothesis testing, regression), predictive statistics (logistic regression, kNN, decision trees) and clustering analytics (k-Means, Hierarchical clustering) in R or Minitab - if data transformation was needed prior to the analysis I used R (mostly data.table package) and QlikView (front end – set expressions, aggregates, pivot tables)
Process Mapping of business or technical processes based on the BPMN 2.0 standard using iGrafx for Six Sigma (with central repository) as a tool
Process Analysis: - analysing process stability or capability with Control Charts or Capability Analysis in Minitab Creating historical reports based on data from various sources - different MySQL servers or MSSQL
Project Reporting - creating project reports based on requirements of Erasmus+ Project Financials Management - tracking expenses - centralizing financial related documents (invoices, payment orders etc.) Writing Submission Application - analyzing project requirements stated by the EU - writing various parts of the application
Tableau Software, ETL, QlikView, Data Warehouse
Digital Marketing, Lean, E-commerce, Six Sigma, Data analysis
PostGreSQL, Google BigQuery, Microsoft SQL Server, MongoDB, MySQL
Talent sourcing specialist de la plateforme Pentalog, SkillValue s’appuie sur un pool de +400 000 Experts Tech & Marketing, dont +15 000 freelancers. Évaluations de compétences, missions, offres d’emploi : les consultants SkillValue vous aident à accélérer votre carrière.
Restez informé de l'actualité tech avec la newsletter Pentalog
À propos de Pentalog
Pentalog est une plateforme de services IT qui accompagne les entreprises dans leur production digitale et leur transformation en fournissant des ingénieurs et développeurs de classe mondiale. Ses 16 Delivery Centers et Agences dans le monde comptent plus de 1600 ingénieurs, développeurs, product designers et spécialistes marketing.