Data Analyst

TARUNDEEP.S. CHOWDHARY

469-***-****; adlk20@r.postjobfree.com www.linkedin.com/in/tarunchowdhary

IT consultant with 8 years of experience in implementation as well as support projects. Good knowledge of Databases, ETL, Business Analysis, Dashboards, ERP, Project Management and Data warehouse. EDUCATION

The University of Texas at Dallas May 2017

M.S. in Information Technology and Management GPA– 3.81 University of Mumbai, India June 2011

B.E. in Computer Science

BUSINESSEXPERIENCE

Convr Inc.

Project Analyst Nov 2018 – Present

Created schema design and business logic for loading into MySQL database and analyzing the data for P&C insurance companies

Aggregated the ingested data from disparate sources, curated the data and loaded the data into Elasticsearch

Performed validation, cleaned and cleaned scraped data from external sources using Python libraries such as Pandas, Numpy to help data scientists build different models

Create dashboards on Metabase and Influx dB to predict business details scraped from different sources based on different KPIs

Defined business objectives and tracked progress to ensure project milestones were completed on time with the desired results.

(Environment: Python, MySQL, Elasticsearch, Metabase, Influx dB) Omni SourcingInc. (Client: ATT)

Data Analyst Sept 2017 – Oct2018

Performed source system data analysis, mapped database schema in K2view ETL tool to manage Master and Transactional data

Created measures and dimensions using K2view fabric studio and ADI tool to create different user reports as per user requirements

Deployed the standalone applications using K2view fabric server from source environment to the target environment

Participated in technical oversight, decision making, and solutions delivery to streamline data across environments

Integrated K2view tool to different data sources i.e. Teradata and Sybase and installed necessary jar files as per the database

Worked on Mongo DB installation, troubleshooting, performance, back-up and recovery on Linux platform in cloud system

Automated the Web Application testing using Selenium scripts in Python for various test scenarios which gave reliable results and reduced time for testers

Coordinated with the different application team and analyzed the data flow between 650 tables for consumer applications

Maintained the status sheet to track the defects of all the applications and documented the defects for the team which helped in improving the resolution time to resolve the defect

(Environment: K2view (Fabric and ADI), Mongo dB, SQL Server, Python (Pandas), PowerBI, Selenium, Linux, Freshdesk) Innowera LLC

Business Solution Engineer Jan 2017 - Sept 2017

Created Business rules, designed E-R Model, modified database tables using SQL queries to optimize the database system

Prepared design documents for the Process Runner too l which interfaces with SAP system to produce results in the excel template based on user’s configuration and delivered solution using SAP technology

Performed data validation & manipulation using Macros, VB.net and excel formulas in Process runner tool as per client’s requirements and worked closely with the technical team on the design

(Environment: SAP, Process Runner, Advanced Excel, SQL Server, Tableau) Cummins Inc.

IT Business Analyst Intern May 2016 - Dec 2016

Facilitated daily meetings for the Web Commerce project and worked as a Salesforceadmin for automation of Parts Ordering system in Japan region

Created user stories tested the application including functional, regression, user acceptance based on test cases assisted in the go-live and support for Dealer Commerce project

Exhibited expert knowledge in data queryingusing SQL, collaborated with multiple teams for database design activities

Enhanced internal application that improves the dealer score using agile methodology and assisted in maintaining the project documentation and worked on design using Visio for Distribution Portal project

(Environment: SQL, Salesforce, Jira, Visio, Movex) Infosys Technologies

Technology Analyst

Developed few mass data upload programs in SAP system from legacy systems using Data Migration Techniques like LSMW,BDC

Interacted with client and prepared a gap analysis document by comparing the client requirements with our original report

Analyzedfactsand dimensions to identify business critical KPI’s and implemented Tableau dashboards to track performance. (Environment – SAP ABAP, Tableau, SQL Server) Mphasis Limited (Client: American Airlines) Sept 2011 - Feb2015 Software Developer

Worked on SQLServer database for a healthcare company to retrieve the employer’s benefits and compensation information

Designed an inbound interface in SAP which fetch data from mainframe system to retrieve payroll data for the auditor

Worked to effectively combine the vision of clients with in-house wireframe designers to provide clear design specifications

Assisted with modification of the code, performance testing, troubleshooting and application performance issues

Developed few mass data upload programs from legacy systems or flat files using data migration SAP techniques

Developed an interface to display and change Personal details, Address details, Staff Details for airline industry

(Environment: SAP ABAP, SAP Security, SQL, Tableau) ACADEMICPROJECTS

Analysis of USUniversitiesviaTableau Jan2017-May2017

Analyzed dataset of 1000 records and predicted the earning potential of students over a period of 10 yearsusingGRE/SAT

Used power view and ranked schools based on academics, earnings size, tuitionw.r.t. average SAT scores, also portrayed the results using line graph, bubble chart, heat maps etc. Airbnb Booking Data Analysis Aug 2016 - Dec 2016

To analyze in which country a new user's first booking destination will be through Airbnb through Statistical Analysis System (SAS) Enterprise Miner

LEADERSHIPANDACHIEVEMENTS

Awarded Monthly Summit Awards for the excellent performance in the project

Participated in White paper Presentation on Improving Data Quality in SAP Systems organized by Mphasis Limited

Conducted training sessions to team members during my tenure at Infosys Technologies TECHNICALSKILLS:

Languages: ABAP/4, Java, C++, SQL, PL-SQL, R, Python, HTML

Tools and Technologies: SAP ECC 6.0, Oracle11g, MongoDB, SAS Enterprise Miner, SAP BOBJ, Tableau, Process Runner, Salesforce, QlikView, Lumira, Crystal Reports, Power BI, K2view, Metabase

Project Management: MS PowerPoint, MS Excel, MS Visio, Requirement Gathering Analysis, Rally

Certifications: UT Dallas/SASData Mining and BI, SAP University Alliance

Contact this candidate