Elisabeth Ido

• As an IBM CIC Career coach, management and coaching a team of 10 IBM colleagues who are evolving as BA Banking
• Organization and support for various IBM events:

- IBM Gen AI in Banking Event Coordination: Overview of the impact of the technology, as well as the implications of introducing generative AI into an organization

- Red Hat OpenShift Event: Containers demo based on Red Hat OpenShift. Architecture and infrastructure / Security considerations

• Participation and support in the creation of RFPs for IBM CIC

INVOICING: Nespresso Fixe Price & Flexible contracts

• Invoicing data preparation based on India team claiming
• Pro-forma approval before invoicing

FORECASTING: Support and Testing Team - Fixe Price and Time & Materiel team

• Data Structure preparation for forecasting (Cut-Off & Weekending)
• Verification of efforts invoiced for each Nespresso collaborator (India, Romania, Mexico)

Other tasks:

• SDM tool: Updating offering id in the Pricing file, Provide Pricing file in different currencies
• FIELDGLASS tool: Work Order Creation & Submission
• Follow-up: Claim codes, Bid &Proposal and BMS codes
• Workshops – Support & Agenda management for more than 300 attendees

As a member of the High Risk Transaction (HRT) in Compliance team, I was in charge of analyzing the requests from the bank's project stakeholders to reinforce the verification process for High-Risk Transactions

The process was mandatory for all client-related transactions that are classified as High Risk as per the HRT Checklist

Daily tasks:

• Work with an Agile approach- High level Business Requirement to be reviewed and approved
• Solve business needs with IT solution: Design and implement a solution that meet Business requirements
• User Stories writing: Short, simple description of the new HRT application functionalities users want
• Test case Management: UAT Testing with project team related to the screens developed - Current state "As-is" to future state "to-be"

As a Project Manager in the IT Finance Team:

• Managing the migration from V8 to V11 of the QUARTAL Financial Solutions - Managing scope, cost, project resources, communication with stakeholders

As a Technical Business Analyst, PL/SQL Developer in ODS team:

• ODS database analysis
• Technical Specifications writing for data flow implementation
• Work planning and organization for offshore team
• IT system knowledge transfer for offshore team
• Assisting offshore in the data loading development process
• Use Cases writing to test PL/SQL data loading process
• Writing business requirements into technical documentation

As a Technical Business Analyst & T-SQL Developer in Client Data Integration team:

• Development of views to reconcile data coming from several databases
• Producing daily reports to point out data discrepancies and data desynchronizations between different systems

As a Technical BA, I had to manage the creation of BI reports in collaboration with the business (digital marketing)

• Define and document the Business Requirements with stakeholders
• Digital data management Analysis, technical specification writing in collaboration with stakeholders, tasks estimation, star modeling, data flows loading in SQL language, development of front-end solutions, deployments monitoring, elaborating use case for unit testing, user training
• Transform Technical Specifications into BI solution
• BI Architecture and data modeling implementation
• Business Views and Reports implementation
• Define test plans to validate the Project Team and End Users requirements
• Train and provide assistance to local & abroad end users

As a BI developer, managing data report migration of the different operational systems (HR, student area, student statistics) from IMPROMPTU 7.4 to COGNOS 8/10 (web environment)

• Define objectives with stakeholders and make arbitrations
• BI architecture and technical specification writing
• Data mapping, new tables design and missing data loaded in the data warehouse - Collect and analyze business needs to plan, design and develop report solutions
• Implementation of the physical & business Views
• Data security implementation (packages, data, objects) and set up users grant access
• Unit testing in Excel files to check data and see if requirements have been met
• Training users on reports creation

• Business & Technical Analysis: Functional and technical analysis with Business team to determine the new data information (Customers portfolio information) to be loaded in the database
• Meeting with stakeholders to collect and analyze Business needs in order to select the data to be processed
• Business Requirement and Technical Specification writing
• Plan, Design and develop technical solutions
• Unit test / Data integration tests
• Design a new structure in the database: Procedures PL/SQL development to integrate the new data file coming from the accounting system

Technical and functional development of the CHUV data warehouse by crossing data coming from the hospital information systems to produce statistics, monitoring indicators used by various services:

• Meetings scheduling with stakeholders (doctors) of the various services to collect applications data
• PL/SQL procedures modification to add controls on the data loading
• Unit tests with TOAD V9.6 for data verification
• Views creation to fill Data warehouse cube measurements

Collaboration in the Financial Data warehouse migration from Oracle 9i to Oracle 11g / Linux:

• Managing performance and non-regression tests with TOAD on the PL/SQL procedures launched with the JOBs of the different processes used to fill the data warehouse in the new Linux environment

Within S.A.G.E SA team: Business Analysis, Development and Maintenance of various modules of PROSPERO, the Bank Financial Portfolio Management system (Back & Front Office), by intervening in procedures that manage the interfaces

• Meeting scheduling to collect and analyze business needs, to plan, design and develop solutions
• Functional and technical specification writing
• Improved the quality of the different modules of the system by correcting PL/SQL procedures that manage the interfaces

• Project 1: Bank Information Management flows: Business Analysis and Business Requirements writing, Architecture documentation, Technical Specifications writing for the Data Warehouse loading process, PL/SQL procedures development to integrate banking data flows into the data warehouse, Managing Unit tests for data validation
• Project 2: Money Laundering Fighting: Business Analysis in collaboration with stakeholders in order to put alerts in customers accounts, Business Requirements & Architecture documents writing, Technical Specifications writing, Developing process for recovery, handling, loading and storage customer bank details (accounts, transaction, etc.) coming from various business applications

Functional and Technical Analysis - Developing PL/SQL code for the banking management software:

• Issues fixing by collaboration with Singapore website stakeholders by changing PL/SQL procedures to update banking management software data transactions
• Development unit tests for data validation
• Business analysis of the Service Contract Loans Client Reporting: Development of new processes to automatically collect new customer information from a DB2 environment to an Oracle environment

Maintaining the Intranet Application that manages the portfolios statements of current accounts of equities, holding securities accounts, on behalf of BNP customers

Business Analysis and information system analysis to set up an automatic billing system for the 6 production services:

• Collaborate with stakeholders to understand, assess and quantify what is produced and at what price
• Business Requirements, Functional Specifications and High-Level Architecture writing
• Develop and improve the elements of the data collection process to be invoiced by implementing automatic extraction of the elements produced by the various departments

Designing and developing various intranet applications for the BPS (Bank of Programs and Services) users

• BPS stakeholders Interview to collect business needs
• Business requirements writing, functional specification writing, architecture document writing, technical specifications writing
• Design, develop and implement intranet applications with Oracle FORMS for managing, extracting subscribers information

• Developing and maintaining accounting software data capture with SQLWINDOWS

Company selling computers, consumables and spare parts for personal computers:

• Analysis and development of customer management software
• Creation, implementation and management of a five-person call center as part of a work-study contract
• Prospecting for small and medium-sized businesses with a view to creating a customer portfolio for the sale of computer hardware