Manil Shrestha
Verified Expert in Engineering
Data Engineering Developer
With over four years of experience in business intelligence, ETL, and Dataviz, Manil is the perfect contractor to help you capitalize on your data. He has an obsession with the highest quality of work and will never complete a project until the client is fully satisfied. If you are looking to automate your data pipeline and build visually impactful Tableau or Power BI dashboards to improve business outcomes, you have come to the right place.
Portfolio
Experience
Availability
Preferred Environment
Data Visualization, Database Design, Data Engineering, Reporting, ETL, Python, Tableau, Microsoft Power BI, Snowflake, Oracle
The most amazing...
...feeling was to streamline a company's data from multiple sources into a centralized warehouse leading an increased efficiency of data team by estimated 80%.
Work Experience
Data Engineer and Data Viz Specialist
Freelance
- Developed meaningful and effective dashboards for multiple clients that would serve as decision support for the organization.
- Helped streamline the data infrastructure of small to mid-sized companies. Implemented ETL environments for customized data warehouse implementation. Oversaw data modeling and warehouse design.
- Enabled the data pipeline to the cloud database from source systems. Used Fivetran and Stitch to achieve it.
- Worked with Google Docs API for data extraction, cleansing, and loading into the data warehouse for additional analysis.
Senior Software Engineer
LIS Nepal Pvt. Ltd.
- Contributed to all stages of the development life cycle, including requirements gathering, architecture design, coding, testing, tuning, integration, and support. Involved in three large scale data warehouse implementations at multinational clients.
- Implemented end to end ETL processes with Oracle tools such as Oracle Data Integrator (ODI) and shell and Python scripting for custom data warehouses.
- Designed and developed BI Reports by understanding business requirements of reports based on Oracle Retail Merchandising System (RMS), Oracle Retail Price Management (RPM), Oracle Retail Invoice Matching (ReIM), and Oracle Retail Analytics (RA).
- Planned and designed a Python library framework for a customized tailored data warehouse catering to the Snowflake database's functionalities.
- Participated in the analysis and rationalization of the client's legacy system and designed a data model for new subject areas customized into Oracle's Enterprise data warehouse.
- Analyzed and tuned the client's existing ETL scripts and reports applying various best practices. Improved performance by up to 82%.
Senior Data warehouse and BI Consultant
Siam Makro, Thailand
- Worked with the tam of consultants to design, develop and deploy the Corporate Report for Makro to support their daily business and processes.
- Tracked and fixed production bugs and provided proactive solutions using ALM as a tracker.
- Tuned the overall B2B platform's ETL and reporting performance by 82%. At the time, the client had over 15,000 reporting requests a day.
- Designed and developed Power BI Dashboards to monitor the system performance in real time. Extracted data from the audit logs of the system, streamlined into data warehouse and reported the data in Power BI dashboards.
Data Warehouse and BI Consultant
Holland and Barrett, the United Kingdom
- Conducted meetings with business personalities to properly understand the existing system, data, and business requirements.
- Modeled business requirements into the technical solutions to be provided and designed analytical/operational reports to be used by the business.
- Developed enhancement change request integrations in ODI and wrote test scripts for retail insights and business intelligence for several business areas.
Data Warehouse and BI Consultant
PT Matahari, Indonesia
- Implemented Oracle Retail Data warehouse (RDW) in Oracle 9i Database.
- Designed and deployed corporate reports to enable Matahari to make insightful decisions. Numerous operational and analytical reports were created as part of the BI Implementation.
- Designed and developed library functions and quite a few korn shell and PL/SQL scripts to enable a smooth data pipelining process from the merchandising system to the data warehouse.
- Coordinated with business associates to understand daily usage and created test cases based on it.
Experience
Data Warehouse Design and Development (GrantMe Canada)
• Python ETL framework designed and developed for smooth data engineering
• Multiple data sources (MySQL, Trello, Hubspot, Acuity) data loaded into snowflake cloud data warehouse.
• Enabled the data pipeline to the cloud database from source systems. Used stitch to achieve it
• Used AWS EC2 to host the scripts, used AWS Lambda to trigger EC2 startup and shutdown, and used Cloudwatch to schedule AWS Lambda function.
Power BI Sales Summary Dashboard
• Designed and developed an ETL process to pipeline required information from a third-party platform into the client's data warehouse.
• Designed and created a beautiful interactive Power BI Dashboard. All heavy lifting was handled with optimally tuned ETL batch scripts, so the dashboard with all the KPIs was available within seconds with a seamless user experience.
Python ETL Framework Design and Development
• The framework sped up the script development process and helped streamline the extraction APIs and integration to third-party source systems.
• Wrote unit test and system test cases to successfully test the developed Python scripts.
Education
Bachelor's Degree in Computer Engineering
Kathmandu University - Dhulikhel, Nepal
Skills
Languages
Snowflake, Python, Batch, SQL, R
Tools
Microsoft Power BI, Tableau, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle BI Publisher, Stitch Data, SQL Server BI, Amazon Elastic Container Service (Amazon ECS), Amazon CloudWatch
Paradigms
Database Development, ETL, Database Design, Business Intelligence (BI), Dimensional Modeling, Requirements Analysis
Platforms
Oracle, Azure, Amazon Web Services (AWS), AWS Lambda, Amazon EC2, HubSpot
Storage
PL/SQL, MySQL, PostgreSQL, Databases, Database Architecture, Oracle9i, Oracle 12c, Data Integration, MongoDB, MariaDB, Redshift, SQL Server Reporting Services (SSRS)
Other
Shell Scripting, Reporting, Training, Data Architecture, Data Modeling, Data Engineering, Data Warehousing, ETL Tools, ETL Development, PL/SQL Tuning, Data Analysis, Data, Reports, CSV File Processing, Fivetran, Training & Training Content Development, Performance Tuning, Team Management, Data Warehouse Design, Data Visualization, DAX, BI Reporting, Dashboard Development, ELT, Azure Data Factory, Informatica
Libraries/APIs
Trello API
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