Ernesto Y. Rodriguez-Lopez
Data Warehouse Specialist at PharmPix Corporation- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
PharmPix Corp
-
United States
-
Wellness and Fitness Services
-
1 - 100 Employee
-
Data Warehouse Specialist
-
Nov 2018 - Sep 2022
United States Pharmpix is a Pharmacy Benefit Manager.
-
-
-
MMM Holdings LLC
-
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.
-
-
-
FBPR
-
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
-
-
-
Unisys
-
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.
-
-
-
Abaco
-
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 -
EDP College of Puerto Rico Inc-San Juan
Bachelor's degree, Business Administration