We provide IT Staff Augmentation Services!

Project Manager - Senior Business Systems Developer Resume

Durham, NC

OBJECTIVE:

Leverage business, system, and data analysis skills, client relations acumen, and training/presentation experience to obtain a challenging business/data analyst, database developer or project manager position.

SUMMARY:

Seasoned IT Professional offering over 15 years of experience in developing, implementing, and administering business applications in Financial, Government and Manufacturing sectors. Additional skills include business process and systems analysis, project management, database and systems development, technical training, system/process documentation and technical writing.

TECHNICAL PROFICIENCIES:

Operating Systems: Windows NT Server/Workstation 3.x/4.x/2000/2003, Windows 95/98/XP/3.x, DOS, and others. I have architecture and implementation experience with the following Servers: Microsoft IIS, Active Director, and SQL Server.

Programming: I have experience working with and designing web - based applications using Visual Basic, VBScript, JavaScript, and Velocity Script.

Other Applications: I have mastered many applications - including popular office applications like Microsoft Excel, Access and Word and I am highly proficient Confidential learning new technology, both client/server and web.

WORK HISTORY:

Confidential, Durham, NC

Project Manager - Senior Business Systems Developer

Responsibilities:

  • Wrote project plan based on business process analysis, review of existing needs documentation, and end user interviews/JAD meetings.
  • Designed and built MS Access 2007 database application from the ground up to address business need. Work included creation of forms, queries, reports, tables, VBA to import and export to/from Excel workbooks, functions, indexes, front end/back end databases, etc.
  • Created user and admin documentation, trained end users in functionality, currently serving as DBA for application.
  • Created Access 2007 application used to produce monthly/ Confidential summary reports for QA department in Excel for multiple departments within the company.
  • Leveraged existing report capabilities by reworking existing data sources to fit new requirements
  • Utilized Crosstab queries, VBA, and SQL to create dataset and export/format to Excel spreadsheets report templates.
  • Application launched ahead of schedule, resulted in savings of between 1 and 2 Confidential workdays per month.
  • Built Access 2007 application used by Confidential insurance team to review/edit/correct correspondence data points for Confidential group recipients.
  • Based on user interviews, created forms, queries, reports, VBA code to build application.
  • Wrote user and admin documentation, trained end users.
  • To date have released 5 updates/revisions to application, and serve as DBA/Sys Admin for this application.

Confidential, Austin, TX

Project Manager-Developer/Analyst

Responsibilities:

  • Based on updated specifications, reworked various forms, queries, and functionality of existing application.
  • Rewrote VBA fiscal “scoring” code, reworking various formulas and ratios.
  • Wrote user and admin documentation, trained end users.
  • Also carried out additional project to analyze, rework, and re-launch parallel Access 2003 based system used to determine “ Confidential ” Nursing home operations within state. application used within the department.
  • Performed business process analysis, determined project scope, developed project plan and schedule.
  • Documented existing objects/code/procedures within system, remediated errors in code, reworked procedures and objects to ensure functionality, created additional code (including complex queries) and objects where needed.
  • Rebuilt, modified and re-launched both applications successfully- on time and within budget.

Confidential, Houston, TX

IT Manager, Loss Mitigation Department

Responsibilities:

  • Managed seven person development/support team working on Access 2003/Oracle based application critical to the operation of business.
  • Responsible for deriving development plans, assessing prioritizing and assigning project tasks, setting team goals, establishing time lines and dependencies, assigning resources to tasks and performing administrative tasks necessary to keep team functioning smoothly.
  • Performed as project manager for multiple federal directive technical enhancement efforts, ensuring successful deployment of 5 federal directive software releases.

Confidential, Austin, TX

Auditor/Analyst

Responsibilities:

  • Worked on project to audit, analyze, and rework billing schedules and rates for data/telecom clients.
  • Analyzed expired and existing service agreements and contracts, evaluated historical bill rates, and determinined appropriate current telecomm rates/charges in various markets nationwide.

Confidential, Downers Grove, IL

MS Access Developer/Business Analyst

Responsibilities:

  • Performed business process analysis, conducted interviews to determine current functionality and derive technical requirements for enhanced QC system.
  • Based on system analysis, determined data inputs/outputs for Access and Excel based applications.
  • Created form for controlling regular/specific reports that would take user inputs to determine report content/output
  • Implemented procedures/code to vastly improve efficiency and accuracy of QC effort.
  • Utilized VBA, .pdf outputs, improved user interfaces to achieve efficiencies.
  • Engaged in meetings/teleconferences in order to scope/determine project for Latin American cost capture process, local QA effort.
  • Utilized Microsoft Access, Excel, VBA, ODBC Acrobat for this project.

Confidential, Schaumburg, IL

Access Developer/Project Manager

Responsibilities:

  • Performed business process analysis, conducted interviews to determine KPIs and KPI trees, data sources.
  • Based on client interviews, determined functional/business requirements and determined project scope.
  • Designed, built and implemented MS Access database for project.
  • Designed/prototyped dashboards, determined data feeds, etc.
  • Utilized Microsoft Access, Excel, Powerpoint, and VBA for this project.

Confidential, Austin, TX

Project Manager-Developer/Analyst

Responsibilities:

  • Performed interviews with users and co-chaired meetings with departmental representatives and managers to determine system needs, requirements, expectations and project scope.
  • Based on client interviews and analysis of existing business processes, “reverse engineered” existing process used to determine facility financial ratios. From analysis of existing procedures and through client interface, derived functional specification for project.
  • Analyzed existing business processes to identify if and where efficiencies could be introduced into the process as well as to determine overall application design.
  • Based on analysis and the interview/meeting results, determined project scope, formulated project plan and identified project deliverables.
  • Designed and built application using Microsoft Access, VBA, and Excel. Wrote uat plans, composed test scripts for designated users. Based on test results, performed intensive iterative modifications/testing in order to ensure accuracy and usability of system.
  • Application utilized multiple inputs for lookups, scoring routines, reports, and system permissions.
  • Performed both ad-hoc and “classroom style” teaching in use of system.
  • Due to positive user testing results, launched system one month early. System was a great success, with considerable savings of time realized in data entry, business analysis and viability determination.
  • Increased accuracy and accountability attained through use of the system, with high overall user satisfaction in regards to simplicity, effectiveness and ease of use.
  • Wrote technical documentation for application, providing dba/tech support for remainder of engagement.

Confidential, Foster City, CA

Pre-Sales Engineer

Responsibilities:

  • Reworked/re-engineered major portions of MS Access database, dramatically increasing efficiency and reducing data corruption failures over 90%
  • Created multiple forms used to determine fiscal ratios, sql inputs, date parameters, report composition and subject matter, import/export routines, etc.
  • Based on fundamental change of core business process, led project to re-write back end schema, develop data archive, and re-engineer system front end to interface with new back end. Designed and executed test plan, based on results finished project early, performed cut-over with minimal impact to end user.
  • Managed project to rework existing and develop new standardized month end, compliance, and performance metrics reporting modules as well as new module to assist in reporting for mortgage aftermarket program. Resulting reports improved accuracy of compliance reporting, increased ability to measure employee performance, and assisted greatly with providing financial data for mortgage resale activity.
  • Performed multiple ad-hoc financial analyses, produced countless ad hoc Access reports/studies used for various business activities.
  • Served as dba and technical support lead, responsible for system documentation, backups, user training, security, data archiving, etc.

Confidential, Glenview, IL

MS Access developer/Project Manager

Responsibilities:

  • Based on existing system and project charter/instruction, determined system requirements and design, derived mathematical basis for workload algorithms.
  • Built and installed system, performed iterative user testing, made system changes based on test results.
  • Developed feasibility guidelines to ensure accuracy of workload algorithms, developed and implemented utilities to enforce guidelines.
  • Developed and implemented utilities to ensure data integrity and “cleanliness” pre-import/pre-export. Utilities controlled by forms requiring user inputs in re: subject matter, geographic area, date ranges, etc.
  • Utilized Access, Excel, SQL Server, ODBC in project.

Confidential, Chicago, IL

MS Access Developer

Responsibilities:

  • Performed intensive user interviews, business process analysis, and requirements analysis. Based on findings, developed project plan, project scope, and system design.
  • Developed and built database system. System utilized lookups, reports, and algorithms based on user input controlled by forms.
  • Wrote user test plan, test scripts. Executed plan, performed iterative enhancements/tests to build satisfactory system.
  • Developed and implemented utilities and procedures to ensure data accuracy, system security.
  • Wrote technical and user documentation, performed user training, served as dba for length of engagement.

Confidential, Chicago, IL

Vice President/Treasurer

Responsibilities:

  • Performed the entrepreneurial functions necessary for starting a company- corporate filings, tax documents, financial statements, etc.
  • Co-developed website and marketing material creation, assisted in strategic partner development, client presentations, writing bids and RFPs.
  • Performed and documented network assessments- analyzed networks to identify vulnerabilities, provide software/hardware recommendations for securing network and network optimization.
  • Developed curriculum for and taught MCSE 2000 track classes.
  • Provided client with tailored two week class in Server 2000 install/configuration/security and usage, basics of MS Access 2000. Project included developing curriculum and writing training manuals based on client needs assessment.

Confidential, Chicago, IL

Developer/Analyst

Responsibilities:

  • Served as co-Project lead for development and implementation of registration web-site for national annual convention (30,000 + attendees). Cleansed/edited initial and subsequent data loads, performed daily cleansing to remove invalid/duplicate data. Utilized Access for back end reporting requirements of site, using ODBC to attach to MYSQL database. Performed functional analysis to determine scope and objectives of project. Documented and trained end users on finished application. Established deadlines, evaluated and chose software tools necessary for project, which finished on-time and under budget.
  • Designed and implemented Access database to assist in tracking project progress, milestone achievement and log developer concerns/action items.
  • Collaborated on design (based on client interviews, needs analysis) and implementation of Oracle database (schema, PL/SQL, stored procedures, views,etc.) for web based advertising piece generation tool. Documented database functionality, worked with programmers to ensure efficient interface between java code and database.
  • Worked extensively with clients to design, implement, and revise websites. Analyzed business processes to determine customer and project needs, devised project plans. Used ASP, HTML, and VBScript to implement/revise websites.

Consultant/Business Analysis and Programming

Confidential

Responsibilities:

  • Served as Co-Project Lead/MS Access application Analyst for international effort to implement and upgrade CMMS software application integral to plant operations. Scheduled workflow and personnel, set project timelines, organized tech support. Co-developed training program and wrote training documentation, performed end user training on four continents, served as international technical support resource .
  • Performed needs/business analyses Confidential multiple jobsites, based on finding developed user applications that performed such tasks as job costing, cost/benefit analyses, customer service phone center operations, direct mail generation, mortgage application processing, and lease accounting analysis. Implemented, trained, and wrote technical documentation for each.
  • Served as on-site “technical resource” for Microsoft Access Confidential an international computer equipment leasing company, providing training and technical support to end users across multiple departments.
  • Resolved network problems, configured and installed servers, implemented software applications.

Program Coordinator/Logistics Analyst

Confidential, Novi, MI

Responsibilities:

  • Demonstrated/Sold, answered tech questions about Ford/HP CPD, a CD-ROM based system cataloging Ford's car and light truck parts Confidential conference sites nationwide.
  • Served as customer liaison for HP's "Hot Line" parts program, resolved customer engineer job site call conflicts.
  • Managed National Customer survey program for Ford/HP Service Bay Diagnostics System, Administered/managed follow-up procedures through to resolution.
  • Instituted and coordinated hard drive upgrade program for multi-state area.

1/94-11/94 Project Manager/Access Developer

Confidential, Chicago, IL

Responsibilities:

  • Developed, tested, implemented, trained and administered MS Access database used in data conversion project for Illinois utility company.
  • Responsible for staffing, training and managing all on-site personnel for multiple projects, all of which were completed on or ahead of schedule, Confidential or below budget.
  • Served as on-site corporate liason to client, ensured client satisfaction, ultimately selling two additional projects to client.
  • Implemented networks, served as system admin for project networks.
  • Performed technical design for and managed archiving project of corporate minute documents.

Hire Now