Tracy Velasquez's Location
Gardena, California, United States, United States
Tracy Velasquez's Contact Details
Tracy Velasquez work email
- Valid
- Valid
Tracy Velasquez personal email
n/a
Tracy Velasquez phone numbers
About Tracy Velasquez
I'm a geek adventuring in the world of data. My loves are numbers, coffee, and cat memes.
Tracy Velasquez Work Experience Details
-
OptumGardena, Ca, Us -
Sr Report AnalystOptum Sep 2022 - PresentEden Prairie , Mn, Us
-
Data AnalystSpoton Jan 2022 - Jul 2022San Francisco, California, Us• Using BI tooling, construct core dashboards, visualizations, and analyses to help stakeholders monitor product health and make better decisions • Own the definition of metrics and KPIs to enable the Product team to define and measure success ▪ Communicate insights to stakeholders distilling complex analysis into accessible learnings and deliver effective presentations to influence multiple levels of stakeholders • Use an analytical perspective to inform decision making and help drive a focus on the most impactful ideas across departments and be a trusted advisor to team members• Partner with Analytics Engineering to design and implement robust data models; Understand our data collection methodologies, how our data is structured and transformed, and how metrics are defined in our analytics platform• Define and improve data structure & transformations and/or dashboards practices and processes with an emphasis on automation -
Data AnalystLeaf Group Feb 2021 - Jan 2022Santa Monica, Ca, Us• Create complex SQL queries and perform ad-hoc and exploratory data analysis• Provide data-driven insights to marketing, operations, and product teams• Create data visualizations using Tableau• Develop, own, and present dashboards to Senior Management that provide actionable insights• Investigate data anomalies and perform Root Cause Analysis• Audit peer reports and provide constructive feedback -
Analytics EngineerAppetize Sep 2019 - Apr 2020• Wrote SQL scripts to extract and transform data for use with Tableau• Worked within the Analytics team to identify best means to display data and build new visualizations• Analyzed reporting performance issues and recommended optimizations for best performance• Rolled out Tableau as a self-service reporting solution and advised customers in governance of Tableau as a self-service analytics tool• Supported Operational teams in understanding and defining business and data requirements for reporting requests• Iteratively designing and documenting dashboards, alerts, and reports• Shared Tableau administrative duties within the Analytics team, including configuring extracts and scheduling tasks, creation of users, and setting appropriate permissions for log-ons• Worked in Agile and Kanban mode and attended daily stand-ups
-
Data Analyst/Custom Reports DevCaps Payroll (A Cast & Crew Entertainment Company) Oct 2014 - Jul 2019Burbank, California, Us• Designed, built, modified, and maintained reports within the company’s accounting, payroll, and business intelligence applications> Requests were primarily ad hoc and custom created per client specifications> Recurring requests were put into automation, either through SSRS or Tableau• Analyzed accounting and payroll data in databases and custom reports> Created recurring reports to reconcile in-house payroll system with accounting data in Oracle > Provided relevant weekly employee and production metrics to operations departments• Assisted with quarterly and year-end accounting and payroll processes• Worked closely with Operations + Accounting departments to determine client requirements and prioritize requests• Identified and defined new process improvement opportunities by reviewing existing stored procedures and automated reports• Managed and supported in-house applications. Analyzed a given issue, diagnosed, identified the root cause, and either solve the problem or forwarded it to the appropriate Specialist -
Operations Support AssistantCaps Payroll (A Cast & Crew Entertainment Company) Jul 2014 - Oct 2014Burbank, California, Us• Performing voids and various adjustments in order to correct payroll errors• Reconciling and depositing daily funds received• Recording and submitting positive pay• Uploading and releasing daily direct deposits• Assisting Accounting with accounts receivable and closing, as needed• Supporting Invoicing and Quality Control, as needed
-
Invoicing ClerkCaps Payroll (A Cast & Crew Entertainment Company) Oct 2013 - Jul 2014Burbank, California, Us• Ensuring payrolls are properly completed and ready for check cutting• Manually calculating and correcting employee taxes as needed• Printing payroll checks and accompanying invoices• Auditing invoices for correct employer fees and taxes• Processing reissued and reimbursement checks• Coordinating with other invoicing offices in New York and Chicago• Assisting Operations Support, as needed
-
Payroll ClerkCaps Payroll (A Cast & Crew Entertainment Company) Mar 2013 - Oct 2013Burbank, California, Us• Setting up new clients in company system• Creating payroll batches to be processed• Processing casting commissions to clients• Assisting Paymaster as needed• Continuing Data Entry Clerk duties, as needed• Special projects as assigned by supervisor
-
Data Entry ClerkCaps Payroll (A Cast & Crew Entertainment Company) Nov 2012 - Mar 2013Burbank, California, Us• Entering background actor information into company database• Entering time card data for system calculation• Auditing payroll reports for data entry errors• Checking system calculations by manual calculation• Filing completed payrolls• Mail room duties
-
Sales AssociateOrchard Supply Hardware Jul 2012 - Dec 2012San José, Ca, Us• Providing excellent customer service and product recommendations to customers primarily in, but not limited to, the paint & housewares department • Maintaining in-stock within the department and ensuring the aisles are always clean• Specifically assigned to prepare low-quantity and out-of-stock paperwork for the housewares sub-department• Keeping up to date on new product knowledge and cross-training in other departments as needed• Projects as assigned by department leads and managers -
Administrative AssistantInational Closing & Escrow, Inc. Sep 2011 - Nov 2011• Performing daily bank reconciliations, trust accounting, and preparing all financial documents for auditing.• Requesting various documentation needed for the completion of escrow including payoffs, proof of insurance, and wires• General office duties: directing calls on a multi-line phone, customer service, delivering escrow packages, maintaining escrow records, and assisting office personnel as needed
-
Arts Library Desk AssistantUc San Diego Dec 2008 - Sep 2011La Jolla, Ca, Us• Checking out and in various digital media to academic and public patrons• Maintaining media viewing stations including: DVD/Blu-ray players, VHS machines, HD monitors, and projectors• Assisting patrons with PC and Mac computer stations, campus printing systems, copying machines, and digital scanners• Assisting the Outreach Coordinator with exhibits for interactive special events and public outreach programs• Headed the reorganization of the entire DVD collection during spring/summer 2011• Projects and maintenance of department paperwork as assigned
Tracy Velasquez Skills
Microsoft Office
Accounting
Sql
Sqlyog
Transact Sql
Microsoft Sql Server
Sql Server Reporting Services
Tableau
Microsoft Word
Microsoft Excel
Powerpoint
Office 365
Word Processing
Adobe Acrobat
Html
Css
Web Design
General Office Skills
General Office Administration
Multi Line Phone
Data Entry
Multilingual
Mandarin
Cantonese
Customer Service
Customer Support
Pc
Mysql
Postgresql
Xml
Tracy Velasquez Education Details
-
Uc San DiegoEconomics
Frequently Asked Questions about Tracy Velasquez
What company does Tracy Velasquez work for?
Tracy Velasquez works for Optum
What is Tracy Velasquez's role at the current company?
Tracy Velasquez's current role is Data Analyst.
What is Tracy Velasquez's email address?
Tracy Velasquez's email address is tv****@****oll.com
What is Tracy Velasquez's direct phone number?
Tracy Velasquez's direct phone number is +184748*****
What schools did Tracy Velasquez attend?
Tracy Velasquez attended Uc San Diego.
What are some of Tracy Velasquez's interests?
Tracy Velasquez has interest in Mathematics, Auditing, Mathematics Baking, Information Technology, Crocheting, Baking, Accounting, Economics, Swimming, Cooking.
What skills is Tracy Velasquez known for?
Tracy Velasquez has skills like Microsoft Office, Accounting, Sql, Sqlyog, Transact Sql, Microsoft Sql Server, Sql Server Reporting Services, Tableau, Microsoft Word, Microsoft Excel, Powerpoint, Office 365.
Who are Tracy Velasquez's colleagues?
Tracy Velasquez's colleagues are Rick Little, Andrew Czapla, Kylea Sutherland, Msw, Kim Nugent, Jeffrey Nonn, Jeremy Bartolome, Michael Palmer, Cma.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial