Arun Bakkera

Arun Bakkera

Data Analyst
United States of America

About Me

Experienced data Analyst with over 3+ years of experience designing and implementing data-driven solutions to complex business challenges. Well-versed in Agile, and Waterfall methodologies, adapting approaches to project…

Experience

Data Analyst

United Healthcare Group, USA
Jan 2023 - Present · 3 years 6 months

● Involved in requirements gathering, analysis, design, development, testing, and production of an application using the Agile model.
● Conduct data manipulation and visualization tasks in Python and R, ensuring data integrity and facilitating comprehensive analysis.
● Implement robust monitoring systems, reducing system downtime by 90%, and ensuring data availability and business continuity.
● Employ ggplot2 in R for elegant and customizable visualizations, enabling a deeper understanding of complex data structures.
● Create interactive and visually compelling dashboardsin Tableau, facilitating easy data exploration and enabling stakeholdersto make informed decisions
based on visual insights.
● Implemented AWS S3 for secure and cost-effective data storage, improving accessibility and data retrieval efficiency by 30%.
● Involve writing, testing, and implementing triggers, stored procedures, and functions at the Database level using MySQL.
● Performing data collection, data cleaning, data wrangling, data analysis, and building machine learning models on the data sets in both R and Python.

Data Analyst

United Healthcare Group, USA
Jan 2023 - Present · 3 years 6 months

Involved in requirements gathering, analysis, design, development, testing, and production of an application using the Agile model.
Conduct data manipulation and visualization tasks in Python and R, ensuring data integrity and facilitating comprehensive analysis.
Employ ggplot2 in R for elegant and customizable visualizations, enabling a deeper understanding of complex data structures.
Create interactive and visually compelling dashboards in Tableau, facilitating easy data exploration and enabling stakeholders to make informed decisions based on visual insights.
Implement robust monitoring systems, reducing system downtime by 90%, and ensuring data availability and business continuity.
Implemented AWS S3 for secure and cost-effective data storage, improving accessibility and data retrieval efficiency by 30%.
Involve writing, testing, and implementing triggers, stored procedures, and functions at the Database level using MySQL.
Performing data collection, data cleaning, data wrangling, data analysis, and building machine learning models on the data sets in both R and Python.

Data Analyst Intern

AGC Automotive Americas, Alabaster, Alabama
Jun 2022 - Dec 2022 · 6 months

Created ETL pipeline using Python and SQL to Streamline the EDI download and analysis process for consistent information that supports the Production & Material planning.
Performed XGBoost algorithms to identify qualifying variables that will have an impact in determining the demand and supply.
Automate the data gathering and reporting process using scripts and load into tables to be consumed by Power BI.
Designed Schemes, tables, and views and Migrated the data from multiple sources to the SQL server database.
Scheduled ETL jobs as per the pipeline workflow using the Python schedule package as a job scheduler.
Establishing comparisons in the visible horizon to identify trends and demand changes.
Organize and prioritize large volumes of information and liaise with various departments within the facility.
Designed general correspondence, memos, charts, tables, graphs, and business plans and implemented KTA ideas for the company's development.
Have an idea about ERP systems such as SAP, Oracle E-Business Suite, Microsoft Dynamics, or other major ERP platforms.
Ability to identify process improvement opportunities and streamline workflows.
Excellent problem-solving and troubleshooting abilities.
Effective communication and interpersonal skills for collaborating with cross-functional teams.
Improved production reporting using VBA and Power Query editor and recording, Analyzing SORs, and implementing the action plan.

Data Analyst

Zensar Technologies, India
Jan 2020 - Jul 2021 · 1 year 6 months

Implemented the project using the Waterfall Methodology to produce artifacts in the Software Development Life Cycle (SDLC) phases.
Utilized SQL queries for data extraction, transformation, and analysis, improving query efficiency and reducing processing time by 30%.
Built complex SQL queries on large datasets for data manipulation and used pandas, NumPy, and Matplotlib to modify and maintain legacy reports.
Used and maintained a database in MS SQL Server to extract the data inputs from internal systems.
Configured AWS EC2 instances and managed resources effectively to match varying data processing requirements, ensuring optimal performance.
Conducted data cleaning and data wrangling to preprocess and transform raw data, improving data quality.
Integrated diverse data sources into Power BI, ensuring comprehensive analysis and enabling a holistic view of business operations.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau SDLC Agile Waterfall Python MATLAB Visual Studio Code PyCharm NumPy Pandas Matplotlib Seaborn Scipy ggplot2 MS Excel AWS MySQL SQL Server NoSQL Data Cleaning Data Wrangling Critical Thinking Communication Skills Presentation Skills Problem-solving ETL XGBoost VBA Power Query AWS EC2 AWS S3 Stored Procedures Triggers Functions Machine Learning Data Analysis Data Collection Data Storage Data Retrieval Data Manipulation Data Extraction Data Transformation Monitoring Reporting Database Management
Report this Profile?