Data Analyst Power Bi

Tejaswini Yeruva Business/Data Analyst

Email: ****.*.******@*****.*** Phone: 412-***-****

Professional Summary

•Experienced Business/Data Analyst with expertise in reporting, data analysis, and process optimization.

•Adept at collecting, transforming, and analyzing data using SQL to provide actionable insights and enhance decision-making.

•Skilled in data wrangling, utilizing advanced techniques to clean and structure large datasets from various sources, ensuring data quality and consistency.

•Experienced in designing and building interactive dashboards and reports using Power BI, leveraging advanced DAX functions to track key performance indicators (KPIs) and visualize trends for stakeholders.

•Proficient in automating data processing and reporting tasks with Python, reducing manual effort and improving operational efficiency.

•Highly collaborative, with a strong background in Agile methodologies and active participation in Scrum ceremonies to drive iterative progress and alignment with business objectives.

•Expertise in creating detailed user stories, managing product backlogs, and conducting user acceptance testing (UAT) to validate solutions against business requirements

•Possess strong analytical skills and a deep understanding of KYC/AML processes, having worked on data governance and reporting systems to ensure regulatory compliance.

•Skilled at presenting data insights to management and ensuring clear communication between technical teams and business stakeholders to improve business processes and reporting capabilities continuously.

Technical Skills:

• Languages: SQL, Python, R Programming

• Analytical Tools: Power BI, Tableau, MS Excel

• Databases: MySQL, Microsoft SQL Server

• Data Visualization Platforms: Microsoft Power BI, Tableau

• Machine Learning: Regression, clustering, SVM, Decision trees, Classification

• Familiar with: ETL, Microsoft Office, PowerPoint, SQLR, Report writing, Visio, JIRA, DAX, and Agile.

Education:

•Bachelor’s Degree: Acharya Nagarjuna University- 2014

•Master Degree: Kent State University- 2023

Professional Experience:

Client: JP MORGAN CHASE & CO - India Jan 2017 – May 2022

Role: Client Data Specialist

Responsibilities:

•Led the implementation of solutions for clients, ensuring seamless integration of products and services according to company guidelines and client expectations.

•Ensured the accuracy, completeness, and timeliness of client information, adhering rigorously to regulatory standards and internal compliance policies.

•Worked closely with stakeholders, customers, and internal teams to gather and document detailed business requirements.

•Collaborated with the product and development teams to translate business needs into functional requirements.

•Created and maintained detailed documentation including process flows, user guides, and technical specifications.

•Developed process maps, workflows, and plots to illustrate the current and future state of data, enhancing team collaboration and decision-making capabilities.

•Analyzed and mapped data, resulting in improved data architecture artifacts that enhanced data quality and accessibility.

•Created insightful Power BI reports and dashboards to drive informed strategic decisions for management and stakeholders.

•Collaborated with internal departments to load and convert client data to new solutions, ensuring accuracy and smooth data migration, resulting in a 20% boost in data reliability and client satisfaction.

•Worked within the company's implementation methodology, ensuring that all projects were completed on time and in line with client-defined timelines.

•Interacted with associates in Sales and Service teams to exchange information regarding client priorities, project status, and timelines.

•Participated in user acceptance testing (UAT) and ensured that new features met quality standards and business requirements.

•Ensured accuracy in client setup, including system configurations, data migration, and product deployment.

•Contributed to the retention of clients by ensuring that their expectations were met and exceeded, fostering long-term relationships.

•Conducted meetings with stakeholders and teams, compiled status reports using Microsoft Power BI, and organized logs and files, enhancing team communication and efficiency.

•Identified and implemented process optimization strategies using automation tools, which increased efficiency and reduced manual workload by streamlining repetitive tasks

•Pioneered data governance practices, including data profiling, cleansing, and transformation, to uphold data integrity and reliability.

INTERNSHIP

Client: Electronic Arts (EA Sports and Games)- India Dec 2014 – Feb 2015

Role: Intern

Responsibilities:

•Oversaw the implementation of technology solutions for clients, optimizing systems based on their specific needs and requirements.

•Provided hands-on support throughout the process, ensuring clients were successfully running the new systems post-implementation. • Coordinated with cross-functional teams to ensure timely solution delivery and resolved any challenges encountered during implementation.

•Maintained accurate and detailed records of client interactions and project progress, ensuring full transparency throughout the project lifecycle.

•Utilized ETL workflows and SQL for querying and reporting, integrating data across multiple sources to ensure efficient and compliant KYC reviews, which enhanced data accuracy and regulatory compliance

•Applied data cleansing, transformation, and validation techniques to standardize and enrich customer data, improving overall data quality and accuracy in KYC records.

•Developed SQL-based scripts to update KYC review dates, manage risk flags, and monitor customers' compliance statuses in real time, optimizing the KYC lifecycle.

•Assisted in scaling ETL operations to handle growing volumes of customer data, enhancing system performance without compromising on data quality or compliance requirements.

•Verified client data and compiled necessary documents using public and internal sources, significantly enhancing accuracy and compliance with client requirements

Contact this candidate