Business Analyst

Rohit Reddy Marreddy

Business Analyst

USA 609-***-**** ***************@*****.***

SUMMARY

* ***** ** ********** ** a Business Analyst with a strong understanding of Business Requirement Gathering, Business Analysis, and Business Process Modeling with a strong focus on delivering actionable insights to drive business decisions.

Proficient in writing complex SQL queries for stakeholders, enabling data-driven decision-making through business analysis, data extraction, and efficient database management across diverse projects.

Skilled in Python for data analysis, automation, and developing predictive models to enable data-driven decision-making.

Leveraged expertise in Agile methodologies to lead projects, enhancing collaboration and efficiency while ensuring high-quality deliverables through detailed test plans and tools like Jira, Rally, and Rational ClearQuest.

Proficient in utilizing AWS services, including S3 for data lake storage and Lambda for automated alerts, enabling efficient data integration and real-time processing within ETL workflows.

Extensive knowledge of HIPAA compliance and medical plans, including HMO, PPO, POS and Medicare/Medicaid, ensuring adherence to regulatory standards in data handling and safeguarding patient data privacy.

Proficiently utilized project management tools including MS Project, MS Excel, MS SharePoint, Asana, and Trello to streamline workflows, allocate resources, and meet project timelines.

Leveraged expertise in data analysis and visualization tools, such as Tableau and Power BI, to provide actionable insights, enabling informed decision-making and enhancing overall business intelligence.

Demonstrated proficiency in CRM systems, including SAP ERP, Salesforce facilitating seamless integration and optimization of customer relationship management processes.

Conducted rigorous Cost/Benefit, Impact, GAP, Risk, and SWOT analysis to inform strategic decision-making, mitigate

risks, and maximize return on investment.

SKILLS

Languages:

SQL, Python, R, SAS

Methodology:

SDLC, Agile, Waterfall, Kanban, Lean Six Sigma, HIPPA, CMS

Documentations:

FRD, BRD, SRS, Test Plan, User Guide, UAT

Project Management Tools:

MS Excel, MS SharePoint, MS Office 365, MS Power Point, Asana,

Tracking Tools:

Jira, HP Quality Center, Rational ClearQuest, RTM

Visualization Tools:

Tableau, Power BI

Business Mapping Tools:

MS Visio, Bizagi, Lucid Charts, UML, BPMN, MS Project

Business Analysis

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

Cloud Computing Platforms:

Snowflake, Amazon Web Services (AWS), Microsoft Azure

ERP Planning & CRM:

SAP ERP, Salesforce Health Cloud, Salesforce Service Cloud

Technical Skills:

KPI, User Acceptance Testing (UAT), Alteryx, Requirement gathering, Data Analysis, MS Visio, Joint Application Development (JAD), MS Office, User Stories, ETL Tools, Snowflake, Data governance, Data Integration, Database Management, Business Intelligence (BI) Tools, Machine Learning Algorithms, Predictive Modeling, Process Mapping, Collibra, Quality Assurance (QA) Knowledge, ServiceNow

Soft Skills:

Time management, Leadership, Management, Problem-solving, Negotiation, Decision- Making, Documentation and Presentation, Verbal communication, Sprint Planning,

Sprint Reviews, Interview Sessions, Team Building, User Stories.

Packages:

NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, TensorFlow, Seaborn, dplyr, ggplot2

EXPERIENCE

Business Analyst Hartford HealthCare, USA Aug 2023 – Current

Extracted clinical data from EPIC databases, including Electronic Health Records (EHRs), lab results, imaging systems, and patient-reported data, and integrated it into a centralized system to enable easier access and comprehensive analysis.

Developed automated reports in Power BI to track HEDIS measures, streamlining the reporting process and improving real-time decision-making for clinical teams, ultimately enhancing patient care outcomes.

Worked with Data Engineers and Data Scientists to extract data from Amazon S3, perform ETL, and integrate it into Snowflake in a structured format, ensuring accuracy, efficient SQL querying, and streamlined analysis.

Utilized Python for data cleaning and data transformation using Snowflake-Connector-Python with libraries like Pandas, NumPy, and PySpark, ensuring high data quality and consistency.

Leveraged AWS services, such as Lambda and S3, for secure data lake storage and automated alert systems, improving operational efficiency and compliance with healthcare regulations.

Designed and executed complex SQL queries to meet business case requirements while maintaining a structured SQL database for patient data, ensuring accurate data retrieval, streamlined analysis, and optimized database performance to support healthcare initiatives.

Established and maintained data dictionaries, data mapping, and data definitions using Collibra as a data governance tool, ensuring data consistency, risk assessments, risk audits and compliance across healthcare systems.

Utilized SAS for analyzing Medicare and Medicaid reimbursement data, including cost reports, Medicare DSH, and bad debts, while implementing notifications for suspicious activities to reduce fraudulent losses related to healthcare claims.

Implemented a new CRM strategy with Salesforce, boosting patient engagement metrics by 20% and improving data accessibility for healthcare providers.

Led a successful transition from Waterfall to Agile methodology, increasing project delivery speed by 25% and improving team collaboration using Jira.

Developed a comprehensive SRS document that streamlined project scope, improving stakeholder alignment, and reducing requirements ambiguity by 10%, facilitated by MS Visio.

Applied advanced Excel functions, including VLOOKUP and PivotTables, to perform comprehensive data analysis, improving reporting accuracy and operational efficiency.

Developed a real-time analytics Tableau dashboard by integrating live hospital admission data and APIs, enabling emergency ward staff to monitor patient influx, optimize resource allocation, and improve response times

Created and reported ad hoc reports on a weekly basis, providing actionable insights into patient care metrics and operational performance to healthcare stakeholders.

Ensured end-to-end HIPAA, CMS compliance by implementing advanced data security measures, safeguarding patient data privacy, and maintaining full regulatory adherence across all data processes and audits.

Business Analyst Tata Consultancy Services (TCS), India Jul 2019 – Jul 2022

Streamlined reporting processes using Tableau and Power BI to generate ad hoc reports and analyze food production and financial metrics, identifying areas for operational improvement, cost-saving opportunities, and enhanced financial forecasting, resulting in a 15% increase in overall efficiency.

Collaborated with the project delivery manager to conduct internal audits across 20+ application teams, creating KPIs and monthly ad hoc reports to ensure compliance with client requirements, enhance process transparency, and improve project delivery efficiency.

Extracted financial and supply chain data from Azure Blob Storage and Azure Data Lake Storage (ADLS), transformed and loaded it into Microsoft Azure SQL Database for structured analysis, enabling business insights through Power BI and Tableau.

Utilized Alteryx for data pre-processing, performing data cleansing, transformation, and enrichment to ensure high-quality datasets for business analysis. Applied joins, aggregations, filtering, and formula tools to structure raw data before storing it in Azure SQL.

Facilitated requirement gathering sessions using BPMN with Bizagi and UML with Lucid chart, streamlining communication between technical and non-technical teams and enhancing project clarity by 20%.

Utilized advanced Excel functions, including VLOOKUP and PivotTables, to analyze and organize production data, achieving a 25% improvement in reporting and supporting better decision-making in food production and supply chain processes.

Implemented Microsoft Purview for data privacy and security, ensuring compliance with regulatory guidelines such as SOX (Sarbanes-Oxley) and GDPR while managing financial and supply chain data governance, access controls and audit trails.

Collaborated on SAP ERP implementation projects, streamlining procurement and financial processes to enhance operational efficiency and data accuracy.

Built machine learning models in Python using TensorFlow, Seaborn, and dplyr to predict future oil product demand, optimizing supply chain efficiency and inventory management.

Created user stories in Jira following Agile Scrum and Kanban methodologies to support the development of internal and web applications, ensuring clear technical understanding for the development team and efficient sprint execution.

Facilitated user acceptance testing (UAT) with comprehensive documentation and test plans created in MS Office, achieving a 20% increase in end-user satisfaction.

Business Analyst Bitinfocom, India May 2018 – Jun 2019

Led risk assessment initiatives by gathering and analyzing business and functional requirements for a credit risk management system, ensuring compliance with Basel III, SOX, and banking regulatory standards.

Conducted financial impact analysis by evaluating loan default patterns, non-performing assets (NPAs), and credit risk metrics, utilizing Excel advanced functions (PivotTables, VLOOKUP, INDEX-MATCH) and Python (Pandas, NumPy) for predictive risk modeling to optimize lending decisions.

Developed and automated Tableau dashboards to track high-risk loan applicants by analyzing credit scores, income levels, and repayment history, enabling risk teams to proactively mitigate financial exposure.

Conducted User Acceptance Testing (UAT) to validate risk classification models before integration and collaborated with development teams to embed risk-assessed customer financial reports into the banking system, enabling automated identification of high-risk customers for informed lending decisions.

Implemented a comprehensive Requirements Traceability Matrix (RTM) to ensure alignment between banking risk models, credit scoring algorithms, and regulatory compliance frameworks, improving audit readiness.

Facilitated Joint Application Development (JAD) sessions with risk analysts, credit officers, and compliance teams to refine risk assessment methodologies and enhance predictive analytics models for fraud prevention.

EDUCATIONS

Master of Science in Business Analytics and Project Management (Aug 2022 – May 2024) - University of Connecticut Stamford Connecticut, USA

Bachelor of Technology in Mechanical Engineering (June 2015 – June 2019) - Velagapudi Ramakrishna Siddhartha Engineering College, India

Contact this candidate