Data Analyst

ROHIT KAUSHIK

858-***-****; ******@*****.***; https://www.linkedin.com/in/rohitkaushik09

SUMMARY

Information Technology and Management graduate student seeking Summer Internship in the field of Data Analytics. Overall 4.5 years of IT experience in Data analysis, Business analysis, Application Development and Application Testing in Agile and Waterfall environment. EDUCATION

The University of Texas at Dallas May 2021(Expected) Master of Science – Information Technology and Management GPA: 3.5/4 Sikkim Manipal Institute of Technology, INDIA June 2014 Bachelor of Technology – Electrical and Electronics Engineering GPA: 7.91/10 SKILLS

Analysis tools: Statistical R, Tableau, MS Power BI, JIRA, Pandas, NumPy, MS Visio, MS Excel Programming & Database: SQL, Python, COBOL, JCL, DB2, ORACLE, SQL Server, MySQL, SAP HANA, AWS Work EXPERIENCE

Tata Consultancy Services, Hyderabad, India September 2017- July 2019 Senior Process Associate

• Performed data manipulation task in Database and wrote more than 50 SQL queries (insert, update, delete, select queries involving joins) to fetch relevant data leading to 15 percent increase in daily productivity of the team

• Created functional designs and technical specification documents for application development from the Business Required Documents helping in easy understanding of requirements for the developers

• Earned the “ON THE SPOT” award for analyzing and solving critical production defects

• Supported and troubleshoot issues on Finance application for Transamerica, a client of TCS and performed root cause analysis of the defect in Test and Production region to avoid the error in future Capgemini, Hyderabad, India November 2014 - August 2017 Associate Consultant

• Developed various batch and online programs in python for T2S, a European central bank project resulting in increased efficiency of delivery-vs-payment system by 20 percent

• Acquired data from primary and secondary data sources, wrote more than 100 SQL queries to extract data for European CSDR which enhances securities and shortens the settlement time by 50 percent

• Collaborated with team to search and optimize the product description as per desired benchmarks defined

• Prepared detailed technical documents, Unit test plans and Unit test reports of the programs developed

• Responsible for interaction between client and various teams to share the daily status of work progress ACADEMIC PROJECTS

• Database design for movie rental store Blockbuster LLC November 2019 – December 2019 Created a relational database using MS Visio to keep track of all the movies rented, movie details, customer details, frequently rented movies, slow rented movies, areas in which most movies are rented and accounting details and performed analysis on various insights we got from the data

• Employee database application October 2019 – November 2019 Created Employee database application to add, delete and update employee’s details and generate the report by using the concept of classes and object in Python

RELEVANT COURSES

Statistics for Business Analytics Business Analytics with R Data Management Business Data Warehousing Data Visualization Oops with Python

Contact this candidate