Data Analyst with
4 years
of experience building reliable analytics and BI solutions. Specializes in
Power BI (DAX, Power Query, model design),
SQL, and
Azure (Fabric/Databricks/ADF).
Proven track record in crafting scalable data models, optimizing Power BI Premium capacities, implementing
RLS, and collaborating with cross‑functional stakeholders to deliver
actionable insights.
Data quality & ETL (Power Query, IDQ, PySpark, ADF/Databricks)
Experience
Sr. Software Engineer Yash Technologies Pvt.
Ltd
Pune • –
Developed interactive dashboards and reports using
Power BI, Tableau, and SSRS, enhancing business intelligence
and data visualization for executives and stakeholders.
Designed reusable semantic models and wrote complex
SQL queries to optimize data extraction, transformation,
and integration across multiple enterprise systems.
Implemented Row-Level Security (RLS), automated data refresh,
and scheduling in Power BI Service to ensure secure and real-time
analytics delivery.
Built ETL pipelines in Databricks, SSIS, and Informatica IDQ,
performing data profiling, cleansing, and scalable transformations for high-quality insights.
Collaborated with cross-functional teams and leadership to translate
business requirements into actionable analytics solutions, driving operational efficiency
and strategic decision-making.
Delivered end-user training and adoption programs for 2,000+ users,
improving Power BI adoption, reducing issue resolution time by 25%,
and increasing overall business performance.
Key Data Analytics & Business Intelligence Projects
Enterprise Analytics Dashboard
Tools: Power BI, MS Excel, SQL, SharePoint
Designed advanced Power BI dashboards and semantic models, integrating SQL-based transformations to improve
reporting efficiency in Microsoft Fabric.
Wrote complex SQL queries for data extraction and transformation, created reusable semantic models in
Power BI Service.
Developed interactive dashboards that significantly increased operational efficiency.
Implemented Row Level Security (RLS) for data access control and automated report refresh scheduling.
Collaborated with executives and cross-functional teams to deliver actionable business insights.
Resource Onboarding & Workforce Analytics
Tools: Power BI, SQL, ServiceNow
Built a project and resource management analytics platform using Power BI and SQL, recognized for driving
onboarding efficiency across 6,000+ resources.
Integrated multiple data sources into Power BI with accurate data models and advanced DAX calculations.
Aligned models with data governance policies in collaboration with leadership and data stewards.
Designed dashboards that tracked onboarding for 6,000+ resources, enhancing workforce planning.
Trained and supported 2,000+ end users, reducing resolution times by 25% and documenting system issues.
Report Migration & Automation
Tools: SSRS, SQL
Migrated 9,000+ reports to SQL Server Reporting Services (SSRS) with full validation, automation, and
scheduling for enterprise reporting reliability.
Resolved technical issues swiftly, boosting team efficiency and uptime.
Managed and delivered high-priority report migration tasks under tight deadlines.
Validated migrated reports to ensure accuracy and consistency of enterprise data.
Automated report generation and scheduled subscriptions to streamline reporting processes.
Insurance Analytics
Tools: Tableau, SQL, Informatica IDQ, Databricks
Engineered end-to-end ETL pipelines integrating Databricks, SSIS, and Informatica IDQ, delivering
high-quality data marts for Tableau reporting in insurance analytics.
Built scalable ETL pipelines in Databricks and SSIS for insurance policy and claims data.
Applied Informatica IDQ for data profiling and cleansing, ensuring accuracy and consistency.
Stored curated datasets in Databricks Delta Lake with applied business logic for reporting.
Developed Tableau dashboards delivering actionable insights to underwriters and analysts.
Skills
Data Visualization & Processing
Power BI, Tableau, SSRS
Excel (Advanced)
SQL, DAX, Power Query
Python, AI/ML
Data Engineering & Quality
Microsoft Fabric, Databricks, Azure
ETL & Integration
Informatica IDQ
Data Profiling & Validation
Collaboration & Operations
Client Communication & Stakeholder Engagement
Cross-functional Collaboration
Azure DevOps, CI/CD, Git
Security & Compliance
Education
Post Graduate Diploma in Big Data Analytics — CDAC ACTs,Pune
Relevant Coursework: Data Warehousing, Statistics, Data Analytics, AI/ML
Bachelor of Engineering, Electronics & Communication — M.I.E.T., Gondia, Maharashtra
in/amit1raj