Chinmayi Venigalla Email & Phone Number

• Manage and integrate large datasets from multiple sources, ensuring accuracy and consistency across different platforms to support business intelligence and decision-making.• Apply principles of database development and data management to design efficient data storage solutions, enabling streamlined data retrieval and processing.• Developed Power BI dashboards to support quarterly performance analysis and portfolio monitoring for financial teams.• Implemented data governance rules to ensure the integrity of large financial datasets across multiple platforms.• Collaborated with cross-functional teams to streamline data workflows and enhance decision-making with actionable insights• Collaborate with financial teams to improve information systems, providing detailed financial data analysis and custom reporting.• Utilize SQL (Oracle and SQL Server) to extract, manipulate, and analyze large datasets, generating actionable insights for business operations.• Demonstrated proficiency in working with large data sets using Microsoft Excel, including data integration, analysis, and management.• Proficient in using Excel for data analysis, including advanced functions like VLOOKUP, INDEX/MATCH, pivot tables, and conditional formatting.• Experience integrating data from various sources into Excel for comprehensive analysis, enabling informed decision-making.• Designed and created dynamic dashboards, scorecards, and KPI’s transforming complex data into visual insights.• Designed, developed, and optimized Power BI reports within the Power BI service, ensuring alignment with industry best practices.• Converted MicroStrategy reports to Power BI and Tableau, guaranteeing a smooth migration across BI systems.• Leveraged Power BI and Pivot/View to create various scorecards and dashboards, delivering critical insights tailored to the needs of different departments and senior management.

• Integrated data from multiple sources, including financial systems, transportation data, and GIS platforms, to provide comprehensive reports that guided executive decision-making.• Spearheaded the integration of data from multiple platforms and sources, leveraging advanced SQL queries and automation tools to ensure seamless data flow and reporting across departments.• Played a key role in improving data quality and integrity through rigorous data validation processes, leading to a 40% reduction in data inconsistencies.• Redesigned and automated key business processes using SQL and Power BI, improving scalability and efficiency of data reporting systems across departments, resulting in a 40% reduction in data inconsistencies.• Developed performance dashboards and reports using Power BI and DAX, providing key insights for quarterly performance analysis and portfolio monitoring for executives and stakeholders.• Collaborated with financial teams to track and monitor portfolio performance, contributing to strategic decision-making by delivering timely and accurate reports.• Improved data governance by implementing validation processes and rules that enhanced data accuracy and integrity, aligning with regulatory and business requirements.• Developed and maintained complex data models to support transportation planning and project development efforts, aligning data with regulatory requirements.• Expertise in creating charts, graphs, and dashboards within Excel to visualize trends and present key insights clearly and effectively.• Utilized Excel to track performance metrics, identify process inefficiencies, and automate repetitive tasks, driving operational improvements.• Applied Excel’s logical functions and tools to analyze data, identify issues, and provide data-driven solutions to business challenges.

• Analyzed and interpreted data using Redshift, Oracle, and NoSQL databases to create accurate and meaningful reports for business decision-makers.• Built complex Power BI dashboards and visualizations, including GSHS reports and custom district financial dashboards for education clients, using advanced DAX functions.• Experience working with financial data in Excel, applying formulas and tools to perform cost analysis, budgeting, and forecasting.• Optimized the front-end user experience by implementing React components for easy report navigation, filtering, and interactivity.• Developed interactive charts (Pie Charts, Bar Charts, Line Charts, etc.) and created custom Georgia district map visualizations to enhance geographic data representation in Power BI.• Experience in using Excel’s forecasting functions and tools to predict trends and make projections based on historical data.• Utilized Power Query to perform data cleansing, pivot/unpivot operations, and merge datasets, improving data consistency across reports.• Developed SQL and T-SQL queries, optimized stored procedures, and performed database troubleshooting to support the data requirements of Power BI reports.• Created, published, and maintained reports on Power BI Report Server, applying row-level security (RLS) to restrict data access by user roles.• Worked with various data sources including SQL Server, Oracle, and ServiceNow to ensure smooth integration into Power BI dashboards.• Implemented and maintained OLAP cubes, facts, and dimensions to provide summarized and aggregate views of large datasets for business intelligence purposes.

India

• Demonstrated expertise in developing and managing large data sets by integrating data from various sources across different platforms, ensuring seamless data flow for business operations.• Applied principles of database development and data management to design, optimize, and maintain relational databases, supporting efficient data storage and retrieval.• Managed large datasets across multiple systems, ensuring consistency and accuracy of data for portfolio analysis and monitoring.• Communicated complex data-driven insights to senior management through interactive dashboards and detailed reports, supporting critical investment decisions.• Utilized advanced Excel functions for ad hoc financial analysis, forecasting, and KPI tracking, improving decision-making processes and operational performance.• Leveraged Excel’s shared workbooks and collaborative features to enable team-based data analysis and reporting.• Utilized SQL, specifically within Oracle and SQL Server environments, to query large datasets, enhancing business decision-making processes with timely and accurate data insights.• Migrated data from an old ERP system to a cloud-based system, improving data accessibility and performance for reporting.• Analyzed and interpreted data using Redshift, Oracle, and NoSQL databases, ensuring accurate reporting and insights for business users.• Performed data modeling and analysis for both OLTP and OLAP systems, creating efficient data marts using Star Schema and Snowflake Schema methodologies.• Experienced in importing and exporting data to/from Excel, working seamlessly with CSV, XML, and other data formats for integration with external systems.• Built and optimized SQL queries in Teradata SQL Assistant and TOAD to extract, clean, and manipulate large datasets for research and reporting.

Master Of Science - Ms, Information Technology

Master Of Science - Ms, Information Technology

Bachelor Of Technology - Btech, Computer Science