Amanda Lopes Email & Phone Number

Columbus, Oh, Us

Columbus, Ohio, United States

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.

Columbus, Ohio Area

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.

Columbus, Ohio Area

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

Pune Area, India

•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.

Kuwait

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

Master'S Degree, Management Information Systems And Services

Data Analytics Certified

Bachelor’S Degree, Electrical, Electronics And Communications Engineering

High School, High School/Secondary Diplomas And Certificates