Alex Castelazo, Mba Email & Phone Number

Phoenix, Arizona, Us

• Test & Measurement Management: Directed the Test & Measurement services, overseeing the analysis of pricing impacts and evaluating email campaign effectiveness to optimize strategic initiatives.• Data Migration Oversight: Executed a comprehensive data audit post-migration from Netezza to Snowflake and Databricks, ensuring data quality and integrity throughout the transition.• Global CRM Campaign Analysis: Spearheaded a global holdout test to meticulously gauge the impact of CRM campaigns, contributing valuable insights for strategic decision-making.• Statistical Education: Assumed a pivotal role in educating business stakeholders on the nuanced interpretation of statistical tests, emphasizing their relevance in measuring impact and lift.• Team Leadership: Led a team of proficient data analysts through diverse projects, including intricate data audits, development of simple machine learning models, and delivery of comprehensive analytics reports.

Phoenix, Arizona, Us

Responsible for developing data-driven tools and methods that empower the organization to make better decisions. Responsibilities include capturing internal and external data, cleaning, merging, and analyzing the data, and producing insights to drive strategic decision-making. Part of this role entails developing relationships with experts in the animal welfare industry to stay abreast of best practices in data collection and analysis and to establish PetSmart Charities’ role as a leader in the application of advanced analytics to the issues surrounding animal welfare in our communities. Other key accomplishments:• Produced analysis of consumer survey conducted in partnership with HABRI to create insights into recent changes to consumer behavior as it pertains to dog acquisition.• Supplied marketing team with timely analysis of shelter data to counteract disinformation in media channels.• Managed historical data migration processes into XML for new grant management system implementation.• Created Bayesian model simulating a recalcitrant firm entering a veterinary market to understand the economic impact to existing firms.

Phoenix, Arizona, Us

Responsible for extracting strategic insights through advanced statistical analysis of internal and external data to identify gaps and opportunities in PetSmart’s pricing strategy. Applied machine learning techniques to classify products and create financial models used to forecast effectiveness of price changes.

New York, Ny, Us

Responsibilities include ground-up implementation of MicroStrategy Business Intelligence solution for hotel commission collection data, coordination with two global commission collection vendors to facilitate zero-defect data transfer process, and development of interactive dashboards, reports, and analytics to provide data-driven insights to senior leadership. A key component of the position was interacting with all levels in different groups like Finance, Accounting, Operations, and Technology to promote alignment and buy in. Other key accomplishments: - Managed a team of 4 analysts to implement MicroStrategy Business Intelligence solution. - Developed SQL solution to replace a legacy invoicing process. - Used Data Mining and other statistical methods to improve hotel attachment rate metric. - Collaborated with senior leadership to establish effective targets and goals for several operations groups. - Managed and improved accounting process for revenue accruals. - Directed the development of several dashboards and reports providing visibility to KPIs and attachment rates.

Tempe, Az, Us

Responsibilities include overseeing and executing economic research projects for commercial and governmental clients, and managing all databases and reporting needs for the Energize Phoenix program - a $25 million federally-funded project to stimulate the adoption of energy conservation measures in the City of Phoenix. A key aspect of this position was to perform statistical analysis of industry, client, and economic data using SPSS. Other key accomplishments:• Created SQL Database and accompanying reports for real-estate client generating $12,500 for Seidman.• Designed and maintained Seidman Research Institute web site using Wordpress and PHP.• Managed reporting processes for Blue Chip Job Growth web site troubleshooting incidental issues.• Established a web-based repository of solar industry data and analysis in Arizona.• Produced two major Aerospace & Defense industry reports that were presented to the Arizona Governor.• Managed the efforts of 3 doctoral students employed by the Energize Phoenix program. • Developed a survey mobile app used by student workers to survey passengers at Phoenix Sky Harbor International Airport.

Provided various analytics and statistical analysis supporting the Business Travel division using T-SQL, Visual Basic and MS Access. Implemented the use of SAS JMP Statistical software in order to provide decision support to upper management. A key aspect of this position was to identify all sources of data, combine and prepare data for analysis, and provide interpretation of statistical results. Other key accomplishments:• Modeled database structure and designed integrated reporting solutions using Microstrategy BI tools.• Automated analytics production process using Visual Basic, MS Access and MS Excel.• Created database application in Access to process and analyze supplier data.• Designed and automated KPI dashboard using MS Access and Excel for Global Supplier Management team. • Managed analytic process for Global Preferred Rewards supplier incentive program.

New York, New York, Us

Responsible for performing complex financial and business data analysis and preparing comprehensive reports for Finance and Operations departments using Access, T-SQL, Oracle and Cognos. Identified internal clients’ needs and gathered necessary data for project requirements. Responsibilities included, assessing data accuracy, drawing research conclusions, and formatting and preparing output. Coordinated the implementation of Cognos BI solutions across business platforms. Other key accomplishments:• Used statistical analysis and regression modeling to develop and maintain a comprehensive staffing model.• Developed and maintained P&L metrics used by Finance department.• Increased effectiveness of mortgage application system by creating a more efficient user interface and leveraging outsourced assets abroad. • Interacted with all levels of management in order to identify each user’s needs.• Reduced strategic planning and staffing costs by 40%.• Provided guidance and direction to less experienced analysts.• Received “President’s Club” award for exceptional service.

New York, New York, Us

Developed, designed and implemented an Access database to track potential talent within the company and identify strategic talent gaps. Worked closely with HR and Business Managers to identify each group’s requirements and provide the best solution. Other key accomplishments include:• Developed multi-user interface servicing over 150 managers.• Used database to help HR implement gap analysis.• Developed and implemented database training for all managers and HR.• Received “Champion of the Year” award for exemplary service and performance.

Master Of Business Administration (M.B.A.), Business/Managerial Economics

Bs, Economics