Nimesh Pandya

Experience

• 

  NSEiT

  Jan 2007 - Jan 2010

  Associate System Analyst

   As a Module Lead, maintaining the projects (FO, OMS, and C&S) from Database perspective. Designed Database Structure for the Exchange System (OMS) and Clearing and Settlement System. Configured and created wide range of reports on SQL Server Reporting Services 2008 as per the client requirements. Created Packages to generate various types of files automatically using SQL Server Integration Services 2008. Used SQL SERVER SERVICE BROKER 2008 for the Alerts/Notifications. Used Snapshot Replication and Transactional Replication to Synchronize the Data. Configured Linked Servers to Synchronize the Online Management System, Front Office and Clearing and Settlement Databases. Created JOBS to automate the daily activities and monthly activities of Clearing and Settlement. Writing and reviewing the complex Stored Procedures, Functions and Views Tracing the Stored Procedures and Queries on SQL Profiler. Worked on SQL Tool Database Tuning Advisor to get the right indexes on the tables. Using Execution Plan to check the Performance of the Queries. Creating roles, logins, giving access rights to database users for code development Backup and Restore of database, moving database, etc Show less

• 

  IAEA

  Jun 2010 - Dec 2011

  Associate Consultant

   Handling daily calls related to Live-Link and Database administration. Interacting with clients for new requirement. Migration activity from SQL Server 2005 to SQL server 2008 R2. Back-up, restore of database using Net Backup. Installing and configuring SQL Server 2008 R2 and handling post installation tasks. TSQL tasks and database optimization, database creation. Managing Database related AD groups and access privileges for users. Writing database maintenance jobs and creation of Linked servers as and when required. Maintaining various Linked servers interfaced to ORACLE. Managing various replication servers, both snapshot and transactional. Writing queries as and when required. Configured log shipping and mirroring for agency databases. Configured SQL clustering on Windows clustering and managing SQL server in clustered environment. As Live-link system administrator, managing files and folders, access control, configuring system parameters, ensuring system availability as it is used agency wide for document storage. Show less

• 

  UNIDO

  Jan 2012 - Dec 2013

  Senior Software Engineer (Project Coordinator)

  1) Server administration and management:  Database management as well as Web management for 20 SPX offices and IMP portal. Hosting of applications in secure webserver infrastructure. Applying operating system updates, patches and configuration changes. Authentication, encryption and logging using custom .Net modules. Troubleshooting issues like permission assignments, log files backup, performance monitoring and tuning as well as alerts configuration for critical performance parameters. Monitor centrally applications, services, operating systems, network protocols, system metrics and infrastructure components Devising and maintaining the backup and restore strategy via analyzing recovery models based on business requirements. Database clustering of servers on physical as well as virtual environment Scheduled replication jobs for data/content synchronization from member states databases to global UNIDO HQ database Involved in routine audits of software application from security as well as performance perspective.2) Project Coordination and Stakeholder management Worked as a coordinator between the development team and member states stakeholders. Briefing the requirements to the developers and getting the work done as per member states requirement. Acted as an SPOC for all the UNIDO SPX stakeholders and efficiently helped them clarify the issues and/or channeled their issues to development team to resolve. Worked very effectively within desired SLA times. Liaising with counterparts in member states for necessary enhancements. Compiling statistical survey data using various methodologies for report generation Implant necessary training's to end-users. Drafting user manuals and necessary documentation for applications.Project Execution and Reporting: Creating the Project plans, Reviewing Milestones, handling escalations and weekly management reporting.Active participation in Internal and External Security audits Show less

• 

  Cox and kings Ltd

  Mar 2014 - Oct 2015

  Project Manager

  Project Management:• Managing Database team for 4 different projects.• Organizing and facilitating Project Steering and Operating Committee meetings.• Interacting with client for requirement gathering and distributing the work across team.• Internal and external stakeholder management.• Aligning with the Business Analysts for Change requests, Cost and Time estimation. Reviewing the BRD / Approach Document and tracking work item as per RTM.• Good knowledge on Agile methodology: Divided the entire Project plan in Sprint plans and taking daily SCRUM calls.• Established and enabled Change Control in the organization.• Successfully implemented SQL Server 2012 Migration Project within first 3 months with the help of 2 developers and 1 DBA.• Working on technical artifacts for performance improvement and optimization.• Sharing technical knowledge within team and passing on information to help them implement database tasks efficiently.Project Planning and Tracking:• Creating Project Plan in Microsoft Project and dividing the same into logical parallel Sprints• Creating Sprint Plans and tracking on Work Item basis.• Monitoring daily progress in SCRUMS and coordinating in case of any roadblocks/impediments.Review and Reporting:• Weekly code review and taking weekly status meeting with database team.• Handling the release management for SQL Server database scripts and objects.• Preparing weekly status reports/monthly status reports for Database team and presenting to Senior Management. Show less

• 

  Zycus

  Oct 2015 - now

  Currently working as an Implementation Project Manager, implementing Procure to Pay products across various international customers. This includes Project Planning, Tracking, managing multiple stakeholders both internally and at client side. Extensive customer engagement and frequent connects with C level executives. Conducting monthly review meetings and Steering Group meetings.Managing multiple internal Programs for identifying Consulting and implementation partners. Standardizing internal processes for requirements gathering and configuration.Handling accounts worth 2 million + which involves multiple fortune 100 customers. Show less

  • Director

    Oct 2021 - now

  • Associate Director

    Oct 2020 - Oct 2021

  • Program Manager - Enterprise Solutions

    Jan 2018 - Oct 2020

  • Program Manager

    Apr 2017 - Dec 2017

  • Project Manager

    Oct 2015 - Mar 2017