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
Similar Profiles
Debrawnia JohnsonDebrawnia Johnson
Chicken Thigh Trimmer at Tyson FoodsChicken Thigh Trimmer at Tyson Foods
KPAW HTOOKPAW HTOO
Production Supervisor at Tyson FoodsProduction Supervisor at Tyson Foods
Miralem OkicMiralem Okic
Quality Assurance Laboratory Technician at Tyson FoodsQuality Assurance Laboratory Technician at Tyson Foods
Annette Smith PughAnnette Smith Pugh
Quality Assurance Inspector at Tyson FoodsQuality Assurance Inspector at Tyson Foods
Sabir PashaSabir Pasha
Senior Technical Solutions Engineer at BARRACUDA NETWORKSSenior Technical Solutions Engineer at BARRACUDA NETWORKS