Ankit Khetan Email & Phone Number

Remote First, Us

Redwood City, California, Us

Redwood City, California, Us

West Palm Beach, Florida, Us

West Palm Beach, Florida, Us

Database: Microsoft SQL Server 2012Project: Lending Space –Mortgage Application.• Implemented Transational Replication from Production database Database and performed al lthe maintenance on it.• Implemented Indexing techniques to enhance the performance of Replication Database.• Designed/Maintained Reports Database from Replication database which consists of only the information which needs for SSRS Reporting.• Implemented SQL procedures/triggers to update Reports Database from Replication Database every hour with the help of SQL Jobs.• Implemented SQL Procedures to flush the Reports database overnight and populate it with a fresh copy from Replication Database.• Automated 5 different Compliance Audits Excel Files by programming them to automatically export different reports using Macros/VBA.• Worked on Solar Winds Software to monitor the performance of a database and Optimize queries which were detected heavy by Solar winds.• Automated the process of Division/Team transfers of an Account Executive by integrating HR Data from third Party application to a SQL table and trigger appropriate division transfer scripts.• Was appreciated and received recognition for my excellent work ethics.

• Developed Feature Enhancement to the existing Website using C#, Silverlight and Microsoft SQL Server 2012.• Created/debugged Store Procedures, Views, Functions, Tables, Triggers and Cursors using Microsoft SQL server 2012 to retrieve/update data effectively.• Optimized and enhanced the existing procedures and SQL statements for the better performance.• Created Database diagrams for better understanding of the tables and their Primary keys.• Create Inspection reports using SSRS and output relevant data as required by the user.• Creating SSRS Reports for presenting huge amount of the data systematically in SSRS. • Extensive communication with business users for requirements.• Presented the whole product “Asset Management System” to one of our client with demo and managed the whole project.• Worked on a small C# project to read the data from a CSV file and manipulated it with user’s requirements.• Responsible for testing the website manually. • Involved in backup and recovery procedures, refreshing databases and setting up new databases for different clients.

Cleveland, Oh, Us

• Developed feature enhancement to the existing website using C# .net and Microsoft SQL Server 2008.• Created Store Procedures, Functions, Triggers and Tables using Microsoft SQL server 2008 to retrieve data effectively. • Created Database diagrams for better understanding of the tables and their Primary keys.• Used Telerik – ASP.net for Ajax for displaying grids, calendar items etc.• Technology used includes C#, asp.net, .Net Framework 3.0, Microsoft SQL server and SSRS.• Responsible for testing the website by creating different test cases.• Responsible for solving the errors/bugs depending on the tickets raised by product managers.

Cleveland, Ohio, Us

• Troubleshooting technical problems of several computers and fix them.• Replaced Hard Drives, Power Supply, CD drives, Ram in case of not working.• Formatted computer hard drives, installed operating system and other required software.• Conducted virus healing activities, update software and perform weekly maintenance of the systems of 3 different labs.• Created a Database for all the systems and their passwords.• Created a system to capture the problem and record the last fix applied on the computer.

Cleveland, Ohio, Us