East Rutherford, New Jersey
201-***-**** ò email@example.com
SQL Developer ò Migration Specialist ò Project Manager
Migrate large/complex databases ò Performance Tuning ò Shell/Perl scripting
Dedicated Database Professional highly regarded for the design, development, integration and delivery of effective solutions that solve client issues, impact productivity and reduce costs. Extensive experience in Investment Banking, all phases of software development lifecycle (SDLC), designing large complex databases, performance tuning, and migration of databases, problem-solving. Implement and manage change on existing business and technology processes, working collaboratively throughout the project lifecycle to ensure success. Exemplary academic qualifications include a Bachelor of Technology in Computer Science from Uttar Pradesh Technical University, India. Outstanding communication skills, capable of working with internal and external stakeholders.
Successfully migrated critical trading databases from Sybase to Microsoft SQL Server 2016 for leading investment bank
Led teams to achieve improvements in overall productivity and consistently met delivery deadlines while working in a high-pressure environment.
Successfully managed large, complex trading databases at Fortune-100 Investment bank, optimized business processes, built teams, and saved operational costs for the company.
Consolidated and migrated several distributed Sybase database servers to a centralized server, saving $1+ Mil in total cost of ownership.
Managed critical trading database with aggregated data volume of 1+ Peta Byte
Cut execution time by 60% by optimizing key client reports for Fortune-100 bank.
Successfully implemented landmark real time royalty payment mechanism for top Media & Entertainment client
Migrate large/complex databases
Stored Procedures & Functions
IRIS Software Inc ò New York City, NY ò 2020 – Present
Database Migration Leader
Project- RBC Capital Markets, CFG (Central Funding Group)
Central Funding group maintains repository of data for security lending and repo businesses within RBC capital markets. RBC uses applications owned by central funding group to maintain relationships and provide consulting services to its client. Application involves front office trading with high transaction volume. Provide expertise for organization wide Sybase to SQL Server migration for central funding group. Enhancing and tuning databases for applications. Work with functional staff to clarify requirements. Prepare comprehensive design and technical specification document for migration. Developed data migration and verification strategy. Recommend hardware improvements to ensure efficiency post migration. Rewrote various business processes to improve performance
Led the planning and migration of critical trading databases from Sybase to Microsoft SQL Server 2016
Provide solutions for technical issues including reducing complexity, increasing maintainability and providing flexibility and reuse
Reengineered existing business processes involving user defined functions into queries to improve performance
Configured and utilized SQL Server migration assistant for migration of complex trading databases from Sybase to SQL Server
Optimized reporting suite cutting down overall execution time by 38% in SQL Server
Utilized SQL Server profiler to capture traces and analyze for performance issues
Recommended design improvements and implement these in terms of usability, scalability, performance
Conducted performance tuning of queries and stored procedures using database engine tuning advisor
Coordinate with front office trading application business users for migration testing
AH Infotech LLC/Larsen & Toubro Infotech LTD ò Rutherford, New Jersey ò 2014 – 2020
Project- Sony Music: CARS (Clearing House Administration & Royalty System) ò 2014 – 2020
Provide expertise on an application utilized as a meeting point for the flow of information from worldwide sellers to owners and a source of historical data. CARS system interacts directly with RAAS/GCLS/EROS & SAP. Ensure system and data availability and integrity through preventative maintenance and upgrades while consistently meeting deadlines and requirements for all production tasks. Implement company policies, technical procedures, and standards for preserving the integrity and security of data, reports, and access. Develop workflow charts and diagrams to ensure production team compliance with client deadlines. Generate business insight reports for senior management
Coordinate real time payment processing with payments that average $25+M in royalties and 30+M transactions daily
Design large complex databases for business services and make recommendations for architectural improvements
Led the documentation for core business processes and pricing model for senior management.
Coordinate with business users across the global to gather requirements for new business processes
Conducted performance tuning of queries and stored procedures to reduce processing time thereby improving efficiency.
Led the planning and migration of existing production servers to new versions of RDMBS to improve efficiency
Artech Information Systems LLC ò Herndon, Virginia ò 2014
Senior Consultant / Project- Fannie Mae: MBS_Reporting (Mortgage Backed Securities Reporting)
Worked on the central application that enables Fannie Mae to manage the Mortgage backed securities and their relationship with the external servicers. Maintained and supported MBS_Reporting PROD database. Wrote stored procedures for various new changes and modified existing code to comply with the enhancements.
Designed and implemented hybrid disks for PROD servers (SSD+SAN) to save operational costs ~$354K annually.
Planned and executed critical Sybase 15.7 migration, involving extensive unit, functional testing.
Reengineered queries into stored procedure for performance enhancement
Optimized key client reports cutting down execution time by 60%.
Ensured system and data availability and integrity through preventative maintenance.
TATA Consultancy Services LTD ò Pune, India/ New York City, NY ò 2007 - 2014
Sybase Programmer/Project Leader / Project- Morgan Stanley: ETSDB (Equity Trading System Databases)
Led and managed the ETSDB, Morgan Stanley's global repository of institutional transactional data, which captures details from order entry to pre-settlement enrichment. Additionally, the databases cut across all equity businesses, regions and applications and promote synergy between different client data by providing a cohesive and consistent data model. Managed critical trading databases for Institutional Equities division with daily transaction volume 500+M. Performed monthly altering schema of databases for Front Office trading databases on 54 PROD servers globally.
Archived ~1TB data to warehouse server on a daily basis to generate compliance reports.
Migrated large complex 100+ Tera Byte size databases for Institutional equities business
Led capacity planning to accommodate new clients for institutional equity business
Met requirements by writing stored procedures for various new changes and changing the existing code.
Optimized queries and stored procedures to reduce processing time taken thereby improving throughput
Planned and migrated production servers to different page sizes, high capacity hardware, and latest versions of Sybase RDMBS
Uttar Pradesh Technical University, India: 2005
Bachelor of Technology in Computer Science
Certifications: ITIL - Completed with 97%
Active volunteer for child education at local religious institution
Microsoft SQL Server 2016, 2012, SSIS, SSRS, Sybase ASE 16.0, 15.7, 15.5, T-SQL, PL/SQL, Perl, UNIX shell scripts, crontab, Linux, Windows, Autosys, SQL Server migration assistant/SQL Server profiler