Business Analyst Power Bi

Vineeth Lanka

BUSINESS ANALYST

Michigan, USA M.no: 732-***-**** Email: **************@*****.*** LinkedIn SUMMARY

● Experienced Business Analyst with around 6 years of expertise in requirement gathering, gap analysis, process improvement, and stakeholder management across diverse industries.

● Proficient in SQL, Excel (Pivot Tables, VLOOKUP, VBA), Power BI, and Tableau for data analysis, reporting, and visualization to drive data-driven decision-making.

● Skilled in Agile (Scrum, Kanban) and Waterfall methodologies, with hands-on experience in Jira, Confluence, and Azure DevOps for project management and collaboration.

● Strong understanding of ERP systems (SAP S/4HANA, Oracle ERP), CRM platforms (Salesforce), and BPM tools

(Visio, Lucidchart, Bizagi) for workflow modeling and optimization.

● Expertise in business process modeling (BPMN, UML), user stories, use case documentation, and functional requirements specification (FRS, BRD, SRS) to enhance system efficiency.

● Knowledge of financial modeling, risk analysis, and regulatory compliance (HIPAA, GDPR, SOX) with a strong foundation in data governance and ETL processes for data integrity and compliance.

● Hands-on experience in Data Engineering tools and technologies, including ETL pipelines, data warehousing

(Snowflake, Redshift), and cloud platforms (AWS, Azure, GCP) for efficient data management.

● Proficient in big data frameworks (Apache Spark, Hadoop), workflow orchestration (Apache Airflow), and Python for data processing and automation, ensuring scalable and optimized data solutions. SKILLS

Methodology: SDLC, Agile, Waterfall, Kanban

Programming Languages: SQL, Python, R

Database Management: SQL, MS XS, MS Excel, Requirements Traceability Matrix (RTM) Documentations: FRD, BRD, SRS, User Guide, User Stories, Use cases Project Management Tools: MS Project, MS Excel, MS SharePoint, Asana, Trello, Rally Visualization Tools: Tableau, Power BI,

Business Analysis: Cost/benefit Analysis, Impact Analysis, GAP Analysis, Risk Analysis, SWOT Analysis Tracking Tools: Jira, HP Quality Center, Rational ClearQuest, RTM Cloud Computing Platforms: AWS, Azure

ERP Planning & CRM: SAP, MS Dynamics Nav, Salesforce, HubSpot Technical Skills: KPI, UAT, Test Plans, Alteryx, Requirement gathering, Google Analytics, Data Analysis, MS Visio, JAD, MS 360, Web XP, Software development & testing, Data Modelling, Database Knowledge, Business Intelligence (BI) Tools, Process Mapping, User Experience (UX) Understanding, Quality Assurance (QA) Knowledge, Prototyping Soft Skills: Time management, Leadership, Management, Problem-solving, Negotiation, Decision- Making, Documentation, and Presentation, Verbal communication, Sprint Planning WORK EXPERIENCE

Bank of America, Florida Business Analyst Sep 2023 – Current

● Led risk management initiatives by identifying, documenting, and remediating operational risks, regulatory issues, and audit observations, ensuring a 30% reduction in compliance gaps and improved adherence to SOX and internal control policies.

● Collaborated with cross-functional teams, including Risk Leads and Process Owners, to develop and implement risk mitigation strategies, reducing audit resolution time by 25% and improving operational efficiency.

● Designed and implemented automated ETL pipelines to extract, transform, and load risk-related data, optimizing financial risk assessment and compliance monitoring, cutting manual processing time by 40%.

● Conducted quarterly SOX 302/ITGC reviews, coordinated attestations, and provided governance oversight for access control, version control, and business continuity management, ensuring 100% regulatory compliance in audit reviews.

● Developed and maintained risk dashboards using SQL, Python, and Power BI, enabling real-time monitoring of vulnerabilities, entitlements, and risk-related KPIs, leading to a 20% faster issue resolution rate.

● Spearheaded stakeholder communication across business units and geographies, ensuring seamless project execution and adherence to Agile and Waterfall SDLC methodologies, resulting in a 15% improvement in project delivery timelines. NextGen Healthcare, India Business Analyst Sep 2020 – Jul 2022

● Led a process improvement initiative to optimize workforce administration and staff scheduling systems, achieving a 20% reduction in scheduling errors and cutting overtime costs by 15% through automation and data- driven scheduling with Tableau and Python.

● Collaborated with cross-functional teams to elicit, analyze, and document business requirements, translating them into actionable functional specifications and system designs, utilizing SQL and Power BI for data extraction and visualization.

● Designed and executed User Acceptance Testing (UAT) plans, identifying and addressing 95% of system issues pre deployment, leveraging tools such as JIRA and Excel for defect tracking and reporting.

● Conducted business process analysis using tools like Visio to re-engineer workflows, resulting in a 30% increase in task turnaround time and improved interdepartmental communication.

● Oversaw configuration and optimization of HR, payroll, and benefits systems, reducing payroll processing time by 40% and improving data accuracy by 15%, leveraging SQL for data validation and ETL processes with SSIS.

● Maintained comprehensive documentation, including FAQs and support guides, leading to a 25% reduction in support tickets, while enabling user empowerment through Power Automate-driven self-service solutions.

● Performed data analysis using Python (Pandas, NumPy) and Power BI to identify inefficiencies and bottlenecks, driving a 20% improvement in productivity and service delivery. Infosys, India Business Analyst Jul 2018 - Aug 2020

● 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.

● Conducted in-depth business process analysis and modeling to identify gaps and recommend process improvements, enhancing overall business performance by 20%.

● Designed and implemented a business solution that defined the future state of operations, integrating SAP for Retail to streamline inventory management, reduce costs, and increase sales by 15%.

● Developed comprehensive project documentation, including functional specifications, user manuals, and business cases to support decision-making processes. EDUCATION

Master of Science in Business Analytics and Information Systems Aug 2022 – Aug 2024

– University of South Florida & Tampa, Florida, USA Bachelor of Technology in Civil Engineering. Jun 2014 – May 2018

– Gitam University & Visakhapatnam, India

Contact this candidate