Rahul Goyal

Business Development Executive

Delhi, India14 yrs 9 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

11 years of experience in business intelligence and data analytics.
Expert in developing interactive dashboards and KPI reports.
Strong background in financial analysis and regulatory compliance.

Stackforce AI infers this person is a Business Intelligence expert with a strong focus on data analytics in the Utility and Insurance sectors.

Contact

Skills

Core Skills

Business IntelligenceData ModelingData VisualizationData AnalysisFinancial Analysis

Other Skills

Analytical SkillsAnalyticsBusiness AnalysisBusiness AnalyticsBusiness InsightsDAXData ManagementData QualityData WarehousingDatabasesDecision-MakingETLEnglishExtract, Transform, Load (ETL)Financial Reporting

About

I am a professional with 11 years of experience in business intelligence, ETL, data extraction, cleaning, profiling and transforming, automation, compliance, designing and building scalable and effective data models, and enabling and implementing the advanced analytics capabilities into reports, interactive visualization and KPI dashboards for insight generation and analysis. Experience in P&C Insurance and Utility domain. Expertise in end-to-end data analysis, data analytics, MIS, reporting and visualization Expertise in Advanced Excel, VBA, SAS Base/Advanced, Oracle, PL/SQL, QlikView, Power BI Developer, Power BI Admin, Power Apps, MySQL, SSIS, Power Query, DAX Strong engineering professional with a Bachelor’s Degree focused in Information Technology from Netaji Subhas Institute of Technology, New Delhi, India

Experience

14 yrs 9 mos

Total Experience

4 yrs 11 mos

Average Tenure

7 yrs 5 mos

Current Experience

Landis+gyr

2 roles

Manager Business Intelligence

Apr 2022 – Present · 4 yrs 2 mos

Technical Lead

Dec 2018 – Mar 2022 · 3 yrs 3 mos

As a BI expert and part of Global IT team taking end to end charge of BI projects and work closely with stakeholders across the business on projects with dashboard development or data analysis.
Designing and building scalable and effective data models, and enabling and implementing the advanced analytics capabilities into reports, interactive visualization and KPI dashboards using multiple data sources on Power BI to track important KPI’s which helps stakeholders like Executives, Sales Team, Manufacturing Team, Product Team, etc. in decision making and also helps in improving the data quality.
Provide insights and recommendations by identifying, analyzing, and interpreting trends or patterns in complex data sets.
Collaborate with other technical and business teams to constantly learn and improve.
Designing, developing, and maintaining ETL packages to load data into centralized database using SSIS.
Building complex SQL queries to support data models in Power BI reports and dashboards.
Writing complex DAX functions and queries to derive complex measures and KPI’s.
Governance of Power BI dashboards and reports and optimization of data models used.
Handling and managing Power BI environment as Power BI Capacity Administrator, Power BI App Workspace Administrator and Power BI Service Administrator.
Technical documentation of technical solutions provided.

Business IntelligencePower BIETLData ModelingSQLDAX+1

Exl

Lead Assistant Manager

Aug 2016 – Dec 2018 · 2 yrs 4 mos · Gurgaon, India

Iffco- tokio general insurance co. ltd.

Assistant Manager

Aug 2011 – Aug 2016 · 5 yrs · Gurgaon, India

Optimizing cumulative summaries encompassing various data sources and carrying out various insightful analysis based on the inputs from Top Management like
Financial Analysis by identifying different KPI's across different Lines of Business (Fire, Marine and Miscellaneous) and then generates reports with actionable insights which support the key management decisions. Root cause analysis on the transactional data.
Portfolio analysis of various network channels of the organisation (like brokers, agents, etc.).
Fraud Cases are identified using different procedures.
Competitor analysis by comparing the data of other market players available on their respective websites
Developing and submitting number of statutory body reports like Public Disclosure of the Company,Monthly Reports,Quarterly Reports
Gather, analyze and synthesize relevant data in its raw form and convert it into presentable information containing actionable recommendations using SAS and Qlikview.
Conduct qualitative and quantitative analysis of the researched- structured and unstructured data.
Data analysis- data cleaning, data preparation and compilation.
Engage in brainstorming sessions to understand business problems and assist Heads in solution building.
Owning responsibility to strictly follow Month End close timetable to publish the Month End MIS & re-conciliation bringing about the day to day changes in it for the reviewing/controlling/reconciling.
Performing automation in SAS and Excel, thereby improving the productivity of the department.
Involved in various UAT’s when any change is required or new module needs to be created.
Creating business metrics which depicts the business across different segments and generating commission report for different channel partners.
Part of the dashboard training team, conduct time to time training sessions for users to educate them how to use of dashboards.