Mohan Potla

Background

About Mohan Potla

Experience in administration and configuration of Cognos Application Servers, Content Manager, Gateway and Transformer 10 years of experience working in a technical role delivering analytics projects Cloud (Azure preferred),SQL and SQL analytics. Strong skills in databases, data warehouses, data modeling, and data processing Extensive knowledge of and experience with large-scale database technology ( Semantic model and report development experience using common Business Intelligence or data exploration tools (e.g. Power BI, Tableau, Qlik, Oracle BI, Cognos, Microstrategy, Business Objects, etc.). • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling. •Extensively worked on COGNOS 8/10/reportnet Framework Manager –by Importing Meta Data from Different Sources and defined Dimension Hierarchy, Star Schema Grouping, Business Layer and published Packages following best practices in multi-user Environment and enabled DQM for performance •Design, develop, and test QlikView scripts to import data from source systems and test QlikView dashboards, Micro strategy dossier.Designed dashboards using Tables Desktop 10.x.Experience with developing complex, optimized and insightful reports on iPad using Active Reports with customized RAVE charts. •Designed transformer models using IQD/reports/package as data source built and published Powerplay cubes. Designed dynamic cubes and monitored performance using DQA. •Involved in the Migration of Impromptu, BOXI,FM,Transformer Models and reports to Cognos 10. Experience with HTML and JavaScript, as used for Cognos reporting Experience writing design specifications, test scripts and other required documentation Experience using Oracle SQL*Plus, Toad, Oracle SQL Developer,Teradata Bteq, SQL Server. •Work experience in Financial, Healthcare, Property & Casuality Insurance,Supply chain and Media domain.