Jan Iman Eduard Castro
About
Detail
Data Analyst
Central Luzon, Philippines
Contact Jan regarding:
work
Full-time jobs
connect_without_contact
Finding mentors
Finding co-founders
groups
Networking
Timeline
work
Job
school
Education
Résumé
Jobs
verified_user
0% verified
- TCRM ExecutiveTravel + Leisure Global Support ServicesMay 2024 - Current (1 year 2 months)• Utilizing Simon Data to effectively segment target audiences for optimized marketing campaigns • Deliver Targeted and tailored email to customer to increase bookings across specific regions and club market • Tracked performance in the APAC region and monitored tailored marketing campaigns to drive engagement and increase bookings among segmented members using PowerBI • Utilizing Snowflake/SQL to filter and gather member data for creating detailed reports • Collaborated weekly with marketing team to strategize ways to leverage bookings and increase engagement across APAC members • Supporting cross-functional teams by efficiently handing ad-hoc data and task request
- SData AnalystSLI ConsultingOct 2023 - Dec 2023 (3 months)• Utilized Excel functions to filter and clean data sets • Removes unnecessary information to ensure data accuracy and relevance • Successfully upload a refined data to CRM web platform • Proficiently utilizing SQL to conduct data gathering • Applied basic to intermediate scripts to filter, sort, and group data within the database • Contributed to enhance data organization and retrieval process
- BEnglish TrainerBizmates PhilippinesJul 2022 - Current (3 years)• Providing guidance and support: I provide guidance and support to my students to help them improve their casual and business English language skills. • Assessing student's progress: We evaluate the progress of the student regularly and I provide feedback regarding on their performance. • Creating a fun and positive environment: I create a learning environment that is fun yet conducive to learning for them to get used to English language. • Continuously improving teaching skills: I am responsible for continuously improving their conversational skill, keeping up-to-date with the lasts trends and techniques in Learning English and applying it to our lessons.
Data AnalystDataquestJan 2020 - Oct 2023 (3 years 10 months)• Extracting data from multiple sources including databases • Using Excel to clean, transform and manipulate data • Utilizing Tableau/PowerBI to generate visual appealing dashboards to identify patterns, trends, and insights to support decision-making • Collaborated weekly with Sales Department to present comprehensive visualization dashboard highlighting key metrics and trends to enhance decision-making processes and drive revenue growth • Weekly meeting with Marketing Department to analyze customer buying pattern and behavior to enhance business revenue, create visualization showcasing successful advertising strategies with data. Conduct market analysis to identify improvement opportunities in advertising strategies to acquire new cu- TBusiness OwnerTastes from the GreensDec 2019 - Aug 2022 (2 years 9 months)• Operation Management: I am responsible for managing day-to-day operations of the shop, not limited to opening and closing the shop, managing staff schedules, ensuring safety and hygienic environment inside the store. • Financial Management: I'm responsible for managing the finances that comes in and out of the shop including budgeting, forecasting and monitoring expenses and revenue. This includes paying bills on time and keep accurate record. • Marketing and Sales: I am responsible for creating and executing marketing strategies to promote our new and existing products to new and existing customers. This includes social media marketing, advertising and promotional events. To stay competitive and relevant in the market, it's crucial to
- SOwnerSun & Suds Laundry ShopJul 2017 - Mar 2020 (2 years 9 months)• Ensuring quality control: I ensure that laundry is properly cleaned, ironed and folded to meet customer standards, and quality measures are followed. • Managing Inventory: I ensure inventory levels of laundry supplies such as detergents, fabric softeners and laundry bags to ensure adequate supplies are available at all times. • Maintaining equipment: I oversee the maintenance and repair of laundry equipment to ensure that it is in good working condition and that downtime is minimized. • Handling customer complaints: I address customer complaints and concerns in a timely and professional manner to ensure customer satisfaction.
- PFinancial advisorPhilam LifeJul 2017 - Jul 2019 (2 years 1 month)• Developing financial plan: I work with clients to develop comprehensive financial plans that meet their short-term and long-term goals. This Includes analyzing financial data, assessing risk tolerance and recommending appropriate investment strategies. • Managing investment portfolio: I am responsible for managing and overseeing my clients' investments portfolios. It includes conducting research, analyzing market trends, and making investment recommendations. • Providing investment advice: I provide advice on investment products, including stocks, bonds, mutual funds and other investment vehicle. I provide advice to my clients how to minimize the risks and maximize return. • Identifying new clients: I identify and acquire new clients
- BFinancial advisorBDO Life (Philexcel Park,Aug 2016 - Feb 2017 (7 months)
- SStore SupervisorSuyen CorporationJul 2015 - Apr 2016 (10 months)• reaching sales target per month and increasing the profit • assisting customer inquiries and complaints • overseeing stock control and receiving deliveries • interviewing and recruiting new staffs to fill up the organization roles • conducting monthly meeting with the staffs • Conducting monthly general cleaning of the store to ensure cleanliness • cash handling/receiving of payments if cashier is on day-off • visual merchandising • ensures all prices are correct • attending monthly meeting of the managers in our head office • ensures all sales are correct and to be deposited the next day • correct filling of overtime, monthly shifts, weekly shifts
- GCustomer Service RepresentativeGlobe Telecommunications (SM Clark)Oct 2014 - Mar 2015 (6 months)• Resolves product or service problems by clarifying the customer's complaint; determining the cause of the problem; selecting and explaining the best solution to solve the problem in a proactive manner; expediting correction or adjustment.
- Data AnalystQ2 HR SolutionsJun 2011 - Aug 2014 (3 years 3 months)• Conducted data analysis using SQL including data cleaning/preprocessing, to identify trends, patterns, and insights that will upscale business decisions. • Created visualizations using tools such as Excel and Microsoft Offices to effectively communicate and report findings to stakeholders. • Developed and maintained reports and dashboards to track and monitor key performance metrics. • Assisted in the management of data quality, ensuring accuracy, consistency, and completeness across databases and systems. • Collaborated with cross-functional teams to understand data needs and develop solutions that supported business objectives. • Participated in team meetings and contributed to the development and execution of data-driven projects
Education
verified_user
0% verified
- UBachelor of Science in Computer ScienceUniversity of the AssumptionJun 2008 - Apr 2014 (5 years 11 months)