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