Andrew Semler, FIA
Market Data Analyst II at TRG Screen- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Spanish Limited working proficiency
Topline Score
Bio
Credentials
-
Financial Information Associate (FIA)
FISDFeb, 2023- Oct, 2024 -
Bloomberg Market Concepts
BloombergDec, 2017- Oct, 2024
Experience
-
TRG Screen
-
United States
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Market Data Analyst II
-
Jun 2019 - Present
• Analyze clients’ market data and report their usage to various global stock exchanges • Normalize market data while utilizing Excel, including PivotTables, VLOOKUP and various other functions • Develop client relationships with market data professionals at global banks and hedge funds • Perform market data audits of global banks and hedge funds on behalf of NYSE and Nasdaq • Leverage client databases using SQL queries to help maximize client’s market data potential savings • Procure market data and licenses for clients within Bloomberg, Refinitiv, and internal environments • Assist clients with understanding invoices from various stock exchanges and data vendors • Act as a Connector for Connector Program to ensure smooth transition of new hires into the firm • Onboard new clients to Axon systems to ensure maximum efficiency of market data inventory Show less
-
-
-
Lazard
-
United States
-
Financial Services
-
700 & Above Employee
-
Corporate Finance Intern
-
May 2018 - Aug 2018
As an intern in the Finance/Tax Department, I rotated through six departments including Management Reporting, Financial Control, SEC Reporting, and Tax. Tasks performed: • Validated over 5,000 daily expense accounts using PeopleSoft nVision and Query to increase efficiency in Financial Control • Fostered the transition from PeopleSoft to SAP for balance sheet accounts utilizing Excel PivotTables and VLOOKUP • Processed quarterly financial advisory and asset management data while collaborating with Management Reporting team to create content for quarter-end reports • Analyzed patterns and trends for non-compensation expenses for the last 10 years and created a historical trend spreadsheet • Presented Capstone project to senior management with a group of six collaborative interns Show less
-
-
-
TD
-
Canada
-
Banking
-
700 & Above Employee
-
Bank Teller
-
May 2017 - Aug 2017
As a bank teller, I handled thousands of dollars daily while making banking transactions. I also provided customer service and aided customers by advising them regarding their banking needs, and providing them with information about TD's products and services. As a bank teller, I handled thousands of dollars daily while making banking transactions. I also provided customer service and aided customers by advising them regarding their banking needs, and providing them with information about TD's products and services.
-
-
-
Nassau County
-
Government Administration
-
700 & Above Employee
-
Seasonal Park Worker
-
Jun 2013 - Aug 2016
As a park worker, I generated daily schedules for 35 employees and organized picnic reservations and boating docks. I also helped manage $15,000 per day to be distributed throughout cashier drawers, as well as advised patrons on various information regarding park details and directions. As a park worker, I generated daily schedules for 35 employees and organized picnic reservations and boating docks. I also helped manage $15,000 per day to be distributed throughout cashier drawers, as well as advised patrons on various information regarding park details and directions.
-
-
-
Wantagh Pride
-
Wantagh, NY
-
Basketball Coach
-
Jan 2015 - Jun 2015
As a basketball coach, I mentored and advised a tightly knit team of third grade basketball players. I constructed drills and practices, while developing a complex playbook. My main goals of each practice and game were to make sure my players had fun and learned the valuable skill of teamwork. As a basketball coach, I mentored and advised a tightly knit team of third grade basketball players. I constructed drills and practices, while developing a complex playbook. My main goals of each practice and game were to make sure my players had fun and learned the valuable skill of teamwork.
-
-
-
Wantagh Little League
-
United States
-
Veterinary Services
-
Umpire
-
Apr 2011 - Jun 2014
As an umpire, I was trusted to use my judgement to accurately call little league baseball games along with a partner umpire, but often times on my own. I was responsible for maintaining good sportsmanship between opposing teams and running a clean, friendly baseball game. As an umpire, I was trusted to use my judgement to accurately call little league baseball games along with a partner umpire, but often times on my own. I was responsible for maintaining good sportsmanship between opposing teams and running a clean, friendly baseball game.
-
-
Education
-
Isenberg School of Management, UMass Amherst
Bachelor of Business Administration - BBA, Finance, General -
Wantagh High School
Advanced Regents Diploma