ARIJIT ROY

Permanent Address:

*A/* Aurobindo Avenue,

A-Zone,Durgapur-713204,

West Bengal

15th November 1995, India Mobile: 790-***-**** / 876-***-**** E-mail: adfcum@r.postjobfree.com

OBJECTIVE

To work and develop amidst a challenging and competitive environment, being innovative, honest and hardworking, maneuvering to bring the best out of me, so that my endeavors are conducive to constant personal growth and can adjoin in the goals of the organization. I am working as an ETL Developer in Cognizant and have working experience on technologies like Informatica PowerCenter, Oracle, Pl/SQL, Unix, SQL, Data warehousing, Data Integration. WORK EXPERIENCE

Programmer Analyst

Cognizant, October 2019 – Present

Role : ETL Developer

Read, analyze and provide feedback and changes on business requirement documents

Strong data warehousing and OLTP system knowledge from database/ETL development perspective

Assist with design and implementation of staging areas and data warehouse

Design, build, testing and maintenance of data integration / ETL processes

Prepared technical designs for Informatica mappings

Created and executed mapping using Slowly Changing Dimensions Type 2

Experience in designing and building complete ETL processes, including moving and transforming data for ODS, Staging, Intermediate and production environment

Knowledge of Oracle DB including database querries, package, procedure, functions, indexes

Participated in providing the project estimates for development team efforts for the off shore as well as on-site.

Programmer Analyst Trainee

Cognizant, October 2018 – September 2019

Role : ETL Developer

Read, analyze and understand on business requirement documents

Analyze and support real time or production failures within deadline

Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 9.x to extract the data from multiple source systems that comprise databases like Oracle 11g, flat files to the Staging area, Intermediate tables and then to the production environment.

Strong management skills with the ability to work in a team-based environment including employees, vendors, and third party contractors

Effectively prioritize and execute tasks in a high pressure environment

Detail design of source to target data mappings

VOCATIONAL TRAINING

INTERN AT DURGAPUR STEEL PLANT,SAIL

DURGAPUR STEEL PLANT, SAIL

The topics included: Single line Diagram, DC and AC motors, Transformers, Cables, Steel Making, Relays, Switches and Gears, Power Plant Working.

EDUCATION

COURSE INSTITUTION

YEAR

OF

COMPLETION

GRADE/PERCENTAGE

B.E. in Electrical and

Electronics

Engineering

Nitte Meenakshi Institute Of

Technology, Bangalore

April,2018 8.12 CGPA

CBSE – XII (PCMC) Guru Teg Bahadur Public

School, Durgapur

May,2014 79.4%

CBSE – X Durgapur Ispat Vidyalaya,

Durgapur May,2012 89.4%

PROJECTS

DESIGNING OF FLIGHT CONTROLLER BOARD USING ARDUINO AND IMPLEMENTING IT IN MULTIROTOR AERIAL VEHICLE (FINAL YEAR PROJECT)

To design a flight controller board using Arduino Uno and interfacing it with IMU to detect the angle of movement of the quadcopter and also to balance it. NOVEMBER 2017-APRIL 2018

ARDUINO BASED DTMF CONTROLLED SURVEILLANCE CAR (SUMMER PROJECT) The project is to develop a car which can be controlled through smart phone using DTMF decoder to send information, from anywhere in the world.

JUNE 2017 – JULY 2017

SAND SAMPLE COLLECTOR (UNDER CENTRE FOR ROBOTICS RESEARCH) The challenge of the project was to make a robot which should be capable of moving on uneven terrain and also to make the design so as to collect the sample of sand from a particular area after drilling and pouring the sand into a separate container.

JULY 2016

Mini Project

o Smart Home Security System using ARDUINO UNO.

o Temperature controlled DC fan using 8051 Microcontroller. o Contactless Tachometer using 8051 Microcontroller. o C++ based TIC-TAC-TOE game using OOPS concept.

WORKSHOPS

Workshop on Lego Mindstorm and Tetrix by Centre for Robotics Research, NMIT

Workshop on Recent Trends in Digital signal processing by Dept. of EEE, NMIT

TECHNOLOGY &TOOLS

Proficient in: Oracle SQL, UNIX, Informatica PC, Control-M

Familiar with: Arduino, Microcontroller 8051

Having core knowledge of Transformers, DC and AC machines, Power System lines, Op-Amps, Power Electronic devices.

STRENGTHS AND PERSONAL SKILLS

Good communication skills

Adaptability to change

Open to learning

Creative

Dedicated

Hardworking

Goal Oriented

Leadership.

PERSONAL DETAILS

Languages known- English, Hindi, Bengali.

Hobbies- Surfing web about latest technologies, Watching Japanese Anime, Reading Novel, Travelling with friends, Sketching.

Campus Activities:

Organized TEQUIP seminars, conducted workshops as Technical Head of the EEE branch from 2016 – 2018

Organization and hosting of events as Technical member of ANAADYANTA, the college annual techno- cultural fest from 2017-2018

ACHIEVEMENTS

Certificate of Completion in "ROBOTICS ENGINEERING-LEGO MINDSTORM & TETRIX" (06/2016)

Certificate of Participation in "RECENT DEVELOPMENTS IN DIGITAL SIGNAL PROCESSORS FOR INDUSTRIAL APPLICATIONS” (02/2017)

Certificate of Excellence in Sports(12/2003 – 01/2011) I hereby solemnly declare that the above written particulars are true to the best of my knowledge and belief. Regards,

Arijit Roy.

Contact this candidate