Manish Reddy

Private Equity & Cloud Solutions Specialist

Data Engineering and Project Leadership

• Spearheaded the transformation of the private equity domain, leveraging extensive experience in Private Equity, Credit, and Real Estate.
• Over the last two years, focused on mastering the Azure ecosystem, with a comprehensive understanding of Azure Synapse Analytics, Dedicated SQL pool, Azure Functions, and various other Azure services.
• Currently overseeing three high-impact projects in Private Equity, Hospitality, and Fitness chains.
• Led end-to-end data warehousing projects on Azure and AWS, optimizing data storage and retrieval for the utmost efficiency. Reduced infrastructure costs by 60% and increased performance by up to 80%.
• Contributed as a solutions architect on diverse projects encompassing Google Cloud, e-commerce sources, and the utilization of data build tools (dbt).
• Recognized for creative dashboard development, notably in Portfolio Monitoring, Due Diligence in deal-making, Private Equity performance assessment, and summary dashboards for quarterly fair value assessments.
• Added Snowflake to my toolset, enhancing my proficiency in data management.

• Engineered an efficient data extraction process using Talend Data Integration, ensuring accurate and swift data transfer from Oracle SQL and various sources to Oracle Autonomous Data Warehouse.
• Developed Power BI reports with custom DAX queries, optimizing performance for more effective decision-making.
• Created Quarterly Business Review Dashboards, Balance Sheets, and Income Statements on Power BI, providing key stakeholders with clear financial insights.
• Utilized Python scripting in Power BI to enhance data visualization, enabling deeper insights.
• Leveraged Oracle Autonomous DB, Talend Data Integration, Power BI, and Python to ensure efficient and reliable data processing.
• Checked client code for bugs and weaknesses using approved troubleshooting methods.

• Engineered an automated process that reduces manual efforts, increasing efficiency significantly.
• Implemented CDC replication processes for Sybase and Greenplum, ensuring data accuracy and minimizing errors.
• Utilized cURL scripts to archive data onto Amazon AWS S3 private cloud, providing a secure and reliable data storage solution.
• Created external tables connected to files uploaded to the cloud, streamlining data processing efficiency.
• The developed solution significantly reduces manual efforts, enhances data accuracy, and ensures reliable and efficient data management processes.

• Developed a Capitation risk adjustment model for a health insurance client, improving risk assessment accuracy, leading to more effective decision-making.
• Enhanced the model by introducing a risk score calculation based on the medical history of plan members, increasing risk assessment accuracy by 25%.
• Contributed to the Flight Plan model, streamlining file submissions to CMS and ensuring operational efficiency.
• Achieved a significant performance boost by optimizing stored procedures, reducing run time by 70% and overall process run time by a minimum of 30%. This optimization not only enhanced data processing but also reduced delays significantly.
• Successfully implemented changes to the existing model, ensuring comprehensive coverage and compliance with evolving requirements.
• Utilized MSSQL and TFS for version control, ensuring timely and budget-compliant project delivery.
• The developed model considerably enhances the risk assessment process, improving decision-making and data processing accuracy.

• Designed and implemented a comprehensive solution for a global digital marketing client. It involved efficient data loading from OLTP databases into Azure SQL Data Warehouse using delta load techniques. Subsequently, a multi-dimensional cube was constructed, enabling advanced data analysis and reporting.
• Ensured end-to-end project success by taking full ownership of the process, from design to deployment, resulting in a streamlined and efficient system.
• Enhanced the solution with automated testing, significantly reducing the time required to identify discrepancies and enabling prompt issue resolution there by improving data accuracy.
• Leveraged a diverse technology stack, including MSSQL, Azure SQL, SSIS, SSAS 2013, Power BI, and VSTS for continuous integration.
• The developed solution empowers advanced data analysis capabilities, resulting in more informed decision-making and deeper insights into the client's global digital marketing activities.