I am a very highly qualified computer science researcher with a Doctorate degree,9+years of experience as an MSSQL Server DBA|Developer.
• Database : SQL Server 2019,2016,Oracle12c/11g/10g/9i/8.1, MongoDB
and MS Access.
• Database Tools: PL*SQL, SQL*Loader, Oracle Forms.
• ETL Tools: SQL Server Integration Services (SSIS), SSAS,Power Bi,Pivot tables
• Data Visualization/Reporting Tools: POWER BI, Crystal Reports, Oracle Reports, SSRS
• Languages: SQL, PL/SQL, C, C++, COBOL, FORTRAN, and UNIX Shell
• Front-End Tools: Oracle Enterprise Manager, Forms Builder, Schema Builder,
I am proficient in ASP .net webdevelopment
I am a very dedicated IT professional, complete every project in time and budget.
• Writing complex SQL queries according to business requirement, schedule backup and restore
• Monitoring databases and query performances by using query store, extended events.
• Experience in SSIS ETL technology using T-SQL, MS-Access, and MS-Excel.
• Perform tuning and operational troubleshooting Responsible for ensuring that the technical output of the Data Engineers
conforms to best practices and standards
MSSQL SSIS developer
Times BPO Services, Delhi India
Jan 2004 - Apr 2013 (9 years, 3 months)
• Developing packages and stored procedures using PL/SQL.
• Extensively used stored procedures, functions, and database triggers.
• Responsible for understanding, changes in business functionalities, add new elements in tables, and accordingly
enhancing PL/SQL stored procedures and triggers.
• Responsible for performing quality assurance, data analysis, and unit testing.
• Remained on call for 24x7 to support scheduled jobs in production data warehouses
Jai Shree Enterprises
Mar 2000 - Jun 2003 (3 years, 3 months)
Receiving and processing all invoices, expense forms, and requests for payments. Handling petty cash, preparing bills and receipts. Maintaining accounting records, making copies, filing documents, etc. Thorough with statutory compliance of deducted and collected taxes viz Service Tax, TDS, Profession tax.
Doctor in Philosophy (PHD) in computer science
University of Rajasthan, India 2010 - 2015
Masters In Library and information Science(MLIS)
Indira Gandhi National Open University, India 2004 - 2005
Masters In computer Science (MCA)
Indira Gandhi National Open University, India 2001 - 2003
T-Sql Query language
Microsoft certification in a T-SQL query language
Oracle Certified professional (OCP)
certified by oracle in development work.
Column-Oriented Databases to Gain High Performance for Data Warehouse System
International Journal of Advancements in Research & Technology
Column-oriented database systems, also known as column-stores, have an important demand in the
past few years. Basically, it is about storing each database column separately so that the attributes
belonging to the same column would be stored contiguously, compressed and densely-packed in