Este perfil está escrito em inglês
BI Developer
Demonstrated experience with SQL Server [contact hidden].
Demonstrated experience with Oracle.
Demonstrated experience with Teradata.
Demonstrated experience with Postgres.
Demonstrated experience with SSIS.
BI Developer open to new opportunities
Developed ETL processes to populate metrics for Verizon myInfo applications, enhancing call center performance tracking.. Collaborated with web developers on data issues and led SQL server upgrades in 2017 and 2022, coordinating migration and testing with DBA and team.. Managed Teradata to GCP migration with contractors and requested storage expansion for data growth.. Facilitated daily meetings with onshore and offshore teams.. Contributed to API development for Retail Dashboards and participated in on-call rotation for process continuity.
Developed and implemented material automation for Project Management, integrating data from multiple sources to support Demand Planning and Order Management.. Collaborated with Applications Developers to transmit updated data through APIs.. Partnered with business groups to create custom reports and enhance existing ones.. Troubleshot SSIS and SQL Agent jobs, established alerts, and managed data purging and archiving processes.
Served as a key resource for XLCubed and Tableau implementation.. Administered Tableau server and Excel add-on.. Configured Tableau server, optimised performance, and rolled out iPad app to 90+ employees.. Developed database objects and reports using SSIS, SSRS, and Tableau.. Modified ETL jobs for data warehouse and mart.. Troubleshot ETL issues and data discrepancies.
Designed and developed databases for EMV chip and pin payment terminal project, ensuring PCI compliance by tokenising credit card data.. Collaborated with the development team to implement SQL Server databases for complex applications.. Installed and configured SQL Server 2008 R2 and 2012 in standalone and clustered environments.. Developed and optimised OLTP databases, stored procedures, and SSIS packages.. Managed over 100 SQL instances across the enterprise.. Established maintenance plan and backup processes for application databases.
Oversaw development, implementation, and support of BI/reporting solutions and data warehouse in SQL Server 2008 R2.. Created, tested, and deployed report definitions with SSRS and SSAS.. Developed ETL packages via SSIS, automating data extraction/load processes on scheduled intervals.. Addressed ETL job issues, managed database security, and performed backup and restore operations.