Nidhi Karia
Business Intelligence Analyst | Azure & AWS Data Engineering | Power BI, Snowflake, dbt | Capital Markets & Healthcare Analytics | GC HOLDER
- Role
- Business Intelligence Analyst at BNY
- Location
- Aurora, IL, US
- LinkedIn followers
- 500 followers
About Nidhi Karia
I’m a Business Intelligence Analyst whose passion is transforming raw data into…
Experience
Business Intelligence Analyst
Oct 2024 — Present · Chicago, IL, US
Architected a Kimball star schema in Azure Synapse and SQL Server for securities lending analytics with conformed dimensions, reducing query latency to 2.2 seconds. Engineered Azure Data Factory and Databricks PySpark pipelines to ingest SWIFT ISO 20022 and Bloomberg pricing to Snowflake, processing 9M records daily. Developed interactive Power BI dashboards with DAX calculations for liquidity risk, Finance, and Treasury, delivered 12 executive dashboards. Governed data lineage in Collibra and enforced BCBS 239 controls for risk marts, clearing 2 internal and 1 external audit. Automated trade-to-GL reconciliation using Python, SQL, and Alteryx for custody cash settlements, eliminating manual checks and saving 10 hours per week. Integrated Bloomberg and Refinitiv corporate actions and pricing via Informatica and REST APIs into the securities master, cutting NAV calculation window to 35 minutes. Deployed CI/CD for BI assets for SSRS and Tabular models with Git, Jenkins, and Docker, added SQL unit tests and data contracts, cutting release cycles from 10 to 2 days.
Education
Springboard
Certification Course , Data Analysis
Saurashtra University, Rajkot
Master of Arts - MA, Literature
Saurashtra University, Rajkot
Post Graduation Diploma Computer Application , Computer Programming, Specific Applications
Bhavnagar University, Bhavnagar,India
Bachelor of Arts - BA, Literature
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.