Divya Velagaleti
Silver Spring,Maryland
Summary
Accomplished Data enthusiast with 6+ years of experience in Marketing Analytics, HR Analytics, and Insurance Analytics. Developed interactive dashboards using PowerBi and Tableau was well appreciated by top level management for unraveling the hidden insights in the data. Proficient Data Engineer with deep understanding of database technologies, data analysis and data transformations. Recognized business analyst with strong analytical capabilities at conceptualizing solutions that align analytics with business strategies to meet business objectives. Equipped with excellent communication skills, work ethics and possess sense of leadership.
Overview
8
8
years of professional experience
1
1
Certification
Work History
HR Analyst
Coders Data
06.2023 - 01.2024
- As HR Analyst, worked on discovering underlying trends in database, deriving value- add information from these trends to drive revenue
- Prepared reports by collecting, analyzing, and summarizing data and trends
- Gathered requirements from SMEs, end users, and business owners
- Analyzed data of employee salaries and experience, productivity, competency identification, efficiency assessment, revenue generated per employee (ROI), performance metrics
- Developed dashboards with insights from data using different graphical representations in PowerBi and Tableau
- Collaborated with multiple stakeholders to design, build and test new data transformations flows, reports and dashboards as needed
- Developed complex SQL queries to extract and validate data from database
- Tracked, resolved, and documented all issues encountered during project.
Data Engineer II
Dun & Bradstreet Technology and Corporate Services India LLP
12.2020 - 01.2023
- As Data Engineer II, I have worked on discovering underlying trends in database, deriving value- add information from these trends to drive revenue
- With Strong data analytics as foundation, worked on data transformations to create solutions that help automate improvements in data quality upto 80% within Unity markets of Asian Countries(Vietnam, Thailand, Korea, Singapore, India, China, Malaysia, United Arab Emirates, Taiwan, Hongkong, Japan)
- Worked on utilizing usage reporting data and returned data from external vendors to pursue value- driven growth
- Supported growth of critical data element coverage for Unity markets and enhanced data mapping processes to ensure delivery of best in class data to customers
- Data schema cleanup initiative to remove unused/redundant fields from tenant schemas to improve application response times and provide analysis to tenants to encourage removal of identified fields
- Used collaboration tools such as Confluence and Teams to increase transparency of Unity data engineering processes and improve integration with global teams
- Performed GAP analysis to ensure the quality of data is as per the standards.
Business Analyst
Nuevora Analytics Technologies Pvt. Ltd. (Sutherland Global Services)
06.2016 - 11.2020
- Design business architecture using requirements such as scope, processes, alternatives and risks
- Analyze client's business requirements and processes through document analysis, interviews, workshops and workflow analysis
- Expertise in all the phases of the Software Development Life Cycle (SDLC), Agile Development methodology
- Experienced in conducting JAD sessions, focus group and brainstorming sessions, reviews and customer interviews for various business processes
- Wrote complex SQL queries to extract and validate the data from the database
- Ability to effectively prioritize and execute tasks in a high-pressure environment
- Prepared BRD (Business Requirements Document), FRD (Functional Requirements Document) and N- FRD (Non- Functional Requirements Document)
- Proactively collaborate with clients to analyze the functional requirement and delivering the use cases as and when required
- Develop business plans by working with subject matter experts, determine Key Performance Indicators (KPI) and coordinate the measurement result
- Collaborate and design advanced analytics and applying statistical modeling techniques by utilizing various applications and platforms
- Analyze call centre metrics like Transfer rate, Contact rate, Customer Satisfaction Score( CSAT score), Average Handling Time and KPIs for Agent Performance Measurement for eBay and GoDaddy projects which included word clouds
- Build statistical models such as Logistic regression, Decision tree and Clustering for improved business decisions
- Build Customer Segmentation model by implementing statistical techniques like Clustering in R to strategically plan the insurance schemes for target customers which inceased customer base by 40% and improved revenue
- Perform Logistic Regression statistical algorithm to understand the factors affecting the agent performance, analyze the claims and understand the underlying pattern of the policies purchase and claims
- Measure the productivity of agents through indexing mean procedure to put the data into context
- Work on Employee Retention analysis to identify the driving factors for motivation of Employees
- Data Visualization through insightful and interactive dashboards using PowerBi for Pepsico, eBay and Gaurdian Life Insurance Company of America
- Develop a generic tool for driver analysis of various KPIs for agents performance in PowerBi for eBay and GoDaddy clients.
Education
Post Graduate Diploma in Business Analytics - Human Resource Analytics and Marketing Analytics
GITAM School of International Business
Visakhapatnam, India08.2016
MBA - Human resource Management and Marketing
Ramachandra College of Engineering
Eluru,India06.2015
B.Sc. (Hons.) - Biosciences
Sri Sathya Sai University
Anantapur,India04.2013
Skills
- Business Case Development
- Develop Data Models
- Customer Relationship Management
- Visual Modeling
- Data Transformations,Data Mining
- Statistical Analysis and Machine Learning
- MS Office (Word, Excel and PowerPoint)
- R Language
- Python
- SQL
- Microsoft Power BI
- Microsoft Visio
- SDLC, Agile, Waterfall
- MongoDb
- Benefits Administration
Certification
- Pursued Business Analytics certification from Indian Institute of Management, Kozhikode.
- Pursued a HR Analytics Master course with Excel. Python and R through Udemy online training platform
- Attended HR Analytics workshop conducted by National Human Resource Development
- Attended online training on "Psychometric Instruments for People and Organization Development"
- Pursuing "Introduction to Artificial Intelligence" course offered by Google.
Internship
- A "Study on Non-Monetary Motivators in Enhancing Performance", 2 months
- Training in the Department of Cytogenetics, Molecular Diagnostics, Research and Development, 2 months
Personal Information
Date of Birth: 9th June1992
Extracurricular Activities
Secured Rajya Puraskar as a part of Bharat Scout and Guide Participated and won prizes in many classical, semi classical, folk Dance competitions. Actively involved in service activities of Sri Sathya Sai Seva Samithis
Projects
A Study on impact of service quality of private clinics on patient satisfaction, 2 months Application of Factor Analysis: A Study on "Why customers prefer shopping in malls", 2 months
Timeline
HR Analyst
Coders Data
06.2023 - 01.2024
Data Engineer II
Dun & Bradstreet Technology and Corporate Services India LLP
12.2020 - 01.2023
Business Analyst
Nuevora Analytics Technologies Pvt. Ltd. (Sutherland Global Services)
06.2016 - 11.2020
Post Graduate Diploma in Business Analytics - Human Resource Analytics and Marketing Analytics
GITAM School of International Business
MBA - Human resource Management and Marketing
Ramachandra College of Engineering
B.Sc. (Hons.) - Biosciences
Sri Sathya Sai University
- Pursued Business Analytics certification from Indian Institute of Management, Kozhikode.
- Pursued a HR Analytics Master course with Excel. Python and R through Udemy online training platform
- Attended HR Analytics workshop conducted by National Human Resource Development
- Attended online training on "Psychometric Instruments for People and Organization Development"
- Pursuing "Introduction to Artificial Intelligence" course offered by Google.
Similar Profiles
Goy JackGoy Jack
Senior Data Analyst at Coders DataSenior Data Analyst at Coders Data
Rajat BhaskarRajat Bhaskar
Talent Acquisition Specialist at Coders DataTalent Acquisition Specialist at Coders Data
Asmita NeupaneAsmita Neupane
Senior Software Designer at Nepali CodersSenior Software Designer at Nepali Coders