Prapti is available for hire

Prapti Thapaliya

Verified Expert in Engineering

Data Warehouse Developer

Location

Philadelphia, PA, United States

Toptal Member Since

August 6, 2021

Prapti has four years of experience in business intelligence and retail analytics. She has a solid background in data analytics, data warehousing, and business intelligence. Prapti worked with multiple international retailers worldwide to provide them with end-to-end data warehouse implementation and top-notch analytics.

Data Modeling Data Visualization Data Migration Data Warehouse Design Data Warehousing Analytics Data Analytics Snowflake Tableau Oracle Agile Microsoft Power BI SQL Database Design ETL Looker (Formerly Google Data Studio)Power BI Oracle Database

Portfolio

LIS Nepal Pvt

Oracle Database, Oracle Data Integrator (ODI)...

Robling, LLC

Looker, Snowflake, Python, Data Engineering, Data Modeling, Agile, SQL...

LIS Nepal Pvt

Looker, Oracle, Snowflake, Python, Git, Azure, Bash Script, Oracle Database...

Experience

Data Warehouse Design - 4 years Snowflake - 4 years Tableau - 4 years Looker - 4 years Python - 4 years Oracle Database - 4 years Microsoft Power BI - 4 years Azure - 3 years

Availability

Part-time

Preferred Environment

Snowflake, Looker, Tableau, Oracle, Database Design, Azure, Python, Microsoft Power BI, Data Warehousing, ETL

The most amazing...

...thing I've developed is COVID-19 analytics that gives US retailers information about the spread of COVID-19 within 20 miles of proximity to their stores.

Work Experience

Senior Software Engineer

2019 - PRESENT

LIS Nepal Pvt

Gained experience in developing both service and product delivery projects.
Developed ETL using scripts as well as BI tools such as Oracle Data Integrator (ODI) and Fivetran.
Designed, developed, and tested analytical reports in platforms such as Looker, Tableau, and OBIEE.
Developed frameworks to validate data across different integration points during data warehouse implementation for 8+ international retailers. Developed both unit and regression test frameworks to validate data across source and target systems.
Conducted research on promotional effectiveness among retailers and produced a high-quality dashboard in Power BI and a proof of concept.
Supervised and led an intern group to develop a supply chain optimization engine through sales forecasting.

Technologies: Oracle Database, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Looker, Tableau, Microsoft Power BI, PostgreSQL, Business Intelligence (BI), T-SQL (Transact-SQL), Data Migration, Databases, Data Integration, Relational Databases, Data Analytics, Analytics Implementation, SQL

Technical Specialist for Data Demo and Data Usability

2019 - PRESENT

Robling, LLC

Served as a technical lead of data usability lane that enhances data usability and data demo.
Designed and developed cutting-edge analytics that provides meaningful insights into a retailer’s business using tools such as Looker.
Developed ETL scripts, Azure data pipelines, and analytical reports for the implementation of large-scale data-warehouse for 6+ international retail organizations.
Designed and developed anomaly detection analytics for two international retail organizations.
Designed and developed COVID-19 analytics that was implemented by over 22 retailers and restauranteurs in the US.
Developed analytics on customer mobility based on data provided by Google on customer mobility during the COVID-19.
Created competitor pricing analytics by scraping eCommerce sites for retailers.
Facilitated knowledge-sharing sessions to clients as well as in-house.
Designed and developed scripts in Python for ETL purposes.

Technologies: Looker, Snowflake, Python, Data Engineering, Data Modeling, Agile, SQL, Algorithms, ETL, Data Pipelines, Business Intelligence (BI), Data Architecture, Web Scraping, Tableau, Microsoft Power BI, PyCharm, Databases, Data Warehouse Design, RDBMS, Stored Procedure, Data Integration, Relational Databases, Reports, Dashboards, Architecture, Azure Blob Storage API, Analytics, Data, Azure Data Factory, Azure Virtual Machines, Analytics Implementation, Data Analytics, Solution Architecture

Software Engineer

2017 - 2019

LIS Nepal Pvt

Designed and developed efficient extract transform load (ETL) scripts and BI dashboards and reports.
Designed and developed analytical decision-supporting dashboards for the upper management of an organization.
Worked with lift and shift of large-scale data from legacy systems to a data warehouse.

Technologies: Looker, Oracle, Snowflake, Python, Git, Azure, Bash Script, Oracle Database, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle BIP, Business Intelligence (BI), SQL, Microsoft SQL Server

Associate Software Developer

2017 - 2018

LIS Nepal Pvt

Worked with large-scale data manipulation and interpretation for a multinational retailer.
Researched methods to integrate data from different sources into a data warehouse and devised documents outlining proof of concepts.
Trained interns and new resources on data warehousing principles and retail analytics.

Technologies: Oracle, Agile, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle BIP, Algorithms, SQL

Experience

Enterprise Data Warehouse

A cloud-based enterprise data warehouse that offers data as a service. I served as the technical lead for data usability and demo. My role was to design and develop data integrations and analytics on top of the data warehouse. I successfully delivered COVID-19 analytics, anomaly detection analytics, and 20+ reports and dashboards implemented by over six international retailers. For all these deliverables, I actively participated in the design of the data model as well.

Leading Health and Wellbeing Retailer in the UK

Served as a technical business intelligence consultant. Developed ETL scripts to load historical data into the data warehouse and over 100 report design documents for operational reporting. Created both operational and analytical reports for the business. Built a validation framework to validate data across different integration points.

Leading Jewelry Retailer (US)

Acted as the history conversion lead. Developed scripts for the historical load of data from their legacy system, lifted and shifted data from an on-premise system to Oracle's cloud data warehouse, and validated data against the legacy system after each historical run. Successfully delivered a golden copy of their five years of historical data into their new system.

Pop Culture-inspired Retailer (US)

Served as the technical lead for data usability and data demo. Participated in the implementation of data warehouse, implementation of Azure for ETL automation, migration of historical data from their legacy system, design, and development of ETL scripts in Python, and delivered over 10 reports and dashboards in Tableau.

Plus-size Clothing Retailer (US)

Served as the technical lead for data usability and data demo, delivering a full data warehouse implementation and migration of data from their legacy system. Additionally, designed and built 500+ metrics in Looker to enable ad-hoc reporting. Delivered 20+ reports and dashboards and conducted technical and business user training to familiarize them with Looker and analytical reporting. Delivered competitor pricing analytics which entailed developing scripts for web scraping competitor eCommerce sites for price data. Also, provided assistance in incorporating Google Analytics into Looker.

Home Decor Retailer (US)

Took the role of the technical lead for data usability and data demo. I successfully implemented a data warehouse and data mart for the client along with my team. This entailed designing and developing data models, data marts, ETL scripts, and analytical reports and dashboards. I also led the efforts to train business users with no technical background in using Looker and building analytical dashboards in the platform.

Skillset

Languages

Snowflake, SQL, Python, Bash Script, T-SQL (Transact-SQL), Stored Procedure

Tools

Looker, Tableau, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Microsoft Power BI, Git, PyCharm, Azure Key Vault, Google Analytics

Paradigms

Agile, Database Design, ETL, Business Intelligence (BI)

Platforms

Oracle Data Integrator (ODI), Oracle, Azure, Oracle Database, Amazon Web Services (AWS)

Storage

PostgreSQL, PL/SQL, Databases, RDBMS, Data Integration, Relational Databases, MySQL, Data Pipelines, Azure Blobs, Data Lakes, Redshift, Microsoft SQL Server

Other

Data Modeling, Data Visualization, Data Migration, Data Warehouse Design, Reports, Dashboards, Architecture, Data Warehousing, Analytics, Dashboard Design, Data Marts, Analytics Implementation, Data Analytics, Oracle BIP, Data Engineering, Data Architecture, Web Scraping, Azure Data Factory, Azure Virtual Machines, Data, Solution Architecture, Software Development, Web Development, Data Structures, Algorithms, Computer Architecture, Natural Language Processing (NLP), Computer Vision, Multiple Object Tracking (MOT), Language Models

Libraries/APIs

Azure Blob Storage API, OpenCV, Natural Language Toolkit (NLTK), PyTorch, TensorFlow, Keras

Education

2022 - 2023

Master's Degree in Computer Science

Villanova University - Villanova, PA, USA

2012 - 2017

Bachelor's Degree in Computer Science and Information Management

Tribhuvan University - Kathmandu, Nepal

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.

Share your needs

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

Choose your talent

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

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