I Hasan Email & Phone Number

New York, United States

Implemented (VBA) scripting to automate complex Excel tasks, such as report generation, data manipulation, and custom dashboard creation, resulting in a 40% reduction in manual work. Leveraged Power BI to develop comprehensive interactive dashboards, enabling stakeholders to gain real-time insights into critical business metrics. Utilized Power Query to extract, transform, and load large and complex data sets from diverse sources into Excel and Power BI. Applied advanced data modeling techniques to create robust data structures within Power BI, facilitating complex analytical tasks. Designed and implemented visually compelling data visualizations in Power BI, translating complex data into actionable insights. Collaborated with cross-functional teams to streamline data workflows between Excel, Power BI, and other data sources, enhancing data accuracy and accessibility.

Austin, Texas, United States

Work in an Agile environment, with the ability to accommodate and test the newly proposed changes at any point of time during the release.Automating web-scraping tool to produce marketing content using Python.● Working with various Integrated Development Environments (IDEs) like Visual Studio Code and PyCharm.● Using Pandas, NumPy, SciPy, and Matplotlib in Python for various analysis purposes.Present Dashboards to Higher Management for more Insights using Tableau.Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings, and profiling results. Providing users with SAS EG setup to access the SAS App metadata.Designed and developed intricate Excel spreadsheets with user-friendly interfaces using VBA forms and controls, improving data accessibility and user experience.Import data from multiple data sources and create automated reports in Power BI after cleaning and preprocessing the data.Write and optimize diverse SQL queries, working knowledge of RDBMS like SQL Server.

India

Implemented the project using the Waterfall Methodology to produce artifacts in the different phases of the SDLC.Redefined many attributes and relationships and cleansed unwanted tables/columns using SQL queries.● Imported the customer data into Python using Pandas libraries and performed data analysis - found patterns in data which helped make key company decisions.Utilized Power BI to create analytical dashboards that help business users get a quick insight into the data.Extracted data from Flat files, MS Excel, and Transforming as per the logic and loaded into Data warehouse.● Developed Power BI reports using Power Query from SharePoint & different Data sources.Involved in production fixes, and trend break analysis using SAS EG.Developed visually appealing and insightful Excel charts, graphs, and pivot tables to present data to stakeholders, aiding in better data interpretation and decision-making.Designed and maintained Excel templates and reports for various business functions, including finance, operations, and sales, resulting in streamlined reporting processes and improved data consistency.Performed Data Analysis and Data profiling using complex SQL on various source systems including MySQL.