TECHNICAL SKILLS:

Languages: T - SQL, PL/SQL, JavaScript, PowerShell, PERL, HTML, Java, C/C++, Visual Basic, Aqua DATA STUDIO, MS VISUAL STUIDO 2008

Middleware: IBM MQSeries, Solace, Tibco, FIX, SWIFTETL: Informatica, SSIS, SSRS

DATABASES: Sybase, MS SQL Server, Oracle O/S: Windows, Linux, UNIX

REPORTING: Business Objects XI, Crystal Report, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Production Support

Responsibilities:

• Primary Support for the vendor products like SunGard P3, Fidessa and Geneva Reporting Tool and inbuilt applications like Data Warehouse.
• PB Application Support for the end to end trade booking, Middle office Clearring and Back Office Reporting.
• Primary Support is done using Bloomberg Security Master plus all the support for Data Application Suite like Account Master, Product and Pricing Master
• Client Reporting Application Geneva for all the client and MIS reporting for Prime Brokerage business for Fix Income trading.
• Complete Automation of DEV and BETA/UAT environment for the DEVOPS requirement. All the processes around DEV and QA are set up on AUTO-ROBOT mode where no manual intervention required using Power Shell and Visual Cron.
• Installation and Maintenance of the application on Unix/Linux Servers, windows servers
• Installation and Maintenance of the Web Servers, Portals ( www.cantorpb.com) using Jboss and SQL Server 2008 R2/ SQL Server 2012/14
• Query Optimizations (Stored Procedures, Views, TSQL)
• Additional SOD Report Writing using SSIS DTX Packages, SSRS Packages using MSDN and Visual Studio 2015
• Support of Multiple middleware messaging tools like Tibco EMS to receive the external trades from the clients.
• Database mirroring and Log shipping for the High Availability and Disaster Recovery.
• Security administration for web portal
• Production Release Roll-outs, functional and Non Functional requirements gathering and analysis for infrastructure and Support management.
• Maintaining consistency among development, QA and Production environments including infrastructure upgrades on weekends
• High Frequency Trading Support for Treasury Market Directed, disclosed trading between a trusted network of professional counterparties using Spoon ETL tool. Specialized trading network support built to facilitate the transfer of genuine liquidityand risk among professional market participants.
• System Architecture work related to new PB financing to facilitate leverage of client assets and Operational support (prime brokers act as a hedge fund's primary operations contact with all other broker dealers)
• Migration to Windows 2012 and SQL Server 2016 from the current existing platform for High Availability and Fail Over Capabilities.
• Support of Geneva Reporting platform for all the client reporting needs such as daily and MTD PNL, Trade Date and Settlement Date Ledgers, Activity, Position and Balance SOD reports for margin and cash,
• Stock loan Application Support for LFA, set up of securities and reports for Locates, loading of all the availability files.
• Support for Client Onboarding including set up of new clients, for Risk monitoring and compliance limits.
• Working with Broadridge for complete Security Master access using Bloomberg
• Support of Seaman Margin System for all the clients in PRIME and Secured Financing

Confidential, New York, NY

Production Support Manager

Responsibilities:

• Primay Support for the vendor products like Sungard GMI, Sungard Clearvision and inbuilt applications to like FOCUS and ODH
• OTC Application Support for the inbuilt products like Credit Limit Hub for the RATES and CREDIT trades.
• FX Options Application PSFI BARX PB which primarily works with the BARX Exchange.
• Client Reporting Application GRM for all the client and MIS reporting for FUTURES and OTC trades.
• Complete Automation of DEV and QA/UAT environment for the DEVOPS requirement. All the processes around DEV and QA are set up on AUTO-ROBOT mode where no manual intervention required using PERL and AUTOSYS.
• Installation and Maintenance of the application on Unix/Linux Servers, windows servers
• Installation and Maintenance of the Web Servers, Portals and support of the same using the Perl/Shell scripting
• Query Optimizations (Stored Procedures, Views, TSQL)
• Support of Multiple middleware messaging tools like Tibco EMS, Business Works, Solace and FIX for ECN like HOTSPOT and TRAIANA.
• Database mirroring and Log shipping for the High Availability and Disaster Recovery.
• Extensive Experience in installation, configuration, deployment and troubleshooting ofTIBCO Active Enterprise Suiteof applicationsTIBCO BusinessWorks, TIBCODesigner,TIBCO Rendezvous, TIBCO EMS, TIBCO Active Database Adapter, TIBCO File Adapter, TIBCO MQ Series Adapter,TIBCO Administrator
• Security administration for Unauthorized Trading, Developers Access to Production, OneCert and RSAM.
• Production Release Roll-outs, functional and Non Functional requirements gathering and analysis for infrastructure and Support management.
• Maintaining consistency among development, QA and Production environments including infrastructure upgrades on weekends
• Maintenance of the RANSYS application along with the connectivity with all the exchanges all over the world like ICE, EUREX, CME, CBOT
• Managing Support for end to end trading cycle from FIDESSA ( front office) to FOCUS/FDM to SunGard GMI ( Back office)
• Managing Support for end to end trading cycle from Broker Files and STP (straight thru processing) to FBOS to ION's RANSYS ( Back office)
• Knowledge in usingTIBCO Administratorfor User Management, Resource Management and Application Management
• Support for clearing of the RATES, FX and CREDIT trades using PSFI BARX PB, Credit Limit Hub applications in direct supp rt of the sales desk along with middle office OPS.
• Managing overnight batches for Sungard GMI and ION's RANSYS for all the Derivatives clearing.
• Managed on-site 6-member team and off-shore (TCS) 9-member team supporting ASIA PAC regions amd EMEA regions.
• Controlled the support work through Level 1 and Level 2 teams for the different level of support.

Confidential

Production Support Manager

Responsibilities:

• Design and Implementation of Backup, Disaster Recovery and Capacity Planning strategy
• Build and maintain Database replications.
• Configure Active/Active and Active/passive clustering
• Installation and patching
• Query Optimizations (Stored Procedures, Views, TSQL)
• Analysis and Optimization of Database Performance
• Database mirroring and Logs shipping
• Security administration
• Support Release Roll-outs
• Worked withTIBCO BusinessWorks Adapterto communicate and update business information that originates fromFinancial Exchanges, ECN's, andSWIFT as well as Databases.
• Functional and Non Functional requirements gathering and analysis
• Maintaining consistency among development, QA and Production databases PERL scripting along with AUTOSYS.
• Design and implement ETL strategies using DTS/SSIS packages for SQL Server
• Optimized database queries within applications to meet non functional requirements
• Implemented Sarbanes Oxley auditing and reporting requirements
• Managed on-site 3-member team and off-shore (TCS) 5-member team supporting ASIA PAC regions amd EMEA regions.
• Controlled the support work through Level 1 and Level 2 teams for the different level of support.
• BPSA environment consists of SQL Server 2008 running on Windows Server 2008 with massive database servers. Environment includes approximately 40 Servers running on 27 machines.

Confidential

Oracle Application DBA/ Data Architect/ Data Modeler

Responsibilities:

• Technical lead in database projects for complete SDLC: requirements, design, development, QA, production implementation and maintenance phases.
• Design and implementation of data warehouse solutions including database design using partitioning and Informatica ETL architecture for real time data warehousing.
• Transform business requirements in to the logical database model with ERWIN and creating physical design from data model.
• Design and development of Data models and ER Diagram using ER Studio and creating oracle structures based on model.
• Database structure maintenances like tables, indexes and tablespaces to obtain optimum performance and follow oracle best practice.
• Mentoring the developers about best Oracle practice and SQL tuning and Code review.
• Support and maintaining non production environment for development and testing, proactive support for performance tuning during design and development for smooth production deployments.
• Design and Development of Oracle procedures for data manipulation and data validation.
• Setup and maintain Golden gate replication for real time data warehouse.
• Set up the database standards and direction, make decisions or recommendations on database-related products and services, develop and implement the best practice and procedures in database architecture design, installation, upgrade and migration, database administration and management, security and auditing, high availability and disaster recovery, performance diagnostic, measurement and optimization, capacity planning, change impact analysis and production control management, information sharing, collaboration, business continuity plan, and DR sites.
• Improve data quality, eliminate architecture inefficiencies and fully automate data load processes, enhance existing dimensions by expanding attributes list, refining dimension to facts s, replacing natural keys with surrogate ones as per Best DW Practices, implementing Oracle partitioning strategy for better loading and reporting performance, revamping index strategy based on data cardinality, identifying new data sources and designing new dimensions and facts to meet additional requirements from business users.
• Implement new features provided by Oracle to the application.
• Major integration of different systems using TIBCO EMS with standards on TOPICS and subscription method for different purposes. Expertise in using messaging standards such asJMSandTIBCO Rendezvous/ TIBCO EMSfor developing distributed applications
• Responsible to create and Implement theTIBCO EMSarchitecture across enterprise using good routing techniques andMQ adapter, Database Adapter and File Adapter.
• Performance tuning and troubleshooting, technical support to development team, Production support for new release and production move, production database maintenance, space management to ensure 24*7 database availability.
• Data guard setup, configuration and maintenance, sync with production database and support during the COB testing.
• Design and development of UNIX shell script to monitor and automate database tasks.
• Managed on-site 3 member team doing pure development using core JAVA.
• Managed on-site 6 member team doing ORACLE development and TIBCO/EMS set up and ETL development using Informatica and AUTOSYS.
• Setup process change management and product releases.

Confidential

Data Architect/ Data Modeler

Responsibilities:

• Performed the requirement gathering, design documentation and data analysis on multiple data sources.
• Development, Enhancement and maintenance of Informatica mappings & workflows with multiple transformers, performance tuning etc.
• Construct the ETL/DB processes in combination of PL/SQL & ETL tools.
• Architect the conceptual, Logical & Physical modeling for relational and dimensional Datawarehouse system.
• Performed physical implementation of physical data model, and optimized systems for better performance.
• Mentored to convert some of old processes from Datastage to Informatica.
• Schedule the batch jobs through shell scripting and schedulers.

Confidential

Team Lead/Sr Microsoft SQL Server Administrator /Developer

Responsibilities:

• Troubleshoot problems using SQL server profiler.
• Performed performance tuning to optimize SQL queries using query analyzer.
• Created database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions.
• UsedDBCC commandsto check physical and logical consistency of the databases and rebuilt indexes.
• Involved in migrating SQL Server Databases from Development to Production Server.
• Developed SQL scripts for maintaining administration tasks.
• Tested point in time disaster recovery of the production databases using the traditionalbackup/restoretechnique.
• Estimated disk storage requirements for database software, database files and database administration needs.
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Developed, deployed, and monitored SSIS Packages.
• Involved heavily with Microsoft SQL Server stored procedures, triggers and database schemas.
• Migrated data from different sources such as text based files and excel spreadsheets to SQL Server databases using SSIS.
• Installed and configured SQL server 2008 database. Upgraded SQL server 2005 to SQL server 2008.
• Responsible for migrations and SSIS deployment, MS SQL 2012 HA and Always ON cluster implementation, SQL server replication.
• Provided support for TeraData systems and utilizing Informatica.
• Mentored two SQL DBA juniors for data architecture/engineering experience.

Confidential

Production DBA

Responsibilities:

• Ensure proper functioning of production databases in situations like 100% CPU utilization, disk space issues, numerous bottlenecks and gaps in the backup-recovery strategy etc.
• Communications with Infrastructure & Operations team to eliminate bottlenecks such as upgrading the Network and SAN storage.
• Analysis of database usage during the process of consolidation in different servers which in turn helps in resolving backup issues and reduction of server maintenance to more than 50%.
• Thorough investigation of database performance for migration (or updating) of databases to SQL Server 2000/2005.
• Optimization of replication system between several servers as part of business functionality.
• Transformation and uploading of huge data from different platforms to DTS.
• Upgrade strategies include complete testing, design the coding standards, Business Continuity testing with DR Failover, communication with the third party vendor such as Broadridge, ADP and IBM.

Environment: ERWIN, ER/Studio, Oracle 11G, SQL Server 2008, DB2 UDB, ETL, Informatica, SAP Business Objects XI, SSIS, SSAS, SSRS, MDX, UNIX, Java, TOAD, DB/Artisan, SDLC (Agile), Autosys 11.3 and 4.5, DB Artisan 8.6 Premiere Global Services; Tinton Falls, NJ Sybase 12.5.4 and 15.0.3 DBA / Oracle 10g DBA / MS SQL Server 2005 DBA

Confidential

Responsibilities:

• Installed new software & Upgraded Sybase version to 12.5. Worked with the developers to test the new software on Linux.
• Single handedly upgraded all the existing Sybase servers to 15.0.3 from 12.5. Worked very closely with UNIX and NT SA’s for the configuration of hardware and software, so that it functions optimally with database software. Maintained Clustered machines for HA using VERITAS. Set up the clustered machines for performance.
• Managed Oracle 10G RAC, Dataguard, Backup and Recovery using RMAN, Data transfer and Management using Import/Export/Data Pump/SQL Loader, Shell Scripting for managing the processes.
• Assisted the developers in TSQL for designing the schema and for creating Stored Procedures, Triggers, Cursors, User - Defined Functions, Rules, Constraints, tables and databases. Helped developers with SQL internals, indexing for queries, query optimization and resource utilization.
• Created DTS Packages in 2000, SSIS packages in 2005, Job Scheduler, Analysis services.
• Security administration involved adding and removing users, administering quotas, auditing and checking for security problems with implementation of DACT and PACT.
• Performance tuning and monitoring: Retuned the system. Built maintenance related jobs using the K-Shell scripting. Involved in configuring the history server as well as monitor server for the performance related information. Ran utilities like top, netstat, vmstat at the os level.
• Backup and recovery: Developed a strategy to perform minute recovery using the replication servers, mirroring (not used High Availability from Sybase). Involved in firedrills to ensure the smooth working of strategy with proper SLA..
• Scheduled Maintenance: Responsible for running jobs like rebuild reorg to do the reindexing of the fragmented tables, update statistics, running the DBCC check storage.
• Troubleshooting: Worked hand in hand with the developers to find the perfect solution to critical issues such as saving the data using multiple languages in the database. Involved in converting an entire Russian project from Cyrillic to Latin. .
• Failure Recovery: Successfully handled sudden issues like tempdb full, hardware failure booting the server, UNIX SA’s changing the hardware parts etc and made sure that the apps are up within the SLA approved by the business users.
• Set up the HA strategy for DR using Warm Standby and MSA replication.
• Set up GVR replication using function replication as this is the Application /SWITCH needs.
• Replaced the then existing monitoring structure of History and Monitor server with MDA tables using KShell scripts.

Environment: Sybase ASE15.0.3, ASE 12.5.4, Replication Server 12.6 including MSA and warm Standby for HA, GVR replication using Function Replication and HUB concept, Solaris 10 using ZFS for clustering, Solaris 9 using VERITAS for clustering, Red Hat Linux 5, Oracle 10g, Microsoft SQL Server 2005 for Data Warehousing using SSIS, Unix Shell - CSH

Confidential, NYC, NY

Consultant - Sybase DBA / Oracle DBA / MS SQL Server 2000 DBA

Responsibilities:

• Responsible for moving all Sybase servers from Solaris to Linux and 24x7 production support.
• Installed and upgraded from version of 11.5 to Sybase version to 12.5. Tested the new software on Linux.
• Worked very closely with UNIX and NT SA’s for the configuration of hardware and software, to ensure optimal functioning of database software.
• Assisted the developers in TSQL for designing the schema and creating Stored Procedures, Triggers, Cursors, User - Defined Functions, Rules, Constraints, tables and databases. Guided developers with SQL internals, indexing for queries, query optimization and resource utilization.
• Created DTS Packages in 2000, SSIS packages in 2005, Job Scheduler, Analysis services.
• Responsible for Performance tuning, monitoring, Backup and recovery
• Involved in Scheduling Maintenance, Troubleshooting & Failure Recovery
• Set up the replication strategy using Warm Standby and MSA.

Environment: Oracle 10g, Sybase ASE 12.5, Replication Server 12.0, DBArtison 8.0, MS Sql Server 2005, UNIX, Linux

Confidential, Jersey City NJ

Senior Associate

Responsibilities:

• Led the project Listed Derivatives Architecture (LDA) project from Client Data team which required huge data cleanup, data migration, decommissioning of GMI system. The data existing in AIX flat files (third party application) system was migrated to Sybase Database.
• Successfully led and completed 2 major projects in data migrations for Japan in Sybase - FIAM and TEIO.
• Managed the project of development of AMHUB, the strategic Account Master Application.
• Work included quarterly DB-CUT with data modeling, physical database design, application design and implementation, system performance and tuning, replication function string maintenance, including day-to-day support.
• Designed and developed GMI - Futures system in AMHUB using Sybase 12 and Replication.
• Designed and developed GSAM - Account Master System in AMHUB.
• De-commissioned Fixed Income Account Master application and merged with Institutional Account Master and firm wide Account master to form a Global Account Master HUB in Sybase supporting all other downstream systems.
• Data modeling using Erwin for new Sybase Application as well as for reverse engineering from the old DB2 Application.
• Designed the new system to maintain the history for the Global Account Master system using Sybase IQ and Sybase Replication.
• Responsible for the maintenance of the Autosys Jobs using the UNIX scripting. (K-shell and C-shell).
• Worked as a team member on the MIFID project using Java - EJB and UDB Database
• Managed the FINRA project using Sybase 12.5 and XML.
• Worked on Client On-Boarding initiative.
• Successfully worked on IBAN project for Account Master in DB2 and UDB.
• Effective presentation to the senior management for the restructuring of replication system and eliminating the need of maintaining the local account masters.

Environment: Sybase ASE 12.5, Replication Server 12.0, DBArtison 7.0, Sun Ultra -1 workstations, Sun E 6500 Servers, Sun 420 R Servers, Sun 220 R Servers, UDB 8.0, Solaris 5.6, 5.7 and 5.8 along with WINDOWS XP. Microsoft Project, Office Suite, PowerPoint, Visio, C,, Java, EJBs, JSP, Servlets, JDBC, SQL, XML, GUIs, BEA weblogic 8,1 with J2EE, XML, Erwin, JMS using MQSeries, Tibco EMS