Prashant Rana

  • Mumbai Maharastra, India
  • +91 9892542989
Prashant Rana

Business Analyst at Tata Consultancy Services


  • 5+ years of rich experience in business analysis, techno-functional solution design, pre-sales, team management and product development gained over multiple indigenous Open Source Cloud based software product offerings
  • Experienced in techno-functional analysis and software product development activities along with performing team management duties
  • Having a proven track record of effectiveness in requirement gathering and planning, translation of business requirements into technical solutions and coordinating effort, with very good troubleshooting skills across multiple engagements
  • Skilled in defining and streamlining business processes and resolving techno-functional issues with a customer-centric approach and in providing functional specifications to the technical team to yield the best technical solutions

Work History

Work History
Oct 2014 - Present

Business Analyst - F&A Product Solutions and Pre Sales

TATA Consultancy Services
  • Lead Business Analysis activities for multiple cloud based P2P product implementations
  • Drove due diligence and requirement gathering workshops leading to scoping and project planning
  • Conducted Product Demonstrations and presentations to key customer stakeholders
  • Liaised between Product Development and Service delivery teams for Product Pricing, Project Scope, Development and Implementation Time Lines
  • Nominated SPoC to present Product Offering to existing customers
  • Formulated business and functional requirements and created business cases for consideration
  • Trained end-users as part of post implementation activity
  • Provided functional guidance to Product Development team for product enhancements 
  • Key Achievements
    • Nominated to conduct onsite due-diligence exercises alongside business process SMEs at start of engagements
    • Proposed as Techno-functional advisory to product development teams on Product PoC / customizations 
    • Proposed well-received technology assisted processes improvements in "Purchase to Pay" and "SCM" practices
Apr 2012 - Sep 2014

Business Analyst - Open Source Products

TATA Consultancy Services
  • Lead a 2-4 Member product development team after gathering requirements from SMEs towards building a custom Open Source CMS platform; Successfully deployed 8 instances of the same on-to the Internet just 4 months
  • Owned implementation, customization and hosting of the platform; Ensured compliance of development standards resulting in higher system performance, user concurrency and availability of applications
  • Coordinated effort for application testing and monitoring subsequent bug fixes done by product developers
  • Enhanced user experience design and provided UI recommendations based on best practices for multiple web-based hosted products for CRM, Vendor management, Telecom OSS, Retail loyalty management, Retail Ecommerce platform etc. via user acceptance testing, surveys and interviews
  • Coordinated with Organizational Legal team and Patent office for securing copyrights
  • Trained 3-5 person teams of Business Analysts towards usage of the product
  • Conducted Usability and User Acceptance Tests via interviews and surveys
  • Brought about high level of SSA adherence(95%) and achieve high application availability(95%) of developed platform
  • Created SOPs and mentored teams cross-country to be self-reliant and build Internet Worthy instances of the CMS in less than 3 months
  • Key Achievements
    • Deployed platforms and further instances have resulted in saving of revenue otherwise spent on Product Support
    • Quick reporting and accurate capture of requirements led to creation of multiple highly acclaimed case studies
    • Developed an indigenous Assessment Model in collaboration with SMEs; Application for IP rights on the model is under consideration with Organizational Legal Team
    • Created 3+ training courses for product users along with appropriate  documentation; Trained more than 40 participants using the same in classroom mode
Nov 2010 - Mar 2012

PLSQL Programmer for the Largest Online Analytics Firm

TATA Consultancy Services
  • Performed database optimization and maintenance of data warehouses containing real-time online analytics data
  • Maintained and optimized scripts for Oracle 11g DBMS to Netezza Data Synchronization
  • Created custom PLSQL scripts and UNIX shell jobs to assist in generating analytics data for vizualization on front end as dashboards
  • Scheduled jobs independently and created automated scripts for non-production environment; Resulted in quicker processing of very large data sets



Office Productivity Tools

Using MS Office /  Open Office Suite of Products for daily activities and deliverables


Querying and creating custom complex queries for data mining

Unix Shell

Shell scripting for custom job creations and troubleshooting / modification of existing scripts

PHP based CMS - MediaWiki, Drupal

Development and customization as per business requirements and hosting of the same

HTML, CSS, JavaScript

Designing of industry standard UI elements for cloud platforms

HTTP/Apache, FTP

Deployment and maintenance of multiple instances on both Windows and Unix environments



Diploma Certificate in Business Analysis (IIBA Affiliated)

TATA Consultancy Services and IIBA

Diploma Certificate from TCS Business Domain Academy in recognition of completion of specialization in Retail Industry Certifications and tests in accordance with IIBA BABOK v2.0


Programming in HTML5 with JavaScript and CSS3

Microsoft Corporation

Recognizing basic programming capabilities in HTML along with JavaScript and CSS


PL/SQL Developer Certified Associate

Oracle Corporation

Recognizing programming capabilities using PLSQL


2006 - 2010

Bachelor in Engineering

University of Mumbai

Specialization in Computer Science and Engineering