Data Analyst Processing

NAME: PRAVALIKA RAO GIRNENI

PHONE NO: 513-***-****

Email: *******************@*****.***

Linked In : www.linkedin.com/in/pravalika-rao-396b3a217

OBJECTIVE

A highly motivated and results-driven individual seeking a position as a Data Analyst. Possessing strong analytical, programming, and collaboration skills with a passion for utilizing data to solve complex problems and drive business growth. Seeking to apply expertise in data analysis, data processing, and data governance reporting to increase the efficiency and accuracy of data processing leading to growth and success.

EDUCATION QUALIFICATION:

Master of Science in Business Analytics

Kent State University, Kent, Ohio

August 2022- December 2023.

Bachelor of Science in Electronics and Communication Engineering

Sridevi Women’s Engineering College, Hyderabad.

September 2014 – May 2018.

TECHNICAL SKILLS:

Hadoop/Big Data ecosystems: HDFS, Map Reduce, Sqoop, Flume, Pig, Hive, Oozie, Impala, Zookeeper and Cloudera Manager, Zookeeper, Spark, Scala

NoSQL Database: HBase, Cassandra

Languages: SQL, PL/SQL, R, Scala, Python

Databases: Oracle, SQL Server, MySQL, DB2, PostgreSQL, Teradata

Tracking Tools and Control: SVN, GIT, Maven

ETL Tools: Apache NiFi, Microsoft SQL Server Integration Services (SSIS)

Visualization Tools: Tableau, Power BI

PROFESSIONAL SUMMARY:

Around 4+ years of experience with emphasis on Big Data Technologies, Development, and Design of Scala-based Enterprise Applications.

Good working knowledge in a multi-tiered distributed environment, a good understanding of Software Development Lifecycle (SDLC)-Agile and Waterfall Methodologies.

Hands on experience on programming languages, such as Python and R.

Experienced working with database tools like Microsoft Excel and SQL.

Experienced working on data visualization tools like Tableau, Jupyter Notebook, and Excel.

Collaborated with cross-functional teams to deliver on-time and on-budget project sand initiatives.

Designed and created meaningful data visualizations to report and communicate insights.

Collected and assimilated data from multiple sources both internal and external.

Performed exploratory analysis to identify patterns and insights in the data.

Developing ETL processes to facilitate the movement of data between systems.

Assisted in the design of a data architecture that meets the needs of the organization.

Implemented and deployed models using predictive analytics to forecast outcomes

Worked with and presented analytics to clients or stakeholders.

Translated complex data-driven analysis into simple, easy-to-understand insights.

Supporting data integrations, cleansing and quality solutions.

Creating and maintaining data dictionaries and other forms of metadata.

Automated data processes to ensure timeliness, accuracy and scalability.

Utilized technologies such as statistical and graphical tools to drive data insights.

Data is collected in excel for analysis from group mail.

Modelling the data in excel sheets and streamline it.

Using VB script to generate automatic reports.

PROFESSIONAL EXPERIENCE:

Advithri Technologies LLC-TX Aug 2023 to Present

Role: Data Analyst Intern

Responsibilities:-

Utilizing APIs RESTful APIs, web scraping tools BeautifulSoup, Scrapy, and database queries SQL to gather data from various sources.

Employing data preprocessing tools and libraries such as Pandas in Python, dplyr in R, or Power Query in Excel to clean and preprocess the data, ensuring it is accurate and usable.

Using statistical programming languages Python with libraries like NumPy and SciPy, R to perform exploratory data analysis EDA, identify patterns, outliers, and derive insights from datasets.

Applying statistical models and machine learning algorithms using tools like R, Python Scikit-learn, or specialized software SPSS, SAS to analyze trends and make predictions.

Develop and maintain dashboards, reports, and visualizations using tools like Tableau,Power BI translating data insights into actionable recommendations.

Compiling findings and insights into reports or presentations using tools like Microsoft PowerPoint, Google Slides, or data visualization platforms that allow for dynamic and interactive reporting.

Writing SQL queries to extract, update, or manipulate data within relational database management systems (RDBMS) such as PostgreSQL, MySQL, or cloud-based databases like Amazon RDS.

Basic understanding and interaction with data warehousing solutions like Google BigQuery, Amazon Redshift, or Snowflake for managing and analyzing large datasets.

Using project management and collaboration tools like Jira, Trello, or Asana to stay organized and communicate with team members.

Utilizing version control systems like Git, and platforms like GitHub or Bitbucket, to manage changes to project files, code, and documents, facilitating team collaboration on development projects.

Environment: Apache NiFi, SSIS, MySQL, PostgreSQL, Oracle, SQL Server, MongoDB Cassandra, Tableau, Power BI, Jira, Slack.

Aliens Group Pvt Lmt-Hyderabad May 2018 to May 2022

Role: Data Analyst

Responsibilities:-

Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.

Conduct data profiling to evaluate data quality, identify inconsistencies, and ensure data integrity before it is used for business analysis or ETL processes

Designed and developed various SQL scripts as part of automation of manual monthly reporting to third party consumer.

Design, develop, and implement ETL pipelines to extract, transform, and load data from various sources into data warehouses, ensuring data consistency and accuracy.

Worked on data profiling, data analysis and validating the reports sent to third party.

Ensure the accuracy and integrity of data by performing data validation and reconciliation of datasets.

Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.

Extracted, Analyzed and Presented Data in a Graphical Format using Microsoft Excel, such a way that helped project manager to make Business Decisions

Proficient in importing/exporting large amounts of data from Excel files to Teradata and vice versa.

Used VBA Macro to create Weekly reports.

Used Joins like Inner Join, Outer join while creating tables from multiple tables.

Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.

Proficient in working on Set, Multiset, Derived, Volatile Temporary tables. ·

Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.

Experience in Power Point Presentation (Financial Data, Charts).

Expertise in generating graphs using MS Excel Pivot tables. Extracted data from existing data source, Developing and executing departmental reports for performance and response purposes by using SQL, MS Excel.

Creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL joins for applications.

Extensively using T- SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Creating Tableau reports, creating BI reports and visualizations

Evaluate current scheduling practices to identify business requirements and translate them into technical requirements to enhance and create new custom report.

Working with team and participating in feedback sessions to improve the system.

Data is gathered from multiple sources like SQL, Excel, SharePoint, Access database.

Query and manipulate data using SQL and other database technologies to extract meaningful insights.

Proficient in Semarchy for mastering data integration, implementing multi-domain master data management (MDM) solutions, and ensuring high data accuracy and consistency.

Experienced in using Collibra for data governance, metadata management, and data stewardship, ensuring compliance and data quality across the organization.

Develop and maintain dashboards, reports, and visualizations using tools like Tableau, translating data insights into actionable recommendations.

Perform data profiling, cleansing, and transformation to ensure data quality and accuracy for analysis.

Coordinates with local site operations personnel team to analyse historical data and create reports to forecast demand for that site.

Create weekly, Monthly and Quarterly reports for capacity planning for a site, to staff and forecast demands.

Creating reports for completed projects and update technical documentation for the staff members and colleagues within the organization for reference.

Environment: Teradata V2R6, VBA, Putty, Tableau, Power BI, MySQL, PostgreSQL, MongoDB, Apache NiFi, SSIS, Collibra and Semarchy,Jira, Git.

Contact this candidate