Alan Anderson Email & Phone Number

San Francisco, California, United States

Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis● Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements● Develop and deploy SSIS packages, configuration files, and schedules job to run packages to generate data in CSV files● Developed Data Source, Data Source View to create logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects● Created many calculated columns and measures using DAX in Power BI based on report requirements● Troubleshooting reports issues, ETL job failures, optimizing query performances● Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS● Explore data in a variety of ways and across multiple visualizations using Power BI● Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries● Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory and T-SQL.● Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.• Implemented data governance and security measures within Azure Data Lake, utilizing Azure Active Directory integration, role-based access controls (RBAC), and Azure Key Vault encryption to ensure data confidentiality, integrity, and compliance with regulatory standards such as GDPR and HIPAA.

Oakland, California, United States

• Specialized in developing BI solutions tailored to the healthcare industry, with a deep understanding of medical data structures, terminologies, and compliance standards (e.g., HL7, HIPAA).• Proficient in extracting, transforming, and loading (ETL) complex healthcare data from disparate sources, including Electronic Health Records (EHR) systems, claims data, and medical devices, using SQL and SSIS.• Developed multidimensional data models and cubes using SSAS, enabling in-depth analysis of clinical outcomes, patient demographics, and operational metrics for healthcare providers.• Designed interactive and intuitive dashboards and reports in Power BI, providing stakeholders with actionable insights into patient care quality, resource utilization, and revenue cycle management.• Implemented robust data integration solutions using SQL Server Integration Services (SSIS) to streamline the extraction, transformation, and loading (ETL) processes of healthcare data from diverse sources, ensuring data integrity and compliance with industry standards such as HIPAA.• Leveraged SQL Server Analysis Services (SSAS) to develop multidimensional data models and cubes tailored to the healthcare domain, facilitating advanced analytics and in-depth exploration of clinical outcomes, patient demographics, and operational metrics essential for healthcare providers' decision-making processes• Developed sophisticated multidimensional data models and cubes using SQL Server Analysis Services (SSAS), tailored specifically to healthcare analytics, enabling comprehensive exploration of clinical outcomes, patient demographics, and operational metrics to drive informed decision-making and improve patient care quality.• Designed and implemented scalable and resilient data lake solutions on Azure, leveraging Azure Data Lake Storage Gen2 to efficiently store structured, semi-structured, and unstructured data, enabling seamless integration and analysis of diverse data types.

Sacramento, California, United States

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.• Implemented Performance tuning to optimize SQL queries using query analyzer.• Tested to optimize the procedures and triggers to be used in production.• Designed transformation rules and processes to derive the correct data from the extracted data and transform into the required format and structure to support the business requirements.• Loaded CSV files and JSON files from Azure Data Lake Storage to Synapse using Azure Data Factory.• Imported and exported data, ETL packages with various control flow choices and data flow transformations, such as Conditional Split, Multicast, Union all, and Derived Column.• Developed ETL packages in SSIS with Lookup, Execute SQL Task, Sequence Container, Breakpoint, and Checkpoint to guarantee data quality and consistency.• Engineered data models and ETL processes, resulting in a reduction in data extraction time and increase in BI platform efficiency.• Collaborated with project managers, ensuring alignment with software design specifications, and implemented optimal development approaches, leading to improvement in project delivery timelines.• Recommended and implemented strategies, enhancing performance, and extending the lifespan of software installations, contributing to decrease in system maintenance costs.• Provided technical support, resolved BI platform issues promptly, and reduced user-reported incidents through proactive troubleshooting and user education.

San Francisco, California, United States

• Performed POC to integrate structured and unstructured data using Azure Data Warehouse and Azure Data Lake, using U-SQL and Azure Data Factory.• Used Azure Data Factory (ADF) to perform Incremental Loads from Azure SQL DB to Azure Synapse• Maintained T-SQL queries, views and stored procedures in multi-database environment with little supervision.• Produced high-standard database solutions to meet stability, reliability and performance metrics.• Developed custom database objects, stored procedures and delivered application support.• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.• Assist in Preparing performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis.• Identified and rectified issues in existing software and system applications, achieving a reduction in system downtime and increase in overall application reliability.• Utilized integrated development environments (IDEs) to streamline development processes, resulting in an improvement in code deployment efficiency.