Scott Lewis
Atlanta
Summary
Experienced leader with strong background in guiding teams, managing complex projects, and achieving strategic objectives. Excels in developing efficient processes, ensuring high standards, and aligning efforts with organizational goals. Known for collaborative approach and commitment to excellence.
Overview
25
25
years of professional experience
Work History
Senior Manager, Business Intelligence
THE COCA-COLA COMPANY
Atlanta, GA
12.2021 - Current
- Led cross-functional teams to implement data-driven strategies enhancing decision-making processes.
- Developed and deployed advanced analytics solutions improving operational efficiency and reporting accuracy.
- Oversaw business intelligence initiatives aligning data insights with corporate objectives for strategic growth.
- Mentored junior analysts, fostering skill development and collaboration within the business intelligence team.
- Mentored junior analysts, fostering a culture of continuous learning and professional growth within the team.
- Streamlined data collection processes, resulting in improved data integrity and reduced turnaround times for reports.
Technical Lead
Tata Consultancy Services
Atlanta, GA
06.2020 - Current
- Led cross-functional teams to deliver complex software solutions on time and within budget.
- Designed and implemented scalable architecture for high-performance applications, enhancing system reliability.Support AIG Property and Casualty group in the design, development and delivery of MicroStrategy report enhancements.
- Consulted with business partners in gathering requirements for performance enhancements and establishing thresholds for measuring performance enhancements.
- Translated requirements into technical specifications and communicated to off-shore resources in order to complete development.
- Coordinate with off-shore resources and QA team in testing and defect resolution.
- Coordinate meetings and presentations to stakeholders during knowledge transfer or issue resolution sessions.
- 5 years 9 months
Technical Architect
Tata Consultancy Services
Atlanta, GA
11.2018 - 01.2020
- Led FP&A team in the design, development and maintenance of online Tableau reports and dashboards.
- Maintained 20+ daily, monthly, and quarterly Tableau reports which are utilized by the Merchandising finance team during regular reviews with leadership.
- Gathered requirements from FP&A Decision Analytics team for the development of tables and views within Google Cloud Platform to support dashboards and reports.
- Designed and maintain processes to integrate data from Excel and DB2 into Google Cloud platform.
- Supported the Home Services team in the development and maintenance of Countertop Installation Cycle-Time reporting to monitor vendor eligibility for incentive payouts.
- Supported the Home Services team in the development and maintenance of vendor job site inspection reporting to facilitate the assessment of fines based on violations of policy.
- 1 year 2 months
Manager, Reporting and Analytics
The Home Depot, INC
Atlanta, GA
01.2010 - 01.2018
- Led team of 5 analysts in the design, development and maintenance of online MicroStrategy reports to support HR organization.
- Designed and developed reporting via MicroStrategy 10.x to support the Manager Self Service function.
- Designed and developed attributes, facts, logical tables, transform tables, metrics and intelligent cubes to support dynamic dashboards within MicroStrategy Architect.
- Designed ETL processes that aggregated large HR data sets and removed sensitive data for use within BI solutions.
- Identified actionable and critical metrics, developing first generation HR dashboards for HR leadership.
- Identified opportunities to consolidate legacy reporting and implemented changes to create single client interface.
- Provided Project Management expertise, guiding HR teams through development, QA, and implementation of HR solutions.
- Built and maintained relationships with IT partners, effectively leveraging resources during reporting implementations.
- Utilized MicroStrategy Architect to migrate components between development environments and coordinated with IT resources for production migrations.
- 8 years
Compensation Manager
The Home Depot, Inc.
Atlanta, GA
01.2006 - 01.2010
- Developed compensation strategies to align with organizational goals and market trends.Managed regular analysis and maintenance of store pay ranges for US Retail and Supply Chain. Provided production support for Compensation and Performance Management applications.
- Led initiatives to update compensation policies reflective of current best practices in the industry.
- Streamlined the annual merit increase process, resulting in more efficient distribution of funds across all departments.
- Collaborated with HR leadership to refine performance evaluation processes and reward systems.
- Served as lead Compensation resource in redesign and implementation of proprietary compensation and performance management system that allowed for data entry of 400K+ performance reviews annually.
- Served as technical liaison between Compensation, IT and external vendors during process and system enhancements ensuring seamless operations.
- Coordinated with HR Reporting to implement reporting solutions that securely provided associate Performance Management and Compensation information across the enterprise.
- 4 years
Senior Business Analyst
The Home Depot
Atlanta, GA
01.2003 - 01.2006
- Designed, implemented, and maintained LDAP structure used to secure internal associate site and access to ESS / MSS functionality.
- Coordinated rollout of LDAP groups to all 1.9K+ enterprise servers providing store user access to HR applications.
- Streamlined LDAP process and eliminated several daily maintenance tasks, including drastically reducing volume of tickets received each day.
- 3 years
Information Analyst
The Home Depot
Atlanta, GA
01.2001 - 01.2003
- Supported multiple HR functions with development and implementation of enterprise standard and ad-hoc reports.
- 2 years
Education
MBA - Information Technology
Georgia State University
Atlanta, GA05-2004
BBA - Management Information Systems
University of Georgia
GASkills
- Report design
- Training and mentoring
- Team management
- ETL development
- Data quality assurance
- Data governance
- Technical leadership
- BI tool proficiency
- Dashboard creation
- ETL processes
- Report development
- Teamwork
- Problem-solving
- Attention to detail
- Critical thinking
- Team leadership
- Business process improvement
- Process improvement
Timeline
Senior Manager, Business Intelligence
THE COCA-COLA COMPANY
12.2021 - Current
Technical Lead
Tata Consultancy Services
06.2020 - Current
Technical Architect
Tata Consultancy Services
11.2018 - 01.2020
Manager, Reporting and Analytics
The Home Depot, INC
01.2010 - 01.2018
Compensation Manager
The Home Depot, Inc.
01.2006 - 01.2010
Senior Business Analyst
The Home Depot
01.2003 - 01.2006
Information Analyst
The Home Depot
01.2001 - 01.2003
MBA - Information Technology
Georgia State University
BBA - Management Information Systems
University of Georgia