Iccha Bastola

• Senior Power BI Developer renowned for developing advanced Power BI dashboards and generating actionable insights with experience defining and tracking Key Performance Indicators using Power BI, and advanced proficiency in Microsoft Office suite including Data analysis and technique; Proven expertise in data-driven decision-making and financial acumen, and attention to detail, along with a demonstrated ability to adapt and remain flexible in dynamic environments.
• Proficient in Power BI, SQL queries, DAX, M-code, and statistical analysis, meeting rigorous technical standards.
• Successfully implemented Row Level Security and crafted user-centric forms via Power Apps.
• I am skilled at managing substantial Data volumes through Dataflow and authoring detailed data documentation for ETL processes.
• Expert in integrating SQL Server, SharePoint, and Azure Data Lake Data to deliver scalable reporting and analytics solutions.
• Demonstrated Prowess in fostering collaboration across multidisciplinary teams.
• Adept at conducting comprehensive requirements gathering, Data analysis, and reporting meticulously tailored to user specifications.
• I am advancing my expertise in Azure Cloud Services, focusing on cloud-based Data processing and engineering workflows to optimize Power BI performance further and adhere to best practices for data governance. Gathered and documented user requirements extracted the relevant data using SQL and DAX and created optimized Power BI dashboards to address user requirements.
• Implemented Row Level Security to provide access to multiple users
• Developed and implemented a Data alert system in Power BI to monitor target value.
• Regularly Refreshed Datasets in Power BI to ensure up-to-date and accurate reporting.
• Address and resolve any issues or inquiries related to the reports.
• Designed and implemented ETL processes from scratch in the Power query editor using M query and optimized Power BI performance tuning and Data model to meet the end user’s requirement.
• Documented ETL process and logical models for clarity and future reference.
• Created Interactive dashboards using Power BI Desktop and user stories to deliver actionable insights and publish them using the Power BI server.
• Utilized Various features of Power BI (e.g., drill-down, cross-reporting, dynamic measure, intrinsic and extrinsic measures, refresh) to enhance the dashboard functionality and user experience.
• Participated in validation, Data quality management, and governance reviews.
• Analyzed Data from scratch and identified business requirements and objectives using Various data analysis tools and techniques.
• Extensively used DAX and visuals to create trend charts over time, exploratory Data analysis (EDA), spatial analysis, descriptive analysis, behavior analysis, predictive analysis, prescriptive analysis, and causal analysis.
• Designed and submitted a dashboard wireframe in Figma, JavaScript and HTML for multiple projects, then replicated the approved design in Power BI, ensuring consistency in layout, functionality, and Data visualization.
• Developed Power BI dashboards while adhering to strict Data governance policies, maintaining confidentiality and security of patient records.
• Worked in an incremental Agile and Kanban environment using JIRA for project tracking, effectively managing tasks and priorities to meet dynamic project requirements. Actively participated in Data quality management, validation, and governance reviews, ensuring consistent project delivery and adherence to timelines
• Created and managed ETL processes using Power BI Dataflows, connecting to SQL Server and Azure Data Lake, with Seamless integration into Power BI Desktop for Data modeling and reporting.
• Proficient in pulling Data from Azure Data Lake and SQL Server into Power BI using Dataflows, transforming and loading data with Power Query for further analysis.
• Designed and developed Data models using Kimball methodology, implementing both star schema and snowflake schema for Various healthcare and analytics projects.
• Developed SSIS packages in Visual Studio to extract, transform, and load Data from Various sources into SQL Server, including the transition from Excel data to SQL Server due to data access restrictions.
• Resolved Data challenges by developing SSIS packages to replicate Power BI transformations and publish data to SQL Server Developer Edition for further reporting.
• Collaborated with the team to design and implement a form in Power Apps, allowing users to edit, add notes, and modify content. The form included fields such as VAMMC and other key Data points, giving users full control over information creation and updates.
• Worked closely on the migration from SharePoint lists to Power Apps, ensuring Seamless Data integration and enhancing user experience by allowing users to directly interact with and modify data via the app.
• Developed form using Power Apps allows users to update and modify information.
• Used Power Automate leverage user to write back to SharePoint list from Power BI reports.
• Implemented Seamless integration between PowerApps and SharePoint, enabling Data migration and allowing users to directly integrate with, modify and update data within Power Apps.
• Created a comprehensive Data dictionary for the project, documenting all data fields, form components, and user interactions to ensure clarity and ease of use for stakeholders and future development efforts.
• Demonstrated a solid understanding of Power Apps functionalities, including form customization, Data validation, and integration with SharePoint, without the need for DAX.
• To meet user requirements and ensure reliable and optimal report creation under Various conditions conducted Unit Testing, Data Validation Testing, Sanity Testing, Functional Testing, Performance Testing, Load Testing, Incremental Refresh Testing, Security Testing (Access Testing), Integration Testing, User Acceptance Testing (UAT), Regression Testing, Usability Testing, and Cross-Browser and Device Compatibility Testing.
• Documented processes, best practices, and guidelines to support the team’s learning and growth.
• For high Data volumes, leveraged Dataflow ensuring efficient data movement and consistency across reports.
• Ensured Compliance with HIPAA regulations by implementing Data protection standards and managing access controls for sensitive healthcare information.
• Have led client engagements to explore solutions, strategy, deployment, and maintenance.

Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.

• Certifications:
• Microsoft: Harnessing the Power of Data with Power BI (Issued Sep 2024) (Credential ID G9SW2UZWZ9KR)
• University of California, Davis: SQL for Data Science (Issued Sep 2024) (Credential ID 0GG1ONDB7A2O)
• Coursera Project Network: Introduction to JavaScript: The Basics (Issued Jan 2021) (Credential ID BZ56CKND7SJK)
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Introduction to AWS RedShift and Snowflake – Udemy.

• Honors & Awards , Exceptional CPAR Scores - IT Concepts, Inc - IT Concepts, Inc Awarded for contributing to IT Concepts' achievement of exceptional CPAR (Contractor Performance Assessment Reporting) scores for the Veteran Health Information Exchange (VHIE) project. Recognized for efforts in driving key performance indicators and delivering outstanding results that improved CPAR scores for the period 09/29/2022 to 03/28/2023 Iccha Bastola - page 1 Iccha Bastola - page 1