Francis Thomas

About Francis Thomas

A dynamic senior consultant with experience in various fields of domain in Banking, Securities and Capital Market and Insurance as Senior System Business Analyst and Senior Data Analyst with experience in Data transformation & Reporting, Requirement Gathering, Operations Management, Process Transitioning, Customer Relationship Management, Project Management, Demand and Release Management, Computer Education. Experience in automation of workflow using Business Process Modelling (BPM) platform.• Proven in areas of requirement gathering, documentation, process transitioning, project management and demand & release management. Experience encompasses new product conceptualization, translation of product strategy to tactical deliverables, retiring legacy applications and transitioning to an enhanced new applications, execution of deliverables throughout SDLC.• Experience in Business Intelligence Reporting, data analysis, and data transformation using SQL and other ETL tools like SAP-BODS, ODI, Power Center, IICS• Expertise in health insurance areas like utilization management, membership, claims processing, etc.• Extensive knowledge of securities and capital market domain and worked in various areas of Corporate Action, Custody Accounting, Collateral Management, Reconciliation, entitlement provisioning, client billing, etc. with major custodian banks like State Street Corporation and BNYM.• Experience in massive distributed systems like Spark, Hadoop, etc. in Agile environment and migrating legacy databases like mainframe, Oracle, etc to Data Lake.• Strong proven expertise of industry-standard methodologies like Software Development Life Cycle (SDLC), Agile, Iterative Software Development Life Cycle Processes • Experience writing Use cases and producing Use Case Model, Analysis Model, Behaviour diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology & Business process flow diagrams using MS Visio and ARIS.• Experience in automation of workflow using Business Process Modelling (BPM) platform.• Proficient in statistical analysis, Data modeling, and Dashboard/ Scorecard reports • Knowledge of SQL/PLSQL, C++ and database platforms like Oracle, MS-Access, MS SQL Server• Facilitated Joint Requirement Planning (JRP) sessions with Business User Groups, conducted Joint Application Development (JAD) sessions with IT Groups and resolved conflicts within the team using effective Conflict Management Techniques.• Excellent and effective communication, interpersonal, problem solving and analytical skills.

Experience

1. Senior Data Analyst

   City National Bank

   Jul 2021 — Present · Los Angeles, CA, US

   Business Intelligence Reporting: Support their bank in their Business Intelligence Reporting, gather requirements, analyze the existing data and provide solutions to process the existing data to get the report in the specified format and output- Provide and suggest the processing logic to get the output in the desired format - Prepare the logical model of the data tables which will be used for reporting - Track all the requirements using the Kanban board in JIRA and the daily standup call to ensure all the cards are completed and done in the desired phase/velocity- Prepare the data mapping document for the developers to deliver the report - Analyze issues/gaps reported by the business users in the output and research in the ETL tools like SAP-BODS, Informatica, IICS- Write SQL queries in Oracle SQL Developer and provide it to developers