Nicholas Ayala Email & Phone Number

Beaverton, Or, Us

Beaverton, Or, Us

Part of the Insights and Analytics team, responsible for driving insights and scalable solutions through data to ensure Nike delivers on customer and consumer promises. Working cross functionally with numerous teams to design, build and apply analytical tools and data structures. Functioning as a key partner to support and enhance tools to optimize Nike supply chain, deliver predictive modeling and design experiments and analysis to deliver insights.• Software used: Snowflake, Teradata, SSMS, SSRS, SSIS, Office 365, Azure, Python, GIT• Work with numerous stakeholders to create or enhance key metrics and dashboards • Created metrics and data solutions to reduce pain points and save millions of dollars• Structure and solve complex analytical problems and generate new perspectives on existing solutions• Skilled at communication, adept at expressing technical concepts to non-technical audience• Prioritize and manage projects to best fit business needs.

Beaverton, Or, Us

New York, New York, Us

Responsible for developing reports, queries, views, dashboards, and optimization, which provide information to clients, stakeholders, managers, and other constituents. Reporting ranges from quick ad-hoc reporting to formal, complex reporting. This position utilizes a strong foundation in relation databases to work with and understand business requirements from various stake holders and teams.• Software used includes: SSMS, SSRS, SSIS, Power BI, Office 365, Azure, Python• T-SQL: complex joins and subqueries, stored procedures, views, triggers, indexing and optimization• Power BI: Create automated reports and dashboards, proficient in DAX • Transform technical requirements into reporting solutions. This includes transforming client needs into usable reporting structures • Translate reporting requirements into seamless dashboards, dynamic content, or static outputs that optimize results• Identify optimal solutions that consume the right data sources for reporting purposes• Maintain and support existing reports, reporting tools, dashboards, and reporting libraries• Create and maintain technical documentation in various forms• Fast paced environment with shifting priorities and tight deadlines.

New York, New York, Us

Glen Allen, Va, Us

Contracted as a Data Analyst on an Agile development team.-Software Used includes SSMS, SSRS, Tableau and Power BI -Responsible for gathering and translating business and service requirements into queries, models and tools to allow for insightful data analysis and forecasting. -Collaborate with various users to develop and interpret reports, create complex data queries, reconcile data from sources, develop ad-hoc queries to augment/pilot new reports and perform data cleansing and auditing to identify idiosyncrasies and ensure data integrity.-Educate customers/employees on availability of standard reports to meet operational information requirements and use deployed business intelligence capabilities to make recommendations to help business users analyze data and create customized reports and analytics-Point of contact for report/analytic needs-Collaborate with all areas of our business including Finance, Marketing, IT, Customer Support, and Order Fulfillment and Sales.-Monitor data integrity to drive the creation and maintenance of valid, standardized data for accounts, contacts, and transactions.-Work with the Analyst and DBA to ensure data is concise and the reporting tools are working as required.

Des Moines, Iowa, Us

Accountable for the successful coordination of deployment, installation and training of remote calibration equipment within the Intoxalock Service Center network, over 2500 service centers covering 47 states. Additionally, responsible for analyzing the monthly implementation and usage, while reporting issues with service centers, distributors or customers.• Facilitate equipment deployment from distributors to service centers, equipment training, and any necessary follow up services.• Serve as a liaison between company departments, training team, vendors and service centers.• Create a quality rapport with Intoxalock teams, vendor teams, and service center teams.• Effectively train Intoxalock teams on product rollout and best practices for service center interaction, observations and training.• Install and train remote calibration equipment and processes to fully prepare the Service Center to conduct this service for Intoxalock customers.• Ensure each service center is fully equipped to take care of Intoxalock customers.• Maintain and manage workflow of training and support teams each week.• Predict possible issues and manage as they occur, including on the fly software and hardware support for training team.• Perform ad hoc analysis and compile weekly and monthly effectiveness reports.• Manage Escalated service center issues, while providing observed feedback of individual Service Centers.

Seattle, Wa, Us

Managed all aspects of business, while exceeding company standards in all key performance areas.Oversaw and ensured sales and installation processes were followed while mentoring and developingstaff to be future leaders. Managed multiple daily, weekly and monthly projects while leading a team of 26people, ensuring the best possible customer experience.• Perform Daily/Weekly/Monthly goal setting, while managing the workflow of both the sales floorand the installation bay.• Analyze and predict sales to create custom sales plans in advance.• Create working relationships with vendors and our business to business customers.• Build rapport with customers to ensure best experience possible.• Manage all escalated issues as quickly as possible while predicting possible issues.• Assist in online fulfillment as needed and respond to online inquiries as quick as possible.• Create monthly presentations for key performance indicators and make regular presentations topeer managers and senior management.• Increased Commercial business by 18% through direct business relations to promote ourproducts and services as top in the industry.• Moved the store from being the 42nd ranked store in 2015 out of 52 to being in the top 5 bestperforming stores for 2016.• Increased stores customer satisfaction index by 30% and increased quality of online presence.• Received the regions first ever 100% on a quarterly store audit.• Won Award for top achieving store in the region, first year as manager.• Consistently won top sales awards.

Akron, Oh, Us

Responsible for supporting the Store Manager in meeting or exceeding sales, unit and profit targets.Protected the assets of the Company by assisting the Store Manager in managing all functions within thestore. Played a lead role in coaching and directing store associates to ensure optimal store performance.Responsible for being a role model to associates by being accountable for job responsibilities andprocess execution, while exceeding customer expectations.• Top in unit sales every month for 14 months• Asked to help open new store, and use expertise to hit the ground running, new store wasturning a profit from the first month it opened• Recruited back to original store, where once again was top in unit sales each month until I leftthe company.• Worked regularly with fleet companies to bring in added business.• Became in expert in inventory processes as well as an inflow and outflow of inventory.• Created and implemented new way to stock inventory, for quicker acquisition of product.• Reduced Inventory loss to almost zero.

Master Of Science - Ms, Data Science

Economics

High School Diploma