Talent's Information
-
Location
Bengaluru, India
-
Rate
$11.0 per Hour
-
Experience
8 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About Pramod
Total 8 Years of hands on experience on database developer and Application support
4.5 years Databasedeveloper and Programming (Oracle, Mysql, Sqlserver 2000, 2005, 2008,postgres)
3.5 years application support to US client and Maintenance of IT systems and solutions:
Extensively worked on database areas like Database queries, Triggers, Cursors, Stored procedure,Functions and hotbackup,coldbackup,ER-diagram, Performance Tuning,Installation of Sql Server,Managing SQL Server Database security, Managing data file size.
Having extensive knowledge in optimization of SQL queries and data migration
Tech Stack Expertise
-
Microsoft SQL Server
Microsoft SQL Server 2016
1 Years -
Java
Java,Core Java
3 Years -
HTML
HTML
2 Years -
Oracle
Oracle 9I
3 Years
Work Experience
Data Engineer
- January 2011 - January 2023 - 12 Year
- India
Projects
Case Information System
- January 2012 - January 2013 - 13 Months
Technologies
Role & Responsibility
-
The project has been conceptualized on the basis of the “National Policy and Action Plan for Implementation of Information and Communication Technology in the Indian Judiciary-2005” by the eCommittee of the Supreme Court of India. ... The project is being implemented by National Informatics Centre (NIC)
The purpose of the system is to streamline the information regarding pending trial cases and to provide various operational and management reports. There are many individuals associated with the case such as investigators, accused, witnesses etc
Close monitoring of PT cases for their speedy disposal and securing conviction.
(ii) Data sharing with other modules to avoid duplicity of data entry.
(iii) To reduce the man power utilization (iv) Tracking of case information online
Roles and Responsibilities:
Database design,
Database maintenance and all query
Tools Used: Microsoft Visio Version 2003
Performance Tuning.
Writing query report query,procedure, trigger ,function ,cursor
Application support
Database Testing.
Database design
Daily Back Up & recovery
response time of executed queries.
Commom Database And E-auction.
- January 2014 - January 2015 - 13 Months
Technologies
Role & Responsibility
-
Common Database is a repository for data storage. It is a global database where all the necessary data will be stored in a common format, that are collected from all other various databases used in 4 different departments i.e. ORMAS, OSEM, SUDA and OSFDC through Web Services.
ORMAS (Odisha Rural Development and Marketing Society)--->Keeps the record of BPL Candidates
OSEM(Odisha State Employment Mission)--->Common database to store all candidate’s information
SUDA(State Urban Development Agency--->Keeps the record of URBAN Candidates
OSFDC (Odisha Scheduled Castes and Scheduled Tribes Development Finance Co-operative Corporation Limited)--->Keeps the record of SC/ST Candidates
The purpose of the project is to develop a robust application along with a Common Database where its main aim is to merge all data across the departments i.e. ORMAS, OSEM, SUDA, OSFDC and store the information into a single common database through Web Services. The whole process is maintained in an online automated Database, which will be helpful to get the employment and unemployment status of the state. Each training activity maintained in a system database not for public but official use to run and monitor several training programs simultaneously
Roles and Responsibilities:
Database design,
Database maintenance and all query
Tools Used: Microsoft Visio Version 2003
Performance Tuning.
Writing query report query,procedure, trigger ,function ,cursor
Application support
Database Testing.
Database design
Daily Back Up & recovery
response time of executed queries.
Tock By Clockware 4.4 And 4.5
- January 2016 - January 2017 - 13 Months
Technologies
Role & Responsibility
-
Tock 4.5 is the latest version of Tock, after Tock4.4.This web biased software can handle by two type of customers one is ASP another is License, ASP customers they will just use the particular product through Internet, their Database server and application server is handle by company itself who have developed and giving support. License customer they provide license for user basis and they will use the software. In that particular software there is one admin who can create users, timesheets, Work item, Work Attribute, Group and assigning them to particular users, group. There users can login as admin, normal users, supervisor, Timekeeper, project manager, and submit their timesheet on daily ,weekly, monthly, semimonthly ,Biweekly basis. Also can run their report as their criteria.
In Tock4.5 there two extra module integrated one is expanse another is accruals; users submit their expanse and accruals and also can run the report.
There is the change of look and field issue on Tock4.5 to create it is more attractive to see and handle.
Roles and Responsibilities:
Design and deploy best practices in IT processes
Database design, Drawing ER Diagram with maintaining versions of the same.
Database script creation & SQL statements written for absence entry & display modules.
Tools Used: Microsoft Visio Version 2003
Database maintenance and all query
Daily Back Up & recovery management –online & offline backups
Database transaction monitoring (Maximum) & performance tuning of database by tracking
response time of executed queries.
Application Testing.
Providing 24*7 supports for mission critical production Sql databases.
Installation of Sql Server manually
Providing High availability support and solution for critical databases.
Worked on Different Migration Project.
Performance Tuning.
Report Design and deployment.
Writing query report query,procedure, trigger ,function ,cursor
116 Stations
- January 2019 - January 2020 - 13 Months
Technologies
Role & Responsibility
-
116Station Classified project, which is developed for various Users who can sell their product through application, and buy the product through the application. There is option for seller who will upload their product for sell also option for customers who can search the product and fix their price by bargaining and can buy their needful things. Also Users can give their massage about the item and also users can view the latest 10 massages by mouse over.
Roles and Responsibilities:
Database design, Drawing ER Diagram with maintaining versions of the same.
Database script creation & Sql statements written for absence entry & display modules.
Tools Used: Microsoft Visio Version 2003
Database maintenance and all query
Daily Back Up & recovery management –online & offline backups
Database transaction monitoring (Maximum) & performance tuning of database by tracking response time of executed queries.
Installation of Sql Server manually
Providing High availability support and solution for critical databases.
Providing Disaster recovery plain and support(Mirroring, Log Shipping)
Worked on Different Migration Project.
Performance Tuning.
Writing query report query,procedure, trigger ,function ,cursor
.
Absence Management System (AMS)
- January 2020 - January 2021 - 13 Months
Technologies
Role & Responsibility
-
Absence Management is the module that tracks all absence-related activities and maintains the corresponding balances of users
Entitlements are created with respect to (certified leave/ uncertified leave)types created in balance section
Entitlements are assigned to groups
In groups users are there
Each user is assigned with the leave types(certified leave / uncertified leave) for absence related entry
User does entry for certified leave/ uncertified leave for the partial day or full day of the absence
In case user has not submitted it can be submitted by the timekeeper
When absence is submitted It goes to respective approver
Approver can either approve or reject the absence entered to the system
Balance engine calculates remaining balance, FMLA eligibility for the pay period
Remaining balance & FMLA calculated in the balance engine displayed in the reports
Roles and Responsibilities:
Database design,
Database script creation & Sql statements written for absence entry & display modules.
Tools Used: Microsoft Visio Version 2003
Database maintenance and all query
Daily Back Up & recovery management –online & offline backups
Database transaction monitoring (Maximum) & performance tuning of database by tracking
Application Testing.
Providing 24*7 supports for mission critical production Sql databases.
Installation of Sql Server manually
Providing High availability support and solution for critical databases.
Performance Tuning.
Report Design and deployment.
Writing query report query,procedure, trigger ,function ,curso
Soft Skills
Industry Expertise
Education
in MCA
Bengaluru University- June 2004 - June 2007
