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
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.
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)