Santiago Pieretti

Experience

• 

  Autónomo

  Jan 2014 - Oct 2015

  Computer Instructor for Seniors

  • Teach basic computer skills such as Word, Outlook, and web browsing.

• 

  HOPE FUNDS S.A. Compañía Argentina de Inversiones

  Jan 2016 - Jul 2016

  Sales Representative for Financial Products

  • Sale financial products such as investment funds, retirement insurance, or savings plans.• Discussing financial goals with clients, recommending products and services, providing information, and reporting to managers.

• 

  EY

  Jul 2017 - May 2023

  • Worked with multiple data sources from private entities and government agencies, integrating and analyzing data to support business decisions.• Extracted, cleaned, and visualized data using SQL, Power Query, Power BI (DAX and M) and Tableau,• Utilized APIs, SQL Server, and data files to retrieve, transform, and export information using Python .• Conducted data collection and analysis to identify areas for improvement and maintain projects on budget and on time.• Created client-specific dashboards and provided relevant suggestions.• Managed data in ServiceNow solutions for clients.• Facilitated finance and Power BI training for teams in the USA and India.• Generated financial reports for project stakeholders and presented finance updates on weekly calls.• Led a global team, handling hiring, interviewing, career planning, and counseling.• Ensured data governance and quality standards were established and followed for all projects.• Managed innovation ideas from the finance team, matching them with the right developer or tool. Show less • Assisted engagement teams with forecasting and budgeting for various initiatives.• Conducted data collection and analysis to identify areas for improvement and maintain projects on budget and on time.• Set metrics alerts to manage costs, expenses, and account receivables, ensuring billing in accordance with the agreed-upon budget and pricing structure with clients.• Created financial reports for project stakeholders to keep them informed.• Extracted, cleaned, and visualized data using SQL, Power Query, and Power BI (DAX and M).• Facilitated finance training for new hires in Argentina, US and India,• Worked on solutions for financial management with the IT department. Show less

  • Senior Finance Data Analyst

    Oct 2020 - May 2023

  • Semi Senior Finance Analyst

    Oct 2019 - Oct 2020

  • Junior Finance Analyst

    Jul 2017 - Oct 2019
• 

  Freelance

  Jan 2023 - Dec 2023

  Data Analyst

  • Work as a part-time freelancer for multiple US-based clients, specializing in data analytics and data engineering.• Collaborate closely with clients to understand their data requirements, objectives, and business needs.• Analyze client needs and provide recommendations for improving data infrastructure, processes, and performance.• Perform data analytics and data engineering tasks using Python, extracting, transforming, and loading data from various sources hosted on different platforms.• Develop data pipelines and workflows to streamline data processing, ensuring accuracy, integrity, and security throughout the analysis process.• Utilize Python libraries (such as pandas, NumPy, and scikit-learn) for data manipulation, analysis, and machine learning tasks.• Work with SQL databases for data querying, manipulation, and management.• Apply statistical analysis techniques and implement machine learning algorithms for predictive analytics and pattern recognition.• Design and create interactive dashboards using Tableau or Power BI to visualize and communicate data insights effectively.• Help clients set up their development environments, configuring Python environments, installing necessary libraries, and guiding best practices for version control and project organization. Show less

• 

  Mercado Libre

  May 2023 - Jan 2024

  Senior Audit Data Analyst

  • Leveraged Jupyter Notebooks to refine data analysis algorithms and employed AI models (Autoencoder, Isolation Forest) to identify suspicious accounting entries, thereby enhancing audit accuracy and efficiency.• Utilized SQL in BigQuery for querying and analyzing large-scale financial datasets.• Validated APIs related to finance SOX controls written in Python, JavaScript, and Go, ensuring compliance and robust security measures.• Worked with various Google Cloud Platform (GCP) services daily for data access, transformation, and workflow development.• Streamlined the audit process by migrating queries and scripts from SAP and BigQuery, thereby improving data accessibility and minimizing disruptions.• Implemented automation solutions with Google Workspace APIs to reduce manual efforts and eliminate repetitive email communications in cross-finance control checks.• Proficiently used advanced data visualization tools such as Tableau and Power BI (DAX and M) for clear communication of complex audit data to stakeholders.• Employed version control systems (Git) for efficient code management and collaboration. Show less

• 

  TEAM International

  Jan 2024 - Jun 2024

  Marketing Data Analyst

  • Six month contract focused on developing new solutions for the Marketing and Sales team and optimizing existing data pipelines.• Used Salesforce API to carefully analyze lead data, aiding informed decisions in marketing campaigns.• Built a data pipeline to collect X (Twitter) and LinkedIn data, leveraging Azure Data Factory for automation and Azure Data Lake Storage for scalable data handling.• Analyzed marketing campaign performance and budget allocation, utilizing Microsoft Fabric’s Dataflows and Power BI to monitor KPIs, maximize ROI, and align spending with business objectives.• Introduced Python web scraper for efficiently extracting company and job listing data from LinkedIn and other platforms. Automated data extraction processes using GitHub Actions.• Developed internal apps using Power Apps. Power Automate was integrated to automate notifications and synchronize data across systems.• Conducted thorough research on different LeadGen tools, offering recommendations based on their strengths, weaknesses, and pricing.• Improved AI driven lead classification projects, refining algorithms for better accuracy. Applied the Random Forest algorithm for improved predictive modeling.• Conducted extensive research to gather company insights from various sources including Crunchbase, ZoomInfo, and LinkedIn, enriching the database for targeted marketing efforts.• Managed the LeadGen team's GitHub repository, ensuring security measures and facilitating collaboration. Shifted local projects to GitHub for easier access and version control. Show less

• 

  Azumo

  Jun 2024 - now

  Data Engineer

  • Build and optimize data pipelines using Azure Data Factory, pulling data from APIs, SQL databases, and files.• Developed and maintained data pipelines in Knime, automating data transformations and integrations across multiple sources.• Build and optimize complex Power BI reports across multiple client service lines, ensuring accuracy, efficiency, and performance.• Developed a Power Apps based Timesheet used by 300+ users daily, along with a data analysis pipeline and multiple reports for tracking and insights.• Optimized data pipeline refresh times by up to 90%, significantly improving load times and report performance.• Manage data governance and access as a Power BI and SharePoint Admin, creating and maintaining groups with different permission levels.• Utilize Python to test APIs, validate data pipelines, and troubleshoot errors to ensure data accuracy and reliability.• Work in an Agile Scrum team, using Jira for project tracking and collaboration. Show less