Available Spring ****
Piyush Srivastava
*** ******** ******, ***** ****,NJ-07087 551-***-**** ac15i0@r.postjobfree.com www.linkedin.com/in/piyush-srivastava-0ba6502
Objective: Seeking an internship/fulltime opportunity in the field of Data Science and Business Analytics. Education: Stevens Institute of Technology, Hoboken, New Jersey Expected May 2018 Master of Science in Information Systems GPA: 3.95*/4 SRM University, Chennai, Tamil Nadu,India May 2012 Bachelor of Technology in Computer Science & Engineering GPA: 8.39/10 Skills: Databases: Oracle DB2, MySQL, SAS, SPDS, Microsoft Excel. Programming Languages: SAS, SQL, Unix/Linux Shell Scripting, R, Python, Java. Software: SAS Tools (SMC, SAS DI Studio, BI IMAP Studio, Web Portal/WRS, SAS EG), Tableau, Autosys, Microsoft Office, MS Visio.
Operating Systems: Linux, Solaris, Windows and MAC OS. Certifications: SAS Certified Base Programmer for SAS 9. RELATED TechMahindra Ltd, Bhubaneswar, India 07/13 - 6/16 EXPERIENCE: SAS Consultant, Developer
• Redesigned the current ETL (Extract, Transform and Load) process along with the introduction of automated validation controls.
• Responsible for Adhoc requests and published all types of frequency reports on database needs.
• Experience in developing SAS SQL procedures and SAS Macros for Data Management.
• Proficient in writing Unix Shell Scripting to automate the process and handling issues.
• Performed User Acceptance testing(UAT) and did analysis and rectified the Production issues.
• Worked with database architects to maintain the efficiency of the database and did reporting and visualization using SAS,SQL and Tableau.
• Created Dashboards and Reports and published it to the Client’s SAS Portal.
• Trained employees on the proper ways to access and utilize the company database.
• Ability to do multitask and interact with multiple teams.
• Awarded Associate Excellence Awards for the two consecutive years at Tech Mahindra Ltd. ACADEMIC Stevens Institute of Technology, Hoboken, NJ PROJECTS: Credit Card Sales Analysis for a Bank (SAS and Tableau) Spring 2017
• Responsible for data cleansing and stored it in data marts using SAS.
• Published Reports based on yearly, monthly and quarterly sales for different regions. Predicting the Flights that are likely to be delayed (SAS and R Programming)
• Cleaning and Transformed the data using R and Normalized the model.
• Performed logistic Regression, Classification on the training and test dataset. Analyze the variables affecting the healthcare costs (R Programming)
• Using ANOVA and Linear Regression created a model and found the variables affecting the Hospital costs.
ACTIVITIES: Volunteered for CSR (Corporate social responsibility) activities in TechMahindra to teach to underprivileged children’s.
Trained number of fresher’s batches on Unix and SAS and mentored them towards the right path.