SUMMARY

• Over 35 years of experience in IT for several Fortune 500 companies. My past 6 years have been supporting OnTrack, a Nice NPM (Performance Management System) for OnStar.
• Strong attributes include very proficient technical, analytical, trouble shooting and problem solving capabilities with experience in Data warehouses, databases, web applications, project management, business analysis, software integration, networking and software development skills.
• S kills include: defining and gathering requirements, designing user interfaces, coding in numerous languages, various vendor software implementations, customizing configuration, product maintenance, and application and user support.
• Other skills include practicing the PMI and RUP project management, software development life cycle, object oriented design, rapid and joint application design methodologies.
• Technical skills include advanced SQL, stored procedures, maintaining and enhancing relational databases such as Oracle, Teradata, DB2, MSSQL, and Sybase. Developed and maintained code using various software languages and have used numerous developer tools.
• Installed and maintained numerous vendor application software on Windows Server 2003, Windows Server 2008, UNIX/Linux servers and in an IBM mainframe environment. Web technologies maintaining Weblogic, Apache, and JBoss application web servers, middleware, and application servers.
• Customized graphical user and data interfaces that integrate with web, client server, windows and mainframe application environments. Previous experience as a Windows and Unix Network Administrator, Software developer, database administrator, PC Support Analyst and User Systems Instructor complement current skill set. I have obtained Confidential, Secret and Top Secret clearances during my career. I am open to working remotely with up to 50% travel, yet I cannot relocate.

TECHNICAL SKILLS

• ETL Ascential Datastage Cognos Reporting, Crystal Reports Oracle SQL Developer, Studio Teradata MSSQL Server Mgmt Studio Nice Performance Mgmt. System (NPM6)
• VB, VB.net, Cobol, CICS, Java, JSPs, JavaScript, HTML, XML, Unix scripting, Cbeans, Joint Application Development Rapid Application Development Security / Networking Fundamentals Word programming, + more Windows, Unix, Web, CAE, and mainframe.
• System Administrator, Windows and Unix, PC Analyst
• Software/Web GUI Design, testing, implementation, integrations, configuration and upgrades Relational databases, Database upgrades / migrations, dba functions, Database application development Advanced SQL, stored procedures Controlled project documentation LDAP, Lotus Notes Designer, Hotdocs, Electronic Forms Systems Document Management Systems Library Management Systems Legal Systems Insurance Systems Manufacturing/Engineering Cad Software

• OnTrack - Call Center Performance Management System Oracle Agile PLM - Product Lifecycle Management System Weblogic - Application Server Autovue - Viewing, collaborating engineering documents Horizon - Integrated Library Management Systems HIP - Online Catalog System Metalib - Federated Search Engine Paisley GRC - Corp Auditing application Law Manager - Legal Case Management System Worldox - Document Management System

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Senior Systems Analyst

Responsibilities:

• Role as an administrator/developer, project management and business analysis skills were utilized when meeting with Call Center/Onstar management and leadership roles on a regular basis and during product upgrades with Nice Systems and update and/or implement new customer business processes into NPM.
• Creating Oracle, Teradata and MSSQL SQL queries to maintain and extract data to/from our data warehouses and into the Nice Oracle database and NPM application.
• Implementing, migrating and deploying new application enhancements to three environments to support business enhances.
• Creating and maintaining source code for numerous DICE conversions for various data feed files, metabeans, cbeans and various system properties files. Maintained cubes.
• Updated the current AOC (automated org chart) process to customize for new sites.
• Gather business requirements and specifications that were used to implement the multiple data sources, custom forms, reports and dashboards for 7 call centers. Have implemented 3 additional sites, rewritten and recreated all existing data feeds, forms, reports, dashboards to meet new business requirements.
• Created and maintain over 100 KPI's used in OLAP reports. Use cbeans and cube query language to create customized facts and calculated metrics. Created, maintain reports for each level within the hierarchy. Created and maintain policies, dimensions, metric sources, cubes, drill paths, drill through reports, pursuits, forms, and any other current NPM functionality.
• Administration and support for a 4000+ user based system using email, bi-monthly SME meetings, a ticket system for password resets and hierarchy issues.
• Skills used in this position: business analyst, systems analysis, system development, system implementation, programming using cbeans, properties files, shell scripts, Cube query language, advanced SQL, trouble shooting and resolution of any issues raised. Web, security, telecommunications, networking, IEX and telephony call recording software fundamental knowledge were required.
• Tools used: Oracle SQL Developer, Oracle DB, Studio Teradata, NPM, DataStage ETL, Cognos Reporting, TigerVNC Viewer, WFM IEX, Puddy, TextPad editor.

Confidential, Canton, MI

Business Analyst

Responsibilities:

• As a Business Analyst my primary responsibility for a short term contract was to meet with clients and gather business requirements, write process flows, define scopes and requirements, functional specifications, technical specifications and system design specifications for a custom Engineering Product Lifecycle Management system written in-house (BEAMS PLM).
• The processes I was responsible for was a adding various component drawing types and a new component search screen with component attribute drill down search with a rating / ranking of components displayed in the result set based on business rules.

Confidential

Application Integration Specialist

Responsibilities:

• Managed and performed the upgrade and implementation of Oracle's Agile Product Lifecycle Management (PLM) software upgrade, a manufacturing/engineering product process management application. This upgrade included the integration and installations of Oracle Agile v9.3.1, Weblogic v11g; an application server, Oracle Autovue; an engineering connector to view and upload design drawings and documents, migrated customized functionality in Agile known as Process Extensions; java applications.
• Integrated Agile to use single sign-on with Active Directory/Weblogic.
• Analyzed, researched and resolved many system configuration conflicts.
• Supported engineering users with Agile issues and problems creating new workflow processes.
• Enhanced a customized MS Access database to include functionality for another department to also use a Work Request tracking system.
• Migrated several databases from MSSQL2005 to MSSQL 2008.
• Performed some DBA tasks, created tables and imported data from other systems, performed adhoc SQL for reporting purposes.
• Monitored and maintained 10 application servers in both test and production environments.

Confidential

Sr. Systems Programmer/ Analyst

Responsibilities:

• Performed all software installations, upgrades, customized software configuration, upgraded existing interfaces, maintained and supported all existing integrated Library applications systems duplicated and customized for each of two networks.
• Managed the implementation and migration of the latest database software upgrades for the Integrated Library Systems. Upgraded and migrated the MSSQL application database platforms from v2000 to v2008, performed SQL enhancements to Views, Stored Procedures, Triggers, Reports.
• Performed Java application upgrades from Java 1.4 to 1.6, recompiled coded fixes and enhancements to custom applications that integrated and deployed to the new environment.
• Managed and coordinated the hardware upgrades for several new Windows Servers 2003/2008, Unix servers, Apache Web servers, and migrated the installed Library applications.
• Provided support to the Library users of the ILS client and Web library applications such as Horizon (library management system), HIP(Online Search Catalog), Metalib (federated search), SFX(meta search), Ariel/ Illiad (Document Delivery, Inner Library Loans), and upgraded many custom java applications.