Tushar Raj Email & Phone Number

Zurich, CH

New York, NY, US

• Single-handedly developed an end-to-end equity trade correction backend application using Python/Teradata/MSSQL/Informatica PowerCenter, which provided financial advisors with the capability to manage a client.
• Creating and modifying, python, Teradata, and MSSQL queries for pulling data from different Data sources for aggregate data and automate
• Conducted GAP analysis to assess the adaptability of a new application in trade correction processes, identifying inefficiencies and implementing strategic solutions for enhanced accuracy and compliance.
• Optimized the long-running Teradata/MSSQL query execution time by 40% through the strategic redesign of business scenarios, incorporating query partitioning, creating indexes, and implementing data compression.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server.
• Develops MSSQL stored procedures and views, and conducts thorough testing of both new and existing systems.

New York, NY, US

• Optimized the long-running sql query execution time by 40% through the strategic redesign of business scenarios,incorporating query partitioning, creating indexes, and implementing data compression techniques.
• Collating data sources and building databases like Hadoop, AWS and DB2 which can be accessed by end-users according totheir intent by SQL
• Implementing the change requests as a part of Business updates
• Designed POC for the better customer experience using Tableau dashboards.

New York, NY, US

Worcester, Massachusetts, US

• Built a new backend system using Python/SQL from scratch for a new insurance product.
• Have developed a tool that performs the basic study of data in all huge tables of database and provides recommendations onpotential column & values that can be compressed to save space and boost performance.
• Performed Exploratory Data Analysis, data wrangling, and feature engineering using Python to identify trends and detectfinancial anomalies within both structured and unstructured datasets for submitted insurance claim.
• Designed, developed, and implemented, data warehouse architectures using logical and physical data models.
• Designed and executed 50+ data visualization projects on Tableau, achieving a high 95% satisfaction rate.
• Ensured data management best practices are being followed when developing new data assets.

Indianapolis, Indiana, US

• 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.
• 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.

Indianapolis, Indiana, US

• 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 analyzingerror codes and suggesting corrective actions.
• Designed two-way Encryption logic using Python to encrypt PII & PHI data so that data can be moved to the AWS cloud beforeexiting client server.

Worldwide, OO

• 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.

Worldwide, OO

• Worked as a Data Analyst for a healthcare insurance client to develop and support various reporting applications for business. The reporting applications majorly use Teradata, Informatica, Hadoop, DB2 and Unix as the.
• 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.

1>Professional player started appearing at the age of 15 for state tournament won continuously 3 times.2>Represent Bihar in national chess event in Saharanpur as a player and captain of the team. 3>Appear in multiple major newspapers for my achievement in chess.

1> Worked along with Sharad Sagar(Forbes 30 young Leader) as a Leader in the organization.2> Worked as a leader in the organization for 2 years making education the biggest issue and bringing it to the forefront as compared to all the other issues.3>Oxygen is a movement of students, teachers and all those people who are unsatisfied with the present system.

Bachelor'S Degree, Computer Science

Masters, Data Analytics