Data Analyst Developer

Oshin Chetule

Dallas, TX ***** 469-***-**** *****.*******.**@*****.*** LinkedIn Tableau Profile Business Intelligence Data Visualization Tableau SQL ETL Business Analytics graduate with three years of experience on several Business Intelligence tools. A Data Visualization Enthusiast with a persistent passion to learn and explore new technologies. EDUCATION

The University of Texas at Dallas, Richardson, TX May 2020 Master of Science, Business Analytics GPA: 3.56/4 Rashtrasant Tukadoji Maharaj Nagpur University, India June 2015 Bachelor of Engineering, Electronics Engineering GPA: 8.84/10 CORE COMPETENCIES

Languages: C, C++, SQL, PL/SQL, NoSQL, Python, R, SAS, STATA, Linux, Unix Databases: Oracle11g, MS SQL, Teradata, Netezza, MongoDB, MarkLogic ETL tools: Informatica PowerCenter 9.6.x, Alteryx, Appworx Analysis tools: SAP BO 4.1, Business Objects (BOXI 3.1), Tableau, Microsoft Power BI, QlikView, MS Excel Certifications: Tableau Desktop Specialist, Google Ad Search Certification, Alteryx Designer Core PROFESSIONAL EXPERIENCE

NTT Data Services, Plano, TX June 2019 - Nov 2019

Data Analyst Intern Business Insights Engine Development Project

• Engineered 360-degree view as an analytical solution to the business problem for Healthcare Payer Industry

• Developed 20+ Tableau dashboards for complex healthcare data using best practices in reporting and analysis

• Optimized all previously built dashboards and the current BIE user interface making them ADA compliant

• Assisted product owner to ensure the data integrity by conducting regression tests for Tableau dashboards Tata Consultancy Services Ltd., Mumbai, India June 2015 - June 2018 Business Intelligence Developer BMOTF Reporting & Analytics

• Designed 650+ analytical reports using SAP BusinessObjects 4.1 in accordance with Agile SDLC

• Performed and monitored the detailed testing of the developed Webi reports in SIT and UAT environment

• Improved the process performance up to 40% by documenting and resolving 50+ defects

• Devised daily, weekly and monthly Appworx Job chains for monitoring of data load

• Converted 100+ Oracle SQL queries to queries compatible with Netezza database Junior BI Developer GE Capital – EMEA

• Successfully migrated around 500 BusinessObjects Webi reports from BOXI 3.1 to SAP BO 4.1

• Slashed refresh time of complex reports by 20% with their performance tuning at Universe level

• Executed ETL enhancements on 30 mappings and data loads using Informatica power center

• Migrated data from Apache Phoenix database to Oracle database using manually developed SQL loader scripts ACADEMIC PROJECTS

• Google Store Database Project Cleaned Google store’s raw data using python script and created entity relationships to load its visitor data as Classes and Objects in a physical database. Analyzed the data using both SQL queries for RDBMS and NoSQL queries for MongoDB.

• TGIF’s Predictive Analytics project with SAS Devised Recency-Frequency-Monetary (RFM) model in SAS enterprise and analyzed different customer segments to boost the sales of a restaurant chain. Performed Price Elasticity to suggest strategies for pricing and discount.

• Google Ads Marketing Campaign for Rookiedeck.com Conducted marketing campaign for rookiedeck.com using Google Ads account resulting in 16.26% of Click Through Rate with 35,523 impressions accounting 5,777 clicks.

Contact this candidate