Bonny Pradhan

Robling data warehouse was implemented for a retailer. The database was migrated to a cloud-based Snowflake database using Python scripting. Looker reporting application provided an ad-hoc interface where the client's business users could create interactive reports.

I was a consultant who worked with top leadership at a national-level retailer in Indonesia with 150 stores to implement an Oracle data warehouse system and BI reporting platform.

The Oracle retail analytics system was implemented for the enterprise using Oracle DB, and five years of data were converted. We developed company-wide Power BI dashboards, scheduled reports for stores, and provided secure data for buyers. An ad hoc reporting environment was also set up, and access was provided to specific users. I collaborated with stakeholders at the management and operational levels to validate the data in reports. I also provided training on the reporting system to the client's business and technical customer support. The project needed advanced SQL queries for ETL for its complex source systems and reporting.

A large retailer in the US had a large ERP system and need to analyze and utilize their data for decision making. A customized data warehouse product was developed for the project and shell scripts were developed for the ETL module.

Some data marts like store plan and store traffic were relatively more complex. Advanced SQL was written for the extraction of data for these data marts, achieved by thorough requirement gathering from the client. Legacy scripts used were then migrated and the data model was designed to incorporate them in the data warehouse.

A master's thesis was done on on-demand services niche markets for an application of a ride-hailing service for women.

A model was developed to show the identifiers and key success variables for a niche market for an on-demand service. The model was validated by a questionnaire survey and quantitative data analysis with SPSS. The model was also illustrated for a ride-hailing service for women and an app was developed for the same.

The national stock exchange (NEPSE) in Nepal needed some upgrades to its web application.

Customizations were done in the centralized trading application to add certain features. Advanced MySQL queries were also written for reporting in the security module. Eight reports were developed using these queries including, circular trade report and broker relationship report.