Data Analyst

SAICHARAN REDDY KANCHARLA

** ***** ****** *** ********* NJ-08901 +1-703-***-**** *********.********@*****.*** https://www.linkedin.com/in/saicharan-reddy-kancharla/ EDUCATION:

Rutgers, The State University of New Jersey, U.S.A Master of Science: December 2020

Information Technology and Analytics, GPA – 3.67/4.0 Jawaharlal Nehru Technology University, India

Bachelor of Technology: May 2017

Electronics& Communication Engineering, GPA – 3.6/4.0 RELEVANT COURSEWORK:

Business Analytics programming, Analytics in Business Intelligence, Business Forecasting, Data analysis and decision making, Data analysis and visualization, Business Data management, Algorithms and Data Structures, Introduction to project management. SKILLSET:

• Programming: MySQL, Python, R, Java, C, Verilog HDL

• Visualization Tools: Power BI, Tableau, Matplotlib, Seaborn, ggplot2, R-Shiny

• Data Processing: Pandas, Numpy, SQL

• Databases: MySQL, MongoDB

• Analytical Tools: Jupyter Notebook, Spyder, RStudio, Microsoft Excel Advanced, Matlab, Xilinx Vivado

• ERP Modules: SAP MM, SAP VIM

• Software Development Life Cycles: Agile (Scrum), Waterfall WORK EXPERIENCE:

SAP BI Consultant, IBM India Pvt. Limited: (Jun2017-Jun2019)

Expertise in requirement gathering, data modeling and analyzing information by understanding the as-is business process using process documentation and client engagement meetings.

Functionally I developed solution for different business areas like Material Management, Sales, Inventory etc.

I proposed multiple solution improvements in SAP BI space, which were accepted and appreciated by customer.

Created visually impactful dashboards in Advanced Excel and Tableau for data reporting to reduce defect rate.

Designed complex SQL queries for service requests to fetch information from SAP sales tables using report programming

As part of improvement in BI space, we have proposed long term systematic growth solution, which help business to save cost and improve performance.

Designed more than 8Functional Specification Documents (FSDs), Prepared test scripts in HP ALM (Application Life Cycle Management), Performed FUT (Functional Unit Testing) based on base configuration ensuring clarity of requirements for intended audience.

Configured master data including material master, vendor master, source list, info records, and pricing, configured purchasing documents like purchase requisitions, purchase orders, RFQ Quotation, and quota arrangements. ARRK Technologies LLC – Lewes, DE (May2020-Aug2020) Role: Data Analyst – Intern

Used SQL to extract transform and load the data from legacy data warehouse. Configured Integrated queries and logics to filter the data based on the behavior of the target system.

Assisted the Power BI team in generating report through media advertising, channels and customer segment performances.

Used Excel and SQL’s best practices to combine financial and operational data and then used Power BI to visualize and generate dashboard with all this data.

Documented all the enhanced processes that were implemented in the org’s migration to visual tools for enhanced data visualization.

Implemented real-time billing, delivery reports which streamlined operational processes. ACADEMIC PROJECTS (Rutgers University):

Impact on Economy and Businesses employees due to COVID19 in USA, Rutgers University (Feb2020-Apr2020) Expertise: Python, Tableau, Power BI

Data Cleaning, Data Analysis and Data Visualization.

Collected the data from relevant Data source scraped and cleaned the data, performed data transformation to load the data into Tableau workbook as required.

Visualized data into three Dashboards for the better visualization as decrease in Number of business open, decrease in number of working employees, decrease in number of working hours.

Identified the states in US where the businesses had a direct correlation with the number of COVID cases, analyzed the industries where the businesses and employees were least and most impacted.

Found a steep decrease in the working hours of employees from 40 hours per week to 10 hours per week on average by state. Crime Data Analysis, Rutgers University (Oct2019-Dec2019) Expertise: Qlik Sense, R Studio, Python

Performed DAR (Dashboard, Analysis and Report) on data from Chicago crime portal to provide insights and solutions to crime rates in Chicago.

Generated a dynamic dashboard showing top crime trends based on hours, location etc. per user requirements.

Performed analysis on reports and determined most frequently occurring crimes, locations with higher crimes, etc. IMDb Data Analysis, Rutgers University (Jan2020-Apr2020) Expertise: Python, SQL, NoSQL

Collect and clean data, design model for structured and unstructured data and use MySQL and MongoDB respectively.

Use PyMongo to set up a connection with MongoDB and perform analysis using optimized NoSQL queries.

Use Matplotlib and Seaborn python packages to do data visualization.

Compare NoSQL results with standard SQL queries and identify performance bottleneck reasons in SQL.

Contact this candidate