Yuvaraj Chengalvarayan Mobile No: 967-***-****, 996-***-****
Mail Id: acum1h@r.postjobfree.com
Professional Summary:
Around 2 Years of experience in Information Technology with a strong background in Database development and Data warehousing/Business Intelligence. 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 and Energy & Process 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 .
Work Experience:
Working as Software Engineer in HCL Technologies, Chennai through BHILWARA Info technology Ltd. (Nov 2014 – Till Date).
Project Experience:
Project # 1 TIAA-FACT (Production Support in Reconnet)
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.
Role: Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
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.
Responsibilities: To understand the functional requirements in detail and providing logical solution.
Job Monitoring, identifying discrepancies and recording the variances for business to research and remediate.
Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
Environment: SQL Server 2008,
Duration: 11-Apr-2015 to till date
Project # 2 ENOC-UOGS
UOGS handles end–to–end Oil and Gas business Inventory related business and enhance information exchange between the various entities in the group that operate at various stages of the Oil and Gas downstream value chain. This application would be used by 11 businesses within the group each would be located in central data center as well as in various locations such as UAE, Singapore etc.
Role: Worked as ETL and SQL developer.
As a SQL developer, was involved in development of procedures understanding the business requirements.
Implemented several concepts to get the required output.
Got chances to meet the business analysts and collected requirements for the reports.
Was involved in requirement gathering, Data Mapping, Design and testing.
Responsibilities: To understand the functional requirements in detail and providing logical solution.
To develop error free queries satisfying the customers.
Involved in performance tuning and Optimization.
Involved in Unit Testing and Functional Testing.
Environment: Oracle 11g, SSRS (Visual Studio 2008)
Duration: 14-Nov-2014 to 15-Apr-2015
Technical Skills:
Programming Languages/Technology/Tools: Data warehousing Testing, HP Quality Center (HP-QC)
Database: SQL server 2008, Oracle Database 11g
Operating System: Windows XP, Windows 7
Educational Details:
Graduation : M Tech (Power System)
College : BS Abdur Rahman University, Chennai
Passed out : 2013
Personal Profile:
Name : Yuvaraj Chengalvarayan
Father’s Name : A. Chengalvarayan
Sex : Male
Date of Birth : 01/Jun
Marital Status : Single
Permanent Address : No: 155, Mannadi Street, Seemapuram, Minjur -601203.
Mobile : 967-***-****, 996-***-****
Languages Known : English, Tamil, and Telugu
Nationality : Indian
Mail Id : acum1h@r.postjobfree.com