Mantej Singh Dhanjal Business Intelligence Analyst | Data Analyst Having 2+ years of analytical experience with data extraction techniques and applications, functional knowledge of data reporting/analysis tools and Business Intelligence tools in Manufacturing and Retail domains. Exposure to various tools: Informatica 9.1, Oracle SQL, Tableau, Spreadsheet, R and Python(PANDAS). [email protected]

+1-862-300-8207

Jersey City, NJ

www.linkedin.com/in/mantejsingh-dhanjal

www.github.com/Mantej-Singh

Work Experience

Skills & Competences

Bluefly Business Intelligence Analyst Intern 06/2016 - 08/2016

Business Intelligence Tools New York, US

Social Media Analyzer: Developed a program in Rstudio using R to gather, analyze and find trends in the Bluefly’s unstructured user’s comments on Twitter & Facebook, gave 10 tips on how Bluefly can use Social Media for lead generation and boost sales Wrote complex SQL queries to get relevant data for analysis from customer’s feedback, Sale, and Stock datasets Implemented Joins, Data Blending, Custom SQL in Tableau, created dashboards & pivots in Tableau and Excel Drove UI testing on Bluefly’s Mobile app and website. Logged defects, 5% decrease in bugs Environment: Tableau Desktop, Excel, SQL Developer, R studio, Python, Google Analytics & Google Trends

Databases Programming Language

Achievements Initiated and delivered ad-hoc requests on behalf of the Business Intelligence team to VMWare Inc. 01/2014 - 12/2014

Slashed production time by 2+ hours using automated queries, saved over 200 man-hours per month. 05/2014 - 08/2014

Lifted the profit margins by 12% for VMware Inc (Q3 2014), eliminated costly services. 07/2014 - 10/2014

Accenture Associate Software Engineer/BI Developer

Projects

11/2013 - 07/2015

Social Media Analyzer | R 06/2016 - 07/2016

Mumbai, India

Sentiment analysis over Twitter API using R.

Build dashboards, automated reports, and ad hoc reports based on agile business requirements

ETL Pipeline | Python 07/2016 - 08/2016

Contributed reports (Pivots) in Excel used advance SQL and functions like VLOOKUP, INDEX + MATCH, SUMIFS Developed and overhauled ETL mappings and mapplets to extract data from source systems into the Staging area Handled issues raised by VMware users in Helpzilla ticketing system, improved communication and reduced ticket turnover rate by 7%

Python code to extract, clean & dump the data with email notification using Pandas.

Web Scraping Project | Python 12/2016 - 01/2017 Crawled the data to parse person’s name, email address, and net worth, generated report from it using BeautifulSoup, Pandas, RE, NLTK and D3 API.

Programming

Automated SQL queries, fetched data directly from the Informatica repository and listed output as succeeded, failed, long running jobs saved overall production time by 2+ hours Environment: Informatica Power Center 9.1, SQL, QlikView, Crontabs, OBIEE, BO, Toad 10.5, Control M

Education Master’s Degree- Computer Science New Jersey Institute of Technology, US. 09/2015 - 08/2016

GPA- 3.4

Bachelor’s Degree- Information Technology University of Mumbai, India. 05/2010 - 06/2013

GPA- 3.8

Interests Data Science | Data Analysis | Data Visualization | SQL

Mantej Singh Dhanjal - GitHub

07/2014 - 10/2014. Accenture. Associate ... Drove UI testing on Bluefly's Mobile app and website. Logged ... 10 tips on how Bluefly can use Social Media for lead.
Download PDF
441KB Sizes 15 Downloads 201 Views
Report

Recommend Documents

Manmohan Singh - Visva Bharati
Topic: India's Export Trends and Prospects for Self-. Sustained Growth. [Published ... Japan's leading business daily. 1996 Honorary. Professor, ... Sept 1982 – Jan 1985: Governor, Reserve Bank of India. April 1980 – Sept 1982: Member-Secretary,
Maharaj Singh Order.pdf
For Respondent(s) Mr. Ashok Desai,Sr.Adv. Ms. Rukhmini Bobde,Adv. Mr. Abhiram Naik,Adv. Ms. Mohuna Thakur,Adv. M/S. Parekh & Co., AOR. UPON hearing the counsel the Court made the following. O R D E R. Delay condoned. The special leave petition is dis
Ritesh Singh Rajpoot.pdf
~Google Analytics ~Google Webmaster ~ Google Merchant Centre. ~ Gupshup messenger bot builder ~Many Chat fb messenger bot builder ~ MOZ. ~Wordpress ~Shopify ~Joomla. ~Blogger ~HTML ~Proshow Video Maker. Ritesh Singh Rajpoot. Phone:09630784804. E-Mail
Amardeep Singh Saini.pdf
under the University of Mumbai. By. Mr. Amardeep Singh Saini. Class & Roll No: MMS-A-52. Specialization: Finance. Batch: 2013-15. Under the Guidance of.
Bikram-Singh-Judgment.pdf
Page 1 of 60. ITA No.55/2017 Page 1 of 25. $~. * IN THE HIGH COURT OF DELHI AT NEW DELH. + ITA 55/2017. Reserved on: 03rd August, 2017. Date of decision: 25th August, 2017. PRINCIPAL COMMISSIONER OF. INCOME TAX – 7 ..... Appellant. Through: Mr. Ruc
Ajay Singh Chautala.pdf
had been admitted to Medanta, Medicity Hospital, Gurgaon. An additional. ground for rejection ... IN. Page 3 of 6. Main menu. Displaying Ajay Singh Chautala.pdf.
Virabhadra Singh - Taxscan.pdf
Page 1 of 58. High Court of H.P.. IN THE HIGH COURT OF HIMACHAL PRADESH. SHIMLA. CWP No. 3077 of 2016 alongwith. CWP No. 3079 of 2016.
Indian-Economy-Ramesh-Singh-7thEdition.pdf
Page 1 of 824. McGRAW HILL EDUCATION SERIES. COCK. INDIAN. ECONOMY. For Civil Services Examinations. S E V E N T H E D I T I O N. Page 1 of 824 ...
Navjot singh Sidhu Judgment.pdf
CRIMINAL APPEAL NO.58 OF 2007 ... injuries: 1) 0.75 cm x 0.5 cm abrasion present over left temporal. region at ... Displaying Navjot singh Sidhu Judgment.pdf.
chatur singh two star 720p.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. chatur singh two ...
870 DIGVIJAY SINGH CHOUHAN.pdf
Sign in. Loading… Whoops! There was a problem loading more pages. Whoops! There was a problem previewing this document. Retrying... Download. Connect ...
Group Theory Anupam Singh
This is class notes for the course on representation theory of finite groups. ..... group has an element of order p2 and H is the subgroup generated by that element ...
Shri Narendra Singh Tomar inaugurates Heat Hardening ...
Shri Narendra Singh Tomar inaugurates Heat Hardening Pelletisation Unit.pdf. Shri Narendra Singh Tomar inaugurates Heat Hardening Pelletisation Unit.pdf.
Navjot singh Sidhu Judgment.pdf
of Battian Wala Chowk in front of the State Bank of Patiala,. Patiala City. Jaswinder Singh (PW3), Avtar Singh (PW4) and the. deceased Gurnam Singh were ...
Hindi_Essay_by singh bhupi sir.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Main menu.
Hindi_Essay_by singh bhupi sir.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Hindi_Essay_by ...
raj kumar singh parihar
Multiprocessor Architecture and Parallel Processing ... VLSI Architecture (RISC, CISC, and DSP). § ... development, ZigBee - MiWi application development.
khamoshiyan song arijit singh free.pdf
Page 1 of 1. Khamoshiyan song arijit singh free. Page 1 of 1. khamoshiyan song arijit singh free.pdf. khamoshiyan song arijit singh free.pdf. Open. Extract. Open with. Sign In. Main menu. Displaying khamoshiyan song arijit singh free.pdf. Page 1 of 1
raj kumar singh parihar
Multiprocessor Architecture and Parallel Processing ... VLSI Architecture (RISC, CISC, and DSP) ... development, ZigBee - MiWi application development.
free mika singh mashup.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. free mika singh mashup.pdf. free mika singh mashup.pdf. Open. Extract. Open with. Sign In. Main menu.
Singh - Steps Towards Continual Learning.pdf
(e.g., push ball to marker, toggle light switch). Objects: Switch controls room lights; Bell rings and moves one square if ball hits it;. Pressing blue/red block turns ...
GitHub
domain = meq.domain(10,20,0,10); cells = meq.cells(domain,num_freq=200, num_time=100); ...... This is now contaminator-free. – Observe the ghosts. Optional ...