Shamshuddin M. Email & Phone Number

Canada

• Collected and integrated data from multiple internal and external sources, including financial, CRM, and website analytics, ensuring data accuracy and consistency for comprehensive analysis• Cleaned and transformed raw data using advanced Excel techniques, ETL processes, and Power Query, optimizing data quality and preparing datasets for detailed analysis• Conducted in-depth data analysis and statistical inference using Python and SQL, identifying key trends, patterns, and correlations that informed business strategies• Developed complex SQL queries in SQL Server for customer segmentation and ad-hoc analysis, enhancing data-driven decision-making for targeted marketing• Visualized data using Power BI and Tableau, creating user-friendly dashboards that effectively communicated complex data insights to business stakeholders• Produced comprehensive reports in Excel using Power Query, identifying key insights and areas for improvement in marketing and campaign strategies• Played a key role in the migration of CRM to Microsoft Dynamics, assisting with user testing, data reconciliation, and reporting, ensuring a smooth transition• Monitored and reported on key performance metrics, leveraging data insights to evaluate the success of financial products and services, guiding strategic adjustments• Designed and managed interactive dashboards on Power BI, integrating data from various sources like social media, financial systems, and website analytics to support decision-making

Canada

• Developed and maintained financial models using Excel, incorporating key metrics and financial scenarios to evaluate the impact of business decisions• Collaborated with finance teams to streamline month-end and quarter-end reporting processes, enhancing the accuracy and timeliness of financial reports• Conducted variance analysis on budget vs. actual financial performance, providing detailed insights and commentary to senior management• Performed exploratory data analysis (EDA) on customer transactions, including EFT, EMT, bank drafts, cash, and cheque transactions flagged for potential fraud, analyzing transaction time, client characteristics, and purchasing patterns to identify suspicious activities• Maintained and updated Tableau dashboards to monitor key performance indicators (KPIs) such as fraud detection confusion matrix, transaction anomalies, false positive rates, and true positive rates, providing insights into CIBC’s client financial behavior

Hyderabad

• Performed daily cash management tasks, including tracking accounts, processing payroll, allocating wages, and reconciling cash and bank transactions• Maintained and processed invoices, financial records, deposits, and money logs, ensuring timely and accurate documentation of all transactions• Monitored financial updates, maintained watch lists, and organized insurance files to support accurate reporting and compliance• Assisted in expanding the client base by networking and fostering relationships, encouraging clients to explore new financial opportunities

Master Of Business Administration - Mba, Project Management

Bachelor'S Degree, Business/Commerce, General