About

Anup Tiwary is a Senior Specialist in Data Engineering at LTI - Larsen & Toubro Infotech. With over 11 years of experience in data warehousing architecture and software development, Anup has become an expert in Microsoft Business Intelligence Tools, SQL Server, and Azure Platform. He has a strong understanding of database design and development with business intelligence using SQL Server 2000/2012/2016, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema, and Snowflake Schema. Anup has extensive experience in migrating SQL databases to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks, and Azure SQL Data warehouse. He is also proficient in controlling and granting database access, as well as migrating on-premise databases to Azure Data lake store using Azure Data factory. Additionally, Anup has developed Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming data to uncover insights into customer usage patterns. Anup is a proactive team player with excellent communication skills and work ethics. He has a good understanding of Spark Architecture, including Spark SQL, Data Frames, Spark Streaming, Driver Node, Worker Node, Stages, Executors, and Tasks. He is also well-versed in visualization tools such as Power BI, Confidential Excel-formulas, Pivot Tables, Charts, and DAX Commands. Anup has hands-on experience with AWS EC2, S3, EMR, Glue, Athena, Lambda, RDS, VPC, IAM, CloudWatch, SNS, and other services of the AWS family. He has expertise in various phases of project life cycles, including design, analysis, implementation, and testing. Anup has worked with several companies in the past, including Ameriprise and Cognizant. He has designed logical and physical data models for staging, DWH, and Data Mart layer. He has also led innovation initiatives of both platform and analytics teams. Anup has identified the scope to improve existing processes and suggested improvement ideas to increase the efficiency and accuracy of the process/reports. Anup holds a Master of Computer Applications (MCA) degree from Guru Gobind Singh Indraprastha University and a Bachelor of Computer Applications degree from Indira Gandhi National Open University. His tech stack includes SQL, Data Engineering, Azure, Spark, AWS