Prapti Thapaliya，美国宾夕法尼亚州费城的开发人员
Prapti is available for hire
Hire Prapti

Prapti Thapaliya

验证专家  in 工程

数据仓库开发人员

Location
费城，美国宾夕法尼亚州
至今成员总数
2021年8月6日

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.

数据可视化数据迁移数据仓库设计数据仓库Analytics数据分析SnowflakeTableauOracleAgileMicrosoft Power BISQL数据库设计ETL商业智能(BI)Power BILooker(原Google Data Studio)Oracle数据库

Portfolio

LIS尼泊尔私人
Oracle数据库，Oracle Data Integrator (ODI)...
白橡树,有限责任公司
Looker, Snowflake, Python，数据工程，数据建模，敏捷，SQL...
LIS尼泊尔私人
Looker, Oracle, Snowflake, Python, Git, Azure, Bash脚本, Oracle数据库...

Experience

数据仓库设计- 4年雪花- 4年表- 4年长相——4年Python - 4年Oracle数据库- 4年Microsoft Power BI - 4年Azure - 3年

Availability

Part-time

首选的环境

Snowflake, Looker, Tableau, Oracle, 数据库设计, Azure, Python, Microsoft Power BI, 数据仓库, ETL

最神奇的...

...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.

工作Experience

高级软件工程师

2019年至今
LIS尼泊尔私人
  • 获得了开发服务和产品交付项目的Experience.
  • 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.
技术:甲骨文数据库，Oracle Data Integrator (ODI), Oracle商业智能企业版11g (OBIEE), Looker, Tableau, Microsoft Power BI, PostgreSQL, 商业智能(BI), t - sql (transact - sql), 数据迁移, Databases, 数据集成, 关系数据库, 数据分析, 分析实现, SQL

数据演示和数据Availability技术专家

2019年至今
白橡树,有限责任公司
  • 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.
  • 开发ETL脚本, Azure数据管道, and analytical reports for the implementation of large-scale data-warehouse for 6+ international retail organizations.
  • Designed and developed 异常检测分析 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.
  • 促进与客户和内部的知识分享会议.
  • 为ETL目的设计和开发Python脚本.
技术:美人, Snowflake, Python，数据工程，数据建模，敏捷，SQL, 算法, ETL, 数据管道, 商业智能(BI), 数据架构, 网页抓取, Tableau, Microsoft Power BI, PyCharm, Databases, 数据仓库设计, RDBMS, 存储过程, 数据集成, 关系数据库, Reports, 指示板, 体系结构, Azure Blob存储API, Analytics, Data, Azure数据工厂, Azure虚拟机, 分析实现, 数据分析, 解决方案架构

软件工程师

2017 - 2019
LIS尼泊尔私人
  • 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.
技术:美人, Oracle, Snowflake, Python, Git, Azure, Bash脚本, Oracle数据库，Oracle Data Integrator (ODI), Oracle商业智能企业版11g (OBIEE), 甲骨文毕普, 商业智能(BI), SQL, Microsoft SQL Server

助理软件开发人员

2017 - 2018
LIS尼泊尔私人
  • 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.
技术:甲骨文, Agile, Oracle Data Integrator (ODI), Oracle商业智能企业版11g (OBIEE), 甲骨文毕普, 算法, SQL

企业数据仓库

一种基于云的企业数据仓库，将数据作为服务提供. 我担任数据Availability和演示的技术主管. My role was to design and develop data integrations and analytics on top of the data warehouse. 我成功交付了COVID-19分析, 异常检测分析, 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.

英国领先的健康和福利零售商

担任技术商业智能顾问. 开发ETL脚本 to load historical data into the data warehouse and over 100 report design documents for operational reporting. 为业务创建操作报告和分析报告. Built a validation framework to validate data across different integration points.

领先的珠宝零售商(美国)

作为历史转换引线. 为来自遗留系统的历史数据负载开发脚本, lifted and shifted data from an on-premise system to Oracle's cloud data warehouse, 并在每次历史运行后根据遗留系统验证数据. Successfully delivered a golden copy of their five years of historical data into their new system.

流行文化启发的零售商(美国)

担任数据Availability和数据演示的技术主管. 参与数据仓库的实现, 实现Azure的ETL自动化, 从遗留系统迁移历史数据, design, 以及用Python开发ETL脚本, 并在Tableau中交付了10多个报告和仪表板.

大码服装零售商(美国)

担任数据Availability和数据演示的技术主管, 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. 此外，在整合谷歌分析到Looker提供协助.

家居装饰零售商(美国)

担任数据Availability和数据演示的技术主管. I successfully implemented a data warehouse and data mart for the client along with my team. 这需要设计和开发数据模型, 数据集市, ETL脚本, 分析报告和仪表板. I also led the efforts to train business users with no technical background in using Looker and building analytical dashboards in the platform.

Languages

Snowflake, SQL, Python, Bash脚本, t - sql (transact - sql), 存储过程

Tools

Looker, Tableau, Oracle商业智能企业版11g (OBIEE), Microsoft Power BI, Git, PyCharm, Azure密钥库, 谷歌分析

Paradigms

敏捷、数据库设计、ETL、商业智能(BI)

Platforms

Oracle Data Integrator (ODI), Oracle, Azure, Oracle数据库, Amazon Web Services (AWS)

Storage

PostgreSQL, PL/SQL, Databases, RDBMS, 数据集成, 关系数据库, MySQL, 数据管道, Azure斑点, Data Lakes, Redshift, Microsoft SQL Server

Other

数据建模, 数据可视化, 数据迁移, 数据仓库设计, Reports, 指示板, 体系结构, 数据仓库, Analytics, 仪表盘的设计, Data Marts, 分析实现, 数据分析, 甲骨文毕普, 工程数据, 数据架构, 网页抓取, Azure数据工厂, Azure虚拟机, Data, 解决方案架构, 软件开发, Web开发, 数据结构, 算法, 计算机体系结构, 自然语言处理(NLP), 计算机视觉, 多目标跟踪(MOT), 语言模型

库/ api

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

2022 - 2023

计算机科学硕士学位

维拉诺瓦大学-美国宾夕法尼亚州维拉诺瓦

2012 - 2017

计算机科学与信息管理学士学位

特里布万大学-加德满都，尼泊尔

有效的合作

如何使用Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

分享你的需求

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

选择你的才能

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

开始你的无风险人才试验

与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.

对顶尖人才的需求很大.

开始招聘