Nov 2015 - Till - Senior Associate , Cognizant Technology Solutions - Chennai
Aug 2014 – Nov 2015 - Technical Lead, Wipro Technologies – Chennai
March 2012 - Aug 2014 - Associate Projects, Cognizant Technologies Solutions- Chennai
June 2010 – Feb 2012 Senior Software Engineer, Wipro Technologies – Chennai
Nov 2007 – June 2010 Software Engineer, Botcode Web Integration Solutions – Chennai
ETL Tools Microsoft SQL Server Integration Services (SSIS)
Databases Microsoft SQL Server 2005/2008, Oracle 9i, Sybase 15, Microsoft Access
Operating Systems Microsoft Windows 7/XP/2000/98, Linux, UNIX
Scheduling Tools Control-M, Tidal
Reporting Tools WebFocus 7.7.03
Test Management Tools HP Quality Center
Issue Tracking Tools JIRA, Quality Center
* IT experience of about 6+ Years in involving various phases of SDLC and informatics using MSBI - SSIS and IBI WebFocus.
* Good experience with SQL Server 2005/2008, MSBI - SSIS (SQL Server Integration Services).
* ETL / Warehouse Developer with progressive experience in impart training and development in Data warehousing, RDBMS concepts and ETL experience in MSBI-SSIS tool.
* Having experience in logical and physical designing of reports in WebFocus.
* Expert level skills on T-SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server 2000/2005.
* Expertise in writing and debugging Stored Procedures and Functions.
* Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
* Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages
* Supported team in resolving SQL Integration services and ETL related issues.
* Strong analytical, problem troubleshooting/solving skills, self-starter.
* Knowledge of scheduling tool like Control – M Application & TIDAL. Experienced in High and Low level ETL design, development and testing of MS SSIS ETL jobs.
* Committed team player with strong analytical, problem solving skills
Senior Associate @ • Development activities of WebFOCUS Reports, Worked on various aspects of BI and Reporting, middleware development, managed reporting.
• To be a part of development activities in online reports.
• Development enhancement will include requirements analysis (determining the size and scope), development and testing.
• To include the online reports into dashboard websites.
• To be a part of development & production implementation activities. From November 2015 to Present (2 months) Technical Lead @ • Development activities of WebFOCUS Reports, Worked on various aspects of BI and Reporting, middleware development, managed reporting.
• To be a part of development activities in online reports.
• Development enhancement will include requirements analysis (determining the size and scope), development and testing.
• To include the online reports into dashboard websites.
• To be a part of development & production implementation activities. From August 2014 to November 2015 (1 year 4 months) Programmer @ • Development activities of WebFOCUS Reports, Worked on various aspects of BI and Reporting, middleware development, managed reporting.
• To be a part of development activities in online reports.
• Development enhancement will include requirements analysis (determining the size and scope), development and testing.
• To include the online reports into dashboard websites.
• To be a part of development & production implementation activities. From January 2013 to August 2014 (1 year 8 months) Chennai Area, IndiaAssociate Projects @ • Development activities of WebFOCUS Reports, Worked on various aspects of BI and Reporting, middleware development, managed reporting.
• To be a part of development activities in online reports.
• Development enhancement will include requirements analysis (determining the size and scope), development and testing.
• To include the online reports into dashboard websites.
• To be a part of development & production implementation activities. From March 2012 to August 2014 (2 years 6 months) Senior Software Engineer @ • ETL / Warehouse Developer with progressive experience in impart training and development in Data warehousing, RDBMS concepts and ETL experience in MS SSIS tool
• Expert level skills on T-SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server 2000/2005.Expertise in writing and debugging Stored Procedures and Functions.
• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages
• Coding (involves policy rule coding, sequence flow, status flow, and dictionary entries).
• Unit Testing. From June 2010 to February 2012 (1 year 9 months) Chennai Area, Indiasoftware engineer @ • To create the SSIS Packages using SQL Server Integration services
• To Schedule the SSIS Packages using SQL server
• Deploy the SQL packages from one environment to another environments
• Monitoring the SQL jobs and investigates the Root cause Analysis of failed job and to fix the issues.
• Written stored procedures and functions to get the clients information from SQL Server
Revised SSIS Packages and stored procedures to improve the performance To Support the SSIS Packages using SQL Server integration services. From November 2007 to June 2010 (2 years 8 months) Chennai Area, India
Master's Degree, Computer Science, 82.35 @ Hindusthan College Of Arts And Science From 2004 to 2007 Bachelor's Degree, Computer Science and Information Technology, 69.14% @ Ayya Nadar Janaki Ammal College at Sivakasi From 2001 to 2004 Veeramani Karuthapandian is skilled in: Microsoft SQL Server, SSIS, ETL, Oracle, Data Warehousing, IBI Webfocus