- Collaborated with SMEs to review and understand the Business and Functional requirements.
- Designed and Developed the Data Model for the Incentive Program incorporating modeling best practices and Standards.
- Worked closely with Business (Finance, Trade Marketing) Users, Application Managers and Sr. Information Analysts to review/determine the mapping of reporting data elements to EDW SIP Data Model.
- Lead and worked with the team of developers across continents to build and implement the business rules/logic to integrate the data, perform batch process and extract the data to down streams.
- Proactively analyzed the source data to determine the inconsistencies between the data and the data model and resolved the issues by raising it to appropriate information analysts.
- Designed and developed application logic to perform complex calculations using SQL / BTEQ.
- Designed and developed job schedule plan and coordinated with TES team to setup jobs to perform data loads and batch processing.
- Collaborated with Business user and Application Manager to capture the data forecast and performed capacity planning.
- Analyzing system capacity and space management at table and database level for projected growth.
- Implementing Join Indexes validation analysis, PPI, MLPPI, Secondary Index recommendation, Multi-value compressions and multicolumn stats usage analysis.
- Performed database and code migration from Dev. to Test, QA, Pre-Prod and Production/Live.
- Automation of collect stats on new system and performance monitoring of the system.
- Analysis, design and implementation of applications batch processing on Windows using power shell scripting.
- Working in all phases of development cycle, right from Requirements and Data Analysis, Data Mapping, Design, Build and Test.
Hardware / Software Environment:NCR 6650/5600, Teradata 13.10, Teradata Tools and Utilities 13.10, Tidal Enterprise Scheduler (TES) 6.0.2, Erwin 8
- Collaborated with SMEs to review and understand the Business and Functional requirements.
- Worked closely with Enterprise Data Modelers to review/determine the mapping of reporting data elements to core EDW Data Model.
- Designed the semantic dimensional model for Integrated Supply Chain and Sales Performance Analytics and reporting based on Data Item Register (reporting data elements)
- Designed and developed semantic layer to support Microsoft Cube (Analysis Services) and reporting.
- Created the semantic mapping document to map the attributes from EDW to Semantic access layer.
- Lead and worked with the team of developers across continents to build and implement the business rules/logic.
- Proactively analyzed the source data to determine the inconsistencies between the data and EDW model and escalated the issues to the appropriate tower.
- Designed and developed application logic to perform complex calculations using SQL / BTEQ.
- Designed and developed job schedule plan and coordinated with TWS team to setup Tivoli schedules and jobs to perform batch loads.
- Analyzing system capacity and space management at table and database level for projected growth.
- Implementing Join Indexes validation analysis, PPI, MLPPI, Secondary Index recommendation, Multi-value compressions and multicolumn stats usage analysis.
- Analysis and tuning of database applications for providing good response for SSAS MOLAP and ROLAP cubes.
- Performed database and code migration from Dev to Test, QA, Pre-Prod and Production/Live.
- Automation of collect stats on new system and performance monitoring of the system.
- Analysis, design and implementation of applications batch processing on Windows using power shell scripting.
- Working in all phases of development cycle, right from Requirements and Data Analysis, Data Mapping, Design, Build and Test.
Hardware / Software Environment: NCR 6650/5600, Teradata 13.10, Teradata Tools and Utilities 13.10, Tivoli Workload Scheduler (TWS) 8.4, Erwin 7.3, Microsoft Analytical Services (MSAS) and Reporting Services (SSRS), Tableau
Business Model Strategy
