Franco R.

I am a skilled Data Engineer and Analyst with expertise in developing scalable data pipelines, designing efficient data architectures, and creating insightful dashboards. I specialize in data integration, transformation, and analytics, delivering optimized solutions that align with business objectives 🏆 Senior Data Analyst | 9+ Years of Experience 📊 Data Visualization Expert: Power BI, Tableau, Google Looker 🛠️ Data Engineer & Architect: ETL (AWS Glue, Azure Data Factory), SQL (T-SQL, MySQL, PostgreSQL, APIs), Data Warehousing (Snowflake, Redshift, BigQuery) 💻 Data Analysis & Modeling: Python (Pandas, SciPy), R, Predictive Modeling (Customer Churn, Sales Forecasts) Expertise & Skills 🛠️ Data Architecture & Engineering ● SQL Mastery: Skilled in writing optimized queries for extracting and manipulating data across databases (T-SQL, MySQL, PostgreSQL) and APIs. Proficient in joins, subqueries, window functions, and stored procedures. ● ETL & Data Pipelines: Extensive experience in data extraction (web scraping, API integration, database connectors), transformation (data mapping, filtering, aggregation), and loading (bulk inserts, staging tables). Strong background in cloud-based ETL platforms like AWS Glue and Azure Data Factory. ● Workflow Automation: Hands-on experience with workflow management tools like Airflow, Snowflake Tasks and Luigi, managing pipeline scheduling, dependencies, and data flow monitoring. ● Data Warehousing: Deep understanding of best practices in dimensional modeling and normalization. Experienced with Snowflake, Redshift, and BigQuery. 🛠️ Data Cleaning & Wrangling ● SQL-Driven Data Cleaning: Expertise in handling missing values, filtering anomalies, type conversion, and standardization. ● Data Quality & Profiling: Proficient in tools like Pandas Profiling, OpenRefine, and Trifacta Wrangler for data statistics, anomaly detection, and distribution analysis. 🛠️ Data Analysis & Modeling ● Statistical Analysis: Strong background in R and Python libraries (NumPy, Pandas, SciPy, PyTorch) for hypothesis testing, regression, and time series analysis. ● Predictive Modeling: Experience building machine learning models (decision trees, regression) for use cases like customer churn prediction and sales forecasting. ● SQL-Driven Data Exploration: Skilled in uncovering patterns and trends through direct SQL analysis, driving insights for visualization and decision-making. 🛠️ Cloud Platform Expertise: ● AWS: Advanced knowledge of Lambda, Glue, S3, and Redshift for scalable and secure data processing. ● Azure: Extensive experience with Function Apps, Synapse, Data Factory, and Data Lake Gen 2 for robust data solutions. ● GCP: Expertise in BigQuery, Cloud Functions, Data Fusion, and Looker for analytics and data management. ● Snowflake: End-to-end warehouse development including schema design, performance tuning, ELT, RBAC security, semi-structured data (VARIANT), Streams & Tasks, external tables, and cost optimization 🛠️ Data Visualization & Communication ● Data Acquisition & Integration: Experienced in connecting diverse data sources (SQL databases, APIs, CRM systems, Excel/CSV) across Power BI, Tableau, and Looker. ● Data Transformation & Modeling: Strong knowledge of Power Query, Tableau Prep, and LookML for shaping and structuring data effectively. ● Interactive Dashboards & Insights: Adept at building compelling, dynamic dashboards with DAX measures, custom visuals, and row-level security. ● Service Administration: Experienced in managing Power BI/Tableau licenses, configuring user access, and optimizing performance. Skilled in using Power BI API and Tableau Prep for automation. If you're looking for a data-driven approach to problem-solving, let’s connect! I’m happy to discuss projects, provide estimates, or assist with any data-related inquiries.