Udeep Shakya, Developer in Minneapolis, MN, United States
Udeep is available for hire
Hire Udeep

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. He is adept in collaborative problem solving, 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.

Portfolio

Toptal
Amazon Web Services (AWS), Apache Airflow, Amazon S3 (AWS S3), Amazon Athena...
Freelance
Microsoft Power BI, Tableau, Qlik Sense, MySQL, Microsoft SQL Server...
LIS Nepal Pvt. Ltd
Business Intelligence (BI), Microsoft Power BI...

Experience

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 was selected as the database, AWS as the cloud platform, Matillion ETL, AWS Lambda, and Snowpipe as the ETL tool.
  • Designed the data lake, data mart, and data warehousing architecture pattern and ingested data from diverse source systems.
  • 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: Amazon Web Services (AWS), Apache Airflow, Amazon S3 (AWS S3), Amazon Athena, 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
  • Performed requirement gathering and conducted technical design sessions with retail, education, fintech, aviation, and healthcare clients.
  • Proposed the strategy and roadmap to implement BI reporting to their systems.
  • 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

Senior DW and BI Consultant | Project Manager

2019 - PRESENT
LIS Nepal Pvt. Ltd
  • Led a team of consultants to migrate Oracle Retail Analytics to Oracle Autonomous Data Warehouse Cloud (ADW) platform.
  • Spearheaded a team of consultants to implement Oracle Retail Analytics for the APAC retailers.
  • Conducted technical and functional workshops and CRP sessions with business users and the client's IT team on BI requirements.
  • Designed and created ETL scripts to add eCommerce, customer analytics, and B2B portal modules to the existing enterprise data warehouse.
  • Developed interactive executive reports for business in Power BI.
  • Designed, developed, and maintained a catalog of operational and analytical reports to support daily operations and business decisions.
  • Conducted training sessions on Oracle Retail Analytics to business and IT teams.
Technologies: Business Intelligence (BI), Microsoft Power BI, Oracle Business Intelligence Enterprise Edition 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 Application Lifecycle Management (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, and data transformation for quarterly and other analytical reports.
  • 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

Senior DW and BI Consultant | Associate Project Manager

2017 - 2019
LIS Nepal Pvt. Ltd
  • Designed and implemented report and data level security for standard OBIEE and BIP reports.
  • 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, and communication with clients to discuss requirements and project status.
  • 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.
  • Designed and developed OBIEE, BIP, and Power BI reports.
Technologies: Oracle Retail, Oracle Data Integrator (ODI), Microsoft Power BI, Oracle BI Publisher, HP Application Lifecycle Management (ALM), Jira, Oracle Business Intelligence Enterprise Edition 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
  • Worked as an offshore lead to develop ETL scripts and reports on different projects.
  • Developed and tested OBIEE and BIP reports as per the specifications provided.
  • Provided support for existing ETL and reporting services.
Technologies: Oracle Database, Oracle Retail, Oracle Business Intelligence Enterprise Edition 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
  • Worked as L2 batch support for Oracle Retail Analytics batch for multiple clients.
  • Developed ETL and history conversion scripts for Oracle Retail Analytics.
  • Created and validated OBIEE and BIP reports as per the requirements.
  • Performed R&D on leveraging Hadoop and other big data platforms for Retail data warehousing.
Technologies: Oracle Retail, Oracle Database, Oracle WebLogic Portal, Oracle Business Intelligence Enterprise Edition 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

School Analytics (Power BI)

The goal was to develop school-wide data literacy so that school management can analyze, interpret and use data to guide all decisions that improve outcomes for the student and school community.

Created dashboards for student wellbeing, student performance, leadership, student achievement and certification, and many others.

Snowflake and Power BI Reporting: Cloud Computing in Healthcare

I worked as a data engineer and BI consultant to create Power BI, paginated, and SSRS reports for healthcare clients. The custom data warehouse was implemented in Snowflake, and all the reports were sourced from Snowflake.

I also created semantic views in Snowflake to support the Power BI reports. I performed R&D on different tools to schedule Power BI and paginated reports to the users and user security.

Power BI Reporting - Fintech

I created Power BI dashboards for a fintech company to automate and standardize their financial reporting and bookkeeping process. Row-level security and access to dashboards online were managed, and users were able to access the reports online as well as get the reports sent to mail.

Oracle Autonomous Data Warehouse Cloud (ADWC) Migration Project

The existing on-premise Oracle Retail Analytics system was migrated to the Oracle ADWC platform, which included migration of the data model, ETL, and reporting systems.

Around 1,500 tables, 10TB data, 1,000 standard reports, and 2,500 report schedules were migrated as part of this project.

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.

The reports were also scheduled to users via different channels like email, 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. The suppliers accessed these reports from the B2B portal to get information on purchase orders, payments, compliance, and more. These reports also had data level security implemented; hence, each supplier could only view their own data.

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. The reports also helped the client to see their business performance and key KPIs like sales, margin, top customers, and service level.

AWS Data Pipeline and Tableau Reporting

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, a semantic layer was designed for the Tableau reports, and reports were built in Tableau. Tableau reporting had both pre-built reports and a self-servicing functionality.

Tableau Expert for Ecommerce Cosmetic Retailer - PT Royal Persona Indonesia

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 and Lambda functions were used to build the pipelines, and a Glue workflow was used to orchestrate the pipelines. As part of the implementation, various analytical reports, such as stock aging, sales and margin reports by channels and brand, and other executive reports were built.

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, the data warehouse was designed in Snowflake and AWS tech stack, along with Matillion ETL for Snowflake. Tableau was used as the reporting tool for the business.

Data Engineer (Tableau) for Top Consumer Food Company

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, and other marketing reports to track leads to appointments.

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, enabling businesses to access crucial data and insights for daily operations.

Languages

Snowflake, SQL, Python

Tools

Microsoft Power BI, Tableau, Oracle BI Publisher, Amazon QuickSight, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), HP Application Lifecycle Management (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

Business Intelligence (BI), ETL, Object-oriented Programming (OOP), Automation

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

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, HubSpot, DAX, Azure Data Lake

Frameworks

Hadoop

Libraries/APIs

PySpark

Industry Expertise

Project Management

2009 - 2013

Bachelor's Degree in Computer Engineering

Institute of Engineering - Pulchowk, Lalitpur, Nepal

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.

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