Ganesh Kapaleshwari

Chicago, IL ***** ac1dgo@r.postjobfree.com 312-***-****

LinkedIn Profile: https://in.linkedin.com/pub/ganesh-kapaleshwari/23/471/38 EDUCATION

Illinois Institute of Technology Chicago, Illinois Aug 2015 – May 2017 Masters in Information Technology & Management

Visvesvaraya Technological University Karnataka, India Aug 2006 – June 2009 Bachelor of Engineering in Electronics and Communication SKILLS

• Java, SQL, PL/SQL

• R, SAS, Python

• Oracle, MSSQL, MS Access

• Tableau, QlikView v12, BIRT Reporting,

• SQL Developer, Eclipse IDE

• Advanced Excel Analysis, Pivot table reporting

• Data Mining, WEKA

• Data Warehousing, ETL, SSAS, SSIS

• IBM Maximo v7.5, IBM WebSphere v7.1

• Service Now, HP Quality Center

• Microsoft Office Suite, MS Visio

• Waterfall Methodology, Agile

ACADEMIC PROJECTS

• Performed analysis of Mortality Data in US, 2014 and determined the manner of death by applying Data Mining techniques and algorithm using R and Weka. Fall 2016

• Performed Cluster analysis and profiling of Clusters using SAS for Tax data prepared by American Community Survey. Fall 2016

• Performed Text Mining analysis using R on DEF14A documents for Dell company. Fall 2016

• Performed analysis on Executive Compensation of Dell CEO and Stock price trend over the years. Fall 2016

• Performed analysis on Chicago Pothole Repair data using Excel (Solver, Pivot table). Fall 2016

• Designed and developed Concert Application Database System using Oracle. Spring 2016

• Research Paper on ITIL Framework (Case study-Project Savior). Spring 2016

• Designed and developed Trading Application using JavaFx, Java and MySql. Fall 2015 EXPERIENCE

Illinois Institute of Technology, Chicago, Illinois Prospect Research Student Assistant Sept 2016 - Present

• Analyzing Donor and Alumni’s data and updating the information in Raiser’s Edge tool.

• Utilizing print and electronic resources to complete research reports on individual, corporate, and foundation prospects.

• Provide general office support to various staff members in the office and reception desk coverage. Accenture Services Private Ltd, Bangalore, India April 2010 - Aug 2015 Utilities Industry

• Designed custom reports using Business Intelligence and Reporting Tool with charts, crosstabs for power distribution client.

• Written simple and complex PL/SQL queries on Oracle for report design purpose.

• Created Technical Design document and Unit Test document for the reports.

• Developed UI’s for Maximo applications using Java customization and deployed the EAR files on server.

• Tested Maximo End-to-End Applications for client in fewer spans of time which resulted in successful Go-Live of application.

• Maintained all the Maximo application servers on IBM WebSphere. Health-Care Industry

• Provided support to Testing team by creating the Test Environment Infrastructure as per the requirement in Mainframe.

• Written queries to extract data for debugging errors and logged the defects in HP Quality Center.

• Executed, monitored, verified the scheduled Batch jobs for EDI,4010,5010 claims.

• Coded JCL as per the environment specification for testing.

• Created low to medium level PL/SQL queries to perform the backend testing.

• Analyzed the Health care domain related System Specs and created High Level Test outline and Detailed Test Plan for system testing.

AWARDS

• Winner in Innovative Ideas and Prototype competition at Illinois Institute of Technology.

Contact this candidate