Summary
Overview
Work History
Education
Skills
Application Experience
Personal Information
Timeline
Generic

Laxman Timalsina

Fort Worth,CT

Summary

With over 9 years of experience, I specialize in the end-to-end implementation of robust database systems, data warehouses, integration services, and reporting frameworks. My expertise spans several in-demand tools, including

Overview

10
10
years of professional experience

Work History

Database Developer

Blue Shield of California
03.2024 - Current
  • Developed and optimized complex SQL queries in Snowflake SQL for data validation, manipulation, and analysis
  • Designed and implemented DBT SQL logic and macros as well as Jinja functions to meet business requirements, facilitating effective data management and decision-making processes
  • Collaborated with cross-functional teams to gather requirements, analyze data, and provide actionable insights to drive business decision-making
  • Conducted data analysis and provided strategic recommendations based on findings to support business objectives
  • Worked in an ELT environment using Azure Synapse and Azure Data Factory for orchestrating and automating data workflows, including data movement and transformation
  • Environment: Windows Operating System, Snowflake Database, DBT, Azure Synapse, Python, Visual Studio Code, SQL, GitHub, SharePoint, Autosys, Excel 2010/2016

Data Analyst /Data Modeler

CareSource
01.2023 - Current
  • Developed and optimized complex SQL queries for data extraction, manipulation, and analysis, resulting in improved efficiency and insights
  • Led data modeling efforts using Erwin Data Model tool, ensuring data integrity and consistency across various projects
  • Designed and implemented IBM Data Warehouse as atomic and Consumption layer using Erwin data model tool, according to business requirements, facilitating effective data management and decision-making processes
  • Managed SQL Server databases, including schema design, indexing, and performance tuning, ensuring optimal database performance
  • Collaborated with cross-functional teams to gather requirements, analyze data, and provide actionable insights to drive business decision-making
  • Conducted data analysis and provided strategic recommendations based on findings to support business objectives
  • Utilized Azure Data Factory for orchestrating and automating data workflows, including data movement and transformation
  • Environment: Windows Operating System, MS SQL Server 2019, Databrick SQL/MySQL, Git
  • Hub, SharePoint, Autosys, MS Visio, Excel PowerPivot, MS Excel 2010/2013, C# .NET

ETL Developer

Vaya Health
01.2022 - 02.2022
  • Created Stored procedures with complex SQL logics where created temp table, CTE, derived table then used accordingly in SSIS Package and SSRS Reports source
  • Developed complex Teradata stored procedures using temp tables, CTEs, and derived tables for ETL processes and reporting in SSIS and SSRS
  • Expertise in analysis, design, and development of end-to-end business intelligence solutions using the MSBI suites such as SQL Server Integration Services (SSIS) and Azure Data Factory, SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
  • Used SSIS variables, parameters, and expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Script tasks, etc
  • Performed unit testing, troubleshooting the slow running SQL Query and Optimized SQL Query with best practices where execution time reduced significantly
  • Conducted and automated the ETL operations to extract data from multiple data sources; transform inconsistent and missing data to consistent and reliable data; and finally load it into the EDW data warehouse
  • Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document
  • Involved in creating power BI reports and wrote DAX Query Language
  • Used Power View and Power Map to visualize reports
  • Environment: Windows Operating System, MS SQL Server 2019, Git hub, Azure DevOps, SharePoint, MS Visio, Excel PowerPivot, MS Excel 2010/2016, C# .NET
  • Client

BI Developer

GainWell Technology
01.2020 - 11.2021
  • Involved in complete SDLC process by analyzing business requirements and functional workflow of information from source systems to destination systems
  • Expertise in analysis, design, and development of end-to-end business intelligence solutions using the MSBI suites such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
  • Used SSIS variables, parameters, and expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments
  • Conducted and automated the ETL operations to extract data from multiple data sources; transform inconsistent and missing data to consistent and reliable data; and finally load it into the multi-dimensional data warehouse
  • Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document
  • Extensively involved in creating robust complex power BI models, writing complex DAX logic's involving rank, filters, and data massaging
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports
  • Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh
  • Environment: Windows Operating System, MS SQL Server 2016, SQL Server Data Tools for
  • Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, Autosys, MS Visio, Excel PowerPivot, MS Excel 2010/2016, C# .NET
  • Collaborated with cross-functional teams to identify business requirements and translate them into technical specifications.

SQL Developer

BCBS
04.2018 - 12.2019
  • Good Experience on creating dashboards, volume reports, operating summaries, and presentations and graphs
  • SSRS Integration to Power BI
  • Hands on experience on Optimal approach for obtaining data from diverse source system platforms and moving it to the BI
  • Expertise in analysis, design, and development of end-to-end business intelligence solutions using the MSBI suites such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
  • Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and MultiValue Parameters in SSRS
  • Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting
  • Involved in creating complicated packages with custom coding using c#.NET in SSIS
  • Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity
  • Extensively involved in creating robust complex power BI models, writing complex DAX logic's involving rank, filters, and data massaging
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments
  • Worked on TFS for performing tasks
  • Environment: Windows Operating System, MS SQL Server 2016, SQL Server Data Tools for
  • Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, Autosys, MS Visio, Excel PowerPivot, MS
  • Excel 2010/2013, C# .NET
  • Analyzed existing SQL queries to identify opportunities for improvements.

Software Developer

Discover Financial Services
10.2016 - 03.2018
  • Responsible for data modeling, designs and development, oversight of implementation, testing, and managing the relationship between the client and the development team
  • Created complex SSIS package to automate complete process and deployed them to File Share & Server to enable users execute these processes using SQL Server 2016
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements
  • Analyzed the requirements and their usage for different reporting purposes using Tableau and PowerBI Visualization tools
  • Explore data in a variety of ways and across multiple visualizations using Power BI
  • Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
  • ETL processes development from third party FTP site to Local SQL Database using Integration Services (SSIS) and .Net Scripting in C# SSAS
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and analyze multi-dimensional reports
  • Used SSIS tasks like Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database
  • Used Team Foundation Server (TFS) to check-in/check-out SSRS reports & SSIS packages
  • Environment: MS SQL Server 2012/2008R2, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), SQL Profiler, Windows 10 and Windows 2003/2008 Server.
  • Saved time and resources by identifying and fixing bugs before product deployment.

Database Developer

Westfield Insurance
10.2014 - 08.2016
  • Involved in complete SDLC process by analyzing business requirements and functional workflow of information from source systems to destination systems
  • Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document
  • Conducted and automated the ETL operations to extract data from multiple data sources; transform inconsistent and missing data to consistent and reliable data; and finally load it into the data warehouse
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts
  • Wrote complex queries, stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules
  • Used XML & environment variables in package configuration for Deploying SSIS packages
  • Generated Drill down, Drill through, Ad-hoc, Matrix Reports, Parameterized reports in SSRS
  • Customized new columns and KPI's in Power Pivot models utilizing DAX
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports
  • Converted Excel reports into SSRS reports and into other required formats
  • Integrated SQL Server reporting services with Microsoft SharePoint Portal Server to deliver automatically generated reports to the Share Point portal
  • TFS used to manage different versions of new and existing reports and code, branching and merging into production
  • Developed functional and technical documentation to assist in the design, development, and maintenance of deliverables.
  • Identified issues within databases, performed troubleshooting and implemented effective solutions.

Education

Bachelors in Law -

Tribhuvan University
Nepal, Kathamandu

Skills

  • SQL Server
  • Snowflake
  • Azure Synapse
  • Teradata
  • SSIS
  • SSRS
  • Informatica
  • Azure Data Factory
  • DBT
  • Tableau
  • Power BI
  • MS SQL Server
  • Oracle SQL
  • JIRA
  • Azure DevOps
  • GitHub
  • Databricks
  • Pyspark
  • Windows Server
  • Unix
  • Linux
  • T-SQL
  • PL/SQL
  • ASPNET
  • Net Framework
  • C#
  • XML
  • Python
  • DTS
  • IBM
  • Informatica Cloud
  • TFS
  • Erwin Enterprise Architect
  • Data Quality Service
  • MDM
  • MySQL
  • DB2
  • Erwin Data Modeler
  • IBM Infosphere Data Architect
  • Oracle SQL Developer Data Modeler
  • SQL programming

Application Experience

  • Healthcare
  • Insurance
  • Retail Connect
  • Finance and Banking

Personal Information

Visa Status: US Citizen

Timeline

Database Developer

Blue Shield of California
03.2024 - Current

Data Analyst /Data Modeler

CareSource
01.2023 - Current

ETL Developer

Vaya Health
01.2022 - 02.2022

BI Developer

GainWell Technology
01.2020 - 11.2021

SQL Developer

BCBS
04.2018 - 12.2019

Software Developer

Discover Financial Services
10.2016 - 03.2018

Database Developer

Westfield Insurance
10.2014 - 08.2016

Bachelors in Law -

Tribhuvan University

Similar Profiles

  • Maria Del Rosario Cole

    Maria Del Rosario ColeMaria Del Rosario Cole

    Implementation Manager, Consultant at California Physicians Services - Blue Shield of CaliforniaImplementation Manager, Consultant at California Physicians Services - Blue Shield of California

    View Profile
  • CHITRA LAXMANAN

    CHITRA LAXMANANCHITRA LAXMANAN

    Head of Product Strategy & Management at Blue Shield of CaliforniaHead of Product Strategy & Management at Blue Shield of California

    View Profile
  • DAN NGUYEN

    DAN NGUYENDAN NGUYEN

    Sr. Compliance Analyst at Blue Shield of California Promise Health PlanSr. Compliance Analyst at Blue Shield of California Promise Health Plan

    View Profile
Laxman Timalsina