Anuj Gulati

• Involved in Data loading and data migration - Used SQL * Loader to load data from excel files from Sprint into staging table, Data Cubes and developed PL/SQL procedures to load data from staging table into base tables of Data Warehouse.  • Automated Excel and manual reports using Tableau reducing reporting time from 184 hours (1.18 FTE) to 2 hours a month • Created and executed detailed test headers and scenarios using SOAP UI for Sprint Credit Card

Data Visualization: Integrated Tableau with Python (numpy) using TabPy Engine to perform K-Means cluster analysis on Titanic dataset Prepared R assignment using ggplot (facet_wrap,) and plotly (choropleth map) to clean data, perform data analysis and visualization Business data warehousing: Performed sentiment analysis that evaluated iPad Pro and Surface Pro 4 as a possible replacement for desktop on twitter data using SAP HANA

• Analyzed historical ticket data & forecasted workforce required at Apple launch events using time series ARIMA Model on Alteryx • Created complex queries in Oracle using indexes, table partitions, procedures, views and materialized views to improve performance • Extracted data from various heterogeneous databases like Oracle 10g (legacy data) and Flat Files to SQL Server 2008R2 using SSIS

• Web Scraping Crop Insurance Rates from RMA website using Python BeautifulSoup Package and visualized using Panda Package • Migrated MS Excel Reports to Web using Highcharts.js, PivotTable.js and JSON for real time update using Agile Methodology • Automated generation and delivery of reports and procedures using MS Access Forms, VBA (DAO), SQL Server & Schedule Tasks • Developed & enhanced Crop Insurance Products Software using MS Access (ETL with Excel) and SQL Server (adhoc reporting)

• Supervised, headed and documented MS Excel Certification tutorials at Jindal School of Management, UT Dallas • Hosted intensive workshops on MS Excel (vLookup, PowerPivot, npv, xnpv functions) & VBA automation concepts with 50+ students

• Provided L2 & L3 support for web products via ServiceNow ticket handling for MSOnline and track server issues using HPBSM • Worked in 24/7 on-call IT Production Support environment with high proficiency in interacting with stakeholders in New York • Liaised between business and development team to convey the exact requirement followed by Root Cause Analysis of the existing issues, fixing them, documenting the process and reporting to the higher management

Business Intelligence Advance Business Intelligence Business Data Warehousing Data Visualizaation Introduction to Risk and Uncertainity in Business Spreadsheet Modelling and Aanaltics