Amanda Lopes

Amanda Lopes

Internship in Instrumentation & Control System

Followers of Amanda Lopes1000 followers
location of Amanda LopesColumbus, Ohio, United States

Connect with Amanda Lopes to Send Message

Connect

Connect with Amanda Lopes to Send Message

Connect
  • Timeline

  • About me

    Senior Quantitative Analyst at JPMorgan Chase & Co.

  • Education

    • Gulf Indian School , Kuwait

      2006 - 2011
      High School HIGH SCHOOL/SECONDARY DIPLOMAS AND CERTIFICATES
    • University of Cincinnati Carl H. Lindner College of Business

      2017 - 2018
      Master's degree Management Information Systems and Services

      Data Analytics Certified

    • K. J. Somaiya Institute of Engineering and Information Technology Somaiya Ayurvihar Complex Eastern Express Highway Sion Mumbai 400 022

      2012 - 2015
      Bachelor’s Degree Electrical, Electronics and Communications Engineering
  • Experience

    • AL Meer Technical Services Co WLL

      Jun 2014 - Aug 2014
      Internship in Instrumentation & Control System

      The two-month internship training was in the field of Instrumentation & Control System pertaining to general industrial plants and Oil & Gas production facilities. It also involved in familiarising with other departments of the company. The focus was on following topics:1. Process Safety Management and Functional Safety Management2. DCS & PLC configuration, characteristics and controller tuning3. Control valve selection, characteristics and controller tuning4. Exposure to smart process control instrumentation Show less

    • Infosys

      Jun 2015 - Jun 2017
      Senior System Engineer

      •Consulted with the clients of US-based Healthcare industry to automate the process of correspondent generator•Translated requirements into design documents and approach documents •Developed and enhanced application in healthcare domain using Pega PRPC tool•Build the application by implementing use case, workflows, activities, rules, soap services •Designed simple, relevant and user-friendly UI.•Implemented design thinking in the project by automating processes such as skill-based routing technique•Created Agents to performed auto-approval every morning using SLA•Developed Listeners to detect CSV files, parse it and map the data to the clipboard.•Incorporated Pega Guardrails to maintain code standards•Created rulesets and products for migration between environments •Performed extensive debugging of with the help of Tracer, Clipboard and SMA•Involved in Integration-Connecting to disparate systems like HPX, FileNet, Tibco•Active in all aspects of the software Development life cycle and followed Scrum methodology. Show less

    • NetJets

      May 2018 - Dec 2018
      Business Insights & Analytics Intern

      CENTER OF EXCELLENCE - VISUAL ANALYTICS• Analyzed the flight data for owners (NetJets customer) to understand their flying pattern, choice of plane, hotspots and provided sales executives with a Tableau dashboard which tells the story of every owner flying NetJets• Collaborated with diverse teams to develop a solution for Business users to ingest their insights into tableau dashboard by integrating technologies like SharePoint, Tableau and Data Vault• Understood NetJets data and perform data manipulation using SAS enterprise guide for various projects• Designed a dashboard to track and analyze scheduling tool which includes donut chart, interactive functionality, viz in tooltip and bar chart. It helped to detect duplicates, failures and reduced load on the system.• Developed the Tableau landing page which links to all the dashboard used at NetJets. Some features of this look up dashboard is as follows:- Row level security so that a logged in user can only see dashboards they have access- Sort the dashboards based by most viewed dashboards- Search capability- Similar dashboards for Dev and QA environment with relevant information- Provides information of which users have access to a project/dashboard- Request Access to new dashboards• Participated in NetJets hackathon 2018 and presented my work to the CEO and executive team during my internship Show less

    • NetJets

      Feb 2019 - Mar 2022
      Operational Analyst

      Team: Crew and Safety Analysis• Created an algorithm to tactically allocate slots for overtime duty for crew members and developed an optimization model to identify crews to ask for overtime duty to meet the daily crewing targets and minimize cost. Improved the existing process of awarding overtime by automating processes which saved approx. 10 hrs. of manual work per day• To tackle existing crisis of reduced commercial airline capacity due to COVID-19, finalized a set of 30 airports locations (crew hubs). Using IBM ILOG CPLEX optimizer, provided most optimized crews paired together to start their duty from these selected airports.• Award work schedules to crew members based on seniority• Visualized and analyzed data to obtain crewing outlook that empowered leadership team with data to make apt decisions about crewing with respect to recent increased demand.• Built a dashboard which allows NetJets to contact/track crew members on duty in case of an emergency.Team: CENTER OF EXCELLENCE - VISUAL ANALYTICS• Created a dashboard template via multiple brainstorming sessions with team members. This template provides information of data refresh times, scores, preferred color templates and other relevant information. This is used as the header of all the dashboards developed in the company to maintain consistency and brand value. • Collaborated with team members to score dashboards developed inhouse and provide valuable guidance to help analyst develop dashboards as per the standards set in the company. This also provides users information of quality of the dashboard used. • Tableau Doctor – Provide advice and mentoring to analysts with Tableau related queries to produce quality dashboards complying with company standards. Show less

    • JPMorgan Chase & Co.

      Mar 2022 - now
      Senior Quantitative Analyst

      Wealth Management Decision SciencePassionate about leveraging data to drive strategic marketing decisions and optimize campaign performance. Proven track record in conducting insightful analysis, implementing data-driven strategies,customer segmentation, KPI measurement, and digital marketing analytics. Excel in translating complex data into actionable insights to propel business growth.

  • Licenses & Certifications

    • Healthcare enrollment and Billing

      Infosys
    • Tableau Desktop Certification

      Tableau Software
      Oct 2018
      View certificate certificate
    • Optimization Modeling Essentials

      IBM
      Sept 2021
      View certificate certificate
    • SAS Base Programming 1

      SAS
      Nov 2019
      View certificate certificate
    • Kickboxing - Orange belt

      WAKO TEAM USA KICKBOXING
      Nov 2016
  • Honors & Awards

    • Awarded to Amanda Lopes
      Third prize in the NBC Universal Analytics Challenge - Apr 2018 Represented team University of Cincinnati for the NBC Universal Analytics challenge held by AIS Student Chapters at the University of Texas, Dallas. The event saw more than 50 entries from across the world of which only 10 were selected as finalists. Of the 10 finalists, our team achieved the third position for our analysis.Does speed matter in e-commerce?● QVC’s dataset was analyzed to derive insights and suggest implementable business solutions on market penetration, product… Show more Represented team University of Cincinnati for the NBC Universal Analytics challenge held by AIS Student Chapters at the University of Texas, Dallas. The event saw more than 50 entries from across the world of which only 10 were selected as finalists. Of the 10 finalists, our team achieved the third position for our analysis.Does speed matter in e-commerce?● QVC’s dataset was analyzed to derive insights and suggest implementable business solutions on market penetration, product distribution and delivery latency time● Devised the most accurate metrics by querying using SQL on big data● Implemented K- cluster algorithm to propose warehouse locations considering the geographic distribution of customers● Presented insights on infographics using Piktochart and TableauFind more at:https://www.uc.edu/news/articles/legacy/enews/2018/04/e26377.htmlhttps://create.piktochart.com/output/29616379-qvc-ais-analytics-challengehttps://public.tableau.com/views/QVC_3/Story2?:embed=y&:display_count=yes&publish=yesTeam Members: Hansel D'Souza, Nikhil Kurnool, Akhil Mudgil, Satyam Singh, Amanda Lopes Show less
    • Awarded to Amanda Lopes
      Second Prize in the 84.51˚ Analytics case competition - Sep 2017 The Analytics challenge provided us with a “Fortune 500 Company’s” transactional data set containing 1.5 million rows to determine if customers preferred larger pack size offerings or multi-packs. First, the data was cleaned and made comprehensible using R. Then the excel file was ingested into tableau to create stacked bar chart, drill down pie chart and tree map to investigate data and derived insights. Finally, recommendations were presented along with external data to support the… Show more The Analytics challenge provided us with a “Fortune 500 Company’s” transactional data set containing 1.5 million rows to determine if customers preferred larger pack size offerings or multi-packs. First, the data was cleaned and made comprehensible using R. Then the excel file was ingested into tableau to create stacked bar chart, drill down pie chart and tree map to investigate data and derived insights. Finally, recommendations were presented along with external data to support the claim.https://www.slideshare.net/AmAndAplopez/second-prize-84670590 Show less
    • Awarded to Amanda Lopes
      Math Topper - May 2015 Topped in Mathematics in the CBSE 12th board exams in Gulf Indian School, Kuwait
    • Awarded to Amanda Lopes
      First prize in Technical presentation - Oct 2014 The presentation was themed on "Automation in Healthcare".
    • Awarded to Amanda Lopes
      Infosys Award -
  • Volunteer Experience

    • Data Analyst- Visualization

      Issued by Haiti Now (Ayiti Now Corp) on Nov 2018
      Haiti Now (Ayiti Now Corp)Associated with Amanda Lopes