Robert Guzman Email & Phone Number

Denver, CO, US

Denver, CO, US

St. Rose, LA, US

• Analyze customer service metrics such as response time, resolution rate, customer satisfaction (CSAT), Net Promoter Score (NPS), and churn rate.
• Create dashboards and reports to track KPIs and performance metrics.
• Use Power BI and Sigma to present insights and trends to stakeholders.
• Identify gaps and opportunities in the customer journey by analyzing customer feedback and service interactions.
• Conduct root cause analysis to understand issues driving negative customer experiences.
• Recommend process improvements to enhance service delivery and customer satisfaction.

US

• Conducts and manages outcomes of various marketing campaigns that include analyzing, reviewing, forecasting, trending, and presenting information for operational and business planning.
• Support short and long-term operational/strategic business activities - by developing, enhancing, and maintaining operational information and models.
• Develop and implement effective/strategic business solutions through research and analysis of data and business processes.
• Collaborate with marketing, admissions, IT, and finance departments to collect, analyze, and interpret data.
• Provide data-driven insights to guide budgetary, lead performance, conversion, enrollment, and retention strategies.
• Effectively communicate findings to key stakeholders and translate reports verbally and in writing into actionable recommendations both verbally and in writing.

Chicago, Illinois, US

• Responsible for planning and managing data analytics that provide overall data management and reporting. Oversees the development of analytical tools and solutions to support the business line. Collaborates with.
• Oversees the business line's data analytics strategy. This includes recommending and developing of related programs for the business line.
• Manages the research, design, development, testing, retrieval, and data reporting, utilizing the knowledge of various software packages.
• Identifies business, technology, and process improvement opportunities. This may include making recommendations to business line leaders.
• Establishes and serves as Business Line's "analytic review" function to ensure the uniformity and quality of analytical tools and reports are delivered consistently to business partners.
• Analyze monthly KPI’s using Archer and presenting data within dashboards utilizing Power BI.

Denver, Colorado, US

• Research, troubleshoot, test, and update systems and databases for the Global Reporting Department. The Global Reporting Department is responsible for developing and implementing state-of-the-art software to support.
• Troubleshoot, monitor and update source and target Power BI dashboards.
• Test and troubleshoot databases, correcting errors and recommending necessary modifications.
• Troubleshoots and modifies the ETL process within Informatica.
• Promote code changes utilizing Databricks within the Azure cloud.
• Troubleshoot the end-to-end daily trading and distribution fund management process.

Columbus, Ohio, US

• Oversees and coordinates changes, testing, and implementations to the database management system.
• Test and programs databases, correcting errors and making necessary modifications.
• Modify existing databases and database management systems or directing programmers and analysts to make changes.
• Writes and code for both logical and physical database descriptions and specifies identifiers of the database to management systems or directs others in coding descriptions.
• Works as part of a project team to coordinate database development and determines project scope and limitations.
• Reviews project requests describing database user needs to estimate time and cost required to accomplish project.

Denver, CO, US

• Systems Analyst to support the ATIMS (JMS) Jail Management System implementation project.
• Support Technology Services, other agency resources, and the software vendor as needed.
• Partner with senior management and end-users within the City to support the system, which includes the planning, analysis, implementation, and phases of the SDLC.
• Perform analysis activities for project including working with other analysts, developers, and testers to complete assigned work.
• Coordinate go-live support and immediate post-production support activities.
• Support system integrations with JMS and data flow processes.

Austin, TX, US

• Forex Trading and Financial Analysis.Engage in monthly, weekly and daily analysis for Forex dollar pairs.
• Analyzed foreign currency charts daily.
• Setup trades in the forex market.

Victoria, British Columbia, CA

• Served as a liaison to the business community in order to provide technical solutions to meet user needs.
• Tracked and reported using SQL and Excel on departmental initiatives and maintained initiative road-map and status reports.
• Created ETL processes for data to support integrations for tools and the design teams.
• Tested end to end process for the construction and design process.
• Lead cross-functional projects related to process improvement, product lifecycle management, or product development.
• Ensured complete analysis and understanding of interdependencies, business risks, risk mitigators that could impact or be impacted by the delivery of new products, services, processes and/or support technologies.

Philadelphia, PA, US

• Provide consultative services, both internal and external, to the organization; designing, documenting, and maintaining architecture diagrams for systems, processes, interfaces, and job scheduling. Interfaces with.
• Developed a continuous integration pipeline that allowed for automated daily deployments; which saved the organization approximately $30,000 monthly.
• Developed Mobile App and Web Portal for Comcast Business Customers
• Create high-level and detailed design using UML, process flows, sequence diagrams, Use Cases, etc.
• Design and Develop enterprise applications using Agile methodology.
• Well versed in SCRUM, Story Mapping and User Stories.

Philadelphia, PA, US

• Provided architectural support, research, and analysis to drive integration of company data into Remedy Trouble Ticketing system developed for company markets that supported approximately over 50,000,000 customers..
• Drove and supported data architecture strategy. Implemented go-to-person for in-depth analysis, focusing on issue identification, resulting in problem determination, documentation, and issue resolution.
• Served as resident expert on CSG source billing data and CSG Vantage database.
• Gained working knowledge of ICOMS and Amdocs billing systems. Teamed with business analysts, developers, and customers to ensure soundness of business rules, data strategies, and source to target mappings.
• Leveraged knowledge of data to provide DBAs with performance tuning recommendations. Articulated complex technical issues to team members and customers.

Supervised 55 technicians on day shift as result of leadership transition and complex process opportunities. Interacted regularly with market teams and various functional groups to assist with complex troubleshooting and customer trouble resolution. Managed quality assurance programs for telephony TRAC and assisted field technicians within markets..

Bachelor Of Applied Science (Basc), Information Technology

Associate Of Applied Science (A.A.S.), Electrical, Electronics And Communications Engineering

Forex Trading