Professional Experience

Confidential

Technical Consultant/Project Management, Enterprise CRM, professional services, 80 travel

• Customer Interaction, Digital Messaging, implementation and configuration, Business Intelligence marketing software.
• Physical Model and Semantic View Modeling from Data Warehouse, mappings of tables and fields for customer segmentation, Integration and UA Testing, Deployment from Dev to QA to Prod, and Documentation.
• Gathered Business Requirements and leveraged customer data for universe, customer hierarchy, drill-down and independent selection attributes, and segmentation for email, direct mail, and SMS customer interactions from EDW, customer data model for data analytics, complex project schedule.
• TERADATA University: PMO Curriculum, Enterprise Data Warehouse PMO, Semantic Layer Curriculum, Advanced SQL, Active Events stored procedures , Temporal Tables, Data Modeling-Conceptual, Logical, Physical, VMware, Linux, BTEQ, SQL Assistant, SQL Server Training troubleshooting/ performance/administration .

Confidential

BI Data Analyst/DW Architect, contractor, Business Intelligence Strategy Group, 100 travel

• Development of New Global Data Warehouse, Dimensional Data Modeling, Analysis and reverse engineering of infrastructure reporting, metrics, KPIs, data analytics of operational data stores, E-R Diagrams, metadata table extraction SQL, data mapping documentation and data specifications.
• Deployment Strategy, Agile, Netezza.
• Informatica ETL, Oracle, SQL Server, Business Objects Web Intelligence, Universe Designer, SDLC.

Confidential

BI Data Analyst, contractor

• Facilitation of mapping reviews, Data Modeling. Data Profiling, Data Warehousing, Data Mappings of accounts for various financial clients including GMAC Mortgage, and Associated Bank with Fiserv SDLC.
• 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

MICROSOFT WEBSITESPARK

I taught myself how to deploy .NET application to Azure from my personal laptop.

Confidential

Banking 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

Technical Business Analyst, contractor

• Emergency Fixes, Requirements, Impact Analysis, Design, Defect Analysis
• Analyze data/business processes to support the operational business areas.
• Queue creation, router strings, testing, CICS production table modifications.
• Customer support system including membership, benefits, claims, inquiries, campaigns.
• COBOL, CICS, DB2, Rational ClearQuest.

Confidential

Data Warehouse Developer

• Data Modeling and created ETL process for Relational Database and Data Warehouse dimension schema design and stored procedures to populate the Data Warehouse from the Operational Flat Files, Asset Management and Tax system, ERP conversion.
• Toad, Oracle, created SQL Loader files from output of positions of column data, FTP.
• Software development and maintenance of COBOL/CICS based systems, prepared and executed test data, production installs, all enhancements/fixes were successfully implemented, batch processing.
• 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

Business Analyst consultant

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

Confidential

Owner

• 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

Application Developer/Data Modeler

Implemented and programmed a Documentation Control System access for the project management of new highway construction.

Confidential

Application Developer/Data Modeler

• 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.