Data Analyst Qa
Resume:
Kovida Malireddy
Email: ***************@*****.***
Career Objective:
Driven and curious data analyst with experience working with Python, SQL, Tableau, PowerBI and several programming languages. With a passion for creative innovation and solving complex problems. I am eager to further implement my skills and improve my data analysis experience with a detail-driven data team.
Collaboration with team members on solving issues and working with external teams to meet deadlines.
Professional Summary:
Around 3 years of experience as Data Analyst, SQL Developer with a solid understanding of Evaluating Data Sources and a strong understanding of SQL, Tableau, Power BI, Python, SQL Server, Client - Server Applications.
Good knowledge in a Python-based environment, along with data analytics, data wrangling and Excel data extracts and Familiar with Pandas, NumPy, matplotlib.
Good in developing different Reports, Analytics, Data Mining solutions to various business generating data visualizations using Python, Tableau and Google Sheets.
Expertise in Excel, Pivot Tables, VLOOKUP and other advanced functions.
Expertise in writing SQL Queries, Dynamic Queries, sub-Queries and joins for generating Stored Procedures, Triggers, User-defined Functions, Views and importing Data from excel.
Experience in Reporting, Data visualization skills using Power Bi, Tableau and advanced MS-Excel and strong experience in databases such as MYSQL and MS SQL server.
Developed SQL, Stored Procedures, Views, Indexes and Constraints, Query optimizer.
Hands on Experience in creating workbooks and dashboards using Power BI and Tableau that includes tools like Tableau desktop, Tableau server.
Experience in data analysis using python (Pandas, NumPy)
Experience in creating Power BI dashboards using different data sets.
Experience in creating Tableau dashboards Bars, Lines and pies, Maps, Scatterplots, Histograms and Highlight tables with filters, parameters.
Strong experience in using Excel, Google sheets to dump the data and analyze based on business needs.
End to end experience in designing and deploying data visualization in Tableau and Power BI.
Hands on Experience in using various stages like Join, Merge, Lookup, Remove Duplicates, Sort, Filter, Dataset, Modify and Aggregator.
Excellent knowledge in Extraction, Cleansing and Modification of data from/to various Data Sources like Flat Files, Sequential files, Comma Delimited files (.csv), XML and Databases like SQL Server, MySQL etc.
Technical Skills:
Programming : Python (Pandas, NumPy, Matplotlib, Plotly, Seaborn)
Data Visualization : PowerBI, Tableau, Excel
Predictive Modeling : Logistic Regressions, Linear Regressions
Database : MySQL
Statistics : Descriptive Statistics, Different Distributions, Inferential Statistics, Hypothesis Testing, P Value, Z Test, Significance Value, T Test, Chisquare Test and Annova Test.
Microsoft Package : Microsoft Excel, Power Point, Word and Visio
Methodologies : Agile, Waterfall
Languages : SAS, XML
Professional Experience:
HPE, Palo Alto, CA Aug 2020 to Till Date
Role: Data Analyst
Responsibilities:
Performed revenue impact analysis on various pricing logic changes using SQL.
Performed post launch measurement analysis on various pricing logic changes and presented the insights to business.
Utilized Tableau to perform what if analysis of various scenarios on surcharge changes.
Created data for customer and sales facing tools by combining data from various sources using SAS and SQL.
Used SQL, Python, Excel, and other tools to create reports and develop practical solutions to challenges for operations, engineering, and sales.
Used Pandas, Numpy, Scipy, Matplotlib, Sci-kit-learn and NLTK in Python for developing various machine learning algorithms.
Used Alteryx for Data Preparation and then Tableau for Visualization and Reporting.
Involved in data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access.
Created Tableau reports and dashboards for data visualization and mining to identify the trends and patterns in the data.
Worked with the DBAs on maintaining existing, and creating new, database Tools & Technologies and communicate to leadership within our company to convey the importance and business value of data descriptions for entities, attributes, domain values and relationships using data modeling tools to create Entity Relationship Diagrams.
Created various reports for Business team using Power BI.
Extensively involved in analyzing various data formats using industry standard tools and effectively communicating them with business users and SMEs.
Involved in Defect Review meetings with Business Core Team and Developed use-case Analysis.
Validating the Data files from source to make sure correct data has been captured to be loaded to target tables.
Environment:
Python, SQL Server, Tableau, Power BI, MS Access, Agile methodologies
MetLife, NY Sep 2019 to Jul 2020
Role: QA Analyst
Responsibilities:
Involved in Analysis, design, and documenting business reports such as Summary reports, undefined exception reports etc.
Worked in Agile environment, with an ability to accommodate and test the newly proposed changes at any point of time during the release.
Filtered inaccurate data from legacy system using complex T-SQL statements and implemented various constraints and triggers for data consistency.
Responsible for ETL through SSIS and loading Data to DB from different input sources.
Accessing Data, creating table from files, filtering Tables in SAS Creating Analytics in SAS.
Generating various reports (graphical) using Python packages like NumPy, matplotlib.
Ability to write and optimize diverse SQL queries, working knowledge of RDBMS like SQL Server, MySQL.
Worked with business team to test the reports developed.
Interacted with Business analysts to understand data requirements to ensure high quality Data is provided to the customers.
Extensively used open-source tools Anaconda (python) Jupyter Notebooks for statistical analysis.
Developed SQL scripts using Joins, Temp tables Data and OLAP functions.
Used Python to save and retrieve data.
Used Python Matplotlib packages to visualize and graphically analyses the data.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Created Graphical Maps, Bar charts Bubble charts and Line Graphs in helping the end-user to have clear idea on visualizations.
Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and Pivot Charts using Power Pivot skill.
Expertise in building Tableau reports.
Wrote several complex SQL queries to extensively test the ETL process.
Delivered data solutions in report/presentation format according to customer specifications and timelines.
Environment:
Python, SQL Server, Tableau, MS Access, Agile methodologies
Education Qualifications:
Bachelor of Science in Computers from Nagarjuna University, India
Contact this candidate