POWERBI
Experienced data professional with 4+ years of expertise in Python, SQL and PowerBI. Proven track record in developing impactful data-driven dashboards, conducting in-depth financial analyses, market research and consistently enhancing business decision-making through data-driven insights.
• Built AI-powered price prediction model using ML algorithms and R, with 95% accuracy in forecasting regional home values.
• Deployed enterprise-wide Power BI dashboards with Microsoft Fabric and Power Automate, enhancing reporting efficiency.
• Automated financial reporting through VBA macros & Excel automation, reducing report generation time by 40%.
• Led the successful ERP data migration project, ensuring 100% data integrity through robust validation frameworks.
• Engineered Python and SQL-based ETL pipelines for real-time data ingestion, reducing processing time by 60%.
• Crafted Power BI dashboards with ETL pipelines, Semantic Models & Azure Synapse for efficient data management.
• Revamped and launched two software products by leveraging SDLC principles and Agile methodologies.
• Spearheaded comprehensive UAT testing, ensuring software met end-user requirements & reduced post-launch defects by 20%.
• Innovated and launched an AI-driven chatbot, improving client satisfaction and streamlining customer interactions.
• Optimized data pipelines and visualizations, driving a 50% increase in factory productivity.
• Streamlined data workflows by centralizing sources into a single data mart for efficient Power BI and Tableau reporting.
• Led financial modeling, budgeting, and sales forecasting for affordable housing projects, enhancing profitability.
• Contributed to MSI study, analyzing 117 key metrics with Tableau, Python, R, and SQL, securing USD 0.2M in CER savings.
Relevant Projects Extraction and Analysis of Annual Report Text
• Utilized Python within Jupyter Notebook and developed a text analysis software to extract strategic insights from over 25 annual reports spanning 20+ companies, offering invaluable guidance for stakeholders' strategic decision-making processes and implemented sentiment analysis using Python on extracted data.
Air Quality Monitoring Web Application
• Developed full-stack web application for real-time air quality insights with comprehensive data views, API integration, and SQL for dynamic updates using Azure Cloud, .NET Framework, HTML, C#, SQL, and Visual Studio Code.
Personalized Movie Streaming Enhancement
• Spearheaded improvements in personalized movie streaming using The Movie DB API, Python, Azure Databricks, SQL, R, & Tableau prep builder.
• Managed Azure SQL database setup for efficient data extraction, transformation, and loading. Visualized API data using Tableau.
Real Estate Trends Visualization
• Employed Tableau to visualize US Real Estate Market trends by scraping data using Python from websites. • Conducted comprehensive analytical investigations using ETL Tools, RStudio, Python, and Tableau.
Machine Learning for Purchase Behavior Prediction
• Yielded a substantial 96% recall score in accurately predicting purchase behavior from website activity using XGBoost and Logistic regression with optimized parameters using machine learning algorithm. translating findings into actionable strategies to potentially increase sales and customer engagement.
Market Shaping Indicators (MSI) Development
• Led collaborative Market Shaping Indicators (MSI) development across Asian countries. Utilized Tableau, Python, R and SQL to collect & analyze 117 key indicators, aiming to stimulate investment in housing markets.
POWERBI
Tableau
Python
ArcGIS
SQL
Real Estate
Crypto