Gulshan Chaurasia,尼泊尔中部开发区加德满都的开发商
Gulshan is available for hire
Hire Gulshan

Gulshan Chaurasia

Verified Expert  in Engineering

Data Warehousing Developer

Location
Kathmandu, Central Development Region, Nepal
Toptal Member Since
October 21, 2020

Gulshan拥有11年的各种角色(开发人员, lead, architect, and manager) with a strong focus on data warehousing, data engineering, and business intelligence. 他曾为全球拥有数百tb数据的数十亿美元收入的零售商提供咨询,并显著改善了他们的数据需求(仓储), reporting, integration, advanced analytics). Gulshan撰写了技术设计,解决了问题的复杂集成,并领导了R&D projects.

Portfolio

A Data Warehouse as a Service Company
数据市场,数据湖设计,数据湖,数据建模,报表...
A Leading Software Services Company
ETL, Data Engineering, SQL, Oracle Data Integrator (ODI)...
A Leading Software Services Company
数据工程,Python, SQL, KornShell, Oracle Data Integrator (ODI)...

Experience

Availability

Full-time

Preferred Environment

Business Intelligence (BI), Data Analysis, Python, Data Warehouse Design, Data Warehousing, Microsoft Power BI, Tableau, Snowflake, Windows, MacOS

The most amazing...

...我已经交付并正在进行的项目是一个云数据仓库. 它将数据作为服务架构,为许多收入数十亿美元的零售商提供服务.

Work Experience

Data Architect

2020 - PRESENT
A Data Warehouse as a Service Company
  • Enhanced and fixed bugs on the existing data model. Bug修复包括对全渠道销售报告模块的完整审查和修复.
  • 改进了数据模型,以适应额外的业务领域,从而支持零售分析. 其中一些领域包括市场营销、客户分析和工资.
  • Assisted with the implementation of three new customers. 我完成了与结构化、半结构化和基于api的数据的各种集成.
  • Managed four developers who delivered a demo dataset, 匿名处理来自我们客户的真实数据(征得他们的同意). 它的目的是ETL编排和演示仪表板,用于向潜在客户展示数据模型的功能.
  • 管理一个三人团队,弃用不需要的模块,向数据模型中添加五个模块, setting up the data model on a modeling tool, 并集中存储库,以便对核心模型和客户端版本进行适当的管理.
Technologies: 数据市场,数据湖设计,数据湖,数据建模,报表, Data Analytics, Data Visualization, Tableau Server, Tableau, ETL, Microsoft Excel, SQL, Data Engineering, Python 3, Snowflake, Azure Data Factory, Data Warehouse Design, Dashboards, CSV File Processing, Databases, Database Development, Reports, Dashboard Development, Looker, Data Warehousing, PyCharm, KornShell, Microsoft Power BI, Database Integration, Dashboard Design, Data Virtualization, Data Science, Data Build Tool (dbt), ELT

Solutions Architect

2018 - PRESENT
A Leading Software Services Company
  • 为澳大利亚两家大型零售商完成售前技术咨询. 管理一个六人的海外团队,交付样本ETL和仪表板上的数据作为POC的一部分.
  • 主持设计会议,并撰写技术设计,以便与各种来源的Oracle MOM套件集成.
  • Headed R&D为雪花项目的加速交付机制. 这包括一个由7名开发人员组成的团队,我在那里设计和管理交付框架. 这一努力的结果是一个两周的加速实施模块.
Technologies: ETL, Data Engineering, SQL, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Exadata, Oracle, Python, Snowflake, Dashboards, Dashboard Design, Dashboard Development, PostgreSQL, MySQL, Data Warehouse Design, Data Warehousing, Data Modeling, PyCharm, KornShell, Tableau, Microsoft Power BI, Database Integration, Data Virtualization, Database Development, Looker, Data Science, Data Build Tool (dbt), ELT

Project Manager

2016 - 2018
A Leading Software Services Company
  • 指导印尼一家零售商重新规划配送,并监督配送. Managed a team of three onsite and seven offshore members.
  • 为印度的一家新零售商执行CRP并制定项目计划.
  • Assisted as a technical project manager in the UK, 包括在Oracle Retail Insights上提供100多个报告和10多个定制. 此外,在这个项目中,我管理着一个由2名现场开发人员和9名海上开发人员组成的团队.
Technologies: 数据工程,Python, SQL, KornShell, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle, Exadata, Data Architecture, Microsoft Power BI, Data Virtualization, DAX, Snowflake, Data Warehouse Design, Data Warehousing, Data Modeling, Tableau, Database Integration, Dashboards, Dashboard Design, Database Development, Dashboard Development, ELT

Project Leader

2015 - 2016
A Leading Software Services Company
  • 领导和管理泰国一家零售商BI项目的500多个报告和仪表板以及25多个定制集成的交付. Managed a team of five onsite and four offshore developers, with eight onsite and 13 offshore members at peak time.
  • 领导基于各种数据方面的供应商盈利能力工具的开发,帮助买家谈判新的合同和交易.
  • Supported the development of a central replenishment module.
  • 领导和管理一个由四名开发人员组成的团队,将B2B门户网站上的50多个报告从基于jsp的迁移到Oracle BI Publisher, including new reports creation, integration of BI publisher to B2B securely, and additional integration as required by reports.
Technologies: Excel Macros, Excel VBA, Microsoft Excel, Data Engineering, Python, KornShell, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), SQL, Exadata, Oracle, PostgreSQL, Snowflake, Data Warehouse Design, Data Warehousing, Data Modeling, Tableau, Microsoft Power BI, Database Integration, Dashboards, Dashboard Design, Data Virtualization, Database Development, Dashboard Development, ELT

Enterprise Data Warehouse

A cloud-based enterprise data warehouse. I was responsible for the data model and integration design. 这后来成为一种数据即服务(DaaS)解决方案,目前在美国和英国的许多零售商中实施

Leading Cash and Carry Operator, Thailand

On this project, I performed the following duties:
• Assisted in the initiation and planning of the project.
领导系统集成测试,历史数据迁移,验证和协调.
•领导10多个定制集成的设计,以支持业务需求. 负责B2B供应商门户架构的设计与开发, 用集成到现有门户的Oracle BI Publisher报告取代50多个遗留的基于java的报告.
•与Oracle Retail MOM套件一起管理切换/上线.
• Managed project plans, scopes, resources, change requests, risks, and issues throughout the project.
•领导跨职能团队设计并交付500多份报告和分析,支持所有过程域, including sales, finance, marketing, and operations.
•提供并管理基于各种数据方面(供应商销售)的供应商盈利能力工具, deal income, etc.),这可以让买家看到供应商的盈利能力,并有助于新合同和交易的谈判.
•管理项目团队的报告方面,负责将业务过渡到中央补货.

Leading Health Food Retailer, UK

在这个项目中,我管理项目计划、范围、资源、变更请求、风险和问题. Also, 我领导了跨职能团队,并交付了100多个支持所有过程域的报告和分析, including sales, finance, marketing, and operations. Furthermore, I managed, architected, 并为零售洞察提供了10多个定制,以支持业务需求.

Languages

Snowflake, Python 3, Python, SQL, Excel VBA

Tools

PyCharm, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Tableau, Microsoft Power BI, Oracle BI Publisher, Microsoft Excel, Looker

Paradigms

Business Intelligence (BI), ETL, ETL Implementation & 设计,Oracle ODI,数据库开发,UI设计,数据科学

Platforms

Windows, Oracle, Oracle Data Integrator (ODI), Oracle Retail, KornShell, MacOS

Storage

Database Integration, Data Integration, Data Lakes, Data Lake Design, Databases, Exadata, PostgreSQL, MySQL

Other

Data Warehousing, Data Modeling, Data Engineering, Data Analysis, Excel Macros, Tableau Server, Data Visualization, Reporting, Data Analytics, Complex Data Analysis, Data Cleaning, Data Cleansing, Quality Assurance (QA), Data Marts, Data Architecture, Dashboards, Dashboard Design, CSV File Processing, Reports, Data Warehouse Design, Dashboard Development, Data Build Tool (dbt), ELT, Statistics, Big Data, Azure Data Factory, Data Virtualization, DAX

2007 - 2012

Bachelor's Degree in Computer Engineering

Tribhuvan University - Kathmandu, Nepal

Collaboration That Works

How to Work with Toptal

在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.

1

Share your needs

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

Choose your talent

在24小时内获得专业匹配人才的简短列表,以进行审查,面试和选择.
3

Start your risk-free talent trial

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

Top talent is in high demand.

Start hiring
" class="hidden">易高定制家具