Venkatesan M

Datawarehouse Designer - 3 Years of Experience - Near 75038


Datawarehouse Designer

Education Level:


Will Relocate:



CAREER SUMMARY * Professional 9+ years of experience in Data Warehousing projects. * Extensive experience in Data Warehouse Architecture and Concepts. * Responsible in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse. * Technically very strong in ETL tool SSIS (Sql Server Integration Services) and followed the best practices in the SSIS packages. * Extensive experience on Databases like Oracle, DB2 and Sql Server 2008, Job scheduling tools 'Control-M', 'AutoSys', 'Redwood' & Hands on experience on Scripting language 'Unix'. * Experience in testing of End-to-End Data warehouse/Data Mart & Hands on experience on testing tool 'Quality Center' (QC). * Hands on experience in the reporting tool 'Microstrategy' & Jump Start classes conducted by Microstrategy at Dallas by November 2016 * Undergone trainings & received certifications from Big Data University on the following courses A. Big Data Fundamentals B. Big Data Analytics C. Accessing Hadoop Data using Hive V2 D. Accessing Hadoop Data using Hive V2 E. Hadoop Fundamentals F. Introduction to NOSQL and DBaas G. Introduction to Pig H. Introduction to Solr I. Data Science Methodology J. Text Analytics Essentials - Case Study K. Using HBase for Real-time Access to your Big Data * Undergone training in Tableau, QLikview, Teradata Basic Architecture, concepts & SQL, MS SQL Server 2008 which includes SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS) and SQL Server Reporting Service (SSRS). * Involved in Requirement gathering, system analysis, design, development, testing and implementation of projects Software Development Life Cycle (SDLC) & Expert in performing various types of testing like Functional Testing, Regression Testing and System Testing and User Acceptance Testing. * Undergone training in 'Power Consulting Program' conducted by CHRD Wipro at Minneapolis, USA * Excellent Analytical, Communication skills and Leadership qualities working in a team and ability to communicate effectively at all levels of the development process.