Pablo Anzola
Myrtle Beach,SC
Summary
Dedicated Data Engineer with over 6 years of experience specializing in the design, development, and maintenance of data solutions across various industries. Proficient in constructing and managing robust data pipelines for seamless ingestion from source to target systems. Adept at translating business requirements into insightful reports and visually appealing dashboard designs. Skilled in designing, developing, managing, and delivering customized reports to meet specific business needs. Extensive involvement in the design and development of software solutions within the financial industry. Recognized as a subject matter expert, providing guidance to both Data Engineers and Application Software teams.
Overview
23
23
years of professional experience
1
1
Certification
Work History
Business Object Developer – Expert
Union Bank MUFG (contracted through Inspyr Solutions, Remote Work)
11.2022 - 07.2023
- Contribute to the establishment of a standardized process for defining data requirements and the design, development, creation, and publication of BI reports and dashboards using BI Tools/Tableau Server for business stakeholders
- Execute data preparation tasks essential for the successful delivery of Data Visualization Solutions within BI Tools, particularly Tableau Server
- Aid in the delivery of BI reporting and dashboards in Tableau, leveraging Python Functions and SQL Server Integration Services for enhanced functionality
- Provide support in defining, designing, implementing, and maintaining key performance indicators (KPIs) to bolster operational efficiency
- Collaborate on identifying innovative approaches to resolve complex design problems associated with BI and advanced data visualization
- Design, develop, and implement Python Functions for inserting and updating data in SQL Server
- Execute ETL processes by Extracting, Transforming, and Loading data from Excel, logs, and flat files to MS SQL Server using Microsoft Visual Studio and SSIS integration services
- Implement ETL using SQL Server Integration Services (SSIS)
- Design, develop, and test stored procedures, views, tables, and functions within SQL Server
- Create, publish, and maintain Analytic Reports in Tableau Server using Tableau Desktop
- Deploy, run, and update data pipelines with Python code for inserting, deleting, and updating data in the SQL Server Database
- Design, implement, support, and deploy Python data pipelines in Spyder.
Data Engineering Applications Specialist
Scotiabank – ScotiaGBS, Remote Work
11.2020 - 08.2022
- Manage large volumes of logs in Splunk (over 25 terabytes of data) with a 7-year retention policy
- Create and oversee data pipelines for ingesting substantial data volumes from diverse source systems (over 100 sources) into Splunk Production
- Build, design, and maintain scalable, custom-built technology solutions to fulfill reporting and ETL application needs within Splunk Software
- Maintain data pipelines during the ingestion of various data sources using Splunk
- Design, build, and operationalize large-scale enterprise data solutions and applications utilizing analytics services
- Develop production data pipelines, covering ingestion to consumption, within a big data architecture, incorporating SSIS, services, Google Cloud, Balabit Syslog, and Splunk heavy forwarder
- Implement data engineering, ingestion, and curation functions through custom programming using SQL, Python, and SPL
- Act as a subject matter expert for Data Engineers, Application Software and ETL Developers
- Design data models in Splunk for unstructured big data
- Generate, develop, and implement stored procedures, jobs, and views in SQL Server databases
- Design, build, and maintain production SQL queries for ingesting transaction data with Splunk
- Integrate Python through Rest API on Linux Servers for Splunk
- Create Dashboards in Power BI
- Develop Dashboards in Splunk using SPL, HTML, XML, CSS
- Implement alerts to detect missing files/logs in Splunk, utilizing SPL Code and Cron expressions.
System Engineer (SME TP Observer)
Teleperformance
10.2016 - 11.2020
- Design and construct data pipelines, covering the entire process from data ingestion to consumption, within a big data architecture (Power BI/Splunk/SQL Server)
- Install and oversee web applications in Windows Server IIS service
- Establish environment parameters for workflow inputs in web applications
- Monitor a network of over 30 servers using Zabbix, Orion, and Dynatrace
- Develop and manage stored procedures, jobs, and views in SQL Server to optimize data pipelines
- Generate SQL queries to supply data to Power BI and Splunk
- Design Analytic Reports and Alerts in Power BI/Splunk
- Integrate and correlate critical data between Splunk software and in-house applications to generate Critical Security Operational Alerts
- Manage databases on over 10 servers
- Oversee the infrastructure of more than 10 Windows servers
- Resolve critical issues within managed applications.
Data Analyst
UNISYS Corporation
10.2015 - 10.2016
- Design, create, and maintain reports in SQL Server and Excel
- Develop and design reports for software and hardware incidents that are in an open status
- Create and publish reports for business leaders
- Manage and update the support ticket system (ServiceNow)
- Report the status of incidents to regional technology leaders.
Data Analyst (SARA Project)
FLEXOSPRING SAS
05.2015 - 07.2015
- Generate reports in SQL Server
- Integrate and deploy the CRM SARA web application
- Configure rules for the payroll application
- Provide end-user support for the application
- Establish environment parameters for workflow inputs in the CRM application.
Systems Administrator
KHEMRA TECHNOLOGIES
03.2009 - 03.2015
- Proficient in developing dynamic web pages using HTML, PHP, CSS, JS, and Dreamweaver to create visually user interfaces
- Expertly manage Oracle Database 10g/11g Express Edition, ensuring efficient and secure data storage and retrieval
- Provide comprehensive IT support to end users, addressing and resolving technical issues to maintain a smooth operational environment
- Successfully oversee the implementation and management of ERP software information systems, handling client and server installations, and offering end-user support to resolve software issues
- Skillfully create and format reports using Crystal Report V.10, contributing to effective data presentation and analysis
- Implement data backup strategies by scheduling jobs, ensuring the integrity and availability of critical information
- Design and manage the Moodle virtual learning platform (LMS) for employee training, fostering a streamlined and effective learning management system
- Administer Windows Server 2008R2/2003, Active Directory, mail server, and SQL Server, ensuring the smooth functioning of critical server-based systems.
Junior Web Developer
CERP SOFTWARE SAS
12.2013 - 12.2014
- Developing C# code using Visual Studio to implement software solutions
- Integrating web services and proficiently crafting XML files to facilitate seamless data exchange and interoperability between systems
- Designing user interfaces with a focus on user experience using ASP.NET, ensuring a responsive and visually appealing frontend
- Expertly creating and managing databases in SQL Server 2008/2012, employing best practices for data integrity, security, and performance
- Constructing and optimizing SQL Server stored procedures to enhance database functionality and streamline data processing
- Orchestrating the scheduling of jobs to execute database procedures, ensuring timely and automated execution for efficient data management
- Crafting engaging and interactive user interfaces utilizing HTML5, JavaScript, and CSS to deliver a modern and intuitive user experience.
Data Center IT Analyst
BMC SOLUTIONS, Myrtle Beach SC
08.2007 - 12.2008
- Proficient in configuring and installing servers, racks, switches, hubs, routers, UPS, and structured cabling to establish and maintain optimal functionality in data center environments
- Adept at installing computer equipment for users within the local network, ensuring seamless integration and optimal performance
- Demonstrated ability to provide comprehensive technical support to clients and customers, addressing and resolving issues to maintain a reliable and efficient IT infrastructure.
Data Center IT Analyst
Networks Operations, New York NY
01.2007 - 07.2007
- Proficient in the configuration and administration of data center servers, ensuring optimal performance and reliability
- Skilled in conducting corrective and preventive maintenance for data center servers, ensuring continuous operational efficiency
- Experienced in hardware and software configuration for both Linux and Windows servers, with a focus on optimizing system functionality
- Proven ability to provide comprehensive technical support to clients and customers, addressing inquiries and resolving issues promptly
- Competent in configuring and managing data backup systems, ensuring the security and integrity of critical data.
Junior Systems administrator
International Silver, New York NY
12.2000 - 04.2005
- Delivering efficient technical support to clients and customers, ensuring prompt issue resolution and customer satisfaction
- Proficient in configuring and managing data backup systems, safeguarding critical data, and ensuring data integrity
- Conducting preventive and corrective maintenance for the local network, overseeing (2) Windows NT servers, and maintaining 10 client computers to guarantee optimal functionality
- Administering and implementing information systems to enhance operational efficiency and support organizational objectives.
Education
Bachelor of Science - Computer Engineering
Polytechnic Grancolombiano University
Bogotá, Colombia04.2021
Associate of Science - Technology in Systems Administration
Polytechnic Grancolombiano University
Bogotá, Colombia06.2018
Skills
- MS SQL Server
- Splunk Enterprise 90
- Splunk SPL Language
- Spyder Python
- Jupiter notebook-Panda
- Dynatrace
- Orion
- Zabbix
- Microsoft Visual Studio
- Microsoft Windows Server
- HTML5
- CSS
- MS Excel
- Power-BI
- Office 365
- VMware & VirtualBox
- Regular Expressions
- SSIS -SQL Server Integration Services
- SSMS-SQL Server Management Studio
- ETL Integration with Visual Studio
- Scrum (Agile)
- Azure Synapse & Devops
- Azure Databricks
- Snowflake
- Tableau Desktop/Server
Certification
- Certificate in Data Analysis with Panda and Python, Udemy, Aug 2023
- Splunk Enterprise System Administration, Splunk Software, May 2022
- Data Warehousing ETL (Level 4 Advanced), Triplebyte Engineering Certificate, June 2022
- Yellow Belt - PL/SQL Assessment, Secure Code Warrior, May 2022
- White Belt - PL/SQL Assessment, Secure Code Warrior, May 2022
- Developing with Splunk's REST API 8.1, Splunk Software, November 2021
- Creating Dashboards with Splunk 8.2, Splunk Software, September 2021
- Splunk for Analytics and Data Science, Splunk Software, September 2021
- Microsoft: Data Management & Analytics - Querying Data with Transact-SQL Certificate 20-761, Microsoft, August 2019
- Microsoft: Data Management & Analytics - Certificate 40 hours: Querying Data with Transact-SQL Course 20-761, Intelligent Training Educational Institution-Microsoft Official Partner, June 2018
- Certificate in Networks and Telecommunications (CCNA) emphasis in Security, Polytechnic Grancolombiano University, Bogotá, Colombia, June 2020
Timeline
Business Object Developer – Expert
Union Bank MUFG (contracted through Inspyr Solutions, Remote Work)
11.2022 - 07.2023
Data Engineering Applications Specialist
Scotiabank – ScotiaGBS, Remote Work
11.2020 - 08.2022
System Engineer (SME TP Observer)
Teleperformance
10.2016 - 11.2020
Data Analyst
UNISYS Corporation
10.2015 - 10.2016
Data Analyst (SARA Project)
FLEXOSPRING SAS
05.2015 - 07.2015
Junior Web Developer
CERP SOFTWARE SAS
12.2013 - 12.2014
Systems Administrator
KHEMRA TECHNOLOGIES
03.2009 - 03.2015
Data Center IT Analyst
BMC SOLUTIONS, Myrtle Beach SC
08.2007 - 12.2008
Data Center IT Analyst
Networks Operations, New York NY
01.2007 - 07.2007
Junior Systems administrator
International Silver, New York NY
12.2000 - 04.2005
Bachelor of Science - Computer Engineering
Polytechnic Grancolombiano University
Associate of Science - Technology in Systems Administration
Polytechnic Grancolombiano University
Similar Profiles
Lisa Trang TRANLisa Trang TRAN
Director – Regional Relationship Manager at MUFG Bank (previously known as MUFG Union Bank)Director – Regional Relationship Manager at MUFG Bank (previously known as MUFG Union Bank)
Naira DavtyanNaira Davtyan
Client Relationship Consultant at U.S. Bank / MUFG Union BankClient Relationship Consultant at U.S. Bank / MUFG Union Bank
MARK A. VALLESMARK A. VALLES
Vice President, Issues Reporting Department at MUFG UNION BANK N.A. / U.S. Bank N.A.Vice President, Issues Reporting Department at MUFG UNION BANK N.A. / U.S. Bank N.A.