Culinary, Biking
PANKHIL AGARWAL
Business Analyst
Ballerup
Summary
I am an enthusiastic professional eager to contribute my analytical expertise to a dynamic team in Copenhagen. Since relocating to this vibrant city on 01/01/24 to support my husband's career at Novo Nordisk, Denmark. I am keen on leveraging my three years of experience in the IT industry. My background is rich with involvement in diverse development phases and the implementation of Reports and Visualization, utilizing cutting-edge Business Intelligence Tools. Known for my collaborative spirit, resilience, and diligent work ethic, I excel as both a team player and an independent performer.
Overview
3
3
years of professional experience
1
1
Language
Work History
IT BUSINESS ANALYST
KOTAK MAHINDRA BANK
12.2021 - 12.2023
- knowledge within KYC case management system
- Experience documenting processes (As- Is)
- Documentation of KYC processes in the old and new system.
- Testing of KYC functionality in an app involves verifying that all aspects of the KYC process work as expected. This includes user experience, document verification, risk assessment, data security, and compliance with regulations.
- Document upload verification.
- We have establish and maintained a CIP to verify customer identities.
- Ensured proper risk-based approach to categorize customers and transactions based on their risk profiles.
- Financial institutions must report suspicious transactions to the Danish Money Laundering Secretariat.
- Institutions are required to retain records of transactions and customer information for a minimum of five years.
- Develop Power BI reports and Effective dashboards after gathering and translating end user requirement
- Experience in creating multi Dashboards and graphs
- Experience in creating calculated measures and columns with DAX in Power BI Desktop
- Connect to different Data Sources from Power Bl
- Created Power BI reports with Table, Matrix, Card, Area Chart, cluster bar chart, column chart, Tree map, Multi card etc.
- Applying built-in functions for various data manipulations (e.g., text, date, number functions)
- Publish Reports
- Identifying and resolving errors within the query editor to ensure data integrity
- Develop business architecture using requirements such as scope, processes, alternatives, and risks
- Analyze client's business requirements and processes through document analysis and workflow analysis
- Conduct different levels of testing including functional, regression, user acceptance, integration, and performance to verify the client's needs are met
- Facilitate monthly meetings with clients to document requirements and explore solutions
- Translate stakeholder requirements into different tangible deliveries, such as functional specifications, user stories, happy workflow, process diagrams, and data flow/ data model diagrams
- Handled project along with team in creating dashboards, presentations and graphs
- Preparing interactive reports according to business requirement in time restricted environment
- Responsible for testing the requirement before going live to production.
ASSOCIATE DATA ANALYST
XL DYNAMICS INDIA PVT. LTD.
10.2020 - 12.2021
- Reviewed the loan documents to identify the triggers associated with the loan and performed the analysis based on the tests suggested under the document
- Gathered necessary credit information and evaluated mortgage loan requests in order to approve or deny applications
- Handled clientele in the US mortgage Industry
- Provided reports and documentation on all loan activities to the management.
Education
MBA (FINANCE) -
MIT-WPU, PUNE
B.COM - undefined
GOVERNMENT GIRLS COLLEGE, MANDSAUR
HSC - undefined
ST.THOMAS.SR.SEC.SCHOOL
SSC - undefined
ST. THOMAS. SR. SEC. SCHOOL
POWER BI AND TABLEAU FOR DATA VISUALIZATION - undefined
03.2024 - 05.2024
SCRUM MASTER CERTIFICATE COURSE - undefined
02.2024 - 05.2024
MICROSOFT OFFICE SPECIALIST, MICROSOFT - undefined
05.2016 - 05.2016
THE COMPLETE FINANCIAL ANALYST COURSE - undefined
11.2019 - 05.2019
NISM SERIES XV - RESEARCH ANALYST - undefined
03.2023 - 05.2023
MICROSOFT POWER APPS COURSE - undefined
05.2024 - 05.2024
Skills
MICROSOFT OFFICE (WORD, EXCEL, POWERPOINT, OUTLOOK)
Personal Information
- Date of Birth: 12/04/96
- Nationality: Indian
- Visa Status: Approved
Interests
Culinary, Biking
Passionate about baking a variety of treats, including cakes, muffins, cupcakes, chocolates. Constantly experimenting with new recipes and techniques. Regularly participate in local baking competitions and events. Baking not only allows me to express my creativity but also teaches me patience, precision, and attention to detail.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
MICROSOFT POWER APPS COURSE - undefined
05.2024 - 05.2024
POWER BI AND TABLEAU FOR DATA VISUALIZATION - undefined
03.2024 - 05.2024
SCRUM MASTER CERTIFICATE COURSE - undefined
02.2024 - 05.2024
NISM SERIES XV - RESEARCH ANALYST - undefined
03.2023 - 05.2023
IT BUSINESS ANALYST
KOTAK MAHINDRA BANK
12.2021 - 12.2023
ASSOCIATE DATA ANALYST
XL DYNAMICS INDIA PVT. LTD.
10.2020 - 12.2021
THE COMPLETE FINANCIAL ANALYST COURSE - undefined
11.2019 - 05.2019
MICROSOFT OFFICE SPECIALIST, MICROSOFT - undefined
05.2016 - 05.2016
MBA (FINANCE) -
MIT-WPU, PUNE
B.COM - undefined
GOVERNMENT GIRLS COLLEGE, MANDSAUR
HSC - undefined
ST.THOMAS.SR.SEC.SCHOOL
SSC - undefined
ST. THOMAS. SR. SEC. SCHOOL
Similar Profiles
Sveta KakerlaSveta Kakerla
DEPUTY MANAGER - Product Manager: Risk Monitoring at KOTAK MAHINDRA BANK- Kotak 811DEPUTY MANAGER - Product Manager: Risk Monitoring at KOTAK MAHINDRA BANK- Kotak 811
Deepali JagdaleDeepali Jagdale
Senior Manager - Analytics at Kotak Mahindra BankSenior Manager - Analytics at Kotak Mahindra Bank
Shubham ManeShubham Mane
Data Analytics at Kotak Mahindra BankData Analytics at Kotak Mahindra Bank