Gulshan Chaurasia, Developer in Kathmandu, Central Development Region, Nepal
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 has 11 years of experience in a mix of roles (developer, lead, architect, and manager) with a strong focus on data warehousing, data engineering, and business intelligence. He has consulted for multi-billion dollar revenue retailers worldwide with hundreds of terabytes of data and significantly improved their data needs (warehousing, reporting, integration, advanced analytics). Gulshan has authored technical designs, problem-solved complex integrations, and headed R&D projects.

Portfolio

A Data Warehouse as a Service Company
Data Marts, Data Lake Design, Data Lakes, Data Modeling, Reporting...
A Leading Software Services Company
ETL, Data Engineering, SQL, Oracle Data Integrator (ODI)...
A Leading Software Services Company
Data Engineering, 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...

...project I've delivered and is ongoing is a cloud data warehouse. It operates on data as a service architecture for many multi-billion dollar revenue retailers.

Work Experience

Data Architect

2020 - PRESENT
A Data Warehouse as a Service Company
  • Enhanced and fixed bugs on the existing data model. Bug fixes included a complete review and fix of the omnichannel sales reporting module.
  • Improved the data model to accommodate additional business areas to support retail analytics. Some of the areas included marketing, customer analytics, and payroll.
  • Assisted with the implementation of three new customers. I completed various integration with structured, semi-structured, and API-based data.
  • Managed four developers who delivered a demo dataset, anonymizing real-world data from one of our clients (with their consent). Its purpose is ETL orchestration and demo dashboards for showcasing the data model's capability to potential customers.
  • Managed a team of three people for deprecating unwanted modules adding five modules to the data model, setting up the data model on a modeling tool, and centralized the repository where the core model and clients' versions could all be appropriately managed.
Technologies: Data Marts, Data Lake Design, Data Lakes, Data Modeling, Reporting, 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
  • Completed pre-sales technical consulting for two large retailers in Australia. Managed a team of six people offshore to deliver sample ETL and dashboards on their data as part of POC.
  • Conducted design sessions and authored technical designs for integrations to the Oracle MOM suite with various sources.
  • Headed R&D for an accelerated delivery mechanism for Snowflake projects. This included a team of seven developers where I architected and managed the delivery framework. The outcome of this effort was a 2-week accelerated implementation module.
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
  • Guided the re-planning delivery for a retailer in Indonesia and oversaw the delivery. Managed a team of three onsite and seven offshore members.
  • Conducted CRP and developed a project plan for a new retailer in India.
  • Assisted as a technical project manager in the UK, including delivering 100+ reports and 10+ customizations on Oracle Retail Insights. Also, I managed a team of two onsite and nine offshore developers during this project.
Technologies: Data Engineering, 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
  • Led and managed delivery of 500+ reports and dashboards and 25+ custom integrations for a retailer's BI project in Thailand. Managed a team of five onsite and four offshore developers, with eight onsite and 13 offshore members at peak time.
  • Led the development of supplier profitability tools based on various data aspects that helped buyers negotiate new contracts and deals.
  • Supported the development of a central replenishment module.
  • Led and managed a team of four developers to migrate 50+ reports on a B2B portal from JSP-based to 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. This later went on to be a data as a service (DaaS) solution currently implemented at many retailers across the US and the UK

Leading Cash and Carry Operator, Thailand

On this project, I performed the following duties:
• Assisted in the initiation and planning of the project.
• Led system, integration testing, history data migration, validation, and reconciliation.
• Led the designs for 10+ custom integrations to support the business needs. I was responsible for B2B supplier portal architecture design and development, replacing 50+ legacy Java-based reporting with Oracle BI Publisher reports integrating to the existing portal.
• Cutover/go-live together with Oracle Retail MOM suite.
• Managed project plans, scopes, resources, change requests, risks, and issues throughout the project.
• Led cross-functional teams to design and deliver 500+ reports and analyses supporting all process areas, including sales, finance, marketing, and operations.
• Managed and delivered a supplier profitability tool based on various data aspects (supplier sales, deal income, etc.) that allows buyers to see the supplier’s profitability and helps in negotiations for new contracts and deals.
• Managed reporting aspects in a project team responsible for transitioning the business to central replenishment.

Leading Health Food Retailer, UK

In this project, I managed project plans, scopes, resources, change requests, risks, and issues. Also, I led cross-functional teams and delivered 100+ reports and analyses supporting all process areas, including sales, finance, marketing, and operations. Furthermore, I managed, architected, and delivered 10+ customizations to retail insights to support business needs.

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 & Design, Oracle ODI, Database Development, UI Design, Data Science

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

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

1

Share your needs

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

Choose your talent

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

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