Microsoft Access and SQL Server Expert
Last active: 20 days ago
16 Years of Extensive Experience as Software System Architect. Developed Applications using MS-ACCESS-VBA & SQL-Server for Automating Business Processes like Managing Clients, Quotes, Purchase Orders, Work Orders, Invoices, and Accounts. I have expertise in Emailing/SMS, PDF Printing, Saving Documents, Data Parsing, and Importing/Exporting Data. Expertise in designing interactive Reports, Forms, Labels with Professional Look and Feel. Thorough experience in developing and integration 3rd Party tools, DLLs, OCX, ActiveX Controls for various purposes like PDF Factory, CHado Text, DBPix, Create PDF, Scanner Setup, Map Point and ActiveExpert Toolkit etc. I have expertise in Google Map integration (Single point, Multiple points, adding tags etc).
Highly Strong in Designing Optimized Databases. I formulate a Complete, Usable, Smart, Robust, Flexible, Scalable, Configurable, Customizable, Integrated and Secure Software Solution.
I have developed hundreds of applications using MS-Access as frontend and SQL Server as backend. I have used ASP.Net for developing Web-Applications with a purpose to provide interface for external stake-holders like clients and vendors. I have developed projects of all sizes, using different technologies for various functional domains. I specialization over developing the mid-sized management information systems using various technologies and architectural models. Technologies framing my core competency are DotNet (C#, VB, and ASP.Net), MS Access VBA, and SQL Server 2005/2008.
I have expertise in Automating Importing/Exporting Date To/From Excel, CSV and various other File Formats including Unstructured File Formats. I have developed modules for Smart Tag Parsing and Publishing DOCs/PDFs on the Fly and also developed systems for saving/emailing them. I have developed many Document Management Systems which are not only full of Feature, but Smart too. I have automated Sending/Receiving of Emails With/Without Outlook. I have even automated Auto Handling of Bouncer Emails and handled Unsubscribes. I have published Calendar Events into Outlook. I have worked on Pushing/Retrieving Data To/From CNC Machines.
I believe in developing a true paperless office by seamlessly integrating business processes, through inventing smart software solutions, using most suited technologies. During requirement analysis, I accumulate knowledge to understand business, its people, their behavior, working environment, associated problems and reasons so that I can develop a functional and constructive solution. I also apply my thought towards defining business process in the shape of well-defined molecules and how they are interlinked.
I can effectively handle all the stages of SDLC. I can help you in writing/refining your specs, analysing the current system and architect the proposed system. I can design well optimized database well considering all future aspects in consideration. I can write create quite attractive GUIs nicely handling the data flow with enhanced productivity. I have through knowledge on software testing and quality assurance, hence can develop robust and reliable software systems. I also know automation tools provided by HP for software quality testing like Quick Test Professional for functional testing and Load-Runner for performance testing. I also have used PHP for developing web-services, HTML/CSS for web-interface.
I am a Java Certified professional and have secured 98% in SCJP Exam. I have knowledge over EJB, JSP, and Oracle. I have also worked on platforms/servers like Weblogic, IIS, Tomcat, Oracle, and MySQL.
On the functional domain, I have handled projects for several domains like hospitals, environmental testing, civil construction, fleet maintenance, airplane parts manufacturing, education, heavy manufacturing industries, forests, and financial accounting.