• Mandip Poonia

    HEAD OF DATA
    DATABASE STRATEGY & GOVERNANCE
    DATABASE MIGRATION
    DATABASE SECURITY
    DATABASE MANAGED SERVICES

    AZURE CLOUD CONSULTANCY
    AZURE CLOUD MANAGED SERVICES
    CLOUD STRATEGY CONSULTANCY
    CLOUD MIGRATION & MODERNIZATION

    Connect on LinkedIn

  • Mandip Poonia

    HEAD OF DATA
    DATABASE STRATEGY & GOVERNANCE
    DATABASE MIGRATION
    DATABASE SECURITY
    DATABASE MANAGED SERVICES

    AZURE CLOUD CONSULTANCY
    AZURE CLOUD MANAGED SERVICES
    CLOUD STRATEGY CONSULTANCY
    CLOUD MIGRATION & MODERNIZATION

    Connect on LinkedIn

About me

An accomplished SQL Server Consultant with extensive experience within financial services & banking arena including front office environments. Team leading & people management experience leading data teams across multiple geographies globally.

Project experience on small, medium & large projects. Delivers, develops, designs & supports robust quality global enterprise solutions to demanding users. Finds ways to drive business value through data and information, whilst providing strategic guidance to customers on how to effectively realise and exploit the value of their technology investments.

Tactful, patient, courteous & a good listener who can deal with business & technical users at all levels including stakeholder management. Has a consultative approach with can do attitude. Strong self-organization, time management & prioritization skills.

Data Management
Agile Methodologies
Product Management
Management
Analytical Skills
Connect on LinkedIn

Recommendations

Mandip is one of the most delightful people I had the pleasure of working for in my career. He has a unique ability to keep our team organized and lift our spirits in challenging situations.

He has in-depth knowledge in technologies we worked together like TSQL, PowerShell development and complex development in SQL. Furthermore, he provided constant recommendations based on his vast expertise in some tough situations in various technical issues.

Mandip was hired to review existing functional and technical specifications to further automate the in-house built IFRS13 disclosure application, and to support the transition of the application from the business to IT. Within weeks Mandip understood the IFRS13 business context and associated regulatory requirements in detail and was in a position to not only review existing specifications but also to re-write most of them. Mandip’s comprehensive business and IT experience coupled with excellent communication skills ensured that the application was transitioned to IT within the given timeframe.

It has been a pleasure to work with Mandip and I would work with him on other projects any time the opportunity arose.

Mandip in a highly knowledgable DBA with vast experience. He was one of the goto people for any database related issues. His understanding of the setup used within the cash equities space was second to none. He always investigated problems or questions and provided answers and solutions to a high standard.

Mandip worked hard on improving the efficiency and performance of the databases being used and he was able to call on his experience to make significant improvements in this area. I have no hesitation recommending Mandip to any company who requires a highly skilled and experienced DBA.

I had the pleasure of working with Mandip Poonia as my manager for 18 months. He is the global team lead for the Agency Trading Core Data team. During that time, I have seen his leadership abilities to lead our team to achieve goals in a highly pressured and challenging environment.
Mandip is an excellent communicator with strong interpersonal skills that enables a strong relationship with his team and stakeholders. Mandip is very technical who possess good skills in the cloud technology (Azure) and the SQL Servers arena. His hands on approach to resolve complex issues and willingness to help is an asset and brings out the best of the team. Mandip is a good listener and his willingness to always help, motivated me to deliver project targets on time and to a high standard.

I worked with Mandip on several critical projects that need to be delivered in a very short time frame. He has helped and utilized his SQL server management / development skill help to create a robust application. I will definitely would like to work with him again and highly recommend him.

Mandip is a skilled DBA. He has an expert level of SQL Server knowledge beyond the core database engine. At the London Metal Exchange, where I worked with Mandip, we had a good working relationship with interesting technical conversations on operational/project work. He possesses an ability to take on board other viewpoints in addition to being able to explain himself both clearly and professionally. He went above and beyond in his support of the production database systems in spite of the inherited problems in the environment and challenging working practices. He is open minded, not averse to change, and delivery focussed. I would not hesitate to recommend Mandip.

Mandip was one of the experts in Trading Systems (MOMS et al) at UBS. He was very process oriented as well ready to extend in helping hand to the team fellows. Working along Mandip made us know a lot about our systems and was a pleasant experience.
Beyond professional relations he was a kind hearted individual too, I wish him all the best for his career ! Cheers Mandip.

Great to work with. Professional, personable and highly technical. There aren’t that many great DBAs out there but Mandip is one of them.

Mandip is a talented production DBA with deep technical expertise and a wealth of experience of how to get things done in the best way. Being a production DBA is a very demanding task; Mandip brings that competence and attitude that are necessary to make it work. Mandip likes to think about ways to improve operations with a smart implementation of technology. I would recommend Mandip to anyone who needs a talented DBA to manage their mission critical SQL databases and instances. Mandip could also bring a level of maturity to raise the performance of a team as well.

I have known Mandip for several years and always seen him as professional, business focussed and a great communicator. Technically, Mandip has shown significant capability and competency in understanding requirements and delivering solutions. He is a motivated team player, plans well and where necessary has worked extended hours in order to address business need or emergency situations.

experience

  • Apr 2021 - Present

     

    UBS

    Director – Product Owner, Product Manager Manager, Chapter Lead, Cloud Champion for Agency Trading

    London, England, United Kingdom · Hybrid

    Managed a team of application aligned data engineers globally to design develop, create and maintain the Cash Equities database platform. The platform includes a suite of mission critical applications spanning the full spectrum of electronic trading activity from static and reference data services through pre-trade, execution, reporting, and post trade analysis. Responsible for strategy, design & modernising the data platform and future roadmap. Successfully and swiftly employed resources to ensure business continuity during times of high attrition.

    As Cloud Champion I drove the acceleration, adoption & migration of apps to the cloud for Agency Trading. Planned and retired on prem database infrastructure globally to cloud hosted environment. Helped crew leads understand benefits, challenges & implications of adopting cloud & helping teams move to the cloud. Successfully prepared Cloud Technical Design Authority and Cloud Design & Deployment reviews for application teams. Incorporated Cloud economics cost reduction strategies, benefits, estimations, optimisations and resizing. Offered technical guidance on cloud and assisted applications with cloud on boarding. Building relationships and collaborations across the architecture community. Software Component Manager with full Software Development Lifestyle (SDLC).Managed a team of application aligned data engineers globally to design develop, create and maintain the Cash Equities database platform. The platform includes a suite of mission critical applications spanning the full spectrum of electronic trading activity from static and reference data services through pre-trade, execution, reporting, and post trade analysis. Responsible for strategy, design & modernising the data platform and future roadmap. Successfully and swiftly employed resources to ensure business continuity during times of high attrition. As Cloud Champion I drove the acceleration, adoption & migration of apps to the cloud for Agency Trading. Planned and retired on prem database infrastructure globally to cloud hosted environment. Helped crew leads understand benefits, challenges & implications of adopting cloud & helping teams move to the cloud. Successfully prepared Cloud Technical Design Authority and Cloud Design & Deployment reviews for application teams. Incorporated Cloud economics cost reduction strategies, benefits, estimations, optimisations and resizing. Offered technical guidance on cloud and assisted applications with cloud on boarding. Building relationships and collaborations across the architecture community. Software Component Manager with full Software Development Lifestyle (SDLC).

    Skills: Agile Methodologies · Management · Data Management · Microsoft SQL Server · Microsoft Azure

  • July 2017 - May 2021

     

    UBS

    Contract SQL Server Engineer

    London, England, United Kingdom

    Took full ownership & lead in unanticipated & ad-hoc situations dealing with issues swiftly & responsibly to minimise business disruption & data loss. Responsible for data related implementation tasks. Inc provision of data storage, ingestion, streaming , batch scheduling & Extraction , Load & Transformation. Consolidated data from structured & unstructured disparate data sets. Successfully migrated SQL Server legacy trading platform estate to high availability multi-site always on clusters during a time of high attrition. Working with the development & test teams with query performance tuning and optimisation of the solution to meet client’s requirements. Developing procedures in the PowerShell for the SQL Servers & databases remediation to meet regulatory requirements. Migration of the SQL Servers infra from Legacy Wide IP to new Citrix NetScaler Load balancer platform. Hybrid pod projects DBA for LMF. Domain experience in client and referential data. Manged EOL migrations of SQL Server. Good understanding of data through exploration, experience with processes related to data retention, validation, visualization, preparation, matching and enhancement.

    Skills: Agile Methodologies · Data Analysis · Data Management · Microsoft SQL Server · Microsoft Azure

  • March 2017 - August 2017

     

    Hewlett Packard Enterprise

    Technical Specialist Always On Multi Site Configuration

    Reading, England, United Kingdom

  • Oct 2016 - Mar 2017

     

    Lloyd’s

    Contract Senior SQL Server DBA

    London, United Kingdom

    Skills: Data Management · Microsoft SQL Server · Database Administration · Powershell · Database Security

  • Jul 2015 - Oct 2016

     

    Deutsche Bank

    Contract SQL Server Developer / Architect

    London, United Kingdom

    • Several RAD projects for Cross Asset & Product Control including Intelligent Month end suite (IMRP,IFSI,IMAFA).
    • PowerShell use in ETL from various sources. Define requirements, technical design, code & test.
    • Modification, enhancement & handover of IFRS 12/13 SQL Production systems.
    • Defined database architecture & System analysis for IFRS 13. SQL Server Full Stack Architecture, ETL deign & development.
    • Develop Strategies for data acquisitions from heterogeneous data sources & enterprise level database implementations
    • Defined enterprise-level standards (coding, architectural, migration), platform & tool selection. System enhancements to SQL Database & C# win forms.
    • SSIS & SSRS for ETL data integration flows & reporting. Data optimization with indexes. Stored procedures & functions.
    • Design & build of stored procedures/tables/views/functions. Design & build of SSIS Packages & SSRS reports. QlickView Exposure.
    • Write & understand C# code for maintaining win forms front end & DAO. Visual Studio, SVN subversion, Oracle SQL Developer
    • Understanding current business process flow & translation to actual designs. Worked with staff from global locations.
    • Designed, built, & maintained efficient, reusable, & reliable code as part of application enhancements. Created technical documentation for apps & databases.
    • Understand business process & data flow. Defined technical functional specs & translate business requirements to actual design.
    • Use of SQL 2012 to maintain & run production process. Troubleshooting any issues that arise.
    • Design & implement deployment strategies required for the tool. Advanced Excel including VBA programming & automation.
    • Ensured data design reflected appropriate business rules & facilitated data integration, conformity & integrity.Designed data structures for flexibility to support future business needs & enhancements. White-boarding sessions, workshops, design sessions & project meetings as required.

    Skills: Data Analysis · Microsoft SQL Server · T-SQL · Data Architecture · Database Design

  • Apr 2014 - Jul 2015

     

    London Metal Exchange

    Contract Senior SQL Server DBA / Consultant

    London, United Kingdom

    Worked on a number of precious metals initiatives including:
    • LMEbullion (supports the daily auctions for Platinum and Palladium in London)
    • LME CLEAR (Clearing House)
    • LME WIRE (regulatory trade reporting for all LME & over-the-counter (OTC) trading & Exchange-traded derivatives (ETD)
    • EDW (Enterprise Data Warehouse)

    •  Primary Senior SQL Server DBA Production Support & Projects.
    • All SQL Server Versions including 2014
    • Implementing and Maintaining Log Shipping | Database| Clustering | Mirroring | Always On HADR
    • Install, manage & troubleshoot multi node multisite SQL Server clusters
    • SQL Server Virtualization & Consolidation
    • SQL Server Setup, Installation, Version Upgrade & Architect Setup
    • SQL Server Hardening & Best Practice Implementation
    • Capacity Planning, Load Balancing & Scaling out SQL Server
    • Design and Implement Database Backup Restore & Disaster Recovery Strategy
    • Database Archiving / Partitioning (Horizontal / Vertical)
    • Database Performance Tuning, and Disaster Recovery
    • Setting up Base lining and Capacity Planning
    • SQL Server Hardware sizing and bottleneck tuning
    • Auditing SQL Server Security
    • Data Transfer / Transformation
    • Plan, Design and Scheduled Database Maintenance & Administrative Tasks
    • Configuring Replication / Data Synchronization
    • SQL Server Database Monitoring with SCOM
    • Troubleshooting SQL Server
    • Schedule SQL Jobs | SQL Server across multiple Servers
    • Disaster Recovery
    • Enterprise Policy Management / Centralized Management

    Skills: Data Management

  • Apr 2013 - Apr 2014

     

    Credit Suisse

    Contract Senior Microsoft SQL Server / Sybase DBA

    Zurich, Switzerland

    Contract Senior Microsoft SQL Server / Sybase DBA based in Zurich, Switzerland.
    • Responsibility for technical management and coordination of issues and projects primarily involving installation, configuration and on-going administration tasks of SQL Server and Sybase databases.
    • Active participation in the resolution of system and performance issues.
    • Close working relationship with other team members locally and globally to provide understanding across all components of the database environments.
    • DBA support for development teams and involvement in recommendations for new projects
    • Additional function to provide advice and assistance in terms of developing and progressing the infrastructure environments, including the assessment of needs and recommend solutions. SSAS Cube Deployments, SSIS Package Deployments, Metadata Deployments, SQL Server Cluster Build

    Skills: Data Analysis · Microsoft SQL Server · Database Administration · Database Design · Database Security

  • Nov 2008 - Jan 2013

     

    UBS Investment Bank

    Contract Senior Microsoft SQL Server DBA / Consultant

    London, United Kingdom

    • Senior / Primary Microsoft SQL Server DBA supporting a multitude of Mission Critical SQL Servers Globally, Providing Database Administration, Sytems Architecture and Database Development to UBS Cash Equities.
    • Supported the Database platform for electronic trading.
    • The platform is also strategic technology and has grown to be multi asset and global in nature.
    • The suite of electronic trading databases has also been extended to include Multi Lateral Trading Fund, post trade, alerting, analytics and reference databases in addition to the core trading platform.

    Skills: Data Management

  • Feb 2007 - Oct 2008

     

    London Stock Exchange

    Contract

    London, United Kingdom

    Skills: Database Administration · Business Intelligence · Database Design · Business Analysis · Project Management

  • 2006 - 2007

     

    Vanco

    Senior SQL Server DBA

    London, United Kingdom

  • Mar 2006 - May 2006

     

    Eversheds

    Senior SQL Server DBA

    Birmingham, United Kingdom

    Senior SQL Server DBA for Eversheds specifically hired to build and implement their SQL Server Clustered Environment.

  • Nov 2004 - Feb 2006

     

    Accenture

    Senior SQL Server DBA

    Leeds, United Kingdom

    Accenture NHS project based in Leeds. Production support SQL DBA working 12 hour shifts on SQL 2000, large scale SAN environment using snapshot backup technology.

    Supporting over 1,500 live databases, running on 200+ servers. Use of MS Cluster Services, supporting both two & four node instances, including four node BizTalk installs.

  • Nov 2000 - Nov 2002

     

    BNP Paribas

    Senior SQL Server DBA

    London, United Kingdom

  • Aug 2000 - Oct 2000

     

    Bigsave Holdings Ltd (bigsave.com)

    Senior SQL Server DBA

    Isle of Man

  • Sep 1999 - Mar 2000

     

    Security First Network Bank USA

    SQL Server DBA

    Atlanta, Georgia USA

    Senior Production SQL Server DBA for SFNB in Atlanta USA. SFNB were the worlds first Internet Bank subsequently they were acquired by Royal Bank of Canada.

  • Jul 1998 - Aug 1999

     

    Transco

    Database Development Consultant

    Birmingham, United Kingdom

    Working as part of a team, I assisted to convert Transco’s business critical databases from MS Access 2.0 to MS Access ’97. My responsibilities were to test and fix Visual Basic code, identify 16 Bit DLL’s and replace with 32 Bit DLL’s where necessary, provide 3rd line support to the development teams and Field Services.

    Working closely with the Y2K Compliancy Manager I was able to identify/fix many potential Y2K problems whilst performing the migrations from Access 2.0 to Access ‘97.

  • Feb 1998 - May 1998

     

    Access SQL Server Consultant/Developer

    Barclays

    Birmingham, United Kingdom

CERTIFICATIONS

Thanks for visiting!
Lets connect on LinkedIn

Connect on LinkedIn

© 2023 Copyright – Mandip Poonia. Website produced by OneDesignPrint.

Thanks for visiting!
Lets connect on LinkedIn

Connect on LinkedIn

© 2023 Copyright – Mandip Poonia. Website produced by OneDesignPrint.