Jose Alejandro Sanchez:

Jose Alejandro Sanchez

Programador www.hobbiesenred.com
WordPress Site https://hobbiesenred.com
Mail: progra@hobbiesenred.com
Facebook Alejandro Sanchez Alejandro Sanchez
Linkedin/ Jose Alejandro Sanchez

Professional Summary:

  • Backend Developer with more than 15 years of experience
  • Proficient in Relational Database Management Systems (RDBMS) – SQL Server and MySQL
  • Expertise in Transact-SQL, Stored procedures, Views, Functions
  • Vast experience in Data Extraction, Transforming and Loading (ETL) using several tools such as SQL Server Integration Services (SSIS) and SQL Jobs
  • Experience developing PowerShell and C# scripts
  • Expertise designing and developing SQL based reports using SQL Server Reporting Services (SSRS), Microsoft Excel and Power-BI
  • Analyzing, developing and testing .NET Applications
  • Experience in Data Warehousing and Data Modeling (Power-BI and SSAS)
  • Extensive knowledge of LAN/WAN design and support, fiber optic technologies and data networking implementation
  • Skills in supporting servers, hardware and software applications
  • Strong knowledge of project management; which includes: research, cost analysis, disaster recovery and business continuity planning
  • Ability to engage with employees, customers, vendors, and providers

Technical Skills:

  • Languages/Programming: T-SQL, PowerShell, C#, Python, PHP, VB.Net, HTML, VBA, DAX, JavaScript
  • Databases: SQL Server (SSMS, SSIS, SSAS, SSRS), MySQL, Power-BI, MS Access
  • Systems: Windows and Linux
  • Hardware: Servers, Switches, Routers, DWDM, SDH.
  • Networking: Switching and Routing, TCP/IP, DNS, DHCP, DMZ, FTP/FTPS/SFTP Servers, SDH and DWDM Systems
  • Firewalls: Cisco, Windows, Linux, others
  • Virtualization: VMWare and Hyper-V

Education:

  • Bachelor’s in Telecommunications Engineering, Polytechnic University (ISPJAE), Habana, Cuba 1997
  • Data Communication and IP Technologies Certificate, Centre for Excellence in Telecom Technology & Management, India 2011
  • Telecommunications Industry Accounting, Telecom Italia, Italy 2007
  • Windows Network Administration, Polytechnic University (ISPJAE), Habana, Cuba 2003
  • Linux Environment Administration, CENSAI, Cuba 2003
  • Website Programming, CENSAI, Cuba 2002
  • Advanced MS ACCESS, CENSAI, Cuba 2000

Work Experience:

DermCare Management Jan/2020

  • Data Developer
  • Developed a complex ETL Process using PowerShell Scripts, SSIS, Stored Procedures, Functions, Triggers, C# Scripts and SQL Jobs to populate the Company Data-Warehouse.
  • Developed daily email alerts to detect new dimension records.
  • Automatized Management Tasks using Excel and VBA Macros.
  • Developed Jet reports according to customer’s requirements.
  • Designed and developed SSRS Reports according to customer’s requirements
  • Tuned SQL queries to improve their efficiency, reducing the execution time and hardware usage
  • Developed PowerShell scripts to automatize regular administrative tasks
  • Developed Excel reports according to customer’s requirements.

Healthcare Financial Systems (HFS) – Hollywood, Florida Jan/2019 – Dec/2019

  • SQL Database Analyst and Developer
  • Developed the Billing App using C#, SSIS, SSRS and Stored Procedures to generate automatically the monthly invoices for each customer and Monthly Income Statement Reports
  • Developed a Workflow using PowerShell, C# and .NET to process EDI 835 files and save their data in a SQL Database and to generate 837 files from SQL Data. The use of this Workflow simplified the process and improved the results accuracy impacting the company income
  • Automatized Management Tasks using Excel and VBA Macros
  • Designed and developed complex SSRS Reports according to customer’s requirements
  • Tuned SQL queries to improve their efficiency reducing the execution time and hardware usage
  • Developed PowerShell scripts to automatize regular administrative tasks
  • Developed Power-BI models and reports according to customer’s requirements

Telefónica USA – Miami, Florida June/2016 – Dec/2018

  • SQL Database Analyst and Developer
  • SQL Developed ETL packages to extract data from complex log and configuration files and load it into SQL Server databases using SSIS, SSMS, Stored Procedures, triggers and C# or Python scripts
  • SQL Designed and deployed operational and dimensional databases
  • SQL Developed complex SSRS Reports
  • SQL Developed Shell and Python scripts to automatize regular administrative tasks
  • SQL Developed Real Time Reporting Systems from San Storage (VMAX, VNX), Backup Solutions (Data Protector, Actifio) and Monitoring Systems (eHealth, Solarwinds)
  • SQL Automatized management tasks using Excel and VBA Macros
  • SQL Implemented backup solutions for Oracle databases, Microsoft SQL Servers and Virtual Servers

Bupa Global. Health Insurance Company – Miami, Florida April/2016 – Mar/2017

  • SQL Database Analyst and Developer – Consultant
  • SQL Developed Stored Procedures, Functions and Views
  • SQL Designed SSIS Packages and Stored Procedures to process and import data from several data sources as Excel spreadsheet, Flat Files and Relational Databases to populate the Company Data warehouse
  • SQL Created Reference tables in order to support the information and to improve System efficiency, for example, the CPT and ICD codes per year
  • SQL Analyzed the Operational Database structure in order to design, develop and implement the most efficient ETL process
  • SQL Documented the project using Diagrams and Text as requested by the customer

Update: 2/21/2021