Jessica Dewitt Email & Phone Number

United States

Columbus, Oh, Us

New York, Ny, Us

Columbus, Ohio, Us

Business Intelligence team’s primary design associate responsible for the Teradata Enterprise Data Warehouse (EDW), Teradata Customer Loyalty database, and Oracle Operational Data Store (ODS) development and maintenance. - Primary technical partner in design sessions with cross functional technical and business teams. - Key technical resource for troubleshooting and solving complex problems. - Defined best practices and standards for all data warehouse development. - Conducted data model design, data mapping, and SQL code reviews to ensure standards were followed. - Trained and mentored other analysts on data modeling and Teradata stored procedure development. - Developed high performing stored procedures to load aggregate tables in the Teradata EDW which were key to improved performance of both integration interfaces and reporting. - Created data marts on Teradata EDW for MicroStrategy reporting. - Partnered with the Quality Assurance team in testing of data warehouse interfaces. - Participated in the on-call rotation for BI owned stored procedures and MicroStrategy reporting. - Created schedules in CA Workload Automation for stored procedures to improve reliability and error trapping.

Columbus, Ohio, Us

Responsible for developing and supporting the Teradata Enterprise Data Warehouse (EDW), Teradata Customer Loyalty database, and Oracle Operational Data Store (ODS). Designed and developed a Merchandising Data Warehouse and the Operation Data Store. - Performed all data modeling for the Teradata Enterprise Data Warehouse, Teradata Customer Loyalty database, and Oracle Operational Data Store using dimensional and relational modeling techniques (snowflake, star, 3NF). - Established naming and data type standards for data governance. - Created source to target mapping documents for integration interfaces to load and retrieve data for the Teradata EDW, Teradata Loyalty database, and Oracle ODS. - Developed macros and stored procedures on Teradata for the Loyalty Web Services supporting real time e-Commerce platform. - Developed views in Teradata used for Business Objects reporting on top of a third normal form data model. - Developed views in Teradata used for tCRM (Teradata Customer Relationship Manager). - Performance tuned views, integration/reporting queries, web service macros and stored procedures, and user ad hoc queries on Teradata. - Assisted with testing of EDW and Loyalty integration interfaces.

Columbus, Ohio, Us

Responsible for helping translate requirements between various technical teams in addition to designing and developing the Enterprise Data Warehouse (EDW). - Created business requirement and technical specification documents for the web development team used to create new loyalty web services to be used with the DSW e-commerce website. - Assisted in the re-design of the customer loyalty and related data models. - Architected and developed Teradata macros and stored procedures for the Loyalty web services. - Created source to target mapping documents for the loyalty program interfaces. - Partnered with the integration team on the QA testing of interfaces. - Collaborated with the integration team to identify defects and gaps in Informatica mappings. - Designed and developed semantic view layer for the Customer Relationship Management tool (tCRM). - Gathered business and technical requirement for Business Objects reporting. - Partnered with the reporting team to design new views for Business Objects.

Columbus, Ohio, Us

Web application developer responsible for the development and maintenance of the websites and loyalty applications for DSW, Value City, Filene’s Basement, and Retail Ventures. - Built websites for DSW, Value City, and Filene’s Basement when they were brought in-house. - Enhanced functionality to the DSW website to allow for customer enrollment and self-service to the Loyalty program. - Developed the customer service application for DSW and Value City’s loyalty programs. - Created the Loyalty application for DSW’s Point of Sale allowing for real-time enrollment and updates to the program and for store associates to lookup the Loyalty member in order to associate them with a transaction. - Collaborated with the Marketing team for changes or modifications to the websites and applications. - Partnered with the database team to create tables, functions, and stored procedures in SQL Server and Oracle to support the website and applications. - Investigate and troubleshoot issues related to the Loyalty program. - Partnered with the Marketing team to compose customer emails in ExactTarget and Cheetahmail, upload customer lists, and scheduling of the emails. - Participated in the conversion and redesign of the Loyalty program from Reward Your Style to DSW Rewards. Updated the website, POS loyalty application, and customer service application for the new Loyalty program.