Stephen La Rosa Email & Phone Number

United States

Phoenix, Arizona

Led process/data automation based solutions to supplement the billing & collections workforce by 50+ FTE (about 100k hours annually).Continuing the support of both internal and external leadership/executive stakeholders by developing insights/reporting related to sales, underwriting, operations, revenue cycle, finance, accounting and compliance. Led the.

Phoenix, Arizona

Sole administrator to CVS Enterprise Alteryx Server Gallery. SME for all Alteryx related system or development requests.Recruit & develop incoming data analysts by training them in system applications as well bringing them up to speed in current BI tools used, SQL data tables and projects. Continuing the development of automated projects through the use of.

Phoenix, Arizona

• 3+ years of experience in developing & maintaining Tableau dashboards. Extensive knowledge in creating calculated fields, filters, sets, groups, window functions, and field parameters. Experience with Tableau Server.
• Collaborate closely with SMEs to identify and analyze core elements of their specific books of business. Then develop and maintain executive & business operational Tableau dashboards to provide in-depth analysis and.
• Provide ad-hoc analysis and data trending to executive, director, and manager level leadership through the use of Oracle SQL Developer & Microsoft SQL Server.
• 2+ years of experience in developing Alteryx workflows that combines both SQL & flat files into automated insightful reporting that can be delivered via an automated email or scheduled file drop. Familiar with Alteryx.
• Improved business efficiency by designing & developing an elaborate Alteryx workflow that creates daily biller work lists. Helped eliminate the need of daily manual tasks by leveraging Alteryx Scheduler to schedule.
• Produced an automated Alteryx workflow to monitor & report third party vendor claim transactions through the use of SQL & Alteryx tools. Created Tableau TDE files in Alteryx to feed data from the workflow to Tableau.

Phoenix, AZ

• Support development and implementation of case analysis work by the reconciliation of data from the Center for Consumer Information & Insurance Oversight.
• Assist Cognosante stakeholders with Centers for Medicare & Medicaid Services 1095-A error resolution processes.
• Improve & resolve data batch updates into SSIS project environment. Update case analysis work into Microsoft Dynamics CRM tool in order to provide a smooth data transition.
• Responsible for conducting extensive MS Excel data research, workflow investigations, business procedures and making case recommendations.

Gilbert, AZ

• Managed & tracked weekly media advertising budget of over $350,000 by selecting all markets, stations, programs, and time slots that profitably generated customer sales & leads.
• Worked with the finance & workforce team to forecast future weeks spend & leads to allow appropriate staffing levels; optimizing spend & maximizing profits.
• Research & analyzed all aspects of creative performance for a new line of business and created a detailed report to help launch a new constant that outperformed all previous ads by 25%.
• Achieved a 20% increase in customer response rate by successfully testing and expanding new creative, which required a thorough analysis of recent and historical performance.
• Presented weekly performance of media sources to executive team with future recommendations & necessary adjustments to hit goal performance utilizing Excel & Tableau database.

Phoenix, Arizona Area

• Worked with the program management team as their go-to analyst for providing ad-hoc reports & analysis for various multi-million dollar travel programs for Silicon Valley clients.
• Specialized in optimizing travel spend by analyzing travel data and providing recommendations for traveler changes & behavior. Produced a specific policy report for a client that was able to change employee travel.
• Served as a traveling analyst in assisting the business development team with procuring new business for the company. Provided in-depth information to potential clients about how & why travel analytics can benefit.
• Appointed as the western region business analyst in beta testing upcoming data reporting tool. Upon release would train the analyst team in tool functionality & features. Also held training classes for clients that.

Austin, TX

Flagstaff, Arizona, United States