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
- 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, SQL, Six Sigma, R Language, QlikView, Python, PostgreSQL, MySQL, MongoDB, Microsoft SQL Server, Lean, Google BigQuery, ETL, E-commerce, Digital Marketing, Data Warehouse, Data Visualization, Data analysis, A/B Testing
You need this profile next month?Contact us!
You’re about to be redirected to SkillValue
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.