KSHITIJ NILANK
-
-
EDUCATION
2016
PGP Business Management (Data Analytics & Finance)
Praxis Business School, Kolkata
6.04/8
2011
B.E (Electrical)
SSBT COET, Jalgaon
68.65%
2007
Class XII (CBSE)
DAV Public School, Patna
58.20%
2005
Class X (CBSE)
Premalok Mission School, Patna
78.33%
B2B SALES | E-AUCTION | PRICING & COSTING | CRM | MARKETING OPERATIONS | KPI DELIVERABLES
WORK EXPERIENCE: 5 YEARS 10 MONTH (PRE-MBA: 2 YEARS 10 MONTH; POST -MBA: 3 YEARS)
Duration: July 2016 (Working)
Company: mjunction Services Limited
India’s Largest B2B eCommerce Company
Designation: Manager
•
Category Manager – Steel Flat Products | July 2016 – currently working
➢ Analyzing business potential, conceptualizing & executing strategies to drive sales, increase turnover and
achieve targets
➢ Conducting competitor analysis by keeping abreast of market trends & competitor moves to achieve
market share metrics
➢ Dealing in CR, HR, COLOR COATED, Galvanized Products
➢ Managing Clients – RSP, BSL, CMO-BSOx, Tata Steel FP & TSPDL Chennai (Qty. 15000 MT per month | TV –
52.5 cr per month| Report - 8 Nos. per month)
➢ Managing business development activities & accountable for the top-line profitability & increased sales
growth.
➢ Market making activities to sell the secondary products (esp. pain items)
➢ Involved in project for primary research and analysis to sell prime products like CC, GP & GC
•
Business Analyst – Project Management | July 2016 – June 2017
➢ Create release notes per user release, sign off on said release notes, and lead in all release notes walk
through meetings with the vendor
➢ Collaborate with system architect and development leads to document all software changes necessary to
meet the project requirements
➢ Finalize requirement in FRS (Functional Requirement Specifications), writing the near final version with
detailed description
➢ Manage the tableau defect resolution process by analyzing and prioritizing defects based on user needs
➢ Plan and lead UAT activities like creating use cases and test cases
➢ Translate business requirement into functional requirement for developers
➢ Represent the metaljunction in vendor meetings, document meeting outcomes, and coordinate all
internal and external follow-ups to close issues in support of the project requirements
Roles
Duration: March 2013 – June 2014
Trade License: UBI Payment
Designation: Entrepreneur
• Convincing & on boarding customer by organizing event in different location of city to make payment via
mobile (through SMS)
• Learning: Incumbents lose & shift towards the digital economy
Duration: Sep2011 - Feb 2013
Company: Vivid Infratech, Navi Mumbai
Designation: Project Engineer
•
Project Coordination
➢ Communication between the Tender department, Construction department, Site team and the Client
➢ Inspecting, documenting and getting the work done approved by the client
➢ Preparing RAB for the work done in the project to the client
➢ Project handled T2 MIAL, Mumbai (0.40 Cr) ; Le Meridian, Mahabaleshwar(1.4 Cr); ONGC, BKC Mumbai
(1.8 Cr)
• RFQ for BBT (Busbar & Trunking)
• Learning: Project management and team work
INTERNSHIP: 2 MONTHS
Duration: Apr 2015 – Jun 2015
Praxis Business
School
Company: KARVY Stock Broking Ltd.
Designation: Intern
• Insight to Indian Capital Market
➢ To do fundamental, technical and comparison analysis of companies in Nifty and CNX Midcap
➢ To come up with the portfolio for a time horizon of 6 months (Till Jan 2016)
➢ Retaining inactive/Lost Customer. Cold Calls: 50 each day; Conversion Ratio: 10%
PROJECTS
Praxis Business
School
SSBT COET
• Construction of optimum portfolio in financial data modeling
➢ Created Markowitz Efficient Frontier using regression and solver for five stocks
➢ Learning: Efficient point for investment (Portfolio Management Service)
• Constructed a valuation model for Oswal Greentech Ltd. using FCFF and FCFE method
➢ Created DCF valuation model through FCF
➢ Used past year data to derive intrinsic value of the company
➢ Learning: Margin of Safety for investment
• Constructed and back tested mean reversal of stock data
➢ Downloaded data for 4 years and get it divided by book value
➢ Used the data to find out standard deviation
➢ Used the model to forecast stock prices movement for short term to mid term
➢ Learning: Heavy industries (BHEL, ONGC etc.), PSU Bank follows this model with 70% accuracy
• Analysis of funny money dataset
➢ Primary research conducted by pvt. banks on rural population which have acquired loan in last 3years
(sample size: 1164 nos.)
➢ Data Sanitation - Treatment of missing data
➢ Demographic profiling, customer loan taking behavior, overall customer satisfaction, psychographic
segmentation
➢ Learning: How to connect to TG (Shift from unorganized to organized ERGO increasing market share)
• Understanding the Marketing Mix of Lighting Industry in India
➢ Study of buying behavior and marketing mix
➢ Compared the Promotion mix of Philips with the major brands in the industry
➢ Developed SWOT analysis on Philips and proposed ideas on how to grow brand
➢ Learning: How to connect to TG (Shift from unorganized to organized ERGO increasing market share)
• Developed a customer feedback system using ZOHO Creator
➢ Collected specification of the software from client
➢ Created prototype in Zoho creator
➢ Learning: A new trend is starting (Shift from Legacy System to Cloud Based)
• Developed Human Powered Small-Scale Generation System from a Dance Floor
➢ It utilizes the energy of steps to convert it into electricity by using piezoelectric material and power
magnet
➢ Output obtained:10 to 12 Watt
POSITION OF RESPONSIBILITIES
• T&P 2010-11 (SSBT COET, Jalgaon)
➢ Coordinate with students and department T&P officer
• EESA 2008-10 (SSBT COET, Jalgaon)
➢ Coordinate with students and department EESA coordinator for organizing events
ACTIVITIES AND INTERESTS
• Activities
➢ Computer Orientation for Kids” in Dakshin Kalikata Sevasram under TVW (Tata Volunteer Week) 6 activities
➢ Stood 1st Runner-up in quiz held at mjunction H.O.
➢ Participated in Business Standard “Business Quiz” and won 2nd prize held in Praxis Business School
➢ Participated in national level paper presentation on topic “Solar Tower” and won 2nd prize in Nashik
• Interests
➢ Reading investor presentation, investment books, quizzing
➢ Quizzing, Solving Sudoku and Playing Carom
OTHER INFORMATION
•
Key Skills
•
Languages Known
•
DOB
•
Address
•
Proficient in Power Point; MS Office - VLOOKUP, HLOOKUP, Pivots, Power View, Solver, Regression
Software: R Studio, SQL & Tableau
English and Hindi
19th July 1989
Flat No. 1, Sukanta Nagar, Sector-IV, Salt Lake City Kolkata. Pin - 700098
