Anirudh .

Experience

• 

  Xerago(citi bank)

  Dec 2020 - Aug 2021

  Software Trainee

  Worked as a Data Analyst for a banking client to develop and support various reporting applications for business. The reporting applications majorly use Teradata, Informatica, Hadoop , DB2 and Unix as the back-end technologies. I am currently leading two reporting modules of the project from offshore and my work involves :1. Daily Reporting and Communication of work to the client.2. Develop Teradata Scripts and Informatica mappings with complex data scenarios.3. End to End Development and Testing of Teradata/Informatica code.4. Ensuring delivery of work within SLAs while assisting the team and at the same time minimize production failures.5. Driving automations to add value to the client work.• Designed a distributed storage and query systems that was scalable, fault tolerant and applied innovative technologies and algorithm to scale up the speed by effectively articulating technical challenges.• Designed and applied data compression tool using Unix and Teradata that uses MVC technique to save 2.8Tb of space in production environment-saving approx. $1.7 million.• Solved existing technical challenge by innovating a tool to reduce manual work by 80%, decreasing project billing and enabling more time for code enhancement and performance tuning. •Constructed data pipelines (Informatica PowerCenter) to integrate multiple distributed systems sources into a single data warehouse to suit large enterprise architecture frameworks with end-to-end QA testing. Show less

• 

  LTIMindtree

  Aug 2021 - Aug 2023

  Senior Software Engineer

  ● Built a new backend system using Python/Teradata/MSSQL/Snowflake from scratch for a new insurance product.● Created and migrated a legacy healthcare system to AWS cloud, using Hadoop, AWS services (IAM,S3, Glue, Lambda, Step Function,EC2), Python, SQL, Informatica PowerCenter and Snowflake for enhanced efficiency and scalability.● Developed and implemented a data warehouse by loading data from AWS S3 data storage into the snowflake stage for quick data loading and analysis.● Migrated the database Tables (JSON) and views from SQL Server to Snowflake.● Successfully migrated a legacy Insurance system to the AWS cloud, utilizing AWS services such as Amazon S3, Amazon EMR, AWS Lambda, and EC2 instances. Implemented technologies including Python, MSSQL and snowflake.● Worked on AWS Data Pipeline to configure data loads from S3 to into snowflake.● Conducted thorough Insurance claim analyses, including exploratory data analysis, statistical analysis, and predictive modeling, to inform data-driven decision-making.● Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.● Migrated Deer walk Source Medical Data into Snowflake. Strong experience in migrating databases to Snowflake.● Designed and executed 50+ data visualization projects on Tableau, achieving a high 95% satisfaction rate.● Conducted comprehensive healthcare analyses, encompassing exploratory data analysis, statistical analysis, and predictivemodeling, to drive informed decision-making.● Developed Python & Unix tool automating 80% of manual support tasks, ensuring uninterrupted batch processing by analyzing Show less