Brian Kiernan Email & Phone Number

Hoboken, Nj, Us

Tokyo, Japan, Jp

- Spearheading the migration from legacy systems to AxiomSL v10, leading tactical andstrategic implementations for critical reports (2052a, FR, FFIEC, TIC, control reports)- Managing user support, design, implementation, development, code management,environment, and system management for AxiomSL, Implementing data masking controls,system monitoring reports, and dashboards.- Successfully managed all manual regression testing from an IT perspective, demonstratingcomprehensive functional and business understanding of critical reportsImplemented an automation framework within TIDAL for workflow execution and codemigration, leveraging RestAPI calls to enhance efficiency and ease of production support.- Providing crucial support as a Business Analyst, writing mapping rules for streamlined productand entity-based data extracts for regulatory reporting.- Contributed to mapping Critical Data Elements (CDE) from legacy databases to the Snowflakecloud data warehouse, including allocation logic by MDRM or PID for all regulatory reports.Integral part of onboarding, administration, and management of a 40+ member team,coordinating across swim-lanes in a sprint/agile format of SDLC.- Proven success in project implementation, showcasing a deep understanding of report logic,system design, and end-user controls for timely submissions.

New York, Us

•Manage and maintain financial models of ALM’s 19 publications, with primary focus on budgets and revenue forecasting, consistently performing SWOT analysis across all areas of the subscription business.•Acting liaison between Finance and Marketing teams to coordinate and ensure consistent measure and reporting of financial and audience metrics. •Assist in the constant improvement of Marketing efforts for both renewals and new business, identifying areas of risk and opportunity of campaign performance, and coordinating with sales leadership to maintain revenue and continued growth.•Create an improved system of reporting on audience cohorts and engagement within the paid subscriber base, as well as newsletter recipients.•Improve report development and update times significantly using local PSQL Database using custom API’s to pull from ALM’s multiple data sources, vendors and fulfillment house.•Utilize Adobe Analytics and Tableau to create scheduled reports on customer engagement, with focus on improving paywall conversion.

Brooklyn, Ny, Us

Data Analyst on Financial Planning & Analysis team, tasked with utilizing knowledge of SQL and Report Development to improve performance, automation and consolidation of Accounting and Tax external reports.- Support Etsy financial planning, accounting and tax teams to build and maintain reports primarily using ad hoc SQL queries and Looker, under strict SOX controls, on financially material data used in IRS and SEC filings.- Improve processes and incorporate automation in an effort to reduce time on revenue close and tax filing, resulting in intuitive and dynamic self-service reports, providing each team with an array of data points from disparate sources.- Provide non-technical analysis of code changes to both internal and third-party compliance teams in regular audits.- Compile data from external sources to develop and maintain reconciliation reports with agile development and reaction to meet the needs of recent domestic and international tax and accounting laws and procedures, including the introduction of Nexus/Marketplace tax, the repeal of South Dakota v Quill decision and recent introduction of Etsy’s subscription revenue stream deferment.- Coordinate with data engineers to successfully develop and organize architecture of data feeds through API integrations with third-party payment processors and business partners.- Incorporate knowledge of change-management and control strategies to assist internal controls team in developing structured processes on financial reporting.

New York, Ny, Us

Data Analytics Lead tasked with designing, developing and maintaining QlikView reporting application for Retail Banking Operations.- Gather requirements and collaborate with Retail Banking Group, Finance Control Group, and Money Movement groups to deliver concise QlikView Reporting application, used to analyze and display Key Point Indicators (KPI) of new Centralized Fee Billing System (CFB), to ensure all Firm standards and SEC regulations are met in monthly, quarterly and annual billing of AAA, BSA, IRA accounts.- Utilize internal firm systems, SQL Database, Teradata, Informatica, ServiceNow, and primarily QlikView Technologies in end to end development, and continued maintenance and management of CFB and Reporting applications.- Utilize understanding, architecture and processing to investigate any discrepancies and provide in depth analysis of CFB transaction processing and invoicing.- Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.- Conduct and assist in multiple areas of testing, including: functional, quality assurance, user acceptance and performance.- Communicate business requirements by constructing concise data and process models, acting as liaison between business and technical teams to ensure mutual understanding of processes and applications.- Acting as developer and as a lead of technical team, frequently asked to provide agile development to deliver immediate solutions.

Stryn, No

As General Manager I maintained a well-organized and competitive business, managing store operations and sales team personnel. In doing so, I regularly coached and evaluated staff, ensuring top-notch customer service at all times. Furthermore, I increased store productivity by:- Raising conversion by 6%,- Raising average dollar spend by 13%,- And raising store units per transaction by 17%.

Barcelona, Spain, Es

A Spanish company new to the American market, I worked with Desigual to assure a smooth integration and strong presence into the US market. I managed two Desigual-owned shops within Bloomgdales in Willowbrook and Bridgewater locations; this included managing staff and scheduling, merchandising, and public relations for each location. International and local travel required strong time management and intercultural skills.

Chiyoda-Ku, Tokyo, Jp

- Responsible for organizing customer information in presentable files accordance to Know Your Customer (KYC) and Anti-money Laundering guidance and regulations.- Identified deficiencies in customer files and escalated through the appropriate channels to resolve potential issues.- Team leader, trained new staff on the task processes, tracked progress and updated metrics for assigned group. Consistently recognized as a top performer and achiever amongst peers.