Trammell C Wilson
Minneapolis, MN 55412
Professional Summary:
Over 10+ years' experience with Data Analyst.
Practical experience creating dashboards, running Tableau Server, and using Tableau to look for patterns and useful information in data.
Developed data collection and navigation desktop and mobile apps in Microsoft Power Apps, as well as Power BI.
Applied pertinent statistical methods to research data using SAS and SAS tools for statistical analysis and data management.
Developed test cases that adhered to functional specifications, and manually tested the entire program, including both positive and negative testing.
Developed SQl queries to enhance performance, identifying critical areas for automation to smooth company operations, reviewing and fixing process flaws, and creating reference materials or reports for the completed project.
Professional Experience:
Wells Fargo (Remote) November 2022 – February 2023
Data Analyst/Developer
Create, update and maintain standard SAS code for auto remediation customers.
Ensures that the data assets are supported by its information technology architecture and documentation.
Office Skills, Analytics including SAS, Teradata
Knowledge and understanding of regulatory agencies: Federal Reserve and OCC
Audit or internal controls testing experience.
Experience evaluating control deficiencies and related remediation activities.
Experience with relationship building and collaboration with stakeholders spanning multiple levels from staff level to senior and executive management.
Created SQL queries to examine databases and access backend data.
Altering SQL queries to enhance performance, identifying critical areas for automation to smooth company operations, reviewing and fixing process flaws, and creating reference materials or reports for the completed project.
CIGNA/EverNorth (Minneapolis,MN) July 2007 – August 2021
Senior Data Specialist
Data extractions using SQL and SAS
Perform adhoc reporting, establish and maintain complex coding.
Data scrubbing for ETLs and update in accordance with policy changes
Translate legal, medical, and insurance-related jargon into layman's terms for clarification purposes.
Create reports based on identification, outcomes and engagement to gage program effectiveness.
Collaborate with stakeholders on reporting needs and creations dashboards.
Working knowledge of designing dashboards, managing Tableau Server, and using Tableau to analyze data to find patterns and insightful information.
Experience in creating visualizations for the data extracted with the help of Tableau, identifying patterns and meaningful insights from data by analyzing it, designing dashboards, and managing Tableau Server.
Perform data analysis on project tasks for the business, ad hoc reports, and scorecards.
Successfully address cross-data and cross-platform data issues.
Develop partnerships with other departments and teams.
Able to effectively communicate technical information to audiences, including senior management and stakeholders.
Effectively communicate outcome information to numerous audiences, including senior management, the user community, and less-experienced staff.
Leverage experience with data, including background in Healthcare Data, Data Modeling, and Data Governance.
Transform complex customer reporting requirements into effective, efficient reports.
United Healthcare 1997-2007
Research Reporting Analyst
Data extraction knowledge with SQL.
Strong communication and written skills.
Analytical coding and problem-solving skills.
Recommend data strategies based on requirements.
Analyze data issues and for systems support.
Over 13 Years Developing and adhoc Reporting experience for various reasons from engagement to outcomes.
Skills:
SAS
Teradata
Tableau
SQL
COGNOS
Power BI
Education:
Computer Science Technical Diploma, 1999
Computer Learning Center, Chicago, Ill