Sales Data

JOHN M. LYONS

*** ********* ****, ***********, ** 19335 484-***-**** *************@*******.***

Senior Engineer

PROFESSIONAL SUMMARY

Versatile, high-energy professional experienced in integrating people, processes and technology to design, build and govern solid, secure database systems and document operational processes that support business endeavors. Diplomatic problem solver with extensive experience implementing large-scale and highly complicated projects. Skilled in multiple technologies and environments.

CORE COMPETENCIES

Data Warehouse ETL Data Integration Data Modeling & Analysis

Database Management Agile Development Design, QA & Testing

Canonical Models Process Improvement Best Practices Documentation

TECHNICAL EXPERTISE

Databases: Oracle, MS SQL Server, DB2, Netezza

Languages: PL/SQL, XML, VBPro Script SAS Shell Scripting

Software: Informatica PowerCenter, 9.5, 10.1 IDQ, PowerExchange/CDC,

IBM WBI / Crossworlds, COBOL

Tool Set: SQL, Tibco,, SQLPlus, SQLLDR, Microsoft Office, Git, SVN, ServiceNow

Environments: Windows, UNIX/Linux

PROFESSIONAL EXPERIENCE

QVC Inc., Philadelphia, PA 1999 - 2019

World’s largest electronic retailer.Multinational corporation, specializing in televised home shopping.

Senior Engineer – Informatica Administrator/ Developer

Informatica subject matter expert Includes administrator responsibilities such as application migrations, and provide best practices in using Informatica Power Center. Provided 24/7 support.

Developed Informatica workflows for Google Product Seearch project. Workflow extracted product data from several sources and translated into XML which was used in making products more visible in internet searches.

Developed Informatica workflows to convert data to be used in data loads for new systems such as Vendor Data systems.

Served as SME for EDW development team in help debugging maps, sessions, etc.

Support multiple initiatives across application areas such as marketing, distribution and sales

Provided technical expertise for database development efforts, including requirements gathering, analysis, functional design, testing and implementation of enterprise data stores.

As a member of the EAI team, designed and developed middleware solutions integrating legacy systems. Modeled and aggregated tables to analyze sales and distribution data as part of the customer service development team

Constructed canonical data models, designed schemas and worked with development team members on the implementation of data extraction processes.

Performed complex data extractions for ad-hoc reporting. Ensured integrity and security of master file data. Documented best practices to improve operational efficiencies.

Key Achievements

Techincal Lead on Informatica Upgrade project. Requirements including upgrading OS environment and repository. Upgraded from PC v9.5 on AIX using UDB with upgrading to v10.1. on VM Linux using Oracle. This required communication to multiple technical groups thoughout the company, including system admins, network support, Oracle DBAs, workstation support, and data security. Implementation responsibilities included processes to convert repositories, install software, as well as a directive role to development teams.

Built confidence in management in using Informatica. Solved installment issues, provided technical guidance, and developed system processes to manage execution and migration of production workflows. Serve as SME on Informatica. Communicated procedures and guidelines in using PowerCenter to the application teams. Served as resource on multiple application projects across all application areas.

Received “Rite Award” for developing Informatica Workflow which sent product information to a large search engine organization.

Received the “Making a Difference” award for uncovering $550K in missed shipping charges and fraud as a result of a special project focused on detailed data mining and analysis.

JOHN M. LYONS, page 2-484-***-**** *************@*******.***

SALES FOCUS TECHNOLOGIES, INC., Dowingtown, PA 1994 - 1999

Independent IT consulting firm.

Senior Consultant – Sales Force Automation

Provided expert consultation services for major pharmaceutical client.

Focused on enhancing sales force automation technology.

Executed activities related to design analysis and implementation of key features of the client/server application including sales force realignment, data extraction, and prospect rating.

Developed data warehouse tool interfacing into the sales automation system, including design of the data warehouse model, and data extraction rules.

Supported call system application aggregating sales and marketing call history. Converted Electronic Mail Process from Windows 3.1 to Windows NT. Communicated program timelines, milestones and deliverables.

Key Achievements

Expanded client sales 20%, through enhanced functionality of client CRM application, delivering an SQL based process to realign sales territories.

Successfully delivered customized SAS and SQL processes to analyze sales results, completing project on time and on budget.

EDUCATION

Bachelor of Science, Computer Science

WEST CHESTER UNIVERSITY, West Chester, PA

Graduate Credits, Software Engineering, Artificial Intelligence and Database Design

PENN STATE UNIVERSITY, Great Valley, PA

Continue Education Credits in J2EE, WBI, Websphere Message Broker, Informatica Admin and developer

Contact this candidate