Overview
Work History
Education
Skills
Timeline
Generic

Prajwol Thapa

Toronto,ON

Overview

13
13
years of professional experience

Work History

Senior Business Intelligence Engineer

Apotex Inc
North York, ON
10.2018 - Current
  • Implemented daily performance monitoring protocols for enterprise applications, with a focus on those integrating overnight ETL processes, ensuring seamless functionality and performance optimization.
  • Engineered diverse Data Transforms within Snowflake utilizing Snowpark, facilitating efficient and scalable data transformations tailored to organizational needs.
  • Designed and implemented Star Schema and Snowflake Schema data models to support data warehousing and business intelligence initiatives,
    catering to diverse analytical requirements.
  • Took full ownership and meticulously maintained the existing Analytics Pipeline established in DBT, serving as a cornerstone for multiple analytics tools including Qliksense, Sigma, and PowerBI, supporting various business domains.
  • Led the migration initiative transferring all Data Model codes from Qlik Load scripts to the DBT environment, enhancing structural organization, documentation, and centralizing BI-related transformations for enhanced efficiency and transparency.
  • Implemented a range of testing methodologies including Generic Test, Relationship Test, and Custom Generic Test provided by DBT to validate model functionality, ensuring adherence to predefined standards and expectations.
  • Post-development of DBT models, ensured meticulous structuring and documentation of YAML files, facilitating the creation of an accurate and comprehensive DBT documentation page for data consumers.
  • Developed complex stored procedures in SQL utilizing Snowpark to orchestrate seamless data loading into the Snowflake environment, ensuring data integrity and efficiency.
  • Engineered Standard and Vectorized User-Defined Functions (UDFs) to enhance data processing speed, optimizing overall data processing efficiency and throughput.
  • Leveraged core functionalities of DBT such as Macros and Jinja to architect scalable functions applicable across the entirety of the Analytics Project, ensuring consistency and scalability.
  • Generated Real-time and Static reports utilizing Sigma with Snowflake as the primary data source, empowering stakeholders with timely and actionable insights.
  • Collaborated closely with business stakeholders and Data Analysts to facilitate setup and configuration of Sigma Workspaces, enabling seamless connection to Snowflake Models crafted for analytical purposes.
  • Provided comprehensive guidance to analysts, elucidating the intricacies of DBT-built Data Models while actively identifying and addressing any missing Data Elements crucial to business interests.
  • Spearheaded efforts to enhance documentation standards within DBT, emphasizing the critical importance of meticulously maintaining YAML files for transparent data definition and dissemination to end-users.
  • Consistently applied principles of Continuous Integration/Continuous Deployment (CI/CD), leveraging tools such as GIT Lab and JIRA to streamline the development, testing, and deployment of new models with precision and efficiency.

Business Intelligence Developer

AmerisourceBergen
Oakville, ON
03.2018 - 10.2018
  • Spearheaded the development and maintenance of robust data pipelines utilizing Databricks, facilitating the ingestion, processing, and analysis of substantial data volumes sourced from diverse enterprise channels.
  • Engineered an advanced analytics pipeline leveraging Databricks to execute Extract, Transform, and Load (ETL) operations, ensuring seamless data flow and optimal performance.
  • Implemented Snowflake Schema models to accommodate complex hierarchical relationships and accommodate evolving business requirements,
    ensuring flexibility and scalability in data analysis.
  • Collaborated closely with Data Analysts to orchestrate the refinement and enhancement of Data Models for reporting purposes, utilizing Azure Data Factory to streamline processes and enhance reporting capabilities.
  • Conducted comprehensive Data Profiling initiatives to gain deep insights into critical data elements, ensuring data accuracy and consistency across all stages of the data lifecycle.
  • Revamped existing logic structures within Business Intelligence (BI) Tools, transitioning them to Azure Data Factory, resulting in improved efficiency and integration across data management platforms.
  • Implemented sophisticated data optimization techniques, including partitioning, indexing, and compression strategies, within Azure Data Factory, resulting in enhanced query performance and significant reductions in storage and compute costs.
  • Executed rigorous testing protocols on complex data pipelines to ensure alignment with business requirements before their productionalization, mitigating risks and ensuring data integrity.
  • Formulated intricate data models encompassing a blend of multiple fact entities with varying granularities, catering to diverse analytical needs and facilitating comprehensive data analysis.
  • Devised and implemented robust scripting methodologies to effectively integrate scripts into Qlik Applications, enhancing automation and operational efficiency.
  • Contributed to the gathering of technical requirements for the development of interactive dashboards in QlikView, enabling stakeholders to derive actionable insights from data visualization.
  • Conducted data retrieval and research activities to generate actionable reports using tools such as Qlik Sense, empowering decision-makers with timely and relevant information for informed decision-making.

Business Intelligence Developer

AmerisourceBergen
Frisco, Texas
09.2016 - 03.2018
  • Lead the development of multiple sophisticated applications utilizing QlikView, Qlik Sense, and PowerBI, meticulously crafted to provide comprehensive Analysis
  • Conducted thorough analysis and interpretation of client business requirements, employing strategic methodologies to transform them into meticulously crafted Logical and Physical Business Intelligence solutions.
  • Implemented and upheld stringent data modeling best practices to safeguard data integrity, promote consistency, and optimize efficiency across intricate databases and expansive data warehouses.
  • Demonstrated proficiency in optimizing and constructing dynamic T-SQL queries, streamlining data retrieval processes and bolstering analytical capabilities within Azure SQL Database environments.
  • Played a pivotal role in the modeling and design of databases and data marts, contributing valuable insights and expertise to ensure the development of scalable and efficient data structures.
  • Developed a diverse array of T-SQL queries, stored procedures, functions, and views within Azure SQL Database environments, facilitating seamless data retrieval, manipulation, and analysis to drive informed decision-making.
  • Collaborated extensively with cross-functional teams to seamlessly embed Qlik Sense objects into internal portals, ensuring a cohesive user experience and maximizing accessibility to business intelligence insights.
  • Successfully navigated and mitigated browser compatibility challenges associated with embedded objects, implementing effective solutions to ensure optimal functionality and user experience across diverse web environments.
  • Designed and implemented robust database schemas, tables, indexes, and views using SQL Server Management Studio (SSMS) and other similar tools, prioritizing efficiency and scalability in data storage and retrieval processes.
  • Authored custom security rules to grant access to specific business units within database environments, ensuring strict adherence to data security protocols and regulatory compliance standards.
  • Orchestrated the creation and scheduling of weekly QlikView reports for distribution via email using NPrinting and publisher, ensuring timely dissemination of critical insights to key stakeholders.
  • Provided comprehensive estimates for the migration of Crystal Reports, guiding seamless transitions to modern reporting solutions while minimizing disruptions to business operations.

Business Intelligence/Data Visualization Engineer

Intel Corp, Intel Education
Santa Clara, California, CA
12.2014 - 06.2016
  • As a Part of sales and marketing group within Intel our team developed a content delivery platform for teachers and school to manage and distribute classroom materials through cloud.
  • Our BI team was responsible for developing Insights an analytics platform that tracked student activity within the application and also supported management in developing relevant financial KPI's that was of interest.
  • Created Insight (Grade vizualization) tool for Schools using Qlikview
  • Implemented custom CSS and Javascript code to alter the look and feel of Qlikview UI
  • Documented and analyzed system requirements. Lead remote Geo team in fixing defects and tracking progress.
  • Assisted in implementing product strategy based on previous use cases and data samples.
  • Developed analytics platform for teachers to track various key metrics like time spent reading, annotations made, and total pages read. Worked establishing a data pipeline for Gradebook data with Kettle Pentaho (Open source data integration tool).
  • Coordinated with sales team to determine product specs and deliverables. Coordinated with backend engineers to develop a deployment platform to push new build into Qlik serves via GIT and Bamboo servers (Linux Deployments).
  • Worked extensively with CSS to customize QlikView dashboard to meet Intel's branding needs.

Data Analyst

ThreePDS
Dallas, TX
01.2011 - 11.2014
  • Worked closely with management to prioritize data needs.
  • Monitor Quality of data imported to build reports.
  • Assisted in ETL developments, documentations and testing.
  • Developed and implemented data collection system to be imported into reporting tools like QlikView, SAS and Excel.

Education

BBA - Finance

University of North Texas
Denton,Texas
08-2014

Skills

  • Qliksense
  • Sigma
  • PowerBI
  • Qlik Sense Administration
  • Python : Pandas/Apache Airflow/Bookeh/PlotPy
  • Node JS
  • Saprk-SQL,PySpark,Snowpark
  • SnowFlake
  • AWS/Azure/Google Big Query
  • PowerShell
  • DBT
  • Javascript/HTML/CSS/BootStrap

Timeline

Senior Business Intelligence Engineer

Apotex Inc
10.2018 - Current

Business Intelligence Developer

AmerisourceBergen
03.2018 - 10.2018

Business Intelligence Developer

AmerisourceBergen
09.2016 - 03.2018

Business Intelligence/Data Visualization Engineer

Intel Corp, Intel Education
12.2014 - 06.2016

Data Analyst

ThreePDS
01.2011 - 11.2014

BBA - Finance

University of North Texas

Similar Profiles

CREATE PROFILE
Prajwol Thapa