Bruno N.

Data Engineer

BI Analyst
1/2/2019 - 1/1/2019

Developed DW loading routines, OLAP data modeling, and maintained database structures. Conducted data gathering and process documentation while reviewing procedures for performance improvement. Created ETL packages using SSIS, monitored and troubleshooted loads, and supported the development of new functionalities. Employed agile methodologies, including Scrum, with tools like Jira.

Data Architect
1/2/2019 - Present

Developed corporate data models for microarchitecture environments, enhancing system efficiency and scalability. Created and maintained scripts for the modification of data structures in production environments, ensuring system integrity and seamless updates. Leveraged non-relational databases (MongoDB) for the development of CQRS patterns, optimizing data retrieval and command execution processes. Conducted extensive data collection to support the development of new system features, driving innovation and improving user experience.

Senior Database Analyst
1/2/2017 - 1/1/2019

Developed OLAP models for BI systems, specializing in data integration routines using Integration Services. Crafted complex stored procedures for calculating indicators and KPIs. Managed database structures, implemented script review and control for production execution, and handled data extraction and importation processes. Enhanced query performance through optimization and tuning, and provided support in the development of new system features.

Senior Database Analyst
1/2/2016 - 1/1/2016

Managed production environment in SQL Server along with various development environments, performing tasks such as backup/restore, index defragmentation, query tuning, and files/filegroups maintenance. Developed data extraction routines using SSIS in a distributed database environment encompassing Teradata, DB2, Oracle, Informix, and PostgreSQL across multiple network servers nationwide. Oversaw the Reporting Services Server and created management reports based on data collected from multiple company units. Maintained effective communication through emails and participated in conference calls with teams in the USA.

Senior Database Analyst
1/2/2015 - 1/1/2016

Handled planning, documentation, management, and integration of corporate information resources. Conducted a comprehensive survey and analysis of the primary company databases to provide a modeling approach that ensured consistency, normalization, data sharing, and integration, while eliminating redundant data. Undertook restructuring of legacy databases, transitioning them to a new database structure on a new systems platform using SQL Server 2014. Executed the migration of legacy data to the new data structure through data transformation, developing data loading routines and integrating with other corporate and legacy systems. Developed both logical and physical data models of the restructured new databases utilizing a data modeling tool, specifically Toad Data Modeler. Additionally, defined data access levels to ensure information availability was restricted appropriately based on the type of information.

Senior SQL Developer Analyst
1/2/2014 - 1/1/2015

Managed and maintained SQL servers, implementing automation routines for server restoration. Analyzed and developed SQL scripts for addressing various issues, providing infrastructure support including database development, problem resolution, GMUD application in production, and systemic log analysis. Spearheaded the development of a data integration system between internal systems, mapping legacy data migration processes and building the new data integration platform. Oversaw functional tests for system interfaces and developed control and log execution for system integration processes. Maintained and developed new features in the Goals and Rewards Control system, adhering to business rules set by the sales team. Created data extraction interfaces between multiple systems and the Salesforce CRM platform.

DBA
1/2/2012 - 1/1/2013

Involved in re-formulation and data migration from Oracle platform to SQL Server in São Paulo Area, Brazil. Developed proficiency in creating SSIS packages for seamless data migration and integration with various satellite systems. Demonstrated technical expertise in developing routines for optimizing financial calculations and storing pre-calculated data in the new SQL Server database to significantly improve performance.

Senior Database Analyst
1/2/2011 - 1/1/2012

Spearheaded the development of integration processes and data migration from legacy systems to a new company platform. Exhibited advanced skills in creating SSIS packages and developing stored procedures to seamlessly integrate data across various corporate systems, specifically utilizing SQL Server 2008. Gained significant expertise in ensuring data consistency and reliability during migration phases, contributing to the overall efficiency and stability of the new platform.

DBA
1/2/2010 - 1/1/2011

Developed customizations for a Business Intelligence (BI) system focused on financial credit analysis, showcasing proficiency in building tailored solutions to meet specific analytical needs. Specialized in the development of Extract, Transform, Load (ETL) packages using SQL Server Integration Services (SSIS) and VB Script, alongside writing and optimizing stored procedures to introduce new system functionalities. Led successful migrations of websites to a new data processing center, which included the seamless conversion of databases from SQL Server 2000 and 2005 to SQL Server 2008. Conducted thorough validation of models and data structures, ensuring compliance with stringent standards and seamless access to new system data. Provided valuable guidance to programmers in database development, SQL access, and adherence to best practices, enhancing overall system efficiency and performance.

Database Analyst at Citibank
1/2/2008 - 1/1/2009

Transitioned a database from SQL Server 2000 to SQL Server 2005 within an international project scope. Conducted extensive data extraction and transformation to align with new data models and data types available in SQL Server 2005. Re-engineered complex Stored Procedures to leverage new features of SQL Server 2005, including the conversion of outdated commands from the previous version to their updated counterparts.

Database Administrator
1/2/2006 - 1/1/2007

Gained expertise in maintaining SQL Server Database Models using Erwin. Developed and executed DML scripts to update database structures reflecting changes in the data model. Leveraged T-SQL to create stored procedures for large-scale SQL Server 2005 databases. Monitored and automated processes within large OLAP database systems to ensure optimal performance. Maintained SQL Server databases and resolved production issues efficiently. Developed comprehensive reports utilizing stored procedures and SQL Server Reporting Services.

SQL Database Analyst
1/2/2005 - 1/1/2005

Developed proficiency in maintaining database models in SQL Server using Erwin. Enhanced understanding of data flow within the corporate database, facilitating user access to tailored information through specific reports. Utilized T-SQL to create stored procedures for interfaces, data extraction, and reporting. Demonstrated expertise in generating reports using Crystal Reports XI and administering Business Objects Enterprise XI.

Database Analyst
1/2/2004 - 1/1/2005

Analyzed the intrusion detection system and monitoring processes of a corporate network to identify critical measurement points for report creation. Collected network security data from various sources and compiled comprehensive reports using Crystal Reports XI and Oracle 9i. Developed expertise in network security monitoring, data analysis, and report generation within a corporate healthcare environment. Demonstrated proficiency in integrating and synthesizing data from multiple systems to provide actionable insights for security improvements.

Systems Analyst
1/2/2001 - 1/1/2004

In the Greater Seattle Area, this role involved developing specific reports from various systems and databases using Crystal Reports. This included the creation of Excel spreadsheets that utilize data from multiple sources such as Access, Excel, and SQL Server. Maintenance and development tasks were performed on an in-house payroll reporting system integrated with a Mainframe, supported by an MS-Access database. Achievements included the migration of a legacy database from Sybase to an Informix database featuring a new data structure.

Additional responsibilities included maintaining and enhancing a Pension system developed in Delphi 6 and MS-Access, with tasks like developing new interfaces for payment systems and generating output files for pension contributions. Ensuring compliance with legal requirements, adjustments were made to the pension contribution calculation process to accommodate new business rules. System documentation was also updated and enhanced.

Development work on the Mainframe payroll system involved creating new data extraction processes to make necessary data available to other systems. Accounts payable and receivable systems were managed by correcting account balance values using SQL commands. Customization and maintenance of the password system were conducted using .NET and SQL Server. Moreover, new data extraction procedures and system reports were developed for better interfacing with other systems.

Systems Analyst
1/2/1999 - 1/1/2000

Demonstrated expertise in system analysis and data administration through a project focused on structural change in a marketing budget management system developed using Power Builder and Sybase database. Collaborated with Business Analysts to transform business requirements into system requirements, leading to the development of a web-based financial system with national-scale database integration. Responsibilities included creating comprehensive system documentation, writing functional requirements, data modeling, and the physical implementation of the database, which involved the creation of stored procedures, triggers, and business constraints. The role included designing and implementing backup procedures, developing training materials, writing program specifications, and creating test plans.

Provided technical support for system development, utilizing tools and frameworks such as UML, ASP, VB script, IIS, Sybase SQL Server, and Unix WAN. Achieved significant improvements in system performance by converting main procedure processing to run directly on the SQL server using stored procedures, creating indexes, and optimizing query performance. This optimization was essential for ensuring the system's processing could be completed within the limited processing window available on the server. Developed system documentation in compliance with company standards and used Remedy as a change management tool to manage the document flow for approval of orders and requests.

Systems Analyst
1/2/1998 - 1/1/1999

Participated in a team of systems analysts in the development of an integrated financial system, with a specific focus on the billing module using Visual Basic and SQL Server. Coordinated the integration of the new billing module with other modules of the financial system. Oversaw a team of programmers, contributing to the design of programs through the creation of prototypes and system specifications, and provided coding assistance.

Systems Analyst
1/2/1997 - 1/1/1998

Developed a comprehensive nomenclature manual for program development that standardized programming rules, enhancing reading, understanding, and maintenance of system processes. Utilized Remedy software to update and document system changes. Conducted frequent monitoring of processing logs through detailed reports. Employed procedural rules for the implementation of system changes in the production environment, ensuring documented approval and notification across all IT department levels concerning changes in physical locations, maintenance windows, backup procedures, and deployment processes. Developed and enhanced functionalities for a logistics system focused on the distribution of containers, optimizing the logic to achieve better cost-benefit ratios using Visual Basic and Sybase.

Managed the complete life cycle of an Information Security system development, primarily aimed at access management and database access auditing. The system comprised an OCX programming component to facilitate secure database access for other systems, a program for logging unauthorized access attempts, and a user permissions management program. This involved system analysis, data modeling, implementation, development of stored procedures and triggers, prototyping, testing, debugging, and comprehensive documentation. Additionally, contributed to the restructuring of a legacy database into a new RDBMS structure, creating a central data repository with superior optimization and integration capabilities for other corporate systems.

SQL Developer
1/2/1995 - 1/1/1997

Specialized in the maintenance and customization of securities trading systems for international financial institutions. Gained expertise in developing and debugging stored procedures and conducting extensive testing to ensure system reliability. Played a pivotal role in front-end and back-end programming for accounts payable and receivable systems as well as telemarketing systems, replacing outdated systems with current and optimized technologies.