Somya Pandey
Dallas, Texas Tel: +1-682-***-**** E-Mail: ac8xvm@r.postjobfree.com
Professional Summary
Pursuing Masters in Information Technology & Management at The University of Texas at Dallas.
Have more than 5 years’ work experience with leading technology companies.
A result orientated professional with a blend of diverse tech and business skills.
Strong Understanding of Data Structures and algorithms.
Relevant Courses
Object Oriented Programming with Python, Big Data Analysis, Business Analytics With R, Statistics and Data Analysis,
Database Management, Agile Project Management, Systems Analysis & Project Management, Operations Management
Skills
Python, SQL, R, SAS, C++, Java, Statistics, Tableau, SAS, Advanced Excel, Linux, MS Office, Hadoop, Spark, Hive, Sqoop, MapReduce, HDFS, MySQL, HTML5, CSS, MS Project
Work Experience
Accenture LLP, India
Senior Business Analyst – 02/2016 to 06/2018
Developed models and dashboards using tools like R, Tableau, Excel for Accenture’s account business across all portfolios (Strategy, Digital, Technology) to improve business cases for tracking critical business metrics like deliverables, intellectual property, enterprise risk, no LBA’s, etc.
Analyzed system specifications and use cases from stakeholders for improvement in record management and contract management systems to release newer versions for effective and improved legal business operations.
G-Cube Solutions, India
Senior Analyst – 07/2014 to 12/2015
Supported country’s largest ecommerce company’s seller business to build data analytical models and dashboards to monitor and enhance key business parameters like seller engagement, seller performance, returns, customer satisfaction, compliance, etc.
Evaluated and created requirement specifications for company’s internal CRM requirements for effective sales tracking and data management. Evaluated multiple vendors and submitted my report to leadership to shortlist one for internal use.
Compunnel Software Group Inc., India
Business Analyst – 07/2012 to 06/2014
Formulated requirement specifications of one of country’s largest consumer goods companies’ supply chain workflows to create an automation tool to streamline their sales and operations planning.
Build dashboards using analytical tools like Python, Tableau, to track real-time sales activities across the country, including order fulfilment. The tool enabled the leadership to pull region-wise and cluster-wise real-time reports in sales and operations.
Academic Projects
UTD-Play Application
August 2018 – December 2018
-Developed a database application for UTD students to connect with other students to play various sports on campus and to enable UTD management to manage facilities and equipment. Concepts used: SQL, ER diagram, Normalization
Data Analysis Project – IMDb 5000
August 2018 – December 2018
-Performed probability classification and logistic regression on 5000 IMDb movies data using 27 independent variables and correcting the model to accurately predict IMDb ratings (dependent variable).
Antivirus
December 2011 – April 2012
-Developed a light-weight and fast-loading antivirus in Java, which could detect and block viruses in 130 file extensions.
Education
M.S: Information Technology & Management, Dec 2019 B.Tech: Information Technology, May 2012
The University of Texas at Dallas – USA Amity University – India
New Dean's Excellence Scholarship