Sign in

Python, SQL, R, Tableau, Agile Project Management, AWS

Dallas, TX
March 29, 2019

Contact this candidate


Somya Pandey

Dallas, Texas Tel: +1-682-***-**** E-Mail:

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


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).


December 2011 – April 2012

-Developed a light-weight and fast-loading antivirus in Java, which could detect and block viruses in 130 file extensions.


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

Contact this candidate