Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Software
Languages
CustomerServiceRepresentative

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

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

JIRA

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

Similar Profiles

CREATE PROFILE
Mohit Murthy