Ankit Sahu Data Analytics Consultant & Tutor
No reviews yet

I am a seasoned freelance data analytics teacher who is a passionate and reliable data analytics professional with over 8 years of experience working in a fast-paced agile environment. Proficient in data warehousing, data modeling, data analysis, visualization, business process improvements, research, business acumen, and problem-solving. Expertise in understanding and communicating insights from huge, complicated data sets to both technical and non-technical team members with experience in leading multiple innovative projects and teams. My extensive experience spans both industry and academia, and I am dedicated to sharing my knowledge and skills with individuals seeking to excel in the world of data analytics. With a track record of successful teaching engagements and a deep passion for data, I offer a wealth of practical insights and hands-on guidance to help learners master this essential discipline.

Tech Stack-
Visualization tools – Tableau, Power BI, JReports, Einstein Analytics (With Server Management)
ERP & CRM – Salesforce, Optymyze, SAP, Microsoft Dynamics 365, SAP, Workday.
ETL – Informatica ILM, SSIS, Salesforce, Tableau Prep, Alteryx, Power Query, Power Automate.
Cloud – Microsoft Azure, GCP, Salesforce, Snowflake (EDW), HDFS, Data Bricks
Languages, Databases & API – SQL, Python, (Pandas, NumPy, Matplotlib, Seaborn, Pyodbc, Tensorflow, Scikit-Learn, Keras), R, SAS, SQL Server, PostgreSQL, Oracle, MS Access, Google APIs, Uber APIs, Tableau server client API, Kepler.gl, Google Analytics, Excel, SAP- Tcodes, Hive, Impala, Hadoop
Areas of competencies – Data visualization and analytics, RDBMS, Machine learning, Predictive Modeling, Market Research, Campaign Analytics, A/B Testing, Data profiling, Data Modelling, Data Warehousing, Data Archival, Data Integration, Project Management, and Leadership.

Subjects

  • Data Visualization Beginner-Expert

  • Alteryx Beginner-Expert

  • Business Intelligence Beginner-Expert

  • Microsoft Power BI Beginner-Expert

  • Tableau Desktop and Server Beginner-Expert

  • Machine learning Python Beginner-Expert

  • Tableau, Python, Data science Beginner-Expert

  • SQL and Data warehousing Beginner-Expert

  • Azure DataBricks Beginner-Expert

  • Power Automate Beginner-Expert

  • Azure Synapse Beginner-Expert

  • SQL/PL and SQL Beginner-Expert

  • Tableau Dashboards Beginner-Expert

  • Tableau Server Beginner-Expert

  • Complex SQL Query writing Beginner-Expert

Experience

  • Senior Business Intelligence Analyst (Oct, 2022–Present) at TD Bank Group,Toronto,Canada
    • Mentored and trained the data analytics team, fostering a culture of continuous learning and professional growth, resulting in improved team performance and higher-quality analytics deliverables.
    • Led the implementation of a new business intelligence platform, resulting in a 30% increase in data accessibility and a 20% reduction in report generation time.
    • Spearheaded a comprehensive data analysis project to identify high-traffic ATM locations, resulting in the strategic relocation of 20 underperforming ATMs to prime locations, increasing transaction volume by 25% within six months.
    • Collaborated with the Marketing team to analyze customer transaction data and identify peak usage periods, leading to the implementation of targeted marketing campaigns, and resulting in a 15% increase in ATM usage during off-peak hours.
    • Developed and maintained interactive dashboards to track ATM performance metrics, enabling the management team to make data-driven decisions promptly and respond to issues proactively.
    • Conducted an in-depth analysis of transaction patterns and customer demographics, leading to the introduction of personalized marketing messages on ATM screens, resulting in a 5% increase in cross-selling opportunities.
    • Initiated a data quality improvement program to ensure the accuracy and completeness of ATM data, leading to more reliable analytics and better-informed decision-making across the business.
  • Tableau Data Visualization Consultant (May, 2022–Oct, 2022) at Westjet Airlines Canada
    • Implemented best practices around design thinking, Business Intelligence development which played a key role in the digital transformation phase for the Sales technology team and provided workshops and trainings across the organisation to make users familiar with the technology and how to utilize it to the optimum.
    • Measured fare market share to determine the actual likelihood % of customers opting WestJet over other airlines across regions of service which helped the key account managers to manipulate and build new contracts for agency and corporate partners.
    • Troubleshoot technical issues for the technology team by providing leadership and guidance to resolve the problem within the databases using DB visualizer and dashboard development using Tableau to implement complex algorithms and logic.
    • Enhanced the existing self-serve business intelligence solutions to align with the current strategy and prioritised the reporting solutions requests using technologies like R, SQL to make sophisticated analytical products.
    • Lead a team of 5+ data analysts to deliver executive projects which had high stakes among the stake holders which helped boards to make multi million dollars deals to provide best and affordable airline experience to our customers.
  • Senior Business Intelligence Developer (Mar, 2019–Apr, 2021) at LKQ Corporation
    • Analysed key performance indicators by producing intuitive dashboards using Tableau and SQL Server databases, which educated 7 category managers to modify product prices, resulting in a 10 % increase in margin.
    • Integrated different departments data from AS400 and other repositories into the SQL Server data warehouse by collaborating with ETL and DB teams by incorporating rule to pull relevant data for addressing business problems in analytics.
    • Worked with the DW Development teams, to implement data strategies, build data flows and develop conceptual data models to establish standards around flexibility of the data model to ensure deviations are within established guard rails.
    • Build highly collaborative relationships with internal stakeholders (leadership and executives) and external stakeholders (external consultants) to understand current challenges and overall business goals to set us up for future success through insight driven strategy.
    • Designed report delivery infrastructure based on Python by integrating Tableau server, SQL Server Database, and Outlook, allowing the system to run with 100% accuracy and saved 200 monthly hours of manual reporting.
    • Designed critical and high usage dashboards and projects, which had a high volume of daily data flow, including daily refresh of extracts with around 50 millions rows in less than 8 minutes.
    • Classified the products in the inventory as fast, medium, slow and dead selling using machine learning techniques of logistic regression to increase cashflow by 15%.
  • Business Intelligence Engineer (Jul, 2018–Mar, 2019) at Graphene Services PTE lTD
    • Prepared management reports defining the problem using business forecasting, segmentation analysis, and data mining and documented the analysis and recommended courses of action to determine the best outcomes.
    • Estimated time and effort for the development of solution and created user stories for request in order for the team to understand the who’s, what’s and why’s for every customer thus eliminating the communication gap by 100%.
    • Managed customer relationship and ensured that there is complete transparency by engaging them in Salesforce CRM to capture information and data accurately so that ETL team can load data without any severity.
    • Analysed data from Cipla's various medical representatives to construct a tale about how the breath-free campaign to sell their medicines functioned in the form of a dashboard that provided insight in only 3 clicks.
    • Guided development of complex dashboards, custom reports, and published to the server with data security while maintaining data analytics standards, discard manual reporting, and data refresh processes, resulting in savings of 200 hours of manual effort.
    • Designed end-to-end frameworks for all the dashboard which included reusable workflows, derived data tables, standardised templates and documentations to enhance scalability, allow flexibility for ad-hoc requests, and increase performance, which helped to clear the backlog of 15 dashboard requests in the quarter.
  • Data Analyst/Engineer (Sep, 2015–Jul, 2018) at Cognizant technology solutions
    • Performed data modelling design, and data mapping and created and maintained large, complex logical and physical
    data models, and metadata repositories using Informatica and SSIS to archive data into warehouses saving 90% on-premises
    storage.
    • Executed and maintained source-to-target data flow of different healthcare applications DB into EDW by mapping
    the data to its metadata and designing the ETL job flows accordingly, making smooth data flow from raw to staging
    to DW tables.
    • Created database objects such as tables, views, stored procedures, and indexes to accommodate complex integrity
    constraints and implement complex business rules.
    • Established organized databases, reviewed, and analyzed data from multiple internal and external sources – SQL
    querying and manipulating data and an understanding of data modeling for creating and maintaining datasets, reducing redundancy by 60%.
    • Constructed data warehouses by moving raw data from different repositories into staging and then into the star
    schema in their respective facts and dimension tables using Informatica ILM to enable the client’s analytics and data
    retrieval capabilities.
    • Delivered dashboard walk-throughs training sessions, presentations, and documents to all the existing and new
    users, which increased the usage of the reports to 100%.
    • Prepared cyclic reports for executive leadership by writing SQL procedures, and Tableau action functionalities to diagnose and help clients determine the cause of a positive or negative outcome by making data and documents
    accessible in one click.
  • Freelance Bi/Analytics Teacher (Feb, 2012–Present) at 10+ years of experience in freelance teaching Online / Offline
    • Applied different data cleaning techniques in R like MICE, KNN, and MissForest on a complex dataset to find the
    best approach.
    • Discovered optimal strategy for a complex dataset using a range of data imputation techniques, including MICE,
    KNN, Median, and MissForest.
    • Used the Scikit-Learn package of Python to apply various binary classification algorithms, such as Logistic
    Regression, Decision Tree, SVM, KNN and Naive Bayes to detect spam emails.
    • To locate and compare the cities with the similar air quality pattern, the time series AQI dataset was clustered using
    the K means, DBSCAN, OPTICS algorithm and seasonality was detected using Fast Fourier aTransform.
    • Used R programming and its packages such as psych and factoextra to perform descriptive analysis, factor analysis,
    and correspondence analysis on the APS personnel census to examine the leadership styles that are important for
    creativity in public organisations.
    • Using Azure Machine Learning Studio, created and deployed an Azure ML pipeline for data preparation, exploratory
    data analysis, statistical analysis, and logistic modelling.
    • Created and deployed an Azure ML pipeline for Image pre-processing and recognition using PyTorch and ResNet
    modelling.
    • Developed best practices on data normalization using log transformation and scalar transformation to further
    process the data as per the problem statement defined based on the objective of the business.
    • Pre-processed the data by imputing the missing values, encoding the categorical variables, splitting the dataset
    based on features and by feature scaling the independent variables using MinMaxScaler to perform the modelling.
    • Developed dashboard for International Finance corporation by using Tableau to track approval timeline of global
    pipeline investments to increase portfolio by 30 million dollars.
    • Linked pipeline companies and contract documents in dashboard by embedding hyper link action in Tableau to
    access confidential data securely and quickly making it 100% secure and compliance
    • Structured mobile/Tablet version of Fintech Portfolio Dashboard using tableau so that users can access it on
    different devices making it dynamic.
    • Integrated data in Salesforce by building recipes and workflows for transformations and consumed these data in
    Tableau CRM (Einstein Analytics).
    • Using Azure Machine Learning Studio, created and deployed an Azure ML pipeline for data preparation, exploratory data analysis, statistical analysis, and logistic modelling.
    • Created and deployed an Azure ML pipeline for Image pre-processing and recognition using PyTorch and ResNet modelling.
    • Developed dashboard for International Finance corporation by using Tableau to track approval timeline of global pipeline investments to increase portfolio by 30 million dollars.
    • Linked pipeline companies and contract documents in dashboard by embedding hyper link action in Tableau to access confidential data securely and quickly making it 100% secure and compliance
    • Structured mobile/Tablet version of Fintech Portfolio Dashboard using tableau so that users can access it on different devices making it dynamic.
    • Integrated data in Salesforce by building recipes and workflows for transformations and consumed these data in Tableau CRM (Einstein Analytics).

Education

  • Analyzing and Visualizing Data with Microsoft Power BI (Mar, 2023–Mar, 2024) from MIcrosoft Professional
  • Azure fundamentals (Jan, 2022–Jan, 2023) from Microsoft Certified in Azure
  • Data Analytics (May, 2021–Aug, 2022) from Langara College, Vancouver BC
  • SAS Programming 1: Essentials (May, 2021–Aug, 2021) from SAS Programming
  • Alteryx Designer Core (Jan, 2021–Jan, 2022) from Alteryx core
  • Business Analytics and Machine Learning (Dec, 2020–Feb, 2021) from INDIAN STATISTICAL INSTITUTE, Bangalore
  • Tableau Desktop Certified Professional Certification (Jan, 2017–Mar, 2017) from Udemy
  • Instrumentation and Control Engineering (May, 2011–May, 2015) from SRM UNIVERSITY

Fee details

    CA$40–100/hour (US$28.17–70.42/hour)

Courses offered

  • Business Analytics

    • CA$1000
    • Duration: 1 Month
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi
    • Certificate provided: No
    Business analytics provides insights into market trends, competitor strategies, and other important metrics that can inform strategic planning. By leveraging data-driven insights, businesses can develop more effective analytics strategies better suited to the current market conditions.

  • Tableau Desktop Professional

    • CA$1000
    • Duration: 1 Month
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi
    • Certificate provided: No
    Tableau Desktop delivers everything you need to access, visualize, and analyze your data. With an intuitive drag and drop interface, you can uncover the hidden insights you need to make impactful business decisions faster, even when you are offline. All while leveraging trusted and governed data in a secure self-service environment.

  • Machine Learning in Python

    • CA$1000
    • Duration: 1 Month
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi
    • Certificate provided: No
    Essential Techniques for Predictive Analysis. Learn a simpler and more effective way to analyze data and predict outcomes with Python Machine Learning in Python shows you how to successfully analyze data using only two core machine learning algorithms, and how to apply them using Python.

  • SQL

    • CA$1000
    • Duration: 1 Month
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi
    • Certificate provided: No
    SQL is a must-have skill if you want to work in the world of data. I teach in the most unique way to write efficient queries of industry standards and give insight on the best practices.

  • Data Visualization

    • CA$750
    • Duration: 3 Weeks
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi
    • Certificate provided: No
    Data and information visualization is the practice of designing and creating easy-to-communicate and easy-to-understand graphic or visual representations of a large amount of complex quantitative and qualitative data and information with the help of static, dynamic or interactive visual items.

  • Business Intelligence

    • CA$1500
    • Duration: 6 Weeks
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi
    • Certificate provided: No
    Business intelligence (BI) is a set of strategies and technologies enterprises use to analyze business information and transform it into actionable insights that inform strategic and tactical business decisions.BI tools access and analyze data sets and present analytical findings in reports, summaries, dashboards, graphs, charts, and maps to provide users with detailed intelligence about the state of the business.

Reviews

No reviews yet. Be the first one to review this tutor.