Ashish Kumar J. Email & Phone Number

With over 12+ years of extensive experience in the Information Technology field, I specialize in the analysis, design, development, testing, and implementation of Data Warehouse Applications. My expertise extends to successfully designing Data Warehouse Architectures, enabling seamless migration of applications from legacy systems. I possess a practical understanding of Data modeling concepts, including Star-Schema Modeling, Snowflake Schema Modeling, Fact, Dimension, normalized and De-normalized tables.As an expert in the field, I have implemented Slowly Changing Dimensions - Type I & II in Dimension tables, ensuring data accuracy as per specific requirements. I am well-versed in working with various database objects like Azure SQL, SQL Server, Netezza, and Oracle, ensuring seamless integration and data management.My hands-on experience in Azure Data Factory, Hydrograph, SSIS, Ab Initio, DMExpress, and Informatica ETL tools has enriched my technical skills and problem-solving abilities. I excel in implementing ETL best practices, including performance tuning, logical solution implementation, and troubleshooting techniques.Adept at project-related documentation, I create comprehensive technical design documents, ETL data mapping spreadsheets, and scope documentation, ensuring efficient project management. I am proficient in leveraging Azure Cloud features, such as Azure Data Factory, Azure SQL, and Azure Data Lake Storage, enhancing project scalability and performance.With comprehensive knowledge and experience in process improvement, data profiling, data extraction, data cleansing, data lineage, data quality, and data manipulation, I continuously strive for excellence in data management.Beyond technical expertise, I am well-versed in project management tasks, including planning, estimating, status reporting, and scope management. Moreover, I am adept at providing support and maintenance for Data Warehouse projects, promptly addressing client and end-user queries/requests.As a driven and experienced IT professional, I am committed to delivering exceptional results, ensuring seamless data management and project success. My passion for data innovation and continuous learning drives me to excel in every aspect of my work. I am always eager to embrace new challenges and contribute positively to the growth and success of any organization I am associated with.