Michael Lee Email & Phone Number

Trenton, New Jersey, United States

Trenton, New Jersey, United States

Trenton, Nj (Database And Marketing Intelligence Dept.)

Create, update and maintain PL/SQL procedures to accommodate client needs.Create or update complex SQL Queries for pulling client dataTroubleshoot and alter HTML for client email sendsCreate proofs and push out live emails to client mailing lists via Sales Force Marketing Cloud

Trenton, Nj (Database And Marketing Intelligence Dept.)

Trenton, Nj (Database And Marketing Intelligence Dept.)

Manage and maintain Fortune 500 and other pharmaceutical client databases to ensure all consumers and/or HCPs are correctly selected for Direct Mailings, Email Campaigns and Text messaging fulfillments.Take project management and technical lead on large six-figure projects. Ensure requirements meet ISO 9001:2008 and other pharmaceutical regulatory standards, deadlines are met and client needs are satisfied within expected timeframes.Identify any potential vulnerabilities and offer process improvements to ensure the database, all associated websites and fulfillment mechanisms are running as efficiently as possible.Write complex SQL queries for custom ad hoc reporting requests and analyze the exported data sets to meet client needs.Monitor all daily internal and external processes used to import and export data within the database from various loads.Ensure all inbound and outbound data is flowing correctly and hitting the appropriate internal landing tables or external destinations with no errors during the multiple daily data transactions.Correctly identify any errors within the database and troubleshoot them in a timely fashion to have them rectified as quickly as possible to not interrupt any outside fulfillment.

Trenton, Nj (Database & Marketing Intelligence Dept.)

Work on a large-scale Amylin pharmaceutical consumer database migration to ensure all processes are correctly implemented and data integrity is maintained with minimal impact to the consumer.Work with Auxilium and Amylin pharmaceutical companies to test new database procedures and ensure all vulnerabilities are identified and corrected prior to production deployments.Develop custom SQL queries to pull specific consumer records for various promotion mailings and custom reporting analysis for both Consumer and HCPs.Manage client-based HCP & consumer websites and offer process improvements and risk integrated analysis.

Trenton, Nj (Client Services Dept.)

Work directly with client vendors Epsilon and McKesson to provide timely and accurate consumer and HCP fulfillment for large pharmaceutical clients Amgen, Pfizer Sanofi Pasteur and Sandoz.Create custom reporting and analyze data analytics to track consumer participation and offer process improvement and enrollment techniques.Work with clients to setup, alter, improve and maintain data driven fulfillment programs.Manage, maintain and offer process improvements to call center scripts from an IT perspective for large OBC programs pharmaceutical clients use to check up on consumers recently enrolling on new drugs.

Newtown, Pa

Research key logistic indicators within the operations of the company and forecast current trends based on detailed analysis’. Work with multiple contacts world-wide to oversee and approve all incoming shipments; review and approve all incoming shipment and freight charges. Propose budget and forecast changes and give current in-depth analysis’ of where we stand currently, quarterly, and YTD. Work with material costs and customer pricing analysis for implementing promotions and price reductions. Analyze, interpret, and help oversee the Operations of the Company.

Absecon And Woodrow Wilson Travel Plazas

Worked extensively with PeopleSoft HRMS to maintain and approve weekly payrollUsed BlueCube and SAP to identify and examine variances in inventory countsUtilized PeopleSoft Financials to examine, correct and balance general ledger accountsCompleted weekly and monthly P&L reports, calculate weekly costs for pricing analysisManaged employee benefits and confidential information via PeopleSoft HR

Burlington Generating Plant

Worked extensively with SAP and Microsoft Excel to control material movement.Managed plant inventory, priced and ordered crucial and custom parts for internal jobs.Traveled to PSE&G locations throughout NJ to meet with management and deliver materials.Participated in company safety trainings and distributed related equipment to employees.

Burlington Generating Plant

Used SAP to organize and sort work orders to manage partial and completed work orders.Helped plan part purchasing and planning for upcoming jobs and outages.Worked extensively with Microsoft Excel to create formulaic worksheets to organize data.Designed an employee manual and multi-media presentation for a new company engraver.Created specialty tags for machinery and safety-related items located within the plant.

Bachelors Of Arts, Criminal Justice

Graduated Cum Laude Awarded Dean’s List recognition every semester

Associates Of Arts, Criminal Justice