Scott Cranston Email & Phone Number

Standish, Me, Us

Scarborough, Maine, United States

Process and maintain customer data, primarily for a Fortune 100 insurance company, ensuring accurate and timely execution. Retrieve data from SFTP and apply customer-specific transformations, such as file combining, coding, record filtering, data cleaning, record de-duplication, presorting, and output formatting for various Canon printers. Meticulously adhere to documented procedures for logging, tracking, and archiving data, ensuring data integrity and security.

North Windham, Me

Supported Specialists in the Millwork department by assisting with various tasks and ensuring smooth operations. Provided exceptional customer service across the entire store, consistently delivering a positive shopping experience. Demonstrated a commitment to professional growth by dedicating personal time to self-improvement through LinkedIn Learning and Salesforce Trailhead.

North Conway, Nh

Delivered exceptional customer service aligned with the core principles of L.L. Bean, fostering a positive shopping experience for customers. Engaged with customers on a personal level, leveraging my extensive hiking experience in New England's mountains over 4000 feet to provide relevant recommendations and insights. Demonstrated a strong dedication to customer satisfaction, resulting in receiving the prestigious "Living The Legend" monthly recognition twice for outstanding customer service. Quickly adapted to the retail environment, leveraging transferable skills and a willingness to learn to excel in a new industry.

Westbrook, Me

Designed, developed, and implemented efficient data acquisition processes in Lavastorm to meet reporting and analysis requirements, effectively supporting business needs. Created visually impactful and informative visualizations using data analysis tools, empowering Companion Animal Group field sales professionals and sales leadership to make data-driven decisions and drive business growth.

Falmouth, Me

Constructed efficient data extracts and developed advanced reporting and data analysis solutions tailored to the specific needs of home equity and home equity lines of credit products. Ensured timely and secure distribution of dozens of daily, weekly, and monthly reports to hundreds of colleagues, maintaining effective communication channels. Mentored and reviewed the work of less experienced analysts, providing guidance and support to enhance their skills and improve overall team performance. Proactively identified areas for process improvement, streamlining reporting and data analysis procedures to increase efficiency and accuracy.

Westbrook, Me

Developed a split Microsoft Access / SQL database, leveraging extensive Visual Basic for Applications (VBA) code to enable over 120 Research & Development scientists to accurately track the percentage of time dedicated to projects. The database played a crucial role in ensuring IDEXX qualified for approximately one million dollars in additional tax credits from the IRS. Implemented user-friendly features such as context-sensitive help, automatic logout after ten minutes of inactivity, and assigned access rights based on Windows usernames. Made significant contributions to an MS-Access based lyophilization analyzer application, providing the finishing touches to enhance functionality and usability. Designed and implemented an application for the Regulatory department to track compliance of newly developed electronic equipment on a country-by-country basis. My supervisor actively advocated for my position to become permanent due to outstanding performance and contributions. Successfully completed the contracted assignment in September 2015, leaving a lasting positive impact on data management and process efficiency.

South Paris, Me

Collaborated with the owners to design and document a custom Access application serving as an interface between their 3Dcart order-processing system and QlikView business intelligence platform. Designed intuitive interfaces and workflows to enhance user experience and productivity. Implemented robust data validation and error handling mechanisms to ensure data accuracy and integrity. Created comprehensive documentation outlining the application's functionality, user guides, and troubleshooting resources for future reference.

Falmouth, Me

Implemented the redesign of weekly Extract, Transform, Load (ETL) reporting Access databases for new and closed accounts (checking and savings) and overdrafts, effectively replacing the use of Excel spreadsheets. Improved process efficiency and reduced input errors, streamlining data management and reporting. Assumed responsibility for monthly reporting of various fee components, including monthly service charges, ensuring accurate and timely reporting. Proactively fulfilled ad-hoc data requests from the Retail Money-In Checking and Fee teams, providing valuable insights and supporting data-driven decision-making. Thoroughly documented all changes made to processes, ensuring clear and comprehensive documentation for future reference and knowledge transfer. Successfully completed the contracted assignment in October 2012.

Portland, Me

Created and maintained multiple Microsoft Access databases to support various functions, including sales compensation reporting, DirecTV sales, the Winning Connections company-wide incentive program, and other metrics. Utilized VBA code and SQL queries to streamline user interfaces, improving usability and efficiency. Thoroughly documented all processes, ensuring clear and comprehensive instructions for ongoing maintenance and knowledge transfer. Played a key role in developing and optimizing database structures and data models, enabling accurate and reliable reporting. However, due to a 10% workforce reduction in September 2011, was laid off along with 400 of my colleagues.

South Portland, M

Served as the sole I.T. person, responsible for administering Active Directory servers, UNIX servers, and an AVAYA phone system. Provided comprehensive help desk support to approximately 120 users, offering assistance via phone, remote access, and in-person interactions. Evaluated and recommended the purchase of PC's, printers, copiers, faxes, and related equipment, ensuring optimal functionality and compatibility. Demonstrated technical expertise by setting up a company-wide intranet on a Linux server created from a spare PC, enhancing communication and collaboration across the organization. Collaborated closely with vendors to coordinate the setup or relocation of data and voice networks at various office locations, including South Portland, Lewiston, Augusta, Waterville, and Rockport.

Freeport, Maine, United States

Played a vital role as part of the help desk team, providing technical support and troubleshooting assistance to end-users. Undertook special projects and contributed to network maintenance activities, ensuring smooth operations and minimizing downtime. Received the prestigious CIGNA Circle of Excellence Award in recognition of the significant improvement made in remote access software distribution to provider offices.

South Portland, Maine, United States

Served as the primary solution provider for all software and hardware issues faced by end-users, ensuring prompt resolution and minimizing downtime. Conducted daily backups, performed periodic server maintenance, and executed virus scans to safeguard data and maintain system integrity. Played a key role in establishing the local- and wide-area network infrastructure for both Jackson Brook Institute (JBI) and its parent company, Community Care Systems, Inc., collaborating with the MIS Team to ensure a robust and reliable network. Implemented a remote access system, enabling outpatient sites to securely connect to the main network. Created Access databases to meet various user needs, supporting efficient data management and reporting.