Business System Analyst

SUMMARY

Motivated and results oriented Business System Analyst. Responsibilities include extensive interaction with diverse user organization and variety of IT teams; documentation according to SDLC methodologies; writing and execution of test protocols demonstrating approved system requirements.

TECHNICAL SKILLS

DATABASES Oracle RDBMS, MS SQL Server

LANGUAGES SQL, SQL*Plus

SOFTWARE Microsoft SharePoint, Microsoft Office, Lotus Notes, HP Quality Center, ISOtrain, Model N Revenue Management, Remedy, Packet Tracker Application (PTA), Business Objects 5.0/5.1/6.5, Cypress, Microsoft Project, MS Visual SourceSafe

PROFESSIONAL EXPERIENCE

Paradigm Technology AbbVie, Waukegan, IL

Business System Analyst 01/2014 – 08/2015

Working on a high visibility Lotus Notes Decommissioning project

Responsible for verifying and modifying Global Inventory database list within SharePoint

Updating record information for 4000+ databases in SharePoint

Responsible for activating decommissions for in scope databases

Verifying legal hold and records retention for each of the databases

Monitor database assessment workflow in SharePoint and make decisions on the next step of the process

Working on a daily basis with members of Records Management team, Legal team and Business Users to successfully decommission archive or replace the Lotus Notes databases.

Testing assessment workflow process for the migration to SharePoint 2013

Fountain Group Abbott, Abbott Park, IL

Business System Analyst 11/2010 – 11/2012

Responsible for gathering requirements and creating systems functional documents

Leading regression test creation and execution for SOX ( Sarbanes-Oxley Act) regulated system Model N

Was involved in the Abbott ADD Symphony Upgrade project; gathering user requirements, creating and executing regression and user acceptance test scripts

Was responsible for creating comprehensive user guides for Model N new enhancements

Provided Model N and HP Quality Center training to the IT personnel

Responsible for creating and executing user acceptance tests for the security systems supported

Provided support for a custom Lotus Notes database used for management of validation packages related to the system lifecycle - Packet Tracker Application (PTA)

Worked on gathering required data and documentation of 100 applications for an internal audit

Participated in the upgrade of the Abbott badging system - OnGuard

Was involved in the Request for Capital Expenditures (RCE), Analysis Rates and Consolidation (ARC), Tracer financial and project tracking system and System for Managing Asset Retirements and Transfers (SMART) systems integration into SAP

Participated in the effort of creating Community of Practices in SharePoint for a variety of systems

Hospira, Inc Lake Forest, IL

Business System Analyst 03/2004-11/2009

Support and development of Business Objects reporting tool

Gathered and created technical design specifications

Created new and modified existing Universes

Created, modified and distributed reports for different business branches of the company

Wrote, conducted and oversaw unit and integration test documentation for Business Objects reports and universes

Performed user accounts management such as managing users privileges for different universes and objects within Universes

Troubleshooting user and system issues and problems

Support and development of Cypress Distributed Storage Management system

Setup and configured new reports for archive and report distribution

User account management consisting of role security and user inbox setup

Troubleshooting system and user issues.

Abbott Laboratories Abbott Park, IL

PC/LAN Support Specialist 06/1999- 03/2004

Performed support and development of Business Objects reporting tool

Business Object Universe and Business Objects repository extensively used, and new universes were designed and developed to support the user requirements

Designed custom reports for Contract Marketing and Finance departments

Maintained security for Business objects users, universes and objects within Universes

Deployed and scheduled reports through BCA.

Troubleshooting user and system issues and problems

Supported source control utility (MS Visual SourceSafe) for 80 + users which involved database administration, database maintenance, project and users security management

Was responsible for preparation of Software Installation Qualification documents

EDUCATION

Bachelor of Science in Business Management 2004- 2007

University of Phoenix Phoenix, AZ

Contact this candidate