Kireet Dasari Email & Phone Number

• 7+ years of experience in installing, configuring and server administration of IBM Cognos 10 & Cognos 8.4 versions, Microsoft SQL Server, ETL development and SQL DB administration.• Experience in Cognos 10, 8.4 and Cognos Reportnet involving creation, modelling and implementing various applications.• Extensive experience in Report Studio, Powerplay studio,Query Studio, Analysis Studio, Framework Manager, Transformer and administration of the applications.• Worked on MS SQL Server 2014, 2012, 2008, 2005 & 2000 versions which involved creating databases, creation and modification of tables, views and stored procedures.• Involved in setting up MS SQL Server databases and configuring the same to client’s requirements. This included sizing the databases and setting up data and log files.• Administered the SQL servers by setting up permissions, linked servers and configuring the MS SQL Management Studio. • Experience in SQL Jobs through SQL Server Management Studio and SQL Server Integration Services (SSIS) through SQL Server Business Intelligence Studio.• Experience in modifying and designing data architecture using Lawson (Infor) BPW Designer 10.4 (ETL).• Worked extensively on creating reports using Report Studio and Powerplay Studio through Framework Manager and Transformer Models against SQL Server & DB2 databases.• Created and modified various Dashboards for the Business Users for analysis various aspects of the business of the organization.• Experienced in providing the Production Support as a part of maintaining the existing Data Warehouses.• Good understanding of Cognos Architecture with Data Mart Architecture, data modeling and dimension modeling using Star Schema and Snow-Flake Schema• Experience on creating cubes through Framework Manager packages and Transformer.

Listed skills include Microsoft Sql Server, Business Intelligence, Etl, Ssis, and 8 others.