Power BI & Tableau Specialist | SQL | Expert Data Analyst & Engineer |
- Verfügbarkeit einsehen
- 1 Referenz
- 80€/Stunde
- 90403 Nürnberg
- Europa
- en | de
- 15.05.2024
Kurzvorstellung
Auszug Referenzen (1)
"K. N. war technisch versiert und in der Datenbankentwicklung äußerst wertvoll."
1/2021 – 6/2022
Tätigkeitsbeschreibung
Ingested data from disparate data sources with help of SQL, APIs, Salesforce API, Dynamics API.
Created SSIS packages to extract data and scheduled jobs to call the packages and stored procedures.
Created Views, Stored procedures, Triggers,UFDs and scripts using T-SQL.
Managed code repositories with GIT and CI/CD pipelines.
Designed Dashboards with PowerBI and prepared user-stories to deliver actionable insights.
Generated KPIs for core business of the client (beside covid) as well for Finance and Sales dept which had a huge impact on the business.
Data Science, Microsoft Power BI, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), SQL
Qualifikationen
Projekt‐ & Berufserfahrung
1/2023 – 12/2023
Tätigkeitsbeschreibung
Supporting the development and maintenance of backend data sources and creation of new tableau reports.
Created Logistics, Store management, Forecasting and Warehouse efficiency reports for daily operations connections with near real time data.
Identified, recommended, and implemented appropriate continuous improvement opportunities.
Datawarehouse / DWH, Tableau, SQL, SAP Fiori, Python
7/2022 – 12/2022
Tätigkeitsbeschreibung
Understanding the technical, organizational and Processual challenges of the client.
Suggesting a optimal data integration tool which will integrate in the client ecosystem. (Data sources, platform and consumption)
Anforderungsmanagement, Big Data, Datawarehouse / DWH, Projekt-Dokumentation
1/2021 – 6/2022
Tätigkeitsbeschreibung
Ingested data from disparate data sources with help of SQL, APIs, Salesforce API, Dynamics API.
Created SSIS packages to extract data and scheduled jobs to call the packages and stored procedures.
Created Views, Stored procedures, Triggers,UFDs and scripts using T-SQL.
Managed code repositories with GIT and CI/CD pipelines.
Designed Dashboards with PowerBI and prepared user-stories to deliver actionable insights.
Generated KPIs for core business of the client (beside covid) as well for Finance and Sales dept which had a huge impact on the business.
Data Science, Microsoft Power BI, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), SQL
12/2019 – 12/2021
Tätigkeitsbeschreibung
Working heavily on SQL Server database (AWS) to extract data and build Business reports and Data analysis.
Serving as overall Project Analyst assisting with the planning and execution of company-wide projects and reporting using Tableau
Synthesizing current business intelligence data to produce reports and presentations, highlights findings and recommending changes.
Drafting quarterly and yearly reports, tracking KPIs to access successes and deficiencies.
Defining profiling data architecture and ETL process in collaboration with the product team and data engineers.
Building and maintaining new automated BI reporting solutions and visualizations that provide valuable and meaningful insights to the key stakeholders
Working closely with product teams to track the efficient roll out of new products and improving them.
Amazon Web Services (AWS), Data Science, PostgreSQL, SQL, Tableau
Ausbildung
Hof University, Germany
Hof, Germany
Pune University, Pune, India
India
Über mich
Key Areas of Specialization:
1. Expert Data Analysis & Engineering: Combining the analytical prowess of a Data Analyst with the problem-solving acumen of a Data Engineer, proficient in SQL, Power BI, and Tableau.
2. Power BI & Tableau Visualization: Creating dynamic dashboards and visual reports in Power BI and Tableau for swift comprehension of nuanced data insights by stakeholders.
3. Advanced SQL Proficiency: Crafting sophisticated SQL queries to establish robust data structures supporting extensive analytical endeavors.
4. Tailored Reporting Solutions: Utilizing Power BI and Tableau to generate insightful and coherent reports that convey complex data narratives effectively.
5. Integration with Azure & AWS: Leveraging Azure and AWS as a Data Engineer to optimize data infrastructure, ensuring seamless and potent analytics workflows.
In my capacity as both a Data Analyst and Engineer, I adeptly navigate intricate data ecosystems utilizing SQL, Power BI, Tableau, and cloud technologies such as Azure and AWS. My primary objective is to transform data into a strategic asset, facilitating informed decision-making and catalyzing business achievements.
Weitere Kenntnisse
- DAX, M (PowerQuery), Python, SQL, R
Data Analytics:
- Tagetik, Databricks, Microsoft Azure Platform (Visual Studio Code, Data Lake, Synapse, Data Factory), Apache Spark SQL, AWS (Redash)
Microsoft Power Platform:
- MS Power BI (DAX, M)
- MS Power Automate (Flow)
- MS PowerApps
Project Management Tools:
- PlanView, ServiceNow, MS Project
Business Intelligence Tools:
- Tableau, Qlik, Power BI
Collaboration Tools:
- Confluence, Jira Atlassian, Microsoft SharePoint, Teams
Web Analytics:
- Google Analytics
Persönliche Daten
- Englisch (Muttersprache)
- Deutsch (Gut)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden