|
Programador www.hobbiesenred.com
WordPress Site.
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
Publication in HobbiesEnRed:
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: 3/9/2021
|
