PAPPU MAJUMDER, Microsoft Business intelligence (MSBI)

PAPPU MAJUMDER

Microsoft Business intelligence (MSBI)

Equifax

Location
India - Bengaluru
Education
Bachelor's degree, Electronics and Communication
Experience
8 years, 5 Months

Share My Profile

Block User


Work Experience

Total years of experience :8 years, 5 Months

Microsoft Business intelligence (MSBI) at Equifax
  • India - Bengaluru
  • My current job since April 2016

Responsibilities:

* Developed and optimized database structures, stored procedures, views, and user-defined functions for the Application.
* Involved application tuning and tested the application for deployment, Function and behavior.
* Created some T-SQL queries, Stored Procedures.
* Design and create SQL tables, indexes.
* Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
* Responsible for gathering/refining requirements from the client for developing reports.
* Created SQL Server Reports using SSRS.
* Developed Query for generating drill down and drill through reports in SSRS.
* Uploaded reports on to the report manager and organized them in folders.
* Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.
* Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
* Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
* Created SSIS process design architecting the flow of data from various sources to target.
* Configured SSIS packages using Package configuration wizard to allow package run on different environments.

Trainee at Moda innovation
  • India - Bengaluru
  • February 2014 to June 2014

As a Organisation, our goal is to contribute to society through broad-ranging activities in the areas of Software development, Training and Technical Projects.

Modainnovations has successfully performed projects under various platforms and has delivered high quality competitively priced products and services to customers all over India.

Modainnovations has successfully performed projects under various platforms and has delivered high quality competitively priced products and services to customers all over India.

Education

Bachelor's degree, Electronics and Communication
  • at East Point College of Engineering and Technology
  • June 2014

Electronics and Communication engineering degree programs with communication concentrations are typically offered from the bachelor's to the doctoral level. These programs prepare students for careers as systems engineers, research engineers, controls engineers, communication engineers and electronic engineers, as well as researchers and university professors. The programs are rigorous with an emphasis in math and science. Students study topics such as wireless, digital, data and fiber optic communications

High school or equivalent, Science, Math
  • at East Lumding High School
  • May 2007

Standards (Grades) XI to XII are called as Higher Secondary School or Senior Secondary School or Junior college. Some states refer to Standards(Grades) IX and X as High School, while XI and XII are termed as Intermediate.Usually, students from ages 14 to 18 study in this section. These schools may be affiliated to national boards/ Councils like Board of Secondary Education (Assam),

Specialties & Skills

Languages

Hindi
Expert
English
Expert
Bengali
Expert
Korean
Intermediate
German
Intermediate

Memberships

Clean Bangalore and Green Bangalore
  • FOUNDER
  • January 2015

Training and Certifications

CERTIFICATE of EXCELLENCE (ROBOWARZ) (Certificate)
Date Attended:
April 2014
CLIMATE CHANGE QUIZ 2013 CERTIFICATE (Certificate)
Date Attended:
September 2013
ROBO GALAXY 2013, MERIT CERTIFICATE (Certificate)
Date Attended:
October 2013
SAMSKRUTHI 2012 (Certificate)
Date Attended:
March 2012
QUALIFY CERTIFICATE (NASA CALIFORNIA) (Certificate)
Date Attended:
April 2014
CERTIFICATE OF COORDINATION (Certificate)
Date Attended:
October 2013
Valid Until:
October 2013
MERIT CERTIFICATE (ANNUAL EXAMINATION 2003) (Certificate)
Date Attended:
April 2004
ETHICAL HACKING AND INFORMATION SECURITY CERTIFICATE (Certificate)
Date Attended:
February 2012
CERTIFICATE OF ACHIEVEMENTS (PAPER PRESENTATION) (Certificate)
Date Attended:
April 2014
RASPBERRY PI WORKSHOP (Certificate)
Date Attended:
April 2014
VOCATIONAL TRAINING (Training)
Training Institute:
B.S.N.L
Date Attended:
December 2012
Duration:
72 hours

Hobbies

  • LONG DRIVE,TIME PASS WITH FRIENDS
  • PAINTING,PROGRAMMING
  • learning new ideas and technologies
  • Visiting new places
  • Searching & learning of tricks to do things