Curt Utz Email & Phone Number

United States

Newtown, Pennsylvania, United States

• Responsible for developing data requirements for new and existing customers in the United States and Europe. Customers include various size pharmaceutical companies and their vendors.
• Manage the data needs for over 20 different external customers, as well as multiple internal customers, such as Analytics and Reporting, Compliance, Incentive Compensation, and virtual sales teams.
• Requirements are created and maintained using Confluence and linked to JIRA requests assigned to offshore resources who then develop these requirements using 2-week Agile Sprint cycles.
• Work with external vendors such as IQVIA and Symphony to obtain Exponent Data to be used for Data Analytics
• Design database tables which are stored in an Azure Data Lake. Tables are loaded using a Bulk Copy Procedure (BCP) or linking tables to external files.
• Created a series of SQL Queries against Veeva tables and views which are used to train new developers and analysts on the working ways with the company.

Philadelphia, Pennsylvania, United States

• Responsible for managing offshore resources for the development of applications and overall operations of several Master Data Management (MDM) systems. These systems include customer and account data warehouses.
• Meet with business owners to gather requirements, document user stories, develop programming specifications, design database tables and views, and backlog prioritization.
• Mange new functionalities and enhancements to the MDM systems using Agile Sprints. Track 4-week sprint cycles using JIRA. Track Configuration, Change and Incident Management for the MDM systems using ServiceNow.
• As part of overall operations, used Value, Flow and Quality (VFQ) methodologies to drive continuous improvement to the MDM systems. Significant improvements achieved by reducing the number of tables and views needed by.
• Led team in migration of MDM databases from Oracle 12 to Oracle 19 and moved data from legacy systems to cloud based solutions.

Greater Philadelphia Area

Two-year project: Roll out of Windows 10 migration of software/data for Sales Reps and in-house staff currently in the implementation stage. Manage testing efforts and planning for the migration of all applications used by US Pharmaceutical business owners from Windows 7 to Windows 10. Responsibilities for this project include working with application.

Greater Philadelphia Area

Review systems documentation to ensure that documents are up-to-date and meet required company standards. Documents include system access plans, system design details, compliance requirements, and risk assessments.Supported various sales and marketing applications used by field Sales Reps in their territories. Responsibilities included development and.

Nairobi, Kenya

Six-month on-site project. One of 100 people selected world-wide to work with Non-Government Organizations (NGO's) who partner with GSK in developing countries. Assignment was with the African Medical Research Foundation (AMREF) where IT knowledge and expertise were shared with the staff at AMREF, to include creating business and technical documentation.

Salem, New Jersey

Responsible for the development, maintenance and support of sales and marketing applications for sales representatives and external distribution customers. Project Leader responsible for migrating multiple applications from IBM ES9000 platform to IBM AS400 platform. Trained Sales Reps and external distribution customers throughout the country on the use of.