Data Analyst Engineer

Professional Summary

Analytical Mindset Focused on Business Processes and Data Analysis: Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

Solid Technical Background: Hands on. Experienced Data Engineer in GCP solutions, BigQuery, SQL, Python, Airflow, Data Pipeline, Excel Data Analyst, Excel pivot tables, formulas, charts, Application Lifecycle Management, projects in banking/financial/retail industries.

Leadership: Experienced leadership for engineering teams. Motivating, inspiring, guiding and always looking for efficiency. Focused on collaboration among different teams. Built roadmaps with both business and technical people. Listen to teams to understand their hardships to minimize or remove team roadblocks.

Project/Process Management: Full understanding of Software Development Life Cycle (SDLC/Iterative) and Agile (Lean/Scrum) methodologies in banking and financial industry. Experience leading and delivering a portfolio of projects concurrently. Experienced building strategies and multi-year product delivery roadmaps that align to business objectives.

Professional Experience

Macys Tech Jun 2022 - Present

Data Engineer

Developing, design and maintain robust data pipelines that extract data from various sources, transforming it into the desired format, loading it into the data storage systems.

Ensured data consistency and integrity during integration, performing data validation and cleaning as needed.

Communicate across the organization to ensure data infrastructure meets business needs and supports informed decision-making at all levels.

Collaborate with data scientists and analysts to optimize models and algorithms for data quality, security, and governance.

Fiserv Oct 2021 – Jun 2022

Data Analyst

Preparing Customer Financial transaction reports for Business areas

Generating Lead Lists for certain products to enable cross-sales on various businesses

Creating Monthly and Quarterly Business Results presentations to be used by Executive level

Refactored MBR report by enhancing SQL Queries and Tableau visualization reducing the run time from 3 days to 1 day.

Working on generic client agnostic solution for Lead Generation in JavaScript

Homestead Hospice Sep 2019 – Oct 2021

Business Systems Analyst

Participation on all phases of a project lifecycle, since its inception: gathering requirements, design, implementation, tests, UAT, promotion to upper environments and post-production

Working with third parties as primary interface ensuring business requirements are fulfilled and technical implementation is standardized.

Communication with both technical and business teams to complete projects on time, identifying timelines, helping them to resolve any issues.

Proposed solutions by identifying and understanding business needs.

Conducted application demo for business team and prepared training material.

Communicated progress and major action items.

Medication Entry Uplift: Integration between EMR system with PBM system. Acting as a crucial point between two third parties, helping them remove any road blockers, ensuring business requirements are met and technical implementations were of high quality.

Data Analyst

Collected, cleansed, and interpreted data in order to transform raw data into managerial and strategic information.

Modeling and designing pattern historical data in KPIs and insights to process improvements.

Analyses of structured and semi-structured data to identify key metrics, GAPs producing meaningful, actionable information

Extract unstructured data, transforming into actionable metrics reports.

Used advanced Microsoft Excel to create post processing, comparison between data, and pivot tables.

Presented visually impactful dashboards in Excel and Power BI for data reporting.

Employee Mileage Reimbursement: Responsible for calculating total mileage for clinicians based on post processing rules from different Health Care system events. Then those totals are credited to employees through the Payroll System. This project generated 10% in savings for the company.

N3 Results Feb 2019 – Aug 2019

Business Development Representative

Client: Microsoft (May 2019 – Present)

Compliance and Licensing Consultant

Licensing GAPs Analysis from Microsoft`s clients

Alignments Licensing Gaps according to Microsoft Standards

Conflict resolution and client relationship management

Client: Automation Anywhere (Feb 2019 – Apr 2019)

Synthesized complicated information about process automation and showed how AA offerings are aligned with our customers' business initiatives.

Ability to identify and qualify the key aspects of a potential lead, including budget, decision-maker, needs, and timeline.

AA Certified Advanced RPA Professional.

Rede (acquirer) Nov 2015 - May 2017

Engineering Team Lead

Led an engineering team of fourteen people, removing team roadblocks, prioritizing activities and deliverables. Providing feedback and guiding people in their careers.

Managed projects in both technical and business side, making sure the deliverables are satisfying customers’ expectations through proper communication channels to stakeholders.

IT Staff hiring, Vendors rates-contracts negotiation and day-to-day activities support.

Supported negotiations and communications to both Product and Business areas.

Working in agile team for Salesforce implementation management. Implemented projects for Logistic, Sales, Risk Management and Fraud Areas.

Salesforce implementation in Logistics, Sales, and Customer Service: Accuracy and efficiency in delivery devices to clients. Client prospection/contracting and client management information. Overcame challenges to be the first project implemented through cloud services, solving different internet and security issues.

Itaú-Unibanco Bank Jan 2008 - Nov 2015

Software Engineer / Business Analyst COBOL

Requirement gathering, support, negotiation, and communication to both Product and Business Financial areas.

Deep understanding in designing, development and implementing large scale enterprise applications.

Built functional and technical specifications based on company’s framework.

Developed COBOL technical solutions, transactions maps, programs, batch transactions and workflows.

Tests support on QA and UAT implementations

Outsourcing and Vendor management in day-to-day activities support for scale and efficiency.

24x7 Production support for canceled and abended routines

Developed and implemented solutions to migrate client databases/systems for M&A purposes.

Credit to investor: New product to Loan money with guaranty. Acting as a Project Manager and Team Lead this project was implemented in 6 months and offering this product the bank was able to decrease risks and frauds.

System Core Simplification: Migration of Systems for adherence to a New Institutional Architecture. Gathering requirements in reverse engineering, negotiating with technical and product areas. Built new system documentation align to architecture and improved systems performance/availability.

Sinergy between business client and individual client: New credit score to differ BC and IC. Project used Agile methodology, managing expectations from clients and changing their waterfall mindset to iterations and constant feedback/deliverables.

Sunrising Consulting Jan 2007 – Jan 2008

Programmer Trainee Peoplesoft

Clients: AmBev and Novartis

Peoplesoft Functional Support: Oriented and user solution

Peoplesoft Technical Support: Solution level 1, maintenance, Queries and reports build

Volunteering Experience

IT Business Analyst Sep 2018 – Aug 2019

Homestead Hospice

Dashboards: Created visually dashboards in Excel for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information. Synthesized data from several data sources to produce consolidated views. Created business and technical requirement documents.

Education

MBA Project Management, FGV – Sao Paulo/BR

Bachelor’s degree in information technology, Fatec – Sao Paulo/BR

Business Intelligence, Emory University

Leadership Essentials, McKinsey & Company

Language skills:

English: Advanced

Portuguese (native speaker)

SKILLS

BigQuery

Airflow

Python

Excel

SQL

Data Mining

Business Intelligence (BI)

Data Structures

Regression Analysis

Data Visualization

Data Technologies

Tableau

Power BI

Smartsheet

COBOL II

DB2

Easytrieve

IMS

VSAM

ISPF/TSO

Control-M

Team Lead

Project Management

Requirement Gathering

AA Certified Advanced RPA Professional

Contact this candidate