Axtria - Ingenious Insights

Associate

- Developed and enabled the validation dashboard which can detect anomalies preventing significant data loss
and has reduced the efforts of manual validation of data by 95% using Python and Tableau
- Enabled high Data Quality data checks and fixed the Data Quality issues while enabling them which reduced
the data issue by 90%
- Optimized the data pipelines and enabled them to refresh three times a day which increased the conformity
of data by 95% using SQL.

Analyst

- Developed and have ownership for the automation scripts using python to pull data from API based source, standardization of files, file movement through SFTP to S3 or within S3, and various other scripts
- Responsible of high-quality data pipelines using SQL and Matillion
- Worked with various pharma data like Veeva, Specialty Pharmacy, IQVIA LAAD, and many other to meet and solve the business requirements raised by the client
- Responsible for creating dynamic dashboards for clients using Tableau

Analyst Trainee

- Responsible orchestration process by using NodeRed and Matillion to process data into reporting tables from staging to provisioning layer
- Developed Various STTMs and performed unit testing over data from staging to provisioning layer using Snowflake
- Worked on defect fixing with respect to data Snowflake

Intern

JUSPAY

- Automated various tasks for Merchants' Emails, Data Interpretation, and Data Visualization using R and Python
- Responsible for the internal dashboard development team using the R shiny framework
- Improved payment success rates which were reduced due to authorization errors using R and Big Query

Technical Product Analyst 

Google Summer of Code

- Developed and Managed the bugRzilla package which helps the user to interact with Bugzilla through an API
- Worked on writing the unit test cases using testthat, raising the code coverage on a package, and used VCR to test API calls and use snapshots to validate the output
Package available here:
https://github.com/llrs/bugRzilla/ 

- Responsible for creating a report on R bugs submitted on Bugzilla which shows my understanding of the R bug tracking system and initiative. As well as my work experiences combining multiple
packages

The report is available here: 
https://llrs.github.io/bugzilla_viz/bugRzilla_review.html

Student Developer

Google Developer Student Clubs- Galgotias University

- Lead a community of 100+ students 
- Mentoring 500+ students
- Share knowledge on Google Technologies
- Organizes workshops, seminars, etc
- Speaker

Community Lead

Core Team Member

Member

Analytics Vidhya

Contributing Writer

OpenMined

An open-source community focused on researching, developing, and elevating tools for secure, privacy, value-aligned artificial intelligence.

Mentor

Technical Mentor

The Sparks Foundation

TechnoJam

Data Science Lead

Widhya

During this internship, I was successfully able to predict and analyze the data.

Data Analytics Intern

Google Code-in

Student Mentor

Dynamic and achievement-oriented Business & Data professional with over two years of hands-on experience in developing and optimizing data pipelines, as well as implementing Master Data Management systems. Proficient in a comprehensive suite of technical tools including Python, R, Databricks, SQL, Redshift, PostgreSQL, R Shiny, ETL, and Git. Skilled in leveraging Python, R, and Tableau for data extraction, manipulation, and visualization to drive informed decision-making. Adept at conducting thorough data analysis, generating insightful reports, and fostering data-driven strategies to enhance business performance. Demonstrates exceptional organizational acumen, meticulous attention to detail, and a nuanced comprehension of data's multifaceted utility. Committed to perpetual learning, fueled by innate curiosity, and dedicated to continual professional advancement and excellence within the realm of Analytics.

Taplio

Piyush Kumar's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Piyush Kumar's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Piyush Kumar's Linkedin Analytics