Candidates About

Mayur Dayal Hamirani

EDUCATION:

Master of Science, Computer Science, California State University, Long Beach                                              Aug 2016- May 2018
Courses: Advanced Software Architecture & Engineering, Database Architecture, Advanced Analysis of Algorithms.
TECHNICAL SKILLS:

WORK EXPERIENCE (4 years):

Data Analyst Research Assistant | Institutional Research & Assessment , CSULB - USA                                         April 2017 - Present

·    Data Analyst responsible for develop dashboard reports using Tableau for Deans of various colleges of CSULB.

·    Perform Data visualization techniques to extract useful insights from the CSU‘s Enrollment DataWarehouse.

·    Ensure accurate reports for budgeting of CSULB’s individual departments.

·    Use SSIS reporting services to identify actionable insights in conjunction with Dashboard Reports.

Software Engineering Analyst - Accenture Services Pvt. Ltd – Mumbai                           Nov 2013 – Aug 2016

SiteCore & SharePoint ASP.NET MVC Developer- Digital Infrastructure Services |Digital Marketing | Client: Avanade

•  Member of an Agile ASP.Net Web Development team which created CMS app for Avanade.com hosted on Azure.

•  Developed Sublayouts and Renderings for multiple page templates according to redlines using C#.

•  DevOps for Avanade.com Servers hosted on Microsoft Azure for weekly go-lives.

•  Participated in daily standups with the team to provide SSRS reports.

•  Optimized page response time by automation of image optimization across 100K Web pages.

•  Fixed 10% of UAT bugs identified in UAT while Migration from  Sharepoint to Sitecore Platform.

•  Used my Analytical skills to create Automated scripts for setting up 50k Redirects and Media Library items(5k) using scripts.

Content Developer & Tester - Digital Infrastructure Services |Digital Marketing | Client: Avanade

·   Managed content of Avanade.com CMS website of 30,000+ pages live across the globe in 12 different languages.

·   Developed automation and Scripts that reduced the time required to create the new page by 35%.

·   Led business and technical knowledge transfer sessions with Clients and trainees.

·   Maintained SiteCore Content Tree (5k SiteCore Items) using powershell ISE scripts.

·   Used Javascript bookmarklets to navigate/test multiple language versions for each Sitecore Item.

·   During SharePoint to Sitecore migration phase identified gaps in development and logged 22% of UAT bugs.

Professor - Advanced Computers Training Institute– Mumbai                                             Jul 2013 - Nov 2013

·  Lecturer for Database Technologies (Oracle) and J2EE batch size – 25 students

PROJECTS:

Enrollment Prediction, Tracking & Budget Estimation Dashboard - Data Analyst | IRA CSULB                         Jan 2017 – Mar 2017

Technologies used:- SQL, Excel, Python, Tableau, TabPy

·   Provided ETL solution for creating enrolment & class dataset using SQL and python.

·   Finalized dashboard for estimating budget annual Budget allocation of CSULB.

·   Implemented tabpy api to predict enrolment trends for various classes in CSULB.

Confidential Grade Analysis & Enrollment Tracking Dashboard - Data Analyst | IRA CSULB                             Mar 2017 - Dec 2017

Technologies used:- SQL, Excel, Python, Tableau

·  Proposed and developed idea of creating Student Grade Reporting & Enrolment Dashboard for all campuses of CSULB.

·  Dashboard aided Deans, Department heads and Chancellors of CSU’s to make effective decision making on Grade Analysis.

·  Analysis and reporting of almost 3 million student records became feasible and automated using the dashboard.

 Yelp Data Challenge Analysis - Datbase Administrator | Database Architecture, CSULB                               Sept 2016 - Dec 2016

Technologies used:- SQL, Excel, Java, Tableau

·  Conducted data analysis on huge data set of yelp.com(100k+) and design Database & web app for querying data set.

·  Performed data screening, cleaning and loading in Oracle & MongoDB by removing inconsistencies.

Redesign Avanade DotCOM - Sitecore 8.0 & ASP.NET MVC Developer | Accenture                                       Dec 2015 - Aug 2016

Technologies used:- Azure, C#, .NET MVC 4.5, JQUERY, BOOTSTRAP, TFS, SITECORE, Angular 2, AGILE

·  Developed SiteCore CMS Modules for Avanade.com Redesign.

·   Lead bi-weekly Azure Deployments for the Bug fixing phase of the project.

·  Created automation scripts for data extraction from items.

Redesign Avanade DotCOM Migration– DevOps Engineer | Accenture                                                               Jan 2013 - Dec 2015

Technologies used:- Azure, C#, .NET MVC 4.5, PowerShell, Windows Server Management, TFS, SITECORE, AGILE, Sharepoint

·  Automatic migration scripts for sitecore items from Sharepoint2010 to SiteCore CMS (Approx 1 million items).

·  Perform UAT for the newly migrated web site and raise issues to development team.

·  Responsible for Content Management of Sharepoint 2010 and SiteCore 8 Web solution.

CERTIFICATIONS:

·  Accenture-ATA Certified Application Tester (MIT Designed Certification Course)                                         Jul 2015

·  Accenture Certified professional for Sitecore 8.0, SPS2013, HSFP & ASP.Net 4.0                                                       Jan 2015

·  Microsoft Certified Solution Developer (Web ) – MC ID: 10657750                                                                                Feb 2014

ADDITIONAL RESPONSIBILITIES

·  Lead a team of 4 content developers of  Avanade.com.                                                                                              Aug 2014 – Jun 2015

·  Conducted SITECORE 8.0 CMS Workshop at Accenture(Participants : 50+)                                                                 Aug 2015

HONORS & PUBLICATIONS

·  Published Whitepaper JavaScript Bookmarklets  -  Accenture                                                                                        Aug 2015