Prashant Pansuria
Vice President, IT at Tradeweb
- Role
- Vice President at Tradeweb
- Location
- Jersey City, NJ, US
- LinkedIn followers
- 500 followers
About Prashant Pansuria
Experienced IT professional with demonstrated history of progressively working in the Financial Technology (FinTech) and Services industry. I have over 17 years of experience as database developer, analyst, and administrator. Currently member of global team responsible for development of trading platforms, it\'s peripheral systems, and management of over 200 SQL database servers that host Trading platform, Clearing, Billing, Reporting, Corporate, In-house and Third Party applications. Specialties: MS SQL Server- Database and system architecture - T-SQL development - Database Administration - Data security - Performance tuning & Optimization - Disaster Recovery solutions - Technologies within SQL Server: SQL Agent, Replication, Mirroring, Service Broker, SSIS, configuration of SSRS, Always On Availability Groups (High Availability and Read-Scale) Sybase ASE- SQL development SAP Business Objects
Experience
Vice President
Mar 2016 — Present · Jersey City, NJ, US
Hands-on ownership of company’s largest database implementations, responsible from business requirements analysis through solution delivery and support, working closely with disparate business groups in development & testing of new products, capabilities, and releases- Extensive experience in Data Design & Development of Stored Procedures, Functions, Views, Triggers, Indexes, and complex queries representing data from multiple sources- Development/maintenance of securities data pertaining to various product groups (US Treasuries, Agencies, MBS, Repo, Corp Bonds, CDS, Swaps, Derivatives, ETFX, Equities, Government Bonds)- Administer production servers, debug/optimize queries to improve performance of trading platforms, develop operational standards- Assist various Technology and Business teams with their objectives of database development, testing, resolving production issues, release management, data replication and securities data related queries- Share knowledge and exchange ideas with team members and technology/business teams to accomplice new development objectives, overcome technical hurdles as they arise pertaining to MS SQL Server, trading, and performance issues- Translate business/industry/financial product specific rules and development requirements into software components such as database architecture, data models, stored procedures, functions, views, indexes, and other objects- Identify and implement optimal strategy for clustering, log shipping, mirroring, Always On Availability Groups, and replication technologies- Performance tuning of SQL Server database instances, analyze Query Plans- Develop and maintain backup, recovery strategies, disaster recovery plans. Full understanding of Business Continuity and Disaster Recovery of Global Trading Systems- Extensive understanding of full Software Development Life Cycle for a global trading system, manage changes, ensure backwards compatibility of code.
Education
Texas A&M University
MS, Computer Science
2003 — 2005
Nagpur University
BE, Computer Technology
1998 — 2002
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.