Varun Agrawal

Experience

• 

  Aricent Technologies Holdings Limited.(Flextronics Software)

  Jun 2006 - Jul 2006

  Internship

  Created Resource Allocation System for maintaining the records of resources (mobiles, charger, data cables) and their current status, thereby increasing the ease in issuing and releasing the resources to the users

• 

  Capgemini Engineering

  Aug 2007 - Oct 2010

  Senior Software Engineer

  • Responsible for requirement analysis, design, development, testing and implementation of middleware and application software• Automated and tested new features into the IMS (IP Multimedia Subsystem) network and developed an understanding of IMS network elements and services• Gathered requirements from Vodafone, UK, the client and customised Testing Platform• Led four engineers for the creation of an application server for functional testing of server

• 

  CPA Global

  Oct 2010 - Feb 2018

  Senior Consultant

  • Led the research & consulting projects involving Market & Industry Analysis, Customer Analysis, Strategy Analysis, Product & Service diagnostics and Trend Analysis• Market Research Skills: Technology Landscape, Technology Trends, Competition Analysis, Market Research & Business Strategy. Advanced Web/Internet-based searching/research & data mining skills for business intelligence & insights. Extensive experience in assisting Sales & Business development teams by conducting using market/customer targeted research• Delivered Strategic & Analytical Reports for business strategy supported by analysis & trends on product, services, market size in key markets and customers• Prepared growth strategy & account plans through revenue/cost analysis• Prepared Tableau BI & excel dashboards including insights, business metrics, R&D data, Technology intelligence reports, gap analysis, landscapes, technology whitespaces, KPIs, financial performance, operations data etc• Research project management including proposal writing, methodology, design, and implementation of primary & secondary research, data analysis, and report writing• Performed advanced Web/Internet-based research & data mining for business intelligence for providing market research & BI using multiple data sources such as databases, publications, government agencies (e.g. Security exchanges), legal databases, industry & academic journals and company sources• Training & Development Skills: Experience in training and leading team of senior-analysts, analysts and executives to deliver complex projects with tight deadlines. Possess a self-starter attitude, excellent time management, and communication skills• Preparation of project estimates/proposals, managing multiple clients of various high-tech & med-tech domains, directly leading (quality-check/review) a team of 7-10 people Show less

• 

  RMIT University

  Jul 2018 - Jan 2019

  Market Intelligence & Insight Analyst

  • Developed and implemented end-to-end student data extraction, collection, consolidation, cleaning, transformation and visualisation solutions• Led the student database transformation and verification from iApply to StudyLink• Developed and maintained data of the prospective student journey, starting from the initial point of enquiry, through to student commencement• Extracted data from databases (iApply, TAC, VTAC, StudyLink), surveys, rankings and external data, transformed data (i.e. cleaning, wrangling, etc) using SQL and loaded data in the central database• Enriched analysis, monitored market & education sector and added context to findings using data from the central database for colleges, stakeholders and marketing campaigns• Translated disparate online and offline marketing data into actionable insights• Implemented automations for data cleaning and transformation using R scripts and excel• Created and maintained operational recruitment dashboard visualisations in BI tools• Developed attribution modelling for marketing effectiveness analysis• Generated data, provided analysis and recommendations required by International and the wider University to inform decision-making • Recommended new internal and external sources of data and information, and methods, to improve analyses, and demonstrate their likely benefits and challenges• Collaborated, cleaned and published data from databases, surveys & external data using SQL, R and Tableau/excel dashboards to monitor education sector• Identified opportunities for improvement of data analysis solutions Show less

• 

  National Australia Bank

  Jan 2019 - Oct 2019

  Senior Data Consultant

  • Designed and implemented NAB’s Change the Bank Dashboards for Executive Leadership Team and the Board which aids strategic decision making and tracks NAB’s achievement of business strategy• Liaised with business, stakeholders and end-users for loading, extracting, transforming and validating data• Analysed raw data, drawing conclusions and developing recommendations• Developed data analytical databases from complex financial source data by manipulating, cleansing and processing data• Supplied qualitative and quantitative data to colleagues & stakeholders• Prepared and analysed supporting materials to drive discussion at strategic decision-making forums such as the Strategy Steering Forum• Identified data and developed strategy for an optimal method of cleaning the data Show less

• 

  Interactive

  Oct 2019 - Apr 2022

  Data & Reporting Analyst

  • Developing and implementing BI solutions• Close working with business heads on solution proposals• Collaborating with business users to determine individual BI requirements• Manipulating and modelling data sets provided to business users within agreed timeframes and according to requirements.• Identifying opportunities to improve existing processes and solutions• Identifying and enabling automation of key reports, data sources and processes were possible• Leading ad-hoc projects as required within agreed timeframes Show less

• 

  NCS Group Australia

  Apr 2022 - now

  Manager of Business Intelligence

  UniSuper (Power BI Lead)• Proposed and implementing Power BI Architecture• Encourage best practices in code versioning, collaboration, CI/CD, testing• Building and maintaining data pipelines that provide features for consumption data analysis/visualisation• Developing and implementing BI solutions• Building and maintaining reporting solutions with consideration of robustness, low-cost operation, accessibility and access patternsAEMO (Power BI Lead)• Power BI Admin• Development of PBI design and development best practices • Stakeholder engagement and requirements gathering • Data analysis and solution design • Data modelling and design Show less