Power Bi Software Engineer
Resume:
SENIOR SOFTWARE ENGINEER **************@*****.***
(Immediate Joiner) LinkedIn - www.linkedin.com/in/anshul-verma-005b56289 Dedicated and skilled professional P R O F I LE S U M M A RY targeting a challenging position in Data
Analytics with a focus on leveraging
Power BI tool, SSMS, Azure cloud, open
to opportunities in PAN India.
C O R E C O M P E T E N C I ES
Data Analytics
Software Development
Analytics Consulting
Data Visualization
Business Intelligence Strategies
Agile Methodology
Database Management
Data Warehousing
ETL Processes
Microsoft Fabrics
Offering 6+ years of Data Analytics field, specializing in optimizing business operations through strategic data-driven insights and software solutions.
Proficient Power BI Developer with a proven track record of designing and implementing dynamic dashboards and reports.
Skilled in data analysis and visualization techniques, transforming complex datasets into meaningful insights that support strategic business initiatives and optimize operational efficiency.
Proven track record in leading cross-functional teams to seamless project execution, specializing in data collection, analysis, and visualization for informed decision-making across diverse industries.
Expertise in creating robust data warehouses and conducting complex data migrations to developing interactive dashboards and implementing KPIs, driving efficiency and profitability.
Expertise in data modeling and ETL processes, committed to staying updated of emerging trends and technologies to deliver innovative Power BI solutions tailored to meet organizational objectives.
Possess advanced technical skills in SQL, DAX, and Azure Cloud, complemented by a commitment to continuous learning and Agile methodologies.
Expertise in various domains Property, Finance, Project Management, HR Attrition.
Experienced in leveraging Microsoft Fabrics and Lakehouse Dataflows to optimize data integration and analytics workflows.
T E C H N I C A L S K I L L S
W O R K E X P E R I E N C E
Power BI, Dax, SSMS, SharePoint, Paginated
Reports, Google Looker Studio, Excel, Azure Cloud, Azure Devops, Azure AD, DAX Studio, Tabular
Editor, ALM Toolkit, Power Bi Helper Tool, Spotfire
Snowflake, GCP, AWS, Databricks, Python, Tableau, Power Query, Power Pivot.
Bizmetric India Pvt. Ltd., Mohali May’24-Aug’25
Senior Software Engineer
Key Result Areas:
Built and modelled a Snowflake Data Warehouse with end-to-end ETL processes for trusted analytics.
Developed Power BI dashboards with KPIs such as Oil Rate, Gas Rate, and Water Rate for performance monitoring.
Integrated 20+ KPIs across dashboards to enable strategic, data-driven decision- making.
S O F T S K I L L S Applied advanced DAX for complex calculations and insightful analysis.
Analytical
Collaborator
Communicator
Innovator
Team Builder
Critical Thinking
E D U C A T I O N
MBA from Mizoram University (Pursuing)
BCA from St. Aloysius College, Jabalpur, 2018
Leveraged Ensured data governance and security within Snowflake for reliable reporting. TMotions Global Ltd., Mohali Aug’23-Apr’24
Senior Software Engineer
Key Result Areas:
Spearheading cross-functional collaboration among Data Engineering, Data Science, and App Development Teams to seamlessly execute project deliverables for a critical government website.
Utilizing Microsoft Fabrics to enhance data integration and streamline Lakehouse Dataflows, ensuring efficient project execution and data accuracy.
Extracting pertinent data from trusted public sources, including government reports, databases, and publications, to inform company projects.
Managing and optimizing the company's database, ensuring it remained current, organized, and easily accessible for internal use.
Regularly updating and maintaining database records, enhancing performance and efficiency across the organization.
C E R T I F I C AT I O N
Microsoft DP 600
Excel, Udemy, 2024
P E R S O N A L D E T AI L S
D a t e o f B i r t h: 16th April 1997
L a n g u a g e s K n o w n: English & Hindi
A d d r e s s : 1524 Lalmati Chandmari Talaiya,
Jabalpur, Madhya Pradesh 482001, India
EXO Edge Advantage India Pvt. Ltd., Mohali Dec’22-Aug’23 Power BI Developer
Highlights:
Partnering with the team to streamline daily workflow through the automation of 20+ redundant reports, reduced time by 2 hours and boosted accuracy by 30%.
Provided essential descriptive analysis insights to support strategic decision-making and ensure compliance, under the guidance of the Project Lead.
Utilized Power BI to craft over 5 substantial and 15+ minor dashboards, gathered data from diverse origins to amplify clarity and furnish actionable insights.
Effectively managed client interactions, demonstrating strong communication and problem-solving skills during regular client calls.
Utilized SSMS to query, design, and manage databases and data warehouses, ensuring efficient data storage and retrieval processes.
Leveraged GCP services, including BigQuery and Dataflow, to enhance data manipulation and reporting capabilities, streamlining data workflows and improving overall efficiency.
Roz Technologies Pvt. Ltd., Pune Oct’21-Dec’22
Power BI Developer
Highlights:
Effectively executed 2 data migration initiatives, resulting in reductions of data processing times by 25% and 30% respectively.
Achieved a remarkable 98% accuracy rate and minimized disruptions during both migration projects, thereby improving system performance.
Leveraged ETL proficiency to enhance data accessibility for end users, resulting in a notable 30% increase.
Worked with paginated reports to deliver the invoices of the company. Infosys, Pune Jul’18-Aug’21
Process Executive
Highlights:
• Collaborated with the team to optimize daily operations by automating 20+ redundant reports, resulting in a time savings of 2 hours and a 30% increase in accuracy. Contributed to strategic decision-making by providing descriptive analysis insights to maintain compliance under the guidance of the project lead.
• Developed over 5 significant and 15+ minor dashboards using Power BI by consolidating data from various sources to enhance clarity and deliver valuable insights.
P R O J E C TS
PROJECT: Oil and Gas domain
Technology tools used: Power BI Desktop, Power Query Editor, Snowflake, DAX, SQL
Utilized Snowflake for performing ETL operations, including data cleansing, transformation, and integration from multiple sources.
Applied data governance and security practices in Snowflake to ensure data quality, compliance, and controlled access.
Built dataflows to fetch curated data from Snowflake into Power BI for streamlined reporting.
Developed complex DAX measures and implemented business logic to address key KPIs in the oil and gas domain.
Designed and delivered interactive Power BI dashboards with features like drill-downs, bookmarks, and multi-level filters (visual, page, and report).
Published reports to Power BI Service and configured scheduled refreshes as per business requirements.
PROJECT: Population census
Technology tool used: Power BI desktop, Power query editor, SharePoint lists, DAX
Collecting data from APIs and then perform data changes for modelling.
Performed ETL process on power query editor to structure the data for better visualizations.
Mapping data that identifies and captures section and sub-section wise data points.
Formulae used, Change YoY, Change Short Term, Change Long Term
Knowledge on DAX creating Measures and Calculated Columns.
Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub Reports, Global Map Reports in both Power BI Desktop and Power BI cloud Service.
Import data from different data source to create Power BI Reports and Dashboards.
Developed and maintained multiple Power BI dashboards/reports and content packs.
Knowledge on Power Query Lists, Tables and Records.
Able to design complex queries for Power BI Report Visualizations
Publishing reports to Power BI service.
Specified Scheduled refresh for the report based on customer instructions.
Created Apps for easy visualization of the reports as per the client requirement. Embed report to website portal.
PROJECT: Property domain
Technology tool used: Power BI desktop, Azure Services, Salesforce Objects, Sharepoint Folder, DAX, SQL
Ingested data from on-premises systems, SharePoint, and APIs into Azure Data Lake Storage using Azure Data Factory for seamless cloud integration.
Performed ETL, data modelling, data cleansing, profiling, and analysis to prepare data for reporting.
Leveraged Azure services for performance tuning, data orchestration, and secure access management.
Designed interactive Power BI dashboards with visualizations such as donut charts, pie charts, bar graphs, line charts, and card visuals.
Applied multiple levels of filters (visual, page, report) to meet reporting requirements.
Developed measures using DAX for KPIs like Actual Revenue, Running Total, Year- over-Year, Quarter-over-Quarter, and Month-over-Month growth.
Implemented bookmarks, drilldowns, drill-throughs, and parameter-based navigation as per client needs.
Configured Row Level Security (RLS) through Azure AD for internal and external user access.
Published reports to Power BI Service, set up scheduled refreshes, and created Power BI Apps for easy access.
Embedded Power BI reports into web portals for wider business usage. PROJECT: Retail domain
Technology tool used: Power BI desktop, Power Query Editor, Google Looker Studio, DAX, Sharepoint.
Migrated Reports: Successfully transitioned reports from Google Looker Studio to Power BI, ensuring data integrity and continuity.
Data Integration: Expertly integrated data from SharePoint and Excel, ensuring seamless data flow and accurate reporting.
Data Preparation: Conducted extensive data preparation including format conversions, deduplication, and data cleansing to enhance report accuracy.
Advanced Visualization: Developed interactive Power BI dashboards with drill-down capabilities and bookmarking to improve user navigation and insights.
Measure Creation: Designed and implemented custom measures in Power BI to meet specific analytical requirements and enhance dashboard functionality.
Row-Level Security: Configured row-level security to control data access based on user roles, ensuring data confidentiality and compliance.
Filter Application: Utilized various filter levels—visual, page, and report—to refine data visibility and tailor the reporting experience.
Publishing and Refreshing: Published Power BI reports to the Power BI Service and set up scheduled refreshes to keep data current and relevant.
Contact this candidate