Senior BI Engineer - Power BI & Tableau Expert - Data Modeling & ETL

Kruti Lakhani

Plano, TX 669-***-**** ****************@*****.*** https://linkedin.com/in/kruti-lakhani/

PROFESSIONAL SUMMARY

Senior BI Engineer with 9 years of experience building enterprise reporting solutions using Power BI, Tableau, advanced DAX, and scalable semantic models. Served as the Power BI POC, leading the modernization of legacy SSRS reports into interactive Power BI dashboards and establishing development standards, best practices, and reusable templates for the team. Skilled in designing performant data models, optimizing report refresh and query performance, and developing analytics solutions on Snowflake and SQL. Experienced with ETL workflows (Alteryx, Azure Data Factory, SQL)

TECHNICAL SKILLS

•Business Intelligence Tools: Power BI, Tableau, SSRS, Alteryx, SSIS, Fabrics, Erwin, Azure Data Factory, Azure Synapse Analytics

•Databases: SQL Server, Snowflake, MySQL, PostgreSQL, Oracle, PySpark, Hive, Impala

•Programming: SQL, T-SQL, PL/SQL, Python, JavaScript, PowerShell, C#, DAX/MDX

•Cloud & Testing: Azure, AWS, Selenium, Atata.io, A/B Testing

•IDEs & Version Control: Microsoft Office, Visual Studio, JIRA, Agile, Git, Bitbucket, TFS

•BI: Data Quality Management, Data modeling, Data Visualization, Data Automation, Data Profiling, Data Lake, Data Mart

•Analytics: Engagement dashboards, adoption metrics, quartile segmentation, baseline KPI tracking

PROFESSIONAL EXPERIENCE

JP Morgan Chase Nov 2022 – Present

Sr Associate Data Visualization Engineer Plano

•Leveraged analytical thinking to deliver executive-level insights through 70+ SSRS, Tableau, and Power BI dashboards tracking KPIs, customer funnels, operational health, Risk Reporting, and performance scorecards.

•Designed high-performance Power BI data models, implemented Row Level Security (RLS), optimized relationships, and reduced refresh times for large datasets.

•Served as the Point of Contact (POC) for Power BI report development within the Home Lending analytics team, guiding developers on development standards,, data modeling, and performance tuning.

•Partnered with business stakeholders to prototype and deliver POCs (Proof of Concepts) showcasing interactive dashboards, automated insights, and modern visual capabilities that replaced static SSRS outputs.

•Developed complex Power BI reports using advanced DAX measures, M-Query, Power Query transformations, and optimized semantic models to support executive dashboards, KPI frameworks, and operational insights.

•Migrated reporting workloads from SQL Server to Snowflake under UDM modernization, improving data warehousing scalability

•Built Alteryx workflows automating KPI validation and improving data management, reducing manual processes by 40%.

•Optimized SQL stored procedures and long-running queries through data analysis, reducing execution time by up to 60%.

•Implemented pipeline scheduling and monitoring using Triggers, Pipeline Runs, Azure Data Factory alerts, and failure handling frameworks.

•Integrated ADF with enterprise data platforms including Azure Synapse Analytics, SQL databases, ADLS Gen2, APIs, and Power BI/Fabric ingestion layers.

•Leveraged LLM automation to generate documentation, source-to-target logic, and lineage for data governance, reducing development time by 40% and improving audit readiness by 35%.

•Collaborated across BI, data engineering, and DevOps teams using GitHub for automation code release and documentation tracking.

Bracebridge Capital LLC Jan 2020 - Nov 2022

Software Engineer - Business Intelligence Boston

• Monitored ETL pipelines to evaluate, analyze, identify bugs and room to improve data integrity and quality in the BI environment

• End-to-end BI ownership covering data ingestion transformation modeling visualization business insights delivery.

• Designed and developed analytical dashboard to compare daily ETL load in different environments using Power BI

• Improved data quality and governance by implementing validation checks using highly optimized SQL queries, which reduced failures by 40%.

• Automated analytics and administrative workflows using Python, with source control and deployment managed via GitHub.

• Acted as an internal Power BI resource for designing dashboards used for ETL monitoring, environment health checks, and reconcile processes.

• Implemented automated errors in resolving functionality of data-acquisition processes to stabilize environments

• Ingested data from different sources using a combination of Sql, Alteryx & Web API using C# to create data views used for BI

Boston Private Financial Services Jan 2019 - Aug 2019

Data & Reporting Analyst Co-op Boston

•Engineered Azure Data factory pipelines for full, delta, and watermark ingestion patterns improving throughput and reliability for financial reporting datasets.

•Tuned SQL procedures improving long-running transformations by 30% for analytics workloads.

•Built operational dashboards in Power BI and Log Analytics monitoring ingestion health, latency, and pipeline SLAs.

•Supported Power BI production deployments, validating refresh success, security configurations, and report performance post-release

Violet Infosystems Feb 2017 – Aug 2017

Business Analyst India

•Managed end-to-end LMS delivery by gathering client requirements, documenting workflows, and converting business needs into detailed functional specifications.

•Developed paginated and operational reports using Power BI Report Builder for regulatory and operational use cases

•Collaborated with product and engineering teams to clarify requirements, validate technical feasibility, and ensure accurate implementation of LMS features.

•Utilized SQL to extract, clean, and validate source data used in LMS workflows, ensuring accurate test results and consistency across environments.

•Designed detailed test cases and performed manual functional testing, including regression, integration, and workflow validation across LMS modules.

•Logged defects using QA tools, analyzed root causes, coordinated with developers on fixes, and retested to confirm technical and functional accuracy.

•Led UAT cycles, supported test environment setup, validated data flows, ensured cross-system compatibility, and secured business sign-off prior to go-live.

Insta Digital, India Aug 2016 – Feb 2017

Business Analyst India

• Collaborated with cross-functional partners (Product, Sales, Finance) to ensure data accuracy, define KPIs, & align marketing goals

• Used SQL to extract, validate, and reconcile marketing and customer datasets, ensuring accurate insights for performance reporting.

• Built BI dashboards and automated reports to track CTR, conversion funnels, campaign attribution, and customer engagement metrics.

• Performed Power BI model optimization using star schema design, calculated tables, and optimized DAX to improve report load times.

• Designed analytical data models that supported multi-channel campaign tracking, reduced manual effort, and improved performance visibility.

• Conducted segmentation, A/B testing, and statistical analyses to evaluate targeting strategies and quantify ROI uplift.

EDUCATION

Northeastern University

2017 - 2019

Master of Science, Information Systems

University of Mumbai

2012 - 2016

Bachelor of Science, Computer Engineering

Contact this candidate