Sql Server Data

Winter Garden

Experienced Solutions and Business Intelligence Architect with excellent client and project

management skills. Action-oriented with strong ability to communicate effectively with technology,

executive, and business audiences.

FRED J.

8119 Key West Dove St,

SUMMARY

ACCOMPLISHMENTS

SKILLS

LAUER, FL 34787 H: 407-***-**** *******@*****.***

Systems Training for End-Users and Development Staff.Reporting Design and Implementation.International Currency Conversion and Data Migration 2002 - 2004 Dodah,Inc.Largo FL Director of Information Systems Development Dodah.com was amultilingual phonetic intelligence engine that returned search results fromthe 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 andimplementation tasking and execution; resource evaluation,organizational development (assessment of staff, educational track tomaintain in-house expertise).Corporate IS strategy - implementation of in-house accounting systems,converting in-house accounting and management systems to ERP (GreatPlains), planning and implementation strategizing.

Oracle Server 6.x / 7.x / 8.x / 9i / NET, ASP.NET, ad, Agile, AIX,10G Application Design, Architect,Microsoft SQL Server & 6.x / 7.0 / AS400, ASP 3.0, ASP, Asset2000 / 2005 / 2008 / 2008 R2 / 2012 Management, automate,MySQL 5.x, 6.x, 7.x automation, Backup, basic,SSMS/SSIS/SSRS/SSAS benchmarking, benefits, BudgetPentaho BI Suite 3.x, 4.x planning, BI, businessDTS and SSIS management, Business Process,SSRS business systems, Capacity

Server ImplementationVMWareHyperVResponsibilities:JIRA setup and configuration,Kanban strategization, teammanagement, solutionsdevelopment, project reporting,risk mitigation.Analysis and design of efficient,secure and scalable RDBMS,diagrams creation,documentation and presentationRequirements development,technical platform, sotftware andhardware implementation andutilization, metrics developmentfor technical and functionalimplementationTeam management anddevelopment for multiple largescale projects concurrentlyFacilitation of business processand data modelling sessions toprovide proper specification indeveloping data solutions andclarification for businessstakeholders and technicalpersonnelProcess/Data diagramsData Warehouse, Data Marts,OLAP Analysis Server (Cubes)development, troubleshooting,enhancements anddocumentationPerformance Tuning - SQL Traces(SQL Profiler) troubleshooting slowsessions or erroneous executionsPerformance Tuning - indexperformance tuning, RAID arraytuning, backups, storedprocedures, views, triggersPerformance Tuning - Index,

Planning, caregiver, catalog,clarify, Clustering,Cognos/Impromptu, Cognos,com, Hardware, Hardwareinstallation, consulting, contractmanagement, contracts,Conversion, Cost Analysis, CPU,Credit, CRM, encryption, client,Clients, Customer Support, dataacquisition, Data analysis, DataDictionary, Data Migration, datamodelling, Data modeling, DTS,data warehouse, DBA, Database,Database Architecture, databasedesign, Database Modeling,Delivery, Disaster recovery,dispatching, Documentation,e-commerce, Staff management- training, ERP, ErWin 4.x, ERWin,ESRI, Essbase 5.0.1, Essbase, ETL,executive management, fast,financial, financial forecasting,financial analysis and forecasting,Financial Management,forecasting, forms, functional, GIS,GL, government, graphicaldesign, Great Plains 5.0,hard-drives, Hazardous Waste,Health and Human Services,hiring, HP/UX, IBM, DB2, imaging,Instructing, Instruction, inventory,layout, Team management anddevelopment, Linux, Mainframe,managerial, managing,marketing strategies, market,Marketing, memory, mentoring,Access, MS Access, backoffice,Microsoft Dynamics, Excel,exchange, mail, office, MicrosoftSQL, SQL Server 2000, MicrosoftSQL Server 7.0, SQL Server 6.5, SQLServer 7.0, Win 3.5.2, Windows2000, 2000, 3.x, NT, NT 5.0, NT 4.0,

procedure, function, traceinteractionPartitioning and MirroringInter-platform integration throughserver linking (MSSQL, DB2, Oracle,Linux, MySQL, Pentaho BI, etc)Expert level SSRS (SQL ServerReporting Services) setup, reportcreation, publishingExpert level DTS and SSIS ETLpackages creation,maintenance, troubleshooting,transfer, integrationExpert level T-SQL development,troubleshooting and performanceenhancementsMS SQL Server (2000/2005/2008R2/2012) Production support (HighAvailability Environments)MS SQL Server (2000/2005/2008R2/2012) ReplicationDisaster recovery (strategy andimplementation)Backup and Reload (strategy andimplementation)Locking and deadlocking analysisand eliminationTutoring and InstructionOracle - Data modeling andoptimization (involved indatabase and application designand deployment)Shell scripting / basicadministration tasks (Oraclespecific tasks: backup,maintenance, performancemonitoring and UNIX memory,CPU and semaphoremanagement, system logmessages, disk management andmiscellaneous)Data import/export (IMP/EXP, SQLLoader)

Migration, Modeling, MySQL,MySQL 5.x, negotiation, Enterprise,Navigator, Network, ODBC, officeautomation, OLAP, OS, OperatingSystem, Optimization, OracleForms 4.5 / 6i, Oracle 9, Oracle7.3, Oracle Discoverer 3.1, Oracle8.0, Oracle Reports 2.5, Oracle,DB, Oracle Designer, OracleDeveloper 2000, Developer,Oracle PL/SQL, PL/SQL, Oracleand SQL, Oracle 8, organizing,OS/2, PCI, Perl, personnel,Platinum 4.5, policies, PR, pricing,process design, processes,procurement, productdevelopment, coding,programming, ProjectManagement, ProjectDevelopment and Management,Project Planning, RAID, RDBMS,Real Estate, Re-Engineering,relational database, reporting,Requirements gathering, retail,retail sales, Sales, sales analysis,securities, Server configuration,scripting, scripts, Shell scripting,Software Development,specification, MS SQL Server,MSSQL, MS SQL, SQL Plus,Microsoft SQL Server, SQL, SQLServer 2.1, SQL Server, SQL Loader,statistics, Strategy, strategydevelopment, strategicdevelopment, Sybase SQLAnywhere 4.x, Sybase, SystemsAnalysis, Systems Engineering,Systems Integration, teammanagement, TechnicalDocumentation,telecommunication,telemarketing, Toad, TransactSQL, Transact-SQL, T-SQL, TSQL,

PL/SQL - Created functions, transportation, troubleshoot,packages, procedures, triggers, troubleshooting, Tutoring, UNIX,sequences, ad-hoc queries, etc. upgrades, Upgrade, vendorBackup and recovery management, VB 6.0, VisualRoutine scheduled maintenance Studio, Wang, Website, written(ANALYZE command, checkstatistics and locks, defragmentthe hard-drives)Performance tuning andmonitoring (Data and ApplicationDesign, queries, memorystructures, etc)General - Configuration ofhardware and OS (OperatingSystem) in cooperation with theNetworkAdministratorsODBC / MDAC setup andtroubleshootCreation & Implementation ofsecurity policies (create users,roles, profiles, assignment of rightsand privileges)Hardware installation, upgrade,troubleshootingData analysis, database designand implementationSoftware Development:Microsoft Transact-SQLSybase SQL Anywhere 4.x / 5.x /6.xEmbarcadero - DB ArtisanOracle PL/SQLOracle Developer 2000 / 6i -Oracle Forms 4.5 / 6i, OracleReports 2.5 / 6i,Oracle Discoverer 3.1Oracle DesignerOracle 9iAS (Reports Server)Tools: SQL Navigator, Toad, SQLDeveloper, SQL Plus, SMMS. StoredProcedures (SQL Server/Oracle)DTS Packages (SQL Server)

ETL Scripting (Perl)CRM/BI with SSAS

EXPERIENCE

01/2017 to Current BI/ETL/Reports Architect

McLarens International Orlando, FL

Performance tuning, SQL query optimization, scheduled processes definedand implemented, data integrity maintenance, security implementation,backup and recovery.ETL Strategy design and implementation in multiple toolsets and platforms.Organized and conducted training sessions with members of ISdepartments and business managers/stakeholders.Demonstrated ability in a variety of telecommunication hardware andsoftware packages.Conducted studies and made recommendations in the appropriate areasof office automation.Computer Instructing and tutoring background.Multinational requirements gathering to combine global datasets into onedata repository.Conversion/Acquisition/Metric development - all ETL process includingmulti data sources and export of existing systems off foreign platforms.Design and Development of queries to drive reporting and dataacquisition for offsite office sites.Coordination of JIRA/Agile for release of global reporting solutionContributed to staff productivity and performance by mentoring andpromoting individuals from team members.

01/2016 to 01/2017 Software Engineering Manager

Transcore Orlando, FL

Project Management and Architecture - Development of data migrationstrategy to centralize data from multiple locations for use in ERP.Development of ICD mapping and overall ETL strategy to migrate currentand legacy data into one central location.Team management and development - resource allocation, teamexpansion, hiring and backfill of team members.

01/2013 to 01/2014 Delivery Management Consultant

Dell Services Texas

Development Architecture - developed data strategy, model and datadelivery mechanisms for, Project Management - Delivery of Flexeraproduct implementation for large scale international client.Asset Management - Hardware and Software inventory acquisition,strategy and deployment.Development Architecture - developed data strategy, model and datadelivery mechanisms for procurement and inventory systems supporting

multiple clients.Analysis Architecture - financial cube design and deployment foranalyzing deployed assets and associated costs (SSAS 2008 R2).Conversion of legacy reporting and interactive reporting to Cognos 10and SSRS 2008 R2.Requirements and Definitions development.Coordinated a team of 5 developers, 2 data analysts and 1 Dataarchitect to provide deliverables per requirements.Documentation and Specifications.

01/2012 to 01/2013 Sr Manager

RCG International Orlando, FL

BI Data Delivery and Acquisition.Analysis and re-design of reporting process for Sales and Marketingreporting processes, data and delivery of reporting per corporaterequirements.Conversion of all data from multiple data sources (MS Access, Excel, Text,ERP, Legacy Mainframe, AIX, AS400) into one general repository forconsumption by audience defined in Sales and Marketing up the GM ofthe division.Repository design and implementation (SQL 2008 R2 and SSAS) (bothRelational 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 SSISpackages and consumption from SQL Server 2008 R2 for multiple sourcecreation.Conversion of SQL Server 2008 R2 to 2012, inclusive of BI Stack objectscreated in project (SSIS, SSRS, Cognos connectors, associated dataobjects).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 Dataarchitect to provide deliverables per requirements.

01/2011 to 01/2012 Senior Data Architect

ECC Consulting Anchorage, AK

Rewrite and Re-design of Hazardous Waste system previously written on theAccess 2005 platform.Conversion efforts included analysis and reverse engineering of currentbackend database, input forms, interactive help systems, businessrequirements and rules development and converting into the MicrosoftSQL 2008 R2 environment.Including a relational database system, a analysis cube, .NET (ASP.NET)

forms implementation and backend reporting on performance, costsanalysis, financial movement, interactive load placement, and freightmovement and delivery analysis.Analyze, design, implement and maintain solutions for the business.Interacts with all levels of the Company to ensure successful and timelydelivery of IT services for clients.Evaluates and drives improvement of all processes within his/her area ofcontrol to ensure efficiencies as well as proper integration with variousareas throughout the Company.Assists all departments with the implementation of new systems byorganizing training, conversion, and startup activities.Manages and directs the organization toward its primary technologicalobjectives, based on long-term product and profitability goals, byperforming the following duties personally or through the IT team:.Follow a comprehensive evaluation, development and implementationRoadmap for system improvement.Plan, schedule, and direct preparation of programs and projects to serviceclients pertaining to process data and solve problems by use of computers:provide managerial and systems analysis to clarify program intent, identifyproblems, suggest changes, and determine extent of programming andcoding required.Analyze user requirements, procedures, and problems to automateprocessing or to improve existing computer system.Exhibits strong vendor management skills including contract management,vendor and expense management and strong negotiation skills to ensurethe Company receives the highest level of value possible.

01/2010 to 01/2011 Production/Development Lead Data Architect

TEWS Staffing Orlando, FL

MS SQL 2008, 2005, SSIS, SSAS, SSRS.Performance Improvements - fine tuning packages, procedures andfunctions.Performance Tuning - locks, indexes, packages, stored procedures,functions, trace interaction.Server configuration and deployment for over 70 locations.Daily Maintenance, monitoring and on-call support for 24x7 businessmodel.PCI Compliance.Microsoft Dynamics Administration, conversion, ramp-up andimplementation.Clustering, certification, encryption, replication, and partitioning.DR strategy development and implementation.Backup and Recovery Strategy.NetAPP/LUN Creation.

01/2009 to 01/2010 Senior BI Architect/DBA

ISO Group Melbourne, FL

Defined and developed BI Reporting solution to server all facets andbusiness management in the company.Defined and developed ETL Strategy to ensure availability of BI Reportingand Data availability for.Power Users coincides with needs of business management andstakeholders.Defined and developed role specific dashboarding and reporting solutionsby business division.Defined and developed data acquisition, conversion and utilization forsubscription and government based data sources to provide market sharehistory 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 andsystem bottlenecks.Maintained and tested Backup and recovery strategy.TSQL development for various group projects.Reviewed Enterprise wide SQL Code and adjusted TSQL code for lockelimination and/or performance enhancements.Created links between various platforms (Excel Datasets, Flat Files, MSAccess, 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.

01/2007 to 01/2009 Tata Consultancy Services International Boca Raton, FL

03/2001 to 08/2001 Director of IT

HSN Direct International Limited

responsibilities - 6 direct reports - reported directly to the CEO.Staff management - training assessment, strategic development fordepartment to support all internal business systems, third party software,development methods and procedures, providing a strong department tosupport the company.Strategizing a full hardware/software upgrade for NT based networksystem supporting all day-to-day operations, strategy included anupgrade path plan to move from NT 4.0 to NT 5.0 (Windows 2000), ensuringthat all software, hardware, development tools, support tools, monitoringsystems, third-party ERP packages and web based tools (ASP and SQLServer 2000) compatibility and performance expectations.Project Planning to upgrade Platinum 4.5 to Great Plains 5.0 for internal

business systems.Architecture assessment and re-design of internal business systems tosupport multiple sources of retail sales tracking from multiple partners(3telemarketing, 4 mail support, and 2 fulfillment houses), SQL Server 6.5, SQLServer 7.0, SQL Server 2000.Re-design and coordination of web e-commerce environment to support1000's of products with affiliate partners as well as baseline retail productsoffered in the company, coordination with business owners as well asgraphical design partners, PR agents, and IT personnel to develop a newweb community for the company.Budget planning and project implementation planning for all abovementioned items.

02/2001 to 03/2001 Essilor International

In-house software benchmarking and capability assessment.Systems Analysis of implementing a RDBMS solution for manufacturing floormanagement system.Hardware Capacity Planning and Re-Engineering of in-house developedsystem supporting internal business in Microsoft SQL Server 7.0.Data Model redesign, business process model re-design.Implementation of project on a fast-track project plan, completed inunder 30 days.

09/2000 to 02/2001 NeoMedia Technologies, Inc

CRM/DSS and Data Warehouse implementation planning and analysisutilizing SQL Server 7.0 and ASP 3.0 frontend.Data Warehouse implementation analysis for Cognos/Impromptu basedsystem (part of Integration with Oracle based system).Upgrade/Integration analysis for Oracle 9i in conjunction with SQL Server7.0 base system software.Integration analysis for additional large scale Oracle 8.1.6, HP/UX 11.0, EMCSymmetrix Array installation with SQL Server 7.0 based system.Transact SQL, Stored Procedure maintenance and development.Production Support, build scripts for base software upgrades.Code management process implementation and verification proceduresdevelopment.Database Maintenance, Tuning and Optimization, processstandardization, backup recovery, and disaster recovery implementationfor internet based SQL Server 7.0 installation.

06/2000 to 09/2000 Danka Business Systems

Design and implementation of a data warehouse solution that analyzesSales commission payouts, sales performance corporate-wide, divisional,regional, financial forecasting and planning, and area territory assignmentand performance reporting.Backend programming to provide auto-feed mechanisms from Oracle

8.0.5 to Essbase 5.0.1.Staging design to provide de-normalization of enterprise data for feed todata warehouse repository.Documentation, presentation, and interaction with all business owners andsponsors of the project.Stored procedure design and implementation for data feed requirementsto fulfill update of data warehouse.Implementation strategy to take OLTP data, provide the data-movestructures and programming to fill a star-schema based staging design forfinal data-move structures and programming into Essbase warehouserepository.

11/1999 to 06/2000 The Home Shopping Network

Business Requirements gathering.Reverse engineering and requirements gathering for large scalee-commerce implementation for product sales on the internet.Data modeling with ER/Win 3.5.2.Building automated scripts to provide 1) Data Dictionary of initial system; 2)Source Code generation;.3) Database status reporting.Building documentation based on technical layout and businessrequirements of the system.Data Architect and requirements gathering for updating processesrelating to Credit Card synchronization, club member processing,customer updates and synchronization with legacy systems (mainframebased), maintaining current processes as well as redesigninglow-performance processes -.Documentation and implementation development for migratingproduction changes per user request.Data and Business Flow diagramming for processes that utilize thedatabase, providing diagramming for all processing that occurs directlyand indirectly against the core systems database.Impact analysis and process design for re-engineering efforts andproduction migration of enhanced and new processing, databasechanges, and requirements change.

01/1999 to 01/2002 Manager

Rapidigm, Inc St Petersburg, FL

Website Marketing and Affiliation, Alliance forming with categorical basedbusiness on the internet.Systems applications architecture and programming, conversion track andclass modeling for ASP 3.0/VB 6.0 to .NET architecture migration, DatabaseSystems Engineering Rapidigm, a multinational conglomerate consultingfirm providing services and product development to multiple industries.Clients, Projects and Products.

01/1997 to 01/1999 Director

MHA Software Services, LLC Omaha, NE

Database Services MHA Software Services provided consulting services tomulti-faceted companies in a wide array of technologies.One of the few IBM business partners able to implement any hardware intheir mid to mainframe lines.Omaha Steaks (www.omahasteaks.com) - provided web backend andfrontend design to provide shopping experience, membership, andupsell/cross-sell automation for this web experience, developedbackoffice management system, as well as multi-faceted interface foroutside vendors and affiliated marketing strategies.Oriental Trading (www.oriental.com) - provided web backend andfrontend design to provide shopping experience, membership,upsell/cross-sell and catalog automation for this site.Pacesetter (www.pacesetter.com) - sales force automation, internetbased sales pricing update with cell-to-laptop data synchronization forin-field sales force of 300+ members.Ameritrade (www.ameritrade.com) - backend processing to provide orderplacement, auto-trade, and customer interface, working with securitiesand exchange as well as the NYSE and NASDAQ entities for tradeautomation.REMS (Real Estate Management System Union Pacific Railroad) - 43 stateasset management system, managing real estate assets of 10.5B forcorporate holdings, automation of titling, documentation, lease,agreements, contracts, paperless imaging system to provide on-clickdemand asset status (continuation from DPRC).Papercorp - automation and upgrade of legacy Wang system to IBM Sseries multi-processor system and Oracle 7.3.3.Nebraska State Patrol - sex offender registry database, web interface,integration with public records to inform the public of sex offenders in aradius to homes per governmental guidelines.State of Nebraska HHS (Health and Human Services) - logistical system toprovide dispatching of caregiver vehicles to aid recipients of state benefitsto have no-cost access to pharmacy, doctors office, medical, hospitaltransportation on demand.

01/1993 to 01/1997 Senior Systems Engineer

DPRC, Inc Kansas City, MO

Development, Implementation and Support of Financial Managementsystems for Real Estate Asset.Management systems, Oracle with VB 6.0 frontend, Visual Studiodevelopment, 2nd largest real estate asset management system in the US.Development, Implementation and Support of GIS data systems andsoftware interfacing.

EDUCATION AND TRAINING

1989

DOT Executive Committee GIS development and implementation,MapQuest Search engine.ESRI GIS implementation, SDE Oracle implementation.Various clients, software product development, financial and businessprocess modeling, systems implementation.Yellow Freight Systems executive management reporting systems, financialanalysis and forecasting, mainframe integration to midrange for fasterreporting, 4th GL implementation under EASEL/2 for OS/2 and SQL Server2.1 (pre Microsoft).

Associate of Applied Science: Computer ProgrammingSoutheast Community College Milford, NE, USA

Coursework Programming Languages, Systems Analysis and Design, Projects,Accounting and Finance3.69 GPA

Contact this candidate