## BIO
=============================== \*\*\*|\*\*\*|\* PREM A. SRINIVASAN \*\*\*|\*\*\*|\* BUSINESS INTELLIGENCE CONSULTANT ** IBM Certified Business Intelligence Solutions Designer ** IBM Certified Database Associate ** Brainbench Certified Data Warehouse Professional =============================== "Solutions-oriented Information Systems Specialist with more than 6 years of experience in designing, developing and successfully implementing many data warehousing and business intelligence solutions." * Extensive experience in analyzing business needs, designing and implementing cost effective data warehouse, enterprise reporting and OLAP solutions in banking industry. * Profound qualifications in full project lifecycle development, software quality assurance and management of project processes. * Organized take-charge professional with exceptional follow-through and multi-tasking abilities and detail orientation. * Excellent expertise in designing and developing Business Intelligence and Data Warehousing solutions, utilizing Kimball Star Schema and Snowflakes Methodology, SQL Server 2000, DB2, MS Analysis Services, DTS, Decision Support Objects, Crystal Enterprise 8.5, Crystal Reports8.5, MS Reporting Services, ProClarity and Panorama Analytics. * Excellent communication skills proven by effective interaction with management, clients, vendors, staff and team members. CORE COMPETENCIES * BI Tools and Technologies * OLAP & Enterprise Reporting * Data Warehousing / Data Marts * Data Warehouse Administration * Data Acquisition & Cleansing * ETL Strategies * Dimensional Modeling * Change Management * Project Planning & Estimation * Software Engineering & QA * Business Requirements Analysis * Problem Analysis & Resolution PROFESSIONAL EXPERIENCE TATA INFOTECH LTD / NATIONAL CITY BANK - Cleveland, OH, 2000 to Present Business Intelligence Data Warehouse Consultant / Data Warehouse Analyst Credited with successful design, development and implementation of many Data Warehousing and Business Intelligence solutions for National City Bank. Originally brought in to lead team in migrating company’s Retail Marketing Data Warehouse from Tandem to IBM Mainframe platform. Retained to administer the enterprise data warehouse and to facilitate the successful implementation of numerous ETL strategies, Dimensional Models, Enterprise Reporting and OLAP Business Intelligence solutions in the organization. Recognized for generating savings of $610K for the IS organization during the assignment. Responsible for collaborating with users and management to analyze business needs and develop appropriate data analysis and reporting solutions. Design and deploy multi-dimensional cubes and reports. Create and implement data marts and data models based on Star and Snowflake schema. Analyze, develop and implement high performance and cost effective ETL processes. Develop data integration, data mapping and extraction strategies. Create customized OLAP and Enterprise-wide reporting solutions. Train users on developing and using Crystal Reports. Accountable for overall success of assigned projects, from initial specifications to planning, designing, development and testing. Direct all aspects of projects, including project planning, scheduling, tracking and issue resolution. Design and deliver status reports to team members, business units and management. Interface extensively with team members, different departments and vendors to ensure on-time implementation of projects. Key Achievements: * As a key BI technical consultant, currently facilitating the successful establishment of company’s BI Competency Center and a BI Framework consisting of standardized architecture, tools, development methodology and standards. * Successfully designed, developed and implemented numerous prototypes for OLAP and enterprise reporting solutions for Branch Performance Planning, Check Returns Adjustments, Small Business Banking, Commercial Loans, Wholesale Banking and Equity Sponsor Group Departments. * Conducted a detailed technical evaluation of BI presentation tools that lead to the selection of ProClarity 5.3 OLAP tool to optimally support company’s BI Framework. * Recognized for identifying and decommissioning unnecessary data warehouse processes, resulting in yearly cost savings of $110K. * Solely accountable for establishing Costing Methodology and reporting structure for data warehouse across 5 business units. Identified accounting errors, resulting in annual savings of $500K. * Recommended the compression of unused data sets within the mainframe data warehouse for reduction of yearly DASD costs by $500K. * Consistently promoted every year owing to excellent performance. Key Project Achievements: * Currently developing an OLAP solution for the Commercial Loans Department using the Agile software development methodology to improve the efficiency of loan processing with Panorama 4.0, MS Analysis Services, DSO, SQL Server, DB2, DTS and Windows Scripting. * Developed dimensional model with conformed dimensions and fact table designs for the Branch Performance Planning department to report on branch performance, sales, incentives and deposit trends. * Credited with designing and developing numerous prototypes for OLAP reporting solutions using MS Analysis Services, ProClarity Desktop Professional, ProClarity Dashboard Server, ProClarity Analytic Server, Panorama 4.0, SQL Server 2000, DTS, Geneva, DB2, T-SQL and SyncSort covering Loan Defects, Deposit Trends, Mainframe DASD usage, Account Transaction Activity, Branch Manager Cube, Small Business Portfolio Management, Channel Analysis, Equity Sponsor Risk Analysis, Wholesale Banking Exposure Risk Analysis subject areas. * Researched and evaluated Cognos PowerPlay 7.1, Crystal Analysis 9.0 and ProClarity 5.2 OLAP Tools for selection of OLAP presentation tool. Currently evaluating MS Reporting Services as an Enterprise Reporting Tool. * Facilitated the establishment of reporting structure for the Returns Adjustment Department. Trained and mentored 5 developers from Returns Adjustments and Commercial Loans departments in relational database concepts, SQL and Crystal Reports. Developed custom report scheduler to schedule more than 100 reports, utilizing Visual Basic 6.0 and Crystal Reports 8.5 SDK. * Spearheaded the development of a Crystal enterprise reporting structure for the Small Business Banking department to help officers optimally manage their loan and deposit portfolio. Created the dimensional model and ETL using DTS and SQL Server 2000. Reports were developed using Crystal Reports 8.5. * Selected to conduct cost and performance analysis of the data warehouse for executive management to identify a cost charge-back methodology. Successfully established new costing methodology to allow the reporting of costs based on usage. Recognized for identifying and decommissioning unnece
## Area of Expertise
Business Intelligence, OLAP, SQl Server, DB2, Visual [login to view URL], VBA, Data Analysis, Data Extraction, Data Conversion, Data Migration, Project Management
