![Profile](https://weekday-user-pics.s3.us-east-2.amazonaws.com/profile-images/default.jpeg)
Anusha Sodani
Data Analyst at EPAM Systems @ Facebook
Anusha Sodani is a dedicated and passionate professional with over 4 years of extensive experience in varied fields of software business applications. She is a Data Analyst at EPAM Systems, working for Facebook, where she provides business insights that help the company make fruitful decis
Show more
11.3
Years of Experience
Education
chameli devi institute, the aditya birla public school
Companies
epam systems, unilever, synapse, utah state university, utah state university, mindtree
Reach out to Anusha Sodani via Email, InMail and SMS drip
by installing Chrome extension
Anusha's contact details
Email (Verified)
anuXXXXXXXXXXXXXXXXXXXXXXXXXXdu
Experience
2019 - Present
epam systems
Data Analyst
• Create reports, dashboards for different departments using Tableau, Excel for analysis and validation and ensuring consistency in data and metrics across all data analytics. • Participate in application and user acceptance testing and assist staff and clients with application problems , issues and defects regarding software capabilities and performance. • Perform exploratory data analysis from multiple disparate sources, generate insights and validate hypotheses developed during data exploration . • Pull, analyze and deliver data using SQL queries to write business logic, spot any issues with data integrity, anomalies and write ad-hoc queries for any business needs. • Pull, analyze and deliver data using SQL queries from MS SQL Server, Data lakes, Data warehouse and unstructured sources and spot any issues with data integrity, anomalies and write ad-hoc queries for any business needs • Write HTML, Javascript to create appropriate web pages for all the analytics related information and embedding Tableau reports to the web pages. • Work with the team to implement organization KPI’s and while adhering to the analytics process – from business understanding, data understanding, data preparation, data modeling, evaluation, and deployment. • Analyze business process and create functional flow breakdowns applying modern business project management software. • Gather requirements and needs, analyze,test,script and document them to strengthen quality and functionality of business-critical applications.
2017 - 2019
unilever
Business Intelligence Analyst
• Extracting data from multiple sources, manipulating data,data validation, and conducting Root Cause Analysis, developing business, operational solutions and recommendations and presenting to Executive team using Tableau and Excel • Automate day to day extraction of data through ETL tool Talend • Successfully built Innovation reports in Tableau to give meaningful insights on the health of each launch. • Manage the offshore team and guiding and helping them in reporting, debugging and developing new projects. • Successfully managed data extraction project from 3rd party warehouse database and analyzed the data to give meaningful reports using SFTP and Tableau • Worked closely with Sales, Operations and Finance teams to gather requirements and develop into meaningful dashboards in Tableau. • Working closely with Unilever for data integration by cleaning and extracting data. • Provide data for ad hoc requests using SQL, PostgreSQL and Excel.
2017 - 2017
synapse
Data Analyst
• Devised solution to compare predicted and actual sales to improve future forecast • Extract data from relational databases (MS SQL Server, Green Plum) using SQL and PostgreSQL and writing business logic to provide insights • Improved ability to analyze SKU level and account level revenue by creating reports in Tableau for visualization of sales data • Identified root cause and provided solution for data breaks in critical management sales reports • Understanding the client’s business requirements and translating them into technical terms to better analyze data and get concrete results
2015 - 2016
utah state university
Data Analyst & Security Intern
• Automated the activity of manually checking each suspicious IP’s server attribute based on Python through Pandas and BeautifulSoup which saved 4 hours of effort per month • Analyzed the IP's and the source of attack. • Protect the IT assets and network of the university by understanding and analyzing traffic flow and differentiating legitimate from unwanted traffic using tools like IP Visualizers, Arecibo and snort for any attacks or scans and blocking them • Work through all the tickets to recognize the malicious systems and work on them accordingly.
2015 - 2016
utah state university
Teaching Assistant
• Attending and solving any queries raised by students in class. • Helping students with any difficulty encountered by them during assignments. • Grading the assignments appropriately. • Created module for R and taught the R sessions for undergraduates.
2012 - 2015
mindtree
Software Engineer
• Designed and implemented a delivery platform using agile methodology which was used for managing data and organizing details of project data needed by project managers for the effective planning and delivery of software development projects from inception to deployment. • Created and maintained robust functionality to save changes on internal web portal in C# and SQL to consistently update data in spite of multiple concurrent access • Increased quality of deliverables by conducting peer code verifications, SONAR analysis and suggesting improvements • Implemented interactive charts to understand and analyze the health of projects • Identified root cause and provided solution for data breaks in critical management sales reports • Translated business requirements into meaningful dashboards using Highcharts and SQL.
Experience
31 Skills
Agile Methodologies
Business Intelligence
C
C#
C++
Cascading Style Sheets (CSS)
Core Java
CSS
Data Analysis
Data Mining
Databases
HTML
JavaScript
Linux
Management
Microsoft Excel
Microsoft Office
Microsoft PowerPoint
Microsoft SQL Server
PostgreSQL
Programming
Python
R
Software Development
SQL
SQL Server Integration Services (SSIS)
Tableau
Visual Studio
Web Development
Web Services
XML
Education
2008 - 2012
chameli devi institute
Bachelor's degree
Computer Science
2006 - 2008
the aditya birla public school
Higher Secondary (High School)