Rosslyn Valdez-Lambert
214-***-**** Email: *************@*****.*** Plano, Tx.
LinkedIn: www.linkedin.com/in/rosslynvaldez
Sales Operations Analyst / Data Entry
Coordinator
EDUCATION
University of North Texas – BBA Management Information Systems 1997 Coursera Advanced Excel Certificate 2020
SKILLS EXPERTISE STRENGTHS
- Data Entry
- Database
updates
- Excel
- Problem solving
- Data audits,
reporting
- CRM Salesforce/ Zoho
- MS PowerPoint
- MS Excel,
- MS Office
- Data validation
- Ad hoc Reporting
- Communications/
Collaboration skills
- Extremely organized
- Dependable
- Customer Service
- Detail Oriented
- Strong work ethic
Professional Accomplishments
• Developed and Tracked Regional Sales activity in Excel spreadsheets using dashboards, pivots, slicers to reflect team metrics.
• Lead the collaboration and produced a Salesforce Maps report to capture routing data on analysis for validation. Reporting on recurring violations.
• Exceeded project deadlines for new switch turnups by creating data process short- cuts to load switch tables by data capture, extraction, formatting and uploading using Access, Excel, .txt, FTP, etc.
• Lead the collaboration and produced standard procedure documentation for all processes in customer and network translations reducing customer service issues and increasing database integrity.
• Installed the Nortel Telepath front end application system as a tool for daily translation database work, and reporting. Reducing switch translation data input errors.
Rosslyn Valdez-Lambert Page 2
Work History
Pyramid – NationWide (remote) 4 month contract Sept 2023 – Jan 2024 Sales Operations Analyst
- Maintain sales account data via audits, data entry and reporting using Salesforce CRM.
- Create/send reports for distribution to sales accounts, Salesforce, BI.
- Coordinate account set-up
- Customer Service for both external and internal customers and clients Vaco – Axon (Remote) 3 month contract Apr 2023 – Jul 2023 Sales Operations Analyst
- Create Sales Force quotes for customer presentation, Data Entry.
- Reduced backlog of orders to current status.
- Research across multiple data sources for existing customers to support contract modifications.
- Audid Sales Force to align with modified contracts Origina Inc. (Justworks) (Remote) Nov 2022 – Mar 2023 Sales Operations Analyst
- Quality Control, maintain sales data through audits. Data entry using Zoho CRM, MS Excel
- Support sales team on operational aspects; assuring deals get delivered.
- Create specialized quotes as needed for customer presentations.
- Update Vendor on-boarding credentials.
Experis / Cisco (Remote) 4 month contract Apr 2022 – Jul 2022 Sales Analyst
- Successfully converted current customers from contract to subscription services.
- Identify, validate and update customer product records for conversion.
- Create customer Estimates and Quotes for subscription service and finance approval using Salesforce.
- Customer data validation, using Tableau, Smartsheet and Excel spreadsheets – pivots, and filters for accounts assigned to me out of 20,000+ records. KT&G USA, Plano, TX Jul 2019 –Mar 2022
Sales Analyst
- Support stakeholders with sales team activity compliance metrics and KPI reporting.
- Validate data with Salesforce and Excel; using pivots, slicers and Vlookup’s to present current and past metrics on account managers. Rosslyn Valdez-Lambert Page 3
KT&G USA, Plano, TX continued
- Collaborate with management to define new and update KPI’s using Excel pivots tables, Vlookup’s and conditional formatting to view metrics at the account manager, region and district level for performance.
- Define and prepare for stakeholders consistent and accurate, interactive Excel spreadsheets and dashboards for KPI summaries.
- Access National database for share market reporting (155k+ records) specifically for our regions and product tier.
Verizon Business, Richardson, TX Mar 1997 – Dec 2017 Switch Translations Engineer IV
- Contributed to department order processing mean time by quickly completing all orders exceeding the allotted time.
- Prioritized all office administration and translations duties for timely updates and Ad-hoc reporting; including data entry, project collaboration, and process documentation.
Data Processing
- Resolved trouble tickets by customer and vendor interaction, and application and data diagnostics.
- Managed database integrity by table audits using data compare and error reports.
- Engineered 911 and DA (directory assistance) for correct routing by collaborating with local PSAP agencies for testing and correct routing.
- Created databases and spreadsheets for department order and process tracking for reporting and time allocation. ‘GOTO’ point of contact for all administrative duties. Database management
- Accomplished the data manipulation for the initial master data load on the startup DMS switches ensuring key fields match; using Excel, Access, txt, etc.
- Demonstrated initiative by getting trained on a system (that was not being used) for switch translations including being trained, and training colleagues.
- Initiated and collaborated with department the documentation of processes. Volunteer activities.
Big Brothers and Sisters - Mentored an 8-year-old for 10 years, till graduation. Clothe a Child - 2 years; helping children get back to school in style. Attitudes and Attire - 3 years, Economic Empowerment for job interviews.