Jerrad Germano
Data Analyst at Pickett and Associates, LLC- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
Pickett and Associates, LLC
-
United States
-
Public Relations and Communications Services
-
1 - 100 Employee
-
Data Analyst
-
Jul 2022 - Present
Tampa, Florida, United States • Utilizes Power BI to develop interactive dashboards and reports, enabling teams to track key performance indicators and make informed decisions. • Designs, develops, and automates custom Power Apps and Power Automate solutions, streamlining data entry and reporting processes for enhanced user productivity. • Presents findings to senior management, influencing strategic decision-making and contributing to business growth.
-
-
-
Corestream
-
United States
-
Software Development
-
100 - 200 Employee
-
Product Support Analyst
-
Apr 2021 - Jul 2022
Tampa, Florida, United States • Oversaw data file exchanges for completion, technical requirements, and file transmission protocol. • Led data cleaning and preparation efforts, ensuring data accuracy and integrity for reporting and analysis purposes using SQL. • Created visually appealing and user-friendly dashboards using Power BI, enhancing data accessibility and enabling self-service analytics.
-
-
-
Charter Communications
-
United States
-
Telecommunications
-
700 & Above Employee
-
Billing Design Analyst
-
Oct 2020 - Apr 2021
Charlotte, North Carolina, United States • Worked intimately with business owner/requestors or design architecture on understanding requirements and documenting requirements. • Performed analysis on billing systems, billing data, and processes in order to determine the best billing design and solution. • Ran SQL queries (Oracle) and pulls billing data to support analysis and billing design. • Designed solutions for MEC (Master Enterprise Catalog) to support the Gateway system.
-
-
-
Colonial Life
-
1 - 100 Employee
-
Customer Data Analyst
-
Mar 2020 - Oct 2020
Columbia, South Carolina, United States • Analyzed data files provided by our large case customers, which includes manipulation of data, utilizing PC based tools such as Excel or text editor, VBA, OCR as well as Microsoft Access. • Prepared, audited, and sent to accounts an electronic return file that includes benefits selections and payroll deductions captured during the enrollment process. • Captured and reported to management all service, technical and customer trends resulting from regular customer contact. Present and/or… Show more • Analyzed data files provided by our large case customers, which includes manipulation of data, utilizing PC based tools such as Excel or text editor, VBA, OCR as well as Microsoft Access. • Prepared, audited, and sent to accounts an electronic return file that includes benefits selections and payroll deductions captured during the enrollment process. • Captured and reported to management all service, technical and customer trends resulting from regular customer contact. Present and/or validate new E-Services concepts or enhancements from our customers’ perspective.
-
-
Billing Coordinator
-
Jul 2018 - Mar 2020
Columbia, South Carolina Area • Managed ongoing enrollment by communicating coverage information (underwriting and deduction information) to plan administrators, brokers, or TPAs. • Performed comprehensive audits on enrollment activity, premium remittance and allocation compensation, validation and policy changes. • Provided problem solving consultation on products, planning, schedule analysis and issue resolutions to policyholders, plan administrators, field partners, brokers, and TPAs.
-
-
Account Services Specialist
-
Mar 2016 - Jul 2018
Columbia, South Carolina Area • Provided timely and accurate insurance information to sales agents thereby increasing profit. • Rectified various client service requests using internal software and processes. • Cross-trained in insurance claims, billing, and customer service, creating a diverse and adaptable background.
-
-
-
Southern Valet
-
United States
-
Public Relations and Communications Services
-
1 - 100 Employee
-
Valet
-
Aug 2012 - Mar 2016
Columbia, South Carolina Area • Administered careful and excellent care of customer vehicles at fine dining restaurants and entertainment venues. • Worked during college to help finance my education.
-
-
Education
-
University of South Carolina-Columbia
Bachelor of Science - BS, Business Administration and Management, General -
Midlands Technical College
Database Analyst Program, Database Analysis -
College of Charleston
Business Administration and Management, General, 3.6 -
Midlands Technical College
Associate of Science - AS, Science -
Universidad del País Vasco/Euskal Herriko Unibertsitatea
Intensive Spanish Immersion Program at the San Sebastián Campus, Spanish -
Tech Talent South
Data Science