Ankush Sharma Email & Phone Number

• Data Analyst with 3+ years of expertise, adept in SQL for performing complex ETL processes, including optimizing queries, managing subqueries, executing data joins, and applying window functions for detailed analysis• Proficient in Python programming and scripting, employing libraries like Pandas, NumPy, Matplotlib, Seaborn, and R for thorough data analysis, manipulation, and visualization, driving strategic business decisions. Skilled in VBA and SAS for automating data tasks and analysis• Specialized in Data Visualization using tools such as Power BI, Tableau, and Looker, crafting interactive and insightful dashboards and reports to enable data-driven decision-making by presenting complex data clearly and attractively• Advanced Excel capabilities, including pivot tables, VLOOKUPs, macros, and sophisticated formulas, to conduct detailed data analysis, automate repetitive tasks, and improve reporting precision and efficiency• Experienced in Database Management and Optimization with hands-on experience in MS SQL Server, SSIS/SSRS, and Snowflake, proficient in query optimization, database design, and implementation, ensuring efficient data retrieval and processing• Skilled in Data Cleaning and Wrangling, addressing missing values, performing data transformation and normalization, and ensuring data integrity and accuracy for high-quality analysis using ETL tools and Azure• Proficient in Data Analysis & Modeling utilizing Power Query, DAX, and machine learning models to derive insights, forecast trends, and support strategic decision-making• Experienced in implementing Machine Learning techniques such as linear regression, logistic regression, and decision trees to predict trends and identify patterns, aiding in business forecasting and strategic planning• Strong foundation in mathematics and statistics, with expertise in probability theory, hypothesis testing, inferential statistics, and descriptive statistics, ensuring rigorous analysis and validation of data findings• Familiar with ERP systems, particularly SAP, to streamline business processes and integrate data across various functions• Proficient in using CRM software to analyze customer interactions throughout the lifecycle, enhance business relationships, and drive sales growth• Effective communicator and collaborative team player with exceptional problem-solving skills, critical thinking, and adaptability, capable of working cross-functionally with business stakeholders, IT teams, and management to define analytics requirements and deliver timely data-driven solutions

• 

  Data Analyst

  Cibc

  Nov 2020 - Present - Canada

  • Analyzed customer transaction data to enhance personal banking services and improve customer experience. Utilized SQL for efficient data extraction and transformation from diverse customer data sources, leading to more targeted and effective customer engagement strategies• Developed interactive Power BI reports to visualize customer behavior and product usage trends. Created custom DAX measures to provide actionable insights, enabling better decision-making for product development and marketing campaigns• Automated data processes using Python and Flask, improving efficiency in portfolio management within Wealth Management. This reduced manual tracking by 70%, allowing for more accurate and timely financial analysis and reporting• Conducted Exploratory Data Analysis (EDA) to identify patterns and trends in investment data. These insights supported strategic investment decisions and enhanced portfolio performance for Wealth Management clients• Analyzed trading data and investment banking activities to support trading strategies. Optimized SQL queries to enhance the performance of financial transaction databases, resulting in faster and more reliable data retrieval for Capital Markets• Designed and maintained data warehouses with Informatica PowerCenter to ensure data quality for insurance policies and claims. Utilized advanced Python programming for data cleaning and processing, leading to improved decision-making in underwriting processes and fraud detection• Implemented complex ETL processes using Power Query to ensure accurate analysis of risk data. Analyzed credit risk and market risk data to support risk management strategies, and defined and tracked Key Performance Indicators (KPIs) for risk assessment and compliance