Sign in

Data Analysis

Chicago, Illinois, United States
March 07, 2018

Contact this candidate


LinkedIn: Phone: (217) ***-****

Email: 765 West Adams St Chicago IL 60661 Summary:

Hands on experience on various Microsoft SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

• Experience in Designing and Building the Dimensions and measures for multidimensional cubes (OLAP) using SQL Server Analysis Services (SSAS).

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

• Worked on creating client and custom reports and dashboards (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub, Charts, Filters, Drill-down, Drill-through, graphical reports etc.) using SSRS and Tableau.

• Experienced in designing and implementing advanced and interactive Business Intelligence Reporting Solutions with Microsoft SQL Server Reporting Services (SSRS).

Specialized in assessing business requirements and provide business acumen. Skills:

Programming: C, C++, R, VB, HTML, Java, NoSQL, MySQL, JavaScript, JQuery, JSON, ASP.NET Big Data, Python Operating System: LINUX, Windows 7, 8.1, 10.1, Mac-OS Other Software: Microsoft Office Suite, Weka, R studios, Pg4admin, Jupyter Database & IDE: Oracle SQL, DBMS, PostgreSQL, Visual Studio, Microsoft Windows Azure Database Tech: SQL server Integration services (SSIS), SQL server Analysis services(SSAS), Data Warehousing, ETL, Master Data Services, Data Quality Services, windows Azure Database

Analytical Skills: Project Management, Forecasting, Gap Analysis, Documentation, Quantitative, Reporting, Research,Risk Assessment,Statistical Analysis, Process Mapping, Process Modeling, Market Analysis. Data analytical tools: Tableau(Dashboards, Stories, Parameters, Actions, Quick Filters, Blending, etc), SAS Enterprise Miner, SQL Server Reporting Services(SSRS), Power BI, Qlikview

Project Skills: SDLC,Agile,Scrum,Waterfall, Usecases, Requirement Elicitation Techniques,Development Lifecycle (SDLC), User Stories,Product Backlog, BRD, SRS, Unit Testing, UAT, Business Case. Work Experience:

Data Analyst - OutsiteVR (Dec 2015-Aug 2016)

Interpreted and analyzed data using statistical techniques, and provided reporting for VR product development.

Acquired data from various data sources and maintained databases/data systems.

Collected, cleaned, analyzed, and visualized data with approximately 100,000 client records using Advanced Excel and Tableau. I Produced internal performance reporting and customer reporting. Developed ETL strategies to populate the data from various source systems feeds using SSIS.

Performed reporting solutions that accelerated architectural project resource time by 45%. Acquired new data sets from internal and external sources, and establish processes to transform/store data in internal databases.

Monitored and built packages for Dynamic ETL flow to validate, extract data, transform and load data into database, deployed SSIS packages using SSIS.

Reviewed business requirements and analyzed data using Excel/Oracle SQL Server for design, development, testing, and production rollover using Tableau.

Identified and designed trends or patterns in complex architectural data sets. Enhanced analytics and reporting databases and data tools. Organized and maintained data for agent performance and key performance indicators.

Collaborated with the Data Management team to ensure data quality controls are fully implemented for all critical data.

Performed predictive and prescriptive analysis along with problem solving capabilities to optimize registration of students and faculties for the workshops.

Collaborated closely with business teams, data managers, and data scientists to turn data into critical information and knowledge. Routinely interacted with the Analytics & Reporting Marketing Product Manager to identify new data and reporting needs and provide updates to marketing for service capabilities

Helped to automate business intelligence processes and improved data access and tools for both internal and external customers. Worked with various business units to evaluate and document current operational processes

Updated report structures with the use of advanced Excel functions including Pivot Tables and V-Look-ups.

Implemented interactive Business Intelligence Reporting Solutions with SSRS. Designed visual data out-put models of the data content, in the form of various charts and graphs using Tableau.

Generated weekly, monthly, and quarterly reports necessary in maintaining targeted audience information.

Researched for new means of qualifying data and methods of utilizing analytical tools effectively to be used for VR systems development and improvement.

Projects Undertaken:

Data Mining - Worked on SAS Enterprise Miner Workstation to perform data analysis on airplane crash data set to predict a trend in order to avoid future airplane crashes. Data preparation and data cleaning was conducted before running the data set and null values were discarded to show uniformity in data. Data visualization for this data was provided in the form of graphs such as scatter plot so as to provide a better understanding of the frequency of airplane crashes based on the operator and fatalities.

Security Based Project: Handled the Security Based watermarking Project like coding of modules using given design specification on "A Copyright Tagging on Android Platform to Prevent Piratical Behavior of Images. Skills Used: Java Framework, Net-beans, Android

Database Management Systems: Developed a Online Coffee shop billing system project Visual Basic & Database handling. Skills Used: SQL,Oracle 10g, Java,HTML,VB,.net environment (C#).

SQL injection Attack project(Computer Security): In this project, I performed various tests on SEEDLABSQLINJECTION website to observe how it responds to several injection attacks. Initially, it was possible to easily hack the website and steal all the information but later with the use of Prepaid statements we could defend the website and prevent the attack. Skills Used: SQL, mysql, Linux

Buffer Overflow Project:In this project, i carried out various experiments on the stack.c and exploit.c program to see how buffer overflow responds to every operation and to see how the shell code responds under those conditions. Skills Used: SQL, mysql, Linux Publication:

Published a research paper on the topic “A Copyright Tagging on Android Platform to Prevent Piratical Behavior of Images”“INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND MOBILE COMPUTING”(2015) Education:

University of Illinois, Springfield (2016-2017) GPA: 3.62 (Master’s in Computer Science) University of Pune, India (May 2015) Percent: 67% (Bachelors in Computer Engineering) Post Graduate Diploma in Software Testing (2015) Grade A Certification:

Earned Certification in Tableau from Udemy.

Earned Certification in Python from Udemy.

Contact this candidate