Mokshith Reddy Yerradoddy

Data Analyst

Location: Peoria-Illinois Email: ad4r48@r.postjobfree.com Phone: 312-***-**** LinkedIn

PROFESSIONAL SUMMARY

Data Analyst possessing 3+ years of expertise and strong proficiency in Python and a versatile skill set tailored for data-centric tasks. Expertise extends to a wide range of data-related activities, including data extraction, cleansing, modeling, and visualization.

Leveraged libraries like NumPy, SciPy, Boto, Pickle, PySiRde, PyTables, Data Frames, and Pandas facilitates scientific computing, AWS interaction, GUI creation, and efficient data storage and analysis, particularly with large datasets. Extending this proficiency to diverse databases such as MySQL, MongoDB, Terra Data, and optimizing Apache Web server handling ensures robust data management across different environments.

Skilled in developing data models to represent complex business processes and relationships within the Infinity Database.

Hands-on experience with AWS, Azure, and OpenStack involves deploying services like Amazon S3, Simple DB, ECS, SQS, CloudWatch, and CloudFormation for storage, organization, monitoring, and infrastructure setup.

Extensive experience in configuring SharePoint lists to capture and manage structured data. Customization of list columns, validation rules, and default values for data integrity.

Skilled in SAP data management, utilizing SAP Data Services and SAP HANA for effective data integration, transformation, and reporting, enhancing business intelligence and analytics capabilities.

Experienced in Salesforce CRM, managing customer data, creating custom reports and dashboards, and automating business processes with Salesforce workflows and Apex code to improve sales and customer service operations.

Collaborated with cross-functional teams to gather requirements, design machine learning solutions, and integrate predictive analytics into business processes, driving data-driven decision-making and innovation initiatives.

Hands-on experience in developing custom applications using Power Apps to address specific business needs.

Expertise in Informatica and SSIS ensures streamlined Extract, Transform, Load (ETL) processes for efficient data integration. Proficiency in PyCharm, PyScripter, Spyder, IDLE, Sublime Text, and Visual Code allows for effective coding and script development across varied projects and tasks.

TECHNICAL SKILLS

Programming Languages:

Python, C++ & R.

Visualization tools:

Power BI, Tableau.

Python Libraries:

NumPy, SciPy, Boto, Pickle, PySide, PyTables, Data Frames, Pandas, Scikit, Seaborn, Matplotlib

ETL:

Informatica, SSIS.

IDE:

PyCharm, PyScripter, Spyder, IDLE, Sublime Text, Visual Code.

Databases:

MySQL, MongoDB, Teradata, Apache Web server, Oracle & Infinity.

Methodologies:

Agile, Scrum, Waterfall

Cloud Computing:

AWS, Azure, OpenStack.

AWS Services:

Amazon S3, Dynamo DB, Amazon ECS, Amazon SQS, AWS Cloud Watch and Amazon, Cloud Formation.

PROFESSIONAL EXPERIENCE

Data Analyst KPMG, IL Jun 2023- Current

Proficiently utilize Python and SQL to dissect and interpret complex datasets. Regularly extracted a minimum of three significant insights each quarter, driving growth and innovation initiatives.

Employed advanced Python libraries such as NumPy, Pandas, and scikit-learn to conduct intricate data analysis, including the creation of predictive models critical for shaping corporate strategies.

Develop and maintain interactive dashboards using PowerBI, resulting in a notable 20% increase in data-centric decision-making across teams.

Work on the planning phase of Snowflake migration projects, defining migration strategies and timelines.

Execute data cleansing using sophisticated Excel functions like VLOOKUPs and pivot tables, ensuring data precision and reliability.

Synthesize and present comprehensive reports and visualizations using PostgreSQL, leading to a 30% improvement in informed decision-making across multiple departments.

Utilized SAP Analytics Cloud to integrate data warehousing and analytics solutions, providing a single source of truth for real-time, data-driven decision-making across various business functions.

Employed Salesforce CRM to track and analyze customer interactions and sales leads across multiple channels, enabling a comprehensive view of customer behavior and sales performance.

Leveraged SAP's predictive analytics and machine learning capabilities to develop models that forecast customer behavior and sales trends, aiding in strategic planning and decision-making.

Utilize AWS cloud services including Lambda, S3, Step Functions, and SageMaker to build scalable and efficient machine learning pipelines for data processing, model training, and deployment.

Orchestrated and refined ETL (Extract, Transform, Load) processes, maintaining data integrity with an accuracy rate exceeding 98% through rigorous validation, anomaly detection, and correction measures.

Leveraged AWS technologies (RDS, Lambda, S3, EC2, Redshift) to enable real-time data analytics, significantly reducing decision-making timelines by 30%.

Generate insightful weekly and monthly reports using advanced MS Excel techniques and conveyed findings through PowerPoint presentations, ensuring clear and effective communication of critical data.

Conduct comprehensive analysis of complex claims data using Pandas, delivering prompt and precise reports for management evaluation and decision-making.

Maximize Jira's advanced features to create intricate reports and metrics, greatly influencing informed decision-making and enhancing project success rates.

Play a vital role in both physical and logical data modeling, increasing data accuracy by 15% through meticulous metadata documentation and user materials.

Data Analyst Intern BNY, IL Jan 2023- May 2023

Efficiently worked on end-to-end data pipelines projects at BNY, significantly reducing data processing time and enhancing team productivity in financial analysis.

Performed meticulous A/B testing and hypothesis validation using SQL and statistical frameworks, leading to data-driven recommendations that improved BNY project performance by an average of 20%.

Developed and maintained interactive data visualizations and dashboards using Power BI, translating complex data findings into actionable insights for stakeholders and facilitating informed decision-making.

Automated data ingestion and transformation processes by creating and managing ETL (Extract, Transform, and Load) jobs with AWS Glue, reducing manual effort and errors.

Integrated Salesforce with SAP ERP systems to synchronize customer data and sales information, ensuring consistency and accuracy across all business processes.

Ensured data integrity and accuracy by designing and configuring data catalogs, schemas, and transformations, leading to a 15% improvement in data quality across projects.

Optimized data warehousing solutions in Amazon Redshift, which included schema design, query performance tuning, and implementing data lifecycle policies in Amazon S3, resulting in a 30% cost reduction and improved data retrieval times.

Applied advanced statistical techniques such as regression, clustering, and time series analysis, consistently delivering actionable insights that drove a 15% average increase in client revenue and supported data-driven growth strategies.

Data Analyst Ouranos Technologies Private Limited, India Aug 2019- Jul 2021

Prepared scripts to automate the ingestion process using Python, achieving a 30% improvement in data ingestion efficiency across various sources like API, AWS S3, and Teradata.

Demonstrated advanced skills in R programming for data analysis, statistical modeling, and data visualization. Adept at adapting R to diverse data scenarios and business needs, consistently delivering actionable insights. Contributed to a 30% improvement in statistical modeling accuracy and data visualization effectiveness

Demonstrated ability in integrating Python with SQL databases, utilizing Python scripts to automate database tasks, perform data cleansing, and execute SQL queries for enhanced data processing.

Skilled in query optimization and performance tuning, ensuring high efficiency in data retrieval and management.

Experienced in Data Warehousing, Data Modelling, and Data Analyst adept in overseeing all phases of the Software Development Life Cycle (SDLC). Proficient in system analysis, design, data modeling, implementation, and comprehensive support and maintenance across diverse applications in both OLTP and OLAP systems.

Proficient in leveraging Power BI to develop visually engaging and interactive dashboards and reports, contributing to a 20% improvement in data-driven decision-making. Skilled in transforming intricate datasets into insightful visuals, aiding stakeholders in uncovering actionable insights for informed strategies and initiatives.

Employed SAP's data visualization tools to create dynamic reports and dashboards that provide insights into business performance, customer trends, and operational efficiency.

Leveraged Salesforce's automation workflows to streamline sales processes, reduce manual tasks, and improve efficiency in lead management and opportunity tracking.

Experienced in detailed data modeling within Teradata, resulting in a 25% optimization of structures for enhanced analysis and reporting capabilities.

Used Azure Data Factory for designing and implementing complex ETL (Extract, Transform, Load) processes, automating data movement and transformation across various data stores and formats.

SQL Developer Ouranos Technologies Private Limited, India

Engaged in the design and enhancement of an Oracle database structure, aiding the application team with technical designs and construction activities to ensure a robust and integrated database architecture.

Authored complex functions and procedures for new and existing packages using predefined business rules, significantly improving database functionality and performance through proficient use of SQL and PL/SQL.

Proficient in SQL with a strong emphasis on practical adaptability. Capable of crafting and optimizing SQL queries and scripts to suit various database systems, resulting in a 25% improvement in database performance and query efficiency.

Optimized data warehousing solutions in Amazon Redshift, which included schema design, query performance tuning, and implementing data lifecycle policies in Amazon S3, resulting in a 30% cost reduction and improved data retrieval times.

Actively involved in continuous enhancements and production support, addressing issues promptly and generating server-side PL/SQL scripts for data manipulation and validation.

Prepared comprehensive documents for program changes and analyzed requirements to create detailed Software Requirement Documents, ensuring clarity and precision in development efforts.

Contributed to a collaborative environment by sharing knowledge with team members and engaging in discussions with stakeholders for requirement clarification and project alignment.

EDUCATION

Masters Bradley University, Peoria, Illinois May 2023

Computer Science in Data Science Specialization

Bachelors Gandhi Institute of Technology and Management May 2020

Computer Science

PROJECTS

Age and Gender Detection

Conducted a comprehensive analysis of demographic data to identify patterns and trends related to age and gender in a large customer base, resulting in actionable insights for targeted marketing campaigns.

Conducted in-depth exploratory data analysis (EDA) using SQL queries and Python data visualization libraries (e.g., Matplotlib, Seaborn) to derive insights and identify patterns in demographic data.

CERTIFICATION

Hacker Rank: https://www.hackerrank.com/profile/mokshithreddy013

Contact this candidate