Data Analyst Engineering

Sahej Vijan

Arlington, TX +1-619-***-**** **********@*****.*** linkedin.com/in/sahej-vijan

Technical SKILLS

Microsoft Technologies Linear Programming, Data Analysis, Solver, VLOOKUP, VBA, Macros, Pivot, MS PowerPoint, MS word, Marketing Engineering for Excel Programing Languages Python, SQL, R, SAS.

Visualization/Reporting Tools Tableau, Power BI, Power Pivot, QuickBooks, Visio, AutoCAD, ETL Frameworks Pandas, Numpy, Matplotlib, scikit-learn, Tensorflow, Django, Plotly Work Experience

University of Texas at Arlington

Help Desk Analyst – OIT Department June2019- May 2020

Prepared references for users by writing clear and precise operating instructions.

Created support documentation for at least 30 customers that empowered and enabled user community to extend skills, leverage system features and find resolutions to questions without intervention from support team.

Installed and updated hardware, software and applications on Mac and Windows devices.

Provided customer support and technical support to almost 50 customers daily.

Assisted customers with troubleshooting issues encountered while using hardware or software, providing actionable tips to resolve problems.

Engaged end users and answered questions via email, phone, website live chat and in forums in a precise manner.

Trained and supported end-users with software, hardware and network standards and use processes. Amber Electrotech

Position: Data Analyst June 2017- July 2018

Amber Electrotech is an Electrical contracting organization providing solution with activities engaging from Substation, Internal & External Electrification for conventional and high-end solutions with projects ranging from $15,000,000 to

$20,000,000 and overall revenue of $40,000,000 to 50,000,000 per year.

Performed loading, Extracting and validation of client database by writing SQL queries.

Proposing solutions to system efficiencies to optimize resources and reduce total expenses by 20%

Evaluated change order requests in response to out-of-scope work activities thereby increasing site revenue by 10%

Proactively Liaised with company executives and project managers to acquire resources to move projects forward.

Created Power BI reports to assist with pulling information from large data sets and presenting to give concise understanding of best placement for needed resources.

Prepared monthly billing reports worth 450,000$ using advanced Excel spreadsheet functions.

Prepared monthly site progress reports on analytical tool Tableau and presented to senior management to aid in forecasting future site complications.

Determined and scheduled priorities as required to progress engineering work and developing field conditions improving Business Operations.

Amber Electrotech

Position – Data Analyst Intern June 2013- July 2015

Determined and scheduled priorities as required to progress engineering work.

Ensured Electrical works were performed under general specifications and with all safety regulations for over 150 unskilled labors.

Double-checked documentation and work orders.

Documented business workflows for managements review.

Presented findings and data to learn and reduce total expenses by 10% EDUCATION

University of Texas at Arlington

Master of Science in Business Analytics August 2018- May 2020 Visvesvaraya Technological University

Bachelor of Engineering in Electrical and Electronics September 2010- May 2017 PROJECTS

Worked with Alcon to their sales territory optimization, enhancing their Sales per representative and reducing Drive time by using Genetic Algorithm improving the Gini coefficient from 43.9 to 16.3.

Implied BeautifulSoup library in Python for web scraping and collect the extracted data in a text file for over 500,000 movies.

Worked on SAS Enterprise miner on employee dataset to identify patterns and calculate the likelihood of employee staying or leaving consequently reducing attrition rate with 89% accuracy.

Performed SVM, Random Forest, and Neural Network classifiers to build different predictive models for Image analysis with 83% accuracy.

Used SAS, Conjoint analysis, segmentation and classification, customer lifetime value, customer choice models in Advanced- Excel.

Executed Customer Lifetime Value model in Ad-Excel to predict customer loyalty.

Applied segmentation, positioning and conjoint analysis to design a new product and marketing strategy.

Contact this candidate