Now you can Instantly Chat with Randhir!
About Me
TOGAF certified and Oracle PL/SQL Developer Certified Associate with experience in various domains including smart cities, IoT, system integration, telecom, E-commerce and finance and also having international exposure Over 18 years 10 months+ of exp...
Show MoreSkills
Portfolio Projects
Description
- I was in the role of Technical Lead for the New Delhi Municipal Council smart city project
- Coordination with stake holders of NDMC
- Regular mentoring and follow-up with my team
- Coordinate for information gathering for FRS, SRS preparation for ICCC (Integrated Command and Control Center) integrations and ERP modules with team including OEMs
- Preparation of HLD and LLD for ICCC integrations and ERP with the OEMs
- Monitoring the project progress and tracking OEM implementation
- Reporting to senior management about project progress
Description
- I was in the role of Solution Architect for the Kakinada smart city project
- My profile included the implementation of the various modules of ICCC integrations, wi-fi, public address system, surveillance, environment sensors, disaster management, red light violation detection (RLVD), automatic number plate recognition (ANPR), variable messaging display (VMD), emergency control box (ECB), smart lighting, automatic traffic control system (ATCS), solid waste management (SWM), smart parking, video analytics etc.
- Co-ordination with stake holders of Kakinada smart city project
- Monitoring the project progress and tracking OEM/vendor implementation
- License verification of software received from OEMs
- Finalization of make/model of BOQ with team
- Involved in UAT test case preparation and subsequent UAT with client
Description
- Involved in requirement gathering and analysis, estimations, solution proposal, architectural designing and RFP writing
- Work on performance tuning of the applications
- Write stored procedures in PL/SQL
- Design and develop database objects
- Work on Cron jobs for scheduling jobs in Linux
- User acceptance test support, analysis and fix of critical defects on production
- Transverse functional testing and sanity verification of deliverables
- Involved in code deployments/production install during all the major releases
- System administrator role on Red Hat Linux
- Performing Oracle DBA operations
- Exposure to BI tools like QlikView and Tableau
- Project Management activities included CAPEX/OPEX, project plans and project monitoring using tools like Gantt chart
Description
- Work on Cron jobs using shell scripts
- Testing functionality of the Crestel system for the end client
- Installation of Oracle database
- Provided support as an FMS person onsite in Lagos, Nigeria for around 9 months
- Use of background jobs in Linux for system maintenance activities
Description
• Executed this project on-site for around 3 weeks at Rome and Milan in Italy
• Worked on implementation of the Elitecore application for the end client
• Installation of Oracle database
• Imparted training on Crestel billing system to end client
• Determining operational feasibility by evaluating analysis, problem definition,
requirements
Description
• Designing the applications in Oracle forms and reports
• Doing development on Developer Suite 9i
• Migration of application from Developer Suite 9i to Developer Suite 10g
• Fix and deliver defects raised by various teams
• Traverse functional testing and sanity verification of deliverables
• Preparing and installing solutions by determining and designing system
specifications, standards and programming
• Involved in implementation of application in development/production environment