Expert Data Analytics - Advanced Calculator, Dashboard, and KPIs
I developed my expertise by building applications, pricing calculators, spreadsheets, dashboards and reports for quants, traders and risk managers for banks including JP Morgan, Deutsche Bank and other financial institutions.
I am an expert in analyzing businesses based on the internal and third-party data and then developing the custom KPI business metrics relevant to help them develop and grow. It does not matter if the data is financial or operational.
My expertise in Business Intelligence has helped a wide variety of SMBs clean up their data environment and integrate multiple sources into insightful dashboards to help streamline marketing, operations and finance.
Technologies:
- Power BI, Power Query, Power Pivot, Advanced Excel / VBA Macro Development
- Python [Scrapy, Pandas, BeautifulSoup, Selenium, InstaPy]
- C#
- SQL [ETL (Extract Transform and Load), Stored Procedures & Functions, Complex Joins and Queries, Query Optimization, Views]
- Ruby on rails
- Wordpress
- Google Analytics
- Google Data Studio
- Other Business Intelligence platforms
Domain Expertise:
- Financial Pricing and Risk Models
- E-commerce Operations
- Marketing Analytics
- Financial Market Data
- Insurance Rating Models
- Lead Conversion Analysis
- ETF/Index Calculators
- Bespoke Business Pricing Calculators
Industries helped:
- Venture Capital
- Real Estate Acquisition, Development and Marketing