Anmol Trakru Email & Phone Number

Virginia, United States

Data Detective & PBI Dev: Transform complex data into actionable insights and compelling dashboards, while brainstorming new ideas daily to drive business success through innovative data solutions.Skills: Stakeholder Management, Snowflake, Power BI, Power Automate, SQL, Python, Data Visualization, ETL processes, and advanced analytics.

Toronto, Ontario, Canada

Skills: Data Analysis · Consulting · Python · SQL · Azure Databricks · Power BI

Toronto, Ontario, Canada

Toronto, Ontario, Canada

● Responsible for migration of analytical capability from SAS to Python by developing models (Back testing of (PD) per portfolio, Risk-weighted assets, etc.) in Python that includes the entire life cycle of projects – data extraction from RDBMS, data cleaning, exploratory data analysis, transitioning from framework of BASEL III, and modelling. Delivered recommendations/alternatives to address problems faced by SAS● Developed Internal Ratings (IG) model for Transportation Infrastructure borrowers. Introduced qualitative factor to address external factors. Automated the validation process using Python which reduced the manual effort of comparing various files● Validated various bank models such as PD (Probability of Default), LGD (Loss Given Default), EAD (Exposure After Default) for retail/wholesale/transportation models. Validations include testing in areas of data, BASEL III framework, outcome analysis, process accuracy, and governance ● Liaison with External consortiums such as GCD (Global Credit Data) to gather historical defaults data and work closely across multi-departments to capture additional credit data collection for stress testing, back testing models, Benchmarking of current predicted PD, EAD and LGD for named counterparties and specific banking book clusters. It helped in fostering impressive time and relationship management skills ● Created GUI automation tool in Python to compare tables from RDBMS and extract/display the rows where data has changes. This tool is widely used to check the integrity of data being used and has reduced the time lag of validation process● Showed excellent communication and quick learning skill by leading multiple presentations to teams of managers from different departments. Showcased great team player characteristics as group work required coordination with team members and helped in brining different ideas to the table and stepped up where the team was lagging behind

Roles & ResponsibilitiesCPG Client: • Market Mix Modelling - Quantifying the impact of several marketing inputs on Saleso Created a roadmap for future strategy by defining how to plan or adjust Client’s marketing budget and channels, as well as other tasks such as creating pricing and distribution strategies and countering the competition.o Developed advanced statistical models like Generalized linear model (GLM) and Hierarchical Linear Regressions o Identified the marketing channels such as TV, digital media or others that will result in maximum returns o Prepared dashboards to deliver a comprehensive snapshot of performance by analyzing huge amount of data o Simulation & Optimization tool: Forecast sales trend as per current marketing mix plan; Predict sales impact subject to planned increase/drop in advertising/price/distribution

Roles & ResponsibilitiesNetwork Client:• Optimal network plan to cater the demand across technologies (2G/3G/4G), maintaining customer experience through capacity and throughput management• Transformation of multiple components viz. Game Theory, Particle Swarm Optimization, Genetic Algorithm, Segmentation and Financial modeling – maximum NPV & ROI to a single structured solution• Optimal Spectrum evaluation to reduce traffic at the busiest hourEnergy Client:• Developed analytical solutions using Predictive Modelling techniques like Random Forest, Decision Trees & Logistic Regression with strong feature engineering to detect and raise malfunction alarms prior to occurrence of failures of equipmentInternal Client:• Developed Optical Character Recognition program for the HR department that automatically stores all essential information of employees in a comprehensive format utilizing Python, Geometric Transformation, Image Thresholding, Morphological Transformation, Canny Edge Detection, TesseractOverall:• Analytical Solution Design: Travel to multiple geographies to partner with clients and build the data science driven solution framework, implementation blueprint, and technical architecture• Stakeholder Management: Translate complex data into actionable insights that aid in making critical business decisions and vend the same to clients in workshops

Master Of Business Administration - Mba

Business Analytics, Analytics

IVY Professional School- Business Analytics IVY is ranked in the top 10 institutes for Big data and Analytics schools in the country.

Bachelor’S Degree, Economics

Activities and Societies: Member of National Service Scheme society

High School, Business/Commerce, General

Activities and Societies: Football and Basketball Team. E-gaming Team. Dramatics Team.