Ryan Marohn Email & Phone Number

- Continued to work with the Centers for Medicare and Medicaid Services on creating self service data pipelines and dashboarding services as well as created documentation for previously built dashboards, notebooks and pipelines along with Alation data catalogs for datasets used in said dashboards, notebooks and pipelines. Also helped design and review code changes for more automated data production.

-Worked with the Department of Transportation's Federal Railroad Administration to design and build a dashboarding and data management system for Quarterly Report on the Performance and Service Quality of Intercity Passenger Train Operations. Documented the process for future refreshes of data and any necessary fixes/ work arounds that must be performed for continued publication in the desired format-Worked with the Centers for Medicare and Medicaid Services as a part of the DataConnect… Show more -Worked with the Department of Transportation's Federal Railroad Administration to design and build a dashboarding and data management system for Quarterly Report on the Performance and Service Quality of Intercity Passenger Train Operations. Documented the process for future refreshes of data and any necessary fixes/ work arounds that must be performed for continued publication in the desired format-Worked with the Centers for Medicare and Medicaid Services as a part of the DataConnect Data Design and Discovery team. Worked with stakeholders and team members to create several analyses of public health data and policy in DataBricks while testing the functionality of AWS QuickSight to visualize said data by building several dashboards with varying data pipelines. Show less

Atlanta

• Founded and manage a 501(c)(3) nonprofit organization based in Chicago, Atlanta, New York and Los Angeles that channels the creativity of skateboarders and artists into giving back to their communities.• Created and managed several collaborative projects with charities/nonprofits including Arts of Life in Chicago, Drawchange in Atlanta, the Sebastian Social Projects in India, Khartoum University in Sudan, Islamic Relief in Yemen and ACE Programs for the Homeless in New York• Worked… Show more • Founded and manage a 501(c)(3) nonprofit organization based in Chicago, Atlanta, New York and Los Angeles that channels the creativity of skateboarders and artists into giving back to their communities.• Created and managed several collaborative projects with charities/nonprofits including Arts of Life in Chicago, Drawchange in Atlanta, the Sebastian Social Projects in India, Khartoum University in Sudan, Islamic Relief in Yemen and ACE Programs for the Homeless in New York• Worked with compliance and accounting officers to write and obtain approval of bylaws and other documentation to obtain 501(c)(3) status, register/ report to secretary of state and attorney general on a yearly basis and report each month sales and use taxes for our locations/ sales nexuses in 4 different states Show less

Greater Atlanta Area

• Led the team’s effort as the sole onsite representative to increase customer investment from a single staff augmentation project to Mu Sigma’s first ever packaged engagement which included multiple cross functional teams, flexible offshore resources, customized software and training sessions for a total increase of 1.9M (or 872%) in billed revenue for a large private paper pulp manufacturer and distributor• Traveled to India to help design, set up and conduct a two day executive workshop… Show more • Led the team’s effort as the sole onsite representative to increase customer investment from a single staff augmentation project to Mu Sigma’s first ever packaged engagement which included multiple cross functional teams, flexible offshore resources, customized software and training sessions for a total increase of 1.9M (or 872%) in billed revenue for a large private paper pulp manufacturer and distributor• Traveled to India to help design, set up and conduct a two day executive workshop in our Bangalore offices in which we trained the CFO, VP of Decision Analytics, VP of Finance and Treasury and VP of Finance Wood Products on the importance of problem solving and analytics and how they can expand their analytics.• Designed and conducted several workshops to train citizen data scientists on how to solve problems and utilize data and analytical tools to create actionable projects for manufacturing and non-manufacturing teams • Designed and implemented a model monitoring system to establish performance thresh-holds and governance for operational and non-operational models being used across several functional teams• Managed 5 different projects of varying offshore team size across the decision analytics team Show less

Greater Atlanta Area

• Engaged clients to better comprehend, solve and avoid business challenges through utilizing analytical tools to extrapolate and interoperate data and make the best, real time decisions for home improvement retail.• Text mined all manually entered coupon promotions and helped build a code for pulling specific transaction-level data in order to identify a $600 Million opportunity by virtualizing 379 merchandising coupons.• Consolidated 10 tools used by planners to affectively drive… Show more • Engaged clients to better comprehend, solve and avoid business challenges through utilizing analytical tools to extrapolate and interoperate data and make the best, real time decisions for home improvement retail.• Text mined all manually entered coupon promotions and helped build a code for pulling specific transaction-level data in order to identify a $600 Million opportunity by virtualizing 379 merchandising coupons.• Consolidated 10 tools used by planners to affectively drive product assortment, investigate customer spending patterns, analyze reset options and effectiveness to one singular, self-serving tool on Google Cloud Platform.• Utilized geographical distance combined with cross shop evaluation to create alternate “neighborhoods” within markets to decrease customer driving distance and cannibalization based on parameters set on a self-serving tool created for the client.• Web scraped newer product descriptions, ratings, reviews and attributes to identify innovative products within the client and competitor’s assortments. Calculated potential impact of innovative products using regression techniques and identification of test/control stores across the country• Developed and transitioned to Google Cloud Platform a statistical tool used to measure impact of executing a wide range of tests determined by merchants and stakeholders in stores across the United States where test and control store selection and impact is based off input from the users in a self-serving tool. Show less

Bentonville, Arkansas

Utilized analytical tools to drive business solutions, organized quarterly business review with top stakeholders and spearheaded agile methodology sessions to improve productivity and streamline results for the world’s largest retailer.

Bengaluru Area, India

Developed skills on how to best utilize SAS, SQL, R, Statistics, Excel and other data tools to be applied in real time data science solutions through a combination of guided deliverables, self-learning and project involvement. Worked alongside a global delivery team at the India Headquarters in order to solve data-intensive problems for clients in the Weather, Retail and Grocery industry with applicable company analytical frameworks and tools.

Urbana-Champaign, Illinois Area

Managed a live concert promotion and production organization of 14 junior managers and 200 students. Coordinated with middle agents across the country to compose offers, contracts and business plans for shows through email and telephone communication. Created a marketing plan for confirmed shows and delegated associated tasks to other students and committees within the organization to complete before each show. Created audits for the university’s approval of funding shows accounting for up to… Show more Managed a live concert promotion and production organization of 14 junior managers and 200 students. Coordinated with middle agents across the country to compose offers, contracts and business plans for shows through email and telephone communication. Created a marketing plan for confirmed shows and delegated associated tasks to other students and committees within the organization to complete before each show. Created audits for the university’s approval of funding shows accounting for up to $50,000 per show. Show less

Lincolnwood, Il

Create a program for young skateboarders age 5-11 over the summer. Create a detailed course guide and lesson plan for continued instruction and advancement in the future. Advertise the new program around the neighborhood. Conduct private lessons if needed.