Charan Jeet Singh

• Collaborate with end-users and stakeholders to gather, analyze, and document business requirements for reporting and data solutions. • Develop storyboards, process models, and workflow diagrams to clearly communicate business needs and system requirements. • Design, develop, and implement reporting solutions using various data sources including data warehouses, data marts, and stand-alone platforms. • Create, test, and deploy reports and dashboards in BI tools such as Power BI and SQL Server Reporting Services (SSRS). • Conduct data analysis and provide actionable insights to support program delivery, planning, and decision-making. • Coordinate and execute testing, training, and implementation of BI solutions to ensure smooth adoption by business users. • Collaborate with multidisciplinary teams to assess options, recommend efficient solutions, and ensure alignment with business goals. • Evaluate the impact of new tools and technologies on staff, processes, and data workflows; develop change management strategies to minimize disruption. • Maintain metadata, data documentation, and ensure adherence to data governance and security standards. • Provide consultation and support to both technical teams and non-technical stakeholders to enhance data literacy and optimize BI processes. • Leverage advanced Microsoft Excel skills and BI technologies to streamline reporting and data analysis processes. • Apply statistical methods and programming tools (Python, R, SAS, DAX) to derive insights, perform analyses, and support complex reporting needs.

• Act as the first point of contact in the department where Leading a team of 55+ employees in the production department and provide regular progress report to the Durabuilt Leadership. • Allocation of work in an efficient and effective manner to meet delivery requirements while achieving quality and safety standards • Assigning tasks/responsibilities to subordinates, monitoring and evaluating the progress of the work and reporting status updates to leadership • Collecting, compiling and analyzing large set of daily production/procurement data into some meaningful patterns from multiple data sources for the Business Insights. • Conduct quality audits and develop quality management and quality assurance standards • Data analysis through advanced statistical techniques of MS-Excel, Power BI and statistical packages like SPSS, R etc. • Ensure that team members follow defined manufacturing procedures, comply with quality requirements and achieve their stated daily capacity targets. • Identify and taking business improvement opportunities as an extra initiative within the organization time to time • Responsible for preparing daily reports, dashboards and statistics to measure the capacity, manpower, team performance, Inventory etc. • Responsible for the full adherence to 5S (Sort, Set In Order, Shine, Standardize, Sustain) practices at all times. • Responsible for the optimization of Inventory, Manpower & Capacity Planning

• Conducting & managing primary as well as secondary market research projects for pharmaceutical market of across countries using advanced statistical and mathematical techniques in the multiple geographies. • Taking complete accountability of the projects: Ensuring data accuracy, quality check for analysis and reports, identifying and removing errors, outliers through sense checks of deliverables. • Preparing comprehensive research plans for data collection and designing questionnaires in accordance with project objectives. • Responsible for end-to-end project management, management of team as well as coordination with other teams to ensure end-to-end project execution. • Data analysis through advanced statistical techniques of MS-Excel and statistical packages like SPSS, R etc. • Reviewing deliverables from perspective of story boarding, insights and recommendations in PPTs, emails or even dashboards and delivering business oriented insights. • Collecting, compiling and analysing large sets of raw data into some meaningful patterns. • Ensuring project deliveries meet quality and accuracy specifications and setting up processes within the team to ensure this. • Conceptualizing and operationalizing new /complex projects, identifying potential challenges and presenting these in a well-developed PPT to seniors or stakeholders. • Identifying capability gaps conducting/organizing trainings for team development, for the efficient utilization of the resources. • Assigning tasks/responsibilities to subordinates, monitoring and evaluating the progress of the project and reporting status updates to leadership. • Providing Training and skill building on the various advanced techniques of Excel & Statistics. • Act as the first point of contact for client and also provide regular progress report.

Work on all aspect of Market Research :The main responsibility for the management, coordination and completion of Market research survey projects in Healthcare industry. Manages all aspects of the projects, including setting deadlines, assigning tasks/responsibilities, monitoring and evaluating the progress of the project and reporting status updates to leadership. Also, to perform quantitative and qualitative analyses for multiple survey projects that serve to produce survey data reports.Typically leading more complex assignments and generally to work independently with minimal support. Key responsibilities included: • Managing large scale projects and standardization • Client interface including offshore visits in India • Setting up quality control processes • Conducting & managing primary as well as secondary Market Research projects using advanced statistical and mathematical techniques in Healthcare sector. • Data analysis through advanced statistical techniques of MS-Excel and statistical packages like SPSS, R etc. • Collecting, compiling and analyzing large sets of raw data in the dashboards. • Ensuring project deliveries meet quality and accuracy specifications and setting up processes within the team to ensure this. • Monitoring and evaluating performance of subordinates and planning for proper training for them for their development

Working as a Statistician where my main responsibilities are execution of Universe Estimation & Sample Design (UE/SD) for Retail industry globally ensuring on-time and quality delivery. Communicate with clients, management of team and internal departments to coordinate overall project execution effort in accordance with corporate goals. • Used mathematical and statistical techniques for modeling/analysis like Regression, Logistic regression, Factor analysis, Cluster analysis, Sampling, ARIMA and have strong retail domain knowledge. • Experience in handling complex data processes using SAS, R, SPSS & Advanced MS Excel. • Responsible for providing and validating universe figures based on business as usual (BAU) universe estimation methodologies and best practices. • Ensure the quality of Universe Estimates & Sample Design work are in line with client standards and guidelines • Responsible for providing accurate UE & SD feasibility analysis according to the new requirements submitted and quality of work and following all quality checks in place and data analyses • flexibility in working in a dynamic work environment where delivery schedules and priorities fluctuate according to client needs and external department demands • Communicate effectively with internal/external teams, including local country Onshore support and cross-functional departments for prompt delivery of data and provide timely responses to data/process related queries • Recommend improvements in processes within area of responsibility • Experience in survey research methodologies, data collection, platforms, research processes and operations • Experience in statistical modeling, variance estimation, trend analyses, indirect estimation, data aggregation techniques, automation, generalization • Experience in Demography, Sampling, Statistics Modeling, Survey Design Practices • Highly detail oriented, strong commitment to timely execution of tasks

Provides comprehensive research support to the Consulting Staff using a large pool of data bases which include CAPITAL IQ, Bloomberg, Prowess, ISI, Accord Fintech, Factiva, Thomson, Datamonitor, Euromonitor, One Source, City skyline, Market Research, MCA and BMI besides exploring our local government websites & associations like RBI, SEBI, ASSOCHAM, MOSPI,NCAER Planning Commission and others. Support to analyze market research project, checking data tables.This should include importing and exporting of "client" data.Collecting and compiling large data sets for further analysis, documenting results, preparing comprehensive research plans, Co-ordinate and support analysts throughout research phase, Contribute to consultancy projects, market survey, Corporate profiling.

Work on all aspect of research : scoping, primary research, secondary research using quantitative (statistical tools / advance excel formulas etc) analysis on multiple industry sectors and geographies.Support to analyze market research project, checking data tables. Ability to extract data for manipulation in Excel. Proven expertise in data manipulation, with in Excel. This should include importing and exporting of "client" data.Collecting and compiling large data sets for further analysis, documenting results, preparing comprehensive research plans, Co-ordinate and support analysts throughout research phase, Contribute to consultancy projects, market survey, Corporate profiling. 1. Conducting & managing primary as well as secondary market research projects using advanced statistical and operational research techniques on multiple industry sectors and geographies. 2. Preparing comprehensive research plans for data collection & designing questionnaire for the appropriate information needed. Developing the project reports in accordance with the needs & requirements of the clients. 3. Data analysis through advanced statistical techniques of MS-Excel and statistical packages like SPSS etc. 4. Collecting, compiling and analysing large set of raw data into some meaningful patterns.Worked on statistical modelling which includes trend analysis/seasonality, forecasting & more advanced statistical methods. 5. Developing and applying theoretical & statistical analytics frameworks. 6. Responsible for designing and driving customer reach-out initiatives such as Newsletters/Customer online Surveys campaign tracking information, analysis and research to improve campaign impact. 7. Co-ordinate and support analysts throughout different phases of the research project, contributing to consultancy projects, market survey, corporate profiling etc.

Collecting and compiling database for analysis, documenting results,preparing comprehensive research plans, Co-ordinate and support analysts throughout research phase, Contribute to consultancy projects, market survey, Corporate profiling . 1. Data collection through secondary and selective primary research, then to analysis data through statistical packages and advanced MS Excel methods. 2. Collecting and compiling database for analysis, documenting results, preparing comprehensive research plans. 3. Responsible for planning, organizing, directing, controlling and evaluating performance of any primary market research project. 4. Preparation and ensuring timely delivery of reports without compromising in the quality. 5. Responsible for end to end project management, management of team and internal departments to coordinate overall project execution effort in accordance with corporate goals. 6. Databases building and maintaining through secondary/internet research as well as modelling work. Providing back end support to key operational processes. Co-ordinate and support analysts throughout research phases.

Data collection through secondary and selective primary research, then to analysis data through MS-Excel 2007 and used some statistical packages like SPSS etc.

Forecasting Demand and Distribution Planning The project is to design and develop transportation and distribution plan of UREA fertiliser for different states in India. This includes forecasting the demand of UREA and then used appropriate method for minimizing the transportation cost.