Connor Buchanan Email & Phone Number

New York, Ny, Us

Engineering role encompassing the following responsibilities:Work with stakeholders across Engineering, Legal and Product teams to manage and support security and privacy protections within different internal data pipelines.Identify and implement best practices for protecting sensitive data, such as Personally-Identifiable Information, within our data lake and end-to-end pipelines. Build tooling to support security, privacy and compliance requirements. Collaborate within the Security Team and with Legal, Engineering and Product to come up with the best solutions for securing data within our pipelines. Sharing knowledge, best practices and training for data pipeline security and privacy.

New York, Ny, Us

Analytics Engineering and Product Management role working primarily with various reporting products and databases. This includes Google BigQuery, Dataform, HANA, Power BI, SAP Analytics Cloud, Lumira, and Web Intelligence in a S/4 HANA system.Created dashboards and visualizations for key performance indicators in SAP Analytics Cloud using live data connections to HANA. Documented and communicated metrics and changes across the company.Worked with business leaders to prioritize, develop, and release enhancements to existing reports and data models. Created detailed requirements and completed changes in an AGILE Scrum environment.Led classes to educate users about reporting functionality and how to pull needed data. Included detailed class on creating and managing dashboards in SAP Analytics Cloud.

Westlake, Texas, Us

Technical Product Owner of Mutual Fund Trading Modernization - Primary duty is to convert all Mutual Fund trading functions from an outdated mainframe system to a distributed environment.Converted 200,000 daily trades and $100,000,000 in trading value from mainframe to new distributed platform. Encompasses trades from seven different sources, including Schwab.com, mobile app, and advisory services.Built Splunk reporting dashboards to identify volumes and issues with the new serviceCreated complex SQL queries in DB2 and Teradata as short term workarounds to production bugs and issues. One query prevented a $225,000 loss that would have otherwise occurred.Worked with business partners to understand current process and with technology partners to determine how to implement it in the new environment. Wrote detailed requirements in the form of user stories.Managed the development and QA team. Utilized AGILE Scrum methodology with two week sprints through JIRA.

Westlake, Texas, Us

Technical Product Owner of Mutual Fund Clearing Services - Primary duty was to manage our vendor-supported Mutual Fund Clearing platform encompassing 20 clients and $200 billion in assets.Created Microsoft Access database solutions to create workarounds for vendor shortcomings. Integrated these databases into macros and Schwab systems to support one-touch automated solutions.Interacted with clients, vendor, and internal operations to determine issues and enhancement requests. Gathered relevant information to write detailed requirements and prioritize the resulting user stories appropriately.Participated in multiple shared JIRA boards organized by technology team. Utilized AGILE scrum methodology with two week sprints.

Westlake, Texas, Us

Technical Business Analyst for Mutual Fund Clearing Services - Primary duty was to convert all Mutual Fund Clearing clients to a new vendor-supported model.Successfully converted 20 Clearing clients and $200 billion in assets to a new vendor supported model. Included integration with clients, vendor, and new internal systems to support the model.Led comprehensive review of all current model processes and how they would translate to the new vendor. Negotiated on development responsibilities and ensured all existing gaps were covered with minimal client impact.Created an entirely new and comprehensive cash and share reconciliation process. Revolutionized the process and significantly reduced system capacity strains by posting lump transactions and still maintaining reconciliation transparency.Performed significant amounts of User Acceptance Testing on new processes. Identified, reported, and prioritized bugs.Interacted with technology and business partners to write detailed requirements in the form of user stories.Participated in multiple shared JIRA boards organized by technology team. Utilized AGILE scrum methodology with two week sprints.

Westlake, Texas, Us

Westlake, Texas, Us

Westlake, Texas, Us

Westlake, Texas, Us

Summer job throughout college

Master Of Science - Ms, Business Analytics

Bachelor'S Degree, Finance