Priyanka Aditya

About Priyanka Aditya

Results-producing Power BI Developer with experience in developing reports/dashboards, translating data into actionable insights from various sources, and developing BI and analytics solutions. Resourceful, organized, and dependable problem solver seeking a position to build winning environments that consistently add value, deliver measurable results, and enhance organizational viability and growth. • Delivering value to the business using data-driven analytics.• Demonstrated ability to deliver valuable insights via data analytics and advanced data-driven methods. • End-to-End Analytics project experience, which constitutes requirement gathering, data preparation, data processing and visualization.• Expertise in developing and maintaining reporting systems, dashboards, and performance metrics that supports key business decisions.• Have gained knowledge of ETL, data warehouse concepts, and hands-on work experience in multiple database environments.• Experience in utilizing Python, SQL, Tableau, and Power BI for the data analysis workflow, including data wrangling, data storytelling, data visualization, exploratory data analysis, statistical data analysis, and applying linear regression models.• Proven ability to communicate solution strategy and product offerings, analyze & translate complex business problems, and design and implement innovative solutions. • Applying analytical skills to business requests & communicate these business wants/needs in a clear/unambiguous manner. Ensuring these are consistent and not in contradiction with each other.

Experience

1. Business Intelligence Consultant

   Akira Insights

   Sep 2021 — Present

   Developing solutions in various BI applications involving Python Solutions, SQL Scripting, Front end Development of BI dashboards etc.• Directly interacting with clients for Requirement gathering, Understanding business problems, dashboard walkthrough etc. • Was involved in migrating Power BI reports from the legacy ERP system to Dynamics 365.• Actively involved with several stakeholders at the requirement-gathering stage.• Functioned as SPOC for developing & supporting existing Power BI reports/dashboards, created, and maintained workspaces and scheduled data refresh cycles in Power BI service, extracted/modeled data from various data sources, including MS Dynamics 365 Business Central, SharePoint, SQL Data Warehouse & Excel.• Developed salesperson’s commission report to measure the salesperson’s success through KPIs built using DAX and implemented row-level security.• Developed a report to analyze an item’s usage in sales, production, and purchasing, using Power BI\'s navigation functionalities such as bookmarks, drill-through, and tooltips.• Optimized SQL queries, fixed memory allocation problems in the Power BI Service, and improved data refresh difficulties in Power BI Desktop.• Performed analysis and produced views for the reports using SQL to curate and query large data sets using SQL Server Management Studio (SSMS).• Minimized reporting errors in purchasing, sales, and manufacturing data when the data gaps between the source systems and data warehouse were identified.• Created reports in Apache Superset and identified Customer Tags from past purchase data in AWS S3, Athena.• Helped to automate the data load, copy, and delete processes between S3 buckets.• Created slicers and dicers, drill-through reports, drill-down reports, sub-reports, and linked reports to create multiple analytical dashboards that display key KPIs.

Education

• Vellore Institute of Technology

  Master of Science - MS, Software Engineering

• Springboard

  Data Analytics