Power Bi Data Analyst

Fenil Vaghasiya

346-***-**** ******************@*****.*** Houston, TX https://www.linkedin.com/in/fenil-vaghasiya/ Experience

Conns HomePlus, Houston, Texas — Power BI Developer March 2024 - Present

• Create dynamic and interactive reporting dashboards using Power BI and QlikView, boosting data visualization efficiency by 30% and facilitating real-time decision-making.

• Building robust automated reports and dashboards using advanced DAX, M Query, and Power Query techniques, improving reporting accuracy and reducing manual effort by 25%.

• Engage with stakeholders to gather comprehensive requirements, define functional specifications, and document data integration needs, ensuring alignment with business goals.

• Leverage Microsoft Fabric, Snowflake, AS400, and SQL Server for efficient data management, while utilizing DBeaver, Excel, and Python for developing predictive forecasting models, decreasing manual data processes by 40%.

• Developing and maintaining Power BI dashboards and paginated reports specifically tailored for retail, e-commerce, and merchandising sectors, enhancing data insight availability and operational efficiency by 35%.

.

M&R Manufacturing LLC, Houston, Texas — Data Analyst June 2023 – March 2024

• Analyzed manufacturing data sets using Python and SQL, identifying trends and patterns that are leading to a 15% reduction in production defects and a 10% increase in overall efficiency.

• Collected, cleaned, and organized manufacturing data from various sources using Python and SQL, ensuring data accuracy and availability for real-time analysis.

• Developed predictive models using Python, SQL, and machine learning algorithms that are improving demand forecasting accuracy by 20%, resulting in optimized inventory levels and reducing carrying costs.

• Created visually appealing dashboards and data visualizations using tools such as Tableau, Power BI, and other data visualization libraries, effectively communicating complex insights to cross-functional teams. Aellon Technology, Gujarat, India — Data Analyst August 2019- July 2021

• Implemented Agile Methodology to streamline the project life cycles of reports design and development, resulting in a minimum of 25% reduction in development time and a 15% increase in overall productivity.

• Successfully created capacity planning reports using Python packages such as NumPy, Pandas, matplotlib, and SciPy, resulting in a 20% improvement in forecasting accuracy and a 30% reduction in reporting time.

• Utilized data visualization tools, such as Tableau and Power BI, to create visually compelling dashboards and reports, driving a 20% improvement in data insights and generating a 10% increase in stakeholder engagement.

• Conducted data analysis and maintenance on a MySQL database, resulting in a 20% reduction in data inconsistencies and a 30% improvement in data integrity.

• Applied SQL and Python for data extraction, transformation, and loading (ETL) activities, reinforcing data quality and readiness for analysis.

Silverwings Technologies PVT LTD., Gujarat, India — Web Developer Intern May 2018 - July 2018

• Designed a Window based application that allows users to sell and buy books from manufacturers, sale vendors, and students and sell them to customers, students, and retailers.

• Employed a MYSQL database to store and manipulate the data, while leveraging HTML for server-side management and GUI to interact with users.

Skills

Programming: Python, SQL, R, HTML, NumPy, Pandas, Matplotlib, PyTorch, SciPy, ggplot2, MySQL, SQL Server, AS400 Visualization Tools: Power BI, Microsoft Excel, Tableau, Microsoft Fabric Other Skills: ETL, Data Cleaning, Data Wrangling, Data Warehousing, Data Ingestion, Data Validation, Data Mining Cloud: AWS services (S3, Redshift, Quick sight), Snowflake Education

Lamar University, Beaumont, TX Master of Science in Computer Science Aug 2021 - May 2023 Gujarat Technological University, Gujarat, India. B.E. in Information Technology Aug 2016 - Aug 2020

Contact this candidate