Scott Hoffer Email & Phone Number

St. Louis, Mo, Us

Three City Place Drive, Suite 400, St. Louis, Mo 63141

Result-oriented Senior Consultant focused on analyzing complex business problems, designing appropriate solutions to business needs and managing business application development and roll-out. Strong collaborative leadership coupled with "hands-on" IT experience. Proficient in Program and Project Management with the ability to interact with people at all levels; a successful track record of aligning people, projects, and priorities, effectively bridging the gap between IT and Business. Take direction, think fast, and execute with precision!Client: Express Scripts – Client Services Transformation – Provided leadership in data architecture by designing the enterprise data foundation layer for Client Account Entity. The foundation blueprints support both current and future project development initiatives. Created the semantic/conceptual data models for Client Account Entity using Erwin modeling tool. Developed a data dictionary that includes Enterprise data subject areas and their related data objects. Benefits include centralized data store, enabling faster time to market; interoperability, and Fast Healthcare Interoperability Resources (FHIR) standard.Client: Royal Canin – Provided data quality and migration / integration services to Royal Canin. Customer engaging in system upgrades and migrations. Project formed to analyze, profile, cleanse, and integrate historical transactional and Master data from Navision to Salesforce OMS.Client: Centene – Provided Data Governance oversight and support to both data governance team and extended team. This includes, but not limited to, leading effort to take security recommendations to fulfillment, mentoring, defining and building KPIsClient: Anheuser-Busch – Provided leadership in data architecture, oversight in SQL development, and management of external data sources. Took ownership of complex ETL processes impacted by data quality, performance and sustainability.

Greater St. Louis Area

GPS provides consulting and administrative support services regarding prescription drug benefit plans, including Medicare Part D. Specifically, GPS provides enrollment processing between Pharmacy Benefit Managers (PBMs) and the Center for Medicare and Medicaid Services (CMS). Development environment: MySQL 5.5, Business Objects Data Integrator 11.7 (Designer), Business Objects Enterprise XI 12.1 R/3• Supported nightly enrollment process covering over 700,000 lives comprising of over 100 Data Integrator jobs running daily 3pm-10am. Provided timely issue resolution to ensure client SLA is met.• Maintained and enhanced enrollment process using Data Integrator to conform with evolving requirements.• Developed multi-tier late enrollment penalty process using MySQL stored procedures, functions, and Data Integrator jobs.• Designed, implemented, and maintained stored procedures, triggers, and functions.• Tuned databases to ensure expected performance results are achieved.• Collected and analyzed user requirements to derive conceptual and logical data models.• Translated data models into physical databases.• Promoted changed physical database entities to production.• Initiated and participated in code reviews to ensure stability.• Applied and maintained security to ensure data is not compromised.• Enhanced user interface which allows PBMs to access and maintain member enrollment information using .DOT NET Framework.• Automated job submission process by performing analysis and documenting job dependencies.

Greater St. Louis Area

Enterprise-class IT support and IT consulting to small and medium sized businesses. We are a trusted IT partner for businesses trying to do more with less money and time. We provide responsive, professional support for the entire technology infrastructure, performing regular ongoing maintenance, monitoring, and backups – everying necessary to ensure an efficient, safe, and reliable computer environment:• Defined the IT Strategy to gain competitive advantage.• Developed and implemented sales and marketing plans to identify and manage business objectives.• Built longstanding customer relationships by developing excellent client expectations.• Planned and coordinated project deliverables, resource requirements, implementation timelines

Greater St. Louis Area

Development environment: SQL Server 2005, Crystal Reports; Business Objects XI R2, R3, Polestar.• Designed, implemented, and maintained stored procedures, triggers, and functions.• Developed ETL using SQL Server stored procedures to process client data from multiple timekeeping and billing platforms into data-warehouse • Configured and enabled security to ensure client data is not compromised• Designed and developed Business Objects universes to ease reporting.• Created multi-dimensional drillable Crystal and Web Intelligence reports to deliver company data.• Designed and developed Business Objects Explorer (Polestar) infospaces to deliver fast executive data.

Greater St. Louis Area

Migration Project: BO 5.1.3 to BO XI R2Development environment: Oracle 8i and 10G; Business Objects 5.1.3. and XI R2 SP2.• Provided support during implementation and upgrade of Business Objects.• Planned and coordinated project deliverables, resource requirements, implementation timelines, testing initiatives, and deployment objectives of a laboratory services project for pre-clinical drug development.• Provided Web Intelligence training to facilitate development, growth and effectiveness of client staff.• Migrated several hundred Business Objects 5.1 reports to XI R2 DeskI; built and implemented test plans, evaluated data integrity through rigid quality assurance practices; defined and implemented processes and standards to streamline user acceptance.• Built and executed test plan to validate the migration of several hundred BO 5.1 reports to BO XI R2.• Configured and enabled security to ensure client data is not compromised.• Analyzed issues, documented and communicated root cause, recommended and provided solution to prevent recurrence.• Developed and implemented interface and back-end enhancements to increase user acceptance and decrease data inconsistency.• Led design and implementation teams on Business Objects upgrade projects including cut-over planning, issue tracking and issue resolution.

Greater St. Louis Area

Migration Project: BO 5.1.3 to BO 6.5Development environment: Microsoft SQL Server 2000, Business Objects 5.1.3. & 6.5, Microsoft VB.NET 2003, Microsoft Visual Studio 6.0, and Microsoft Visual Studio.Net 2003.• Liaison between development team and senior management on development and implementation projects.• Planned and coordinated all phases of Business Objects migration project from 5.1 to 6.5.• Upgraded Business Objects from 5.1.3 to 6.5; migrated 6 universes and more than 30 Web Intelligence reports to enhance company performance capabilities.• Created Business Objects universes using Business Objects Designer 6.5.

Greater St. Louis Area

Laboratory services project for pre-clinical drug development Development environment: Microsoft SQL Server 2005, Crystal Reports and Microsoft VB.NET 2005.• Liaison between development team and senior management on development and implementation projects.• Planned and coordinated project deliverables, resource requirements, implementation timelines, testing initiatives, and deployment objectives of a laboratory services project for pre-clinical drug development.• Administered and managed change control to prevent scope-creep and ensure on-time delivery.• Provided analysis, design, development, testing and implementation of Client/server and Web based platform to manage advisory and laboratory services in pre-clinical drug development using .NET Framework; integrated with active directory, SQL Server database and Crystal reports. • Designed, developed, and implemented field-level role-based security on a Web-based application using .NET Framework Captured history of changes for all studies.

Greater St. Louis Area

Data Warehouse Build and Reporting ProjectDevelopment environment: Microsoft SQL Server 2000/2005, Business Objects Enterprise XI R2 (Web Intelligence XI, Designer XI, Dashboard Manager XI), Microsoft VB.NET 2003/2005, and Microsoft Visual Studio.Net 2003/2005.• Created ETL using SQL Server stored procedures to process sales data for multiple divisions of into a data-warehouse.• Developed Business Objects dashboards using key performance indicators to enable quick and objective view of sales data.• Installed Business Objects Enterprise XI R2; developed universes to report from Microsoft SQL Server and migrated more than 350 Crystal XI reports enabling new features and enhancing performance capabilities.• Implemented active directory authentication.• Designed, implemented, and maintained stored procedures, triggers, and functions.• Tuned databases to ensure expected performance results are achieved.• Collected and analyzed user requirements to derive conceptual and logical data models• Translated data model into physical database.

Greater St. Louis Area

Business Objects Maintenance ProjectDevelopment environment: Microsoft SQL Server 2000, Business Objects 5.1.3, Microsoft VB.NET 2003, Microsoft Visual Studio 6.0, and Microsoft Visual Studio.Net 2003.• Liaison between development team and senior management on maintenance project.• Developed ETL using SQL Server stored procedures to process client data.• Analyzed issues, documented and communicated root cause, recommended and provided solution to prevent recurrence.• Designed, implemented, and maintained stored procedures, triggers, and functions.• Tuned databases to ensure expected performance results are achieved.• Collected and analyzed user requirements to derive conceptual and logical data models• Translated data models into physical databases.

Greater St. Louis Area

Development environment: Microsoft SQL Server 2000, Microsoft ASP.NET, Microsoft VB.NET, and Microsoft Windows 2000 Server.•Provided analysis, design, programming, and implementation of software systems.•Designed and implemented the local area network.•Produced specifications and provided deliverables for a Microsoft SQL server database.•Provided analysis, design, and programming for a client server application and web interface.

Greater St. Louis Area

Provided team leadership; generated ideas and conceptual frameworks to guide research and analysis; created work plans, ensured projects remained on time and within budget; communicated project status. Managed production support staff workloads; updated team leads and management daily with status.•Exceeded key reporting objectives to deliver complete and on time sales reporting. Improved metrics representing complete and on-time sales reporting from 75% to 90%.•Defined, automated, captured, and communicated over forty “early warning” metrics to gauge risk of inaccurate or incomplete sales reporting.•Proactively monitored execution of nightly data warehouse batch process - extracts from eight systems and execution of over 500 batch programs. Promptly provided alerts to management and customers of issues including details, resolution, and impact.•Developed and implemented detection program to alert support staff when error volume exceeded acceptable levels. This proactive monitoring and notification tool is used in over 30 processes.•Implemented change control processes.

•Managed vendor relations and coordinated activities to streamline product enhancements.•Maintained reliable production environments with no less than 99% operational time. •Implemented data archiving strategy (60,000 expense reports annually) to acceptable performance levels. •Defined disaster recovery plan to ensure maximum system uptime and minimum data loss.•Implemented problem resolution response time metrics - all support calls responded to within four hours and all issues addressed within 24 hours.•Automated over 30 error detection processes to filter and report on suspicious data.•Developed and implemented interface and back-end enhancements to increase user acceptance and decrease data inconsistency.•Facilitated the migration of Monsanto’s expense reporting system from client-server to the Web.•Maintained and enhanced back-end SQL server database containing four years of expense reporting history.

Greater St. Louis Area

•Defined and managed projects, built budgets, acquired resources, and communicated progress. •Produced functional prototypes to enable end users to participate in design and offer recommendations.•Performed life-cycle software development: analysis, design, development, testing, implementation, and training.•Implemented change control to eliminate project inefficiencies, ensured timely completion, and prevented budget overrides.•Automated problem identification and resolution process by developing “early warning” alerts.

Springfield Illinois

Ms, Criminal Justice

Computer Science, Computer Science