Ernesto Y. Rodriguez-Lopez

Data Warehouse Specialist at PharmPix Corporation
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Lakeland, Florida, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Wellness and Fitness Services
    • 1 - 100 Employee
    • Data Warehouse Specialist
      • Nov 2018 - Sep 2022

      United States Pharmpix is a Pharmacy Benefit Manager.

    • Puerto Rico
    • Insurance
    • 700 & Above Employee
    • System Analyst
      • May 2012 - Mar 2018

      MMM is a Medicare Advantage Plan. Responsible for partnering with business analysts to focus on business process improvement, re-engineering, and hands-on configuration activities Work with architecture and operations departments to ensure applications and batch processes comply with company standards and operating at a high level of availability. Work with the business team (Health Services Department) to provide effective data integration and reporting solutions and… Show more MMM is a Medicare Advantage Plan. Responsible for partnering with business analysts to focus on business process improvement, re-engineering, and hands-on configuration activities Work with architecture and operations departments to ensure applications and batch processes comply with company standards and operating at a high level of availability. Work with the business team (Health Services Department) to provide effective data integration and reporting solutions and identify and solve production environment problems. Analyze current business processes, suggests improvements, and participates in the design, testing (Unit Test), and implementation of new systems in a complex production environment Lead team of developers and conduct code reviews to ensure technical specifications are accurately translated into production code Document specifications for proper data transformation/validation, events handling, process scheduling, data mappings, data/process flow modeling, and reconciliation control. Show less

    • IT Consultant
      • May 2008 - May 2012

      Integrate manufacturing devices (PLC/SCADA) in the pharmaceutical industry with OSISoft Plant Information (PI) System, which is a Data Historian System to make automation (Continuous Measurements, alarms, and events) process information available to engineers, planners, and operators Experience extracting data from Allen-Bradley PLC devices using OPC protocol. PLC programming.

    • Puerto Rico
    • Banking
    • 100 - 200 Employee
    • Programmer / Analyst
      • May 2002 - Mar 2008

      Responsible for administering the Computer Telephony Integration (CTI) platform (Genesis) to keep call center operations (24/7) with minimum interruptions Coordinate project management activities with service providers Performs liaisons functions between the Bank’s business units (Telephone Banking, Mortgage) and IT department Administer the mortgage loan origination application MortgageWare Maintain stored procedures in Oracle PL/SQL that implements the logic for… Show more Responsible for administering the Computer Telephony Integration (CTI) platform (Genesis) to keep call center operations (24/7) with minimum interruptions Coordinate project management activities with service providers Performs liaisons functions between the Bank’s business units (Telephone Banking, Mortgage) and IT department Administer the mortgage loan origination application MortgageWare Maintain stored procedures in Oracle PL/SQL that implements the logic for the data synchronization between ALTAIR (bank’s core system) and the Counselor CRM platform Administer the Voice Response Unit (VRU) Avaya over the Unix platform. Show less

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • System Consultant
      • May 2000 - Apr 2002

      Provide consulting services to customers in government and financial sectors: services included requirements gathering for new projects, re-engineering, and software architecture development to integrate enterprise systems.

    • Software Development
    • 100 - 200 Employee
    • Software Developer
      • Apr 1998 - Apr 2000

      Develop Automated Data Collection Systems for manufacturing environments Integrate ERP host (SAP/R3), RDBMS (SQL Server 6.5 and 7.0), Abaco Middleware (The Bridge for R/3), and Radio Frequency devices (Intermec and Norand) to provide a turn-key solution to automate the manufacturing process Create Client/Server and Sockets (TCP/IP) applications using Delphi (Object Pascal). Successfully developed and implemented (on time) the following projects: Coca-Cola Pennsylvania USA… Show more Develop Automated Data Collection Systems for manufacturing environments Integrate ERP host (SAP/R3), RDBMS (SQL Server 6.5 and 7.0), Abaco Middleware (The Bridge for R/3), and Radio Frequency devices (Intermec and Norand) to provide a turn-key solution to automate the manufacturing process Create Client/Server and Sockets (TCP/IP) applications using Delphi (Object Pascal). Successfully developed and implemented (on time) the following projects: Coca-Cola Pennsylvania USA (Shipping and Receiving), Coca-Cola Femsa Argentina (Scrap Notifications and Quality Inspection), GE FANUC Virginia USA (Inventory, Cycle Count, and Bar Code Label Creation). Show less

Education

  • EDP College of Puerto Rico Inc-San Juan
    Bachelor's degree, Computer Programming
    1994 - 1997
  • EDP College of Puerto Rico Inc-San Juan
    Bachelor's degree, Business Administration
    1994 - 1997

Community

You need to have a working account to view this content. Click here to join now