PREETPAL KAPOOR

Email : adhpxj@r.postjobfree.com

Address: M-15 Sriniwaspuri, New delhi-110065

Contact no: +91-965*******

CAREER OBJECTIVE:

Seeking an opportunity to utilize my skills and abilities in the Information Technology Industry that can offer professional growth while being resourceful, innovative and flexible.

AN OVERVIEW:

A logical, analytical thinker with good Technical skills possesses more than 8 years of experience in IT industry.

Ability to work independently as well as with team having varying backgrounds on complex issues and have strong verbal and communication skills.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

3+ years of experience in Tableau dashboard designing.

Good experience in performance tuning and optimizing ETL packages.

Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

Knowledge in creating web-based reporting application using SSRS and C#, .NET.

TECHNICAL SKILL SET:

Languages : C#, VBA, SQL, Python

Business Intelligence Tool : SSRS, SSIS, Report Builder, SSAS, Tableau 2018.2, Pentaho

Databases : MS SQL Server 2016/2012, Oracle 9i, MS-Access

Front End : Visual studio 2015/2010/2012

Web Designing : .Net4.0, HTML, JavaScript, jQuery

Tools : MS Office 2013, Excel

Operating Systems : Windows XP, Windows vista, Windows 7

WORK EXPERIENCE

Currently working with Bureau Veritas Noida as Sr. BI Consultant since May 2019.

Worked with WNS Gurgaon as Deputy Manager from September 2016 till May 2019.

Worked with BA Continuum India pvt. ltd. (Bank of America) Gurgaon as Sr. Software Engineer from February 2014 till September 2016.

Worked with TCS Noida (On Payroll of Mbit consultant) as System Engineer from July 2013 to February 2014.

Worked with HCL Technologies as Software Engineer from November 2010 to June 2013.

PROJECT OVERVIEW:

Media tracker report via Google Analytics

Client: Moneycorp

Technologies: SQL Server 2012, SSIS, Tableau 10.0

Responsibilities:

Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model and gathered reporting requirement from the business analysts

Created a SSIS package to fetch data from Google Analytics service for Moneycorp media partners with the help of 3rd part driver. The report shows the leads count of Moneycorp customers.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis

CMO Sales Incentive

Client: Bank of America

Technologies: SQL Server 2012, Tableau 9.0

Responsibilities:

Create the database objects for CMO Sales incentive report.

Created a dashboard which shows a view to high level management about the revenue an agent generated and how much incentive he is getting. With the dashboard it also has a link for agent view report – this view shows the incentive related details for an agent.

NHB Report

Client: Bank of America

Technologies: SQL Server 2012, SSIS, SSRS

Responsibilities:

Create the database objects and ETL packages for NHB application which use to run on daily basis.

Created single report to show New hired agents’ performance analysis based on 30-60-90 days data.

CMO Agent scorecard

Client: Bank of America

Technologies: SQL Server 2012, SSIS, SSRS, .NET c# 4.0, Jquery

Responsibilities:

Requirement gathering and Involved in designing logical and physical data models.

Created SSIS packages and custom transfer components to move data from oracle to SQL server.

.Net based custom reporting dashboard was developed.

Data Centre Migration

Client: HCL

Technologies: SQL SERVER 2008, SSIS, SSRS

Responsibilities:

Involved in CRM Database understanding and new data warehourse design system.

Involved in data model level for the system.

Creating Tables structures for reporting purpose to capture data from different data sources and loading the Data to different tables using Bulk Insert and ETL Jobs in SQL server 2008.

Creating VBA automation to capture the data from AVAYA though an ODBC link.

EDUCATION QUALIFICATIONS:

B.TECH in Computer Science Engineering (2006-2010) from CT institute of engineering and management (Punjab Technical University).

XII (CBSE Board) from Dev Samaj Modern School.

X (CBSE Board) from Dev Samaj Modern School.

ACHIEVEMENTS:

Recognized two times with a Bronze award for delivering fast and with quality work to LOB and Awarded with Silver award for handling multiple projects.

Handled a project and visited On-Site for 2.5 months

Awarded as a star performer of the year (2012).

DECLARATION:

I do hereby declare that the particulars of information and facts stated herein above are true, correct and complete to the best of my knowledge and belief.

Place New Delhi Preetpal Kapoor

Contact this candidate