* Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
* Proven background completing projects under financial and time constraints.
* Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
* Develop GUI interfaces with progress bars and status label to intimate the user about background
process.
* Creating Data validation on inputs to reduce the complexity and runtime errors.
* Accessing and developing customized solutions for clients/users.
* Designed and wrote the automation code for Excel/Outlook/Power point and Access database
queries and resolution.
* Creating link-based module to enable automatic updates for excel workbooks.
* Designing client-specific modules for automatic reconciliation and tracking database
modifications.
* Designing a self-training manual for clients and users.
* Designing an Algorithm and Flow charts using MS Visio wherever require (For Lengthy Projects).
* Developing data validation & input analysis programs prior to final run of process.
* Providing on-site and off-site troubleshoot assistance.
* Ensured maximum performance of processes in coordination with VBS+VBA+SQL