Brian Siqueira

30+ years in multiple areas of IT domain in data architecture, data migration, data modelling design and development in relational databases, business analysis and project management

Resource Solutions. Aug 2017-Dec 2018

IT Project Manager at Chief Data Office, BNP/Paribas, Hong Kong

• Worked on contract to deploy an IT regulatory solution in APAC for the capture, recording and monitoring of received guarantees procured against credit facilities extended to the bank’s corporate clients.
• Created and managed project work plans, issues, risks and key decisions
• Present status on IT stream to Regional and Global senior management and stakeholders.
• Assessed data quality, lead workshops with operations and business users for data mapping of remediated stock, and design process for system integration and liaise with IT team to develop solution for integration of remediated stock into deployed solution.
• Led BAU project stream by organizing workshops with Front office, Legal, Operations for process improvements and adjustments, controls and develop and implement operational guidelines.
• Coordinate compliance approvals and timelines for IT solution deployment in each APAC country.
• Develop and coordinate plan and roadmap for user acceptance testing, UAT testing.

Planaxis Canada/Alti France. Feb 2011-Mar 2017


Business Analyst Credit Risk & Compliance at BNP/Paribas ALM Treasury Paris & Hong Kong

• Worked from Hong Kong since 2012 in my previous role for Planaxis Canada for client BNP-Paribas, Paris as in April 2008-Feb 2010, focusing on functionality enhancements in the Counterparty Credit Risk and Compliance modules.
• Work directly with senior management to develop and integrate new counterparty compliance functions in the credit risk module.
• Managed all phases of compliance, counterparty risk, country risk development, including mapping, designing, configuring, implementation, testing and post-launch support.
• Maintain compliance database, including creating and modifying tables, monitoring traffic, and importing and synchronizing data.

Accenture Hong Kong. Aug 2010-Sep 2010 

Manager Technology Group 

• Drive data architecture and design solutions for client AXA Insurance in Hong Kong. 
• Primarily worked on a response to a RFP in requirements gathering, technical architecture and solution architecture for a data warehousing project for a client in the insurance industry.
• Technical discussions with potential solution vendors IBM and SAS to evaluate which solution best meet the requirements of the client.

Planaxis Canada/Alti France. Apr 2008-Feb 2010


DBA & Development at BNP/Paribas ALM Treasury Paris. France 


• Worked within a team managing a real-time risk-management application WARM (World-wide Asset Risk Management) that encapsulates all Treasury activities 1.5 Terabyte database running under Sybase Adaptive Server 12.5 and Sybase Replication Server 12.6 under HP/UX.
• Design (functional and technical), development such as optimizing stored procedures, triggers, queries,& database views 
• Technical and functional support for 450+ users across 50 treasuries around the world. 
• Undertook development work on calculations of credit risk, liquidity, gapping, and interest rate.  
• User and technical documentation, unit testing, regression testing, change management, capacity planning.
• Ιnvolved with planning, testing and migration to Sybase 15 and ETL for Sybase IQ.
• Migrated database components and mapping for real-time data feeds to Kondor 3.0 front office application based on Sybase 15 ASE and Sybase 15.6 Replication Server.
• Provided data models and dataflow mappings for integrating an internal referential system using a real-time solution based on MQ Series, Java and stored procedures. 

NSB Retail Systems Inc, Montreal, Canada  Jan 2001-Feb 2008


Data Modeler/Architect

The company's Connected Retailer suite of software and services enables retailers to manage supply chains, automate transaction processing, track orders and fulfillment, and control the flow of merchandise from purchase order to delivery and distribution.

• Team leader of core architecture development group responsible for building an enterprise logical and physical data model encapsulating all application data marts under Sybase, Oracle and MS SQL Server in a technology renewal effort under .NET.
• Developed data governance policies and help implement it across application teams.
• Developed best practices for data management.
• Evaluated, recommended, implemented data modeling tools and administered the projects’ shared meta-data repository.
• Managed resources from individual areas of the business to create an enterprise data model. 
• Participated in requirements gathering and understanding data requirements in key areas of the business such as merchandising, CRM, sales audit and warehouse management.
• Reversed-engineered the following application databases: Merchandising, CRM, warehouse management and created data models for the following subject areas: location, customer, employee, merchandise, inventory movement & transaction.
• Participated in benchmark activities at Microsoft Labs for measurement and tuning load speeds for populating a data warehouse.
• Defined enterprise data model standards and best practices and implemented online documentation of data models and standards on the intranet.


STS Systems, Montreal , Canada Nov 1991 – Dec 2000

Project manager (Nov 1998-Dec 2000)

• Managed a 5-man team to build e-Commerce development and integration of thin-client solutions to company’s CRM offering. 
• Successful integration to web sites running MS Commerce Server, Apache building middle tier components with SOAP. 
• On-time and on budget development of mass email & personalization solution for generating promotional campaign & tracking from company’s CRM product.

Database designer/architect (1992-1998)

• Principal data architect for CRM data mart solution in a client-server environment with Powerbuilder frontend and backend databases under either Oracle, Sybase or MS SQL Server under Unix Sun Solaris/AIX/ HP-UX servers or Windows NT environment.
• Technical resource for support, developers in my team, clients and sales related issues. 
• Involved through multiple releases of product life cycle, benchmarking, product direction and development.
• Data modeling, database design and architecture, Application design, troubleshooting Powerbuilder code, identifying and resolving database related performance problems, emergency DBA work (resolving corruption, etc.).
• Benchmarking application performance at Sun Microsystem, IBM, and Microsoft labs.


Groupe Synergie Développements Inc, Montreal, Canada Mar 1991-Nov 1991


Customer Support Analyst

• Provided telephone, on site support and training for an integrated manufacturing and financial accounting package, Myte Myke, on XENIX/UNIX and Novell platforms. 
• Clarified procedural guidelines, problem solving, undertook software customization, coordinated new installations, and organized training courses on the application and operating system. Clients were based in Quebec and Ontario in the manufacturing and distribution sectors.


Al Ghurair Enterprises, Dubai, United Arab Emirates Aug 1987- Sep 1990 


Systems Analyst

• Designed applications & provided software support for clients in trading, retailing, manufacturing and banking sectors. 
• Resource to sales for demos, estimate software customization efforts. Designed and developed a fully integrated accounting system that was customized and successfully marketed to other clients. As project leader, supervised two programmers in the development of a Documentary Letter of Credit System for a major regional bank. 
• Worked on smaller sub-systems such as a TelexBox interface, Testkey verification and data capture applications. Used primarily COBOL, Oracle Forms, and Pascal as development tools. Environment: Unisys BTOS & Unix


Al Yousuf Computer Systems. Dubai, United Arab Emirates Apr 1985 – Jul 1987 Programmer/Analyst

• Undertook development and customization of Order Entry/ Invoicing, Purchase Order and Fixed Assets modules within an integrated accounting package. Smaller applications implemented include payroll, timesheet accounting and clinic management software. 
• Provided customer training, software and hardware support and updated documentation of user manuals and system training guides. 
• Part-time instructor giving short-term evening courses in Lotus 123, dBase III, Pascal, Basic, COBOL and software design courses. Prepared course curriculum and wrote up course material. Course lengths varied between 20 and 60 hours. Environment: Windows-based systems

Macalester College, St. Paul, Minnesota. U.S.A. (1983)
B.A. Computer Science, Economics and Business with Core Concentration in Mathematics

Karachi Grammar School, Karachi, Pakistan.(1979) 
GCE A Level (University of Cambridge, UK).