ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

YUVARAJ_SQL

•Download as DOC, PDF•
•
A
Ac Yuvaraj

This document is a resume for Yuvaraj C which provides his contact information, professional summary, education details, technical skills, and work experience. The professional summary highlights over 2 years of experience in SQL Server development and data warehousing. It also details skills in designing reports using SQL Server Reporting Services, creating views, functions, and indexes in SQL, and proficiency in SQL Server 2008/2012. The resume describes work as a SQL developer for TIAA-CREF from 2014-2016 where responsibilities included developing stored procedures and views, using indexes to improve performance, providing support for MSBI reports and cubes, and performing testing, debugging, and production support.

1 of 3
Download to read offline
YUVARAJ C Phone No: +91 9677175911 E-mail: yuvarajac01@gmail.com PROFESSIONAL SUMMARY • Energetic and goal oriented professional 2 years of experience in SQL Server development and Data Warehousing. • Deploying applications from one environment to other (such as development to testing). • Skilled in designing report solution using Microsoft SQL Server Reporting Services. • Hands-on experience in creating Views, Functions, Cursors, Index. • Proficient in implementing the change Request received from Client in a short span. • Well versed in understanding the business flow and functionality of the Projects. • Worked in different roles as a developer, tester and reviewer. • Strong analytical, communication and problem-solving skills. • Involved in Business Analysis of the OLTP and OLAP data and in decision support. • Experience in T-SQL programming in developing Tables, Stored Procedures, Views, Indexes, functions, CTEs. • Experience in ETL development & Support and issue fixing. • Good understanding of Insurance Domain. Analyzing of SQL Queries to improve the performance and minimizing execution time. • Strong understanding of SDLC and experience working as part of development and Quality Assurance Teams. • Proficient in understanding business processes / requirements and translating them into technical requirements. • Extensive experience in SQL Server 2008R2/2012 . Education • M.E in Power Systems with aggregate of 7.5 CGPA from B.S. Abdur Rahman University, Chennai, T.N, India. Technical Skills: Operating Systems: Windows XP, Windows 7 Languages: T-SQL, PL/SQL Databases: SQL Server 2008, SQL Server 2008R2/SQL Server 2012, Oracle 11g Professional Experience • Working as Software Engineer in HCL Technologies Chennai through Bhilwara technology, since 2014 November. Project Profile:
Project 1 : TIAA-CREF Role : SQL Developer Duration : Nov 2014 to July 2016 Environment : SQL Server 2008 Description TIAA–CREF is a Fortune 100 financial services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. ReconNET is a reconciliation package used by finance and actuarial to provide business with a means of ensuring the integrity and accuracy of the financial transactions which flow from various pension applications and the corresponding transactions on the ledgering system. ReconNET is also used as a tool for identifying discrepancies and recording the variances for business to research and remediate. Responsibilities: • Developed queries by creating Stored Procedures and Views in SQL Server 2008 database. • Used Non-clustered Index to improve query performance. • Used Cursors in Stored Procedures. • Providing support to customers for the existing MSBI reports and Cube. • Fixing the defects raised in HPQC by the customer and application team. • To develop error free queries satisfying the customers. • Involved in performance tuning and Optimization. • Involved in Unit Testing and Functional Testing. • Extensively used SQL Server database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts. Written several complex SQL queries for data verification and data quality checks. • Experience in 24X7 production support, ETL executions and resolving root causes. • Job Monitoring, identifying discrepancies and recording the variances for business to research and remediate. • Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs. • Understanding tasks that need to be completed and approximate time required to complete tasks. • Interaction with the clients for each release and providing proper information regarding the objects delivered. • Working with client to prioritize the objects to be delivered in the next release. Personal Details: Name : Yuvaraj C Date of Birth : 01-Jun-1988 Alternate Mobile No : +91 8610232034 Alternate Email ID : yuvarajac88@gmail.com Current Employer : HCL technologies, Chennai
Current Location : Chennai Preferred Location : Chennai, Bengaluru Languages Known : English, Tamil, and Telugu.

More Related Content

YUVARAJ_SQL

  • 1. YUVARAJ C Phone No: +91 9677175911 E-mail: yuvarajac01@gmail.com PROFESSIONAL SUMMARY • Energetic and goal oriented professional 2 years of experience in SQL Server development and Data Warehousing. • Deploying applications from one environment to other (such as development to testing). • Skilled in designing report solution using Microsoft SQL Server Reporting Services. • Hands-on experience in creating Views, Functions, Cursors, Index. • Proficient in implementing the change Request received from Client in a short span. • Well versed in understanding the business flow and functionality of the Projects. • Worked in different roles as a developer, tester and reviewer. • Strong analytical, communication and problem-solving skills. • Involved in Business Analysis of the OLTP and OLAP data and in decision support. • Experience in T-SQL programming in developing Tables, Stored Procedures, Views, Indexes, functions, CTEs. • Experience in ETL development & Support and issue fixing. • Good understanding of Insurance Domain. Analyzing of SQL Queries to improve the performance and minimizing execution time. • Strong understanding of SDLC and experience working as part of development and Quality Assurance Teams. • Proficient in understanding business processes / requirements and translating them into technical requirements. • Extensive experience in SQL Server 2008R2/2012 . Education • M.E in Power Systems with aggregate of 7.5 CGPA from B.S. Abdur Rahman University, Chennai, T.N, India. Technical Skills: Operating Systems: Windows XP, Windows 7 Languages: T-SQL, PL/SQL Databases: SQL Server 2008, SQL Server 2008R2/SQL Server 2012, Oracle 11g Professional Experience • Working as Software Engineer in HCL Technologies Chennai through Bhilwara technology, since 2014 November. Project Profile:
  • 2. Project 1 : TIAA-CREF Role : SQL Developer Duration : Nov 2014 to July 2016 Environment : SQL Server 2008 Description TIAA–CREF is a Fortune 100 financial services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. ReconNET is a reconciliation package used by finance and actuarial to provide business with a means of ensuring the integrity and accuracy of the financial transactions which flow from various pension applications and the corresponding transactions on the ledgering system. ReconNET is also used as a tool for identifying discrepancies and recording the variances for business to research and remediate. Responsibilities: • Developed queries by creating Stored Procedures and Views in SQL Server 2008 database. • Used Non-clustered Index to improve query performance. • Used Cursors in Stored Procedures. • Providing support to customers for the existing MSBI reports and Cube. • Fixing the defects raised in HPQC by the customer and application team. • To develop error free queries satisfying the customers. • Involved in performance tuning and Optimization. • Involved in Unit Testing and Functional Testing. • Extensively used SQL Server database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts. Written several complex SQL queries for data verification and data quality checks. • Experience in 24X7 production support, ETL executions and resolving root causes. • Job Monitoring, identifying discrepancies and recording the variances for business to research and remediate. • Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs. • Understanding tasks that need to be completed and approximate time required to complete tasks. • Interaction with the clients for each release and providing proper information regarding the objects delivered. • Working with client to prioritize the objects to be delivered in the next release. Personal Details: Name : Yuvaraj C Date of Birth : 01-Jun-1988 Alternate Mobile No : +91 8610232034 Alternate Email ID : yuvarajac88@gmail.com Current Employer : HCL technologies, Chennai
  • 3. Current Location : Chennai Preferred Location : Chennai, Bengaluru Languages Known : English, Tamil, and Telugu.