Aishwarya Venkatesh

Contact number: 984-***-****

Cary, North Carolina adxg9o@r.postjobfree.com www.linkedin.com/in/aishwaryavenkatesha

SUMMARY

I am an adept data professional with 3+ years’ experience in managing and analyzing vast datasets using a range of Cloud services and programming languages such as Python and SQL. My expertise lies in developing intricate data pipelines, implementing cutting-edge data security protocols, examining data to extract valuable insights, and designing interactive dashboards and visualizations enhancing decision-making in business. I am currently seeking a fitting role as a Data Analyst or as a Data Engineer.

SKILLS

Data Analysis: Excel, SQL, Python, R, Agile

Data Visualization: Tableau, Power BI, QlikView, MS Excel

Requirements Management: JIRA, Confluence

Process Modeling: BPMN, Visio, Agile methodologies, UML methodologies, BRD

Collaboration Tools: SharePoint, Slack, Trello

Project Management: MS Project, Asana

ERP Systems: SAP, Oracle

Other tools: Docker, Jenkins, Talend, Splunk, JASON, HANA

Machine Learning: Linear Regression, Logistic Regression, KNN, Support Vector Machine, Decision Tree, Clustering, Random Forest.

Area of Interest: Data Cleaning, Data Visualization, Data Analysis, Data mapping, Agile methodology, Data Warehousing, Data mining, statistical analysis

WORK EXPERIENCE

Amazon Web Services

Bangalore, India

Data Analytical Engineer

Sep 2017 - Sep 2018

• Researched and analyzed large datasets with AWS services for 25% increase in data processing efficiency.

• Built data pipelines with AWS services for 40% reduction in manual intervention and 30% increase in data accuracy.

• Formulated data with Python and SQL for 50% improvement in business decision-making.

• Implemented AWS security best practices for 100% compliance with data privacy regulations.

• Collaborated with cross-functional teams for 20% increase in customer retention.

• Created visualizations with AWS QuickSight for 15% increase in revenue and conducted data analysis for 16% reduction in operational costs and 7% increase in productivity.

Dell Technologies

Bangalore, India

Business/Data analyst

Nov 2015 - Sep 2017

• Designed reports from business clients to identify inefficiencies and areas for improvement, leading to a successful implementation of process changes resulting in a 30% increase in efficiency.

• Customized data visualization dashboards to present insights from claim reports to internal stakeholders, leading to faster decision-making and a 25% improvement in overall business performance.

• Proficient in troubleshooting the reporting database environment and reports, ensuring the accuracy and reliability of data analytics insights.

• Streamlined data pipelines using Python that improved efficiency by reducing manual intervention by 50%, resulting in an annual time savings of over 200 hours, performed SQL queries to fine tune structured data for ingestion and ETL data pipeline.

• Optimized ETL processes using TDD principles to achieve a data processing speed improvement of 50%, resulting in faster time-to-insights for business stakeholders.

• Utilized SAS Output Delivery System to automate generation of RTF, HTML and PDF files, resulting in a 50% reduction in production time.

• Adapted version control system with Git, resulting in a faster deployment process and reducing production downtime by 40%.

PROJECTS

ISM 646-03: Visualization Data and Design strategy

DATA VISUALIZATION ON COVID-19 PANDEMIC Using Python and Modeling for house prices using R programing.

University project Jan 2021 - May 2021

• Utilized Python, Tableau, R markdown, and Power BI to conduct a thorough analysis of Covid-19 pandemic, resulting in creation of 50+ insightful visualizations and dashboards.

• Developed and implemented Excel macros to perform data cleaning, formatting, and analysis, improving accuracy and productivity in project management assignments.

• Investigated pandemic's impact on hospitals and delivered a final presentation to the University, and received a score of 95% from reviewing panel.

• Acquired valuable expertise in project management, research methodology, and data analysis, resulting in a 30% increase in project efficiency and a 25% reduction in errors.

ISM 671-01: Organizing Data for Analytics

DATABASE MANAGEMENT SYSTEM FOR THE GREENSBORO PRESTIGE HOSPITAL

University project Jan 2022 - May 2022

• Identified problem statement and functional requirements for a database system, resulting in a 50% improvement in data management efficiency.

• Advanced a comprehensive conceptual database design with an ER diagram and normalized design to 1NF, 2NF, and 3NF normal forms, ensuring data consistency and eliminating data redundancy by 70%.

• Originated optimized SQL queries for entities from ER diagram, including Create, Select, Insert, Delete, and Drop, resulting in a 40% increase in query speed.

• Formulated complex SQL queries using left Inner/Outer JOINS to retrieve data from multiple tables, resulting in a 60% reduction in number of queries required for data extraction.

• Performed data aggregation using sub-queries and other advanced SQL operators, resulting in a 30% improvement in data analysis accuracy and saving 25% of time spent on data analysis.

LEADERSHIP EXPERIENCE

• Acted as a point of contact for technical questions and issues, providing prompt and effective support to team members and stakeholders.

• Mentored new employees, providing guidance and support to improve technical skills and advance professional growth.

• Conducted technical training sessions for colleagues and team members, sharing knowledge and best practices in data engineering and management.

• Participated in recruitment efforts, interviewing and evaluating potential candidates for data engineering roles.

• Contributed to team planning and strategy sessions, offering insights and ideas to help shape data engineering priorities and objectives.

• Maintained a commitment to continuous learning and improvement, staying up-to-date with emerging technologies and trends in data engineering and management.

EDUCATION

Master of Science in Information technology Management

University of North Carolina Greensboro North Carolina, US 2022 - 3.8

Bachelors of Engineer in Electronics and Communication

Visveswaraya Institution of Technology Bengaluru, India 2015 - 3.5

Contact this candidate