Software Developer / Analyst Resume

Title
Software Developer / Analyst

Primary Skills
VB.Net, VBA, SQL, Crystal reports, HTML, Javascript, COBOL, CICS

Location
US-AZ-Phoenix (will consider relocating)

Posted
Aug-06-09

SUMMARY OF QUALIFICATIONS

Business Analyst Developer / Project Manager with exceptional results of delivering performance solutions. Extraordinary in extracting business requirements, analysis, design, integration and problem solving. Highly proficient in VB.NET, MS Access/VBA, SQL, TSQL, Crrystal Reporting, HTML, Javascript, COBOL and CICS. Accomplished leader possessing demonstrated communication, analytical, relationship building and presentation skills.

TECHNICAL SKILLS

LANGUAGES / SOFTWARE
· VB.NET · SQL/TSQL · HTML
· CRYSTAL REPORTS
· ACCESS/VBA · COBOL · CICS
· PEOPLESOFT · JAVASCRIPT · SAS
· CSS · PEOPLETOOLS · SAP
· MS PROJECT · NVISION
· ADSO · GOLIVE · RPG
· PHOTOSHOP · PHP · XML
· FRONTPAGE · FOCUS · DTS
· COGNOS · ADSA
· STORED PROCEDURES · VISUAL STUDIO

DATABASES
· SQL · DB2 · SYBASE · INFORMIX
· IDMS · MYSQL

EXPERIENCE HIGHLIGHTS

GOULD INTELLIGENT
07/2005 - 07/2009
Phoenix, Arizona
Software Consultant
· Maintained and developed and maintained Crystal reports and SQL queries to retrieve data for a Physicians
Group Certification Plan.
· Analyzed business processes for multiple departments for the City of Peoria to develop customized solutions.
· Performed maintenance, development and 2007 conversion of all MS Access databases for the City of Peoria. Interfaced with users to define business and technical requirements, creation of functional and technical specs, user guides and provide training for said databases.
· Re-engineered, converted and implemented a Budget VBA database to a SQL back-end. The database supported 800+ users and was inclusive of 200+ queries, forms, tables and reports.
· Designed and implemented a Salary Survey VBA database for the HR department given to 11 other municipalities for input. Resulting reports used for AFSCME negotiations.
· Re-architected and delivered a Water Conservation Rebate VBA database used to track utility users rebates and increase advertising efficiency of that program.
· Constructed and implemented Applicant Recruitment and Employee Education Reimbursement VBA solutions for the HR department.
· Redesigned a Traffic Signal controlling VBA system for the engineering department.
· Converted Excel workbooks to an VBA database for a Bond Authoring application for the Budget department.
· Created a front-end reporting VBA for the Police department for a software package where reporting was inefficient. This resulted in the user only having to click and run the report in seconds vs. days to create prior.
· Designed and implemented a Gang Intelligence VBA database for the Police department to track and search for gang members.
· Trained users to create their own Access databases.
· Received several commendations for interaction with users and work on databases.
· Wrote a VBA database to extract data from the Budget system to be formatted and imported into PEOPLESOFT.

DAR'S DESIGNS
2000 - 2005
Phoenix, Arizona
Independent Software Consultant
· Analyzed business processes, developed and delivered a Parts Tracking solution for an airline parts refurbishing company. Utilized VB.NET front-end and created the entire SQL database including tables, views, backups, DTS packages and stored procedures. Wrote calls from within VB to SQL for data extraction and manipulation. Utilized Crystal Reports as the reporting tool.
· Converted numerous Excel workbooks into a VBA database
· Created business and technical requirements, software development, report creation, data mapping and audit, extracting data from a legacy insurance claims database reporting for an Insurance Claims Processing Company.
· Performed data mapping and wrote data extract programs to port data from MS Access to a SQL Data Warehouse for reporting for an Insurance Claims Processing Company.
· Created numerous, varied reports from the Data Warehouse. Tools utilized included El Dorado utilities, VBA 2000, VB 6 and SQL server 7.0 and SQL Server 2000. Utilized SQL to extract data for reporting.
· Developed and maintained numerous web sites and graphics from inception to implementation for various clients utilizing HTML, PHP, MYSQL, JavaScript, Photoshop, GoLive, FrontPage, CorelDraw, Illustrator and others. Incorporated personal photography and illustrations in and modified client's existing graphics/logos to give them a more professional look.

ALLIANCE CONSULTING GROUP
1998 - 2000
Phoenix, Arizona
Senior Software Consultant
· Performed analysis, specification writing, programming, testing and documentation of an interface system from AMAPS to SAP for INTEL. Project Leader on that same project. The legacy system comprised of COBOL, CICS, and VSAM.
· Programmed a Bill of Material tracking tool written in VB utilizing SQL, DB2 and Access.
· Wrote SQL queries to extract specific data into an Access/VBA db, calculate lead times, create new records, update existing records, create queries and reports.
· Managed multiple projects to fill in for sabbatical employees for INTEL. Additionally met with users to create business, functional and technical requirements utilizing best practices.

MCDONNELL DOUGLAS TECHNICAL SERVICES COMPANY 1997 - 1998
Tempe, Arizona
Senior Software Consultant
· Executed analysis, business and technical specification writing, programming, testing and documentation of a Parts Costing system for Boeing.
· Led a team of others in the conversion effort and on-line enhancements to the system. The legacy system is comprised of COBOL, IDMS, DB2, ADSO, CICS, SAS, CULPRIT and Easytrieve.

CSK AUTO INC.
1993 - 1997
Phoenix, Arizona
I.T. Business Applications Manager
· Managed the financial, payroll and HR systems on Mainframe, AS/400, HP9000, NT Server, PC and UNIX based systems.
· Identified business and technical requirements, and led the development team for implementation and future enhancements of the applications on these varied platforms.
· Managed and mentored 10 programmer/analysts. For all projects within my realm: defined the phase deliverables, tracks milestones, scheduled roles and resources, managed quality assurance, resolved issues, performed status reviews and reporting, developed standards, change control, and ensured compliance with all policies and procedures.
· Technical manager for the selection, purchase and implementation of a financial (Peoplesoft) and payroll (Smartstream) system from the legacy DBS financials.
· Created Nvision reports from the Peoplesoft system.
· Member of the team that proposed/implemented a “Store to Corporate” E-mail system imbedded in the Paperless Management System providing 540 stores ability to transmit Time and Attendance data and forms to the corporate office.
· Implemented conversion of existing IBM POS system to UNIX based POS system for 540 stores.
· Provided solutions for financial, retail, audit and inventory systems.
· Assisted programmers in QA review and debugging of C code.

HEXCEL CORPORATION
1991 - 1993
Chandler, Arizona
MRP Coordinator
· Supported all MIS support for the Chandler plant including Novell LAN and SCO UNIX administration.
· Created reports from an MRP system.
· Made program enhancements to COBOL programs with an IDMS backend.
· Maintained system security and hardware maintenance throughout the plant.
· Researched, proposed and instituted a UNIX client server system.
· Investigated and selected conversion software for various document tools.
· Trained users in the use of the document conversion tool.
· Developed and proposed to management a plan to turn the Chandler plant into a paperless facility.

MCDONNELL DOUGLAS HELICOPTER COMPANY
1985 - 1991
Mesa, Arizona
Management Systems Analyst Sr.
· Coded programs for the reporting and performance monitoring of CPU and DASD utilization.
· Instrumental in creating the Capacity plan for the MIS department.
· Wrote programs to track DASD utilization and program inefficiencies in SAS and SASGRAPH.
Management Systems Analyst
· Team member for development of the System Architecture and selection of CASE tools.
· Researched, reviewed and recommended various CASE tools for the Information Technology department.
· Headed a project to complete a major portion of a payroll system utilizing a Code Generator on a client server
platform.
· Co-authored the Software Development Methodology.
Management Systems Analyst/Programmer
· Performed analysis and programming for engineering, manufacturing and financial systems utilizing COBOL, CICS, IDMS, DB2, ADSO, SAS and Easytrieve.
· Successfully led a project to redesign an Engineering system.
· Re-wrote a Wire Harness Tracking system for the helicopter written in COBOL and CICS. Created the user guide and trained shop floor personnel in the usage of the application.

GENERAL ELECTRIC CONSULTING SERVICES
1983 - 1985
Cincinnati, Ohio
Computer Programmer
· Performed programming, testing and implementation for a Time and Attendance system utilizing COBOL and a Technical Publication system for GE.

DYNALECTRON CORPORATION
1982 - 1983
Cincinnati, Ohio
Computer Programmer
· Fulfilled programming, testing and implementation assignments for the conversion of expense, liability and payroll applications and a Data Information System for a government agency utilizing COBOL.
· Created User Guides and Maintenance Manuals.

UNIVERSITY OF CINCINNATI MEDICAL CENTER
1979 - 1982
Cincinnati, Ohio
Computer Programmer
· Programmed and maintained Data Analysis System in SAS for a government contract.

ADDITIONAL TECHNICAL SKILLS

· AMAPS/G · CORELDRAW
· SMARTSTREAM HR & PAYROLL
· ILLUSTRATOR · TSO/ISPF
· ALL MS OFFICE PRODUCTS
· ASSEMBLER · SQR
· ENDEVOR · FILEAID
· ABENDAID · EXPEDITER

EDUCATION
· Cincinnati Technical College -- Data processing studies 2 years

ADDITIONAL TRAINING
· Anthony Robbins Mastery University & Leadership Training
· HIPAA statute & rules

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Phoenix, AZ | Resumes in Arizona

View other Software Developer / Analyst resumes