Deval Jain's Email

▪ Over 7 years of experience as Business Intelligence and Data Ware housing specialist ▪ Certified Data Analytics professional from University of Cincinnati ▪ Proficient in development of reports using Business Objects, Microsoft SSRS, Microsoft Excel and Crystal Reports. Dashboard using Xcelsius ▪ Expertise in security setup among groups, categories, users and successfully implemented windows authentication, single sign on among single and multiple Domains ▪ Good experience in CMC and CCM in BO XI R3.1/R3/R2 ▪ Proficient in Data Analysis ▪ Proficient in testing the reports ▪ Proficient in creating BI Handover documents ▪ Skilled communicator with ability to communicate with people at all the levels ▪ Sound knowledge of Data Visualization tools Microstrategy, Spotfire, Tableau, Qlikview etc. ▪ Highly motivated and passionate for working with data, creating visualizations and dashboards ▪ Sound knowledge of ITIL ▪ Proficient on working on Unix environment ▪ Exposed to SAP HANA

Senior Report Developer @ Roles and responsibilities: ------------------------------------- ▪ Reduced considerable cost and efforts by automating reporting in support of a high performing operations team using various reporting forums on top of an SAP solution (BI, BW, BEx, BOBJ) SQL, Oracle and MS Access ▪ Developed various operational reports such as enrollment reconciliation, un-invoiced accounts report, credit and collections efficiency report, productivity report of agents etc. ▪ Ensure CPI/KPI, other operational reports are generated in an accurate and timely manner ▪ Gather requirements from various operational departments viz. Credit and Collections, Issue Resolution Group, Customer Service etc and develop automated reporting solutions to ensure operational efficiency ▪ Perform UAT for the reports developed by IT team and provide post deployment support for report validation. ▪ Generate CPI/KPI stats every week and schedule meetings for actions required for operations efficiency. ▪ Work with business process owners to resolve issues and improve operational efficiency ▪ Establish and maintain effective work procedures ▪ Perform bench marking and achievement of optimal customer satisfaction ▪ Lead development of improved service level metrics for customer operations functions ▪ Coordinate and manage multiple projects assigned by senior management, providing input on customer operations related matters ▪ Develop documentation and process flows to allow for proof and leveraging of processes ▪ Developed point based "Attendance Tracker app" in Microsoft Access From May 2014 to Present (1 year 8 months) Graduate Assistant, Business Intelligence @ Roles and responsibilities: ------------------------------------- 1) Revamp the course using lab sessions to teach tools like SAP BusinessObjects (BO) and SAP Business Warehouse. 2) Demonstrated the insights of SAP BO tools namely web intelligence and Business Explorer using case studies. 3) Conducted lab sessions for current students on creation of Data marts and Infocubes in SAP BW. 4) Currently working on delivering lab sessions for data modeling, ETL, reporting and multi-dimensional analysis using SAP BW and BO 5) Independent Study in Advanced Business Intelligence. From February 2014 to April 2014 (3 months) Consultant – Business Intelligence and Job Scheduling @ Roles and Responsibilities: -------------------------------------- • Worked with functional managers / End Users to gather reporting requirements to implement business logic for successful implementation of reporting system to satisfy the needs of Business units and Supplier partners • Implemented data warehousing schemas like Star-Schema and Snow-Flake schema • Designed and built universe, classes and objects • Resolved loops and traps using contexts and aliases while designing universes • Developed custom hierarchies to support drill down reports • Created derived tables and customized prompts in the designer • Created multi-tab ad-hoc reports using web intelligence • Coordinate and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them • Wrote complex views, functions and stored procedures using SQL, PL/SQL • Built new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections • Recommended standards of good practices of report development and maintenance of universes • Migrated BO 6.5 reports to BO XIR2 From October 2012 to July 2013 (10 months) Mumbai Area, IndiaSenior Technical Associate – Data Visualization and Report Developer @ Roles and Responsibilities: --------------------------------------- • Started as Associate SAP Business Objects developer • Interacted with Business Users and Managers in gathering business requirements • Designed universes, multi-tab reports/charts on Oracle and SAP BW using SAP BO/Microsoft Excel and dashboards using Xcelsius • Leveraged SDLC methodologies namely agile and waterfall models • Worked on implementing the LOV’s, hierarchy's, pre-defined conditions, resolving database connections, adding new objects to the universes • Created complex reports using user-defined functions like @variables, @prompt, condition Objects and aggregate awareness functions • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure • Created reports by using multiple data providers to combine multiple reports as a single report • Improved performance by reducing fetching time of data by reports hence improving customer satisfaction index • Analysed and explored reports using slice and dice and drill down functionality • Created WebI and Crystal reports based on the end users requirements and modified the existing reports based on the specifications and requirements From June 2007 to October 2012 (5 years 5 months)

Master's Degree, Management Information Systems, 3.7/4.0 @ University of Cincinnati College of Business From 2013 to 2014 Bachelor of Science (BS), Electrical, Electronics and Communications Engineering, A @ University of Mumbai From 2004 to 2007 Deval Jain is skilled in: Data Warehousing, Business Intelligence, SAP BusinessObjects Report Development, ETL, Unix, Oracle, SQL, Business Objects, PL/SQL, Unix Shell Scripting, Data Analysis, Visio, Shell Scripting, Control-M, IT Service Management