SUMMARY:

• Over 18 years of experience in Information Technology as an analyst, software developer, systems analyst and systems administrator.
• Successful in performing all phases of the Software Development Life Cycle (SDLC), including requirements gathering, technical design, development, testing, and production support.
• Managed projects from design through implementation.
• Developed enterprise - wide and global applications.
• Provided production support. Resolved application incidents. Provided assistance to users.
• Performed Quality Assurance Testing using the HP Application Lifecycle Management Testing Tool. Created test plans, test cases, design steps. Executed test cases. Recorded test results.
• Conceptualized, designed, coded, tested and implemented Excel VBA Tools to extract data from files, excel spreadsheets, and databases.
• Mentored / Trained workforce.
• Excellent oral and written communication skills, capable of addressing both technical and non-technical audiences.
• Able to interface with people from all levels of the organization, including senior management.
• Industry Experience: Automotive, Financial, Defense
• Areas of Experience: Marketing Sales and Support Operations, Electronic Forms Management, Financial Business Systems, Automotive Dealer Systems, International Operations, Training, Telecommunications WAN/LAN Planning, Advanced Technologies, Learning
• Broad-based experience in different job roles: Form Management Analyst, Technical Business Analyst, Software Developer, Systems Analyst, Technical Support, Systems Administration, Database Administration, Corporate Training

TECHNICAL SKILLS:

Databases: Microsoft Access, Lotus Notes, Oracle

Languages: Microsoft VBA (Visual Basic for Applications), Java, JavaScript, HTML, CSS, XML, Micro Focus COBOL II, Lotus Notes Formula, LotusScript, Adobe Scripting, Oracle SQL

Software: Microsoft Office (Excel, Access, Word, PowerPoint, Outlook, Project, Visio), HP Autonomy Process Automation Form Designer, Cardiff LiquidOffice Form Designer, Adobe LiveCycle Designer, HP ALM Application Lifecycle Management, HP ALM Defect Management, Oracle SQL*Plus, TextPad, Lotus Notes Domino Designer, TeamStudio CIAO & Delta, LEI Lotus Enterprise Integrator, Lotus Notes Domino 4/5/6/7/8.5.3, Confidential Systems by CHP Consulting

Operating Systems: Windows 7/2003/XP, Unix System V, DOS, Novell NetWare

Networking: Novell NetWare, LAN/WAN, TCP/IP

Methodologies: Agile, Waterfall, SDLC-Software Development Life Cycle

PROFESSIONAL EXPERIENCE:

Confidential, Farmington Hills, Michigan

Management Analyst

Responsibilities:

• Supports the Financial Services company-wide form changes and new form requests.
• Works collaboratively with Daimler Truck Financial, Forms Management Team, ITM organization, Confidential (Office of General Council), Marketing Sales and Support Team, Nexus Business Project Team, in identifying, tracking and converting forms to be used by the new Enterprise Contract Management System ( Confidential System by CHP Consulting ).
• Performs business needs analysis, requirements gathering, specification documents creation, form analysis, form design, form testing, form programming, data mapping, and project tracking.
• Conceptualizes, designs, codes, tests and implements Excel VBA Tools to extract data from form files, excel spreadsheets, and Lotus Notes databases.
• Creates Excel dashboards, macros, workbooks utilizing VBA programming to organize and track the form conversion efforts.
• Creates LotusScript programming agents to export data from Lotus Notes applications to further analyze form information.
• Performs Quality Assurance Testing and documents test results in the HP ALM - Application Lifecycle Management Tool. Creates test plans, test cases, design steps. Executes test cases. Records test results. Performs root cause analysis regarding testing defects. Communicates within team and IT organization regarding testing findings. Assists other UAT testers.
• Performs Quality Validation of data on vendor produced customer communication letters, forms, and billing statements.
• Performs Forms Commonality Assessment in preparation for new form generation and workflow management system.
• Assists in assembling PDF versions of the California Native Language LAW Contracts along with the various language translations.
• Learning how to create targeted monthly marketing billing statement campaigns.
• Works on special projects as they relate to forms.
• Creates training manuals.
• Trains team members.
• Automated processes. Increased efficiencies.
• Conceptualized, created, and implemented Microsoft SharePoint Master File to be used by several departments to track high priority high visibility multi-million dollar project. Incorporated editor access controls, audit logs, cell address change security, email notifications, dialog boxes, multi-value field selections, and VBA programming modules. Ensured data integrity through use of data validations, pick list, lookup codes, dialog boxes, and automated processing agents. One file used as a single point of contact to capture all the template identifiers; i.e., form configuration settings, for forms to be configured correctly to be used by the new Enterprise Contract Management System.
• Conceptualized, created, and implemented VBA Data Mapping Tool to map and capture form fields, field properties, field calculations, form database lookup values from Oracle Tables, button functionality and form programming logic from source form files to target data mapping files for the IT organization and offshore developers. Automated a 2.5 hour manual data mapping process down to an automated 2 second process per form.
• Conceptualized, created, and implemented VBA Data Mining / Search Engine Tool to extract Enterprise form information. This tool can drill down over 1100 data mapped files within seconds and generate metrics on form data.
• Conceptualized, created, and implemented VBA Project Request Database Record Extract Tool. This tool extracts Lotus Notes database form project requests documents and file attachments to Microsoft Word project request documents. Created customized Microsoft Word Ribbon to help user move through the new project request document. The tool also creates a Microsoft Excel extract log report file for auditing purposes.

Confidential, Auburn Hills, Michigan

Technical Business Analyst

Responsibilities:

• Worked with the Technology Life Cycle Management project team to complete Exception Request Forms that captured the assessment, cost benefit analysis and recommendation of upgrading system technologies to ensure IT Compliance.
• Performed analysis.
• Reviewed source documents and assessment data. Performed cost benefit analysis. Made recommendations. Tracked project status.
• Individual Contributor to successfully completing technology assessment for the Chief Information Officer (CIO) of the bank.

Confidential, Shelby Twp, Michigan

Lotus Notes Domino Developer

Responsibilities:

• Performed lotus notes application development.

Confidential, Auburn Hills, Michigan

Senior Application Systems Developer

Responsibilities:

• Responsible for new design changes, breakfixes and enhancements to applications.
• Analyzed client requirements and designed solutions.
• Translated customer requirements into technical designs.
• Interacted daily with customers to clarify requirements and obtain feedback on deliverables.
• Performed Lotus Notes formula programming, LotusScript programming, Java programming.
• Integrated Lotus Notes with Microsoft Excel using VBA (Visual Basic for Applications).
• Performed systems analysis, systems design, coding, testing, implementation of application changes, and production support.
• Identified, researched and solved software and system problems.
• Coordinated the decommissioning of servers in the production environment.
• Participated in Adobe eForms agile software development project to create electronic forms.
• Learned agile software development, UML and Scrum activities. Participated in Scrum, Sprint Planning, Review, and Retrospective meetings. Programmed electronic forms using iterative software development, and pair programming.
• Performed Adobe LiveCycle forms design, Adobe scripting, JavaScript programming.
• Conceptualized, designed and coded user friendly reporting extract process whereby the user can pick and choose what fields they want to appear in the report. This eliminated the need for the user to be dependent upon a developer to make programming changes to the software application.
• Received the Business Systems Operations Excellence Service Award for providing excellent customer service in performing production support activities.

Confidential, Auburn Hills, Michigan

Systems Specialist

Responsibilities:

• Technical Architect / Lead Lotus Notes Developer for Confidential ’s Sales & Marketing group.
• Responsible for new design changes, breakfixes and enhancements to applications.
• Performed Lotus Notes formula programming, LotusScript programming, Java programming.
• Integrated Lotus Notes with Microsoft Excel and Word using Microsoft VBA (Visual Basic for Applications).
• Provided production support and ad-hoc reporting.
• Participated in knowledge transfer sessions with offshore vendor.
• Created transition documentation.
• Conducted training sessions.
• Successfully conceptualized, architected, coded and deployed two major software upgrades to the Sales and Marketing Five Star Dealership Certification System. The upgrades were completed three months in advance of schedule deadlines.
• During Confidential ’s turnaround phase, was assigned special project with direct report to CEO’s team. Created software tool to track/monitor the turnaround transformation activities. Gathered application needs/requirements. Successfully designed, developed, tested and implemented application, including customized security controls. Commended by CEO direct report for fast software development and deployment of application, and a job well done

Confidential, Warren, Michigan

Lotus Notes Developer

Responsibilities:

• Worked collaboratively with the Confidential Product Development organization to create a global issue tracking system to capture the identification, root cause analysis, and resolution of anomalies with electronic modules.
• Performed Lotus Notes formula programming, LotusScript programming, Microsoft VBA programming, systems analysis, systems design, coding, and testing of application changes.
• Created test plans and test cases. Executed test cases.
• Assisted with data conversion and data analysis.
• Created programming agents to facilitate the data conversion process.
• Automated report generation using LotusScript programming and Microsoft VBA programming.
• Automated the import of Microsoft Excel data into the application.
• Automated the export of data from the application to Microsoft Excel.
• Incorporated workflow approval process, security, and customized email notifications.
• Worked closely with customer.
• Demonstrated programming changes at weekly meetings.
• Mentored programmers.
• Individual Contributor to a successful global application for the Confidential Product Development organization.

Confidential, Rochester Hills, Michigan

Responsibilities:

• Completed training in the following: Oracle 9i Database Administration, Oracle SQL*Plus, Java, JavaScript, and HTML.

Confidential, Troy, Michigan

Infrastructure Analyst

Responsibilities:

• Assigned to Confidential account.
• Analyzed client requirements and designed solutions.
• Created business requirements documents and technical design documents.
• Performed Lotus Notes formula and LotusScript programming.
• Wrote and executed test plan and test cases to ensure application quality.
• Wrote system implementation procedures.
• Successfully upgraded server application tools to be used by the Notes Engineering Team.
• Conceptualized and created system tool that automated the manual process of applying customized email template designs based on departmental needs to over 80,000 users’ mail files. The automated process saved hundreds of man-hours to apply the customized designs.

Confidential, Auburn Hills, Michigan

Senior Systems Analyst

Responsibilities:

• Provided network system administration, systems analysis, computer programming, training, data analysis, technical and operational support.
• Recognized by Executive Leadership for consistent excellence in applying technical knowledge and providing attentive, quality customer service and support.
• Served as International training liaison between country offices and the Information Technology Management organization.
• Surveyed and assessed training requirements. Conceptualized and developed interactive Microsoft VBA software tool to quickly gather international training requirements in an organized and efficient manner.
• Performed skills gap analysis. Presented findings to management. Coordinated pilot classes and in-country vendor training.
• Assisted in the daily operations of the Enterprise Knowledge Management Learning Center.
• Created and maintained Departmental and Vendor Performance Metrics.
• Assisted in special projects, including creation of post merger training manual, Merger Activities Database, Strategic Planning Tracking Database, and Executive presentations.
• Provided Telecom liaison support for Confidential ’s global locations.
• Attended strategic planning meetings and International WAN/LAN planning meetings. Prepared WAN/LAN planning documentation and telecom presentations.
• Performed TCP/IP database administration for International sites.
• Served as International Department Information Administrator. Supported Southeast Asia operations, 125+ end-users and three file servers.
• Performed Novell NetWare LAN System Administration. Added, modified and deleted users. Assigned appropriate rights to users, groups, directories and files. Assigned/Changed passwords. Performed file server backups and restored files. Set up and configured printers for LAN use.
• Provided technical support. Configured PCs and laptops.
• Identified, researched, and resolved software and system problems.
• Educated Domestic and International personnel in use of corporate applications.
• Provided desk side mentoring to onsite personnel and remote assistance to overseas systems management team.
• Mentored analysts in Microsoft VBA programming.
• Installed Japanese version of Windows and Japanese version of Microsoft Office onto computer. Demonstrated Japanese version of the Microsoft Office product suite to key executives and leadership staff.