United States Data Analyst

Spoorthy Reddy Merugu

*******************@*****.*** +1-205-***-**** Alabama, United States. Spoorthy smerugu EDUCATION

Bachelors in Electronics and Communication Engineering CMR College of Engineering & Technology

•Courses: SQL, JAVA Programming, Data Structures And Algorithm, Control Systems, VLSI Design, Embedded Systems, Real Time OS, Digital Image Processing.

Aug 2017 – May 2021

Hyderabad, India

•CGPA: 9.42/10.00

Masters in Computer Science

University of Alabama at Birmingham

•Courses: Deep Learning, Database Systems, Cloud Computing, Adv Web Application Dev, Probability & Statistics in CS, Structured query language.

Jan 2023 – present

Birmingham, United States

•CGPA: 3.80/4.00

PROFESSIONAL EXPERIENCE

FactSet Research Systems INC.

Data Analyst

Aug 2021 – Dec 2022

Hyderabad, India

•Developed comprehensive testing strategies and conducted rigorous testing processes to ensure robustness and reliability of software solutions; integrated automated testing tools which reduced manual testing efforts by 50%.

•Processed and delivered real-time financial news stories from various vendors in the form of JSON, XML, and so on to various clients.

•Implemented a Python service to lessen reliance on a Machine Learning service, improving tagging performance from 60% to 100%.

•Engineered innovative updates for subsystems of end-user applications software across various platforms, resulting in a 40% decrease in system downtime and a 25% improvement in user satisfaction metrics.

•Assisted in preparing monthly and quarterly credit reports for internal and external stakeholders, including Regulatory Reporting Schedules.

•Led a comprehensive data integration initiative, transitioning over 500GB of data from Oracle Fusion to Autonomous Data Warehouse, enhancing data retrieval speed by 40%.

•Implemented Object Storage and Bucket solutions, reducing data movement time by 30% and bolstering security measures.

• Formulated and executed 15+ data loader tasks, SQL tasks, and data pipelines, ensuring accurate data transfer and reducing errors by 25%.

•Planned to apply advanced visualization techniques to craft compelling dashboards, reports, and visuals, enriching data models for impactful analytics.

•Designed and developed PL/SQL packages to efficiently transform and manipulate data within the database, ensuring data accuracy and consistency.

•Technologies used included Python, C++, MySQL, Git, Perforce, Shell Scripting, UNIX, and Unit Test, Statistical Analysis Systems (SAS), Structured Query Language (SQL), Power Business Intelligence (Power BI). PROJECTS

Enhancing Regulatory Reporting with Data Visualization

•Revolutionized monthly and quarterly regulatory submissions by spearheading a project focused on optimizing reporting processes through advanced data visualization techniques.

•Gathered diverse data from internal databases, spreadsheets, and external sources, resulting in a 30% reduction in system latency.

•Leveraged SAS, SQL, and Python to cleanse, transform, and centralize data, ensuring 99.9% accuracy and integrity. Utilized Tableau, Power BI, and Python libraries to craft interactive visualizations, offering insights into regulatory metrics for compliance.

•Engineered automated scripts to detect and rectify discrepancies in data, contributing to a 25% increase in data quality. Contributed ideas for bank-wide data enhancements in working groups, evaluating reporting processes and visualizations for optimization and refinement.

•Technologies: SAS, SQL, Python for data integration and transformation, Tableau, Power BI, and Python libraries

(Matplotlib, Seaborn) for visualization, and Microsoft Office suite for communication and documentation.

•Technologies: SAS, SQL, Python for data integration and transformation, Tableau, Power BI, and Python libraries

(Matplotlib, Seaborn) for visualization, and Microsoft Office suite Online Ticket Booking System

Web Interface

•Provided a user-friendly interface, seamless booking process by improving efficiency, and enhancing customer satisfaction.

May 2023 – Jul 2023

•Engineered a dynamic partnership with developers, UI/UX designers, and database administrators to fuse various elements of the ticket booking system, leading to a 30% reduction in system latency and enhanced user experience.

•Collaborated on the refinement of user authentication using JSON Web Tokens (JWT) to ensure secure user interactions and data protection.

• Front-end: HTML, CSS, JavaScript, React.js

•Back-end: Node.js, Express.js, Django, Flask

•Database: MongoDB, SQL Server.

Cloud-Based File Sharing Tool May 2023 – Jul 2023

•Developed user-friendly web interface for secure file uploads and sharing, utilizing AWS EC2 for hosting and ensuring smooth interactions.

•Crafted robust file upload capabilities leveraging the AWS S3 SDK, with DynamoDB managing file metadata and user interactions.

•Automated email notifications via AWS Lambda and SES for improved engagement.

•Ensured seamless user experience through testing, including reliable email notifications and precise database operations.

•Key Technologies: Amazon EC2, Amazon S3, AWS Lambda, Amazon SES, Amazon DynamoDB, HTML, CSS, JavaScript

Face Recognition System Based on Raspberry Pi Using Python

•Developed an image capture system that stores video images as two-dimensional arrays in the database; integrated facial recognition to verify the identity of individuals, reducing unauthorized access incidents by 40% Jan 2021

•Technologies: RASPBERRY-PI and PYTHON

CERTIFICATES

Big Data and Data Analytics — By DELLEMC CERTIFICATION Introduction to Internet of Things And Embedded Systems — By Coursera Coursera Data Analysis and Visualization with Power BI — I have learned to add and design visualizations for accessible reports and dashboards, and perform data analysis. Skills gained: Data Analysis, Data Visualization, Power BI, Report Design, and Dashboard Design. Python Course Certificate

— By NPTEL and Coursera. Oracle Cloud Infrastructure 2023 Foundations Associate — By Oracle The Joy of Computing using Python — By NPTEL Database Programming with SQL — By Oracle Academy Machine Learning A-Z: Hands-On Python — By Udemy SKILLS

Languages

PYTHON, JAVA, Azure, Angular, HTML/CSS, SQL, JavaScript Tools

Power BI, Tableau, Probability and Statistics, Data Analytics, Pandas, Scikitlearn, NumPy, Matplotlib, Git, Perforce, UNIX, AWS, EC2, Kubernetes, Elastic search, EBS.

Database

SQL Server, Oracle, PostgreSQL.

Contact this candidate