With over 8 years of experience, I'm a data architect and engineer by day, data analyst and visualization expert by night. I'm here to connect the pieces and build the blueprint for your data success.
🏆 Senior Data Analyst with more than 8 years of experience
📊 Data Visualization Expert: Power BI, Tableau and Google Looker
🛠️ Data Architect & Engineer: ETL (AWS Glue, Azure Data Factory), SQL (T-SQL, MySQL, PostgreSQL, APIs), and Data Warehousing (Snowflake, Redshift, BigQuery)
💻Data Analysis & Modeling: Python (Pandas,SciPy), R and Predictive Modeling (Customer churn, sales forecasts)
My Expertise:
🛠️ Data Architecture & Engineering:
● SQL Mastery: Expert in writing optimized SQL queries for data extraction from diverse databases (T-SQL, MySQL, PostgreSQL) and APIs. Experienced with joins, subqueries, window functions, and stored procedures for complex data manipulation.
● Experience in data extraction (web scraping, API integration, database connectors), transformation (data mapping, filtering, aggregation), and loading (bulk inserts, staging tables). Expert in cloud-based ETL platforms like AWS Glue and Azure Data Factory.
● Data Pipelines: Handled workflow management with tools like Airflow or Luigi. Experience with scheduling pipelines, handling dependencies, and monitoring data flow.
● Data Warehouses: Familiarity with data warehouse design best practices (dimensional modeling, data normalization). Experience with platforms like Snowflake, Redshift, or BigQuery.
🛠️ Data Cleaning & Wrangling:
● Strong SQL skills for data cleaning tasks: handling missing values, filtering anomalies, data type conversion, and standardization.
● Data Quality Techniques: Familiar with various data profiling tools like Pandas profiling, OpenRefine, DataCleaner, and Trifacta Wrangler. Utilized these tools for data statistics, type identification, missing value discovery, distribution analysis, and anomaly detection.
🛠️ Data Analysis & Modeling:
● Statistical Analysis: Familiar with R and Python libraries (NumPy, Pandas, SciPy, PyTorch) for hypothesis testing, regression analysis, and advanced techniques like time series analysis or machine learning.
● Modeling Techniques: Experience with building predictive models (e.g., decision trees, linear regression) for use cases like customer churn prediction or sales forecasting.
● SQL-driven Data Exploration: Perform exploratory data analysis directly using SQL queries to uncover patterns and trends, feeding insights into modeling and visualization work.
🛠️ Data Visualization & Communication:
● Data Acquisition and Integration: Adept at connecting to a wide range of data sources across PowerBI/Tableau/Looker, including SQL databases, APIs, CRM systems, and Excel/CSV files.
● Data Transformation and Modeling: Strong understanding of data transformation techniques in Power Query, Tableau Prep, and LookML for effective cleaning, shaping, and modeling.
● Visualizations and Insights: Skilled at crafting compelling and interactive visualizations using DAX measures, dynamic filtering, custom visuals and Row Level Security.
● Service Administration: Adept in managing BI services licenses (PowerBI/Tableau). Configuring user access, permissions, and performance optimization strategies. Leveraging the Power BI API and Tableau Prep for automation and advanced tasks.
My expertise is here to help! Reach out for a project estimate or any data-related inquiries!