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)
PowerBI
SQL Server
SQL
Advanced Excel
Python Programming
Business & Data Analysis
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)