AJAY THAKUR
Bengaluru
Overview
5
5
years of professional experience
1
1
Certification
Work History
Power BI Developer
Tyson Foods
Bengaluru
01.2024 - Current
- Developed a semantic model to calculate profitability metrics for international data, such as Adjustments, COGS, EBITA, EBIT, etc., at various levels by integrating data from multiple sources (GCP, SharePoint, Power User Workspace).
- Developed base metrics and integrated Year-To-Date, Quarter-To-Date, Period-To-Date computations along with Variances and Variances %.
- Implemented Row-Level Security (RLS) and Column-Level Security (CLS) based on Material Business Units (MBU) and Sub-MBU for regions and key metrics.
- Reduced the number of calculation measures from 3000 to 250 using calculation groups, leading to significant model size reduction and improved user experience.
- Achieved 95% optimization of semantic model performance resulting in dashboards and Excel rendering time limited to 5 seconds.
- Conducted proof-of-concepts for integrating RLS and CLS with ARS roles and Microsoft Intra ID.
- Awarded a Spot Award in Data and Analytics All Hands for my contribution to Project Pyramid.
Power BI Adminstrator
Tyson Foods
Bengaluru
02.2023 - 12.2024
- Defined and implemented governance practices to manage, secure, and ensure compliance within the Power BI environment.
- Developed Documentation Certification Standards for Power BI semantic models to standardize documentation practices.
- Established backup procedures using SharePoint and implemented version control through ALM Toolkit.
- Introduced a Change Logbook to document changes in Power BI semantic models and contributed to defining best practices using the Best Practices Analyzer (BPA).
- Assisted in report optimization, KPIs, and performance improvements, collaborating with multiple team members to drive efficiency and enhance business decision-making.
Power BI Developer & SQL Developer
Client: HP
08.2021 - 02.2023
- Developed 5 self-Served Power BI Models by connecting to various data sources into Power BI desktop and transforming the data in Power Query Editor and creating enterprise reports and dashboards
- Implemented Complex measures, incremental refresh, gateways, parameter Binding, parameters, hierarchies, relationships and published the model to Power BI Service as a dataset
- Resolved 70% performance issues by implementing proper indexing, distribution and partitioning of the database table
- Delivered 95% defect free Models & Reports as per the timeline
- Prepared SQL scripts/queries to create Tables, views & validate the data.
AAS & SQL Developer
Client: HP
11.2019 - 07.2021
- Worked on the design and development of the Customer C360 Azure Analysis Model
- Documented Low-Level Design/ Data Dictionary of the model in MS Excel
- Using Azure Data factory for ETL related workflows to load historical and incremental data into Azure Data Warehouse and Azure Data Lake increasing efficiency by 30%
- Prepared SQL scripts/queries to create Tables, views & validate the data such as checking duplicates, null values and truncated values
- Created triggers in ADF to load data from ADLS Gen2 to Azure Database tables
- Migrated Azure Analysis Service model to Power BI model and created report and dashboards
- Implementing data security using Column level security, Dynamic Data Masking and Always Encryption in Azure SQL Database
- Collaborated with DevOps Team on integrating GITHUB with Visual Studios and using it for SQL / AAS object deployment
- Interacted with clients daily for requirement gathering and to understand business needs
- Resolved 70% Performance issue by implementing proper Indexing of the table in the database.
Education
B.E in Electronics & Telecommunication Engineering -
Army Institute of Technology, Pune
01.2019
12th/Intermediate -
K.V. No - 2 Chandimandir, Haryana
01.2014
10th/SSE -
Sainik School, Sujanpur Tira
01.2012
Skills
- Power BI
- Power BI Service
- DAX
- Azure SQL
- Azure Data Factory
- GIT
- DAX Studios
- Tabular Editor
- MS Excel
- Paginated Reports
- Data Modelling
- Data Warehouse
- Power Automate
Certification
- PL-300 Power BI Data Analyst Associate, Microsoft, 07/20/204
- Advanced DAX for Microsoft Power BI Desktop, Udemy, 09/20/22
- Advance SQL and Query Optimization, Udemy, 09/20/2024
- Power BI Administration and Governance, Pragmatic Works
Hobbies and Interests
- Football
- Swimming
- Traveling
- Badminton
Languages
- English
- Hindi
Timeline
Power BI Developer
Tyson Foods
01.2024 - Current
Power BI Adminstrator
Tyson Foods
02.2023 - 12.2024
Power BI Developer & SQL Developer
Client: HP
08.2021 - 02.2023
AAS & SQL Developer
Client: HP
11.2019 - 07.2021
B.E in Electronics & Telecommunication Engineering -
Army Institute of Technology, Pune
12th/Intermediate -
K.V. No - 2 Chandimandir, Haryana
10th/SSE -
Sainik School, Sujanpur Tira