Wilson W. Email & Phone Number

Sunnyvale, Ca, Us

New York, Ny, Us

• Collaborate closely with data scientists to build out datasets and feature stores used for clustering and machine learning models to provide directives for future companywide strategies and operations.• Perform EDA and deep dive analysis for business initiatives, where findings are presented through visualization created by Python. Recommendations are also provided based off of the findings to help make data driven decisions.• Combine customer, financial, and digital(web) data together into a single location through a Tableau dashboard. Alleviating the need for business users to go through multiple different systems for their needed data.• Migrating Power BI dashboards to Tableau to have a centralize reporting repository.• Developing dashboards in Adobe Analytics for real-time analytics on e-commerce metrics.• Mentoring junior members on dashboard and SQL development, and function as quality assurance for their work.

New York, Ny, Us

• Developed one of the most widely used dashboard with Power BI that provides high level overview of customer analytics such as demographics, customer status, spending behavior, and shopping behavior. It includes over 40+ filtering options. Responsible for end to end development and engaged with stakeholders for requirement gathering. The dashboard became the single source of truth for customer data and reduced ad-hoc requests up to 80%.• Led the development of the dashboard that tracks the performance of myList, Bloomingdale's new subscription service, in an Agile manner by partnering with the special projects team to scope out requirements, provided vendors with the design of the needed data feeds, and collaborated with data engineering team to ingest the feeds.• Worked with the site team to provide a deep dive analysis on the pre and post-performance of the new Wishlist feature by combining customer data with web data using advance SQL queries containing multi-table joins, subqueries, functions, and CTE. Findings were showcased through a combination of tabular data and visualization for storytelling.• Provided company-wide training on how to use dashboards that was developed and created documentations for them. Also acted as the contact person for any questions or bugs regarding dashboards.• Designed tabular models using star schema that are housed in Azure Analysis Services as data sources for Power BI dashboards. • Automated the refresh of dashboard data sources by developing stored procedures and orchestrated the calling of it and processing of tabular models through Azure Data Factory.

Los Angeles, California, Us

• Spearheaded and managed a project with developers to integrate Google AdWords data into the database. Improved data granularity and automated reporting, reduced customer acquisition costs up to 50%.• Engaged with chief operating officer and marketing director to develop KPI reports for monitoring overall business performance.• Developed, maintained, and enhanced a data warehouse in PostgreSQL. Replaced legacy scripts and queries to improve data accuracy and optimize performance. Multi-hour processes were reduced to under 30 minutes. • Formulated and implemented A/B testing on website enhancement and marketing effort to evaluate the success of these changes.• Implemented currency exchange rate component into the database to facilitate accurate representation of revenue numbers for decision making and data analysis.• Used company’s proprietary BI tool, Google Analytics/AdWords, and Excel to create dashboards, data visualization, and report automation for analytic purposes.• Created Python scripts to batch process high-cost queries to avoid server lock up.

• Programmed Microsoft Access to interact with various data sources such as Access databases, SQL server, and flat files to support reporting needs and operational tasks. • Developed purchase order processing and stock transfer application using VBA and SQL queries to replace manual tasks, reducing processing time by 90%. • Recommended and implemented workflow process changes to improve data quality and streamline business processes. Standardized format of frequently used Excel spreadsheets across departments to optimize data collection procedures.• Worked with vendors to implement ETL processes to ingest and provide data feeds and implement changes to existing applications in the retail management system.• Supported reporting by developing custom reporting applications using Access with user selectable criteria and the use of Cognos and Crystal Reports.

Brooklyn, Ny, Us

• Maintained and supported a computer lab with over 300 devices including Windows computers, Macs, printers, and scanners. • Migrated Windows XP Novell environment to Windows 7 being administered by Active Directory.• Deployed computers through an imaging system and set up account privileges/security for Macs and PC.• Tutored users on installed applications (Microsoft Office Suite, Adobe Acrobat, etc.) and assisted them with the general computer usage and operation.• Trained incoming new employees and briefed them on the facility’s operation policies.