SHASHANK SHANKARNARAYAN
#** ********** ***, *** *********, NJ 08901 Ph no.+1-412-***-**** *****************@*****.*** www.linkedin.com/in/shashankshankarn/ SUMMARY
Experienced IT professional with work experience in Oracle PL/SQL, Business Intelligence Reports, Talend ETL, Greenplum, SQL Server, Pitney Bowes. Thorough knowledge in Database management concepts, Analytics and ETL. Actively seeking opportunities in Data Analytics, Data Warehousing/Business Intelligence, Data Engineering, Business Analyst, Databases, Product/Technology Management and other relevant positions. EDUCATION
• Rutgers Business School, Rutgers University, NJ, USA Expected Dec 2018 Master’s in Information Technology & Analytics. Relevant Courses: Data Mining, Data Management, IT Strategy GPA: 3.741
• University of Mumbai May - 2011
Bachelor of Engineering in Electronics & Telecommunication First Class TECHNICAL SKILLS
Programming: R, Python, Java, HTML
Tools: Talend ETL, Informatica ETL, Tableau, BIRT Reports, Pitney Bowes, SSIS, SPSS, Unix Databases: Oracle PL/SQL, Greenplum, PostgreSQL, MS SQL Server Others: MS Office, JIRA, Tortoise SVN, GIT, Excel Functions VLookup TRAININGS & CERTIFICATIONS
Intro to Python for Data Science – Jan 2018, SQL Server Integration Services – June 2015, Informatica ETL - Nov 2013 PROFESSIONAL EXPERIENCE
CITDEX ADVISORY Aug 2018 – Aug 2018
Information Systems Intern New York, NY
• Developed a business case to conduct market research on emerging block chain technologies like Hyperledger Fabric, Ethereum and Bitcoin.
• Designed technical specs for the outlined projects and technical due diligence of the potential customers.
• Presented the research findings to the leadership team which led to selection of appropriate blockchain technology by customers. CAPGEMINI Jan 2017 – Jun 2017
Consultant, Mc Donald’s Client Mumbai, India
• Led a team of three members and was involved with the Data Analysis of Customers of Mc Donald.
• Collaborated with Clients for Requirement Gathering and proposed Data Quality checks on the customers’ data. TATA CONSULTANCY SERVICES LTD Apr 2016 – Dec 2016
Systems Engineer, General Electric (GE), Data Ingestion Project Mumbai, India
• Involved with cleaning of the csv’s using unix commands and manual ingestion using gpfdist commands, and also performed root cause analysis to eliminate the improper data format and for proper ingestion into target.
• Proposed and designed the solution to automate Talend job for database cleanup activity for increasing the database space of Oil & Gas, Healthcare domains, which increased the efficiency by 30%, and scheduled it using Talend Administrator Center. MASTEK LTD Apr 2012 – Feb 2016
Software Engineer, Home Office UK Govt Project Reading, UK
• Developed Talend ETL mappings and Unit Tested the Talend jobs which resulted in least number of defects, to form an operational data store, following Agile methodology.
• Customized Oracle PL/SQL packages, Business Intelligence reports and Output forms using Pitney Bowes Tool to print Mumbai, India the Output Form with all the Line of Businesses and with the coverage information regarding the insurance, organized knowledge transfer sessions as well, designated as Trainee Software Engineer/Software Engineer in Cypress Project. GRADUATE PROJECTS
Data Analysis of Car Company which launched SUV Model Fall 2017
• Performed Classification using Decision Tree, Random Forest and Logistic Regression. Obtained 85% accuracy for purchase by customers, thereby suggesting that the car company must go for the production of its new SUV model. Self-Driving Autonomous Uber Cars' Data Analysis Fall 2017
• This Marketing Research project was undertaken to evaluate Uber’s autonomous cars acceptance in terms of what people expect in self-driving car. Conducted Linear Regression, T - Test, Cross Tabulation, Correlation, Pie charts, clustered bar graphs using SPSS. Analysis will help Uber in aligning itself to people’s needs for the launch of its self-driving car. Online News Popularity Spring 2018
• Successfully managed and guided a team of 4. Performed Regression and Classification using Knn and Regression Trees, Data Visualization by plotting ROC, Decision Tree, scatterplot, R libraries like ggplot. to predict the popularity some of the news (url). US Candy Production Fall 2018
• Implemented time series forecasting to analyze monthly Candy production data using exponential models like SES, Holt’s method, Holt Winters, ETS and ARIMA models, and achieving best results using ARIMA. Future productions were forecasted in order to win the competitive market.