Business Analyst

Harshwardhan Deshmukh

Columbus, OH ***** *********@*****.*** +1-216-***-**** http://www.linkedin.com/in/harshwardhan-deshmukh-a07a3a120

Education

Cleveland State University, Monte Ahuja College of Business GPA:3.66 Cleveland, Ohio

Master of Science (M.S) in Information Systems Scholarship Award for excellence

Rajiv Gandhi Prodyuogiki Vishwavidyalaya GPA:3.3 Indore, India

Bachelors of Technology(B.Tech) in Electronics and Communication

CERTIFICATIONS & SKILLS

Certifications

Ready, Set, Agile! Virtual Experience Program, Programming for Everybody, AWS Cloud Foundations

Programming Languages

SQL, Python

Tools

Salesforce, Tableau, Office 365 suite, MS Excel, Microsoft PowerBI, MS Visio, Rational Rose, Axure, Adobe Photoshop, Rational ClearQuest, Rational Clear Case, MS Visio, UML, TFS, IBM BAW, IBM BPM, MS project

Cloud, Framework

MS Access, Amazon Web Services, Microsoft Azure DevOps, JIRA, Confluence

Database

MongoDB, MySQL, Oracle, MSSQL, SAS, DBMS

EXPERIENCE

Altruist Technologies Indore, India

Business System Analyst August 2020 – August 2021

Documented and analyzed Altruist’s IBM Cloud PAK migration project for user validation in the organization's cloud service.

Facilitated communication between IT team and stakeholders, while maintaining technical documentation like WBS, Need assessment, RACI matrix, Change Management and Budget.

Developed expertise in Java, J2EE, Spring Boot, and HTML5, contributing to complex client projects.

Processed data using MySQL and Pl/SQL to identify trends, regression suggesting optimizations for business alignment.

Aided internal audit utilizing Auditing Command Language analytics to audit results and create visualizations for data analysis.

Created accurate UML Diagrams with Microsoft Visio to enhance system interaction understanding.

Conducted interviews and JAD sessions involving developers, senior stakeholders, and sponsors to gather comprehensive business and functional requirements.

Analyzed business problems, elicited requirements, and translated them into actionable deliverables for developers.

Collaborated with cross-functional teams to design, develop, and integrate systems in complex environments.

Streamlined cross-platform data processing by Implementing robust error handling mechanisms to deal with exceptions and failures during data processing., resulting in 25% improved accuracy and efficiency.

Utilized IBM process manager to introduce a feedback loop in the system which resulted in reduced B2B data exchange processing time by 30%.

Developed robust test cases for Medicaid systems, achieving a 95% defect detection rate.

Conducted gap analysis for EDI, reducing error rate by 20%.

Provided subject matter expertise for project overviews, created risk registers and risk mitigation strategies like Risk Avoidance, Reduction, Risk Transfer, Risk Acceptance and Diversification, reducing project risks by 15%.

Protomac Systems Indore, India

Associate Business Analyst September 2019 – August 2020

Proposed and assisted transition from waterfall to agile for website maintenance, creating tailored business requirement documents.

Enhanced Performance utilizing techniques like caching, parallel processing, and load balancing.

Managed project schedule, Gantt chart and workflow using MS Project's WBS structure.

Analyzed requirements and provided Saudi Arabian customer-specific solutions.

Delivered effective presentations and communicated with stakeholders at all levels.

Utilized collaboration tools like Mural and Azure Boards for efficient project management.

Proactively solved problems, offering innovative solutions with attention to detail.

Committed to understanding banking and insurance industries for tailored client solutions.

Improved SCRUM and Agile processes by smarter resource allocation, cutting project timelines by 40%.

Prioritized business needs through data analysis for better tech alignment.

Bridged communication by surveying and interviewing technical and non-technical stakeholders.

Created templates for documentation currently in use even after 4 years.

Enhanced user experience by translating technical requirements for designers.

Created user stories and test cases, ensuring software met expectations.

Acted as a transparent liaison for project updates to stakeholders through daily standup meetings, presentations, and client communication.

Proactively monitored tech trends, suggesting process improvements.

ACADEMIC PROJECTS

Conversion of an Electronic Health Records September 2022 – December 2022

Assisted Ohio State College of Medicine's Radiology Centre in identifying certified electronic health records for WHO.

Achieved 100% adherence to stage 1 meaningful use criteria for "CSU' 22" proposal.

Implemented Agile methodologies, conducted gap analysis, and created comprehensive business requirements using MS Office and MS Project.

Converted uncertified EHR to certified EHR with <0.1% unforced error rate.

Meat Delivery Ecommerce May 2022 – October 2022

Created project schedule with budget and Risk Register for a Meat Delivery Application, including Gantt Chart for resource allocation and risk analysis.

Led meetings on process re-engineering, system enhancements, and BI report development, collaborating with MicroStrategy, Teradata, and ETL teams.

Conducted root cause analysis, defined key deliverables, and estimated a 22% increase in Halal Meat consumption using MS Visio.

Assumed leadership role in Business Intelligence report development, contributing to improved efficiency and product backlogs.

APP-ointments December 2021 – April 2022

Developed a MySQL and Invision application to automatically reschedule COVID-19 impacted appointments.

Implemented Risk Severity Index, Resolved Point of Sales (POS) issues and ensured smooth transaction processing. Created Use Cases and Workflow Diagrams using MS Visio and Excel. Coached new Scrum masters for improved backlog understanding. Collaborated with Oracle teams to integrate Oracle Demantra with E-Business Suite R12.

The results analyzed using MS Excel showed reduced cancellation rate by 60% and increase in rescheduling of appointments by 92%.

Data-Driven Customer Experience Enhancement in Banking May 2022- Oct 2022

As a Business Analyst, I led the "Data-Driven Customer Experience Enhancement in Banking" project.

This initiative aimed to leverage customer data insights to improve satisfaction and operational efficiency within the Bank of America.

I collaborated with cross-functional teams, gathered requirements, analyzed customer data, and designed solutions to streamline processes and deliver personalized experiences.

Through customer journey mapping, solution design, and UAT, we enhanced services, optimized operations, and fostered data-driven decision-making.

This project led to improved customer satisfaction, targeted marketing, and operational effectiveness.

Contact this candidate