Fraud Data & Credit Data management using SAS Viya, Google Cloud Platform, Amazon Web Services.

BI/ETL Developer at Canadian Western Bank • Develop new ETL pipelines into EDW & Report into Datamart for the Business Intelligence environment and support or fix an existing Jobs, Stored Procedures, Scripts under the AML - Financial Crime Data Hub using primarily SAS DI, T-SQL, LSF, PowerBI. • Responsible for analyzing business requirements, gap analysis, planning and provide end-to-end solutions design within standard frameworks and best practices, coding, testing, documentation, deployment and UAT support for data foundation. • Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed a solution meeting defining the specifications, Modeling, Logical Database Design and needs. • Hands on experience using T-SQL in constructing tables, indexes, Stored Procedures and complex queries for data manipulation, data mining, data profiling and fixing Historical data in EDW. • Responsible to tune the scripts by using various method and functions such as CTE, Temp Tables, Aggregate Function and Window Functions. • Design the Test Plans, Test Cases and Developed a Stored Procedures using T-SQL for TDD Unit testing In SQL Server Management Studio. • Responsible for Database-based migration (Dev, Test, Prod) using TFS as a tool for source control. • Responsible to plan, monitor projects and create/maintain the Kanban Board, Work Order, PBI and individual task using TFS. • Perform and support daily tasks such as job scheduling, monitoring, troubleshooting and remediation in Production

• Analyzed Sales data, transaction logs, and other POS related metrics to identify trends, patterns and anomalies.• Extract insights to support decision making processes related to inventory management, sales strategies and customer behavior.• Generate regular and ad hoc reports summarizing key performance indicators (KPIs) such as sales revenue, transaction volume, average ticket size, and product performance. • Present findings to management and stakeholders to inform strategic business decisions.• Implemented real-time data updates and refresh mechanisms to ensure that the POS dashboard reflects the most current information available.

Worked with company leaders to bring out analytical data for their upcoming products.Developed research document with using visualisations to present better understanding.

• Individually worked on ESI processing, including data transfer, inventory, and extraction using the EDRM pipeline. Ensured eDiscovery tools operate optimally for user satisfaction. Performed OCR/Tiffing as per client requests.• Conducted database migrations from legacy database including preparation and quality control of export and load files; writing, executing and troubleshooting SQL scripts; communication with vendors on various steps of projects; review and quality control of databases.• Providing Data Management services including the execution, logging and management of data acquisitions, ingestion, processing and loading of electronic data. Document production in various formats, data decommissioning and archiving.• Led the identification of errors in load files and eDiscovery tools, liaising with vendors for technical issues. Collaborated with teams for swift problem resolution. Ensured our eDiscovery practices meet industry standards. Conduct regular checks to uphold production capacity.• Crafted automation scripts in MS SQL for Relativity platform enhancement. Excelled in integrating Windows Server with eDiscovery tools.• Prepared and managed custom reports to assess the export in terms of duplication and redundancies.