Data Analyst

Mobile: +1-929-***-****; Email: *************@*****.***; LinkedIn: www.linkedin.com/in/rishigupta92

Work Experience

iTrending Solutions LLC, Tampa, FL – US Sept 2019 - Present

Data Analyst/SSIS Developer

Client: Starr Companies, New York, NY Apr 2020 – Present

●Lead Project from Concept to Design to Building and Shipping

●Analyzing data to provide recommendation to help increase data quality.

●Designing and Testing SQL Based stored procedures to perform validations based on incoming data

●Creating SQL based Tables and Views for SSRS, Tableau and Power BI reports

●Build interactive dashboards to communicate project status to stake holders

●Collaborates with Salesforce CRM developers to maintain, create, and update user roles, security, profiles, workflow rules

Client: HCA IT&S, Nashville, TN Sep 2019 – Mar 2020

●Team Lead and conducting daily Scrum calls with the offshore team

●Defined metrics for the overseas team to easily analyze the files generated with the business requirements

●Replicated the Legacy Repository process into SQL based Stored Procedures

●Actively interacting with users, team lead, DBA’s and technical manager to fully understand the business requirements.

●Designed, built and launched SSIS packages performing ETL (Extract, Transform and Load) operations

Pencil Tech, San Francisco, CA – US

Data Analyst Consultant Oct 2019 – Mar 2020

●Building a detailed analysis on competitor growth and their financials, understanding the international market

●Carry out detailed Market research on competitors, demography, geography using tableau, google analytics

●Engaged in designing a Marketing strategy with focus to have a unique selling point helping both teachers and students

●Understanding the competitive landscape and relative position in the market, to inform the product growth strategy and design

Emeec Invest Inc (Now BITS), New York, NY – US

Product Marketing Intern Aug 2018 – Oct 2018

●Defined KPIs based on business requirements and presented to Stakeholders

●Designed & Developed Email Marketing and Social Media Campaign

●Analyzed data using SPSS & Tableau to provide customers insights to make meaningful investments

●Developed a Market Mix Model to allocate the marketing budget effectively, increasing marketing qualified leads by 15%.

Jersey Services, Doha-Qatar

Data Engineer Apr 2017 – Aug 2017

●Analyzed alternative techniques for energy consumption reduction and efficiency improvement

●Developed an SQL database on CAFM Explorer with respect to machinery in the factory

●Conducted Energy Audit/Power Quality Analysis in AlBateel Interior, reducing the energy cost by 30%

●Responsible to conduct Power Quality Analysis for all clients under the Annual maintenance contracts for chillers

●Providing detailed root cause analysis and modifications that can be done to reduce cost and improve efficiency

Switchgear International, Doha-Qatar

System Engineer Jan 2016 – Apr 2017

●Project Estimation, preparing offers, meeting and Negotiating with clients and suppliers

●Developed a database system using Microsoft SQL, sorting the projects according to their status and timeline

●Involved in the website SEO with respect to location, visualization and marketing

●Responsible for conducting internal ISO audit of the company and listed company into Govt. Projects vendor list

●Increased turnover by $3 million by bringing in high profile clients and projects

●Initiated company’s new Annual maintenance division bringing in 500,000 US$ /year

Skills

Languages – Python, SQL, R, HTML, SSDT, CSS, JS, C, C++

Database – Salesforce CRM, SSMS, Repository, Pervasive, Azure, Git

Reporting – Excel, SSRS, Google Analytics, Tableau, Amplitude, Looker, SPSS, JMP, Alteryx, PowerBI

Education

New York University, New York, U.S.A. 2017 – 2019

M.Sc. Data Analytics and Integrated Marketing.

Course Projects/Collaborations:

●Determine if E-commerce should focus on brick and mortar using SPSS

●Building a profitable marketing strategy for brands like Lululemon, Blue Apron and, United Airlines

●Built a Data Visualization Model for Olive Garden based on 5yr - YoY Branch Revenue using JMP

University of Nottingham, Nottingham, U.K. 2014 – 2015

M.Sc. Electrical Engineering in Sustainable and Renewable Energy

Course Project/Collaboration:

●Design and programming of a functioning Solar panel using PVSyst and AutoCAD

BITS – Pilani, Dubai, U.A.E. 2009 – 2013

B.E. (Hons) in Electrical and Electronics Engineering

Contact this candidate