Robin Rutkowski Email and Phone Number

Design, develop and maintain data warehouse to support 16 facilities and 10 unique ERP instancesWork with developers and managers to ensure business rules when migrating and normalizing dataDevelop rules and audits for data cleansing and normalization;Develop and implement strategies for gathering data from operational databases and third-party vendors Build customer and sku profitability model for leveraging resources; resulted 9M savingsDesign and develop enterprise-wide business intelligence data cubes and reporting solutionsProvide leadership in managing technical resources and staff

Define specifications for a centralized data warehouse normalizing data from 10 legacy systems.Define and implement corporate level data and business rules for maintaining accuracy of data.Develop and maintain mapping document of data from legacy systems including business rulesDevelop reports for all levels of manufacturing and corporate reporting as requested. Migrate over 150 historical reports to SSRS format; creating views and adding functionality to improve performance; Develop SQL table of reports and their characteristics for user access.Assisted in the setup of SharePoint Reporting site; administer user rightsDevelop training documents and conducted training for accessing and running SSRS reports.

Direct and manage reporting for all levels of manufacturing and corporate reporting. Define and implement strategies to track key data components within the database. Develop and implement new manufactured parts definitions including the bill of materials. Assist in the successful conversion to a higher level database and migration of historical information. Develop and maintain documents to support FDA validation requirements.Assist in the development and implementation of a new Marketing strategy and sku rationalizationDevelop training documents and conducted training for updating the database.Implement new EDI software

Direct procurement functions associated with information technology for State Agencies to ensurecompliance with SC Consolidated Procurement Code and AOC standards including: researching and writing solicitation requirements, conducting pre-bid conferences and site visits, negotiating contracts, administering and issuing modifications for all types of contracts, and handle vendor concerns and complaintsReview and negotiate end user license agreements for state term contracts and multi agency contractsProject yearly negotiated savings and budget usage by state agencies by contractAttend training and continually review legislation, regulations, policies and procedures governingprocurement services to build expertise and ensure compliance with all stages of procurementProven ability to solve problems, prioritizes job duties, establish and maintain effective workingrelationships and communicate effectively

Supervise and guide the professional development of the advancement services and mailroom staffDirect the training of other staff members in the use of software and related applicationsAnticipate External Relations office needs with regards to information technologyDevelop internal guidelines to ensure compliance with CASE for financial recording and reportingDevelop standards to ensure constituent information confidentiality and accuracy.Maintain efficient communication between Advancement and other college offices Function as a senior member of the VP of Development staff.Direct, in communication with Administrative Computing, External Relations’ enterprise systemsDatabase Administrator for Raiser’s Edge Report monthly on financial progress of the overall Campaign Report and Capital Projects ReportAd hoc reports upon request

Special Projects management for specific user requirementsAdministrator for WebIntelligence and Broadcast Agent servers – on call supportDevelop presentations for Management and Sales personnelActive member for choosing, testing and implementing OLAP tool to support reporting via webResearch, report design and implementation of corporate reporting needsDesign universe and assist Database Administrator in database design for new projectsAssist new users with data definitions and tool implementation

Project management of enhancements to automated pricing system on AS400Develop and implement policies and procedures for marketing with regard to pricing, data managementResearch, develop, and implement programs to accomplish special projects for management and field salesCoordinate communications between customers and internal management to facilitate quotes and contractsUpdate system reflecting current market trends with regards to pricing for all product linesTrain and supervise employees whose primary responsibilities are related to pricing systemsContinually review and update reference and training manuals as enhancements are developed

Design, develop and implement programs and databases for developing a quoting system for PC applicationDesign pricing procedures for implementation on AS400 Midrange for contract and base pricing modulesBuild and maintain programs to interface files between PC, Mainframe and Midrange hardwareResearch and implement reporting procedures for tracking market trends and contractual agreementsProvide Technical Support to Marketing personnel; develop technical documents for reference and training