01Professional Core
Financial & Business Analytics
Portfolio performance, credit risk, structured finance, KPI monitoring and business reporting.
FINANCIAL & BUSINESS ANALYTICS PROFESSIONAL
Structured Finance • Business Intelligence • Macroeconomic Research • SQL · Python · Tableau · Power BI
Turning complex data into decision-ready insight.
I am a financial and business analytics professional with experience across structured finance, portfolio reporting, credit analytics and risk assessment. I use SQL, Excel, Python, Tableau and Power BI to build dashboards, analytical frameworks and clear business narratives.
My work sits at the intersection of financial analytics, business intelligence, macroeconomic research and automation.
Selected work includes country-risk frameworks, structured-finance reporting, macroeconomic dashboards, automated monitoring tools and research-led visual analysis.
ANALYTICAL SYSTEM
DATAMODELDECISION
One connected portfolioDashboards · frameworks · automation · research
02Professional Core
Data Preparation & Quality
Cleaning, validation, joins, anomaly checks, missing-value review and business-rule creation.
03Professional Core
Business Intelligence
Interactive dashboards, reporting systems and decision-support tools built around practical questions.
04Demonstrated Work
Macroeconomic Research
Country comparisons, stability frameworks, scenario analysis and public-data interpretation.
05Developing
Geopolitical Analysis
Independent research on strategic affairs, economic exposure and geopolitical transmission channels.
06Developing
Automation
Python, APIs, refresh workflows and AI-assisted tools used to make analysis more repeatable.
EXPERIENCE
Financial analysis grounded in operating detail.
Selected roles and the analytical work behind them—not a duplicate résumé.
01
Oxane Partners
Senior Analyst — Platform Solutions
Developed structured-finance and private-credit reporting solutions for international banking and investment clients.
- Portfolio dashboards for borrowing bases, covenants, waterfalls and collateral performance
- Advanced SQL using CTEs, window functions, stored procedures and dynamic SQL
- KPI analysis across ABS, private-credit and specialty-finance portfolios
02
Apollo Global Management
SOX Audit Analyst
Supported enterprise control testing, financial-reporting processes and data validation across investment-management operations.
- Testing across 30+ entity-level controls
- Walkthroughs, evidence validation and external-audit support
- Control-gap identification using Excel, Salesforce and Analytics Studio
03
Rubix Data Sciences
Credit & business information
Supported credit-risk and business-information analysis, including company-level scoring and dashboard reporting for a portfolio exceeding ₹500 crore.
- Analysed financial and non-financial indicators for credit assessment
- Supported scoring dashboards and structured company research
- Improved risk reporting through clearer indicator presentation
04
Genpact
Analytics & operations
Supported data-analysis and reporting workflows using Excel, Salesforce and Analytics Studio.
- Cleaned and interpreted operational datasets
- Built recurring reports and analytical views
- Supported data accuracy and stakeholder reporting requirements
PROJECTS
Models, dashboards and tools built around real questions.
Every case shows the challenge, the analytical approach and the decision value.
Research Framework
Stability Index
A multi-dimensional framework comparing countries across economic strength, governance, social development, hard power and climate resilience.
Case study: Challenge → Approach → Output → Insight
- Challenge
- How can national resilience be compared without reducing it to one economic metric?
- Approach
- Normalised diverse indicators, applied transparent weights and benchmarked countries across five dimensions.
- Output
- Country scorecards, comparative dashboards and a presentation-ready index.
- Insight
- Stability is an interacting system; economic scale alone does not guarantee resilience.
Research Framework
Macro-Financial Index (MFI)
A global assessment of economic resilience and fragility using inflation, debt, growth, unemployment, external balances and reserves.
Case study: Challenge → Approach → Output → Insight
- Challenge
- Which economies appear robust on headline growth but remain vulnerable underneath?
- Approach
- Used inverse indicators, min-max normalisation and weighted scoring to create comparable macro-financial profiles.
- Output
- A ranked fragility model with indicator-level diagnostic views and a 13-page research deck.
- Insight
- External buffers and policy space can matter as much as headline GDP growth.
HMX
Scenario Framework · Data Feed PendingScenario framework completed · Public dashboard temporarily paused pending a licensed market-data feed.
Strait of Hormuz Risk Monitor
A scenario lab connecting disruption in the Strait of Hormuz with oil, gold, USD/INR, Asian currencies and equity-market sentiment.
Case study: Challenge → Approach → Output → Insight
- Challenge
- How could a regional chokepoint disruption translate into business and macroeconomic risk?
- Approach
- Separates observed market data from ceasefire, partial-disruption and major-closure assumptions, then maps transmission across India, China, Japan and South Korea.
- Output
- Scenario framework completed. Public dashboard temporarily paused pending a licensed market-data feed.
- Insight
- The largest second-order effects may appear through currencies, freight, inflation and import dependence—not only oil prices.
Prototype
India Monsoon Macro Dashboard
An automated view linking rainfall patterns with crop stress, food inflation, rural demand and market risk.
Case study: Challenge → Approach → Output → Insight
- Challenge
- How can scattered weather data become an early macroeconomic signal?
- Approach
- Connected regional rainfall data to agricultural and inflation-sensitive indicators through repeatable refresh workflows.
- Output
- A regional monitoring dashboard with interpretable risk signals.
- Insight
- Rainfall deviation becomes more useful when translated into crop, price and demand exposure.
GGI
Live Project
Green Gas India
A data-led initiative connecting waste management, rural income, clean energy and investable biogas projects.
Case study: Challenge → Approach → Output → Insight
- Challenge
- How can local organic waste be reframed as energy, soil value and economic opportunity?
- Approach
- Mapped feedstock, conversion, outputs, stakeholders and first-site readiness gates.
- Output
- A concept dashboard and investor-policy conversation deck.
- Insight
- The opportunity is strongest when site, feedstock, operator and offtake are designed as one system.
Completed Dashboard
Live Job Opportunity Dashboard
A verified job-opportunity operating system tracking role fit, priority, location, source and direct application links.
Case study: Challenge → Approach → Output → Insight
- Challenge
- How can a noisy job market become a focused, verifiable shortlist?
- Approach
- Verified direct job descriptions, categorised fit and priority, and structured roles into a filterable decision dashboard.
- Output
- A live working dashboard with priority, NCR and remote-India views.
- Insight
- Job-search data becomes useful when every lead is verifiable and tied to an explicit decision rule.
CAROUSELS
Complex global stories, made structured and accessible.
Published visual narratives only. Unverified titles and unfinished concepts are kept off the public portfolio.
A Kargil Vijay Diwas special tracing the lessons of 1999 through India’s defence modernisation, indigenous capabilities and military posture in 2026.
India’s trade concentration, regional opportunity and a practical case for diversification across the Global South.
Exports, energy security, manufacturing, infrastructure and the reforms shaping India’s long-term growth opportunity.
A visual 2024–25 comparison of the scale, structure and direction of trade in the United States and India.
Two diversification trajectories: one established early, the other transforming at scale through investment and reform.
The physical-resource systems underneath the AI economy—and why infrastructure constraints still shape technological power.
How decentralised biodigesters can turn waste into energy, strengthen sanitation and reduce dependence on imported gas.
MEDIUM ARTICLES
Writing about the systems beneath the headlines.
Published Medium articles only. Drafts and unverified titles are excluded from the public view.
Geopolitics & Security
Made in Japan, Found in Russian Missiles
The hidden supply-chain routes through which civilian and dual-use technology can sustain Russia’s war machine.
Published on MediumRead
India & Indo-Pacific
The Forgotten Gateway
How Indonesia’s geography, trade links and strategic position are making it an increasingly important partner for India.
Published on MediumRead
India & Politics
Who Captured India’s Student Protest?
How a legitimate grievance over the NEET leak evolved into a wider political confrontation—raising questions about influence, funding and control.
Published on MediumRead
Geopolitics & Security
Russia’s Silent Power
How Russia’s naval posture is turning pressure from the Ukraine war into a broader warning across the Arctic.
Published on MediumRead
India & West Asia
From Chabahar to Cyprus
India’s emerging geopolitical powerplay across West Asia through ports, partnerships, connectivity and strategic access.
Published on MediumRead
CONNECT
Interested in financial analytics, business intelligence, macroeconomic research or data-driven storytelling?
Let’s discuss the work, a role, or a problem worth analysing.
ROLE-ALIGNED RESUMES
Choose the version closest to the opportunity.
The underlying experience remains consistent; each version changes the emphasis for a specific role.
Business Analyst
Business intelligence, requirements, KPI reporting, dashboards and stakeholder-focused analysis.
Open resumeFinancial Analyst
Structured finance, portfolio reporting, credit analysis, controls and investment reporting.
Open resumeResearch Analyst
Financial research, market intelligence, macroeconomic analysis and analytical storytelling.
Open resumeAbout the work
Vikram Analytics is an independent portfolio documenting analytical work created through professional experience, self-directed research and practical experimentation. Confidential employer and client information is not reproduced.
Independent research focuses on macroeconomics, geopolitics and strategic affairs; it is presented as developing research practice, not as senior geopolitical expertise.