Year | Project Name | Description |
2016-2020 | FCS Analytics | Complete BI Solution for FCS products, including web based etl (SSIS/SSAS/Windows & Web Service) , open source visualizations and Cube based on DW Model |
2019 | Predictive Model | Predictive model to predict expected time required to complete a Guest request based on Time, Skill and room occupancy. |
2015 | Audience framework | SQL & SSIS to automate Contact audience tracking structure by defining job title, Role and level from database |
2013 | ETL Automation | Developing & scheduling SSIS application to manage data transformation of huge files in multiple chunks and pre and post load QA verification. Migration of SSIS jobs to Informatica |
2011-2013 | Inhouse CRM | A web based application to manage end to end campaign activities divided into various modules like: Accounts, Locations, Contacts, Campaigns, Products, Cases, Reports, EDM templates with very rich user friendly campaign module (including web campaign) |
2013 | Data Parsing Application | Application automate data maintenance activities like data cleansing & formatting with different information domain like Company name, Email, Address, City, State, Contact name , designation, job title & etc. Managing different views of centralized Master data for different clients w.r.t to Segmentation, Classification and Business region and relationship attributes |
2010 | Campaign Response Cell | Windows application to Capture and manage responses and execuet post campaign activities like: response management & lead generation with campaign with dynamic field’s option |
2009-2010 | CDC | ETL & DW |
2006-2009 | Various Apps | TPMS, Excel Automation, Login Logger, File Splitter |