SHUBHAM DWIVEDI
469-***-**** **************.****@*****.*** https://www.linkedin.com/in/dwivedishubham
PROFESSIONAL SUMMARY
Experienced data scientist and worked extensively in data modelling, business intelligence and analytics with strong hold in data mining, ETL tools, requirement gathering and analysis and data visualization tools. Have a proven track record for improving the efficiency and productivity of corporations through strong communication, technical and analytical skills.
EDUCATION
Master of Science in Information Technology and Management August 2017
(Minor in Business Intelligence and Analytics) 3.72
University of Texas at Dallas, Richardson, Texas
Bachelor of Technology in Computer Science and Engineering July 2012
Uttar Pradesh Technical University, India 3.70
TECHNICAL SKILLS & CERTIFICATIONS
Languages: R, SAS Enterprise Miner, Octave, C++, C, Java, Python 2.7.9, Oracle SQL, MySQL and PL/SQL
Reporting and Visualization Tool: SAP Business Objects XI 3.1/ BOBJ, Tableau 9.0, and Qlikview
ETL Tool: Informatica Power Center 8.6/9.1/9.5.1/9.6.1, SAP BODS 3.2/4.1, Microsoft BI (SSIS, SSAS, SSRS), DOMO
Application Tool: Toad, SQL Developer, MS Office (Microsoft Advance Excel and Access) and MS Project
Scheduling, Analysis and Analytics Tools: Autosys, Digital Marketing (Google Analytics & AdWords)
Certifications:
Awarded with Level 1 certification for DWH/BI Concepts by NTTDATA Learning & Certification Institute.
Google Analytics and Google AdWords Certification
Machine Learning – Stanford university
Big Data Basics: Hadoop, MapReduce, Hive, Pig, & Spark by Udemy
Data Science: Polynomial Regression, R, and ggplot by Udemy
Familiar with Agile Software Development Methodology
PROFESSIONAL EXPERIENCE
Data Scientist Intern, SPLASH MEDIA GROUP, LLC (Dallas, Texas) May 2016 – Present
(Facebook):
Performing correlation analysis, regression analysis, developing algorithms and mathematical models to improve reporting platforms etc.
Extracting, compiling and analyzing client’s big data for web, social and video data to get Business Insights using tools (DOMO, SPREDFAST etc.)
Providing actionable insights to through Social Network Analysis and Data Visualization to clients like Facebook, SBI etc.
Extracting meaning from large data sets using a variety of machine learning, data mining, and data science techniques
Software Engineer, NTT DATA (India) June 2013 – February 2015
(Honeywell): Performed data analysis and worked extensively in Data warehousing, database systems and coded using ETL tools like SAP BODS (3.x & 4.x) and Power Center Informatica (8.x & 9.x) that improved the productivity by 10%.
Worked in Oracle 11g using Toad to develop PL/SQL programs to help to monitor the data loads in JSP web page
Designed and developed SAP (Business Objects) reports. Also, enrooted and maintained dashboards for clients
Developed PL/SQL scripts for providing access to users and getting the transaction details
Implemented a one-stop all-platform all-metrics data reservoir for ad-hoc reporting, expediting data visualization by 10%
NON-ACADEMIC PROJECTS
Recommender System: Produced automated recommendations of products with collaborative filtering techniques
Movie Trailer website: Developed a movie trailer website using Python 2.7.9 to watch movies trailer. A browser will open on your machine and click on movie thumbnail you can view the trailer
Profanity Editor: Developed a project in Python 2.7.9 to tell to keep check on profanity
ACADEMIC PROJECTS
Data Mining and Data Modelling - San Francisco Crime Classification (SAS Enterprise Miner): Generated a set of decision rules as part of predictive analytics and data mining to predict the category of the crime for a given location
Data Visualizations using Tableau: Identified dimensions and measures. Placed different types of charts according to the KPIs to be illustrated. Applied understanding of quick filter formatting, story points, Visual data window handling, excel and text file connector. Added complicated data to the reports using the calculated fields formed using various aggregation levels in Meta data
Inventory Warehouse (Microsoft SQL Server): Designed an Inventory Online Transaction Processing System in MS-SQL. Designed and developed a data warehouse for reporting on the above OLTP. Created an ETL program using SSIS. Created Reporting cubes in SSAS
AWARDS & RECOGNITIONS
Elected as Vice-President of Infinity Lions Club by members of the club (People’s Choice)
Led the Team as Team Captain and was among Top 5 teams in Clinton’s 6th Annual Hult Prize Challenge in UTD
Awarded for being the Founder & Organizer of Literary Committee, IIMT Institute of Engineering & Technology, India