K C S Pvt Ltd Work Values

Daily Duties at K C S Pvt Ltd:

• Created Depository Back Office System for tracking and managing the security transactions between the Clients and Depositories (Banks) • Created Loan Against Demat Shares System to draw loan against Demat shares from the bank according to bank value of shares. • Created a system to generate and process the Annual Maintenance Charges of Emat billing by calculating various charges like account opening charges, prepaid credit adjustments and promotional credit adjustments. • Designed and created Tables, Indices, Views, Procedures, Packages, and Functions. • Created normalized tables by creating the reference keys • Fine-tuned the stored procedures, queries by changing the join orders and giving all combinations of joins and fixed them with the help of various utilities. • Tuned SQL queries and PL/SQL code using Oracle utilities like tkprof, Explain Plan and Autotrace. • Developed procedures, packages, functions, triggers using PL/SQL & Oracle supplied packages. • Created complex joins, correlated sub-queries, aggregate functions and analytic functions • Dropped and recreated the indexes on tables for performance improvements • Partitioned tables, which have frequent inserts, deletes and updates to reduce the contention and to improve the performance • Created and run the SQL scripts to create the database logical structures. • Shifted data into oracle which had already been present in other databases such as excel. • Creating and grant roles for privileges. • Create sequences based on volume of the data • Created comprehensive test plans and result test cases and scripts for unit and integration testing

What they like about K C S Pvt Ltd:

Working for a company with an emphasis on social values and helping society is a clear and important priority for you - a critical factor in who you choose to work for. In contrast to other factors, you place an organization's reputation for fairness and concern for the community above most other aspects of the company. As you search for a new job opportunity, it is usually possible to find out if the company is involved in the community and/or if it is addressing problems and issues in society. Pay special attention to non-profit organizations and those specifically involved in social action. Moreover, speaking with current and former employees should enlighten you to perceptions of the fairness of the company's leaders and the treatment of employees.

Tags

Oracle, pl/sql, datawarehouse

Skills

These are some of the questions we asked our climbers about their experiences with K C S Pvt Ltd: