BRIAN L. McVEY

SKILLS

Oracle Databases

** *****

7.x, 8.x, 9i, 9i PE, 10g, 11g, 12

SQL Server Database

* *****

****, ****, **** **********

Oracle Programming

* *****

PL/SQL, SQL, SQL Loader, Data Loading/Conversion, Triggers, DDL Scripting

Data Warehousing

4 years

Informatica Power Center 6.2.1/7.1.2/7.1.3/8, Data Modeling, SSIS, Toad Data Point

BI Reporting

6 years

Business Objects 3.1, 4.1, SSRS, Oracle Reports, Power BI

Others

UNIX, Korn Shell Scripting, Windows 7,8,10, DOS, Visual Studio, C#, JIRA, Linux, SOAP UI, EPDM, Active Directory, ADO, Linux

Business Areas

Retail, Pharmaceuticals, Consulting, Insurance, Manufacturing, Telecommunications, Contact Center Technologies

PROFESSIONAL EXPERIENCE

Humana

Business Intelligence Engineer 2 – IT/DG – (Remote) April 2021 – Present

Interact with business and IT departments in understanding team’s data and reporting uses and needs.

Perform in-depth data analysis to derive insights that drives business outcomes and decision making.

Utilize data skills to uncover data gaps and provide necessary actions.

Self-motivated and possess ability to manage priorities and meet PI deadlines.

Develop data requirements for system enhancements.

HealthCare Support December 2020 – April 2021

Senior Consultant (Contract - Remote)

Worked with Humana personnel in identifying business information and key Genesys data informing responses to development requests.

Conducted interviews with key business user to collect reporting information in assisting Humana’s transition from Avaya to Genesys Pure Cloud.

Voxai Solutions September 2015 to December 2020

Senior Genesys Reporting Consultant (Coppell, TX) – (Remote March 2020 – December 2020)

Provided Genesys consultants with assistance in solving DB and ETL related issues by reviewing code and providing solutions

Genesys including experience in designing complex Genesys data solutions in a (HA) highly available environment as well as understanding of Call Routing strategies.

Provided Custom LOE to existing customers through extensive requirement gathering and discovery discussions

Created reporting processes for ETL job execution, data audit, and metrics (KVP) reporting to Senior Client Management.

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 various clients.

Involved with upgrading all Business Objects reporting from 3.1 to 4.1 for our largest client USPS.

Solid technical experience in Teir 3 Managed Services role developing/supporting Genesys Voice Routing, Real-time and Historical reporting.

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.

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

Database Developer

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

Database Developer

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.

5+ years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various proprietary applications in Online Transactional processing (OLTP) and Online Analytical Processing (OLAP), Data Warehousing and ETL Environment.

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 TMS 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

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.

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

CASH AMERICA INTERNATIONAL December 1996 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.

EDUCATION

University of Texas at Arlington

Bachelor of Science (BS) in Information Systems

Bachelor of Business Administration (BBA) in Management

Contact this candidate