Description
SUMMARY: * 7+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design. * Extensive experiences in Investment Banking, Online Banking and Financial Services projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management. * Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets Groups, Parameters etc., in Tableau * 4 years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as an Analyst. * In depth knowledge Rational Unified Process (RUP) Waterfall methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D). * Competent in Creating Unified Modelling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams. * Extensive experience in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR and knowledge of standard SDLC methodologies, including RUP, MSF, Prototype and Spiral. * Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modelling and Design. * Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse * Proficient in developing and debugging to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting * Extensive experience in Business Objects which includes building and maintaining Universes, retrieving data using Universes and Freehand SQL methods and creating complex Ad hoc Reports using the Desktop Intelligence and Web Intelligence Tools. * Extensive experience in Requirements Gathering, Surveys/Questionnaire Development, Business Requirement Documents (BRD), Functional Requirement Specifications/Documents (FRS/FRD). * Understanding of US Risk & Compliance Regulations - CCAR, Dodd-Frank (DFA), Basel, FACTA etc. Sound understanding of Reg Sho, Ticket Marking, Wash Sales and Suspicious Trade Activity. * Strong knowledge with Basel III, CCAR, FR-Y 9C, FR-Y 14Q, PPNR, FR-Y 11, FR-Y 9LP, FFIEC 031, FFIEC 041, FFIEC D09, Dodd-Frank, KYC, AML, FINRA's rules and regulations * Expertise in SQL Performance Tuning, Good understanding of Explain Plan, Zone Maps, confidence levels, Database Skew and Collect Statistics. * Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment. * Experience in writing PL/SQL stored procedures, triggers and functions. Good experience in Data Cleansing, Data profiling and Data Analysis * Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
Accomplishments
Highlights:
Job Skills
Keywords
