Badges
Certifications
Work Experience
Business intelligence Developer
Confidential CC• July 2023 - Present
Microsoft Power BI Developer
Banner Health• October 2022 - February 2023
• Write Complex SQL queries on Teradata Studio such as Multi-joins to unite many tables as source code • Write SQL code for a materialized view on Teradata studio using many tables at once. • Work in agile methodology utilizing bi-weekly sprints. • Write DAX code to fulfill business need by using calculate, format, sum, average, and divide. • Write dynamic dax code to determine the color of text base on underlying data. • Create tooltip pages to bring more context to visuals for business stakeholders. • Optimize and dramatically increase the performance of a PBI report by reducing the underlying data size. • Create sparklines on a table visual using dates from a date table. • Implement data modeling using star schema to efficiently manage table relationships.
Microsoft Power BI Developer
FINRA• December 2021 - September 2022
• Write Complex queries on postgresql database to pull data and maintain database integrity. • Write DQL, DDL, and DML type of queries in postgresql to fact check current power bi dashboards. • Work with power bi premium to manage workspace and to create paginated reports. • Create KPIs to capture business performance. • Use cards to show crucial business metrics. • Create stacked column and bar charts for showcase of business leadership within organization. • Write complex DAX queries that make use of calculate, concatenate and various time intelligence functions. • Manage the deployment of test power bi workspace to production power bi work space. • Query data from amazon web services database. • Perform power query modification by writing code in M language. • Enabled many Drill-Throughs and Cross Report Drill Throughs on reports to enhance user experience. • Work in agile methodology, go through bi weekly sprints and demonstrate relevant IT tickets.
Senior Power BI Developer
Columbia University• February 2021 - November 2021
• Manage and perform machine learning using AutoML and drag and drop feature in azure platform. • Use Dax studio to perform ETL transformation on CSV data of 150,000 rows. • Perform complex data modeling within power bi to fulfil business logic. • Use SSAS as data source for report for the school of international and public affirs. • Utilize data from SQL server views and some times write complex SQL queries. • Routinely use azure blob storage for data ingestion and data source for power bi dashboards. • Manage Premium work spaces and use premium features such as paginated reports. • Manage and perform machine learning on dataflow in power bi service. • Perform complex data modeling task to fulfil business logic for various departments in Columbia university. • Juggling multiple projects from clients from within Columbia university, also meeting deadlines when projects are due. • Write R code to produce R visual in power bi desktop, such as loess regression curve and violin chart. • Create report for what-if analysis, using what-if analysis option in power bi desktop. • Modify KPIs and Cards for business logic. • Generate visual to visual edit interactions to manipulate cross-filtering function in power bi desktop.
Senior Business Intelligence Developer
Dentsu Aegis• February 2013 - January 2021
• Analyze Data from Azure SQL Server Database(10TB+). • 50% Microsoft Power BI Development and 50% SQL Development. • Worked on migrating reports from Tableau and SSRS to Power BI. • Gather Power BI/SQL development requirements directly from Microsoft client. • Use live connection to get update report • Pin visuals from many sources such as Q&A and workbook to dashboard to tell a story. • Design interactive buttons in power bi report to adjust for viewing pleasure. • Build drill down reports in SSRS. • Build Parametrized reports in SSRS. • Migration of SSRS reports to Microsoft Power BI.
Education
State University of New York at Stony Brook
Applied Mathematics and Statistics, BS• September 2008 - July 2012
State University of New York at Stony Brook
Economics, BA• September 2008 - July 2012