Sumit Gaikwad

Experience

• 

  DSS Mobilink Pvt Ltd

  Jan 2004 - Nov 2004

  Technical Officer

  Routing and maintaining of Telecom Switch of Alacatel 4300 L EPABX System.Inventory and updating of Sun Server for paging customers on Oracle database.Installation and management of Routers, Switches and Hubs of Cisco, Intel, D-Link.Troubleshooting of Samsung & Pizza Hut SQL Server Based on Oracle Familiar with different Networking protocols such as TCP/IP, DNS, FTP, DHCP, ISDN PRI, E-1, OSPF, and BGP. Installation of Mail server Linux 6.1 and implemented. Interoffice mails are sent to mail server, Whereas Interoffice mails are handed locally by configuring using protocol SMTP, POP3, DNS, GATEWAY etc.Backup of systems on daily basis on export DAT. Show less

• 

  TATA Bussiness Support Services

  Nov 2004 - Jan 2007

  Technical Support

  WORKED WITH THE TATA VSNL INTERNET SERVICE PROVIDER Troubleshooting the clients of TATA (VSNL ISP) Broadband, Dial Up and ISDN by using Tools such as OSS, Dslims.Installing, configuring and troubleshooting of Customer End Premises Devices such as Routers, Adsl modem and related accessories running on DSL and MAN Technologies and supporting PPPoE, PPPoA and VPN protocols.Manage team of 6 members, monitor their performance, motivate and recognize Analyzing calls to identify the root cause of deviationMaintaining updating customer's database on Oracle, Dslims and billing CRM. Show less

• 

  Patni Computer Systems

  Jan 2007 - Oct 2008

  Senior Analyst

  Project : Matrix PACSDatabase : Windows 2000/2003 SQL ServerSoftware :Front End-Visual Basic 6.0 Back End- SQL ServerClient : Merge Healthcare, MilwaukeeRole : Senior AnalystMaintenance, upgrading of database and Performance Testing.Requirements and Analysis: Understanding the requirements of the client and act as a functional resource. Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.Creating and Executing SQL queries and SQL Backups.Product : Immedia Archive Database : Sybase Software : AmassHardware :SPARC Enterprise 250, V240 Client : Merge Healthcare, MilwaukeeRole : Senior Analyst Administration Support •Installation and Administration of the Sun servers.•Troubleshooting issues of storage devices like NAS and Juke Box.•Recommend and perform version upgrades and patches for Sun server.•Monitor server capacity and make recommendations for hardware upgrades or add-ons (e.g. processors, disk space, memory) to accommodate current and planned server usage.•Job responsibilities included executing queries in different databases, including Sybase.•Recommend upgrade/addition of new servers based on current and planned application usage. •Adhered to International imaging standards including DICOM and HL7. Show less

• 

  Altera Digital Health

  Oct 2008 - now

  Platinum Tech Support Consultant

  Application Specialist:Coordinate with the Clients on various forums to discuss the status of the project, Recommending System specification, clarify any queries regarding the features.Customize application to meet customer requirement. Troubleshoot complex application issues escalated by L2.Test the application for defects and provide workaround to the client till the hot fix is released. This includes writing SQL Scripts to fix the issue.Active member of Service Review board and Product Planning meeting with Developers and BA Team for defects and enhancements management.Implementation: Onsite at USA for Implementation and Application Support Presbyterian Intercommunity Hospital (Los Angeles) & Athens Regional Medical Center (Atlanta) Onsite at Singapore for Application Support at Parkway Healthcare Hospitals Groups.DBA: Installation, Administration of SQL server 2005/2008/2012/2014Managing Tables, indexes and other database objects.Creating & maintaining Database files, Transaction log files, DTS, Views, Triggers and Stored Procedures.Configuring and implementing Replication and AOAG at client DB servers.Implementing Logshipping and Mirroring to maintain high availability.Installation of IIS and Apache and configuration for customer/In-house Customers.Creating, Managing jobs and Monitoring Sql Server Agent Error log.Assisting customer / in-house users / developers for any SQL / Windows issues. Planning suitable backup and recovery strategies for all databases to ensure better Availability. Managing/ maintaining proper indexes at all customer/In-House servers.Monitoring Database performance and optimizing performance using tools like Profiler, SQL logs and Event logs. Running and maintaining in-house and customer SQL Servers and applications (100+ customer sites).Quality testing and deployments of products on in-house and customer sites.HL7 Integration:Configure and Integrating HL7 interfaces and troubleshooting HL7 issues Show less