Education and Credentials
Master of Science Degree in Information Science
Bachelor of Science Degree in Mathematics, Business Management

• Information Technology Project Management. PMP exam qualification course from Katz MBA program. Harvard Business School case analyses of worldwide corporations.
• Management Information Systems. Developed database for an RFID (Radio Frequency Identification) MIS to monitor the movements of medical staff and patients around a busy medical clinic, system included decision support, business process reengineering, forecasting.
• Database Management Systems. ER Diagrams, Object Oriented Modeling, Operational Database and Star Schema OLAP Data Warehouse Design, DDL, DML, relational algebra, SQL, Triggers, Views, Rollup, Cube, Loading, Deadlocks, Recovery, Storage, Oracle 10g, corporate decision support systems, Visio.
• C# .net

Professional Experience

Confidential, Pittsburgh, PA current 
Business Intelligence (BI) Analyst

• Facilitation of mapping reviews, Data Source Analysis, Data Warehousing, Data Mappings of accounts for various financial clients including GMAC Mortgage, and Associated Bank.
• Data Mappings for GMAC Mortgage Loan Defaults, Associated Trust Accounts, Online Banking.
• Analysis of Metadata tables including the creation of new Metadata records as needed.
• Oracle, Toad, scripts, Excel, ETL with DBA, Reporting, trending tables, training of new employees, troubleshooting.
• Fiserv Warehouse Architect, KnowledgeShare Reporting Tool, PowerShare Business Objects.

Confidential, Pittsburgh, PA 2009-2011 
Financial Sales Consultant

• 2010 Excellence Club Inductee, Sales Leader, ranked top 10% in consumer sales volume 4th qtr 2010.
• Spirit interface, mainframe, banking concepts, product knowledge.

Confidential, Pittsburgh, PA 2008–2009 
Developer

• Large Relational Database and Data Warehouse dimension schema design and stored procedures to populate the Data Warehouse from the Operational Database, Asset Management and Tax system.
• Toad, Oracle, created SQL Loader files from output of positions of column data, FTP, mainframe flat file to Excel reporting, EBCDIC, 24/7 call rotation.
• Software development and maintenance of COBOL/CICS based systems, prepared and executed test data, production installs, all enhancements/fixes were successfully implemented.
• 2009 fixed asset and tax reporting schedule programming for Slovakia, AISI (American Iron and Steel Institute) reporting, programming of reports for intranet access, Management Training participant.

Confidential, Canonsburg, PA 2007 
Business Analyst Consultant, part-time

• Analysis/design of application for client access to financial model from complex spreadsheet. .NET

Confidential, Bethel Park, PA 2007-2008 
Sales Representative

• Self-designed multi-insurance group sales presentations, including financial annuity and life products, at apartment complexes in Washington County, attended professional “Boot Camp” sales training.
• Adept at scheduling and delivering Medicare and Part D drug plan information to groups through company PowerPoint presentations, knowledge of benefit packages (health, life retirement, flex plans).
• Effective cold calling, able to coordinate and conduct seminars at senior centers in Greene County.

Confidential, McMurray, PA 1993 - 2000
Owner
Pennsylvania Turnpike Commission, Maryland State Highway Administration Projects

• Managed and programmed infrastructure Construction Management System that tracked $300,000,000 to $700,000,000 of annual contractor pay estimates subject to audits from Federal Highway Administration. Oversaw the systems for ten years. Maintained project scope and schedule.
• Directed rapid application development requirements sessions with business units to gather requirements for working prototypes and test cases for system that included complex mathematical
• procedures for calculating quantities of two and three dimensional construction items, procedure for auditors, contractor payments and suppliers. Clipper
• Successfully utilized Prototype, Incremental Build, and Agile Life Cycle project management techniques

Confidential, Coraopolis, PA 1994 - 1995
Contract Developer

• Implemented and programmed a Documentation Control System that organized and enabled quick access to crucial documents for the project management of new highway construction. FoxPro

Confidential., Pittsburgh, PA 1985 - 1993
Systems Analyst

• Pennsylvania Department of Transportation Project: spearheaded the first infrastructure Construction Management System in the United States that transferred contractor pay estimates to main system for processing. System processed plans, change orders, MBE/WBE, suppliers, invoices and master diary, Clipper, Incremental Build Life Cycle.
• Republic Engineered Steels Project: Development of Facilities Management System for the inspection and repairs of facilities at ten production plants while company was in bankruptcy; search engine for Division Manager to optimize use of limited funds for crucial repairs. Clipper, Agile Life Cycle.
• Designed and implemented company HRIS system for the HR department that tracked benefits, payroll, education, family dependents, salary history, and other employee information.
• Developed engineering solution that calculated excavation volumes for major projects.

Languages: C#, SQL, PL/SQL, COBOL/CICS
DBMS: ORACLE, SQL Server; Database/Warehouse Design, Complex Queries, Stored procedures, DML/DDL Triggers, Views
Web Servers: IIS
Tools: SQLServerManagement Studio, SSIS,SSAS, ETL, Rational ClearQuest, SnagIt, Lotus Notes, Microsoft Office System (including Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, and Microsoft Outlook, Project, Visio), TOAD, FTP, ServiceManager, Planview Time/Project Management.