JIRA
Mohit Murthy
Celina,TX
Summary
Senior business analyst with over 6 years of experience in IT project management and business process improvement. Skilled in delivering high-quality software systems and enhancing business processes using agile methodologies. Proficient in leading requirements elicitation, performing thorough GAP and SWOT analyses, and developing interactive dashboards with Tableau and Power BI. Utilized extensive expertise in SDLC, data warehousing, and financial management to ensure project success and stakeholder satisfaction.
Overview
12
12
years of professional experience
4
4
years of post-secondary education
5
5
Certifications
Work History
Senior Business Analyst/Product Owner
SAVVY IT Group Inc.
02.2020 - Current
- Company Overview: Federal National Mortgage Association (Fannie Mae)
- Assisting Manager in ROI Analysis, Feasibility & Complexity Analysis, and Impact analysis to understand the scope, identify important functionalities and risk mitigation for Oracle HCM Fusion, ADP Vantage, Peoplesoft
- Generated Roadmap documents analyzing feasibility & complexity for Workday migration, identified additional migration scope opportunities, and outlined potential benefits for HR/Payroll/Time/Finance integration, significantly improving the process and user experience
- Utilized excel modeling and Data analysis techniques to transform transactional source data into 150+ financial reports for senior leadership presentations across the organization to drive business decisions
- Create capacity-based reports, Head Count (employees) by pulling in datasets using SQL Query from ADP and using Power BI for visualizing reports into Pie charts/graphs for companywide resource planning, which decreased costs by 5%
- Conducting RFI analysis (Request for Information) for HR, Payroll and Time management systems with Ceridian, ADP, UKG, Oracle, and Workday
- Analyzing As-Is and creating To-Be processes as part of Gap Analysis
- Coordinating with numerous business teams to understand the As-Is process and providing a solution to leverage the change in the To-Be process
- Assisting in designing, developing, and testing multiple projects with upgrades and application maintenance/support for Payroll and Corporate & Benefits Accounting
- Assisted developers in identifying parameters required for coding logic in the interface between Oracle HCM Fusion and ADP Vantage, ensuring accurate handling of Retired employees, Group Term Life, Action & Action Reason
- Built and maintained relationships with stakeholders, Business Directors, Developers, and vendor representatives
- Conducted interviews, focus groups, and JAD sessions to gather requirements and identify areas for improvement, resulting in more efficient project execution
- Created and maintained JIRA Dashboards for Vice Presidents/Executives to track project implementation stages for Expense, Benefits Accounting, and Payroll teams, improving project visibility and management
- Gathered business requirements and wrote Functional Design Documents, Process Workflows, and System Requirement Specifications for automating Oracle HCM Fusion to Fidelity Interface, Cartus to Fannie Mae Interface, and ADP Vantage-E-time Upgrade, streamlining processes and improving efficiency
- Created use cases, context diagrams, and business process flow diagrams for system analysis, providing clear and comprehensive documentation to support development and implementation
- Created and executed database SQL queries using SQL Server Management Studio to improve data retrieval efficiency, enhancing capacity and resource planning
- Supported the Payroll team by developing and monitoring macros in Microsoft Access Database, ensuring accurate payroll processing and reducing errors
- Developed test strategies, created Test Plans, Test Scenarios, and Test Cases, and performed various testing types, ensuring successful project implementations for ADP Vantage-E-time upgrade, Oracle HCM Fusion interfaces, and other projects
- Configured, executed, and validated reports in Oracle HCM Fusion, ensuring accurate GTL elections in Informatica and updated records in ADP Vantage
- Monitored the flow of demographic data from Oracle HCM Fusion to ADP Vantage, ensuring all records were captured and discrepancies were analyzed and rectified
- Administered and consolidated reports in Oracle HCM Fusion and ADP Vantage for Benefits data flow, executed Deduction audits using Excel VBA Macros, and corrected Benefits data
- Monitored and validated project and phase codes in DRM, Peoplesoft, and ADP Vantage applications, ensuring active codes for accurate employee time booking
- Supported the Payroll team by implementing Captiva 16.6 system to convert W2 to a spreadsheet, monitored and resolved issues during the conversion process
- Reviewed and approved employees' timesheets bi-weekly as a Practitioner (Super User) of E-Time
- Provided daily and weekly updates to the reporting manager in standup and conference team meetings
- Federal National Mortgage Association (Fannie Mae)
- Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
- Managed backlog prioritization, ensuring alignment with business goals and stakeholder expectations.
- Owned and prioritized product backlog.
Senior Business Analyst
Colsh Consultants LLC
04.2019 - 01.2020
- Company Overview: Federal National Mortgage Association (Fannie Mae)
- Assisting Accounting Manager and Innovation Manager in ROI Analysis, Feasibility & Complexity Analysis, and Impact analysis to understand the scope, identify important functionalities and risk mitigation for Oracle HCM Fusion, ADP Vantage, Peoplesoft
- Analyzing As-Is and creating To-Be processes as part of Gap Analysis
- Assisting in designing, developing, and testing multiple projects with upgrades and application maintenance/support for Payroll and Corporate & Benefits Accounting
- Gathering Business Requirements and writing Functional Design Documents, Process workflows, System Requirement Specification and UML Diagrams for the automation process of Alteryx workflow, Oracle HCM Fusion to Fidelity Interface, Cartus to Fannie Mae Interface and ADP Vantage-E-time Upgrade
- Supported the Payroll team by monitoring and developing macros in Microsoft Access Database, delivering maintenance support, and assisting in shakeout testing of the Access PayData Template tool, ensuring smooth payroll operations
- Developed test strategies, created Test Plans, Test Scenarios, and Test Cases, and performed Regression Testing, Shakeout Testing, and facilitated User Acceptance Testing and Defect Tracking for multiple projects, ensuring high-quality project outcomes
- Executed and validated Group Term Life reports in Oracle HCM Fusion, running GTL elections in Informatica and updating ADP Vantage based on validation results, ensuring accurate employee benefits data
- Monitored the flow of demographic data of employees from Oracle HCM Fusion to ADP Vantage, ensuring all records are captured and discrepancies are analyzed and rectified, maintaining data integrity
- Monitored and validated project codes and phase codes in DRM, Peoplesoft, and ADP Vantage applications, ensuring codes are active and employees book their time accurately, supporting project management
- Reported updates to the reporting manager in Standup and conference team meetings, ensuring clear communication and alignment on project progress
- Federal National Mortgage Association (Fannie Mae)
Business Analyst
BSASPEC Inc.
09.2018 - 04.2019
- Assisted and worked with Project manager in creating and assigned task through WBS
- Gathered user requirements and expectations from customers and internal stakeholders to create Business Requirements Document, Functional Requirements Document, and SRS
- Identified and collaborated with stakeholders based on their influence and decision-making to ensure project success
- Examined inputs and ensured maintenance of information on scheduled activities, follow up on successful accomplishments and coordinate IT portfolio input ensuring prompt submission of initial budgets and quarterly updates
- Analyzed Business Requirements and developed System Specifications to meet project goals
- Created UML Diagrams like Activity Diagram, Sequence Diagram, and Use Case Diagram using Rational Rose, improving project documentation clarity
- Tracked and reported timely performance of plans and analyzed gaps and recommended corrective measures
- Assessed business priorities and advised business units by performing Risk Analysis, leading to more informed decision-making and risk mitigation
- Collaborated with the testing team to develop and prepare the Test Plan, ensuring testability, reliability, usability, maintainability, and performance of the application, which enhanced overall software quality
- Managed incident reporting and change management procedures using Clear Case, ensuring smooth and efficient handling of system changes and issues
- Managed and shared documents with MS SharePoint, and logged defects using HP QC tool, improving team collaboration
- Designed and implemented SQL queries for QA testing and data validation, enhancing reporting accuracy
- Planned and organized team engagement activities to encourage self-organization, boosting team productivity
Technical Support Assistant
Johnson and Wales University
06.2017 - 05.2018
- Resolved customer issues in a clear, courteous, and straightforward manner
- Always demonstrated professionalism and courtesy with customers
- Identified and solved technical issues with a variety of diagnostic tools
Vendor Manager/Business Analyst
Swiggy Operations Office
07.2016 - 12.2016
- Co-ordinated with the sales team to understand the universe of partner restaurants and prospective restaurants
- Coordinated visits to restaurants to sample their food and collect their business information
- Ensured smooth and transparent business with our partner restaurants
- Managed a team of 7 vendor managers who oversaw bringing restaurants on board
Customer Service Associate Senior and Communication Trainer
Amazon Pvt. Ltd.
07.2013 - 06.2016
- Described product to customers and accurately explained details of merchandise on phone, chat, and email, resulting in improved customer satisfaction and reduced return rates
- Designed and implemented communication skills modules for new hires and production teams, leading to a 20% increase in training effectiveness and faster onboarding times
- Recognized communication issues timely and actively worked on changing behavior, resulting in a 15% improvement in team communication efficiency
- Conducted audits to regularly score Associates on the language content of contacts, improving overall communication quality and customer satisfaction scores
- Collaborated with associates and team leads to identify development opportunities in communication, soft skills, and presentation skills, resulting in a 10% improvement in team performance and individual growth
- Conducted training sessions for team leaders and SMEs on Voice and Accent (V&A), utilizing MS Visio for visual aids, resulting in improved communication skills and customer satisfaction
Education
Master - Business Administration
Johnson & Wales University
Providence, RI 03.2017 - 05.2018
Bachelor - Commerce
Indian Institute of Management and Commerce
06.2010 - 05.2013
Skills
Business Analysis
Product Management
Problem Solving
SQL Querying
Agile methodology
Stakeholder management
Requirements gathering
User acceptance testing
Data analysis
Project management
Gap analysis
Problem-solving
Change management
Problem-solving abilities
Certification
International Scrum Institute certificate: Scrum Master Accredited Certification
Accomplishments
- Resolved product issue through consumer testing.
- Used Microsoft Excel to develop inventory tracking spreadsheets.
- Collaborated with team of 8 in the implementation of Workday.
- Delivered customer value through effectively helping with Backlog prioritization.
Timeline
Senior Business Analyst/Product Owner
SAVVY IT Group Inc.
02.2020 - Current
Senior Business Analyst
Colsh Consultants LLC
04.2019 - 01.2020
Business Analyst
BSASPEC Inc.
09.2018 - 04.2019
Technical Support Assistant
Johnson and Wales University
06.2017 - 05.2018
Master - Business Administration
Johnson & Wales University
03.2017 - 05.2018
Vendor Manager/Business Analyst
Swiggy Operations Office
07.2016 - 12.2016
Customer Service Associate Senior and Communication Trainer
Amazon Pvt. Ltd.
07.2013 - 06.2016
Bachelor - Commerce
Indian Institute of Management and Commerce
06.2010 - 05.2013
Software
Confluence
ADP Vantage
Workday
ThoughtSpot
PowerBI
Captiva
Blackline
Microsoft 365
Genesys DX
CARA cloud
SAP Concur
Sharepoint
PowerApps
Tableau
Languages
English
Full Professional
Hindi
Full Professional
Marathi
Full Professional
Telugu
Full Professional