Bhuwan Prasad Bhatt, Developer in Patan, Nepal
Bhuwan is available for hire
Hire Bhuwan

Bhuwan Prasad Bhatt

Verified Expert  in Engineering

Data Architect and Software Developer

Location
Patan, Nepal
Toptal Member Since
August 9, 2021

With over six years working in business intelligence, Bhuwan has gained experience in all stages of the systems development lifecycle, including requirements gathering, architecture design, coding, testing, tuning, integration, reporting, and post-support. Bhuwan has consulted different retailers around the globe, transforming their data into data lake and data warehouse solutions and designing meaningful visualizations for businesses.

Portfolio

Freelance
Microsoft Power BI, SQL, Microsoft SQL Server, Documentation, SAP, Databases...
LIS Nepal Pvt
Data Warehouse Design, Oracle, Snowflake, Oracle Data Integrator (ODI)...
Oracle
Oracle Exadata, Oracle Cloud, RPM, Retail Merchandising, Oracle...

Experience

Availability

Full-time

Preferred Environment

Business Intelligence (BI), Oracle, Snowflake, Data Warehouse Design, ETL, Tableau, Microsoft Power BI, Python, Dataiku, Data Engineering

The most amazing...

...project I've delivered is a migration framework, migrating data from multiple sources into the central data warehouse and designing insightful BI reports.

Work Experience

SQL Developer

2022 - PRESENT
Freelance
  • Managed performance optimization of long-running SQL queries.
  • Handled a project to calculate the ETA of sales orders created by dealers for which the items were in in-transit status. Developed complex SQL/T-SQL queries to extract data from SAP, transformed the data, and loaded it into the required tables.
  • Created batch scripts to automate the daily data load process.
  • Designed the Power BI KPI reports to display the delayed orders from the supplier to the warehouse.
Technologies: Microsoft Power BI, SQL, Microsoft SQL Server, Documentation, SAP, Databases, Data Cleansing, Data Analysis, Data Governance, Microsoft Excel, Data Pipelines

Senior Software Engineer | Senior BI Consultant

2018 - PRESENT
LIS Nepal Pvt
  • Contributed to onsite requirement gathering sessions and led the offshore team to deliver the planned tasks efficiently. Regularly interacted with the Oracle support team to fix and enhance the existing bugs.
  • Designed and developed a user and data-level security framework for 700+ operational reports (BIP and OBIEE) when the business expanded to different countries in APEC.
  • Developed thoughtful, operational, and analytical reports for the accounting, store operation, and logistics teams using BIP, OBIEE, Power BI, and Tableau.
  • Contributed to the lift and shift process for a client to different countries like India and China during the business expansion. Customized the existing systems based on the local currency and languages.
  • Provided training on BI reporting using BIP and OBIEE to the business end users.
  • Optimized the performance of base and custom ETL batches (ODI and Unix script) and reduced the nightly batch time from around 9 hours to 2.5 hours. Tuned the Oracle BIP reports—which used to take 1.5 hours—and reduced the timing to 0.8 minutes.
  • Prepared and automated the end-to-end daily integration validation between Oracle operational systems and the central data warehouse.
  • Created the history conversion design framework, documentation, testing, and validation and scheduled the nightly batch in Automic (UC4) and Control-M based on the client's preference.
  • Built the plan for the reclassification of as-is and as-was reporting tests, which was not supported in Oracle Retail Analytics 13.2.4. Delivered the OBIEE reports to clients based on historical trends.
  • Implemented Oracle Retail Insights 16.0 for a leading healthcare company in the UK. Added the customization to the base product and created a custom integration using ODI 12c.
Technologies: Data Warehouse Design, Oracle, Snowflake, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle BIP, Unix Shell Scripting, Python, Jira, HP Application Lifecycle Management (ALM), Microsoft Power BI, Tableau, Confluence, Automic (UC4), SOS Berlin Scheduler, Control-M, Business Intelligence (BI), Databases, Data Cleansing, Data Governance, Data Strategy, Data Analysis, Data Engineering, Microsoft Excel, ETL Tools, Data Pipelines

Data Architect

2020 - 2021
Oracle
  • Designed and developed the Data Migration Framework (DMF) to migrate the data of 90+ brands from different legacy systems to the Oracle merchandise operation management system.
  • Created the validation framework on DMF itself, which validates the extracted data from the legacy system to the business case provided by the functional team.
  • Interacted regularly with the client and the Oracle functional team regarding the new brands' data requirements and any customization in DMF.
  • Prepared the weekly summary reports on the Jira status and discussed the progress with different vendors and SMEs.
Technologies: Oracle Exadata, Oracle Cloud, RPM, Retail Merchandising, Oracle, Retail Integration Bus (RIB), Oracle Retail, Jira, Tableau, Git, SharePoint, Business Intelligence (BI), Data Engineering, Data Migration, Excel VBA, Microsoft Excel, Technical Architecture, ETL Tools, Data Pipelines

Managed Services Lead

2016 - 2017
LIS Nepal Pvt
  • Developed operational and analytical reports from data warehousing solutions (Oracle RA).
  • Tracked the issues raised by clients and resolved them promptly.
  • Created a roster plan for 24/7 L2 batch support for the retail analytics solution.
  • Planned the upgrade of Oracle Retail Analytics from version 13.2.4 to 13.2.8.
  • Gathered the requirements from clients for new features and accomplished them with effective solutions.
Technologies: Oracle, Oracle BIP, PostgreSQL, Teradata, Netezza, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle ODI, Jira, Confluence, Subversion (SVN), Unix Shell Scripting, Data Strategy, Data Governance, Data Engineering, Monitoring

Software Engineer | BI Consultant

2015 - 2017
LIS Nepal Pvt
  • Designed and developed a customized data warehouse solution with ETL scripts to get the data from different sources using Unix shell script and a validation framework to validate the data.
  • Served as L2 batch and data support for Oracle Retail Analytics for multiple clients all over the globe.
  • Gathered the requirements from the onsite team and led the offshore team of six to eight members to deliver the customization of the existing warehouse solution.
  • Assembled the requirements from the client and designed the custom ELT integration package using Oracle Data Integrator (11g and 12c).
  • Designed and tested 15+ new operational reports of store operation using MicroStrategy.
  • Developed the custom integration package to handle the product and organization reclassification using shell scripting.
Technologies: Oracle, Teradata, Netezza, Data Warehouse Design, Unix Shell Scripting, Analytics, Retail & Wholesale, MicroStrategy, Oracle BIP, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Data Integrator (ODI), Python, Subversion (SVN), SQL, Business Intelligence (BI), Data Engineering, ETL Tools

Data Migration Framework

The challenge for one of the leading retailer groups in Kuwait was to migrate the data of 90+ brands from different legacy systems to a centralized Oracle merchandising operation management suite.

• Designed and developed a Data Migration Framework (DMF) to migrate the data from the legacy system to the Oracle MOM suite.
• Executed the DMF framework to facilitate the data conversion.
• Gathered the requirements from the business to adopt data migration of custom subject areas in MOM.
• Collaborated and had regular discussions with different vendors on data support.

BI Reporting

Oracle Retail Analytics was implemented as a data warehouse model for Asia's leading cash and carry retailer.

My role in the project required the following:
• Performing requirement gathering, providing feasibility analysis, estimating new report developments, and designing the report per the business requirements.
• Providing training on BI reporting using BIP and OBIEE to the business end-users.
• Handling the performance tuning of long-running BIP reports, which were critical to business, and enhancing overall system performance.
• Providing technical support on the defects and issues raised for the reports and fixing the reports.
• Customizing the base RA warehouse during the business expansion to different countries for localization, currencies, tax, GST, and MRP.
• Preparing and automating the end-to-end daily integration validation between MOM and RA.
• Preparing and automating the system monitoring reports, especially for the reporting side, using Power BI.
• Developing insightful operational and analytical reports using BIP, OBIEE, and Power BI.

Oracle Retail Insights Implementation

Oracle RI V16 was implemented for a famous healthcare retailer in Europe.

In this project I:
• Led the offshore team from onsite to implement Oracle Retail Insights V16 with custom development.
• Contributed to development, testing, and validating the data across the development and SIT cycle.
• Prepared the history conversion design documentation, testing, and validation.
• Created and helped to set up the night batch flow of the scripts in UC4.
• Designed technical design documentation and developed the optimal solution for ETL in ODI.

Oracle Retail Analytics Implementation and Support

Retail Analytics is Oracle's warehouse data model. I was the team lead responsible for implementing the base and customizing a few areas of the product.

Project deliverables:
• Implemented the base product for the client.
• Provided functional as well as technical training to business end-users.
• Designed the custom ETL integration for new subject areas.
• Involved in extending the business calendar, partition tables, and data archives.
• Prepared and automated daily integration validation between MOM and RA.
• Optimized the ODI base packages and long-running scripts.
• Analyzed and fixed errors and bugs in base RA integration packages.
• Maintained regular interaction with Oracle support for the issues related to the base integration in RA.
• Prepared the BIP and OBIEE reports for the business.
• Documented the issues during nightly batches as part of the batch support document.

In-house Data Warehouse Design

Developed and designed the in-house data warehouse for a famous retailer in North America.

My role in this project required the following:
• Gathering requirements from the onsite team.
• Developing the integration for the custom subject areas like store traffic, sales forecast, and transactional sales.
• Preparing the technical design documentation of all the custom integration.
• Automating data validation between the operational data source and DW.

Customization on Existing EDW

The enterprise data warehouse was already implemented for the famous jewelry retailers.

My role in this project was:
• Requirement gathering and coordination with the onsite team.
• Analyzed and fixed errors and bugs in the Unix ETL shell scripts.
• Collected and documented new data warehousing and reporting requirements for the store operation team.
• Developed and tested new ETL scripts as per the client’s requirements (UK store and eCommerce integrations).
• Designed and tested the new MSTR reports as per the business needs.
• Developed and tested new BIPublisher and MSTR reports as per the client’s requirement.
• Used Oracle Retail Sales Audit (ReSA) for the sales audit and analyzed and resolved the errors.

SQL Development

The project required extracting the data from SAP and applying the logic of expected arrival date as part of the transformation to calculate the ETA of sales orders. The dealers were facing the challenge of seeing the exact ETA of sales orders created from the BOSSWeb. As part of this project, ETA was calculated based on the in-transit item order and placed sales order based on the sales order creation date.

Additionally, building the dashboard to show the KPI metrics on late orders was essential. The dashboard displays the average in-transit time to get the sales order from supplier to dealers, the most delayed sales orders, performance by region, and more.

Languages

Snowflake, SQL, Python, C++, C, Java, T-SQL (Transact-SQL), Excel VBA

Tools

Microsoft Power BI, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Subversion (SVN), Jira, HP Application Lifecycle Management (ALM), Git, Tableau, Confluence, Automic (UC4), Oracle Exadata, RPM, SOS Berlin Scheduler, Control-M, Microsoft Excel

Paradigms

Business Intelligence (BI), ETL, Object-oriented Programming (OOP), Data Science, Oracle ODI

Platforms

Oracle, Oracle Data Integrator (ODI), Oracle Retail, SharePoint, Dataiku, Oracle Data Integrator 11g, Oracle Data Integrator 12c

Storage

Database Management Systems (DBMS), Databases, Data Pipelines, Teradata, Netezza, Oracle Cloud, PostgreSQL, Microsoft SQL Server

Industry Expertise

Retail & Wholesale

Other

Data Warehouse Design, Unix Shell Scripting, Analytics, MicroStrategy, Oracle BIP, Data Engineering, Data Analysis, Data Cleansing, Technical Architecture, ETL Tools, Data Mining, Computer Graphics, Retail Merchandising, Retail Integration Bus (RIB), Monitoring, Networking, Data Structures, Data Warehousing, Documentation, SAP, Forecasting, Data Governance, Data Strategy, Data Migration

2011 - 2015

Bachelor's Degree in Computer Engineering

Institute of Engineering, Pulchowk Campus - Pulchowk, Lalitput, Nepal

JULY 2022 - PRESENT

ML Practitioner

Dataiku Academy

JULY 2022 - PRESENT

Core Designer Certificate

Dataiku Academy

JULY 2019 - PRESENT

Snowflake Academy Certification

Snowflake

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring