RDBMS, SQL SERVER, Data analysis

Kishore Bharathy

469-***-****; *******.********@********.***

https://www.linkedin.com/in/kishorebharathy

EDUCATION

The University of Texas at Dallas Aug 2017

M.S., Information Technology Management GPA 3.51

College of Engineering Guindy, Anna University May 2014 B.E., Computer Science and Engineering GPA 3.65

TECHNICAL SKILLS

Databases: SQL Server 2014/2012/2008 R2, MySQL, Oracle. BI & ETL Tools: Microsoft BI stack (SSIS, SSAS, SSRS, Power BI), Tableau, Microstrategy. Programming: R, SAS, UNIX, Powershell, Python, Java. Software: MS Visio, MySQL Workbench, SSMS.

Big Data: Hadoop, Hive.

TECHNICAL EXPERIENCE

National board of Medical Examiners, Philadelphia

Business Intelligence Intern May-2016–Aug 2016

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Involved in creating SSIS Packages to migrate data from flat file, excel, OLEDB and other sources to Database using SSIS 2012.

Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Indiaproperty.com, Chennai, India

Data Warehouse Engineer May-2012 – Jun-2015

Developed data models, ETL packages, OLAP cubes, and reports utilizing Microsoft BI stack applying best practices through agile development lifecycle.

Implemented Data warehouse (table sizes greater than 200 GB) from website log files with ETL best practices using SSIS on Data modelling techniques.

Hands on experience in various tasks and transformations like Execute SQL Task, Execute Package Task, conditional split, Script Component, Merge, Multicast, Lookup and Slowly changing dimension while loading the data into Destination.

ACADEMIC PROJECTS

Internet Ads Prediction Sep-2016 – Dec-2016

Created a BI model which predicts whether an image is an advertisement or not using the geometry and phrases occurring in the URL.

Implemented statistical techniques like Regression analysis and Decision trees for the perfect model creation.

CERTIFICATIONS

SAS - UT Dallas Graduate Certificate in Business Intelligence and Data Mining.

Google Analytics Certification Exam.

Contact this candidate