Venkata Saikiran Melam
Troy,NY
Summary
Dynamic Data Analyst with over 6 years of experience in process optimization, MS SQL Server, SSIS and data visualization using Python, R, SAS and Tableau. Proven ability to lead cross-functional teams, develop innovative solutions, and drive cost savings. Expertise in data visualization, statistical analysis, and business process improvement.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Project Manager
KeelWorks Foundation
04.2024 - Current
- Developed JSON files for Q&A, enabling structured data handling that enhanced chat bot response accuracy by 25%.
- Implemented rule-based systems for chat bot operations, optimizing prompt processing and increasing user interaction efficiency by 30%.
- Engineered prompt processing mechanisms for scheduling, leading to a 20% reduction in scheduling conflicts and improved user engagement.
- Integrated chatbots with UI and backend systems, streamlining data flow and user experience, which boosted overall system usability and performance by 35%.
Business Capstone Project
Wells Fargo
08.2023 - 12.2023
- Led process optimization and data analysis for Wells Fargo's Escalated Complaints team, reducing resolution time by 20%
- Developed ML models to predict service level KPI achievement, enabling proactive interventions to improve operational metrics.
Technology Intern
Invesco
01.2023 - 05.2023
- Conducted exploratory data analysis on municipal bond data using Python (Pandas, improving data collection using API, Automation and cleaning efficiency by 40%
- Developed an interactive Python dashboard for fund managers.
Data Analyst
Quicknify
08.2016 - 07.2022
- Optimized SQL scripts and ETL processes, achieving a 30% reduction in query response times and significantly enhancing MS SQL Server front-end application performance.
- Enhanced data pipeline efficiency by implementing advanced error handling and parallel processing techniques, ensuring improved data integrity and system reliability by over 40%.
- Maintained and optimized ETL processes across both on-premise and AWS cloud-based systems, achieving system-wide standardization that improved process efficiency and compliance documentation.
- Led collaborative efforts with global teams to support system integrations and data quality management, resulting in a 25% improvement in data accuracy and contributing to critical quality and safety reports for enterprise clients.
- Leveraged AWS cloud technologies for advanced data analytics, facilitating the production of insightful regular reports and detailed research analyses on health outcomes, improving data-driven decision-making by 35%.
Jr Data Analyst
TATA Consultancy Services
10.2013 - 08.2016
- Created complex ETL packages using SSIS for incremental data loads, resulting in a 40% improvement in data processing efficiency.
- Designed, deployed, and monitored SSIS packages, enhancing data integration workflows and reducing errors by 35%.
- Implemented SSIS packages for heterogeneous data export (OLE DB, Excel to SQL Server), increasing data consistency by 20%; also incorporated real-time data visualization dashboards using Power BI to monitor data flow and integration metrics.
- Developed dynamic SSIS packages for data extraction and transformation, integrating Power BI to create interactive visual reports, improving data transparency and decision-making efficiency by 30%.
Education
Master of Science - Business Analytics
Rensselaer Polytechnic Institute
Troy, NY12.2023
Bachelor of Science - Electronics And Communications Engineering
SRM Institute of Science & Technology
Chennai, IND06.2013
Skills
- Python
- SQL
- R
- SAS
- Jira
- Tableau
- Power BI
- AWS
- NLP
- Machine Learning
Certification
AWS Cloud developer
Timeline
Project Manager
KeelWorks Foundation
04.2024 - Current
Business Capstone Project
Wells Fargo
08.2023 - 12.2023
Technology Intern
Invesco
01.2023 - 05.2023
Data Analyst
Quicknify
08.2016 - 07.2022
Jr Data Analyst
TATA Consultancy Services
10.2013 - 08.2016
Master of Science - Business Analytics
Rensselaer Polytechnic Institute
Bachelor of Science - Electronics And Communications Engineering
SRM Institute of Science & Technology
Similar Profiles
Mathews VargheseMathews Varghese
UX Researcher/Product Manager at KeelworksUX Researcher/Product Manager at Keelworks
Athar AbolelaAthar Abolela
Volunteer UX Designer at KeelworksVolunteer UX Designer at Keelworks
Chandrashekar DChandrashekar D
Consultant F&A Compliance at WeLive Foundation, T4G, Dhakshin FoundationConsultant F&A Compliance at WeLive Foundation, T4G, Dhakshin Foundation
Tatianna ArroyoTatianna Arroyo
Teacher Assistant at CEOTeacher Assistant at CEO
Patrick J O'GormanPatrick J O'Gorman
Regional Sales Manager at UGI Energy Services, LLCRegional Sales Manager at UGI Energy Services, LLC