Amy Masters Email & Phone Number

New York, United States

Buffalo, New York, United States

Building a data warehouse / landing zone in SQL Server to combine sources of data at Evans for reporting and analytical purposes, (flat files, excel, databases)Building SSIS Packages and Stored Procedures to perform ETLCreating Data Dictionary, source documentation and diagrams for data warehouseCreating tables and views in SQL Server to be moved to Azure.Cognos 10 and 11 Horizon 360 BI Report BuilderAttend FIS Cognos 11 basic and advances report writing course in Dec… Show more Building a data warehouse / landing zone in SQL Server to combine sources of data at Evans for reporting and analytical purposes, (flat files, excel, databases)Building SSIS Packages and Stored Procedures to perform ETLCreating Data Dictionary, source documentation and diagrams for data warehouseCreating tables and views in SQL Server to be moved to Azure.Cognos 10 and 11 Horizon 360 BI Report BuilderAttend FIS Cognos 11 basic and advances report writing course in Dec 2019Strong troubleshooting skills, multitasking, communication and collaboration.Learning Power BI and Python for reporting and optimization Show less

Buffalo/Niagara, New York Area

Working with Teradata and SQL Server database. Keeping the lights on and continually learning.

Buffalo/Niagara, New York Area

Promoted to new title but still on DBA team

Admin work, data moving , query optimizationSQL SERVER & Teradata databases

Used C# .Net to develop a dashboard website for data warehouse stats and ID management systemSQL developer for Teradata , SQL server (CDR warehouse) and OracleAdmin work for Teradata Data LabsSharePoint DesignerSSIS Packages

Fredonia Ny

Provided 4- 5 hours of drop in tutoring per week Spring 2014: One-on-One tutoring for CSIT 251 Managing Computer Information System and CSIT 151 Intro To CIS

Fredonia,Ny

Spring 2014: Teaching Assistant for CSIT 151 - Introduction to Information SystemsAssisted students with learning Access and ExcelSpring 2015: Lab Proctor Fenton 115 LabAssist students with question. Help in areas of C++, Discrete Math, HTML/CSS, Access/ Excel, PHP, SQL and Visual Basic as needed.

Fredonia, Ny

Design, built and update webpagesCreated and implemented a Twitter news feedUsed OMNI Content Management SystemIncreased web design knowledge and communication skills to develop a professional looking web siteOver 100 hours of hands on experiencehttp://www.fredonia.edu/department/english/

Westfield, Ny

Designed, built and implemented a database for an Inventory / Order Entry System for juice concentrates to save time, money, and redundant hand written paperworkDesigned relationships, tables, queries, forms and reports using VBA language, SQL and Microsoft AccessDatabase stores customer, shippers, product and order informationDisplays reports for inventory and open orders; can be filtered by date and product statusCreates and prints 10 or more different… Show more Designed, built and implemented a database for an Inventory / Order Entry System for juice concentrates to save time, money, and redundant hand written paperworkDesigned relationships, tables, queries, forms and reports using VBA language, SQL and Microsoft AccessDatabase stores customer, shippers, product and order informationDisplays reports for inventory and open orders; can be filtered by date and product statusCreates and prints 10 or more different customizable invoices, certificates, reports and labels Show less

Jamestown, Ny

•Created promotion material for annual Electric Power Research Institute (EPRI) Conference•Designed and created brochures and sent mailer to attract new clients•Performed website updates using HTML, FTP, Dreamweaver, and Photoshop •Completed OSHA 10 hour course certified (expires 4-17-15)•Performed lab work; sample preparation for labeling, shipment and additional testing•Performed air emission test to ensure companies were meeting EPA regulations•Wrote reports for… Show more •Created promotion material for annual Electric Power Research Institute (EPRI) Conference•Designed and created brochures and sent mailer to attract new clients•Performed website updates using HTML, FTP, Dreamweaver, and Photoshop •Completed OSHA 10 hour course certified (expires 4-17-15)•Performed lab work; sample preparation for labeling, shipment and additional testing•Performed air emission test to ensure companies were meeting EPA regulations•Wrote reports for clients listing results and findings of testing•Designed web site and created custom graphics using Photoshop and Illustrator•Created and executed marketing plans and procedures including online social media marketing with Facebook and Twitter•Designed and created promotional material (e.g. brochures, flyers, window displays)•Performed customer service and account payable tasks•Constructed ads and wrote press releases distributing to local newspapers Show less

Bachelor'S Degree, Computer Information Systems Major - Web Programming Minor, 3.71

Activities and Societies: Computer Lab Assistantship: Spring 2014 & Spring 2015 Semesters Courses: Visual BASIC I & II Information Systems.

Bachelor'S Degree, Communications Media Management Major - Leadership Studies Minor, 3.58

Activities and Societies: Fredonia Radio Systems Member Music Business Club Memeber

Associate'S Degree, Communications, 3.61