Ccar Business Analyst/axiom Developer/grc Resume
New York, NY
SUMMARY
- Over 9 years Extensive work Experience as a Business Analyst, GRC (Governance, Risk and Compliance) Analyst and AXIOM Analyst, Insurance, Reinsurance, Underwriting, Claims Analyst in Banking, Finance, Mortgage, Insurance, Reinsurance, P&C Insurance and Health Insurance Domains.
- Detailed knowledge of Equity market (Common and Preferred stocks), Fixed Income securities including MBS, TBA, CMO, Corporate Bonds, Municipal Bonds, Convertible Bonds, Junk Bonds, Treasury Bonds, Treasury Notes, and Treasury Bills. In - depth knowledge of Trading Derivatives which includes Options, Contracts (Future and Forwards) and Swaps (Interest Rate Swaps, Currency Swaps, Total Return Swaps, Credit Default Swaps) in Capital Market.
- Strong analytical skills in analyzing financial risk such as Interest Rate Risk, Default Risk, Credit Risk, Inflation Risk, Operational Risk, Market Risk. Detailed knowledge of Risk Management using metrics such as Greeks, VaR, Duration and Convexity.
- Strong background in CCAR Regulatory Reporting especially in FRY 9C, FRY 14M/Q/A, FFIEC 041, FFIEC 031 reports and the related schedules.
- Working knowledge of Case Management Applications (e.g. Actimize) and Strong product knowledge on financial instruments and payment/Treasury products Understanding of AML, KYC process, and Trade Life Cycle Working knowledge of AML/Financial Data (e.g. Wires, checks, ACH, Accounts).
- Knowledge of various financial products, retail & commercial lending, credit risk management and regulatory risk reporting likeBaselII, CCAR and FDIC.
- As a Governance, Risk and Compliance (GRC) Analyst, provide support for revising internal security policies and standards, participate in risk assessments and audits with stakeholders, create and document internal processes to support GRC and participate in executing the cyber-security awareness program.
- Strong Experience in GRC Tools, GRC Consulting Risk Compliance Assurance Technology, GRC Technology, and GRC Process.
- Strong Understanding ofArcherData Feeds, questionnaires, calculated fields, work flow, reports, dashboards, I-views, Packaging.
- Maintain accurate information within the GRC tool, and the ability to prepare concise, accurate information while balancing project deadlines with the occurrence of unanticipated issues.
- In-depth knowledge of Dodd Frank, Basel I/II regulations for transparency of transactions and stockholders’ interests.
- Experience and knowledge of Axiom products. Experience in Black Knight and FIS loan servicing system.
- SDLC tasks - Requirements gathering, Analysis and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low Level Design documents, etc.
- Conduct GAP analysis in order to capture functionalities of existing systems and analysis requirements of the proposed system or enhancement in order to bridge the GAP and design solution and followed various SDLC methodologies which include AGILE Scrum, AGILE Extreme Programming, Rational Unified Process (RUP), Iterative, and Incremental and Waterfall models to execute the proposed requirements.
- Experienced with working with Testing teams, participated in writing Test Plans, Test Cases, Test Scenarios, RTM, Test Reports, and conducting various forms of testing.
TECHNICAL SKILLS
- MS Visio
- JIRA
- Banking and Finance
- Fixed Income
- Derivatives
- CCAR Basel stress testing
- Oracle
- HTML
- UML
- UNIX Shell Scripting
- ASP
- Windows 95/98/XP
- Crystal Reports
- MS Office++
- Python
- DB2
- SQL server
- MS Access
- SAS( Base
- Enterprise Guide)
- Eviews
- Matlab
- Excel.
PROFESSIONAL EXPERIENCE
Confidential, New York, NY
CCAR Business Analyst/AXIOM Developer/GRC
Responsibilities:
- Analyzed and documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies.
- Involved in development phase meetings for business analysis and requirements gathering.
- Maintained a working knowledge of the Comprehensive Capital Analysis and Review “CCAR”.
- Had intimate knowledge of the line of business data to ensure Instruction changes have minimal impact to CCAR Schedule.
- Analyzed and created Business Requirements and Functional Requirements for 14Q/A Actual for various schedules.
- Assisted the 14A Projection team in the analysis for PPNR schedules - PPNR Submission, NII, and Metrics.
- Responsible for executing on project management efforts for PPNR and balance sheet projections over nine quarter horizon.
- Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
- Proficient and experienced in Market Risk functions such asSensitivities, VaR Computation, Trading PnL computations, Understanding of Trade booking & settlement process and sound understanding of Regulations such asBasel II.5, Volcker, Basel III.
- SupportedEaglePace data management importers, exporters, events and stored procedures. Created and maintainedEagletrade log and reconciliation reports.
- Used SQL to analyze data on the databases andEaglesystems.
- Tested the flow of data from Compass toEagleand Informix databases
- As an Market Risk role, collects data used in measuring the Company’s financial risk, organizes, and analyzes data to validate the accuracy of the forward prices.
- Updated BRD and FSD requirements documents for Basel 2 RWA calculations.
- Participated in RWA model development (General Market Risk, SRAO, CCR, and SSFA).
- Supported calculation of General Market RWA, Counterparty RWA, Credit RWA, SSFA, and SRAO.
- Assisted the execution of CCAR stress testing framework including gathering requirements of multiple stress scenarios and defining data elements required by stress tests.
- Coordinated with Finance & Regulatory Report Automation Project (Dodd Frank and Call Reporting Process) designed to enhance production efficiencies while decreasing operational risk by using automated reporting application AXIOM SL.
- Documented the manual upload process for AXIOM team for different schedules - 14Q/A.
- Created different types of reports in AXIOM- Control Report, Adjustment Report, and Manual Upload template.
- Experience in AXIOM Controller View for Report Development.
- Migration of Axiom components from one environment to another. Developing new Data Sources, Data Models, Portfolio, Aggregation, Workflows inAxiom.
- AxiomDevelopment on below Controller View objects like creating multiple data source objects to load the flat files from the STAR Data Mart.
- Performing Import / Export of theAxiomObjects across the multiple environments for testing purpose.
- PerformingAxiomadmin activities like creating users for the DEV / UAT team Interaction with Users if required.
- Serve as liaison between Finance Team and OFSAA, DRM,AxiomSL configurators.
- Controller View (CV) delivers data lineage, risk aggregation, workflow automation, and validation and audit functionality and supports disclosures in multiple formats, including XBRL.
- Developed SQL Scripts for the Online Editing Application for the Client interface.
- Retrieved and analyzed data using T-SQL, Excel, SSRS.
- Used the SQL queries to pull and analyze historical data to determine appropriate loan size, terms, and pricing for the customer.
- Developed the Interfaces in SQL for Data calculations and data manipulations.
- Assisted in implementing the Liquidity Module of OFSAA (Oracle Financial Services Analytical Applications) for LCR / Federal reporting.
- Ensured the correctness of data uploaded to OFSAA staging, development and production tables by validating this against the source system data.
- Developed and lead team for Liquidity Risk Management (LRM) application on OFSAA.
- Developed end to end documentation for forms framework and OFSAA platform.
- Strong Understanding of RSAArcherData Feeds, questionnaires, calculated fields, work flow, reports, dashboards, I-views, Packaging.
- Delivering software orbusinessconsulting services within theArcherPlatform.
- DeployedArcherapplications to provide user acceptance testing, performance load testing and production work.
- ProvidedArcheroperational support, including troubleshooting issues, user IDs and report and data requests support.
- ProvidedRSA Archeroperational support, including troubleshooting issues, user IDs and report and data requests support.
- Took RSA'sArcherBasic Administration class. Knowledge in building on-demand application, dashboards, workspace, global iViews.
- DeployedArcherapplications to provide user acceptance testing, performance load testing and production work.
- Performed AML analysis and work with the business line to complete the documentation requirements to create the Customer Due Diligence (CDD).
- Performed an alert review on alerts generated from the AML Transaction Monitoring System.
- Functioned as a key contributor with demonstrated knowledge of AML/KYC issues, as well as broader functional knowledge.
- Complied with Anti-Money Laundering (AML) and Anti-Terrorist Financing (ATF) laws and regulations.
- Observed Know-Your-Customer (KYC) principles and customer identification regulations.
- Assessed operational implementation of the Bank’s AML policy and procedures; provided recommendations to responsible Global AML Compliance Officers to ensure the consistency and accuracy of the Bank’s KYC records.
- Used Performance Monitor andSQLProfiler to optimizequeriesand enhance the performance of database servers.
- Develop and maintainSQLqueriesfrom multiple data sources to support thebusiness.
- UseSQLto analyze,query, sort and manipulate data according to definedbusinessrules and procedures.
- Import multiple Daily and Weekly csv files Using Bulk InsertSQLcommand into Tables to generate Reports.
Environment: AXIOM Controller View, Windows XP, SQL, MS Excel, PowerPoint, MS SharePoint.
Confidential, NJ
Business Analyst
Responsibilities:
- Implemented business logic, data lineage mapping and traceability for Dodd Frank regulatory reports: Monthly and Quarterly FR Y-14 and Quarterly Call Reports (FFIEC031, FFIEC 041, FR Y-9LP & FR Y-9C) for Federal filing 2015 & 2016.
- Created custom monthly report whole sales and retail banking (First lean mortgage, Home equity loans, Auto loans, Small business loans and other consumer loans) for different loan services used by the bank.
- Worked with other line of business on initiative of identifying, researching, and rectifying gaps and discrepancies in Regulatory Reporting.
- Accountable to lead Business Acceptance Testing ( BAT) team and finance team in implementing logic deployed to populate regulatory reporting schedules, via creating Test Data according to Axiom Mapping Logic and Filteration Logics of the FFIEC 031, FFIEC 041, FRY 14M/Q as per the required Schedules (Schedule A, A2, A7 A9).
- Created Blank Instances from Source Maintenance - Axiom Controller View for the FFIEC 031, FFIEC 041, FRY 14M/Q Reports.
- Performed Enrichment according to the appropriate Project, Branch and Workflows for the FFIEC 031, FFIEC 041, FRY 14M/Q Reports.
- Ran the Report in Axiom Controller View Tool to view the Output of the FFIEC 031, FFIEC 041, FRY 14M/Q forms.
- Worked as part of the AXIOM team on the business rules and the change requests when there were changes from Dodd Frank.
- Writequeriesto resolve Ad-hoc requests and modified existing Stored Procedures and Views.
- WroteSQLtriggers for checking Insert and Update on particular tables.
Environment: AXIOM Controller View, Windows XP,SQL, MS Excel, PowerPoint, MS SharePoint.
Confidential, McLean, VA
Business Analyst
Responsibilities:
- Project involved various Governance, Risk and Compliance duties which include the following:
- Monitored and managed compliance to the supply chain governance framework within the company.
- Facilitated the audit process and tracking corrective actions identified per deficiency.
- Facilitated the risk management process.
- Developed and communicated standards for adherence to governance principles within the company.
- Coordinated SOX testing and audit requirements.
- Identified new best practices and continuous improvements through benchmarking, innovative ideas and approved methodologies to improve governance, risk and compliance within supply chain. Experience using bank origination and loan systems Black Knight, Atlas On Base and other systems of record.
- Reviewed policies and procedures in order to identify gaps and provide with recommendations.
- Assist with multiple aspects of themortgageloan origination process, including ordering title work, appraisals, surveys, tax return transcripts.
- Reviewed approvedmortgageloan to determine conditions that must be met prior to closing and funding such as purchase of privatemortgageinsurance, Taxes and HOI to be paid.
- Provided a consultative service to stakeholders in the design and implementation of risk mitigating controls & solutions.
- Risk Mitigation Planning and implementation of risk management initiatives and compile risk mitigation plans in order to proactively action identified risks.
- Managed documentation retention process including facilitation storage and follow up on overdue/redundant policies and procedures with document owners.
- Involved in the stack sessions, and met with all stake holders to understand, articulate, and document the requirements.
- Worked on projects which used RUP and Waterfall methodologies.
- Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the internal systems.
- Facilitated JAD sessions with the management, developers and analysts from all the dependent systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
Environment: MS Office Suite 2007, MS Visio 2007, SQL, HTML, XML, Mercury Quality Center 9.0, RUP, UML
Confidential, Westchester, IL
Business Analyst
Responsibilities:
- Served as the liaison between the Academic Tools and Utilities IT teams, New Teach and TATA Consulting off-shore development teams, and Follett product managers. Managed the inter-departmental coordination task of developing, clarifying, and finalizing business and functional requirements for new application/system development projects, system enhancement projects, and in sourcing formerly outsourced applications and systems.
- Initiated, developed and managed the agile development process for the Academic Tools and Utilities team.
- Defined and implemented business processes as well as a BA engagement process for interactions with business teams.
- Managed offshore resources, participated in code reviews, and daily stand-ups.
- Developed and monitored QA test plans (i.e. new feature, regression testing, etc.).
Environment: Rational Rose, Requisite Pro, Quality Centre, SQL, MS Office (MS Word, MS Excel, MS Access), Crystal Reports, Java, Oracle.
Confidential, Coral Springs, FL
Credit Risk Analyst
Responsibilities:
- Mitigated exposure to credit and fraud risks.
- Negotiated collateral requirements and restructuring terms as required.
- Resolved merchant issues with Credit Card processing accounts.
- Implemented risk management policies and procedures.
- Interfaced regularly with Alliance Bank partners.
- Prepared monthly reporting and communicate risk management results to Alliance partners.
- Coordinated risk mitigation efforts with other areas of the business such as Funding, Legal, Operations, Client Services, etc.
- Produced monthly management reports.
- Created procedures for various workflows.
- Conducted process and system improvement studies.
- Completed Suspicious Activity Reports (SARs) for Cases as needed. The reports were utilized by senior and board-level management to assist them in decision making, communicating to regulators and shareholders. Validated loans adherence to policy, procedures and compliance with federal laws and regulations.
- Increased report development efficiency by 60 % by utilizing SAP Business Objects.
- Worked effectively with senior and executive level management to determine, analyze, and report the bank’s ability to absorb loss and calculation of needed provisions.
- Forecasted perspective changes on the banks’ credit and risk trends on a monthly and as needed basis. Improved bank’s projection accuracy from 60% to 90%.
- Submitted discrepancies to lending officers and operations to make necessary corrections. Loan portfolio error margin, policy exceptions, and audit citations decreased to less 3%.
- Alleviated three days from the month-end reports verification and reconciliation process using VLookup and pivot tables in Microsoft Excel.
Confidential
Insurance Underwriter, Claims & Risk Analyst
Responsibilities:
- Reviewed applications for Insurance acceptance.
- Led and coordinate renewal initiatives with the goal of improving customer retention.
- Analyzed exposures, claims data, loss ratio, etc. to create sound underwriting decisions.
- Handled underwriting decisions on new and renewal business and referrals that fell outside the guidelines and within delegated authority levels.
- Handled assigned workload within quality, productivity and service standards.
- Provided technical underwriting support for team members.
- Assisted agents and policyholders with policy questions and complaints.
- Reviewed and process endorsements, cancellations, reinstatements, DMV submission, etc.
- Requested additional documentation needed to successfully process an application, renewal quote or endorsement request.