MS SQL Developer
Resume:
M.Rajarajan B.Tech
********@*****.*** Resume
Mobile No: +91-994*******
Objective:
Seeking a challenging career with a progressive organization which will utilize my skills, abilities and experiences, and provide me with opportunities to grow and develop with the organization. Professional Summary:
Good experience in relational database like MS SQL Server
Around 6 years of experience in querying MS SQL Server 2012/2008R2/2008/2005.
Experience in T-SQL programming for writing DDL and DML queries, stored procedures, user-defined functions, Triggers, Cursors and Views.
Experience in Performance tuning by optimizing queries, checking execution plans and proper usage of indexes in SQL.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server using Import/Export Wizard and BULK INSERT.
Good exposure to Database backup, restore and Job scheduling.
Have exposure in building web application using .Net 4 Framework
Around 3 years of experience in supporting VB.NET and C# programming technologies.
Experience in creating reports using Crystal Reports
Experience in version control tool VSS.
Good in Internet technologies like HTML etc.
Good communication, interpersonal, multi-tasking and problem-solving skills.
Has been exposed to the entire Project development life cycle, which includes Analysis, Design, Coding, and Testing
Work Experience:
Employed and worked as a System Analyst for 4 Years and worked as a Senior Executive for 4.1 Years in MM Imagine Technologies Pvt Ltd (From 1st December 2010 to 31st December 2018).
Employed and working as a Developer for 2.4 Years in ESAB India Ltd (From 2nd January 2019 to Till Date).
Project History:
Company Name Project Project Details
MM Imagine Technologies Costco Costco is one of the biggest Pharmacies in U.S.A. They send information of claims and checks; we receive payment from various insurance payers. We import all data into the database and reconcile claims with payments and payments with checks. Weekly once we send report to the client, also we show claims, payments and checks information in the website.
MM Imagine Technologies Practice Tracker™ It is complete practice management software on the cloud, fully certified for Electronic Health Record (EHR) and Meaningful Use
ESAB India Limited Infor® M3 Infor® M3 is a cloud-based, manufacturing and distribution ERP system. Develop customized application to fulfill organization needs.
Technical Skills:
Certification:
Microsoft certified professional in Querying Microsoft SQL Server 2012 Project Profile:
1. Costco
Costco is one of the biggest Pharmacies in U.S.A. They send information of claims and checks; we receive payment from various Insurance companies. We import all data into our database and reconcile claims with payments and payments with checks. Weekly once we send report to the client, also we show claims, payments and checks information in the website. Project Responsibilities include:
Processing all claim, payment and check files.
Database backup and restore
Perform the manual testing and verifying data
Investigate non recon claims, payments and checks
Follow up with medical insurance payers regarding the status of outstanding claims.
Adhere to HIPAA compliance.
Data Archival
Use of Sql queries and Joins.
Technologies: SQL Server 2008
2. Practice Tracker
It is a web Application project, allow you to record patient data in pre-defined templates, access it on demand, and export if necessary. This is in addition to features that help you manage your practice like appointments, billing, claims, reports and more. Software
Operating System Windows 2000 professional, Windows XP professional, Windows 7, 8, 10
Programming Languages ASP.Net, VB.Net, C#
Database Skill Microsoft SQL Server 2012, DBA(Basics) IDE Visual Studio 2015
Version Control Microsoft Visual Source Safe 2005
Web-Specific Skill HTML
Scripting Language jQuery, JavaScript
Style sheet CSS
Other Skills Microsoft Office
Project Responsibilities include:
Develop .Net Application using VB.NET and C#
Use of Sql queries, Joins, Views, Triggers and Stored procedures
Performance tuning by optimizing SQL queries and checking execution plans
Developing reports using Crystal Reports
Perform Testing after development.
Generate reports (Patient appointment, treatment, billing, claim details). Technologies: .Net Framework 3.5, VB.NET, C#, SQL Server 2005 Report Tool: Dev Express controls, Microsoft Report Viewer, Crystal Report Viewer. 3. Infor M3
It is an industry standard ERP application, allow to record data based on business requirements. We develop customized external application and reports, that suits business needs and involves complexity in ERP.
Project Responsibilities include:
Develop .Net Application using VB.NET and C#
Use of SQL queries, Joins, Views, Triggers and Stored procedures
Experience in Database Designing for new applications and database changes to existing applications
Developing reports using Crystal Reports
Perform Testing after development.
Technologies: .Net Framework 4, VB.NET, C#, SQL Server 2012 Report Tool: Crystal Report Viewer.
Strength:
Good communication skill
Capable of Accepting Responsibility
Willingness
Ability to Learn
Educational Details:
Degree INSTITUTION YEAR OF PASSING Percentage
B. TECH - CSE SRM University 2013 79.58%
Diploma in CSE I.R.T Polytechnic College, Chrompet, Chennai
2008 88.38%
SSLC PSBB metric. Hr., Sec., School, Mangadu,
Chennai
2005 72.63%
Personal Details:
Name : M.Rajarajan
Birth Date : 14th July 1990
Nationality : Indian
Father Name : P.Manogharan
Mother Name : M.Shanthi
Current Address : No 33, Sadaiyandeeswaran Koil Street, Kundrathur,
Chennai 69.
Permanent Address : No 33, Sadaiyandeeswaran Koil Street, Kundrathur,
Chennai 69.
E-mail : ********@*****.***
Gender : Male
Language Known : English, Tamil
Phone no : 994*******
Declaration:
I wish to confirm that the above given information is true. I will be happy to extend further references of all above on request.
Place: Chennai Signature,
Date: (M.Rajarajan)
Contact this candidate