Abhijeet H.

Abhijeet H.

Expert Software Engineer

Pune , India

Experience: 8 Years

Abhijeet

Pune , India

Expert Software Engineer

8 Years

Now you can Instantly Chat with Abhijeet!

About Me

I am a professional BI consultant having over 8 years of experience. 

My skill set includes MSBI full stack, Python, Power Bi, Tableau, Data Analysis, Data Modelling, Data warehousing.

I have experience in end to end development o...

I have experience in end to end development of Reporting Solutions. 

I can also work on Data entry tasks.

Show More

Portfolio Projects

Digital Marketing Domain Project

Company

Digital Marketing Domain Project

Description

The Client was leading digital marketing company in US market. We built a Dataware House cubes and reports for them using MSBI. I was acting lead of the project which was having support and enhancement teams.

Show More Show Less

Data Ingestion

Company

Data Ingestion

Description

This project is to migrate the legacy system to cloud. Pure ingestion process using tools like SSIS and informatica.  SQL as a source and Hive, Aurora,Redshift and S3 locations as a target. Some of the ingestion process is implemented in SSIS and some in Informatica.

Responsibilities:

  • Understanding the existing System.
  • Development of SSIS packages to migrate SQL objects to Hive and Redshift.
  • Getting involved actively in the architectural decisions.
  • Replicate informatica workflows in SSIS.

Show More Show Less

Ingestion Alert Dashboard

Company

Ingestion Alert Dashboard

Description

This project was initiative from my side to help our dev ops team to monitor a huge ingestion process which runs daily. This project is developed to send email notifications along with dashboard link. The Dashboard designed speaks about all the server health and Ingestion process status across the entire on going Ingestion project.

Responsibilities:

  • Understanding the existing Ingestion Framework.
  • Building an architecture for the project
  • Development of different Python scripts
  • Database designing.

Show More Show Less

SQL .Net –A product in Payment Domain

Company

SQL .Net –A product in Payment Domain

Description

This product is build to manage all the payments being done through the client systems. Through the product the biller can see all the payments made against his services  This product is actually a replacement of two different products which were getting used to manage the payments earlier by the billers

Responsibilities:

  • Understanding the existing System.
  • Modifying the existing system according to requirements and bug fixes.
  • Document the system flows and understanding
  • Getting involved actively in the architectural decisions.

Developing complex stored procedures to support .net application and payment processing.

Show More Show Less

SSIS,SSRS,SSAS,EXCEL – A client based out of USA

Company

SSIS,SSRS,SSAS,EXCEL – A client based out of USA

Description

The Client is having an energy drink production business across USA. He is having his tabular reports of the business in excel format. He wanted SSRS reports replicating the excel data. We have written some macros and transformed the excel data in proper rows and column format.

Responsibilities:

  • Understand the existing Excel system data.
  • Pulling the excel data into SQL database.
  • Creating a DW in two tier architecture (SCD2)
  • Developing a cube in SSAS.
  • Developing SSRS Dashboard on top of the SQL CUBE and deploying them in client environment.

Show More Show Less

SSAS (Tabular)/SSIS/SQL/SQL Report/ Server Management

Company

SSAS (Tabular)/SSIS/SQL/SQL Report/ Server Management

Description

This project is to build the tabular cube based on the various data coming from different sources and maintain the cubes. Monitor daily Job runs, do support activity. We are currently in transition phase for this project.

Responsibilities:

  • Ownership of 7 SharePoint (Source) projects and 3 SSAS Cube Solutions and 3 SSIS solutions along with SQL /SSAS/SSIS servers.
  • Working with minimum information provided from the other vendor.
  • Scheduling KT meetings and asking the questions regarding the echo system to get exact information needed for Support activity.
  • Get the knowledge of the system without environment access permissions, based on KT calls and documents.
  • Getting involved actively in the architectural decisions.
  • Look after Daily job runs.
  • Give/Suggest Quick fix for P1 and P2 incidents on the Production
  • Work on optimization plans for the cubes and SSIS processes
  • Be an individual contributor in planning and handling the Project.

Get involved in new requirement discussion meetings and provide estimations for the BI part(SQL/SSIS/SSAS) on top of it.

Show More Show Less

Service Now Syncing with SQL server database

Company

Service Now Syncing with SQL server database

Description

The project is developed to conect the Service Now back end data base using Table API that they have provided using Python. Read the data from Service Now and write into SQL server. This project was way faster than the legacy odbc driver to read the data from Service Now.

Show More Show Less

PureCloud Integration with SQL server

Company

PureCloud Integration with SQL server

Description

We had a call center tool PureCloud in our organization. The goal of this project is to do adhoc reporting on the data generated by the tool. The project development is still in progress.

Show More Show Less