Adrian Hernandez Email & Phone Number

Orlando, Fl, Us

Worldwide, Oo

At this company, I have led the design and implementation of critical ETL processes using Databricks, focusing on data cleaning, analysis, and querying. I manage Databricks environments, integrate them with AWS, and migrate SQL pipelines and databases from Oracle to Azure SQL, ensuring seamless transitions and robust data infrastructure support.Some of the key achievements in this role include:* Developed and optimized Databricks pipelines for efficient data cleaning and analysis, enhancing overall performance.* Streamlined SQL-based processes by migrating legacy Qlik QVDs into Databricks, leading to improved data accessibility and reporting efficiency.* Configured and optimized Databricks environments to integrate AWS policies and S3 storage, improving cross-platform functionality.* Provided expert-level support for the migration of Oracle on-prem data, databases, and code to Azure SQL, ensuring smooth transition and minimal downtime.* Delivered key reporting and analytics solutions by utilizing SQL Server, SSAS, and SSRS to support business intelligence initiatives.* Assisted data engineering teams in troubleshooting SQL and Databricks issues, resulting in increased operational efficiency.

Richardson, Tx, Us

• Managed ETL and data related processes using tools such as SQL Server, SSIS, T-SQL, etc.• Implemented reporting solutions using SSRS,and Power BI. Help clients gain value from their data via Dashboards, reports and other data reporting tools.• Assisted customers in migrating Healthcare data and processes to 3rd party cloud based healthcare analytic solutions.• Analyze, clean and transform data to gain actionable insights.

Basingstoke , Hampshire, Gb

• Developed data processes, queries, etc., on SQL Server on Azure for reporting solutions.• Developed, deploy and administer Power BI reports, Dashboards, and shared datasets.• Shared data, reports, workspaces, etc., in Power BI service (cloud) with company users.

Orlando, Florida, Us

In my role as an ETL & Data Developer, contracted through TEKsystems, I managed the ETL infrastructure, adapting it to business changes, and enhanced operational efficiency through advanced SQL Server, T-SQL, and .NET processes. I also upgraded ETL architecture and optimized system performance comprehensively.Some of the key achievements in this role include:* Enhanced ETL processes to handle complex business rule changes more efficiently, reducing system bottlenecks.* Designed and deployed new data processes using SSIS, SQL, and other tools, improving data processing speed and accuracy.* Developed prototype Power BI dashboards for finance and marketing, enabling faster and more insightful reporting.* Spearheaded the transition from legacy reporting systems to modern tools like SSRS and Power BI, enhancing reporting capabilities.* Optimized stored procedures and queries, reducing execution times, and improving overall database performance.

Orlando, Fl, Us

As a Databases and Business Intelligence Engineer, I led advanced reporting solutions using SSRS and Power BI, managed reporting servers, and spearheaded a pilot project promoting Power BI as the primary reporting tool, significantly enhancing data processing and reporting capabilities.Some of the key achievements in this role include:* Introduced new Power BI dashboards with drill-down and advanced filtering capabilities, improving user experience for reporting.* Enhanced SQL code for reporting purposes, leading to reduced execution times and resource usage across on-premises SQL Servers.* Established RedGate monitoring solutions, enabling real-time notifications for key system issues, improving system reliability.* Led the migration of reports to modern tools, successfully shifting from outdated reporting platforms to Power BI and SSRS.

Zamudio, Vizcaya, Es

At this company, as a Data Engineer, I developed Tableau reporting solutions and deployed ServiceMax for enhanced service management operations across North America, significantly streamlining data accuracy and process efficiency.Some of the key achievements in this role include:* Developed and deployed Tableau dashboards that improved visibility into key performance metrics for various departments.* Implemented and trained teams on ServiceMax, improving service management processes and data integrity across the organization.* Optimized ETL processes using SSIS and SQL, enhancing data accuracy and reporting efficiency for internal stakeholders.

Charlotte, North Carolina, Us

I supported business operations by enhancing BI tools and analytics, collaborated on IT development projects, and leveraged a range of technologies from SAP to Tableau for improved data collection, analysis, and operational insights.Some of the key achievements in this role include:* Developed and enhanced business intelligence tools to improve data accuracy and reporting across multiple departments.* Optimized data sourcing processes using SQL Server, Salesforce, and SAP, streamlining data collection and analysis.* Collaborated with IT and engineering teams to upgrade and support performance analytics tools, leading to better operational insights.* Implemented Tableau dashboards for performance monitoring, enhancing the visibility of critical metrics for leadership teams.

Charlotte, North Carolina, Us

• Served as a Granta MI (n-tier Information System used by engineering to work with materials data) engineer and admin. Managed system security, user access, import/export, data management for materials engineering data.• Developed advanced Excel, VBA, Access, and SQL based tools for importing/exporting data into 3rd party and custom (in house) solutions. Improved performance for existing tools and templates and overall data processes.

Plano, Texas, Us

3 Projects of experience as a Microsoft Business Intelligence Developer• Experience in MS SQL Server 2000 - 2012 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services.• Good experience to integrate multiple data sources including but not limited to multiple RDBMS (SQL Server, DB2, Oracle), flat files (csv, excel, dat and xml)• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency. Strong experience in client interaction and understanding business applications, data mining, data flow and data relations. • Created & formatted cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports.

Microsoft Sql Server Bi Certificate, Business Intelligence

Master'S Degree, Open Information Systems, Minor In Databases

Bachelor’S Degree, Computer Sciences, Major In Programming