BRIAN L. McVEY
Developer/2000, Developer 6i suite – Forms 4.5/5/6i, Reports 2.5, 3.0, 6i, 10g, 11g
7.x, 8.x, 9i, 9i PE, 10g, 11g
SQL Server Database
Version 2005, 2008, 2012 Enterprise
PL/SQL, SQL, Data Loading/Conversion, Triggers, DDL Scripting
Informatica Power Center 6.2.1/7.1.2/7.1.3/8
Business Objects 3.1, 4.1, SSRS
UNIX, Korn Shell Scripting, Windows 95/98/2000/XP/2007,7,8, DOS, Visual Studio 2008, 2010 C#,JIRA, Linux, SOAP UI, EPDM, Active Directory
Retail, Pharmaceuticals, Consulting, Insurance, Manufacturing, Telecommunications, Call Center Technologies
Voxai Solutions September 2015 to Present
Senior Genesys Reporting Consultant (Coppell, TX)
Ability to be an active team member and provide other Genesys consultants with assistance in solving problems DB and ETL related issues.
Resource having extensive knowledge of Genesys including experience in designing complex Genesys data solutions in a highly available environment as well as understanding of Call Routing strategies.
Proficient in the application of the following call center technologies: Genesys call routing,
Communicate alternative solutions based on improved costs and efficiencies.
Create functional and technical specification documents.
Responsible for the availability and configuration of the Genesys client custom historical reporting development.
Strong written and verbal communication skills.
Currently reporting and billing all time to USPS, per IVR reporting accomplishments in their Speech Storm IVR application.
Installed all 8.5 reporting applications for recent USPS upgrades for their ECC (line-of-business) segmentation project on all applicable platforms.
Effectively engaged as Custom Report’s Developer in the design, development and support of Webi Business Objects 4.1 Universes, measures, dimensions and filters for our various clients.
Involved with upgrading all Business Objects reporting from 3.1 to 4.1 for our largest client USPS.
Go-To on Information Design Tool (IDT) on the creation of custom Universes and connections using various data sources.
WRHowell LLC February 2015 to September 2015
Lead Developer/IT Manager (Ft. Worth, TX)
Sole developer responsible for providing newly formed engineering company IT assistance and on-going translation of business requirements into proprietary business applications.
Worked closely with HR for the tracking of exempt and non-exempt employee’s time in an Access Forms application.
Met daily with upper management and engineering to discuss current IT demands, future IT project initiatives and provided day-to-day assistance to the purchasing department for the processing planning and delivery of WRHowell inventory.
Created SQL Server 2014 databases on company server for employees to track time, create purchase requests and orders.
Developed front end user applications in Access forms and Oracle apex for users to enter their hours, view engineering data from Solid works and EPDM.
Act as DBA in the administration of all company databases, as well as system administrator for all connections to and from the company servers.
Provided on-site IT computer support to all users and office devices including MacBook, Windows 7, 8.1.
Resolved user’s wireless connectivity issues.
Setup and managed all domain users and computers in Active Directory.
DBG LOYALTY October 2014 to February 2015
Database Developer (Irving, TX)
Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
Sole developer responsible for database development and maintenance of Loyalty Programs and online retail mall initiatives.
Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the client's schema.
Practiced self-organization, initiative, and follow-up in carrying out to completion arising projects.
Involved with monitoring and rewriting company projects including large clients as: American Airlines, Marriott, Tracfone and Bank of America.
Performed various application support roles including the set up of new CSR user accounts/passwords, monitored permission/access rights, troubleshot errors, performed maintenance and generated activity reports.
Utilized SQL knowledge in creating/maintaining very complex SQL scripts.
EARTHBOUND TRADING COMPANY February 2014 to April 2014
IT Support (Grapevine, TX)
Worked as part of the Corporate Office team in support of their stores nationwide.
Created complex SQL scripts to aide store personnel in identifying transaction type errors, reporting issues and general hardware and software tribulations.
Collaborated with company staff to optimize working environment and customer service.
Trained IT staff and guided them in helping store users in their reporting and application needs/issues.
ROBERT HALF TECHNOLOGIES February 2014 to February 2014
On-Site at a local client site developing and monitoring Auto-Ordering application in Access 2010.
Created project specifications and worked closely with client determining project scope.
Completed Phase I of the project and delivered the application in a timely manner expediting the reordering process for the client and effectively increasing their daily profit.
INTELLISOFT TECHNOLOGIES INCORPORATION December 2012 to April 2013
Worked according to approved statements of requirements and detailed specification.
Created technical design documents, codes and unit tests for deliverables.
Worked with the Quality Assurance group to support their testing efforts.
Documented tasked related production applications and resolved application issues and answered all requests in a timely manner.
CASH AMERICA INTERNATIONAL August 2009 to September 2012
Technical Systems Analyst (Fort Worth, TX) February 2011 to September 2012
Developed necessary database objects, including packages, procedures, functions and views to aid in the conversion process using complex PL/SQL.
Expanded the existing production environment cycle loading process by developing dynamic data verification procedures and Oracle 10g reports to provide to the BI reporting groups for validation and analysis.
Demonstrated a high level of proficiency to read, write and communicate orally the English language, especially IT technical terms and concepts.
Provided training to various new employees and assisted with expert knowledge on all production related processes.
Documented tasked related production applications and resolved all application issues and answered all requests in a timely manner.
3rd level store support identifying networking/database and other anomalies as company changed from distributed to centralized database.
Performed Business Requirements Gathering, Business Process Analysis, Business Process Modeling, Business Logic, Case Tools, and Business Analysis.
Programmer III (Fort Worth, TX) August 2009 to February 2011
Served as programmer responsible for the design, development, documentation and business requirements for a time tracking system (TMS), using Visual Studio, C# on an Oracle 10g database.
Developed a prototype for approval of the above mentioned application and produced the final version using complex PL/SQL procedures and functions.
Generated reports and user interface forms in a Windows 2007 environment.
Performed testing on web services using SOAP UI 2.0 & 2.5
Brian McVey, Page 2
AMERICREDIT, INC October 2007 to January 2008
Data Warehouse Developer II (Arlington, TX)
Developed mapplets, mappings and configured sessions.
Created and monitored workflows and tasks using Informatica PowerCenter Work flow Manager.
Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations.
Extracted data from different sources including Oracle and Flat files implemented business logic and loaded into the target Warehouse (Oracle).
CAMBRIDGE INTEGRATED SERVICES GROUP, INC. January 2004 to March 31, 2006
Developer Analyst II (Carrollton, TX) (Rehired June 2006 to October 2007)
Analyzed internal and external client’s data and created mapping documentation for converting data into an internal Oracle web-based Worker’s Compensation application.
Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
Extensively used Informatica client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Workflow Manager.
Developed ETL mappings, transformations using Informatica PowerCenter 6.2.1/7.1.2/7.1.3.
Worked significantly on different types of transformations including source qualifiers, expressions, aggregators, routers, filters, update strategies, lookups, sorters, normalizers, stored procedures and sequence generators.
Created, launched and scheduled Workflows/Sessions and was involved in the Performance Tuning of Mappings and Sessions.
Analyzed client’s conversion data; met with end users and business units in order to define the project requirements.
IT TRAILBLAZER LLC (On-Contract) May 2006 to June 2006
ETL Developer - Verizon (Grapevine, TX)
Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
Used Transformation Developer to create joiners, filters, routers, expressions and aggregator transformations that are used in complex mappings.
Created workflows and sessions.
SYSTEMTEC INCORPORATED (On-Contract) April 2003 to October 2003
Oracle Consultant (Columbia, SC)
Designed, developed and maintained product movement and shipping applications using Oracle Forms and Reports 6i for Westinghouse Electric Company.
As per written functional specifications created database tables, SQL queries, PL/SQL procedures and packages as prototypes for the client.
Developed and maintained custom forms and reports to track nuclear fuel usage.
Quick to respond to client requests in meeting DOE specifications and regulations.
MANDOLFO & ASSOCIATES (On-Contract) November 2002 to March 2003
Oracle Developer (Omaha, NE)
Designed, developed and maintained customer/sales invoice applications using Oracle Forms and Reports 6i.
Designed and developed various applications using Oracle product tools for process automation, PL/SQL packages, procedures and database triggers, Unix shell scripts, DOS and Windows 98/2000/NT, based on client/server and multi-tier technology.
Demonstrated the firm's project progress for Merial, Inc., a leading Animal Pharmaceuticals Manufacturer in Atlanta, GA.
Brian McVey, Page 3
VOYAGER INSURANCE COMPANY November 1999 to May 2002
Technical Systems Analyst (Fort Worth, TX)
Assisted in upgrading Oracle Forms 4.5 and Reports 2.5 to Oracle Forms and Reports 6.0 and the subsequent deployment of the system into a web environment.
Designed and maintained a corporate accounting system using Oracle Financials, PL/SQL packages, procedures, triggers and functions on an Oracle 7.3.4 database.
Served as the Lead Developer responsible for developing and maintaining a proprietary application designed to track product information using Oracle Forms and Reports 6.0
Developed an accounting system for multi-business transaction processing using Oracle Forms 6.0, Reports 6.0 and PL/SQL in a Windows NT environment.
CASH AMERICA INTERNATIONAL December 1992 to November 1999
Programmer I (Fort Worth, TX) August 1998 to November 1999
Provided technical support to end users at headquarters and field sites.
Solicited feedback from end users and enhanced system features for new releases.
Technical Support Analyst (Fort Worth, TX) May 1996 to August 1998
Supported and trained field personnel on software and procedural related issues.
Interacted with over 500 shop locations responding and resolving software/computer and procedural issues.
Internal Software Trainer (Fort Worth, TX) June 1994 to May 1996
Developed and trained multi-level internal software programs for over 300 loan and retail operations.
Internal Auditor (Houston, TX) December 1992 to June 1994
Performed all aspects of audit procedures including cash counts, physical inventories and inventory control.
University of Texas at Arlington
Bachelor of Science in Information Systems - 1997
Bachelor of Business Administration in Management - 1991
Brian McVey, Page 4