Bhuwan Prasad Bhatt, Data Architect and Software Developer in Patan, Central Development Region, Nepal
Bhuwan Prasad Bhatt

Data Architect and Software Developer in Patan, Central Development Region, Nepal

Member since April 26, 2021
With over six years of working in business intelligence, Bhuwan gained experience in all stages of the systems development lifecycle, including requirement gathering, architecture design, coding, testing, tuning, integration, reporting, and post support. He has consulted different retailers around the globe to transform their data into data lake and data warehouse solutions and designed meaningful visualization for businesses.
Bhuwan is now available for hire

Portfolio

  • Oracle
    Oracle Exadata, Oracle Cloud, RPM, Retail Merchandising System, ReSA...
  • LIS Nepal Pvt
    Data Warehouse Design, Oracle, Snowflake, Oracle Data Integrator (ODI)...
  • LIS Nepal Pvt
    Oracle, Oracle BIP, PostgreSQL, Teradata, Netezza...

Experience

Location

Patan, Central Development Region, Nepal

Availability

Full-time

Preferred Environment

Business Intelligence (BI), Oracle, Snowflake, Data Warehouse Design, ETL, Tableau, Microsoft Power BI, Python, Unix Shell Scripting, Oracle Data Integrator (ODI)

The most amazing...

...project I've delivered is a migration framework to migrate data from multiple sources into the central data warehouse and designed insightful BI reports.

Employment

  • Data Architect

    2020 - PRESENT
    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 with the client and Oracle functional team regularly to fit the data requirements of the new brands and in case of any customization in DMF.
    • Prepared the weekly summary reports on Jira status and discussed the progress with different vendors involved and SMEs.
    Technologies: Oracle Exadata, Oracle Cloud, RPM, Retail Merchandising System, ReSA, Oracle DSF, Retail Integration Bus (RIB), Oracle Retail, Jira, Tableau, Git, SharePoint, Business Intelligence (BI)
  • Senior Software Engineer | Senior BI Consultant

    2018 - PRESENT
    LIS Nepal Pvt
    • Contributed to requirement gathering sessions from onsite 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 framework of user and data-level security for 700+ operational reports (BIP and OBIEE) when the business expanded to different countries in APEC.
    • Designed thoughtful operational and analytical reports for 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.
    • Implemented the Oracle Retail Insights V16 for leading healthcare in the UK. Added the customization to the base product and created custom integration using ODI 12c.
    • 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 nine hours to 2.5 hours. Tuned the Oracle BIP reports, which used to take 1.5 hours and reduced the timing to eight minutes.
    • Prepared and automated the end-to-end daily integration validation between Oracle operational systems and the central data warehouse.
    • Prepared 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.
    • Prepared the plan for reclassification as-is and as-was reporting test, which was not supported in Oracle Retail Analytics 13.2.4. Delivered the OBIEE reports to clients based on historical trends.
    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)
  • 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
  • Software Engineer | BI Consultant

    2015 - 2017
    LIS Nepal Pvt
    • Designed and developed the customized data warehouse solution, ETL scripts to get the data from different sources using Unix shell script, and the validation framework to validate the data.
    • Served as L2 batch and data support for Oracle Retail Analytics for multiple clients 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.
    • Gathered 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, Retail Analytics, MicroStrategy, Oracle BIP, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Data Integrator (ODI), Python, Subversion (SVN), SQL, Business Intelligence (BI)

Experience

  • Data Migration Framework

    The challenge for one of the leading retailer's 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 leading cash and carry retailers in Asia.

    My roles in the project were:
    • Requirement gathering, feasibility analysis, providing the estimation for new report developments and designing the report as per the business requirements.
    • Providing training on BI reporting using BIP and OBIEE to the business end-users.
    • 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 sides 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 famous health care retailers in Europe.

    My roles in the project:
    • 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 for implementing the base and few custom areas of the product.

    Moles in the project:
    • 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, partitions tables, and data archive.
    • 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.
    • Regular interaction with Oracle support for the issue related to 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 famous retailers in North America.

    My role in this project was:
    • Requirement gathering from the onsite team. Developed the integration for the custom subject areas like store traffic, sales forecast, and transactional sales.
    • Prepared the technical design documentation of all the custom integration.
    • Automation of 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.

Skills

  • Languages

    Snowflake, SQL, Python, C++, C, Java
  • 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
  • Paradigms

    Business Intelligence (BI), ETL, Object-oriented Programming (OOP), Oracle ODI
  • Platforms

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

    Database Management Systems (DBMS), Teradata, Netezza, Oracle Cloud, PostgreSQL
  • Other

    Data Warehouse Design, Unix Shell Scripting, Retail Analytics, MicroStrategy, Oracle BIP, Data Mining, Computer Graphics, Retail Merchandising System, ReSA, Oracle DSF, Retail Integration Bus (RIB), Networking, Data Structures, Data Warehousing

Education

  • Bachelor's Degree in Computer Engineering
    2011 - 2015
    Institute of Engineering, Pulchowk Campus - Pulchowk, Lalitput, Nepal

Certifications

  • Snowflake Academy Certification
    JULY 2019 - PRESENT
    Snowflake

To view more profiles

Join Toptal
Share it with others