Will Lally Email & Phone Number

United States

Tempe, Arizona, United States

•Led a team of software developers in designing, developing, and deploying scalable androbust solutions.•Managed the full software development lifecycle from requirements gathering to productrelease, ensuring adherence to timelines and quality standards.•Collaborated closely with product management and cross-functional teams to aligntechnical solutions with business objectives.•Implemented Agile methodologies and fostered a culture of continuous improvementand innovation.•Orchestrated provisioning and deployment of on-premise Windows servers, Linux servers,and SQL Server virtual machines, enhancing collaboration between security, network, andinfrastructure teams. Improved efficiency and reduced downtime for critical systems.Microsoft Windows Server, Red Hat Linux, Oracle and Microsoft SQL Server, virtualmachines, and hard devices.•Implemented enhanced Azure data bricks template, increasing data processingcapacity and enabling the business to handle larger datasets more effectively.•Migrated on-premise SSIS ETL processes to the Azure cloud using data bricks, reducingoperational costs and improving scalability and performance for the business.•Expertly provisioned multiple types of Azure resources, optimizing system performanceand scalability for the business.•Collaborated closely with business partners, project and vendor staff to successfullyconvert on-premise vendor platform to Azure, leading to an improvement in systemperformance and scalability.•Collaborated with business partners to successfully deliver projects using AGILEmethodologies, Azure DevOps, and GitHub, leading to improved project quality and on-time delivery.•Led the design, documentation, and testing of Disaster Recovery plans for on-premiseand cloud resources, ensuring reduction in recovery time and minimizing businessdowntime

Tempe, Az, United States

•Designed and implemented Java-based ETL (Extract, Transform, Load) processes forintegration with a third-party platform, enhancing data extraction efficiency.•Developed custom data pipelines using Java, ensuring seamless extraction from varioussource systems and transforming data to meet specific business requirements.•Led a team of developers in the design, development, and maintenance of applicationsusing C#, Java, .NET Core, Python and other related technologies.•Implemented Agile methodologies (Scrum/Kanban) to streamline developmentprocesses, improve team efficiency, and ensure on-time project delivery.•Designed and implemented scalable architecture and solutions, ensuring highperformance, reliability, and security.•Participated in hiring processes, contributing to the recruitment and onboarding of newteam members.•Mentored and coached team members, conducting performance evaluations andproviding constructive feedback to foster professional growth and development.•Utilized SQL Server for database design, optimization, and maintenance, ensuring dataintegrity and performance.•Participated in all phases of the software development lifecycle (SDLC), includingrequirements gathering, design, development, testing, deployment, and support.•Conducted code reviews and implemented best practices to maintain high code qualityand ensure adherence to coding standards.•Defined best practices and guidelines for SSIS development to ensure consistency,scalability, and maintainability across projects.•Created and standardized SSIS (SQL Server Integration Services) packages andtemplates for efficient data extraction, transformation, and loading processes.•Collaborated with cross-functional teams to gather requirements, design data flows, andoptimize performance in SSIS solutions.•Conducted training sessions and provided documentation to educate team memberson the SSIS standard and template, promoting adoption and adherence to establishedpractices

Seattle, Washington, United States

•Design, develop and lead a small team in building applications to fulfill both internal andexternal customer engagements, including dashboards, data transfer services,databases and interfaces.•Led a team of developers in designing, customizing, and deploying Microsoft DynamicsCRM/ERP solutions.•Design and develop custom tools, applications and services to support enterprisesystems and applications, including data transfer and transformation automation, clientnotifications, extensions and interfaces.•Engage, evaluate and manage external vendor resources in the development andimplementation of custom applications and services.•Led a team of engineers in designing, developing, and implementing enterpriseapplication integration (EAI) solutions.•Designed and implemented RESTful and SOAP-based web services to facilitatecommunication between disparate systems.•Developed custom connectors and adapters to integrate third-party applications andproprietary systems.•Architected and implemented scalable CRM/ERP solutions using Microsoft Dynamics 365,including customization of entities, workflows, plugins, and integrations.•Implemented message queuing and event-driven architecture (EDA) patterns to ensurereliable and asynchronous data exchange.•Collaborated with cross-functional teams to gather requirements, define technicalspecifications, and prioritize integration tasks based on business priorities.•Provided technical leadership, mentoring, and training to team members, fostering aculture of knowledge sharing and continuous improvement.•Designed and developed custom modules, web resources, and dashboards to meetspecific business requirements using JavaScript, TypeScript, HTML, and CSS.•Managed deployment processes and supported post-implementation activities,including user training and support.

Redmond, Wa

•Led a team of developers in designing, implementing, and maintaining C# tools andapplications.•Designed and developed scalable and efficient software tools using C#, .NET framework,and related technologies.•Architect for an extensible managed code, multi-document, “plug-in” applicationframework.•Designed and developed an enterprise-wide incident notification and managementsystem.•Collaborated with cross-functional teams, including product management and UX/UIdesigners, to define requirements and deliver user-friendly tools.•Designed and developed an installation application integrating 3 client applications, 7databases, 5 windows services, and 4 web services using InstallShield and WindowsInstaller.•Conducted code reviews, mentored junior developers, and provided technical guidanceto ensure project success and team growth.•Technical writer documenting 24 applications and services including installationprocedures.•Implemented best practices for code quality, performance, and security throughout thedevelopment lifecycle.•Managed project timelines, resources, and deliverables to meet organizational goals andcustomer expectations.• Recipient - Microsoft Gold Star Award for Excellent and Innovation – 2004.

Redmond, Washington, United States

•Installed, configured, and maintained SQL Server instances across various environments(production, test, development).•Designed and implemented database schemas, tables, indexes, and stored proceduresto support application development projects.•Developed and optimized T-SQL queries, stored procedures, functions, and triggers tosupport application development and data manipulation.•Designed and developed a data warehouse to encompass 3 terabytes of confidentialdata.•Performance tuned SQL queries and database operations to improve applicationperformance and response times.•Lead architect for high availability database serving 40 million transactions per day.•Led effort to consolidate content database servers saving $1.24 million annually.•Monitored and optimized database performance using tools such as SQL Profiler,Performance Monitor, and DMVs.•Implemented and maintained database security best practices, including role-basedaccess control and encryption.•Conducted regular database maintenance activities, such as index defragmentationand statistics updates.• Implemented Microsoft Operations Manager across three domains and 4,000 servers

Redmond, Washington, United States

•Designed high performance, enterprise scale databases using production and prototypedevices.•Analyzed and optimized system performance of Microsoft Windows Server and MicrosoftSQL Server.•Developed and executed performance test plans, identifying bottlenecks and proposingsolutions to improve performance.•Collaborated with development teams to implement performance improvements andvalidate their effectiveness.•Conducted deep-dive analysis of system metrics using tools such as Perfmon, Profiler,SQLIO, DiskTrace, IOMon, etc.•Increased performance of processor, memory and storage operations by 19% forWindows 2000.• Enhanced total storage capacity and device scalability by 38% for Windows 2000.• Improved SQL Server read performance by 12% and write performance by 9%.