Database & BI Specialist with 10+ Years Experience

KESHAR L. JOSHI Email: ***********@*****.***

Alhambra, CA 91801 Phone: 562-***-****

LinkedIn: https://www.linkedin.com/in/kesharjoshi-database/

PROFESSIONAL SUMMARY

An accomplished BI/SQL developer/Analyst specialized with valuable 10+ years of diverse experience in all phases of Software Development Life Cycle (SDLC), Database Objects Creation, SSRS, SSIS, and Normalization seeking a position where a high level of development, communication, and organizational skills can be utilized and enhanced.

PROFESSIONAL TRAINING

Computer System Analyst (1872 hrs.) (2004) – College of Software Engineering, Nepal.

EDUCATION

2001 - 01 Master’s in Business Administration, Tribhuvan University, Nepal

1997 - 01 Bachelor’s in Commerce, Tribhuvan University, Nepal

SKILLS

Database and SQL

Ms SQL Server, T-SQL, My sql, Airtable, Stored Procedures

Query Optimization, SQL Agent, Indexing

Cloud & Tools

Azure SQL, Azure Data Studio, Airtable databse

Excel (Power Pivot, Power Query, Macros)

Programming

Python (Pandas, ETL scripts)

VBA (Excel automation)

Data Modeling

Data Modeling: Visio, Erwin, Dataedo

Business Intelligence & Reporting

Power BI (DAX, M, Query Folding)

Power BI Report Builder, Tableau, SSRS

Semantic Models, Star Schema

ETL & Data Integration

SSIS, Power Query, Python ETL

QuickBooks, Fishbowl, CRM integrations

APIs, JSON, Flat-file ingestion

Project Delivery

SDLC, UAT Testing, Requirements Gathering

Documentation, Version Control, Agile

ACCOMPLISHMENTS

Built databases and dashboards from scratch following the full SDLC, enabling startup companies to operate more efficiently.

Improved SQL query and database performance by 40-70% through optimization and automation.

Built automated ETL pipelines (SQL/SSIS/Python), reducing manual work by 80%.

Designed Power Bi dashboards and semantic models that improved decision-making and cut refresh time by 50%.

Integrated data from QuickBooks, Fishbowl, CRM and Excel into a unified SQL database

Created Excel, SSRS reports, and Power BI dashboards saving teams 80% time.

Ensured 99% data accuracy through validation, cleaning, and UAT defect analysis.

Implemented RLS, security, and governance improving audit readiness.

PROFESSIONAL EXPERIENCE

Senior Database / BI Developer/ Analyst (Part time) Nov 2024 – Till Now

CanvasNepal Alhambra, CA

Created and managed SQL and Airtable databases, built tailored Dashboards, and reports in Power BI report builder that streamlined reporting processes and improved decision-making efficiency.

Documented enterprise databases using Dataedo, creating comprehensive data dictionaries with table, column, key, and relationship definitions.

Participated in the full solution development lifecycle gathering reporting requirements, collaborating with users to build efficient metadata, analyzing and organizing complex data with accuracy, and strategically embedding business logic within ETL and metadata models to deliver well-designed reports, dashboards, and BI solutions.

Analyzed the website views, client reach out, other scopes with timeline views using Google Analytics tool.

Designed and maintained data pipelines integrating Google Analytics data into SQL Server / Power BI for reporting and business insights.

BI Analyst / Database manager (Contract) June 16 2025 –Aug 15 2025

Neuroptics Irvine CA

Worked as a Database Architect, created a RAD Flow chart, documented it, interviewed with different stakeholders, and management.

Confirmed the Database objects, relationships, and made connections with other data sources like QuickBooks, SugarCRM, Fishbowl, Vintara.

Power BI reporting tool introduced, set up, and created some reports using different sources.

Created sales reports by regions and representatives, where quote vs. Sales are automated, which saved the sales director’s time by 90%.

Data manager April 2025- June 2025

LA County (Tetratech tech) Los Angeles CA (Contract)

Managed, cleaned, and validated large datasets that supported county-wide projects in areas such as environmental planning, infrastructure development, and emergency response.

Created and improved reporting in Power BI and Excel through Power Query, reducing manual work and saving nearly 80% of processing time.

Senior BI / Database Developer (direct hire) January 2022 – March 2024

Brainasium Los Angeles, CA

Led a team of four developers managing SQL databases in Azure Cloud and Airtable, and delivering scripts and reports aligned with company objectives where I had used Monday.com as a Project mgmt tool.

Gather necessary documents from end clients to design MS-SQL databases and other database objects.

Documented enterprise databases using Dataedo, creating comprehensive data dictionaries with table, column, key, and relationship definitions.

Develoerd ERDs (Entity Relationship Diagrams) in Dataedo to visualize dta modeles and improve system understanding for developers and business users.

Implement all the SDLC procedures and gather necessary documents from end users to generate reports using the Power BI Reporting Tool.

Collaborated with stakeholders to gather requirements, optimized stored procedures, and performed ETL processes to integrate data from multiple sources.

Analyzed web traffic, user behavior, and acquisition metrics to support data-driven business decisions.

Created custom GA dashboards and automated reports for marketing, product, and executive teams.

Automated reporting and Airtable workflows, reducing manual workload by 30% and improving efficiency by 20%.

BI Developer / Data Analyst (contract) December 2019 - December 2021

Kaiser Permanente Pasadena, CA

Collaborated with stakeholders to collect and verity client documentation, including Payers information, automates the Depreciation Budget, and deliver accurate reports using SQL Server, Excel (Pivot Tables, DAX).

Work on Property Management and depreciation-forecast concepts, contributing to the creation of a Depreciation Budget for the upcoming year. Automated scripts for future use.

Generate ad hoc reports and formulate queries based on specific client requirements.

Develop Stored Procedures for reporting purposes.

Create database objects and load data from flat files and other source files.

Utilize Views, Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases. Develop Reports on Business Objects.

Design and implement SSIS Packages to import data from various sources, automating job schedules.

Validate data and perform data analysis, comparing data in Excel with other tools.

Develop complex Pivot tables in Excel, extracting data from SQL Server.

Leveraged SSRS report to rapidly adopt power BI Paginated report Builder.

Designed and developed SSIS packages for ETL and data imports from diverse sources, improving efficiency by 30% and enabling more reliable data integration.

Mid-Level BI Engineer (contract) June 2019 – August 2019

Bravo Sports Santa Fe Spring, CA

Collected necessary documents from the end client to generate reports using Report Builder.

Generated ad hoc reports and crafting queries based on client specifications.

Developed Stored Procedures for reporting purposes.

Created triggers, stored procedures, functions, views, etc. to retrieve data efficiently, accurately, and timely.

Managed tasks related to the Microsoft Dynamics GP System.

Oversee daily EDI start and end-of-day data import/export processes.

Providing Gentran EDI support for MS GP Dynamics.

Created reports using the Power BI Reporting Tool.

Designing and implementing database objects, loading databases from given flat files.

Utilizing Views, Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases. Developing Reports on Business Objects.

Developed SSRS and Power BI reports (using DAX, STAR schema, SQL, CSV, and Airtable data), and built stored procedures and database objects, cutting manual work by 50%.

Managed Microsoft Dynamics GP tasks, provided Gentran EDI support, and ensured accurate reporting through client document gathering and data integration.

BI Report / Database Developer (contract) August 2017 – May 2019

AT&T El Segundo, CA

Handled financial and revenue data (Forecast, Actual, Budget) by creating tables, queries, and stored procedures.

Gathered requirements interviewing stakeholders, users.

Designed dashboards with Pie charts, tables, and various chart options while creating report on Power BI.

Created data dictionary and data modeling to migrate data across MSSQL, PLSQL, and MySQL.

Optimized queries using query optimizing tools, reorganizing indexes, and rechecking/altering scripts.

Generated reports in Business Object, SSRS, Tableau, and Report Builder environments.

Designed and developed reports/dashboards using Business Objects, SSRS, Power BI, Tableau, and data lake sources (fact/dimension tables, flat files, production, historical), improving efficiency by 20%.

Used JASON to parse data in SQL.

Worked with Python programming to retrieve data from SQL.

Database / BI Report Developer (contract) August 2016 - April 2017

BDS Marketing LLC Irvine, CA

Led requirements-gathering sessions with team leads and clients, and developed complex SSRS reports in Visual Studio (drill-down, cascading parameters) deployed with subscriptions and FTP automation.

Generated diverse types of complex reports (drill-down, parameterized, cascaded, etc.) in Report Builder, Visual Studio (SSRS), and Tableau, tailoring them to meet the specific requirements of Business Users.

Applied expertise in adding, updating, and comparing Geographic Information System (GIS) in a database-based Google map latitude and longitude.

Developed stored procedures for report creation in SSRS and Tableau.

Crafted Ad hoc Scripts and Reports as needed.

Managed, updated, maintained, and deployed reports in the production database.

Conducted data FTP using FileZilla software.

Created subscription reports based on client needs.

Worked with QlikView software to extract data from client sources.

Database / BI Developer (contract) November 2015 - April 2016

DirecTV / AT&T El Segundo, CA

Utilized advanced T-SQL/PLSQL (query optimization, materialized views, joins, and sub-queries) and Python for complex data analysis; performed SQL tuning with indexes to enhance query performance.

Designed, deployed, and managed SSIS packages for extracting and transforming data from SQL Server, Excel, Access, and flat files, ensuring accuracy and efficiency in production databases within an Agile/Jira environment.

Established connectivity with SharePoint and Project Server.

Gained experience in SharePoint by creating, updating, and maintaining projects.

Proficient in creating report dashboards in SharePoint.

Developed financial-based reports based on client requirements.

Created macros using VB to automate various tasks in Excel.

Utilized Visio tools to create milestones and timelines.

Database / BI Report Developer (contract) November 2014 - July 2015

BHP Billiton Houston, TX

Collaborated with team leads, BAs, and managers to gather requirements and create SSRS reports using fact/dimension tables (Star Schema) and stakeholder interviews.

Worked within the Team Foundation Server (TFS) environment.

Applied Materialized Views, Joins, correlated and non-correlated sub-queries for complex business queries across multiple tables from different databases.

Developed intricate PL-SQL queries for data analysis, research, bug identification, and resolution. Managed data uploads manipulation, updating, and maintenance in the production database.

Wrote and gathered supporting documents for SSRS reports through interviews with table owners, Business Analysts, and business users.

Extracted and transformed data from various sources such as Pervasive database, SQL Server, Excel, Access, and flat files using export-import tools and SSIS, ensuring alignment with business requirements.

Built and maintained dashboards with evolving requirements, reducing manual ad-hoc reporting by 85% and ensuring timely, accurate delivery.

Database Developer / Data Analyst (contract) September 2013 - October 2014

University of California San Diego (UCSD) San Diego, CA

Gathered requirements and documentation through interviews with users, team leads, managers, and directors to support reporting and data needs.

Executed data migration to newer SQL versions, and developed joins, sub-queries, and stored procedures for complex business queries across multiple databases.

Developed intricate T-SQL queries for data analysis, research, unit testing, and bug identification and resolution.

Developed payroll-based reports using SSRS in Visual Studio.

Created charts based on Excel data, with Excel data exported to SQL and data mapping.

Developed macros in Excel using VB to automate recording and execution of tasks.

Applied VLOOKUP and other formulas in Excel for efficient data filtering and retrieval.

Maintained and updated monthly data of students and employees by writing queries, uploading data into the database, and forwarding the information to team leaders and department VIPs.

LANGUAGES

English: Full Professional

Nepali: Native or Bilingual

Newari: Native or Bilingual

Hindi: Full Professional

Contact this candidate