I have strong Knowledge of Data Warehousing, ETL and Business Intelligence Reporting Architecture. Well versed in Normalization and DeNormalization techniques for optimum performance in relational and dimensional database environments. Strong experience working with conceptual, logical and physical data modeling considering meta data standards. Experience in developing tools using Access, VBA, Excel environment. Extensive experience in translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry. Over 5 years of extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA. Experience working with Agile and Waterfall data modeling methodologies. Experience in designing a canonical models. Extensive experience analyzing and documenting business requirements and system functional specifications including use cases facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams. Involved in the critical design review of the finalized database model. Worked extensively with XML schema designing and XML data. Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio. Worked with various RDBMS like Oracle 9i/10g/11g, SQL Server 2. Very Good exposure to ETL tools like Informatica, Micro Strategy and IBM Data Stage and SSIS 2008/ 2005. Building reports using SQL SERVER Reporting Services (SSRS 2005/2008), Crystal Reports.