Kostubh Kumar BI Consultant
No reviews yet

Dynamic and dedicated data analytics professional with over a decade of experience thriving in fast-paced agile environments. I am skilled in data warehousing, modeling, and analysis, and have a proven track record in driving business process enhancements. Adept at conducting thorough research, I possess strong business acumen and excel in problem-solving. My proficiency lies in conveying insights from complex datasets to both technical and non-technical stakeholders, ensuring clear and actionable communication. With a history of leadership, I have successfully led innovative projects and teams, consistently delivering results that align with business goals. My ability to navigate and adapt to evolving data landscapes underscores my commitment to leveraging data for strategic decision-making and organizational growth.

Visualization tools – Tableau, Power BI, Report Builder, Paginated Reports, Power BI Apps, Spotfire, Cognos, SAP Crystal Reports, SSRS, JReports
ETL – Alteryx, Azure Data Factory, Databricks, Dataflows, Power Query, Talend, Informatica ILM, Tableau Prep, Informatica Power Center, SSIS.
Cloud – Azure Synapse Analytics, Azure Data Lake
Automation - Microsoft Power Platform - Power Automate and Power Apps
Languages, Databases & API – SQL, Python, (Pandas, NumPy, Matplotlib, Seaborn, Pyodbc, Tensorflow, Scikit-Learn), R, SAS, SQL Server, Oracle, MS Access, Excel.
Areas of competencies – Data visualization and analytics, RDBMS, Exploratory Data Analysis (EDA), Data Modelling, Data Warehousing, Data Manipulation and wrangling, Market Research, Campaign Analytics, A/B Testing, Data profiling, Machine learning, Predictive Modeling, Data Archival and Data Integration, Project Management, and Leadership.

Subjects

  • Alteryx Beginner-Expert

  • Business Intelligence Beginner-Expert

  • Microsoft Power BI Beginner-Expert

  • Power BI Desktop Beginner-Expert

  • Data Visualisation Beginner-Expert

Experience

  • Senior Business Intelligence Developer (Jul, 2021–Present) at EXL Service, Gurgaon
    •Collaborated with cross-functional teams to enhance the Teradata to Azure data migration process, incorporating new business logic and improving stakeholder report utilization by 30%.
    •Led the development of master dashboards for Spend and Inventory in PowerBI, serving as a unified solution that bolstered decision-making efficiency for stakeholders.
    •Optimized data flows by reducing dependencies and retiring unused fields, achieving a 20% improvement in data refresh times and supporting more agile business operations.
    •Designed and executed Query surge tests to cleanse 80% of inconsistent raw data, ensuring high-quality inputs for our SQL databases and enhancing overall data integrity.
    •Collaborated with IT and business stakeholders to successfully migrate and deploy 175 Licensing reports from Cognos to Tableau, demonstrating strong teamwork and a commitment to seamless transitions.
    •Spearheaded a cross-functional team initiative that improved report generation speed by 40% in SQL and PowerBI, significantly aiding timely strategic decisions and showcasing my ability to lead and support team efforts.
    •Employed data mining techniques to extract actionable insights, fostering a culture of continuous improvement and curiosity within the business intelligence team.
  • Data Visualization Consultant (Nov, 2018–Jul, 2021) at Ernst & Young Global Delivery Services LLP, Gurgaon
    •Led a survey data analysis project that measured corporate confidence and M&A appetite, conducting sentiment analysis for the EY Confidence Capital Barometer and driving a six-figure revenue biannually
    •Enhanced the GSA audit product to analyze COVID-19 impact on distressed companies, resulting in a
    20% increase in user engagement and a 15% reduction in report generation time by consolidating data from multiple sources and creating reports in Power BI.
    •Collaborated with the UK&I Restructuring team to design Sales & Pipeline reporting, utilizing an SQL database and Power BI dashboard to support data-driven decision-making.
    •Supervised and mentored a 4-member team, fostering a culture of collaboration and teamwork, while prioritizing tasks and delivering solutions. Provided technical and business training in SQL, database modeling, and advanced Excel to enhance team capabilities.
    •Developed a predictive model that identified market trends, contributing to a 10% increase in sales
    for existing products and demonstrating a commitment to innovation and proactive market analysis.
    •Developed PySpark code to create Spark DataFrames with source Data from Azure Open Datasets, and use SQL to query the data.
    •Automated jobs using different triggers like Events, Schedules, and Tumbling in ADF.
    •Created, and provisioned different Databricks clusters, notebooks, jobs, and autoscaling.
  • Data Analyst (Mar, 2014–Nov, 2018) at Cognizant technology solutions bangalore
    •Performed data modeling and mapping, significantly reducing on-premises storage by 90%
    through the use of Informatica Lifecycle Management (ILM) and SQL optimization techniques.
    •Collaborated with cross-functional teams to manage the source-to-target data flow for healthcare applications, ensuring seamless data transition and contributing to a 15% increase in operational efficiency.
    •Designed and implemented a Power BI dashboard to track key performance indicators, enhancing stakeholder decision-making and supporting a data-driven culture within the organization.
    •Established and maintained organized databases, achieving a 60% reduction in data redundancy
    by employing advanced SQL querying and data modeling practices.
    •Constructed and optimized data warehouses using Informatica ILM, which facilitated client analytics and improved data retrieval processes.
    •Generated executive reports and insights using SQL procedures and JReports, aiding in strategic decision-making and forecasting market trends that led to a 20% growth in product sales.
    •Fostered teamwork and collaboration within the data team to support ongoing projects and initiatives, ensuring alignment with company goals and client expectations.

Education

  • Microsoft Certified: Fabric Analytics Engineer Associate (Jun, 2024–Jul, 2024) from Microsoft Professional, Toronto
  • Data Analytics for Business Decision Making (Jan, 2024–Apr, 2024) from Durham College, Oshawa
  • Azure fundamentals (Jan, 2022–Jan, 2023) from Microsoft Certified in Azure
  • Microsoft Certified: Power BI Data Analyst Associate (Feb, 2021–Feb, 2022) from MIcrosoft Professional
  • Tableau Analyst - Tableau Software (Jun, 2020–Dec, 2020) from Tableau Software
  • Tableau Designer - Tableau Software (Jun, 2020–Dec, 2020) from Tableau Software
  • Alteryx Designer Core (Feb, 2019–Feb, 2020) from Alteryx core
  • Electronics and Communication engineering (Jun, 2009–Jun, 2013) from Apeejay College of Engineering

Fee details

    CA$25–50/hour (US$17.61–35.21/hour)

Reviews

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