Udeep is available for hire

Udeep Shakya

Verified Expert in Engineering

Data Engineer Developer

Location

Minneapolis, MN, United States

Toptal Member Since

May 19, 2021

Udeep is an enthusiastic and strategic senior consultant with 10+ years of experience in data warehousing and business analytics. 他善于合作解决问题, risk management, and creative solutions to improve customer satisfaction and drive overall operational and business improvements. Udeep's business awareness and consulting experience helped clients to realize their business needs through IT solutions with a strategic and professional approach throughout the process.

Software Engineering Data Visualization Data Warehousing Data Modeling Data Engineering Data Analytics Data Analysis Database Management Systems (DBMS)Business Intelligence (BI)MySQL SQL ETL Microsoft SQL Server Oracle Snowflake Tableau Oracle OBIEE

Portfolio

Toptal

亚马逊网络服务(AWS)， Apache气流，亚马逊S3 (AWS S3)，亚马逊雅典娜...

Freelance

Microsoft Power BI, Tableau, Qlik Sense, MySQL, Microsoft SQL Server...

LIS Nepal Pvt. Ltd

商业智能(BI)， Microsoft Power BI...

Experience

SQL - 10 years Data Engineering - 10 years ETL - 10 years Data Warehousing - 10 years Microsoft Power BI - 8 years Snowflake - 8 years Tableau - 8 years Looker - 5 years

Availability

Full-time

Preferred Environment

Oracle, Snowflake, Microsoft Power BI, Tableau, Data Warehousing, Business Intelligence (BI), Amazon Web Services (AWS), SQL, Data Modeling, Looker

The most amazing...

...project I've worked on was implementing BI reports for an APAC retailer to support business operational and analytical needs and help their global expansion.

Work Experience

Data Architect and BI Engineer

2021 - PRESENT

Toptal

Conducted tech stack review to best suit the project's requirements and provisioned and configured the environments. 选择Snowflake作为数据库, AWS as the cloud platform, Matillion ETL, AWS Lambda, and Snowpipe as the ETL tool.
Designed the data lake, data mart, 数据仓库架构模式和从不同源系统摄取的数据.
Conducted requirement gathering sessions with business users and tracked and prioritized activities.
Designed and developed Tableau reports to cover business needs and maintained reports in Tableau Online.

Technologies: 亚马逊网络服务(AWS)， Apache气流，亚马逊S3 (AWS S3)，亚马逊雅典娜, Data Lakes, AWS Lambda, Tableau, Amazon Elastic MapReduce (EMR), Snowflake, ETL, HubSpot CRM, MongoDB, Oracle Cloud, Excel 365, Data Analytics, Data Analysis, Data Warehousing, Business Intelligence (BI), MySQL, Data Modeling, HubSpot, Xero, Power Query, DAX

BI Consultant

2020 - PRESENT

Freelance

与零售部门进行需求收集和技术设计会议, education, fintech, aviation, and healthcare clients.
提出在系统中实现BI报告的策略和路线图.
Performed data modeling and developed stored procedures and scripts for load and transformation.
Designed and created BI reports in Power BI, Tableau, and Qlik Sense as per the design communicated.

Technologies: Microsoft Power BI, Tableau, Qlik Sense, MySQL, Microsoft SQL Server, Data Modeling, Business Intelligence (BI), Google Data Studio, SQL, SQL Server Reporting Services (SSRS), ETL, Data Engineering, Looker, Redshift, Azure SQL Databases, Amazon Web Services (AWS), Team Leadership, Excel 365, Data Analytics, Data Analysis, Data Warehousing, Snowflake, Power Query, DAX

高级DW和BI顾问|项目经理

2019 - PRESENT

LIS Nepal Pvt. Ltd

Led a team of consultants to migrate Oracle Retail Analytics to Oracle Autonomous Data Warehouse Cloud (ADW) platform.
带领顾问团队为亚太地区零售商实施Oracle零售分析.
Conducted technical and functional workshops and CRP sessions with business users and the client's IT team on BI requirements.
设计和创建ETL脚本来添加电子商务, customer analytics, 和B2B门户模块到现有的企业数据仓库.
在Power BI中为业务开发交互式执行报告.
Designed, developed, and maintained a catalog of operational and analytical reports to support daily operations and business decisions.
对业务和IT团队进行Oracle零售分析培训.

Technologies: 商业智能(BI)， Microsoft Power BI, Oracle商业智能企业版11g (OBIEE), Oracle BI Publisher, Oracle Cloud, Oracle Retail, Oracle Database, Snowflake, Data Warehousing, Oracle Data Integrator (ODI), Microsoft SQL Server, Azure Data Factory, Subversion (SVN), HP应用生命周期管理(ALM), Jira, Confluence, Smartsheet, Microsoft Project, Redshift, Apache Airflow, ETL, Tableau, Data Engineering, SQL Server Reporting Services (SSRS), Team Leadership, MongoDB, Excel 365, Data Analytics, Data Analysis, Oracle, MySQL, Data Modeling, Power Query, DAX

Data Engineer

2022 - 2023

PepsiCo Global - Main

Automated data collection, processing, 以及季度和其他分析报告的数据转换.
Reviewed present manual spreadsheet reports; designed visualizations and report layout; incorporated new features for the business to easily access and review the data being presented in the reports.
Designed the data model in the Snowflake database to support various dashboards created in Tableau.
Maintained the Tableau workbook repositories in GitHub and defined the testing and deployment standard operating procedures (SOPs).

Technologies: SQL, Tableau, Snowflake, GitHub, Data Visualization, Business Intelligence (BI), Automation

高级DW和BI顾问|副项目经理

2017 - 2019

LIS Nepal Pvt. Ltd

为标准OBIEE和BIP报告设计和实现报告和数据级安全.
Supported the client's expansion in the APAC region and led the internationalization project to support different currencies and languages in existing Oracle Retail Analytics and reports.
Managed teams, project timelines, 并与客户沟通，讨论需求和项目状态.
Implemented Oracle Retail Datawarehouse (RDW) and Oracle Business Intelligence 12c at an APAC client to enable businesses to perform ad hoc reports and have a standard set of corporate reports.
设计和开发OBIEE, BIP和Power BI报告.

Technologies: Oracle Retail, Oracle Data Integrator (ODI), Microsoft Power BI, Oracle BI Publisher, HP应用生命周期管理(ALM), Jira, Oracle商业智能企业版11g (OBIEE), Oracle Database, Microsoft SQL Server, Subversion (SVN), Looker, Tableau, Team Leadership, MongoDB, Excel 365, Data Analytics, Data Analysis, Data Warehousing, Business Intelligence (BI), Oracle, Snowflake, MySQL, Data Modeling

Senior Software Engineer | Consultant

2015 - 2017

LIS Nepal Pvt. Ltd

在不同的项目中担任开发ETL脚本和报告的离岸领导.
根据提供的规范开发和测试OBIEE和BIP报告.
为现有ETL和报告服务提供支持.

Technologies: Oracle Database, Oracle Retail, Oracle商业智能企业版11g (OBIEE), Oracle BIP, Subversion (SVN), Jira, Confluence, Oracle Data Integrator (ODI), Shell, Automic (UC4), Team Leadership, Excel 365, Data Analytics, Data Warehousing, Business Intelligence (BI), Oracle, Snowflake, Oracle BI Publisher, MySQL, Data Modeling

Software Engineer | Consultant

2013 - 2015

LIS Nepal Pvt. Ltd

为多个客户端提供Oracle Retail Analytics批处理的L2批处理支持.
为Oracle Retail Analytics开发ETL和历史转换脚本.
根据要求创建并验证OBIEE和BIP报告.
Performed R&D利用Hadoop和其他大数据平台进行零售数据仓库.

Technologies: Oracle Retail, Oracle Database, Oracle WebLogic Portal, Oracle商业智能企业版11g (OBIEE), Oracle BIP, Oracle WebCenter Portal, Oracle Data Integrator (ODI), Shell, Subversion (SVN), Hadoop, Apache Hive, QlikView, Team Leadership, Excel 365, Data Warehousing, Business Intelligence (BI), Oracle, Snowflake, Oracle BI Publisher, MySQL, Data Modeling

Experience

School Analytics (Power BI)

其目标是培养全校范围的数据素养，以便学校管理部门进行分析, interpret and use data to guide all decisions that improve outcomes for the student and school community.

为学生的健康创建仪表板, student performance, leadership, student achievement and certification, and many others.

雪花和Power BI报告:医疗保健中的云计算

我作为数据工程师和商业智能顾问创建了Power BI, paginated, 以及医疗保健客户的SSRS报告. 自定义数据仓库在Snowflake中实现, 所有的报道都来自雪花.

我还在Snowflake中创建了语义视图来支持Power BI报告. I performed R&在不同的工具上安排Power BI和分页报告给用户和用户安全.

Power BI Reporting - Fintech

I created Power BI dashboards for a fintech company to automate and standardize their financial reporting and bookkeeping process. 行级安全性和在线访问仪表板的权限得到了管理, 用户可以在线访问报告，也可以将报告发送到邮件中.

Oracle自治数据仓库云(ADWC)迁移项目

The existing on-premise Oracle Retail Analytics system was migrated to the Oracle ADWC platform, 其中包括数据模型的迁移, ETL, and reporting systems.

Around 1,500 tables, 10TB data, 1,000 standard reports, and 2,作为该项目的一部分，迁移了500个报告进度表.

Oracle Retail Analytics Implementation

I worked as a project lead for implementing Oracle Retail Analytics for multiple US and APAC clients. As part of this Oracle base data model, I implemented the ETL process, and pre-built reports, including custom integration, OBIEE, BI Publisher, and Power BI reports.

报告也通过电子邮件等不同渠道安排给用户, printer, network drive, and others.

B2B Portal Reports

Designed and developed semantic layer for B2B platform and developed a set of Oracle BI Publisher reports. 供应商从B2B门户访问这些报告，以获取有关采购订单的信息, payments, compliance, and more. These reports also had data level security implemented; hence, 每个供应商只能查看自己的数据.

Power BI Reporting for a Startup Business

I created a set of Power BI reports for a startup retail business to help them track customer orders and fulfillment. 这些报告还帮助客户了解他们的业务绩效和关键kpi(如销售额), margin, top customers, and service level.

AWS数据管道和表格报表

I was the technical lead in the project to design and implement a custom customer data model and enable Tableau reporting. It integrated the data from multiple source systems over the AWS platform and ingested it into the RedShift database with S3 as a data lake. With the base data model created, 为Tableau报表设计了语义层, and reports were built in Tableau. Tableau报表既有预构建的报表，也有自助服务功能.

电子商务化妆品零售商- PT Royal Persona印度尼西亚的图表专家

A reporting platform with a built-in Tableau gives business users and key stakeholders access to the data to make smarter decisions. A data warehouse was also built with automated pipelines to support the reporting platform to integrate the data from different source systems into the RedShift database. 我们使用AWS Glue和Lambda函数来构建管道, 并且使用Glue工作流来编排管道. As part of the implementation, various analytical reports, such as stock aging, 各渠道及品牌销售及毛利报告, 其他的执行报告也被制作出来了.

Tableau Dashboards

Created Tableau dashboards and reports to automate the current financial business reports and provide more insights to the operations and management team on revenue, risk assessment, customer cohort, and other business areas. As part of this, 数据仓库采用Snowflake和AWS技术栈进行设计, 随着matilion ETL雪花. Tableau被用作业务的报告工具.

顶级消费者食品公司数据工程师(Tableau)

I designed and created Tableau reports to assist the business with an ongoing marketing project. The Tableau reports created replaced over 100 manual spreadsheets and multiple hours of manual effort on the business and data team.

Platform Support

I helped the client implement Microsoft Power BI as their business intelligence (BI) tool and streamline the existing tech stack. I connected with the business in gathering reporting requirements and designed and built a new patient report, patient scheduling report, 还有其他的市场营销报告来追踪约会的线索.

Data Model for a Financial Company

As a data architect, I designed and implemented an integrated data warehouse platform in Snowflake to ingest data from different 3rd-party source systems, 使企业能够访问日常运营的关键数据和见解.

Skills

Languages

Snowflake, SQL, Python

Tools

Microsoft Power BI, Tableau, Oracle BI Publisher, Amazon QuickSight, Oracle商业智能企业版11g (OBIEE), HP应用生命周期管理(ALM), Jira, Subversion (SVN), Apache Airflow, Looker, Qlik Sense, Confluence, Shell, Automic (UC4), Smartsheet, Microsoft Project, Google Sheets, AWS Glue, Amazon Athena, Amazon Elastic MapReduce (EMR), Xero, Power Query, GitHub

Paradigms

商业智能(BI)， ETL，面向对象编程(OOP)，自动化

Platforms

Oracle, Oracle Database, Oracle Retail, Linux, Oracle Data Integrator (ODI), Amazon Web Services (AWS), Oracle WebCenter Portal, QlikView, SharePoint, Microsoft Power Automate, AWS Lambda, Dataiku, HubSpot

Storage

Database Management Systems (DBMS), Microsoft SQL Server, MySQL, SQL Server Reporting Services (SSRS), PostgreSQL, Oracle Cloud, Data Pipelines, MongoDB, Apache Hive, Redshift, Azure SQL Databases, Amazon S3 (AWS S3), Data Lakes

Other

Software Engineering, Data Visualization, Data Warehousing, Data Modeling, Oracle BIP, Data Engineering, Excel 365, Team Leadership, Dashboard Design, Dashboards, Data Analytics, Data Analysis, Google Data Studio, Probability Theory, Computer Networking, Azure Data Factory, Oracle WebLogic Portal, Learning Management Systems (LMS), Forms, HubSpot CRM, Fivetran, DAX, Azure Data Lake

Frameworks

Hadoop

Libraries/APIs

PySpark

Industry Expertise

Project Management

Education

2009 - 2013

计算机工程学士学位

工程学院-普尔乔克，拉利特普尔，尼泊尔

Certifications

JULY 2022 - PRESENT

Dataiku Core Designer Certificate

Dataiku

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

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.

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

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring