Aritra BanerjeeE -mail: ban1989aritra@gmail.com

Phone: 9035174480Cyber Park, Plot No: 76 & 77, Electronic City Phase1, Dodathogur,

Hosur Road, Bangalore – 560100

OBJECTIVES

Seeking an analyst position where I can utilize analytical thinking and relevant expertise to help the organization comprehend its long term goals.

ORGANISATIONAL EXPERIENCES

Company Name : CGI Inc. (Canada)Experience : 3 years (September 2013- Till Date)

Current Position : Software Engineer

SUMMARY

Experience in SQL Server. Working alongside with web developers and programmers Collecting, organizing and managing data. Strong understanding in software development life cycle (SDLC) process with an analytical, programming

and problem solving skill. Created SSIS/ DTS, SSRS Packages for Data Migration and Transformation. Worked on server certificate issues.

WORK EXPERIENCE

Organization: CGI

Application Name: TAP

Client Name: Bell CanadaProject Details: With this project, Bell will be extending the Bell Total Connect Unified Communication features to small site locations across Mass, M id and Enterprise markets via Fiber based accesses. Customers will gain access to the same features that are available today through Bell Total Connect Voice (IP-VPN) and will benefit from feature enhancements which are under development as part of Peats 28917. This is consistent with the Product Roadmap evolution plan to move customers to feature-rich communication services.Project Role:

Responsible for handling the integrity of the SQL database and maintain any issues to the database architect.

Assisted in mining data from the SQL database that was used in several significant presentations. Assisted in offering support to other personnel who were required to access and analyze the SQL

database.SDLC Phases Covered: Requirement gathering, Discussion with client for requirement analysis, Feasibility Study, Development of unit test cases, Production support, Technical documentations of the developed program and interfaces, reporting of completed and planned task.

Application Name: SARA

Client Name: Bell Canada

1

Project Details :

WebFOCUS Global Report changes based on Global Alliance Partner value (GA or N ON -GA) coming to IPACT. Implementing changes required by the new flag that will be received from IPACT that will identify which customer is Global Alliance.Project Role:

Analyzing data, provided by the client depending upon their requirements for the project. Database (SSIS Packages) management for SARA

SDLC Phases Covered:

Requirement gathering, Discussion with client for requirement analysis, Feasibility Study, Development of unit test cases, Production support, Technical documentations of the developed program and interfaces, Reporting of completed and planned task.

Application Name: SARA

Client Name: Bell Canada

Project Details :

The client wants to implement a schedule job using DTS package on a weekly basis which will pump the filtered data to the downstream applications.Project Role:

Analyzing data, provided by the client depending upon their requirements for the project. Creating and implementing the DTS package. Database (SSIS Packages) management for SARA.

SDLC Phases Covered:

Requirement gathering, Discussion with client for requirement analysis.

EDUCATIONAL BACKGROUND

Masters in Computer Application (MCA) 2010 — 2013B. P. Poddar Institute of Management & Technology, Kolkata, West Bengal

Studied Programming Languages C, C++, C#, .N E T, Database SQL Server Management Studio, DBMS along with Mathematics and Computer Architecture. Completed with an aggregate of 82.3 from WBUT (West Bengal University of Technology) in 2013.

Bachelors in Computer Application (BCA) 2007 — 2010Techno India, Saltlake, Kolkata, West Bengal

Studied Programming Languages C, C++, VB, .N E T, Databases S QL Server Management Studio, DBMS along with Mathematics and Computer Architecture. Completed with an aggregate of 79.6 from WBUT (West Bengal University of Technology) in 2010.

Higher Secondary (H.S) 2005 — 2007Purba Barasat Adarsha Bidyapeeth, Kolkata, West Bengal

Studied Economics, Statistics, Geography, Mathematics, and Computer Application and completed with 68% from West Bengal Council of Higher Secondary Education in 2007.

Secondary (Madhyamik) 2004 — 2005Priyanath Boys’ High School, Kolkata, West BengalStudied Language Group (Bengali, English, Hindi) with Science (Physical Science, Biology, Mathematics) and General Subjects (History, Geography, and Computer) and completed with 75.4% from West Bengal Board of Secondary Education in 2005.

2

TECHNICAL PROSPECT

Languages : C#, ASP.Net, VB6 (Partially)

Databases : MS-SQL Server Management Studio, Oracle Operating System : Windows Server 2003, WINDOWS XP/2000/NT Software : MS SQL Server 2012/2008/2005/2000/7.0, Visual Studio 2010/2008/2005 Tools : DTS, SSIS, SSRS, SQL Server

Others : Worked on BMC Remedy Ticketing Tool (ITSM Ticketing Tool) Current Status : Learning Python 2.4

ORGANISATIONAL TRAINING

1. The Confident Communicator organized by CGI2. Customer Centricity organized by CGI3. The Presentation Skills organized by CGI4. SSIS and SSRS training organized by CGI5. Aware of the Process Related Trainings (Peritus and Pareto Chart)

CERTIFICATIONS AND MERIT RECOGNITION

1. Awarded Certificates for NIIT Merit Scholarship Test in 2012 and 2013.2. Received Merit Scholarship from CMC Ltd for the academic year 2011-12 and 2012-13.

EXTRA- CURRICULAR ACTIVITIES

1. Received awards for becoming Runner-up in Inter and Intra CGI Football Competition (2015).2. Awarded Certificates for performing well in College Football tournament (2008 to 2013).

PERSONAL DETAILS

Father’s Name : Chandrasekhar BanerjeePermanent Address : "Prasanna",

1/D Ghosal Para Rd. P.O: Barasat, Kolkata- 700124

Date of Birth : 12th November, 1989Marital Status : SinglePassport Details : L4056057 (Number)Valid Till : August 2023Languages Known : English, Hindi and Bengali

3