Data Analyst Power Bi

G BALA PRASAD

New York, USA +1-845-***-**** ****.**********@*****.***

SUMMARY

Accomplished Business/Data Analyst with extensive experience in leveraging advanced analytical tools and methodologies to drive business insights and eƯiciencies. Proven track record in utilising SQL, Python, and AWS for data processing, modelling, and reporting. Demonstrated expertise in statistical analysis, machine learning algorithms, and data visualisation using Tableau and Power BI. Adept at conducting GAP analysis, improving reporting eƯiciency by 10%, and reducing operational costs by 20%. Skilled in managing functional and non-functional business requirements using Jira and Kanban. Proficient in SDLC methodologies including Agile and Waterfall. SKILLS

Programming Languages: SQL, Python, R

Databases: MS SQL Server, Oracle, MySQL, NoSQL, PostgreSQL, MongoDB, Cassandra

Tools/Frameworks: Jira, Confluence, Power BI, Tableau, Apache Spark, Hadoop

Web Technologies: Microsoft Excel, Microsoft Word, HTML, JavaScript, CSS, Bootstrap, PowerPoint

Business Analysis & Processes: User Requirements Gathering, Project Management, Change Management, UAT, Process Mapping, Deployment, Stakeholder Collaboration, User Stories, Business Requirement Analysis, Business Process Modeling, Business Intelligence, Business Rules, Data Requirements, Project Scope

Documentation: FRD, BRD, SRS, Use Cases, Process Flow Diagrams, Technical Requirements, Business Requirements, Technical Design, Data Flow Diagrams

Methodologies: SDLC, Agile/Scrum, Waterfall, Lean, Kanban, DevOps

Soft Skills: Time Management, Leadership, Problem-Solving, Negotiation, Decision-Making, Written and Verbal Communication, Ability to Prioritize, Attention to Detail, Critical Thinking, Highly Organized, Analytical, Accuracy, Contextual Decision Making, Commercial Awareness, Team Collaboration

Project Management Tools: MS Project, MS SharePoint, Trello, Asana, Monday.com

Visualization Tools: Tableau, Power BI, QlikView, Looker, Google Data Studio

Analysis Skills: Cost/Benefit Analysis, Impact Analysis, GAP Analysis, Risk Analysis, SWOT Analysis, Data Analysis, Risk Management, Issue Management, Research, Data Mining

Tracking/Other Skills: Microsoft Visio, HP Quality Center, JAD, RTM, Selenium, JMeter

Operating Systems: Windows, Linux, macOS, Unix

EXPERIENCE

Business Analyst

Assurant

09/2023 to Current

USA

Streamlined financial business processes by conducting comprehensive As-Is and To-Be analysis, identifying ineƯiciencies, and implementing targeted improvements that enhanced operational eƯiciency and stakeholder satisfaction.

Facilitated cross-functional requirement gathering sessions through workshops, stakeholder interviews, and collaborative meetings, resulting in clear project scopes, aligned objectives, and timely deliverables.

Automated manual workflows by designing and deploying Excel-based solutions using VBA and Macros, reducing repetitive data entry by 70% and saving 10+ hours per week for finance teams.

Implemented data security controls within Excel models through advanced VBA scripting, achieving a 90% reduction in unauthorized edits and ensuring high data integrity and audit readiness.

Developed interactive dashboards in Power BI, providing real-time visibility into key financial and operational metrics, empowering executives with actionable insights for strategic decision-making.

Led cross-departmental initiatives to design and implement customer segmentation strategies, improving campaign targeting eƯectiveness by 15% and boosting customer satisfaction ratings by 10%.

Built predictive churn models leveraging statistical techniques and machine learning algorithms, reducing customer attrition by 20% through targeted retention strategies.

Performed complex SQL queries to extract, cleanse, and analyze data from relational databases, uncovering process bottlenecks and enabling data-driven optimizations across key business functions.

Collaborated with stakeholders across finance, marketing, and operations to transform data insights into high-impact recommendations, driving continuous improvement and business value.

Business Analyst

Intercontinental Exchange

09/2019 to 11/2021

Hyderabad, India

Designed and implemented serverless solutions using AWS Lambda and Azure Functions, significantly improving application scalability, reducing infrastructure costs, and eliminating dependency on traditional servers.

Automated routine analytical tasks with Python scripting, enabling early detection of business trends and triggering real-time alerts—resulting in a 40% reduction in manual analysis time and 50% fewer ad-hoc report requests.

Architected and optimized ETL pipelines for ingesting and transforming large-scale customer and transactional datasets, ensuring clean, validated, and consistent data across business systems.

Utilized enterprise-grade data warehousing platforms (e.g., Amazon Redshift, Snowflake) to streamline data storage, improve query performance, and support scalable analytics.

Employed CI/CD pipelines (e.g., GitHub Actions, Jenkins) and Agile project management tools (e.g., JIRA, Azure DevOps) to enhance deployment velocity, reduce integration errors, and support continuous delivery practices. Business Analyst

Paytm

01/2017 to 08/2019

India

Partnered with cross-functional teams to evaluate business needs, define analytics requirements, and translate technical data outputs into actionable business insights supporting strategic goals.

Led business and data discovery sessions with stakeholders to gather functional requirements, define KPIs, and identify key data sources for enterprise reporting.

Created and maintained data dictionaries and mapping documents, ensuring transparency in data flow across systems and reducing onboarding time for new analysts by 30%.

Analyzed data from multiple sources (structured and semi-structured) using SQL and visualization tools to monitor business performance and uncover revenue and cost-saving opportunities.

Collaborated with engineering teams to support data ingestion into a centralized Data Lake architecture, facilitating unified access to customer and product data for analysis and machine learning applications.

Contributed to data pipeline testing and documentation, ensuring successful migration and transformation of legacy ETL logic to modern, cloud-compatible architectures.

Provided impact analysis and gap assessments for upstream data source changes, reducing unplanned reporting failures and improving system resilience. EDUCATION

Master of Science: Computer and Information Sciences Marist University

2023

USA

Contact this candidate