Ashlee R. Email & Phone Number

Technical ownership of data storage architecture, data warehouse modeling, ETL pipelines, reporting, and data visualization.Designing, developing, and documenting AWS data architecture and ETL pipelines for data lakes, data warehousing, and analytics utilizing Redshift, S3, IAM, Glue, and DMS.Application software engineering tasks resolving defects and adding features using C# .NET and Angular.Collaborating with other engineers in managing CI/CD pipelines using NAnt… Show more Technical ownership of data storage architecture, data warehouse modeling, ETL pipelines, reporting, and data visualization.Designing, developing, and documenting AWS data architecture and ETL pipelines for data lakes, data warehousing, and analytics utilizing Redshift, S3, IAM, Glue, and DMS.Application software engineering tasks resolving defects and adding features using C# .NET and Angular.Collaborating with other engineers in managing CI/CD pipelines using NAnt automation scripts and various testing platforms including nunit, jest, and tSQLt.Internal SQL SME, performing regular code reviews of SQL work by other developers at all levels.Advising internal Cloud Hosting, System Administration, DBA, and Support teams in SQL Server best practices. Show less

Converted data from legacy systems into Tessitura, developed customizations to the Tessitura e-commerce functionality, and developed code to provide customizations including reports, data visualizations, web server interceptors, and custom application screens.Created a parking customization to load parking garage barcodes into Tessitura, assign barcodes to ticket orders including a parking add-on product, and displaying parking garage barcodes on event tickets.Developed an… Show more Converted data from legacy systems into Tessitura, developed customizations to the Tessitura e-commerce functionality, and developed code to provide customizations including reports, data visualizations, web server interceptors, and custom application screens.Created a parking customization to load parking garage barcodes into Tessitura, assign barcodes to ticket orders including a parking add-on product, and displaying parking garage barcodes on event tickets.Developed an add-on integrating the WordFly digital messaging platform with the Tessitura database, displaying messaging history in the standard application, an optional custom screen, and new reports.Provided API consulting services for clients with custom e-commerce sites wanting to integrate Tessitura ticket sales and donation capabilities using the application API. Show less

Greater Chicago Area

Senior member of engineering team responsible for interactive exhibit technologies, the organization's e-commerce website, and customization of Tessitura. Collaborated with business leaders and managed all phases of web application development, including design, configuration, testing, implementation, and post-launch support.Mentored junior team members by assigning work and pairing on complex projects.Key member of interdepartmental data governance committee; actively… Show more Senior member of engineering team responsible for interactive exhibit technologies, the organization's e-commerce website, and customization of Tessitura. Collaborated with business leaders and managed all phases of web application development, including design, configuration, testing, implementation, and post-launch support.Mentored junior team members by assigning work and pairing on complex projects.Key member of interdepartmental data governance committee; actively contributed in defining and authoring data governance policies, related workflows and procedures for all departments within the organization.Designed and monitored ETL pipelines, custom reports, and visualizations for all departments. Show less

Chicago, Illinois

Hybrid role combining data engineer, data architect, and DBA responsibilities to design, implement, monitor and manage database systems, data warehousing, reporting, and ETL processes for external and internal CRM data sources in an Agile Scrum environment.

Nashville, Tn

SME of custom ASP.NET revenue control software, ETL pipelines, and relevant business processes. Leader of cross-functional teams focused on issue resolution involving network, systems, programming, and operations processes. Identified trends in support requests, then implemented long-term solutions minimizing the need for workarounds. Support requests reduced by 42% from 2014 to 2015. Developed reports using SSRS combining legacy and current system data following massive integration project… Show more SME of custom ASP.NET revenue control software, ETL pipelines, and relevant business processes. Leader of cross-functional teams focused on issue resolution involving network, systems, programming, and operations processes. Identified trends in support requests, then implemented long-term solutions minimizing the need for workarounds. Support requests reduced by 42% from 2014 to 2015. Developed reports using SSRS combining legacy and current system data following massive integration project. Modified SQL stored procedures to improve performance, add functionality, and prevent data corruption. Show less

Franklin, Tn

Senior member of IT infrastructure team; managed the configuration and support of EHR web-based application for 117 client Health Centers. Primary resource in SQL, XML, HTML and IIS troubleshooting and resolution deployment. Created report templates and customized reports addressing client-specific needs using Crystal Reports. Conducted monthly support calls with Health Center managers to assess ongoing IT service and training needs.Designed and implemented replicable processes to… Show more Senior member of IT infrastructure team; managed the configuration and support of EHR web-based application for 117 client Health Centers. Primary resource in SQL, XML, HTML and IIS troubleshooting and resolution deployment. Created report templates and customized reports addressing client-specific needs using Crystal Reports. Conducted monthly support calls with Health Center managers to assess ongoing IT service and training needs.Designed and implemented replicable processes to reduce new client implementation time by 50%. Uncovered potentially disastrous vaccination medical coding mapping errors. Visualized relevant data and collaborated with Health Informatics team to design and implement resolution for all clients. Key participant in interdepartmental project and process development planning; ensured HIPAA compliance. Show less

Franklin, Tennessee

Nashville, Tn

Served in a multifaceted role assisting Senior Network Technician and IT Director in administration of 35 Windows servers, Nortel PBX system, VMware vSphere, and AD/GPO. Performed general network maintenance and system administration duties; provided desktop support services for Mac and PC platforms. Assessed hardware and software needs within provided budget constraints. Assisted with data center upgrade and power distribution planning, reduced unscheduled down time by 90%. Designed and… Show more Served in a multifaceted role assisting Senior Network Technician and IT Director in administration of 35 Windows servers, Nortel PBX system, VMware vSphere, and AD/GPO. Performed general network maintenance and system administration duties; provided desktop support services for Mac and PC platforms. Assessed hardware and software needs within provided budget constraints. Assisted with data center upgrade and power distribution planning, reduced unscheduled down time by 90%. Designed and implemented IT policies promoting PCI security compliance and general best practices. Configured and maintained Tessitura ticketing system. Show less

Norwalk, Ct

Managed print production of in-store displays, POS, sales material, fulfillment and premiums. Clients included Unilever, McNeil Healthcare, Nexxus. Managed worldwide shipping to distribution centers and major retailers including Wal-Mart, Target, Club Stores and major food chains. Reviewed final proofs with Art Directors and Account Team, attended press checks. Managed an average of 45 programs per week with budgets up to $250K. Assured timelines and budgets were met; 100% on-time… Show more Managed print production of in-store displays, POS, sales material, fulfillment and premiums. Clients included Unilever, McNeil Healthcare, Nexxus. Managed worldwide shipping to distribution centers and major retailers including Wal-Mart, Target, Club Stores and major food chains. Reviewed final proofs with Art Directors and Account Team, attended press checks. Managed an average of 45 programs per week with budgets up to $250K. Assured timelines and budgets were met; 100% on-time completion, under budget, ensured SOX compliance. Show less

Norwalk, Ct

Taught multiple SAT preparation classes comprised of 12 students and conducted private tutoring sessions.

Bowling Green, Ky

Functioned as Print Production Operator, Graphic Designer, and assisted the branch manager with all areas of business including accounting and employee scheduling. Employed full-time while attending school full-time.

Chicago, Il

Created CAD drawings using Rhinoceros, produced 3D objects using rapid prototyping layered manufacturing. Worked with graduate students to develop new method of creating bone mass for reconstructive surgery. Presented research in local and national venues.

Bachelor Of Arts (Ba), Broadcasting, Magna Cum Laude

Activities and Societies: WKU SIFE (Founding Chapter Member, Technical Director) • Intramural Girls’ Lacrosse (member) • Golden Key.

Master Of Business Administration (Mba), Gpa 4.0/4.0

Activities and Societies: Beta Gamma Sigma International Honor Society (member) • The Honor Society of Phi Kappa Phi (member) Worked.