Oscar Castro Email & Phone Number

Portland, Me, Us

Portland, Maine, United States

Portland, Maine, United States

At Arkatechture, I am passionate about helping our clients solve some of the most pressing data challenges they face, such as identifying redundancies in data that have resulted in savings of over 5 TB of premium storage in their Enterprise Data Warehouse. •Test and validate code modifications to maintain data quality and mitigate unwanted data loss•Document and communicate insights to technical and business audiences•Develop source-to-target mappings (STTM) for data sources and transformations within data pipelines•Process, clean, and verify the integrity of data used for analysis using data profiling techniques•Build data tables and views using SQL used in dashboard creation•Utilize documentation and project management tools (e.g., Jira, Confluence) to collaborate effectively

Brunswick, Maine, United States

At Wayfair, I supported the International Supply Chain and Finance Operations teams by discovering process improvements in Accounts Payable. •Leverage technical tools to reduce manual invoice review processes. In Q1-2021, 67% of invoices were reviewed using a process I independently and proactively developed using strong data wrangling techniques. This reduced the amount of time spent reviewing manual invoices by approximately 12 hours each week.•Discovered over $50K USD in overcharges from different vendors during Q1-2021 thanks to strong attention to detail skills as well as a strong understanding of supply chain and freight contracts.•Solved a wide range of EDI (electronic data interchange) issues with vendors by applying solid collaboration skills and an analytical approach that allowed for pattern recognition and helped locate root causes.

Los Angeles, California, United States

As a Business Solutions Advisor I was passionate about helping our clients discover, monitor, and improve their customer experience by combining field-based resources and using analytics-driven technology. •Produced accurate and consistent daily evaluations in brand standards, quality assurance, and risk analysis.•Communicated findings effectively and established action plans that aligned with the client's procedures and goals.•Built strong relationships with key stakeholders and served as a liaison between management companies and our client.•Managed travel logistics adhering to budget guidelines and accurately reported business expenses and billable hours.

Boston, Massachusetts, United States

As an Operations Team Leader, I collaboratively executed daily operations of one of the largest hotels in Boston, Massachusetts. With a consistent occupancy rate of over 98%, I helped solve a wide range of unforeseen challenges (eg. technical, billing, operational) in a fast-paced environment. •Analyzed operational metrics and assisted in the creation of paths to reach individual and team goals improving client satisfaction by 5% in 30 days.•Reconciled 500-800 daily transactions and resolved discrepancies ensuring proper accountability of revenue.•Led team in client buy-in to different Marriott programs which increased operational efficiency by 20% to 25%.•Coached and developed current and new staff members allowing for productive cross-departmental collaboration•Analyzed historical data to forecast adequate staffing levels

Master Of Professional Studies, Analytics

Online Certificate, Data Analytics

Curriculum developed in partnership with Microsoft, mastering skills in Python, SQL, Excel, Tableau, Power BI, and hypothesis testing. 1:1.

Online Certificate, Business Analytics, Economics For Managers, And Financial Accounting

Bachelor Of Arts - Ba, Hospitality Administration/Management