We provide IT Staff Augmentation Services!

Business Analyst - Inventory Resume

Portland, OR

SUMMARY:

  • Accomplished, multifaceted Business Analyst with experience implementing, managing and supporting innovative IT infrastructures, architectures, applications and systems to increase operational efficiency, while supporting strategic business objectives. In - depth knowledge of existing system / software development and implementation methodologies. Committed to helping organizations achieve maximum benefit from their IT investment, through meticulous research, development and implementation of technologies.
  • Business Solutions Architecture & Analysis Systems / Software Design & Development
  • Requirements Gathering Software Optimization Project Management Systems Implementation
  • Process & Business Analysis Programming Testing

COMPUTER SKILLS:

Software: MS Word, Excel, PowerPoint, SharePoint, Outlook, VISIO, MS Project, Lync, Crystal Reports, UML

Programming: SB+, SBClient, Unidata, SQL, Unix, NT, UniBasic, PICK, Python, RPG II, UCSD Basic

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Business Analyst - Inventory

Responsibilities:

  • Excel - Spiral Pipe inventory reports to track steel coils purchased by the ton to shipped pipe sold by the foot with the appropriate conversion from feet to tons.
  • Used Excel formulas to automatically generate inventory reports from up to 28 data tables.
  • Tracked steel from the receipt of raw material to the shipment of finished product.
  • Prepared an inventory snapshot for publication before noon every Monday, Wednesday and Friday to trace steel from raw material to shipped pipe. Helping to reduce waste by about 10%.

Confidential, Portland, OR

Software Engineer IV - Business Analyst

Responsibilities:

  • Convert Unemployment Insurance Quarterly Reports to efile formats which I obtained from State websites to meet state e-filing requirements.
  • Research State web sites to gather updates to State Tax Withholding tables and calculations.
  • On a Scrum/Waterfall team that worked as closely as possible to a Scrum team and still meet the unmovable deadlines of government requirements.
  • Created the “Patches” to install the Tax Table changes via QMSm (Mantis). Used CORA2GIT for Source Control.

Confidential, Portland, OR

Business Analyst

Responsibilities:

  • Update requirements for their new Business Partner
  • Requirements updated in Case Complete. Documents maintained on SharePoint.

Confidential, Warrenville, IL

Business Analyst

Responsibilities:

  • Wrote specifications in MS Word for data migration from client legacy database to NWL WaveOlution database product.
  • Updated Functional Designs to meet evolving standards and database designs.
  • Developed detailed specifications, including screen layouts and database updates (using SQL queries to check database) for administration of data to support WaveOlution direct selling solutions in accordance with client requirements.
  • Maintained Use Cases, screen designs, ERDs, Functional Designs, etc. on SharePoint.
  • Updated Visio ERD's based on actual database based on SQL queries for use of other analysts.
  • Did User Acceptance Testing of application enhancements to ensure proper functionality, recording results in Excel spreadsheets and posting issues to JIRA to track corrections.
  • Wrote specifications to configure client incentive programs in WaveOlution database. On the team which completed project on time to avoid a $100K late fee.
  • Facilitated and increased accuracy of configurations by developing functional designs.

Confidential, Portland, OR

Systems Analyst / Programmer

Responsibilities:

  • Using EDI, ensured accuracy of computerized medical claims processing. Maintained accurate exchange of eligibility and claims data between healthcare insurance companies and healthcare providers.
  • Wrote programs to format and transmit data to medical care providers, banks and the IRS.
  • Transferred data from Confidential & Company system to Confidential system following company acquisition.
  • Provided accounting staff with Crystal Reports of outstanding checks based on data received from banks.
  • Selected application to meet HIPAA compliance requirements for handling healthcare eligibility and claims.
  • Lead the Process Change from legacy system to LuminX by Ebix Health.
  • Played key role in transitioning data to Confidential system with minimal impact to more than 30 clients.

Confidential, Vancouver, WA

Systems Analyst

Responsibilities:

  • Designed car leasing application for bonus car incentive of major client.
  • Traveled to client sites to work directly with users on system designs and fit analysis.
  • Conducted fit analysis producing detailed description of gaps between business needs of client and Confidential software, including proposed solutions ranging from simple procedural changes to custom programming solutions, including cost estimates. Wrote detailed specifications to implement custom programming solutions. Developed SB+, UniBasic and Python programs to implement specifications.
  • Produced fit analysis that was accepted by client, providing Confidential with consistent revenue stream.
  • Worked closely with client to design and implement car leasing program to track bonus car incentive program, enabling client to track vehicle and maintenance costs and notify lessees when scheduled maintenance was due.

Senior Programmer / Analyst

Confidential

Responsibilities:

  • Held responsibility for writing DataBasic programs to enhance Confidential Data Systems products, in addition to developing detailed programming specifications to enhance software solution.
  • Wrote SB+ and DataBasic programs to implement software solutions.
  • Wrote test plans for quality assurance.
  • Reviewed user manuals for accuracy, and installed software at client sites.
  • Enhanced programs to print checks attached to statements with calculation of odd and even pages, saving clients paper costs. Ensured MICR line was printed correctly so checks would be accepted by the banks to minimize check processing charges
  • Worked with IRS and Revenue Canada to meet tax reporting requirements. Analyzed government documentation, designed and coded programs to extract earnings from the Confidential database, and calculated totals to be reported. Wrote programs to facilitate reporting, saving clients from late filing fees.
  • Saved clients time and money, and improved accuracy, by making product sales and recruiting information available to both commission calculation and incentive program systems.

Confidential, Portland, OR

Programmer Analyst

Responsibilities:

  • Worked with the sales force on an iterative (Agile) development of a Finance & Insurance application including data entry, financial calculations and forms printing.
  • Detailed specifications were written in WordPerfect. Programs were written in Reality Basic. I traveled to client sites to install hardware and software and train users.
  • Worked with the accounting team on sales tax calculations, payroll processing and W2 processing.
  • Used MS Project in leading a project team (Analysts, Programmers, Tech Writers, Testers and CSR’s) to upgrade the Automated Labor Time Guide system including the capture of service technician’s time.
  • About 3 years on the standards committee developing standards for documentation, programming, testing and training.
  • Designed and constructed a Finance & Insurance application. Selected a new impact printer and did the code changes to make it work. This was an example of Agile development before it was called that and encompassed the entire Software Development Life Cycle from requirements gathering to installation and user training.
  • Led a 6 person team to make a major to upgrade to the Automated Labor Time Guide application.

Hire Now