VADIVEL
Chennai
Summary
Senior Software Consultant at RR Donnelley with expertise in SQL Server and SSIS, driving impactful data solutions. Successfully enhanced business insights through innovative SSRS report generation and automated ETL processes. A collaborative problem-solver, I thrive on transforming complex data into actionable intelligence, ensuring optimal decision-making for stakeholders.
Overview
11
11
years of professional experience
Work History
Senior Software Consultant
RR Donnelley
Chennai
03.2022 - Current
- Doing daily/weekly adhoc SSRS report generation for marketing solution also configured automation with ssis package to load the periodic order files into database.
- Working in SSIS for finance data processing for 7 customers in separate databases and source data are used as text file also involving enhancement and SQL Agent jobs administrations.
Technology Analyst
Infosys
08.2018 - 03.2022
- Developed multidimensional data models to analyze the sales of insurance products, resulting in enhanced business insights and decision-making.
- Implemented SSIS packages to load data into warehouse servers from various sources such as excel, csv, etc., facilitating regular data refresh for OLAP cubes.
- Utilized SSRS reports to visually represent analyzed data and distributed reports via email to user distribution groups, while also saving them in required file formats on shared drives.
- Established direct connections from SQL Datawarehouse databases to SSRS reports using procedures and SQL commands, optimizing data visualization and accessibility.
Senior Software Engineer
Profiniti Systems
11.2014 - 08.2018
- Designed and developed SSRS reports, stored procedures, and datasets.
- Enhanced existing SOLAP Cube and managed role management for improved efficiency.
- Developed ETL processes using SSIS and automated them through SQL Agent jobs.
- Created basic calculations, including string manipulation, arithmetic calculations, custom aggregations, ratios, date math, and logic statements.
- Utilized visualizations such as charts to represent data effectively.
- Developed back-end processes in MSSQL to meet UI requirements.
- Implemented parameters and input controls to provide users with data control.
- Combined data sources by joining tables and using data blending techniques.
- Created SSIS packages to load data from various sources and automated them using SQL Agent jobs.
- Designed and developed SSRS reports and administered Report Manager.
- Configured data-driven subscriptions and deployed reports efficiently.
Education
B.Tech/B.E. -
Anna University
01.2012
12th -
Tamil Nadu, Tamil01.2008
10th -
Tamil Nadu, Tamil01.2006
Skills
- SQL Server
- SSRS
- SSIS
- SSAS
Languages
- Tamil
- English
Timeline
Senior Software Consultant
RR Donnelley
03.2022 - Current
Technology Analyst
Infosys
08.2018 - 03.2022
Senior Software Engineer
Profiniti Systems
11.2014 - 08.2018
B.Tech/B.E. -
Anna University
12th -
10th -
Similar Profiles
Margaret JulesMargaret Jules
BILlING ANALYSTS at RR DonnelleyBILlING ANALYSTS at RR Donnelley
Aura RiveraAura Rivera
Specialist supply 2 at RR DonnelleySpecialist supply 2 at RR Donnelley
Luis Mora UtreraLuis Mora Utrera
Press Operator at RR DonnelleyPress Operator at RR Donnelley
Taylor LozierTaylor Lozier
Light Equipment Operator at RR DonnelleyLight Equipment Operator at RR Donnelley
Vedavalli SVedavalli S
Senior Technical Lead at Alten Calsoft LabsSenior Technical Lead at Alten Calsoft Labs