With GAP Inc. expanding its footprint globally and opening Franchise and Brick and Mortar stores across the Globe focusing on Asia, the data warehouse should be enabled to accept data from the newly opened stores and Franchises. The Item number is identified differently across the various RMS systems throughout the PDLC. This is a bottle neck to the global reporting team where the same item spans across multiple genres under different numbers. To streamline the Item number, the proposed solution is to clean up the Multi-parent items and assign the correct hierarchy at all levels. Re-assignment has been achieved at Style /Style Color / SKU level. Item Master which is the Global source for generating Item numbers is considered the System of record. Data correction in Dimensions, Cross reference and Lookup tables was done and then the corrected keys have been re-stamped in facts. It involves various LOB's like Planning, Inventory, Price, Sales and Order.
Upgrading to a New Teradata Server for the SOX Compliance Data processing 2650 (Teradata Data Warehouse Appliance), profoundly for processing High volumes of Data is configured and the existing Production processes have been migrated to this Data Processing Engine. With this, the existing 6680 (Teradata Active Enterprise Data Warehouse Appliance) server transformed to a Reporting Engine and acts a Single Source for all the User reports and Business queries. With heavy lifting being done at 2650, the reporting server will better be utilized for addressing Business questions. The Data after being cleansed, transformed will be copied using a Custom built TPT process on to 6680. This enables real time data availability across servers. As this is a Financial Data Mart, SOX Compliance is in place and data is being masked to ensure its availability to identified Users.
ePI is Enterprise Person Identifier (ePI) project is linked to the 2012 BCBSM strategic plan through the consumer strategy. The Enterprise Person Identifier is a core foundational element for enabling BCBSM to better know and engage with consumers across their lifetime. It built the infrastructure and populated the solution with core membership systems. ePI takes in data from disparate source systems and links records that refer to the same person. The linking is done by assigning a Unique Person Identifier (UPI) to records that are considered to be referencing the same person. ePI uses the power of IBM's Initiate software to compare membership records and generate two person outputs that are housed in the EDW. In order to create and promote new products to sustain and enhance market share, it is critical to link, analyze, and leverage individual consumer behavior and health care history. ePI will allows the foundation to enhance consumer strategy and customer satisfaction.
ABIS is an Enterprise Data warehouse built for reporting purposes to leverage the data availability to Business to measure the trends and buying patterns of customers. There are wide ranges of Metrics and Semantics defined to diversely provide the required data using Cognos reporting solutions. The claim, patient and prescription information is loaded from source systems using Ab-Initio to Teradata systems. As the reports are pulled with few years of data, Teradata handles it efficiently with quicker response times. The reports are provided with various filters to enable users filter the data as per their necessity.
E-Receipt is an electronic way of sending the sales receipt to customer's personal email address. This is a new service rendered for more customer satisfaction and an effective way for the customer to keep track of Purchase history and for any future returns. E-Receipt transactional data from the source is extracted and sent as flat files. This will be loaded to Teradata warehouse database to identify the new customers and their marketing preference. Daily and Weekly reports are created from warehouse database using Microstrategy and distributed the reports to the users using Report Center.
Rack Scheduling is an Employee Workforce Management Application to forecast Employee work hours using Historical data, scheduling Labor as per availability and Actual Hours logged. Weekly and Monthly reports are created and distributed to the users using Micro Strategy narrowcast Administrator. The objective of this project is migration of ETL from the legacy system on Access database and Excel reports to a High performance Teradata Database and Microstrategy reports with improved Design Process.
The objective of this project is to provide data for the Planning application. Sales Transaction data from OLTP source system is loaded to Teradata database for analyzing the trends and support DSS applications. Daily and Weekly extracts are created from warehouse database using Teradata FastExport.
The CDM database/platform in Teradata will collect all the available customer data including historical data from all different LOBs and host it in its central repository. When an LOB doesn't find required customer information they will send a request to CDM application. CDM collects all requests and send them to Vendors on a daily basis. Informatica collects all the requests from the CDM and performs the required transformation and sends it to Vendors. Vendors send the Response files and Informatica process them and send back to CDM.
The objective of this project is to track the Store Sales performance. All the transaction data is captured in the source system and sent in flat files to be loaded to Teradata warehouse. Historical data snapshot for last 10 years is maintained in the warehouse. Data is stored in Aggregate and Fact tables. Reports run at a weekly batch interface to drill up the data to Division and Zone level. The performance of the store is compared with the Average sales per store. Top selling items and least selling items are other significant reports.
ERoster Application is an Associate Scheduling Application to forecast Employee work hours for the future weeks. Manager/Employee can make any further edits and the historical snapshot is stored until the actuals are captured for these weeks. A Weekly and Monthly report with the latest version of forecasted data and the actual metrics are extracted and sent across for measuring the Manager's performance. Zonal and Divisional Managers use the reports. Supporting multiple application suite, answering End user questions and helping them resolve their Technical and Business questions.
Companies Worked For:
Job Titles Held:
© 2019, Bold Limited. All rights reserved.