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.

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.

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 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.

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 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.

The Client is one of the largest digital marketing company in USA and wanted to track their business across USA. The client is having many sources of data including MDS, MIND, Web Services,Google and MSN API etc.

The Client is having a chain of liquor stores across USA. He has SSRS reports developed on top of SSAS cube. These reports have been developed by our company and now it is in support. These reports help the management to take business decisions and overlook of whole business.

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.

The client is having a real estate business across USA and using a .net application developed by our company. He wanted to migrate his old system backend database which is in MS Access to SQL Server 2008 R2 so that the new .net system can consume it. The source access database is in separate access files according to locations. He wanted a one click conversion of all the database files into single SQL Server db.

This client is from health care domain and medicine production business. Client having a Share Point website developed by our company where he can monitor status of his projects. To ease this process, he wanted some SSRS reports on top of it by using their backend SQL server 2008 r2 db.

A company based in USA was about to launch their own product which was capable of doing ETL and Cube management like BIDS. The client is also having an excel add in where a cube can be browsed as pivot table. They wanted to test the different tools thoroughly for its advanced capabilities over BIDS.

India based client wanted to develop a product which will be installed and used by the fitness industry organization and helps to maintain and track their business revenue including gym members fitness data and reporting based on the gym member health and gym track record.

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.

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.