Harshadeep Bajantry +91-798*******
Business Analyst adk553@r.postjobfree.com
Professional
Summary
Solution-Oriented professional with over 2 years in Business Intelligence Analyst using advanced excel, Tableau and SQL to deliver deep insights from data through visualizations by creating business dashboards and reports. Post Graduation Diploma in Business Analytics with Hands-on experience in R and python. Skills
Machine Learning: Logistic Regression, Linear Regression, Classification, Regression, K - means Clustering Time Series
Statistical Methods: Predictive Analysis, Hypothesis testing, Basket Analysis
Programming Languages: R, Python
Data Reporting: Tableau Desktop 2020.4
Advanced Excel: Hlookup, Vlookup, Pivot, Data cleansing, Analytics Tool kit, creating charts
Excellent Communication and interpersonal Skills Education
Great Lakes Executive Learning Post Graduation Program in Business Analytics Yogi Vemana University Master of Business Administration – HRM S V University BSc Computer Applications
Work Experience
Business Analyst Synchroserve Global Solutions Pvt Ltd, Hyderabad-TS (Nov’19 - Dec’2020) Core strengths include
- Data Reporting - Team Builder - Analytical Skills
Interpreting data to conclude managerial actions.
Using statistical techniques to validate data and interpretations.
Building predictive models using regression techniques to estimate student footprints & occupancy of courses.
Performing feature engineering on the data collected.
Understanding the Client’s needs and requirements on the availability of the applications and making necessary changes in the models.
Performing Classification & clustering models to categorise the students based on the survey data. Gathering data from primary and secondary resources.
Writing SQL queries to gather data from different tables.
Cleaning the data and perform statistical techniques on the cleansed data using Advanced MS Excel/R/Python.
Observing trends and patterns that help to develop business opportunities.
Communicating with stakeholders to generate ad hoc reports when needed.
Applying prescriptive analytics and predictive analytics to draw meaningful insights& suggestions for various modules of the business.
Mapped current business and operational processes and recommended areas for improvement.
Evaluated Student footprints and student enrollment trends to understand competitive environments and assess current strategies
PGP Business Analytics -Certification program Great Lakes, Hyderabad-TS (Jan’19 - Sep’19) Core strengths include
- Data Visualising - Advanced Statistics - Statistical Methods Project – Machine Learning
The project involves deciding on the mode of transport that the employees prefer while commuting to the office. For this, multiple models such as KNN, Naive Bayes, Logistic Regression have been created and explored to check their model performance metrics. Bagging and Boosting modelling procedures have also been applied to create the models.
Project – Predictive Modeling
The primary objective was to investigate the parameters contributing to customer churn (attrition) in the Telecom Industry. A Logistic Regression Model was developed and validated with test data to predict customer churn.
Project – Data Visualization
Problem-solving with the aid of visual analytics to identify properties of sale and factors affecting it. Tableau’s data visualization tools were used to create interactive dashboards to uncover hidden insights for sellers of the properties as well as prospective buyers for real estate.
Tableau’s data visualization tools were used to create interactive dashboards to provide high-level insights to the CEO of an Insurance company to drive the company's policymaking Project – Factor Analysis
Consumer perceptions towards a brand can be built on various parameters depending upon the product. This project uses Factor Analysis to evaluate and identify the most significant attributes that contribute towards the consumer perception of the different cereal brands.
Hypothesis Testing and visualization to evaluate the success of a new sales incentive payment scheme for an insurance company.
Executive HR Compass Group, Hyderabad-TS (Sep’17 - Dec’18) Brand Ambassador to promote and manage Compass food team at client location (Google, Hyderabad)
Enhanced employee retention & employee satisfaction scores of 92% (2018) in the recent Survey from the previous 85% (2017)
Excellent client interaction skills; think and act strategically in the deployment of various HR programs and is process-oriented and organized.
Maintain employee relations through proactive connect with employees.
Supported day-to-day HR operations through data analysis and reporting.
Collaborate with HR functions, interact with associates with confidence and be responsive to business needs to ensure information is shared in a timely fashion.
Conducted annual salary surveys and developed, analyzed and updated company salary budget.
Analyzing and presenting data and reports to the appropriate area of expertise, identifying errors and advising on solutions
investigated the factors that cause employee attrition in organizations. Employee attrition models were built using Neural Network and Random Forest. After generating common performance parameters for both the models, an Ensemble Model was created that identified the cause of employee attrition. Branch HR Support G4S Secure Solutions India Pvt, Hyderabad-TS (Sep’16 – Aug’17) Part of Human Resource department team handling payroll, employee grievances and statutory compliance audits
Member of G4S India of Excellence for employee relations
Achieved null error in preparing Audit Documents like Wage Register, Muster Roll, ESI & PF Declarations under the CLRA Act 1970 with the updated formats.
Analyzed issues and employed improvement processes. Personnel Executive Aparajitha Corporate Services Pvt Ltd, Hyderabad-TS (Jan’13 – Aug’16)
Maintaining the employee database
Preparing daily service M.I.S and reporting to top management
Coordinated with business unit teams in planning strategies to improve the performance of management processes and tools
Reformatted the Investor month-to-date Dashboard on the Business Intelligence system which provided the status of investor performance in real-time
Performing and designing test scenarios and test scripts.
Developed a dynamic database to fulfil broad reports creation and statistics generation requirements of the group by integrating historical data and appending monthly updates.
Generated KPI's to review performance and suggested corrective actions
Creating Utilization report for hundred teams on monthly basis to measure utilization, Productivity and shrinkage
PERSONAL
DOSSIER
Interests: Reading Biographies Technology Exploring Gadgets Adventurous Touring Languages: Telugu, English, Hindi & Tamil
Bajantry Harshadeep