demostenes gonzalez

* Setup a backup/restore strategy using Arcserve backup agent from CA which was essential to protect the data on the databases for the financial systems. * Worked with functional business personnel to create a database that facilitated the assessment and continuous improvement of reporting and analysis of data across the organization to deliver actionable insights. * Researched the company’s call center and identified issues that allowed me to create a documentation process greatly reducing the volume of calls for support. * Member of a team working in the design, coding, testing of a high level ETL system on a data-integration project for financial reporting that consolidated information from different accounting applications. * Worked with an IT manager to determine the database hardware and configuration needed for third-party software packages.

✯ Team Leadership: Designed a database for parts inventory, job tracking and reporting with SQL and Microsoft Access. Automated daily tasks performed among laboratory personnel and collaboration with design engineers. Provided support for AutoCAD and Pro-Engineer by installing, configuring and troubleshooting advanced software modules and integration with the design tools for engineers. Implemented test plans that ultimately impacted products design and features. Involved in every phase of the product cycle, devising methods and strategy to obtain the best performance out of wiring devices.

■ Responsible for repair and maintenance of PCs and peripherals. ■ Customer support on hardware and software installation and configurations.

✪ My first job ■ Servicing AM/FM radio station transmitters and two-way transmitters. ■ Responsible for the sound projecting equipment of the radio station.

* Hands-on installation and configuration of SQL Server database instances, remote monitoring and maintaining system health and security on premises and on the cloud. * Project lead in establishing a disaster recovery protocol from design, test to implementation for all database systems. * Developed database management procedures, T-SQL scripts, SSIS packages and full documentation to automate common tasks for database maintenance keeping the system performing optimally. * Analyzed data from various financial system and built SSIS packages to aid the development of in-house reports solution using SSRS greatly reducing the amount of money spent on vendor’s support feeds. * Challenge and encourage support team in continuous process improvement efforts, also provided the tools and knowledge to team members so that they could achieve their goals in supporting the client’s needs.

Developed purchase requisition reports using SQL Server Reporting Services, Amazon cloud hosted database application on SQL Server, T-SQL programming and used my knowledge of Visual Basic to write custom functions that were embedded to the reports. Debugged and improved many board of finance reports used by top decision-making executives at the organization. These custom reports were developed writing stored procedures, T-SQL code and SSRS deriving data from a cloud-based application with many generic columns, used SSIS to format and cleanse source data for the reports. Worked on improving the report system so that it would allow for more flexibility and future requirements. Worked on a new report structure by fixing the report model so that more report definitions can be derived and reports categories can be mapped appropriately as new report types are developed. Implemented new and improved stored procedures, SQL code and made modifications to the SSRS reports to produce the new reports as requested.

Young & Rubicam Group is a global network of preeminent companies focused on building strategic partnerships to deliver global excellence in all forms of communications. Our family of companies, long described as "best alone, better together," focuses on the delivery of the broadest and most innovative of integrated solutions for our clients.