“An Analytical mind with a problem-solving aptitude, Microsoft Certified Solutions Associate in SQL Server 2012/2014 with experience designing, developing and maintaining Business Intelligence (BI) in the organization, presenting information through reports and visualization, crafting and executing queries upon request for data, the implementation of Extract, Transform, and Load (ETL) processes with control flow and data flow definitions, the implementation of Enterprise-Level Master Data and Data Quality, Building Dimension Tables in a Data Warehouse, configuring logging and event handling, deploying an ETL solution, and Implementing Master Data and Data Quality Solutions. SSIS, SSAS, SSRS, HTML5, CSS3, JavaScript, jQuery, AJAX, ASP.NET. Experience in programming language such as C#, T-SQL and development environments such as Microsoft Power BI, Microsoft Visual Studio and Microsoft SQL Server”.
Work Experience
SQL Developer & DBA / Business Intelligence (BI) Analyst - City of Doral. Doral, Fl – USA
Jan 2019 - Current
Create dashboards, automated reports, report templates and presentations using advanced data visualization tools, such as PowerBi, to provide an easy to understand interface for end users to quickly identify key themes within data.
Works with Directors and other team members to understand & clarify data analysis and reporting needs. Provides guidance and insight on data visualization options for report design.
Monitors database for performance problems: reviews error logs, checks to see that scheduled jobs have been completed, troubleshoots database connectivity issues. Provides application support to end-users and technical staff.
Plans, coordinates, and implements security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure of city's data at rest and while in transit.
Approves, schedules, plans, and supervises the installation and testing of new products and improvements of computer systems, such as the installation of new databases or testing changes to an application database system on multiple test and QA environments.
Monitors and optimizes system performance using index tuning, disk optimization, and other methods. Administers users and user access levels within database environment.
Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
Ability to transform the data from the staging database and transform the data using Data Flow Tasks and worked extensively with on ETL process using SSIS Packages.
Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
Hands on Experience in Managing, Monitoring and Troubleshooting SQL Server Management Studio 2012, 2014 and 2016.
Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
IT System Administrator / SQL DBA - Davis Engineering. Miami, Fl – USA
Jan 2010 - Dec 2018
Administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases.
Design and implement SQL Server Database backup strategies and Perform backups of all databases routinely.
Perform disaster recovery plans using backups and restores.
Implement database maintenance plan, create user profiles and grant permissions depending of the level Hierarchy.
Maintain or update business intelligence tools, databases, dashboards, systems, or methods.
Monitor and profile database servers for load and performance bottlenecks.
Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.
Responsible for Improvement the performance of the data integration operations controlling parallelism in Microsoft SQL Server Integration Services (SSIS) platform (ETL) for extraction, transformation and loading the data into destination of the data warehousing.
Tracking metrics over a period of time with SQL Profiler to monitor data growth and usage to determine database and hardware scalability and capacity requirements.
Generate standard or custom reports summarizing business, financial for review by executives, managers and other stakeholders.
Good understanding of SQL Tables, Indexes, Stored Procedures and Functions.
Familiar in MS SQL Server suite of products like SSIS, SSAS and SSRS of MS SQL Server.
Installation, repair, configuration and preventative maintenance of personal computers, network equipment and telecommunications equipment.
Installation, configuration, and maintenance of LAN/WAN hardware, software, and peripheral equipment.
Install, configure and maintain server systems and software monitor performance and upgrade. Set up and modify new and existing computer workstations, servers and network components.
Configuration and debugging of server and network desktop clients to include TCP/IP, network printers, security management, and other applications.
IT System Administrator – Ameritel Wireless. Pembroke Pines, Fl - USA
Oct 2002 - Dec 2009
Install, configure and support Dell network server devices, print servers, PCs, laptops, Cisco routers and switches at all locations.
Perform troubleshooting and technical support to all users for Microsoft Office products, specialize software, PCs and networking issues.
Manage all WAN/LAN connectivity for local and remote offices.
Installation, Configuration, and support organization's LAN/WAN. Monitor network to ensure network availability to all system users and perform necessary maintenance to support network availability.
Collaborate with management team to identify strategic IT initiatives and facilitate the adoption of technology-based solutions.
Programmer Analyst / Technical Support – Banco Occidental de Descuento. Maracaibo, Venezuela
Jan 1999 - Mar 2001
Maintain and Administer Computer Networks and related computing environments including computer hardware, system software, application software and all configurations.
Perform installation and configuration of software packages on end user machines, and provided overview of software use to end-users.
Perform troubleshooting and Technical Support diagnosis to hardware/software network failures and provided resolutions.
Perform installation, configuration and maintenance of Windows and Servers Cisco infrastructure system network components, Domain Controllers (WINS), DNS, DHCP, Mail Servers (Exchange Server), Dataware Server, FILE Server, FTP Server, Intranet Server, Antivirus Server (Symantec), Cluster, SQL Server, IIS, Internet Server (ISA Server 2000), SMS Server, MOM Server.
Design, develop and implement of System, ATM devices (Automated Teller Machines) and wire transfer system Applications (SQL/MP and SQL/MX database C-TAL, COBOL, Tandem).
