Nothing Special   »   [go: up one dir, main page]

Mohit (Senior Software-Analytics)

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

MOHIT

 mj28392@gmail.com

 +919780930850

 https://www.linkedin.com/in/mohit-jain-7476bb106

 Professional Summary
Diligent IT professional with more than 3 years of experience in the field of Analytics and Business
Intelligence.Hands-on expertise in Data Visualization, Data Analysis, Python and Analytical Tools.

 Experience
Trianz Holdings PVT. LTD.
Feb 2018 - Present
Senior Software Engineer-Analytics
Worked as a Analyst in improving products and services for our clients by using
Business Intelligence and Advanced Analytics.

Worked with different visualization tools simultaneously, developing variety of


charts that meets the need of end user and client requirement.

Designed a fully interactive dashboards and story to demonstrate every insight on


industry-specific reports.

Performed impact analysis with each iteration of data using advance Excel.
Strong understanding in implementing row level security on data and have an
understanding of application security layer models.
Worked on data warehouse methodologies and data modeling as per client's
requirement.

Collaborated in cleansing, processing and analyzing structured and unstructured


data.

 Skills
BI Reporting Tools- Tableau, Qliksense/Qlikview, Power BI

Programming Languages- Python, C/C++, HTML5, CSS, SQL

Databases- MySQL, Microsoft SQL Server

Competencies- Data and Statisticcal Analysis, Data Visualization, Business Intelligence and
Business Analysis.

Cloud Environments- Amazon EC2, RDS

Operating System- Linux, Windows

Libraries/Packages- NumPy, Pandas, Scipy, Sklearn, Matplotlib


 Projects
Trasers
Trasers is a platform that provides actionable and fact based insights and help business and IT
leaders in developing and evolving their transformation strategy.
Contributions-
Managed end-to-end development from data handling, data transformation and visualization.

Customized the chart extensions as per the insight requirement.

Executed SQL queries and stored procedure for data management.

Involved in designing data models, extraction and transforming the data (ETL) from
heterogeneous data sources like Excel, SQL Server in creating charts and dashboards.

Worked on DAX queries in Power BI to meet the business requirements.

Extensively worked with QlikSense functions, Objects, Set Analysis, Variables to generate
different kinds of charts. Also generated QVD files by writing scripts in QlikSense application.

Leveraged SQL Queries for maximum efficiency and performance.

Technologies Used - Power BI, Tableau, Qliksense, Excel, SQL, Python


Role - Data Analyst

Mastercard
Mastercard consists of a portfolio which deals with association of various NGOs to track and
visualize their data.
Contributions-
Involved in full project life cycle implementation of data handling, data transformation and
visualization.

Built and published interactive dashboards as per the requirement.

Executed SQL queries and custom SQL to fetch data from SQL server.

Worked extensively on calculations, Parameters, Background images, Maps and table


calculations.

Worked on building in Groups, hierarchies, Sets to create detail level summary reports and
Dashboard using KPI's.

Technologies Used - Power BI, Tableau, Excel, SQL, Python


Role - BI Developer

Website Traffic Analysis


Analyzed the traffic from various countries at various point of time on Trasers and Trianz websites
in analyzing the user behaviour metrics such as conversion rate, time spent on site and page views
per session.
Contributions-
Developed Power BI dashboard/reports on the website traffic analysis.

Technologies Used - Power BI, Clicky, Excel


Role- BI developer
POC- Ranking resumes based on search key
POC was designed to assist the Talent Acquisition team in the complete process of relevant
resume search and storage of the resume in a well structure manner.
Contribution-
Extracted relevant information from the resume using data mining techniques.

Developed model for resume search and ranking based on multigram search key using
document distance.

Technologies Used - Numpy, Pandas, Python, NLTK, Gensim, Spacy.


Role - Developer

 Education
CGC college of Engineering
2017
B.Tech-Computer Science and Engineering
73%

 Achievements & Awards


Received appreciation based on the work done in Trasers from senior managers and management.

Conducted training and seminars for various Colleges and Institutes on Big Data.

Recognized for playing a vital role in delivering the complex deliverable/tasks in stringent timelines.

 Language
English

Hindi

 Personal Details
Date of Birth : 15/06/1995
Marital Status : Single
Nationality : Indian

You might also like