Gopinath K.

Having 20+ yrs of IT experience with 16+ years of experience in various Data Base development and web applications Having good experience in building complex queries,triggers, stored procedures and functions. Experienced in index tuning and performance optimization technique To monitor performance of queries, stored procedures using various profiler Tool. Thorough understanding about Software Development Life Cycle. Experienced in Data Migration. Having good experience in Node Js API servces Proactively monitor the Production Server and optimize stored procedures for better performance Resolve locking conflicts and resource utilization Experienced in handling teams for various Clients. Creative, analytical thinker with demonstrated ability to troubleshoot problems determines strategies to resolve issues and consistently implement effective solutions. Result oriented leader with determined strategies, resolving issues, consistently implement effective solutions.

Maclear’s Risk Management, .Net, SQL Server, Maclear’s Risk Management Solution provides a structured automated approach to managing risk. A software solution designed to apply uniform risk assessment frameworks across the risk landscape. Built-in comprehensive dashboards with a wealth of qualitative and quantitative data that provide real-time risk insights. The data, reports and analytics can be used to across the enterprise to manage top-down and bottom-up approaches and roll-up scores based on business hierarchy, objective, product, process and more., Database Designing, To write SQL Stored Procedures, Identify and resolve database performance issues, database capacity issues Drumee, Node-JS, MYSQL, Drumee simplifies information sharing, makes exchanges more dynamic and makes work more fluid, via an all-in-one collaborative on-line platform., Database Designing, To write REST API services, To write MYSQL Stored Procedures, Identify and resolve database performance issues, database capacity issues, To monitor performance of queries, stored procedures using various tools. Runster, Go, ORACLE, Python, Runster SAS offers a digital platform of services to develop running experience of its users, all disciplines., Database Designing, To write SQL Stored Procedures, Identify and resolve database performance issues, database capacity issues, Designed an ETL tool (python) in for Data Loading. Citygo, Magneto, MYSQL, Citygo is an urban carpooling mobile application service that connects passengers and drivers who want to share their journeys., Identify and resolve database performance issues, database capacity issues, Write an ETL package to move the records from huge tables in production DB to archive DB., To write SQL queries, Stored Procedures & Views., To monitor performance of queries, stored procedures using Jet profiler., Daily health checks report., Configure slow query logs to identify the long running queries., Create statistical Queries and Procedures for KPI Reports. CMiC, JAVA, ORACLE, CMiC is the leading provider of complete, integrated, and advanced enterprise level software solutions designed exclusively for the construction industry. CMiC software integrates all departments and functions in a single, scalable database, allowing information to be transmitted across the enterprise and eliminating the need for duplicate data entry., Database Backup and recovery, table space creation and modifications, upgrades and migrations, Index management, user management, privileges Design, Patch updates, Apply hot fixes., Generate Weekly & Monthly Database health report., Created powershell script to get Memory, CPU & Disk usage in a periodical interval, Create triggers for auditing nextSource, JAVA, Oracle, nextSource helps companies of all sizes and across all industries to optimize their workforce. The company's 'How-To' human capital management methodology encompasses vendor management programs, salary and rate benchmarking, pay rolling, staffing, procurement, and HR consulting services., Logical and Physical Database Designing, To write packages, Stored Procedures, functions, and triggers., Supporting Documentation ChannelHub, NODE JS, POSTGRES, It is B2B Web application to digitally connect consumer technology vendors and retailers to allow a faster and more productive way to bring innovative products to the market. ChannelHub enables vendors, distributors and retailers from all over the world to build trusted relationships in a fast and easy way, leveraging cutting-edge technology with human expertise., Logical and Physical Database Designing, Creation and maintenance of various database objects, To write SQL queries, functions & Views., To write JSON functions., To monitor performance of queries, stored procedures using Jet profiler. MAP Health Management, JAVA, SQL Server, MAP provides telehealth services, extended treatment support programs and revenue cycle management to a client base of nationally recognized addiction treatment providers and behavioral health professionals., Logical and Physical Database Designing, Creation and maintenance of various database objects, To write SQL queries, Stored Procedures, Cursors, Views and Functions., To monitor performance of queries, stored procedures using Profiler Tool., Supporting Documentation, Designed ETL tool for Data Migration from legacy DB to new db. MCC (Marketing Control Center), JAVA, ORACLE, MCC provides a complete next-generation marketing automation platform that enables its customers to optimize marketing campaigns and increase revenue through e-mail, mobile and social interactive tactics., Database Backup and recovery, table space creation and modifications, upgrades and migrations, To write SQL queries, Packages, Stored Procedures, Cursors, Views and Functions., Index management, user management, privileges Design CompACT Online, ASP.Net 2.0, SQL Server 2010, JavaScript, C1 Component Reports, CompACT is compensation application tool used by our client organizations. The Compensation team of the client acts as the ADMIN of the application. We need to deal with the compensation team to get update for all their employees’ performance and pay recommendations. The managers in the organization used this tool to review their employees. Once they finished their recommendations and review for each of their employees, they submit them to their higher manager for approval. This process continues from the lowest level of the hierarchy to the highest level till the CEO of the organization. There are also HR users who can view and follows up their assigned manager. Once all the Managers submission process is finished, the reports and data migration process will be undertaken., Logical and Physical Database Designing, Creation and maintenance of various database objects, Designed SSIS Package for Data loading., Database Backup and Restore Procedures., To write SQL queries, Stored Procedures, Cursors, Views and Functions., To monitor performance of queries, stored procedures using Profiler Tool., Supporting Documentation QTIP Online, ASP.Net 2.0, SQL Server 2008, JavaScript, C1 Component Reports, This is a Web Version of the PeopleSoft HRMS Application developed for Blue Shield of California. In this system, all the employees are provided their Appraisals which include Salary Increase based on the Guidelines and Targets fixed by the Administrators based on the company policy and Market Standards of the Job Titles. The Application involves various modules like Annual Incentive Pay Verification, Merit Recommendation, Bonus Recommendation, and Stock Recommendation. The Managers in the Organization will give appraisals to their employees and submit this for the approval to their Managers. The higher level managers can either accept or deny the approvals made by their managers., Logical and Physical Database Designing, Creation and maintenance of various database objects, Designed SSIS Package for Data loading., Database Backup and Restore Procedures., To write SQL queries, Stored Procedures, Cursors, Views and Functions., To monitor performance of queries, stored procedures using Profiler Tool., Supporting Documentation

SQL Server, Mysql, Postgres, Oracle, T-SQL, PL/SQL, PGSQL, PYTHON, NODE-JS, TKPROF, Explain Plan, SQL Profiler, Explain, Jetprofiler, Nero, RMAN, Import/Export, MSSql Management Studio, SQL+, SQL Developer, WorkBench, PGAdmin, ASP.NET 2.0, ASP, Jquery, Java Script, HTML, AJAX, CSS, linux, DOS, Windows NT, XP, Windows 2000 Server, 9x