Surya Mitra Vedula

Client - CalHEERS - State of California Project

Sector - Health Care and Insurance

Tools/Software - MS Excel (Macros), MS Power BI, JIRA, MS Project, Ceptah Bridge, MS Share Point, MS Visio, Service Now

• Piloted fiscal analysis and reporting for 4+ years, extracted and organized large datasets using JIRA and processed them efficiently with Excel, leveraging Macros to significantly improve preparation workflows.
• Delivered real-time budget utilization insights and strategic recommendations for spending adjustments, supporting data-driven decision making. Led efforts to present these insights in an interactive dashboard format using Power BI.
• Over 4 years of hands-on experience in JIRA administration and analysis, creating and managing structures for time logging by project resources. Monitored time-tracking trends across SDLC phases, analyzed associated costs and provided detailed trend reports to leadership and the client.
• Created project work plans in MS Project and synchronized them with JIRA using tools like Ceptah Bridge to ensure seamless tracking and alignment of project tasks.
• Managed a client-facing invoicing process with a monthly cadence, ensuring timely and accurate billing.
• Designed and maintained a comprehensive organizational hierarchy framework for the project with 800+ using MS Visio, establishing a clear hierarchy and distribution of roles, and regularly improvised the process to ensure efficiency.
• Generated weekly and monthly trend reports to track resource activity, highlighting hour logging trends, under-burning, and over-burning resources. Worked on integrating these reports with Power BI for an interactive dashboard. Reports also included PTO data to monitor overall resource utilization.
• Served as a SharePoint Administrator for over 4 years, managing site structures, user access, and content to ensure seamless collaboration and system efficiency. Managed access control for key tools such as MS SharePoint, Distribution Lists and JIRA.

Client - Raytheon Technologies (RTX)

Sector - Defense

Tools/Software - MS SQL Server, .NET Framework, HTML, CSS, Service Now

• Collaborated with the team to develop and enhance client web page UIs using HTML and CSS, ensuring improved functionality and user experience.
• Managed ServiceNow tickets. addressing technical glitches in applications and UI issues on client websites, and streamlined ticket handling processes for the team.
• Developed SOPs for maintaining client applications and
  conducted quality checks to ensure system reliability and
  compliance.

Sector - General Administration and Management

Tools/Software - MS Excel, MS Power Point, MS Outlook

• Led placement coordination for 1,000+ students across all engineering branches, serving as the primary liaison between the Training & Placement Department, faculty, and top recruiters including Cisco, ExxonMobil, L&T, Goldman Sachs, and Deloitte.
• Oversaw candidate shortlisting and eligibility verification for full-time roles, ensuring seamless execution of multi-stage interview processes across diverse firms.
• Developed Excel reports to present branch-wise placement statistics, compensation trends, and recruiter insights, enabling data-driven decisions for faculty and administration.

Sector - General Administration and Management

Tools/Software - MS Excel, MS Power Point, MS Outlook

• Acted as the primary liaison between 150+ Civil Engineering students and the Training & Placement Department, streamlining communication on internship and placement opportunities through Outlook and PowerPoint.
• Supported the shortlisting process by matching student eligibility with firm requirements, ensuring smooth coordination of interview rounds for both internship and full-time roles.
• Built and maintained Excel reports to track offers, average CTC, and placement percentages, enabling faculty and administration to monitor outcomes and make informed decisions.