Mastercard

What do you think makes a company good to work for? What do you like about your current company? What could be better?

- A company that cares about and supports its employees while also challenging them to grow with the company. A shared commitment between employees and managers to both individual and company success. Transparency at all levels - Like about current company - Trust. When the individual who was initially supposed to jumpstart and lead the BI project left the company, my manager gave me the opportunity to take it on, adjusting timelines to allow for a ramp up period so that I could become familiar with the tool and learn SQL. Fortunately, I was able to take online courses after business hours to learn at a quicker pace than was expected so that the company was able to reap the rewards of its investment in the BI platform itself, and in me taking on the role earlier than expected. By doing so, I was able to complete the initial phase of data and dashboard design 2 months earlier than expected. - Could be better about current company - Communication frequency from Leadership. I would like to hear more updates from our Leadership team on the state and direction of the company. For example, individual goal-setting period begins this week, but we have not heard the company's goals for 2022 yet. I feel it's important to know the goals of the company before employees set individual goals so that its employees can fashion their own goals towards moving the needle for the greater good of the company as a whole and feel enthusiastic about the contribution we make to the success and progress of the company's goals.

Biggest Challenge in Role

A couple of months into my current role, the Director of Business Systems left the company. At that time, she was the one leading the roll-our of our new BI platform, creating the data models, and building dashboards. When she left, I was handed an entirely new platform of unfinished data models and dashboards and asked to be its administrator. Our goal for that year was to implement the dashboard from scratch, replace all existing manual dashboards with automated ones, onboard end users to the platform and earn trust in the data and platform. I had never used SQL before or worked with a BI tool. So that we could keep the momentum, I spent time before and after work hours each day to take SQL courses online so that I could pick up where my former colleague had left off. At the onset, I was only chipping away slowly at modeling the data, but as to keep stakeholders involved and equally as excited for what was to come, I worked with them to identify the highest priority dashboards to develop so that they had the tools needed to run their business effectively. As a means of keeping them in the loop, I created a spreadsheet with a Dashboard Roll-Out timeline with the prioritization of dashboard releases, their status, risks, and expected delivery dates so that they always knew what was being worked on and when they could expect the report. By the end of that year, I had successfully replaced the initial goals of replacing all 21 manual reports with automated reports in the BI platform and even crafted 9 entirely new ones. • Dashboard onboarding sessions and onboarding materials • Weekly office hours • 1:1s with individuals who have questions about how to use, what insights to draw

Tell me about yourself:

A little bit about myself — when I'm not working you'll usually find me either learning Spanish on duolingo or running outside — not fast of course. I would describe myself as being a particularly curious person — both personally and professionally — and I look to data to satiate that curiosity. I am tactful in that I enjoy using facts and figures to arrive at decisions and I'm always interested in learning new skills at work and on my own time that will make arriving at those decisions that much more accurate and efficient! In my career, I find the most fulfilling part of a job to be supporting the people I work with and making their lives easier. To see them achieve growth in their projects and careers gives me the deepest pride. Through data, I've helped my colleagues, and in turn, our company achieve higher levels of success, and now I am excited at the opportunity to do the same thing for Mastercard and its customers!

What has been your proudest accomplishment in your career?

At the end of the day, I've always found the most fulfilling part of my job to be supporting the people I work with and making their lives easier. To see them achieve growth in their projects and careers gives me the deepest pride. Through data, I've helped my colleagues, and in turn, our company achieve higher levels of success. This is something I'm excited for the opportunity to do at Mastercard as well, using data to substantiate business decisions and recommendations, and to propel growth and success for Mastercard and its customers. Example: Built a tool for a Business Unit Lead to increase her team's profitability by 26% in less than 6 months and exceed EOY financial targets.

Do you prefer working alone or in teams? Give examples of how you worked successfully both alone and in a team. What do you attribute your success to?

Both independent work and teamwork have their benefits and drawbacks. I am excited about the flexibility of this position because it will allow me to collaborate with others and also work independently. In my previous role, I worked as part of the Consulting team, and I enjoyed collaborating and learning from my colleagues and our team leader. However, I was also required to complete many research and data analyses independently, which I also enjoyed because it gave me the space I needed to focus. In my current position I have been given much room to initiate projects independently. With this experience, my attention to detail, and motivation to succeed and help the company, I am confident that I can make positive contributions in either environment.

What do you feel must be present in a successful business?

Company goals and values that employees feel passionate about and involved in. Shared values that employees can rally around. Something larger than their individual goals and aspirations. When I have clear direction on the goals and values of the company, I am more enthusiastic about setting individual goals for myself to contribute to those of the company. Accountability has also proven an important aspect for moving the needle on goals and remaining true to my values as is demonstrated by the agenda I have set in my current role with my manager. Each week I make it a point of reviewing the progress I have made towards achieving my goals — not matter how big or small the progress is, talking about it and remaining accountable by disclosing progress and updates to my manager has proven more effective.

Give me 3 adjectives you would use to describe your weaknesses/areas for improvement & the reasons why you feel you need to work on these.

Critical of myself - I'm the biggest critic of my own work. I can always find something that can be improved upon or changed. To help myself improve in this area and not go overboard, I give myself deadlines for Minimum Viable Products or Outputs. This helps ensure that I'm delivering what is expected of me and absolutely needed, and only if time allows or if there is an absolute need for improvements will I revisit and spend more time making changes / updates. For example, dashboards. Overly ambitious - Because I truly love my work and have ambitious career goals, it can be difficult for me to keep a healthy balance between work and my personal life. I have seen a negative impact on my motivation and focus when I ignore my personal needs. For this reason, I have made it a point to focus on creating space in my schedule to focus on volunteering and spending time with my family. When I maintain a good work/life balance, I have found my output is of higher quality, I get more work done and I feel excited about coming to work in the morning.

Tell Me About a Time When You Were Forced to Make an Unpopular Decision

Decision to implement a dashboard that scored individuals on their delinquent timesheets. • people are busy due to billable work • it's time consuming • they will feel "watched" Benefits: • Accurate costs at all times • we are professional services and it goes wiith the territory • it promotes regular behavior and actually will save employees time at the end of each month

6. Tell About a Time You Solved a Problem

HOSTING COSTS BEING APPLIED TO THE WRONG PROJECTS

Why are you a good fit for this role?

Here are the qualities I am bringing that I know will help me not just meet, but exceed expectations for this role: • A degree in Mathematics • 4 years of analysis experience • Experience with a Business Intelligence visualization tools (Sisense) • In all 3 of my roles, I have proven successful in providing direct analytical support to a variety of disciplines including Leadership, Finance and Accounting, Engineering, Product, and Sales & Marketing teams • A thirst for learning and a proactive nature in which I will go the extra mile to learn new tools and skills quickly so that I can be efficient for the company • The ability to be an effective independent worker and team player - I have experience doing both and find joy in either environment; willing to take the lead when need be, and support where necessary. • I also really enjoy having the time to focus on a task at hand and dive deep into the data. I feel that this role offers a nice balance of collaborative and independent, focus work, playing to both of my strengths :) • While I am not a SQL expert, I have demonstrated significant growth since starting to learn the language — I've able to take over a BI project in my current role and develop 30+ dashboards using SQL to model the data within 10 months of ever writing my first SQL query. I continue to challenge myself and spend evenings doing online challenges to further develop my skills because it is a programming language I am thoroughly intrigued by and eager to grow in through new, exciting challenges and experiences like the one that MasterCard offers.

What do you like to do outside of work?

I am currently being vetted to become a Big Sister with the Big Brothers Big Sisters program on Long Island. I love to run. Visiting my nieces and nephews. Attempting to cook (almost entirely with Ina Garten's recipes).

Give me 3 adjectives you would use to describe yourself & examples of your work style to support them.

I would describe myself as being • motivated / driven • curious / investigative • organized • reliable • resilient As an example, in the first few weeks in my current role as Lead Data Analyst, I set a short-term goal for myself to better understand our company's revenue-generating Business Units and the tools and data they relied upon to be successful. I scheduled 1:1 sessions with each Business Unit lead to familiarize myself with their business, goals, and pain points. As an outcome of these conversations, it was clear that aside from financial performance to date delivered in the form of a monthly P&L statement, the BU Leads did not have the foresight or tools needed to ensure their own financial success.I saw an opportunity to create tools that could be used by BU Leads to better plan their BU's future. I identified and pulled together a combination of new and existing data sources to report on historical and projected financial performance against annual targets. Using Salesforce to view expected revenue, creating an entirely new tool in Google Sheets to plan resource costs, and working with Finance to secure the financial targets for the year, I was able to develop a comprehensive dashboard in Google Sheets that displayed each BU's financial performance over time and projected performance compared to their annual targets.I scheduled monthly meetings with each BU to review performance to date and discuss what levers they could adjust to contribute to more successful future performance. By the end of the year, just 5 months after my first day as a Lead Data Analyst, 7 of the 8 BUs had successfully hit their targets. One BU even outperformed its GPM target by 3 points after being 25% below its target just 5 months prior. In the following year, all 8 BUs hit their targets, and the dashboard was recreated in Sisense with visual and automated enhancements.

If you were given a task to complete in an unrealistic time frame, what would you do?

I would do my best to be clear, transparent, and honest by providing an immediate estimate of the time required to complete the job and then evaluating if I have the time to complete it. • If I do then no problem. • If I don't it could be for 2 reasons. There just isn't enough time I have other things on my plate too, thus not enough time - In the case of the former I would immediately tell my boss, "in order for me to complete the job within the deadline I will need x, y, z resources or support from other teammates." - If that is not possible then I will tell him how much time I realistically need for the job. If he/she insists to do it in less. I will say, "I will do my best to complete it within the time you have asked, however, can only commit [my estimate] based on other things I have on my plate. I will keep you updated on the progress." - If the latter, I will then ask them to help me prioritize my current tasks to see what can be pushed to later so that I can instead focus on this job. Saying, "in order for me to complete this new job on time, I will need to reschedule/delay one of my current tasks. Which one do you suggest?"

If I was to ask a co-worker about you, how would they describe you on the job?

I've asked my managers and coworkers and based on their feedback, they've describe me as: • Always having a positive attitude when dealing with pressure or when posed with a new or unfamiliar challenge • Being dependable and willing to take initiative and jump in and help with any situation without necessarily being asked • Having a rational and resourceful demeanor in which I use my own knowledge, research, and network within the workplace to gather as much information about the task, situation, or opportunity at hand before taking action.

Someone you admire? Would elect to be president? Why?

Igor Ulis - he surrounded himself by people smarter than himself. He spent time getting to know his employees, and in doing so, he developed trust with them so much that they were motivated and enthusiastic and more flexible when the time came to go the extra mile for him. It was well worth it. He celebrated wins with the rest of us, wasn't afraid to roll up his sleeves and contribute to a project, and was sad, tired when his employees were as well. I would trust him to do a job well done because he is rational - he listens to all of the facts and consults others he esteems before acting on a whim or on his emotions.

What was the biggest mistake you've made on a job? How did you handle the failure?

In my current role I was managing the timeline, development, and release of a financial dashboard for our Leadership team, and I was so eager to please them that I told them that I could build the entire thing in time for their meeting with our parent company in 2 weeks. I thought this was doable, but it up taking three weeks and our Leadership team did not have some of the data visuals they were expecting to use to during the meeting. Looking back, I realized I should have been more conservative in my estimate to my stakeholders or I should have discussed reprioritizing some of the less urgent tasks with my Manager so that I had sufficient time to produce the dashboard. I realized that the Leadership team wouldn't have been upset if I was clear about the timeline in advance, but they were certainly going to be disappointed if I promised something and then didn't deliver. So I took this experience and used it to become much better at managing the expectations of stakeholders on projects I am responsible for. For example, on the next dashboard with the same stakeholders, I estimated that it would take four weeks and I ended up delivering in three. They were very happy about this.

Tell me about a time when you took a calculated risk

In the role of Live Video Coordinator during the live event there was a security concern that came up during the second day of the event in which the analytics api being used was using an exposed api, so if hackers wanted, they could tap into the data on their own. I reelayed the information to the client, outlining the incident and the risk involved: • if we released an update with the key that initially should have been used, it would lead to stream downtime. • if we didnt, then that risk would remain for the end of the day I could not get word back from the client within a reasonable amount of time, so i made the decision to force the release during the switch between groups. As an estimate, the stream would be down for 3 seconds, and end users ould have to force refresh theeir streams to begin playing the live video again. Other factors that led me to this decision was that the major groups were not on at this time, and basedd on the analytics, end users were still starting to trickle in. The impact would be more minimal than if we were to wait until hearing back from the client and risking having 10s of thousands of more end users streams be disrupted. nd while it did cause a minnor disruption in the stream viewing experience, the security concern was thwarted before anything happened, and the client was happy.

What is a JOIN in SQL?

Joins in SQL are commands which are used to combine rows from two or more tables, based on a related column between those tables. The main types of joins in SQL are Inner, Outer, Cross and Self joins • (INNER) JOIN: Returns records that have matching values in both tables • LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table • RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table • FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table

What are your own business philosophies?

Just because you are struggling does not mean you are failing - Tenacity - most companies achieve success by overcoming challenges, encountering struggles, and working hard. Same goes for individuals. The path we as individuals and as companies take to get to where we are today or where we want to be tomorrow is more important than the actual achievement of the goal itself, because we are trying, growing and because we were true to our values along the way. For example, it took me some time to ramp up when taking over the Business Intelligence initiative in my current role. When I first took the project over, I had never written a single SQL query. When the individual who was initially in the position to lead it left the company, I was incredibly excited to be given such an opportunity to not only administer the entire BI platform, but also to create data models, build dashboards, and make other people's lives easier using data. I struggled in the first couple of months. I was trying my hardest though to develop SQL skills and while data model and dashboard production was not flowing as fluidly as others probably would have liked, I was doing everything to keep going, make progress, and become more versed in the language every day. In the end, ended up accomplishing Phase I of the BI initiative earlier than planned, producing 30+ dashboards in the first 10 months, and I am still growing this very day. This is also the reason I'm seeking new challenges elsewhere. I want to continue learning and becoming more and more fluent in SQL, especially.

Superpower?

Mind-reading - add a layer of emotional data to the mix for more extensive analysis of customer trends; also would allow for more efficient delivery of findings when delivering results to various audiences. For example, tailor visualizations or communications based on the specific needs of the individuals or groups consuming the content. By immediately knowing the best way to present the data and findings to different views, listeners, or end viewers, I could be more efficient in delivering analyses or presenting / visualizing findings. Sometimes I go through a couple of different iterations of a report or dashboard to ensure that it is best received and understood by the end users. Sometimes, what works for one person may not work for another. For example, I developed a financial tool that allowed BUs to better manage and project their costs. I made a universal tool for all BU leads. One was not understanding the data and so I decided to change the visuals in the tool in the hopes that it would be better received by this individual. The tools were more extensive, but it helped this individual to understand more clearly how each adjustment she made affected her BU's profitability. With the additional tool added to her tool, she was able to increase her BU's Gross Profit Margin by 26% and exceed her GPM target for the year in just 7 months.

What do you feel makes you successful in your current role? Give an example to support your success.

My drivenness and desire to keep learning new tools and skills. I strive to become better in data, tools, presentation, and communication styles. S - During my time as a Lead Analyst on the Consulting team, there was a lull in billable work for me. At the same time, the USGA team was experiencing challenges with its Live Video Coordinator working on the biggest event of the year, the U.S. Open Golf Championship. T - My Manager asked if I would be willing to go outside the responsibilities of my Lead Analyst role and step in to support the USGA team and its 4 vendors in getting back on track and preparing for the live event just 2 months away. While I had never led a project of such magnitude or worked with third-party vendors, I agreed to take on the role and saw it as an opportunity to develop my organizational and communication skills further. A - I requested a small budget to take an online, on-demand course in project management best practices and spent a week working a few extra hours each day to set myself, and the USGA team up for success, while also ramping up on the project by researching how live streaming works, learning about the services that each live video vendor provides, what each was in scope to deliver, and how this role was successful in previous years by reviewing internal documentation from the previous years' Confluence space. I set up regular check-ins with the lead from the USGA team to ensure expectations were being met and scheduled weekly synchs with our own Account Exec to ensure she always had a pulse on live video operations as well. R - By the time of the live event, I had conducted 4 simulations with all teams and vendors and everyone was fully prepared for the 4 days of the event. The 2019 U.S. Open event was delivered successfully, and the USGA requested that I return to lead the Live Video Operations for the 2020 event as well, which I gladly did, taking with me great learnings on how to lead diverse teams with different skills and better communication skills.

Experience with SQL

My experience with SQL has been entirely for data analysis within our company's Business Intelligence platform, Sisense. I use SQL everyday to to interact with multiple internal and relational databases at once spanning financial, CRM, ERP, Jira, and HR data. With SQL I have created upwards of 40 reports and dashboards in 18 months that serve as tools to our internal Leadership, Operations, HR, Sales and Marketing, and Finance and Account teams for more extensive use and analysis of our otherwise siloed internal data sources.

Where do you see yourself in 5 years?

My focus for the next 1-2 years is to understand the specifics of the role and become a subject matter expert in them. Then, for 2-3 years after that, I would like to take on more responsibility, lead more projects, and contribute to the growth of the company and its customers. I hope that with each year, that I continue to build a strong network within MasterCard where I can leverage my strengths and be valued in an environment of colleagues who share similar goals and values to those of myself. My overall hope is that this role is the beginning of a long career working for MasterCard!

What are your greatest professional strengths?

Personally, I think my greatest professional strength is my ability to remain present and focused. Especially now with work from home I do my best to remain fully focused and present because that is how I am able to be most effective for my team and most satisfied with my work.... When I am fully engaged and able to enjoy the task at hand without distraction. I believe in collaboration and in involving people from various disciplines and all organizational layers right from the start. This helps create understanding, foster commitment, build the right mindset, and remove resistance, and it makes them feel that changes are "theirs." Also, ensuring that all processes are as lean as possible is important, so the team does not feel any unnecessary workload.

Tell me about your greatest accomplishment on the job.

S - In 2020, 4 of our 8 Business Units were performing well below their annual profitability targets halfway through the year and did not know if they would meeting their revenue and gross profit margin targets by the end of the year. T - New to the Lead Data Analyst position, my goal was to develop a tool(s) that would give control back to the Business Unit Leads so that they could run their business well, plan for the future, and meet their annual financial targets. A - Leveraging 4 disparate internal data sources — P&Ls, Salesforce CRM, HR, Resource Management — I developed an extensive set of tools that gave the BU Leads the foresight to better understand projected revenue, costs, and GPM. I also set up monthly reviews with each BU to take a look at P&L performance to date, projections, and plans / action items needed to meet end-of-year targets. R - By the end of the first year, 7 of the 8 Business Units had met their annual targets, with one BU coming in just 1.3% below its GPM target. The following year, all 8 Business Units exceeded their annual revenue targets by 12% and the company's GPM grew by 6%.

Tell me about a difficult situation you encountered at work and how you overcame it.

S - In my current role on the Operations team, there was a point in time when the company was without a Salesforce Administrator. Given my background in Salesforce, my Manager asked if I would be willing to split my time between teams until the Commercial team was able to fill the role. I was tasked with helping to maintain the Salesforce platform while continuing my daily responsibilities on the Operations team. After 2 months, the role was still unfilled and the company was putting a hiring freeze on all non-revenue generating positions. T - I was beginning to experience burnout as the list of high-priority Commercial and Operations requests continued to build and there was no relief in sight on the Commercial side with the role being filled. I become increasingly unmotivated in my Data Analyst position because I had little time to focus on the projects and skills that I enjoyed the most. A - I decided that I needed for my Managers and I — my temporary Commercial manager, and my primary Operations team manager — to come together at the beginning of each week to review my to-do list, and align on the prioritization of each. By doing so, I was able to better manage high-priority, competing tasks across both teams. I set realistic, weekly expectations with both of my Managers and, in turn, found myself having enough time to focus on tasks for both teams without continuous disruption and context switching. I also created a shared communication channel where any urgent requests that came up in the middle of the week were visible by both Managers and so that expectations could be reset if necessary. By coming together each week and opening a secondary form of communication and alignment with my Managers, there was more transparency in setting better expectations with my manager's competing priorities. I was able to complete more tasks because I had the time needed to focus on each and complete them accurately and effectively. I continued this way for 5 more months until we were able to hire for the Commercial role. R - This experience taught me just how important it is to align and communicate with my team. I learned just how important it was to communicate with my Manager(s) and took these learnings, and applied this structure to my current role with 1 manager which has made our working relationship even stronger than before. We now meet at the beginning of each week to align on my priorities and set weekly goals for myself. This has increased the satisfaction I feel in my job.

Tell me about a situation where you did not get along with a co-worker and how you resolved it.

S - In my previous role on the Consulting team I was assigned to a high-profile project with an aggressive timeline working with only 1 other teammate who consistently skipped the morning meetings that I scheduled with him. When I would reach out to him, he would apologize and ask to reschedule for later in the day. When we met, he would often get distracted, spark conversations with others in our office sitting nearby or end up in lengthy conversations when getting a drink or snack. T- After several days of missed morning meetings, minimal progress, and a looming initial deadline, I requested to meet with my teammate for lunch so that I could express my concerns about the pending deadline and the amount of work we had yet to do. First, I asked why he kept missing our meetings. A - After listening to his response, I realized that we simply had different work styles. While I liked to get to the office early, tackle collaborative efforts in the morning, and allow for independent, focus work in the afternoon, my teammate liked to work out in the morning and was more productive working in the afternoon and into the night when everyone had already left the office. We decided to come up with a different plan for working together that played to both of our styles. We came up with a new plan for synching — meeting early afternoon, drinks and snacks already in hand, and in a closed room with little to no opportunity for social distraction. Both of us were happy to meet in the middle and we ended up delivering a solid, strong deliverable to the client on time and under budget. R - With every project thereafter, I made it a point of asking my teammates their work style, preferences, and made sure to voice my own preferences as well so that we could agree on a plan that worked best for the dynamic of our team and set us up for success. By doing so, I have become much more flexible and have come to appreciate the work styles of those that differ from my own.

Tell me about a time when you were required to work with a difficult person. How did you handle the situation? What was the outcome?

S - In my previous role on the Consulting team, I was working on a customer / fan data strategy project for a new client. T - I was to present my research findings and recommendations to a particularly closed-minded stakeholder who had dissected and questioned every finding I had presented during Phase I of the project. The stakeholder was very wary of what I had to say and very vocal about the methodologies I had used to arrive at my initial findings A - In order to avoid a similar situation during Phase II of the project and while presenting my findings, I knew I had to work a little harder to earn trust with the stakeholder and be effective in instilling his confidence in my findings and recommendations. Rather than work entirely on my own, I spoke with the Lead Consultant on the project about making direct contact with this stakeholder. I wanted the stakeholder to feel that he was a part of the process and that his experience at his own company, expertise on the subject, and opinions were valued, heard and being considered when I was conducting my research, drawing insights, and fashioning recommendations for him and his team. The Lead Consultant was able to allocate some of the project budget to me spending some extra time working with the stakeholder and conducting two smaller 1:1 workshops with him directly. He was willing to meet with me, happy to offer up additional details about his business, and I was also able to explain to him in more depth the approach I was taking and why. R - By involving the stakeholder in the process, I was able to earn his trust. When presenting the final deliverable, the stakeholder was much more open to listening to the findings and recommendations rather than questioning and poking holes in them, and even spoke up in support of the recommendations when others on his team expressed caution!

Order of SQL Queries

SELECT FROM & JOINs determine & filter rows WHERE more filters on the rows GROUP BY combines those rows into groups HAVING filters groups ORDER BY arranges the remaining rows/groups LIMIT filters on the remaining rows/groups

What is SQL?

SQL (Structured Query Language) is a standard computer language for database management and manipulation. In database systems, statements are used to generate queries from a client program to the database, this allows a user to extract a wide range of fast data manipulation. The main functions of SQL are querying and editing information stored in a certain database management system, whether this is inserting, searching, updating or deleting database records.

Why is SQL important?

SQL is important for a number of reasons, one of these being that SQL has the capabilities to deal with large volumes of datasets stored in databases, that other systems couldn't cope with. SQL is completely equipped to handle data pools of virtually all sizes. Almost every PC and mobile device will eventually require and touch with SQL as data rises to databases, they cannot function without SQL - making it a highly essential coding language. As companies strive to accomplish more with their information, SQL is key in allowing this to be achieved. SQL is a coding language that is relied upon by multiple databases around the world, making it an exciting industry to work in.

Mastercard Products and Services

Small and Medium Businesses - • Payment facilitator Services • Mobile Point-of-Sale Solutions - simple, low-cost solutions that leverage mobile devices as POS • Tap & Go Payments • Mastercard Identity Check to ensure secure transactions • Digital Doors Program to help small business owners build an online presence quickly and safely • Mastercard Access - a single-source network connection A number of other products and services for customers like myself, large enterprises, banks, credit unions, and the public sector

How do I know / decide which reports and / or dashboards to create?

Speak and collaborate with others - stakeholder interviews to understand immediate needs, pain points and / or bottlenecks. • What are we trying to learn? • What data is needed to glean such insights? • Do we already have the data? • Do we need to start collecting new data? How? • How will the data be used? • What are we expecting the data to tell us? • Are we already reporting on this? If so, where? What is currently working? What is missing? What can be done better?

Why the Payments Industry?

The payments industry embraces innovation and the future belongs to the innovators. * No shortage of data or challenges • Despite its complexities and diverse array of institutions and technologies, the payment industry is truly a cohesive landscape that's at the forefront of innovation. And increasingly, the industry's ability to spearhead cutting-edge solutions is driving continued investments and a growing number of mergers and acquisitions. Even as new technologies and acquisitions disrupt the payment landscape, though, one thing's for certain: the industry will continue to do all that it can to make the payment processing cycle as seamless as possible. During my time as a Lead Analyst on the Strategy & Key Accounts team, I worked on a Connected Fan Data project in which one of our major golf clients wanted to collect and make better use of its customer data through its POS, mobile payments, digital products, wearables, etc.. While the client was interested in capitalizing on such efforts by introducing new revenue streams for itself, the customers would also reap incredible benefits and rewards. I found it fascinating that this investment being made in exploring new, innovative ways to connect its various customer data sources would significantly improve the customer's experience onsite at its major championship event, and also make it so much easier! If our client could do this at one of its events, then imagine what a company like MasterCard can do for its clients around the world — not only optimize the users experience or allow for more scalable solutions, but also increase its clients' growth capital and contribute to the economy at large.

Mastercard Mission

To connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart, and accessible

Why are you leaving Infront X?

Two reasons: When I started working at Infront X, I really enjoyed my job and the company, but a lot has changed internally since then, especially within the last 2 years. The company has undergone 3 rebrands and 3 CEO changes in 2 years and the notion of culture and investing in its employees has dissipated over time. I'm looking to return to a culture that is nurtured and emphasized like it is at MasterCard. Also, over time I realized that it has been increasingly difficult to grow new skills here. I am eager to continue learning, developing new skills, and improving upon existing ones, and so I am looking to find a place where I will be exposed to new, interesting challenges and tools that will further develop my skills.

What is a Union in SQL?

UNION command is used to combine the results of two or more SELECT statements without returning any duplicate rows. Union All keeps duplicates.

Tell About a Time You Showed Leadership

USGA VIDEO EXPERIENCE

How long are you planning on staying?

Well, I don't know how long I will stay, but I can tell you that I'm looking to stay someplace longterm. I'm looking to grow my skills and if that's something that I can do here, then there really would be no reason for me to leave. It sounds like this is a real concern for you? Would you be willing to shed more light on why you're worried about someone wanting to leave this position? Because it sounds like you are a fantastic company...

Why do you want this job?

Well, in addition to all of the positive aspects of working for Mastercard, what really excites me about this job is that I will have the opportunity to cultivate my inherently collaborative, investigative, and analytical skills to provide quantitative analysis and strategic perspective to Mastercard's Customer Interoperability organization. I am also excited at the opportunity to apply the SQL, problem-solving, and data management and visualization skills that I developed in my three of my previous roles to foster a more data-driven culture at MC, enhance the quality and usefulness of its data, and achieve even higher levels of success for the team. I also admire the emphasis that the job description places on the ability of the individual In this role to collaborate with teams and act on insights. This is something that I have done successfully for a number of years at my company and that I still do even today — establishing business objectives and KPIs to measure performance, analyze performance using reports and dashboards, acting on those insights using data-informed decisions, and then evaluating performance of those programs over time.

What are some of your professional weaknesses?

When I think about this position, I know there are a few areas that I need to be really proficient in in order to do the job well. — Data, Metrics, Analysis and Trends, SQL, and ETL flows. I have ranked myself, and I believe that I am strong in these in the following order: Data Analysis and Trends Metrics Program Evaluation SQL ETL flows The bottom 2-3 skills would be SQL and designing of ETL flows. While I have skills in SQL, I have neither scripted using SQL nor have I designed an ETL flow and that's why I'm excited about this job! Because I am eager to learn these skills and continue honing my existing ones. I am going to get better through the increased exposure at your company to these challenges that I need in order to exceed your expectations. I am a proven continuous and fast learner — In my current role I spend time after business hours taking online courses to learn and continue being exposed to more advanced SQL queries so that I can be more effective and successful at my position and I would do the same if given the opportunity in this role. My goal is to continue growing in all of these areas so that I can be more valuable in this role.

ELT vs ETL and experience with them

Within the ETL (traditional process), data is extracted to the staging area (either in-memory data structures or temporary databases) before it is transformed and loaded into the analytic (OLAP) database for analysis. ELT (extract-load-transform) takes advantage of the new data warehousing technologies (e.g. BigQuery, Amazon Redshift, Snowflake...) by loading the raw data into a data warehouse or data lake first and transforming the data on the fly when it is needed for analysis. ELT is preferred for operations working with extremely large volumes of data or with real-time data. The main conceptual difference is the final step of the process: in ETL, clean data is loaded in the target destination store. In ELT, loading data happens before transformations - the final step is transforming the data just before data analysis.

Why Mastercard?

am looking for new challenges in an environment where I am inspired by the people around me, where I can be myself, and where I can define my career as being something bigger than myself. Mastercard offers all of that and so much more. It has ambitious goals to continue accelerating emerging ideas into real, scalable solutions that create meaningful experiences for its customers energize me. I strongly believe that my collaborative demeanor, curious mind, and SQL and data skills can help propel Mastercard towards achieving even higher levels of success through streamlined access to data and data insights. Invest in their employees • Flexible - understands the need for flexibility so that its employees can maintain a healthy work / personal life • A great place to work is all about the people who chose to work there because those are the people that I will be spending 5 days a week with. • Emphasis on relationships and inclusion - Business • Resource Groups (BRGs) - it seems that there's a really supportive network for employees in the company, not only within your direct team but across the entire organization. If given the opportunity, I would love to join the Women's Leadership Network and the Young Professionals group (if I didn't age out of that group already haha) • Invest beyond the walls of its offices and home offices - making the world a better place and leveling the playing field for girls in particular - Girls4Tech - something that I would have taken advantage of if available in my youth and something that I will be sharing with girls in my life. • Employee Benefits are unlike any other (some that piques my interest were the tuition assistance to explore new and expand upon existing skillsets, the volunteer incentive program, Wellness Rewards Program)

Tell me about the best manager you ever had? Now tell me about the worst.

• Best Manager - Thalia - not only did she foster her employees, and encourage their growth and development, but she was also open to learning from them. She realized that every person on her team brought a different skillset to the position, a different outlook that was based on their own personal experiences in life, and their own work-style and preferences. She was able to play to the strengths of each of us, and push us to grow in other areas. • Worst Manager - My second manager was a rather closed-minded individual. When reviewing my work with him, he would often disagree the ways in which in which I conducted even if he agreed with the end result, or he would say that the result was "wrong." I did my best to be open to hearing his feedback, but he was unwilling to give constructive feedback because he felt that he was giving me the answer without me having to figure it out on my own. I often found myself suppressing the creativity in my methodologies and findings and trying to appease what would be most agreeable to him. I appreciate my experience and time working with him, though, because he was an incredibly smart individual and he did teach me a lot. My time working with him also made me see realize important it is to be open-minded, even when I might think that you know the best way of doing something or the "right" answer. Everyone offers a unique perspective and a different way of thinking about things. The best thing I can do is be open to listening because that's one of the ways I can grow and be more flexible.

What do you know about Mastercard?

• Global technology company in the payments industry • Headquartered in Purchase, NY • Founded in 1966 • More than 21,000 employees, working in over 90 countries around the world • Decency Quotient, dubbed by Executive Chair Ajay Banga, drives and encapsulates MasterCard's culture • Selected as one of Fortune's "100 Best Companies to Work For" in 2021 • Business Resource Groups for Women, Young Professionals • Girls4Tech • Benefits Niche: • Digital Doors Program to help small businesses be successful in creating an online presence • Offers a plethora of resources that MasterCard invests into diversity, empowering disadvantaged groups, and being a responsible company • Despite the difficult decision MC made to cease its Russian operations, MasterCard treated its impacted employees with respect (the 200 or so Russian colleagues) and remains dedicated to ensure their safety and well-being including continuing to provide pay and benefits to those individuals.

If someone came to you with an enthusiastic, yet unrealistic request, how would you handle it?

• If expectations don't seem realistic, I would ask for clarification to make sure I'm understanding the request correctly. You realize that miscommunication could be at work and actively work to ensure ideas are correctly understood. • I would chose to be optimistic and come up with a plan, asking others interested for support as well if I felt it was necessary, Positive thinking will help to make the request more realistic to others as well and help us achieve the ambition goal.

What are you looking for in your next role?

• New challenges, more data • Exposure to more data and analytics tools and methodologies - SQL, Python, R, statistics, etc. • A place where I am encouraged to be myself and inspired by those around me • An environment that fosters continuous growth and learning • A mentor or manager who cares about my career path

How do I identify data sources?

• Review existing data sources • start with the sources; • are there gaps in data? • is there an actual need for a new data source? Where to get the data you will need for your project. • Use Current Research as a Guide • National Data Resources • State and Local Data Resources • Collecting New Data Consider where to store the data if a new data source. How will this data be used?

What are the 3 most valuable things you've learned while working in your current position?

• SQL - I love it and am excited that the experience I have been given in my current position has opened the doors to a long career in leveraging SQL to be more effective at data analysis. • Experience with data visualization tool, Sisense • Exposure to and experience with developing key business metrics and then following through on those goals by developing reports and dashboards that monitor progress, analyses of such business metrics.

Why the Customer Interoperability team?

• There are countless opportunities for professional and personal growth -- to hone my SQL, analysis, and data modeling skills and learn new areas of the business by working with other business functions. • I know how incredible this opportunity is to collaborate with like minds at Mastercard who are passionate about using data to achieve even higher levels of success for Mastercard and its customers • I believe in collaboration and enjoy bringing minds together to identify pain points and then using data to solve and act upon them in order to move the businesses forward.

My experience with SQL includes

• Writing SELECT queries and subqueries including correlated and nested subqueries and derived tables • Used control flow statements (IF/ELSE) • Used CASE statements • Used various join types (INNER, OUTER, LEFT, RIGHT, FULL, CROSS JOIN •Used UNION AND UNION ALL