Resume

Sign in

Business Intelligence Developer

Location:
Sterling Heights, MI
Posted:
March 30, 2019

Contact this candidate

Resume:

ADITYA GOSWAMI

408-***-****; ac8yc3@r.postjobfree.com; https://www.linkedin.com/in/adityagoswami28

SUMMARY

Four years of experience in Business Analytics with advanced knowledge of quantitative analytics, Data Warehousing and data mining techniques with excellent programming knowledge of RStudio, SAS Base, SQL, Advanced Excel, Qlikview, Tableau and Hadoop.

A highly motivated hardworking and quick learner, graduated as Master of Science in Business Analytics with strong background of MBA in Marketing. Seeking for full time opportunities in the field of Business Analysis.

EDUCATION

The University of Texas at Dallas, Richardson, Texas

May 2016

M.S., Business Analytics

GPA: 3.66

Mumbai University, Mumbai, India

June 2013

MBA – Marketing

GPA: 3.52

Pune University, Pune, India

June 2010

B.E., Computer Science

GPA: 3.40

TECHNICAL SKILLS

Data Mining & Analytics:

SAS Enterprise Miner, R Studio, Alteryx, Power BI, Google Analytics, SAS Base, Hadoop

Database:

MySQL, Microsoft Access

Programming:

C, C++, Java, VB, SAS Base, SQL, Oracle, PL/SQL, HTML, HTML5

Operating System:

Windows, Macintosh, Linux

Data Visualization:

Tableau, Qlikview, Qlik Sense, Zoho reports

Software Tools:

MS Office, SQL Developer, SAS, Advanced MS Excel, SSIS

PROFESSIONAL EXPERIENCE

Ford Motor Company – Dearborn, Michigan

Business Intelligence Developers June 2016 - Present

Gathered and maintained data from various sources and created working and robust data structure using alteryx

Joined multiple functional datasets together to create star and snowflake schemas for fast processing

Developed and published dashboard and created executive reports using Tableau and QlikView

Performed set analysis on multiple variables of the dataset to categorize variables into multiple sets for better understanding of the data

Developed and tested the dashboards in the proof of concept environment and moved them into Production environment upon completion

Developed a decisive dashboard about the cost structure of the cloud services and helped save department $1.8 millions per month

Analyzed data of more than 100 million rows using Hadoop, qlikview and tableau and created weekly reports for executives for decision making

Gathered and analyzed technical requirement and produced high quality requirement document

Presented the findings in monthly business progress review

Krishna Web Developers – Pune, India

Business Intelligence Analyst January 2013 – December 2014

Analyzed requirements and lead design sessions to produce high quality business requirements

Formulated user stories, created business documents like Functional requirement document and System design document

Designed various business diagrams such as Use case diagrams, Activity diagrams using Visio

Worked with stakeholders and development team to resolve issues, provide appropriate solutions and create new products

Implemented predictive models using SAS, Tableau and derived many predictions based on the data in hand

Analyzed data with more than 100 million transactions using SAS Base and used many statistical techniques such as Logistic regression, Multinomial regression, decision tree, market basket analysis

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction and developed various SQL queries to maintain Data Warehousing schema

Presented the findings to the stakeholders and also created business reports

Business Development Executive Intern May 2012 – August 2012

Formulated the online Marketing strategy for the VoucherKarma, introduced Karma points and reduced the bounce rate by 56%

Estimated the perceived value of the Vouchers by conducting an online research and increased the sale by 80%

Acquired new business customers by analyzing the requirements, negotiating contracts with the clients and increased the annual sale by 60%

Interacted and collaborated with marketing and development teams as a voice of client and also documented analyzed requirement stating the detailed business process

Increased the clientele of the company by 50% thereby achieving the monetary target of more than 150%

ACADEMIC PROJECTS

Business Intelligence – Predicting Customer salary August 2015 – December 2015

Designed a model using different predictive modelling techniques to predict the salary of a person using various variables

Determined the best predictive model by comparing misclassification rate and increased accuracy by 20%

Identified and established KPIs using Tableau and Qlikview

Marketing Analytics using SAS - ConAgra Project June 2015 – August 2015

Analyzed and examined real transactional data using SAS and used many statistical techniques like K-means clustering, logistic regression and survival analysis as a result achieved 2nd prize in a class of 60

Suggested possible recommendations which when forecasted would increase the revenue by an estimate of 1.9%

Identified correlation between private label categories to develop new business strategies

LEADERSHIP EXPERIENCE

Peer to Peer Mentor, UT Dallas

August 2015 - Present

Business Analytics Buddy Program, UT Dallas

May 2015 - Present

Versatalia, General Sport Secretary

June 2009 – June 2010



Contact this candidate