Power Bi Business Intelligence
Resume:
MICHAEL LEVDANSKI
Edgewater, New Jersey
***************@*****.***
Objective: Dynamic and results-driven Power BI Developer with extensive experience in business intelligence and data analytics, seeking a full-time or consulting role. Eager to leverage advanced expertise in Power BI, Excel VBA, and data visualization to deliver impactful business intelligence solutions that drive data-driven decision-making and enhance operational efficiency.
Summary
●Lead technologist in business intelligence for healthcare global institutions, Nomura Bank, Deutsche Bank, Credit Suisse Bank, Lehman Brothers Holdings, the United States Department of Education, and Unilever Companies, specializing in designing and implementing advanced BI solutions.
●Experienced Power BI Developer with advanced proficiency in creating interactive dashboards, reports, and data models for data-driven decision-making.
●An early adopter of Data Lakes methodology for advanced data analysis and business intelligence solutions, enabling efficient handling of structured and unstructured data.
●Skilled in implementing Data Warehousing solutions and integrating Databricks for scalable data processing and analytics.
●Proven ability to integrate Excel VBA and Python, with Power BI for seamless automation and data transformation.
●Expertise in designing end-to-end BI solutions, including data extraction, transformation, modeling, and visualization, with powerful data storytelling.
●Adept at integrating Data Lakes with Power BI, SQL Server, and Python for enhanced data storage and analytics capabilities.
●Strong background in financial modeling, regulatory compliance (SOX, Dodd-Frank), and structured reporting systems.
●Experience with Azure Data Lake, Azure Synapse, Google BigQuery, and AWS Redshift.
●Power BI Service for publishing dashboards, setting up workspaces, and managing user access via Power BI Gateway.
Key Skills
●Power BI: Dashboard design, data modeling, Python/Pandas integration, DAX calculations, and publishing reports.
●Excel VBA: Advanced programming for automation, modeling, and data manipulation. UNIQUE AND POWERFUL METHODOLOGIES of integrating Excel with Power BI.
●Data Integration: Data Lakes, Databricks, SQL Server, SharePoint, API connections, and real-time data feeds.
●Data Warehousing: Design, implementation, and optimization of data warehouses for structured analytics.
●Data Transformation: Power Query, Python, ETL processes, and Databricks pipelines.
●Reporting Tools: Power BI, SSRS, Cognos, Tableau.
●Agile Methodology: Sprint planning, scrums, and cross-functional collaboration.
Professional Experience
Consultant – Power BI & Excel VBA Specialist Various Alternative Investment Firms and Hedge Funds, and the US Department of Education.
Jan 2017 – Present Remote/On-site/Hybrid
●Designed and implemented Power BI dashboards for portfolio performance, risk analysis, and operational metrics, providing actionable insights to portfolio managers and executives.
●Automated manual reporting processes using Excel VBA, improving efficiency and accuracy in valuation, portfolio tracking, and compliance reporting.
●Created scalable Data Warehousing solutions to consolidate and analyze large datasets from trading platforms, market feeds, and internal systems.
●Integrated Data Lakes methodology to handle unstructured financial data, enabling advanced analytics for alternative investment strategies.
●Collaborated with clients to develop customized DAX measures and Power BI reports tailored to specific hedge fund strategies, including long/short equity, credit, and quant funds.
●Designed reusable Databricks pipelines to streamline data ingestion, transformation, and analytics for fund performance and market data.
●Conducted training sessions for investment teams on leveraging Power BI and Excel VBA for data visualization, automation, and business intelligence.
Nomura Holdings LLC Power BI Developer / Excel VBA Specialist
July 2014 – September 2016 Midtown NYC
●Developed and maintained Power BI dashboards to monitor trading and valuation systems, integrating data from Data Lakes, SQL Server, and Excel.
●Pioneered the use of Data Lakes methodology for storing and analyzing real-time trading and market data, ensuring scalability and efficiency.
●Migrated legacy Excel VBA applications into Power BI, integrating with Databricks for advanced data analytics.
●Designed reusable Power BI data models and DAX measures for scalability across departments.
●Automated reports in Power BI and SSRS, supporting compliance with Dodd-Frank and other regulations.
●Enhanced real-time data pipelines using Databricks and SQL Server, integrating seamlessly with Power BI dashboards.
●Led multi-regional Agile scrums to prioritize BI development and manage projects effectively.
Lehman Brothers Holdings, Bankruptcy Proceedings Power BI & Data Automation Consultant
Nov 2009 – Jan 2014 Midtown NYC
●Built dynamic Power BI dashboards for senior management reporting, leveraging Data Warehousing solutions for consolidated trade data.
●Streamlined data integration between Power BI, Python, SQL Server, and Excel for pricing and valuation systems.
●Supported the unwinding of structured products by designing Power BI visualizations for key financial metrics and trade analytics.
●Enhanced existing Excel VBA tools to integrate seamlessly with Power BI for real-time analytics.
Deutsche Bank AG BI Developer / Excel VBA Specialist
Oct 2007 – Nov 2009 New York, NY
●Created industry-renowned Excel VBA tools integrated with Power BI and Data Lakes for collateral and valuation reporting.
●Automated financial reporting systems, allowing efficient visualization in Power BI dashboards.
●Developed a Power BI framework to monitor collateral interest recoveries, recovering $260M for the bank.
●Implemented scalable Data Warehousing strategies, improving performance and reliability for data storage and reporting.
●Collaborated with stakeholders to migrate Excel VBA applications to Power BI and integrate Databricks pipelines for advanced analytics.
Credit Suisse (formerly CSFB) Assistant Vice President, BI Solutions & Excel VBA Specialist
June 2004 – Oct 2007 New York, NY
●Led the migration of over 500 Excel-based trading books to a strategic C#/SQL Server platform, introducing Data Warehousing and Power BI prototypes for derivatives visualization and reporting.
●Developed Excel VBA applications for the Front Office and Middle Office to reconcile complex derivatives data, later integrating with Power BI dashboards and Data Lakes.
●Spearheaded compliance efforts to ensure SOX regulations were applied to BI and Excel VBA solutions, gaining government approval for processes.
●Designed and implemented Power BI reports for derivatives price testing, yield curve
Computer Skills
●Power BI: Data modeling, Python, DAX, Power Query, custom visualizations.
●Excel VBA: Very Advanced Automation, one of the top 20 specialists in the US.
●Python: Data analysis with NumPy, pandas; script integration with Power BI.
●Data Lakes & Warehousing: Architecture, integration, and analytics.
●Databricks: Pipelines, scalable data processing, and ETL workflows.
●SQL Server: Queries, stored procedures, triggers, data modeling.
●Data Feeds: Bloomberg, Reuters, Totem, SharePoint integration.
Education
Advanced IT Specialist Training
●Learning Tree, New York
●Focused on advanced IT methodologies and business intelligence tools, including Power BI and Excel VBA.
Computer Science Degree
●Ukraine
●Completed comprehensive courses in computer science, covering data analysis, programming, and systems architecture.
Lean Six Sigma Training
●Credit Suisse Bank, New York
●Completed coursework in Lean Six Sigma methodologies, emphasizing process improvement, efficiency, and quality management principles.
Anti-Money Laundering IT Specialist Training
●Deutsche Bank, New York
●Specialized training in AML compliance technologies and data analytics for monitoring and reporting suspicious financial activities.
Microsoft Embedded Partner Certificate for Excel VBA and Power BI - This program is designed for partners developing embedded solutions using Windows technologies. It allows partners to customize intelligent systems that gather, store, and process data for business intelligence applications.
Contact this candidate