Prakash's portfolio (Data Architect: Business Intelligence & Data Professional)

About Prakash! as on December,2020

Year Project NameDescription
2016-2020FCS AnalyticsComplete BI Solution for FCS products, including web based etl (SSIS/SSAS/Windows & Web Service) , open source visualizations and Cube based on DW Model
2019Predictive ModelPredictive model to predict expected time required to complete a Guest request based on Time, Skill and room occupancy.
2015Audience frameworkSQL & SSIS to automate Contact audience tracking structure by defining job title, Role and level from database
2013ETL AutomationDeveloping & 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-2013Inhouse CRMA 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)
2013Data Parsing ApplicationApplication 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
2010Campaign Response CellWindows application to Capture and manage responses and execuet post campaign activities like: response management & lead generation with campaign with dynamic field’s option
2009-2010CDCETL & DW
2006-2009Various AppsTPMS, Excel Automation, Login Logger, File Splitter