Data Analyst, Business Analyst

Shreyas Najan *** Sussex Street Harrison NJ, ***** 862-***-**** ********@****.***

EDUCATION:

Pace University Seidenberg School of CSIS, New York, NY May 2018

Master of Science in Information Systems GPA: 3.3

Relevant Coursework: Database Programming, Database Design and Development of Web, IS Project and Change Management, Data Warehousing, Mining and Visualisation, IS Design and Development, Advance Topics in Management, IS Planning and policy, Big Data, Social media and mobile marketing and Business Telecommunications.

Devi Ahilya University, Indore, India December 2014

Bachelors of Commerce (Honours) GPA: 3.7

Relevant Coursework: Programming with C++, Computer Fundamentals, RDBMS, Accounting Information Systems and Packages, E-Business and Internet Tools, Management Information System, Financial Accounting, Organizational Behaviour, Corporate, Advance and Cost Accounting, Taxation, Human Resource Management, Economics.

TECHNICAL SKILLS & CERTIFICATIONS:

Database: SQL, MySQL, NOSQL, MS Access, Oracle

Programming Languages: C++, HTML 5, CSS, PHP

Other Skills Packages: Microsoft Office(Excel, Outlook) MS Visio, MS Project, HTML, PHP Storm and My Admin, R Studio, Python, Anaconda, Spyder, Jupyter, Tableau, Apache Hadoop, IBM Bluemix, Google analytics.

PROFFESIONAL EXPERIENCE:

Magal Auto Pvt. Ltd., India Analyst July 2013 - June 2016

Provided support in client/vendor management, business risk management, cost management, business development, resource management and overall operation of gas fitting and restorations. Oversaw 10+ employees, managed revenues and developed financial reports using excel to closely monitor margins. Successfully interpreted data to identify key metrics and draw conclusions. Assisted team with analysis that increased sales performance by 21%.

Studied market research and trends to determine customer demand, potential sales volume and effect of competitor's operations on sales using prediction models. Automated the pipeline for reporting and developed user interface with reproducible method using R, VBA, Tableau. Describing Meeting Minutes of day to day work.

Used SAS and R statistical languages to create a number of intricate datasets which produced statistics, tables, figures, charts and graphs. Supported other members in preparation and interpretation of financial statements such as balance sheets and income statements. Implemented procedures for construction of optimal portfolio for maximizing returns. Provided assistance for pattern recognition of financial time series data sources and forecasting of returns.

ACADEMIC PROJECTS:

Project Management and Information Systems Planning and Policy

Involved in entire SDLC lifecycle, interacting with the product managers and stakeholders for collecting functional-technical requirements to accommodate changing needs, participated in release management activities, delivering essential quality products, Risk Management, ERP, various analysis and other documents as a Project Manager in Bay Heights Marathon. Agile and Waterfall methodology used. Researched case studies in multiple industries. Used 4 phases that is Requirements Gathering, Designing, Developing and Testing. Defining future scope.

Studied and made projects on B2B and B2C companies. Prepared project on Broadway Cafe and analysed Porter’s Five Forces, E Business Strategy, Inventory and Customer Relationship Management, Security, Risk and disaster management.

Database Design, Programming and Development of Web

Developed web page using HTML, CSS, PHP. Created Inventory Management system for watches. Created Entity-Relational Diagram. Achieved performance tuning by indexing key attributes of tables in schema.

Database Warehousing, Mining, Visualisation and Big Data

Prepared regression models using R studio, Python and Anaconda on various numerical and structured datasets.

Analysed datasets for helping in decision making using Decision Tree and Knn and knowing the future trends.

Performed various tasks on project on Classified ads for cars such as predictive, quantitative and qualitative analysis to show the relationship between the variables and accuracy.

Coded machine learning with python using Scipy, Numpy, Matplotlib, Pandas and Sklearn libraries. Performed Visualisation models on IBMBluemix/Tableau. Performed numerous tasks on Project on New York Stock Exchange dataset. Predicted future stock prices and trends based on past returns and numerical news indicators to construct a portfolio of multiple stocks in order to diversify the risk applying supervised machine learning methods for stock price forecasting by interpreting the seemingly chaotic market data. Techniques used are Data Cleaning, Rolling Mean, Standard Deviation, Time Series, Testing and Training, Trend, Seasonality, Augmented Dickey Fuller test, ACF, PACF, ARIMA model.

Finance, Accounting, Human Resource and Marketing

Prepared financial accounts, fund flow statement, accounts payable, profit-loss account and balance sheet. Calculated Financial Analysis and ratio analysis based on reports and finding the variance.

Contact this candidate