Andrew Robles Email & Phone Number

Seattle, Wa, Us

Seattle, Washington, United States

Seattle, Washington, United States

Seattle, Washington, United States

 Verified cash and tax lot data in Excel for over 5,000 accounts to mitigate risk and approve for trading  Created multiple Python scripts to expedite routine work and eliminate human error  Appointed to emergency task force as department lead to identify, prevent, and solve trade errors Managed daily reconciliation, reports, and ad-hoc requests with strict stock market deadlines Identified trends in financial data to introduce new logic to team’s workflow using Excel and… Show more  Verified cash and tax lot data in Excel for over 5,000 accounts to mitigate risk and approve for trading  Created multiple Python scripts to expedite routine work and eliminate human error  Appointed to emergency task force as department lead to identify, prevent, and solve trade errors Managed daily reconciliation, reports, and ad-hoc requests with strict stock market deadlines Identified trends in financial data to introduce new logic to team’s workflow using Excel and Python Show less

 Develop pipelines via APIs and web scraping to ingest external datasets into proprietary tools Coordinated with content managers to develop improved data gathering techniques  Utilized Tableau and Excel to produce actionable charts and dashboards for sales teams Automated 6 routine data requests with Python to generate customized Excel reports for team managers Produced over 150 internal ad-hoc data requests querying relational databases using Python and… Show more  Develop pipelines via APIs and web scraping to ingest external datasets into proprietary tools Coordinated with content managers to develop improved data gathering techniques  Utilized Tableau and Excel to produce actionable charts and dashboards for sales teams Automated 6 routine data requests with Python to generate customized Excel reports for team managers Produced over 150 internal ad-hoc data requests querying relational databases using Python and SQL Developed and monitored new KPIs for upper management and clients Presented capstone project to 3 different offices for incorporation into respective R&D teams Programs Used: Python (Pandas, Selenium, BS4), SQL(BigQuery), Excel, Tableau, Looker Show less

Greater Seattle Area

 Work directly with the International Visitors Program of the United States. Researched, wrote, and edited 8 unique proposals for the State Department’s professional exchange program Connected with local organizations, companies, and leaders to build topic-specific programs Secured $1000 in additional funding from State Department to sponsor capstone program Managed multiple projects and deadlines while attending conferences and events programmed by the council.

University Village, Wa

 Works on a 6-person team that coordinates orders with 60 other staff  Coordinates all house orders under stressful conditions processing an average of $1,500 in sales directly while verifying the $20,000 in sales made by our servers Strong emphasis on customer service, communication, and teamwork.

Greater Seattle Area

 Gained trust from multiple clients a day and ensured the safe transport of all their belongings. Built strong relations with other team-members to maximize our efficiency. Keen attention to detail . Built a strong work ethic and positive attitude in high-stress situations.

Bachelor Of Arts - Ba, International Political Economy & Foreign Policy

Bachelor Of Arts - Ba, Economics

Certificates Of Completion, Data Analysis

Completed courses in Python (NumPy, Pandas), PowerBI, SQL, Tableau, Excel, and overall data analysis techniques and fundamentals to build.