Ruchi Agarwal Email & Phone Number

Toronto, On, Ca

Greater Toronto Area, Canada

Toronto, Ontario, Canada

• Subject matter expert on all Reference Data for liquidity reporting for global cross divisional projects• Provided technical expertise across a broad range of data analysis functions including data modelling, visualization, data profiling, data quality and reconciliation, report design, and other specialized data management functions• Built a robust and streamlined process to ensure accurate market data based on regional market fluctuations across multiple workstreams leading to… Show more • Subject matter expert on all Reference Data for liquidity reporting for global cross divisional projects• Provided technical expertise across a broad range of data analysis functions including data modelling, visualization, data profiling, data quality and reconciliation, report design, and other specialized data management functions• Built a robust and streamlined process to ensure accurate market data based on regional market fluctuations across multiple workstreams leading to improved data quality and coverage• Served as an authority on a given business domain and provided business expertise to place context around analytics discovery and inform recommendations• Presented and communicated generated insights ranging in complexity and recommended business actions to stakeholders/ business leaders in governance meetings• Built Tableau corporate scorecards for senior management for monthly insight on various business KPIs• Provided strategic and tactical solutions for risk and treasury business, with strong focus on formulating, designing, and delivering IT solutions in the Securities lending and Financing areas• Called out data/process related problems and communicated to relevant teams in a timely manner and make recommendations for resolution• Worked autonomously and accountable for acting as a lead within a specialized business management function and may provide work direction to the team• Managed a global multi-functional team and responsible for hiring, training and development Show less

Toronto, Canada Area

Working for CIBC Mortgage, Lending, Insurance & Deposit Technology - I am involved in developing, maintaining and enhancing the data warehouse for lending and insurance banking products and reports for regional market comparisons, sales and market penetration trends.I leverage technical and business acumen to effectively communicate and extract work from the team within the planned budget and time.I work with Business on cost and time efforts for project initialisation and… Show more Working for CIBC Mortgage, Lending, Insurance & Deposit Technology - I am involved in developing, maintaining and enhancing the data warehouse for lending and insurance banking products and reports for regional market comparisons, sales and market penetration trends.I leverage technical and business acumen to effectively communicate and extract work from the team within the planned budget and time.I work with Business on cost and time efforts for project initialisation and conception. I collaborate with Business and SMEs in gathering and understanding business requirements.My role also focuses on optimising and tuning performance of code processes at both database and ETL levels. I have developed and led various PoCs with business & developers to evaluate feasibility of solutions. Show less

Mumbai, Maharashtra, India

Worked for CIBC where I was involved in handling and executing Business Intelligence Project involving – Requirement Gathering, System Analysis, Estimation, Risk Identification, Documentation, Designing and Developing ETL scripts, Timely & Defect free deliveries/ implementation.I had performed Initial Data and Impact Analysis of the business requirements for both new and enhancement requirements and built architectures for Data management, Data warehousing and Data migration. I also… Show more Worked for CIBC where I was involved in handling and executing Business Intelligence Project involving – Requirement Gathering, System Analysis, Estimation, Risk Identification, Documentation, Designing and Developing ETL scripts, Timely & Defect free deliveries/ implementation.I had performed Initial Data and Impact Analysis of the business requirements for both new and enhancement requirements and built architectures for Data management, Data warehousing and Data migration. I also developed stored procedures and complex ETL processes and monitored their performances and implemented data acquisition and reporting with significant project worth. Show less

Kolkata Area, India

Worked for Toyota Financial Services where I built diverse data marts like Marketing, Customer, Sales, Product Profitability and Accounting. I also demonstrated ability to design, build and document Data Warehouses using modelling and analysis tools, ER diagrams, logical and physical data models, dimension models as well as unstructured data analysis service-oriented business.I was involved in setting up a new architecture/framework – Data Quality & Reconciliation, which was used to… Show more Worked for Toyota Financial Services where I built diverse data marts like Marketing, Customer, Sales, Product Profitability and Accounting. I also demonstrated ability to design, build and document Data Warehouses using modelling and analysis tools, ER diagrams, logical and physical data models, dimension models as well as unstructured data analysis service-oriented business.I was involved in setting up a new architecture/framework – Data Quality & Reconciliation, which was used to perform data reconciliation to keep a check on data loss between source and target and check for quality of data between source and target based on predefined set of parameters.I also set up a Metadata Lineage framework that serves as table dictionary to be looked up by business for reference which helped business identify the lineage of each column for all tables in the data model across files and report dashboards. Show less

Master Of Computer Applications (M.C.A.)

B.C.A, Computer Engineering

Education record

Education record