This tutor is banned because of:
Sharing Contact Details. Also LinkedIn details.

Ankit Kumar Sahu Senior Business Intelligence Analyst
1 Review

I am 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. expert and like to give back to the global community through my teaching, consulting, and support. I make sure my students or project partners get the best industry knowledge and experience from me with real-time scenarios which gives them an edge over others. As I have worked with global clients I understand the market and teach or mentor my students accordingly so they get the best outcome and their expectations are met,
I like to be in touch with the best mindsets as I always look for collaborative work. In case someone asks me to help them to get a job post-training, I make sure I train, support, and prepare them to face all the challenges when they dive into the market for a Job hunt.
I also provide job support and consulting to clients who are ready to collaborate and make our job easier.
Please don't forget to drop your contact details when you message me so that it will be easy for me to reply back to you personally.

Subjects

  • Data Science Beginner-Expert

  • Business Intelligence Beginner-Expert

  • Tableau Desktop and Server Beginner-Expert

  • Data analysis and visualization Beginner-Expert

  • Complex SQL Query writing Beginner-Expert

Experience

  • Senior Data Analytics Consultant (Apr, 2021–Present) at Vancouver
  • Senior Business Analyst (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.
    Ankit Kumar Sahu +1 (778) 834-8842
    ankit.sahu160294@gmail.com
    Page 2 of 3
    • 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.
    • Consulted with stakeholders to gather and document data governance project requirements, helping to establish
    agreed-upon data definitions and consistent data capture across the project by actively involved in data mining,
    profiling and integration activities.
    • 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%.
  • Senior Business Intelligence Developer (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 the solution and created user stories for requests 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 relationships and ensured that there is complete transparency by engaging them in Salesforce CRM captures information and data accurately so that the 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, and custom reports, and published them to the server with data security while
    maintaining data analytics standards, discarding manual reporting, and data refresh processes, resulting in savings of
    200 hours of manual effort.
    • Designed end-to-end frameworks for all the dashboards 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 Engineer (Sep, 2015–Jul, 2018) at Cognizant technology solutions
    • Performed data modeling 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 flow of data 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.
    Ankit Kumar Sahu +1 (778) 834-8842
    ankit.sahu160294@gmail.com
    Page 3 of 3
    • 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 creation and maintenance of datasets
    reducing redundancy by 60%.
    • Constructed data warehouses by moving raw data from different repositories into staging and then into the star
    the schema in their respective facts and dimension tables using Informatica ILM to enable client’s analytics and data
    retrieval capabilities.
    • Delivered dashboard walk throughs, training sessions, and 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 to determine the cause of a positive or negative outcome by making data and documents
    accessible in one click.

Education

  • Post Graduation Diploma (Apr, 2021–Aug, 2022) from Langara College, Vancouver BC
  • Bachelor Of Technology (May, 2011–May, 2015) from SRM UNIVERSITY

Fee details

    CA$2,000–4,000/month (US$1449.28–2898.55/month)

    I am flexible to work on hourly, daily, weekly and monthly and can also negotiate on charges

1 Review
5 out of 5

User Photo May 15, 2021

Best tableau tutor

Ankit is an amazing and friendly tutor. He really cares about his students/clients. I had him for my tableau projects and he really spends hours and walk through me every step in projects and gave me a better understanding of dashboards. Highly recommended him. Good luck bro for your bright future.