Pankaj B.

Pankaj B.

Tech Lead

Bangalore , India

Experience: 10 Years

Pankaj

Bangalore , India

Tech Lead

54717 USD / Year

  • Notice Period: Days

10 Years

Now you can Instantly Chat with Pankaj!

About Me

·         BI Professional with 7 years of Extensive Technical & Leadership experience in BI Solutions (ETL, Reporting & Dashboards) using Power-BI, Tableau, SSIS, SSRS,SSAS Tabular,T-SQL, Programming for various business applications and ...

·         Experience in creating interactive dashboards & analyzing and visualize the data by using Power BI and Tableau.

·         Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and Power BI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.

·         Created various types of charts like Pie Charts, Bar Charts, Tree Maps, Scatter Charts Map Charts, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau & Power BI to provide better data visualization.

·         Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.

·         Highly experienced in creating scalable and reusable ETL process using SSIS, Extracting and Transforming data (ETL) from various heterogeneous sources.

·         Proficiency at Data Transformations, Tasks, Containers, Sources and Destinations.

·         Worked with parameterized reports, Drill-Through reports, sub reports, matrix SSRS 2008R2/2012, Crystal Report.

·         Experience in migrating, deploying the packages across Dev/UAT/Prod environment, Job creation and package scheduling

·         Experience in Stored Procedure, Functions, indexes Good understanding of RDBMS concepts and experience in writing Complex Queries, Sub queries, Co-related Sub query, CTE, Views.

·         Comprehensive knowledge in Error handling and debugging coding issues and troubleshooting production problems.

·         Involved in Preparing Functional and Technical documents.

·         Have independently handled the team and have driven the project to success.

·         Experienced in Configuring on creation and scheduling of SQL server agent jobs.

·         Experience with all phases of software development life cycle (SDLC) and agile Methodologies.

·         Good at SQL Query optimization for high performance& high-volume databases.

·         In-depth working knowledge of debugging in SQL Queries.

Show More

Portfolio Projects

https://www.bioclinica.com

Project : Medical Imaging Client : Imaging USA Role : Reporting & Dashboard

Contribute

· Working as Logi Reports, Power BI Reports developer. · Working with Power BI Reporting & Dashboard Designing team. · Good hands on experience on sql server stored procedures development and enhancem

Description

Description

Our therapeutically aligned team delivers Operational expertise necessary to successfully design and manage your clinical trials with best-in-class operations, centralized image assessments, and global data management. We work together with sponsors and sites to capture and skillfully analyze imaging endpoints and deliver the highest quality data for your eligibility, safety, and efficacy studies.

We provide global support for clinical trials through the use of SMART, a full suite of medical imaging services backed by proprietary, leading-edge technology. Bioclinica’ s SMART digital customer portal allows sites and sponsors to benefit from real-time access to their trial data for quicker go/no go decisions.

This team deals with various types of reports that includes Excel reporting, Logi reports, Power BI Dashboards.

Show More Show Less

https://www.cisco.com/c/en_in/index.html

Project : WW DISTI CISCO Client : CISCO USA Role : ETL & Dashboard Developer

Contribute

· Worked as MSBI development (tools like SSIS). · Worked with Tableau reporting & Dashboard Designing team. · Involved in ETL & Tableau dashboard development. · Good hands on experience on sql serve

Description

The WW Distribution Strategy & Planning team in collaboration with WW Finance and GBS BI has created a true SSOT. Distribution data mart and is the most widely used data source in Distribution today. The WW Disti team within Cisco focuses on analysis, design, development and production of reports for various Theaters/Functions. WW Disti team handles complex reporting requirements of worldwide distributors, these reports form the basis of all forecast, commits calls for client and facilitates decision making.

This team deals with various types of reports that includes Excel reporting, Tableau Dashboards.

Show More Show Less

https://www.laureate.net

BI Developer.

Contribute

• Involved in ETL processes to load Fact and Dimensions tables. • Involved in ETL testing for various data files. • Involved in package configuration and job scheduling. • Involved in daily ETL suppor

Description

Laureate is a group of universities spread across the globe. ETL process is a complicated system that is scheduled to runs over the night so that the Reports are available for the business in the morning. We support the team from off-shore during the ETL run and also develop and test the ETL packages.

I was the part of Laureate Migration team. And we migrated SSIS Packages from version 2008 into 2012

Show More Show Less