Sivareddy Pondugula

● Collaborated closely with business stakeholders to gather tailored requirements, leading to the design and development of customized Ad-hoc reports using SQL.
● Leveraged AWS and Snowflake integration to produce customized reports, meeting specific requirements for diverse teams in investment operations.
● Preprocessed and cleaned raw data using Python libraries to address missing values, outliers, and inconsistencies, ensuring data readiness for modeling tasks.
● Utilized exploratory data analysis (EDA) techniques to uncover patterns, trends, and anomalies within datasets, and developed and implemented machine learning
models to derive actionable insights and facilitate predictive analytics.
● Designed and implemented customized Python functions to automate analysis and optimization processes, effectively mitigating risks.
● Utilized Snowflake for high-performance analytics, ensuring quick query responses and timely decision-making through complex queries and report generation.
● Created and delivered impactful Tableau dashboards, translating complex financial data into visually compelling insights for the management team, enhancing data
visualization and facilitating informed decision-making.

Collaborated closely with business stakeholders to gather tailored requirements, leading to the design and development of customized Ad-hoc reports using SQL.
Leveraged AWS and Snowflake integration to produce customized reports, meeting specific requirements for diverse teams in investment operations.
Preprocessed and cleaned raw data using Python libraries to address missing values, outliers, and inconsistencies, ensuring data readiness for modeling tasks.
Utilized exploratory data analysis (EDA) techniques to uncover patterns, trends, and anomalies within datasets, and developed and implemented machine learning models to derive actionable insights and facilitate predictive analytics.
Designed and implemented customized Python functions to automate analysis and optimization processes, effectively mitigating risks.
Utilized Snowflake for high-performance analytics, ensuring quick query responses and timely decision-making through complex queries and report generation.
Created and delivered impactful Tableau dashboards, translating complex financial data into visually compelling insights for the management team, enhancing data visualization and facilitating informed decision-making.

Analyzed and interpreted data from internal and external teams and facilitated communication between data scientists and data engineering teams.
Proficient in utilizing Alteryx and SQL to seamlessly extract and integrate data from diverse sources such as databases, spreadsheets, and various data sources.
Utilized Alteryx to clean, enrich, and standardize data from diverse sources, addressing missing values and ensuring consistency across the dataset.
Used Python libraries to conduct statistical analysis on clients traded and investment stocks throughout the week, leveraging Python libraries and tools for effective data analysis and extracting valuable insights.
Analyzed batches of stock market pricing data and prevented overlooked pricing errors from activating during market opening using Databases ServiceNow CRM, internal software, and Microsoft Excel.
Captured, escalated, reviewed, and resolved 30+ pricing errors using ServiceNow ticketing software, Bloomberg terminal and other internal software.
Participating in weekly and monthly management calls to address weekly issues and process-related queries and creating presentations KPI for senior management.
Designed and presented Tableau dashboards translating complex financial data into visually compelling insights for management, enhancing decision-making.

Performed comprehensive research on the pricing of equity securities and fixed-income instruments by gathering and synthesizing financial and operational data from diverse sources, including Bloomberg, IDC, Reuters, and various vendor databases and data systems.
Collaborated with cross-functional teams, translating business needs into SQL queries for actionable insights in investment strategies and risk management.
Proficiently manipulate and wrangle data using SQL, showcasing expertise in tasks such as seamlessly joining tables, crafting calculated columns, renaming fields, and sorting data with precision and efficiency.
Developed SQL queries to validate and clean data, including checks for duplicate entries, identification of null values, and ensuring accurate data aggregation.
Conducted analysis on batches of stock market pricing data, identifying, and preventing pricing errors from triggering during market opening.
Leveraged advanced Excel capabilities, including VBA macros, pivot tables, VLOOKUP, and concatenation techniques, to automate tasks and enhance functionality, optimizing trade support processes for increased efficiency.
Ensure timely Processing& settlement of trades, investigate& resolve trade-related breaks under the established work practices and procedures.
Promptly responded to client queries Met SLA /TAT with 100% accuracy and regularly updated and maintained Tableau dashboards to reflect the latest market trends and pricing information, contributing to informed decision-making processes.

Applied fundamental and technical analysis to stocks, options, and futures, identifying trends and patterns using various chart types and statistical indicators.
Monitored KPIs, analyzed trends, and investigated variances to provide decision-making support for optimizing business outcomes.
Utilized SQL Server for data extraction and harnessed advanced Excel features to implement risk mitigation strategies, presenting the outcomes to the management team in a PowerPoint presentation.
Implemented diverse derivative strategies to manage risk and capitalize on market opportunities, maintaining a proactive stance in dynamic market conditions.
Cultivated and maintained strong relationships with clients, providing investment advice and recommendations based on thorough research and analysis.