Dhinesh Durairaju
Data Analyst @Publicis Sapient
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Publicis Sapient
Toronto, ON, CA
Wealth & Portfolio Data Migration:Led large-scale data migration for Wealth Management and Portfolio Management accounts from legacy platforms to Addepar, ensuring accuracy across account, billing, and fee datasets.Data Reconciliation & Validation:Performed end-to-end data reconciliation across billing groups, fee schedules, and portfolio structures, ensuring 100% alignment between source and target systems before production cutover.Billing & Fee Rule Verification:Validated complex billing group logic, fee calculations, and portfolio billing rules by working closely with Product Owners, SMEs, and Engineering teams across multiple test cycles.Automation & Data Processing:Used Python, SQL, and Excel (Power Query, VLOOKUP) to process millions of records, automate reconciliation workflows, and reduce manual validation effort by 40–50%.Defect Triage & Root Cause Analysis:Led data defect triage for migration issues related to portfolios, fees, and billing groups, resolving 95% of data-related defects before go-live.Reporting & Migration Sign-off:Delivered reconciliation reports, exception summaries, and data quality scorecards that improved migration sign-off efficiency by 30%+ and strengthened Wealth Management data governance.Cross-Functional Collaboration:Partnered with product, engineering, and financial SMEs to ensure migrated portfolio and billing data met regulatory, operational, and reporting standards.
EDUCATION
Sastra University
Bachelor's degree, Mechanical Engineering
Centennial College
Postgraduate Degree, Marketing Research and Analytics
Sheridan College
Postgraduate Degree, Marketing/Marketing Management, General
ABOUT DHINESH DURAIRAJU
With 3+ years of experience in Data acquisition, analysis, and visualization. Skilled in SQL, Power BI, and Tableau, with a proven track record of optimizing processes and delivering actionable insights that improve business decisionsAdvanced skills in Tableau and Proficient in designing, developing, and scheduling reports/dashboards using Tableau Dashboard/ServerMastery of Excel functionalities including data modelling, analysis, reporting, Pivot Tables, Power Query, and Macros for sophisticated data manipulation and automationStrong presentation skills using Microsoft Office tools (Word, Excel, PowerPoint) to communicate complex data insights to stakeholders effectivelyEfficient in working with various data sources and databases, including structured and unstructured data, cloud-based platforms, and REST APIs, ensuring seamless data integration and high accuracyKnowledge in Azure Data Factory for orchestrating complex data workflows, integrating data from diverse sources, and automating ETL processes to ensure seamless data operationsStrong command of Python, NumPy, Pandas, SciPy, matplotlib, and SQL for data manipulation, complex query writing, and comprehensive data analysisSkilled in streamlining ETL workflows and automation, with extensive SSIS experience ensuring seamless data integration and delivering predictive dashboards to boost operational efficiencyProven ability to lead cross-functional teams through more than 20 Agile sprints, consistently delivering high-quality data insights ahead of deadlines while effectively collaborating with team members and stakeholders, presenting outcomes clearly and effectively
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.