Nancy Schaffer Email & Phone Number

Cincinnati, Oh, Us

Cincinnati Area

SEI is a business and technology consulting firm committed to consistent delivery and collaborative partnerships. Founded in Cincinnati in 1992, SEI now employs more than 500 consultants across the United States.With support from our national organization, our seasoned local teams take a holistic approach to new engagements, working with client stakeholders to solve problems efficiently, sustainably, and at scale. No matter the project, our consultants ensure that solutions meet clients’ short-term needs and long-term goals. We support critical client needs in the areas of Data & Analytics, Technology Enablement, Information Security, Strategy & Operations, and Concept to Delivery.Designer and Developer Enterprise Data Warehouse• Architect to combine two manufacturers’ source systems and data warehouses together to provide consolidated reporting. Creating a single source of dependable and accurate sales and manufacturing information with consistent data definitions and a flexible self-service reporting environment. Involved in all design and most ETL development as well as reporting content and administration.• IBM Cognos Business Intelligence architect and designer for a large financial services company. Provided Cognos modeling and reporting design and development to hide the complexity of the transactional system including row level security, as well as Cognos standards. Created model, reports, analysis and requirements for several other transactional and data warehouse groups• Designer and ETL developer for an Insurance Enterprise Data Warehouse using DataStage, DB2, and Actuate. Designed summarized fact tables and processes for Agency and Sales reporting as well as a custom application to calculate agency bonuses.• Worked directly with the business and external customer at multiple clients to support and understand their needs and help manage expectations.

Data Warehouse Developer• Designed, developed, and supported a materials data warehouse running on Oracle. Responsible for extracting data from many different legacy systems. • Designed, developed, and tested Oracle databases including data relationships, tables, views, procedures, functions, triggers, and PL/SQL. Extracted source data from mainframe legacy systems using COBOL, JCL, and SQL Loader.• Project leader of Champion's first Extranet application, WebExpress Online Inventory.• Designed the look and feel of extranet application and worked with design consultant to refine details.• Responsible for collecting, summarizing, and delivering written and oral peer performance reviews, as well as providing formal and informal feedback to all levels of IT.• A member of the Information Technology Interview Team responsible for determining technical and team skills of candidates.• A key member of several cross-functional materials teams responsible for reducing supplier base and supply chain costs. • Spent six months on a business assignment at a manufacturing facility helping to streamline outdated processes and training production employees

Bachelor Of Science, Mis

Mba, Management