Pavan Preetam Motagi
+1-929-***-**** • ********@****.**.*** • linkedin.com/in/pavan-motagi • Cincinnati, OH (open to relocation anywhere in USA) SKILLS
• Languages & Tools: SQL, SSIS, Python, R, Alteryx, Tableau, Advanced Excel, Visio, GitHub, Jenkins
• Project Management Skills: SDLC, Agile, Scrum, Scrumban, Kanban, Jira, Confluence, Rally, Azure DevOps
• Soft Skills: Business Ethics, Leadership, Mentorship, Presentation, Facilitation, Project Planning, Project Execution, IT Project Management, Team Management, Stakeholder Management, Risk Management, Requirements Gathering, Report Writing CERTIFICATIONS
• Professional Scrum Master I – December 2023 • Data Analytics from University of Cincinnati – April 2023 WORK EXPERIENCE
Great American Insurance Group
Intern (IT Auditor and Data Analyst)
Cincinnati, OH
May 2023 – December 2023
• Interviewed stakeholders from multiple business units and audited 15+ key controls documenting them using Visio, Excel, and Adobe to ensure SOX compliance.
• Automated manual tasks by 95% through the development of Alteryx workflows improving audit process efficiency.
• Performed analysis on 16M+ journal entries in Tableau and identified patterns on transactions to detect potential fraud. PricewaterhouseCoopers AC
Senior Associate (Developer and Scrum Master)
Bengaluru, INDIA
August 2019 – July 2022
• Planned and managed 3 healthcare IT projects by utilizing the Scrum and Scrumban frameworks and facilitating discussions, decision-making, and conflict resolution with cross-functional scrum teams and multiple stakeholders.
• Led and managed core Agile and Scrum ceremonies, including PI planning, sprint planning, daily standups, sprint reviews, and sprint retrospectives.
• Collaborated with the scrum teams in defining product and sprint goals, maintaining product and sprint backlogs, and facilitated product backlog refinement sessions.
• Leveraged Azure DevOps, Jira, and Confluence to define user stories, groom backlog, prioritize features, track sprint metrics, and monitor project progress.
• Led the requirements gathering process with the developers to analyze and document legacy codebases into 50+ functional requirement documents enabling cloud migration of legacy data.
• Created and maintained defect tracker sheets facilitating documentation and ensuring timely remediation of issues.
• Designed MuleSoft API specifications and developed, deployed, and monitored MuleSoft APIs.
• Designed and developed SQL queries to retrieve data from Salesforce, SQL Server, etc. ACHIEVEMENTS & DATA ANALYTICS PROJECTS
• Centric Consulting Case Competition – Formulated data-driven business strategies for a logistics company in debt to generate positive cash flow; Secured the 3rd place.
• English Premier League Data Visualization Tableau – Developed a comprehensive interactive dashboard by combining multiple data sources to provide a visual representation of the EPL 2019 season’s title race.
• Exploratory Data Analysis for Regork (Kroger) Python, R – Generated business insights into purchasing trends of customers and sales trends during holidays to increase profitability.
• Bluebox Rentals Database System (Redbox) SQL, MySQL, MS Access – Designed and developed a database system to centralize data and transform the current Point-of-Sale (POS) business model enabling tracking of KPIs. EDUCATION
University of Cincinnati, Carl H. Lindner College of Business Cincinnati, OH Master of Science in Information Systems - STEM designated; GPA: 3.97/4 December 2023