| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSravan Kumar Reddy Ramidi Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLE LinkedInWork ExperienceData AnalystCognizant Technology Solutions, Chennai, IndiaClient: Peloton June 2020 - June 2022 Designed and Implemented ETL Workflows: Created robust ETL workflows using SSIS to extract data from various sources, transform it to meet business requirements, and load it into MySQL servers, ensuring seamless data integration and high performance. Performed Data Cleansing and Validation: Utilized SSIS transformations to clean and validate data during the ETL process, eliminating inconsistencies and improving data quality, which resulted in a 25% increase in data accuracy. Automated data Pipelines: 30% and ETL processes with SSIS to run on a scheduled basis, reducing manual intervention, increasing efficiency by 30%, and ensuring timely data availability for analysis. Utilized machine learning models in Python (Pandas and NumPy) to analyze historical sales data and market trends, accurately predicting future demand and achieving a 15% reduction in overstocking and a 10% decrease in lost sales. Optimized inventory levels by leveraging SQL for querying data from MySQL and PostgreSQL databases, reducing excess inventory by 20%. Implemented data cleaning techniques using Python (Pandas) to identify and rectify inconsistencies, missing values, and outliers, leading to a 25% improvement in data accuracy. Developed compelling data visualizations using Power BI and Tableau to enhance data-driven decision decision-making processes, resulting in a 20% increase in strategic planning effectiveness. Streamlined inventory management processes by integrating Unleashed with e-Commerce platforms, improving stock allocation efficiency by 18% across multiple locations. Conducted supplier performance analysis through Unleashed to improve supplier lead times by 12% and negotiate better pricing terms, resulting in a 5% cost reduction. Enhanced customer satisfaction by maintaining accurate inventory levels, reducing stockouts by 15% and decreasing lead times by 10%. Created real-time reports and dashboards using Power BI to monitor sales trends and stock levels, leading to a 30% increase in operational efficiency and providing actionable insights for inventory optimization. Utilized predictive analytics and manual forecasting techniques in Unleashed to boost demand forecasting accuracy by 22%, aiding in more informed purchasing decisions. Performed stock aging analysis using Python (Pandas and Matplotlib) to identify slow-moving items, resulting in promotional strategies that reduced aged inventory by 25% and improved overall inventory turnover. Projects360 Business InsightPersonal Project, Wichita, KS March 2024 - June 2024 Live Dashboard Imported data from MySQL server to Power BI to ensure seamless integration and real-time data availability, resulting in a 20% improvement in data accessibility. Applied ETL processes (Extracted, transformed (manipulated), loaded data) to clean and structure data for analysis, enhancing data quality and reducing inconsistencies by 30%. Created calculated columns to enhance data analysis, ensuring accurate and meaningful insights, which improved inventory tracking accuracy by 15%. Generated measures using DAX language for performance metrics, enabling real-time decision-making and boosting operational efficiency by 20%. Performed data modeling to establish relationships between different data sources, leading to streamlined reporting and a 25% reduction in data retrieval time. Utilized bookmarks to switch between visuals for dynamic presentations, enhancing stakeholder engagement and improving report usability. Implemented page navigation with buttons to create intuitive report navigation, resulting in a 30% increase in user satisfaction. Applied the divide function to prevent zero division errors in calculations, ensuring data integrity and reliability across reports. Created a date table using M language for accurate time-based analysis, supporting trend analysis and seasonality assessments. Configured dynamic titles based on applied filters to provide context-specific insights, improving report clarity and relevance. Used KPI indicators to track and display key performance metrics, aiding in quick identification of performance issues and achievements. Using conditional formatting to values in visuals using icons or background color, highlighting critical data points and trends effectively. Implemented data validation techniques to ensure data accuracy and consistency, reducing data errors by 10%. Utilized Power BI services for enhanced collaboration and sharing, enabling seamless access to ad-hoc reports for all stakeholders. Published reports to Power BI services to facilitate real-time data access and insights, improving decision-making processes. Set up personal gateway to enable automatic data refresh, ensuring up-to-date information is always available. Created Power BI App for centralized access to reports, improving report accessibility and user experience. Managed collaboration with cross-functional, workspace, and access permissions in Power BI services to maintain data security and control, ensuring appropriate access for all team members. FINANCIAL ANALYTICSPersonal Project, Wichita, KS January 2024 Created comprehensive customer performance reports using advanced data analysis techniques, providing valuable insights for decision-making and improving data collection efficiency by 30%. Constructed detailed market performance reports through rigorous data cleaning and transformation, enhancing data quality and analysis efficiency by 25%. Build a detailed P&L reports by year and month using robust data modeling techniques, ensuring 99% accuracy in financial analysis and demonstrating proficiency in databases. Executed ETL processes to integrate data from diverse sources, ensuring data integrity and completeness with a 95% data accuracy rate. Designed intuitive reports using pivot tables, increasing clarity and usability by 20%, showcasing Microsoft Excel expertise. Applied advanced data cleaning techniques in Power Query, improving data quality and analysis efficiency by 30%. Demonstrated expertise in advanced data analysis, providing valuable insights for decision-making and problem-solving, leading to a 15% increase in strategic planning effectiveness. Utilized statistical analysis techniques and predictive modeling to analyze data, uncovering critical trends and patterns, enhancing strategic planning with statistical knowledge and leveraging SWOT analysis, resulting in a 20% improvement in decision-making processes. Demonstrated strong attention to detail throughout the project lifecycle, ensuring high-quality deliverables. EducationMasters in Data ScienceWichita State University, Wichita, KS May 2024Bachelors in Statistics (MSCs)Auroras Degree & PG College, Hyderabad, India October 2020 Skills Programming and Analysis: Python (Pandas, NumPy, SciPy, Matplotlib), R, Sigma Data Management: SQL (SQL Server, MySQL, PostgreSQL, SSIS, SSRS, SSAS) Machine Learning: Regression, Decision Trees, Time Series Analysis, NLP Business Intelligence: Microsoft Power BI (DAX, API, Power Query), Tableau, SharePoint, A/B test, NetSuite Big Data Technologies: Hadoop, Spark Cloud Services: Microsoft Azure (Data Bricks, Azure Data Lake, Azure Data Warehouse, Azure Synapse Analytics) Project Management: Jira Excel: VLOOKUP, Conditional Formatting, Pivot Tables, VBA Certifications Excel Codebasics March 2024 Power BI Codebasics June 2024 |
