Jairo Perez Email & Phone Number

Peru

Peru

Implemented real-time analytics.Migrated to a new GCP account.Made Postgres talk to GPT, which enabled us to parse highly unstructured data.

Raleigh, North Carolina, Us

Los Angeles, California, Us

Reporting database owner.Designed and implemented ETL processes to consume data from different sources (API, Service Bus / PubSub, Email, etc.), using batch and real-time techniques.Created tables and views to standardize and centralize the data ingested. Built Looker dashboards on top of them.Implemented services to send reports to our internal and external customers.Coordinated database migration from MS SQL Server to PostgreSQL.

Fort Lee, Nj, Us

Area: Enterprise Data Management - Data Services (Vertical: Digital Marketing)Developed the SMS and Email Processors, systems that improved the communication we had with our leads by automating the lead lists based on dynamic criteria for each campaign, reducing manual work.Implemented and automated ETLs, reports and data pulls.Data pipelines migration from in-house system to AirFlow.

Seoul, Kr

Area: Trade Marketing (Product: Mobile Communications. Others: Home Appliances-TV-Audio)Continuous database maintenance and optimization for the collection of sell-out information. Create and analyze sell-out, stock, weeks of sales and forecast reports (formal and ad-hoc).Responsible of sell-out management weekly meeting to review sales result and forecast, market share and support the decisions making to improve the sales. Constant communication with sales team, product team, directors and CEO to discuss requirements and solve specific business questions.

Bogotá, Co

Area: Debt Collection StrategyDatabase analyze and design. Data integration responsible of 12 debt collection call-centers. First person that propose to use SSIS in the company to reduce times and manual work. Custom dashboard design for each user type. Data patterns analysis and participation in collection strategy proposals (+600K debts, +S/2 billion). Attend manager’s requirements.

Madrid, Madrid, Es

Area: Traffic ControlResponsible for collecting, analyzing and using data to create reports that support decision making. Consolidate data of several sources like .csv, .xls and .txt files before inserting it to the database. Redesign of old reports based on excel files to use the database as a new data source. Elaborate report of commissions and bonuses. Analyze call patterns and propose strategy in real time.