Data Analysis Business Process

Udhay J

Location: Memphis, TN Phone: 901-***-**** Email: *****.***@*****.***

Over 3 years of experience as a Business Systems Analyst across banking, pharmaceutical, and CRM integration projects.

Expertise in data analysis, business process optimization, and system integration using SQL, Microsoft Excel, Power BI, and Tableau.

Proficient in designing interactive dashboards and data visualizations for real-time business performance monitoring.

Strong skills in business process mapping and workflow optimization using Microsoft Visio/Lucidchart.

Extensive experience in gathering and documenting business requirements (BRD, FRD, Use Cases, User Stories).

Skilled in managing project workflows and tasks using Agile methodologies (JIRA/Trello).

Led Salesforce CRM integrations to streamline customer data management and improve productivity.

Proficient in automating repetitive tasks to improve operational efficiency and reduce manual effort.

Designed and delivered wireframes and prototypes using Balsamiq/Figma to enhance UI/UX.

Delivered actionable insights through automated reports and dashboards, supporting data-driven decision-making.

Reduced loan-processing time by 20% and improved inventory forecasting accuracy by 15%.

Strong collaborator with cross-functional teams and stakeholders, ensuring successful project outcomes.

TECHNICAL SKILLS

Data Analysis and SQL – Data extraction, cleaning, providing actionable insights for business decisions.

Microsoft Excel – Pivot Tables, VLOOKUP, data analysis, and reporting.

Business Intelligence (BI) Tools – Power BI, Tableau

Process Mapping and Documentation – Microsoft Visio, Lucidchart, Gap analysis.

Agile Project Management – JIRA, Trello – Task tracking.

CRM Systems – Salesforce – Integration, data management, and customer analytics.

Programming for Data Analysis – Python, R – Advanced data analysis, trend prediction, and automation of business processes.

Cloud Platforms – AWS, Azure – Data storage.

Wireframing and Prototyping – Balsamiq, Figma – UI/UX design and prototypes for system enhancements.

Business Requirement Documentation – BRD, FRD, Use Cases, User Stories – Gathering and documenting business requirements.

Automation Tools – Automation of reporting and business processes to improve operational efficiency.

Education

Master in Computer Science University of Memphis May 2024 Memphis, TN

PROFESSIONAL EXPERIENCE

AP Task, Jan 2024 - Present

Business System Analyst

Conducted in-depth data extraction, cleaning, and analysis using SQL, providing insights that drove business process optimization and data-driven decision-making.

Utilized Microsoft Excel (Pivot Tables, VLOOKUP) to analyze key business trends, ensuring accurate reporting and informed decision-making.

Developed and maintained interactive Power BI/Tableau dashboards, enabling real-time monitoring of business performance and key metrics.

Mapped and documented business processes using Microsoft Visio/Lucidchart, identifying inefficiencies and implementing solutions to improve workflow efficiency.

Conducted gap analysis to assess and improve business processes, recommending and executing strategies for continuous operational improvements.

Led the integration of Salesforce CRM with internal systems, streamlining customer data management and automating workflows to improve productivity.

Gathered and documented comprehensive business requirements, creating BRD, FRD, Use Cases, and User Stories to guide system enhancements and process optimizations.

Collaborated with cross-functional teams to align business needs with technical solutions, ensuring smooth project execution and stakeholder satisfaction.

Managed project tasks and timelines using JIRA/Trello, participating in Agile sprint planning, stand-ups, and retrospectives to ensure project progress and team alignment.

Utilized Python and R for advanced data analysis and automation, creating models to predict trends and automate business processes.

Assisted in cloud migration efforts to AWS and Azure, ensuring seamless data storage and system scalability for improved performance.

HDFC Bank Jun 2021 – July 2022

Business Analyst

Conducted customer transaction analysis using SQL, providing data-driven insights to support business decision-making.

Analyzed loan approval rates, demographics, and financial risk factors using Microsoft Excel (Pivot Tables, VLOOKUP) to drive business strategy.

Designed and developed interactive dashboards in Power BI/Tableau, enabling real-time tracking of loan performance and customer engagement.

Mapped and optimized loan processing workflows using Microsoft Visio/Lucidchart, streamlining operations and reducing inefficiencies.

Performed gap analysis to identify process inefficiencies, recommending and implementing changes to enhance business operations.

Automated manual reporting tasks, reducing effort by 25% and improving data accuracy for business analysis.

Collaborated with stakeholders to gather and document business requirements, ensuring alignment with organizational goals and compliance standards.

Developed and maintained BRD, FRD, Use Cases, and User Stories to support system enhancements and process improvements.

Managed project deliverables using JIRA/Trello, facilitating task tracking and Agile workflows.

Participated in Agile stand-ups, sprint planning, and retrospectives, fostering collaboration across teams.

Created wireframes and prototypes using Balsamiq/Figma, enhancing UI/UX for digital banking platforms.

Supported the integration of Salesforce CRM, improving customer data management, lead tracking, and engagement analytics.

Led training sessions for business users, ensuring smooth adoption of new tools and dashboards.

Reduced loan-processing time by 20% through workflow optimization and automation, improving overall efficiency.

Delivered actionable insights through automated reports and dashboards, strengthening data-driven decision-making.

Enhanced customer experience and operational performance by implementing process improvements and data visualization strategies.

Apollo Pharmacy May 2020 - May 2021

Business Analyst

Analyzed and optimized large datasets using SQL to extract actionable insights, enhancing inventory management and sales forecasting.

Leveraged Microsoft Excel (Pivot Tables, VLOOKUP, and Charts) to conduct data analysis and support strategic decision-making.

Developed and maintained interactive dashboards in Power BI/Tableau, enabling real-time business performance monitoring.

Conducted business process analysis and created workflow diagrams using Microsoft Visio/Lucidchart to identify inefficiencies and recommend optimizations.

Performed gap analysis to assess existing processes and implement data-driven improvements, enhancing operational efficiency.

Automated repetitive tasks, reducing manual effort by 30% and increasing overall productivity.

Collaborated with stakeholders to gather, document, and refine business requirements, ensuring alignment with organizational goals.

Created comprehensive Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Use Cases, and User Stories to guide development teams.

Defined acceptance criteria and participated in User Acceptance Testing (UAT) to validate system functionality and ensure compliance with business needs.

Managed project workflows using JIRA/Trello, tracking tasks, sprint planning, and supporting Agile project execution.

Engaged in daily stand-ups, sprint planning, and retrospectives, coordinating cross-functional teams to drive project success.

Led stakeholder meetings to clarify business needs, ensuring seamless communication between technical and non-technical teams.

Designed wireframes and prototypes using Balsamiq and Figma to enhance UI/UX and streamline system enhancements.

Assisted in Salesforce CRM integration with inventory databases, improving operational efficiency and data accessibility.

Enhanced inventory forecasting accuracy by 15%, minimizing stock shortages and optimizing supply chain management.

Automated reporting processes to support data-driven decision-making, improving response time for business insights.

Contact this candidate