SUMMARY:

• Years of professional experience in Ecommerce, Healthcare, Banking as a Business system Analyst.
• Strong understanding of construction projects and operations.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Analyzing, understanding and effectively assisting in the identification, prioritization and management of the key risks of the business.
• Created several templates, reports and queries in Business Warehouse as part of the simplification process.
• Excellent in Developing and evaluating business process Models. Effective utilization of available data in Salesforce to identify risks and provide practical risk management solutions for the firm.
• Connoisseur in documenting Business Requirements Document (BRDs), Functional Requirements Document (FRDs), Non - Functional Requirements Documents, Use Cases, Test Cases and User Interface Prototypes
• Develop database, data warehouse, and reporting solutions for the capital asset team's lending and risk data.
• Research, Analyze and create Lifecycle Services Compliance Package for key Stakeholder.
• Work closely with Service Managers and Account Managers on compliance and uncovered opportunities.
• Established entitlements reporting for a number of applications for compliance.
• Experience Financial, Statistical & Business Intelligence Reporting: Crystal Reports, SAP, Business Objects, Excel, & SSRS (horizontal markets- finance, billing, resources, metrics, B2B, B2C, process improvement, operations).
• Oversaw overall credit card processes from enterprise operational perspective; including PCI compliance, contract fulfillment with Visa and Chase Paymentech.
• Interact with ARS leaders from Legal, Internal Audit, Risk Management and Compliance.
• Creating daily reports and tasks efficiently. Member of 2 projects which spans multiple departments - Coordinating with different stakeholders for handover4 and migration of processes, Excel, Microsoft Access, Crystal Reports, Raisers Edge, SQL Server 2012, Office 365, PL/SQL, Windows, Power BI.
• Requirement elicitation and preparation of Report Specification for various Basel compliance reports.
• Further conducted research on high-risk customers and submitted written profiles to management for ongoing risk assessment.
• Knowledge in developing and deploying custom integration Salesforce.com CRM solution.
• Attend key meetings, both internal and external, and report findings from the meetings.
• Design and develop models for econometric and quantitative analysis around product.
• Analyze and assess data usage and product performance for maintenance prioritization and compliance with service level agreements.
• Ability to effectively translate Salesforce data into business understandable metrics using Reports (Matrix, Summary, and Tabular), Analytical Snapshots, and Dash Boards (Static and dynamic).
• Utilized advanced MS Excel to manipulate data and support DSS - Decision Support Systems
• Experience in using Unified Modeling Language (UML) for creating Use Case Diagrams, Business Process Model, Class Diagrams, Activity Diagrams, Sequence Diagrams, and work flow diagrams. Strong experience in RUP Business Modeling process.
• Hands-on experience on Tableau Desktop, Tableau Reader and Tableau Server
• First-hand experience in Waterfall and Agile (Scrum) methodology of Software Development Life Cycle (SDLC) .
• Knowledge in bulk Data mitigation from Excel, MS Outlook and Legacy systems to Salesforce.com using Apex Data Loader, Import Wizard. Involved in data integration to SalesForce.
• Supporting the delivery of corporate risk management and business resilience requirements of multinational clients.
• Experience in migrating data from various systems into Salesforce CRM using Data ETL tools Informatica on Demand, Cast Iron, Data Junction (Pervasive), and DQC.
• Driving multiple JAD sessions to capture the business needs vs. wants.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Collaborate on product launch plans and servicing requirements
• Developed business solutions for SAP Customer Master Data configuration to support new SAP Hybris Cloud 4 Customer Project.
• Enabling clients to advance their risk understanding in order to facilitate a more fit-for-purpose risk management framework, increased business resilience awareness, and transfer strategy.
• Developed business solutions by leveraging SAP SD HANA & Material Master Data configuration to support new e-commerce Hybris Project.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Business Intelligence, Client/Server applications.
• Strong knowledge in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Utilized SLT to integrate SAP ECC master data to Hybris using SLT private cloud. Created the VPN with RFC connection from SLT to ECC/CRM and Hana and replicated the master data and Target groups using control tables dd02L, dd025 and dd08. Initiated the Initial load and Delta for the update.
• Performed and coordinated compliance review with senior managers and external auditors Performed audit to ensure originated loans are in compliance with Truth In Lending Act and RESPA.
• Creating / maintaining the data mapping for each vendor (e.g. Confidential ) field with the Eagle fields in order to load / upload the relevant data within the Eagle database.
• Knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Familiar with new SAP CRM package tool to extract data into SAP Hybris.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Member of Compliance Team focused on verifying any changes to customer risk scoring.
• Meet with business users to gather requirements for various SharePoint projects.
• Knowledge in developing and deploying custom integration Salesforce.com CRM solution.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
• Research and analysis of data, market needs, and customer issues.
• Experience with ATG / Oracle Commerce and/or Endeca.
• Develop client software to consume already published web SOAP services to interface with Hybris and Endeca.
• Knowledge in bulk Data mitigation from Excel, MS Outlook and Legacy systems to Salesforce.com using Apex Data Loader, Import Wizard.

TECHNICAL SKILLS:

Methodologies:: SDLC, QA Life Cycle, Waterfall Development, Agile Development, Data Extraction, Data Visualization, Complex Data Analysis, SQL/Macola ERP, Process Modeling, Gap Analysis, Change Management, Impact Analysis, Root Cause Analysis, SWOT Analysis, Project Planning, Budgeting and Scheduling, JAD Sessions. REST APIs, CCAR/DFAST/ICAAP/Risk Appetite Capital. Transportation Lifecycle Management (TLM), Warehouse Management Open Systems (WMOS), SAP APO DP- (Advanced Planning Optimization), SAP SCM APO 5.0.

Databases:: Progress, MS Access, Oracle, SQL Server.

Operating Systems:: Windows Server, RUP, Agile/ SCRUM framework, and Waterfall. SQL, HTML and XML. Database Oracle 10g/9i/8i, DB2, MS SQL Server Office Tools MS Office (Package), MS Visio, MS Project, MS FrontPage. Ecommerce Platforms SAP hybris, Oracle ATG, IBM WCS commerce, Magento, Fry's, Blue Martini. Oracle, Database,E-Business, Compliance, Regulatory Compliance, Order Management, Oracle Forms, GS1 Model, RUP, Agile/ SCRUM framework, and Waterfall. Risk Management, Risk Assessment, Risk Analysis SQL, HTML and XML.Teradata, Database Oracle 10g/9i/8i, DB2, MS SQL Server Office Tools MS Office (Package),PIM, MS Visio, MS Project, MS FrontPage. Ecommerce Platforms, Oracle ATG, IBM WCS commerce, Magento, Fry's, Blue Martini. Microsoft Excel and Access, Query Analyzer, SharePoint, Office 365,Oracle,Database,E-Business,Order Management,Oracle Forms, MySQL, SQL Server 2005/2008, PL/SQL, Oracle, UNIX, Windows, CRM, Data Analysis, Microsoft Share Point, Statistics 101, Windows and Macintosh OS, Data Extraction, Data Visualization, Data mapping, Data minning,Data Modelling, Complex Data Analysis, Inferential and Descriptive Statistics, CRM tools, AGILE/SCRUM, Process Improvement, Business Strategy, SharePoint, Excel, Microsoft Access, Crystal Reports, SQL Server 2012, Office 365,Scrum, Lotus Notes, Cognos. Autosys and Control-M, Virtual User Generator, Load Runner, Rational Unified Process (RUP), Test Director, Quality Center, MMIS, EPIC, EDI X12, HL7, HIPAA, ICD 10, Mainframe COBOL, DB2, JCL, CICS, MVS.

PROFESSIONAL EXPERIENCE:

‎ Confidential, San Francisco, CA

Business Data Analyst

Responsibilities:

• Developed business solutions by leveraging SAP SD HANA & Material Master Data configuration to support new e-commerce Hybris Project.
• Develop application User Stories against business requirements.
• Experience in Designing and implementing data integration modules for extracting, transforming, and loading (ETL) functions. Worked on Gap Analysis.
• Gathered, analyzed, reviewed and documented design documents & business requirements, functional specifications/requirements and Use Case Document relating to business requirements to learn the scope and purpose of the application.
• Reviewed the developed product with Development before the release cycle and worked with development to fix issues.
• Coordinated with senior management in developing effective internal controls methodology, and identifying better business process improvements to compliance policy and procedures.
• Experienced Supply Chain Consultant and Business Analyst with expertise in production planning, supply chain management and SAP APO.
• Worked closely with Risk Management team supporting the firm’s AML program.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Business Intelligence, Client/Server applications.
• Actively participated in the weekly status report meetings between team lead, developers, SME and Project Manager.
• Created PowerShell scripts to migrate and tag documents from file share to SharePoint.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact, Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Develop business solution for Customer Master Data configuration to support new e-commerce Hybris Project.
• Preparation of mapping documents for data flow from source system to various stages of datamart
• GRDW Liquidity Compliance.
• Completed mapping of vendor data, items, and purchase orders, as specified by business.
• Create custom SharePoint Designer workflows to automate business processes.
• Integration: cloud services/applications, SharePoint development, organization of archived documentation.
• Reviewed accounts to determine bank’s exposer to risk and escalated for review. Produce risk determination narrative submitted with supporting data. Mitigated 18 cases weekly.
• Identified and investigated high risk transactions. Worked as business analyst in the Market Risk Technology Team supporting platforms being delivered to the risk managers for their day to day activities and support.
• Compliance system had regular updates every six-months which involved enhancements in existing functionality and addition of new functionality.
• Collaborates with senior compliance management to ensure effective policy and procedures are in place.
• Assisted in establishing and executing operational procedures for business continuity planning and operational risk management.
• High proficiency with Microsoft Office applications - InfoPath reports, Outlook, templates, SharePoint applications and integration.
• Generated forecast reports from gap analysis models, risk pipeline and Siebel leading to 10% increase in sales.
• Responsible in doing the Proper Data Mapping by querying the Murex Database with respect to the missing identifiers and mapping the same with the Identifiers Coloum.
• Worked on a global team to support and implement SAP/SD and Master Data in other business units. Perform monthly APO DP forecasting, MRP transfer and SNP deployment planning tasks.
• Develop and implement new functionality requests by users and configure, maintain and resolve issues related to the existing SAP Core Interface, APO Demand Planning and Supply Network Planning solutions.
• Integrated Hybris with SAP ECC and CRM using Data Hub core extension, Used Hybris Data hub and processed the data using CRM customer, ECC product, order and utilized synchronous and asynchrous integration using IDOCS in the backend.
• Used ETL Informatica to do source to target mapping for business Objects migration to enterprise data warehouse.
• Data analysis of existing data base to understand the data flow and business rule applied to different data bases by SQL . Used Basic SQL Queries for Data Mapping like SQL Join queries like Inner Join, Left Join, Right Join, etc.
• Wrote User Stories even for Service Now Rest Objects. Help business stakeholders configure their new SharePoint sites.
• Conducted meetings with the business and technical team to gather necessary analytical data requirements in JAD sessions.
• Used complex pre-defined and Ad-Hoc SQL queries for data validation, duplication, forward/reverse engineering for data mapping and ETL for data migration from the ERP/OLTP to the Data warehouse/OLAP system.
• Worked on enhancements for most of the mission critical Applications, which include Java, J2EE, JMS, Struts, spring, Hibernate, Service Now Rest API's, which are involved in Collections, payment Gateways, Network Provisioning etc.
• Responsible for data mapping and data mediation between the source data table and WMO data tables using MS Access and MS Excel.
• Experience in Conceptual, logical/physical database design & review sessions to determine and describe data flow. Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various new and Existing Applications across Enterprise and Data Warehouse.
• Proposed SharePoint-based solutions to improve existing business challenges. Implemented company's business standards in SharePoint.
• Improved APO-DP transactional data quality by re-design of APO-BW structures so that it supported planning processes.
• Provided Supply Chain Planning's input to the Interchangeability and Substitutability proof of concept for ECC 6.0 and helped develop the Service Parts Planning Proof of Concept for SAP APO release SCM2007.
• Perform all stages of testing in APO, BW and ECC for SAP upgrades and rollouts to new divisions.
• Utilized Hybris configurable product (CPQ). This solution used existing configurable products setup for SAP Variant Configuration (VC), Integrates CPQ configuration user experience and process in Hybris to SAP backend.
• Provided complete support and implemented new configuration for the SAP APO and ECC systems. Lead the initiative on change management of new processes to support APO planning systems.
• Lead blueprint and requirements gathering sessions and establish current state and future state vision for APO DP.
• Direct the SAP MDM team responsible for the data integration and quality between ECC and APO.
• Solely responsible for supporting APO and SAP ECC instances.
• Utilized SLT to integrate SAP ECC master data to Hybris using SLT private cloud. Created the VPN with RFC connection from SLT to ECC/CRM and Hana and replicated the master data and Target groups using control tables dd02L, dd025 and dd08. Initiated the Initial load and Delta for the update.
• Heavy use of SharePoint 2013 social features and functionality.
• Managed the SAP Master Data Management team responsible for the data integration quality between ECC and APO.
• Familiar with new SAP CRM package tool to extract data into SAP Hybris
• Involved in design of a SAP based solution for Confidential . The harmonized solution envisages the usage of SAP Hybris.
• Utilized SAP Hybris for search and merchandising, content management, Order management, product information management and digital asset management.
• Hybris marketing is utilized to created the target group using Customer data management of Hybris.
• Experience in SharePoint Development of Features for deploying web parts, workflows, custom menus, content types, sites templates in SharePoint 2013/ SPS 2010.
• Architected the commerce solutions such as B2B and B2C scenarios on the Hybris Platform and conducted the requirement and design sessions.
• Worked with Hybris Report Cockpit for the report dashboard. APO instance includes Demand Planning, Supply Network Planning and Production Planning and Detailed Scheduling modules as well as Core Interface, Business Intelligence Warehouse and Live Cache. ECC instance includes Production Planning and Materials Management modules. Also performed Basis functions related to APO and PP.
• Worked with Hybris Product cockpit for the product and catalog modeling. Provided technical support for SAP software modules in APO (DP and SNP) and PP (MRP, MP, PI, SOP, SFC) areas.
• Worked with Hybris CMS cockpit for the content management
• An in depth understanding of how to integrate Hybris with a corporate back office fulfillment product like SAP and CMS systems.
• Manage CertainTeed's forecasting process by developing new macros, jobs, etc. in APO DP per user requirements. Supported the interface between legacy sales information system, Sales tracker, and APO DP.
• Participated in requirements gathering sessions to determine site hierarchy and design, navigation, search and security for SharePoint.
• Design the system architecture for the project, Design data models for Customer, Products etc.
• Design the approach for the data migration into the Hybris system from SAP systems. Provided the integration strategy documents, designed the classification hierarchy.
• Performed Business Process Modeling (BPM), Analysis & Re-engineering and providing solutions for issues relating to Risk management and Solution Management processes for better and efficient decision making in time.
• Capable of producing various documents like functional specifications requirements (FSR), business requirements documents (BRD), business process documents, user manuals, user interface specs and data mapping documents.
• Documented High Level Business needs, Requirement Report, Project Report, User Stories, bug reporting and other project deliverables in synch with SDLC mandates.
• Elicited requirements through brainstorming, Joint Application Development (JAD) and interview sessions.
• Maintain CIF Integration Models for Master and Transaction Data transfer between ECC and APO. Mass Maintenance of Master Data in APO.
• Have a working knowledge of APO PPDS, CIF and live Cache functions, along with ECC MM, SD and Basis areas. Proficient in the SAP BIW as it relates data integration to Demand Planning and BEX reporting from APO.
• Created Business Requirement Document (BRD), System Requirement Specification (SRS) and Functional Requirement Document (FRD).
• Adhered to Good Manufacturing Practices (GMP) to implement changes in SAP ECC and Advanced Planning and Optimization (APO) systems: Ensured compliance to FDA standards.
• Implementing and reinforcing the SAP APO, highlighting the importance of understanding the connection among different modules, and how all areas integrate with each other.

Confidential, Dublin, OH

Business Data Analyst

Responsibilities:

• Worked on Hospital data processing for improving database for storing user files.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Experience in Conceptual, logical/physical database design & review sessions to determine and describe data flow. Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various new and Existing Applications across Enterprise and Data Warehouse.
• Provided SharePoint best practices and advice regarding site set-up, site security, maintenance, and future needs.
• Developed and implemented several SharePoint 2010/2013 and SharePoint Online solutions using Angular, Knockout, JavaScript, JQuery, HTML, CSS, Kendo UI, PowerShell, and REST.
• Led the initiative on change management of new processes to support APO planning systems.
• Communicated data-related standards and conducted data modeling JAD sessions.
• Gained thorough knowledge in Oracle RDBMS concepts like Normalization, Data Modeling, Data Integration, and Database Designing.
• Identified new functionalities in APO modules. Designed and implemented a full APO SNP network distribution model and completed 2 full lifecycles for Primed Product Model and Color Plus Product Model.
• Migrated SharePoint 2010 sites to 2013. Created and developed workflows using Nintex and SharePoint designer.
• Worked with large data sets, automate data extraction, built monitoring/reporting dashboards and high-value, automated Business Intelligence solutions (data warehousing and visualization).
• Created the logical and physical Data model using MS Access. .
• Active involvement in ETL design for data integration and master data management.
• Worked with SQL queries for data manipulations. Designed and implemented a SAP APO DP module and completed 1 full lifecycle for all product forecasting.
• Prepared Test cases & Managed Requirement churn by incorporating changes to product backlog.
• Created Entity relationship diagrams for the proposed database.
• Participated in the development and creation of the data warehouse.
• Assisted in building a business analysis process model using Rational Rose, Requisite Pro and Visio.
• Involved in Designing, Mapping and Testing of the ETL transformations to populate the data from various source systems feeds using Informatica.
• Performed Data Analysis and Data Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored.
• Architected and developed SIS SharePoint 2013 Intranet site.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams.
• Very good understanding and experience in Relational Database Management Systems (RDBMS) like Oracle, SQL Server, Teradata, DB2, IMS, MySQL, including scripting, querying, updating, data extraction, analysis, modeling, testing.
• Built several SharePoint 2010/2013 solutions using out the box features.
• Well experienced with Informatica, in handling huge volumes of data in a Data warehouse for various ETL processes spanning over multiple systems with multiple source to target mappings and complex transformations.
• Responsible for systems infrastructure support of internet/internal/extranet websites which included SharePoint Administration, system analysis, creating workflows, and SharePoint development.
• Gathered High-Level and Detailed-Level functional and non-functional requirements via daily JAD sessions to define the Business requirements and also created Requirement Traceability Matrix (RTM) .
• Worked to create data mapping documents and worked with business to write transformation rules through SQL.
• Coordinated the upgrade of Transaction Sets 837 to HIPAA compliance.
• Did gap analysis for HIPAA 4010 EDI 837 and HIPAA 5010 EDI 837.
• Involved in impact analysis of HIPAA transaction sets on different systems in Assurant Health.
• Identifying the requirements for accommodating HIPAA 4010 and 5010 standards for EDI X12 transactions
• Performed data validation using SQL queries. Monitored and maintained compliance regulatory process and procedures.
• Shared knowledge by performing Impact Analysis on transition from ICD 9 - ICD 10, made suggestions on UI and other changes required to be met during transition.
• Involved in requirements gathering and preparing the technical system design and System Design analysis of the flow of EDI transaction sets 834, 835, 997.
• Extensively used SQL and PL/SQL to retrieve the data from databases to perform data validations and comparisons for regression testing.
• Formulated procedures for data extraction, transformation and integration of healthcare data
• Experience on projects related to Health Information Exchange (HIE), Interoperability, Medicare, Medicaid, EDI transactions (inbound and outbound: 837, 820, 834 etc., ) HL7, Eligibility and Benefit systems, ICD 10, HCPCS, CPT, Claims Adjudication and expert in Affordable Care Act (ACA), aka Healthcare Reform (HCR)

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Prepared Business Requirement Documents (BRDs) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, Use Cases, UML Diagrams for overall system.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Performed due diligence review on all pending re-underwriting of foreclosure loans to ensure compliance with regulatory requirements.
• Designed and developed Project document templates based on SDLC methodology.
• Interacted with users for verifying User Requirements, managing Change Control Process, and updating existing Documentation.
• Perform compliance assessment for pre purchase and post closing loans.
• Advises and guide the compliance underwriters on regulatory requirements/TRID.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional Requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes and participated in Stakeholder Management to communicate effectively with them.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, Technical Specifications and/or Product Knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the Project Manager and Technical Lead.
• Worked on broad range of technologies including business process tools such as MS Project, Primavera, MS Excel, MS Word, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the Business Requirements.
• Perform risk assessment of CFPB mortgage rules and regulations to ensure TCB correspondent is in compliance.
• Installed and configured SharePoint 2007 and 2010. Lead the architectural design, development, customization for the SharePoint portal application.
• Extensive experience in Business Process Modeling using Visual modeling tools.
• Proven track record in maximizing resource utilization and successfully delivering projects in Banking, Retail Merchandising and Financial domains using waterfall and agile SDLC methodologies.
• Installed and configured 3rd party tools such as the Lightning Conductor web part and SharePoint 2010 FBA Pack.
• Utilize ComplianceEsae application to test loans against regulations. Compliance analysis of closed and paid off loans. Ensured loans were in compliance with Truth In Lending Act and RESPA.
• Analyzed loans to ensure regulatory compliance requirements were adhered to of clear of compliance defects. Sample tested mortgage loans for regulatory requirements compliance.
• Knowledge with AML, Base II, Dodd - Frank/ Volker Rules and CCAR, Dodd-Frank Regulatory Reporting FRY-14A/Q Monthly, Quarterly, Annual, FACTA, FRY9-C, FFIEC 041, FFIEC 031 reports, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
• Knowledge of Base II, CCAR, DFAST, PPNR, ALLL, Credit Risk, Market Risk, operational risk, ACH, Liquidity Risk Modeling and Management, PD/LGD/EAD modeling, Quantitative Approaches including General Linear Regression, Time Series Analysis, Decision Tress, Classification and Cluster Analysis, and Principal Component Analysis.
• Development, implementation and maintenance of documentation standards for capital management broadly CCAR/DFAST specifically.
• Compilation, quality assurance and delivery of CCAR submission documentation.
• Management of forecast documentation delivery for CCAR/DFAST.
• Development and/or enhancement of next generation capabilities including CCAR and DFAST to a leading practice standard.
• Ensured appropriate controls were in place and risks were documented and that business process is in compliance with regulatory policies and procedures.
• Documented Federal Reserve CCAR stress test qualitative assessment for regulatory requirements and internal audits.
• Played Market Risk, Finance and CCAR SME role between Business Heads and sponsors from Risk & Finance.
• Evaluated the current systems/processes in place with regard to the generation and reporting of 9Q forecast in its current shape as part of the CCAR, DFAST, ICAAP and Risk Appetite remits to perform Gap Analysis.
• Responsible for overall status reporting to Sr. Business, Risk, Finance and Technology Leadership on state of the underlying CCAR projects.
• Engage with Finance, Risk and Capital planning to deliver CCAR/DFAST capital adequacy regulatory reporting and stress testing requirements twice each year.
• Face off with Regional Presidents and other business managers of the branch retail network. Assist in any financial related matters as needed.
• Strong background in CCAR Regulatory Reporting especially in FRY 9C, FRY 14M/Q/A, FFIEC 041, FFIEC 031 reports and the related schedules.
• Maintained a working knowledge of the Comprehensive Capital Analysis and Review "CCAR".
• Developed good practices for risk modeling procedures related to CCAR/DFAST.
• Developed and managed complex spreadsheets to aggregate firm-wide forecasts for the annual Dodd- Frank Act Stress Test (DFAST).