Rob Andrew N Email & Phone Number

Los Angeles, Ca, Us

San Joaquin County, California, United States

Worked alongside a focused team to build standard and ad-hoc reports and dashboards in Tableau and Power BIConfigured Tableau data sources and handled client requests to handle data inconsistenciesParticipated in scrum methodology in Azure DevOps to negotiate project scope and address risk of creep with a high functioning backlog of client requestsLeveraged Microsoft SQL Server to build datasets and compile data for reporting purposesFluently communicated with other healthcare professionals to translate semantic business needs to changes in dynamic claims reports

Santa Ana, California, United States

Developed new changes to a slow running stored procedure in an integrated workflowCleaned and prepared high volume of daily claims data for Tableau dashboardingReduced the runtime of an 8 hour stored procedure by 25% and identified other areas to improve the runtime further beyond the scope of my projectInvestigated and analyzed complex nesting stored procedures to identify slow running stepsUtilized execution plans to identify missing indexes and make suggestions for optimizing slow running queriesCreated functional indexes, crosswalk tables, CTEs, and views to resolve business needsIdentified key strategies to implement changes to slow running stored proceduresGenerated dynamic pivot statements to cut down slow run timesTransitioned team to an incremental and full load system for higher variability and better control over the data

Worked alongside a fast paced team to maintain and update a live RDBMS environmentUsed complex SQL using views, CTEs, variables, and inner/outer joins to investigate and resolve findings from QA teamManaged and maintained ETL jobs for weekly, monthly, and quarterly data loads in a timely manner by collaborating with team members alongside client needsEdited complex stored procedures to resolve processing errors and clean the data processUsed SSIS to create packages for data extraction and optimized data loadingDeployed packages and created Integration Services Environments to create SQL JobsCollaborated with business leads to resolve client questions and build queries to give higher levels of understandingHelped our team with a recent data migration to an optimized platformImplemented configuration with parameters to deploy the SSIS project across multiple environments.Updated and refreshed processing files using SVN Check-InsCreated detailed documentation for the processes already implemented in our team and new processes which I created myself

Denver, Colorado, United States

Coordinated with the business users to clarify business requirements pertaining to the database application.DevelopedFormulated complex SQL queries, derived tables, common table expressions (CTEs), stored procedures, views, and user defined functions (UDF).Worked alone and with experienced team members reallocating millions of customers and their sales data for better company-wide visibilityCultivated higher visibility of KPIs for business executives by cleaning and mapping dirty data for analysis needsCollaborated with co-workers and business users on reports and dashboards utilizing Tableau