About Me
#Professional experience as a data analyst/engineer.
#Experience in data cleaning, data analysis using sql ,python pandas and developing & optimising Tableau dashboards for visualization.
# Experience in Oracle 11g ,mysql including p...
Show More
Skills
Development Tools
Programming Language
Database
Operating System
Web Development
Others
Portfolio Projects
Company
Enterprise datawarehouse
Description
#worked on enterprise data warehouse (EDW) .
#to accomplish the target of the project tableau, python pandas and sql had been used.
# project named as campaign datawarehouse used for analysis & reporting of data for android applications.
# project was all about to analysis of trends and patterns among users by unifying data coming from multiple campaigns and survey files.
# based on these patterns and data analysis, visualizations reports had been generated.
#performed source data cleaning, joining of related data sources,sorts, filter,extracting favorable information and adding table calculations to match business requirements using tableau .
#developed & optimized Tableau dashboards.
Tools
TableauCompany
Datawarehousing for payments and invoice
Description
#worked for telecom company which required data warehousing solutions for payment and invoice .
#to accomplished the project unix shell scripts ,Oracle,IBM datastage tool was used.
#datawarehouse was built on entity relationship methodology where star schema was used to store the data.
# worked in agile environment in a datawarehouse management team.
# performed requirement gathering and translation of functional requirement to technical design.
# created parallel jobs in IBM DataStage to extract the data from the files and load it in the data warehouse.
# testing of loaded data and other data quality checks.
# performed performance Tuning of SQL queries.
#performed bulk data loading from excel sheets to Oracle tables.
# wrote unix shell scripts & scheduled them as cron jobs.
#git was being implemented for versioning.
Tools
Datastage