John Bromfield Email & Phone Number

Bethlehem, Pa, Us

Colmar, Pa

Designed, developed, and maintained comprehensive BI Solutions and complex reporting using SAP BI applications: BusinessObjects Data Services ETL, UDT/IDT Universes, Dashboards, and WebI reports for the Quality, Supply Chain, Operations, Finance, and Sales areas.Worked closely with BI Architect and BI content users across various business areas to develop accurate and maintainable solutions.Assisted power users with WebI training and guidance.Designed, developed, and maintained large BusinessObjects Data Services / SQL Server Stored Procedures data provisioning systems which span across business towers.

Allentown, Pennsylvania Area

Designed and developed BusinessObjects Dashboards (Xcelsius) and WebIntelligence reports (tabular and graphical) for the Finance, Manufacturing, and Sales areas. Worked closely with Business Analysts and led off-shore SAP BW developers to model flexible and accurate Universe designs. Extensive interaction with analysts and end users to build efficient and useful BOBJ reports and dashboards.Led SAP Business Warehouse / BusinessObjects WebIntelligence inventory management project which saved LSI $9M over a 3 year period. Built technical design, worked closely with Business Analyst in obtaining the correct data sources, managed the development efforts of the SAP BW team, and designed and developed the Universe and WebIntelligence reports resulting in: - $249K: reduction in manual effort by Finance team - $5.4M: increases in precious metals (gold) reclaim results - $3.6M: supplier price reductionsAs a direct result of this project, worked with Finance team and Business Analyst to utilize existing BW datasets and BOBJ universe and built a Work in Process (WIP) Analysis report that was used to reduce WIP by 93% over a 5 quarter period.Held many formal and informal training sessions for power users and development staff for reporting and development tools

Allentown, Pennsylvania

Successfully managed the migration of LSI’s corporate intranet site to SharePoint. Coordinated and ran meetings that discussed requirements, development, testing, and status. Used MS-Project and SharePoint as the software tools to support the project.Developed SharePoint pages/sites for various teams. Trained managers and analysts and held several demonstrations on how to use SharePoint.Managed Intellectual Property (IP/Legal) team’s migration from several old systems and manual processes to 3rd party applications. Prior to solution search, convinced the IP/Legal team to work out its business process model. Facilitated these meetings. This effort was critical in the success and smooth transition to the new applications.Supported a large list of legacy IP/Legal applications by analyzing data issues and system bugs, designing, coding, testing, and implementing code and data fixes. Provided technical expertise regarding Excel, SQL (SQLServer and Oracle), and SharePoint.Spearheaded the initiative to update and standardize all merged company's (Agere and LSI Logic) IP/Legal websites. Learned HTML and CSS (from sites like w3schools.com and through experimentation) to support this effort.Served as Footprints Administrator: • Footprints was utilized as an internal issue tracking system and was also utilized by the various engineering teams as an issue and upgrade tracking system with outside vendors and customers.• Coordinated and managed Footprints upgrade, system patches and database upgrades which affected Footprints. These activities required extensive coordination with scores of teams and hundreds of users.• Partnered with engineering teams in Texas, Colorado, and Pennsylvania to design and build effective projects and reports in the Footprints environment. This required extensive configuration, SQL and UNIX scripts, and testing with the engineering teams without affecting current SLAs with external customers.

Allentown, Pennsylvania

Successfully managed a multi-national development team through many staff reductions and a long period of uncertainty. The team continued to thrive, meet project, development, and support goals with minimal staff turnover.Provided project management for the development activities for various projects including the upgrade of the Oracle Application Suite. This required resource loading for a diverse multi-national team and continuously monitoring and analyzing critical paths to ensure on-time and within-budget deliveries.Played key role in reaching company’s goal of creating a global team of developers. Traveled to India to train new staff and emphasize department processes and procedures. This effort resulted in lower costs, 24x7 support for development and production issues and increased satisfaction of end users.Saved over $10,000 by carefully reviewing and negotiating license renewals for department software packages. After a company merger, successfully negotiated the combination of software renewals for software common to both companies.Successfully managed the HR/Payroll systems analysts team. The team was extremely limited in its ability to design new functions. Reduced the team’s production support hours by 50% by:• Successfully negotiating with the End User team to provide more effective and efficient Level 1 support• Partnering with IT Manager to tighten, standardize, and more effectively document HR scheduled programs• Coordinating in-depth support training between HR IT Team and the Application Support TeamSuccessfully managed the upgrade of Oracle HR module. This included the replacement of several homegrown HR related applications.Worked vigorously to support the teams served: provided quality feedback, assisted in the building of goals, development and promotion plans.

Allentown, Pennsylvania

Designed and developed over 20 sophisticated ERP and Legacy Systems to Data Warehouse manufacturing interfaces in support of two major Oracle Application Suite implementations using PL/SQL, Triggers, and Stored Procedures.Demonstrated strong team leadership abilities by working closely with systems analysts and project managers across functional areas on resource loading and other project management issues. Majority of projects were on-time and within budget.Provided production support for issues of complexity that were beyond the scope of the dedicated production support team. This required prompt response to difficult issues – including: in-depth investigation, coordination with subject matter experts, and possibly coding/data changes all of which resulted in increased customer satisfaction.

Allentown, Pennsylvania Area

Performed team leader duties for Agere's Oracle Application Suite (OAS) Implementation Projects:• Effectively partnered with IBM Development team to develop and maintain enhancements and interfaces to OAS• Organized and performed troubleshooting efforts• Led two development teams to a successful installation of the Manufacturing Modules of OAS for two major Business Units• Partnered with IBM counterpart to build an Application Support Team from the development teamEffectively managed the development and support tasks during the change from IBM managed outsourcing model to an Agere “in-sourcing” model.Updated and standardized up to 15 department websites. Project provided clear and consistent look and feel to all websites.Because of budget cuts, led team cross-training to build a highly effective pool of development resources. This activity allowed the development resources work on the highest priority initiatives while providing quality support of existing systems.

Allentown, Pennsylvania

As a Consultant to Lucent Technologies (entire Lucent project was “out-sourced”), performed team leader duties on the Total Order Management (TOM) project and the TOM Data Warehouse project:• Managed two project plans in order to schedule and prioritize development tasks for the Back End (UNIX/Oracle/C) and the Data Warehouse teams• Conducted design meetings with TOM users to determine Data Warehousing needs and translated the customer requirements into specifications and designs• Designed reporting de-normalized reporting Oracle RDMS tables• Organized and performed troubleshooting efforts• Developed and coordinated on-call procedures and schedules• Communicated project progress to TOM users and project managementPerformed systems analyst duties for the TOM project’s interface with the Oracle Application Suite (OAS) implementation project:• Coordinated table changes with OAS Design, TOM Development, and DBA teams• Led the conversion team to build interface tables and work out interface issues with OAS team

Allentown, Pennsylvania

Performed team leader duties on the Total Order Management (TOM) project and the TOM Data Warehouse project:• Managed two project plans in order to schedule and prioritize development tasks for the Back End (UNIX/Oracle/C) and the Data Warehouse teams• Conducted design meetings with TOM users to determine Data Warehousing needs and translated the customer requirements into specifications and designs• Designed reporting de-normalized reporting Oracle RDMS tables• Organized and performed troubleshooting efforts• Developed and coordinated on-call procedures and schedules• Communicated project progress to TOM users and project managementPerformed various programming / analyst duties for the TOM project.