Resume

Sign in

Data Analyst

Location:
Des Moines, Iowa, United States
Salary:
50000
Posted:
April 12, 2018

Contact this candidate

Resume:

VIGNESH KASI VISWANATHAN

**** ******* ****, ***** ** 50325 +1 (813) - 607 – 0489 ac44hg@r.postjobfree.com

SUMMARY:

Business/Data Analyst with 2+ years of experience in gathering Raw Data and creating database using Excel and SQL.

Strong attention to detail generating documentations and reports.

Knowledge of MS Excel Macros with VBA.

Proficient in using Excel and tableau in developing visualization dashboards.

Adept in SQL queries in creating and updating databases.

Highly proficient using SQL queries for Data Mapping and Data Analysis.

Knowledge of SSIS, SSAS and SSRS in SQL for integration, analytics and validation.

Highly Efficient in Ad-hoc report generation for data analysis and data validation.

Excellent in handling VLOOKUP, PIVOT Table, X-Y Bar chart, Pareto Chart, Fishbone Chart

EDUCATION:

MASTER OF SCIENCE UNIVERSITY OF SOUTH FLORIDA, TAMPA, FL Aug 2015 – Dec 2016

Major: Engineering Management/Industrial Engineering GPA: 3.6/4 Graduate Certificate: Technology Management

BACHELOR OF TECHNOLOGY SRM UNIVERSITY, INDIA Aug 2011 – May 2015

Major: Mechanical Engineering GPA: 3.83/4

SKILLS:

Languages: Python, JavaScript

Database: MySQL, MS SQL Server, Oracle, MS Excel

Tools: Tableau, Minitab, AutoCAD, MS Visio, MS Project

EXPERIENCE

Business/Data Analyst, Consultant: Feb 2017 - Dec 2017

●Responsible for gathering requirements from users, mainly from SME's.

●Daily involvement with the Waterfall Methodology software development life cycle, documenting and working through systems issues as part of a business analysis team.

●Performed GAP analysis to compare the existing system with the proposed system and documented new requirements and features.

●Used MS-Visio to document current workflows, manual processes and end-to-end processing of system interactions.

●Designed and Implemented data integration modules for Extract/Transform/Load (ETL) functions.

●Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.

●Involved in data warehouse design.

●Experience with various data warehousing tools and concepts.

●Retrieved Data using SQL queries and did Data Mapping and Data analysis.

●Worked to create Data Mapping Documents and ad-hoc reports to conduct data analysis and validation.

●Played a key role in the planning, testing, and implementation of system enhancements and conversions.

●Performed Data Analysis and data manipulation of source data from Oracle Server and other data structures to support the business organization.

●Reviewed the UAT Results to identify defects and enhancement request from the Users.

PROJECTS:

H1B Visa Analysis: May 2016 – Dec 2016

●Implementation and Development of a visualization dashboard in Tableau to analyze the H1B dataset.

●Importing the dataset into Tableau by using SQL queries and available Database connectors in Tableau.

●Implementation of various JOINS in the SQL queries for Initial Data munging and massaging prior to cleaning the data in Tableau.

●Implementation of Prediction algorithm for approval of H1B Visas based on various input factors such as Salary, State, Job Title, Experience, and Highest Qualification.

●Use of various visualizations such as Bar Charts, Histograms, Pie charts and Maps to display the results of the H1B Visa Analysis.

Student Database Management System: Jan 2016 – May 2016

●Implementation of a system for a better management of student records.

●Objective is to allow administrators to easily create, find and append student records for various administrative tasks.

●Use of SQL as a backend development platform to create databases for the details gathered.

●Using the gathered student data to create a database and table of the details using MySQL.

●The Database Design and Development includes use of SQL functions CREATE and INSERT to build the student database.

●Testing of the Front End and Back End connectivity by running SQL Queries for loading data into and retrieval of data from the database.

FRS HVAC LEAN Six Sigma: Jun 2015 – Dec 2015

●Understand the end to end client requirement and focusing on deliver the same to Operation Team i.e., Development Team.

●Worked with various department to understand their requirement for Process Improvement.

●Worked with Business Operation, PAYROLL, to understand the flow of Business and task to reach the margin target for every quarter period.

●Using VLOOKUP, PIVOT Table, X-Y Bar chart, Pareto Chart, Fishbone Chart to analyse the wastes in the process and cutting down Non- Value added activities to improve the efficiency of the system.

●Excellent in Planning and Cost cutting Management.

●Key of knowledge to access the Quality at Six Sigma Level.



Contact this candidate