Verified Expert in Engineering
Data Engineer and Developer
Motiram is a data engineer with over eight years of technical experience focused primarily on designing, developing, and implementing on-premise and cloud data warehouse systems. With his broad knowledge, experience, and expertise in retail processes, data, and systems, Motiram can translate business ask into optimum technical solutions, analyze potential impacts on other business processes, and deliver solutions that add maximum value to the business.
PyCharm, Python, Amazon Web Services (AWS), Snowflake, MicroStrategy, ETL, Data Warehouse Design, BI Reporting, Data Processing Automation, SQL
The most amazing...
...project I've done is the real-time sales integration for stores to track inventory and sales trends and generate hourly out-of-stock alert reports.
Solution Architect | Offshore Delivery Lead
LIS Nepal Pvt. Ltd.
- Led project delivery, enhancing data warehouse implementation and development projects for multiple US Retail clients, resulting in a 20% improvement in data accessibility and a 15% increase in reporting efficiency.
- Collaborated with an onsite consultant, understanding problem statements and requirements, leading to successfully planning and implementing solutions that exceeded client expectations.
- Designed and developed applications, ensuring timely and quality project delivery, resulting in a 25% reduction in development time, as an offshore development lead.
BI Implementation Consultant | Data Architect
Logic Information Systems
- Implemented data warehousing and business intelligence solutions for multiple clients onsite, resulting in a 30% improvement in data processing speed and a 20% increase in analytical capabilities.
- Worked as a technical data engineer in integrating, visualizing, and analyzing data from various sources into data lakes and warehouses, improving overall data accuracy by 15%.
- Designed and implemented ETL processes for data warehouse, optimizing data flow, improving efficiency, and reducing data processing errors by 25%.
Senior BI Developer
LIS Nepal Pvt. Ltd.
- Developed and implemented different data warehousing solutions built on Oracle and Teradata, resulting in a 25% improvement in data retrieval times.
- Implemented ETL solutions using custom scripts and industry-standard tools, optimizing data processing efficiency and reducing data processing costs by 20%.
- Successfully served as a retail analytics implementation consultant at Siam Makro Thailand, contributing to a 30% enhancement in retail analytics processes and decision-making.
- Worked as level two batch support for Oracle Retail Analytics batch for multiple clients.
- Developed ETL and history conversion scripts for Oracle Retail Analytics.
- Created and validated OBIEE and BIP reports as per the requirements.
- Developed custom Oracle Data Integrator packages for customer ETL integration with the Oracle ecosystem.
Azure-based Healthcare Application for Inventory Management
Additionally, an automated data ingestion framework and enhanced reporting through Azure Power BI resulted in a 40% reduction in processing time and a 20% increase in data-driven decision-making. The streamlined Azure setup achieved a 15% reduction in operational costs, showcasing the tangible impact on efficiency, accuracy, and cost-effectiveness in healthcare inventory management.
Tableau for Customer Self Service Analytics
Moreover, this transition facilitated a sales-driven impact, providing stakeholders real-time insights into customer behavior and preferences. The implementation met business needs and empowered users with self-service capabilities, allowing them to make data-informed decisions on-demand. This evolution from Excel-based reports to easily accessible, standardized Tableau reports streamlined end-of-month/week reporting and drove sales efficiency by enabling data-driven decision-making at any time and from any location.
AWS Data Pipeline for Customer Analytics
I led technical requirements gathering and integration design sessions and played a vital role in shaping the project's success, contributing to a 25% acceleration in the development timeline. The culmination of these efforts, spanning 8+ months, resulted in a centralized data foundation for customer analytics. This transformative initiative enabled the client to track customer key performance indicators (KPIs) in conjunction with sales and marketing KPIs, providing a comprehensive, single source of truth. The standardized marketing reporting platform further streamlined processes, fostering a more agile and strategic approach to future growth and customer-centric strategies, leading to a 20% increase in overall operational efficiency.
Real-time Sales Integration
The system ingested sales and inventory data every 15 minutes, resulting in a 25% reduction in reporting latency. Leveraging Python, Snowflake, and Power BI, this streamlined pipeline ensured the timely generation and publication of hourly reports. Used Power BI Premium or Embedded capacity for refresh intervals, critical data security features boosted privacy, leading to a 20% increase in user confidence. This transformative project significantly improved store managers' visibility of available items, empowering proactive inventory management, informed decisions, and streamlining processes by 30%.
Omnichannel Reporting for Enterprise Data Warehouse
I implemented data security measures, safeguarding customer-sensitive data within MicroStrategy reports. Scheduled report distribution improved accessibility, resulting in a 20% increase in user efficiency. The project seamlessly transitioned to MicroStrategy, providing omnichannel key performance indicator (KPI) visibility on both mobile and web platforms. When users sought additional analysis, reports were delivered in Excel as part of the scheduled process, enhancing analytical experiences.
Data Warehouse Implementation Using Snowflake and Microsoft Azure
In technical execution, I played a key role in constructing a new data warehouse on the Snowflake database. Leveraging native Snowflake features, Azure Data Lake Storage, Snowpipes, Streams, and Azure tools, the project achieved a 30% enhancement in data processing speed. Custom integrations using Snowflake and report development on Tableau with Power BI addressed unique business analytical needs, leading to a 25% increase in report relevance.
Scheduled report distribution via various channels, including email, printer, and network drive, resulted in a 20% improvement in user accessibility. This comprehensive implementation empowered decision-makers, providing a profound understanding of business-driving factors. The documented technical design, production deployments, and functional data documents ensured clarity, contributing to a 30% increase in operational efficiency. The project significantly elevated analytical capabilities, with a 20% enhancement in data-driven decision-making for all stakeholders.
Python-based Accelerator Package for Teradata ODS
In this role, I designed, developed, and tested data pipelines using Python for the ODS Teradata layer. I provided comprehensive documentation, including architecture diagrams, process flows, and technical design documents. Collaborating closely with the onsite project lead, I communicated technical issues, blockers, milestones, and plans, ensuring a cohesive development process.
Introducing the custom Python package empowered the client's tech team to incorporate new data sources with minimal effort effortlessly. Post-implementation, the maintenance overhead was significantly reduced by around 60%, showcasing the project's success in optimizing efficiency and simplifying the integration process for ongoing data sources.
Oracle Retail Analytics Migration Project
As a tech lead, I prepared the implementation plan and upgraded the strategy. Actively participated in data profiling, reports, and table rationalization. Prepared mapping document between the legacy source system and RA. Provided technical support on OBIEE and BI Publisher (BIP) report migration.
In addition, I prepared Oracle RA cutover strategies to align the cutover plan with other integrated systems. Put together a plan for data validation between the old and newer versions of systems and across the merchandising system.
Around 8 TB of data, nearly 200 legacy reports, and around 450 manual report schedules were migrated as part of this project. Rationalized 1500 tables in existing legacy to around 1000 tables in new RA system. All dbt transformations were moved to Oracle Data Integrator (ODI), and manual report schedules were automated. This reduced around 90% of the manual effort to send report emails to each department, store, buyer, and supplier.
Oracle Retail Analytics Implementation
I was a project lead for implementing Oracle Retail Analytics for multiple clients. As part of the base implementation, I deployed the Oracle base data model and pre-built base reports and integration package in ODI.
As part of the customization and depending on business needs, I developed custom integration with source systems and custom reports on BIP, OBIEE, and Power BI. These reports were also scheduled to users via different channels like email, printer, network drive, and others.
In addition, the Oracle Apex app was created on top of its warehouse management system, which runs on the Oracle Database for scanning items and automatically generating correct prices and currency labels.
Merchandise Reclassification Support and Performance Tuning
As a developer and data analyst, I analyzed the system process and the bottleneck and prepared custom packages to improve the performance of reclassification processing in RA. I executed the reclassification process in analytics and built custom integration to build the validation process for as-is aggregation. I also added custom reporting views to enable as-is reporting.
The performance was improved by around 60% with custom integration packages for reclassification. Now, the client will also have visibility of As-Is vs. As-Was KPI performances.
Python, Snowflake, SQL, Stored Procedure, Java, C#
ETL, Database Development, Modular Design, Dimensional Modeling, Business Intelligence (BI), Kanban, Scrum, Data Science, Azure DevOps
Oracle Data Integrator (ODI), Microsoft, Oracle, Unix, Microsoft Power Automate, Azure, Azure SQL Data Warehouse, Google Cloud Platform (GCP), Amazon Web Services (AWS), Jupyter Notebook, Alteryx, Dedicated SQL Pool (formerly SQL DW), Dataiku, Oracle Database, AWS Lambda, Azure Functions, Azure Synapse
Data Pipelines, Data Integration, Database Modeling, Databases, RDBMS, Database Architecture, Teradata, Amazon S3 (AWS S3), Redshift, SQL Performance, Teradata Databases, Data Lakes, PostgreSQL, Database Migration, SQL Stored Procedures, MySQL, MongoDB, Azure SQL Databases, Microsoft SQL Server, NoSQL, Azure SQL, SQL Server Integration Services (SSIS)
MicroStrategy, Data Warehouse Design, Scripting, Analytics, Data Analytics, BI Reporting, Data Architecture, Data Modeling, Data Analysis, Data, Reports, Reporting, Integration, Data Visualization, Interactive Dashboards, Data Engineering, Data Warehousing, Automated Data Flows, Schemas, Star Schema, Database Schema Design, Pipelines, Warehouses, ELT, Data Processing Automation, BI Reports, Relational Database Design, Unix Shell Scripting, Oracle BIP, Agile Sprints, Customer Analytics, Dashboards, APIs, Data-level Security, Job Schedulers, Scheduling, CSV, MicroStrategy Visual Insight, Online Sales, Online Shops, Web Dashboards, Azure Data Lake, Azure Data Factory, Data Migration, Migration, Cloud Migration, Amazon RDS, Consulting, Fivetran, Big Data, Documentation, Design, Data Reporting, Decision Support Systems, API Integration, Machine Learning, Google BigQuery, Startups, Metabase, Data Build Tool (dbt), Microsoft Azure, Microsoft Fabric
PyCharm, Apache Airflow, AWS Glue, AWS CLI, Amazon Elastic MapReduce (EMR), Amazon Athena, Tableau, Microsoft Power BI, Microsoft Excel, Looker, Google Analytics, BigQuery, Power Query, Microsoft Access, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Matillion ETL for Redshift, Oracle Application Express (APEX), Microsoft Power Apps, Azure DevOps Services
Bachelor's Degree in Computer Engineering
Tribhuvan University - Kathmandu, Nepal
Core Designer Certificate
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