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 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 and tables as needed. Oracle, Toad, scripts, Excel, Sharepoint, ETL with DBA, Reporting, trending tables, training of new employees, troubleshooting. Fiserv Warehouse Architect ETL Tool, KnowledgeShare (BRIO with JavaScript) Reporting Tool, PowerShare Business Objects. Developed Associated Bank Loan Metadata Business Object Views and Monthly Trend Views from mapped data and SQL test scripts with conversion rules for validation, at client’s request. Query tuning including restructuring SQL and index recommendation. Devised method for obtaining information to determine mappings of possible critical slightly fluctuating field values. Trained in SAP Business Objects, data governance, and slowly changing dimensions. Confidential Pittsburgh, PA 2009-2010  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 2007–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. Confidential, Canonsburg, PA 2007  Business Analyst Consultant Analysis/design of application for client access to financial model from complex spreadsheet. .NET 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. 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#, 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, ETL, Rational ClearQuest, Microsoft Office System (including Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, and Microsoft Outlook, Project, Visio), TOAD, FTP. ACTIVITIES Math Tutor Technical Reading Microsoft WebsiteSpark