Responsibilities -Business requirements analysis, BI technical architecture, design, implementation, testing, deployment & production support.
Build customizable and easily adaptable reporting solutions that leverage re-usable reporting components-Identify, document and follow industry best practices for enterprise reporting and semantic layer-
Performance Tuning of reports to minimize execution time-Provide expert consulting in Solution Design for ETL and Data Migration based on expertise.
SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) and SQL Server Analytics Services (SSAS)-
Hands on experience in ETL tools SSIS, Ab initio, Data Stage, Data Mirror, Informatica & Prism and OLAP Cognos, Business Objects, and SSAS Analysis tool -
Good exposure to BCP & DRP projects, OLAP tools viz. Data Stage, Ab initio, Informatica, COGNOS and BO tools.-Expertise in Configuring Report Server and Scheduling Report Manager-
Thorough understanding of Software Engineering Methodologies.-Excellent database expertise in MS SQL Server (2005, 2008 R2, 2012).
Knowledge of WebTrends, the measurement and analytics tool is highly desirable-Well versed with defining data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an Analysis Services.