RESUME
Rudrapathy S Mobile: +91-637*******
EMail: ac7wj2@r.postjobfree.com
OBJECTIVE
To pursue a highly rewarding career, seeking for a job in challenging and healthy work environment where I can utilize my skills and knowledge efficiently for organizational growth.
SUMMARY OF QUALIFICATIONS
An experienced IT professional with Masters of Computer Science, Strong technical background with 7 years of Technical Support and solid project experience in SQL Server.
The core role was to keep the applications up 24/7 and to be in touch with administrators and users to help them and to resolve server and application related issues.
Check email Alerts, Notification mails and any tickets in queue with their priority
If any jobs running for longer time. Check why stored procedure/jobs are taking lot of time to run.
Work on all issues related to database and Unix scripts
Experience in Creation of Tables, Triggers, Views, Indexes.
Excellent SQL skills, experience writing complex queries and working with database objects (i.e. tables / views etc.)
Experience with basic commands of Unix/Linux.
Involved in the preparation & planning of incident, risk and change management procedural documentation for clients.
Understanding and Troubleshooting complex customer issues on production environment.
Responsible for identifying any bugs occurring in the applications as well as fixing them
Plan and coordinate production engineering processes on daily basis to produce high quality products.
Evaluate current production activities and make recommendations for improvements.
Perform engineering analysis to reduce downtime and outages.
Investigate problems, analyze root causes and derive resolutions.
As a Shift Leader in my team, providing knowledge transfer to my team members of new projects developed in Dot Net and SQL Server.
Having Strong Knowledge in writing stored procedures.
Good team player with a synergistic approach and effective communication skills.
Responsibilities:
Checking email Alerts, Notification mails and any tickets in queue with their priority.
Work on all issues related to database and Unix scripts.
Maintained SQL scripts, indexes and complex queries for analysis and extraction.
Performed quality testing and assurance for SQL servers.
Carrying out database tuning activities to ensure optimal performance.
Worked with stakeholders, developers and production teams across units to identify business needs and solution options.
Ensured best practice application to maintain security and integrity of data.
Maintain, update and monitor the existing database on daily basis.
Perform regular reviews of the database to identify performance problems and data duplication problems.
As a Shift Lead,
Directing employees through their daily routines.
Planning in detail for each shift.
Providing leadership to a team during a shift.
Being involved in and contributing to team meetings.
Making sure that all staff have the basic skills training needed to perform their jobs.
Motivating staff to deliver better results.
Academic details
Year of Passing
Course
Institution
2009
MCA
Krishnasamy College of Engineering and Technology,Cuddalore.
2005
B.Sc. (Industrial Electronics)
E.G.S.Pillai College of Arts and Science, Nagapattinam.
2002
12th
C.S.I.HR.SEC.School, Nagapattinam.
2000
10th
C.S.I.HR.SEC.School, Nagapattinam.
WORK EXPERIENCE
Working as a Senior System Analyst -> Technical Lead in SourceHOV (HOV Services), Chennai, from March 2013 to till Date.
Worked as a Software Engineer for 6 months in Smartek India, Chennai from Apr 2012 to Oct 2012.
Worked as a Software Engineer for 2.6 years in colizeeum Technologies, Chennai from July 2009 to March 2012
TECHNICAL EXPERTISE
Languages : SQL, Unix
Databases : SQL SERVER
Other Tools : Putty, FileZilla, vi Editor
Domain : Healthcare Insurance and Non HealthCare and Banking Projects
PROJECTS PROFILE
PROJECT PROFILE: #1
Project Title
Progressive
Client
Progressive health services
Database
MS SQL Server 2008, Web service
DESCRIPTION
Progressive has been in business since 1937 and currently is the third-largest auto insurance group in the United States. They have more than 10 million policies in force, and growth continues as more people choose us for their vehicle insurance needs. Progressive sells insurance directly to customers online and by phone, and also offers insurance through more than 30,000 local independent agents.
Client’s EFF System and to distribute claimants or policyholders' medical bills to a separate feed to a Mitchell Medical database hosted at Client. Medical bills will be scanned and key data fields will be turned into an XML file format that can be ingested by a Mitchell Medical database.
PROJECT PROFILE: #2
Project Title
Anthem West & Central & Denver
Client
Anthem
Database
MS SQL Server 2008
DESCRIPTION
Anthem, Inc. is an American health insurance company founded in the 1940s, prior to 2014 known as WellPoint, Inc. It is the largest for-profit managed health care company in the Blue Cross and Blue Shield Association. It was formed when Anthem Insurance Company acquired WellPoint Health Networks, Inc., with the combined company adopting the name WellPoint, Inc.; trading on the NYSE for the combined company began under the WLP symbol on December 1, 2004. On December 3, 2014, WellPoint changed its corporate name to Anthem Inc., and its NYSE ticker changed from WLP to ANTM.
PROJECT PROFILE: #2
Project Title
Bank of America
Client
BOA
Database
MS SQL Server 2008
DESCRIPTION
Bank of America Corporation (abbreviated as BofA)[4] is an American multinational financial services company headquartered in Charlotte, North Carolina. It is ranked 2nd on the list of largest banks in the United States by assets.[5] As of 2016, Bank of America was the 26th largest company in the United States by total revenue. In 2016, it was ranked #11 on the Forbes Magazine Global 2000 list of largest companies in the world
OTHER projects handled:
oOVATION
oOPTUM360
oLIBERTY MUTUAL
oOPTUM MOUNTAIN WEST
oTRINITY HEALTH
oACCENTURE TEXAS
PERSONAL DETAILS
Date of Birth : 26th August 1984
Marital Status : Married
Languages Known : English and Tamil.