Resume

Sign in

SQL Server 2012/2016, SSIS, SSRS

Location:
East Rutherford, NJ
Posted:
May 15, 2020

Contact this candidate

Resume:

Mayank Jain

East Rutherford, New Jersey

201-***-**** ò adc8vc@r.postjobfree.com

https://www.linkedin.com/in/mayank-jain-a4386616/

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.

Selected Highlights

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

Core Competencies

Migrate large/complex databases

Database Development

Project Management

Stored Procedures & Functions

Leadership

Extract/Transform/Load

Technical Solutions/Improvements

Database Administration

Requirements Gathering

Data Flows

Documentation

Server Migration

Change Management

QA/Testing

Cloud Computing

Shell/Perl scripts

Performance Tuning

Reporting Solutions

Professional Experience

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

Lead Consultant

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

Education

Uttar Pradesh Technical University, India: 2005

Bachelor of Technology in Computer Science

Certifications: ITIL - Completed with 97%

Additional Credentials

Volunteer Work

Active volunteer for child education at local religious institution

Technical Skills

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

HOBBIES

Adventure Sports



Contact this candidate