Kalpanish Kothari
Austin,TX
Summary
Over 6 years of experience in designing, developing, and deploying business intelligence solutions. Proficient in SQL query optimization and data transformation techniques. Skilled in leveraging PowerBI for creating impactful reports and dashboards that drive business decisions.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Vice President, Business Intelligence Lead
The Bank of New York Mellon
03.2022 - Current
- Gathered data from Impala, ODBC, SharePoint, and Excel to construct a robust data model using Star/Snowflake schema.
- Led initiatives to assess user needs and established feedback mechanisms for report enhancement.
- Created standard operating procedures for data modeling, requirement gathering, report development, and deployment.
- Achieved improved stability and reduced maintenance by developing a unified shared data model.
- Implemented interactive features such as RLS, Data Alerts, Subscriptions, Drill-Through, and Custom Tooltips to increase user engagement.
- Managed Power BI workspace activities, including access control, app configuration, deployment pipeline setup, and refresh schedules.
- Conducted proof-of-concept projects to demonstrate Power BI capabilities and promote organizational adoption.
- Monitored usage reports to identify challenges and effectively track user engagement.
Power BI Architect
Fiserv
07.2021 - 01.2022
- Led 25 developers in migrating over 600 reports from Hyperion Studio to the Power BI environment.
- Designed end-to-end Power BI solutions that addressed complex business requirements.
- Reduced report development time by fifty percent through the implementation of best practices and shared datasets.
- Provided technical guidance on Power BI architecture to development teams.
- Conducted data assessments and audits to identify quality issues during migration to the Power BI platform.
- Engaged stakeholders at all levels to gather feedback and refine Power BI solutions for enhanced impact.
Power BI Developer
Microsoft
12.2019 - 06.2021
- Developed and designed comprehensive reports and dashboards on the Power BI platform.
- Compiled data from various sources, including SSMS and Excel, for accurate reporting.
- Produced more than 50 reports to facilitate Microsoft customers' onboarding.
- Established and sustained data models within tabular cube and Power BI datasets.
- Maintained documentation of data sources through data dictionaries and metadata catalogs.
- Executed security measures, including RBAC, to ensure regulatory compliance.
- Pinpointed areas for process enhancements to minimize support calls.
Education
MS - Engineering Management
The University of Texas at Arlington
05.2019
Skills
- Power BI
- SQL
- Data modeling
- Azure
- DAX
- MDX
- SSRS
- SSAS
- Star Schema
- Snowflake schema
- Power Apps
- GIT
- Excel
- Data Warehouse
- SharePoint
- ER modeling
Certification
- Power BI Data Analyst Associate (IP), Microsoft
- Advance MS Excel, Udemy, UC-331S62VW
- Agile Project Management (APM), AgileKB
- Project Management Essentials Certified, Management and Strategy Institute
Projects
Graduate Research Assistant, Published paper Utilizing Internet of things [IOT] Technologies to prevent Mass gun related Shootings Advance Engineering Economics Analysis, Analyzed the capital investment in engineering and technical projects using MS Excel and Calculated returns based on worth methods, rate of return, depreciation, taxes and revenue requirements
Timeline
Vice President, Business Intelligence Lead
The Bank of New York Mellon
03.2022 - Current
Power BI Architect
Fiserv
07.2021 - 01.2022
Power BI Developer
Microsoft
12.2019 - 06.2021
MS - Engineering Management
The University of Texas at Arlington
Similar Profiles
ANKUR WADHEANKUR WADHE
Associate I at Bank of New York Mellon (BNY Mellon)Associate I at Bank of New York Mellon (BNY Mellon)
Vishal TilwaniVishal Tilwani
Associate, AML/Prevention/KYC Representative at BNY Mellon (Bank of New York Mellon)Associate, AML/Prevention/KYC Representative at BNY Mellon (Bank of New York Mellon)
Varun PeterVarun Peter
Vice President Middle Office at The Bank of New York MellonVice President Middle Office at The Bank of New York Mellon
Scott ThompsonScott Thompson
Director - U.S. Head of Default Services at The Bank of New York MellonDirector - U.S. Head of Default Services at The Bank of New York Mellon
Tatiana T. TorresTatiana T. Torres
Senior Enlisted Advisor at U. S. Navy, Recruit Training CommandSenior Enlisted Advisor at U. S. Navy, Recruit Training Command