Vinayak Shukla

Results-driven Data Analyst with strong foundation in data preparation, exploratory analysis, and Marketing Mix Modeling (MMM). Proficient in SQL, Python, Power BI, and Excel, leveraging these tools to derive insights that drive strategic decision-making. Demonstrated ability to comprehend customer requirements and translate them into actionable project plans that deliver measurable outcomes. Committed to excellence and passionate about harnessing the power of Big Data to solve complex business challenges.

• Proficient in SQL and RDBMS practices such as data retrieval, data manipulation, data cleaning and transformation, joins, data filtering, data aggregation and summarization; and data constraints, data integrity, normalization(1NF, 2NF, 3NF), ACID properties, schema design and surrogate key usage.
• Solid grasp of statistics concepts such multicollinearity, regression, mean, deviation, variance, standard deviation, MAPE, R² etc.
• Well versed in Data/Dimensional Modeling concepts such as Fact & Dimension tables, Surrogate Keys, Natural Keys, Star Schema, Snowflake Schema, SCDs, Fact tables types(Transactional, Snapshot, Factless), granularity along with ETL/ELT frameworks.
• Solid understanding of data engineering concepts such as data warehouses, data lakes, and data lakehouses, along with ETL/ELT frameworks.
• Exposure to platforms like ADF, Amazon S3 and Databricks for data integration and orchestration, ETL/ELT, data wareshousing, data migration, storage and Big-Data processing.
• Solid understanding of advanced SQL concepts like query optimization, join optimization strategies, effective indexing, sargability, subqueries and CTEs.
• Well-versed in Agile methodologies, including sprint planning, iterative development, and collaboration in cross-functional teams and team management.
• Strong analytical thinking and problem-solving skills, with the ability to break down complex data scenarios and deliver actionable insights.