William Castillo Email & Phone Number

Taylor, Texas, United States

𝗦𝘂𝗺𝗺𝗲𝗿 𝗣𝗿𝗼𝗷𝗲𝗰𝘁:● Designed and developed a Power BI dashboard to visualize and analyze Jira issue tracker data from Oracle DB, enabling managers to track task durations and measure performance against Service Level Agreement (SLA) metrics.● Conducted data extraction, transformation, and analysis using SQL and Power BI to identify trends in task completion times and areas for process improvement in the Change Management process.● Collaborated with the Release & Change Management team to understand and analyze data on change request submissions, tracking progress and outcomes to ensure SLA compliance.● Participated in Change Advisory Board (CAB) meetings, applying insights from data analysis to help assess the effectiveness of change request approvals and their impact on operational performance.● Gained expertise in analyzing different types of change requests—standard, emergency, and normal—and their implications on system reliability, NERC compliance, and overall process efficiency.𝗠𝗮𝗿𝗸𝗲𝘁 𝗧𝗼𝗽𝗶𝗰𝘀 𝗟𝗲𝗮𝗿𝗻𝗲𝗱:•Locational Marginal Pricing (LMP) and its role in price formation within the energy market, including calculating new LMPs, due to congestion, Shift Factors, shadow pricing, and price adders.•Security Constrained Economic Dispatch (SCED) and its role in the day-ahead market:- State Estimation- Contingency Analysis- Economic Dispatch•Ancillary Services in the energy sector, focusing on functions such as managing frequency deviations and providing fast-responding capacity during demand fluctuations, while gaining knowledge about the four types of ancillary services: -Regulation-Responsive Reserve Service (RRS)-Emergency Contingency Reserve Service (ECRS) -Non-Spinning Reserve Service

Austin, Texas, United States

• 𝗦𝘆𝘀𝘁𝗲𝗺 𝗠𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻: Collaborated in the successful migration of macOS computers to a new central management system, transitioning from an outdated server to a campus-wide JAMF management server. This migration resulted in enhanced system integration, streamlined management, and improved security compliance.• 𝗥𝗲𝗺𝗼𝘁𝗲 𝗧𝗿𝗼𝘂𝗯𝗹𝗲𝘀𝗵𝗼𝗼𝘁𝗶𝗻𝗴: Utilized Beyond Trust software and MacOS ScreenSharing to remotely access and troubleshoot user computers, ensuring efficient resolution of technical issues and enhancing user satisfaction and productivity.• 𝗦𝗲𝗿𝘃𝗶𝗰𝗲 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: Managed service requests and reported issues through the ServiceNow ticketing system, prioritizing and resolving tickets effectively.

San Marcos, Texas, United States

Austin, Texas, United States

● Audited, analyzed, and resolved intellectual property infringement reports by systematically reviewing data to identify and address potential violations, contributing to risk management efforts.● Leveraged data insights to assess emerging industry trends, potential escalations, and recommended enhancements to tools and workflow processes.● Prioritized and managed high-revenue client issues, achieving a 100% resolution rate within designated timeframes.● Collaborated with cross-functional teams to devise data-driven strategies for intellectual property protection.● Monitored and analyzed changes in intellectual property laws and regulations, ensuring compliance and facilitating informed, data-backed decision-making.

Austin, Texas, United States

• 𝗟𝗲𝗮𝗱𝗲𝗿𝘀𝗵𝗶𝗽 & 𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝘀: Assumed a leadership role in overseeing store operations in the absence of the store manager. Ensured seamless execution of daily activities, maintaining operational efficiency and service quality.• 𝗖𝗼𝗺𝗽𝗹𝗶𝗮𝗻𝗰𝗲 & 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆: Maintained strict adherence to operational protocols, including cash handling procedures, safety protocols, and security measures. Guaranteed a secure and compliant environment, contributing to the store's overall integrity and trustworthiness.• 𝗧𝗿𝗮𝗶𝗻𝗶𝗻𝗴 & 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: Actively participated in the onboarding and training of new team members, contributing to the development of approximately 15 partners annually. Facilitated their integration into the team, enhancing their skills and performance.• 𝗚𝘂𝗶𝗱𝗮𝗻𝗰𝗲 & 𝗦𝘂𝗽𝗽𝗼𝗿𝘁: Provided hands-on guidance and support to new team members, fostering their growth within the company. Ensured effective integration into the team, promoting a collaborative and supportive work environment.• 𝗢𝗿𝗴𝗮𝗻𝗶𝘇𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗦𝗸𝗶𝗹𝗹𝘀: Demonstrated exceptional organizational skills and a keen eye for detail. Ensured a consistently high level of service and customer satisfaction, contributing to the store’s positive reputation and success.

Master Of Science - Ms, Information Science, 4.0

Emphasizes the practical application of analytical and technical tools to solve organizational issues, with a focus on data manipulation.

Bachelor Of Arts - Ba, Computer Science, 3.67

𝐂𝐨𝐮𝐫𝐬𝐞𝐰𝐨𝐫𝐤: -Computer Architecture -Computer Ethics -Computer System Security -Data Structures -Database Systems -Discrete Mathematics.

Associate Of Science - As, General Studies

•Completed foundational courses in C++ and Python, focusing on structured programming principles. •Acquired in-depth knowledge of data.

Associate Of Arts - Aa, General Studies