Senior Programmer/analyst Resume
CA
Summary: Senior Programmer/Analyst - Team Leader - Development Manager
- Proficient software application developer with progressive experience as a Computer Programmer/Analyst.
- Skilled in database design and development, trusted to maintain data systems from thousands to millions of rows of data.
- A track record of making processes more efficient and providing solutions that add substantial savings in time and money to the organization.
- Experienced team leader demonstrating ability to direct and train teams of up to 5 programmers.
- BA in Philosophy completed with further studies in Computer Science.
Confidential,
.Net, C#, HTML, PHP,
- Various short term projects for Confidential, Inc to support their systems, as required.
- Refining knowledge and experience with .Net technologies with emphasis on C#.
Confidential, Westlake Village, Ca
Oracle, SQL 2005, Powerbuilder, Excel, VBS, HTML, Windows 2000, Unix
- Significant experience in interviewing clients, creating requirements documents, designing database tables and triggers, creating stored procedures, creating user interfaces, thorough user acceptance testing, deploying applications, producing user documentation and maintaining deployed applications.
- Designed, developed and implemented several significant new applications. Created a revenue recovery process, comparing invoices and receipts that contributed more than one million dollars to the company each year. Designed and created the database tables to support these invoices and receipts and coded a Windows program to interface with stored procedures that processed the data. Worked with campaign managers and supervisors to smoothly process tens of thousands of products sold each week.
- Improved processes to manage hundreds of thousands of sales leads, saving the sales managers (> 18) more than 20 hours data processing per week. Designed, programmed and implemented the Windows interface with the stored procedures which allows auto batch processing of incoming leads and on-demand requests for leads data sheets. This system increase sales productivity and increased income by making efficient use of sales persons' time in contacting new customers.
- Solved the problem of a slow client research website by creating an automated process for gathering data. This made the researchers more efficient and saved hiring an additional researcher. This process was written in VBS.
- Created multiple preprocessing applications to allow manipulation of data by campaign managers prior to this data being auto-entered into the production database. The interface for these processes were created using HTML and VBS.
Confidential, El Segundo, Ca
Sybase, Powerbuilder, Windows 2000
- Worked on contract to Great American Custom Insurance Service and was responsible for processing incoming insurance premium transactions. On a daily basis, these transactions come in via FTP as flat files. These flat files are processed through a number of Powerbuilder and SQL-based stored procedures which checked for problems and identified incomplete transactions. Once checked, these transactions were processed into the production database. Code changes were made as the needs of the client changed and as changes happened in the insurance industry.
- The major contribution was modification of the process to unify all the tasks into one user interface.
Confidential, Camarillo, CA
Sybase 12, Powerbuilder, Windows 2000
- Senior Programmer/Analyst, worked on major and minor changes to the GOLD system. This system automatically accepted orders from various customers and companies. It then tracked the creation and distribution of DVD, CD, and VHS tape orders and status information was sent to the various client companies. The Gold system operates in five sites across the United States and Mexico. It makes extensive use of stored procedures and code inheritance for consistency throughout the system.
- Significant saving in material costs achieved by switching users from printed reports to emailed reports that could be printed on demand.
- Created a process resulting in significant savings achieved by monitoring the efficient use of shipping materials per order.
- Contributed to the application moving one of the five warehouses to automated order fulfillment.
Confidential, Burbank, CA
MS-SQL 7, Powerbuilder, Windows 2000
- Senior Applications Developer responsible for maintaining and enhancing the upDoc system. This system tracked the movies, TV series and other products produced by Warner Bros. Studios and its subsidiaries.
- Work regularly included the client to create groupings of products to market and also to prevent double bookings of products.
- Allocated payments received to the products used and kept statistics on market penetration and viewing.
- Supervised the upgrade of the system from Powerbuilder 5.0 to version 8.0.
- Convert a database of products from an acquired company and placed these products in the database.
- Monitored the database administrator and was responsible for the day to day monitoring of the system.
- Constantly enhanced the system to meet new challenges due to the changing nature of the entertainment business.
Confidential, Thousand Oaks, CA
MS-SQL 7, Powerbuilder, Access, NT Network
- Responsible as Manager of Development for leading a team of three other programmers to design and implement new software and maintain current software to meet the business needs of the company.
- Migration of the legacy system from ACCESS to PowerBuilder was complete.
- Implemented a documentation method and development structure due to the lacked standards.
- Regularly worked with the database administrator, the network administrator and the users to constantly improve the system.
Confidential,Calabasas, CA
Oracle, Powerbuilder with PFC, NT Network
- Senior Programmer Analyst and Team Leader responsible for a team of four other programmers who maintained and upgraded the system.
- Managed databases of several hundred thousand records on an NT Network.
- Held weekly meetings with the users to discuss work priority, problems and report on completed work.
- Worked closely with the accounting department to provide accurate income and expenditure reports.
- Managed a major conversion from an AS400 legacy system into the company Oracle database.
Confidential, Camarillo, CA
Sybase, Powerbuilder w/ PFC
- Lead programmer analyst of a team of 3 to 5 programmers in the development of a variety of programs. Programmed a customer service tracking program used to record and maintain records of phone calls and contacts from providers and patients and the call resolutions.
- Quality assurance testing was provided for a dental practice application. The application maintained data on dental providers and their contracts. From this system directories could be derived and market penetration could be tracked.
- Programmed a standard reporting system which provided a common interface for all users for generating reports.
- Recognition received for team participation in a successful Y2K transition for all our systems.
Confidential, Woodland Hills, CA 8
Powerbuilder, MS-SQL
- Responsible for designing and implementing a set of Powerbuilder 5.0 programs and SQL stored procedures to load and verify customer information. The system updated, added and terminated dental plan members as required. The sets of customer records ranged from records to be processed for more than ten input sets from customers a month. This system used MS-SQL Server 4.2 on an NT Network. The database contains more than 8 million records.
Confidential, Santa Monica/ Carlsbad, CA 7
Powerbuilder, Oracle, Foxpro
- Translated a FoxPro application into Powerbuilder 5.0 with Oracle. Records were entered into the system in batches, verified and uploaded to the database, The program allowed the lookup and updating of student information from a prospect list. Student information wss then used through a sophisticated mail merge program to correspond with the student as required.
Confidential, Camarillo, CA 6
Powerbuilder 5.0, Oracle
- Developed the Information Technology Budget System to report on expenditures for new technology. This was a networked multi-user application designed to track expenditures by operational division. The fixed budget for each division was tracked by purchases of hardware, software and training. Responsible for designing the database and developed the user interface and coding.
1
- Supervised four programmers to develop the Inventory Management System. This system saved $2 million in annual materials losses. Developed the Technical Manual Tracking System to reduce managers' report preparation time from 2 weeks to 1 day. Created the Contract Delivery Requirements List system and the Software Library Tracking System.
Confidential
Oxnard, CA Thousand Oaks, CA
- Was responsible, as instructor, for course content, testing and administration.
- Taught computer program development using Powerbuilder and C.
