Randy Castro Email & Phone Number

New York, Ny, Us

Woonsocket, Ri, Us

● Report analysis with Microsoft EXCEL using VLOOKUP / Pivot Tables / Excel Scripting / Data Importing / Filtering results of reports to identify core data elements, and applying changes when applicable● Performing in a high volume, fast-paced organization with working with multiple projects and clients concurrently● Applying Data Profiling, Data Cleansing, Data Mapping on audits and handling filing with the IRS

Charlottesville, Virginia, Us

● Generated Ad-hoc database reports using Microsoft SQL Server to support budgeting analyses● Incorporated Alteryx workflows to facilitate ETL processes and applied predictive modeling to 3 years historical data to project future outcomes● Operated daily handling and refreshing of dashboards on Tableau Server, with regular updates when necessary● Supported marketing campaign reporting of 400,000+ direct contacts for multiple businesses nationwide

New York, Ny, Us

● Aggregated data, made use of logical formulas, and applied Pivot tables to develop interactive Excel dashboards for optimal reporting layouts ● Corrected and validated data on Dynamics 365 CRM● Reduced time-consuming manual reports by introducing automated scripts and procedures● Displayed effective verbal and non-verbal communication skills when briefing team leads, and program directors

Los Angeles, Ca, Us

Category Recommendations For The Prospective Bilingual Youtuber• Queried 171,149 trending Youtube videos using SQL to determine category bias• Extracted 33,085 English & Spanish videos from the United States and Mexico, visualizing the findings using Tableau• Discovered viewer habits/interest by category are dissimilar between US and MX, with a limited positive shared audience focused on ‘Education’, ‘How-to & Style’, and ‘Pets & Animals’, whereas categories pertaining to ‘Entertainment’ and ‘News & Politics’ are highly engaged and simultaneously highly disliked in both countriesNYPD Civilian Complaint Review Board Analysis• Explored 33,358 records by the NYPD’s independent oversight board (CCRB)• Of 77 precincts in all boroughs, 25 reported more than 500 complaints; Bronx, parts of Brooklyn and portions of Queens exceeding 1,000+ complaints per precinct in recent years• 46% of reports remained ‘Unsubstantiated’ with zero resolution. ‘Substantiated’, or occurred, made up less than 25% of the total datasetTokyo Airbnb Sentiment/Trend Analysis• Parsed and cleaned 15,008 entries, assigning a positive/negative value to english words• Deployed several python packages to count words, assign values, translated Japanese to English natively, and used Regex to clear user comments of filler• Found the ‘Most Positive’ use cases associated with Airbnb descriptions displaying Japanese and English translation, with pure Japanese descriptions of hosts rating the highest while simultaneously being the most criticized by rentersIEEE CIS - Determining Risk Factors in Customer Data to Detect Fraud• Processed 600,000+ anonymous customer credit/debit transactions tracked over a 6 month period• Implemented Statistical Significance Tests to determine relationship between Time/Day of transactions, and type of transaction• Created visualizations demonstrating high correlation of fraud occurring on certain days of the week, and the anonymously assigned hours of ‘4’ to ‘9’

• Facilitated purchases and sales for a network of 4,000 members in the New York metropolitan area and 50,000+ global affiliates• Generated revenues exceeding $300K+ in sales for consecutive months in Q3 & Q4 of 2019• Successfully negotiated contracts for clients with household brands and NY-Centric media/advertising related companies including SpectrumTV-NY Metro, Firefly, The New York Post, The Real Deal, several Times Square billboards, etc.• Processed and superintended $1MM of incoming/outgoing inventory of hard goods and shipments using CRM systems and third party logistics• Trained new-hires on the sales team to achieve performance goals

ブルックリン区, ニューヨーク, Us

• Provided support to Japanese management to reach a quota of 500 bowls per day by counseling on American dining etiquette, delegating roles to waitstaff, and maintaining a work environment to the highest of Japanese standards• Surveilled the entire patron experience, fulfilling customer requests, applying finishing touches to orders and managing restaurant flow with keen attention to speed and accuracy• Contributed substantially in establishing current menu, FOH operations, restaurant layout, and aided in delivering a successful promotional campaign through social media• Introduced solutions for a previously unservable but crucial menu item by promoting its concept and improving both time efficiency in preparation and presentation

Education record

Education record