Morgan Gilday Email & Phone Number

Greensboro, North Carolina, United States

Greensboro, North Carolina, United States

Greensboro, North Carolina, United States

Scottsdale, Arizona

● Create and modify SQL Stored Procedures● Maintain Data Warehouse to meet reporting needs ● Create and schedule SSRS reporting to meet senior management and business needs● Manage business critical IT Projects like transaction automation and software implementation ● Facilitate project meeting with internal stakeholders, third party vendors and clients● Manage IT vendor relationships including contract negations, change management and end user training ● Lead process improvement projects in collaboration with business senior management and end users● Support and maintain ERP solution including user training, end user support, managing and testing updates● Direct and support international development and helpdesk associates in IT projects and end user support● Communicate all current project statuses and outstanding support concerns to Directors, CEO and Owner

Scottsdale, Arizona

● Create and modify SQL Stored Procedures to facilitate BI report generation● Maintain Data Warehouse to meet BI reporting needs ● Collaborate with Web Development team to embed Business Intelligence Reports, Visualizations and KPI’s into existing web applications● Lead discussion related to Business Intelligence development in daily stand up meetings● Participate in Agile Software Development process using KanBan framework● Create BI Visualization Solutions in LOGI ● Efficiently transform and load new data sources using SSIS

• Effectively gather and document requirements from business stakeholders• Create and modify SQL Stored Procedures to automate data transformation and file creation• Create, Alter, and delete SQL tables as needed to meet business requirements• Develop solutions in SQL Server to automate business tasks and data feeds• Clearly communicate objectives and project progress to management on Business Intelligence Projects• Lead project meetings and provide useful follow up documentation• Collaborate with internal resources to ensure development, testing and release tasks are completed within agreed project timelines• Provide accurate and efficient reporting solutions to end users and management in all areas of the business• Ensure data integrity on all internal and external reporting• Create visual data models in SSRS and LOGI Analytics to provide actionable intelligence for stakeholders• Maintain and support existing SSAS date cubes• Efficiently transform and load new data sources using SSIS

Scottsdale, Az

● Effectively collaborate with external clients to determine goals and generate requirements for new custom soft-ware and existing Point of Sale and Business Intelligence software customization● Create thorough and efficient project plans and associated technical documentation for all stages of the software development cycle● Lead and participate in architecture of new software including design, development, networking, data gathering and testing● Efficiently provide technical support to existing clients for software, hardware and data issues and effectively documents and communicates cause and resolution● Independently manage and execute all phases of business intelligence customization requests for existing clients; including gathering requirements, providing quote, SQL programming, validating and modeling data, and client communication● Gather data required to conduct analysis from several sources, compile it together in standardized format and enter the data into Business Intelligence software● Create charts and dashboard design to maximize the data visualization of KPI’s for operational, accounting, manager, technician and salesperson focused dashboards● Design User Interface, test and lead UAT testing for mobile applications

Scottsdale, Arizona

● Proficiently provide programming, reporting and business analysis services to internal and external parties using SQL for DB2 , Monarch, MS Excel, MS Access and other database technologies● Provide system support for multiple critical business systems including rotating on-call coverage● Lead and participate in business critical projects, requirements analysis, requirements documentation creation, and development testing; primarily using Agile or Waterfall SDLC methodologies ● Effectively make proper business decisions by weighing multiple options and identifying the option with an optimal balance of cost effectiveness and minimal customer impact● Excel as a liaison between Capital Group Companies, internal/external clients and third party data warehouse regarding system maintenance, enhancements, issues, outages, and delays● Serve as a valuable resource to direct peers and as a subject matter expert to internal and external clients for enterprise applications and business process● Take initiative in researching and analyzing business system / application issues, including assessing business impacts, recommending and documenting solutions, and facilitating design and requirements discussions ● Provide time sensitive reports and data analysis to senior management to ensure compliance with regulatory obligations and/or to reduce cost or time expenditures● Manage annual data reduction projects to reduce cost

Scottsdale, Az

● Demonstrate business and technical skill supporting all enterprise and vendor applications for associates at all levels of the organization ● Demonstrate strong leadership skills and initiative when working with the team and others across the organization● Partner with other support groups and business units for problem resolution, knowledge sharing and implementing and refining processes● Coordinate outage response for systems affecting internal and/or external customers and responsible for com-municating the details to IT groups and business areas● Test new products for potential use by American Fund and Capital Group associates, communicated results and provided recommendations to business stakeholders ● Regularly represent American Funds Technology Support Center and our customers in meetings and projects with senior management● Effectively apply the incident management processes using the Remedy ticketing system, internal email and website communications, and facilitating technical issue call with tier 2 support teams● Train new associates and serve as a mentor as they expand their knowledge and grow in the role

Scottsdale, Az

● Demonstrate business and technical skill using and supporting all Capital Group systems for associates at all levels of the organization ● Demonstrate strong leadership skills and initiative when working with the team and others across the organization● Partner with other support groups and business units for problem resolution, knowledge sharing and implementing and refining processes● Coordinate outage response for systems affecting internal and/or external customers and responsible for communicating the details to IT groups and business areas● Test new products for potential use by American Fund and Capital Group associates, communicated results and provided recommendations to business stakeholders ● Regularly represent American Funds Technology Support Center and our customers in meetings and projects with senior management● Effectively apply the incident management processes using the appropriate tools