Harjit P.

Harjit P.

Freelance Trainer and MSBI Consultant

Delhi , India

Experience: 11 Years

Harjit

Delhi , India

Freelance Trainer and MSBI Consultant

USD / Year

  • Start Date / Notice Period end date:

11 Years

Now you can Instantly Chat with Harjit!

About Me

I am Sr Technology consultant having more than 10 years of experience. I am having core experience in SQL Server,ETL Tool(SSIS),SSRS and SSAS. I also worked omn  AWS Redshift, Athena,AWS Glue. Also worked on ADF(Azure Data Factory) . Worked on va...

Show More

Portfolio Projects

Description

Involved in Cube Design and MDX queries in SSAS
 Processing and Deployment of Cube
 Adding New dimensions in the existing Cube
 Creating Different User Defined Hierarchy in the Cube and involved in Optimization.
 Involved in the ongoing DW activities regarding addition of Dimensions and Facts depending
upon the requirement.
 Worked as Data Analyst in the Managed Print Services to get insight of the data using SQL
 Managed the Data resulting from Analysis to get shared with the management for
 Worked with Onsite team for various Day to Day DW activities.
 Worked on Dashboards for Manage Printing Services for different Geographical Locations for
various measures.

Show More Show Less

Description

Involved in the automation of Reports for Dell Customers and Resellers.
• Highly involved in SSIS and SSRS for automation of reports
• Involved in creation of SQL jobs
• Worked on Data Analysis for different regions
• Creation of Customer Quality Review Report for Dell
• Creation of SQL Stored Procedures
• Optimization of SQL Stored Procedures
• Creation of new SSRS Reports based on Client Requirement
• Involved in Teradata(Nexus)Query which is used for automation process.
• Client interaction on Daily basis
• Giving production support as well of existing products (SSIS and SSRS)

Show More Show Less

Description

created customwer quality service project for dell customers using ssis.

Show More Show Less

Description

Liaise with business subject matter experts in analyzing business requirements and translating them
into detailed conceptual data models, process models, logical models, physical models and schema
development in the database.
 24x7 Support for Cassandra related issues.
 Map source system data elements to target system and develop, test, and support extraction,
transformation and load processes.
 Based on business rules, load Insurance related data, develop SSIS Packages using best performance
techniques to load into DW.
 Defines and captures metadata and rules associated with ETL processes.
 Creating SSRS Reports (Medium and complex) and SSRS (MDX Reports)as well. Creating SSIS
Jobs(Packages) and Scheduling.
 Assigning Roles in SSAS Cube
 Monitoring Jobs in SQL Server.

Show More Show Less