Sagar Nayak


About Me

I am a Graduate student at Illinois Institute of Technology doing Masters in Information Technology and Management. I am looking forward for Full Time Internships for Summer 2017.

Location

Chicago, Illinois
Bengaluru, India
Education
    Illinois Institute of Technology
    August, 2016 - May, 2018
    degree
    Master's
    major
    Information Technology Management
Work Experience
    HCL
    Analyst
    August, 2013 - July, 2016
    company
    HCL
    title
    Analyst
    overview
    • Writing complex statements, Stored Procedures and adhoc queries for data analysis and creating jobs and monitoring jobs in production server. • Involved in merging existing databases and designed new data models to meet the requirements. • Utilize Data Mining skills and knowledge of SQL and create management reports on weekly and monthly basis. • Applying normalization and de-normalization techniques to improve the performance of the query. • Implemented advanced Excel programming skills to develop and maintain daily backup reports of servers. • Designing and development of SSIS packages, good experience in using various transformations effectively. • Proficient in creating SSRS reports and deploying them. Environment: SQL, SQL Server Management studio, Data Mining, Microsoft Excel, SSIS, SSRS
Fun Fact
Humorous,
Skills
Languages
HindiKannadaTamilTelugu
Technical skills
hadoopjavapythonrsassqlt-sql
Skills
Juggling