deepak

1 - “Android Native App – Parts Delivery Management System” Successfully architected and implemented a comprehensive mobile solution for streamlining parts delivery operations, integrating with Oracle backend systems through APIs.  Developed end-to-end parts delivery management solution enabling: o Real-time order capture from field sales teams, Automated assignment to warehouse pickers. Inventory tracking across multiple warehouses, Backorder management and fulfillment.  Technical Implementation, Engineered robust Android application with: o Seamless Oracle API integration for real-time data synchronization. Real-time order status tracking and updates. User-specific dashboards for sales teams and pickers. Push notifications for order updates and assignments. 2 - “Fleetwave Complete Monitoring System” ASP.net Web Based App to Control, Monitor & Track Vehicles, Cranes & Gensets • Complete software development life cycle of the project. • Database design, architecture, management, and implementation. • Developed C# server tool to fetch and read Modbus 485, CAN, Serial Device, RS 232 data for communication with the vehicle and generator controllers. • Extensive requirement gathering from managers, field technicians and users of the application. • Conducted comprehensive testing of embedded devices for seamless communication with Generator Controller using Modbus Protocol, enhancing operational reliability and performance. Resolve, Develop and Issue out new ways to handle the efficiency of the software. • Develop reports related to the data retrieved from the generators for effective use and efficiency. • Currently Monitoring over 200+ Vehicles/ Forklifts, 30+ Generators & 5 Cranes. 3 - “Android Gate Monitoring System” • Complete software development life cycle of the project. • Develop & implement web services for communication between Android devices, Web Application for the data. • Testing training the Security to use the Android application. Training the staff to view and monitor the data. 4 - “SMS Work Order Automation” Android Based SMS Collection for Billing & Time Tracking of Employees. • Develop & implement an android application for the periodical retrieval of the SMS data & pushing it to the web service. • Develop web services for validation of employee attendance and validation of task/job Number from Oracle ERP. • Training the employees on the proper use of the system. 5 - “Warehouse Pick to Light Application” • Complete software development life cycle of the project using VB.net, ASP.Net and SQL Server 2000. • Develop & implement the web services and classification of data from the Oracle Warehousing Module. • Testing and training the warehouse handheld pickers for effective handling of the warehouse operations. • Mapping the warehouse for the positioning of the lights (Aisle Level positions) for visual information.

“Software Support” for Kapital (Risk Management) and Chimp (Risk Reporting) Systems  Designed and developed high-performance data retrieval scripts, translating complex user requirements into efficient technical solutions.  Optimized existing database scripts through systematic analysis and performance tuning, enhancing data validation processes and system efficiency.  Engineered automated reporting solutions using Excel VBA, integrating Sybase stored procedures to deliver time-critical financial reports within SLA parameters.  Provided 24/7 global market support for Kapital software platform across major financial centres: o Managed real-time data delivery for Singapore, London, and New York stock markets, ensured timely file distribution to end-users across different time zones.  Maintained consistent service quality across international operations.

1 – Power Builder Application Developer - Production Planning and Control (PPC) Led maintenance and enhancement of mission-critical PPC application built on PowerBuilder 6.5, serving Production, Planning and Accounts departments. Deepak Poornachandran Poolamadai +971-56-599 6598 [email protected] Page 3 of 2  System Enhancement & Support - Performed advanced troubleshooting and code optimization of existing systems, developed custom add-ons using PowerBuilder and Visual Basic 6. Created specialized management reporting solutions aligned with business objectives  Database Administration - Managed and optimized Informix Database performance through, Strategic implementation of database tuning strategies, Systematic indexing for improved query performance. Regular archiving and transaction log maintenance. Implementation of performance monitoring and optimization protocols  User Support & Training - Managed user access provisioning for new employees, conducted comprehensive software training sessions. Provided ongoing technical support to ensure minimal system downtime  Technical Implementations - Successfully integrated Visual Basic 6 modules with existing PowerBuilder infrastructure. Designed and implemented custom reporting solutions for executive decision-making. Optimized database performance resulting in improved system response times 2 - ERP Implementation “Infor VISUAL ERP” Infor VISUAL ERP for the manufacturing and refurbishing Industry was tested out and implemented with the requirements and guidelines of the company.  Analyse and study the current process of system and the requirement of the company.  Study the technical feasibility and scope of the Software / Database / Network to be installed.  Implementation of the ERP Software and Database Installation & Administration, Database connectivity and Daily Backup Schedule on disk and tapes.  Data Migration from Informix Database to Infor VISUAL SQL Server 2005 database via DTS tool 3 – Reports Development for the Visual Infor ERP Successfully led post-implementation reporting solutions development, bridging critical gaps in management reporting capabilities after Visual Infor ERP adoption.  Architected and deployed comprehensive reporting infrastructure serving 100+ users across organization. 10 executivelevel management reports, 18 operational reports for general staff. Custom cheque printing solutions  Designed and implemented integrated reporting solutions using, Crystal Reports and VB.NET for complex reporting needs. Modified Gupta Reports maintaining consistent UI/UX across ERP. Custom T-SQL stored procedures for optimized data retrieval Technical Deliverables:  Engineered seamless integration between custom reporting modules and Visual Infor ERP, ensuring intuitive user experience and minimal learning curve  Developed specialized financial instruments printing system (cheque printing) using Gupta Reports where Crystal Reports implementation wasn't feasible  Implemented performance optimization through, SQL Server tuning for enhanced report generation speed. Efficient data spooling mechanisms. Custom macros for business logic implementation Project Management:  Led end-to-end reporting solution lifecycle including, requirements analysis and documentation, User interface design and standardization. Performance optimization and testing. User acceptance testing and deployment

“Associate Programmer” - VB6 -PLSQL & T-SQL Programmer - Total Branch Automation to Core Banking Banking Software Migration Specialist | Core Banking Transformation Project Led critical data migration initiatives for major Indian banks transitioning from Total Branch Automation (TBA) to TCS's B@NCS Core Banking platform Key Achievements and Responsibilities:  Successfully architected and implemented data migration solutions for 60+ bank branches across multiple institutions including Allahabad Bank, Bank of Maharashtra, Greater Bombay Bank, and Central Bank of India  Engineered an optimized migration framework in Visual Basic 6, reducing core migration modules from 22 to 5, significantly improving operational efficiency and reducing technical overhead  Developed robust PL/SQL stored procedures for seamless data migration across diverse database platforms (Informix, Oracle, SQL Server), ensuring 100% data accuracy and financial reconciliation o Implemented sophisticated data transformation logic in Complex field-level mapping between source and destination databases. Custom calculation algorithms for processing banking software flat files o Automated data cleaning and formatting routines for special character handling. o Streamlined the migration process by automating manual intervention points to minimize user interaction and creating standardized procedures for weekly migration cycles. Developing comprehensive validation checks for data integrity  Provided on-site technical expertise at multiple bank branches, conducting migration testing and real-time optimization of migration processes.

“Tutor & Programmer” – Teaching Mumbai Uni Subjects of Networking, Programming & Web Designing. Served as a technical instructor while developing institutional management solutions, combining educational with practical development skills. Delivered comprehensive technical curriculum in, Computer Networking fundamentals and protocols. Programming and application development. Web design and development technologies. Also Developed and implemented Education Centre Management System featuring, Student enrolment and attendance tracking. Course scheduling and resource management Performance assessment and administrative reporting.