Accomplished MIS Executive at RMSI Pvt Ltd, adept in database management and SQL programming, I've significantly enhanced data processing and analysis. My expertise in PostgreSQL and Oracle, combined with strong project management and problem-solving abilities, has driven operational excellence and innovation in GIS and database projects.
• Currently working on RPMS project using PostgreSQL and Oracle.
• I am responsible for designing and managing database structures, manipulating data through SQL queries, optimizing database performance, and facilitating data import/export processes.
• My role involves creating tables, updating and inserting records, performing complex joins, importing CSV files, and utilizing functions and subqueries to retrieve and analyze data effectively.
• I collaborate with stakeholders to understand their data requirements, design efficient database schemas, and provide insights through data analysis.
• I also stay updated on the latest features and best practices in PostgreSQL and Oracle to continuously enhance database management and optimization strategies.
• I am involved in ensuring data integrity and security measures within the database, including implementing access controls and encryption where necessary.
• I provide support and training to team members on SQL techniques and database management practices to foster a culture of data-driven decision-making across the organization.
• Worked on AutoCAD and Spatial.Net.
• Perform all aspects of OSP engineering for fiber projects according to customer requirement and guidelines.
• Provide best route planning to support construction
Requirement.
• Ensure customer network access is reliable and highly maintained.
• Attach fiber/copper cables to poles and place underground cables according to construction requirements.
• Strong project management skills, with the capability to oversee projects from conception through completion, ensuring they are delivered on time and within budget.
• Strong problem-solving skills, with a focus on providing innovative solutions to design and operational challenges.
• Worked on well known application- AutoCAD, Google Earth, Spatial.Net, Magellan.
• Prepared BOM & BOQ.
• Experience in leading and developing teams, with a focus on operational excellence and continuous improvement.
• Worked on zero-mile connectivity amazon project.
• Ensure data finalization and project deliveries.
• Created maps on different platforms (ARCGIS, Customized Software)
• Trained team members for new projects.
• Worked on some pilot projects.
• Discussion with clients.
• Assisted for finalization.
• Assisted team for production and the new requirements of the projects.
• Geocoding of the data.
• Created delivery documents.
Database Management Systems: PostgreSQL, Oracle
Oracle 11g
Oracle 11g