Jared Mccarthy Email & Phone Number

Columbus, Ohio

• Responsible for end-to-end preparation of intelligent solutions developed to eliminate user tools.• Develops and enhances Extract, Transform, Load (ETL) workflows and datasets in Alteryx, collecting data from different data sources and summarizing the data as defined in requirements gathering with the stakeholders.• Responsible for preparation of data used for ad-hoc analysis, reporting, and decision-making.• Develops interactive Tableau dashboards used in the financial services domain.• Optimizes SQL queries used to summarize large datasets for reporting. • Automates reporting processes based upon business requirements and reporting dependencies.• Responsible for testing Tableau dashboards, Alteryx workflows, automated jobs, and new table creation or updates made to existing reporting tables.• Performs monthly production code deployments across multiple applications and multiple lines of business.• Coordinates planning and testing for server upgrades, and updates to other leveraged technology components.• Operates in an agile development environment: leads daily standup meeting, manages kanban board, grooms and refines backlog.• Creates training documents and leads technical sessions with other developers to demonstrate new tools.• Demonstrates strong written and oral communication skills with all levels of management and associates from a variety of business functions.

Columbus, Ohio Area

• Worked closely with Financial Controllers and the development Team to analyze business needs and develop technical requirements.• Developed Tableau dashboards for financial reporting using Tableau Desktop application.• Wrote SQL queries in Oracle and Hadoop that were used to create the tables needed to support new Tableau Dashboards.• Assessed in-use financial User Tools then built them into existing Tableau dashboards or created new dashboards to house them. • Provided User Acceptance Testing and Production validation for new Tableau dashboards and changes to existing dashboards.• Facilitated the implementation of new functionality through training sessions, demos, and the development of appropriate documentation.• Responsible for the requirements gathering, research, and implementation of new financial reporting fields requested by the business for internal and external reporting.• Resolved end user reporting issues through collaboration with IT and Development Teams.• Served as liaison between IT and business end-users.• Operated in an agile development environment.

Hilliard, Ohio

Hands-on IT system testing:·Ensure complete testing for coding changes impacting Verizon Wireless customer or employee facing systems and/or pricing reference data changes.·Judgmentally assess system and customer experience risk impacts associated with each change and determine appropriate level of focus.·Determine appropriate priority of focus based on risk assessment and workload balance.·Maintain strong working relationships with other organizations that are both internal and external.·Support business initiatives that impact Verizon Wireless front end systems by providing ad hoc analytical, operational, testing, or technical support.·Design, implement, and execute specific tests to ensure the integrity of various billing flows. Document test results, defects, and projects.·Engage internal stakeholders to refine and improve requirements for both new and existing products and services. Create or identify system reference training tools to improve testing functions.·Protect proprietary and confidential information.·Improve the customer experience and advocate for our shareholders.·Lead and coordinate IT enterprise release UAT testing for the Revenue Assurance department·Support testing for billing system UAT and UAT in all POS systems Project support:·Act as team lead for Revenue Assurance on projects related to front end system testing, pricing reference data testing, and projects of varying degrees of complexity and scale; validate that the experience matches to billing output or customer experience.·Analyze the system, process and organizational impact of change requests and quantify potential or actual dollar impacts; ensure key stakeholders are aware as well as they make recommendations based on this analysis.·Represent Testing Operations as the technical subject matter expert on cross-functional implementation teams and provide related Testing Operations requirements by coordinating with the internal Revenue Assurance teams.

Hilliard, Ohio

Oversee the implementation process for the roll out of a new billing system and integrated equipment ordering system to all call centers in the Midwest region.Subject matter expert for the new billing system and integrated equipment ordering system - responsibilities included customizing real time training materials and providing on-site floor support.Act as a liaison between the end users and IT development to identify system issues so an action plan can be established.Lead weekly calls with senior management in customer service to present status updates and identify actionable items.Analyze metrics and report weekly to determine success of the new system following implementation.Provide monthly reporting on call metrics to determine center performance and identify outliers at the individual level.Provide deep dive analysis and troubleshooting to identify the root cause that is driving undesirable performance results; presenting findings to senior leadership.Uncover opportunity for enhancements to the online customer website to eliminate calls and improve the existing system. Present to senior management for approval then partner with Marketing and IT to implement these changes.Participate on a committee responsible for reviewing submissions from the employee idea portal, researching and collaborating on action plans to execute the selected ideas.

Provide regional support in verifying escalated billing issues and partnering with the billing division to execute resolution.Provide User Acceptance Testing (UAT) for the system used in identify billing issues.Utilize multiple internal systems to investigate billing error submittals surrounding call validity, voice and data roaming, data validity and other billing inquiries. Provide detailed reporting surrounding the new hire training and on-boarding process as well as individual performance. Audit service rep issued credits for the Midwest region Call Centers in order to identify the primary drivers and adjust rep behaviors that result in unnecessary credits. Reporting of audit results, outlier representatives, trends, and identified coaching opportunities is deliverable on a weekly basis directly to senior leadership.