Experience Summary Over 15 years of comprehensive and in-depth work experience in Information Technology IT Industry with specialization and expertise in Data Warehousing and Business Intelligence with implementation experience in Banking Financial services domain. Banking and technical knowledge in Enterprise Information Management, Business Intelligence and Data warehouse has been practiced with financial institutions like Confidential and various other Bank / Financial institutions as DW Consultant, Sr. Data Architect and Sr. Data Warehouse/BI Architect. DW implementations in various functional domains including Basel II Operational Credit Risk , Fund Administration, Credit Cards, HR Information Systems etc.

• High proficiency in Data Modeling, Data warehouse Business Intelligence Design and Architecture.
• Manage 25 direct reports across multiple locations including India, US UK in a account 100 associates working at offshore locations in India.
• Excellent knowledge and understanding in Hadoop and NoSQL database. Trained in Hadoop.
• Strong Database skills with good experience in Oracle, Sybase and SQL Server databases.
• Proven experience in effectively translating business needs int data centric strategic technology solutions.
• Business Requirements collection, documentation and analysis, and technology assessments and translation of these concepts int crisp, focused and actionable designs, specifications, recommendations, and go-forward strategies.
• Deep hands-on experience with the full complement of contemporary Data Warehouse Business Intelligence Tools and Technologies including DBMSs, Data Modeling, ETL tools, Reporting and Analytic suites, BI Portals, Dashboard and Scorecards and contemporary programming languages.
• Strong expertise in Data Modeling including Logical Data Modeling, Physical Data Modeling, Data warehouse Design, Operational Data store Design, Datamart design and Metadata management.
• Strong Project Program Management Skills
• Handled large data warehouse database projects with High data volumes.
• Strong Technical, communication, presentation and team management skills.
• International work exposure and client management skills.
• Core Skills
• Project Program Management
• Data warehouse Design and ETL Architecture
• Data Modeling
• Data Analysis
• Database Design Configuration
• Informatica Power Center 9.0.1
• SSIS, SSRS, SSAS
• CA Erwin Data Modeler v7.3
• Power Designer
• Oracle 11g
• Sybase ASE 12.5
• SAP Business Objects XI R3
• Xcelsius 2008
• MS Project 2007

Project Experience: Confidential Sr. Technical Manager/Senior Data warehouse Architect Technology Oracle 10g, Informatica Power Center 9.0.1, Unix shell scripts, Erwin Data Modeler, Business Objects XIR3, XCelsius 2008, SSIS, SSRS, SSAS Program Abstract Operational Risk Dashboard and HR Information Warehouse Role

• Responsible for defining overall data architectures, understand the business objectives and provide solutions that efficiently meet the needs in a timely manner with a focus on data integrity and quality.
• Lead in evaluating requirements and help design an end-to-end integration architecture and data model for the target data warehouse, staging, and data marts.
• Lead the identification and analysis of enterprise business drivers and requirements that drive the future state architecture
• Interacted with key individuals at various levels within an organization including client managers/account executives, customer leaders, team leads, project managers, etc.
• Contributed t the development of new Data Information product strategies
• Developed Conceptual, Logical and Physical data models.
• Championed the ETL BI architecture.

Confidential Senior Technical Manager/Senior Data Architect Project Abstract Project objective of GFR is t create a multi-dimensional reporting database t allow standardized and consolidated reporting across all European TA operations. Role

• Designed, Architected and managed the project resources.
• Built a star schema model compatible t the business and data domains.
• Managed owned the delivery of ETL Reporting design and development
• Responsible for reporting the performance of the project t the customer on a periodic basis.
• Conducted the requirement workshop with the business.

Confidential Sr. Technical Manager/Senior Data Architect Project Abstract The objective of the Credit Exposure Monitoring CEM project is t satisfy regulator's comments on Northern Trust t aggregate the credit exposure of any given client or counterparty on an on-demand basis t identify and measure the risk associated with the customer. Role

• Designed and architected the Credit Exposure Monitoring application.
• Responsible in developing a scalable data model using Erwin, t allow the data from disparate data sources and maintain their data integrity
• Organized and conducted the JAD sessions for the analysis and design phase of the project.
• Responsible for planning, scheduling, resource augmentation, resource planning, risk management and client management. Responsible for the end t end delivery of the application and co-ordination with the customers in the acceptance of the deliverables.

Confidential Project Abstract The vision of this project is t consolidate platforms for Campaign execution across all lines of business. Role

• Responsible for the delivery of the design, implementation and maintenance of the system.
• Instrumental in architecting and designing the Enterprise Warehouse for the Home Loans Direct Marketing.
• Involved in the review of the data model and other deliverables of the projects.
• Involved in the performance tuning of the application during the UAT phase of the project and als managed the defects.
• Responsible for identifying the activity definitions, duration estimation, resource leveling and change control.

Confidential Project Abstract The Analytical Data Hub ADH Programme of HBOS covers the provision of Credit Risk data t the Analytics team for BASEL II requirements. Role

• Responsible for the Technical Design and architecture. The technical and data architecture was arrived at after consultation with the business and technical users of the System.
• Organized and conducted the JAD sessions for the requirements gathering and design.
• Managed the onsite and offshore resources.
• Responsible for the delivery of the deliverables in all the phases of the project.
• Involved in the database configuration and tuning of the application and the ETL loads.
• Involved in the review of the data model and other deliverables of the project.