Post Job Free
Sign in

Data Sales

Location:
Buffalo, NY
Posted:
September 29, 2017

Contact this candidate

Resume:

Education:

University at Buffalo Master of Science in Management Information Systems September 2017

Rajagiri School of Engineering and Technology Bachelor of Technology in Electrical and Electronics Engineering June 2013

Skills:

Requirements Gathering and Analysis

ERP, BI & RDBMS Tools: SQL, SAS programming, SAS E-Miner, MySQL, Oracle, Python, C, Excel (Pivot tables, Macros)

Data Discovery Tools: NodeXL, Tableau Data Analytics: Courses in Predictive Analytics, Social Network Analytics, Systems Analysis and Design (SDLC, Agile), Data Mining, Modern Database Management, Health Information Systems

Projects:

Development of a Vendor-Management System to manage all applications associated Spring 2017

Performed stakeholder analysis and requirements gathering, created requirements elicitation questions based on suitable techniques, developed functional hierarchy and documented high-level, low-level and non-functional requirements.

Documentation of Non-Functional Requirements in Agile Projects (Requirements gathering in Agile) Spring 2017

Demonstrated the current issues with addressing Non-Functional Requirements (NFRs) in Agile, compared the exiting alternatives available in the market and proposed better solutions to deal with NFRs more effectively.

Banking Data Exploitation for Informed Decisions: Fall 2016

Designed the conceptual and logical data model (ER Diagram) of a credit card company entities using MS Visio.

Created a physical data model (relational database management system) via SQL developer on Oracle 11g.

Retrieved meaningful insights from the designed database by generating complex SQL queries.

Contrasted the effectiveness of their respective social media campaigns over a period of three months.

Developed BI Solution for Retail Analytics: Fall 2016

Scrubbed the data and applied several data transformation techniques using ETL Informatica.

Analysed the data to determine the loyal customers, the number of customers lost in the previous year, promotion methods for active and inactive customers and changes in profit percentage .

Forecasted sales by generating dashboards and BI reports in Tableau.

Data Manipulation using Python: Summer 2017

Created a Python technical documentation for novice programmers with no prior experience in Python.

Performed data analysis using pandas from CSV, Excel, Txt and JSON files including indexing, slicing, deleting and updating data frame rows and columns.

Employed Python for interacting with SQLite and Psycopg2 Databases and creating data visualization charts.

Sales Forecasting Analysis using SAS E-Miner: Spring 2017

Built regression models, decision trees, random forests for predicting financial profits using SAS Enterprise Miner.

Data collected was insightful in boosting sales for customer-oriented organizations.

Social Media Analysis of ad-campaigns: Spring 2017

Analysed the Social Network data from Twitter and YouTube pertaining to Google’s Waymo and Tesla’s Autopilot using NodeXL.

Created network visualizations based on the user behaviour (likes, dislikes and co-commenting on YouTube videos).

Work Experience:

Specialist - JP Morgan and Chase, Bangalore, India March 2016 - June 2016

Performed fraud analytics on calls from customers disputing unauthorized transactions on their Chase bank accounts.

Technical Support Associate - Dell International Services, Bangalore, India May 2015 - August 2015

Resolved various issues pertaining to data backup, virus removal, data recovery, operating system thereby preventing any data loss for clients with 100 percent customer satisfaction and reduced call backs from 70 to 40 per day.

Systems Engineer - WIPRO Technologies, Bangalore, India January 2014 - April 2015

Performed testing on Egan, Marino Corporation Symmetrix storage boxes and single-handedly prevented data loss by troubleshooting back-end problems employing Salesforce.

Analyzed application and system logs to perform root cause analysis.



Contact this candidate