Civil Engineering Data

AMRIT ANAND

*** ***** ****** *******, ** 142**-***-*** 5011 ***@*******.*** www.linkedin.com/in/amrit-anand14

EDUCATION

UNIVERSITY AT BUFFALO, THE STATE UNIVERSITY OF NEW YORK

Master of Science in MANAGEMENT INFORMATION SYSTEMS, CGPA- 3.890 expected June 2019

MANIPAL INSTITUTE OF TECHNOLOGY, MANIPAL UNIVERSITY

Bachelor of Engineering in Civil Engineering, Graduated First Class with Distinction May 2012

ACADEMIC PROJECTS

Employee Database Design and Analysis FALL 2018

Designed entity relationship (ER) Models, followed by database design, adhering to business rules.

Analyzed employee data using SQL and created Excel-based reports for the same.

Industrial Project: Rich’s Process Systems, Buffalo Feb 2019-present

Collaborated with client to understand the requirements and communicated the same with the team.

Created lucid technical design and flows by applying techno-functional expertise.

Identified technical feasibility, risks and highlighted business impact to stakeholders in case of implementation failures.

EXPERIENCE

MYSMARTPRICE WEB TECHNOLOGY PVT LTD Hyderabad, India

Business Analyst Oct 2015-Jun 2018

Created ad-hoc reports to analyze web data, prepared Business MIS, measured the performance of sale activities conducted by writing SQL queries on MySQL and Redshift databases, and using Google Analytics.

Created multiple pre and post analysis and A/B testing to optimize web pages, sale pages, email marketing campaigns.

Created complex SQL queries using joins, subqueries and analytical functions to analyze transaction data, path to purchase of users, funnel metrics and utilized MS Excel Pivot charts/dashboards to make informed business decisions.

Worked with the Strategy Lead to Identify and document key metrics to measure the performance of website and App across all categories (mobiles, electronics, appliance, fashion etc).

Collaborated with Engineering team to design reporting panel which automated report generation, saving daily effort and aiding Strategy lead and Sales team in making business decisions.

Designed wireframes and mockups using Balsamiq, to add new features and modify existing features of the product.

Played an integral role in the data intelligence project providing intelligence on e-commerce pricing, user purchase behavior across online stores etc. to 3rd party clients, generating additional revenue of 10%.

Analyzed user behavior across travel sites and browsing devices – desktop, mobile etc. and applied statistics internally to target users through browser notifications, emails generating additional revenue of 5%.

TATA CONSULTANCY SERVICES LTD Mumbai, India

Business Intelligence Developer Sep 2012- Sep 2015

Created automated scripts to process and store data in SQL Data warehouse used for creation of various business reports/dashboards in MicroStrategy, driving effective business decisions.

Designed database tables to store data and wrote complex SQL queries using Teradata utilities to perform ETL on SQL Data warehouse, and conducted Unit Tests, System Integration testing (SIT) for the same.

Acted as a single point of contact (SPOC) for a 4+ member team in planning and delivering business intelligence projects.

Prepared and presented status reports for clients, shared with leadership regularly.

Earned Star of the Month and On-The-Spot awards for consistent, high quality deliverables.

SKILLS AND CERTIFICATIONS

Tools/Software: MS Excel, MS PowerPoint, Google Analytics, Tableau, IBM Watson, SAS, Balsamiq

Databases: Teradata, Oracle 11g, Amazon Redshift, MySQL

Languages: SQL, Unix shell script, Python, Java, HTML

Certifications: Tableau Certified Desktop Specialist, Google Analytics Certified- Advanced, Certified Scrum Master,Pursuing Oracle SQL Certified Associate

Contact this candidate