JEAN BERTIN LOUIS
***********@*****.***
West Orange, New Jersey 07052
SUMMARY
Subject matter expert in maintaining accurate Customer Master data for Healthcare Providers (HCPs) and Healthcare Organizations (HCOs) for over 7 years. Demonstrate high level of productivity for the client and delivered quality results in all tasks. Understand client's needs and respond them in prompt and professional manner. That includes but is not limited to productive email communication and completed daily reports for representatives on time. In addition, work with integrity and efficiency to ensure all client needs are met.
TECHNICAL SKILLS
MS Visual Basic Net
SQL Server Database
Oracles
VB and VB Script
MS Access
PeopleSoft
C, C+
HTML Editors
TCP/IP
Java
XML
DNS
Java Script
WiFi
FTP
FrontPage
SNMP
Telnet
Toad
IBM Certification for Laptop, Desktop & Warranty
PROFESSIONAL EXPERIENCE
QuintilesIMS Plymouth Meeting, Pennsylvania Dec 2014 – April 2017
Client Consultant/Data Analyst
Served as a support liaison between multiple external clients and the Sales Inquiry Resolution, Data Stewardship, and Data Management groups for technical issues and provided recommendations for process improvement
Managed the data integrity of multiple clients’ Master Data Management (MDM) using internal Data Stewardship Customer Relationship Management systems that assisted with project deliverable rollouts.
Expedited updates to current and new prescriber information by auditing and approving Health Care Professional (HCP) requests by utilizing WebMethods OneData, Mobile Intelligence (MI), and Nucleus software applications.
Lead client status meetings and deliver insightful dashboard metrics and presentations.
Streamlined process flow modules by creating Standard Operating Procedures (SOPs) and editing documentation.
Enhanced resolution methodologies by identifying an issue’s root cause by analyzing inquiries/requests within client’s Sales Inquiry Tool or Mobile Intelligence.
Performed quality assurance and meet service level agreements (SLAs) for on-time and accurate deliverables consistent with project requirements.
Johnson & Johnson Raritan, New Jersey
Compliance & Audit Specialist April 2014 – Nov 2014
Developed, verified and published weekly and monthly reports that monitored Xarelto and Invokana market performance
Analyzed data patterns and trends for Xarelto and Invokana by using excel pivot table, vlookup and other key excel functions/formulas
Provided ad-hoc analysis as required to support internal customers.
Attained knowledge of pharmaceutical secondary data source (IMS Xponent, IMS NPA and IMS Plantrak)
Analyzed Xarelto and Invokana movement in the market against its Competitor.
Utilized Gpharma and Dig application for impromptu reports and internal communications.
IMS Health Parsippany, New Jersey September 2012 – June 2013
Data Management Analyst, GO
Ensured the quality of all facility based data elements entering one of the largest healthcare industry databases in the U.S. utilizing mainframe operating systems; TSO, BETA92/IOF and proprietary OLEP application on PowerBuilder/server based platform, generating >$500 million per quarter.
JEAN BERTIN LOUIS 862-***-**** Page 2
Ensured 98% quality by performing healthcare facility primary and secondary research for determining proprietary class of trade designations recognized across the pharmaceutical industry, making >= 250 adjustments per month..
Increased company revenue by >$200,000 annually by analyzing and integrating pharmaceutical /health care industry numbers across industry files and internal proprietary facility indicators.
Utilized Microsoft office software such as Excel, Word, Access and PowerPoint for impromptu reports and internal communications.
Verified and adjusted client and wholesaler customer based data submissions, integrating >= 1000 industry numbers per month.
Worked directly with management in the analysis and discovery of emerging health care market business trends leading to company policy revisions and new product offerings.
Made decisions independently and assured that they followed the protocols.
Identified incorrect outlets and determined potential root causes.
Organized and conducted high quality primary and secondary research and synthesizes findings for review by colleagues.
Business Systems Analyst Sales Data
Ensured the quality of all data elements entering the largest healthcare industry database in the U.S. utilizing mainframe operating systems; TSO, CICS, BETA92/IOF, OS/JCL.
Managed and analyzed the receipt of daily and weekly FTP data submissions.
Analyzed data formats from various media types such as but not limited to diskettes and electronic data submissions. for an assigned district of data suppliers.
Resolved data integrity issues by coordinating with various MIS departments, programmers and consultants at data suppliers including pharmaceutical manufacturers.
Analyzed pharmaceutical product movement at the manufacturer, distributor, customer and individual dispensing product pack level utilizing statistical mainframe reports.
Maintained mainframe parameters and assisted in changes due to pharmaceutical market changes.
Maintained statistical logs trending individual data suppliers, distribution volume, and pharmaceutical sales movement and customer base variations.
Bloomberg Finance Skillman, New Jersey Dec 2009 – June 2010
Finance Data Analyst
Analyzed data for International Company
Modified reports to correct longstanding problems
Input, analyzed and interpreted data
Attained knowledge of equity, debt cash, derivative products, key attributes and characteristics.
Preformed ad hoc financial analysis and development and reporting of key sales, financial and operating metrics
ADDITIONAL RELEVENT EXPERIENCE
Morgan Stanley, New York, New York – Technician Consultant
EDUCATION
Bachelor of Science Degree – Major: Computer Information System (Concentration: Business)
Caldwell College; Caldwell, New Jersey
HONORS
Award for Best Student in C++ project in the Math Intensive Program at Steven Technology in Hoboken, NJ