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