About

Nitish Ranjan is a Business Intelligence Consultant with almost 8 years of experience in the field. He is currently working with Northern Trust as a BI Consultant. Nitish has a strong background in Data Warehousing, ETL, Markit EDM, Data Visualization, Teradata, and Informatica. In his previous role at AXA, Nitish managed a team of 4 people and was responsible for process enhancements. He was involved in requirement gathering, designing, developing, testing, deploying, and maintaining ETL processes. He also worked on Qlikview scripting, data modeling, and dashboard creation. Nitish developed Unix scripts for various scenarios and was responsible for setting up the Unix Cron tab and creating cron jobs for ETL scheduling. Prior to AXA, Nitish worked as a System Engineer at TCS. He has experience in different phases of the software development life cycle, including requirement analysis, designing, coding, unit testing, and deployment in data warehousing projects. Nitish is adept in UNIX operating system commands and Shell Scripting. He developed standard and re-usable mappings and mapplets using Transformations like Filter, Expression, Lookup, and Aggregate for better data messaging and to migrate clean and consistent data. Nitish implemented slowly changing dimension methodology as per business requirements and extensively worked on Informatica performance tuning involving source level, target level, and transformation level bottlenecks. He implemented PDO, partitions for parallel processing of data to improve performance. Nitish is proficient in coding optimized Teradata batch processing scripts for data transformation, aggregation, and load using BTEQ. He has expertise in RDBMS, database normalization and denormalization concepts and principles. Nitish has strong experience in creating database objects such as tables, views, functions, stored procedures, indexes, triggers, and cursors in Teradata. He has also worked on the automation of manual tasks to speed up the process. Nitish has worked in Agile processes with end-to-end ownership of the task for monthly release cycles. Nitish holds a Bachelor of Technology degree in Information Technology from Techno India College of Technology. He has a strong tech stack, including ETL, SQL, Software Engineering, Normalization, and more. Nitish has relevant experience of 7.95 years.