Luis Cazares Email and Phone Number

Improve and maintain database code for their different systems.• Improved processes by reducing processing times and resource consumption by correcting T-SQL code and redesigning indexes.• Maintained and improved SQL Server Analysis Services cubes• Monitored and fixed outages or problems reported by users in production environments. • Created and delivered training to write high performing SQL code.• Mentored developers on writing SQL code.• Reviewed code to prevent errors or performance problems from being introduced in the system.• Detected problematic code causing poor performance on the system and provided alternatives to fix it.• Worked with Agile Methodology tracking the product backlog and resolved the defects/solution assigned during sprints.

Assigned to contract with PrimeRevenue.Improve and maintain database code for the trading OLTP system.• Improved processes by reducing times and resource consumption in half by correcting T-SQL code and redesigning indexes.• Created a best practices document for SQL Server code.• Created and delivered training to write high performing SQL code.• Reviewed code to prevent errors or performance problems to be introduced in the system.• Detected problematic code causing poor performance on the system and provided with alternatives to fix it.• Worked with Agile Methodology tracking the product backlog and resolved the defects/solution assigned during sprints.

Improve and maintain database code for Financial Compliance, Audit Management, and Claims Administration systems.• Maintain and improve previous processes.• Improve performance on long running queries and processes.• Code review.• Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned during sprints.• Define Best Practices for database development.• Coordinate efforts to implement CI/CD for database code.Technologies: SQL Server 2008/2012/2017, CA Agile Central, Pervasive SQL.

Improve and maintain database code for Financial Compliance, Audit Management, and Claims Administration systems.• Maintain and improve previous processes.• Improve performance on long running queries and processes.• Code review.• Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned during sprints.• Define Best Practices for database development.• Coordinate efforts to implement CI/CD for database code.Technologies: SQL Server 2008/2012, CA Agile Central.

In charge of the Deposits area for the Management Information Systems. Responsible for duties involving T-SQL programming, ETL processes and OLAP cubes correctness.• Maintain and improve previous processes.• Migration processes from SQL Server Data Transformation Services to Stored Procedures and SSIS projects.• Improve performance on long running queries and processes..• Creation of Data Analysis cubes on SSAS.Technologies: SQL Server Management Studio 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, SQL Server Data Transformation Services.

Developer of management reports for compliance department, obtaining information from different servers and databases.• Create and maintain reports for compliance department.• Deliver reports on distinct formats such as Excel files, Access databases and SQL Reports.• Document all the activities within each project.• Database design for applications.Technologies: SQL Server Management Studio 2008, SQL Server Reporting Services 2008, Teradata SQL Assistant.

Open Technology is a company that is dedicated to the sales of Access Control, Credentialing, Automation, Process Optimization and Recruitment of Personnel. Constructed, Maintained and upgraded databases using SQL Server 2008. Built a critical BI Project that increased productivity and sales by using the application Qlikview.• Designed and Constructed Databases.• Improved performance on long running queries.• Automatize processes using SQL Server jobs and stored procedures.• Provided maintenance and support on the Databases.• Developed Qlikview BI projects.Technologies: Qlikview & SQL Server 2008.

Azur Sistemas de Informacion is a company that develops software for middle to large corporations enabling them to streamline their processes, productivity and profit. Developed and improved multiple applications for many clients.• Maintained and improved an ERP system using Visual FoxPro and SQL Server.• Acted as Development leader for the Sales department, accounts receivable and printers’ estimates.• Implemented migration between different administrative software applications.• Participated on Sharepoint development projects.Tools Used: Visual FoxPro 6, SQL Server 2000/2008, Sharepoint 2007 & ERP.