We provide IT Staff Augmentation Services!

Sr. Consultant, Senior Business Analyst  Resume

5.00/5 (Submit Your Rating)

Nj

SUMMARY:

Business professional with significant experience developing, managing and implementing strategic and innovative communications for database and data driven projects in dynamic, global organizations. Able to leverage traditional technical experience, business and risk management with a proven ability to work in challenging, matrix environments with diverse functions and audiences. Extensive background in risk management, finance, financial products (including swaps and derivatives), coding, data architecture, cost reductions, project management and stakeholder communications. Passionate, thrives in fast paced environments, challenging environments, problem solver, articulate and innovative with a client focus. Authorized to work in the US for any employer

PROFESSIONAL EXPERIENCE:

Sr. Consultant, Senior Business Analyst

Confidential, NJ

Responsibilities:

  • Leads in trading platform surveillance of OTW, RTL and other surveillance methodologies in Big Data to determine fraudulent activity through root cause analysis and implementing corrective actions.
  • Develops communication plans and strategies for key Basel group and Risk Architecture initiatives, including business transformation, controls, regulatory and user training.
  • Manages communications plans and strategy for 10 business presentations since 2015. Efforts received extremely positive feedback from senior management, Managing Directors and business project teams,
  • Develops and launched an extensive and highly commended communications program in support of the new integration of database vision and architectural model, leveraging a mix of channels/ including a presentations and written communications. Partnered with Operations, Business and Risk Architecture teams to deliver end - to-end program.
  • Revamps digital communication channels to effectively cascade core messaging across diverse employee populations, while leveraging social media tools such as collaboration sites to enhance business engagement.
  • Provided support with analysis (SQL) to determine categories of Basel, CCAR reports to be migrated based on frequency of usage, categorization of reports, complexity of logic of reports, database logic review, discussions with users, Operations and Production Support and internal auditing and change management experts.
  • Leads in development of Functional Requirements Document for strategy, scope and priorities for implementation of Basel III reports for various asset classes such as OTC derivatives, repos, CDO or collateralized debt obligations, Securitizational Trade Products based on calculations of RWA, LGD and PD.
  • Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, User Cases, UML diagrams for overall System and business and process analysis.
  • Developed and documented timelines for Project Delivery and managed Projects and resources to successful completion with Agile methodology
  • Validates and tests reports using Cognos to ensure testing standards were met for Basel, Finance and Risk reports such as variance analysis, international scorecards and profits and loss reports.
  • Manages a project with responsibility for integrating reports from outsourced database.
  • Responds to requests from customers across the business organizations to determine credit risk components required in reports.
  • Facilitated planning sessions with SME's in understanding the requirements from Loan origination to loan processing
  • Designed and maintained a SharePoint application where client data can be stored and accessed enterprise wide for the following purpose: enhanced due diligence by Basel II personnel, periodic diligence reviews, report generation and other inquires mad over the life of the client relationship
  • Developed and monitored data migration procedure for migrating data from legacy system to existing Opima and Private Bank Wealth Management systems

Tools: SQL Server, Oracle and Teradata, Cognos

Confidential, NYC

Managing Director

Responsibilities:

  • Eliminated losses across regulatory risk buckets such as regulatory penalties, regulatory remediation and regulatory restitution by eliminating manual adjustments amounting to $10 billion
  • Performed BAU tasks as Variance Analysis of reconciliations, general ledger eliminations, Credit Benchmark PD indicators.
  • Interviewed Business users to gather requirements and analyzes the feasibility of their needs by coordinating with global Project managers, executive management, technical leads, Risk and IT
  • Responsible for the clerical functions involved with daily monitoring of activities related to credit risk as: Basel III and CCAR and other testing and validation of quarterly and daily tasks
  • Conducted in - depth analysis of customer transactions (SQL) and relationships to ensure conformity with Basel III for products as CDOs, repos, OTC derivatives, swaps, futures and fixed income bonds and facility loans for wholesale and wealth management sector
  • Reviewed documentation to verify that the clients' transactions meet the standards of Basel II and summarized all of the business process and controls in the procedures for daily and quarterly tasks
  • Played a key role in the planning, testing and implementation of system enhancements and conversions
  • Conducts sessions with IT groups by identifying key changes and participating in Stakeholder Management to communicate effectively with them in Agile methodology
  • Managed a project with responsibility for integrating reports from outsourced database.
  • Responded to requests from customers across the business organizations to determine credit risk components required in reports.
  • Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and business
  • Created procedures to in corporate market data onto financial products as fixed income from FINRA, MSRB market pricing for models that regulatory group uses to assess the liquidity of product.
  • Responding to regulatory and internal audits on risk and control structures and processes to investigate discrepancies in customer transactions and provide corrective actions

Tools: SQL Server, Oracle, Teradata, Datawarehouse, ETL side, WKFS Maestro Rules.

Manager

Confidential, NJ

Responsibilities:

  • Partnered with senior leaders to optimize their effectiveness as communicators and developed and implemented strategic communication plans to help meet their risk and control oriented business objectives.
  • Supported the executive director of Fraud for leadership team for site visits, town halls, and risk and control communications, blogs, videos, employee engagement and leadership calls.
  • Launched Fraud’s first blog for head of retail, enhancing employee (retail staff) engagement.
  • Created predictions for international losses using correlation factors in Tableau and SQL queries with Monte Carlo Simulation that achieved $200,000 in preventions.
  • Conceived and drafted presentations, organizational announcements, newsletters and strategic communications plan for the EVP, Head of Global Fraud, Finance and senior team. "Roadmap" newsletter recommended as a model for Fraud.
  • Advanced leadership and talent development efforts through performance coaching, mentorship, and ongoing succession planning for next generation leaders
  • Performed analysis using,Python, R, Tableau and Oracle to determine compliance with Fraud regulations to produce reports for departments that will remedy in the event of fraud vulnerabilities are exploited as a risk management procedure.
  • Performed Scenario Testing analysis utilizing Teradata and Excel to determine compliance within US, and international phone calls analyzing attributes as thresholds for gaming cellular systems of telecomm systems through interaction between terminating and originating users.
  • Managed a team with operational responsibility for running aforementioned models and reporting.
  • Develops companywide reports based on assimilation of regional reports across all business lines for executives.
  • Created PowerPoint presentations for client meetings to summarize fraud and losses within partnering retailers.
  • Responded to ad hoc requests from customers across the organizations to determine losses across the business using SQL Server.
  • Created dashboards and reports using Cognos to summarize losses and fraud across the business.
  • Validated data for dashboards created to summarize losses and business metrics for the Verizon Board of

Tools: Tableau, R, Teradata, SQL Server, Oracle.

Senior Experienced Associate

Confidential, NYC

Responsibilities:

  • Supported external communications facilitating Confidential process redesign initiatives in compliance with Confidential regulations to produce reports for regulators that will remedy in the event a bank becomes insolvent as a risk management procedure.
  • Provided communication support to client senior business heads, including strategic messaging, presentation development, and meeting facilitation.
  • Performed Scenario Testing analysis utilizing Teradata, Spotfire and Excel to determine AML compliance within UK, Mexico and US Confidential analyzing attributes as thresholds for Wiring, Wiring Structuring, Cash Structuring, credit card risk and Beneficiary Analysis of banking systems through interaction with end users and KYC
  • Performed analysis using SQL Server and Excel to determine compliance with Confidential regulations to produce reports for regulators that will remedy in the event a bank becomes insolvent as a risk management procedure.
  • Performed Scenario Testing analysis utilizing Teradata, Burb, Spotfire and Excel to determine AML compliance within UK, Mexico and US Confidential analyzing attributes as thresholds for Wiring, Wiring Structuring, Cash Structuring, credit card risk and Beneficiary Analysis of banking systems through interaction with end users and KYC.
  • Created instructions for end users using Spotfire.

Tools: SQL Server, Teradata.

Lead Quantitative Analyst

Confidential, NJ

Responsibilities:

  • Developed and implemented strategies, communications, analysis and tools to drive profit change from a service to sales environment. Helped develop sales tracking mechanisms, presentations for sales education/ product materials.
  • Supported implementation of a $3.9MM Reward and Recognition program for Marketing. Seen as a key lever to meeting aggressive 2013 business goals and driving profit increase.
  • Led monthly operational metrics reports based on SQL queries and PowerPoint presentations of new enrollments to drive increases in Sales and Marketing Revenue.
  • Ensured that the settlements meet the criteria of the customer compliance regulations by PJM utilities.
  • Led Identification of risk management metrics, resolution of incidents and escalation of tasks for VP of National Sciences to create customer awareness plans and strategic resolutions.
  • Developed/Implemented customer annual reports and customer segmentation analysis to distribute population across region and products and coordinated efforts with team, VP of Operations and VP of Marketing to ensure rollout of new products and launches.
  • Developed energy trading quantitative models using Python to analyze customer usage and trends using historical and near real time data to determine and forecast customer level contract compliance and population distribution.
  • Managed customer annual reports and coordinates efforts with team to ensure timeliness and validation of data.
  • Performed time series modeling to predict future prices of commodities for futures and OTC derivatives in Excel VBA add in creation.
  • Responsible for disbursements on contracts, reporting customer contract compliance statistics and settlements.
  • Managed an analyst with operational responsibility for running aforementioned models and reporting.
  • Monitored and creates monthly operational metrics reports and PowerPoint presentations of new enrollments through liaising with Project Managers for VP.
  • Identification of risk management metrics, resolution of incidents and escalation of tasks when appropriate in Incident Management Database utilizing SQL Server queries.
  • Documented procedures for Incident management database.
  • Responded to ad hoc requests from Marketing and Sales creating models to target specific sector for Marketing and develops models of Customer Specific baselines using SQL Server queries and Excel and interacted with the end user.

Tools: SQL Server, Excel Macro, SAS and Python.

Confidential

Business Analyst / Manager, NYC

Responsibilities:

  • Led Bank Secrecy Act and Stress Testing analysis and communication efforts including management of Loan, Risk awareness plans. Revamped internal SQL databases. Framework used by other corporate businesses.
  • Developed/implemented employee communication programs for bank-wide, strategic initiatives including technology, rollout of a new database, Six Sigma and consolidation of a National processing center.
  • Designed analysis to identify common elements in the Bank's loan portfolio that are ex-anti indicators of default credit risk management and reported these metrics to the Bank's CEO and CFO.
  • Designed processes and procedures to ensure timely and accurate capture of loan level data, analysis and rollup and reporting on a near real time basis at the loan and portfolio level to credit risk indicators to the Bank's Board of Directors, Director's Loan Committee, Audit Committee, CEO and CFO.
  • Provided support for calculation of loss given default and value at risk for significant loan portfolio segments representing concentrations of credit as well as industry concentrations within each portfolio segment to ensure adequate funding of the allowance for loan and lease loss reserve on a portfolio segmentation and industry concentration basis.
  • Provided support for liquidity risk management, stress testing, allowance for loan and lease loss reserve adequacy, concentration risk management and capital risk management model validation for banking system using Excel.
  • Tools used: MS Access, SQL Server
  • Financial Products: Assisted with evaluating ETD and OTC derivatives, swaps and fixed income security investment options including US treasury securities, sponsored agency securities and MBS pass-thrus, agency CMOs, municipal bonds, fixed income products, securities, DUS bonds, SBA protocols and corporate bonds, CDOs and repos.

Portfolio Planning Associate/Financial Associate

Confidential, NY

Responsibilities:

  • Developed competitive and industry analyses used by senior management and sales to help determine and improve product, pricing and target portfolio strategies.
  • Provided support including development of product and portfolio analysis targeted for both internal and external audiences.
  • Developed a model to integrate National Recognized Statistical Ratio Organization (NRSRO) ratings as well as various indices including Confidential 's Index and Confidential Index and other Indices as well as the current yields of fixed income instruments, options contracts, OTC derivatives, mutual fund indices, and distressed assets to determine portfolio worth for bonds, fixed income, equities, securities, money market funds.
  • Financial Products; fixed income instruments, options contracts, OTC derivatives, mutual fund indices, and distressed assets to determine portfolio worth for bonds, fixed income, equities, securities, money market funds, CDOs and repos.

Business Analyst

Confidential, CT

Responsibilities:

  • Developed and supervised implementation of $1mill annual Direct Maintenance Cost Blackhawk budget.
  • Prepared Budgets using Microsoft Project to determine operating expenses of labor and materials.
  • Saved $270,000 in 2008 and 2009 in conjunction with reliability and design team by implementing fixes on failed items and acted as a liaison between production, purchasing and reliability department and other cross-functional teams.
  • Prepared PowerPoint presentations for executive management monthly review meetings on reduction of maintenance costs on aircraft.

Tools: MS Excel, SQL Server and MS ACCESS.

We'd love your feedback!