Terrence Mclemore
Houston,TX
Summary
Qualified IT Professional with 9+years of total experience including 7+ years of experience as a Data Analyst with a track record of driving business growth through ambitious strategies that increase sales, market share, and market penetration. Effective driver of product development lifecycle from concept to delivery. Understanding customer requirements and translate into actionable project plans. Ability to work independently and as part of a group. Aptitude for learning and rapidly mastering whilst adapting to new applications and technology. Proactive, goal-oriented and dynamic professional with passion for Big Data with real-time problem-solving flexibility.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Business Data Analyst
Farmers Insurance
07.2022 - Current
- Operate analytical and statistical tools such as SSAS, SSIS, and Tableau, gather, extract, manipulate, analyze, and model data
- Discover new data sources and techniques for beber data collection, interpretation, and reporting
- Generate Complex reports to document and evaluate system operations involving everyday data sets
- Experience with MS-SQL Server T-SQL production and performance tuning for reporting required queries
- Knowledge of data warehouse techniques, methods, logging, and dimensional modeling
- Use Tableau, to design and build business intelligence and data analysis reports to provide business insights
- Day-to-day problem-solving, reporting, communication, and interpersonal skills, as well as the ability to handle time and tasks while working in a variety of (technical/business) sebings and provide end-user training
- Built deep cross-organizational partnerships, partnering with teams to further exploit data to obtain market insights that affect business decisions
- Worked individually with the customer and was proactive in the implementation of deliverables
- Using PowerPoint, provide HR Team with ongoing, deadline-driven assistance for employee and benefits-related parts on VIC
- Configure and update reports on the status of agreed-upon success metrics for the Planner, Team Leader, and Department Head using PowerPoint regularly.
Data Analyst
Regions Bank
03.2021 - 06.2022
- Developed, created, and deployed business intelligence (BI) solutions for data, finance, and accounting (e.g
- Reporting tools)
- Experience of ETL and Data Warehousing principles, as well as incremental loads
- Maintained and supported data analytics platforms, converting business requirements into technical specifications, created dashboard reports from relational databases, and developing data storage tools (e.g
- OLAP cubes)
- Restored and managed various types of data for data integration operations and writing user stories, including OLTP, OLAP, Excel, XML, CSV, and Flat files
- Evaluated and upgraded existing business intelligence systems, as well as developed and executed database queries, conducted evaluations, and performed unit testing and troubleshooting
- Collaborated with teams to implement processes, build, and update technical documents, and generate visualizations and reports for requested projects
- Analyzed available data, collaborate with business users to collect data and report criteria, identify data sources to extract business data for reporting, and identify and suggest the best sources for creating reports
- Diagnosed best practices and suggested improvements for communicating metrics through dashboards, as well as coordinating with the business team on additional data marts to support dashboard reporting, including data validation collaboration with business users
- Developed complex reports ensuring that the application's synchronization with other systems, such as the customer information system, asset management system, and mobile workforce management system, was effective
- Intense analytical skills, including the ability to gather, compile, interpret, and disseminate large quantities of data while paying close abention to detail and accuracy
- Generated TSQL queries, stored procedures, functions, and views, as well as review and troubleshoot them
- Used Excel, Power BI, and Tableau to devise, manufacture, and deploy data, financial, and accounting BI solutions (e.g
- Reporting tools).
Data Analyst
Apple
11.2017 - 02.2021
- Used Office 365, MS Word, Excel, Access, SharePoint, MS SQL 2014, Data Processing, and Data Entry, MS Visio, and SAS for Statistical Analysis
- Composed, analyzed, and troubleshot TSQL queries, stored procedures, functions, and views
- Managed analytical and statistical methods to capture, extract, manipulate, evaluate, and model data
- Detected new data sources and approaches for beber data collection, interpretation, and reporting
- Filtered and 'cleaned' data by analyzing reports and performance metrics to identify and address code issues
- Produced executive-level presentations to highlight important learnings and opportunities
- Established deep cross-organizational partnerships by collaborating with teams to beber exploit data and gain market insights that affected business decisions
- Comprehension of SQL-Server Catalog for SSIS -Package deployment and automation
- ETL-Jobs that are not working (DataStage and SSIS)
- Provided Line of Business staff with coaching opportunities and ensured that they adhered to Regulation B policies as well as other procedural and regulatory regulations
- Designed reports and dashboards using Tableau software
- Originated reports using a range of filters, including cascading and data source filters
- Assured the development and maintenance of projects with a variety of parameters, including database joins hierarchies, measured fields, behavior, and maps
- Educated clients how to use Salesforce and its services through customer and administration training sessions.
Education
Bachelor's Degree - Data Science
University of North Texas
Denton, TexasAssociates Degree - Computer System and Information Technology
North Central Texas College
Denton, TexasSkills
- Data Cleaning
- SQL Server Integration Services
- ETL development
- SIX SIGMA
- SQL Programming
- Natural Language Processing
- Machine Learning
- HTML and CSS
- Data Mining
- CRM Systems
- KPI Tracking
- MS Office Suite
- JIRA
- R Programming
- Data Quality Assurance
- SSIS
- SSRS
- Python Programming
- Tableau Software
- Oracle 10g DBMS
- Data Analysis
- Gap analysis
- SAP
- Power BI
- SCRUM
- Analytical Skills
- SharePoint
- SQL Visual Studio
- SQL Management Studio
- Data Mapping
- Cluster Analysis
- Advanced Excel
Certification
- Microsoft Certified Technology Specialist - SQL Server 2016
- Certified Analytics Professional (CAP)
- Microsoft Certified: Data Analyst Associate
- Agile (Scrum)
- ITIL Foundation Framework
- Help Desk Certification
- Scrum Product Owner
- Tableau
Timeline
Business Data Analyst
Farmers Insurance
07.2022 - Current
Data Analyst
Regions Bank
03.2021 - 06.2022
Data Analyst
Apple
11.2017 - 02.2021
Bachelor's Degree - Data Science
University of North Texas
Associates Degree - Computer System and Information Technology
North Central Texas College
- Microsoft Certified Technology Specialist - SQL Server 2016
- Certified Analytics Professional (CAP)
- Microsoft Certified: Data Analyst Associate
- Agile (Scrum)
- ITIL Foundation Framework
- Help Desk Certification
- Scrum Product Owner
- Tableau
Similar Profiles
Travis NorthupTravis Northup
Senior Field Claims Representative at Farmers InsuranceSenior Field Claims Representative at Farmers Insurance
Marla AllenMarla Allen
Senior Customer Service Associate at Farmers InsuranceSenior Customer Service Associate at Farmers Insurance
Alan LawsAlan Laws
Insurance Agent – Sales Agent at Farmers InsuranceInsurance Agent – Sales Agent at Farmers Insurance