Project Leader for multiple projects involving Data Integration (ETL), Data Quality Management and EDW data modeling support and maintenance for TD Bank. The roles and responsibilities includeLeading a team at client site (TD Bank) for Data Integration projects.Creating ETL solution designs on data integration platform which includes multiple data sources like IBM DB2, Oracle and IBM Mainframes.Data Quality Management and archival plans.Data profiling and source data… Show more Project Leader for multiple projects involving Data Integration (ETL), Data Quality Management and EDW data modeling support and maintenance for TD Bank. The roles and responsibilities includeLeading a team at client site (TD Bank) for Data Integration projects.Creating ETL solution designs on data integration platform which includes multiple data sources like IBM DB2, Oracle and IBM Mainframes.Data Quality Management and archival plans.Data profiling and source data analysis and coming up the data integration mapping documents based on the business requirements.Conduct meetings with the stake holders and reporting application team on the EDW modeling requirements.Management and Modifying the EDW staging model using ERwin r9.Preparing the high level solution design for data staging jobs.Estimating and preparing ROM on the Design, Development and Testing effort based on the complexity of the requirement and resource availability.Guide BI developers on the data integration and data ware housing standards.Preparing best practice documents to help developers on the data ware housing platform. Show less

Lead Enterprise Data Staging and Integration TeamPreparing the High level design, low level ETL design templates.Estimating the Design, Development and Testing effort based on the complexity of the requirement and resource availability.Reviewing the ETL Low level designs.Review of the ETL (abinitio) code and Unit test results.Leading a team of four and tracking the daily activities of the team.Providing technical support to the team.Building reusable unix shell… Show more Lead Enterprise Data Staging and Integration TeamPreparing the High level design, low level ETL design templates.Estimating the Design, Development and Testing effort based on the complexity of the requirement and resource availability.Reviewing the ETL Low level designs.Review of the ETL (abinitio) code and Unit test results.Leading a team of four and tracking the daily activities of the team.Providing technical support to the team.Building reusable unix shell scripts for the platform which will help the developers in saving time.Build unix scripts for automated scheduling, automated system testing, House keeping. Show less

Leading a BI six member team from offshore and taking the bottom line responsibility on the deliverables and meeting the dead lines.Interacting with the clients to understand their business requirements.Design the data and code migration strategy for the project.Data modeling for building an ROLAP on SQL server.Creation of key documents like High level design, Low level design, Test Strategy, Migration strategy, Capacity planning, Data profiling, Solution proposals.Worked on… Show more Leading a BI six member team from offshore and taking the bottom line responsibility on the deliverables and meeting the dead lines.Interacting with the clients to understand their business requirements.Design the data and code migration strategy for the project.Data modeling for building an ROLAP on SQL server.Creation of key documents like High level design, Low level design, Test Strategy, Migration strategy, Capacity planning, Data profiling, Solution proposals.Worked on volumetric analysis to provide accurate space requirements to the production support team.Worked as an onsite project coordinator in order to implement the data warehouse according to the implementation standards.Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.Creating data Extract, Transform, Load strategy in SSIS.Cube creation and development of multiple measures and dimensions using SSAS.Implementing the reports and dashboards in SSRS and publishing on SharePoint. Show less

Team Lead for multiple DW/BI projects.Coding in MS BI (SSMS/SSIS/SSAS/SSRS).Coding (Abinitio, UNIX shell).Designing, developing and deploying packages in SSIS 2008 Business Intelligence DevelopmentStudio (BIDS).Prepared data mapping documents for integrations jobs in SSIS.Applied SSIS components like Excel, Flat file, OLEDB sources and destinations, data flow transformations like Lookup, Merge, Merge Join, Union All, Multicast, Conditional Split, Aggregate,Sort… Show more Team Lead for multiple DW/BI projects.Coding in MS BI (SSMS/SSIS/SSAS/SSRS).Coding (Abinitio, UNIX shell).Designing, developing and deploying packages in SSIS 2008 Business Intelligence DevelopmentStudio (BIDS).Prepared data mapping documents for integrations jobs in SSIS.Applied SSIS components like Excel, Flat file, OLEDB sources and destinations, data flow transformations like Lookup, Merge, Merge Join, Union All, Multicast, Conditional Split, Aggregate,Sort, SCD.Created the data source views and multiple cubes, measures and dimensions on MS BI platform.Requirement gathering and Design documentation.Taking the bottom line responsibility on the deliverables and meeting the dead lines.Maintaining all the metrics and following all the quality standards.Providing technical assistance to the team. Show less