Guggenheim PartnersBusiness Analyst - Regulatory Compliance
May. 2016 - Apr. 2018Greater New York City Area• Employee Trading Activities: Create, manage and enhance compliance disclosures, pre clearance forms, and approval workflows in SharePoint. Manage and amend onboarding process workflows, quarterly and annual attestation tasks, perform data analysis and create SQL stored procedures in providing decision models to the business. Provide requirements and test API’s to verify system integration functionalities. • Trade Surveillance: involved in the data migration project from legacy consolidation systems to STAR Compliance. This involves building, testing and setting User Acceptance for Business Intelligence tools that run surveillance on daily firm and employee activities.
• Test script automation in Selenium to fulfil standard checklists during weekly deployments.
• Reconciliation project involving ETL of compliance forms from legacy systems into SQL databases, and develop Entity Relationship diagrams for versioning forms. Scripted stored procedures to transfer reviewed/approved compliance forms into Open Text and have executable files run this process on a daily basis. Also developed detailed folder structures to facilitate filtering, reporting and retention functionality. • JIRA administration: Onboard teams using Tempo, creating and managing projects and Kanban boards, setting and configuring user permissions to maintain data visibility and confidentiality. Manage and support EazyBI plugin in JIRA for providing data graphs/charts and dashboards.