Customer Service Project
Resume:
Sagar Hinge
Rajmata CHS, Building No-M*, Room No-19, Kashish Park, LBS road, Thane 400604.
Mobile - +91-966*******
eMail: **********@*****.***
**********@*****.***
Objective:
Seeking a challenging and growth oriented career where I can utilize my skills and training to the maximum, with the opportunity for professional growth and to excel by contributing towards the achievement of organizational goals.
Profile Summary:
1. Completed BE-CSE from Shivaji University Kolhapur (Maharashtra)
2. About 1 year 6 months of experience.
3. Knowledge of SQL,T-SQL,SSIS,PLSQL,SSRS.
Skills:
1. Very quick on grasping requirements and delivering modules to meet them with minimal supervision.
2. Adaptable to a variety of technologies like SQL, T-SQL, Oracle, Microsoft SQL Server 2008, SSIS without taking much time to switch between them.
3. Makes conscious efforts to follow and improve the process and ensure quality of the software by following coding standards and guidelines.
4. Participates in knowledge sharing sessions to understand the new technology and requirements.
5. Possess the Problem Analysis skills to understand the existing framework and modules to solve the defects in them.
6. Works as a team player to alleviate pressure on the fellow team members by assisting them in their problems.
Skill Set:
Skill Set
Description
Operating Systems
Windows, Unix
Programming Languages
T-SQL, PLSQL,SSIS
DB
Oracle10g,Microsoft SQL Server 2008
Work Experience Details :
Organization: Inube Software, Bangalore
Designation: SQL developer Period: Jun 2012 till date
Project Name
:
Portal(General Insurance )
Team Size
:
3
Location
:
Reliance General Insurance Pvt. Ltd, Mumbai
Environment
:
Windows
Technology used
Project Duration :
:
T-SQL,SSIS
9 months
Description
:
(RGICL) is one of the leading non-life insurers in India. RGICL expands its reach to its customers (retail and Corporate), Business Partners (Agents, Brokers, Business Partners), Service Providers (Surveyors, Hospitals, Garages, etc.) by enabling a world class ‘Service Delivery Portal’. RGICL provides Servicing policies for both Pre-Underwritten and Underwritten products like Motors, Health, Travel, Personal accident, Home, Shopkeeper’s policy, and Student care policy. Portal is the one of the web application which is already developed in 2009.Right now we are working on enhancing and maintaining the application as per underwriter requirement.
Role
:
1. Creating SQL Stored Procedures, Functions, Triggers.
2. Creating Packages, Object Data types.
3. To solving the issue /problem of Branches and Region while issuing policies.
4. Fetching reports of agent and brokers.
5. Creating SQL scripts.
6. Creating SSIS packages
Organization: Reliance Communications Pvt. Ltd
Designation: Trainee Engineer Period: July 2011 – May 2012
Projects and Technical Exposure:
Project Name
:
Order Management System
Client
:
Reliance Communications
Team Size
:
6
Location
:
DAKC., Mumbai
Environment
:
Windows
Technology used
:
Oracle,Unix
Description
:
Order Processing is to provide automated end to end to Order Management process for Enterprise customers. Activities involved in Order Management to Create Customer and Services for the customer for the Wire line Range of Products POTS,PBX, IPVPN_L3, DEDICATED_INTERNET, ISDN, etc). Uploading the Order file in XML format received from the Central File Server after it has been processed by different System Servers (such as Selectica, Clarify server, Clarity server, ADC (Billing), OMS server and sent for reconciliation in Sap ERP/3 Database. The xml File is been decomposed into different sections such as Customer Profile, Location details Service Details. Stored Procedures written in each section is run and if properly decomposed and the order xml file is then send to the Network Provisioning System Clarity (OSS).
Role
:
. Developing and updating PL/SQL as per the requirements of the System
Customer service activation, number change, service cancellation, Suspension, resumption etc in billing system by uploading the csv (comma separated value) file through FTP
Scheduling the tasks and jobs in Singleview for creating new customer, updating exiting customer profile as per customer request
Project Name
:
BulkSMS
Client
:
Reliance Communications
Team Size
:
4
Location
:
DAKC., Mumbai
Environment
:
Unix
Technology used
:
Oracle,Unix
Description
:
Basically pushing the Bulk messages on reliance Bulk handlers PUTTY (based on UNIX through).
Role
:
1. End-to-end process of Bulk SMS handling
2. SMS Servers involved to process the SMS relay
3. Guidelines for NNOC followed for SMS relay
4. Teams involved at various levels of SMS process workflow
5. Retrieving data from FTP
6. Uploading the database on the server
7. Truncating the temporary database
8. Checking the correctness of the database.
9. Maintaining the records of database
10. Fragmenting the database
11. Backup and if needed restoration of data
Education Qualification:
B.E. (CSE), from Shivaji University Kolhapur, Maharashtra with 62 % (2008-11).
Diploma in Computer Engineering, from MSBTE Mumbai, Maharashtra with 69% (2005-08) .
S.S.C., from Maharashtra State Board, Maharashtra with 78 % (2005).
Personal details:
Gender : Male
Marital Status : Single
Date of Birth : 11th March 1989
Nationality : Indian
Language Known : English, Marathi, Hindi
Declaration:
I hereby declare that the information furnished above is true to the best of my knowledge and belief.
Place: Thane.
Mr. Sagar Hinge
Sagar Hinge **********@*****.***
Contact this candidate