Vikranth A

About Vikranth A

7+ years of IT experience in database design, development, BI, enterprise reporting and…

Experience

1. Sr Power Bi Engineer

   Apexon

   Oct 2021 — Present

   Responsible for designing reporting architectures for multiple clients in Power BI and Tableau to modernize their reporting architecture replicating the requirements or setting up new architecture catering to their needs. Designed and developed multiple POCs to demonstrate the feasibility of development roadmap with a clear understanding of requirements. Assisted in building Power API rest APIs to embed reports in customer application portal with security configurations, AAD integration & user access. Developed operational, HR, healthcare and logistics dashboards for multiple clients in Power BI & Tableau integrating data from multiple sources and building efficient data models. Developed reports/dashboards with KPIs, drill downs, parameters, groups, sets, bookmarks, hierarchies, actions, visual interactions, URLs, and filters. Responsible for modernization of reports from multiple technologies like Web focus and Business objects to Power BI replicating the existing business requirements. Implemented CI/CD for SQL Databases with Redgate, Git and source control. Developed and deployed scalable, efficient, reliable data pipelines to production. Developed data pipelines in Azure Data Factory to fetch data from upstream for reports. Designed and implemented complex ETL workflows in Alteryx to integrate data from multiple sources, ensuring data accuracy and consistency. Generated insightful reports and visualizations in Tableau using data processed and prepared with Alteryx, enabling data-driven decision-making. Implemented row level security for the users to restrict the data across groups.

Education

• Northern Illinois University

  Master's degree

• Jawaharlal Nehru Technological University

  Bachelor of Technology - BTech

  2011 — 2015