• Formulated a data strategy for the organization to unlock and effectively utilize a wealth of data available from the policy and claims management systems by developing practical solutions to provide solid reporting and analytical capabilities to business, clients and senior executives.• Provided leadership in advising senior executives on implementing a data-centric corporate strategic plan.• Conceived and implemented the Enterprise Data Warehouse and Reporting (BI 2020) project, to… Show more • Formulated a data strategy for the organization to unlock and effectively utilize a wealth of data available from the policy and claims management systems by developing practical solutions to provide solid reporting and analytical capabilities to business, clients and senior executives.• Provided leadership in advising senior executives on implementing a data-centric corporate strategic plan.• Conceived and implemented the Enterprise Data Warehouse and Reporting (BI 2020) project, to create one source of truth for the entire organization’s reporting and analytic needs by integrating data from multiple sources, removing redundant and inaccurate legacy systems, with a high performance (80-90% loading time improvement) and high data quality Enterprise Data Warehouse (EDW). • Led the architecture and design of the EDW, making sure they are aligned with business requirements. Ensured the coding standards and best practices were followed in the ETL development and the performance was optimal. Performed solution reviews and constant walk-throughs / feedback sessions were arranged with all teams of developers, QA, business analysts etc. for successful delivery of the solution.• Overhauled the external subscriber reports publication system by designing and building an in-house solution in a short time which was fully automated. This resulted in significant software licensing cost savings and a 90% reduction in team efforts for the highly manual recurring tasks. Show less

Solutions Designer for the two critical Enterprise Compliance Programs - Foreign Account Tax Compliant Act (FATCA) and Common Reporting Standard (CRS) with data from multiple lines of business.• Designed and developed many complex modules of FATCA and CRS Core Applications. Authored the System Design Specifications (SDS) and built ETL solution for processing parties and agreements from multiple LOB systems of TD and determine their final FATCA and CRS (multiple tax jurisdictions) compliance… Show more Solutions Designer for the two critical Enterprise Compliance Programs - Foreign Account Tax Compliant Act (FATCA) and Common Reporting Standard (CRS) with data from multiple lines of business.• Designed and developed many complex modules of FATCA and CRS Core Applications. Authored the System Design Specifications (SDS) and built ETL solution for processing parties and agreements from multiple LOB systems of TD and determine their final FATCA and CRS (multiple tax jurisdictions) compliance status.• Provided consultation for the Data Architecture and Modeling of the application to implement the business requirements efficiently on the available technical platform. Collaborated with multiple teams and vendors, heavily engaged in defect fixes and ETL performance optimization across all modules of the application. • Nominated and won as star performer in one of the quarters. Show less

Technical Team Lead responsible for the full spectrum of client’s multi-year BI engagement. • Led the Global Data Warehouse (GDW) / Business Objects (BO) migration as part of the One Vale SAP ERP implementation and successfully delivered a high-quality BI solution within tight timelines, while collaborating with teams from 5 continents.• Analyzed requirements and gaps, designed and developed the GDW in a highly complex application landscape, with multiple data source systems like LIMS… Show more Technical Team Lead responsible for the full spectrum of client’s multi-year BI engagement. • Led the Global Data Warehouse (GDW) / Business Objects (BO) migration as part of the One Vale SAP ERP implementation and successfully delivered a high-quality BI solution within tight timelines, while collaborating with teams from 5 continents.• Analyzed requirements and gaps, designed and developed the GDW in a highly complex application landscape, with multiple data source systems like LIMS, TruckScales, HR/Payroll applications like PeopleSoft, VIP, GEAC, Mainframe applications, IAM etc. being interfaced with the GDW.• Worked on preparing integration plan, functional and technical designs, data modeling and architecture, environment setup, data migration, security and standards, ETL development and review, co-ordination with downstream and reporting groups, migration plan, project documentation, project transition to support team and warranty support.• Ensured risks were identified and addressed in advance, and by having a strong understanding of client’s systems enabled significant effort and cost savings. Excellent feedback and reviews were received from client on project closure.• Provided support for the legacy GDW and reports (pre-migration) while improving data loading performance by 50-90% through ETL and database tuning. Reduced incident volumes by 80-90%. Show less

Designed and developed several high profile Business Intelligence solutions for Fortune 500 clients. Specialised in Global Data Warehousing and Analytical Reporting.Key technologies used: MS SQL Server, SSIS, Oracle, PL/SQL, T-SQL, SSAS (Cubes), ERwin Data Modeler, SAP BusinessObjects Enterprise: Web Intelligence (Rich Client, InfoView), Universe Designer, Xcelcius, SAP BO Data Services, SAP BW - BEx reporting, Unix, Unix shell scripting (bash and ksh)