Michael Rogers

Contact: 12117 Mackey St  Overland Park, KS 66213

Phone: (816) 309-7576

Technical Experience: Pro*C, Oracle, Oracle Forms and Menus, GUI Development, Unix (Sun Solaris, AIX), Unix Shell Scripting (Ksh, Bash, Sed, Awk), SQL, PL/SQL, C, C++, VC++, DSS Agent, Mainframe exposure, Informix, Perl, Java, Abinitio/ETL, Crystal Reports, HTML, C#.NET, ASP.NET, VB.NET, ADO.NET, XML, SQL Server, Visual Basic (VB), SCCS, PVCS, Visual Age, Microsoft Visual Studio, JBuilder, CBuilder, Microsoft Visual C++, Operational Data Stores (ODS), Data Warehousing (DW), MS Access

Professional Summary: 8 Years

As a Contract Developer for Penpower – (4/04 – Present)

• Worked on a client site in Kansas City as a .NET programmer. The client specialized in GIS and mapping systems. Daily tasks involved using C#.NET, MS Access, and SQL Server.

• Member of the maintenance and development team that performed analysis of code and data in order to write and trouble shoot software. I also worked to continually provide end-user satisfaction by implementing their desired requirements and enhancements.

• Wrote a utility that allowed the end-user to export the contents of a DataGrid in either comma separated, text, or Excel format. The end-user could then use third party reporting tools to view the DataGrid contents.

• Implemented a DataGrid enhancement that allowed the end-user to copy and paste at will. The user could copy any combination of cells, rows, or columns. The user could then paste to either a third party tool, such as Excel, or paste back into the DataGrid. When pasting back into the DataGrid, this created greater accuracy for the users as the risk of typographical errors were lowered.

• Implemented DataGrid enhancements that allowed the end-user to order by multiple columns. The ordering could be ascending, descending, or a combination of both. Also, gave the user the option of choosing which columns they wanted to have visible or invisible.

• Wrote a user interface that displayed the data for several tables in a graphical format. Once the user clicked on the graphical display they were then provided with another interface that helped them create a filter. Once the filter was created by the user it would then be applied to the original display, thus showing a subset of the original. In effect, this tool allowed the user to filter out subsets of the tables based on their specifications.

• Wrote a user interface that allowed the user to select from a list of input tables. Based on the table selected, the user was provided with a list of properties that could be modified. Once the user was done selecting the desired attributes they could save their settings to a serialized file which could be recalled and loaded at a later time. The settings chosen by the user were then fed to other applications which generated reports based off of those settings.

• Primary point of contact for globalization of code effort. This involved verifying that all code had the proper formatting methods for dates and numbers. Also, any strings which were to be displayed were also consolidated into project specific resource files. This effort allowed for easy translation from one spoken language to another by simply changing resource files for that specific project.

• Integrated standardized help utility into all applications.

• The overall goal of the project to which I was assigned was to allow the users to view GIS and mapping system data. The end-user could then manipulate the data by applying filters, choosing to view the data in different reporting formats, and more. While on the team I wrote, enhanced, and maintained several .NET Forms and Menus to help in achieving this goal.

As a Contract Developer for CreateTank - (9/03 – 4/04)

• Member of team that designed and developed Messaging System Framework. This project allowed for easily passing data between numerous systems regardless of their platform. Development was done in Java using J2EE, Perl, JMS, Unix Shell Scripting, PL/SQL, and Web Services. For further information, please see : http://elemenope.createtank.com.

• Current project involves merchandising and web development. A website is being created where customers can shop for a variety of items. Web development was done using Microsoft Visual Studio .NET. Applications were written in ASP.NET, VB.NET, ADO.NET, C#.NET, and HTML/XML. Data storage was done on Microsoft SQL Server.

As a Technical Consultant for Modis - (7-99 – 4-03)

As a Consultant to Sprint

• Data Migration and Production Support Projects - Migrated and converted data to be sent across different servers and databases to accomplish database mirroring. This involved setting up automated Unix Shell Scripts and Perl Scripts to extract and massage data from Informix and Oracle databases into text files. These text files were then FTP'd to destination servers where another automated process was executed to load the text files into the desired target tables.

• Maintained database integrity through data validation, constraints, and keys for any records that were inserted, updated, or deleted.

• Analyzed and researched both data and SQL reports generated by DSS Agent and Crystal Reports in order to improve speed, enhance performance, or to provide validation of data.

• Enhanced and refined database query performance for both Oracle and Informix databases.

• Wrote and tested database triggers and stored procedures using PL/SQL for Oracle and Informix databases.

• Created tables, sequences, grants, keys, and indexing for testing environments on Production Support and Testing machines. Work was done on both Oracle and Informix databases.

• Provided data maintenance according to customer specifications and needs. This work was done on both Oracle and Informix databases.

• CRM Application - CRM was used for marketing purposes and for tracking customer feedback. Was Production Support Member of team maintaining the application. I developed and maintained code in a 24x7 production environment. I also was a point of contact for Customer Support, clients, and issue management. The work environment was Unix using C, Pro*C, SQL, PL/SQL, Access, Crystal Reports, DSS Agent, and embedded SQL.

• Wrote numerous Unix shell scripts (ksh and bash) to assist in processing and monitoring operational tasks. Also wrote shell scripts to act as wrappers to call executable code in a Control-M environment.

• Assured end-user satisfaction and knowledge transfer by investigating their issues and concerns. I would perform research and provide them with the appropriate documentation and the findings of each investigation.

• NIDA Application - Application was designed as a repository for all company data. Provided technical support to both operational data store and data warehouse. I developed new code and maintained existing code in a 24x7 production environment. As a member of the maintenance team, I was a primary point of contact for Customer Support, clients, and their issue management. Work was done using Korn Shell, C, Embedded C, Perl, Java, and PL/SQL in a Unix environment. Databases were Informix and Oracle.

• Source Code Library Project - Wrote, maintained, and enhanced an in-house repository for source code. The user interface and tools for checking code in, out, etc were done primarily using Korn shell.

• Network Forecasting System - System was designed to track trends in customer service. Was a primary member of team to code and design the application from creation to production phases. This involved requirements gathering, assignment of tasks and projects, deadline creation, status meetings with clients, coding, creation of test plans and test environments, testing, migrating code to production servers, and support of the live application. Work was done using Korn Shell, C, Embedded C, and PL/SQL in a Unix environment. Databases were Informix and Oracle.

• Omni Project - Primary Developer for HTML parsing project. A Web Services file was sent from the client site in HTML format. Our process would then parse the HTML file and load it into Informix tables based on tags. Coding was done in Java using Visual Age.

• Experienced with both SCCS and PVCS source code utilities.

• Wrote scripts in Sed and Awk to assist in day-to-day duties.

As a Systems Developer for Multi Service Corporation - (9/95 – 6/99)

• Oracle experience gained by modifying and creating Oracle tables. Created user roles, schemas, and grants. Did performance tuning, troubleshooting, and debugging of unique keys. Ensured data integrity through constraints and keys. Worked with SQL Loaders to export and import data across systems.

• Wrote, enhanced, and maintained numerous SQL Reports using Oracle and forms and menus utilizing Oracle Forms and Menus for the accounting, customer service, operations, and managerial departments.

• Texaco Project - Worked with a team of four programmers to design and maintain an entire credit card billing application utilizing C, Pro*C, Oracle, SQL, PL/SQL and Forms 3.0 on a Unix operating system. The scope of the project involved everything from capturing all of the actual daily transactions to printing out the monthly bill for each of the credit card holders.

• Y2K Project - Team leader. Evaluated all of our team's source code to identify any Y2K changes that were needed, implemented the code changes, created test cases, built a suitable testing environment, and developed testing procedures to validate the implementation. While Team Leader I assigned tasks, scheduled team meetings, and provided help and support to the team members.

• Avfuel Project - Rewrote an older billing application. This involved rewriting code and migrating data from a VAX/VMS to a Unix operating system.

• Primary point of contact for Customer Support. I supported 100+ in-house end-users that used Oracle Forms and Menus (GUIs) to accomplish their daily operational tasks. While in this role I worked directly with the customers and provided hands-on troubleshooting, support, and teaching. Customers were able to provide me with lists of enhancement requests, system improvements, and software problems.

• Trained end-users on new and existing software. I personally configured each end-user's PC for the new user interfaces. I also taught classes where I instructed small groups of users how to navigate and use any interfaces that were new to them.

• Assisted in troubleshooting and maintenance of software and hardware problems.

• Was responsible for 24x7 on-call troubleshooting, maintenance, and support.

• Assisted and verified completion of daily processing tasks by weekend staff.

• Mentored new employees by providing training, guidance, and assistance.

• Interviewed programmer applicants.

Educational Summary:

BS in Computer Science with an emphasis in programming from the University of Kansas – Lawrence, KS (1993)