Gayatri Alias Pranita Sutar Email & Phone Number

Chicago, Il, Us

• Identified tuition reimbursement opportunities by conducting extensive data gathering from various online sources, benefiting over 2,000 students across multiple majors and locations.• Enhanced data accuracy by 30% through comprehensive data cleanup, addressing missing values and merging diverse datasets using data modeling techniques, and optimized data processing, reducing preparation time by 15%.• Led cross-functional teams, utilizing Slack and GitHub to streamline communication and task management, which bolstered collaboration and cut delays by 15%.• Automated manual processes using VBA scripting and contributed to developing efficient data pipelines, improving data processing efficiency by 20% across multiple projects.• Created interactive dashboards in Excel and Power BI, visualizing program availability and reimbursement metrics, increasing stakeholder engagement by 40%.

United States

• Engineered complex SQL queries to extract, transform, and analyze large datasets from PostgreSQL databases, ensuring data precision and reliability for reporting and analysis.• Developed Python scripts to automate data processing, implement statistical models, and execute advanced data analysis tasks, boosting forecast accuracy and efficiency by processing up to 50 records per hour.• Implemented AWS services including CloudWatch for system monitoring, streamlining cloud-based data workflows, and enhancing system efficiency.• Produced compelling data visualizations and interactive dashboards using Tableau, effectively conveying insights and trends to both technical and non-technical stakeholders, monitoring over 30 key performance indicators (KPIs).• Executed text mining techniques on unstructured data sources, uncovering valuable insights and patterns to support decision-making and assessment processes.• Performed detailed risk analysis, employing statistical techniques to identify potential risks and generate actionable insights for mitigation, evaluating risk factors for various products and scenarios.• Architected Service-Oriented Architectures (SOA) to enhance system interoperability and flexibility, facilitating seamless integration of various services and improving overall business efficiency.

India

• Architected a Supply Chain Optimization System for a major retail client, involving the extraction and integration of inventory and sales data from Oracle databases using SQL to ensure data integrity and consistency throughout the process. • Designed a sophisticated learning model in Python to predict demand and optimize inventory levels, reducing stockouts and overstock situations. • Deployed the optimization model on AWS EC2 instances, and used Lambda for real-time inventory adjustments, and use S3 for secure and scalable storage of 1TB of data. • Crafted detailed visualizations using Matplotlib to analyze and present complex data trends, supporting strategic decision-making and operational improvements. • Constructed comprehensive Tableau dashboards that allowed the client to monitor inventory levels, demand forecasts, and KPI in real-time, enhancing their decision-making capabilities. • Orchestrated the entire project lifecycle using the Waterfall methodology, coordinating with cross-functional teams of 10+ members to ensure all deliverables were met on schedule and within budget. • Integrated Git for version control of the codebase, facilitated efficient collaboration among team members, and maintained a clear history of project development. • Delivered detailed statistical analyses and data visualizations to key stakeholders, demonstrated an improvement in supply chain efficiency, and highlighted the positive impact on the client's operations. • Executed process engineering analysis for IT management, identifying areas for improvement and implementing optimized processes to enhance operational efficiency and reduce costs.

Pune, Maharashtra, India

• Consolidated and integrated extensive datasets from Oracle databases using Python and Pandas for data extraction, transformation, and cleansing, maintaining data accuracy and completeness.• Implemented data modeling and DAX calculations in Power BI to create robust and scalable data models, facilitating in-depth analysis and forecasting.• Utilized SQL to perform advanced data mining and analysis, extracted meaningful insights from large volumes of data, and generated comprehensive reports.• Applied data cleansing techniques to identify and rectify data inconsistencies and errors, improving overall data quality and reliability across 100 data entries.• Leveraged Git for version control, ensured efficient management and collaboration on analytical projects, and make a robust and organized codebase.• Managed project management initiatives, utilizing best practices and methodologies to plan, execute, and monitor IT projects, ensuring they were completed on time, within scope, and met quality standards.

India

• Conducted data analysis using Python and SQL, extracting insights from datasets and identifying critical trends that informed key business strategies.• Designed intricate SQL queries in MySQL databases to extract, merge, and integrate data, ensuring completeness and accuracy across all datasets.• Harnessed NumPy for advanced numerical computations and data manipulation tasks, including dataset merging, data filtering, and creating new calculated fields.• Developed insightful visual representations using Power BI, effectively translating complex data patterns, correlations, and trends into easily digestible formats for stakeholder comprehension, visualizing 25 key metrics.• Created interactive dashboards in Power BI to visualize key performance indicators (KPIs), customer segmentation, and churn predictions, providing stakeholders with real-time insights.• Produced detailed Excel reports featuring pivot tables, charts, and summaries to communicate analytical findings and recommendations effectively.• Facilitated communication between business and technical teams, ensuring that IT projects aligned with business goals and delivered value to the organization.

Master'S Degree, Information Technology And Management, 3.55

Bachelor'S Degree, Computer Science, 3.8

Apart from the excellent academic credentials , I also bring event management experience and the ability to coordinate academic programs.