AMRITA GUHA
Bosepara, Chandannagar
Hooghly, W.B Pin - 712136-,
Mob:-
Summary
•
•
•
•
Over 3+ Years of experience in IT industry in Power BI, Web Scraping.
Experienced on MS Excel, SQL Server Management Studio and Power BI.
I am detail-oriented, organized, and precise in my work. I have strong communication skills
with a knack for clear and illuminating presentation. I’m comfortable on my own facing the
numbers, but I really enjoy being part of a motivated team of smart people.
Highly self-motivated and able to set effective priorities to achieve immediate & long-term
goals and meet project & operational deadlines
Technical Skills
Technical Tools:
- Reporting tool: Excel
- Programming Technologies: SQL
- Visualization Tools: Power BI, Tableau, Qlik Sense
Experience
Indus Towers, Gurgaon, 10/2019 – Present
Working on Data Visualization, my responsibilities are:
• The main objective is to automate the whole manual excel work with the help of Power
BI. To reduce the time to create daily excel reports manually.
• Developing Visual Reports, Dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Proficient in making DAX queries using power BI desktop.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Able to implement row level security on data and have an understanding of application security
layer models in Power BI.
• Knowledge of SQL queries also worked on SQL Server Management Studio.
• Maintaining, uploading the company’s raw data into the SharePoint, analyzing the dataset to
get the deeper business insights. Creating Excel dashboards, having good hands-on
experience in working with VLOOKUP, HLOOKUP, Pivot Tables.
Freelancer (Health Care Domain) – Data Visualization, USA, 06/2019- Present
Working as a Freelancer on Power BI, my responsibilities are:
• To create different visualization depending on the Client’s need
• To create Calculated Column, Measures using DAX
• To provide different analysis based on the reports created.
• Provided all the reports within the given deadline.
• Created End-to-End reports.
Freelancer (E-Learning) – Subject Matter Expert (Power BI), India, 03/2021 – Present
Working as a Subject Matter Expert on Power BI for one of the E-Learning Platform includes
providing tailor-made assessments & solutions which are customized according to the requirements of
the client to provide the right sets of questions that will help in screening process during recruitment.
Selling Simplified (Contractual Period), Noida, 3/2019 – 9/2019
Working as an Associate Consultant Data Analytics, my responsibilities are:
• Web Scrapping based on the internal tool to scrap the data from the various sites like
Hoovers, LinkedIn etc. and creating dashboards using Power BI.
• Core experience in building customized database (Company & Contacts complete details) for
Marketing Campaign List or User Conference Database using Power BI, SQL and MS Excel.
• Create a dashboard using Power BI based on the various lead generated through
different campaigns.
• Analysis on how the customers are increasing and on what basis more customers are
attracted towards the product.
• Quality Check of the raw file and analysis on the changes that has occurred over a period.
GlobalLogic Pvt. Ltd., Gurugram, 05/2017 – 12/2018
Working as an Analyst, my responsibility was:
• Analyzing of data with the help of internal tool provided by Google and using MySQL.
• We have a large amount of data where different databases are used to join with the
help of SQL and extraction had to be done as per the requirement.
• Sales analysis report of Google Shopping that was a client of GlobalLogic.
• Sales summary report for country wise.
• Analysis on sales based on various factors:
1. Comparison reports on new and old Product pricing.
2. Analysis on New Vs Existing Customers and sales by zip codes.
Education
Supreme Knowledge Foundation Group of Institutions, West Bengal, June
2016 B.Tech electronics and Communication Engineering
76.8%, Bachelor’s Degree
Academic Projects
Time Series Forecasting
A project is done on Time Series Forecasting done in R, to predict the future year sales based
on the past sales using ARIMA.
Costa Rica Household Poverty
We have done this project based on Kaggle Dataset, and used KNN algorithm, Random Forest and XG
Boost to compare the results to find out all the household that need help from the government.
IEEE Project on High Order Filter
Project done on FPGA based Higher Order FIR Filter using XILINX System Generator has
been published by IEEE.
Personal Details:
Date of Birth: 20th June 1994
Father’s Name: Mr. Samir Guha
Gender: Female
Nationality: Indian
I hereby confirm that the information in this document is accurate & true to the best of
my knowledge.
Signature
Amrita Guha