Susmitha Dalli Email & Phone Number

Charlotte, NC, US

Tennessee, United States

• Boosted employee engagement analysis by 75% by developing an interactive Power BI dashboard displaying statistical user active performance metrics, utilizing DAX queries for KPI tracking, and calculated measures.
• Reduced data pipeline processing time by 50% through automated SSIS ETL triggered by SQL Server Agent, employing complex data transformations with C# and SQL to load optimized data into an SSAS data model.
• Increased stakeholder trust by 25% (Tenncare, NTT, KPMG, Deloitte) by efficiently communicating project deliverables on-time within profit margins, streamlining Agile SDLC with Jira-based sprint retrospective.
• Enhanced estimate budget reports consistency by 65% across DEV, UAT, and PROD by creating robust unit test cases with complex SQL subqueries and refining data cleaning practices using Power Query, stored procedure.
• Ensured data governance and compliance by working within financial regulations maintaining security, documented data dictionaries and business logic in Confluence reducing 20% onboarding time for team.
• Leveraged macros using VBA, data links, SQL aggregations and indexes to automate error detection in data from ERP systems and removal of 500,000+ duplicate records, streamlined data workflows, and ensured consistent.

Charlotte, North Carolina, United States

• Achieved a 97% course completion by designing Tableau visualizations with filters, parameters, and actions to monitor student’s grade in Applied Databases and KDD (data mining), improving targeted academic performance.
• Created dynamic storyboards after data preparation in Tableau Prep, highlighting trends, outliers, and drill down into insights with LOD calculations achieving a 24% boost in decision making across multiple departments.
• Improved student engagement by 15% with training programs resolving conceptual doubts and technical issues. Assisted faculty with assignment grading and preparing effective curriculum.
• Implemented keyword extraction with Sentence-Bert in semantic recommendation engine, performed text mining and NLP to suggest qualified resources resulting 40% gain in adaptive learning.
• Set professional development workshops with leaderboards and constructive feedback motivating 100+ students.

India

• Increased operational process efficiency by 60% by designing a scalable Flask REST API for metadata entry, tested CRUD endpoints using Postman ensuring reliability, integrated with DynamoDB improving data accessibility.
• Accelerated data processing by 30% through an AWS Glue ETL pipeline with Amazon S3 storage, utilized CloudWatch for error logging.
• Facilitated meetings with retail chain stakeholders, identifying credit risk and financial statements, analyzed credit scoring models, resulting 35% enhancement in real-time CRM.
• Resulted cost-benefit analysis enhancement by 26% supporting digital card and payment recommendations in QuickSight, integrating ETL triggers and AWS Lambda for dynamic data refreshes, and established a client-approved.
• Maintained 85% consistency across multi-environment by establishing CI/CD pipelines with AWS CodePipeline and Docker, and version control with Git.
• Analyzed portfolio performance using market risk modeling and VaR techniques, leading to a 15% reduction in financial risk for investment strategies.

India

• Identified supply chain bottlenecks through scenario and cost-to-serve analysis, following Lean Six Sigma principles, applied predictive modeling using machine learning classification algorithms, succeeding revenue.
• Performed ROI analysis processing 100,000+ transactions using joins and window functions in MySQL to generate extensive accounting reports.
• Conducted EDA with Pandas and NumPy to clean and transform 1 million+ historical sales entries, Matplotlib and Seaborn to enhance demand forecasting accuracy by 20%, minimizing stock issues.
• Optimized inventory level through procurement analysis and coordinated with logistics team to streamline distribution, improving expense management by 18%.