Sourabh Jain

Experienced BIA Analyst (Business Analyst) with a demonstrated history of working in the information technology and services industry. Skilled in SAS, SQL, HR Analytical Skills, Microsoft Word, Business Intelligence, Microsoft Excel, and Data Analysis. Strong research professional with a Bachelor of Engineering (B.E.) focused in Computer Science & Engineering from Sir M Visvesvaraya Institute of Technology, Bangalore.

Business/Senior Business/HR Analyst
Bangalore, Karnataka, IN
Email : jsourabh44@gmail.com

Phone : +91-961-1428988

Date of Birth : 21st April 1995

Work Experience

Danske IT and Support Services India Pvt Ltd, BIA Analyst, Oct 2019 ~ Present

  • Presently involved in the Predictive analytics of Churn Model across the bank, to increase Employee Retention and hence decreasing the overall cost of FTE acquisition.
  • Leading a team of two junior associates to complete the migration of Old, historical MVSW/DB2 SAS codes to the new & better versions, into the SQL server HR mart, hence decreasing the effective cost to maintain the HR tables on two different environments.
  • Created & efficiently handling the HR Quarterly delivery, which in itself is the single most information concerning HR figures (and analysis) in the bank. It is sent out to the Executive Leadership Team (ELT) or EXBO, the HR Management Team and the HR Strategy Partners. The dataset supports most of the analysis done in the People Analytics team, and is being used by the CFO Area – Financial Planning team for monitoring of new hires and leavers.
  • Successfully predicted the FTE count for the future 5 years, using the HoltsWinter, ARIMA & Neural Network techniques in R studio, to help the Sustainability Strategy Lead for Group Real Estate and the Real Estate Research & Concepts team, so that they can predict the Energy consumption across the bank in next 5 years.

     Danske IT and Support Services India Pvt Ltd, Associate Business Analyst, Aug 2017 ~ Sep 2019

     Got Promoted to BIA Analyst 

  • Delivering Better and Efficient Solutions to the Stakeholders in Nordic region while working as a part of HR Reporting and Analytics team in India. 
  • Assist in development, rollout, and maintenance of dashboards, both executive and management reporting, across the enterprise. 
  • Work with Business Intelligence tools such as SAS, Microsoft SQL, Excel and Tableau to develop reports and provide data to stakeholders. 
  • Develops and maintains reports, models or databases to support individuals and the enterprise’s routine and ad hoc data and analytical needs. 
  • Experience with relational databases and possess the ability to link data between tables, to create efficient SQL queries and design scalable data models. 
  • Perform analysis of domain specific source data to provide accurate statements and conclusions. 
  • Creation of Salary Review Data and Employee Main Data for Group HR's Incentive Tool, for the monthly data validation for Salary & Bonus rollouts.
  • Handling HR Standard dashboards and HR related reports on Tableau.

Achievements

  • Our team received a rating of 6.2 out of 7.0 and awarded the best team in HRS-Delivery. 
  • Got the monthly GEM AWARD within 6 months of joining the enterprise, for efforts that I have put in different fields apart from my daily work. 
  • Being the key member of the HR Reporting team, stabilised the process of monthly Salary Review Data & automated the Employee Main Data, hence saving more than 6 million DKK of the enterprise. Got the prestigious quarterly (July-Sep, 2019) STAR AWARD, a special recognition, for this effort. 
  • Completed around 30 adhoc in a month along with other important projects. Automated around 50 reports and converted 30 percent of adhoc to recurring reports. 
  • Provided all-important data to CEO - Sweden, for his interview with Bloomberg on a short notice. 
  • Received Appreciation from the stakeholders and the supervisors for swift deliveries maintaining the data Quality.
  • Collaborated with the Data Warehouse team for data validations, performed quality checks on reports and exports to ensure exceptional quality.
  • Actively taking part across the different Fun & Cultural committees, like Emergency Response Team (ERT), Fun Team, Team representative of ACOE, etc., in the organisation.

Education

  • 2013 - 2017 - B.E. in Computer Science & Engineering : Sir M Visvesvaraya Institute of Technology, Bangalore - Percentage : 71.28%.
  • 2012 - 2013 - XII Std - CBSE - Hundred Flowers Higher Secondary School, Pangei, Imphal - Percentage : 80.40%. Subjects: Physics, Chemistry & Mathematics.
  • 2010 - 2011 - X Std - CBSE - Kendriya Vidyalaya, Leimakhong, Imphal - CGPA : 9.8/10 (A1). Subjects: Science, Mathematics, English, Hindi & Social Science.

Skills

  • Microsoft Office Microsoft Word Microsoft Excel
  • SAS SQL  Tableau
  • Data Analysis Analytical Skills Data Management
  • HR Analytics  HR Operations HR Strategy HR Reports  
Full Resume