Carolina Murillo Email and Phone Number

● Created and maintained tables, and stored procedures in the data warehouse in SQL Server Management Studio (SSMS) by communicating with various business teams (operations, accounting, etc.) to see what data would best simplify their tracking and reporting processes.● Developed SQL queries to fetch necessary data & exports the results into and Excel file for each team in the company when requested resulting in improved data accessibility and usability in order for them to make the best… Show more ● Created and maintained tables, and stored procedures in the data warehouse in SQL Server Management Studio (SSMS) by communicating with various business teams (operations, accounting, etc.) to see what data would best simplify their tracking and reporting processes.● Developed SQL queries to fetch necessary data & exports the results into and Excel file for each team in the company when requested resulting in improved data accessibility and usability in order for them to make the best business decisions.● Migrated Microsoft Access Database tables that refreshed manually once a week into the SQL Server warehouse that automatically refreshed every 15 minutes by converting MS Access’s SQL language into SSMS’s SQL language and adding any additional data manipulation. The migration and automation of the employee performance data provided significantly quicker results for the employee performance dashboard giving the opportunity for employees to see the quantitative results of their hard workfaster and be able to be recognized for it a lot quicker as well.● Wrote Python scripts that retrieve files from a source, convert and manipulate the data, and go to Postman for load tests. A second python script I developed took the manipulated file and stored it in a corresponding MongoDB database table.● Collaborated in an Agile work environment, participating in weekly scrum meetings and utilizing JIRA to track progress and manage tasks, and documented project outcomes in Confluence to ensure knowledge sharing and project continuity. Show less

● Developed and maintained ETL processes to support the RedShift data warehouse in Amazon Web Services (AWS) resulting in an increase in data throughput.● Worked directly with a Data Analyst and helped them meet reporting requirements by providing modifications to data and eliminated errors using AWS Glue/Redshift/S3.● Analyzed source data using AWS S3 buckets to identify data quality issues and developed strategies to address them using problem solving skills resulting in a reduction… Show more ● Developed and maintained ETL processes to support the RedShift data warehouse in Amazon Web Services (AWS) resulting in an increase in data throughput.● Worked directly with a Data Analyst and helped them meet reporting requirements by providing modifications to data and eliminated errors using AWS Glue/Redshift/S3.● Analyzed source data using AWS S3 buckets to identify data quality issues and developed strategies to address them using problem solving skills resulting in a reduction in data inconsistencies.● Participated in code reviews with the team of developers and built relationships by communicating regularly with suggestions or questions for improvements on current tasks. Show less