Ankit Das BI developer, Data Analytics, Data Integration
No reviews yet

Experience BI Developer over 5 years with experience in Data visualization using Power BI. Deployed Data Packages and Data Flow using SSIS, SSAS. Worked with Clients for requirement gathering. Worked with Financial and FMCG clients. Analyzed Raw data and used it for creating Dashboards. Created Packages for Data Integration. Worked for an insurance-based client of UK for developing wireframes and dashboard to improve Customer centric call center experiences.
Have developed multiple interactive wireframes using Bookmarks, Slicers based on the client User Stories and have won multiple phases of the project.
Implemented DAX skills which involves Aggregate, Iterative and Time Intelligence functions for calculated columns and measures.
Used Conditional formatting and implemented icons for showing YoY and MoM trend
analysis.
Hands on experience in performance optimization using Performance Analyzer and implementing Data Modelling Techniques.
Fair knowledge on SSIS and Power Automate integration. Have also worked on building SQL queries using Joins, Group By, Aggregate and key functions for reporting.
Experienced in transforming unstructured data from various data sources such as Excel spreadsheets, SharePoint, OLTP databases and flat files.

Subjects

  • Data Visualization Beginner-Expert

  • Microsoft Power BI Beginner-Expert

  • ETL SSIS Beginner-Intermediate

  • SQL and Data warehousing Beginner-Intermediate

Experience

  • Specialist Software Engineer (Jun, 2023–Present) at Societe Generale Global Solution Center
    Advanced Power BI Dashboard Design: Designed and developed interactive dashboards
    and reports using Power BI, incorporating advanced visualizations and custom calculations to deliver actionable insights into key business metrics. Utilized features such as bookmarks and slicers to enhance user experience and enable dynamic data exploration. Designed and
    developed Power BI dashboards using Starburst data, providing actionable business insights.

    Complex Data Integration and Transformation: Created intricate SQL queries to extract,
    transform, and load data from diverse sources, ensuring data consistency and accuracy
    across all environments. Developed and maintained SSIS packages for seamless data
    integration, cleansing, and loading tasks, enhancing the reliability and efficiency of the data
    warehouse.

    Multidimensional Analytics and Reporting: Designed and implemented SSAS multidimensional cubes and tabular models to support advanced analytics and reporting needs. Optimized cube performance and implemented robust security measures to safeguard data access and integrity.

    Stakeholder Collaboration and Requirements Gathering: Collaborated closely with business
    stakeholders to gather requirements, define key performance indicators (KPIs), and deliver BI solutions that align with business objectives. Successfully translated complex business needs into technical specifications, contributing to enhanced decision-making processes.

    Environment Management and Deployment: Managed the deployment of attributes and
    tables across development, testing, and production environments, ensuring consistency and
    reliability of data assets.

    Business Continuity Management Data Project: Led initiatives within the Business Continuity
    Management Data project, leveraging BI expertise to implement solutions that improve
    operational resilience and mitigate risks.
  • Senior BI Developer (Jan, 2022–Jun, 2023) at Enquero Global LLP, Bengalore
    Developed Wireframes and Dashboards: Created wireframes and interactive Power BI
    dashboards to enhance insights into customer-centric call center data points, improving
    operational efficiency and decision-making.

    Utilized Bookmarks and Slicers: Developed multiple interactive Power BI dashboards using
    bookmarks and customized slicers tailored to client user stories, facilitating intuitive data
    exploration and analysis.

    Project Success: Successfully delivered multiple project phases, winning recognition for
    meeting client objectives and enhancing business outcomes through effective BI solutions.

    DAX Implementation: Implemented advanced DAX skills, including aggregate, iterative, and
    time intelligence functions, to create calculated columns and measures that provided
    deeper insights into business metrics and trends.

    Conditional Formatting and Trend Analysis: Applied conditional formatting techniques and
    utilized icons for year-over-year (YoY) and month-over-month (MoM) trend analysis within
    Power BI, enhancing data visualization and interpretation for stakeholders.
  • Software Engineer (Jul, 2021–Dec, 2021) at In time tec Bangalore
    Report Migration: Led the migration of reports from Cognos to Power BI, improving report
    accessibility and performance for the client.
    Report Design: Designed reports using advanced visualizations such as Gauge charts and
    Clustered Column charts optimized for drilldown purposes, enhancing data exploration
    capabilities.
    Publication and Management: Published reports in Power BI Workspace, ensuring accessibility and collaboration among stakeholders. Set up Gateways to facilitate secure data
    connections and scheduled refreshes for timely updates.
  • Associate Data Analyst (Feb, 2019–Jun, 2021) at Envestnet Yodlee
    Data Analysis and Enrichment: Conducted comprehensive data analysis and enrichment
    tasks within the fintech sector, enhancing data quality and extracting actionable insights for
    strategic decision-making.

    Excel to Power BI Conversion: Successfully converted all operational Excel reports into
    interactive Power BI reports, improving data visualization and accessibility for stakeholders.

    SQL Scripting Expertise: Developed advanced SQL queries using subqueries, aggregate
    functions, window functions, Common Table Expressions (CTE), and joins to generate
    structured datasets, facilitating data-driven solutions and operational efficiency
    enhancements.

Education

  • Bachelor of Technology (Aug, 2014–May, 2018) from Institute of technical education and research,BHUBANESWAR

Fee details

    ₹450–750/hour (US$5.35–8.92/hour)

Reviews

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