Bhuwan Prasad Bhatt
Verified Expert in Engineering
Data Architect and Software Developer
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
Experience
Availability
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
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.
Senior Software Engineer | Senior BI Consultant
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.
Data Architect
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.
Managed Services Lead
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.
Software Engineer | BI Consultant
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.
Experience
Data Migration Framework
• 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
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
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
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
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
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
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.
Skills
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
Education
Bachelor's Degree in Computer Engineering
Institute of Engineering, Pulchowk Campus - Pulchowk, Lalitput, Nepal
Certifications
ML Practitioner
Dataiku Academy
Core Designer Certificate
Dataiku Academy
Snowflake Academy Certification
Snowflake
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring