About jsmorgan24 Name:  jsmorgan24 (see 21 ratings)   in Royersford, Pennsylvania United States Seller / Coder Rating:  9.47 (Superb) Sign up date:  Mar 26, 2002 12:44:58 PM EDT Last Logged In:  Jul 19, 2003 2:54:36 PM EDT Jobs Started:  28 Jobs Completed:  27 Missed Status Report Warnings Issued:  0 Arbitrations Lost:  3 (out of 4 Arbitrations) What is arbitration?       Post a new project exclusively for jsmorgan24   Invite jsmorgan24 to bid on one of my existing projects    Send jsmorgan24 a bonus   Add jsmorgan24 to my custom list of favorite coders     Areas Of Expertise:  Visual Basic VBA Database Architecture SQL Server Web Design (HTML, ASP, Javascript) Microsoft Office: Excel Powerpoint Word Access ASP   Resume: DESIGNER/DEVELOPER for Wyeth Datapack application used for processing weekly, monthly and quarterly pharmaceutical data. Developed in Visual Basic with an MS Access 97 back-end database. Estimated 50% to 75% accuracy improvement over previous MS Excel macro-driven system.· Used ADO Objects to both build MS Access databases dynamically and for loading over one million pharmaceutical data records on a monthly basis. DEVELOPMENT TEAM MEMBER responsible for new development as well as performing maintenance on existing production programs used to provide clients with medical and pharmaceutical data.· Wrote VBA modules for MS Access and Excel. APPLICATION DEVELOPER for an initiative to create a repository of enterprise-wide print vendor performance data. Developed in Visual Basic with an MS Access 97 back-end database; provided an annual benefit of over $1MM in cost savings through improved quality and better leveraging during contract negotiations. ·Full lifecycle development ·Provide system documentation and user training .Facilitate meetings with management and end users APPLICATION DEVELOPER for the design and development of several Access and Visual Basic based systems, including Inventory Reporting Engine, Corporate Travel User Profile System and Supplier Performance Tracking System ·Used ADO Objects to connect multiple Visual Basic applications to Oracle, MS Access and SQL Server databases ·Developed several VBA applications with Microsoft Office, to include MS Access, Excel and Word. PROJECT LEAD for the development and implementation of the redesigned Corporate Travel intranet site. Technologies used include HTML, Javascript and ASP. Facilitated meetings with Corporate Travel Manager, travel agency associates and WEBCOM representative. TECHNICAL MEMBER for the design, development and implementation of an integrated on-line Travel Reservation system. With an average annual corporate travel spend in excess of $20MM, the initial phase projected savings of $2-3MM by 2002. TECHNICAL MEMBER of M&A software development team responsible for analyzing current programs and procedures. Assisted in the design, development and implementation of upgrades to existing applications and several new, more cost-effective applications. Provided a reduction of 20% production time. ·Several full lifecycle development projects ·Provide system documentation and user training ·COBOL, JCL, Easytrieve DESIGNER/DEVELOPER for the Stellar Performance Tracking System used my senior management to recognize exceptional associate performance. Developed originally in MS Access 97 and later upgraded to a Visual Basic front-end application. Provided email notifications to senior management and associates being recognized. MIS ANALYST for Underserved Markets solicitation team; responsible for the segmentation and processing of vendor-provided names for solicitation mailings. TECHNICAL MENTOR to programmers with less experience in MS Access and Visual Basic. Facilitated weekly development training sessions.DEVELOPER of electronic surveys using automated E-mail and Visual Basic capabilities to conduct skills assessments, corporate data collection and customer satisfaction reviews for database capture. INCENTIVE ADMINISTRATOR for the Secured Card Department consisting of over 1,300 phone, data-processing and support personnel. Provided management and senior management with performance data on weekly, monthly, quarterly and yearly basis. DESIGNER/DEVELOPER for the secured card incentive tracking system (SCITS) used for the storage and analysis of all customer service call center data. Developed in Visual Basic and MS Access 95. Education: Bachelor of Science Information Systems     Rent A Coder Work History All ratings and comments are the opinion of the poster and do not reflect the official view of Rent A Coder. Rated For Rated By Rating Bid Amount Rated On   Word and Excel Clone Application Ian Ippolito (RAC) None Given $650.00 June 11, 2003 12:58:15 PM EDT   The coder accepted the work and then stated that they did not have the proper software to complete the project.     Cleaning a text file cmhsieh54 10 (Excellent) $150.00 April 22, 2003 1:52:55 AM EDT   Once again, great work!     Bonus for jsmorgan24 on 4/10/2003 1:59:15 PM cmhsieh54 None Given $25.00 April 10, 2003 2:01:03 PM EDT       Computer program to extract from text file cmhsieh54 10 (Excellent) $75.00 April 10, 2003 1:42:23 PM EDT   JSMORGAN is extremely professional, prompt, and polite. He delivered the program to me almost 2 weeks ahead of my schedule! A+++++++     Simple Stock Control System whiteLotus 10 (Excellent) $35.00 March 28, 2003 7:31:33 AM EDT   It was an absolute pleasure working with John. He replied to all my emails promptly, took him very little time to understand exactly what I needed, gave me regular updates and finished the project on time. I couldnt ask for any more and I would definately recommend him to anyone. I will definately be working with him again.     Visual Basic frm contruction Ian Ippolito (RAC) 2 (Bad) $30.00 March 12, 2003 10:53:42 AM EDT   The coder did not complete the project.     School Registration Ian Ippolito (RAC) None Given $375.00 February 18, 2003 1:35:27 PM EDT       Need an excel macro JTIDev 10 (Excellent) $100.00 January 23, 2003 1:56:44 PM EDT   Jsmorgan24 finished the most important part of the project in no time. He is extremely knowledgable in the VBA area. I look forward to using him on my other excel projects.     text file sorting aristotle1 10 (Excellent) $100.00 January 12, 2003 12:50:20 PM EDT   Prompt & professional service. He did exactly what I requested with no fuss     Excel Macros Needed(for jsmorgan24) TheStatMan 10 (Excellent) $40.00 December 18, 2002 6:08:34 PM EDT   Got just what I asked for. Good work!     Bonus for jsmorgan24 on 7/20/2002 9:53:33 PM beau None Given $10.00 July 20, 2002 9:57:22 PM EDT       update quality.xls beau 10 (Excellent) $10.00 July 20, 2002 9:52:46 PM EDT   Excellent service. Thanks so much!     Graph for VB application JohnnyM 10 (Excellent) $200.00 July 17, 2002 6:42:16 AM EDT       Mailing Label Ian Ippolito (RAC) None Given $60.00 July 10, 2002 5:37:05 PM EDT   Coder dropped off the project citing family reasons     Mailing Label APATEL None Given $60.00 June 17, 2002 11:04:31 PM EDT       a simple file stream string operation program dan37_123 10 (Excellent) $150.00 May 28, 2002 6:44:53 AM EDT   John, I found it extrmely pleasent to work with him. His approach was very professional, the code was very clear and well written. Communication with him was a pleasure. So if anyone wants a dependable, deadline RESPECTING coder, John is the right person.     Setting up TrendGrid in Excel beau None Given $70.00 May 22, 2002 9:33:36 AM EDT       Break one large excel wkbk into wksheets beau 10 (Excellent) $10.00 May 17, 2002 11:18:03 PM EDT   Very quick and efficient.     vb to make new files beau 10 (Excellent) $20.00 May 17, 2002 10:02:51 PM EDT   Great, as usual!     Excel Formulas to calculate by month/staff/quarter beau 10 (Excellent) $10.00 May 15, 2002 12:47:29 PM EDT   Thank you sooooo much!     Bonus for jsmorgan24 on 5/12/2002 10:50:51 PM Tina McElroy 10 (Excellent) $30.00 May 12, 2002 10:54:50 PM EDT       memory2 Tina McElroy 10 (Excellent) $10.00 May 12, 2002 10:50:37 PM EDT   I enjoyed working with jsmorgan. He helped me tremendously with my project.     Hide short text in jpg file Louka None Given $50.00 April 29, 2002 10:32:05 AM EDT       MS Access Text Search steved None Given $40.00 April 25, 2002 2:57:39 PM EDT       Power Point Thingy mwade 10 (Excellent) $40.00 April 24, 2002 3:47:57 PM EDT   Great work in a very short amount of time…     Random Generator II lflores92201 10 (Excellent) $20.00 April 19, 2002 5:37:31 PM EDT   Thank you.     Automatic Teller Machine DirtRacng 10 (Excellent) $35.00 April 19, 2002 8:21:00 AM EDT   Very fast turn around time. Well domcumented code in VB. I will definately use him again! Highly recommend.     Expert Support Diagnostic System on Common Corn Diseases Ms_pacific None Given $25.00 April 18, 2002 10:34:09 AM EDT       Excel VBA, convert sheet to update SQL statement 5947 9 (Superb) $15.00 April 17, 2002 5:56:54 PM EDT   John did a very good job! The communication in between the project is excellent. He delivered much more than what I expected. I will use him again. Great job!!     ASP/Database Online Questionnaire Eddyyoynoy 8 (Very Good) $45.00 April 14, 2002 6:53:25 AM EDT   I was very pleased by the work that John produced for me. He displayed a very good understanding of the problem in hand and included extra ideas and features that i had previously not thought of. I recommend him to you all and hope he can produce the same standard of work for you that he did for me. Thanks John     Automatic Teller Machine(for jsmorgan24) DirtRacng None Given $35.00 April 13, 2002 9:41:49 AM EDT       Small Access Project Wampy1 10 (Excellent) $35.00 April 8, 2002 5:51:26 PM EDT   Wow! John did an excellent job! I was very concerned that posting this project would be difficult, because it was slightly complicated in what I wanted and I thought the coder may have problems comprehending what I needed. I expected a lot of dialogue to try to get a finished project. Not the case with John. He obviously took great strides to understand my project description, and completed the work in a few short hours, and it was flawless!!! I know a lot of people give 10's to coders just for completing the work on time, but John really deserves a 10. I will work with him again, and highly recommend him to others. Thanks John, for doing a superb job!     Bonus for jsmorgan24 on 4/24/2002 3:48:04 PM mwade None Given $20.00  EDT       ------ Average:   9.47