Nithin Reddy Penta Reddy

Experience

• 

  IDBI Federal Life Insurance

  Apr 2015 - May 2015

  Sales

  Sale of insurance products, building awareness about the products and to determine the investors perception towards Insurance products.

• 

  Verity Knowledge Solutions Pvt. Ltd.

  May 2015 - Aug 2023

  Designed and developed a Security Framework to provide fine-grained access to objects in AWS S3 using AWS Lambda and DynamoDB.Extensively worked with AWS CDK (Cloud Development Kit), deploying infrastructures for static websites or complex, multi-stack applications spanning multiple AWS accounts and regions using Python/TypeScript.Performed end-to-end architecture and implementation assessments of various AWS services like Amazon EMR, Redshift, and S3.Created Python frameworks for AWS Cloud automation, including multiprocessing for daily and intraday uploads and extracts using AWS SDK and CDK.Utilized Data Build Tool (DBT) for schema tests, referential integrity tests, and custom tests, ensuring data quality.Developed extract/load/transform (ETL) processes in Snowflake Data Factory using DBT to manage and store data from internal and external sources.Developed reusable frameworks to automate ETL processes from RDBMS to Data Lake utilizing Spark Data Sources and Hive data objects.Implemented AWS Step Functions to automate and orchestrate Amazon SageMaker tasks, including data publishing to S3, model training, and deployment for prediction.Used AWS Glue for data transformation, validation, and cleansing.Led cross-functional weekly metric reviews, using SQL queries and Python scripts to perform deep dives into performance data, driving actions that resulted in a 15% increase in key KPIs for clients.Delivered executive-level presentations, translating complex data findings into actionable insights through advanced visualizations, predictive models, and statistical analysis, influencing top-level business decisions.Mentored junior associates in advanced data analysis techniques and data visualization, fostering skill development and boosting team performance, resulting in three team promotions. Show less Built ETL pipelines from AWS S3 to DynamoDB and Snowflake for analytical queries.Worked on deployment using AWS EC2 with PostgreSQL RDS and S3 file storage.Involved in setting up Hadoop configurations (Hadoop cluster, Hive connection) using Informatica BDM.Developed machine learning models (Logistic Regression, KNN, Gradient Boosting) with Python (Pandas, NumPy, Seaborn, Matplotlib, Scikit-learn).Conducted data blending and preparation using Alteryx and SQL for Tableau consumption, publishing data sources to Tableau Server.Developed star and snowflake schema models to support business intelligence solutions in Power BI and Tableau.Created Operational Data Tables (OBTs) and fact-dimension models to streamline data analysis and reporting workflows, improving efficiency.Automated data workflows and optimized processes using Python (Pandas, NumPy) and Power Query, reducing manual work by 30% and improving overall efficiency.Built pipelines to integrate Azure Cloud to AWS S3 for data movement into Azure Databases.Applied NLP techniques to analyze unstructured data from customer reviews and social media, extracting valuable insights for improving product offerings and customer satisfaction. Show less Utilized SQL to manage and analyze large datasets, uncovering key insights and generating reports to inform strategic decisions and optimize business performance.Extracted, cleaned, and analyzed large datasets from multiple sources using SQL, Snowflake, and Python, providing strategic business insights to support sales initiatives.Performed advanced data cleaning and Exploratory Data Analysis (EDA) to standardize, validate, and explore datasets, ensuring high data quality for decision-making.Developed and maintained interactive dashboards in Tableau and Power BI, enabling transparent tracking of KPIs and driving a 20% improvement in business outcomes.Applied Python (Pandas, NumPy, SciPy, Matplotlib, Seaborn) and R (dplyr, ggplot2, caret, tidyverse) for advanced data analysis, predictive modeling, and statistical modeling, achieving a 25% improvement in operational efficiency.Designed and optimized data models (including star and snowflake schema) to improve query efficiency and data accessibility for analytics and reporting.Developed and deployed machine learning models (Random Forest, Logistic Regression, Gradient Boosting Machines, SVM), achieving high model accuracy and predictive power.Conducted A/B testing (split and multivariate testing) to measure the impact of variables on user behavior, optimizing marketing campaigns and increasing customer engagement by 10%.Collaborated cross-functionally to document business requirements and support Agile projects, ensuring alignment with client expectations and strategic goals. Show less

  • Senior Associate

    Nov 2018 - Aug 2023

  • Associate

    Jun 2016 - Nov 2018

  • Trainee

    May 2015 - May 2016
• 

  RCIScience (Royal Canadian Institute for Science)

  Apr 2024 - Jun 2024

  Student Data Analyst

   Led a cross-functional team to design and implement an ETL data migration architecture from Universal Analytics to Google Analytics 4, ensuring seamless data tracking continuity and improving data accuracy by 25%. Created a comprehensive data archive from Universal Analytics to Google Analytics 4 to preserve historical insights and ensure long-term accessibility of critical metrics. Evaluated social network traffic data in depth and leveraged data-driven insights to enhance the social media content strategy, resulting in a 30% increase in website traffic. Developed interactive dashboards using Looker Studio and Tableau to provide a comprehensive overview of RCIScience’s audience, landing pages, and event performance, enabling more informed strategic decisions. Show less

• 

  Canadian Pride Historical Society

  Dec 2024 - Mar 2025

  Student Data Analyst (Capstone)

  To optimize the structure, usability, and analytics of the Pride Information Management System (PIMS) to enhance accessibility and data-driven decision-making.Cleaned and standardized metadata using SQL and regex-based scripts, improving data accuracy and consistency by 40%.Designed and implemented a structured database schema to improve the organization and retrieval of historical LGBTQ2+ content.Integrated Power BI with SharePoint to build interactive dashboards, enabling stakeholders to track collection growth, keyword trends, and content distribution.Enhanced search and filter functionalities using TF-IDF and LDA for document categorization and dynamic filtering based on user behavior and content themes.Applied machine learning techniques including clustering and decision trees to identify content gaps and recommend user-personalized resources.Delivered final recommendations to CPHS leadership, resulting in an improved digital repository experience for researchers and the general public Show less