Data Analyst Research Assistant Resume
TECHNICAL SKILLS:
Programming Languages: C#, Java,Python
Database: No - SQL (MongoDB), SQL, PostGRESQL, PIG, HIVE
Scripting Languages: JS, Angular,BOOTSTRAP JQUERY, NODE JS
Web Dev: ASP.NET MVC 4.5,CSS, HTML5, WebAPIREST API,ASP.NET CORE, JSON, SPARK
Cloud Platforms: MS Azure, AWS
SDLC Model: Agile - SCRUM, RAD
Content Management: Sitecore 8.1/8.0, MS Sharepoint 2013, O-365
Analysis/Scripting: Tableau, Google Analytics, PowerShell ISE, Excel
Platforms: Windows, Linux
Team Collaboration: TFS, SVN, GIT, JIRA
WORK EXPERIENCE:
Data Analyst Research Assistant
Confidential
Responsibilities:
- Data Analyst responsible for develop dashboard reports using Tableau for Deans of various colleges of Confidential .
- Accomplished Data visualization techniques to extract useful insights from the CSU‘s Enrollment DataWarehouse.
- Ensure accurate reports for budgeting of Confidential ’s individual departments.
- Use SSIS reporting services to identify actionable insights in conjunction with Dashboard Reports.
Software Engineering Analyst
Confidential
Responsibilities:
- Member of an Agile ASP.Net Web Development team which created CMS app for Confidential .com hosted on Azure.
- Developed Sublayouts and Renderings for multiple page templates according to redlines using C#.
- DevOps for Confidential .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
Confidential
Responsibilities:
- Managed content of Confidential 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.
Confidential
Data Analyst
Technologies used: SQL, Excel, Python, Tableau, TabPy, C#, ASP.NET MVC
Responsibilities:
- Provided ETL solution for creating enrolment & class dataset using SQL and python.
- Finalized dashboard for estimating budget annual Budget allocation of Confidential .
- Implemented tabpy api to predict enrolment trends for various classes in Confidential .
Confidential
Data Analyst
Technologies used: SQL, Excel, Python, Tableau, C#, ASP.NET MVC
Responsibilities:
- Proposed and developed idea of creating Student Grade Reporting & Enrolment Dashboard for all campuses of Confidential .
- 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.
Datbase Administrator
Confidential
Technologies used: SQL, Excel, Java, Tableau, AWS, JSON
Responsibilities:
- Accomplished 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.
Sitecore 8.0 & ASP.NET MVC Developer
Confidential
Technologies used: Azure, C#, .NET MVC 4.5, JQUERY, BOOTSTRAP, TFS, SITECORE, Angular 2, AGILE
Responsibilities:
- Developed SiteCore CMS Modules for Confidential .com Redesign.
- Lead bi-weekly Azure Deployments for the Bug fixing phase of the project.
- Created automation scripts for data extraction from items.
- Accomplished low wep page response rate by developing script to reduce image resolution on 100k pages.
