Over all 5+ years of experience in PowerBI, SQL,PL\SQL,ETL Tool - Talend,Snowflake.
Adapting multiple roles like data analysis,data modelling, software development for the Mantys Application.
Responsibilities:
Collecting data from multiple sources like Hubspot, Salesforce,Quickbooks, Zohobooks, Stripes etc and transforming those data using DBT and applied multiple types of data modelling based on the customers inputs and created multiple marts for creating analysis and reports on top of the modeled data.
● Created PowerBI Dashboards, Quicksight reports in Medtronics, Needlenine and IdeaRX Team which helped in giving clear insights to the clients and provides appropriate business solutions.
● Worked in Snowflake project for capturing bot status and writing sql queries to create a workflow in storing a data in Snowflake data warehouse
● Experience in writing complex SQL,PL\SQL queries in oracle databases.
● Experience in creating ETL jobs and also scheduled it based on the user's requirement.
● Automated and scheduled more than 170 reports in ETL tool.
Project Summary:
Projects in Ideas2IT:
Project 1: Needlenine (June 2022 to Tilldate)
Worked on Creating dashboards for the Needlenine clients Based on the requirements and embedded the same in the Third Party application using the powerBI Embed version.
Reports List:
● Instructor Insights
● Course Insights
● Summary Reports
● Hours Reports
Responsibilities:
● Analyzing the business requirements from the client and working on delivering the output with in the TAT
● Taking responsibility of the project from the scratch
● Generating the query and fetching the data from AWS(RDS) Database ● Integrating Power with AWS and fetching the data
● Creating the visuals based on the clients requirements and the data ● Integrating the Dashboards with the Needlenine Web
application(Embedding the dashboard)
● Validating the data in the PowerBI
● Providing Post production support to the clients.
Technical Stack: PowerBI, SQL Queries.
Project 2: IdeaRX (Nov-2022 to May 2022)
Worked in Multiple projects in PowerBI which are listed Below. Created dashboards for Hospital and Manufacturers data.
Reports List:
● Sales Trend
● Purchase Trend
● Inventory analysis
● Top 10 Margins
● Multicurrency Dashboards
● Multilanguage Dashboards
● Alert mails Triggering for the dashboards exceeding the thresholds
● Email Integration with PowerBI
● Whats App integration with PowerBI
● Implementing RLS - Row level Security.
Responsibilities:
● Analyzing the business requirements from the client and working on delivering the output with in the TAT
● Creating the data models for the projects and analyzing the data.
● Loading the data from excel or connecting to the MYSQL Database to load the data.
● Generated SQL queries to fetch the data from database and loading the same in PowerBI to generate Dashboards
● Post generating dashboards checking the values with the query result sets
● Publishing the data to PowerBI service and sharing the same to the clients.
Technical Stack: PowerBI, SQL Queries.
Project 3: Simitree project (Aug 2022 to Oct 2022) :
Created workflow in snowflake for capturing bot status for simitree clients in snowflake data warehouse.
Responsibilities:
● Gathering and understanding business requirements from the clients.
● Created flow to move data from S3 bucket to Snowflake warehouse.
● Created API queries to generate data which is later used for creating alerts for the bot status using front end tools.
Technical Stack: Snowflake.
Projects in CAMS (SQL Programmer):
Project 1: Webservice log Automation (Aug 2019 to Jun 2020)
A log table is capturing all the success and failure attempts made by the end user.
We have generated an alert for the failure attempts and the alert has been sent to the user three times a day with the hierarchy.
Responsibilities:
● Gathering and understanding business requirements from the clients.
● Built dynamic jobs to generate alerts in ETL.
● used sql queries inside the Talend tool to enhance optimization.
Project 2: Pan-Aadhar Linking (Jul 2020 to Dec 2020 )
We have been maintaining a master table for all the investors which contains a pan column.The outcome of the project is to get the pan of the newly arrived investors (i.e getting the incremental data on a daily basis) which has to be shared automatically to the SEBI and AMFI.
Responsibilities:
● Used the SCD techniques to get the newly arrived data referring the historical data
● A flow has been created in the ETL tool to share the incremental data to the end users
Project 3: SIP Universe (Jan 2021 to Jun 2022)
The concept of this project is to create a single data warehouse for the SIP investors to get the data to the reporting platform on a monthly basis which is then shared to SEBI and AMFI
Responsibilities:
● Creating a data warehouse for maintaining the historical and incremental data
● Data from many tables and databases has been clubbed together and has been stored in the datawarehouse for the reporting purpose.
● Created a dynamic flow to get the data on the incremental basis
Ad hoc requests :
Apart from these projects we have worked on a lot of Ad hoc requests to provide data to the clients,management teams,SEBI,AMFI.
Worked as a customer service executive in the Hospital domain - US clients
Worked as a customer service executive for the providers office
Visualization Tool: PowerBI, Quicksight, Tableau
Programming: SQL, PL\SQL
Tools: ETL - Talend
DB/DW: Oracle, Snowflake, Redshift, Postgres
Language: Python(Basics)