Data Analyst Power Bi

Prasanna P

Data Analyst

302-***-**** ********.*@************.*** Newark, DE

Professional Summary

5+ years of experience as a Data analyst in data cleaning, transformation, and validation, ensuring data accuracy and consistency enables me to extract valuable insights from complex datasets and deliver actionable recommendations.

Proficient in leveraging industry-standard tools such as Power BI, Tableau, Servicenow and Python (Pandas, NumPy, Matplotlib) to extract actionable insights from complex datasets.

Proven track record in writing detailed business requirements, interpreting technical architecture, and delivering new product features in Agile environments.

Expertise in AWS cloud technologies, including S3, EC2, Redshift, QuickSight, SageMaker, and other AWS services, for data storage, processing, analysis, and visualization.

Strong experience with API-based designs, SQL-based data analysis, and cross-functional collaboration to drive data solutions aligned with business needs.

Skilled in cleansing, transforming, and validating data to ensure accuracy and consistency, employing techniques like data imputation, outlier detection, and normalization.

Work Experience

Allstate, DE BI Analyst/ Data Analyst Jan 2024 – Present

Worked closely with cross-functional teams in an Agile environment, facilitating discussions between business and IT to ensure data-driven decision-making.

Utilized JIRA to track and manage project progress, user stories, and sprint backlogs, ensuring efficient workflow and project transparency.

Developed custom SQL scripts and Python workflows to analyze ServiceNow ticket trends, SLA compliance, and resolution times, helping reduce average ticket closure time by 20%.

Interpreted technical architecture documentation and API-based designs to support integration of internal reporting tools with ServiceNow, contributing to enhanced data flow and automation.

Provided actionable insights via interactive dashboards (Power BI, QuickSight), helping stakeholders make informed decisions that improved business processes.

Designed and maintained automated data systems and dashboards using Power Apps and Power Automate for internal reporting and process improvement.

Supported quality assurance efforts and generated analytical reports to monitor service levels and inform OCFH leadership.

Developed training documentation and conducted onboarding sessions for staff using Power Platform tools and related reporting systems.

Designed and maintained enterprise data systems leveraging Power Platform tools (Power BI, Power Apps, SharePoint) for internal analytics and reporting.

Utilized Python and R to build automated scripts for data transformation, statistical analysis, and visualization supporting cross-functional stakeholders.

Supported public sector-style reporting structures and compliance requirements, aligning with standards commonly found in government and nonprofit environments.

Led feature delivery initiatives in Agile sprints by gathering business requirements, prioritizing deliverables, and communicating effectively across business and IT teams.

Presented findings and recommendations to business leaders, contributing to a 15% improvement in decision-making speed.

Enforced best practices for data governance, version control, and quality checks, contributing to smooth development processes and change management in an Agile setting.

Kpit Technologies, India Data Analyst Sep 2020 – Jul 2022

Partnered with development teams and business units in an Agile-Scrum environment, supporting sprint planning and backlog refinement sessions.

Collaborated with product owners to write detailed business requirements and acceptance criteria supporting microservices-based data delivery in Agile projects.

Managed and tracked project tasks in JIRA, ensuring smooth Agile workflows and sprint execution.

Removed manual dependencies by automating data cleaning and transformation processes, reducing project execution time by 35%.

Worked with Product Owners, Scrum Masters, and Developers to refine requirements and align data solutions with business needs.

Applied predictive modeling, regression analysis, and hypothesis testing to improve forecasting accuracy by 20%.

Enhanced SQL queries for performance tuning, improving database response time by 25%, ensuring seamless data retrieval and processing.

Translated system diagrams and SQL-based logic into clear visual reports and documentation, improving business users' understanding and adoption of analytics solutions.

Employed Python and R for statistical modeling, forecasting, and predictive analytics used by client-facing teams for performance optimization.

Collaborated with cross-functional teams in Agile-Scrum sprints to gather, document, and communicate clear business requirements, contributing to timely delivery of new data features aligned with evolving product goals.

Interpreted technical system diagrams and performed SQL-based data analysis to validate integration points across web services and APIs, ensuring accurate reporting and downstream data flow for business applications.

Developed dashboards using Power BI and maintained collaborative project content via SharePoint.

Engaged with nonprofit-aligned clients, adapting analytical insights to fit public sector needs and constraints

TopHat Software Technologies, India Jr. Data Analyst May 2018 – Aug 2020

Spearheaded data-driven decision-making by collaborating with cross-functional teams to develop effective data models, boosted data accessibility and analysis led to a 20% faster time-to-insight.

Participated in API-focused solution planning sessions with technical teams to understand service interactions and ensure alignment with data reporting needs.

Authored detailed user stories and business requirement documentation to support data dashboard enhancements and backend system alignment, ensuring effective communication with developers and stakeholders.

Built interactive Power BI dashboards, converting raw business data into meaningful insights that enhanced decision-making efficiency by 30% for sales and operations teams, enabling data-driven strategies and improved performance tracking.

Analyzed A/B test results using statistical methods such as t-tests and confidence intervals to identify statistically significant differences, enabling data-driven decisions that improved conversion rates by 15%.

Automated data cleaning and preprocessing workflows using Python and SQL, reducing manual data preparation time by 35% and improving data accuracy for statistical modeling.

Worked on data transformation pipelines and statistical reporting models that consumed inputs from microservices and API-driven systems, facilitating scalable and automated analytics delivery.

Delivered key dashboard features on tight deadlines by organizing tasks based on business priorities and maintaining communication with project stakeholders.

Instituted reusable SQL templates and interactive Excel reports, fostering a data-driven culture that increased independent data analysis and boosted team efficiency by 20%.

Skills & Certification

Languages and IDEs: Python, SQL, NoSQL, R Programming, Visual Studio Code, PyCharm

Packages: NumPy, Pandas, Matplotlib, SciPy, Seaborn, Scikit-learn

Business Intelligence Tools: Tableau, Power BI, Excel, Looker, Power Query

Databases and Tools: SQL Server, MySQL, MongoDB, SQL Server Management Studio (SSMS), Teradata

ML & Statistical Methods: Predictive Modeling, Decision Trees, Clustering, Regression

Cloud: AWS (S3, EC2, Redshift, Quick Sight, DynamoDB)

Data Skills: Data Warehousing, Data Mining, Data Manipulation, Statistical Analysis, Data Modeling, Data Processing

Certification : PL-300-Microsoft Power BI Data Analyst

Education

Master of Science in Information Systems and Technology Wilmington University, Newcastle, DE

Contact this candidate