Dhruv كالاريا

o Managed project resources, progress, completion timeframes, and budget while exceeding key operational performance targets.
o Teamed with product development/product management to integrate data into new products that increased revenue and customer satisfaction.
o Participates in the scoping of proposed enhancements, and works with Product Managers to turn business requirements into actionable developer specifications.
o Write optimized Queries, Stored Procedures, Batch Files, Reports (SQL or Excel), VB scripts and T-SQL scripts to maintain integrity of the data from different servers and large databases.
o Writing specification for the software and communicate with system development team with new requirements and responsible for the system and associated subsystems. Provide system-level support of multi-user systems.
o Provides training, technical and functional support, and develops and maintains procedures.

1. Content Manager (SNL Financial) www.SNL.com) (Feb - 2012 To Current)

Responsible for the accuracy, completeness, and timeliness of data published in SNL products for the information tracked by the respective department. Maintains a high level of subject matter expertise related to content set, including knowledge of internal applications and external products. Develops and supervises departmental goals and projects. Assists Associate Directors and Directors with cross-departmental initiatives while also communicating status reports on their own departments

➢ Participates in the scoping of proposed enhancements, and works with Product Managers, or other Project Managers to turn business requirements into actionable developer specifications

➢ Write optimized Queries, Stored Procedures, Batch Files, Reports (SQL or Excel), VB scripts and T-SQL scripts to maintain integrity of the data from different servers and large databases. Experience of working for 3 different kinds of industries which include (Energy, Bank Regulatory, Statutory Insurance)

➢ Oversees or works independently to provide for data transformation, testing, troubleshooting, and end-user support needs.

➢ Writing specification for the software and communicate with system development team with new requirements and responsible for the system and associated subsystems. Provide system-level support of multi-user systems.

➢ Provides training, technical and functional support, and develops and maintains procedures.

2. Systems Analyst (SNL Financial) (Dec - 2009 To Feb - 2012)
Maintaining current operation of Bank Regulatory Financial Content, and communicate with global offices for departments regular updates. Also responsible to Train the new Data Analyst in department. Also performing regular data analyst duties.

3. Data Analyst (SNL Financial) (Aug - 2008 To Nov - 2009)
Responsible for gathering source electronic information from primary sources as soon as they are available. Analyzes, manipulates, and loads data to back end structures. Researches and corrects data errors. Creates and documents processing procedures. Works with Business Systems Analysts and Managers (located in global offices) to improve collection operations. Communicates with stakeholders on status of projects and daily operations to the global offices. Creating VBScripts and SQL Stored Procedures to correct data. Responsible for the quality of Output of the automated data.

1. Bank Regulatory Data Processing Revamp
Project is being performed on Agile methodology TFS Microsoft. Mainly it is a complete reorganization of Bank Reg Data processing using tools like flex grid and SQL Server 2008. Project is being done in SNL Financial.

2. Website Scraper: (Made for SNL Financial and for company use only)
Using SQL Server 2005 and VBScripting tools this project was made, . Particularly purpose was to make SNL Energy database updated on daily/weekly basis. As soon as data get publish on source website, this script was fetching data from that source website and give that data in desired format.
Tools: VBScript, SQL Server, XML, Excel

3. Columbia Books & Information Services (MCA Semester - VI)
www.columbiabooks.com
This project was developed in Ace Infoway as a trainee for 3 months.
Front End: ASP.NET with C#
Back End: SQL Server 2005

4. Real Estate Online (MCA Semester - VI)
Front End: ASP.NET with C#
Back End: SQL Server 2005

5. Project Management System (MCA Semester - V)
System especially for IT companies to facilitate better communication with client. Clients can check their project status & schedule online and the same way company can update it online. It also provides Internal Messaging System.
Front End: ASP.NET with C#
Back End: SQL Server 2005

6. Super Market Management System (MCA Semester - III)
To maintain inventory of supermarket store. Especially it involves sales & purchase transaction & bill generations.
Front End: Visual Basic 6.0
Back End: Oracle 8i

7. Video Library Management System (MCA Sem-III)
Front End: ASP Back End: Ms Access 2003