Verified Expert in Engineering
Software Engineer and Developer
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.
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.
Data Architect and BI Engineer
- 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.
- 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.
Senior DW and BI Consultant | Project Manager
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.
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).
Senior DW and BI Consultant | Associate Project Manager
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.
Senior Software Engineer | Consultant
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.
Software Engineer | Consultant
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.
School Analytics (Power BI)
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 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
Oracle Autonomous Data Warehouse Cloud (ADWC) Migration Project
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
The reports were also scheduled to users via different channels like email, printer, network drive, and others.
B2B Portal Reports
Power BI Reporting for a Startup Business
AWS Data Pipeline and Tableau Reporting
Tableau Expert for Ecommerce Cosmetic Retailer - PT Royal Persona Indonesia
Data Engineer (Tableau) for Top Consumer Food Company
Snowflake, SQL, Python
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
Business Intelligence (BI), ETL, Object-oriented Programming (OOP), Automation
Oracle, Oracle Database, Oracle Retail, Linux, Oracle Data Integrator (ODI), Amazon Web Services (AWS), Oracle WebCenter Portal, QlikView, SharePoint, AWS Lambda, Dataiku
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
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, Microsoft Power Automate, HubSpot CRM, Fivetran, HubSpot, DAX
Bachelor's Degree in Computer Engineering
Institute of Engineering - Pulchowk, Lalitpur, Nepal
Dataiku Core Designer Certificate