Business Analyst

SKILLS

Methodology:

Agile (Scrum, Kanban), Waterfall, Lean Six Sigma, SDLC

Programming Languages:

SQL, Python (NumPy, Pandas, Matplotlib)

Database Management:

MySQL, PostgreSQL

Documentations:

FRD, BRD, SRS, User Stories, Use Cases, Requirements Traceability Matrix

Project Management Tools:

JIRA, Trello, MS Project, Asana, Rally, Confluence

Visualization Tools:

Power BI, Tableau, Advanced Excel (Pivot Tables, Macros)

Business Analysis:

Cost/Benefit Analysis, Impact Analysis, GAP Analysis, Risk Analysis, SWOT Analysis

Cloud Technologies:

AWS, Salesforce

Technical Skills:

ETL Tools, Statistics, ServiceNow, SSIS, SSRS, MapReduce, Snowflake, Alteryx, Probability Distributions, Confidence Intervals, ANOVA, Hypothesis Testing, Regression Analysis, Linear Algebra, Advanced Analytics, Data Mining, Data Visualization, Data Warehousing, DAX, Power Query, Power Pivot, KPI, UAT,

Requirement Gathering, Data Modeling, Data Analysis, MS Visio, Process Mapping, Alteryx, Prototyping, BPMN, Lucidchart

Soft Skills:

Analytical Thinking, Problem-Solving, Stakeholder Communication, Time

Management, Decision Making, Leadership, Negotiation, Documentation and Presentation, Team Collaboration, Adaptability, Sprint Planning

EDUCATION

University Of North Texas, Denton, Texas

College of Information Master’s in Information Science with a health informatics concentration

Osmania University, Hyderabad

MNR College of Pharmacy Pharm-D

Certification:

Salesforce Certified -Platform Administrator

Salesforce Certified - Platform App Builder

WORK EXPERIENCE

Business Analyst McKesson Corporation, Irving, TX (Remote) Sep 2023 – Present

Responsibilities

Led the development of a comprehensive staffing model for a healthcare provider, optimizing resource allocation by analyzing appointment supply and demand trends using SQL and Tableau, resulting in a 15% increase in scheduling efficiency.

Designed and implemented predictive models using Python and SAS to forecast patient volume trends, enabling data-driven decision- making and improving operational planning accuracy by 20%.

Using tools like Azure Resource Manager (ARM) templates, Bicep, or Terraform for defining and deploying infrastructure Monitoring and managing security policies and compliance across Azure resources. Collecting, analyzing, and acting on telemetry data from your Azure resources to ensure optimal performance and health.

I’ve leveraged Oracle WMS data to generate reports and KPIs, providing actionable insights to management for better decision-making and continuous improvement in warehouse operations.

Partnered with cross-functional teams to create dynamic dashboards in Tableau, streamlining the reporting of key performance indicators (KPIs) such as income, expenses, and utilization metrics, enhancing visibility for senior leadership.

Conducted variance analyses of operational and financial performance, identifying cost recovery opportunities and recommending strategies that achieved a 10% reduction in overall operational costs.

Business Analyst Infosys, India May 2019– Jul 2022

Responsibilities:

Project: 1

•Led the analysis and redesign of business processes and systems for a retail organization, focusing on improving operational efficiency and integrating technology solutions using SAP for Retail.

•Collaborated closely with cross-functional teams to gather and document business requirements, ensuring alignment with the organization's business model and technology strategy.

•Managed stakeholder engagement, facilitating workshops to capture key customer requirements and ensuring seamless communication between technical and non-technical teams.

•I have Configured events within Pendo to track specific user actions or journeys, such as button clicks, page views, or completed tasks also building and maintaining dashboards in Pendo that display key product metrics.

•I have used Pendo’s analytics to identify trends in user behavior, such as changes in feature usage or adoption over time and using this data to make informed decisions.

•Ensuring that data entered InfoLease is accurate, up-to-date, and consistent across the system. Configuring InfoLease to handle different types of leases, asset classes, and accounting methods based on business requirements.

•I’ve been involved in configuring Oracle WMS to meet specific business needs, including setting up location structures, inventory management, and customizing workflows to streamline warehouse operations.

Project: 2

•Led a team of data interns to design and optimize a scalable ETL pipeline using GCP for audio and video data processing, enhancing the system’s capacity to handle 100GB of data daily, while managing project timelines and ensuring seamless scalability.

•Participated in grooming calls and knowledge transfer sessions to support the creation of user stories and ensure alignment between business objectives and technical deliverables.

•Worked closely with Product Managers and Cloud Engineering teams to align business strategies with technical architecture, ensuring the delivery of integrated solutions that adhered to program standards and business objectives.

•Spearheaded automation of data validation and transformation processes, reducing manual intervention by 60% and accelerating time-to-insight for media model improvements, driving efficiency in project execution.

•Developed detailed business requirements and optimized workflows for the ETL pipeline, ensuring alignment with technical specifications and improving the overall media processing for the Voice Synthesizing AI model.

PUBLICATION AND PRESENTATIONS

Thesis

Prevalence of urinary tract infections and resistance patterns of uro-pathogens among women in a tertiary care hospital in Sangareddy dist. of Telangana, India- Submitted to Osmania University, Hyderabad, Telangana, India.

Research Publications

1.Mendem, S., Vinyas, M., Faraz, A. A., Swamy, M. V., & Patil, S. (2020). A retrospective study on the prevalence of urinary tract infections in a tertiary care hospital in Sangareddy district of south India. International Journal of Reproduction, Contraception, Obstetrics and Gynecology, 9(8), 3422.

https://doi-org.libproxy.library.unt.edu/10.18203/2320-1770.ijrcog20203335

2.Faraz, M. A. A., Mendem, S., Swamy, M. V., & Patil, S. (2021). Prevalence of Urinary Tract Infections and Related Anti-Microbial Resistance in India: A Systematic Review and Meta-Analysis. International Journal of Pharmaceutical Sciences and Research, 12(8), 4314-4321.

Review Publications

1.Faraz, A. A., Mendem, S., Swamy, M. V., Patil, S., & Vinyas, M. (2020). Urinary tract infections in women: Treatment options and antibiotic resistance. Journal of Pharmaceutical Sciences and Research, 12(7), 875- 879.

Contact this candidate