Team Lead Business Analyst

PROFESSIONAL EXPERIENCE

Sony Pictures Entertainment Mar 2023 to Current

Solutions Specialist (Team Lead/Sr. Manager level BRM) Culver City, CA

•Manage relationships with business stake holders, upstream, and downstream application teams.

•Lead meetings with operations stake holders to gather business requirements and manage expectations.

•Analyze business requirement against application and translate it into business logic and rules.

•Document business requirements and create user stories with acceptance criteria in Jira.

•Manage day to day IT operations to ensure deliverables are met in timely manner.

•Assist tech leads with reviewing backend codes and providing guidance and feedback.

•Engage in back log grooming, release planning and creating road maps with product owner.

•UAT developments with business owners to ensure customer satisfaction.

Luxoft (Capital Group - Clarity) Feb 2022 to Mar 2023

Business System Analyst Downtown LA / Irvine, CA (Client)

•Deliver live investment dashboard to client in an Agile DevOps environment.

•Integrate dashboard to ingest prior closing day’s holdings, pricing, performance results, and yield data.

•Integrate dashboard to listen to AWS Kafka messages from order management system to calculate and display real-time room to buy, projected position and projected cash balances.

•Perform data analysis on source data systems and design ETL strategy for AWS RDS through DaaS.

•Create business requirement documentation for product team and technical documentations for application, database, API, and front-end developers.

Castle Peak Associates Apr 2021 to Sep 2021

SQL Developer / Data Analyst El Segundo, CA (Client)

•Perform system analysis on trade order management systems across multiple entities to integrate derivatives trading and collateral activity to primary investment accounting system.

•Create stored procedures to warehouse data from offsite systems and non-integrated vendor services.

•Create stored procedures for cedent’s (insurance sector investor) T-1 reports.

•Plan and manage offshore development, job scheduling, QA, and production release.

InvestCloud Jan 2019 to Oct 2019

Business Analyst West Hollywood, CA

•Deliver personal wealth management websites to clients in an Agile DevOps environment.

•Integrate financial portals with banking platforms through API certifications testing security and frontend and backend functionalities to support account opening, closing, fund transfers and trade executions.

•Conduct analysis on client’s project objectives, define optimum solution and translate it to deliverables.

•Perform data analysis on source data systems and design integration strategy for ETL.

•Create business requirement documentation for clients and use case documentations for application, database, and front-end developers.

•Demo and train clients with new product and manage expectations and debug list.

Viking River Cruises Feb 2015 to Dec 2018

Sr. Business Analyst - FP&A Woodland Hills, CA

•Design and monitor ETL process feeding reservation system data to reporting and financial databases.

•Perform data analysis on ad hoc reporting needs for all departments.

•Develop, support, and administer SSRS solutions on intranet.

•Automate Excel reporting process in shared drives with MS VBA scripting.

•Maintain financial models for budgeting and forecasting in SQL.

•Assist Financial Analysts with preparation of P&L and reporting packages for board of director meetings.

•Assist Corporate Accounting team with quarterly cost actualization and budget to actuals.

•Maintain and reconcile ship deployment, pricing, cost, and other ancillary data in SQL.

SS&C GlobeOp (Servicing Ares Management as client) Aug 2013 to Apr 2014

Data and Pricing Groups Manager Century City, CA

•Manage client expectations and provide updates on issues log, projects, and achievements.

•Develop controls and checks to assist Capital Markets Investment Operations with risk management.

•Develop and enforce internal controls over offshored tasks.

•Oversee daily and quarterly pricing updates.

Ares Management LLC. Mar 2009 to Aug 2013

Data Group Manager (November 2012 to August 2013) Century City, CA

•Maintain data integrity of all Assets Under Management.

•Manage Corporate Action for the entire firm. (Communication, Processing & Accounting Verification)

•Evaluate design of data flows and reconciliation process.

•Research data requirement for new lines of business.

•Manage rating updates for public and private ratings from various vendors.

Senior Capital Markets Loan Operations Analyst (March 2009 to November 2012)

•Maintain loan investment universe in Advent Geneva and FCS Wall Street Office platforms.

•Assist PMs and Analysts with high yield debt restructures for borrowers coming out of bankruptcy.

•Document Capital Markets Loan Operations daily process. Train and supervise outsourcing and workflow.

•Manage Internal IT projects to automate repetitive tasks. Assist IT teams with system customization/upgrade planning, testing and rollout.

Countrywide Securities Corporation - Alternative Asset Management Jul 2007 to Oct 2008

Financial Systems Developer / CDO Analyst Calabasas, CA

•Monitor portfolio compliance tests with trustees and tie-out monthly remittance reports.

•Monitor and approve waterfall schedules and payment amounts.

•Create and maintain financial reports using Crystal Reports.

•Create Excel Bloomberg API spreadsheets to monitor assets daily.

•Coordinate modeling of new deals in CDO Sentry with Atlantic Information Systems.

University of California, San Diego - Moores Cancer Center Sep 2002 to Jul 2007

Information Systems Developer - Programmer/Analyst II (January 2004 to July 2007) La Jolla, CA

•Create and maintain databases for clinical trials research data.

•Develop and maintain a web-based data entry system for multi-institutional clinical research.

•Supervise and train help desk and student employees.

•Provide IT support for UCSD Cancer Center staff.

EDUCATION

University of California, San Diego - Math and Computer Science

SKILLS

•Programming Language: SQL, Excel VBA, JSON

•Experience with applications: Bloomberg, Advent Geneva, FCS WSO, SSB PAM, Black Mountain Everest, CDO Suite, CDO Sentry, Crystal Reports, Plaid, Microsoft SQL Server Studio, Microsoft Visual Studio, SAP.

Contact this candidate