📈Laurence F. S. Email & Phone Number

Atlanta, Ga, Us

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.

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.

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

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)

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).

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.

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.

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.

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.

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.

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.

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)

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.

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.

Certification In Business Intelligence

Bachelor Of Science - Bs, Computer Information Science (Cis)