VICTOR J. FROME, JR.
631 N Geyer Rd., St. Louis, MO 63122-2755
Home: (314) 965-7975 Cell: (314) 363-6313 email: majfrome@swbell.net
Web: www.victorfrome.com
Professional Summary:
Senior Project/Business Analyst with many years of experience working in different capacities from architecture and design to development, from process improvement, implementation and release management, to project analysis and project management. Implementation and release management background includes conceptualizing, researching and evaluating possible solutions, designing, testing, and developing new processes, applications, systems and user procedures.
•
Created in-house marketing plans to “sell” management and other departments on using new applications, systems, processes and procedures.
•Developed, tracked and reported project metrics.
•Project management experience including managing concurrent projects through their entire lifecycle, creating timelines, tracking progress and working on budgetary responsibilities adhering to formal project methodologies.
•Responsibilities have included developing project plans, status reports, meeting minutes, issues tracking and communication of application and process changes to user communities.
•Excellent follow-up skills and the ability to meet deadlines in a timely manner.
•Strong leadership and communication skills provide the ability to act as a liaison between all levels of the organization, internal and external business customers.
Work Experience:
Sisters of Mercy Health System 7/05 – 7/08
Business Intelligence Developer and SharePoint Administrator
Initially involved in the development of Oracle views, procedures and functions, development and design of Crystal Reports (10 & XI), and intranet dashboards in support of Mercy’s Genesis ERP project. The Genesis Project is an exciting and ambitious effort by the Sisters of Mercy Health System to transform the clinical and business work processes and enhance the information systems.
•Stripped Lawson data was collected which represents various Human Resources, Financial, and Supply Chain functions. The data was imported into various tools for the purpose of analyzing business trends and prevent potential problems.
•Scripts were developed by usage of TOAD 8.6.083
•Many SQL views were created for the purpose of having Lawson data available for the many, Financial, Personnel, Supply Chain and Payroll Crystal Reports.
•Data mapping of the Lawson’s Oracle system was necessary for the development of the many complex Crystal Reports.
Was a team member who developed the Share Point proposal for management and implemented it within the organization. Once implemented, became the Share Point Administrator who developed, maintained, and operated the Business Intelligence site performed the following:
•Maintained the application security.
•Developed sub-sites.
•Modified site contents which was updated on a regular basis.
•Acted as the point of contact for any Share Point Issues/Problems.
Within a year, other skills were discovered and were put to use. They discovered my dynamitic people skills which were used during the department’s growth from 10 people to over 80 within a little over a year. This new responsibility resulted in the following:
•The creation, implementation, and operation of a very successful interview program which included:
oCoordination with the internal staff, Human Resources, and the many outside IT vendors.
oSetup complex schedules at different sites throughout the organization’s multiple locations.
oFunction as the Liaison Officer for all interview matters.
oMaintain the interview document repository.
oSet up an interview evaluation program with written feedback.
•Created, maintained, and operated an employee on-board process which include:
oAcquisition of equipment and software.
oCoordination of employee physical and system security matters.
oConducted other personal management functions to insure a smooth transition into the department.
•Function as the Department Morale Officer. This include co-worker activities such as:
oDevelopment of motivation programs
oOn Site social activities
oContinuously created enthusiastic messages to department members.
oSisters of Mercy internal and external contribution programs used for the poor, underprivileged, and those in need of assistance.
The last position at Mercy was that of a QA Analyst who was responsible for the Provider Connection Portal/Internal Claims and Eligibility (PCP/ICE) activities such as:
•Transposing Version One specifications into QA’s Quality Center system.
•Developing a test plan, test cases, and test lab scenarios.
•Developed SQL scripts to test the Consolidated Warehouse Developers transformation of data from source to target.
Metro St. Louis 6/03 – 5/05
ERP/Business Analyst
Supported the Core Financials ERP project for a large metropolitan government transportation agency. Major responsibility was to reengineer the current business process in two major phases. The first was to learn the current process flow requirements with the various users. The second phase was to develop the future process flow and present it to the users and the review committee. This second phase also consisted of gathering requirements and analyzing findings. Once approved by the review committee the following was implemented.
•Performed requirements gathering, functional gap analysis, module set-up, generation of system test scripts, design new process flows, reengineering existing process flows and production support. Determined the Business rules and procedures and gathered requirements for the new MRP system. This included the review and analysis of all the existing and future requirements needed by the users across the organization. Created and disseminated reports of the recorded information to Project Technicians, Business Owners and IT staff members.
•Managed and tracked the improved process by developing and maintaining timelines and budgets, implementation plans, and standardized operating procedures as well as keeping an inventory of available resources.
•Created and recommended detail future process flows for the new Oracle system that allowed a very smooth transition from the old mainframe CAS system. Proposed process flows reflected both short and long-term solutions. These process flows of the CAS system were created using Visio. The symbols with detail explanations allowed for the easy creation of the detail future process flows.
•Created a prototype design for the implementation and support process. Learned current process design and developed an improved process design after many meetings with the business owners.
•Developed detailed user operating procedures for smooth processing within the warehouse. This requirement was accomplished by writing in detail all the steps needed to perform a certain task. Screen prints along with MS Power Point assisted in making the procedures easy to understand and follow by the operators.
•Created in-house marketing plans to “sell” management and other departments on using the new Mobile Supply Chain application. This was accomplished by showing management and first line supervisors through presentations, discussions and written documents how efficiency could be increased and cost reduced. Emphasis was placed on examples of other organizations using the type of equipment and software required.
•Conducted staff meetings, training sessions, information gatherings, briefings, and quality circle get-togethers for all members of the staff and management. These interactions were critical to the problem management and resolution process.
•Developed complex ‘Use Case’ scenarios for the new proposed system. It was important to develop these Use Case scenarios to insure the new system would operate in a very efficient manner. After development, the team tried to break the system to see if any problems existed.
•Created a unique Report Requirements database for use by all members of the project. The system was put in place to track project metrics. This reporting system was designed in Microsoft Access. System was assessable by all members of the team. Other members of the organization (on a read only basis) could also review it. The system’s purpose was to identify detailed report requirements for all functions of the organization.
•Developed Mobile Supply Chain system through usage of Oracle 11i Manufacturing, Inventory, Purchasing, and System Administration applications along with various tools such as Visio, PowerPoint, Excel, Word and Oracle’s Metalink TAR system.
•Designed and set-up Purchasing, Receivables, and Mobile Supply Chain. Each Application or Module within Oracle requires certain setup requirements such as late or early delivery, quantity and dollar tolerance. Depending on the application a dozen requirements must be setup according to the Business Owners.
•Defined and set-up Physical Inventory and Cycle Count Procedures. The warehouse operators performed these procedures while management reviewed the results. These applications are necessary for the success of the organizations mission of serving the public.
•Installed and configured Loftware Bar Code software to operate with Oracle 11i. Set-up and configured the many Ethernet 802.11b Wireless Access Point required for the organizations Bar Code Scanners.
•Performed widespread research in various Oracle 11i Applications for Bill of Materials, Capacity Planning, Inventory, Mobile Supply Chain and Shop Floor Control.
•Researched and evaluated new products by attending vendor presentations and performing scoring of the vendor’s product. This allowed team members to compare software, training, support, and additional tools with other vendors submitting their proposals.
Peabody Energy, Inc. 1/03 – 6/03
Lead Developer
Supported Allegro Coal software, which managed buying, selling, transportation & storage of coal. Allegro Coal gives traders, credit managers, risk managers, schedulers and accountants’ instant access to the data they need for rapid, informed decision making. By capturing all of the discreet data elements specific to coal trading, Allegro brings ease-of-use to managing coal in a complete, integrated package.
•Created, developed and implemented various unique Crystal reports in support of the Coal Trade Industry. The reports were specifically devoted to Accounting, Trade, Scheduling, Risk Management and Shipping.
•Developed a warehouse system, which collected information from various Oracle tables. This allowed for snap shots of historical data used for the creation of many sophisticated Access developed reports. These Risk Management reports allowed traders to adjust portfolios used in their everyday customer relations.
•Trained users on the detailed functions of the warehouse system. These sessions were either on a one-on-one basis or in a group (classroom style). Developed detailed user procedures, lesson plans and handouts for the users.
•Created and modified various Oracle views in support of the many Crystal reports.
Independent Contractor 8/01 – 1/03
Business Analysis/System Analysis/Advisor/Trainer/Developer
•Provided Web Based Quality Assurance support to Mercy Health Plans. This new dynamic system required usage of prior analytical and technical test skills.
•Developed Seagate Crystal reports, version 7, for personal endeavors and a non-profit organization.
•Developed a sophisticated Access system using Graphic User Interface (GUI) techniques for computer illiterate operators. Implemented this for Feed My People, a charitable organization, which had a severe problem regarding the accountability of monetary, perishable, and non-perishable items given to the poor.
•Designed and developed a sophisticated Financial Control Information System (FCIS) for Supplemental Medical Services (SMS). The system was developed in Access using Visual Basic for Applications (VBA) coding structure. This system was designed to accept financial information from the state of Missouri, payroll records and data from SMS’ sister office in Kansas City. Online queries and reports were developed to provide a unique profile of the financial situation of the organization. Manual processing of records was replaced with this dynamic system and allowed office personnel to eliminate processing backlogs.
•Evaluated new and emerging technologies, as well as vendors, that would serve the long-term strategic objective of a startup company, Southern Facilities Management (SFM), to become a dominant player in the supply-chain management of the medical pharmaceutical industry for seniors through its portal.
•Presented professional training to senior citizens (Senior Net) on basic computer knowledge and specialty skills needed for the Internet.
MasterCard International 10/99 – 8/01
Project Manager/Web Specialist
•Created, implemented, and operated a unique web usage reporting system for multiple business owners located throughout North and South America, Europe, Asia and Australia. This involved MS Site Server, iLux Enterprise 2000, Web Trends, Access, SQL, Oracle, HTML and various system modifications using Dreamweaver and MS Front Page. API modifications were also made using Telnet and CRT.
•Developed and operated the “LinkBot” system which is an automated tool used to identify broken links and missing pages on the intranet and internet.
•Provided all levels of support to users via telephone, e-mail, detailed conference calls to users at different geographic locations, or by a visit to the user’s site.
•Designed new business processes utilizing the new web usage reporting system.
•Trained business owners on the detailed functions of the web usage reporting system. These sessions were either on a one-on-one basis or in a group (classroom style). Developed detailed user procedures, lesson plans and handouts.
•Developed written and delivered verbal technical expert web analytical advice concerning multiple maintained sites to business owners, web developers and outside agencies. This professional advice assisted business owners to ultimately increase company profits by thousands of dollars.
A.G. Edwards & Sons 9/97 – 7/99
Visual Basic Programmer/Analyst
•Developed a time and accounting reporting system designed to provide managers with an automated tool used to cut cost, eliminate waste, and assist in making the company very profitable. This system was developed using Visual Basic with a Sybase database; Crystal Reports and SQL stored procedures. Every conceivable report for time spent on various mission essential projects was possible with this dynamic reporting tool. After much research, it was discovered that the only tool available to meet the organizational needs was Seagate Crystal.
•Presented all of the designed and programmed systems to a “walk through” committee for approval prior to testing and release to the business owners.
•Developed and maintained the AG Edwards United Way contribution system using Visual Basic with a Delphi database.
•Developed MS Access reports that captured various manpower resource information requirements for high-level directorate teams, allowing managers to make efficient and cost effective decisions.
•Provided all levels of support to users via telephone, e-mail, detailed conference calls to users at different geographic locations, or by a visit to the user’s site.
•Trained users on the detailed functions of the accounting reporting system. These sessions were either on a one-on-one basis or in a group (classroom style). Developed detailed user procedures, lesson plans and handouts for the users.
Business Analyst/Systems Analyst
•Performed analysis, design, testing, documenting, implementation and maintenance of the major mainframe order entry and creative billing systems. This responsibility was accomplished by using TSO/ISPF, Pan Valet, File Aid, Predict, Net View, and Natural. Mainframe modifications were made by changing the Job Control Language (JCL).
•Developed and managed external service agreements with between Martiz and the users.
•Performed workflow analysis using such tools as Visio and Corel Flow. This analysis was presented to the business owners and approved before projects were developed using guidelines in the System Design Methodology (SDM) procedures.
•Using life cycle methodology, designed and developed the following MS Access systems:
•A fulfillment system that included a multi-million dollar billing system for a major frozen food distribution company and a major fulfillment/catalog company. This system electronically processed hundreds of daily orders for merchandise, certificates and travel request.
•A personnel information database capturing detail personal data about thousands of freelance employees and time utilization which provided necessary information for planning and organizing motivational functions/activities for human resources.
•An inventory distribution system consisting of order entry, inventory, and shipping functions. This robust system improved lead times by over 25 percent and decreased inventory by 20 percent thus warehouse space was relieved by over 30 percent.
•An incident tracking system that captured various user and software problems for the Mail order and Catalog System (MACS). This dynamic user-friendly system increased efficiency by over 50 percent and retained historical information for ease of future incident resolutions.
•Developed detailed unit, system, and acceptance test plans. They were then approved, executed and reviewed with all business owners prior to the implementation of the appropriate system.
•Provided all levels of support to users via telephone, e-mail, detailed conference calls to users at different geographic locations, or by a visit to the user’s site.
Mercantile Bank N.A. 9/88 – 10/89
Business Analyst/Systems Analyst
•Conceptualized, designed, tested, and developed user procedures and implemented a financial check ordering system for approximately 50 branches throughout the state. This streamlined system saved check order time by 50 percent.
•Gathered information from multiple departments to write detailed Business Functional Requirements and conduct Requirement and an Impact Walk-through. Develop comprehensive test plans, prepare test cases and test data, execute test plans, write release documentation for member banks, and provide member implementation support.
•Implemented and maintained an automated balancing system, UNITECH Audit/Control Reporting System, for all mainframe financial applications within this monetary institution.
Associate Equipment Corp. 7/83 – 9/88
Data/Voice Information Manager
•Managed the Information Processing System for this automotive after market manufacturing company. This included the maintenance of Interactive Manufacture Control System (IMCS). The various modules within IMCS consist of Material Requirements Planning, Capacity Planning, Shop Floor Control, Receiving, Storage and Inventory Control, Fix Assets, Accounts Payable, Accounts Receivable, General Ledger, and Inventory Control systems.
•Refined systems security and control procedures to include daily backup of total system.
•Performed resource planning and scheduling along with determining cost and time required for programming projects.
•Modifications were made to the COBOL programs to facilitate processing and implement changes requested by various plant and office personnel.
•Maintained and optimized the voice communication system for the entire physical plant.
United States Army 10/62 – 5/83
Commission Officer (Major), Data Processing, Personnel Management & Administration
•As Deputy Commander, directed or personally conducted resource utilization, inventory and distribution management, warehouse operations and labor/management relations using state of art organization effectiveness. Orchestrated and programmed in BASIC a revolutionary microcomputer driven transportation system. This system changed processing from many hours to less than 5 minutes. Efficiency was improved by over 25% with the implementation of this system.
•As Project Manager, planned and controlled site preparation for, installation of and program conversion to a 33 million dollar (1975 dollars) computer complex. Introduced and implemented at corporate level the matrix concept of project management used within a thousand plus employee organization. Exercised staff responsibilities and assisted in the final preparation of the official Request for Proposals (RFP) to be released to the public computer industry.
•As Administrator, directly supervised and have shirtsleeve experience with administrative and personnel operations in computer software design and production oriented organizations.
•As Personnel Manager, orchestrated automated systems that streamlined personnel management procedures, achieved efficiency and expedited processing.
Technical Summary:
Education:
Master of Arts – Management and Supervision
Central Michigan University - Mt Pleasant, Michigan
Bachelor of Arts (Cum Laude) – Business Administration Golden Gate University - San Francisco, California
References:
Available upon request.
