IS/Business Analyst

HARSHIT SHARMA

ac2ljl@r.postjobfree.com • 408-***-**** • www.linkedin.com/in/harshitsharma91 • San Jose, CA - 95134 EDUCATION

Masters of Science, Engineering Management San Jose State University, San Jose, CA, USA GPA – 3.55 May 2017 Bachelor of Technology, Computer Science Vellore Institute of Technology, Chennai, INDIA GPA – 3.80 May 2013 TECHNICAL SKILLS AND ACADEMIC ACHIEVEMENTS

Tools: Advanced Excel, Microsoft Office, Power Point Presentation, MySQL, Minitab, Tableau, FMEA, JIRA, Microsoft VISIO, SAP, Google Sheets, Google Tools & Analytics, Google Sites, Microsoft Power BI, ZOHO CRM. Certification: Six-Sigma Green Belt, DEMO Bachelor Software Languages: SQL, PL/SQL, Python, C, C++, R- Programming Core Competencies: Lean and Six-Sigma Management, Forecasting, Scheduling, Project Co-ordination/Management, Business Processes Improvement, Business Systems Analysis, Trend Analysis, Product/System Design & Development, Agile Trained, Change Management, Data Mining/Analysis & Visualization, Market Research & Analysis, Cost Benefit Analysis, SEO, Failure Analysis, Fault Tree Analysis. WORK EXPERIENCE

IS/Business Analyst Intern, Trimble Inc., USA June 2016 – Present

Ensure data quality & integrity by gathering data from stakeholders of different businesses, validate & verify using Advanced Excel. Document it & then upload it to Oracle's EBS to ensure data is complete and updated.

Clean the data for better analysis of resource allocation & optimization by using formulas and pivots in Excel.

Analyze and visualize data by creating dashboards in Power BI to track progress of different BUs, extract KPIs to derive useful insights to present to the management.

Support project management efforts like track progress of work in different BUs, manage in JIRA the access control of roles & responsibilities for projects, manage JIRA dashboards and logging of tickets, extract reports of user responsibilities from Oracle dB

Create training manuals, videos, presentation, and task flow for better comprehension of business functionalities.

Created Issue statistics and Test statistics Dashboard in JIRA for the CRP1, CRP2, and UAT test cycles.

Performed A/B test for the training sites.

Documented all phases of the project with the information required in the functional areas. IT Consultant, SYNA Limited, India Feb 2014 – April 2015

Conducted a careful research of the company to get a better understanding of company objectives, progress & profits made and diagnose process defects.

Analyzed different business reports and created dashboard using Power BI to understand the key profit areas.

Coordinated with the onsite team to propose optimal process improvement strategies to ensure success.

Created new business process flow diagram using MS Visio. Software Engineer, Wipro Limited, India Sep 2013 – Jan 2014

Created and monitored test logs, recreated and retested the defects to resolve issues.

Generated test cases based on the thorough evaluation of client requirements.

Participated in Route Cause Analysis when repetitive failure of company’s products occurred. Intern, Business Analyst, Philips Electronics Pvt. Ltd., India May 2012 – Jul 2012

Involved in the “Report Automation Project”. Part of the team responsible for automation and standardizing all finance and sales reports.

Interacted with clients to gather required information to create major financial reports for company sectors on a fortnightly basis. Intern, Business Operations, Headstrong Solutions, India Jun 2011 – Aug 2011

Tracked and managed asset and location data throughout the asset lifecycle.

Learned to develop an effective Software Requirement Specification (SRS) documentation for products.

Contributed to the Project Life Cycle development for a software used for creating accounts and honed my Project Development skills. ACADEMIC PROJECTS

Reduction in the total shopping time and process improvement at Best Buy using Lean & 6-Sigma

Studied the current shop layout, arrangement of goods & process flow using the DMAIC & SIPOC technique. Designed a future state layout after doing an RCA, FMEA, 5S and VSM. Modified the process to reduce the time to find goods, wait time, & billing time thus improving the overall shopping time by 7.47%

Marketing Strategy Plan, SJSU

First-hand experience at market strategy formation, positioning, segmentation, and promotion keeping in mind the marketing mix and market research and monitored financial performances to make changes to the growth strategy Data Analysis using R and Tableau, SJSU

Did exploratory data analysis, built linear regression, regression tree model to study temperature effect on soil composition of rocks. Data Analysis and visualization using R and Power BI, SJSU

Conducted exploratory data analysis in R for the dataset ‘Student Grade Performance’, analyzed & visualized KPI’s such as parent’s education, students’ grades etc. in Power BI

Designing an Anti-Theft Bike Locking System

Used principles of system engineering & tools such as VOC, QFD, AHP and Context Diagram to understand and analyze customer needs, map out a conceptual and final design for a Anti-Theft Bike locking system providing a solution to a very prominent problem.

Contact this candidate