Edmar Ocampo

Edmar Ocampo

$20/hr
Data ANALYTICS Pro | EXCEL and GSHEET Wizard | DASHBOARD Developer
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Philippines /Mabalacat, Pampanga, Philippines
Experience:
15 years
EDMAR N. OCAMPO Senior End of Line Process Engineer | Data Analytics Pro| Volunteers Program Manager Address: Madapdap Resettlement, Mabalacat, Pampanga, Philippines LinkedIn: Edmar Ocampo LinkedIn Portfolio: Edmar Ocampo Email:- Phone: - Skills:  Data Analysis and Visualization  Advanced Excel (Pivot Tables, VLOOKUP, Macros)  Google Sheets (Importrange, Query Function)  Power BI and Spotfire  SQL Querying  Data Cleansing and Quality Assurance  Report Automation  Dashboard Creation  Presentation Design (PowerPoint)  Lean Six Sigma  Failure Analysis  Lean Manufacturing  SPC (Statistical Process Control)  Problem Solving  Process Improvement  Cost savings and Material Qualification Profession Summary: Dependable and self-motivated professional with over 15 years of experience in data analytics, process engineering, and project management. Expert in leveraging advanced Excel and Google Sheets skills to automate reports and create insightful dashboards. Proven track record in managing multiple projects, improving efficiency, and achieving cost savings. Known for strong analytical thinking, problem-solving abilities, and effective utilization of data analytics tools and methodologies. Top-rated freelancer with a 95% job success score and Senior Process Engineer. Data Analyst Projects: Interactive Real Estate Dashboard: Developed a comprehensive dashboard to track property metrics and market trends, enabling better decision-making for real estate investments. COVID-19 Survey Analysis: Conducted data exploration and linkage to analyze survey results and identify key trends, providing actionable insights for public health strategies. Election Result Comparative Analysis: Created dashboards to compare and analyze election results across different regions, facilitating clear visual representation of data. Salesforce Health Check Dashboard: Implemented a dashboard to monitor and optimize Salesforce performance, improving operational efficiency. Google Ads Dashboard: Designed an interactive dashboard to track and analyze Google Ads performance, helping clients optimize their advertising strategies. Customer Journey Pipeline Dashboard: Created a visual representation of the customer journey, enabling better tracking of customer interactions and improving conversion rates. Income & Expense Analysis: Developed tools for analyzing and visualizing income and expenses, providing clearer financial oversight for businesses. Employee Efficiency Dashboard: Monitored and visualized employee performance metrics, aiding in the optimization of workforce management. Relevant Projects: QFN Resin Blade Qualification and Sourcing (2019 – Present) Request bidding and perform selection of suppliers in terms cost, life and quality. Perform evaluation and risk assessment to check if material meets the quality standard. Accomplish monitoring, data gathering of actual performance during implementation. Prepare and route essential documents for the new material. The impact of the Material Qualification and Sourcing projects includes a $450k actual savings, with 60%-300% life improvement and 75% LRR reduction on EOL relate jams at Final Test from 2022 to date, a $27k actual savings and 200% life improvement for 2021, and a $2.8k actual saving for 2019. These successful projects have had a significant positive impact on the company's financial performance and material quality. Defect Elimination through Parameter Optimization and Material Evaluation (February 2018 - December 2019) This project involves an extensive defect characterization and analysis process to identify possible causes of defects through DMAIC and 8D Methodology. A Design of Experiment is conducted to identify the optimum parameters for improving performance and reducing defects. Additionally, new material qualification is performed to further improve yield and overall performance of the product. The ultimate goal of reducing defects and improving performance for this project has been achieved, resulting in zero customer returned units. This outcome underscores the success of the project and speaks to the effectiveness of the defect reduction strategies implemented, demonstrating the positive impact of optimizing parameters and evaluating materials. Efficient Lead frame Design: Eliminating Excess Tie Bar Material -) This project involves proposing a new lead frame design and aligning stakeholders on the designated task. After this, an evaluation and risk assessment are conducted to check if the new design meets the quality standard. Monitoring and data gathering of actual performance during implementation are carried out, and essential documents for the new design are prepared and routed to ensure seamless implementation. This project is a Zero-Defect Initiative resulting in a 30% improvement in yield and a Zero Lot Rejection Rate. This outcome underscores the success of the project and speaks to the effectiveness of the proposed lead frame design, demonstrating the positive impact of aligning stakeholders, conducting thorough evaluations, and monitoring implementation. The yield improvement and zero lot rejection rate demonstrate a commitment to quality, resulting in increased efficiency and cost savings for the organization. Professional Experience: Freelance Data Analyst at UpworkFeb 2021 – Present Conducted data cleanup and codebook revisions, ensuring data accuracy and integrity. Developed dynamic dashboards for various industries, including real estate, marketing, and healthcare. Extracted and analyzed data from databases using advanced SQL techniques. Audited and repaired complex spreadsheets to improve efficiency and accuracy. Created tailored Excel and Google Sheets solutions, including financial models, KPI monitoring systems, and cost reduction programs. Designed compelling PowerPoint presentations to effectively communicate findings and insights. Texas Instruments, Clark Freeport Zone PampangaMarch 2012 – Present End of Line Process Engineer Designed, developed, and optimized semiconductor manufacturing processes for various products, resulting in improved yields and cycle times. Conducted statistical process analysis (SPC) to identify and solve manufacturing problems, resulting in a 30% increase in product yields. Collaborated with cross-functional teams to drive process improvements and cost reduction initiatives which leads to more than $479,000 cost savings. Coordinated with vendors to ensure timely installation and qualification of new process material which impacted to 60% increase in material life reducing the in between down time. Process optimization and improvement using data analysis and statistical tools (e.g., SPC, DOE) Developed process flow charts, control plans, and work instructions to ensure consistent manufacturing practices. Conducted equipment and process training for production personnel, resulting in improved quality and productivity. Established clear goals and objectives for the project and communicate them to all team members. Set up a system for tracking progress and identifying potential issues, such as regular meetings and clear lines of communication. Regularly assessed processes and procedures, taking measurements and interpreting data to identify areas for improvement. Developed best practices, routines, and innovative solutions to improve production and reduce costs. Perform root cause analysis and risk assessments to identify and address potential problems. Review the Key Performance Indicator (KPI) monitoring systems to determine ways to improve their effectiveness in maintaining company operations. Acts of Love Community (Non-Profit Organization)September 2017 - Present Program Manager Managed and coordinated the activities of volunteers for an organization or event, ensuring that the organization's goals and objectives were met. Developed and implemented volunteer policies and procedures and trained and supervised volunteers. Provided recognition and support to volunteers and worked closely with other staff members and volunteers to create a positive work environment. Demonstrated strong leadership skills and a commitment to providing high-quality volunteer experiences. Trainings: Regular Company Trainings | Texas Instruments Control Plan DMAIC 1 (Define, Measure, Analyze, Improve, Control) Failure Mode & Effects Analysis (FMEA) 8D/CAPA Methodology Seven Quality Control (7QC) Tools Statistical Process Control (SPC) Engineering 5S Six Sigma Green Belt (CSSGB) November 2023 Google Data Analytics August 2023 Excel Fundamentals for Data Analysis April 2023 Certified MS Excel Specialist October 2022 Become a Data Analyst July 2022 Other Trainings: https://www.linkedin.com/in/edmarocampo/details/certifications/ Licensure Examination: Registered Electrical Engineer Licensure Examination September 2011 Score: 84.45% Volunteering Experience: Acts of Love Community Project Dunong October 2022 – Present Core Team Lead Tree Planting and Brigada Eskwela August 2022 Core Team Lead Visit the Angels of Duyan ni Maria January 2022 Core Team Lead Organization Facebook: https://web.facebook.com/actsoflovecommunityofficial Character Reference: Renmark A. Salalila MIS Head, Mabalacat City College Pampanga-
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.