Venkata Sai Manohar Gedela Email & Phone Number

Longstanton, Gb

Chester, England, United Kingdom

- Maintained high-quality reference data, performed cleaning and transformation operations, and ensured integrity in a relational environment in close collaboration with stakeholders and solution architects.- Assessed end-to-end architecture and implementation of various AWS services including Amazon EMR, Redshift, and S3.- Extensive knowledge and experience in producing tables, reports, and graphs using various procedures and handling large databases to perform data manipulations.- Developed and maintained data visualizations and dashboards for key stakeholders.- Managed database import and export using SQL Server Integration Services (SSIS) and Data Transformation Services (DTS).- An excellent team player and technically strong person who has the capability to work with business users, project managers, team leads, and peers, thus maintaining a healthy environment in the project.- Performed data cleaning, transformation, and validation.- Involved in Requirement gathering, Analysis, Design, Development and Delivering of Business Intelligence with Stakeholders to Manage Delivery and BI Solutions using tools Tableau and Power Bi.- Conducted exploratory data analysis to identify trends, patterns, and insights.- Developed, optimized, and maintained SQL databases.- Performance tuning and optimization of SQL queries for improved efficiency.- Collaborated with software developers to integrate database functionality into applications.- Implemented security measures to safeguard sensitive data.

London, England, United Kingdom

- Designed and developed Tableau dashboards, KPIs, SLA & Client survey dashboards for Regulatory Compliance Analytics monitoring of product, sale, post-sale, risk across HSBC business lines and sites.- Worked with Agile (Scrum) and iterative methodologies, ensuring project timelines and deliverables were met.- Independent Monitoring Reviewers (IMR) Findings dashboards based on Severity, Controls, Target date base calculations, Risk Acceptance statuses & due date Reporting.- Implemented CI/CD practices, resulting in a streamlined and automated deployment process.- CRR Attestation dashboards for Wholesale IRB & Traded Models. (Reports for PRA, Attestation Non-Compliance Severity & Appendix C dashboards).- Played a significant role in delivering the Regulatory Compliance Analytics agenda through data management, statistical analysis, and establishing clear and robust governance and oversight.- Discriminatory Power Dashboards for the models to correctly rank customers based on Credit Risk profiles.- Developed Excel macros using VBA for risk teams.- Developed customized Excel templates, automating routine tasks and improving overall workflow efficiency.- Implemented cloud-based solutions to support and optimize ETL processes, improving overall efficiency.- Managed and maintained large datasets, utilizing Excel's advanced functions and formulas to extract meaningful insights.- Collaborated with cloud teams to design and implement cloud-native solutions for regulatory compliance analytics.- Ensured security best practices in cloud environments, aligning with regulatory compliance standards.- Verified and deployed databases change scripts provided by the internal team, replicate or mirror active data, and keep the data in always-available mode.

Sheffield, England, United Kingdom

- Led a data-driven initiative to enhance patient care by implementing Machine Learning algorithms, including Linear Regression, Decision Trees, and k-means clustering.- Developed a predictive model for determining the optimal time for weaning patients in mechanical ventilation.- Leveraged data analysis and algorithmic techniques to extract meaningful patterns from patient data and vital signs.- Collaborated closely with NHS to ensure seamless integration of the model into the clinical workflow.

- Intensive programme for essential knowledge and skills as a data analyst, including core data concepts, processes of data collection, cleansing, processing, transformation, and visualization, as well as presentations on the results and actionable insights that help make data-driven decisions.- Hands-on experience in technical skills (Excel, SQL, Python), such as the usage of functions, pivot tables, charts, and dashboards in Excel, querying and managing relational databases via SQL, exploring and analysing datasets using Python, and relevant libraries like NumPy and Pandas.- Completed two data analysis team projects that utilised Microsoft SQL Server, Python, and Excel (report and dashboard).

Visakhapatnam, Andhra Pradesh, India

- Gained valuable hands-on experience during an internship at the Electro-Technical LabDeveloped proficiency in widely used techniques, including PCB testing and electronic component testing.- Collaborated with a team to perform comprehensive testing and analysis of printed circuit boards (PCBs).- Conducted electronic component testing, ensuring accurate functionality and performance.Assisted in troubleshooting and diagnosing technical issues, contributing to efficient problem resolution.- Participated in team discussions and shared insights to improve testing processes.Demonstrated a strong commitment to safety protocols and maintained a clean and organized work environment.

Vellore, Tamil Nadu, India

Oversaw and implemented all components of stakeholder events including logistics, budgeting, venue selection, activity planning, transportation and entertainment. Oversaw spending and worked with the accounting department to monitor budgets.

Master'S Degree, Data Analytics, Merit

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering, 7.96