Optimized SQL queries through performance tuning techniques such as indexing and query hints in SSMS, significantly enhancing database performance.Developed and maintained data models and transformations using Data Build Tool (DBT), ensuring consistency, accuracy, and reliability of data across the organization.Performed data cleaning and wrangling using Python libraries like NumPy, Pandas, and Datetime to merge datasets, adjust data types, remove duplicates, handle null values, and identify outliers.Applied machine learning algorithms and advanced statistical techniques, including decision trees, regression models, SVM, and clustering, using the scikit-learn package in Python.Built Tableau dashboards to analyze large datasets from multiple sources, including databases and CRM systems, identifying key trends and patterns to drive data-informed business decisions.Utilized Python and SQL to extract, transform, and load (ETL) large datasets from various sources into a centralized data warehouse on AWS, improving data accessibility and efficiency.

Extracted and cleaned terabytes of data from relational databases (MySQL) and cloud data warehouses (Snowflake) to prepare for analysis, ensuring data accuracy and reducing analysis time by 20%.Developed complex SQL queries to extract and transform data from various sources (relational databases, cloud storage) containing over a million records, resulting in a 25% reduction in data processing time.Leveraged Python libraries such as Pandas, NumPy, Scikit-learn (Random Forests), and Matplotlib to perform comprehensive data analysis, including data cleaning, screening, exploration, visualization, feature selection, and engineering.Developed and implemented predictive models using machine learning algorithms such as linear regression, classification, K-means clustering, and regularization for data analysis.Industrialized various interactive dashboards using Tableau to communicate data trends and KPIs to non-technical audiences, leading to a 30% increase in data-driven decision-making.Collaborated with stakeholders to develop and maintain data standards and naming conventions, improving data consistency and facilitating effective data governance practices.Wrote complex SQL scripts to analyze data in different databases/data warehouses like Snowflake, Teradata, and Redshift.