VENKATA ASHA DEEPIKA PENAGGANTI

857-***-**** ad2bar@r.postjobfree.com www.linkedin.com/in/ashadeepika09 SKILLS

Programming: SQL, Python, R Programming, SAS

Business Intelligence Tools: Microsoft Office(Word, Excel, PowerPoint, Outlook), Informatica ETL, Alteryx, Tableau Desktop, Power BI Data Science & Analytics: Logistic Regression, ARIMA, Prophet, Decision Trees, Correlation Analysis, Descriptive & Statistical Analysis Project Management: Agile Methodologies, JIRA

Soft Skills: Attention to Detail, Effective Documentation, Communication Skills, Time Management, Analytical Thinking WORK EXPERIENCE

DXC Technology Bangalore, India

Data Analyst Aug 2020 - Aug 2022

• Implemented over 50 change requests and user stories in the production database using SQL and Informatica ETL technology. This initiative significantly enhanced database functionality and user experience.

• Developed and led the creation of User Acceptance Test (UAT) plans, achieving a 90% reduction in errors. This initiative ensured strict alignment with business needs and streamlined development processes.

• Extracted and automated external large-volume data to analysis-ready tables into SQL Server and performed data quality checks.

• Resolved 50+ incidents in 30 countries via ServiceNow, adhering to SLAs through back tracing Informatica workflows, database tables and stored procedures, leading to a 30% improvement in resolution times and enhanced process efficiency.

• Monitored over 4000 daily, monthly, quarterly, and annual tidal workflow jobs across 100+ countries. This effort ensured efficient data transfer from HRIS systems (Workday) to downstream systems, facilitating timely payroll processing.

• Extracted ad-hoc reports tailored to business’s needs while upholding strict data accuracy and confidentiality standards.

• Built strong collaborative relationships with both SME’s and fellow teams, facilitating the exchange of insights, updates, and results. PROJECTS

NOVICA – E-commerce Optimization (Tech: Python, Machine Learning Algorithms)

• Developed forecasting models (ARIMA, Prophet) to improve inventory strategy, achieving accurate 90-day forecasts for key SKU’s.

• Performed OLS regression on low-view SKUs to pinpoint factors affecting session views, guiding enhanced keyword strategy.

• Segmented high-view Amazon SKUs by conversion rates and price/session and performed sentiment analysis for improved product performance and engagement insights.

Bank Management System (Tech: SQL, Oracle Database) Designed Entity Relational Diagram of 8 tables and conducted database normalization to 3rd normal form to resolve anomalies; Assisted in the processes of database implementation. Developed complex SQL queries to extract information regarding merchant and transactional processes, resulting in a marked improvement in system efficiency and significant error reduction.

Engagement of Esports (League of Legends) and Culinary (Tech: R, Tableau) Performed data cleaning and feature engineering, followed by descriptive statistics to determine data trends. Built an interactive dashboard that significantly improves food vendors' understanding of customer preferences, expected to result in a 30% increase in sales. Prediction of Heart stroke (Tech: Python, Machine Learning) Conducted exploratory data analysis using sea born and Matplotlib for a deeper understanding of data and implemented various machine learning models (Logistic Regression, Correlation Analysis, Random Forest) in Python. This was to predict and classify cancer likelihood based on demographics, smoking, and eating habits, achieving an 85% accuracy rate, and provided recommendations accordingly.

EDUCATION

Northeastern University (D’Amore-McKim School of Business) Boston, MA Master of Science in Business Analytics (CGPA- 3.67/4.0) Sept 2022 - Dec 2023

(Course work: Data Mining and Machine Learning for Business, Data Wrangling for Business, Info Visual/Dashboard for Business) Vellore Institute of Technology Vellore, India

Bachelor of Technology in Electronics and Communication Engineering Jul 2016 - Jun 2020 ACHIVEMENTS

• Azure Fundamentals: AZ900 from Microsoft.

• Champs Award for excellence in supporting production migration activities from Informatica 9.6.1 to Informatica 10.4.1 on AWS cloud.

• Led project teams to achieve 100% delivery success, effectively assigning tasks and updating senior management.

• Promoted from Associate Data Analyst to Data Analyst at DXC Technology, in recognition of outstanding performance.

Contact this candidate