Data Analyst Power Bi
Resume:
Jiban Kharel
Summary
Results-driven BI Developer and Senior Data Analyst with 8+ years of experience in data analytics, database development, and business intelligence solutions. Specialized in Microsoft SQL Server (2008–2019), SSIS, SSRS, Power BI, and Azure Data Pipelines for end-to-end data integration and reporting. Proficient in building interactive Power BI dashboards with custom visuals, bookmarks, advanced DAX measures, and dynamic KPIs to support data-driven decision-making. Experienced in all phases of the SDLC and well-versed in data warehousing concepts, stakeholder engagement, and translating complex business needs into actionable insights. Strong background in data governance, agile delivery, and domain expertise in public sector, healthcare, and human services analytics.
Core Competencies
oDesign, develop, and maintain large-scale relational databases
oWrite complex SQL, T-SQL, stored procedures, views, functions, triggers, and indexes (clustered and non-clustered)
oApply database normalization/denormalization, DDL/DML, and maintain referential integrity
oDevelop ETL processes and SSIS packages for data migration from Oracle, flat files, Excel, and text files
oEnsure data integrity using ACID properties and database locking mechanisms
oImplement data warehousing concepts: star and snowflake schemas, cubes, fact/dimension tables, OLTP, OLAP
oCreate advanced SSRS reports: parameterized, drill-through, drill-down, tabular, linked, and sub- reports
oModel data dimensionally using MS SQL Server Analysis Services (SSAS)
oDesign and implement RDBMS solutions using SQL and Oracle 8i/9i
oCollaborate effectively with cross-functional teams including developers, designers, and QA engineers
oDesigned and implemented complex dimensional data models (star and snowflake schemas) to support enterprise BI reporting and analysis.
Technical Skills
oOperating Systems: Windows 7/Vista/XP/2008/2010, UNIX, MS SQL Server
oDatabases: SSMS 2016/2014/2012/2008, Oracle, SSMS, Snowflake
oSQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer, Profiler, DTS,
SSIS, SSRS, Database Tuning Advisor
oETL Tools: DTS, SQL Server Integration Services (SSIS), Visual Studio, Azure Pipeline, Azure Data Factory (ADF)
oCloud G Analytics: Azure Synapse Analytics
oReporting Tools: SQL Server Reporting Services (SSRS), Power BI
oAutomation G Workflow: Power Apps, Power Automate (Flow)
oProgramming: T-SQL, PL/SQL, Dynamic SQL, DAX, C#, XML, Python (basic scripting)
oVersion Control: Git, GitHub
oJob Scheduling: SQL Server Agent, Tidal
oRDBMS: SQL Server 2012/2014/2016, Oracle 11g/10g/9i
Power BI Developer/Analyst Costco Wholesale
WA (Remote)
May 2024 – Apri2025
Developed and maintained complex Power BI dashboards and reports delivering critical insights.
Designed and optimized data models, enhancing report performance with efficient DAX usage.
Transformed Explore DX web reports into interactive, dynamic Power BI dashboards, improving data visualization and analysis after analyzing datasets to identify major trends, insights, and KPIs.
Developed Power BI reports by extracting and integrating data from Explore DX, ensuring smooth transitions and data consistency.
Implemented Row-Level Security (RLS) and Object-Level Security (OLS) to restrict data access based on user roles.
Managed Power BI workspace access and user permissions aligned with governance policies.
Created custom DAX measures and calculated columns to replicate and improve Explore reports.
Utilized SQL, Excel, and Azure as data sources to generate computed tables and visuals.
Created, published, scheduled, and maintained numerous Power BI visualizations, including executive dashboards.
Applied DAX and Power Queries to maximize Power BI report and dashboard functionality.
Designed intuitive and interactive dashboards using best practices in UX/UI to enhance user engagement and data storytelling.
Developed and documented PBIX templates; managed interactive Power BI dashboards to track key business and operational metrics.
Optimized data models and DAX calculations, improving report performance and user efficiency.
Created KPIs, measures, calculated columns, slicers, tooltips, and other advanced Power BI Desktop features.
Implemented advanced DAX queries in Power BI Desktop to provide detailed insights and enhance performance.
Integrated SAP HANA and SAP BW data into Power BI dashboards using direct query and import methods to support business reporting needs.
Collaborated with SAP security and identity teams to ensure Power BI role-level access aligned with SAP user authorizations
Developed complex SQL queries, including joins, stored procedures, and views, based on business requirements to enforce business rules and transformations.
Analyzed database performance using SQL Profiler and optimized indexes for query efficiency.
Optimized stored procedures, UDFs, and queries to maintain database integrity, performance, and security proactively.
Led Power BI initiatives across cross-functional teams, collaborating with developers, analysts, and business stakeholders to ensure accurate, impactful reporting.
Environment: SQL Server 2019, Synapse Analytics, Power BI, SSIS
Power BI Developer/Analyst
Cottonwood Financial Irving TX
May 2023 – April 2024 Developer:
Configured Azure Pipelines as ETL tools to perform data transformations (transferring data from SFTP servers to Data Lake and database).
Scheduled and automated Azure Pipelines based on report requirements and timing preferences
Developed and managed data pipelines using Azure Synapse Analytics and Azure Data Factory, integrating diverse data sources across the real-time Azure ecosystem for advanced analytics and reporting.
Designed Power BI semantic data models by combining data from Azure Data Factory and Synapse Analytics.
Developed advanced DAX measures and calculated columns to enable dynamic KPIs and complex logic.
Utilized Power Query (M language) extensively for data transformation, cleansing, and combining data from diverse sources.
Maintained and optimized semantic models to ensure accurate reporting and efficient analysis across business units.
Developed ETL packages with various source files and migrated data into destinations via SQL Server Integration Services (SSIS).
Performed data cleansing and validation to ensure high data quality.
Wrote stored procedures involving multi-table joins and unions.
Translated business requirements effectively to technical and non-technical stakeholders.
Created, published, scheduled, and maintained numerous Power BI reports, including executive dashboards.
Employed DAX and Power Queries to maximize Power BI report functionality.
Developed PBIX templates and created documentation.
Built KPIs, measures, calculated columns, slicers, and tooltips within Power BI Desktop.
Integrated Power BI reports with Power Apps to facilitate interactive business workflows.
Developed Power Automate flows to trigger email notifications at various levels.
Fixed bugs in reports and data pipelines.
Analyzed raw customer data to build frameworks for future use.
Utilized Python scripting to dynamically create Azure Data Factory pipelines.
Worked in Agile teams following Scrum methodology with sprint planning, daily stand-ups, and iterative delivery.
Analyst:
Collaborated with business stakeholders to gather and understand data and reporting needs.
Designed and implemented data models supporting BI and analytics.
Optimized queries and data workflows to ensure timely information delivery.
Coordinated with cross-functional teams, including analysts, DBAs, and developers, to deliver BI solutions.
Created and maintained BI documentation including technical specs, user guides, and best practices.
Provided training and user support for BI tools and reports.
Automated ETL processes using Azure Pipelines to improve efficiency.
Designed customized Power BI visualizations to track financial and operational metrics.
Environment: SQL Server 2019, Synapse Analytics, Azure Data Lake/Factory, Power BI, SSIS
Power BI Developer
Medtronic
MN Remote
Feb 2021 – March 2023
Developed Power BI reports from the ground up—including sub-reports, parameterized, and drill-down reports—focused on manufacturing operations such as inventory tracking, supply chain metrics, and production
Created and maintained Power BI reports aligned with business needs; involved in report refreshing, maintenance, and bug fixing.
Wrote DAX queries to generate computed columns and tables within Power BI.
Utilized Power BI Gateways to keep dashboards and reports updated.
Installed and configured Enterprise and Personal Gateways in Power BI Services.
Designed high-level matrix and KPI reports based on detailed business and technical specifications.
Integrated data from multiple sources such as SQL Server, SAP BW, Oracle, and SQL Azure.
Collaborated with SAP functional teams to integrate SAP BW and SAP HANA data sources into Power BI reports using standard and custom connectors.
Used Git and Bitbucket for version control, and managed tasks and sprints in an Agile environment.
Scheduled automatic and manual data refresh in Power BI service.
Integrated Microsoft D365 data with Power BI to create dynamic reports supporting financial and operational decision-making
Created calculated columns and measures in Power BI Desktop applying advanced data analysis techniques.
Developed and maintained complex SQL scripts, indexes, and queries for data extraction and analysis.
Reduced manual intervention by working on ETL processes in Snowflake ensuring data consistency.
Conducted quality assurance and testing in SQL Server environments.
Tuned long-running queries using SQL Server 2014/2016.
Extensively developed queries, stored procedures, functions, and triggers in SQL.
Collaborated with production support teams to implement hotfixes for critical issues.
Used execution plans to optimize database queries.
Implemented error handling and data viewers in ETL packages.
Designed ETL packages handling diverse sources including flat files, Excel, text, and CSV files using SSIS.
SQL/Power BI Developer
Care Source
Dayton OH
Dec 2018 – Feb 2021
Developed and deployed ad-hoc and customized reports using SSRS and Power BI to meet business owner requirements.
Created workspaces and content packs enabling business users to access reports.
Pulled data into Power BI from SQL Server sources.
Built multiple Power BI dashboards and reports with various matrix and visualization types.
Monitored production dashboards daily to enhance performance; managed dataset refresh schedules.
Acted as Power BI delegate resolving issues alongside the Power BI Admin team.
Performed custom calculations and filtering using DAX.
Validated Power BI dashboards for compliance with company standards in collaboration with cross- functional teams.
Supported deployment and monitoring of Power BI dashboards.
Handled regulatory reports and CRM daily processes.
Scheduled SSIS package executions using SQL Server Agent and Tidal.
Designed ETL packages from various source file formats migrating data to SQL Server using SSIS.
Conducted monthly data refresh tasks on multiple servers.
Developed tables, stored procedures, views, and SQL queries ranging from simple to complex as requested by business owners.
Participated in physical database design and modifications with development teams.
Worked in an Agile environment attending daily, bi-weekly, and monthly ceremonies.
Developed SSRS and SSIS reports related to claims and encounter data for provider and encounter teams.
Created SSIS packages and SSRS reports supporting claim submission, resubmission, acceptance, and rejection workflows.
Delivered regulatory reports and Power BI dashboards ensuring CMS and state compliance.
Optimized data integration and reporting workflows with advanced SQL queries and SSIS packages.
Managed version control using Git and GitHub, including branch management and conflict resolution.
SQL BI Developer
Wells Fargo
May 2017 – Nov 2018
Developed complex SQL queries including joins, T-SQL, stored procedures, views, and triggers to implement business rules.
Analyzed query performance using SQL Profiler and optimized indexes.
Created ETL jobs using SSIS for data extraction, transformation, and loading into the data warehouse.
Scheduled SSIS packages via SQL Agent and configured database email notifications for job success/failure.
Created database objects including views, indexes, stored procedures, functions, and triggers following logical and physical design requirements.
Designed and deployed reports using SSRS within Visual Studio.
Extracted data from flat files, applied business logic transformations, and loaded into data warehouse via SSIS.
Created parameterized, drill-down, click-through, chart, matrix, and sub-reports using SSRS 2008.
Developed reports in multiple formats including Excel and PDF.
Delivered ad-hoc reports using SSRS to fulfill business requirements.
Created Power BI reports visualizing data per business needs.
Configured report servers and managed report scheduling and user permissions in SSRS.
Education
oBSc. Public Health, Purbanchal University, Nepal
Certification
oScrum Master Accredited
oGoogle Cybersecurity Professional
Contact
Email:***********@*****.***
LinkedIn: www.linkedin.com/in/jiban-kharel-bi
Contact this candidate