Data Analyst Power Bi
Resume:
Sravanti E
Data analyst/data Visualization Specialist
********.*****@*****.***
PROFESSIONAL SUMMARY:
* ***** ** ******* ********** in research, academic, data analysis, data engineering, and statistical modeling, including data extraction, manipulation, visualization, and validation techniques.
Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple tools such as power bi, Tableau.
Monitor and optimize the performance of Power BI workspaces, reports, and dashboards to ensure fast and efficient data visualization and analysis.
Worked in the entire data science project life cycle and actively involved in all the phases including data extraction, data cleaning, statistical modelling and data visualization with large data sets of structured and unstructured data.
Extensive experience in Text Analytics, developing different Statistical Machine Learning, Data Mining solutions to various business problems and generating data visualizations using Python.
Proficient in data mining tools like R, SAP, Python, SQL, Excel, ecosystems Staff leadership and development
Proficient in data entry, data auditing, creating data reports & monitoring data for accuracy Ability to extract Web search and data collection, Web data mining, Extract database from website, Extract Data entry and Data processing.
Proficiency in writing complex SQL queries, stored procedures and functions in Snowflake.
Experience with Data Analytics, Data Reporting, Adhoc Reporting, Graphs, Scales, PivotTables and OLAP reporting.
Experience in generation BI reports using Power BI
Expertise in Data Reporting, Adhoc Reporting, Graphs, Scales, PivotTables and OLAP reporting.
Proficient in data mining tools like R, SAP, Python, MY SQL, Excel, Big Data Hadoop ecosystems.
Very responsible and good team player. Can work independently with minimal supervision.
Professional Experience 1:
Client: Philips, Cambridge, MA(Wipro. Pvt.ltd) Duration: 14 Aug 2020 to 30 DEC 2022
Role: Data Analyst
Responsibilities:
Built interactive Tableau dashboards that visualized sales trends, increasing decision-making efficiency.
Conducted data cleansing and preparation, reducing errors in reporting.
Created SQL queries to extract insights from large relational databases, streamlining reporting processes.
Utilized SQL and Microsoft SQL Server 2019/2022 for complex data querying, ensuring accurate data extraction for analysis impacting policy renewal strategies.
Developed automated tools and dashboards in Power BI, providing real-time business intelligence that supported financial forecasting and risk management.
Experience in Microsoft SSAS tabular model with proficiency in writing complex DAX scripts to support Power BI KPIs
Utilized Tiles to create dashboard in the Power BI Service.
Optimized data retrieval processes using SQL and BigQuery, reducing report generation time by 40% and supporting timely business decisions.
Connected to gateway and utilized Power BI schedule for weekly and monthly refreshes.
Streamlined data operations and maintenance using Microsoft Office tools, ensuring consistent data handling practices and adherence to data security protocols.
Professional Experience 2:
Company: Cognizant technology solution, Hyderabad. Duration: May 2016 to Nov 2019
Role: Junior data analyst
Responsibilities:
Providing technical support for new software systems by creating database structures and tables based on business requirements.
Interacting with other data scientists and architects, custom solutions for data visualization using tools like a tableau and Packages in Python.
Creating dashboards using SSRS and tableau display KPI related to distinctive areas of interest within departmental operations.
Managed company research equipment and trained undergraduate students on properly trained them.
Interacting with other data scientists and architects, custom solutions for data visualization using tools like a tableau and Packages in Python.
routine operational reporting and data manipulation to produce routine metrics and dashboards for management
Written complex SQL queries using joins and OLAP functions like Count, CSUM, and Rank etc.
Building, publishing customized interactive reports, report scheduling and dashboards using Tableau server.
Created dashboards as part of Data Visualization using Tableau and Power BI.
Responsible for scheduling jobs for weekly, daily data refresh on different Power Bi reports.
Created Row Level Security (RLS) and Integrated with Power BI Service portal.
Developed in Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files.
Performing statistical data analysis and data visualization using Python.
Worked on creating filters and calculated sets for preparing dashboards and worksheets in Tableau.
Created data models in Splunk using pivot tables by analyzing vast amount of data and extracting key information to suit various business requirements.
Implemented data refreshes on Tableau Server for biweekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
Worked on writing complex SQL queries in performing Data analysis using window functions and joins, improving performance by creating partitioned tables.
Proficient in developing and implementing Spark-based data pipelines for data ingestion, transformation, and analysis, ensuring optimal performance and scalability.
Maintenance of large data sets, combining data from various sources by Excel, Enterprise, and SAS Grid, Access and SQL queries.
Provided R/SQL programming, with detailed direction, in the execution of data analysis that contributed to the final project deliverables. Responsible for data mining.
Environment: SQL/Server, Oracle, MS-Office, Power BI, MY SQL, Python, R, Tableau, SAP.
TECHNICAL SKILLS:
Data Tools & Technologies: SQ, Python, R programming language.
Visualization & Reporting: Tableau, Power BI, Excel (Advanced), Google Data Studio.
Soft Skills: Analytical thinking, collaboration, communication, problem-solving.
Educational Qualifications: Master of data analytics
Indiana Wesleyan University, MARION, IN, USA
Expected Graduation: May 2025
Current GPA: 3.8
Relevant Coursework: Statistical Analysis, Data Mining, Machine Learning, SQL, Python Programming
Capstone Project: “Zomato analysis Using Machine Learning” – Developed a predictive model that achieved 87% accuracy using Python and Scikit-learn.
Contact this candidate