Mark Roman Email & Phone Number

Chicago, Il, Us

Lisle, Illinois, United States

Performed oversight on all installation and validation activities that related to the Medical Affairs department. Worked with the validation team to ensure that accurate documentation was provided to the client with regards to the full Anju validation package as well as all documentation to support installations and upgrades of our software.Act as liaison between the Medical Affairs department and the Finance department to report accurate revenue recognition, project time tracking and accurate data recording within NetSuite for the company.Perform various IT activities such as data migrations, SQL Server administration activities, support ticket assistance, software installations and act as software subject matter expert.

Lisle, Illinois, United States

Performed activity tracking visibility and financial reporting for all services within the Medical Affairs department.Monitored time entry, budget constraints for all medical affairs projects. Assisted with data migration into NetSuite for a single point of reference for the entire company. Contributed to the medical affairs department by performing, installations, data migrations and acted as a subject matter expert on several software offerings.Performed validation activities within the medical affairs group such as IQ creation/execution and OP/PQ script execution. Reviewed new service contracts prior to signings, provided feedback to the sales team when necessary.Performed SharePoint administration activities for the Medical Affairs team to share project data with the clients for all active projects.

Lisle, Illinois, United States

Lead a team of up to 4 other project managers to ensure budgets and timelines were being in line with client and management expectations. Lead over 20+ projects for high profile pharmaceutical / bio-pharma clients.Worked with our internal resources to plan software implementation, customization and data migrations. Became subject matter expert for SQL Server, data reporting and mobile applications for IRMS. Assisted with software installations, troubleshooting and validation activities for active projects.

Lisle, Illinois, United States

Managed and coordinated resources for multiple software implementation projects with project budgets between $50K to $1M. Performed risk analysis and change control with regards to any issues that arose during the course of projects with regards to new software releases.Assisted with software validation adhering to FDA 21 CFR Part 11 as well as following good documentation practices.

Lisle, Illinois, United States

Customized a scheduled backup/maintenance schedule for our client's SQL Server production environment.Completed many full database cross-platform migrations.Created custom data migrations from legacy customer databases into the IRMS database.Assisted with client support issues.

Lead account contact/developer for 3 high profile accounts. Daily tasks involve work to transform customer facing data sources and delivery of data to other databases and or web pages / interfaces via XML, audit checks between data sources and internal improvements. Work with end users to implement design changes to data adapters and ensure data quality is maintained.

Overseeing daily operations of development team responsible for service level agreement metrics reporting. Created requirement documentation in accordance with customer needs for implementation by other developers, including data mapping between both source and target systems. Acted as team lead for group of 5 developers and 2 production support personnel. Reduced customer costs through identification of unnecessary procedures and redundant reporting. Partnered with other departments on outside projects and tasks to meet deadlines.Provided seamless support for diverse Fortune 500 customer accounts ranging from financial institutions to telecommunications companies. Earned numerous awards and letters of appreciation from upper management regarding top professionalism and attention to detail. In addition to team lead role, I have stayed active as a developer and SQL Server Administrator as well.

Recommended and implemented technical improvements that reduced overall time for completion on reports being delivered to customers by 75%. Designed and implemented improved automated method of running execution steps using table driven code that increased efficiencies by reducing the need for one full time overnight support person. Designed automated email / Lotus Notes database delivery procedure for use in custom application.Led and partnered in seamless transitioning of $1M+ global and domestic accounts; all were delivered on time and under budget. Acted as SQL Server DBA for several servers/databases. Provided timely maintenance and created new tables, enhancements, etc. that met operational specifications. Acted as source code control administrator which involved gathering weekly reports of items to review as well as updating production versions of code.

Downers Grove, Il

Worked with account customers to indentify business needs then to apply and/or correct existing IT solutions or create new ones.Various accounts involved financial institutions, law offices and marketing companies. Obtained several certifications while supporting clients during the year (MCSD, PCDocs (now Open Text) specialist).

Bachelor Of Science, Computer Information Systems, 4.0

Activities and Societies: Summa Cum Laude, finished top of graduating class with a 4.0 GPA. Coursework included project management, client.

Bachelor Of Arts, Finance

Minored in Economics