Business Intelligence Sql Server

Vinay Panchal

682-***-**** ****************@*****.*** Arlington, TX

Summary

• 2+ years of experience as a Business Intelligence Analyst with expertise in data visualization, statistical analysis, data cleaning, and deriving actionable insights from complex datasets.

• Skilled in utilizing data visualization tools such as Power BI, Tableau, Alteryx, QlikView, Python (Matplotlib), and AWS QuickSight to design and deliver interactive, insightful reports and dashboards that drive actionable business decisions.

• Practical understanding of Data modeling (Dimensional and relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, and Fact and Dimension tables.

• Proficient in data extraction, transformation, and analysis across various relational and NoSQL databases, including SQL Server, MySQL, PostgreSQL, and MongoDB, to derive meaningful insights and support data-driven decisions. Skills

Languages: Python, R Programming, SQL

Package: NumPy, Pandas, Matplotlib, SciPy, Seaborn, Plotly, ggplot2, dplyr, tidy Business Intelligence Tools: SQL Server Integration Services (SSIS), Informatica Power Center, Power BI, Tableau, SQL Server Management Studio (SSMS), Alteryx

Cloud Technology: AWS (S3, EC2, Redshift, Quick sight, Sagemaker, Lambda), Azure Data Skills: Data Warehousing, Data Mining, ETL, Data Manipulation, Statistical Analysis, Data Modeling Version Control Tools and Databases: GitHub, Git, SQL Server, MySQL, Oracle, MongoDB Education

Master of Science in Computer Science Dec 2023

University of Texas, Arlington, TX

Bachelor of Engineering in Computer Engineering May 2021 LDRP Institute of Technology and Research, Gujarat, India Work Experience

CitiGroup, TX Oct 2023 – Current

Business Intelligence Analyst

• Implemented data cleaning routines for large datasets using Python and SQL, working closely with data scientists to ensure data accuracy and reliability, leading to a 25% reduction in data cleaning time and allowing more time for advanced data.

• Deployed a data visualization solution to provide stakeholders with easy access to key metrics on devices, improving data accessibility by 45% and enabling real-time decision-making.

• Developed and managed ETL pipelines using AWS to process and transform raw data from multiple sources, improving data processing efficiency by 40% and enabling faster reporting for business decision-making.

• Established static modeling techniques to improve customer retention, resulting in a 15% reduction in attrition costs, demonstrating accuracy in predicting customer retention.

• Built interactive Tableau dashboards to visualize key metrics like profit margins, expense variances, and cash flow trends, enabling senior management to identify potential risks 20% faster and improve financial forecasting accuracy.

• 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%. Dixon Technology, India Aug 2020 – Jul 2021

Business Intelligence Analyst

• Applied Scikit-learn to implement classification algorithms, including Logistic Regression and Random Forests, for customer churn prediction, achieving a 92% precision rate of retention strategies, leading to retention rates.

• Implemented statistical modeling techniques, including multiple regression models, to predict trends for historical data, achieving a 95%

• accuracy rate in optimizing inventory and pricing strategies.

• Cooperated with stakeholders to develop and maintain data standards and naming conventions, working with the data governance team to

• ensure compliance with data management policies, improving data consistency, and data governance.

• Engineered scalable data transformation workflows using Azure Databricks, automating the preprocessing of data sources 35% reduction in manual data cleaning efforts, and streamlined the overall data preparation process.

• Designed and implemented interactive Power BI dashboards using Azure SQL Database, enabling real-time data visualization for 50+

• business users, which led to a 20% improvement in key performance metric tracking.

• Established automated dashboards to monitor A/B test performance, allowing stakeholders to track real-time results and adjust strategies, leading to more agile decision-making and faster iteration cycles.

• Optimized SQL Server queries using techniques such as indexing, partitioning, and stored procedures, reducing query execution times by 25% and improving data retrieval efficiency.

Certification

• AZ-900: Microsoft Azure Fundamentals Certification

Contact this candidate