Head Business Consulting

Job Description

• Data mining from database and applying statistical models to analysis and find out the insights from the data.

• Extensively using MS-Excel for analyzing the data.

• Creating reports in Excel by using Conditions, lookups etc

• Creating VBA Macros used to simplify routine tasks for end users.

• Creating pivot tables and power pivot of large data and modify spreadsheets to achieve analytical goals.

• Research, update, and validate data analyzing spreadsheet production strategically fill gaps.

• Adding some tools in Excel for advanced analysis of large data like data analysis tool, kurtools for better and accurate output by using statistical methods etc.

• Creating MS power point presentations weekly and monthly to the client s it shows the improving of productivity and quality.

• Creating graphs for visualization by using MS-Excel to analyze and understanding the data visually

• Deep understanding of mathematics including Probability, Linear Algebra, and Functions.

• Data manipulate and updating by Using SQL.

• Implement and practice Machine learning techniques on structured and unstructured data with equal proficiency.

• Analysing and manipulate the raw data as per there requirements.

• Creating reports for the many projects on daily basis.

• Cleansing, Consolidating and collecting the data for projects.

• Applying transformations for normalization of data and using calculations of quality accuracy.

• Trend analysis with Excel and Regression analysis on medical coding data.

• Data visualization by using Ms-Excel like control charts, Pareto, Histogram, Scatter plot

• Creating power point presentations on daily basis for the client purpose to present the productivity and quality capability.

• Creating a VBA Macros for the management it helps to reduce the time on regular tasks

• Creating flow charts by using MS-Vision to present project workflow structure to the clients

• Preparing MIS reports, trackers (daily, weekly, & monthly) as per business requirement

• Handling and analyzing large database for various reports

• Day to day coordination with concerned team on various market intelligence data and reports

• Keep the departmental heads updated on the reports on a regular basis.

• Maintain a proper schedule of reports.

Key Skills needed

• Candidate should have excellent knowledge in Excel techniques like Pivot Table, Charts, Data Validation, Lookup, Subtotals, Sumif, Countif, Index, Match, Conditional formatting to prepare reports.

• Candidate should be able to understand business objective of preparing reports

• Candidate with Basic knowledge of Graphs & Charts.

• Minimum work experience of 2-4 yrs of experience in Dealing as a short term trader/ arbitrage trader/ dealer is must have.

• Candidate with an eye for detail, Self-driven and timeline oriented is necessary.

ROLE: Fundamental Analyst Designation Fundamental Analyst Education Graduationfrom premiuminstitute and or Post Graduation in Management- Agriculture/ Finance / Economics/ Statistics with related experience. Additional Qualification Industry specific diplomas/ Functional certifications Work Experience 2 years to 5yrs Domain Research on Agri commodities- (Gaurgum, wheat, sugar, coco, mentha, others Location of work Noida Essential Language English & Hindi Cost to Company As per market standards No. Of open positions 1

Job Objective: The Research Analyst would be required to perform extensive research on the supply-demand-price of select commodities on a global basis and build several forecast models based on the collected information.To be successful in this role, the Analyst will be expected to demonstrate strong analytical capabilities, forecast modeling, and the ability to critically analyse data in an efficient manner. Commodity Fundamental Analysts are required to support Commodity Consulting Services at TransGraph which are aimed to serve various corporate houses that are exposed to price risk in the commodity segment.

Job Requirements:

• Expert level of skills in fundamental analysis and strong ability to take a call on the market for short term to long term periods.
• Ability to build any indicators, forecasting models for any new commodity
• Statistical knowledge is a must.
• Business acumen, attention to detail and strong data interpretation skills to connect dots and predict market developments
• The ideal candidate should have strong communication skills, both written and verbal, to generate timely reports, as well as mastery in MS Excel and very good PPT preparation skills.
• Negotiation and persuasive skills to discuss and obtain information from market participants,industry experts and the ability to interact and establish various market sources to obtain the market intelligence.
• Good understanding of the value chain of the respective domain/commodity
• Sound knowledge in derivative markets and related concepts
• Ability to effectively operate independently and in a team environment
• Service-oriented attitude while delivering the research and working with passion for clientesteem.
• Innovation, willingness to learn / un-learn and be the change agent.
• Ability to think out-of-box on facing any constraints

Job Responsibilities:

• Responsible for independently handling the assigned commodities from the needs of consulting clients.
• Coordinate with the TG research team and provide various research inputs to the client. Identification of various price drivers of commodities on a periodical basis and alerting the concerned stakeholders on the business decisions that needs to be taken.
• Actively participating in market outlook discussions and contribute to enhancing the forecasting accuracy.
• Active role while designing the procurement strategies. Prepare and make presentations to the clients leadership as and when required
• Ability to guide the team and convert the collected data into decision enabling content.
• Be hands-on on industry developments.
• Should travel to the markets in-person with short notices.
• Handling the assigned clients with respect to the client needs.