Deepika Lohani
Melbourne,Australia
Summary
Results-driven professional with extensive experience across diverse industries, specializing in KPI development and data visualization. Proven track record in enhancing reporting accuracy and fostering stakeholder engagement, leading to significant operational improvements. Proficient in Power BI, Qlik, and SQL, with a strong focus on delivering actionable insights and driving strategic initiatives.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Investment Portfolio Lead
ANZ
Melbourne, VIC
11.2024 - 11.2025
- Created customized Qlik dashboards for user personas, delivering insights on KPI trends for Portfolio Governance.
- Analyzed data gaps in key metrics, ensuring comprehensive KPI coverage with targeted recommendations.
- Engineered role-based dashboard views, enhancing user experience while maintaining data confidentiality.
- Executed mapping of data lineage across multiple systems, improving accuracy of weekly billing reports.
- Sourced and documented business rules for efficient end-to-end impact assessments during feature modifications.
- Coordinated with cloud migration teams to assess data architecture for potential AWS migration.
- Elicited business requirements for reporting solutions aligned with quarterly cycles and security protocols.
- Provided guidance to colleagues, fostering a collaborative work environment.
Senior Analytics and Insights Specialist
Kiwibank
01.2020 - 09.2024
- Defined banking relationship metrics to analyze customer behavior for primary bank selection.
- Established baseline metrics to evaluate impact of engagement activities and promotions.
- Enhanced data maturity capabilities, resulting in 12% increase in salary deposits within 3 months.
- Conducted analytics to assess deposit opportunities in NZ business market, identifying $250 million growth potential.
- Facilitated story mapping sessions with stakeholders to gather requirements and create milestone plan for continuous value delivery.
- Led prototype development, user acceptance testing, and provided mentorship for junior team members.
- Achieved 10% reduction in operational risk events and increased productivity by 200 hours monthly.
Senior Reporting Analyst
Nielsen
05.2018 - 12.2019
- Created comprehensive business requirement documents and established detailed project scope with milestones.
Coordinated efforts with cross-functional team for efficient report migration to Web.
Generated real-time insights on pricing, product mix, and brand dynamics.
Evaluated promotions alongside competitive products in the category for strategic advantage. - Collaborated with cross-functional teams to enhance reporting accuracy.
- Streamlined reporting processes to improve efficiency and consistency.
Consultant
KPMG
03.2016 - 05.2017
- Enhanced pricing strategy effectiveness through execution of comprehensive pricing analytics.
- Uncovered market trends by analyzing patent databases for innovation potential.
- Summarized research findings and proposed strategies in comprehensive reports.
- Identified trends by analyzing complex information from various sources.
- Developed strategic recommendations based on diverse industry data analysis.
- Managed multiple projects focused on patent analysis using advanced analytics methodologies.
Technical Analyst
Accenture
10.2012 - 05.2014
- Established a robust development framework by crafting technical and functional design documents.
- Conducted thorough analysis of business requirements to deliver targeted technical solutions.
- Implemented system testing and quality assurance protocols, ensuring all functionalities met established standards.
- Designed modules and reports for data migration, incorporating SQL queries for effective reconciliation.
Education
MBA -
Institute of Management And Technology
India03.2016
B.Tech - Computer Science
Jaypee University of Information And Technology
India05-2012
Skills
- Business analysis and KPI development
- Insights generation
- Data visualization
- Stakeholder engagement
- Power BI, Tableau, and QlikSense
- SQL, SSRS, and SSAS
- Python programming
- Databricks platform
- Excel and Alteryx tools
- Azure DevOps and JIRA management
Certification
AWS Cloud Practitioner, 12/01/23
Timeline
Investment Portfolio Lead
ANZ
11.2024 - 11.2025
Senior Analytics and Insights Specialist
Kiwibank
01.2020 - 09.2024
Senior Reporting Analyst
Nielsen
05.2018 - 12.2019
Consultant
KPMG
03.2016 - 05.2017
Technical Analyst
Accenture
10.2012 - 05.2014
MBA -
Institute of Management And Technology
B.Tech - Computer Science
Jaypee University of Information And Technology