Mike Verdugo Email and Phone Number

Technologies: Oracle Data Modeler, Erwin, MySQL, Oracle, SQLServerWorked as a Senior Consultant within the Master Data Management (MDM) practice. The MDMpractice maintained a proprietary data product called Databurst which was focused on providing customers in the pharmaceutical commercial domain with a platform for managing voluminous data from heterogeneous data sources. The practice also maintained MySQL databases in the AWS cloud for several clients. The MySQL databases act as interfaces to the Reltio MDM product. My primary responsibilities were to maintain the data models and database objects that support the Databurst product and the Reltio database interfaces as well as assist the ETL developers with any sql issues and general database maintenance requests (ddl and dml).

Project: Design and build data interfaces in SqlServer between a Oracle Fusion Hub and SAP ERP and Salesforce.ComTechnologies: SqlServer 2008r2, CDC (Change, Data, Capture), SSISWorked as a sql developer on a major project for our client, DealerTrack, to design and build data interfaces between their Oracle Fusion hub and SAP ERP (Enterprise Resource Planning) and Salesforce.Com. The data interfaces were built in a SqlServer 2008r2 spoke database. Source data originated in the Fusion hub and was replicated to the SqlServer spoke database. The SqlServer database utilized replication (publish/subscribe) for synchronization to the Fusion hub and the SqlServer CDC agent to identify data modifications. Within the spoke database, I built stored procedures to communicate with the SqlServer CDC agent to identify new and updated data which was subsequently inserted into interface tables. The external systems, SAP and Salesforce.Com, pulled data from the interface tables into their environment. Once data was processed in the external systems, they transmited a response, which included external system identifiers, back to the spoke database. The SAP and Salesforce.Com identifiers were then replicated back to the Fusion hub, thus completing the round trip from source to external systems via the spoke database. Exception reporting was accomplished from SSIS packages and Splunk, Dealertrack’s standard log and error reporting system. The SSIS packages extracted data from the interface log tables into flat files which were then imported into the Splunk system.

Employed at Ness Technologies as a Technical Consultant (PM, Data Modeler, SQL Developer) on a number of consulting projects which are listed below.

Project: Financial Application for a major bank in Brussels, BelgiumTechnologies: Oracle 11g , SQL, PLSQL, MySQL, EnterpriseArchitect, Liquibase DB Version Control, Talend ETL, Jaspersoft iReportWorked as a data modeler and sql db developer on the proprietary Ness financial product, Financial Data Enterprise (FDE). FDE is a web application that captures financial market data from various data providers such as Bloomberg, Reuters and Telekurs, for example. The collected data is normalized and corrected into a common copy, sometimes referred to as a ‘golden copy’, which can then be distributed to subscribing clients. The architecture for FDE is based on open source technologies (java, apache web server and MySQL), but is designed to be portable to any database platform. For KBC, the underlying database was Oracle 11g. My responsibilities initially involved interviewing the Middle Office Data (MOD) clients at KBC Bank to understand their business, gather requirements and model a time series enhancement to FDE that would meet their objectives. Additionally, I was actively involved in analyzing, designing and developing the underlying database schemas for supporting the various FDE modules. Used Enterprise Architect to develop the conceptual, logical and physical database models. Utilized Liquibase to manage database versions and facilitate migrations from MySQL to Oracle. Talend ETL was used in the initial stages of the project. Created reports using Jaspersoft iReport. FDE was developed using the Agile methodology.

Listed below are additional client projects undertaken while employed at Ness Technologies. Depending on the client specific needs, my project roles varied between technical lead, data modeler and sql developer.HR Data Warehouse and Business Intelligence Environment (SqlServer 2000, Microsoft DTS, Cognos) - Worked as the technical lead for a data warehouse and business intelligence project for the Society for Human Resource Management, a major association in Alexandria, Virginia.Departmental Information Warehouse Project (Oracle8i, InterMedia, Java Stored Procedures, Cognos, ERWin, Sun SPARC Solaris, Unix Korn scripts) - Worked as an Oracle SQL Developer on a project to build a drug information warehouse system for Pfizer Pharmaceuticals for tracking drug products through the product development cycle. Enterprise Data Warehouse Project (Oracle8i, Sagent Technologies) - Worked as an Oracle SQL Developer on a project to build an enterprise data warehouse for Pairgain Corporation, a West Coast electronics manufacturer of network communication equipment.

Worked as a technical lead and senior analyst on the following projects for American Cyanamid Company.Sales Force Automation for 300+ sales representatives (Oracle, SQL, PL/SQL, MS Access, Project Management, ERWin, Delphi) - Responsible for designs and processes for distributing data to sales representatives. Analyzed, designed, and developed the primary Sales Force Automation Oracle database to manage Grower Customer Profile and Agricultural Dealer Sales information. Designed system architecture for managing and deploying distributed databases to sales representatives. Developed Delphi processes to manage the synchronization and importation of multi-sourced data into the Oracle database.Preprocessed Incentive Orders System (Oracle WebServer, MS Access) - Analyzed, designed and developed an Oracle WebServer application for regional coordinators to enter, consolidate and report pre-season orders. In addition to entering orders, the Web application gave the regional coordinators the ability to monitor and update orders transmitted from their field sales representatives.Customer Service Complaint System (Oracle, MS Access, ERWin) - Project leader for team of three developers with responsibility for budget, project coordination, client liaison as well as analysis, design and development. Performed requirements analysis with Marketing clients and wrote functional design documents for creating the Customer Service Complaint System whichcaptured product performance complaints from individual growers and dealers.

Worked as a senior analyst on the following projects at Chevron Corporation.Voyage Management System (Client-Server, Oracle Forms, SQL*ReportWriter, OS/2) - Analyzed, designed and developed Oracle Forms and SQL*ReportWriter applications for the Voyage Management System (VMS) serving Chevron Shipping Company’s international and domestic shipping operations. The Voyage Management System was a client / server application installed on 40 Chevron owned oil tankers as well as the primary LAN at the San Francisco headquarters. The ship-board LAN consisted of an Oracle database on an OS/2 server with 5 DOS PC clients. Developed the Cargo Management and Voyage Planning modules as well as reporting functions for VMS.VMS Remote Maintenance System (Oracle, C, Korn Shell, RS/6000, AIX) - Analyzed, designed and managed team development effort for the Remote Maintenance System used tosupport the Oracle based Voyage Management System (VMS), a distributed database system installed on 40 Chevron owned oil tankers. Developed the system using Korn shell scripts, C, Oracle Pro*C, and sql scripts. Developed server side data extract programs in Oracle Pro*C and C to process against the main Oracle database residing on an RS/6000 server running the AIX operating system. Received a special recognition and achievement awardfrom Chevron Shipping Company for the system development effort.Mainframe systems Lubricating Oil Dealer Incentive System (Mainframe, Nomad, IMS, DB2, PL/1) - Worked with several teams that analyzed, designed and developed the following mainframe applications: Lubricating Oil Dealer Incentive system, Lubricating Oil Inventory System, Bulk Products Reporting, Sales Reporting. These applications were developed using Nomad, IMS, DB2 and PL/1.