Karthic A Email & Phone Number

Chennai, Tn, In

Chennai, Tn, In

Bengaluru, Karnataka, India

SQL Server DBA:• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2005/2008R2/2014/2016/2017/2019 • Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups• Experience in Database administration activities like Installation, Configuration, Backup & Recovery and Database Security. • Experience in high availability solutions like Replication, Mirroring, Log Shipping, Failover clustering and Always on. • Experience in Creating and Managing Databases and adding data files and log files to the databases whenever it is required• Experience with performance monitoring, backup, restore, and security recovery solutions • Troubleshooting expertise in SQL Server issues under production environment. • Exposure in handling the entire production servers with skills and understanding client's requirement Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them). • Strong Experience in Backup and Recovery strategy • Creation and maintenance of Databases, creating Roles and managing user permissions • Implemented database refresh and troubleshooting orphaned users • Having experience on rebuilding master database during crash situations Windows Azure (IaaS):▪ Creating Azure Virtual Machines and installing SQL Server in the VMs.▪ Understanding on Premium/Standard Storage accounts.▪ Creating Shared Storage using File and sharing the files across multiple VMs.▪ Understanding Azure Networking (VNets, Subnets, Private-Public IPs).SQL Azure (PaaS):▪ Creating/Configuring Azure SQL Databases (PaaS/DBaaS) ▪ Exporting BACPAC from Azure SQL Databases.▪ Creating and configuring Azure SQL Database Managed Instance.▪ Migrating On-Premises Databases to Azure SQL Databases (Singleton) using DMA▪ Exposure to DMA tools for On-Premises and Azure migrations

Chennai Area, India

• Performed installation of SQL Enterprise 2012,2014,2016,2017 64bit version on Windows 2012 , Windows 2016 clusters• Troubleshooting expertise in SQL Server issues under production environment. • Monitoring of database size and disk space in Production, Staging & Development environments. • Configured Clustering, Replication, Log Shipping and Mirroring with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues. • Strong Experience in Backup and Recovery strategy • Creation of logins and users, Grant and deny permissions and moving databases between servers • Troubleshooting transaction logs and Tempdb when full• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS. • Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.• Monitoring SQL Server alerts at regular intervals • Monitoring SQL Server agent jobs/maintenance plans • Co-coordinating with Development, Test and Support teams for server wide issues.

Chennai Area, India

INVESTMENT BANKING OPERATIONS (TREASURY DOMAIN) PROJECT DETAILS Client : Commercial Bank of QatarRole : Investment banking Analyst Duration : NOV 15 to NOV 17SETTLEMENT ACTIVITIES• Trade Settlements of capital market, foreign exchange trades for Interbank, Corporate, Money Market customers and CLS settlements• To ensure accurate processing of gross and netting deals• Investigating cancelled payment messages and initiate recall of funds in case of cancelled trade after payment goes out of system• Processing of nostro transfers requests from front office for transfer of funds between nostro accounts.• Ensure that all cutoffs are monitored and payments are affected• All relevant queues are monitored and settled before cutoffs• Ensure that batch is handed over before the SLA cut offs• Handle the customer queries over phone, swift and emails• Extensive knowledge in swift message handling (MT103, MT202, MT300, MT320, MT199, MT299, MT190, MT191, MT210, MT900 series)• Involved in Test case review process and performed Smoke Testing, Acceptance testing in Kondor application• Knowledge of complete Software Test Life Cycle and Agile testing• Performed Functional & System Testing to check the stability of the Application.• Performed Integration testing for Data Flow among the Modules.PAYMENT ACTIVITIES• Trade Settlements of capital market, foreign exchange trades for Interbank, Corporate, Money Market customers and CLS settlements• Processing Brokerage invoices and vouchers• Liaising with customers in getting swift confirmations• Validating deals based on Reuters conversation, Fax, Phone and broker confirmation.• To liase with production support teams and ensure resolution of system related issues

Chennai Area, India

PROJECT DETAILS Client : Standard Chartered bankRole : Investment banking Analyst Duration : OCT 13 to NOV 15PAYMENT ACTIVITIES• Trade Settlements of capital market, foreign exchange trades for Interbank, Corporate, Derivatives, Money Market customers, OTC and CLS settlements• Reconcile handle nostro breaks due to non-settlement of trades, investigate the issue and analyze the root cause to non-settlement and resolve the issue. • Processing Brokerage invoices and vouchers• Liaising with customers in getting swift confirmations• Validating deals based on Reuters conversation, Fax, Phone and broker confirmation.• To liase with production support teams and ensure resolution of system related issues• Checklists and DOI updates• Ensure that all cutoffs are monitored and payments are affectedREPAIR ACTIVITIES• Handling Forex (FX) and Money market (MM) for US, Mesa and UK settlements• Overall responsibility in prioritizing currency cut off trades to be settled within the bank (Interbank, Money Market, Corporate clients) • Analytical task includes rate re-fixing for MM deals, amount rate calculation for FX deals.• Escalating scenarios to senior manager or group head in finding solutions within turnaround time• Liaising with static support team to create new trader id, new currency pair, amending holidays setups for the system.• Conducting preliminary training for new joiners regarding interface desk and corporate settlement activities

Master Of Business Administration (Mba), Finance And It

Bachelor Of Engineering (B.E.), Electrical And Electronics Engineering