Bi Developer Data Engineer

Dilli Acharya

Email: *****.**@*****.*** Cell: 714-***-**** Address: Beaumont, CA, 92223

Objective

Seeking a full-time position as a BI Developer, SQL Developer, Data Warehouse Developer, SSRS/Power BI Developer, ETL Developer, or Data Engineer where I can utilize my expertise to support organizational growth and innovation.

Summary

Over 10 + years of IT experience as a BI Developer, SQL Database Developer, Data Warehouse Developer, Data Engineer, SSRS / Power BI Developer, and ETL Developer.

Experienced in Data Migration, Data Integration, and Data Conversion across various systems, including MS CRM to Data Warehouse, CRM to Salesforce, Anthology to Salesforce, and within multiple docketing software platforms.

Expert in writing complex SQL Queries, Stored Procedures, views, triggers, and functions. Expert in database Performance Tuning, performance monitoring and Database schema design.

Experienced in developing ETL Processes using SSIS, Power Automate, Python and Azure Data Factory (ADF).

Designed and developed Data Warehouses with Fact/Dimension models and corresponding ETL Jobs.

Multiple years of experience in developing Power BI reports, Dashboards and Paginated reports. Skilled in writing complex DAX and designing Power BI Data models.

Proficient in SSRS Reporting to develop professional reports with features such as Drill Down, Drill Through, Sub reports, Linked Reports, Data Driven Subscriptions.

Experienced in developing SQL Server Analysis Services (SSAS) cubes (both Multidimensional and Tabular Cube), MDX, DAX.

Experienced in creating User interfaces using MS Power Apps and MS Power Automate.

Developed Master Data Services (MDS) models and synchronized it with Data Warehouse (EDW).

Strong in documentation, time management, teamwork, and problem-solving.

Experienced in Agile/Scrum environments and the software development life cycle (SDLC).

Databases: MS SQL Server (2005 - 2022), Azure Databricks, Microsoft Azure SQL, MS Access, Oracle.

Reporting: SSRS, Power BI, Power BI Paginated Reports, Tableau, Excel.

ETL: SSIS, Power Automate, Python, BCP Utility.

Languages: T-SQL, PL/SQL, Python, DAX, MDX, XML Query, C#, C++, Visual Basic, JSON, XML, PowerShell.

Additional Skills: Data Modeling, Database Design, Schema Design, Fact and Dimension Modeling of Data Warehouse, SCD Type2 Database Modeling, Data Integration, Data Migration, Analysis Services (SSAS) Cubes, (Multidimensional & Tabular SSAS Cube), Parsing XMLJSON data using SQL and Python, SQL Query Execution Plan, Performance Tuning, Data Integration to Salesforce using CData-DBAmp connection.

Tools: SSMS, SSDT, Visual Studio, VS Code, SQL Profiler, Power Apps, Power Automate, Master Data Services (MDS), Data Quality Services (DQS), Jupyter Notebooks, TFS, Azure Data Factory (ADF), Azure DevOps, Jira, Red Gate, Microsoft CRM

Professional Information

Work Eligibility: U.S. Citizen (Naturalized)

Education: M.S. in Electrical Engineering, California State University, Fullerton

Certification: Microsoft Certified Professional

Sr. BI Developer / Database Developer / Data Engineer (Dec 2024 - Present)

American Homes for Rent (AMH), Calabasas, CA https://www.amh.com

Develop numerous Power BI Dashboards, Reports and Paginated Reports with professional looking designs.

Designed and developed multiple Microsoft Power Apps applications (with MS SQL as the backend).

Developed Power Automate flows to automate data load processes and set up email alert notifications.

Created data ingestion processes using SQL and Python to load data into DataScience databases from various Sources systems and Flat files.

Wrote complex business logic in SQL Stored Procedure, Functions and Python Scripts to prepare analytical layers of data before loading them into DataScience databases.

Analyzing Source System data, Ensuring data Integrity and Data quality. Ensure Proper design in database objects.

Refactored multiple SQL and Python Scripts to point data source from Azure Databricks.

Took responsibility of daily monitoring of Data Load Jobs, resolve any Prod issues and errors, Research and resolve any issues in reports and databases. Support Ad Hoc requests.

Closely worked with Asset Management, Pricing Management and Finance Departments to collect requirements and feedback for their Reporting and Dashboarding needs.

Sr. BI Developer / Data Engineer (Jan 2022 – Dec 2024)

West Coast University, Irvine, CA https://westcoastuniversity.edu

Developed downstream and upstream Data Integration Jobs to sync data back and forth within multiple platforms like: Salesforce, Anthology, Canvas, MS CRM and on-prem Data Warehouse.

Migrated Data for multiple campus branches of West Coast University (WCU) and American Career College (ACC) from Microsoft CRM to Salesforce.

Implemented complex logics in SQL Stored Procedures, Functions, Views, Triggers in the Data Warehouse layer, Reporting layer, and Data Integration layer.

Built numerous Power BI dashboards and Paginated Reports using DAX and advanced Power BI features (like: bookmarks, page navigation, filters, drill through, drill down, field parameters, Visual calculations).

Developed and maintained SSRS Reports, implementing features like Drill Down, Drill Through, Sub Reports, Linked Reports, and Data Driven Subscriptions.

Implemented logic to call various APIs from Stored Procedures using OAMethod and parse JSON responses into SQL tables.

Developed SSIS Packages to load data from various sources (flat files, SharePoint lists, CRM, Salesforce Marketing Cloud, Anthology) into the Data Warehouse. Created outbound file generation processes using SSIS, BCP Utility and Python.

Daily monitoring of data load processes, SQL jobs, and report refresh schedules. Created automated email alerts for production failures.

Developed Power Automate flows to call APIs, configure data load jobs, and automate notification alerts.

Refactored legacy SQL stored procedures and views for performance improvement. Performance tuning using SQL Profiler, Execution Plans, Database Tuning Advisor, and DMVs.

Investigated and resolved production issues in data load processes and reports; supported daily ad-hoc requests.

Sr. BI Developer / Database Developer / Data Engineer (Oct 2016 – Dec 2021)

New Century Health (NCH), Brea, CA https://www.newcenturyhealth.com

Designed and developed Enterprise Data Warehouse (EDW) and corresponding ODS Staging layer of Databases for healthcare data using SCD Type2 dimensional modeling Approach.

Built end-to-end ETL processes with SSIS to load Authorization and Claim data from CRM and GHIS backends into EDW Fact and Dimension tables, incorporating SCD Type 2 logic.

Developed numerous SSRS Reports including CMS Compliance reports with advanced features such as drilldown, drill-through, sub-reports, linked reports, matrix/tabular layouts, row/column groupings. Utilized Data-Driven and Standard Subscriptions for scheduled delivery of report files.

Designed Power BI Dashboards and Paginated Reports with interactive visualizations using complex DAX and features like bookmarks, page navigation, hyperlinks, synced slicers, filters, and drill-through capabilities.

Built and maintained SSAS Multidimensional Cube and Tabular Cubes on the top of EDW Fact and Dimension tables.

Created Master Data Services (MDS) models, entities, and subscription views. Developed SSIS packages to integrate MDS data with EDW tables bidirectionally.

Authored complex Stored Procedures, Views, Functions, Triggers, and Merge statements across EDW layer, Analytical layer, and Reporting layer.

Developed automated ETL monitoring reports and alert emails. Involved in production monitoring, issue resolution, and performance optimization.

Built analytical layer data marts on top of EDW to support complex business logic, internal/external reporting, and advanced analytics.

Participated in Design Review and Code Review of other developer’s work and giving proper feedback.

Database Developer / Database Engineer (Feb 2014 – Sep 2016)

American LegalNet (now Aderant), Encino, CA www.alncorp.com

Worked on multiple Data Conversion / Data Migration projects from legacy docketing systems (MA3000, ProLaw, Elite, JuraLaw, LawBase, DM2000) to eDocket backend.

Built and optimized Stored Procedures, Functions, Views, Tables (with indexes, triggers, constraints) to support new and existing features of eDocket software.

Created database installation packages using RedGate. Developed pre/post deployment scripts for eDocket DB Wizard Installer. Deployed DB changes to QA/UAT/PROD.

Developed SSIS packages to load legal case data from court SFTP sites into our centralized Data Warehouse for Docket Direct and Case Alert services.

Implemented MS SQL Boolean Search functionality using Full Text Search (Full Text Index) method.

Implemented SQL Server Database Maintenance Jobs (Reorganize Indexes, Recreate Index, Update Database Statistics, Cleaning Maintenance History).

Daily monitoring of SQL Jobs, ETL Jobs, and their logs. Implemented Email Alerts, and Log-reports.

Developed numerous SSRS reports and maintained existing ones.

Conducted SQL Performance Tuning using SQL Profiler, DMV, SQL Execution Plans. Identify bad and long running SQL Codes and refactor them.

Jr. SQL Developer / QDBA (Aug 2012 – Jan 2014)

Lender Processing Services (LPS), Irvine, CA. http://www.lpsvcs.com

LPS is now Black Knight Financial Services (BKFS) https://www.blackknightinc.com

Wrote numerous SQL Scripts and XML queries for ETL Testing and Data Comparison between the Property Data Warehouse (called PDW) and its source systems.

Developed Automated Data Validation Platform specific to each data model in Property Data Warehouse

Wrote Dynamic SQL to handle state-wise and county-wise data tables in source system.

Implemented business logics for multiple Data Models such as Loan Transaction History, Pre-Foreclosure Transaction History, Foreclosure Transaction History, Risk Analysis Model etc.

Write complex SQL Stored Procedures, Views, and Functions including calculations of distance and area using longitude, latitude, and geographic data types. Implemented Logics for comparative analysis of properties (houses) within a certain radius range.

Support ad hoc data requests and on-demand data analysis. Researching data mismatches between sources and EDW.

Involved in gathering, reviewing, and understanding requirements, logic, and transformation rules for both the source-to-Property Data Warehouse (PDW) layer and the PDW-to-final product layer.

Contact this candidate