- Create regular Business Intelligence reports by querying the reporting interfaces and organizing the data into easy to understand Excel reports.
- Implementing Extraction, Transformation and Load (ETL) on the data for the analysis.
- Review and summarize miscellaneous reports and spreadsheets.
- Designing and maintaining processes for measurement, tracking, reporting and analyzing traffic and user experience.
- Advanced Excel proficiency is a must including Pivot tables, vlookup / hlookup, graphs etc
- Other routine operational tasks to help in the efficient functioning of business operations.
- Construction of complex queries to get relevant data for Quality Audits.
- Secondary market research using web resources.
- Recognizing and extracting critical indicators from large and complex data sets and being able to interpret and express those indicators in a business context.
- Identifying the data related defects in the existing system and providing a solution.
- Providing feedback and suggestions in related business process enhancements.
Other Major Responsibilities: –
Project Management/Process Enhancement
- Initiate brainstorming sessions with various stakeholders.
- Understand business requirements and prepare the project plan.
- Work with designers, developers and DevOps to ensure that the project is moving in the right direction.
- Be a facilitator for the entire team.
- Responsible for administration of the system and training to the end users.
- Implementation of Analytic of order booking and funnel – This was implemented through Google Docs for better collaboration and reporting.
- Work with Ticketing System team for further enhancement by applying plug-in and creating custom modules.
- Customer Onboarding/migration project management – Infrastructure and software
- Gold Coin Contest – Cross Selling and Up Selling Process Setup End-to-end
- Document Management System(Alfresco and OnlyOffice) – Evaluation, implementation, administration and maintenance
- TenderTiger – administration and maintenance
Presentation/Front Ending
- eNlight 360 Presentation Concept and Animation
- Presentation for Bodhost prospect Incyte – Presentation Theme Generation, Technical Solution, Presentation
- Guided the animator for animated videos made for the products
- Prepared Content and presentation for events – ET Delhi, Young Entrepreneur, Goa Banking Frontier, Payment Banks Technical Solution Presentation, Short Success Stories
- Case Studies for eNlight 360 and eMagic
- Conduct Webinars for internal teams, existing and potential customers
Strategy and Data-driven decision making
- Data Analysis Reports which enabled data-driven decision-making
- Client Revenue Reports which helped in assigning an account manager to the necessary customer based on its ratings and provide exuberant customer service.
- Domestic Premium Client List – To evaluate the current strength of premium client and enhance the level of service provided to them.
- Customer Acquisition Reports vs Estimated Revenue – Help finance team
- City Product Industry Wise List – helped the marketing and sales team to set the target audience.
- Support Ticket Type Report Setup – Cron to help the team to visualize the flow daily.
- ESDS Active Client Study for UAE Market
- Tickets Reports – To gauge the performance of UK Team
- Provide data to QA for audits and Billing team for monthly performance reports
- Implemented new tool for Data Analytic – Tableau
Solution Architecture/ Business Analysis
- Cloud, Dedicated, VPS, Shared and co-location solution. From Business Analysis to Technical Solution and Commercials.
- Contributed in the proposal sent to MSETCL, Supermax, BARTI, Sadhana Bank Presentation, Incyte – Bodhost, Atos, Indorama – Bodhost, Nethority.
- Solution Team(Cost of an individual team member) Cost Calculator
- Service Catalogue revamp
- RACI model of Solution Team
Market Research
- Understanding market requirements through Voice of Customers(VOC) – existing and the potential ones.
- Sharing insights with the product management and development team to help them structure the roadmap of the products.
- Conduct competitive analysis at a regular frequency.
- Prepare/gather reports from major Market research organizations like Gartner, MarketandMarket, etc