Venkata Sai manohar

Venkata Sai manohar

Data Analyst
United Kingdom

نبذة عني

Experienced Data Analyst with 4 years of expertise in Tableau, SQL, AWS, and data visualisation. Skilled in generating actionable insights, optimising data operations, data validation, and implementing robust BI solution…

الخبرة

Data Analyst

Infonix Solutions LTD
Oct 2023 - حتى الآن · 2 سنوات 8 أشهر

- Developed and optimized SQL scripts for database manipulation and management.
- Performed data analysis and data profiling using SQL on various source systems.
- 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.
- Collaborated with cross-functional teams to gather and analyze business requirements.
- 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.
- Utilized statistical techniques to uncover actionable insights.
- 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.

Data Analyst / SQL Developer

INFONIX SOLUTIONS - UK
حتى الآن

Developed and optimized SQL scripts for database manipulation and management.
Performed data analysis and data profiling using SQL on various source systems.
Produced tables, reports and graphs using various procedures and handled large databases to perform data manipulations.
Worked closely with IT teams to implement data quality rules and ensure compliance with industry standards.
Developed and maintained data visualizations and dashboards for key stakeholders.
Collaborated with cross-functional teams to gather and analyze business requirements.
Worked with business users, project managers, team leads and peers.
Performed data cleaning, transformation, and validation.
Utilized statistical techniques to uncover actionable insights.
Conducted exploratory data analysis to identify trends, patterns, and insights.
Developed, optimized, and maintained SQL databases.
Performed 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.

Data Analyst / Tableau Developer

HSBC - London, UK

Designed and developed Tableau dashboards, KPIs, SLA and client survey dashboards for Regulatory Compliance Analytics.
Monitored product, sale, post-sale, and risk across HSBC business lines and sites.
Worked with Agile (Scrum) and iterative methodologies, ensuring project timelines and deliverables were met.
Collaborated with cross-functional teams, utilizing GitHub for version control and collaborative development.
Implemented CI/CD practices, resulting in a streamlined and automated deployment process.
Developed bespoke solutions and tools to enhance the effectiveness and efficiency of surveillance within Regulatory Compliance.
Executed data quality tests and provided detailed reports on findings to stakeholders.
Contributed to delivering the Regulatory Compliance analytics agenda through data management, statistical analysis, establishing clear and robust governance and oversight.
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 database change scripts provided by the internal team.
Replicated and mirrored active data to keep data in always available mode.

Intern Data Analyst

NHS - Sheffield, UK

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.

Junior Data Analyst

RSOCL

Completed an intensive programme for essential knowledge and skills as a Data Analyst, including core data concepts.
Worked on processes of data collection, cleansing, processing, transformation, visualisation, and presentation of results and actionable insights.
Gained hands-on experience with Excel, SQL, and Python.
Used Excel functions, pivot tables, charts, and dashboards.
Queried and managed relational databases via SQL.
Explored and analysed datasets using Python and relevant libraries like NumPy and Pandas.
Completed 2 data analysis team projects using Microsoft SQL Server, Python, and Excel reports and dashboards.

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) تابلو SQL Server Management Studio ETL Processes Power Query MySQL SQL Server AWS Services AWS S3 Python Data Transformation Data Cleaning Data Quality Assurance Data Integration Informatica Alteryx Git Agile Methodologies Project Coordination Team Leadership VBA GitHub CI/CD Machine Learning Linear Regression Decision Trees k-means clustering Excel NumPy Pandas
الإبلاغ عن هذا الملف الشخصي؟