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 MoreSkills
Programming Language
Data & Analytics
Database
Web Development
Others
Portfolio Projects
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 LessCompany
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.
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.
Tools
Spotfire Python SQL Server 2012Company
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 LessTools
SQL Server 2012Company
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.
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 LessCompany
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 LessSkills
Python SQL Server 2014