SUMMARY:

• Senior technical, functional, data business analyst, product owner with proven performance in implementing Information Technology, Business Transformation and Corporate / Departmental initiatives, seeking a challenging consulting assignment, where it will be possible to leverage experience in order to make a significant individual contribution.
• Proven ability to analyze, manage and prepare business and functional specifications, UAT test plans, coordinate multiply business and technology projects
• Gather and prepare comprehensive requirements for utilization by global platforms.
• Show consistent success in complicated areas of financial regulatory analysis.
• Possess SME knowledge of specific financial and securities products, trade and post - trade flow and IT implementations
• Well versed in complicated areas of IT and Business interaction, including executive level reporting

TECHNICAL SKILLS:

Operating Systems: UNIX/LINUX, WINDOWS XP, IBM MVS / Z/OBasel / CCAR DW Moody s Analytics RiskAuthority RWA Calculators / Risk Foundation, Credit/Market Risk/Basel II Capital Charges Calculator; Axiom SL (Controller View 7.0); ER Star Schema, ETL

Databases: Sybase 15.0, DB2-9, SQL Server 2003/2008, ORACLE g10/g11, IDMS 14.0, PL/SQL

Mainframe: COBOL II/MVS/Enterprise, CICS, MVS/JCL, VSAM, TSO/ISPF, FILE-AID, IDCAMS

Project Methodology: SDLC (waterfall, agile), CMMi, PMI PMBOK, SCRUM

Data Modeling: Embarcadero / DBArtizan 9.2, SQL Server Management Studio, Oracle SQL Developer

QA / UAT: HP Quality Center

Productivity Tools: MS Office 2013 Suite (Visio, Power Point, MS Project, Excel), Jira, Collaborate, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, NYC NY

Senior Business Data Analyst

Responsibilities:

• Enterprise Technology Solutions, Consumer Bank Retail Risk Analytics
• Lead and participates in CitiRisk (Enterprise Retail Risk Platform) subject areas (CCAR Y 14A, 14Q, 14M, Retail Basel) design and development.
• As a senior BA/Product Owner provides link between high level Risk leadership (regional and country risk leads) and CCAR development teams.
• Managed gathering and implementation of CCAR requirements globally, by regions (NAM, LATAM, EMEA and PAC) and countries, including target template feasibility and proof, gap analysis, data acquisitions / mapping, FR Y 14A, 14Q Data Quality, Business Rules, Submission and reporting. Maintains Roadmap and Epics (BRD) related to CCAR development and enhancements.
• Investigated and documented data logical lineage, mapping and modelling. Established validity of data definitions (Entity, Attributes), Data Quality controls and performed gap assessments. Was responsible for gathering and logging the CCAR / Basel flow of key data elements (KDEs) from Line of Business through the Regional Center and up to CitiRisk data acquisitions, profiling, aggregation and FED filing. Coordinated LOB governance approval for lineage, data quality and controls, including the review and approval of Key Procedural Controls (KPCs).
• Worked with retail portfolios / products (country specific mortgages, QRE, auto loans, student loans, consumers and small businesses).

Senior Business / Data Analyst

Responsibilities:

• Led SWAT reporting remediation effort. SWAT Reporting is a special set of Actimize models and in-house developed reports intended for use by SocGen Compliance Surveillance Group It includes more than 100 models and reports developed and written during the last ten years. These reports act as a traffic light signals showing abnormal behavior, if any. They are generated from various data sources and cover all types of products: Equities, Fixed Income, Loans and Derivatives (Border, XOne, Summit, etc.).
• Functionally these reports and models allow users successfully monitor trading behavior, market abuse, customer and employee account adherence to SocGen rules and procedures as well as legal compliance requirements (AML, OFAC/BSA, OAT, TAG and others).
• Wrote new BRD/FRD/SRS for each individual report as well as Conceptual System Diagram and Flow Charts. Data Providers were identified and categorized.
• Full list of incoming feeds, delivery windows and receiving servers were documented.
• The current state of SWAT Compliance Reporting, its preparedness for daily use and for future audits is upgraded and drastically improved.
• Was involved in New Edge, Inc. integration in regards to Trade Surveillance and AML workflow / reporting.

Senior Business / Data Analyst

Responsibilities:

• Was engaged in interpretation, evaluation and preparation of technical documentation of CCAR, FR Y 14A Schedule A Summary reporting: Schedule A.1.c.1 General RWA, Schedule A.1.c.2 Standardized RWA, Schedule A.1.c.3 Advanced RWA, Schedule A.5, Counterparty Credit Risk.
• Co-ordinated the acquisition methods and analysis of the data to identify business issues. Analyzed incoming data extracts to be used in CCAR data transformation and consecutive product classification.
• Engaged each data provider to establish and present the collection of data attributes.
• Looked into and documented data aggregation, quality and lineage, associated with FR Y-14A reporting.
• Have general knowledge of regulatory components of CCAR submission (regulatory capital instruments and transactions form, scenarios form, stress testing).
• Participated in Enterprise and Wholesale Basel DW integration, including feasibility proof, gap analysis, data mapping
• Prepared Development Documents: BRD, FRD, SRD.
• Validated and performed element mapping, investigated and documented defects raised in implementation of Genesis, enterprise-wide and Optima Wholesale Basel data warehouses.
• Prepared development documents: data maps, attributes dictionaries, data types, flow charts for both Banking and Trade books assets.
• Worked with different wholesale exposures / assets categories: Trade Products, Loans, Securities, Derivatives, Securitization.
• Constructed Oracle queries in order to clarify population, granularity and relationships of existing Optima elements in comparison to Genesis subscription dictionary.
• Interpreted and documented data acquisition, classification, enrichment, adjustments processes and data flows, inbound / outbound feeds to ACE (analytical calculation engine, Credit and Market Risk) as well as inbound feeds from source systems / product processors.
• Documented reconciliation results between source data feeds and data received by Optima from Genesis.
• Participated and runs daily status meetings, ensuring documentation current version is maintained & distributed, action logs are tracked and updated.
• Prepared software enhancements artifacts to improve Optima load and processing performance by redesigning Optima internal tables.
• The project included dropping unnecessary or duplicate elements, changing the data flow and processing logic in all integral parts of Optima data warehouse.

Senior Data Analyst

Responsibilities:

• Participated in Wholesale and OTC Derivatives regulatory capital reporting initiatives, RWA calculator implementations, provides data definition, sourcing and profiling.
• Gathered and analyzes business and data requirements for product classification; capital calculations, data usage across interfaces to trade capture, post execution, post trade analytics, books and records, settlement and risk systems as an upstream source for risk capital calculation and regulatory disclosures.
• Worked with regulatory controllers, Analyzed and mapped business data definitions to logical data attributes.
• Identified gaps in availability, quality and population.
• Worked with system owners, program governance and data stewards to provision data and address existing gaps. Prepared data specifications and identifies necessary criteria for selecting population, desired granularity and uniqueness of specific data feeds. Defined specifications for data feed integration.
• Established level of anticipated data quality of risk measures, reference and transaction data supplied by various data providers.
• Defined and refined data feeds specifications and mapped them to Axiom Dynamic Data Warehouse. Prepared specifications for Data Sources and Data Models (hierarchies and streams).
• Led and performed UAT testing.
• Worked with controllers to identify UAT testing strategy.
• Created test cases, test plans and scenarios.
• Reconciled regulatory capital calculations results against GL balances, automated and manual solutions.
• Worked with financial and regulatory controllers in defining tactical (manual) and strategic (automated) solutions, business and functional requirements and implementation by technical teams for the following projects:
• Basel 2.5 Final Rule. FED and FSA reporting of Trading Book Securitization Specific Risk Standardized Add-on implementation of Final Rule requirement in regards to Market Risk SFA and SSFA approaches. Interprets calculation functionality and data source BRD as well as Data Specifications Document. Defines and selects different populations for specific formulae.
• Basel 2 FFIEC 101 Fails, Frees, and Long Settling Trades capital charges. A comprehensive population of open fails, frees and long settlement pending trades allows Regulatory controllers to improve the capital calculation. Modifies existing BRD, identifies correct data sources, and develops data feeds technical specifications.

Senior Business Systems Analyst

Responsibilities:

• As a Senior BSA, participated in full life cycle design, development and implementation of the BASEL II Framework by Confidential .
• Basel II Implementation of Moody Analytics Financial Data Mart / RWA Calculator (former Fermat, current RiskAuthority / RiskFoundation).
• Utilized knowledge of Confidential major business functions, systems and applications, performs business / data analysis and requirement gathering.
• Used Commercial, Retail, Traded Products, Securitization source to target data mapping to discover and verify data source and data lineage up to the DW tables and the resulting FFIEC reporting templates.
• Compiled data quality checks and business data constraints document.
• Learned and analyzed Basel II data governance and procedures.
• Participated in discovery process of RWA Calculator functionality and regulatory reporting, RWA calculated result exposures vs. Regulatory GL balances.
• Facilitated functional configuration workshops and data mapping sessions.
• Participated in defining setup strategy of Moody’s RiskAuthority tool: specifically in design / definition of Confidential hierarchy and structure, in mapping and netting of Intercompany exposures by inclusion of Confidential businesses into calculation perimeter, Bank Book and Trading Book portfolios / products mapping to Moody asset categories (LoanDepo, Entity, Facility, Dealbooks tables, etc.), defining and scaling Calculator internal functionality and result tables in relation to the SOR data providers
• Participated in preliminary discussions about Operational Risk implementation.

Senior Business Systems Technical Analyst / PM

Responsibilities:

• Subject of integration were separate units of Wachovia and Confidential Wholesale Trade Finance businesses dispersed across numerous geographical locations. The existing systems were integrated into surviving Web based front-end (TradeXchange) and SOA back-end (TradeWorks) applications. The work load included business requirement solicitation, impact analysis, gap analysis, functional system design, test plans, test cases, defect tracking, etc.
• Implemented numerous data gathering techniques (one-on-one, large group facilitated sessions, documentation discoveries).
• Managed multiple tasks and deliverables, data mapping enrichment and validation.
• Identified potential scope changes.
• Provided requirement analysis for consequent translation into ETL workflows.
• Provided mapping Off-Balance Sheet exposures (Documentary Credit, Standby Letters of Credit, and Foreign Guaranties) to BASEL II data warehouse, interface requirement and feeds structure.
• Documented wholesale business data elements hierarchy, data dictionary, mapping.
• Collected and uploaded updated project documentation as needed onto a team SharePoint site.
• Facilitated coordination of all team sessions, requirements reviews, design brainstorming, deliverable sign-offs, etc. Followed-up on all issues requiring resolution and escalates when necessary.
• Participated in End to End QA testing efforts (UAT, Performance Load, and Regression), utilizing HP Quality Center Defect Tracking System.
• Co-ordinated and led regular and Triage UAT calls Establish and manage the UAT run book.
• Tracked testing and raised defects against expected results in Quality Center. Provide progress update.
• Together with technology partners supervised deployment ensuring high quality and minimal defects.
• Monitored client expectations through client involvement and communication throughout the life cycle of the project. Ensured that contributors were motivated to complete assigned tasks within the parameters of the project plan.

Senior Business Analyst / Technical PM

Responsibilities:

• Utilizing knowledge and understanding of asset classes, products and instruments as well as OTC derivatives (unfunded - CDS, TRS, funded - CLN, CDO, exotic options; IRS), fixed income instruments (bonds, vanilla and with embedded options, caps, floors), Traditional and Synthetic Securitization (MBS, CMBS, IO-MBS, ABS, ABCP), credit mitigation (collateral, guarantees), analyzed proposed data flows and interfaces from SOR Data Marts to Basel II Data Warehouse.
• Discover source data stores (RDBMS, Hierarchical Databases and VSAM files) and their technical metadata (COBOL copybooks, database schemas, dictionaries).
• Participated in discovery and development of high level design and architecture.
• Provided profiling and identification of business metadata, validation process flows used in selection and integration of close data fields.
• Participated in analysis of data structure being promoted into Basel II DW staging area for consecutive feed to Basel II Risk Engine.
• Created data maps for wholesale and retail data elements and BASEL II data quality checks.
• Demonstrated solid understanding of OTC derivatives measuring and calculating of PD, which derives from assets current market value, volatility and distance-of-default ratio (DD), scaling of DD to PD
• Lead business systems implementation adhering to iterative principals, Agile (Scrum) lightweight project development method style.
• Supervised and participated in defining of product scope, functional specifications, system prototyping, construction and deployment.
• Interviewed Clients stakeholders, business owners, end-users and developed business/system use cases.
• Utilizing SDLC and CMMi project methodology archived greater synergy between the stockholders.

Senior Business Systems Analyst, Technical PM, Mainframe Analyst

Responsibilities:

• Managed and maintained the CitiTrade - Automated Trade Finance suite of applications that first, were running on IBM Mainframe under IDMS/CICS and IDMS/VSAM batch and then upgraded to become an integral part of Citibank online banking portal CitiDirect. During eleven years of service managed and provided business analysis, technical support and application level maintenance to the Mission Critical applications in Cash and Trade Group of Global Finance North America division of Citibank.
• As a senior business analyst / project manager lead numerous projects and enhancement initiatives, providing business analytical services for Trade Finance units in New York, Tampa, LA, and HK, all related to financial instruments (standby, import, export commercial letters of credit, bankers acceptances, documentary collections, OFAC and FinCen compliance).
• Successfully controlled the technical aspects of project progress, interacted with project stakeholders and coordinated local and offshore development teams.
• Through interviews, workshops and existing systems documentation or procedures solicited client requirements. Coordinated and documented meetings and workshops.
• Performed business requirements gathering and evaluation.
• Utilizing standard analysis techniques, delivered cross-system integration solutions.
• Provided project status reporting, Conducted weekly and monthly project progress reviews.
• Technologies employed to support Trade Group business activities were Cititrade and a series of application interfaces to the DDA, Payment, General Ledgers, Risk Management systems and SWIFT MT-700 messaging, Correspondent bank advising.
• All development processes adhered to CMMI/PMBOK and SDLC standards and best practices.
• Was responsible for scheduling, timely progression, business analysis, testing and deployment of all enhancements to the Trade Finance systems, as well as coordination with related IT groups and User community.
• Conducted and was responsible for pre and post implementation reviews, ensuring all technical solutions have met business requirements.
• Lead and participated in planning, design and successful implementation of the following projects:
• Merger of European American Bank Trade Finance and Services with Citibank applications. Participated in gathering requirements for implementation of EAB and Confidential legacy data integration.
• Functional and technical analysis related to application integration of Trade Finance AML processing, OFAC queries and regulatory compliance.
• Application Integration project to in corporate Citibank Private Bank Letter of Credit Business Unit into Citibank, Global Finance division processing.
• External credit enhancement to structured securities. Financial Standby Letter of Credit processing as an evaluated application of non-funded credit derivatives and LC hedging.
• Worked with the Credit Risk Business to understand and refine aggregation and hierarchy specifications to be incorporated into interface processes.
• BAU support to User community in all related to LC processing, Amendments, GL adjustments, Customer Account profiles, COA, Proof and Expense code tables.
• Managed Y2K technical efforts in remediation and stabilization of Trade Finance and its interface related financial applications. Supervised offshore team project progression: scheduling, tasks dependencies, targeted deliverables and milestones. Coordinated user acceptance testing. Successfully re-deployed new code and interfaces.

Senior Programmer Analyst

Responsibilities:

• In CICS/DB2/IDMS and Batch IDMS/VSAM environment was responsible for maintenance, support, and development of Credit Score
• Functionality for Business Credit Rating Application, which included processing, modeling and development of workflows and data flows.
• Client requested ratings of business establishments in posted inquiry.
• Performed business and technical analysis for new additions and enhancements.
• Performed analysis, coding and SIT testing of UCC Filling Statement and UCC Fabrication subsystems that included numerous programs written in CICS/COBOL II for online and IDMS/COBOL II batch processing.
• Coded JCL Control Cards, Supported VSAM Files and IDMS Database, worked with IBM utilities, IDCAMS, Sincsort and FSort, TSO, Intertest and other Mainframe related tools.
• Provided system support and maintenance.