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.

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

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

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.
• Built and executed test plan to validate the migration of several hundred BO 5.1 reports to BO XI R2.

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

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.

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

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