Goutham Prasad
Business System Analyst @BMO
Signup · Get unlimited contacts
WORK HISTORY
Business System Analyst @BMO
Toronto, ON, CA
Designed and developed data mapping and technical requirement documents for migrating data source systems from a legacy platform, ensuring a seamless data transition.• Created and executed SQL-based data validation scripts for target tables, achieving 97% balance reconciliation across multiple granularity levels for profit and loss validation during migration, enhancing data accuracy and integrity.• Served as a Data Architecture SME, drafting data modeling templates for source and consumption tables, streamlining data model design for US financial regulatory reporting, resulting in a 25% improvement in data reporting performance.• Developed and optimized SQL-based data transformation rules for 20+ target tables, facilitating source-to-consumption layer transformation, and conducted unit testing, ensuring high transformation accuracy and efficiency.• Acted as a liaison between source data teams and business owners, drafting a Service Level Agreement (SLA) defining data ingestion strategies, metadata management, data validation rules, and processing frequency.• Authored critical business artifacts supporting multiple data migration projects, including Technical Requirement Documents (TRDs), Data Requirement Documents (DRDs), Data Model Templates, and Data Governance artifacts.
EDUCATION
SCT College of Engineering
Bachelor’s Degree
Humber College
Postgraduate Degree
ABOUT GOUTHAM PRASAD
Business Intelligence and Data Analyst with over 6 years of experience in complex data environments, specializing in data extraction, manipulation, and analysis using Excel, Power BI, Tableau, SQL, and Python. Adept at transforming raw data into actionable business insights through interactive dashboards, statistical modeling, and data visualization. • Proficient in Advanced Excel, including Pivot Tables, VLOOKUP, Index-Match, conditional formatting, data validation, and complex formulas, enabling efficient data handling and reporting. • Skilled in Power BI and Tableau for dynamic dashboard creation, ensuring effective communication of key performance indicators (KPIs) to stakeholders. • Strong SQL expertise, leveraging MySQL and relational databases to perform data extraction, manipulation, transformation, and complex querying using CTEs, stored procedures, window functions, indexing, and partitioning to ensure data integrity and accuracy. • Highly skilled in Python for data analysis and ETL processes, utilizing Pandas, NumPy, Matplotlib, and Seaborn to perform data cleaning, transformation, and exploratory data analysis (EDA). • Experienced in automating and optimizing data processes using VBA, and developing interactive reports and dashboards in SSRS, significantly improving reporting efficiency. • Familiar with SAS for in-depth statistical modeling and data-driven decision-making. Basic knowledge of R Studio, IBM Cognos Analytics, and IBM SPSS, supporting data mining, statistical analysis, and business intelligence initiatives. • Adept in Agile methodologies, including Scrum, and experienced with JIRA for project tracking, sprint planning, and issue management, ensuring efficient collaboration and workflow optimization. • Strong problem-solving skills, attention to detail, and effective communication abilities, capable of working independently and collaboratively in cross-functional teams to meet tight deadlines.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.