BI Developer in Seattle, WA, United States

Developed a highly scalable and flexible metadata-driven ETL solution that provides auditability, configurability, graceful error handling, parallel execution, incremental data load, process orchestration and monitoring/notification enabling the data and analytics team to onboard any new source system without writing any new code and thus saving hundreds of hours.

Built a reporting solution that ingests major retailer sell-thru data coming in a wide variety of formats with automated data quality check using statistical and set business rules, transformation of the data into a common format, calculated various metrics for sell-thru rate, weeks of supply, etc, designed and developed a dashboard showing consolidate views for all retailers and also individual retailers, identifying opportunity for the business and call for actions.

Built a reporting solution to have transparency around product and service discount to government entities in different countries.

Data pipeline, transformation, cube, and reporting to have a clear view of the order pipeline and also warehouse performance tracking.

Developed an application that gathers various compliant information from clients based on their financial and business profile to make sure the organization is compliant with the Office of Foreign Asset Control.

A notification system using Azure Logic App, Enterprise Service Bus, and Queue to send custom emails and text message-based on configurations for an IoT solution.

Built the data pipeline with multiple retail POS systems and traffic tracker systems, created the data transformation process, Power BI reporting and dashboards showing core retail KPIs (AUR, UPT, AST, Traffic Conversion, Net Sales, Net Sales/SFT, etc), Sales and Traffic Trend, Drill down report, store by store comparison report, and an amazing view using Visio visual in Power BI that shows which section of a store is performing how well on a store layout diagram.

Built a chatbot using Azure and integrated it with Facebook Messenger to answer frequently asked questions about a website.

Implemented a reporting that takes photos as input and identifies all the faces in the picture, emotion, gender, age, facial features, etc. and displays that in a dashboard.

Designed the data model and developed a data pipeline and a BI Cube with row-level security and designed and developed reports/dashboards to measure the monthly/quarterly/annual sales goal of a company's sales representatives.

Designed data model, developed data pipeline and a report to measure the effectiveness of sales campaigns displaying the metrics for any selected campaign, the drill-down capability to see details sales information associated with the campaign, and also before and after picture of a campaign to understand the impact of it.