G Dharani Devi

Experience

• 

  Capgemini

  Aug 2018 - May 2021

  Senior Business Analyst

  • Developed Python scripts to identify and delete 25% of redundant technical manuals, streamlining documentation and reducing data storage costs.• Spearheaded the automation of data collection and analysis processes, reducing data processing time by 35% and enhancing the accuracy of the maintenance forecasting models.• Developed advanced dashboards in Power BI and Tableau, facilitating real-time tracking of workflow processes and enhancing operational visibility for aircraft maintenance and repair operations, reducing turnaround time by 20%.• Collaborated with IT and systems engineering teams to enhance the SAP ERP data integrity, which improved data availability and reliability by 25% for cross-departmental use.• Performed data modeling using ER diagrams and database design tools in Lucidchart to resolve data anomalies caused by multiple part numbers, improving data integrity and accuracy by 40%.• Mentored and provided guidance to 5 junior data analysts, fostering their professional development and ensuring adherence to best practices.• Leveraged DAX to develop sophisticated data models and measures in Power BI, enabling in-depth analysis and reporting for technical documentation usage, revision trends, and operational performance. Show less

• 

  Cyient

  Jun 2021 - Dec 2022

  Data Analyst

  • Spearheaded the design and development of ETL process to load large amounts of financial data into data warehouse by SQL script optimization using SSIS to enhance data quality and analytics readiness. • Leveraged CRM analytics to refine sales strategies, identifying high-value customer segments and improving lead conversion rates by 30% through targeted marketing campaigns, resulting in increased revenue and profitability.• Developed and implemented a predictive analytics model in R that decreased equipment downtime by 20%, leading to a yearly cost saving of approximately 50,000 dollars. • Utilized SAP PM to streamline asset management and sales operations, resulting in a 20% increase in sales productivity by reducing system downtime.• Automated monthly financial reporting and KPI dashboard generation using Python, reducing manual effort by 80% and decreasing reporting cycle time by 20%, facilitating faster decision-making and financial analysis.• Documented project requirements, data mapping, and process flows related to finance and dashboard development to maintain clear communication and knowledge transfer within the team, ensuring alignment with financial goals and objectives Show less

• 

  University of Louisville

  Jun 2023 - Oct 2023

  Data Analyst Intern

  • Assessed and organized over 5,000 records related to the admissions department for the College of Business, improving data accessibility and integrity.• Successfully gathered and documented requirements from 3 key departments admissions, student services, and academic affairs, ensuring alignment with project objectives.• Analyzed datasets encompassing 10,000+ student records in Alteryx to identify key trends in enrollment and academic performance, which contributed to a 15% improvement in departmental reporting accuracy.• Conducted workshops and surveys to stakeholders, achieving a 90% response rate and ensuring comprehensive data collection.• Created visualizations using Excel and QlikView to represent data trends and analysis findings, which were used in departmental meetings that facilitated in data-driven decision-making. Show less