Business Analyst Power Bi
Resume:
Vamsi Krishna
Business Analyst
+1-618-***-**** *******************@*****.*** St louis, MO
SUMMARY
Business Analyst with 3+ years of experience specializing in Business Requirement Gathering, Analysis, Business Systems Integration and Process Modeling. Expert in creating detailed BRDs, FRDs, and SRS to ensure clear communication and alignment between stakeholders and development teams. Skilled in conducting cost/benefit, impact, GAP, risk, and SWOT analyses to support decision- making. Extensive experience with Waterfall, Agile, RUP, and Scrum frameworks for effective project delivery. Proven ability to facilitate JAD sessions and engage with SMEs to elicit and define functional requirements. Proficient in using tools like MS Project and MS SharePoint to plan, schedule, and monitor project progress. Skilled in designing dashboards and decision support tools using Tableau and Power BI for actionable insights and strategic planning. SKILLS
Methodologies: SDLC, Agile/Scrum, Waterfall, Kanban Languages & Tools: Tableau, Power BI, MS Excel, MS Access, MS Visio, R, SQL, Python Python and R Libraries: Pandas, NumPy, SciPy, Ggplot2, dplyr, data-table, SparkR, rpart, R shiny Data Visualization Tableau, Power BI, SSRS
Requirements Gathering: Joint Application Development (JAD) sessions, interviews, surveys, document analysis Documentation Business Requirements Document (BRD), Functional Requirements Document (FRD) Process Modeling: As-Is and To-Be Process Models, Value Stream Mapping, BPMN, UML Diagrams Stakeholder Management: Stakeholder Analysis, Negotiation, Workshop Facilitation, Meeting Facilitation Reporting Tools: Tableau, SSRS, Business Intelligence Dashboards ETL Tools: SSIS, SSAS, Data PipeLines, OLAP, OLTP
Databases: MySQL, MS SQL Server, Teradata, Oracle, MongoDB (for NoSQL) Business Intelligence: Data Analytics, KPI Development, Dashboard Creation, Ad-hoc Reporting Process Modeling: BPMN, UML, As-Is and To-Be Process Mapping Version control tool: GIT
Operating Systems: Windows, Linux
Other Tools: JIRA, MS Office, OLAP, OLTP, KPI
Tracking/Software/Other Skills: Rational ClearQuest, RTM, UAT, Lucid chart, ETL Process, ELT Process, ERP Systems, Test Outlines & Test Cases, Use Case Mapping, Business Requirements, Confluence, Smartsheet, Google Analytics, Business Analysis, Business Intelligence, Data Analytics, Salesforce
Data Analysis and Management:
Proficient in data extraction, transformation, and loading (ETL), data profiling, quality improvement, and leveraging BI tools for reporting and visualization.
Proficient in creating Reports, Dashboard, aggregates, Hierarchies, Charts, Filters, Quick filters, Table calculation, trend lines calculated measures in Tableau.
Good knowledge of data analytics, data reporting, Ad-hoc reporting, Graphs, Scales, PivotTables and OLAP reporting. Financial Acumen and Problem Solving:
Skilled in building ROI models for care management programs, identifying care gaps, and applying critical thinking to develop innovative solutions.
Good communicative, interpersonal, intuitive, analysis, leadership skills, a quick starter with the ability to master and apply new concepts. EDUCATION
Master in Information Technology Management Webster University, St Louis, MO, USA Bachelor of Engineering in Electrical and Electronics Reva University, Bangalore, India Diploma in Electrical and Electronics Engineering Madanapalle Institutes of technologies and science, India EXPERENCE
Capital One, USA Nov 2023 - Current
Business Analyst
Developed interactive dashboards and reports using Tableau and Power BI, translating complex business data into actionable insights for stakeholders.
Designed and automated financial reports to track key performance indicators (KPIs), operational expenses, and revenue trends.
Led business systems integration projects, ensuring seamless communication between proprietary applications and enterprise systems.
Facilitated Joint Requirement Planning (JRP) and JAD sessions to elicit requirements and define system improvements.
Conducted Business GAP Analysis and provided solutions for process enhancement.
Created various complex SSAS cubes with usage-based aggregations, KPIs and calculate members and used appropriate storage modes for them.
Entering Tickets for the product line into TFS, and assess them through the TFS board, later routing them to the Kanban boards according to the division or particular specifications.
Facilitated Joint Requirement Planning (JRP) sessions to gather and analyze requirements collaboratively.
Documented and analyzed specifications for enhancing a scalable and efficient system.
Conducted Business GAP Analysis to identify disparities and proposed solutions for proposed enhancements and new requirements.
Collaborated with the development team to address any issues or changes during the sprint.
Contributed to sprint reviews, providing insights into the achieved enhancements and addressing feedback.
Performed feasibility studies by mapping current (AS-IS) and future (TO-BE) business processes.
Collaborated with Subject Matter Experts (SMEs) to identify and create a Business Requirements Document (BRD) and Functional Requirements Document (FRD).
Defined and managed user story acceptance criteria to ensure precise and efficient testing and validation within Agile frameworks.
Designed and maintained interactive dashboards and reports in Tableau, providing stakeholders with real-time insights into key performance indicators and critical business metrics.
Conducted Gap Analysis to compare As-Is and To-Be processes, identifying and addressing gaps to optimize business operations.
Led the implementation of incremental and full-load ETL processes, improving data pipeline efficiency by 35%.
operational efficiency.
Utilized CRM to manage client contacts, tracking and documenting interactions and communications Supported engineers in analyzing and performance data and identifying and optimization opportunities. Agva Healthcare Pvt. Ltd, India Jan 2020 - Dec 2021 Business Analyst
Enhance health IT policies to improve cybersecurity, achieving a 38% increase in preventive measures.
Utilize patient-level social risk data to support care plans, resulting in a 67% increase in effectiveness.
Facilitate integration of clinical information across healthcare sources, improving care coordination and workflows by 48%
Developed business process models in Agile & Waterfall to document existing and future business processes.
Developed programs with manipulate arrays using Python libraries like NumPy, Pandas, and SciPy.
Created Ad-hoc charts like donut charts, Funnel charts, analytical models used for the Dashboard and modified existing Tableau workbook stories and added Action filters.
Used R and Tableau for Visualizations, Summary Reports and Presentations.
Used R packages like dplyr, tidyr & ggplot2 in R Studio for data visualization and generated scatter plot and high low graph to identify relation between different variables.
Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
Created various complex SSAS cubes with usage-based aggregations, KPIs and calculate members and used appropriate storage modes for them.
Resolved Several problems and documented troubleshooting documents.
Designed and developed Relational Database Management System using MySQL and SQL Server.
Contact this candidate