Francis Thomas Email and Phone Number
Francis Thomas work email
- Valid
Francis Thomas personal email
- Valid
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.
-
Senior Business And Data AnalystBlue Cross Blue Shield Of MassachusettsQuincy, Ma, Us
-
Senior Data AnalystCity National Bank Jul 2021 - PresentLos Angeles, Ca, UsBusiness 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 -
Senior Business & Data AnalystBlue Cross Blue Shield Of Massachusetts May 2018 - Jun 2021Boston, Ma, Us• Lead Data Analyst for facilitating the migration of the legacy mainframe Utilization Management system to a more robust cloud-based system. Facilitate design and build of the new database and study the impact on the downstream applications. Help in building the new downstream reports from new database with minimum impact.• Analyze the loading of files for Members, Group and Capitation from existing source systems (RTMS) and comparing it with the new source system (NASCO-Members Edge).• Develop conceptual models of all attributes with the business description using MS Visio.• Create logical model based on the outcome of discussion between business and IT teams and then the physical data model.• Analyze the data models in RDBMS databases.• Map the output from the queries to the business system requirements and create technical specification documents.• Help in the process of Data Extraction, Data Cleansing, Transformation & Load using ETL tool Oracle Database Integrator (ODI).• Write queries in existing on-premises environment which supports SQL for the data analysis.• Write queries in upstream Hadoop platform using Hue environment in Impala and Hive and use the exported output from the queries for data analysis.• Document business processes and work flows and the relationship to current and future software solutions• Lead Analyst in ingesting files for Claims, Provider, Pharmacy from mainframe systems to Data Lake • Work with domain leads and technologists to identify & gather data relevant for analysis• Work alongside agile development teams to help improve completeness, accuracy and timeliness of datasets and improve processes• Provide stable and reliable data solutions.• Analyze the complex data set, working knowledge and expertise with Hive, Impala and Spark.• Work in Hadoop environment like submitting jobs, resolving failures.• Write complex queries using Hive and Impala to help transform the data to be fed to Hadoop Data Lake platform
-
Senior Business AnalystState Street Bank & Trust Co. Dec 2015 - May 2018Quincy, Il, UsBusiness Process Management (BPM): Automation of workflow using BPM and building dashboards for better efficiency and faster delivery. Cloud Reporting: Build automated or on-demand reports distributed to clients through Model Reporting Platform (MRP) – a centralized reporting platform to automate report generation, distribution and report execution On-Demand.• Understand the current workflow and the challenges being faced by the users implementing them.• Design new workflow, leveraging the BPM model and ratifying it with the end users.• Write the specification document for the new workflow under BPM, design the wireframe for the new screens of the dashboard, and get the sign-off from the business users.• Gather requirement for building new reports from Global Markets team in Middle Office USA, London, APAC areas and Dodd Frank reporting. • Develop SQL queries from different database to ensure the output is as per client specification.• Migrate the existing Crystal Reports which were decommissioned to Cloud Reporting and do data mapping for the migration.• Interact with the dev team to explain the requirement and get the development work on schedule.• Co-ordinate with the QA team, help in building test scenarios, resolve gaps, conduct the triage meeting and clarify their questions.• Track and monitor the project to ensure that they are delivered on time.• Interact with other stakeholders from upstream applications and conduct JAD sessions.• Receive feedback from end users and implement the enhancements suggested by them.• Prepare User Guide for all the different applications developed. -
Senior Business AnalystState Street Bank & Trust Co. Oct 2013 - Nov 2015Quincy, Il, UsEnterprise Security Framework: An initiative to retire the legacy security framework with improvised architecture and is intended to be the security architecture for all new State Street applications across the corporation. It will also provision to legacy applications and will be used to manage the provisioning or de-provisioning of user accounts to various platforms, business applications of State Street.• Receive request for new functionality and enhancement from different stakeholders and drafting the initial Request Form.• Perform an initial analysis of the request with business justification and its impact on the security framework.• Coordinating with business stakeholders to gather requirements for onboarding legacy applications. • Gap analysis between 'AS-IS' functionality of the legacy application and 'To-BE' functionality in eSF. Preparing business specification documents.• Mapping of data entitlements of existing applications to the new security platform and grouping them as per the entitlement architecture of the new platform.• Build SQL queries for analyzing data from existing application, pulling reports from new platform for reconciliation with the legacy application.• Arrange for the weekly/fortnightly Demand Management meeting and conduct it. Present the various requests to the Release, Application, Development and Testing teams for further analysis, sizing, prioritization and scheduling to a release.• Prepare the 3 Year Road Map giving broad timelines and functionalities to be implemented and periodically iterate it. Extensively used the Pivot table through Microsoft Excel to analyze the demand pipeline backlog and present it to the management to make strategic decisions for implementation.• Prepare the eSF Principles document and update it with subsequent releases.• Review the BSDs and FSDs prepared by the BAs for these requests.
-
Senior Business AnalystState Street Bank & Trust Co. May 2013 - Sep 2013Quincy, Il, UsGold Copy - A new initiative in State Street Corporation, to have a single hub for all transactions where feeds from different systems (accounting/custody/corporate action) are sent for identifying & resolving breaks and routing to all downstream applications.• Involved in the different use cases related to Corporate Action and the UI for the Gold Copy application. • Gathering the requirements, interacting with the business team to understand the requirements, preparing the FSDs and working with the development team. • Worked on UI designing for the application. Understand the change requirements requested from business team and conveying it to the development team through relevant documents. • Involved in Gap analysis between BSDs and FSDs.
-
Senior Business AnalystState Street Bank & Trust Co. Jan 2013 - Apr 2013Quincy, Il, UsCorporate Billing System - Build the new billing system for the newly acquired Intesa Bank clients of State Street Corporation.• Understanding the key requirements of the new application• Preparing the FSD and getting sign offs from the stake holders• Testing between SIT and UAT in the cloud environment• Identifying the issues and creating the tickets for resolution• Monitoring the performance and the issues opened
-
Senior Business AnalystState Street Bank & Trust Co. Jan 2011 - Dec 2012Quincy, Il, UsMigration of application support from client to Wipro • Was part of the pilot team to transition custody applications (support, maintenance and minor enhancements) from client to Wipro. • Transitioned various applications in Custody area like GCAS on Corporate Action, other mainframe applications like GIC, CAMS, AIR, CAIR, trade processing application GTM, reconciliation applications TLM and DRS • Understanding the business functionality of the applications.• Obtaining the process flow• Determining the risks involved• Preparing the documents such as SMTD and EPD and obtaining the signoff from the client• Conducting the knowledge transition with the offshore technical team and helping them understand the domain and functionality aspect of the application
-
Consulting Business AnalystBny Mellon Jan 2009 - Jun 2012New York, Ny, UsDocumenting the bank’s processes of various departments after the merger of the legacy banks of BoNY and Mellon Bank, incorporating the best practices from each of the legacy processes.Directly coordinated with operation staff of various departments of the bank, to understand their work flow, document them in steps as well as process flow diagram through MS-Visio, and suggest improvements. These documents were uploaded to the SharePoint as a knowledge document for the employees.• Preparing SOPs, FMEAS, Process Maps after understanding the applications and gathering screenshots from SMEs.• Obtaining signoffs from the Process Owners after modifications• Ensuring the documents are uploaded in the required Knowledge Source format of the bank• Tracking the project progress and ensuring it is completed on time• Coordinating with the offshore/onshore team for the smooth functioning of the progress and obtaining quality documents
Frequently Asked Questions about Francis Thomas
What company does Francis Thomas work for?
Francis Thomas works for Blue Cross Blue Shield Of Massachusetts
What is Francis Thomas's role at the current company?
Francis Thomas's current role is Senior Business and Data Analyst.
What is Francis Thomas's email address?
Francis Thomas's email address is fd****@****ail.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial