KANIKA VERMA

Santa Clara, Cell: 408-***-****

California. acw0ai@r.postjobfree.com

SUMMARY:

•3 years of professional expertise in Data Analysis, Business Analysis and BI Reporting.

•Experience with gathering and translating Business Requirement into business artifacts.

•Hands-on experience with SQL ( DDL, DML, Joins, Views, System functions, Stored procedures, Triggers)

•Advance skills in MS Excel (Pivot-table, Functions, VLookup, Macros, VBA, Data Mining & Statistics)

•Proficient in BI tools (ETL, Reporting & Analysis) like SSIS, SSRS, SSAS, Tableau.

•Proficient in Data Mapping, Data Integration and Data Validation process.

•Experience with dashboard, storytelling and visualize data in form of various charts, plots & maps using Tableau

•Hands-on experience with Data Analysis (Statistical) using R programming.

•Experience with Predictive Analytics/Data Mining with Decision Trees, Clustering - SSAS, Excel

•Familiar with Big Data & Hadoop concepts ( Hive, Hbase, sqoop)

•Experience with CRM applications, ERP and SAP business modules. – FI-CO, MM, PP, SD, HR

•Experience with Programming & Scripting - PHP, Python, Mysqli, HTML, CSS, JavaScript

EXPERIENCE:

1.HCL: Data Analyst May '09 - Jan '12

Scope of this project was to streamline the business growth for HCL laptops by analyzing the customer's behavior from his purchase history and market analysis. This also involved the analysis of web visitor behavior via Google analytics. This project gives the information on customer's buying patterns and trend over a period of time.

•Responsible for the analysis of business requirements and design implementation of the business solution.

•Executed SQL queries to extract data from database and analyze it for Reporting.

•Assisted DBA with performance tuning and taking server backup using SQL scripts.

•Created Marketing reports (data and graphs) using MS Excel for Sale’s department.

•Created Reports like Matrix report, Tabular report, Chart Report by using tools like SSRS

•Performed data analysis using ‘R’ programming for analyzing the financial statements.

•Performed Data mining and Data analysis to answer business questions.

•Performed Web Analysis and was responsible for monitoring the KPI to analyze and enhance sales.

EDUCATION QUALIFICATION:

•Northwestern Polytechnic University, CA, USA. Aug 2016

M.B.A in IT and Business Analyst (GPA: 3.9)

•Symbiosis University, Pune, India May 2011

M.B.A in Finance (GPA: 3.65)

•RDVV University, M.P, India Apr 2009

Bachelors of Commerce (GPA: 3.7)

PROJECTS:

Data Warehouse Implementation for Sales & Inventory (SQL, ETL) Jan'16 - Aug '16

•Data modeling for building Data Warehouse using ERwin tool.

•Designing from conceptual model, logical data model to physical model for star schema.

•Created Data Mapping document for Data Migration from one Database to another base.

•Used ETL techniques to transfer data using SSIS, where I applied merge transformation.

Data Mining & Forecast of Product Sale (Decision Tree -SSAS) Oct'15 - Dec'15

•Used the historical data and customer's profile to conclude future sales.

•Analysis using Decision tree algorithm on past data.

Data Analysis on Share Market (Histogram) Aug '15- Oct'15

•Analyzed the stock return using the histogram for different companies.

•Compared and analyzed the histogram for better investment from large set of data.

Forecast & Prediction of Company's Revenue (MS Excel) May'15 - July'15

•Based on the previous revenue and incremental growth, we used exponential formula.

•Revenue prediction based on last 4 years data for upcoming quarter.

Data Visualization for UK Bank (Tableau) Feb'15 - Apr'15

•Implemented project for visualizing “UK Bank” data using Tableau.

•Analyze variety of datasets, blend, join, and calculate data.

•Created Dashboard and storytelling - visualize data in the form of various Charts, Plots, and Maps.

Student Information System ( PHP, Mysqli, JavaScript, HTML) Oct'14 - Jan'15

•Implemented a student portal for student to login and check schedule, courses enrolled, marks, GPA.

•3- tier architecture where front end was WebPages designed using HTML, CSS, JavaScript.

•Middle layer which was implemented using PHP code which used to process the inputs & query database.

•Third layer was database, where we had all tables required for storing all data & running apache server

Thanksgiving campaign (Zoho CRM) Jul'14 - Sep'14

•The project included adding, editing, and tracking leads, converting leads, email integration, document integration, managing activities and events.

Data Migration to Hadoop Environment (Hive) Apr'14 - Jun'14

•Implemented a project to move data (tables) from traditional database ( mysql) to Hadoop (hive)

•Monitored the error logs via Hue and confirmed data was moved successfully.

TECHNICAL SKILLS:

Programming: SQL, HTML, CSS, Mysqli, PHP, Python

Databases: Oracle, SQL Server, MySQL.

BI Applications: Tableau, SSRS, SSIS

CRM Applications: Zoho CRM, Salesboom CRM,

ERP Modules: FI-CO, MM, PP, SD, HR

Operating System: Linux, UNIX, Windows.

Servers: Apache server

Software: MS SQL Server, Oracle SQL Developer, mysap, WAMP, Putty, Winscp, VNC viewer, JIRA

Miscellaneous: MS Excel, MS Word, MS Visio

LinkedIn Profile: www.linkedin.com/in/kanika-v

Contact this candidate