Atul Verma

 Atul Verma Mobile No: - Experience Summary 8+ years of in-depth experience in Data Analytics and Data Warehousing in E-Commerce, Hospitality, FMCG, 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 Oracle Business Intelligence (OBIEE) 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. BI Lead at Rawmind July 2014 – Current Experience with dimensional modeling and architecture experience implementing proper data structures for analytical reporting from different data sources. Design and architect the data warehouse for different clients based on the inputs and taking considerations like performance, data availability, integration of data points from different OL’s. Database and Data Warehouse designing and migration from relational databases (like Oracle, SQL Server, Postgres) to NoSQL databases (like HBase, Cassandra ) and Hadoop (HDFS) ecosystem. Performing data integration for data warehouse applications. Creating star and snowflake schemas and implementing them in Cloud BI solutions for BIRST, Tableau, OBIEE, Qlikview 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 OBIEE 11g, BIRST, Tableau Sr BI Programmer at AbsolutData Analytics, Gurgaon 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 Tableau, Qlikview, R, OBIEE 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 resolving ambiguities Designed advanced approach to synchronize measures based on preceding metrics and developed transformational model using OLAP inputs and schema for Input Measures. Involved in understanding the reporting requirements and providing reporting solutions. Sr BI Developer at Accenture India Pvt. Ltd, BangaloreSep 2010 – Jan 2013 Participated in metric-formulation and design of metrics to measure the Business User expectation and appropriate product road map maturity. Led the deep-dive/ root-cause analytics & strategy initiatives for identifying and tracking the Project Development phase analysis. Defining, developing and tracking KPIs for products and assisting management team in product progress analysis. Carry out analysis of the given data and draw correct inferences, in keeping the objectives of the analysis, Trend Analysis, Comparative Analysis BI Developer at Cognizant Technology Solutions, Pune Nov 2009 – Sep 2010 Participated in ETL data architecture to ensure availability of data on Daily basis and re-engineered their ETL solution framework. Participated in development of ETL model of data staging and transformation and further loading. It includes developing transformations and jobs for data extraction, transformation and loading. Designed advanced approach to synchronize measures based on preceding metrics and developed transformational model using OLAP inputs and schema for Input Measures. Led to design an advanced approach to synchronize measures based on preceding metrics and developed transformational model using OLAP inputs and schema for Input Measures. Defining the metrics for Performance Tracking, Summary, Profile reports and ensuring the development in line with the specification as expected to business customers. Software Engineer at Ebusinessware, Gurgaon Jun 2009 – Nov 2009 Availability management for performance and service health check reports using BIRT and OMEGA application server coordination approach. Application monitoring and implementation of new features accounting for the revenue generation and track management of value added services. Data Analysis to provide the comparative understanding of different aspects of VAS for enlisted services and to support them in decision making Skill Sets Programming Languages: SQL, MDX, SHELL Script, JAVASCRIPT, VBS Tools: Google Analytics, PENTAHO, Oracle OBIEE, MySQL, PostgreSQL Star/Snowflake Schema (Dimensional Modeling), Excel, Qlikview, BIRT, Tableau, BIRST, GoodData, Cognos, PowerBI, Micrsostrategy Web Analytics: Predictive Analysis, Turnaround Analysis, Change Convergence, Segmentation Business Intelligence: ETL, OLAP Modeling, Actionable Dashboards, Reports Educational Qualifications B. TECH from YMCA Institute of Engineering, Haryana, INDIA 2005 –09 Projects – Rawmind Competitive Intelligence for Brand/Retailer (Big Data, Oracle, BIRST) Develops a business intelligence and analytics platform for retail brands selling via traditional brick-and-mortar merchants Developer the Birst model based on Star schema and Snowflake design model. Providing post-implementation, enhancement & maintenance support for application. Provided ongoing support related to BIRST dashboards and optimization of existing reports, dashboards and metric formulation including technical expressions. Maintenance and performance tuning of reports and resolving issues for BIRST. YouTube Analytics (T-Series: Hadoop, OBIEE, Oracle) Lead the development team responsible for building the application Design the overall Hadoop architecture and the toolsets for data ingestion, processing & reporting Develop pig, hive based aggregation scripts on the Hadoop platform to crunch large volume of information to arrive at insights Development of data warehouse in Oracle. Design OBIEE reports & visualization for presenting the song analysis and earnings dashboard Enterprise Information System (Fishbowl: Tableau, Hadoop, Oracle) Understanding requirement and designing the solutions for various sections of client's business. Database and Data Warehouse designing and migration from relational database Oracle to NoSQL database (like HBase) and Hadoop (HDFS) ecosystem. Developed complex logical expressions to implement business requirements and guide team to establish standard practices for preparing sustainable framework. Data blending to create views combining data from multiple data sources, connecting and extracting data from multiple data sources Integrated data available in Hadoop (MapR Drill) and perform analysis in Tableau An improved user experience, especially for the initiator of the process, with provision of on-screen help and user friendly reporting system. Checkout Optimization (Tesco’s) (PowerBI) Checkout is the area of a supermarket where the tills are, with their accompanying assistants who takes the cash in the respect of goods In the supermarket, all tills are not fully utilized may be few tills are occupied and some are not. Analyze the whole process of Tills and write an algorithm to calculate the efficiency of each tills Developed an algorithm to calculate checkout optimization efficiency. Projects – AbsolutData Analytics Global Guest Data Mart Development: Carnival Cruise Lines Interact with Client and different stakeholders from different operating lines and freeze the client requirement for data mart Design and architect the data mart based on the inputs and taking considerations like performance, data availability, integration of data points from different OL’s Developed ETL process and delivered it successfully with achieving the performance of system. Developed and designed the algorithm for the Global user identification ID for guest travelling in the different OL’s. Managed 120 TB of data and integrated data from Campaign, Guest Profile, and Loyalty, Email Response, booking and Revenue. Lead team of 15 team members from CRM, BI team to deliver the project Technologies used: Oracle 11g, OBIEE , ODI BIRST Cloud BI Understanding requirement and designing the solutions for various sections of client's business. Developed complex logical expressions to implement business requirements and guide team to establish standard practices for preparing sustainable framework. Provided ongoing support related to BIRST dashboards and optimization of existing reports, dashboards and metric formulation including technical expressions. On site development in collaboration with client to design actionable metrics & KPIs and incorporated the accepted technical solution in agile manner. Tableau Visualization Interaction with data management team to understand the requirement and conceptualize them into measurable KPIs that helps higher management in decision making. Developed data model in Tableau using data blending of different sources to produce desired data for technical implementation of business formulas. Designed Dashboards and drilled reports which provides real time information about mining sites and trucks involved between sites for regular movement. Data Quality: AstraZeneca Identify the algorithm for the inconsistent or incorrect data points reported in database for different sources. Identification of exceptions by defining quintiles using Standard deviation and other statistical functions Development of the exceptions reports using SSIS, SSAS, SSRS and Excel. Developed basic macros through excel VBA Projects – Accenture India Pvt. Ltd SalesForce.com Integration with Cognos: Reports are developed based on the details imported through SFDC. Requirement study and interaction with SFDC team has been done to identify the report details functionally. IBM Virtual View Manager is also being used to interact with SFDC package. Spd eMIS: This project provides the daily, monthly report details related to primary sales, manufacturing & sourcing reports, marketing reports, financial reports and RASP reports. Data Source: Oracle 10g, SAP, SQL Server, Excel, DB2 ETL: SSIS & OLAP: Cognos Transformer, SSAS Cognos 8.4.1 BI used for developing relational & multi-dimensional reports with drill up/down feature, column freezing, conditional styles, render variable, prompt page reporting etc. Cognos Report studio, portals, Analysis Studio and Metric studio are used to define the different types of reports and dashboards. Secondary Sales Analytics: This project is the provides the monthly analysis of secondary sales made by organization across India at outlet – brand pack level details SSAS Cube is developed which handles around 140GB size of data with around 30 dimensions and 16 measures. Calculated measures and dimensions are developed using MDX queries. Roles are defined to define & restrict data access at data level. Tableau reports are developed for dynamic reporting and static reports developed in report studio. Performance optimization of Cube and reports are done which were certified by Microsoft. SMILE Integration: Understanding the function requirement from client and defining the process of integration of independent 3rd Party application SMILE with Tableau reports. Developed the ETL process using SSIS which perform the extraction of details from SMILE server and load into Client’s domain Designed and developed Cubes using SSAS which used for analytics purpose. Projects – Cognizant Technology Solutions Lloyds Banking Group Understanding the business process for Implementing Models in Framework Manager. Developing the FM model using dimensional modeling. Developing Advanced reports using Report studio like Cascading prompts Creating complex reports with the functionalities like prompts, conditional blocks, conditional variables, drill through, render variables, master-detail Unit testing of the reports. Involved in deployment activities after successful completion of UAT. Created Query Prompts, calculations, Filters Projects – Ebusinessware, Gurgaon Executive Information System (AIS Glass Solution, India) Worked at Client location: AIS Glass Solution & developed various types of reports like detail, summary, drill through and master-detail reports in Cognos 8.4. Developed IT dashboard which provides details from different type of data sources like SQL server, excel. Developing prompt pages and cascaded input prompts to display the only the selected entries in the report. Extensively worked with Condition explorer and query explorer in Report Studio