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

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.
• 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.

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.

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.