Deepak Jain 22

pune, Maharashtra, India

Yearly Stats: $0 Earned |

Data Analytics and Data Warehousing Expe

9+ years of in-depth experience in Data Analytics and Data Warehousing in E-Commerce, Error and Change Management, FMCG, Semiconductor, Instore and Telecom domain
?Expertise in leveraging the data to build models to measure and improve Performance Management, Error and Change Management applications using Dashboards, Reports and user driven solutions.
?Expertise in Business Intelligence Applications using Tableau, Cognos , Qlikview, Microstrategy in Marketing, Sales, Procurement modules.
?On-Site/Off-Shore experience of working with different business groups and cross functional teams to manage and deliver Analytics/Decision Making and Data Warehousing solutions.
?Experience in developing analytics, metrics measurement requirements and providing periodic reports & suitable outcomes to business with ability to make consensus decisions and resolving ambiguities.
?Experience in full BI implementation cycle from installation and configuration of BI Tools, freezing client’s requirement, designing ETL, cubes & data models, developing reports/dashboards.
?Extensive experience on Enterprise Reporting, Cube Analysis (MOLAP), and Adhoc query (ROLAP) & analysis, Statistical Analysis & Mining and Report Delivery &Alerting.


Sr BI Architect at AbsolutData Analytics, Gurgaon July 2014 – Current
?Experience with dimensional modeling and architecture experience implementing proper data structures for analytical reporting from different data sources.
?Performing data integration for data warehouse applications. Creating star and snowflake schemas and implementing them in Cloud BI solutions for BIRST, Qlikview, Microstrategy, Tableau, PowerBI, Cognos 11
?Installation and configuration of the tools like OBIEE, Microstrategy, Cognos, Qlik Sense is successfully done.
?Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables.
?Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
?Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data. Developed BI Consumer reports using BI tools.


Sr BI Programmer at Accenture Solutions Private Ltd Feb 2013 – Aug 2014
?Conceptualizing dashboards and analytical models to derive insights using dashboards and developing POC accordingly.
?Providing Solutions capable of assisting higher management in decision making, Business Discovery, Data Management system and Business Research using different BI tools Cognos, Tableau, R, POWERBI etc.
?Leading team to ensure end to end implementation including all phases of BI/DWH in traditional as well as cloud BI solutions.
?Experience in developing analytics, metrics measurement requirements and providing periodic reports & suitable outcomes to business with ability to make consensus decisions and resol

$15 / Hour
$30,000 minimum budget