Data Analyst Senior

Carol Perez, BBA

210-***-**** ***********@*********.*** San Antonio, TX 78254 LinkedIn

SENIOR DATA ANALYST

Dynamic, results-driven, detail-oriented Senior Data Analyst with over 20 years of experience in data management and analysis, specializing in providing actionable insights and optimizing data processes. Adept at leveraging advanced SQL scripting and Power BI to deliver comprehensive reporting and analytics that support strategic decision-making and exceed expectations. Proven ability to mentor teams, manage complex data projects, and build strong client relationships, with a track record of driving significant business improvements and operational efficiencies.

Recognized for successfully leading initiatives such as developing a robust reporting process during the COVID-19 Fiber Sales campaign, enhancing metadata efforts during a database transition, and improving data accuracy and sales reporting through standardization of vendor spreadsheets.

Skills Profile

Data Analysis & Interpretation Data Visualization & Reporting Data Quality & Integrity

Stakeholder Collaboration Problem-Solving & Diagnostics Project Management

Cross-Functional Collaboration Teradata, TOAD, Snowflake POWER BI

Leadership & Team Building Staff Training & Development Continuous Learning

PROFESSIONAL EXPERIENCE

AT&T Consumer Products San Antonio, TX 8 /2018 – 7/2024

Senior Data Analyst

Led comprehensive data analysis to provide strategic insights supporting decision-making across the organization. Serving as Power BI Administrator, ensured efficient management of data processes while supporting data clients. As subject matter expert for Legacy Consumer Products, mentored colleagues and leveraged deep expertise in product knowledge and processes to drive business success and optimize operations.

Achievement Highlights:

Provided actionable insights enabling company to measure effectiveness of Fiber Sales Door Hanger campaign during COVID by developing a comprehensive reporting process tracking sales success by key parameters, leading to 20% increase in targeted sales conversions despite staggered campaign starts.

Successfully incorporated data from new application into reporting process, fulfilling client request within two weeks after completing training and gaining access, allowing team to handle previously impossible data requests.

To accommodate transition to alternate database application, led metadata effort and creation of comprehensive data dictionary, increasing description completion rate from 6% to 93% across 350 tables and 14,000 fields and significantly enhancing data clarity.

Group O & TEKsystems @ AT&T San Antonio, TX 1/2006 – 8/2018

Database Analyst

Consolidated, analyzed, and managed data to support clients, management, and business needs. Utilized advanced SQL scripting and Excel to create and maintain reports, delivering insightful analytics to both internal and external clients. Built strong client relationships by addressing report enhancement requests and translating stakeholder requirements into actionable reporting deliverables. Managed multiple projects, developed data warehousing solutions, troubleshot reporting issues, and provided business recommendations based on thorough data evaluation. ensuring data quality and organization through advanced delivery technologies and data profiling.

Achievement Highlights:

Transformed inexperienced contractors into successful, independent workers by guiding them through data requests and providing support, leading to a retention rate of 100%.

By standardizing vendor-provided spreadsheets and introducing preformatted templates, improved data accuracy and uncovered $200,000 in unreported monthly sales and $2M increase in vendor revenue while identifying product sales stuck in pending status due to incomplete customer self-installs.

Developed custom programs and managed databases to support various business needs. Created ad hoc reports, optimized SQL queries, and maintained database performance to ensure data integrity and availability. Collaborated with different teams to design and implement solutions for data-driven decision-making while handling troubleshooting, database tuning, and process automation.

PREVIOUS EXPERIENCE

General Manager – 3 Locations Liberty Tax Service San Antonio, TX

Data Analyst First American Claims Outsourcing San Antonio, TX

List Support Analyst West Corporation San Antonio, TX

EDUCATION

Master of Business Administration (MBA Program), Human Resource Management St. Mary’s University San Antonio, TX

Bachelor of Business Administration (BBA Program), Information Technology University of the Incarnate Word San Antonio, TX

Bachelor of Business Administration (BBA), Human Resource Management St. Mary’s University San Antonio, TX

TECHNICAL SKILLS

Essential Software Microsoft Office Suite, Power BI, SQL, Advanced Excel. Teradata, Snowflake, Toad

P

Contact this candidate