Data Management

DIPANJAN BOSE Email:*************@*****.***

**** ******** ******, ********, ** 13210 Phone: 315-***-****

EDUC ATION:

August 2013 – May 2015

M.S. Information Management (GPA: 3.67/4.00)

Syracuse University, School of Information Studies, Syracuse, NY

Bachelor of Technology in Electronics and Instrumentation (GPA: 3.19/4.00) Ma y 2011

Vellore Institute of Technology University, Vellore, India

Relevant Coursework: Database Management, Information Systems Analysis, Project Management, Information Visualization,

Data Analytics, Applied Data Science, Data Warehouse, Business Intelligence, Software Modelling and Analysis

PROFESSIONAL EXPERIENCE:

Business Analyst Intern

th

June 2014 – August 2014

20 Century Fox, Los Angeles, USA

Collaborated with the Lead business analyst and gathered requirements from business users for the Siebel Financial

Planning project which involves generating Ultimates (projected revenue that a movie or a TV show might make during

the fiscal year) using a Siebel CRM application.

Coordinated with the team on JAD sessions, defined dependencies, risks and established m ilestones to be achieved.

Involved in preparing Functional Requirements Specifications (FRS) based on user requirements.

Analyzed the current state and designed wokflows for the future state of the application after migration using MS Visio.

W orked with the development team during design phase to ensure reliability, usability, maintainability of the application.

Assisted with test plans, test cases, unit testing and conducted UAT to determine test requirements and pass/fail criteria.

Presented a Sneak Peek material which analyzed the risks and highlighted the benefits of the new application to users.

Created the Home Office Training guide for business users in order to walk them through the Siebel application.

Programmer Analyst

August 2011 – May 2013

Cognizant Technology Solutions Ltd, Kolkata, India

Acquired working knowledge of EDI (Electronic Data Interchange) systems and used it in various maintenance and

enhancement projects for BNY Mellon bank.

Analyzed business and technology requirements through active collaboration with clients, analysts and developers .

Designed effective business, technical and system process flows by focusing on ways to improve efficiency.

Built ad-hoc UNIX scripts for daily monitoring and automating processes to improve performance by 10%.

Provided support and maintenance of existing database on more than 100 data fields for over 1.2 million insurance firms

and professionals using SQL queries.

Developed periodic reports and data extracts based on client needs using MS Access to gain key insights on the data.

Developed test cases and performed root cause analysis of defects to improve the overall efficiency of the code.

AC ADEMIC PROJECTS:

Data Analysis of Health Insurance Coverage in US September 2014

Gathered raw data from multiple sources, processed and reorganized it to prepare data sets for analysis.

Replaced missing data elements by studying nature of missing data to improve overall data quality.

Performed analysis using R to forecast the health insurance coverage of people in US among various age groups.

Developed reports and charts using data visualization techniques to provide key insights on data sets.

American Teaching Hospital Information System January 2014

Gathered requirements from clients to define business strategy for the teaching hospital based on market research.

Designed and developed a high level business model for the system and categorized the various functional areas.

Performed root-cause analysis to identify issues and determined the overall feasibility of the project.

Analyzed the existing and proposed system by using swim lane diagram, Data flow diagram, PIECES Framework, use

case diagram, ERD, ITIL methodology, performance metrics, business data mapping, system integration testing, UAT,

unit testing, regression testing and risk assessment techniques.

Mobile Store Management System February 2014

Conceptualized a database system for a mobile store to automate their purchase, sales, billing, customer information and

track inventory management

Designed overall relational-database model using Microsoft Visio and developed it using Microsoft SQL Server.

Enhanced user experience by developing interactive forms and prepared insightful reports using Microsoft Access .

TECHNICAL SKILLS:

Programming Languages: C#, SQL, UNIX Shell Scripting, R

Operating Systems: W indows, Ubuntu

Application Software: MS W ord, MS PowerPoint, MS Excel, MS Project, Siebel CRM, Tableau, SharePoint, MS

Access, MS Visio, MS Visual Studio, MS SQL Server (SSIS,SSAS,SSMS), Adobe Illustrator

LEADERSHIP:

Graduate mentor for new students arriving on campus at Syracuse University.

Committee head of SINC 2010 organized by SEDS group at VIT University.

Volunteered for Outreach programs as part of Cognizant and helped students in their school work.

Organized workshop on "Social Entrepreneurship Symposium" at VIT University.

Contact this candidate