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.

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.

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.

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.

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.

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.

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.

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.