- An accomplished Data Engineer with 14+ years of experience, specialized in building warehouse and analytical systems with extensive experience in the full life cycle of the software design process including software requirement definition, design and architecture, prototyping, coding, proof of concept, ETL implementation, testing and maintenance.
- Design and Developed analytical and data warehouse systems.
- Developed multiple big data systems using big data solutions.
- Developed Risk attribute algorithms using analytical models and organizational of machine learning models.
- Design and deployed multiple tabular and multi dimension models.
- Developed multiple dashboards using Power BI and created multiple APPs from dashboards.
- Developed database replication in different datacenters and implemented failover cluster.
- Developed system using different azure components like azure run books, key vaults, azure storage accounts, app services, Application insights data, etc.
- Developed service for monitoring the health of machines and alerting.
- Developed data monitor dashboards to look at Accuracy and Consistency of data loads.
- Developed Proof of Concepts and validate facts to eliminate technical risk.
- Developed Azure database elastic pool architecture to better performance and reduced the cost.
- Developed microservices to support proactive risk analysis systems.
- SQL Server
- SQL Server Integration Services
- SQL Server Analysis Services
Sr. Software Engineer
- Design and Developed product on retail intelligence system.
- Design the warehouse system to support the intelligent system.
- Developed ETL framework to consume data from the different sources.
- Design the multiple reports to present intelligent system data.
- Design the multiple multi - dimensional cubes to support huge data and multiple reports.
- Developed the dimensional model to support to build ad-hoc reports using report builder.
- Implemented market basket analysis to support sales
- Implemented multiple modules like Performance Management, Merchandise Analytics, Store Optimization, Sales Analysis, Marketing analytics and Inventory based on annual, quarterly, monthly, weekly, and daily.
- Designed and developed domain model for application. Designed logical model for database.
- Designed and developed user login and administration modules.
- Worked on application to enable users to build and configure specific category of equipment in application and order them. Support for online and offline mode was required.