Experience

  • MSBI Developer/ Data Analyst

    at IPC HEALTH

    August 2019 - October 2019

    State of Victoria

    IPC health is one of the largest community health services in Victoria. Our aim was to establish the function, setup, own and manage the Information Management about patients behavior in IPC. After building package and cubes, utilizing that source to perform Statistical procedures in SAS and R. Key Responsibilities: • Created a Data ware house in OLAP using SSIS and designed data storage models and data flow processes in SSIS. • Created Multidimensional model using data source in cubes of SSAS. • Using SSRS created a report. • Using those analysis performed Statistical modelling in SAS and R. Technology Used: Microsoft SQL server, SSIS, SSRS, SSAS, SAS and R.

  • DATA ANALYST INTERN

    at DPV HEALTH

    March 2019 - July 2019

    State of Victoria

    Our main aim was to understand the business problem at DPV Health and to identify customers based on the risk and income they bring to the table of DPV. As the main problem of the business revolves around to minimize their revenue losses and point out wherever DPV is losing a significant amount of their resources based on their location and the programs which they were implementing. Key Responsibilities: • Extraction and statistical analysis of data using Oracle SQL queries, Python and R analytical tools • Developing data visualizations using Tableau. • Improve data quality and undertake data reduction using Principle Component Analysis. • Worked on Supervised Machine Learning (ML) and implemented various Classification Algorithms. • Development of detailed documentation and process guides to support key activities of data analyst. Technology Used: Excel Macros, SQL, Python, R and Tableau.

  • RISK ANALYST INTERN

    at ANZ BANK

    November 2017 - March 2018

    State of Victoria

    Worked in Credit Department using SAS EG environment to build Base SAS and Advanced SAS (Macros), Teradata and SQL platform during this Internship to design code for Credit Cards based on the state of accounts and payment options. Key Responsibilities: • Data Preprocessing and Data Modelling to classify the customers and clean the Missing Values using PROC. • Utilized SAS GRAPHS to build Visualizations to understand the behavior of the customers • Then based on the output using Transition Matrix and PCA concepts modeled the data, after that using that data built a Machine learning Model. • Created Macro Variables in PROC SQL using INTO clause and using CALL SYMPUT function to write fewer %let statements, so that I can reduce time delay in execution time. • Worked on IFRS 9 credit cards to reduce credit losses using SAS environment. Technology Used: BASE SAS and ADVANCED SAS (MACROS) and SQL.

  • SQL DEVELOPER

    at CYBER NETICS PRO

    August 2015 - October 2016

    Hyderābād - Telangana

    Cyber Netics is one of the financial service organization based in Hyderabad. My role is troubleshooting/ resolving escalations from service desk, addressing exceptions and supporting their business users and updating/ developing new features/functionalities in their existing database applications. Technology Used: Oracle PL/ SQL and Excel.

Education

  • Master of Analytics

    at RMIT University

    2017 - at Present (3 years) State of Victoria

  • Bachelors of Mechanical Engineering

    at JB Institute of Engineering and Technology

    2011 - 2015 (4 years) Hyderābād - Telangana

Languages

  • English Native

Hives