đŸ“ˆLaurence F. S.

đŸ“ˆLaurence F. S. Email and Phone Number

HR Data Management and Analytics Specialist @ Delta Air Lines
Atlanta, GA, US
đŸ“ˆLaurence F. S.'s Location
Atlanta, Georgia, United States, United States
đŸ“ˆLaurence F. S.'s Contact Details

đŸ“ˆLaurence F. S. work email

đŸ“ˆLaurence F. S. personal email

About đŸ“ˆLaurence F. S.

My comments are my own and do not reflect the views or ideas of Delta Air Lines.As a Data Analytics Specialist, I design and implement HR Service Delivery reports and analytics as well as the data conversion, development, and maintenance of HR data sources and pipelines. Including but not limited to report development, analytics presentation development, data conversion processes and projects, and technical support for HR data needs.Identity Access Management (IAM): • SailPoint IdentityIQ platform (create, manage, and approve system access)Tableau Solutions:• Strong understanding of Tableau best practices, constraints, and limitations• Data gathering, cleaning, analysis, story conveyance, governance, modeling, integration, auditing, dashboard creation, requirements gathering, improve visualization efficiencies, and performance.• Desktop Professional, Cloud-based Prep Builder, AWS Site Administrator and Tableau Cloud (all current versions), Tableau Beta ProgramGenerative AI queries Excel and Power BI Reporting:• Data cleaning, querying, and transformation• Creating custom reports using Data Analysis Expressions (DAX) functions.• Data Modeling and Data Integration with the Transformation Data (Query Editor) featureAlteryx Designer and Server:• Data gathering, preparation, blending, creation, modeling (prototyping and workflow)• Automation framework, filtering, spatial, migration, integration, and Extract, Transform and Load (ETL)• Server (workflow scheduling, private team gallery workflow/app creation, and departmental app collection management)Coding Technology: • MySQL, T-SQL, MS SQL Server, PL-SQL, MS Studio Management (versions 18 and higher) with Azure• Visual Studio for SS Integration Services, Oracle Hyperion Brio Interactive Reporting StudioCoding Editors: SAP HANA Studio and MS SQL Server Management Studio (SSMS)Microsoft Office & Apps• Excel (Pivot Tables, V-Lookup, Macros, Slicers, Index, Match, 3D Maps)• Excel Data Modeling (Power Pivot and Power Query)• Access Data Base, Visio, PowerPoint, Outlook, Microsoft (Office) 365, Microsoft (Office) ProPlus (Enterprise), and Microsoft Word.

đŸ“ˆLaurence F. S.'s Current Company Details
Delta Air Lines

Delta Air Lines

View
HR Data Management and Analytics Specialist
Atlanta, GA, US
Website:
delta.com
Employees:
78100
đŸ“ˆLaurence F. S. Work Experience Details
  • Delta Air Lines
    Hr Data Management And Analytics Specialist
    Delta Air Lines
    Atlanta, Ga, Us
    View
  • Delta Air Lines
    Data Analyst Specialist
    Delta Air Lines Apr 2024 - Present
    Atlanta, Georgia, Us
    Reporting and Analytics: • Compile the reporting and analytics deliverables, including the implementation of standardized recurring reports, ad hoc queries, analytics presentations, dashboards, and data models. • Work with internal customers to understand their people data requests, attain necessary approvals to release sensitive information, and prioritize delivery dates. • Coordinates cross department and external vendor discovery and requirement gathering sessions to define end-to-end Human Resources data requirements. Ensures accuracy and final quality review of all analytics and reports. • Provide support for the administration and reporting of special programs as they are developed and implemented. This could include special or recurring benefit and compensation programs, time management, talent management and talent acquisition.
    View
  • Delta Air Lines
    Hr Data Analytics Specialist
    Delta Air Lines Sep 2022 - Apr 2024
    Atlanta, Georgia, Us
    Reporting and Analytics: • Compile the HR reporting and analytics deliverables, including the implementation of standardized recurring reports, ad hoc queries, analytics presentations, dashboards, and data models. • Work with internal customers to understand their people data requests, attain necessary approvals to release sensitive information, and prioritize delivery dates. • Coordinates cross department and external vendor discovery and requirement gathering sessions to define end-to-end HR data requirements. Ensures accuracy and final quality review of all analytics and reports. • Provide support for the administration and reporting of special programs as they are developed and implemented. This could include special or recurring benefit and compensation programs, time management, talent management and talent acquisition.
    View
  • Delta Air Lines
    Business Analyst Iii
    Delta Air Lines Dec 2020 - Sep 2022
    Atlanta, Georgia, Us
    A Senior Business Analyst on a client-based team part of the Global Human Resources (HR) Analytics and Reporting Group. Working on multi-functional projects including developing end-to-end executive Tableau and Power BI dashboards for multiple business unit stakeholders within HRSD (Human Resources Services Delivery).Day to day responsibilities:* Execute on reporting and analytical roadmaps in a team context* Partner with other groups to support downstream productionization and deployment of analytics (Tableau HR Site Administrator with dashboards, Alteryx (Designer and Server Admin of HR gallery) workflows and apps, SAP HANA, T-SQL, SAP BI/BW, Power BI Reporting and Oracle Hyperion Brio Interactive Reporting Studio - BQY files)* Provide technical leadership to business units, particularly business units that are partnered with Global HR teams* Mentor junior developers on Tableau and Alteryx architecture, and process improvements* Support the Analytics and Reporting Director, Manager and team* Partnership with Tableau Server Admin to test, migrate and upgrade server/desktop from older version to a recent version Utilizing BI Tech with HRIS platforms:1. Tableau (Desktop, Site Administrator, and Prep Builder)2. Alteryx (Designer, Automation, and Server Scheduling)3. SQL (SSMS and SSDT) and Visual Studio 20194. SAP BI/BW (SAP Analysis for Microsoft Office)5. SAP HANA (Row-Level Security User Access for Tableau)6. Teradata (SQL and EDW)7. Oracle Hyperion Brio Interactive Reporting Studio8. Power BI Reporting Development
    View
  • Sole Proprietor
    Tableau Developer
    Sole Proprietor Aug 2020 - Dec 2020
    My areas of expertise were:1. Tableau Developer (Desktop and Cloud)2. Tableau Consultant (Improving Visualization Performance)3. Data Blending, Data Prototyping and Workflow4. Extract, Transform and Load (ETL)5. Data Modeling (Alteryx and Tableau Prep Builder)
    View
  • Sole Proprietor
    Senior Business Intelligence Analyst
    Sole Proprietor Jan 2020 - Aug 2020
    Providing Platform as a Service (PaaS): Reporting tools as a Business Intelligence Analyst with capabilities in the following areas: Data Extraction (or ETL) using Alteryx and SSIS, Data Mining, Data Visualization (Tableau and Power BI), Advanced Excel, APIs and SQL coding (MS SQL server 2019).• Performed web-scraping to Excel (per client requirement: using APIs with Power Query)• Developed Tableau dashboards using client provided web data (APIs with Data Mining)• Provided consultation to client on Data Migration (to Data Mart) with best practices• Automated data migration from IBM DB2 to SQL Server DB using SSIS for Power BI analysis for client• Tutored clients on Tableau, Alteryx and Power BI (Business Intelligence Tools and Visualizations)• Designed multiple Tableau dashboards to track inventory with location data, order processing, sales, specialized packaging and shipping. Data sources were Azure and Shopify (with limited ksync).
    View
  • Ncr Corporation
    Business Operations Data Analyst
    Ncr Corporation 2017 - 2018
    Atlanta, Georgia, Us
    Successfully applied optimization, enhancements, standardization on multiple Tableau workbooks to ensure maximum dashboard performance. Created framework to document data source connections between EDW (Enterprise Data Warehouse) and Tableau dashboards. • Worked in Agile Scrum environment (user story grooming, sprint planning, sprint retrospective)• Performed detailed data quality analysis using various data sources and tools (Tableau, JIRA, Excel, Power Query, Power Pivot, PowerBI, Python, PL-SQL, Teradata SQL, T-SQL, Alteryx on large data sets greater than 100 million records for business unit).• Assisted on Tableau projects and developed business dashboards with UAT.• Audited all Tableau workbooks for quality on Tableau server to gain insights and understanding of the data sources. The objective: to prepare for various data source optimizations and migrations. • Conducted an analysis on the Tableau workbooks to improve efficiency and visualization performance. The objective: to reduce visualization rendering wait time to less than 30 seconds.
    View
  • State Road & Tollway Authority
    Data Quality Analyst
    State Road & Tollway Authority 2012 - 2017
    Atlanta, Georgia, Us
    Performed multiple job responsibilities for this State of Georgia Authority. Hired initially as a Quality Analyst and promoted rapidly into a Data Analyst/Developer role.Quality Analyst (on the Process Improvement team)• Worked in Agile environment• Created, edited business requirement documents and performed User Acceptance Testing (UAT) for all toll-road integrated system reporting. • Created test cases (UAT) and Quality Assurance (QA) checks to improve and monitor reporting capabilities.• Participated on a project to migrate all ticket data from Zendesk to ServiceNow, established KPIs (Key Performance Indicators), participated in project with bundled payments (PCI DSS-payment card industry data security standard) for express toll lanes and commuter bus transit and benchmarks for all business units. • Worked in Agile environmentData Analyst/Developer (on Transportation Performance and Innovation team) • Worked in Agile environment• Performed detailed data analysis using various data sources and tools - Tableau, Excel, Power Query, Power Pivot, PowerBI, Alteryx, SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services) on large data sets.• Created and maintained all Alteryx workflows used to create data extracts for the Tableau dashboards. • Utilized Tableau Subject Matter Expertise to provide insight on the Georgia Express Lanes project reporting.• Worked on Data migrating project to migrate ticket data from Zendesk to ServiceNow. Project entailed verifying, updating, migrating all relevant ticket data and CRM (Client Relationship Management) information from Zendesk to ServiceNow using APIs.• Applied embedded analytics through APIs to add Tableau dashboards to external website for external affairs.• Performed consulting, data and business analysis for the Joint Customer Service Center using APIs to access data for both agent and IVR (Interactive Voice Response) call data.
    View
  • Bank Of America
    Senior Operations Analyst, Officer - Atlanta Treasury (Lockbox) Operations
    Bank Of America 2008 - 2011
    Charlotte, Nc, Us
    Provided support and analysis of existing Treasury Payment Systems to create and update into more efficient processes such as extracting raw data from disparaging large database datasets using MS Excel and MS Access converting into a trackable format to increase reporting productivity. Increased efficiency by simplifying and consolidating associate procedures of data collection processes for billing.Key Achievements:• Executed an image-based mail sorting and extraction process with Systems Development Life Cycle for the operations site.• Created and implemented a state-wide process for deposit and settlement of handling cash received in error at the operations site.
    View
  • Bank Of America
    Senior Operations Analyst, Officer – Business Support Southern Region Check Operations
    Bank Of America 2007 - 2008
    Charlotte, Nc, Us
    Researched and developed resolutions covering a wide scope of issues within the Business Support Southern region. Lead contact for all report analysis. Extracted and converted raw data from large database datasets into usable formats for tracking and productivity reporting.Key Achievements:• Administered training for procedural, technical, and operational changes to site management.• Developed and published established weekly and monthly reports to track regional operations and image processes.
    View
  • Bank Of America
    Operations Analyst, Officer - Check Operations
    Bank Of America 2005 - 2007
    Charlotte, Nc, Us
    Report analysis lead contact. Developed and implemented resolutions covering a large variety of issues within the site. Presented procedural, technical, and operational training to site management covering updates and changes. Prepared and published ad-hoc reports that research, analyze, and provide resolutions to issues within the system.• Implemented temporary check image storage in collaborated with Image Project teams. • Developed an Access database for tracking productivity, check volume, and internal operational float.
    View
  • Bank Of America
    Operations Team Manager, Officer - Check Operations
    Bank Of America 2001 - 2005
    Charlotte, Nc, Us
    Supervised and managed employees in two departments and researched and resolved day-to-day issues. Devised a solution to decrease internal operational float and operational productivity by addressing the issue of late flight arrivals through collaboration with all business stakeholders. Assisted in reducing the number of rejected checks in a Greenbelt project.• Created and implemented architectural floor plans improving continuous process design and Six Sigma Lean workflow for two departments.• Project lead for the Electronic Check Presentment (ECP) and Image Cash Letter (ICL) initiatives.
    View
  • Bank Of America
    Various Positions - Check Operations
    Bank Of America 1996 - 2001
    Charlotte, Nc, Us
    Performed multiple job responsibilities for Bank of America during these years.(Quickly Promoted Due To Exceptional Performance)Entry-Level Positions:• Accounting Specialist 3 (1996-1997)• Operations Support Liaison (1997-1998)• Group Lead Operations Supervisor (1998-2001)Management-Level Positions:• Operations Team Manager, Officer (2001-2005)• Operations Analyst, Officer (2005-2007)• Senior Operations Analyst, Officer - Business Support (2007-2008)• Senior Operations Analyst, Officer - Treasury Operations (Lockbox) (2008-2011)
    View
  • Nationsbank
    Accounting Operations Specialist
    Nationsbank 1995 - 1996
    Washington, District Of Columbia, Us
    Performed basic level account reconciliation on work from the Federal Reserve System, Corporate sales, Wholesale and Commercial Banks across the United States.
    View
  • Wachovia Corp
    Accounting Operations Specialist
    Wachovia Corp 1994 - 1995
    Charlotte, North Carolina, Us
    Performed basic level account reconciliation and preparation for shipment of paper transaction items (checks) to the Federal Reserve System, Wholesale and Commercial Banks across the United States.
    View

đŸ“ˆLaurence F. S. Skills

Acts Consulting H Lookup Service Desk Jira Procedural Image Processing Finance Tableau Convert Miami Site Management Minitab Programming Database Applications Cross Functional Team Leadership Facilitation Windows Xp Windows 7 Data Conversion Florida Requirements Gathering Float Management Bpmn Design General Ledger Computer Science Calls Sql Server Reporting Services Statistics Reconcilement Integration Data Mining Script Creation Analyzer Microsoft Power Bi Leadership Data Storage Sorting Feed Aviation Powerpoint Monitors Requirements Analysis Lean Manufacturing Accounting Sdlc Workflow Brio Query Sharepoint Microsoft Powerpoint Settlement Ecp Federal Reserve Load Forecasting Crystal Reports Trade Unions Continuous Process Atlanta Team Management Reports Alteryx Account Reconciliation Information Extraction Hyperion Microsoft Office Data Modeling Sql Server Integration Services Tables Microsoft Excel Transportation Testing Asset Management Risk Management Training Customer Service Extract Client Advocate Image Scripting Analytical Skills Project Management Shareholder Research Reporting Incident Call Centers Operational Support Problem Management Data Visualization Partnerships Analysis Access Data Integration Cpcs Emergence Query Analyzer Operations Research Banking Technology Retail Drives For Results Dax Applications Maximo Data Analysis Data Collection Business Analysis Communication Advertising Erp Strategic Planning Customization Operations Macro Microsoft Access Lockbox Technical Information Vba Credit Checks Time Management Floor Plans Change Management Business Intelligence Communications Management Sql Project Continuous Process Improvement Distribution Center Operations Business Process Improvement Datasets Vendor Relationship Management Analytics Paper Sap Bi/bw Linkedin Internal Audit Six Sigma Means System Conversion Project Teams Banking Business Intelligence Tools Data Warehousing Control Charts Personnel Management Level 2 Powerpivot Lotus Notes Sql Server Analysis Services Microsoft Azure Microsoft Sql Server Electronics Data Analytics Office 2013 Process Improvement Data Quality Visio Control Systems Design Software Pivot Tables Sas Image Capture Outlook Microsoft Power Query Microsoft Word Information Science Microstrategy Cash Proprietary Software Ach Platforms Invoicing Interpersonal Skills Team Motivation Business Strategy Problem Solving Mail Sorting Debit Cards Transform Automation Performance Management Databases

đŸ“ˆLaurence F. S. Education Details

  • Emory University
    Emory University
    Certification In Business Intelligence
  • Morris Brown College
    Morris Brown College
    Computer Information Science (Cis)

Frequently Asked Questions about đŸ“ˆLaurence F. S.

What company does đŸ“ˆLaurence F. S. work for?

đŸ“ˆLaurence F. S. works for Delta Air Lines

What is đŸ“ˆLaurence F. S.'s role at the current company?

đŸ“ˆLaurence F. S.'s current role is HR Data Management and Analytics Specialist.

What is đŸ“ˆLaurence F. S.'s email address?

đŸ“ˆLaurence F. S.'s email address is la****@****ork.com

What schools did đŸ“ˆLaurence F. S. attend?

đŸ“ˆLaurence F. S. attended Emory University, Morris Brown College.

What skills is đŸ“ˆLaurence F. S. known for?

đŸ“ˆLaurence F. S. has skills like Acts, Consulting, H Lookup, Service Desk, Jira, Procedural, Image Processing, Finance, Tableau, Convert, Miami, Site Management.

Who are đŸ“ˆLaurence F. S.'s colleagues?

đŸ“ˆLaurence F. S.'s colleagues are Callie Sorensen, Susan Connors, Donovan Brown, Stephen Smith, Janalee Sullivan, Sheniqua Charles, Sheryl Berghofer.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.