Information Systems Sql Server

GAURAV MAHICH

************@*****.*** https://www.linkedin.com/in/gauravmahich 815-***-**** 5820 N Sheridan Rd. #304 Chicago IL 60660 PROFESSIONAL SUMMARY:

• Graduate Student with a Master’s Degree in Management Information Systems at Northern Illinois University seeking full time opportunities as a Business Analyst

• A highly articulate person with excellent Interpersonal Skills and Customer Relation Skills with an innate ability in decision making for organizational efficiency

• Knowledge in Business System Analysis, Agile Methodology and Visualization Concepts WORK EXPERIENCE:

Software Developer Intern June 2013-July 2013

Add Value Software- Jaipur, India

Assimilated the core concepts of JAVA programming

Developed Web & Enterprise applications using JAVA and J2EE Technologies

Requirement analysis and designing of the web applications ACADEMIC PROJECTS:

Data Visualization – 911 Calls for Montgomery County, PA- Analyzed 911 calls data for the year 2015 and 2016 and created visualizations deriving useful information like call frequency over hours, weeks, months, types of emergency

-Tools used – MS Excel, Tableau (FALL 2016)

Data Visualization for Northern Public Radio-2012 General Election Comparison for three counties- DeKalb, Winnebago and LaSalle and statewide counties for Illinois using Tableau (FALL 2016) http://northernpublicradio.org/post/unofficial-results-show-increased-turnout-and- third-party-votes-area-counties )

Data Visualization on Divvy Bikes Chicago -Used the Data set from Divvy Bike Challenge to show trip trends, user types and average age of users, seasons in which they are used the most and trip route trends (Source and Destinations)

-Tools Used- Python and Tableau (FALL 2016)

Business Intelligence- Data Analysis, KPI and Report Generation for Global Bikes Inc. using BI tools such as SAP Business Warehousing and Business Objects, Visual Studio, Excel, Pivot Tables, Power Pivot, flat files and cube configuration to import data from the Data-mart with understanding of ETL(Spring 2016)

Databases- Translated and created relational database from raw data using SQL Server and MySQL and ER diagrams (Fall 2105)

Business System Analysis and Design- Business Process Improvement - implemented a new ERP System replacing the old legacy system. Use of techniques like use case diagrams, Structure charts, UML, Decision trees, Decision tables, Data Flow Diagrams. User stories

-Tools Used- Microsoft Visio (Fall 2015)

TECHNICAL SKILLS:

EDUCATION:

Master of Science in Management and Information Systems Aug 2015-Dec 2016 Northern Illinois University, DeKalb, IL, USA

Bachelor of Technology in Computer Science Engineering Aug 2010-June 2014 Arya College of Engineering and Information Technology, Jaipur, INDIA CERITIFCATIONS/AWARDS:

Microsoft Certificate of Recognition (Academic),2014 Oracle Certified Professional Java SE6,2013

Oracle Database Associate 10g,2012

• C, C++, Java

• SSAS and Power Pivot

• Business Intelligence Development Studio, MS

Excel - Pivot Table, Vlookup, Business Objects

• Microsoft Visio, MS SQL Server, JIRA

• Agile Methodology, UML, DFD, Business Cases,

Decision Trees

• MS Access, MS Project, SQL,SAP(FI/CO)

• MS SQL Server 2008, MySQL, MS Access

• Tableau, Reporting

• SDLC

• MS Office

• Strong decision maker

• Excellent written and oral communication

• Requirement Analysis

• Data Visualization

• Analytical Skills and Creative

• Influencing Skills

• Attention to Detail

• Planning and Organizational Skills

• Detail Oriented

• Data review and Visualization

• Balsamiq

• Business Process Improvement

Contact this candidate