Data Analyst

Likhit Jain

Data Analyst

Location: NJ

E-mail: *********@*****.***

Telephone: 908-***-****

SUMMARY

3+ years of experience in Data Analyst and statistical modelling including data extraction, manipulation, visualization and validation techniques, reporting on various projects. Professional experience of working on different SDLC methodologies such as Agile (Scrum), Waterfall & Rational Unified Process.

Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.

Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau.

Experience in creating visualizations using Python. Experience in creating dashboards and reports using SSRS.

Designed, developed and implemented Power BI Dashboards, Scorecards & KPI Reports.

Worked with packages like ggplot2 and shiny in R to understand data and developing applications.

Experience in a Python-based environment, along with data analytics, data wrangling and Excel data extracts. Familiar with NumPy, Pandas and Matplotlib.

Knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.

Experience in implementation of Data Cleanup Procedures, Transformation, Scripts, Stored Procedures and execution of Test plans for loading the data successfully into Targets.

Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.

Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.

Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.

EDUCATION

Master’s in Information Systems

New Jersey Institute of Technology, NJ

SKILLS

Python, R, Tableau, Power BI, SDLC, Agile, Waterfall, Scrum, RUP, SQL, PL/SQL, SQL Server, Teradata, Data Modeling, Data Mining, SSRS, SSAS, SSIS OLAP, OLTP, TOAD, NumPy, Pandas, Matplotlib

WORK EXPERIENCE

Piper Jaffray, NY Jan 2019 – Current

Data Analyst

Prepared Test plan, test case according to the Source to target mapping document.

Involved in logical and physical designs and transforming logical models into physical implementations.

Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements.

Assisted Supply chain analysts with automating reporting functionality using Power BI tools Power BI reporting, Dashboards & Scorecards (KPI).

Worked on creating DDL, DML scripts for the data models.

Created interactive dashboards and visualizations of claims reports, competitor analysis and improved statistical data using Tableau.

Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to Testing and Implementation, Reporting etc.

Designed and built Data marts by using Star Schema.

Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Toad, MS Access, Excel and SQL.

Performed data mining on Claims data using complex SQL queries and discovered claims pattern.

Vivma, India May 2015 – June 2017

Data Analyst

Understand the data visualization requirements from the Business Users.

Analyze Sales data mart model to identify the tables and their relations in order to extract required data.

Writing SQL queries to extract data from the Sales data marts as per the requirements.

Create Source to Target Data mappings for the individual reports.

Create Pivot tables in Excel to analyze data across several dimensions.

Creating mock-ups of Dashboards and individual data visualizations in MS Excel.

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and another Chart.

Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.

Maintained data integrity during extraction, transformation and loading of data into data warehouse and engaged in requirements and gap workshops with clients for identifying the data sources and data needed for analysis.

Developing tidy dataset, Data visualization in R using various packages.

Building Dashboard/Stories over data using Tableau and Excel.

Contact this candidate