A

Alija Karki Bhattarai

About

Detail

Euless, Texas, United States
Contact Alija regarding: 
work
Full-time jobs

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • Labcorp
    SQL/ BI Developer
    Labcorp
    Sep 2024 - Current (2 years)
    • Coordinated with Business Analysts and customers to develop business requirements and specifications documents using Microsoft word and Power Point. • Worked on OnPrem version of Data Warehouse initially and moved to Cloud version in order to solve the challenges faced on OnPrem Servers, leveraged power of Server less Azure Services which in turn used Apache Spark. • Implemented Data Factory Pipelines to load data from OnPrem SQL Server 2022/2019to Azure Data Lake Storage in the form of a comma separated value format and further loaded this data into Azure MS SQL. • Designed physical and logical data models and handling data repository for data models. • Analyzed and performed Data modelling and mapping which involved identifying the
  • D
    SQL/ETL Developer
    Delta Dental Insurance
    Oct 2022 - Aug 2024 (1 year 11 months)
    • Implemented data warehousing solutions, including the design and development of dimensional models and ETL processes to support business intelligence and reporting needs. Utilized Azure Data Factory for orchestrating data pipelines and Azure Databricks for scalable data transformation. Developed Power BI dashboards using DAX and RLS for secure and interactive reporting. • Utilized advanced SQL features such as window functions, common table expressions (CTEs), and recursive queries to solve complex data manipulation and analysis tasks. • Used T-SQL for data transformation tasks, including data cleansing, data merging, and data aggregation. • Experience building Analytics Platforms using Python. • Implemented Azure Data Factory pipeli
  • C
    Jr. SQL Developer
    Cedar Gate Technologies, Inc.
    Jun 2020 - Aug 2022 (2 years 3 months)
    • Involved in requirement analysis for new development or change requests, understanding existing defect in system. • Work closely with Report Analysts and Operation Staff for support in problem resolution and root cause analysis. • Worked on change requests pertaining to existing database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to support ongoing business change requests. • Developed new user defined stored procedures, user defined functions, and triggers using T-SQL as part of adding new data elements in the Data Warehouse. • Created Clustered and Non-Clustered Indexes to improve the performance of database access by looking at actual execution plans and index suggested