Rajnish Gaur

Lead presales efforts for government accounts, ensuring alignment with client requirements and business objectives.

• Conduct detailed needs analysis to understand client challenges and provide tailored solutions leveraging cloud technologies and data analytics features.
• Develop and deliver compelling technical presentations and demonstrations to prospective government clients.
• Collaborate with sales, engineering, and product teams to create proposals and RFP responses.
• Conduct proof-of-concept (POC) and pilot projects to showcase solution capabilities and value to our clients.
• Build and maintain strong relationships with key stakeholders, ensuring client satisfaction and long-term partnerships.
• Stay updated with industry trends and emerging technologies to provide innovative solutions to clients.
• Mentor and train junior presales team members on best practices and solution selling techniques.

Key Achievements:

• Successfully closed deals worth over $3 million by providing expert technical guidance and solutions.
• Led presales team in achieving 150% of sales target for 2023-24.
• Implemented streamlined proposal process, reducing turnaround time by 30%.
• Successfully implemented Data Analytics solutions on distributed platform hosted in-premise for government client in collaboration with vendor.

• Designed and implemented cloud-based solutions for clients on Azure and GCP.
• Provided technical leadership in the migration of legacy systems to cloud environments.
• Developed and documented best practices for cloud architecture and data analytics implementations.
• Worked closely with security teams to ensure compliance with government regulations and standards.

Key Achievements:

• Successfully migrated 2 government applications to the Azure cloud, improving scalability and performance.
• Authored a comprehensive guide on cloud security best practices, adopted by the organization.
• Managing activities that take place during solution ideation, solution design, and solution implementation.
• Creating and maintaining data pipelines workflows on Apache Airflow using Python and R.

• Worked as consultant for "MoRD" project DISHA PMU.
• DISHA is flagship program of Govt of India for effective development coordination of almost all programs of central government in states and districts. It unifies data from 50+ flagship schemes across 23 ministries
• Worked as team lead for LGD, Analytics, ETL.Microsoft Azure
• Responsible for designing systems which enforces data quality and consistency standards, conforms data so that separate sources can be used together, delivers data in a format that enables application developers to build applications and enables end users to make decisions.
• Created various analytical dashboards for DISHA PMU using predictive analytics models, designed to assess historical data, discover patterns, observe trends and use that information to draw up predictions about future trends providing multiple views of performance of schemes.
• Architecture development of Airflow, creation and management of Airflow pipelines, managing database design, implementation & dash boarding
• Supporting the development, sharing, and enhancement of dashboard and reporting solutions
• Conducting system study and coordinating with team members for product documentation, system design & integration, coding, and application maintenance
• Leading, mentoring & monitoring the performance of team members to ensure efficiency in process
• Formulation of dashboard widgets as per user needs
• Advised optimal data architecture and query design
• Collected and analyzed data, provided recommendations from a statistical data analysis perspective.

• Managing activities that take place during solution ideation, solution design, and solution implementation.
• Supporting clients in a cross-functional environment, performed analysis based on requirements analysis and technical evaluation.
• Liaising with users for requirement gathering; preparing functional specifications and high-level & low-level design documents
• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
• Integrated ETL pipelines using Airflow & python.
• Build models in Python using optimal design patterns.
• Analyzed the SQL scripts and designed the solution to implement using Spark.
• Generate actionable insights from data and creating presentations and dashboards to make recommendations for improvement.

• Handled the project single handedly as a Software developer using .Net & Microsoft Sql Server and other technologies
• Have designed the auditing and notification feature for the application for some module
• Have helped the testing team for testing environment preparations and other testing activities
• Successfully completed the project in time and appreciated by the client and management for the same.

• Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions.
• Managing Backups on a daily basis and Recovery as per request.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server.
• Ensuring data consistency in the data base through DBCC commands.
• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
• Upgrading the environment from SQL Server 2000 to SQL Server 2005.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Fixing orphaned users.
• Handling blocking and locking incidents if any.
• Configuring and troubleshooting Log Shipping and Database Mirroring for databases on Production and Development environments.
• Daily interact with developers, is there any performance issue and troubleshoot accordingly.