Business Analyst Data Analysis

GOWTHAMI KOTTAM

Business Analyst

USA +1-214-***-**** *****************@*****.*** LinkedIn

Summary

Business Analyst with over 4+ years of experience in process optimization, advanced data analysis, and reporting across industries. Proficient in SQL, Tableau, Oracle Cloud, and SSIS, with expertise in data migration, data warehousing, and ensuring regulatory compliance. leveraged SQL, Tableau, and Excel to drive data-driven solutions, reducing operational costs by 20% through optimized forecasting models and real-time reporting, successfully delivering improvements in financial analysis, risk management, and process automation.

Skills

• Methodologies: SDLC, Agile/Scrum, Waterfall

• Documentation: FRD, BRD, SRS, User Stories, Mock-ups, Business Process Flow Diagrams

• Management & Collaboration Tools: MS Project, MS Excel, MS SharePoint, Asana, JIRA, Figma, Confluence, Slack, Teams

• Data Visualization Tools: Tableau, Power BI, Qlik

• ETL Tools: SSIS, SSAS, Informatica, Databricks

• Analytical: Cost-Benefit Analysis, Impact Determination, GAP Analysis, Risk Assessment, SWOT Analysis

• Systems & Processes: Microsoft Visio, JAD (Joint Application Design), Rational ClearQuest, RTM, UAT

• Data Warehousing: Data Marts, Data Lakes, Data Modeling, Data Mapping, ETL, ELT, ODS, OLAP, OLTP

• BI/Reporting Tools: Tableau, Power BI, Qlik, MS Office Suite (Excel, Word, PowerPoint)

• Healthcare & Imaging: DICOM, MRI Image Processing

• Operating Systems: Windows, Linux

Experience

DXC Technology, USA Oct 2023 - Current

Business Analyst

• Collaborated with cross-functional teams to gather requirements and translated them into a data driven solution, leveraging SQL, MS Excel, and Tableau for data analysis.

• Conducted in-depth data analysis using SQL and Excel to identify trends and insights. Prepared intermediate to advanced level of SQL queries using different types of commands – DDL, DML, DCL, TCL, and DQL.

• Developed and implemented interactive dashboards in Tableau by integrating it with SQL server to provide real-time insights into sales performance, customer behaviour, and KPIs, driving a 20% reduction in operational costs through more informed decision- making.

• Increased the efficiency of forecasting models by dividing data in silos and then integrating them with data mapping.

• Streamlined Data Warehousing workflows by optimizing ETL processes with SSIS and Databricks, leading to improved data flow, reporting capabilities, and overall performance across multiple business channels.

• Facilitated the implementation of SAP for enhanced data management, integrating it with existing systems to improve data accessibility and enable advanced cloud-based analytics.

• Assisted the integration of e-commerce platforms with enterprise business systems using SSIS, resulting in a 30% improvement in data accuracy and transparency, significantly enhancing data-driven operations.

• Developed real-time reporting dashboards using SQL, optimizing data-driven decision-making in e-commerce operations.

• Managed complex data migration projects, utilizing Informatica to ensure seamless transitions of historical data across platforms while maintaining strict adherence to GDPR and SOX compliance requirements, mitigating risks and ensuring data integrity. CitiusTech, India Jan 2020 – Aug 2021

Business Analyst

• Conducted requirement-gathering sessions with cross-functional healthcare teams to develop BRDs, FRDs, and SRS documents for the new EHR system, Figma to design intuitive user interfaces that met clinical workflow needs.

• Collaborated with development teams to define user stories, ensuring accurate translation of business requirements into technical specifications.

• Oversaw the integration of EHR systems with existing healthcare applications using SSIS and Informatica, improving data accuracy and patient care efficiency by 25%, while ensuring compliance with HIPAA and HL7 standards.

• Led User Acceptance Testing (UAT) for the EHR system, utilizing Confluence and JIRA for documentation and issue tracking, resulting in a 15% reduction in post-launch defects through proactive testing and rigorous defect resolution processes.

• Created interactive dashboards in Power BI to provide leaders with real-time insights into customer feedback, contributing to a 20% improvement in care quality and a reduction in operational costs.

• Assisted in the creation of training materials and conducted training sessions for end-users, promoting smooth adoption of new systems.

• Managed critical data migration projects using Informatica to transfer patient records and clinical data from legacy systems to the new EHR, ensuring 100% compliance with HIPAA and HITECH Act regulations.

• Assisted Implementation of scalable ETL pipelines using Databricks, enabling real-time data processing and healthcare reporting, improving analytics capabilities and facilitating more effective patient care outcomes.

• Conducted SWOT analysis, risk assessments, and cost-benefit analysis using Excel to assess strategies, successfully reducing overall risk exposure by 15% and aligning business strategies with data-driven insights. Brightmind Technogies, India Oct 2019 – Dec 2019

Business Analyst

• Conducted comprehensive process mapping and analysis to streamline business operations, identifying inefficiencies and implementing targeted solutions, resulting in a 20% increase in operational efficiency and a 15% improvement in process throughput.

• Developed and executed complex SQL queries for data extraction, cleansing, and analysis across multiple data sources, enabling data- driven decision-making and improving decision-making speed by 15%.

• Designed and implemented interactive Power BI dashboards with real-time visualizations, enhancing stakeholder engagement and increasing business transparency by 25%.

• Led requirement gathering sessions, translating business needs into detailed functional specifications, ensuring 100% alignment with client objectives and expectations.

• Managed Agile sprints for cross-functional teams, overseeing backlog prioritization and feature delivery, achieving 95% adherence to project deadlines.

• Facilitated Joint Application Development (JAD) sessions to improve collaboration between business stakeholders and technical teams, increasing cross-functional cooperation and providing clearer project goals by 30%.

• Maintained and tracked business requirements using a Requirements Traceability Matrix (RTM), ensuring 100% compliance with project objectives and successful delivery.

• Conducted cost-benefit analysis and Root Cause Analysis (RCA) to identify operational inefficiencies, implementing improvements that reduced costs by 10%.

Education

Masters of Science in Information Technology Management Aug 2022 – Oct 2023 Campbellsville University Kentucky, USA

Bachelors in Computer science Aug 2017 – May 2021

Sathyabama University, Chennai, India

Contact this candidate