Marcin Krukowski Email & Phone Number

- Microsoft Power BI tools development including Microsoft Flow automation and PowerApps support.- Veterinary wholesaler data processing including product and location databases administration.- Pharmacy Chain data processing including IQVIA (IMS Health) reports integration.

- Creating tools that automate processes within the company (including placing production orders). Cooperation with Managers at creation and implementation.- Recognition of the capabilities of the Electronic Data Interchange system (ECOD Comarch) purchased by the company, implementation of subsequent elements to be managed by the system.- Creation of an electronic mailing PDF invoice system.- Automation of reports for clients based on the ERP XL Comarch, MS SQL and dtsx.packages from Visual Studio.

Durham, North Carolina, Us

- ePharmacy Tracker (online pharmacies project) - process setting: pharmacies recruitment for cooperation, data aquisition from pharmacies, isolating algorithms for recognizing internet sales in sales data, tasks distribution within a team, reports preparation and distribution.- Web based BI platforms for pharmacy chains and individual pharmacies. Support of international project as Local Office. Preparation and interpretation of batch data sets. Cooperation with developers from United Kingdom and India, adaptation of the database architecture to Polish reality. Website and marketing materials translation. Regular data feed. Presentation of BI platform use at the conference.- PromoTrack - support as Local Office of an international product regarding promotional activity survey of pharmaceutical companies, cooperation with lawyers and personal data administrators from Poland, Great Britain and the Czech Republic, preparation of agreements enabling the transfer of doctors' data, preparation and transfer of tools for interpreting of doctors and pharmacies data to the purchaser of the product (Kantar Health).

Danbury, Ct, Us

- Administration of IMS Health pharmacies database- Design, creation and implementation of reports sending tool- Design, creation and implementation of tool for monitoring data flow effectiveness from pharmacies to IMS- Pharmacy Monitor – product management, from survey to report- Anonymized Patient Data (NPA / LRx) coordination part of project in Data Sources Team- Support of new pharmacies recruitment (up to 4,5k)

Danbury, Ct, Us

- Managing a team of 3 representatives. Increase of data flow effectiveness from pharmacies to IMS. Recruitment of new pharmacies.- Pharmacy profile survey made with CATI technique. Selection of service provider, definition of requirements, interviewers team training. Quality control and payment checks. Final creation of complete pharmacy profile database (input for further data mining processes).- Internet Pharmacies.- Design, creation and implementation of tool for raw data input to production of PTR service.

Danbury, Ct, Us

- Managing a team of 3 representatives. Increase of data flow effectiveness from pharmacies to IMS.- Recruitment of 500 selected pharmacies for IMS pharmacy panel, aim achieved by cooperation with representatives.- Design and creation a set of tools for coding doctors’ interviews in following surveys: Prescriber Focus Cardio, Prescriber Focus GP, Medical Index, DermatoMirror, Oncology Universe Study, Polish Medical Index.- Design, creation and implementation of tool for preparation and control of financial reserves for pharmacy department in IMS.- Pharmacy profile survey (FFI) on small scale connected with CATI interviews.- Financial survey for Polish Pharmaceutical Chamber.

Danbury, Ct, Us

- Pharmacy profile survey of all pharmacies in Poland. Cooperation with web services provider for quality control, CATI service provider for quality control, printing company and interviewing firm. Logistics of printed surveys. Quality control. Design, creation and implementation of coding tool, organization of 12 persons coding team. Payment checks. Final creation of complete pharmacy profile database (input for further data mining processes).- Recruitment of 800 selected pharmacies for IMS pharmacy panel, aim achieved by cooperation with 10 representatives.- Preparation of raw data for production of Pharmacy Trend Reports- Design, creation and implementation of tool for communication with team of representatives.

Danbury, Ct, Us

- Managing clients’ claims and queries concerning quality of data and verification of process in each case.- Design, creation and implementation of claims database, enabling analysis of problems concerning data or data interpretation.- Design, implementation and service of validation tool (Quality Index) made for comparison IMS vs clients data.- Design, creation, implementation and service of set of quality control systems and procedures.- Design and creation a tool for finding sale peeks in daily data, comparison daily data with weekly data, and searching for potential clients on daily reports (Early Warning)