Sign in

Business analyst

Chicago, Illinois, United States
January 08, 2017

Contact this candidate

Kunal Purohit

*** * ******* ****** *****: 551-***-****

Apt 3910

Chicago IL – 60661


Masters in Management Information Systems CGPA: 3.73

Harrisburg University, Harrisburg, PA, USA 2017

Courses – Project & Program Management, Applied Consulting, SAS, Big Data Analytics, Enterprise Information Infrastructure Planning and Security, Advanced DBMS, Advanced Java, Advanced System Analysis and Design.


Business Analyst Intern, Cox and Kings June 2016 – December 2016

Chicago, IL, USA

• Coordinated collaborative activities between Embassies and company to develop unified customer solutions.

Business Intelligence: Generated weekly dashboard and visual reports using Tableau to analyze a marketing campaign performed on a specific age band of the firm’s customers.

Business Analysis: Involved in business process redesign for various payment and billing processes as part of migration of customers’ data from legacy systems to web based database servers.

Requirements Gathering & Analysis: Gathered business requirement and functional specifications and developed business requirement document for various change requests in a large on-going integration project.

Graduate Research Assistant, June 2016 – December 2016

DeVry University, Chicago, IL - USA

Network Admin: Responsible for designing and setup and maintenance of Virtual server system of student job portal.

Database development: Created, updated and maintained the tables in MySQL and generated periodic SQL server reports against RDBMS

Data Analysis: Statistical regression analysis on data sets of career services services using R and SAS.

Business Analyst, Tata Consultancy services, India July 2013 – March 2015

Client: Pandit Deendayal Petroleum University

Project Planning: Developed test traceability Matrix, test scenario matrix and requirement traceability matrix using IBM’s Rational Quality Manager (RQM).

Initiative: Developed VBA for weekly metrics Dashboard using the VB macros reducing the manual efforts by 82.33%. Automated the browser testing functionalities using IBM’s Rational Functional Tester (RFT) and showcased the cost savings to the client.

Developed an analysis model that includes Use Case diagrams, and Activity diagrams using UML methodologies in MS Visio, which provided the development team a view of the requirements for design and construction phases.


IT Infrastructure: Reviewed and analyzed the survivability of IT infrastructure of a large nation-wide retailer

Dimensional Modeling and Business Intelligence: Created dimensional framework for Illinois State Operating budget by transforming number heavy information to self-explanatory Business Intelligence reports.

Project Implementation: Implemented a project plan for developing a new Order entry subsystem for a Pizza delivery firm using MS Project Professional tool. Also used MS excel- Pivot tables, V- lookups and other functions to make every day report.

Leadership: Interviewed Hon’ble Prime Minister of India Shri Narendra Modi as a part of leadership project.


• Proficient in Microsoft Office (Excel, PowerPoint, Word, Outlook)

• Professional experience in Social Media (Facebook, Google +, Instagram, Tumblr, Twitter, & Vine)

• Operating System: Mac OS, Windows 7/Vista/XP/2000, Linux, Unix, Ms DOS

• Methodologies: RUP, Waterfall, Agile(Scrum)

• Business Modelling Tools: MS Visio, MS Project, Rational Rose, UML, MS Outlook

• Database: SQL, MS Access, Mapping Designer, IBM Mainframes

• Other Tools: Rational Clear Quest, Quality Centre

• Microsoft (Word, Excel, Outlook, PowerPoint, Publisher, Visio, Project, Access, InfoPath, Expressions Blend, FrontPage), Confluence, JIRA, Github

• Microsoft SharePoint and SharePoint Designer

• Process/Business Intelligence


Travelling, tennis, foreign cultures and Chess


English, Hindi, French, German and Spanish

Contact this candidate