Nsight is a leading global technology consulting firm focused on accelerating digital transformation to create winning business solutions and strategies.
- Led key initiatives within the Center of Excellence (CoE) team by managing solution projects, partnership management, weekly/Monthly reporting, RFP & RFQ Documents, pre-sales efforts.
- Collaborated with management to develop tailored solution architectures to meet client needs and objectives.
- Worked closely with the technical team to automate billing and invoicing processes on the NetSuite platform, demonstrating hands-on expertise in custom form creation, records, transactions, analytics dashboards, roles & permissions configuration.
- Utilized NetSuite Analytics Workbook to perform data analysis by employing various visualization techniques.
- Administered Oracle Identity & Security Management and the Oracle Autonomous Database System, ensuring robust-data security and system performance.
- Designed and developed comprehensive Sales & Financials dashboards using Tableau, providing actionable insights to the executive team.
- Created dynamic and interactive Tableau dashboards to monitor key performance indicators (KPIs).
- Utilized advanced Tableau features, including calculated fields and level of detail expressions, to customize visualizations and meet specific business needs.
Project1: N-Hub - Chatbot Development & Deployment
Overview:
- Led creation of intelligent chatbot using Google Dialogflow to streamline employee interactions. Chatbot, integrated with employee portal, handles queries across HR, IT, Finance, Marketing, and other departments, reducing reliance on multiple channels.
Technology Stack: Google Dialogflow, JAVA (for Intent Payload).
Keypoints:
- Developed chatbot with Google Dialogflow, incorporating NLP and machine learning for natural conversations.
- 9 primary intents for HR, IT, Finance, Marketing, Delivery, Admin, RMG, etc with relevant sub intents and entities were included.
- Handles both text and voice conversations, offering precise responses and efficient query routing.
- Significantly decreases employee effort, enabling self-service and enhancing overall Employee Experience.
- Integrated seamlessly with employee portal for easy access.
- Implemented in 2022, serving 300+ employees across regions.
Key Achievements:
- Improved employee experience with quick query resolutions.
- Reduced HR and IT case volume by 30% in six months, promoting self-service.
- Minimized employee effort and dependence on human agents.
- Positive employee feedback on chatbot's utility and effectiveness.
Project2: Database Application for chemical manufacturing industry
Overview:
- Designed, developed, and implemented robust database application for prominent chemical manufacturing industry leveraging Platform-as-a-Service (PaaS) stack.
Technology Stack - Hooperlabs (Platform-as-a-service)
Keypoints:
- Designed and developed database table design for chemical product formulation.
- Created robust table schema with clear understanding of tables and their relationships.
- Built custom forms with various functions to facilitate storage of product data.
- Implemented Advanced Search Criteria (Key Word), Version Control, Bulk Upload, Reporting, and Approval Workflows.
- Enabled Advanced Search Criteria (Key Word), Version Control, Bulk Upload, Reportings & approval Workflows.
Key Achievements:
- Leveraged Hooperlabs, Platform-as-a-Service (PaaS) stack, for rapid development completed within 2-3-week timeframe.
- Successfully reduced implementation costs by 60% by choosing PaaS while meeting all client requirements.
- Streamline and Handle chemical product formulas, Bill of Materials (BOM) and their making procedures.
Project3: Excel Data Processing and Automation
Overview:
- I designed and implemented robust Python script for Excel data processing and automation within context of Excel Automation task for business scenario. Primary objective was to efficiently handle and manipulate data from multiple sheets of Excel file related to shipment and components.
Technology Stack - Python, Excel
Keypoints:
- Developed Python script for Excel data processing and automation.
- Utilized pandas library for efficient data manipulation.
- Processed data from multiple sheets, performed data transformations, and calculated new column.
- Exported processed data to new Excel file.
- Implemented date formatting and grouped data based on vendor preferences.
- Automated creation of vendor-specific output files in designated directories.
- Demonstrated proficiency in handling Excel data and automating file management tasks using Python.
Key Achievements:
- Automated process, streamlining vendor-specific data distribution.
- Increased productivity by 30% by automating Ad-Hoc manual process.
Project4: Easy Portal - GUI Application
Overview:
- Engineered Python and Tkinter-based graphical user interface (GUI) application facilitating swift access to vital portal links for enhanced employee efficiency. Application's tabbed interface and intuitive buttons streamline link organization, ensuring quick and effortless navigation.
Technology Stack: Python and Tkinter GUI framework, Powershell to convert .py to .exe file.
Keypoints:
- Developed with Python 3 and Tkinter, featuring tabbed interface for efficient link organization.
- Buttons within main window seamlessly open links in default web browser.
- Tkinter style configure applied for customized styling of tabs, buttons, and text.
- Easily extensible, allowing addition of new tabs and buttons for expanded functionality.
- Streamlines access to crucial portals with one-click functionality, boosting employee productivity.
- Modularized code for reusable functions, enhancing maintainability.
- Substantially reduces time employees spend searching for portal links.
- Transformed Python file into executable (.exe) file for convenient distribution and use on Windows platforms.
Key Achievements:
- Rapid development completed within 2-week timeframe using Python and Tkinter.
- Intuitive tabbed interface ensures easy navigation for users.
- Effortless link access in default browser without additional configuration.
- Successfully adopted and deployed to 50+ employees within organization.
- Improved accessibility to all portals from centralized location.
- Achieved remarkable 50% reduction in time spent searching for links, enhancing overall efficiency.