Summary
Overview
Work History
Education
Skills
Core Signature Skills
Professional Certifications Awards
Timeline
Generic

Amit Mishra

Power BI Senior Data Analyst
Singapore

Summary

Experienced BI Analyst with 11+ years in SAS, Power BI & Python. Skilled in data modeling, reporting & analytics for BFSI. Expert in KPIs, risk, compliance & delivering actionable, data-driven insights.

Overview

12
12
years of professional experience
2012
2012
years of post-secondary education
2
2
Languages

Work History

Senior Business Intelligence Analyst

Persolkelly Singapore Pte Ltd
04.2024 - Current
  • Have developed PowerBI reports with the migrated data based on the earlier report in Qliksense.
  • Reduced use of excel by automating reports using Power BI for DBS Martech team.
  • Real-Time Marketing Campaign Analysis Report : Develop a comprehensive Power BI dashboard that provides real-time insights into marketing campaign performance, allowing stakeholders to make informed decisions based on live data. Improved campaign ROI by 6.75% within 3 months.

Senior Consultant 2

Ernst & Young Global Consulting Services
10.2022 - 12.2023
  • Utilized SAS Data Integration Studio and SAS Visual investigator skills to design, develop, and implement robust solutions to enhance the transaction monitoring process and contribute to the overall security of financial activity in Singapore.
  • Fraudulent Transaction Detection and Analysis Dashboard : Develop a sophisticated Power BI dashboard to analyze and visualize fraudulent transactions in real time, enabling financial institutions to detect, respond to, and mitigate fraudulent activities effectively.
  • HR Dashboard for Employee Insights for EY Data & Analytics team (Internal Project) : Built a centralized dashboard integrating HR data (attendance, attrition, headcount) from multiple Excel sources. Result: Reduced team leads manual effort by 70% and improved accuracy in monthly headcount reporting.

Senior Consultant

Capgemini
01.2021 - 09.2022
  • Spearheaded a high-performing SAS Middleware DevOps team overseeing 200+ processes, optimizing data retrieval, manipulation, and report generation with exceptional efficiency and precision.
  • Drove SAS Windowing environment to code for around 200+ processes using base and advanced SAS programming in which reading of data was done from different sources (like API, Databases & External Files) and manipulating and generating reports and output based on the requirement.
  • Have undertaken projects involving SAS built framework, which required coding with error handling. The tasks included data validation, cleaning, and output file creation in a three-part process, enhancing data quality for cross-team utilization.

SAS Analyst Programmer

NMG Consulting
12.2019 - 12.2020
  • Drove success in the NMG Insights program, delivered market research to insurance/reinsurance firms, and assessed critical factors such as customer satisfaction, relationship management, underwriting and claims experience, technology, and products.
  • Integrated SAS graphs to generate the trends of the insurance and reinsurance company based on the survey conducted by NMG Consulting and provide insight to the client.
  • Creating different SAS graphs like Bar charts, Box plots, Quadrant plots for different clients and across different parameters using SAS. Extensively using SAS macros for automation of whole process.

Data Analyst

AIG
10.2017 - 12.2019
  • Orchestrated the creation of pricing actuarial profitability data for diverse business towers, derived from insurance transactional data and aligned with pricing actuaries' logic; automated quarterly processes, implementing robust data validation and reporting mechanisms to promptly identify and address any alterations in the data.
  • Have introduced error handling using SAS EG to make the code work in all possible scenarios.
  • Worked in Agile environment to deliver the adhoc analytical tasks with high quality.

Data Analyst

Equifax
05.2016 - 10.2017
  • Spearheaded ad-hoc data analysis requests, entailing source identification, aggregation, meticulous data cleaning, and reporting through SAS EG.
  • Created Demonetization data at PAN India level depicting aggregated deposited amount by each customer and their personal and demographical details. This data was used for many adhoc analysis and reporting purposes by bank higher management.
  • Created locker dashboard using VBA and excel-SAS add-ins by cleaning, aggregating and processing data in SAS server using SAS EG and automating front end process using excel VBA.

Software Developer

Syntel
08.2013 - 02.2016
  • Innovated a universal ETL process in SAS EG, streamlining multiple ETL jobs simultaneously. Led the migration of the Selective Acceptance B2B model from SAS to R.
  • Implemented automated process for User on-boarding into the SAS system as per ONCOP compliance for American Express bank. Also worked on created ONCOP Stored Procedure using SAS EG, which provides new user addition, existing user update/removal/exception with the secure access over data across the system as per the ONCOP compliance defined by bank’s policy.
  • Created a generic ETL process which can be used for multiple ETL jobs at the same time in SAS using SAS EG.

Education

B.Tech. - Electronics and Communication Engineering

Faculty of Science and Technology (ICFAI University)

Skills

SAS Programming(Base&Advance)

undefined

Core Signature Skills

  • SAS Programming(Base&Advance)
  • PowerBI
  • SQL Server
  • Python Programming
  • Data Analysis
  • SAS Data Integration (SAS DI)
  • ETL Processes

Professional Certifications Awards

  • Base SAS Certified, NWP44VE1BE1413SG
  • AWS Cloud Certified Practitioner
  • Statistics Professional Certified from Edureka, AYE592ER
  • Employee of the Quarter award from AIG

Timeline

Senior Business Intelligence Analyst

Persolkelly Singapore Pte Ltd
04.2024 - Current

Senior Consultant 2

Ernst & Young Global Consulting Services
10.2022 - 12.2023

Senior Consultant

Capgemini
01.2021 - 09.2022

SAS Analyst Programmer

NMG Consulting
12.2019 - 12.2020

Data Analyst

AIG
10.2017 - 12.2019

Data Analyst

Equifax
05.2016 - 10.2017

Software Developer

Syntel
08.2013 - 02.2016

B.Tech. - Electronics and Communication Engineering

Faculty of Science and Technology (ICFAI University)

Similar Profiles

CREATE PROFILE
Amit MishraPower BI Senior Data Analyst