Product Development Systems Engineer
Resume:
SUMMARY
SKILLS
DATA ANALYSIS
DATA MAPPING
DATA MIGRATION
DATABASE SYSTEMS
DB2
MAPPING
MDAC
MYSQL
ODBC
OLTP
PL/SQL
RELATIONAL DATABASE
REPLICATION
SQL
STORED PROCEDURE
STORED PROCEDURES
SYBASE
CLUSTERING
DATA ARCHITECTURE
DATA FEED
DATA INTEGRATION
DATA MANAGEMENT
DATA MODEL
DATA SOURCES
Fred
Lauer
1
*******@*****.***
Phone: 480-***-****
DATASETS
ETL
PENTAHO BI
JIRA
PROJECT DEVELOPMENT
PROJECT PLAN
PROJECT PLANNING
PROJECT PLANS
SOFTWARE PRODUCT DEVELOPMENT
TEAM MANAGEMENT
CODE GENERATION
CODING
PERL
SALES FORCE AUTOMATION
SCRIPTING
SYSTEMS ANALYSIS
SYSTEMS DEVELOPMENT
SYSTEMS ENGINEER
SYSTEMS INTEGRATION
CHANGE MANAGEMENT
DEPLOYMENT
MIGRATION STRATEGY
ROLLOUT
DATA ACQUISITION
COGNOS
MICROSOFT PROJECT
OLAP
ORACLE DISCOVERER
PENTAHO
T-SQL
DATA WAREHOUSE
DATA WAREHOUSING
ESSBASE
APPLICATION DESIGN
DATA MODELING
DATABASE ARCHITECTURE
ER/WIN
Fred Lauer 2
ERWIN
RE-ENGINEERING
SDE
SYSTEMS ENGINEERING
RDBMS
AIX
LINUX
SHELL SCRIPTING
ASP
SEARCH ENGINE
WEB BASED
BACKUPS
DISASTER RECOVERY
ISO
ESRI
GIS
CLARIFY
CRM
ERP
OS/2
RAID
EMC SYMMETRIX
NETAPP
UNIX
KANBAN
ENCRYPTION
EXCHANGE
OPTIMIZATION
AS400
PROVISIONING
MICROSOFT DYNAMICS
MAINFRAME
CUSTOMER SUPPORT
IMAGING
MANAGER
MONITORING
NEGOTIATION
Fred Lauer 3
REPORTING
RESOURCE MANAGEMENT
ANALYTICAL
ANALYTICS
AZURE
SSAS
SSIS
AUTOMATION
DELIVERABLES
HARDWARE
MICROSOFT
MSSQL
PM
REPORTS
SQL DEVELOPER
UX
PRODUCTION SUPPORT
PROJECT MANAGEMENT
ETL PROCESSES
IT
CONFIGURATION
FULFILLMENT
SALES COMMISSION
TEAM LEADERSHIP
BUSINESS PROCESS
CONSULTING
PROCESS DEVELOPMENT
MANAGEMENT REPORTING
PCI COMPLIANCE
TRADING
COACHING
MENTOR
MENTORING
TRAINING
PERFORMANCE TUNING
PROCESS DESIGN
TEST PLANS
Fred Lauer 4
MARKETING
PRODUCT DEVELOPMENT
PRODUCT IMPLEMENTATION
CONTRACT MANAGEMENT
MARKET SHARE
BUSINESS MANAGEMENT
ASSET MANAGEMENT
ACCOUNTING SYSTEMS
BUSINESS INTELLIGENCE
CAPACITY PLANNING
IMPORT/EXPORT
PROCESSOR
BUDGETS
CREDIT CARD
FINANCIAL ANALYSIS
FINANCIAL MANAGEMENT
GL
ACCOUNTING
FORECASTING
COST ANALYSIS
FINANCIAL FORECASTING
GREAT PLAINS
VENDOR MANAGEMENT
SECURITIES
ARCHITECTURE
PROCESS MODELING
QUICKBOOKS
BUDGET
STEERING
AUTOMATION DESIGN
MITIGATION
REVERSE ENGINEERING
HAZARDOUS WASTE
DOCUMENTATION
TECHNICAL DOCUMENTATION
PUBLISHING
ICD
Fred Lauer 5
PRICING
MANAGERIAL
TELEMARKETING
ORGANIZATIONAL DEVELOPMENT
STAFFING
BEST PRACTICES
CONTRACTS
METRICS
STATISTICS
BUSINESS PROCESS MODELLING
OPERATIONS
SALES ANALYSIS
FACETS
ANALYZES SALES
PRODUCT SALES
RETAIL
OFFSHORE
RAILROAD
REAL ESTATE
CLIENTS
TELECOMMUNICATION
SECURITY IMPLEMENTATION
SECURITY POLICIES
PROCUREMENT
INVENTORY
HARDWARE INSTALLATION
MAINTENANCE
LOADER
EMBARCADERO
DOT
DISPATCHING
PHARMACY
EXCEL
EASEL
WANG
DATABASE
DATABASE DESIGN
Fred Lauer 6
WORK EXPERIENCE
MS ACCESS
MS ACCESS 2000
MICROSOFT SQL SERVER
SQL SERVER
SQL SERVER 2000
SQL SERVER 2008 R2
ORACLE 7
ORACLE 8
ORACLE DEVELOPER 2000
ORACLE FORMS 4
SQL SERVER INTEGRATION SERVICES
SOFTWARE ENGINEERING
VISUAL STUDIO
.NET
MICROSOFT SECURITY
SOFTWARE DEVELOPMENT
VB 6.0
SQL SERVER REPORTING SERVICES
SSRS
SOLUTION ARCHITECT
ASP.NET
R2
BI
PR
INTEGRATION
BUSINESS REQUIREMENTS GATHERING
REQUIREMENTS GATHERING
USER ACCEPTANCE TESTING
E-COMMERCE
WINDOWS 2000
Senior Database Consultant Accruent
Dallas TX US
January 2022-February 2024
Fred Lauer 7
2022 to 2024 - Accruent - Dallas TX
Senior Database Consultant
ł Design, optimize, and manage database systems
ł Assess client needs, recommend solutions, and implement database architectures ł Performance tuning, security, and migration.
ł Project lead for migration of all base clients to new system for Hospital Asset Management ł Mentor junior staff
ł Develop, track and manage project budgets, project plans, timelines, and scope ł Develop data integration strategies to enhance use of in-house tools and attain more from ancillary product investment
ł Data mapping, Data Modeling
Independent Consultant - Remote
Phoenix AZ US
January 2020-January 2022
2020 to 2022- Independent Consultant - Remote - Phoenix AZ Solutions Integrator
ł Develop, track and manage project budgets, project plans, timelines, and scope ł Develop data integration strategies to enhance use of QuickBooks and attain more from product investment
ł Develop budgets and resources needed to define and attain goals defined by business owners ł Use desktop BI tools to enhance reporting capabilities, determine gaps and space of missing analytics and measures to provide a better roadmap ł Training
Project Solutions Manager Qlik
Boston MA US
January 2019-January 2020
2019 to 2020 - Qlik - Remote - Boston MA
Project Solutions Manager
ł Qlik is a robust tool for providing Business Intelligence dashboards, data warehousing and analytical strategies with a minimal set of tools, an all in one solution for companies of all sizes ł Develop, track and manage project budgets, project plans, timelines, and scope ł Manage project resources including procuring project staff like Analysts and Engineers, ł developing, motivating, coaching, and advising ł Partner closely with other members of functional project teams to define business requirements ł Define test plans and ensure that products are defect free before User Acceptance Testing ł Facilitate the User Acceptance Testing process, developing rollout plans and procedures ł Prepare and present cost-benefit analyses
ł Ensure appropriate systems development and project management processes are being utilized ł Make presentations to steering committees or project sponsors BI/ETL/Reports Architect McLarens International
Orlando FL US
January 2017-January 2019
2017 to 2019 - McLarens International - Orlando, FL BI/ETL/Reports Architect
ł Multinational requirements gathering to combine global datasets into one data repository ł Conversion/Acquisition/Metric development - all ETL process including multi data sources and export of existing systems off foreign platforms
ł Design and Development of queries to drive reporting and data acquisition for offsite office sites ł Coordination of JIRA/Agile for release of global reporting solution Contributed to staff productivity and performance by mentoring and promoting individuals from team members
Software Engineering Manager Transcore
Orlando FL US
January 2016-January 2017
Fred Lauer 8
2016 to 2017 Transcore - Orlando, FL
Software Engineering Manager
ł Project Management and Architecture - Development of data migration strategy to centralize data from multiple locations for use in ERP. Development of ICD mapping and overall ETL strategy to migrate current and legacy data into one central location. ł Team management and development - resource allocation, team expansion, hiring and backfill of team members
ł Team leadership - 1 Technical PM, 2 DBA, 2 BA, 3 Vendors (23 various resources overall) ł Planning and execution of development effort
ł Automation design of redundant procedures
ł Delivery of milestone components in project
ł Improved productivity by streamlining process for development and requirements gathering by all players on the team
ł Contributed to staff productivity and performance by mentoring and promoting individuals from team members
Solution Architect GCI
Orlando FL US
January 2015-January 2016
2015 to 2016 GCI - Orlando, FL
Solution Architect
ł Project Management - Development of BI/DW Initiative, rework on deliverables and aligning technology
with business objectives
ł Team management - 3 DBA, 2 Vendors (software development, one onshore, one offshore in Russia), 3 network resources
ł Development Process Development
o Best Practices
ł Code Management
ł Change Management
ł Data Management
ł Technical Resource Management
ł Architecture -
o SQL Server Configuration - RDBMS/SSRS/SSIS Mapping for SSAS o ETL Processes
o Hardware Configuration
Senior Data Architect Universal American
Lake Mary FL US
January 2014-January 2015
2014 to 2015 Universal American - Lake Mary, FL
Senior Data Architect
ł Data Architecture - BI Initiative/Architecture development for Facets Data Analysis System ł Team Management - 3 Data Analysts and 2 Mid Level Data Architects ł SQL Server 2008 R2 - SSIS/SSRS/SSAS
Delivery Management Consultant Dell Services
January 2013-January 2014
Fred Lauer 9
Development Architecture - developed data strategy, model and data delivery mechanisms for 2013 to 2014 Dell Services - USA, Texas Virtual (Telecommute) Delivery Management Consultant
ł Project Management - Delivery of Flexera product implementation for large scale international client ł Asset Management - Hardware and Software inventory acquisition, strategy and deployment ł Development Architecture - developed data strategy, model and data delivery mechanisms for procurement and inventory systems supporting multiple clients ł Analysis Architecture - financial cube design and deployment for analyzing deployed assets and associated costs (SSAS 2008 R2)
ł Conversion of legacy reporting and interactive reporting to Cognos 10 and SSRS 2008 R2 ł Requirements and Definitions development
ł Coordinated a team of 5 developers, 2 data analysts and 1 Data architect to provide deliverables per requirements
ł Documentation and Specifications
Sr Manager BI Data Delivery and Acquisition RCG International Orlando FL US
January 2012-January 2013
2012 to 2013 RCG International - Orlando, FL
Sr Manager BI Data Delivery and Acquisition
ł Analysis and re-design of reporting process for Sales and Marketing reporting processes, data and delivery of reporting per corporate requirements
ł Conversion of all data from multiple data sources (MS Access, Excel, Text, ERP, Legacy Mainframe, AIX, AS400) into one general repository for consumption by audience defined in Sales and Marketing up the GM of the division
ł Repository design and implementation (SQL 2008 R2 and SSAS) (both Relational and Dimensional) ł Conversion of legacy DTS data movement into SSIS ł Conversion of legacy pivot reporting into SSAS
ł Conversion of legacy MS Access reports and forms into automated SSIS packages and consumption from SQL Server 2008 R2 for multiple source creation ł Conversion of SQL Server 2008 R2 to 2012, inclusive of BI Stack objects created in project (SSIS, SSRS, Cognos connectors, associated data objects)
ł Conversion of legacy reporting and interactive reporting to Cognos 10 ł Project Development and Management
ł Requirements and Definitions development
ł Coordinated a team of 5 developers, 2 data analysts and 1 Data architect to provide deliverables per requirements
Senior Data Architect ECC Consulting
Anchorage AK US
January 2011-January 2012
Fred Lauer 10
2011 - 2012 ECC Consulting - Anchorage, AK
Senior Data Architect
ł Rewrite and Re-design of Hazardous Waste system previously written on the Access 2005 platform. Conversion efforts included analysis and reverse engineering of current backend database, input forms, interactive help systems, business requirements and rules development and converting into the Microsoft SQL 2008 R2 environment. Including a relational database system, a analysis cube, .NET
(ASP.NET) forms implementation and backend reporting on performance, costs analysis, financial movement, interactive load placement, and freight movement and delivery analysis. ł Analyze, design, implement and maintain solutions for the business. ł Interacts with all levels of the Company to ensure successful and timely delivery of IT services for clients.
ł Evaluates and drives improvement of all processes within his/her area of control to ensure efficiencies as well as proper integration with various areas throughout the Company. ł Assists all departments with the implementation of new systems by organizing training, conversion, and startup activities.
ł Manages and directs the organization toward its primary technological objectives, based on long-term product and profitability goals, by performing the following duties personally or through the IT team: ł Follow a comprehensive evaluation, development and implementation Roadmap for system improvement.
ł Plan, schedule, and direct preparation of programs and projects to service clients pertaining to process data and solve problems by use of computers: provide managerial and systems analysis to clarify program intent, identify problems, suggest changes, and determine extent of programming and coding required.
ł Analyze user requirements, procedures, and problems to automate processing or to improve existing computer system.
ł Exhibits strong vendor management skills including contract management, vendor and expense management and strong negotiation skills to ensure the Company receives the highest level of value possible.
Production/Development Lead Data Architect TEWS Staffing Orlando FL US
January 2010-January 2011
2010 - 2011 TEWS Staffing - Orlando, FL
Production/Development Lead Data Architect
Senior BI Architect/DBA ISO Group
Melbourne FL US
January 2009-January 2010
2009 - 2010 ISO Group - Melbourne, FL
Senior BI Architect/DBA
ł Defined and developed BI Reporting solution to server all facets and business management in the company
ł Defined and developed ETL Strategy to ensure availability of BI Reporting and Data availability for ł Power Users coincides with needs of business management and stakeholders ł Defined and developed role specific dashboarding and reporting solutions by business division ł Defined and developed data acquisition, conversion and utilization for subscription and government based data sources to provide market share history for sales analysis to provide forecasting and provisioning
ł MS SQL 2005, SSIS, SSAS, SSRS
MS SQL 2008, SSIS, SSAS, SSRS
ł Provided 24/7/365 DBA Production support
ł Performance improvements, fine tuning procedures and functions ł Used SQL Profiler traces to identify problem procedures, deadlocks and system bottlenecks ł Maintained and tested Backup and recovery strategy ł TSQL development for various group projects
ł Reviewed Enterprise wide SQL Code and adjusted TSQL code for lock elimination and/or performance enhancements
ł Created links between various platforms (Excel Datasets, Flat Files, MS Access, Sybase, SQL Server) ł DTS and SSIS development for ETL cross platforms data movement ł Setup 2005 (server, client), service packs
ł Implemented monthly Microsoft Security and hotfix patches ł Tutoring Management and developers
Senior Data Architect Tata Consultancy Services International Fred Lauer 11
Boca Raton FL US
January 2007-January 2009
2007 - 2009 Tata Consultancy Services International - Boca Raton, FL Senior Data Architect - SQL Server, SSIS, SSAS, MySQL, Pentaho BI Platform ł Migration of Legacy system data
ł Systems Integration and Design
ł Stored Procedures (SQL Server and MySQL)
ł ETL Strategizing, design and implementation
ł Mondrian Cube design and implementation
ł Pentaho BI Server Deployment
ł Pentaho Reporting
ł Dashboarding
ł Performance Monitoring/Tuning
ł Database and Business Process Modeling/Logical Design/Physical Implementation ł Development Standards Naming Conventions, Practices development Data Architect Fervent Technology
Tampa FL US
January 2006-January 2007
2006 - 2007 Fervent Technology - Tampa, FL
Data Architect
ł Migration of Foreign systems to one-stable platform ł Systems Integration and Design
ł Data Migration scripting and automation
ł Stored Procedures (SQL Server, Oracle)
ł DTS Packages (SQL Server)
ł ETL Scripting (Perl)
ł SSIS (SQL Server Integration Services)
ł Performance Monitoring/Performance Tuning
ł Query Cost Analysis
ł Database and Business Process Modeling/Logical Design/Physical Implementation ł Development Standards/Naming Conventions Creation ł Embarcadero DB Studio Modeling tool
ł Technical Documentation
ł Systems Training for End-Users
ł Reporting Design and Implementation
ł ETL for high-speed high-availability system
ł BI Design and Implementation using SSAS
ł International Currency Conversion and Data Migration Data Architect/Systems Integrator FJLIC Consultants St Pete Beach FL US
January 2004-January 2006
2004 - 2006 FJLIC Consultants - St Pete Beach, FL
Data Architect/Systems Integrator
ł Logical Modelling/Physical Implementation of Database (Oracle and SQL Server) ł Stored Procedures (SQL Server/Oracle)
ł DTS Packages (SQL Server)
ł ETL Scripting (Perl)
ł CRM/BI with SSAS
ł Database and Business Process Modelling/Logical Design/Physical Implementation ł ERWin Modelling Tool
ł Technical Documentation
ł Systems Training for End-Users and Development Staff ł Reporting Design and Implementation
ł International Currency Conversion and Data Migration Director of Information Systems Development Dodah, Inc Largo FL US
January 1999-January 2002
Fred Lauer 12
EDUCATION
LICENSES & CERTIFICATIONS
LANGUAGES
PUBLICATIONS
AWARDS & ACHIEVEMENTS
PATENTS
PROFESSIONAL AFFILIATIONS & ASSOCIATIONS
2002 - 2004 Dodah, Inc. - Largo FL
Director of Information Systems Development
Dodah.com was a multilingual phonetic intelligence engine that returned search results from the internet in
16 languages. The phonetic engine allowed the user to misspell in any of 16 languages, and returned correct
results to 93.6% efficiency. A well-known search engine company now owns this technology. ł SQL Server 2000, ERWin 3.5.4, MS Access 2000, Embarcadero Rapid SQL, Embarcadero Performance Center, Embarcadero DM
ł Hardware Implementation - HP L6000, HP L4000, HP L2000 ł OS - NT 5.0, Linux
ł Microsoft Project, Phase I, II, & III mapping, tasking, design and implementation tasking and execution; resource evaluation, organizational development (assessment of staff, educational track to maintain in- house expertise)
ł Corporate IS strategy - implementation of in-house accounting systems, converting in-house accounting
and management systems to ERP (Great Plains), planning and implementation strategizing ł Website Marketing and Affiliation, Alliance forming with categorical based business on the internet ł Systems applications architecture and programming, conversion track and class modeling for ASP 3.0/VB 6.0 to .NET architecture migration
Manager - Database Systems Engineering Rapidigm, Inc St Petersburg FL US
January 1999-January 2002
1999 - 2002 Rapidigm, Inc. - St Petersburg, FL
Manager - Database Systems Engineering
Rapidigm, a multinational conglomerate consulting firm providing services and product development to multiple industries.
Clients, Projects and Products
Fred Lauer 13
MILITARY SERVICE
REFERENCES
Fred Lauer 14
Contact this candidate