Andres Lambrano Rivera

Andres Lambrano Rivera

About

Detail

Data Integrity Specialist
Colombia
Contact Andres regarding: 
work
Full-time jobs
Starting at USD4k/month
Flexible work
Starting at USD25/hour

Timeline

work
Job
school
Education
folder
Project

Résumé

Jobs verified_user 0% verified
  • Finalsite
    Data Integrity Specialist
    Finalsite
    Jan 2023 - Current (3 years 8 months)
    • Use SQL and Python to perform advanced data analysis and create custom reports and dashboards. • Develop and maintain ETL pipelines using SQL and Python to integrate data from external systems into Salesforce. • Use SQL queries to analyze data trends and identify potential integrity issues. • Write Python scripts to automate repetitive data tasks, such as imports, updates, and exports. • Create and maintain dashboards and reports in Looker and Salesforce to provide data insights and monitor data quality metrics. • Provide data-driven recommendations to improve business processes and decision-making. • Provide root cause analysis for data integrity issues and recommend preventive measures. • Conduct regular audits of Salesfor
  • Finalsite
    Renewal Operations Analyst
    Finalsite
    Sep 2022 - Jan 2023 (5 months)
    • Analyze and import data from third-party providers or acquisitions to ensure its accuracy and integration within Salesforce. • Create reports and dashboards in Salesforce to help the teams visualize data and improve data-driven decisions. • Import, export, and update Accounts, Opportunities, and Products to improve data quality. • Ensure compliance with data protection regulations (e.g., GDPR) within Salesforce. • Ensure the accuracy of sales data in Salesforce. • Solve cases related to changes or problems within Salesforce. • Help different teams with miscellaneous tasks related to Salesforce issues or requests. • Leveraged my understanding of SaaS (Software as a Service) while supporting the Renewals Team, enabling the cre
  • Anthology Inc
    Renewal Operations Analyst
    Anthology Inc
    May 2021 - Sep 2022 (1 year 5 months)
    • Managed renewal notices and associated analysis, ensuring timely communication with clients. • Ensured the accuracy of renewal sales data in the enterprise CRM tool, maintaining up-to-date client information. • Analyzed multiple data sets in Excel to identify and correct discrepancies, enhancing data integrity for the Renewal Sales team. • Reviewed different types of customer contracts to ensure compliance and accuracy. • Enforced proper use of the Salesforce CRM and Oracle CPQ tools, providing training and support to team members. • Acted as a subject matter expert and "go-to" person to help support the Renewal Sales team in achieving their goals. • Developed and executed creative strategies to assist the Renewal Sales team i
  • Teleperformance
    Business Development Analyst
    Teleperformance
    Aug 2018 - Dec 2020 (2 years 5 months)
    • Analyze and gather business requirements, identifying needs for change or improvement in business processes and/or applications. This aligns with defined standards and methodologies to guarantee the implementation of functional changes with accompanying documentation. • Contribute to the generation of regular Wins/Pipeline follow-up reports, detailing their evolution by territory/country (Nearshore, Pan-American, Domestic) including Colombia, Peru, Guyana, and Nicaragua. • Develop funnel reports providing Prospect and Client perspectives. • Create Follow-up Reports tracking defined targets by country and sector. • Analyze, organize, and review business processes to contribute to the design of functional models for applications sup
  • Thomas Processing & Systems
    Administrative Assistant
    Thomas Processing & Systems
    Dec 2017 - Apr 2018 (5 months)
    • Requested and managed data/documents, analyzing, verifying, and recording information accurately. • Loaded accountable information, validating third-party information consistency and cost centers to ensure data integrity. • Recorded miscellaneous expenses, legalizations, bonuses, travel expenses, and bank reconciliations, maintaining meticulous financial records. • Utilized the SAP application for efficient data management and reporting. Additionally, I oversaw revenue operations by managing the expenses incurred by the sales department, ensuring budget adherence and optimizing resource allocation to maximize efficiency.
  • R
    Billing Assistant
    RECUBRIMIENTOS INDUSTRIALES
    Aug 2016 - Nov 2017 (1 year 4 months)
    • Fill of entries, purchases, inventory management, cash receipts, payments and reconciliations. • Use of SAI program. • Support for everything related to payroll, social benefits, permits, and all tasks within the area.
  • Banco de Bogotá
    Operative Assistant and Commercial Support
    Banco de Bogotá
    Mar 2012 - Feb 2015 (3 years)
    • Customer support, archive and documents management, solution to customer's requirements, plus basic Office accounting. • Management of warranties like Promissory Notes, Security and Purchase Promises. • Help with fill out of forms for credits, savings and checking accounts, among other services.
Education verified_user 0% verified
  • Politécnico Grancolombiano
    Systems Engineer
    Politécnico Grancolombiano
    Aug 2022 - Mar 2025 (2 years 8 months)
  • S
    Technologist in Systems Analysis and Development -Software Development
    Servicio Nacional de Aprendizaje
    Sep 2018 - Dec 2020 (2 years 4 months)
  • Universidad del Atlántico
    Business Administration (B.B.A.)
    Universidad del Atlántico
    Aug 2010 - Feb 2017 (6 years 7 months)
Projects (professional or personal) verified_user 0% verified
  • Finalsite
    Client Communication Services Expense Analysis (K12)
    Finalsite
    Dec 2024 - Current (1 year 9 months)
    - Contributed to a data analysis project within Databricks, using SQL, Python, and PySpark to thoroughly analyze communication service consumption patterns in K12 schools and districts. - Designed and executed complex queries to accurately calculate client expenses, identifying overpayments and underpayments based on monthly usage data. - Uncovered critical discrepancies, including services used but not billed for years due to post-acquisition data integration issues—enabling revenue recovery opportunities. - Delivered actionable insights that helped optimize revenue, refine service offerings, and enhance financial efficiency, while improving client satisfaction. - Collaborated with Salesforce and NetSuite teams to resolve data inconsistenc