Samrat Dey

Experience

• 

  Supertech Limited

  Apr 2016 - Jun 2016

  Summer Intern in HR

  Analyzing issues related to employee engagement and developing and conducting surveys to determine factors of employee engagement in relation to department, gender differences, tenure, work experiences etc, and investigating reasons for varying engagement levels. Investigating competencies required at each level for each department in order to design competency framework for the organization.

• 

  Cognizant

  Jun 2017 - Jan 2021

  Business Analyst

  Client-facing roles involving development of analytics-based real time solutions to generate business insights and create value. Works on data visualization tools like Tableau and Microsoft Power BI to develop real time dashboards showing critical metrics and data analytics; complemented with advanced application of R and Python coding in data cleansing and restructuring, automating tasks, process mining, text mining, machine learning and other areas of data analytics.For a leading US financial services company: • Created real time reports on Tableau and MS Power BI to show analytics for business processes like money movement processes, financial advisor recruitments and client onboarding, automated tool performance metrics, resource utilization and cost variance etc.• Created the R code for real time data extraction as well as data cleansing, calculation of additional parameters and application of process mining on output data to generate process flow maps and process mining insights.For a Swiss multinational investment bank and financial services company:• Created dashboard views using R and Tableau for daily reporting of business parameters, process movement and reworks for business processes.For a UK based multinational investment bank and financial services holding company:• Created R based automated reconciliation tool for monthly trades’ data to reconcile between broker and bank sides.• Created Tableau based reports for reconciled/unreconciled trades’ brokerage (broker by trader) according to client requirements. Show less

• 

  Deloitte

  Jan 2021 - now

  Leading Analytics, Dashboard and Automation pod to identify opportunities, develop and implement automation and analytics solutions with focus on generating account value and vastly reducing or eliminating manual effort and time consumed in repetitive operational tasks. Exploring tools like Tableau, MS Power BI, Python, VBA Macros etc. to build and leverage skills to execute complex projects across accounts in GPS. Leading cross-functional and cross-industry collaboration efforts in developing and knowledge sharing on innovative solutions. Supporting project management operations in team. Exploring Generative AI tools in automation. Show less Created automated solutions for analysis of team performance, utilization, open roles, recruitment process, roster updating, email generation, pipeline data integrity concerns, account planning etc.• Developed Tableau dashboard to track team members’ allocation and utilization percentages across multiple accounts, sectors, and segments.• Developed automated solution for data extraction, consolidation and dashboard visualization for annual account planning activity related quantitative and qualitative data across 80 accounts in the GPS sector.• Developed and maintained multiple other Tableau as well as excel based dashboards across accounts/sectors to track staffing, recruitment, client relationships, pipeline opportunities etc.• Developed macro-based Excel trackers to track team pipeline bandwidth availability, deliverable quality scores• Developed Python-based automation for pipeline opportunity data integrity reporting process for 10 accounts, reducing time and manual effort involved by 99% and saving ~ 20 FTE hours on weekly basis.• Developed Python-based automation for Outlook distribution list management process for 30 accounts, reducing time and manual effort by 90% and saving ~ 60 FTE hours on a periodic basis.• Developed Python-based automation for web scraping for 30+ account newsletters, reducing time and manual effort by 70% and saving ~ 15 FTE hours on weekly basis.• Developed Python-based automated solutions for report generation and outlook email automation across accounts.• As pod leader of sub team, took responsibility of allocating projects to team members, quality reviews, training, supervision and guidance on team roles and responsibilities.• Conducted detailed hands-on technical training sessions on Tableau Desktop for 80+ team members across multiple teams.• Was involved in multiple organization-wide initiatives focused on gathering and implementing innovative ideas related to automation/process improvement across multiple teams. Show less

  • Assistant Manager

    Sept 2023 - now

  • Senior Analyst

    Jan 2021 - Aug 2023