ISHAN NEEMA

Data Enthusiast | Analytics | Business Intelligence

Intuit infotech ltd 1.2 Yrs , Wide Vision Technology 0.6 Yrs

University of Houston Clear Lake Masters Management Information Systems, Rajiv Gandhi Proudyogiki Vishwavidyalaya Bachelors Information Technology

Data Analyst 01.05 Yrs, Business Intelligence Analyst 01.05 Yrs, Business Analyst 01.05 Yrs

SQL,  Python,  ETL,  Tableau,  Power BI


About ISHAN NEEMA

I thrive on Data. I love to tweak it, toy with it, visualize it, and then extract a cohesive story from it. A firm believer of the maxim, “when in doubt, crunch data!”

I have always been a keen learner and driven by results. Driven by my affinity for Data Analytics and Data Visualization, I got an MS degree in MIS from University of Houston Clear Lake.

I have been working as a Data Analyst for the last one and a half years and I have loved every day of my job. My areas of interest include data analysis (obviously!), business intelligence, business analysis. As a data analyst I strive to act as a conduit between the organization and end-customers. I am also constantly looking for opportunities that can utilize my skill-set, and organizations that believe (like me) in the mantra: the more complicated the data, the simpler it can make our lives.

Skill Set:
• Programming Language: SQL, PL/SQL, Python, Java.
• Business Intelligence Tools: Tableau, Power BI, ETL SSIS, Informatica, MicroStrategy
• Database: SQL, MS SQL Server, MySQL, Oracle 11g
• Design and Simulation Software: NetBeans, Eclipse, Visual Studio, Rational Rose, Toad Data Modeler
• Other Tools: MS Excel (Pivot Tables, Vlookup),JIRA, GIT
• Software Development Methodologies: Waterfall, Agile, Scrum, Extreme Programming

Total Work Experience: 01.08 Yrs

Domain Experience : Information Technology

Work Sponsorhip/Visa Required? : Yes, Currently on OPT first year.

PRIMARY AREAS OF EXPERTISE

  • SQL
  • Python
  • ETL
  • Tableau
  • Power BI

ADDITIONAL SKILLS

  • technical communication skills
  • Organization Management
  • Communication
  • node js
  • Javascript
  • Adobe
  • Google
  • Slack
  • Micosoft 365
  • MySQL
  • Oracle
  • Tableau,PowerBi

Experience

  • Data Analyst 01.05 Yrs
  • Business Intelligence Analyst 01.05 Yrs
  • Business Analyst 01.05 Yrs

WORK HISTORY

Company Name: Intuit infotech ltd

Job Title: Data Analyst

Experience: 2017 Jun - 2018 Jul (1yr 2mos )

• Enhanced business processes and workflow efficiencies by 25% using automated data ingest, gathering and extraction processes across diverse systems.

• Designed 20+ insightful reports and dashboards using Tableau providing visibility to senior management in strategic decision making in 5 functional areas across Engineering, Product, Marketing, Sales and Operations.

Improved ETL data accuracy by 30% using data quality improvement techniques such as anomaly detection, data schema monitoring and ad-hoc analysis with ETL Informatica tool.

• Leveraged ETL tools (SSIS) and Python Pandas to pre-process raw data by employing 4 data cleansing approaches: redundant values validation, missing data treatment, inconsistent information assessment and outliers premovement.

• Developed workflows to extract, manipulate, and ingest a wide variety of data feeds using SQL.


Company Name: Wide Vision Technology

Job Title: Data Analyst

Experience: 2016 Jul - 2016 Dec (0yr 6mos )

• Impacted annual revenue growth by 9% developing recommendations and using data wrangling, queries, validations, and ad-hoc analysis that aided broader enterprise-wide strategic decision-making processes.

• Created 30+ Tableau reports to outline market conditions, trends patterns and long-term predictions.


Academic Projects

Title : Cyber Security - Threat and Malware Detection
Technology Used : Python, SQL

• Classify malware using NumPy/Pandas libraries in a complex dataset having 120,000 features and 10,000 data samples

• Develop techniques to correctly identify varying cyber-attacks and threats by analyzing windows API calls data.

• Accelerate analysis on multi-dimensional data through standardization, resampling and applied sparse matrix methods.

• Developed Machine Learning Models to perform multi-class classification of malwares, achieving a Recall score of 92.


Title : Growth of Online Learning
Technology Used : Tableau

• Built 5 interactive dashboards in Tableau investigating Online Learning trends

• Implemented data quality checks, cross data joins, action filters and Level of Detail expressions to improve UI/UX of interactive dashboards by 20%

Investigated the dependence of mobile phone usage and spend increase on education. Found the correlation of 0.65%.


Title : US Accidents
Technology Used : Python, SQL

• Collected, cleaned, and transformed datasets into useful actionable insights by using Python Jupyter Notebook, pandas.

• Created Star Schema, including Dimensions and Fact Tables of data exported from Excel to MS Access

• Created intelligence dashboards from OLAP databases with Data Cube Schema through SSMs, Visual Studio and pivots charts.


Education


, Management Information Systems



, Information Technology